United States Postal Service (USPS) Street Suffix Database.
Lists USA street suffixes.
EG:
1 ALLEY ALLEE ALY
2 ALLEY ALLEY ALY
3 ALLEY ALLY ALY
4 ALLEY ALY ALY
5 ANNEX ANEX ANX
6 ANNEX ANNEX ANX
7 ANNEX ANNX ANX
8 ANNEX ANX ANX
9 ARCADE ARC ARC
10 ARCADE ARCADE ARC
11 AVENUE AV AVE
12 AVENUE AVE AVE
13 AVENUE AVEN AVE
14 AVENUE AVENU AVE
15 AVENUE AVENUE AVE
16 AVENUE AVN AVE
17 AVENUE AVNUE AVE
18 BAYOO BAYOO BYU
19 BAYOO BAYOU BYU
20 BEACH BCH BCH
21 BEACH BEACH BCH
22 BEND BEND BND
23 BEND BND BND
24 BLUFF BLF BLF
25 BLUFF BLUF BLF
26 BLUFF BLUFF BLF
27 BLUFFS BLUFFS BLFS
28 BOTTOM BOT BTM
USPS street suffixes database table structure:
PrimaryStreetSuffixName | CommonlyUsed | StandardSuffixAbbreviation
Actual MYSQL USPS street suffixes database sample:
INSERT INTO `uspsstreetsuff` (`ID`, `PrimaryStreetSuffixName`, `CommonlyUsed`, `StandardSuffixAbbreviation`) VALUES
(1, ´PrimaryStreetSuffixName´, ´CommonlyUsed´, ´StandardSuffixAbbreviation´),
(2, ´ALLEY´, ´ALLEY´, ´ALY´),
(3, ´ALLEY´, ´ALLY´, ´ALY´),
(4, ´ALLEY´, ´ALY´, ´ALY´),
(5, ´ANNEX´, ´ANEX ´, ´ANX´),
(6, ´ANNEX´, ´ANNEX´, ´ANX´),
(7, ´ANNEX´, ´ANNX´, ´ANX´),
(8, ´ANNEX ´, ´ANX´, ´ANX´),
(9, ´ARCADE´, ´ARC´, ´ARC´),
(10, ´ARCADE´, ´ARCADE´, ´ARC´),
(11, ´AVENUE´, ´AV´, ´AVE´),
(12, ´AVENUE´, ´AVE´, ´AVE´),
(13, ´AVENUE´, ´AVEN´, ´AVE´),
(14, ´AVENUE´, ´AVENU´, ´AVE´),
(15, ´AVENUE´, ´AVENUE´, ´AVE´),
(16, ´AVENUE´, ´AVN´, ´AVE´),
(17, ´AVENUE´, ´AVNUE´, ´AVE´),
(18, ´BAYOO´, ´BAYOO´, ´BYU´),
(19, ´BAYOO´, ´BAYOU´, ´BYU´),
(20, ´BEACH´, ´BCH´, ´BCH´),
Total records 528.
File Types: MYSQL (.sql) - CSV (.csv) |