World Statistics Day was yesterday, but we’re celebrating all week long! This celebration means acknowledging the impact statistics has on our world. Who is your favorite statistician? Share with us who they are and why they top your favorites list.
Choose Language Hide Translation Bar
XanGregg
Staff

Geocoding Place Names

Helps convert places names to longitude/latitude coordinates.

This add-in will go through a specified data table and check user-specified columns for location names or addresses. It will then check these places against internal data tables installed with the add-in or the online services of OpenStreetMaps.org. For example: say that you have a data table with American cities paired with some numerical data, and you want to view this information on a map with JMP. You can use this add-in to find latitude and longitude coordinates for each of the different cities, and then creating your map is rather easy.

Author: intern David Spruill

Updated April 4, 2016 with extra error check and reduced data base size.

Related blog post: A JMP add-in to geocode your geographic data - JMP Blog

Comments

Awesome! Saved me a bunch of time. I was about to do this in Excel, when I asked myself "I wonder if there is JSL for this at the user community?"

Hello,

I'm having a little trouble with the geocoder add-in.  Is it expecting a certain format for the input text?  I have some addresses with unit/apt numbers, would this create a problem.

Thanks for posting this add-in.

 

Hello,

Is anyone else having an issue with Georgia?  It found the country not the state.  I'm especially surprised because I set the search to custom and selected just USA and Canada.

 

JMP_WrongGeorgia.JPG 


Has anyone been able to reverse geocode in JMP by inputting latitude and longitude coordinates and outputting the country?

@PaulJones, this is a scripting solution but maybe it will get you started.  I just noticed I did City/State in the USA but you can expand this to Country using the other table (JMP Geocoder - World Geodatabase.jmp) in the same Add-In folder.

 

//Open the table in the JMP Geocoder
dt = Open("$ADDIN_HOME(com.jmp.jmpgeocoder)\JMP Geocoder - US Geodatabase Ordered.jmp");
			    
//Build table for KNN
mat = (dt:Latitude << getvalues) || (dt:Longitude << getvalues);
kdt = KDTable( mat );

//Find the the nearest row for new data and print the result
{rows, dist} = kdt << K nearest rows(1,[35.824548, -78.757867])
row = rows[1]
"Zip Code: " || char(dt:Zip Code[row]) || " in " || dt:Zip Name[row] || ", " || dt:State[row] || ", from row: " || char(row)

Has anyone on the board happened to scrape data from Census.gov by census tract and used the Mapping function?  There is a load of data to be gotten for use and I wanted to have the granularity of census tract data.  A GeoCode ID is provided but I have not been able to find a way to convert it to a JMP sensible output.

Article Tags