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)
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
