Coordinate display rules

From IMSMA Wiki

Revision as of 04:26, 12 February 2014 by Alnaucler (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

This query identifies coordinates where userinputformat is not correctly set.

SELECT
geopoint.userinputformat,
Count(geopoint.geopoint_guid)
FROM
geopoint
GROUP BY
geopoint.userinputformat
HAVING
(geopoint.userinputformat <>  'X and Y' AND
geopoint.userinputformat <> 'MGRS' AND
geopoint.userinputformat <> 'Bearing and distance') OR
geopoint.userinputformat is null

Retrieved from "http://mwiki.gichd.org/IM/index.php?title=Coordinate_display_rules&oldid=13633"