[postgis-tickets] [PostGIS] #5437: ST_Intersects polygon geography empty results
PostGIS
trac at osgeo.org
Wed Jul 12 16:32:06 PDT 2023
#5437: ST_Intersects polygon geography empty results
-----------------------------------+---------------------------
Reporter: royjacksonalertmedia | Owner: pramsey
Type: defect | Status: closed
Priority: medium | Milestone: PostGIS 3.3.4
Component: postgis | Version: 3.3.x
Resolution: invalid | Keywords:
-----------------------------------+---------------------------
Comment (by robe):
I also figured out why SQL Server thinks they intersect. It is seeing the
box as covering everything but the box, presumably because it is using the
orientation winding of the vertices where as PostGIS is just going by
shortest length.
So this is what PostGIS sees: (using the query that Paul showed above)
[[Image(postgis-segmentize.png)]]
T
his is what SQL Server sees:
[[Image(sqlserver.png)]]
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5437#comment:5>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list