Spatial Data Analysis with JMP

Last week I had the pleasure to participate in the first European JMP Discovery Summit. As part of this I was able to give a talk on our JMP-Add-In extending JMPs capabilities in spatial data analysis. Now let me show you how to use the Add-In to geocode some addresses in JMP!

As the conference was located at Brussels and the talk was all about mapping the right example was not far away: Let's do some sightseeing, of course!

If you don't know what the Brussels Comic Route is all about you'll get some impressions here. Basically you'll find some walls of buildings in the city center of brussels covered with large-scaled comics.

First of all check wikipedia to see the list of all addresses. We can easily import those addresses by using the Internet Open ... -command in JMP. Go to File -> Internet Open in JMP and paste the Wikipedia-URL into the dialog.

Addresses for the Brussels Comic Tour on Wikipedia

Select only the first table in the next step. Now you should see the list of all comic-walls in Brussel's city center. It should look like this:

The next step for geocoding is to slightly chance the address column. Sadly the add-in is not a wizard thus it will not know in which city those streets are. I used a formula to add the word Brussels to each address.

Now select Add-Ins -> Spatial Data Analysis -> Geocode from the main menu.

The newly created address-column will be used on the right hand side of the dialog. Loading the coordinates from the internet (using R and the Google Maps API) might take a moment. But soon you should see two new columns in the data set: latitude and longitude for each address.

Now it's easy to present all comic-walls in a map. Just use the graph builder with a background roadmap!

If you think this map is a bit messy ... next time I'll show you how to do this in JMP:

If you liked this, don't hesitate to download the Add-In here (be aware that you will need R together with the two packages TSP and ggmap).

All feedback is welcome at sebastian.hoffmeister@statcon.de or @statcon on Twitter!


Autor: