SubscribeBookmarkRSS Feed

Community Trekker


Mar 27, 2015

Add-In: Spatial Data Analysis

This Add-In provides methods to:

  • Geocode Addresses (requires R)
  • Ease the Import of Foreign Shape Files
  • Create Distance Matrices (requires R)
  • Solve Traveling Saleperson Problems (requires R)
  • Calculate Measures for Spatial Autocorrelation (Moran's I and Geary's Ratio)

Last Changes:


This Add-In makes use of JMP's R-Interface and requires the R-Packages TSP and ggmap. It is tested on JMP 11 and Windows 7.

There is a blogpost about the geocoding part on the STATCON-Blog. This Add-In was first published as part of a talk at the European JMP Discovery Summit 2015 in Brussels. You can find the slides of the talk here.

For a more detailed documentation find the attached PDF.


This is great. I've just started research that includes a geo component so this is very timely. Would you happen to know how to replicate this using SAS and JMP instead of R and JMP? Thanks, Randy


Hi Randy,

Great that you like it. Sadly I have no experience with spatial data analysis using SAS. I guess you might do the same using PROC GEOCODE and PROC OPTNET but I have no idea how it would work in detail, as I haven't jet had the chance to work with those PROCs.




Thanks Sebastian for the reply. Maybe its time for me to dive into R. Cheers, Randy


Any thoughts why the add-in will not work for JMP 12 on Mac, or how to add?

Thanks! Todd


Hi Todd,

sorry for my late response. Was quite busy the last week. Sadly I haven't had a chance to try the addin on mac as I have no Mac-version of JMP. Maybe we can figure it out if you give me some more information on what is not working.

Does installation fail? Or are the specific features that do not work?

Kind Regards,



Hi Sebastian,

Thanks you kindly for the response. When I try to load the add-in I receive the following message

     "Installation of JMP Add-In "Spatial Data Analysis" failed."

Any ideas on how to resolve the conflict?

Thanks again!



Hi Todd,

I just uploaded a version that should be installable on a mac. Would love to get your feedback which functions work on mac and which don't. (I'm pretty sure that the shape-file import will not work, but I guess that is not the most relevant part of the addin).

Kind regards,



Hi Sebastian,

Sorry for the delay in getting back to you. Yes, the add-in will now load to JMP 12 but there seems to be a problem in the script. The script is all jumbled up in the session log window after initiation. I will spend a bit more time with it as soon as I get few minutes. and see if I can determine what is happening

Thanks for the new version. I will try to get back to you soon,



I was trying to run the Brussels Comic Tour example, and the GeoCode part hung. I'm running JMP v13 on Mac.


The following looks like it pops up a couple of times in the script:

No data table in access or evaluation of 'Column Dialog' , Column Dialog/*###*/(addressCol = Col List( "Address",

MaxCol( 1 ),

MinCol( 1 ),

Data Type( character )



Also, further on down in the code, I notice you set the Downloads to a windows file name default (Y:/Downloads). On Macs, the default is /<userid>/Downloads.


Anyway the filename pick box could be expanded? Also, I click the browse and nothing happens (no directory / file name?)


I noticed the following:

Invalid Open Name in access or evaluation of 'Open' , Open/*###*/(shp.file, invisible)

dbf.file = Substitute( shp.file, ".shp", ".dbf" );

shp = Open/*###*/(shp.file, invisible);


Subscript Range in access or evaluation of 'Subscript' , addressCol[/*###*/[1]]

Eval List( dlg );

adresses = addressCol[/*###*/[1]] << Get As Matrix;


Send Expects Scriptable Object in access or evaluation of 'List' , {/*###*/:Address}


Thanks for any help.


Really nice Visualization Sebastian, simple and clear.  Thanks for your efforts on this Add-In.