I have ~4000 insurance claims for a city. I have made a fishnet and would like to count the number of claims within each polygon. It is easy to count the total number of claims, but I would like to find out how many claims there are within each cell for every claim date.
This is how the data set looks like:
FID Shape Name Date 83 Point ZM A2528 20030718 84 Point ZM A2529 20100814 85 Point ZM A2530 20140831 86 Point ZM A2531 20140831 87 Point ZM A2532 20140831 88 Point ZM A2533 20110607 89 Point ZM A2534 20120116 90 Point ZM A2535 20100915 91 Point ZM A2536 20100813 92 Point ZM A2537 20140831
As you can see, the flood claims are from different dates (~50). Does anyone of you have an idea how to solve this problem? I have read some similar Q&A's (Compute total area of several polygons within a polygon; Total of attribute field of point layer per polygon layer; How to write FIDs of points within each polygon to polygon field?), but could not find any answer that works in this case. The resulting table will consist of ~4000 rows (one for each cell) and ~50 columns (one for each claim date). The value in each field will tell how many flood claims there are in each cell for a certain date.
I work in ArcMap 10.1.