47350_en-US

liliconcom

Spatial Data Analysis

Hi,

 

i have a question. I have got from a customer who would like to calculate the distances between different locations (adresses, cities, postal codes). The data that he send to me is attached. it contains addresses in Germany and postal codes. i don't who to get the coordinates from those different locations. Any clue?

 

Thanks in advance,

Cheers,

Valerie

Re: Spatial Data AnalysisCool thanks for your help :smiling_face_with_smiling_eyes:
Re: Spatial Data AnalysisHi,
And some other options—
https://community.jmp.com/t5/Discussions/Distance-Calculation-using-Latitude-and-Longitude/td-p/19258

Or using an add-in with R—
https://community.jmp.com/kvoqx44227/attachments/kvoqx44227/add-ins/75/2/Documentation.pdf

Cheers,
Stan
Re: Spatial Data Analysis

Haven't used this either, but it might help.

Else (using the Google Distance Matrix API) someone could take advantage of the REST capabilities in JMP 14).

Ian

Re: Spatial Data AnalysisI got it to work, thank you, but now, how can we calculate the distances between 2 cities?
Re: Spatial Data Analysis

Hi Valerie,

 

According to the help file for the addin, you will need the following four entries outside the US:

 

Street Address, City, Province, Country

 

The file provided lacks City and Province. If your user can provide these the addin should work fine.

 

Malcolm

 

 

Re: Spatial Data AnalysisThat looks promissing, but do you know how the data (addresses,postal code and city, country) needs to be formatted?
Re: Spatial Data Analysis

I've not used it, but Xan's add-in might help, Valerie.

Cheers,

Ian