Thanks Jean. I'll do this ASAP...
> -----Original Message----- > From: [email protected] [mailto:postgis-users- > [email protected]] On Behalf Of Jean Marchal > Sent: Wednesday, August 28, 2013 6:52 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] ST_Split fails on a quite simple geometry > > Hi Pierre, > > > seems to work with the following version of PostGIS > > SELECT postgis_full_version() > > "POSTGIS="2.1.0 r11822" GEOS="3.4.1-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0, 6 > March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8" > LIBJSON="UNKNOWN" RASTER" > > > Ouput of ST_AsText (SELECT ST_Split(ST_GeomFromEWKT(' > POLYGON((252049.803755834 5230978.87794769, > 252049.803755834 5230977.67794767, > 252050.003755837 5230977.67794767, > 252050.003755837 5230978.27794768, > 252050.20375584 5230978.27794768, > 252050.20375584 5230978.47794768, > 252050.003755837 5230978.47794768, > 252050.003755837 5230978.87794769, > 252049.803755834 > 5230978.87794769))'), > ST_MakeLine(ST_MakePoint(252050.003755837, > 5230978.87794769), > > ST_MakePoint(252049.803755834, > 5230977.67794767)) > > )) > > > "GEOMETRYCOLLECTION(POLYGON((252049.803755834 > 5230977.67794767,252049.803755834 > 5230978.87794769,252050.003755837 > 5230978.87794769,252049.803755834 > 5230977.67794767)),POLYGON((252050.003755837 > 5230978.87794769,252050.003755837 > 5230978.47794768,252050.20375584 > 5230978.47794768,252050.20375584 > 5230978.27794768,252050.003755837 > 5230978.27794768,252050.003755837 > 5230977.67794767,252049.803755834 > 5230977.67794767,252050.003755837 5230978.87794769)))" > > > 2 polygons are returned here. Try an upgrade ? > > > HTH, > > > Jean > > > > 2013/8/28 Pierre Racine <[email protected]> > > > Hi, > > This query should return the geometry splitted in two but it returns > only one of the two sides. > > SELECT > ST_Split(ST_GeomFromEWKT('POLYGON((252049.803755834 > 5230978.87794769, > 252049.803755834 > 5230977.67794767, > 252050.003755837 > 5230977.67794767, > 252050.003755837 > 5230978.27794768, > 252050.20375584 > 5230978.27794768, > 252050.20375584 > 5230978.47794768, > 252050.003755837 > 5230978.47794768, > 252050.003755837 > 5230978.87794769, > 252049.803755834 > 5230978.87794769))'), > ST_MakeLine(ST_MakePoint(252050.003755837, > 5230978.87794769), > > ST_MakePoint(252049.803755834, > 5230977.67794767)) > ) geom > > SELECT postgis_full_version() > > "POSTGIS="2.1.0SVN r11202" GEOS="3.4.0dev-CAPI-1.8.0 r0" > PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" > LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER" > > Bug? Or it works on earlier version? > > Thanks, > > Pierre > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > > > > > -- > Jean Marchal > > Etudiant au doctorat / PHD student > Université Laval - Pavillon Abitibi-Price > Faculté de foresterie, de géographie et de géomatique > 2405, rue de la Terrasse > Québec (Québec) G1V 0A6 > Tél: 418-656-2131 poste 2620 _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
