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

 Thanks for the quick turnaround! I think the city now works correctly, but
 the result as a whole becomes a mix of the old (incorrect) result and the
 new one. e.g.

 {{{
 # SELECT ST_X(ST_SnapToGrid(g.geomout, 0.00001)) As longitude,
 ST_Y(ST_SnapToGrid(g.geomout, 0.00001)) As latitude,addy FROM geocode('1
 Main St, Hanover, MA',1) as g;
      longitude      | latitude |                addy
 --------------------+----------+-------------------------------------
  -70.84437000000001 | 42.15834 | (1,,Main,St,,,Hanover,MA,02061,t,,)
 }}}

 The city looks right, but the coordinates and zip code point to what I'm
 guessing would be the result if the custom zip lookup table wasn't present
 - Jacobs Lane, Norwell, MA.

 (ST_SnapToGrid also doesn't seem to abbreviate the result properly the way
 I'm using it, but that's a question I'll address separately)

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