Changes

Coordinate display rules

349 bytes added, 16:59, 6 February 2014
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..."
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

[[Category:NoPublic]]
6,632
edits