topic Re: Trying to generate Zip4 postal codes from an address list. in Data Management Questions

Trying to generate Zip4 postal codes from an address list.

ChadWhaley — Tue, 27 Nov 2012 15:48:36 GMT

I am trying to generate Zip4 postal codes from an address list. I have the address which is currently in this format

   Address                 City                State               ZIP
111 Camp Rd       Pensacola          FLORIDA        325040000

I have tried using the ZIP+4 address locator when geocoding but I only get xy coordinates and no ZIP+4 are generated.
Is there a certain process to this or do I need business analyst.

I currently just have home single use license.

Re: Trying to generate Zip4 postal codes from an address list.

JoeBorgione — Tue, 27 Nov 2012 16:33:19 GMT

I am trying to generate Zip4 postal codes from an address list. I have the address which is currently in this format

   Address                 City                State               ZIP
111 Camp Rd       Pensacola          FLORIDA        325040000

I have tried using the ZIP+4 address locator when geocoding but I only get xy coordinates and no ZIP+4 are generated.
Is there a certain process to this or do I need business analyst.

I currently just have home single use license.

Looks like you have the zip+4 data in your zip field: you should be able to extract the last four digits/characters with vba:
You can add a couple of fields called ZIP1 and ZIP2, where ZIP1 is the first 5 characters and and ZIP2 is your zip+4.

In the field calculator calc ZIP1 = left([zip],5)

In the field calculator calc ZIP2 = right([zip],4)

Is that what you want to do?

Re: Trying to generate Zip4 postal codes from an address list.

ChadWhaley — Tue, 27 Nov 2012 16:48:32 GMT

I may have stated that wrong....I am actually trying to get the Zip4 codes....all of the records have 0000 at the end of them.

Re: Trying to generate Zip4 postal codes from an address list.

JoeBorgione — Tue, 27 Nov 2012 18:54:35 GMT

I may have stated that wrong....I am actually trying to get the Zip4 codes....all of the records have 0000 at the end of them.

Well.... Good luck with that. Have you tried a local agency or the USPS for the information you are looking for?

The geocoding process doesn't automagically generate data; it works against existing data and 'simply' changes an address that you and I understand to an x,y pair of coordinates that the GIS understands...

Re: Trying to generate Zip4 postal codes from an address list.

KyleDixon — Fri, 18 Jul 2014 17:16:26 GMT

USPS has online tools that can do that: https://www.usps.com/business/web-tools-apis/welcome.htm‌

Or you can look up individually here: https://tools.usps.com/go/ZipLookupAction!input.action‌

- This would be a good QA tool.