NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
</pre>
This query identifies coordinates where the ''userenteredcoord'' contains ''':''' and the ''userinputformat'when coordformat is ' and/or ''coordformatDecimal Degrees'' are wrong
<pre>
SELECT
WHERE
userenteredcoord LIKE '%:%'
AND (coordformat = 'Decimal Degrees'OR geopoint.userinputformat <> 'X and Y')
</pre>
