Space coordinates: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
SELECT | SELECT | ||
geopoint.pointlocal_id, | geopoint.pointlocal_id, geopoint.pointno, geopoint.longitude, geopoint.latitude, geopoint.userenteredcoord | ||
geopoint.pointno, | |||
geopoint.longitude, | |||
geopoint.latitude, | |||
geopoint.userenteredcoord | |||
FROM | FROM | ||
geopoint | geopoint | ||
INNER JOIN geospatialinfo ON geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid | INNER JOIN geospatialinfo ON geospatialinfo.geospatialinfo_guid = geopoint.geospatialinfo_guid | ||
WHERE geopoint.longitude > '180' OR | WHERE geopoint.longitude > '180' OR | ||
geopoint.longitude < '-180' OR | geopoint.longitude < '-180' OR | ||
geopoint.latitude > '90' OR | geopoint.latitude > '90' OR | ||
geopoint.latitude < '-90' OR | geopoint.latitude < '-90' OR | ||
geopoint.latitude IS NULL OR | geopoint.latitude IS NULL OR | ||
geopoint.longitude IS NULL OR | geopoint.longitude IS NULL OR | ||
geopoint.userenteredcoord IS NULL | geopoint.userenteredcoord IS NULL | ||
Revision as of 16:06, 6 February 2014
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