cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

plotting data on grid

abmayfield
Level VI

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