Smith, The general approach taken is using line interpolation - ST_line_interpolate_point(linestring geometry, locationfraction float8). So if you have a street say that has number 1 - 10 and you know you want street number 2 you would take intepolated point at position 0.2 along the segment. http://postgis.refractions.net/documentation/manual-svn/ch06.html#id2531874 Unfortunately we don't have any examples yet in the docs of that.
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith Roman Sent: Monday, October 20, 2008 5:38 AM To: Obe, Regina Cc: Users Postgis Subject: [postgis-users] Your opinion on geocoding ? Hi, 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 ? Thanks, Smith Roman. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
