Non overlap Trade area

Hi,

I am have some locations (latitude and longtitude and drivetime). I am trying to find the non-overlap trade areas for each location. I have tried to use a workflow that I saw in the community discussion but I am not sure it worked. Can you please look at my file?

myworkflow.yxmd

Locations.xlsx

Spatial Analysis

Accepted answers

danilang

You're very welcome @Mariam2. It was an interesting debugging experience especially since I didn't have access to the drive time data set.

If you don't mind, would you consider marking this post as solved. I like adding to my total, but it also helps the search engine deliver more helpful results.

Dan

All comments

danilang

Hi @Mariam2

You were very close with your initial workflow. The changes necessary

1. Change the criteria in your filter to [RecordID]!=[Universe_RecordID] to remove all self matches but this leaves the matched pairs, i.e. row with original id 7 and universe id 9 and row with the inverse 9,7.

2. Change the spatial process to Cut 2nd from 1st. This takes out the overlap from id 7 on row 7, 9 and the overlap from 9 on row 9, 7

3. Remove the summary tool since its no longer required.

After the join and union you end up with the 9 original records. The non-overlap parts of 7 and 9 look like this

7 and 9.png

Note that I didn't have access to a drive time dataset, so I had to use distance in the trade area tool which accounts for the nice round trade areas in my image

Dan

myworkflow v2.yxmd

Mariam2

Hi Danilang,

Sorry to respond now. Thank you for taking the time to help me. I was out of the office when you sent me your workflow. I do have a question. You did the workflow assuming that the trade areas were determined by radius. However, in my case,they are determined by drivetime. There is one column called Trade area Drivetime. Somehow when I changed it to drivetime, I end up with 31 trade areas instead of 9. See attached.

Results.PNG

Trade area setting.PNG

danilang

Hi @Mariam2

Like I mentioned in my post, I don't have access to a drive time dataset and that's why I used distance instead. From what I've seen before though, drive time trade areas can extend quite a ways along major arteries, looking like flattened jellyfish instead of neat circles. It's probably these long thin tendrils that are overlapping. 2 trade areas that don't overlap when viewed by distance can overlap by drive time if they're connected by a road. Another possibility is that you can have 2 trade areas on a rectangular grid of roads. The tendrils can extend along the roads and produce multiple overlaps. Zoom in on the results in the map and look to see if this is the case.

Another thing: Can you add an Output tool after the trade area tool and write the results to an alteryx .yxdb database file. Export your workflow from the Options->Export Workflow menu and post the results. That way I'll be able to look at the trade areas once they are created.

Dan

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703