I have started working an organisation that uses ArcGIS to manage its GIS data generally. They use a wide range of other software and methods to also manage collection of routine data, such as:
- Water Meter readings - the meter locations are stored in GIS, but the usage data is stored elsewhere
- Water quality sampling - there are a range of locations where the samples are collected weekly/monthly/quarterly for laboratory analysis and stored in an excel spreadsheet.
The current system is fragmented and I thought that ArcGIS could possibly manage this better by consolidating the data. I am a novice in ArcGIS, but thought that possibly each "round" could be stored as a new feature, with geographic location linking results and the attribute table recording the specific round data (eg date, time, analysis results, etc). In addition, I thought GIS system may enable capturing the spatial variation of results - for example areas of high water usage.
Is this a common use of ArcGIS? I understand that ArcGIS can create "dashboards" and would this be a suitable delivery method?