Geography & MS Map

Chartman of the Bored · May 20th, 2002, 02:56 PM

I'm trying to use MS Map to show the concentration of companies (about 4000 in my list) throughout the U.S. However, MS Map doesn't recognize a lot of the zip codes and I'm not sure why. I tried the Format Cells/Number/Special/Zip Codes formatting for all the zip codes cells, but still get this problem for many cells. Thanks in advance for any help.

Chris Davison · May 22nd, 2002, 01:06 PM

Are you able to post examples of the codes that aren't recognised ?

I'm guessing they're those weird ones with extra numbers

02468-4378 for example

Chris

cornbread · May 22nd, 2002, 01:18 PM

post an example of a zip code with a problem and I'll tell you what's wrong if I can. The zips 97200-9999 or whatever won't show up because the -9999 is a delivery route within that postal zip of 97200. If that is your only problem set up a macro that parses out the -9999 segment also known as the +4 and try those zip codes then without the +4. If the problem is larger than that post some true examples of the zips not running and I will run them against the USPS data base and see what's up with them. The plus four or -9999 form of zip coding you will never need unless you are creating mailing lists and want reduced postal rates or you are a GIS person validating address data for a company like a telecom or power company.

Chartman of the Bored · May 22nd, 2002, 03:25 PM

cornbread and Chris,

Thanks for responding. I had almost given up on this thread after no replies for a couple of days...

I did extensive re-formatting of the codes using LEN, LEFT, concatenation, etc. I managed to get almost all the zip codes to work, except for seven of them. For those seven, I got an error saying, "The following data is not recognized as geographical data:", so it finally dawned on me that maybe they really are just bad data. Someone probably typed in some zip codes that don't exist (or maybe didn't exist when MS Map was created). Here are the seven:

92618, 06615, 30005, 01702, 02421, 02451, 13507.

Thanks

Chris Davison · May 25th, 2002, 05:24 AM

those zips do exist, except the last one :

http://zip.langenberg.com/

May 25th, 2002, 05:24 AM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	those zips do exist, except the last one : http://zip.langenberg.com/ __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 02:56 PM	#1
Chartman of the Bored Board Regular Join Date: Apr 2002 Location: Palo Alto, CA Posts: 75	I'm trying to use MS Map to show the concentration of companies (about 4000 in my list) throughout the U.S. However, MS Map doesn't recognize a lot of the zip codes and I'm not sure why. I tried the Format Cells/Number/Special/Zip Codes formatting for all the zip codes cells, but still get this problem for many cells. Thanks in advance for any help.

May 22nd, 2002, 01:06 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Are you able to post examples of the codes that aren't recognised ? I'm guessing they're those weird ones with extra numbers 02468-4378 for example Chris

May 22nd, 2002, 01:18 PM	#3
cornbread Board Regular Join Date: Apr 2002 Location: Oregon Posts: 77	post an example of a zip code with a problem and I'll tell you what's wrong if I can. The zips 97200-9999 or whatever won't show up because the -9999 is a delivery route within that postal zip of 97200. If that is your only problem set up a macro that parses out the -9999 segment also known as the +4 and try those zip codes then without the +4. If the problem is larger than that post some true examples of the zips not running and I will run them against the USPS data base and see what's up with them. The plus four or -9999 form of zip coding you will never need unless you are creating mailing lists and want reduced postal rates or you are a GIS person validating address data for a company like a telecom or power company.

May 22nd, 2002, 03:25 PM	#4
Chartman of the Bored Board Regular Join Date: Apr 2002 Location: Palo Alto, CA Posts: 75	cornbread and Chris, Thanks for responding. I had almost given up on this thread after no replies for a couple of days... I did extensive re-formatting of the codes using LEN, LEFT, concatenation, etc. I managed to get almost all the zip codes to work, except for seven of them. For those seven, I got an error saying, "The following data is not recognized as geographical data:", so it finally dawned on me that maybe they really are just bad data. Someone probably typed in some zip codes that don't exist (or maybe didn't exist when MS Map was created). Here are the seven: 92618, 06615, 30005, 01702, 02421, 02451, 13507. Thanks