[postgis-tickets] [PostGIS] #2289: Redesign Geocoder

[PostGIS]

#2289: Redesign  Geocoder
----------------------------+-----------------------------------------------
 Reporter:  woodbri         |       Owner:  robe          
     Type:  enhancement     |      Status:  new           
 Priority:  medium          |   Milestone:  PostGIS Future
Component:  tiger geocoder  |     Version:  2.0.x         
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by woodbri):

 Correction: The 1000+ delta was because the tiger data did not have enough
 data or standardize, for example 434 had no name info and others probably
 had a required field that was null.

 To look at the record that failed to stanadardize I used the following
 query:

 {{{
 select count(*) as cnt,
        array_to_string(ARRAY[predirabrv, pretypabrv, prequalabr, name,
                              sufdirabrv, suftypabrv, sufqualabr], ' ') as
 micro
   from streets
  where gid in (
     select id
       from stdstreets
      where coalesce(building, house_num, predir, qual, pretype, name,
                     suftype, sufdir, ruralroute, extra,
                     city, state, country, postcode, box, unit) is null
       )
       and ac2='MA'
  group by micro
  order by micro;
 }}}

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