topic Re: heatmap of the US in Discussions

heatmap of the US

biancapiccirill — Mon, 10 Oct 2016 23:31:57 GMT

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?

Re: heatmap of the US

txnelson — Wed, 19 Oct 2016 04:19:05 GMT

The short answer is Yes.

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

US-ZIP5-2010.zip

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.

Re: heatmap of the US

biancapiccirill — Tue, 11 Oct 2016 13:31:20 GMT

Awesome. Thank you so much!

Re: heatmap of the US

biancapiccirill — Tue, 11 Oct 2016 17:21:55 GMT

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?

Re: heatmap of the US

txnelson — Tue, 11 Oct 2016 18:38:59 GMT

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.

Re: heatmap of the US

SamReich — Mon, 23 Mar 2020 13:11:18 GMT

Thank you txnelson. It worked like a charm on my JMP version 14. However, I have three questions to proceed:

1) as you might be able to see in the enclosed image, I need to add an underlying map with geographical data. How do I do that?

2) the color depth and the information obtained in the popup window when I place the cursor on one of the divisions, is just the numbers of the JMP table rows represented in each zip code area. I need a summary statistics (mean, median) of the actual variable displayed across the rows.

3) is there a more recent zip code file available?. The one you mention seems to be OK, but it is 10 years old and I would need to disclose that fact to users.

Thanks again,

@SamReich

Re: heatmap of the US

txnelson — Mon, 23 Mar 2020 14:04:47 GMT

To handle what you want to do, my first suggestion is to upgrade to JMP 15. It has major upgrades to the handling of popup information using graphlets.

Short of that, you can create new columns in your data table that contain the information you want to be displayed when you click on a specific zip code. This is done by specifying the Label state for the columns you want displayed.

Concerning the update of the zip code map, take a look at the documentation on creating maps in the Essential Graphics documentation. You can bring in all of the latest maps from various sources and make them available to your JMP instance.