<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16735" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008>Smith,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008>The general approach taken is using line interpolation
- <SPAN class=term><FONT face="Times New Roman" color=#000000
size=3>ST_line_interpolate_point(linestring geometry, locationfraction
float8)</FONT></SPAN>. </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008>So if you have a street say that has
number</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008>1 - 10 </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008>and you know you want street number
2</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008>you would take intepolated point at
position 0.2 along the segment.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008><A
href="http://postgis.refractions.net/documentation/manual-svn/ch06.html#id2531874">http://postgis.refractions.net/documentation/manual-svn/ch06.html#id2531874</A></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008>Unfortunately we don't have any examples yet in the
docs of that.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=359265619-20102008></SPAN></FONT> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Smith
Roman<BR><B>Sent:</B> Monday, October 20, 2008 5:38 AM<BR><B>To:</B> Obe,
Regina<BR><B>Cc:</B> Users Postgis<BR><B>Subject:</B> [postgis-users] Your
opinion on geocoding ?<BR></FONT><BR></DIV>
<DIV></DIV>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD vAlign=top>Hi,<BR><BR>Thanks, for your replies. I will like to ask for
your own opinion as regarding geocoding. Considering the limitations of my
data. Which geocoding method do you think will be appropriate ? If
possible, if you have links to papers on geocoding i will be grateful. Or
do u think geocoding the street names using the center point of the
linestrings is the most appropriate method ?<BR><BR>Thanks,<BR><BR>Smith
Roman.
<BR></TD></TR></TBODY></TABLE><BR>__________________________________________________<BR>Do
You Yahoo!?<BR>Tired of spam? Yahoo! Mail has the best spam protection around
<BR>http://mail.yahoo.com </BODY></HTML>