Hi Diego, What about remove ::geography from your query?
On Mon, Aug 5, 2013 at 3:26 PM, Diego Roberto <[email protected]>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 > > How should I treat this information, can someone help me? The way I'm > working is correct? > > Thank you. > Diego. > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > -- Rogério De Pieri (Lelo) MBA em Gerenciamento de Projetos - FGV SCJP 5 Buscando melhorar a cada dia Áudio, Hardware & Software www.twitter.com/lelopieri blogdolelo.wordpress.com
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
