[postgis-users] geocode function finding wrong town

[Kevin Lynch]

Hello,

I am using Postgis 2.0 with Postgresql 9.1, loaded with TIGER 2010 data. 
I created the database using the fuzzystrmatch extension, and am unable 
to find a specific town. I suspect that the fuzzy matcher is the 
problem, but am unsure of how to further debug this issue.

When I am looking for "Westford, MA", I am given "Westfield, MA" in 
return. Westford is in the database, as I can correctly do a reverse lookup.

Any help would be appreciated.

Thanks,
Kevin Lynch


SELECT * FROM geocode('Westford, MA', 100);

               addy               |                      
geomout                       | rating
---------------------------------+----------------------------------------------------+--------
  (,,,,,,Westfield,MA,,t)         | 
0101000020AD1000009564FFB9653052C05A34E5E1AE114540 |    103
  (,,,,,,Westborough,MA,,t)       | 
0101000020AD100000DD75E8687AE751C06C5D7DD232224540 |    105
  (,,,,,,"West Falmouth",MA,,t)   | 
0101000020AD10000093592354E3A851C0ACB25BABF9CC4440 |    107
  (,,,,,,"West Brookfield",MA,,t) | 
0101000020AD100000E800D9FA4F0952C013424220911E4540 |    109
(4 rows)


SELECT * FROM reverse_geocode(ST_GeomFromText('POINT(-71.43712 42.58134)'));
                         intpt                         
|                   addy                   |         street
------------------------------------------------------+------------------------------------------+-------------------------
  {0101000020AD1000002DFF09C706DC51C0C0BA350E774A4540} | 
{"(2,,Lincoln,St,,,Westford,MA,01886,)"} | {"Main St","Boston Rd"}
(1 row)