[postgis-users] build a polygon from points

[Paragon Corporation]

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 at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Caspa
Sent: Monday, June 22, 2009 10:15 AM
To: postgis-users at postgis.refractions.net
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 at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users