[postgis-users] Split Polygon in PostGIS

[strk]

On Thu, Oct 07, 2010 at 11:56:17AM +0530, venkat wrote:

> 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: Operation on mixed SRID geometries

Try this:

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

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html