Open main menu
Changes
MGRS coordinates
72 bytes added
,
17:52, 11 February 2014
no edit summary
These two queries finds MGRS coordinates where the format is incorrect
<pre>SELECT geopoint.userenteredcoord,
concat( upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1)),right(geopoint.userenteredcoord,7))
FROM
← Older edit
Newer edit →
Alnaucler
NoPublic,
bureaucrat
,
administrator
6,632
edits