Address Matching in Visual Basic 6
$100-250 USD
Paid on delivery
I have 2 tables with 18.3 million addresses that have two different forms that need to be matched to 97% accuracy or better.
The forms are:
1) Address, city, state, zip
2) StreetNumber, Pre-directional (North, West, East, South)), StreetName, Suffix, Post-directional (North, West, East, South), Unit type, Unit, City, State, Zip.
Both tables are in SQL 2005 format.
I can remove all of the other data and just send you backup files of the database with the address and a index key.
## Deliverables
example of #1 address type:
1109 Fairview Rd
16127 Early Rd
1810 Poinciana Rd
1112 E 1st St
1581 N Curry Rd
111 Rockville Pike #980
199 Weymouth St Ste 2
10345 Jj Hwy
2222 Filmore Ave Ste 1
1909 Oakhurst Ave
4304 Monitor St
219 S 6th St
example of #2 address type:
STREET_NUMBER PRE_DIRECTIONAL PREFIX STREET_NAME SUFFIX POST_DIRECTIONAL UNIT_TYPE UNIT CITY_NAME STATE_ABBR ZIP ZIP4
9945 HIGHWAY 352 CLARKSVILLE AR 72830
300 MARKET ST OAKLAND CA 94607 3005
737 2ND ST APT 309 OAKLAND CA 94607 3007
655 3RD ST OAKLAND CA 94607 3559
431 MARTIN LUTHER KING JR WAY OAKLAND CA 94607 3535
418 CASTRO ST OAKLAND CA 94607
578 4TH ST OAKLAND CA 94607
300 JEFFERSON ST OAKLAND CA 94607 3538
570 3RD ST OAKLAND CA 94607
577 5TH ST OAKLAND CA 94607 3555
229 BROADWAY OAKLAND CA 94607 3802
201 BROADWAY OAKLAND CA 94607 3802
101 BROADWAY OAKLAND CA 94607 3745
300 BROADWAY OAKLAND CA 94607 3805
424 2ND ST OAKLAND CA 94607 3815
381 5TH ST OAKLAND CA 94607 4132
330 FRANKLIN ST OAKLAND CA 94607 3823
373 4TH ST APT 2C OAKLAND CA 94607 4115
333 5TH ST OAKLAND CA 94607 4107
311 4TH ST APT 126 OAKLAND CA 94607 4137
335 3RD ST OAKLAND CA 94607
Project ID: #2784387