Kevin, Can you ticket this one:
http://trac.osgeo.org/postgis/ and I'll take a look next I have the chance. I suspect it has something to do with the fact that Westford only appears in cousub table and the reverse geocoder uses that as a check, but I suspect the geocoder doesn't or at least not in the 2010 version. Interesting For my tiger_2011 mass data this query: SELECT * FROM geocode('Westford, MA', 100); returns addy | geomout | rating ----------------------------+----------------------------------------------- -----+-------- (,,,,,,Westford,MA,01450,t) | 0101000020AD10000087BC5348EDE351C0865356BC8C4E4540 | 100 (the point in plain text is -- POINT(-71.5613575761546 42.6136699124827) which still seems wrong and the zip is wrong. The tiger 2010 as you said returns those other answers and not even Westford. Thanks, Regina http://www.postgis.us > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On > Behalf Of Kevin Lynch > Sent: Thursday, July 05, 2012 1:41 PM > To: postgis-users@postgis.refractions.net > Subject: [postgis-users] geocode function finding wrong town > > 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 > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users