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