[postgis-users] MULTILINESTRING edges
Nandorov
nandorov at gmail.com
Tue Sep 23 13:20:30 PDT 2008
thanks a lot
Sufficool, Stanley wrote:
>
>
> Or try a real query (smacks head):
>
> select st_pointn(the_geom, 1) as first_point, st_pointn(the_geom,
> st_npoints(the_geom)) as last_point From my_geometry_table
>
>
>
>
>> -----Original Message-----
>> From: postgis-users-bounces at postgis.refractions.net
>> [mailto:postgis-users-bounces at postgis.refractions.net] On
>> Behalf Of Sufficool, Stanley
>> Sent: Tuesday, September 23, 2008 12:27 PM
>> To: PostGIS Users Discussion
>> Subject: RE: [postgis-users] MULTILINESTRING edges
>>
>>
>> Try:
>>
>> select st_pointn(the_geom) as first_point,
>> st_pointn(st_npoints(the_geom)) as last_point
>> >From my_geometry_table
>>
>> > -----Original Message-----
>> > From: postgis-users-bounces at postgis.refractions.net
>> > [mailto:postgis-users-bounces at postgis.refractions.net] On
>> > Behalf Of Nandorov
>> > Sent: Tuesday, September 23, 2008 11:03 AM
>> > To: postgis-users at postgis.refractions.net
>> > Subject: [postgis-users] MULTILINESTRING edges
>> >
>> >
>> >
>> > hi again, i'm sorry if i bother you, but i need some help
>> >
>> > I have a multilinestring, and i want to get the coordinates
>> > of its edges. For example i have MULTILINESTRING(0 1, 2 3, 6
>> > 7,4 6) i want to recover its edges that would be
>> > (0 1) and (4 6)
>> > X & Y function only works with points, if there's a function
>> > to get them? or i have to build my own?
>> >
>> > thanks
>> > --
>> > View this message in context:
>> > http://www.nabble.com/MULTILINESTRING-edges-tp19633515p19633515.html
>> > Sent from the PostGIS - User mailing list archive at Nabble.com.
>> >
>> > _______________________________________________
>> > 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
>
>
--
View this message in context: http://www.nabble.com/MULTILINESTRING-edges-tp19633515p19636134.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
More information about the postgis-users
mailing list