.CSV file is depth or river water level collected by automatic sensors, now it is required to make automatic switch to link this device to Model (HECRas) of GIS based map.
Through Installation of Automated Gauges for Early Warning System real time data is collected, which will involve Monitoring of Water Level.
The data is now required presented in Arc GIS format after computations from modelling softwares (HEC RAS and HEC HMS etc.).
How to produce an automatic Switch; for device data file to ArcGIS Map.
1. Device Data:
A device will be installed on river swat, which will collect data and be shown on online site (www.thinkspeak.com). A file if downloaded manually appears as (.CSV). In which data patterns are as follow if open in Ms Excel.
Created_at entry_id
field1 latitude longitude elevation status
2019-08-27 06:48:18 UTC 1 248.148
2019-08-27 06:48:38 UTC 2 249.8091
2019-08-27 07:18:20 UTC 3 250.3854
2019-08-27 07:18:37 UTC 4 249.3176
2019-08-27 07:28:48 UTC 5 249.8261
2019-08-27 07:29:05 UTC 6 249.3515
2. ArcGIS Maps
A map generated in ArcGIS, which must accumulate the device real time readings on map. That device real time readings are in .CSV file. Producing a switch for this .CSV file,