[postgis-users] polygonize line strings
mike at fuhr.org
Fri Mar 3 02:55:00 PST 2006
On Fri, Mar 03, 2006 at 09:58:30AM +0100, Bart van den Eijnden (OSGIS) wrote:
> I have a dataset in the form of a linestring shapefile, it is in fact a
> cadastral map. This shapefile consists of many separate linestrings per
> polygon, and has an attribute stating the cadastral object to the left
> of the linestring (PERCEEL_LI), and another one describing the cadastral
> object right of the linestring (PERCEEL_RE). I also have available a
> points shapefile which has the cadastrale object code as well.
> Can this data be polygonized with PostGIS? If so how can this be done?
Is the following close to what you're looking for? If not then
maybe I've misunderstood.
SELECT perceel, polygonize_garray(accum(geom)) AS geom
SELECT perceel_li AS perceel, geom FROM foo
SELECT perceel_re AS perceel, geom FROM foo
) AS s
GROUP BY perceel;
More information about the postgis-users