Coordinate display rules: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 16: | Line 16: | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | |||
Revision as of 04:26, 12 February 2014
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