NE ag data

[amabdallah]

Start here and read this one https://nednr.nebraska.gov/insight/about.html

Check this data https://nednr.nebraska.gov/insight/

Zoom in to a basin and toggle between the different tabs and drop-down menus. Download CSV data. We probably need to reach out to the DNR and ask them if there is another way to mass-download the data for the basins and variables at once.

[rwjam]

Looks like the shapefile downlead option has the supply and demand values imbedded in the tables. However, I don't see a ReportYearCV value anywhere on the NE website / data to use with this.

[amabdallah]

Interesting, is that average data then? I'll ask them. What other metadata we may need that they dont have?

[rwjam]

Found some more time detailed water data files for both basin and subasin, in the MODELING DATA -> 2015 - > FinalFiles. Data has supply and demand data for 1988 - 2012. I think we can use the following fields....

Year = ReportYearCV Basin = reporting area name

SWDTotal_Annual= surface water, depletion GWDP_Annual = groundwater amount, depletion GWCTotal_Annual = groundwater amount, from consumptive use SWDemandTotal_Annual = total surface water amount, demand

GWCIrrigation_Annual = groundwater amount for ben use irrigation, consumptive use GWCMunicipal_Annual = groundwater amount for ben use municipal, consumptive use GWCIndustrial_Annual = groundwater amount for ben use industrial, consumptive use

GWIAcres = Amount of acreage estimated to be irrigated by groundwater. SWIAcres = Surface Water Irrigated Acres COIAcres = Amount of estimated acreage identified as having the potential to be irrigated by both groundwater and surface water (note: doesn't appear to be the sum of GWIAcres & COIAcres).

[amabdallah]

Great! I think it would be useful to map this to WaDE and import it if possible to see if there is anything else we need from NE folks before our call with them in early July.

[rwjam]

Having difficulty determining how to map out the INSIGHT data into WaDE, too many fields to work with. Data and documentation saved here, need to spend some time reviewing. Adel to reach out to Shea Winkler for some basic answer and questions.

Questions we have...

• Difference between surface water consumptive use in both supply and demand tabs? How do they relate?
• What is part / what makes up the Total-Non-consumptive Demand & Net Surface Water Loss bars in the demand plots?
• Difference between groundwater depletion (supply tab) and consumptive use (demand tab)?

[rwjam]

Data pushed to QA using the above logic.

[rwjam]

Revisiting how to map out NE ag data to match the updated timeseries approach. Here is the current idea to build a VariableSpecificCV...

AmountInput	VariableCV	AggreationInterval	Benefical Use	WaterSource
SWDTotal_Annual	Depletion	Annual	Total	Surface Water
GWDP_Annual	Depletion	Annual	Total	Groundwater
GWCTotal_Annual	Consumptive Use	Annual	Total	Groundwater
GWCIrrigation_Annual	Consumptive Use	Annual	Irrigation	Groundwater
GWCMunicipal_Annual	Consumptive Use	Annual	Municipal	Groundwater
GWCIndustrial_Annual	Consumptive Use	Annual	Industrial	Groundwater
SWDemandTotal_Annual	Demand	Annual	Total	Surface Water

There are lots of other time series we could also utilize (e.g., Hydropower, NetEvaporation, Streamflow, etc). Looks like NE still hasn't created good meta to work with, hard to trace back and describe exact what the data is.