Coordinate display rules: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre>SELECT | This query identifies coordinates where userinputformat is not correctly set. | ||
<pre> | |||
SELECT | |||
geopoint.userinputformat, | geopoint.userinputformat, | ||
Count(geopoint.geopoint_guid) | Count(geopoint.geopoint_guid) | ||
| Line 12: | Line 14: | ||
geopoint.userinputformat is null | geopoint.userinputformat is null | ||
</pre> | </pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
Revision as of 16:57, 11 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