Coordinate display rules: Difference between revisions
Jump to navigation
Jump to search
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..." |
No edit summary |
||
| Line 1: | Line 1: | ||
SELECT | <pre>SELECT | ||
geopoint.userinputformat, | geopoint.userinputformat, | ||
Count(geopoint.geopoint_guid) | Count(geopoint.geopoint_guid) | ||
FROM | FROM | ||
geopoint | geopoint | ||
GROUP BY | GROUP BY | ||
geopoint.userinputformat | geopoint.userinputformat | ||
HAVING | HAVING | ||
(geopoint.userinputformat <> 'X and Y' AND | (geopoint.userinputformat <> 'X and Y' AND | ||
| Line 14: | Line 11: | ||
geopoint.userinputformat <> 'Bearing and distance') OR | geopoint.userinputformat <> 'Bearing and distance') OR | ||
geopoint.userinputformat is null | geopoint.userinputformat is null | ||
</pre> | |||
Note: This query is in 5.x format | Note: This query is in 5.x format | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
Revision as of 16:35, 10 February 2014
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