MGRS coordinates: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 11: | Line 11: | ||
ORDER BY length(geopoint.userenteredcoord) | ORDER BY length(geopoint.userenteredcoord) | ||
--------------------------------------------------- | |||
SELECT | SELECT | ||
user_entered_mgrs | user_entered_mgrs | ||
Revision as of 16:31, 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