Texas site-specific water use data

[amabdallah]

TCEQ publishes the monthly self-reported site-specific water use data in three variables: diverted, consumed, return flow for each water right (except wastewater treatment plants)

https://www.tceq.texas.gov/permitting/water_rights/wr-permitting/wrwud

Mapping the data to WaDE site-specific data will require lots of pivoting and manipulation. For now, lets only target this data "From 2000 through 2014"

[rwjam]

TCEQ publishes the monthly self-reported site-specific water use data in three variables: diverted, consumed, return flow for each water right (except wastewater treatment plants)

Of those three variables, which should we focus on? diverted, consumed, return flow?

At the moment (09/09/2020), WaDE 2.0 Site Specific data looks for an Amount value, which has a loose definition of 'The aggregated variable amount." I think we can take this in either two directions: 1) break up the WaDE 2.0 Amount term into more specific values, 2) break this TCEQ data into three separate data sets with a variable types of diverted, consumed, return flow.

TCEQ data is also missing any location information (e.g., no lat or long).

[amabdallah]

Let's discuss this one. It looks similar to the UT M&I data. Its

https://www.twdb.texas.gov/waterplanning/waterusesurvey/serviceboundaryeditor.asp

More

There must be a way to join the shapefile info with the time series historic data file (somewhere at the link below). We probably need to chat with the TWDB to see what they suggest. I recommend looking into all these to prepare for the call and ask them questions. https://www.twdb.texas.gov/waterplanning/waterusesurvey/estimates/index.asp

[amabdallah]

Out point of contact at TCEQ shared an Excel file with us that includes all their data.

[rwjam]

Data provided here is outdate. Please see new issue to work on. https://github.com/WSWCWaterDataExchange/MappingStatesDataToWaDE2.0/issues/89

[amabdallah]

I'm opening this issue because it contains relevant info. http://www.twdb.texas.gov/waterplanning/waterusesurvey/estimates/index.asp If you click at this link as in the screenshot below, TWDB does now seem to share the aggregate water withdrawal per "city" or as they call it "Public Water System" per water source type. This fits what USGS wants at the POU level. So this data might be a better fit for WaDE because of the sensitivity of the wells' locations for them.

I tried a couple of cities and they seem to match wit this GIS layer, not sure to what extent the rest do https://www3.twdb.texas.gov/apps/waterserviceboundaries

[amabdallah]

So the Excel file is for aggregate POD data per water source type. There is a monthly time series data from 1971-2020 attached to each POD. We can define unique water sources from all the data and reuse them across the sites. The shapefile is the POU sites that are related to the aggregate PODs in the Excel file. In this case, a POU site has no provided time-series data.

I'm not sure what coordinates to include for each POD site. We could use the centroid of the water source name such as reservoirs or groundwater aquifers but that will be a lot of work and there are "unknown" water source names which we won't know. Also, aquafers like the Ogallala aquifer can be giant and their centroid might be outside Texas (no idea). I suggested before using the centroid of the POU for a POD coordinates but now I don't like this idea for two reasons: 1) in visualization, it won't show a line between the a POU and POD because they are on top of each other, 2) there seem to be many aggregate POD sites (e.g., GW#1, GW#2, SW#4, Reuse#5) supplying a POU. So all of them would be on top of each other.

[amabdallah]

The best solution I could think of is that we use the centroid of the POU and then add a radial distance from it for each aggregate POD site like this example. I'm not sure how that could be automated in ArcGIS, if at all.

[rwjam]

We also want to pair the water use (new) with the intake data. http://www.twdb.texas.gov/waterplanning/waterusesurvey/estimates/index.asp

[amabdallah]

I'm opening this issue as there is a new relevant data source

Water Service Boundary Viewer

Public Water System layer: relatively new. It seems that each public water system identifier in this layer can be joined with the Water Service Boundary Viewer to connect polygons (POUs) with intakes and wells (PODs) https://gis-tceq.opendata.arcgis.com/maps/TCEQ::public-water-system/about

[rwjam]

Not sure if relevant any more. There TCEQ data appears to be no way to export this data to an externa csv / shp file. The ESRI Extract Data (Map Viewer) tool does not work. It appears the owner (TCEQ) has not allowed this data to be exportable in their ESRI Online settings. We can only make a copy of it to view to our own ESRI online service, which does not allow any table viewing / export options.