[postgis-tickets] [PostGIS] #4951: Geometries returning zero area with PostGIS 3.1.2

PostGIS trac at osgeo.org
Mon Jul 12 12:59:14 PDT 2021


#4951: Geometries returning zero area with PostGIS 3.1.2
-----------------------+---------------------------
 Reporter:  mboeringa  |      Owner:  pramsey
     Type:  defect     |     Status:  new
 Priority:  medium     |  Milestone:  PostGIS 3.1.3
Component:  postgis    |    Version:  3.1.x
 Keywords:             |
-----------------------+---------------------------
 I am running into an issue with two of OpenStreetMap's polygon geomtries
 returning a zero area for the following PostGIS SQL clause:

 ST_Area(ST_ConvexHull(ST_Transform(way,4326))::geography,true)

 Note that the data was imported using osm2pgsql, with the data stored in
 WGS1984, not Web Mercator.

 The two relations that cause the issue are:

 https://www.openstreetmap.org/relation/2186646

 https://www.openstreetmap.org/relation/3394113

 One represents "Antarctica", the other the "Ross Dependency".

 Note that both relations appear to be quite old (years), and I am therefor
 pretty sure I have processed the exact same geometries previously without
 issues with older versions of PostGIS after planet import. Note also that
 both geometries test as valid with "ST_Isvalid(way)" after import using
 osm2pgsql.

 Has something changed in the latest PostGIS 3.1.2 that might explain this
 result, e.g. especially related to the "::geography" cast or the
 "ST_ConvexHull" statement?

 Of course, in the way these geometries wrap the globe, they may represent
 a challenge, but as said, I am pretty sure I must have processed the same
 geometries without issues in previous releases of PostGIS.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4951>
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