[postgis-users] Postgis for dummies

[Fernando Tong]

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.


On Fri, Nov 6, 2009 at 9:19 AM, David Fawcett <david.fawcett at gmail.com>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 <lr at pcorp.us> 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: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] 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 <info at sovereignstates.net>
> > 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
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091106/ae1e1cf5/attachment.html>