[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:
-----------------------------+---------------------------

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


 {{{

 12:42:06        turova:
 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.


 Examples:


 {{{
 -- 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,E,Main,St,,,Ware,MA,01082,t,,)
 0101000020AD1000002FB5DC320F0F52C0E0E8EF375B214540      10
 }}}

--

Comment (by robe):

 Examples:


 {{{
 -- yields right answer
 SELECT *
 FROM geocode('1 Main St, Hanover, MA 02339',1);

 (1,,Main,St,,,Hanover,MA,02339,t,,)
 0101000020AD1000007FB2EFD615B651C06A1D3D91020F4540      0

 }}}



 {{{
 -- yields right answer
 SELECT *
 FROM geocode('1 Main St, Hanover, MA 02339',1);

 (1,,Main,St,,,Hanover,MA,02339,t,,)
 0101000020AD1000007FB2EFD615B651C06A1D3D91020F4540      0

 }}}

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