cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
abmayfield
Level VI

plotting data on grid

I know that you can plot geo-referenced data on a map in Graphbuilder. Now I want to do something more complex, which, truth be told, is easy to do in ArcGIS, but I want to see if it's possible in JMP: set a 1 x 1 km grid over the entire Earth and then overlay averages within each of the 1 km2 bins. It would seem that the bottleneck is the grid itself. I was shocked to not find a single shp file on Google corresponding to such a grid. Short of using a custom map generator and hand selecting all 1 x 1 km cells across the planet, can anyone think of an easier way? I tried making binning formulas based on latitude and longitude, but that did not work. Basically, I want to make something similar to what you see in the attachment. I feel like it SHOULD be possible!

Anderson B. Mayfield
1 REPLY 1
abmayfield
Level VI

Re: plotting data on grid

Update: it would appear that overlaying a heatmap on a map approaches what I seek to do. As long as you set the increment for both axes to the scale you desire, it will force the cells into that size (in this example I used 0.1 degrees rather than 1 km). What I don't know (but what I suspect is happening) is that, within each cell, I am getting the average of all data points within that area (i.e., what I desire). You can see the script in the attached data table. However, if anyone knows of a 1-km x 1 km grid shape file, that still might be useful for other analyses. 

Anderson B. Mayfield

Recommended Articles