Re: build a polygon from points

Andrea,
Are those individual records or columns in the table?

Take a look at ST_MakeLine, ST_MakePolygon, ST_BuildArea

http://postgis.refractions.net/documentation/manual-svn/ST_MakeLine.html

http://postgis.refractions.net/documentation/manual-svn/ST_BuildArea.html

http://postgis.refractions.net/documentation/manual-svn/ST_MakePolygon.html


You build a line from points with ST_MakeLine and then do a ST_BuildArea or
ST_MakePolygon depending on your desired effect.

Leo

 

-----Original Message-----
From: postgis-users-bounces@...
[mailto:postgis-users-bounces@...] On Behalf Of Caspa
Sent: Monday, June 22, 2009 10:15 AM
To: postgis-users@...
Subject: [postgis-users] build a polygon from points

Hi everybody,
I'm new to postgis...
how can i build a polygon starting from points and not from x,y coord?

i have a table built like this:

point1 | point2 | point3 | point4 | polygon

guess i have to use MakeLine and MakePolygon but i can't fugure out why...
thanks in advance

Andrea
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users