On Fri, Nov 6, 2009 at 7:03 PM, Fernando Tong <[email protected]> wrote: > I have a dummy question: > i have a POLYGON, how can i get all the polygon's coordinates with a SELECT > query? > something like: > select unknown_functions(polygon) from mytable > output: > 1 POINT(1 2) > 2 POINT(2 2) > 3 POINT(3 2) > ... > or much better if i get > X Y > 1 1 2 > 2 2 2 > 3 3 2 > Thanks a lot. >
Maybe a SELECT ST_AsText(polygon_column) FROM Table Is enough Output: POLYGON( (1 1, 2 2, 3 3) ) > On Fri, Nov 6, 2009 at 9:19 AM, David Fawcett <[email protected]> > wrote: >> >> I think that another good way to approach it is to have a task/problem >> that you want to solve using PostGIS (whether real or made up). Learn >> what you need to about PostGIS to solve that problem and branch out >> from there. >> >> David. >> >> On Fri, Nov 6, 2009 at 12:04 AM, Paragon Corporation <[email protected]> wrote: >> > You can also look at some of these - might be helpful >> > >> > http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 >> > >> > http://workshops.opengeo.org/stack-intro/ >> > >> > This one is a bit dated but probably still useful >> > http://2007.foss4g.org/workshops/W-04/ >> > >> > Leo >> > ________________________________ >> > From: [email protected] >> > [mailto:[email protected]] On Behalf Of Bob >> > and >> > Deb >> > Sent: Thursday, November 05, 2009 11:51 PM >> > To: PostGIS Users Discussion >> > Subject: Re: [postgis-users] Postgis for dummies >> > >> > How about the book, "PostGIS in Action" ? There is even a free chapter >> > that might give you enough info to get started. There is also the Wiki. >> > >> > -Bob >> > >> > On Thu, Nov 5, 2009 at 6:34 PM, Jeff Matthews <[email protected]> >> > wrote: >> >> >> >> Need link to tutorial at the “dummy” level. >> >> >> >> >> >> >> >> I know a bit about kml, but that’s it. In looking at postgis, I now >> >> see, >> >> in the instructions, things like, “To spatially-enable a jump-oriented >> >> static sql line pointer,….” That’s just wayyyy over me. Where do I >> >> go as >> >> I newbie in gis to become a pro like you all? >> >> >> >> >> >> >> >> Thanks. >> >> >> >> _______________________________________________ >> >> postgis-users mailing list >> >> [email protected] >> >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> >> > >> > >> > _______________________________________________ >> > postgis-users mailing list >> > [email protected] >> > http://postgis.refractions.net/mailman/listinfo/postgis-users >> > >> > >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
