[postgis-users] Address Geocoding

[ibrahim saricicek]

Hi;

for reverse geoceding now using this and works fine;

SELECT id, the_geom
FROM (roads, settlements, poi, province, etc...)
WHERE
  the_geom && SetSRID('BOX3D(x+0.01 y+0.01, x-0.01 y-0.01)'::box3d, 4326)
ORDER BY
  ST_Distance(the_geom, GeomFromText('POINT(x y)', 4326))
LIMIT 1;

regards...

On Fri, Mar 19, 2010 at 8:23 PM, Stephen Woodbridge <woodbri at swoodbridge.com
> wrote:

> http://www.google.com/#hl=en&source=hp&q=postgis+geocoder
>
> Ricardo Bayley wrote:
>
>> Hi fellows,
>>
>> I was wondering if any of you have a good approach to do Address Geocoding
>> within postgis.
>> Any ideas, considerations, thoughts ??
>>
>> thanks in advanced.
>>
>>
>> Warm regards,
>>
>>
>> Ricardo
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100324/e97f9f08/attachment.html>