009/12/4 Daniel Grum <[email protected]>: > Hi > > I want to update a geometry table with polygon geometries: > > UPDATE wald_by > SET the_geom = > ST_BuildArea(ST_Collect(ST_Intersection(poly.the_geom,ST_Expand(pt.the_geom, > 2000)),poly.the_geom)) > FROM public.wald_by poly, public.holzfaeller pt, public.runden i > WHERE poly.the_geom && ST_Expand(pt.the_geom, 2000) AND pt.style=2 AND > i%10=0; > > Every 10th round this Update will be startet and only for this that have the > style=2 -->lumberjacks that clear wood and not work regenerative like > style=1. > > Info to the attributes of the table: > gid serial NOT NULL, id integer, the_geom geometry, flaeche double > precision, flaeche_ges double precision, > CONSTRAINT wald_by_pkey PRIMARY KEY (gid), > CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2), > CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = > 'MULTIPOLYGON'::text OR the_geom IS NULL), > CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 31467) > > The Update don't works because: > ERROR: new line for relation »wald_by« breaches Check-Constraint > »enforce_geotype_the_geom« > > So I thing the new geometry is no MULTIPOLYGON???!!!
The return type can be a Polygon or MultiPolygon, depending on input > Are there any ideas? ST_Multi(ST_BuildArea(ST_Collect(ST_Intersection(poly.the_geom,ST_Expand(pt.the_geom,2000)),poly.the_geom))) > > --daniel > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa http://www.zwartberg.com/ _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
