use segmentation dynamic fuctions:
1) firest get the "point" ( called for example pointtonline) of the
line nearest to your point using : st_Line_Locate_Point
2) second "make" a line from pointtonline to start or to end or to
another "pointtonline"
for this you can use st_Line_Substring(the_geom, pointtonline, startpoint)
of cource st_distance to get length etc....
best regards
julien
--------
Le 22/05/2012 14:28, ram prasad a écrit :
Hi,
I want to find the length of the particular part(from starting
point of linestring to a point i given) in line string. Is it possible
to do this in Postgis.If possible how to write query for this.
Also I attached the explanation image with this mail....
--
BY
R.RAMPRASAD
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
