[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