[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 robe):

 Try replacing your geocode_address with this one - make sure to prefix
 with tiger.

 [ba2f659c001142687caf05a3999501ecd37e307a/git]


 With the above patch, my results for:


 {{{
 SELECT rating, ST_X(g.geomout), ST_Y(g.geomout), addy from geocode('1 Main
 st, Hanover, MA', 100) as g;

 }}}

 Look like:


 {{{
 3       -70.84508298309264      42.11726584896208
 (1,,Main,St,,,Hanover,MA,02339,t,,)
 9       -70.84437177401415      42.15834177639816
 (1,,Main,St,,,Norwell,MA,02061,t,,)
 10      -72.23530265382281      42.260596267836945
 (1,E,Main,St,,,Ware,MA,01082,t,,)
 11      -72.79730604439531      42.43541221562752
 (1,S,Main,St,,,Goshen,MA,01096,t,,)
 12      -72.87424511880401      42.500985260983285
 (1,E,Main,St,,,Plainfield,MA,01070,t,,)
 14      -72.40080978104714      42.276919680561925
 (1,S,Main,St,,,Belchertown,MA,01007,t,,)
 14      -72.65981893720061      42.328655966035754
 (1,S,Main,St,,,Northampton,MA,01062,t,,)
 14      -72.40355779373047      42.27997542236744
 (1,N,Main,St,,,Belchertown,MA,01007,t,,)
 14      -72.3321618003692       42.18801537873117
 (1,S,Main,St,,,"Palmer Town",MA,01079,t,,)
 15      -72.59183570986102      42.214047537431945
 (1,S,Main,St,,,"South Hadley",MA,01075,t,,)
 15      -72.73052592739397      42.39331433997838
 (1,N,Main,St,,,Williamsburg,MA,01096,t,,)
 15      -72.59865296286365      42.215393856763214
 (1,N,Main,St,,,"South Hadley",MA,01075,t,,)
 21      -70.75985323124343      42.16990860652304
 (,,Main,St,,,Scituate,MA,02061,t,,)
 }}}

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