[postgis-tickets] [PostGIS] #2760: geocoder producing erronous results

[PostGIS]

#2760: geocoder producing erronous results
----------------------------+-----------------------------------------------
 Reporter:  infinityedge    |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.1.5
Component:  tiger geocoder  |     Version:  2.1.x        
 Keywords:  geocoder        |  
----------------------------+-----------------------------------------------
Changes (by robe):

  * milestone:  => PostGIS 2.1.5


Comment:

 This is weird I didn't notice this ticket was this old, maybe because it
 wasn't slated for a milestone I missed it.  I tried these on my PostGIS
 2.1.4 install (which is newer than yours) and they give the right answers.
 But I'm not sure if my install is completely a clean 2.1.4 since I think I
 upgraded from prior.

 The Shields one doesn't geocode right but part of that is the
 normalize_address doesn't know what do to with One (translate to 1)

 the others seem reasonable for example:

 {{{
   select * FROM geocode('805 Russell Blvd, Davis, CA 95616',100);

 -- gives
 (805,,Russell,Blvd,,,Davis,CA,95616,t);0101000020AD100000C7336FA6A9705EC05BF054B5F0454340;0

 -- and
 select (geocode('30 LA PATERA CT., CAMARILLO, CA 9301',1));

 --gives
 ("(30,,""la
 Patera"",Ct,,,Camarillo,CA,93010,t)",0101000020AD1000001E51989626C55DC0763B53F60B1F4140,1)
 }}}

 I see you did load up the nation script and other so my comment isn't
 relevant.

 The behavior you are getting sounds like you are missing records in your
 california edges or featnames.  If the problem is isolated to a particular
 region, that could be the issue.

 Just for compare to rule that out:
 I have 3,908,126 records in my tiger.ca_edges
 4,532,617 in tiger.ca_featnames
 1,127,191 in tiger.ca_faces


 Can you run:


 {{{
 SELECT set_geocode_setting('debug_geocode_address', 'true');


 }}}

 Then rerun and paste the notice that outputs the queries and prepared
 statements

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2760#comment:5>
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.