[postgis-users] Problem in a spatial query
    Diego Roberto 
    diegorrborges at gmail.com
       
    Mon Aug  5 11:26:04 PDT 2013
    
    
  
Hello I am conducting a survey to check if a point that I am trying to
insert already exists a point near recorded in a radius of 300 meters.
I use this query to perform this procedure:
SELECT i.id_impediments
  FROM impediments AS i
  WHERE st_dwithin(
GeomFromText('POINT(-49.256452 -16.674886)',4326)::geography,
i.geometry_data,
  300)
So far so good, however for coordinates outside the 'Brazil' displays the
following error:
Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type
Following SQL:
SELECT i.id_impediments
  FROM impediments AS i
  WHERE st_dwithin(
GeomFromText('POINT(37.797848 -122.466774)',4326)::geography,
i.geometry_data,
  300) AND i.id_type =5
How should I treat this information, can someone help me? The way I'm
working is correct?
Thank you.
Diego.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130805/3cd16a4c/attachment.html>
    
    
More information about the postgis-users
mailing list