I am building a simple tool with ModelBuilder to calculate a density score for projects within a delineated watershed. I am working with two tables: a table of the project points and a table of the delineated watershed. In the watershed table, I have added and calculated a new field for the watershed area in square miles, and also a new field "Project Density Score". In the project points table, I already have selected the points within the watershed polygon with Select-by-Location.
The Project Density Score is Sq Mile Area of Watershed / # of projects within the watershed polygon. I am wondering the best way to calculate this score in the watershed shed table field using the count of selected features from the Project Points table. There is no real way to join the two tables that I can see that would work. Should I use FeatureSetbyName in an Arcade Expression or use Cursors in Python? I'm having trouble figuring out the syntax specifically for making the calculation using the selected features of one table and the area value in a separate table.
Thank you!
