[postgis-users] Regarding calculating locations for a map

2009-10-27 Thread Thilani Imalka
Hi, I am currently developing a shortest path application for my MSc degree project. Road information are stored in the postgis table and there I can find geometries for all the roads. But I am having few issues when selecting from and to location from GUI (open layers). Where I have to provide a

[postgis-users] Regarding calculating locations for a map

2009-10-27 Thread Thilani Imalka
I am currently developing a shortest path application for my MSc degree project. Road information are stored in the postgis table and there I can find geometries for all the roads. But I am having few issues when selecting from and to location from GUI (open layers). Where I have to provide a faci

[postgis-users] Regarding calculating locations on a map

2009-10-26 Thread Thilani Imalka
I am currently developing a shortest path application for my MSc degree project. Road information are stored in the postgis table and there I can find geometries for all the roads. But I am having few issues when selecting from and to location from GUI (open layers). Where I have to provide a faci

[postgis-users] Regarding calculating locations on a map

2009-10-26 Thread Thilani Imalka
Hi, I am currently developing a shortest path application for my MSc degree project. Road information are stored in the postgis table and there I can find geometries for all the roads. But I am having few issues when selecting from and to location from GUI (open layers). Where I have to provide a

Re: [postgis-users] How to get the nearest point for a given point from a geometry of multilinestring

2009-07-20 Thread Thilani Imalka
; > Or, use ST_Line_Locate_Point > (http://www.postgis.org/documentation/manual-svn/ST_Line_Locate_Point.html) > to determine the percentage along your linestring the intersection point > occurs.  Then for every vertex determine their percentage along to find the > two vertices of intere

[postgis-users] How to get the nearest point for a given point from a geometry of multilinestring

2009-07-20 Thread Thilani Imalka
We used ST_Intersection function to get the cross point when roads are crossing each other. So with the output of this function we have the crossing point and now we need to get adjacent points to that crossing point from the road (where the road is a geometry of multilinestring).Is there any post