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

 I have 756,778 segments in stdaddr and 757,766 in tiger for MA. The
 difference is 1000+ that did not standardize. I simple left join and
 distinct on the name will show you the records that need to be considered
 when updating the the lexicon and/or rules.

 I store my tiger records as single-sided denormalized records. So if a
 segment has 4 names and 3 alt address ranges, and 2 placenames, I have
 4*3*2 records for it. Each of my tiger records has a side field so I can I
 can offset if needed. My goal was to preprocess the data to make the
 geocoder design simple and straight forward.

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