Changes

Jump to: navigation, search

MGRS coordinates

42 bytes removed, 12:05, 12 February 2014
no edit summary
The first This query finds MGRS coordinates with the incorrect format of type '''4qfj12345678 and the second query finds MGRS coordinates with blanks 4 QFJ 1234 5678'''.
<pre>
locate('|', geopoint.userenteredcoord) -1) <> upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1))
ORDER BY length(geopoint.userenteredcoord)
</pre>
Note: This query is in 5.x format
---------------------------------------------------This query finds MGRS coordinates with blanks '''4 QFJ 1234 5678'''.
<pre>
SELECT
userenteredcoord
Alnaucler
NoPublic, bureaucrat, administrator
6,632
edits
Retrieved from "http://mwiki.gichd.org:8090/IM/Special:MobileDiff/13665"

Navigation menu