NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
</pre>
This query identifies coordinates where the ''userenteredcoord'' does '''not''' contains 4 ''':''' when coordformat is ''Degrees:Minutes:Seconds'' OR ''Degrees:Decimal Minutes''
<pre>
SELECT
geopoint.coordrefsys,
geopoint.userinputformat,
geopoint.coordformat,
geopoint.userenteredcoord,
LENGTH(userenteredcoord) - LENGTH(REPLACE( userenteredcoord, ':', '')) AS occ
FROM
geopoint
WHERE
geopoint.userenteredcoord LIKE '%:%' and
LENGTH(userenteredcoord) - LENGTH(REPLACE( userenteredcoord, ':', '')) <> 4
and coordformat = 'Degrees:Minutes:Seconds'
</pre>
This query identifies coordinates where the ''userenteredcoord'' does '''not''' contains 2 ''':''' when coordformat is ''Degrees:Decimal Minutes''
<pre>
ELECT
geopoint.coordrefsys,
geopoint.userinputformat,
geopoint.coordformat,geopoint.userenteredcoord,LENGTH(userenteredcoord) - LENGTH(REPLACE( userenteredcoord, ':', '')) AS occ
FROM
geopoint
WHERE
geopoint.userenteredcoord NOT LIKE '%:%'andAND LENGTH(coordformat = userenteredcoord) - LENGTH(REPLACE( userenteredcoord, 'Degrees:Minutes:Seconds' OR , '')) <> 2and coordformat = 'Degrees:Decimal Minutes')
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
