<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
use segmentation dynamic fuctions:<br>
<br>
1) firest get the "point" ( called for example pointtonline) of the
line nearest to your point using : st_Line_Locate_Point<br>
<br>
2) second "make" a line from pointtonline to start or to end or to
another "pointtonline"<br>
for this you can use st_Line_Substring(the_geom, pointtonline,
startpoint)<br>
<br>
<br>
of cource st_distance to get length etc....<br>
<br>
<br>
best regards<br>
julien<br>
--------<br>
Le 22/05/2012 14:28, ram prasad a écrit :
<blockquote
cite="mid:CAPy8Krk1n0fbAzQkKhf0wPd0JEdmY3565wkE2SA-B9Qn1vRdCw@mail.gmail.com"
type="cite"><br clear="all">
<div>Hi,</div>
<div><br>
</div>
<div> 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.</div>
<div><br>
</div>
<div>Also I attached the explanation image with this mail....</div>
-- <br>
<font face="comic sans ms,sans-serif"><span
style="color:rgb(153,0,0)">BY</span><br>
<br>
<span
style="color:rgb(0,102,0);background-color:rgb(255,255,255)">R.RAMPRASAD</span></font></blockquote>
</body>
</html>