Import Texas Groundwater Database

[amabdallah]

Sam Marie Hermitte, Assistant Deputy Executive Administrator, reached out saying that the Texas Water Development Board (TWDB) maintains this groundwater wells database for well-specific information on Water Data Interactive platform.

Download + metadata http://www.twdb.texas.gov/groundwater/data/gwdbrpt.asp

This could be an intern's task

Let's import this data and make it Exempt. No priority date and no permitted amount.
We need to come up with a water allocation type for this type of data. We need Michelle's help with that. These would be WaDE names: Values I can think of

• Riparian (as in California)
• Prior Appropriation (most water rights in WestDAAT)
• Rule of Capture (this one applies to groundwater in Texas and likely other states).
• Domestic Exempt (these for groundwater wells, I think in Arizona outside AMAs)

These groundwater well reports in Texas have an allocation type of Rule of Capture.

So eventually, we may add a new WestDAAT filter for Allocation Type. We also need to add Allocation Type to the landing pages

[amabdallah]

One of the datasets have all the metadata below Will keep them in mind for future extension to our metadata

Metadata columns

StateWellNumber County RiverBasin GMA RWPA GCD AquiferCode AquiferCodeDescription AquiferId Aquifer Classification AquiferPickMethod LatitudeDD Dlat Mlat Slat LongitudeDD Dlong Mlong Slong CoordinateSource Owner Driller WellDepth DepthSource LandSurfaceElevation LandSurfaceElevationMethod DrillingStartDate DrillingMonth DrillingDay DrillingYear DrillingEndDate DrillingMethod BoreHoleCompletion WellType Pump PowerType WellUse WaterLevelStatus CurrentWaterLevelWell WaterQualityAvailable CurrentWaterQualityWell ReportingAgency OtherDataAvailable Remarks WellReportTrackingNumber PluggingReportTrackingNumber USGSSiteNumber TCEQSourceId GCDWellNumber OwnerWellNumber OtherWellNumber PreviousStateWellNumber CreatedDate LastUpdateDate

[amabdallah]

Let's add this paragraph right before the existing disclaimer text https://westdaat.westernstateswater.org/details/right/TWDBwr_WR4427403

The Texas Water Development Board (TWDB) Groundwater Database (GWDB) contains information on selected water wells, springs, oil/gas tests (that were originally intended to be or were converted to water wells), water levels, and water quality to gain representative information about aquifers in Texas to support water planning from a local to a more regional perspective. For common questions on groundwater information, please check out the General Groundwater and Private Water Well FAQ page: https://www.twdb.texas.gov/groundwater/faq/faqgwm.asp