Coordinate display rules

From IMSMA Wiki
Revision as of 16:59, 6 February 2014 by Alnaucler (talk | contribs) (Created page with "SELECT geopoint.userinputformat, Count(geopoint.geopoint_guid) FROM geopoint GROUP BY geopoint.userinputformat HAVING (geopoint.userinputformat <> 'X and Y' AND geopoint.u...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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

Note: This query is in 5.x format

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