[postgis-users] Postgis for dummies

Jorge Arévalo jorge.arevalo at gmail.com
Sun Nov 8 07:11:54 PST 2009


On Fri, Nov 6, 2009 at 7:03 PM, Fernando Tong <nandorov at gmail.com> 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 <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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



More information about the postgis-users mailing list