nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Spatial Data Analysis

Valerie_Nedbal

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

Copy of Address Data set.xlsx

Accepted answers

malcolm_moore1

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

ian_jmp

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

stan_koprowski

Hi,
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

All comments

ian_jmp

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

Cheers,

Ian

Valerie_Nedbal

That looks promissing, but do you know how the data (addresses,postal code and city, country) needs to be formatted?

malcolm_moore1

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

Valerie_Nedbal

I got it to work, thank you, but now, how can we calculate the distances between 2 cities?

stan_koprowski

Valerie_Nedbal

Cool thanks for your help :smiling_face_with_smiling_eyes: