[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