[postgis-users] Create polygon from points in several rows

[Paragon Corporation]

I would guess you can use a combination of ST_MakeLine and ST_MakePolygon
(you can also use ST_BuildArea instead of ST_MakePolygon)
 
http://postgis.refractions.net/documentation/manual-svn/ST_MakeLine.html
 
 
http://postgis.refractions.net/documentation/manual-svn/ST_MakePolygon.html
 
http://postgis.refractions.net/documentation/manual-svn/ST_BuildArea.html
 
Leo

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of eehab
hamzeh
Sent: Saturday, September 05, 2009 1:07 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Create polygon from points in several rows


Hello, 
 
Can any body give me a hint how to insert a polygon. The polygon vertix are
stored in another table, each point in seperate row.
 
Kind regards
 


  _____  

With Windows Live, you can organize, edit, and share your photos.
<http://www.microsoft.com/middleeast/windows/windowslive/products/photo-gall
ery-edit.aspx>  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090905/e450271a/attachment.html>