<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">In PostGIS parlance, <span class="Apple-style-span" style="font-family: monospace; white-space: pre; ">given a lat/lng point... where -- in terms of percentage or decimal -- does it lie along on a row's </span><span class="Apple-style-span" style="font-family: monospace; white-space: pre; ">multilinestring?</span><div><font class="Apple-style-span" face="monospace"><span class="Apple-style-span" style="white-space: pre;"><br></span></font></div><div><font class="Apple-style-span" face="monospace"><span class="Apple-style-span" style="white-space: pre;">The thing is, the multilinestring is just a single line string. But I suppose there are cases where there are more than one segment to the street… In any case, I have a range of house numbers, and I need to determine which side of the multilinestring the latlng lies, and then how far along… I know I'm not the first person to ask this, but I haven't been able to find a suitable answer.<br></span></font></div><div><div><font class="Apple-style-span" face="monospace"><span class="Apple-style-span" style="white-space: pre;"><br></span></font></div><div><font class="Apple-style-span" face="monospace"><span class="Apple-style-span" style="white-space: pre;">For what it's worth, I'm using the 2010 Tigerline data imported via shp2pgsql. </span></font></div><div><font class="Apple-style-span" face="monospace"><span class="Apple-style-span" style="white-space: pre;"><br></span></font></div><div><font class="Apple-style-span" face="monospace"><span class="Apple-style-span" style="white-space: pre;">Any ideas? Thanks!</span></font></div><div><font class="Apple-style-span" face="monospace"><span class="Apple-style-span" style="white-space: pre;"><br></span></font></div><div><font class="Apple-style-span" face="monospace"><span class="Apple-style-span" style="white-space: pre;">…Rene</span></font></div><div><br></div></div></body></html>