[postgis-users] Split Polygon in PostGIS

venkat ven.tammineni at gmail.com
Wed Oct 6 23:26:17 PDT 2010


Dear All,

   I want to split polygon based on line..I am using below query which is
given http://trac.osgeo.org/postgis/wiki/UsersWikiSplitPolygonWithLineString
 .


CREATE TABLE splitDemo AS
SELECT geom FROM dump ((
   SELECT polygonize(geomunion(boundary(districts.the_geom),'LINESTRING
(37.376106262 40.181087494,18.1275424955 18.1275424955)'))
   FROM districts
));

But I am getting error as

********** Error **********

ERROR: Operation on mixed SRID geometries
SQL state: XX000

Here I have some queries that is what is Dump table...which is not
even existing my database.

and I dont know how to set srid to the above query.Please guide me.

Its very urgent.I am waiting for your great response.

Thanks and Regards,

Venkat
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101007/5a671c62/attachment.html>


More information about the postgis-users mailing list