Opened 4 years ago

Last modified 3 years ago

#4826 closed defect

Geocoder gives goofy resutls for 1 Main St, Hanover, MA — at Version 1

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 3.1.2
Component: tiger geocoder Version: 3.1.x
Keywords: Cc:

Description (last modified by robe)

tiger geocoder as mentioned on IRC

http://irclogs.geoapt.com/postgis/%23postgis.2021-01-05.log

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
**/

Change History (1)

comment:1 by robe, 4 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.