Receiving ERROR: ExteriorRing: geom is not a polygon with ST_ConcaveHull

[cumminsjp]

I am receiving this error: Error ERROR: ExteriorRing: geom is not a polygon SQL state: XX000 Context: PL/pgSQL function st_concavehull(geometry,double precision,boolean) line 67 at assignment

when using a target_percent below 0.99.

I originally posted this question on gis.se because I wasn't sure if it was user error or not (still wouldn't rule it out): ​http://gis.stackexchange.com/questions/106854/is-this-correct-behavior-for-st-concavehull-postgis

PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 64-bit POSTGIS="2.0.4" GEOS="3.4.2-CAPI-1.8.2 r0" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8" LIBJSON="UNKNOWN" (core procs from "2.0.4" need upgrade) RASTER (raster procs from "2.0.4" need upgrade)

I'll attach an export of the table.

I will say that as I was creating test tables from the large table and retesting the query, I was able to successfully to run st_concavehull. I wouldn't have thought that it would have changed what is passed to st_concavehull(ST_Collect(.

with concavePolys as (

select id , st_concavehull(ST_Collect(vx), 0.90) concaveHullPoly from (

SELECT vertex_point vx, id

FROM public.postgis_concavehull_bugdata1

union SELECT comparison_vertex_point vx, id

FROM public.postgis_concavehull_bugdata1 ) t group by id having ST_NPoints (ST_Collect(vx)) > 3

) select * from concavePolys

[cumminsjp]

Postgresql export of a table with test data compressed to 7z (public schema)

[robe]

sadly this is still a problem even in latest 2.4.0.

[robe]

In 15775:

ST_ConcaveHull fix for EXtenriorRing is not a polygon
References #2836 for PostGIS 2.4.0

[robe]

In 15776:

ST_ConcaveHull fix for ExteriorRing is not a polygon
References #2836 for PostGIS 2.3.4

[robe]

In 15777:

ST_ConcaveHull fix for ExteriorRing is not a polygon
Closes #2836 for PostGIS 2.2.6