[postgis-devel] [PostGIS] #1074: Matching on different street spelling?

[PostGIS]

#1074: Matching on different street spelling?
----------------------------+-----------------------------------------------
 Reporter:  mikepease       |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  tiger geocoder  |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 For that to work I'd have to add a var_ops btree index.  Right now its
 doing a soundex or exact match.  I'm going to experiment to see which is
 more efficient for both speed and efficiency a var_ops btree or fulltext
 (or trigram -- but trigram helping ILIKE only works in 9.1, so that rules
 that out a bit thought I could use native trigram similarity checks) .
 Fulltext would probably solve the St. .. and Cam / Camino cases with
 custom dictionaries so I'm still leaning toward that solution.

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