cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-452356%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E3%82%B0%E3%83%AA%E3%83%83%E3%83%89%E3%81%AB%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E3%83%97%E3%83%AD%E3%83%83%E3%83%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-452356%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EGraphbuilder%E3%81%AE%E3%83%9E%E3%83%83%E3%83%97%E3%81%AB%E5%9C%B0%E7%90%86%E5%8F%82%E7%85%A7%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E3%83%97%E3%83%AD%E3%83%83%E3%83%88%E3%81%A7%E3%81%8D%E3%82%8B%E3%81%93%E3%81%A8%E3%82%92%E7%9F%A5%E3%81%A3%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%20%E4%BB%8A%E3%80%81%E7%A7%81%E3%81%AF%E3%82%82%E3%81%A3%E3%81%A8%E8%A4%87%E9%9B%91%E3%81%AA%E3%81%93%E3%81%A8%E3%82%92%E3%81%97%E3%81%9F%E3%81%84%E3%81%A8%E6%80%9D%E3%81%A3%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%E3%81%93%E3%82%8C%E3%81%AF%E3%80%81ArcGIS%E3%81%A7%E7%B0%A1%E5%8D%98%E3%81%AB%E5%AE%9F%E8%A1%8C%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%99%E3%81%8C%E3%80%81JMP%E3%81%A7%E5%8F%AF%E8%83%BD%E3%81%8B%E3%81%A9%E3%81%86%E3%81%8B%E3%82%92%E7%A2%BA%E8%AA%8D%E3%81%97%E3%81%9F%E3%81%84%E3%81%A8%E6%80%9D%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%E5%9C%B0%E7%90%83%E5%85%A8%E4%BD%93%E3%81%AB1%20x%201%20km%E3%81%AE%E3%82%B0%E3%83%AA%E3%83%83%E3%83%89%E3%82%92%E8%A8%AD%E5%AE%9A%E3%81%97%E3%80%81%E3%81%9D%E3%82%8C%E3%81%9E%E3%82%8C%E3%81%AE%E5%B9%B3%E5%9D%87%E3%82%92%E3%82%AA%E3%83%BC%E3%83%90%E3%83%BC%E3%83%AC%E3%82%A4%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%201km2%E3%81%AE%E3%83%93%E3%83%B3%E3%81%AE%E3%80%82%20%E3%83%9C%E3%83%88%E3%83%AB%E3%83%8D%E3%83%83%E3%82%AF%E3%81%AF%E3%82%B0%E3%83%AA%E3%83%83%E3%83%89%E8%87%AA%E4%BD%93%E3%81%A7%E3%81%82%E3%82%8B%E3%82%88%E3%81%86%E3%81%AB%E6%80%9D%E3%82%8F%E3%82%8C%E3%81%BE%E3%81%99%E3%80%82%20%E3%81%9D%E3%81%AE%E3%82%88%E3%81%86%E3%81%AA%E3%82%B0%E3%83%AA%E3%83%83%E3%83%89%E3%81%AB%E5%AF%BE%E5%BF%9C%E3%81%99%E3%82%8B%E5%8D%98%E4%B8%80%E3%81%AEshp%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%8CGoogle%E3%81%A7%E8%A6%8B%E3%81%A4%E3%81%8B%E3%82%89%E3%81%AA%E3%81%8B%E3%81%A3%E3%81%9F%E3%81%93%E3%81%A8%E3%81%AB%E3%82%B7%E3%83%A7%E3%83%83%E3%82%AF%E3%82%92%E5%8F%97%E3%81%91%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%20%E3%82%AB%E3%82%B9%E3%82%BF%E3%83%A0%E3%83%9E%E3%83%83%E3%83%97%E3%82%B8%E3%82%A7%E3%83%8D%E3%83%AC%E3%83%BC%E3%82%BF%E3%83%BC%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E3%80%81%E5%9C%B0%E7%90%83%E5%85%A8%E4%BD%93%E3%81%AE1%20x%201%20km%E3%81%AE%E3%82%BB%E3%83%AB%E3%82%92%E3%81%99%E3%81%B9%E3%81%A6%E6%89%8B%E4%BD%9C%E6%A5%AD%E3%81%A7%E9%81%B8%E6%8A%9E%E3%81%99%E3%82%8B%E4%BB%A5%E5%A4%96%E3%81%AB%E3%80%81%E3%82%82%E3%81%A3%E3%81%A8%E7%B0%A1%E5%8D%98%E3%81%AA%E6%96%B9%E6%B3%95%E3%82%92%E8%80%83%E3%81%88%E3%82%89%E3%82%8C%E3%82%8B%E4%BA%BA%E3%81%AF%E3%81%84%E3%81%BE%E3%81%99%E3%81%8B%EF%BC%9F%20%E7%B7%AF%E5%BA%A6%E3%81%A8%E7%B5%8C%E5%BA%A6%E3%81%AB%E5%9F%BA%E3%81%A5%E3%81%84%E3%81%A6%E3%83%93%E3%83%8B%E3%83%B3%E3%82%B0%E5%BC%8F%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%82%88%E3%81%86%E3%81%A8%E3%81%97%E3%81%BE%E3%81%97%E3%81%9F%E3%81%8C%E3%80%81%E3%81%86%E3%81%BE%E3%81%8F%E3%81%84%E3%81%8D%E3%81%BE%E3%81%9B%E3%82%93%E3%81%A7%E3%81%97%E3%81%9F%E3%80%82%20%E5%9F%BA%E6%9C%AC%E7%9A%84%E3%81%AB%E3%81%AF%E3%80%81%E6%B7%BB%E4%BB%98%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%AB%E3%81%82%E3%82%8B%E3%82%88%E3%81%86%E3%81%AA%E3%82%82%E3%81%AE%E3%82%92%E4%BD%9C%E3%82%8A%E3%81%9F%E3%81%84%E3%81%A8%E6%80%9D%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%20%E7%A7%81%E3%81%AF%E3%81%9D%E3%82%8C%E3%81%8C%E5%8F%AF%E8%83%BD%E3%81%A7%E3%81%82%E3%82%8B%E3%81%B9%E3%81%8D%E3%81%A0%E3%81%A8%E6%84%9F%E3%81%98%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%EF%BC%81%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-452356%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E3%82%B0%E3%83%A9%E3%83%95%E3%82%A3%E3%83%83%E3%82%AF%E3%82%B9%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E3%83%9E%E3%83%83%E3%82%AFOS%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-452381%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%EF%BC%9A%E3%82%B0%E3%83%AA%E3%83%83%E3%83%89%E3%81%AB%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E3%83%97%E3%83%AD%E3%83%83%E3%83%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-452381%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%9B%B4%E6%96%B0%EF%BC%9A%E3%83%92%E3%83%BC%E3%83%88%E3%83%9E%E3%83%83%E3%83%97%E3%82%92%E3%83%9E%E3%83%83%E3%83%97%E3%81%AB%E3%82%AA%E3%83%BC%E3%83%90%E3%83%BC%E3%83%AC%E3%82%A4%E3%81%99%E3%82%8B%E3%81%93%E3%81%A8%E3%81%AF%E3%80%81%E7%A7%81%E3%81%8C%E3%82%84%E3%82%8D%E3%81%86%E3%81%A8%E3%81%97%E3%81%A6%E3%81%84%E3%82%8B%E3%81%93%E3%81%A8%E3%81%AB%E8%BF%91%E3%81%A5%E3%81%84%E3%81%A6%E3%81%84%E3%82%8B%E3%82%88%E3%81%86%E3%81%AB%E8%A6%8B%E3%81%88%E3%81%BE%E3%81%99%E3%80%82%20%E4%B8%A1%E6%96%B9%E3%81%AE%E8%BB%B8%E3%81%AE%E5%A2%97%E5%88%86%E3%82%92%E5%B8%8C%E6%9C%9B%E3%81%AE%E3%82%B9%E3%82%B1%E3%83%BC%E3%83%AB%E3%81%AB%E8%A8%AD%E5%AE%9A%E3%81%97%E3%81%A6%E3%81%84%E3%82%8B%E9%99%90%E3%82%8A%E3%80%81%E3%82%BB%E3%83%AB%E3%81%AF%E3%81%9D%E3%81%AE%E3%82%B5%E3%82%A4%E3%82%BA%E3%81%AB%E5%BC%B7%E5%88%B6%E3%81%95%E3%82%8C%E3%81%BE%E3%81%99%EF%BC%88%E3%81%93%E3%81%AE%E4%BE%8B%E3%81%A7%E3%81%AF%E3%80%811%20km%E3%81%A7%E3%81%AF%E3%81%AA%E3%81%8F0.1%E5%BA%A6%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%BE%E3%81%97%E3%81%9F%EF%BC%89%E3%80%82%20%E7%A7%81%E3%81%8C%E7%9F%A5%E3%82%89%E3%81%AA%E3%81%84%E3%81%93%E3%81%A8%EF%BC%88%E3%81%97%E3%81%8B%E3%81%97%E3%80%81%E7%A7%81%E3%81%8C%E4%BD%95%E3%81%8C%E8%B5%B7%E3%81%93%E3%81%A3%E3%81%A6%E3%81%84%E3%82%8B%E3%81%AE%E3%81%8B%EF%BC%89%E3%81%AF%E3%80%81%E5%90%84%E3%82%BB%E3%83%AB%E5%86%85%E3%81%A7%E3%80%81%E3%81%9D%E3%81%AE%E9%A0%98%E5%9F%9F%E5%86%85%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%83%9D%E3%82%A4%E3%83%B3%E3%83%88%E3%81%AE%E5%B9%B3%E5%9D%87%EF%BC%88%E3%81%A4%E3%81%BE%E3%82%8A%E3%80%81%E7%A7%81%E3%81%8C%E6%9C%9B%E3%82%80%E3%82%82%E3%81%AE%EF%BC%89%E3%82%92%E5%8F%96%E5%BE%97%E3%81%97%E3%81%A6%E3%81%84%E3%82%8B%E3%81%A8%E3%81%84%E3%81%86%E3%81%93%E3%81%A8%E3%81%A7%E3%81%99%E3%80%82%20%E6%B7%BB%E4%BB%98%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%A7%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%82%92%E7%A2%BA%E8%AA%8D%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%99%E3%80%82%20%E3%81%9F%E3%81%A0%E3%81%97%E3%80%811%20km%20x%201%20km%E3%81%AE%E3%82%B0%E3%83%AA%E3%83%83%E3%83%89%E3%82%B7%E3%82%A7%E3%83%BC%E3%83%97%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E7%9F%A5%E3%81%A3%E3%81%A6%E3%81%84%E3%82%8B%E4%BA%BA%E3%81%8C%E3%81%84%E3%82%8C%E3%81%B0%E3%80%81%E3%81%9D%E3%82%8C%E3%81%A7%E3%82%82%E4%BB%96%E3%81%AE%E5%88%86%E6%9E%90%E3%81%AB%E5%BD%B9%E7%AB%8B%E3%81%A4%E5%8F%AF%E8%83%BD%E6%80%A7%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E
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