Space coordinates: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre>SELECT | This query finds invalid / space coordinates | ||
<pre> | |||
SELECT | |||
geopoint.pointlocal_id, geopoint.pointno, geopoint.longitude, geopoint.latitude, geopoint.userenteredcoord | geopoint.pointlocal_id, geopoint.pointno, geopoint.longitude, geopoint.latitude, geopoint.userenteredcoord | ||
FROM | FROM | ||
Revision as of 16:50, 11 February 2014
This query finds invalid / space coordinates
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
Note: This query is in 5.x format