[postgis-tickets] [PostGIS] #4826: Geocoder gives goofy resutls for 1 Main St, Hanover, MA

[PostGIS]

#4826: Geocoder gives goofy resutls for 1 Main St, Hanover, MA
-----------------------------+---------------------------
  Reporter:  robe            |      Owner:  robe
      Type:  defect          |     Status:  new
  Priority:  medium          |  Milestone:  PostGIS 3.1.1
 Component:  tiger geocoder  |    Version:  3.1.x
Resolution:                  |   Keywords:
-----------------------------+---------------------------
Description changed by robe:

Old description:

> 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.

New description:

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

--

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4826#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.