I can think of two examples of how this could be done with Arcade.
I would read through KGerrow's blog post on how to intersect data from different layers.
A second relevant read that will help you is by xander bakker, who did something quite similar to what you want to do.
After you read through that, you will have an idea how to do it and you can use the API documentation to help you put together your code.
