[postgis-users] Incorrect Address Normalization

[Shawn Peterson]

I was testing normalize_address on the following address:
*
*
*100 El Camino Real, Menlo Park, CA 94025*

but it gives incorrect results. I tried to add the following entry
to postgis-2.1.0SVN/extras/tiger_geocoder/tiger_2011/tables/lookup_tables_2011.sql:

    FROM (VALUES
*        ('EL CAMINO', 'El Cam'),*
        ('CAM', 'Cam'),
        ('CAM.', 'Cam'),
...

and then
run postgis-2.1.0SVN/extras/tiger_geocoder/tiger_2011/create_geocode.sh.
But it does not work.

My postgreSQL is 9.2.4, and postGIS is 2.1.0SVN.

Any help is appreciated!

Thanks,
Shawn
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130425/0c3d49fd/attachment.html>