Changes

Space coordinates

3 bytes added, 17:18, 10 February 2014

no edit summary

<pre>SELECT

geopoint.pointlocal_id, geopoint.pointno, geopoint.longitude, geopoint.latitude, geopoint.userenteredcoord

FROM

geopoint

INNER JOIN geospatialinfo ON geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid

WHERE geopoint.longitude > '180' OR

geopoint.longitude < '-180' OR

geopoint.latitude > '90' OR

geopoint.latitude < '-90' OR

geopoint.latitude IS NULL OR

geopoint.longitude IS NULL OR

geopoint.userenteredcoord IS NULL

</pre>

Note: This query is in 5.x format

[[Category:NoPublic]]

6,632

edits