[postgis-users] computing the center of a Linestring ?

[Smith Roman]

HI,
I have a base map of lagos, Nigeria that contains roads, streets and points of interest (POI). Unfortunately the street addresses are not geocoded. I was told they are possible ways to geocode such kind of data e.g. geocode to a street name, geocode to a street intersection and/or point of interest.
 
I will like to ask what postgis functions can be used to do this kind of operation ? 
 
For example, If I intend geocoding to a street name, this will imply assigning point coordinates to represent each street, to this i will need to get the center point of each street. By their nature streets and roads are not straight.
 is there a postgis function for computing the center of a Linestring ? especially if the linestring is not straight but has a few curves. All the roads and streets are represented as linestrings in my data.
 
It will be appreciated if I can get suggestions on the geocoding method to use and how postgis can be used to implement it. 
 
Thanks, 
 
Smith.



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081016/f73dc3e8/attachment.html>