[postgis-users] [?? Probable Spam] How to find length of a part of line string...

[ju]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120522/9368a308/attachment.html>