|
Hi:
On 08/05/2013 09:26 PM, Diego Roberto wrote:
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
Are your Lon/Lat coordinates backwards?
I think it should be POINT(-122.466774 37.797848)
How
should I treat this information, can someone help me? The
way I'm working is correct?
Thank
you.
Diego.
This mail was received via Mail-SeCure System.
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
This mail was received via Mail-SeCure System.
--
Micha Silver
GIS Consultant, Arava Development Co.
http://www.surfaces.co.il
|
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
