Geocoder gives goofy resutls for 1 Main St, Hanover, MA
|Reported by:||robe||Owned by:||robe|
Description (last modified by )
tiger geocoder as mentioned on IRC
sorry for the repeat from last night, but if anyone's here and knows where I can look for an answer - my TIGER PostGIS setup is returning weird results? when I run geocode('1 Main St, Hanover, MA 02239') it returns a good result, but when I skip the zip code, it returns a result in Andover, which is obviously wrong even though the correct result does exist
One observation is that Hanover is not in the place table, but is in the cousub table.
-- yields right answer SELECT * FROM geocode('1 Main St, Hanover, MA 02339',1); /** (1,,Main,St,,,Hanover,MA,02339,t,,) 0101000020AD1000007FB2EFD615B651C06A1D3D91020F4540 0 **/
-- yields wrong answer SELECT * FROM geocode('1 Main St, Hanover, MA',1); /** (1,E,Main,St,,,Ware,MA,01082,t,,) 0101000020AD1000002FB5DC320F0F52C0E0E8EF375B214540 10 **/