Unreliable results returned with PostgreSQL Spatial query?

Started by Burgess, Freddieover 11 years ago2 messagesbugs
Jump to latest
#1Burgess, Freddie
FBurgess@Radiantblue.com

PostgreSQL version: 9.3.4
PostGIS version 2.1.1
Operating system: Linux 6.4
Description:

Does the ST_Intersects function have problems returning the correct results with non-box type geometries, like a circle polygon or other style polygons.

i.e.

select count(*) from doti_sensors_report where ST_INTERSECTS(sensor_location, ST_Buffer(ST_MakePoint(21.304116745663165, 38.68607570952619)::geography, 4000));

thanks

#2Michael Paquier
michael@paquier.xyz
In reply to: Burgess, Freddie (#1)
Re: Unreliable results returned with PostgreSQL Spatial query?

On Thu, Oct 2, 2014 at 12:50 PM, Burgess, Freddie <FBurgess@radiantblue.com>
wrote:

Does the ST_Intersects function have problems returning the correct
results with non-box type geometries, like a circle polygon or other style
polygons.

i.e.

select count(*) from doti_sensors_report where
ST_INTERSECTS(sensor_location, ST_Buffer(ST_MakePoint(21.304116745663165,
38.68607570952619)::geography, 4000));

st_intersects is distributed with postgis and not directly with Postgres,
hence this issue would be better discussed from here:
http://postgis.net/support
Regards,
--
Michael