Unreliable results returned with PostgreSQL Spatial query?
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
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