binary variable surrounding region within buffer

[Neico]

Dear community,

I have a data set with the location of airports. I calculated circular buffers around each airport from 1 to 30 km (in 1km increments). Now I would like to create a binary variable that tells me whether a surrounding region falls within each buffer (0 does not fall within buffer, 1 falls within buffer). The output should look like this:

Region	Buffer 1 km	Buffer 2 km	...	Buffer 30 km
ABC	0	1	...	1
DEF	0	0	...	0
GHI	0	0	...	1
...

I attached a screenshot of the initial workflow I started working with.

Thank you for your help!

[Jonathan-Sherman · Accepted solution]

Hi @Neico,

I think this may be what you're trying to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[OllieClarke]

Here's a way of doing it @Neico 

[danilang]

Hi @Neico 

Here's one way to go about it

In order to get a complete matrix, you need to cross join using the Append Fields tool.  This gives you every possible combination of trade area and target.  After this set a default value of 0 for the intersect value.  Join this the output of your spatial match tool.  For the items that join, set the InRadius flag to 1.  Union the J and L and cross tab the results giving you

 

Dan