Only one organization is showing up on the Situation Awareness Map

[Mark Prutsalis]

Have entered three organizations into the organization registry - with slightly different GPS coordinates to create some separation. On maximum zoom on the situational awareness map, only one of the three is being displayed.

Need to verify and validate that all geo-referenced organizations get added and are displayed on the situational awareness map.

[Gavin Treadgold (gt)]

Have just been digging around, and it appears that some coord pairs have been getting swapped in the gis_features table. E.g.

coords field: -120.764,35.72,0,wkt{POINT Z (-120.764 35.72 0)}
coord_x field: -120.7640000000
coord_y field: 35.7200000000

The above is the correct format. However, we are seeing some interesting inverted and incorrect coords that result in them not being displayed on the map. E.g.

coords: 35.71544,-120.76421,0,wkt{POINT Z (35.71544 -120.76421 0)}
coord_x: 120.7639600000
coord_y: 35.7154700000

1. In coords - note that lat/long have been reversed.
2. In coord_x - note that the latitude has lost the negative value.

[dot dot dot (dotdotdotdeactivated-deactivatedaccount)]

wont fix. module deprecated. reopen if module regains owner.