[postgis-tickets] [PostGIS] #3791: PostGIS tiger geocoder should use cousub in addition to place for non-specific

[PostGIS]

#3791: PostGIS tiger geocoder should use cousub in addition to place for non-
specific
----------------------------+---------------------------
 Reporter:  robe            |      Owner:  robe
     Type:  defect          |     Status:  new
 Priority:  medium          |  Milestone:  PostGIS 2.4.0
Component:  tiger geocoder  |    Version:  2.3.x
 Keywords:                  |
----------------------------+---------------------------
 Seems if you do:


 {{{
   SELECT pprint_addy(addy), ST_AsText(geomout), rating FROM
 geocode('Brooklyn, NY',1);
 }}}

 you get no answer back although Brooklyn is listed in
 tiger_data.ny_cousub.

 However if you use a value that is in ny_place such as

 {{{
   SELECT pprint_addy(addy), ST_AsText(geomout), rating FROM
 geocode('Bronxvilled, NY',1);
 }}}

 it works.

 tiger should try to use tiger.cousub as well as tiger.place.

 I think cousub might currently only be used for some joins.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3791>
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.