I'm new to ARCGIS with little formal training (more figuring it out as I go.) I had a question on the best way to approach my dataset.
Overall, my goal is to show general areas that fishing ships operate and the amount of time that they spend in each area.
My data is CSVs with LAT, LONG, and TIME (in YYYY-MM-DDTHH:MM:SSZ format). My notional work flow is:
1.) Add CSV as a data table
2.) Plot X,Y points
3.) Generate Tessellations (hexagons with an area of 10 KM)
4.) Summarize Within Toolset
Each CSV represents one week of data and is rather large ( up to 30,000 points for example). Is there a way to combine the Summarize Within outputs from each week into one overall dataset that doesn't lose the counts? (I.E. A hexagon from output 1 has a point count of 50 and the same hexagon from output 2 has a count of 25 - so they combined output should show 75.) If I merge the X,Y points from all of my CSVs prior to running the Summarize Within toolset, it would bog down my computer for hours (or not work).
Additionally, since each X,Y coordinate has a discrete temporal data point (to the second) - when I use the Summarize within toolset, would it be best to use the mean of time? Would that show me the average "seconds" the fishing vessel was within that hexagon? Is there any easier way or better toolset to accomplish what I'm looking for?
Thank you all so much for your help!
Geoprocessing Tools
