NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
geopoint
WHERE
userenteredcoord like LIKE '%:%'and AND (coordformat = 'Decimal Degrees'or 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>
SELECT
geopoint.longitude,
geopoint.latitude,
geopoint.coordrefsys,
geopoint.coordformat,
geopoint.userinputformat,
geopoint.userenteredcoord
FROM
geopoint
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]]