Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEALong winded way of parsing, REGEX was a tough one.
Nice Challenge, I did not know that I could aggregate and calculate the centroid with spatial data. Here's my solution:
Not sure the summarise spatial method in the solution gives the right way, although the result it the same.
I used the traditional way to calculate all the distance in the same region to each city. It may slow down the workflow if we have too many cities as I used the append tool.