NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
This query identifies coordinates where ''userinputformat '' is not correctly set.
<pre>
SELECT
geopoint.userinputformat <> 'Bearing and distance') OR
geopoint.userinputformat is null
</pre>
This query identifies coordinates where the ''userenteredcoord'' contains three ''':''' 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 like '%:%:%:%'
and (coordformat = 'Decimal Degrees'
or geopoint.userinputformat <> 'X and Y')
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]