WSWCWaterDataExchange / MappingStatesDataToWaDE2.0

Manage all code to map and import state's data into WaDE 2.0
BSD 3-Clause "New" or "Revised" License
4 stars 1 forks source link

General to all states: let's include unit (csf) and aggregation.statistic (average) #325

Open amabdallah opened 4 months ago

amabdallah commented 4 months ago

I think we need to expand the VariableSpecificCV definition to also include unit (e.g., csf) and aggregation.statistic (e.g., average). While those are metadata that can be queried, VariableSpecificCV is meant to be an encapsulation of the unique time series data at a site to ensure that users are seeing all the critical metadata that define the time series at that site. I hope the VariableSpecificCV is long enough to handle all this. Let's discuss if needed.

image

I was looking at New Mexico site-specific time series data and couldn't quickly tell if it was in CSF or AF and if it was average daily or cumulative daily values. Here is a list of all VariableSpecificCV for this time series data

Discharge Flow_Monthly_Stage_Surface Water

Reservoir Level_Monthly_Storage_Surface Water Water Use_Monthly_Agriculture Irrigation_Surface Water Water Use_Monthly_Agriculture Irrigation_Unspecified Water Use_Monthly_Aquaculture_Surface Water Water Use_Monthly_Aquaculture_Unspecified Water Use_Monthly_Commercial/Industrial_Surface Water Water Use_Monthly_Commercial/Industrial_Unspecified Water Use_Monthly_Domestic_Surface Water Water Use_Monthly_Domestic_Unspecified Water Use_Monthly_Fire_Surface Water Water Use_Monthly_Fire_Unspecified Water Use_Monthly_Hydroelectric_Surface Water Water Use_Monthly_Hydroelectric_Unspecified Water Use_Monthly_In-Stream Flow_Surface Water Water Use_Monthly_In-Stream Flow_Unspecified Water Use_Monthly_Livestock_Surface Water Water Use_Monthly_Livestock_Unspecified Water Use_Monthly_Mining_Surface Water Water Use_Monthly_Mining_Unspecified Water Use_Monthly_Municipal Irrigation_Surface Water Water Use_Monthly_Other_Surface Water Water Use_Monthly_Other_Unspecified Water Use_Monthly_Public Supply_Surface Water Water Use_Monthly_Public Supply_Unspecified Water Use_Monthly_Recreation_Surface Water Water Use_Monthly_Recreation_Unspecified Water Use_Monthly_Snow_Surface Water Water Use_Monthly_Snow_Unspecified Water Use_Monthly_Thermoelectric Cooling_Surface Water Water Use_Monthly_Thermoelectric Cooling_Unspecified Water Use_Monthly_Unspecified_Surface Water Water Use_Monthly_Unspecified_Unspecified Discharge Flow_Annual_DivTotal_Groundwater Discharge Flow_Annual_DivTotal_Surface Water Discharge Flow_Monthly_Agriculture Irrigation_Groundwater Discharge Flow_Monthly_Agriculture Irrigation_Surface Water Discharge Flow_Monthly_Aquaculture_Groundwater Discharge Flow_Monthly_Aquaculture_Surface Water Discharge Flow_Monthly_Commercial/Industrial_Groundwater Discharge Flow_Monthly_Commercial/Industrial_Surface Water Discharge Flow_Monthly_Domestic_Groundwater Discharge Flow_Monthly_Domestic_Surface Water Discharge Flow_Monthly_Fire_Groundwater Discharge Flow_Monthly_Fire_Surface Water Discharge Flow_Monthly_Hydroelectric_Groundwater Discharge Flow_Monthly_Hydroelectric_Surface Water Discharge Flow_Monthly_In-Stream Flow_Groundwater Discharge Flow_Monthly_In-Stream Flow_Surface Water Discharge Flow_Monthly_Livestock_Groundwater Discharge Flow_Monthly_Livestock_Surface Water Discharge Flow_Monthly_Public Supply_Groundwater Discharge Flow_Monthly_Public Supply_Surface Water Discharge Flow_Monthly_Recreation_Surface Water Discharge Flow_Monthly_Reservoir Storage_Surface Water Discharge Flow_Monthly_Unspecified_Groundwater Discharge Flow_Monthly_Unspecified_Surface Water Discharge Flow_Daily_Stage_Surface Water Discharge Flow_Daily_Discharge_Surface Water Reservoir Level_Daily_Stage_Surface Water Withdrawal_Annual_Agriculture Irrigation_Groundwater Withdrawal_Annual_Agriculture Irrigation_Surface Water Withdrawal_Annual_Commercial/Industrial_Groundwater Withdrawal_Annual_Commercial/Industrial_Surface Water Withdrawal_Annual_Domestic_Groundwater Withdrawal_Annual_Domestic_Surface Water Withdrawal_Annual_Hydroelectric_Surface Water Withdrawal_Annual_In-Stream Flow_Groundwater Withdrawal_Annual_In-Stream Flow_Surface Water Withdrawal_Annual_Livestock_Surface Water Withdrawal_Annual_Other_Surface Water Withdrawal_Annual_Public Supply_Groundwater Withdrawal_Annual_Public Supply_Surface Water Withdrawal_Annual_Recreation_Groundwater Withdrawal_Annual_Recreation_Surface Water Discharge Flow_Daily_Unspecified_Surface Water Discharge_Daily_Stream Gage_Surface Water Discharge Flow_Daily_Discharge_Surface Water Discharge MDF JTW 062922_Daily_Stream Gage_Surface Water Discharge MDF_Daily_Stream Gage_Surface Water Discharge Mean Daily_Daily_Stream Gage_Surface Water Discharge Flow_Daily_Unspecified_Surface Water Reservoir Level_Daily_Storage_Surface Water Reservoir Storage_Daily_Storage_Surface Water Water Use_Monthly_Agriculture Irrigation_Surface Water Water Use_Monthly_Aquaculture_Surface Water Water Use_Monthly_Aquifer Recharge_Surface Water Water Use_Monthly_Commercial/Industrial_Surface Water Water Use_Monthly_Domestic_Surface Water Water Use_Monthly_Hydroelectric_Surface Water Water Use_Monthly_In-Stream Flow_Surface Water Water Use_Monthly_Livestock_Surface Water Water Use_Monthly_Mining_Surface Water Water Use_Monthly_Municipal Irrigation_Surface Water Water Use_Monthly_Other_Surface Water Water Use_Monthly_Public Supply_Surface Water Water Use_Monthly_Recreation_Surface Water Water Use_Monthly_Reservoir Storage_Surface Water Water Use_Monthly_Treated Wastewater/Reuse_Surface Water Discharge AF_Daily_Discharge_Surface Water Discharge_Daily_Discharge_Surface Water Diversion_Daily_Diversion_Surface Water Evaporation_Daily_Evaporation_Surface Water Stage_Daily_Stage_Surface Water Storage_Daily_Storage_Surface Water Discharge_Daily_Discharge_Surface Water Field Visit Discharge_Daily_Discharge_Surface Water Historical Discharge_Daily_Discharge_Surface Water Historical Storage_Daily_Storage_Surface Water Storage_Daily_Storage_Surface Water