NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
</pre>
This query identifies coordinates where the ''userenteredcoord'' contains three ''':''' and the ''userinputformat'' and/or coordformat are wrong
<pre>
SELECT
geopoint
WHERE
userenteredcoord like '%:%:%:%'
and (coordformat = 'Decimal Degrees'
or geopoint.userinputformat <> 'X and Y')
</pre>
This query identifies coordinates where the ''userenteredcoord'' does not contains ''':''' and the ''userinputformat'' and/or coordformat are wrong
<pre>
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]