topic Re: Where is the USPS Abbreviation dictionary?.. in Mapping Questions

Where is the USPS Abbreviation dictionary?..

SteveCole — Tue, 31 Jul 2012 15:16:41 GMT

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?

Re: Where is the USPS Abbreviation dictionary?..

ElliottPlack — Fri, 03 Aug 2012 17:51:51 GMT

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

Re: Where is the USPS Abbreviation dictionary?..

ElliottPlack — Fri, 03 Aug 2012 19:33:54 GMT

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:

Visited the official USPS abbreviation list

Copied everything in the Street Suffixes section

Pasted it into MS Excel (to preserve tables)

Brought the tables into Google Refine

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

Exported as space separated

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

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

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   } ]

Re: Where is the USPS Abbreviation dictionary?..

SteveCole — Fri, 03 Aug 2012 20:51:25 GMT

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

Re: Where is the USPS Abbreviation dictionary?..

SteveCole — Wed, 08 Aug 2012 20:28:11 GMT

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..

Re: Where is the USPS Abbreviation dictionary?..

SamuelTroth — Wed, 22 Aug 2012 09:39:09 GMT

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

Re: ...USPS Abbreviation dictionary? - Could you post your Excel Tables?

KathrynArchuleta — Mon, 10 Feb 2014 17:56:43 GMT

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

Re: ...USPS Abbreviation dictionary? - Could you post your Excel Tables?

mneer — Thu, 26 Jun 2014 21:30:16 GMT

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