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

Comment (by turova):

 I actually do see a correct result show up in geocode, when I print all
 the results:

 {{{
 # SELECT rating, ST_X(g.geomout), ST_Y(g.geomout), addy from geocode('1
 Main st, Hanover, MA', 100) as g;
  rating |        st_x        |        st_y        |
 addy
 --------+--------------------+--------------------+---------------------------------------------
       3 | -70.84580124395251 |  42.11770418442778 |
 (1,,Main,St,,,Norwell,MA,02339,t,,)
       3 | -70.84580124395251 |  42.11770418442778 |
 (1,,Main,St,,,Hanover,MA,02339,t,,)
       3 | -70.84437177401414 |  42.15834177639814 |
 (1,,Main,St,,,Hanover,MA,02061,t,,)
       9 | -70.84437177401414 |  42.15834177639814 |
 (1,,Main,St,,,Norwell,MA,02061,t,,)
      10 | -72.59865296286365 | 42.215393856763214 |
 (1,N,Main,St,,,Chicopee,MA,01075,t,,)
      10 |  -72.9734286784644 |  42.49264706267212 |
 (1,W,Main,St,,,Windsor,MA,01026,t,,)
      10 | -72.87441852410113 |  42.50110417638284 |
 (1,E,Main,St,,,Windsor,MA,01070,t,,)
      12 |  -72.9734286784644 |  42.49264706267212 |
 (1,W,Main,St,,,Plainfield,MA,01026,t,,)
      12 | -72.87441852410113 |  42.50110417638284 |
 (1,E,Main,St,,,Plainfield,MA,01070,t,,)
      13 | -72.87736680839346 |  42.23484564776451 |
 (1,E,Main,St,,,Huntington,MA,01050,t,,)
      14 |  -72.9734286784644 |  42.49264706267212 |
 (1,W,Main,St,,,Worthington,MA,01026,t,,)
      14 |  -72.9734286784644 |  42.49264706267212 |
 (1,W,Main,St,,,Cummington,MA,01026,t,,)
      14 |  -72.9734286784644 |  42.49264706267212 |
 (1,W,Main,St,,,Chesterfield,MA,01026,t,,)
      15 | -72.59865296286365 | 42.215393856763214 | (1,N,Main,St,,,"South
 Hadley",MA,01075,t,,)
 (14 rows)
 }}}

 The the result I want is the 2nd one in this case, though I saw it as the
 3rd result when set the second argument of geocode to 3. I think the new
 lookup table will now give an extra result for any city sharing the
 related zip code, adding the correct location to the results list, but
 also making it programmatically indistinguishable from the incorrect
 result.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4826#comment:6>
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.