Space coordinates: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 17: Line 17:


[[Category:NoPublic]]
[[Category:NoPublic]]
[[Category:SQL Queries]]

Revision as of 17:34, 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