I have two data sets:
- points with a timestamp
- polygons representing neighbourhoods
I need to compute how many points are in each neighbourhood polygon, based on a time range. So in other words, how many points are in zone A between 9 am and 10 am and then how many are there between 10 am and 11 am.
Currently, I am separating the points into separate layers - one layer for 9 am to 10 am then I do a spatial join. Then another layer for 10 am - 11 am and another join. This is exceptionally tedious and insufficient to do this same analysis across a week for example.