[postgis-users] ST_Split fails on a quite simple geometry

Jean Marchal jean.d.marchal at gmail.com
Wed Aug 28 15:52:07 PDT 2013


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 <Pierre.Racine at sbf.ulaval.ca>

> 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
> postgis-users at lists.osgeo.org
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130828/7b29e688/attachment.html>


More information about the postgis-users mailing list