Calculate border distance between two points

[benjaviver]

Hello,

I have two points in two different country. I want to calculate what is the distance from the first point to the border and then from the border to the second point.

Calculate the distance between the two points is easy, but what about the border caclulation ?

In other words, I want the intersection between the line (between the two point) and the border. With that, I could easily make my calculation :-).

Is it possible ? Small detail : Border in Europa

Many thanks

Benjamin

[AngelosPachis]

Hi @benjaviver ,

Do you have a polygon spatial object that displays the borders of Europe?

Thanks,

Angelos

[benjaviver]

Nope,

Does it exist in Alteryx ?

Thanks,

Benjamin

[AngelosPachis · Accepted solution]

@benjaviver  Nope

But what you can do is build that border yourself with a Map Input tool.

In the example I have created, I selected two points on the map, one in Spain and one in Morocco. You should have those two points already.

Then I have used a map input tool to create a line that approximates the borders between the two countries.

Then I have used a Spatial Match tool to create an intersection between the line formed by the two points and the line formed by the borders. The outcome would be a point.

Finally, I used a distance tool to estimate the distance between each of my original points and the intersection.

Try that and let me know if that worked for you please.

Cheers,

Angelos

[benjaviver]

Many thanks Angelo,

It completely answer to the question.

Weird Alteryx hasn't this country border tool already define somewhere :-).

Cheers,

Benjamin