<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=684040519-19042005><FONT face=Arial color=#0000ff size=2>JTS
1.7 will contain code to do just this, in a new Linear Referencing API.
Hopefully it will show up in PostGIS at some point.</FONT></SPAN></DIV>
<DIV><SPAN class=684040519-19042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=684040519-19042005><FONT face=Arial color=#0000ff size=2>No ETA
for the release yet - probably in a month or two.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV align=center><FONT face=Arial size=2><STRONG>Martin Davis, Senior Technical
Architect</STRONG><BR><STRONG><FONT color=#0000ff>Vivid Solutions
Inc.
<I>www.vividsolutions.com</I></FONT></STRONG><BR></FONT><EM><FONT face=Arial
size=2>Suite #1A-2328 Government Street Victoria, B.C. V8T 5G5<BR>Phone: (250)
385 6040 - Local 308 Fax: (250) 385 6046</FONT></EM></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Derek C. Figg<BR><B>Sent:</B> April 19, 2005 9:40 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
Distance of point on a line<BR><BR></FONT></DIV>
<DIV><SPAN class=711281016-19042005><FONT face=Arial size=2>Hello
all,</FONT></SPAN></DIV>
<DIV><SPAN class=711281016-19042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=711281016-19042005><FONT face=Arial size=2>I sent out a
fairly dumb question about a week ago and received many helpful responses, and
wanted to thank everyone for that. Now I have another fairly simple (I
hope) question that I cannot find an answer to in the
documentation.</FONT></SPAN></DIV>
<DIV><SPAN class=711281016-19042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=711281016-19042005><FONT face=Arial size=2>If I have a
non-linear linestring, with many points, I know I can find the total distance
of the line with "length(geom)". If I specify a point that lies
somewhere directly on the linestring, is there a function that will determine
the length from the beginning point of the line to the specified point
somewhere on that line? Thanks for the help.</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2>Derek Figg</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>CXT Software,</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>a Connection Technology
Company</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="http://www.cxtsoftware.com/">www.cxtsoftware.com</A></FONT></DIV>
<DIV align=left><FONT face=Arial size=2>office (602) 265-0195</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>fax (602) 263-0942</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>