Data scenarios

[ksonda]

There are probably 3-5 basic data scenarios we should think about covering

Scenario 1: All of the data and metadata is in one csv/ excel sheet.

• 1A There’s a column for location ID, latitude, longitude, and then long-formatted parameters/sample results and timestamps. (e.g. WQX type format)

Lower Mackenzie River Basin Long-term Water Quality Monitoring D.zip

• 1B Similar to above, but wide- instead of long-formatted, typical for sensors that take simultaneous measurements like weather stations.

https://catalog.newmexicowaterdata.org/dataset/b68f4c18-d544-46b1-a113-1b76a8a326c6/resource/66dcced2-f151-4f5a-bb65-dff25a9a8689/download/2016-aquifertestindex-data.xls

Scenario 2: There is a csv/excel sheet of sensor/location data, OR this data does not exist in a structured format in one table and would need to be filled into a template or using a UI. A second csv/excel sheet that has all the data for all parameters, with columns for location ID, parameters, and timestamps.

• 2A long-formatted

emnrd-mmd-coal-water-quality-sample-and-parameter-data.xlsx

• 2B Similar to above, but wide- instead of long-formatted, typical for sensors that take simultaneous continuous measurements like weather stations.

Weather example
kint.txt

Well example (sheet 1 for metadata, sheet 2 for depth and temperature)
Copy of 2017 SPCE--WELL LOCATION DTW DATA.xlsx

Scenario 3: There is a csv/excel sheet of sensor/location data, OR this data does not exist in a structured format in one table and would need to be filled into a template or using a UI. There are separate csv files or excel sheets for each location that have a column for timestamps and columns for sample results.

(The Wells data you're already working with)