[postgis-devel] Normalize_address() behavior

[maplabs at light42.com]

of the 150,000 USPS CASS test-suite addresses 
116,000 of them start with a number - set the others aside for now
(rural route, PO Box, etc)

of those 116,000 run through normalize_address()
about 60,000 match in the "round trip" of normalize, then pprint

my approach was
for all, record the Levenshtein distance of  UPPER(in) 
 UPPER(pprint(norm(in)))
 sort by lev distance and examine.. 

meanwhile, Bob Spence is looking at specific behaviors
so far, he has picked out a few telling examples

---------------------------------------------------------------

400 AVENUE I, WEST POINT, GA 31833
400 AVENUE I W, POINT, GA 31833

---------------
19596 COUNTY ROAD 480, COLCORD, OK 74338
19596 480 Co Rd, COLCORD, OK 74338

29779 STATE HIGHWAY C BOX 974, POTOSI, MO 63664
29779 C State Hwy, POTOSI, MO 63664

10559 NE STATE HIGHWAY 90, PINEVILLE, MO 64856
10559 90 State Hwy NE, PINEVILLE, MO 64856

18208 N COUNTY ROAD 241, ALACHUA, FL 32615
18208 241 Co Rd N, ALACHUA, FL 32615

4345 ROUTE 353, SALAMANCA, NY 14779
4345 353 Rte, SALAMANCA, NY 14779

19799 STATE ROUTE O, COSBY, MO 64436
19799 O State Rte, COSBY, MO 64436

------------------------------------------------------

1292 NE AVENUE B, SWEETWATER, TX 79556
1292 NE Ave, SWEETWATER, TX 79556

399 WEST AVE F, JEROME, ID 83338
399 WEST Ave, JEROME, ID 83338

------------------------------------------------------

19126-20 9TH AVE, PARKER, AZ 85344
1912620 9TH Ave, PARKER, AZ 85344

1818-307 N 40TH ST, PHOENIX, AZ 85008
1818307 N 40TH St, PHOENIX, AZ 85008

------------------------------------------------------

4D 664TH ST, NEW CASTLE, AL 35119
4 664TH St, NEW CASTLE, AL 35119

------------------------------------------------------

110 CENTER COVE I, SPICEWOOD, TX 78669
110 CENTER Cv, SPICEWOOD, TX 78669

------------------------------------------------------

492 STUYVESANT AVE # 4223 # 1330, IRVINGTON, NJ 07111
492 STUYVESANT Ave, IRVINGTON, NJ 07111

114 HAYES ML RD APT B122, ATCO, NJ 08004
114 HAYES ML Rd, APT, ATCO, NJ 08004

4906 LA BR APT A, HOUSTON, TX 77004
4906 LA Br, APT, HOUSTON, TX 77004

------------------------------------------------------

900 CITY FEDERAL BUILDING # 407, BIRMINGHAM, AL 35203
900, BUILDING # 407, BIRMINGHAM, AL 35203