Subscribe Bookmark RSS Feed

heatmap of the US

biancapiccirill

Occasional Contributor

Joined:

May 10, 2016

I'm looking to create a map of the US in JMP that shows dollars by zip code. Is there a way I can do this in JMP?

4 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

The short answer is Yes.

12959_pastedImage_0.png

The Zipcode map is not distributed with the basic JMP or JMPPro product.  However, the maps are downloadable from the File Exchange

and then open the 2 data tables and save them to

On Windows: C:\Users\<user name>\AppData\Roaming\SAS\JMP\Maps

On Mac: /Users/<user name>/Library/Application Support/JMP/Maps


Then open your file that has you Dollar data in it, along with the Zipcode it is associated with. 

Go to Graph Builder, Drag the Zipcode column to the Shape area of the display, and the Dollar column to the center of the display, and you will get a map like the one displayed above.

Jim
biancapiccirill

Occasional Contributor

Joined:

May 10, 2016

Awesome. Thank you so much!

biancapiccirill

Occasional Contributor

Joined:

May 10, 2016

Sorry, another quick question.. do the zip codes in my file have to be in a specific format? I am currently using the character format so a zip code of "00012" doesn't change to "12".

When I drag the zip codes into the Shape area it does not give me a shape of the US. Am I doing something wrong?

txnelson

Super User

Joined:

Jun 22, 2012

The zip code needs to be character, for just the reason's you suggested.

Concerning your issue:

What version of JMP and what operating system are you running on?

Did you copy the 2 files to the directory specified?  You may have to create some directories that are not currently available.

Both the -XY and the -Name data tables need to be copied to the correct folder

Since the zip code files are large, it may take a while for the map to show up.

Attached is a data table that I knows works with the zip code shape files, so if you try it, and it works, then the issue is with your data table.  If you try it and it doesn't work, then your issue is with the install of the shape files from the Xan Gregg files I pointed you to.

Jim