MGRS coordinates: Difference between revisions
Jump to navigation
Jump to search
Created page with "SELECT geopoint.userenteredcoord, concat( upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1)),right(geopoint.userenteredcoord,7)) FROM geopoint ..." |
No edit summary |
||
| Line 10: | Line 10: | ||
ORDER BY length(geopoint.userenteredcoord) | ORDER BY length(geopoint.userenteredcoord) | ||
SELECT | |||
user_entered_mgrs | |||
FROM | |||
geopoint | |||
WHERE | |||
coordrefsys = 'MGRS' AND user_entered_mgrs LIKE '% %' | |||
ORDER BY | |||
user_entered_mgrs ASC | |||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
Revision as of 16:29, 6 February 2014
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)
SELECT user_entered_mgrs
FROM geopoint
WHERE coordrefsys = 'MGRS' AND user_entered_mgrs LIKE '% %'
ORDER BY user_entered_mgrs ASC