Changes

Jump to: navigation, search

Coordinate display rules

56 bytes added, 17:57, 15 July 2014
no edit summary
This query identifies coordinates where the combination of ''coordrefsys'', ''coordformat'' and ''userinputformat'' is not correctly set.
<pre>
SELECT
geopoint.coordrefsys,
geopoint.coordformat,
geopoint.userinputformat,
Count(geopoint.geopoint_guid)
geopoint
GROUP BY
geopoint.coordrefsys,
geopoint.coordformat,
geopoint.userinputformat
HAVINGORDER BY(geopoint.userinputformat <> 'X and Y' ANDgeopoint.userinputformat <> 'MGRS' ANDcoordrefsys ASC,geopoint.userinputformat <> 'Bearing and distance') ORcoordformat ASC,geopoint.userinputformat is nullASC
</pre>
Alnaucler
NoPublic, bureaucrat, administrator
6,632
edits
Retrieved from "http://mwiki.gichd.org:8090/IM/Special:MobileDiff/15958"

Navigation menu