Where is the USPS Abbreviation dictionary?..

[SteveCole]

At the conference in the workshop about using Maplex, the presenters mentioned that there was a USPS abbreviation dictionary available but I can't seem to find it on any of the ESRI pages (or desktop help).

Am I just missing the link?

[ElliottPlack]

I was looking for it too, with no luck, so I'm just going to create it. Standby.

[ElliottPlack · Accepted solution]

Ok. I made this from scratch using Google Refine. It's attached as a python file because the forum does not allow uploads of text files larger than 12.5kb. You'll need to change the extension to .dic and then add it via the Open From File dialog. I'm assuming you know how to do that.

Here was my process if interested:

1. Visited the official USPS abbreviation list


2. Copied everything in the Street Suffixes section


3. Pasted it into MS Excel (to preserve tables)


4. Brought the tables into Google Refine


5. Did some transformations and deleted the unneeded first column (code is below)


6. Exported as space separated


7. Used text editor to replace triple double quotes with single double quotes


8. QC'd data... Found and deleted one duplicate (ANNEX) and one error (CT--> CTS), perhaps I'll notify USPS.


9. Uploaded here

Google Refine code used:

[   {     "op": "core/column-move",     "description": "Move column Commonly Used Street*Suffix or Abbreviation to position 0",     "columnName": "Commonly Used Street*Suffix or Abbreviation",     "index": 0   },   {     "op": "core/column-removal",     "description": "Remove column Primary Street Suffix",     "columnName": "Primary Street Suffix"   },   {     "op": "core/row-removal",     "description": "Remove rows",     "engineConfig": {       "facets": [         {           "invert": false,           "expression": "isBlank(value)",           "selectError": false,           "omitError": false,           "selectBlank": false,           "name": "Commonly Used Street*Suffix or Abbreviation",           "omitBlank": false,           "columnName": "Commonly Used Street*Suffix or Abbreviation",           "type": "list",           "selection": [             {               "v": {                 "v": true,                 "l": "true"               }             }           ]         }       ],       "mode": "row-based"     }   },   {     "op": "core/text-transform",     "description": "Text transform on cells in column Commonly Used Street*Suffix or Abbreviation using expression value.trim()",     "engineConfig": {       "facets": [         {           "invert": false,           "expression": "isBlank(value)",           "selectError": false,           "omitError": false,           "selectBlank": false,           "name": "Commonly Used Street*Suffix or Abbreviation",           "omitBlank": false,           "columnName": "Commonly Used Street*Suffix or Abbreviation",           "type": "list",           "selection": [             {               "v": {                 "v": false,                 "l": "false"               }             }           ]         }       ],       "mode": "row-based"     },     "columnName": "Commonly Used Street*Suffix or Abbreviation",     "expression": "value.trim()",     "onError": "keep-original",     "repeat": false,     "repeatCount": 10   },   {     "op": "core/text-transform",     "description": "Text transform on cells in column Commonly Used Street*Suffix or Abbreviation using expression value.trim()",     "engineConfig": {       "facets": [],       "mode": "row-based"     },     "columnName": "Commonly Used Street*Suffix or Abbreviation",     "expression": "value.trim()",     "onError": "keep-original",     "repeat": false,     "repeatCount": 10   },   {     "op": "core/text-transform",     "description": "Text transform on cells in column Commonly Used Street*Suffix or Abbreviation using expression value.replace(/\\s+/,' ')",     "engineConfig": {       "facets": [],       "mode": "row-based"     },     "columnName": "Commonly Used Street*Suffix or Abbreviation",     "expression": "value.replace(/\\s+/,' ')",     "onError": "keep-original",     "repeat": false,     "repeatCount": 10   },   {     "op": "core/text-transform",     "description": "Text transform on cells in column Commonly Used Street*Suffix or Abbreviation using expression grel:value.replace(\"\\s\",value)",     "engineConfig": {       "facets": [],       "mode": "row-based"     },     "columnName": "Commonly Used Street*Suffix or Abbreviation",     "expression": "grel:value.replace(\"\\s\",value)",     "onError": "keep-original",     "repeat": false,     "repeatCount": 10   },   {     "op": "core/text-transform",     "description": "Text transform on cells in column Commonly Used Street*Suffix or Abbreviation using expression grel:value.replace(\" \",value)",     "engineConfig": {       "facets": [],       "mode": "row-based"     },     "columnName": "Commonly Used Street*Suffix or Abbreviation",     "expression": "grel:value.replace(\" \",value)",     "onError": "keep-original",     "repeat": false,     "repeatCount": 10   } ]

[SteveCole]

Awesome! Thanks, Elliott. Your file imported just fine..

[SteveCole]

FYI-

I just came across my notes from the ESRI UC workshop I mentioned in my original post. Their slide says to look at Knowledge Base 30494 for the US Streets example. I just searched on that number and nothing was returned..

[SamuelTroth · Accepted solution]

Here is a link to the knowledge base article: http://support.esri.com/en/knowledgebase/techarticles/detail/30494

The link in the article is broken and you should use the link eplack posted. For creating abbreviation dictionaries in Maplex refer to the instructions in the above KB article.

Sam
Esri

[KathrynArchuleta]

Here was my process if interested: 

 
 
• Visited the official USPS abbreviation list
 
 
• Copied everything in the Street Suffixes section
 
 
• Pasted it into MS Excel (to preserve tables)
 

I was wondering if you would be so kind as to post your original Excel files. I am working on doing mailing lists & new contacts for our non-profit organization and I can't seem to find ANYWHERE where they have a table that will copy CORRECTLY into Excel (or preferably, Numbers - The Mac OS X equivalent of Excel).

I've been able to find a couple of websites that will copy correctly,but they ONLY do so if you select the EXACT NUMBER of cells that are needed for the data you are copying!! Needless to say this is FRUSTRATING!!

I Would GREATLY APPRECIATE any of the USPS Abbreviation Tables that you have in MS Excel format.

Thank You.

~ KMA

[m_neer]

Attached is the dictionary (.dic) I got from above statements (USPS) Website  "Enjoy"