[postgis-users] geocode function finding wrong town

[Paragon Corporation]

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-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Kevin Lynch
> Sent: Thursday, July 05, 2012 1:41 PM
> To: postgis-users at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>