Coordinate display rules

From IMSMA Wiki
Revision as of 16:35, 10 February 2014 by Alnaucler (talk | contribs)
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