[postgis-users] ST_Polygonize thows an error

Francois Hugues hugues.francois at irstea.fr
Wed Dec 12 12:06:36 PST 2012


This error seems normal to me : in your sub select cntr_value is aliased as the_geom but does not seem to be of geometry type. If it is really a value, double precision should be correct and st_polygonize is waiting for a geometry.


-------- Message d'origine--------
De: postgis-users-bounces at lists.osgeo.org de la part de Jeff Lake
Date: mer. 12/12/2012 20:48
À: PostGIS Users Discussion
Objet : [postgis-users] ST_Polygonize thows an error
I using the following query

SELECT ST_Polygonize(the_geom) FROM (SELECT 
ST_AsTEXT(the_geom),date,cntr_value AS the_geom FROM li_poly_000 ORDER 
BY cntr_value desc) as foo;

the Error:

ERROR:  function st_polygonize(double precision) does not exist
LINE 1: select ST_Polygonize(the_geom) from (select st_astext(the_ge...
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.


POSTGIS="2.0.1 r9979" GEOS="3.3.6-CAPI-1.7.6" PROJ="Rel. 4.8.0, 6 March 2012" LIBXML="2.7.6"

*Jeff Lake*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 3313 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121212/e18993aa/attachment.bin>

More information about the postgis-users mailing list