MGRS coordinates: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
--------------------------------------------------- | --------------------------------------------------- | ||
SELECT | SELECT | ||
userenteredcoord | |||
FROM | FROM | ||
geopoint | geopoint | ||
WHERE | WHERE | ||
coordrefsys = 'MGRS' AND | coordrefsys = 'MGRS' AND userenteredcoord LIKE '% %' | ||
ORDER BY | ORDER BY | ||
userenteredcoord ASC | |||
Note: This query is in 5.x format | Note: This query is in 5.x format | ||
</pre> | </pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | |||
Revision as of 04:17, 12 February 2014
These two queries finds MGRS coordinates where the format is incorrect
SELECT geopoint.userenteredcoord,
concat( upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1)),right(geopoint.userenteredcoord,7))
FROM
geopoint
WHERE
geopoint.coordrefsys = 'MGRS' AND
binary left(geopoint.userenteredcoord,
locate('|', geopoint.userenteredcoord) -1) <> upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1))
ORDER BY length(geopoint.userenteredcoord)
Note: This query is in 5.x format
---------------------------------------------------
SELECT
userenteredcoord
FROM
geopoint
WHERE
coordrefsys = 'MGRS' AND userenteredcoord LIKE '% %'
ORDER BY
userenteredcoord ASC
Note: This query is in 5.x format