[postgis-tickets] [PostGIS] #2836: Receiving ERROR: ExteriorRing: geom is not a polygon with ST_ConcaveHull

[PostGIS]

#2836: Receiving ERROR: ExteriorRing: geom is not a polygon with ST_ConcaveHull
-----------------------+----------------------------------------------------
 Reporter:  cumminsjp  |       Owner:  pramsey
     Type:  defect     |      Status:  new    
 Priority:  medium     |   Milestone:         
Component:  postgis    |     Version:  2.0.x  
 Keywords:             |  
-----------------------+----------------------------------------------------
 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

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