[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Make polygons on mixed closed/non closed linestrings?
From:       Pietro Rossin <pierigis () gmail ! com>
Date:       2013-02-22 11:30:02
Message-ID: 1361532602846-5002663.post () n6 ! nabble ! com
[Download RAW message or body]


Is it possible?
I have a postgis table that is an importation of dxf data.
In autocad a polygon is a closed polyline
All civil buildings, in my table, are closed polylines and I can convert
them on the fly to polygon by st_makepolygon() function, ok.
My problem is for big buildings, in cities, where there are many buildings
that share a wall.

If, for example, a building is made by three unit, with different roof
height, I have two layers, one that is the overall perimeter of the three
building and the second that is a layer containing the divisions, let's say
linestring that have their ends on the perimeter..

Is there some aggregation I can perform by sql statements to obtain three
polygons or must I export data and process them via external software (ex
grass)?

Thanks
Pietro




--
View this message in context: \
http://postgis.17.n6.nabble.com/Make-polygons-on-mixed-closed-non-closed-linestrings-tp5002663.html
 Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]