<div dir="ltr"><div><div>Hi Pierre,<br><br></div>seems to work with the following version of PostGIS<br><br>SELECT postgis_full_version()<br><br>"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"<br><br></div>Ouput of<b> ST_AsText (</b>SELECT ST_Split(ST_GeomFromEWKT('<div id=":qw">POLYGON((252049.803755834 5230978.87794769,<br>


                                          252049.803755834 5230977.67794767,<br>
                                          252050.003755837 5230977.67794767,<br>
                                          252050.003755837 5230978.27794768,<br>
                                          252050.20375584  5230978.27794768,<br>
                                          252050.20375584  5230978.47794768,<br>
                                          252050.003755837 5230978.47794768,<br>
                                          252050.003755837 5230978.87794769,<br>
                                          252049.803755834 5230978.87794769))'),<br>
                           ST_MakeLine(ST_MakePoint(252050.003755837,  5230978.87794769),<br>
                                                   ST_MakePoint(252049.803755834,  5230977.67794767))<br></div><div id=":qw">
                          )<b>) </b><br></div><div><div><div><div><br>"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)))"<br>

<br></div><div>2 polygons are returned here. Try an upgrade ?<br></div><div><div><br></div><div>HTH,<br><br></div><div>Jean<br></div></div></div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">

2013/8/28 Pierre Racine <span dir="ltr"><<a href="mailto:Pierre.Racine@sbf.ulaval.ca" target="_blank">Pierre.Racine@sbf.ulaval.ca</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

Hi,<br>
<br>
This query should return the geometry splitted in two but it returns only one of the two sides.<br>
<br>
SELECT ST_Split(ST_GeomFromEWKT('POLYGON((252049.803755834 5230978.87794769,<br>
                                          252049.803755834 5230977.67794767,<br>
                                          252050.003755837 5230977.67794767,<br>
                                          252050.003755837 5230978.27794768,<br>
                                          252050.20375584  5230978.27794768,<br>
                                          252050.20375584  5230978.47794768,<br>
                                          252050.003755837 5230978.47794768,<br>
                                          252050.003755837 5230978.87794769,<br>
                                          252049.803755834 5230978.87794769))'),<br>
                           ST_MakeLine(ST_MakePoint(252050.003755837,  5230978.87794769),<br>
                                                   ST_MakePoint(252049.803755834,  5230977.67794767))<br>
                          ) geom<br>
<br>
SELECT postgis_full_version()<br>
<br>
"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"<br>


<br>
Bug? Or it works on earlier version?<br>
<br>
Thanks,<br>
<br>
Pierre<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Jean Marchal<br><br>Etudiant au doctorat / PHD student<br>Université Laval - Pavillon Abitibi-Price<br>Faculté de foresterie, de géographie et de géomatique<br>2405, rue de la Terrasse<br>

Québec (Québec) G1V 0A6<br>Tél: 418-656-2131 poste 2620
</div>