geocommons / geocoder

Modular Street Address Geocoder
http:///www.geocommons.com
GNU Lesser General Public License v3.0
395 stars 89 forks source link

Metaphone on import doesn't match metaphone when geocoding #17

Open peterlandry opened 14 years ago

peterlandry commented 14 years ago

After importing tiger data, a feature record for "Dexter St" gets a metaphone value of "TKTR". This is confirmed by manually testing the metaphone library:

$sqlite3 /opt/tiger/geocoder.db
sqlite> .load lib/geocoder/us/sqlite3.so
sqlite> select metaphone('Dexter');
TKTR

This, compared to the results from Text::Metaphone:

$ irb
irb(main):001:0> require 'rubygems'
=> true
irb(main):002:0> require 'text'
=> true
irb(main):003:0> Text::Metaphone.metaphone 'Dexter'
=> "TXTR"

This is preventing valid addresses on Dexter St from being geocoded at the range level.