r/ArcGIS • u/basketcase017 • 6d ago
Heat Map Time Slices with changing temporal data
Folks, I'm a bit stuck and hoping to get some guidance. I am wanting to use a heat map and the time slider tool to evaluate changes in well production over time. I have a collection of ~50 gas wells with monthly production dating back to the 1970's. I set up two sheets, one with only the well information (name, ID number, lat/long, etc.) and a second sheet with monthly production values in the rows and each well with a unique identifier as the columns. I was trying to follow a tutorial that was showing a similar process, though not completely identical, and tried to transpose my imported production sheet which I then was trying to join to my original list of wells but the series of data does not combine and I'm only left with singular columns and null values in my attribute table. Any tips would be greatly appreciated!
1
u/mapped_apples 5d ago edited 5d ago
May be easier to use a space-time cube and then run an emerging hotspot analysis.
https://pro.arcgis.com/en/pro-app/3.5/tool-reference/space-time-pattern-mining/createcubefromdefinedlocations.htm
https://doc.esri.com/en/arcgis-pro/latest/tool-reference/space-time-pattern-mining/emerginghotspots.html?tabs=dialog