Master Data Sources
Purpose
This page documents known data sources that issue unique identifiers
Groundwater - Wells (Regulated by state - mostly)
Several types of permitted wells: Public water system well, private domestic, irrigation, monitoring wells, industrial, injection, etc.
Public Water Systems (PWS)
Permitted for water quality under NMED and EPA, with water use permitting under NM OSE.
NMED for water quality regulation
https://newmexicowaterdata.org/dataset/drinking-water-watch
NMED issues the identifiers out of the SDWIS database (currently managed by Daniel Ramirez). SDWIS is an EPA federal database, that states work with to provide water quality data assurances for public supply. System ID may include numerous infrastructure pieces with it, not JUST the well.
Data are made publicly available through a viewer database called Drinking Water Watch. Example:
OSE ID
https://newmexicowaterdata.org/dataset/ose-points-of-diversion
OSE provides the permit to use the water - the water right permit. They issue the OSE ID (text string, like RG-09843...). The WATERS database is built in INFORMIX (4GL language) and is queried by MS Access. These views of data are run periodically (weekly?) and provided to co-workers or collaborators as needed.
One example output is the online database view called the Water Rights Reporting System.
These are listed under Points of Diversion. An example is here: http://geospatialdata-ose.opendata.arcgis.com/datasets/ose-pods
OSE ID is a combination of these 3 fields in this example. This is an output example from the WATERs database maintained by OSE. The WATERS database is built in INFORMIX (4GL language) and is queried by MS Access.
NM Department of Health
With OSE, Department of Health (private well epidemiology program) established a well-tagging program from in 2017 for newly permitted wells (e.g., domestic, livestock, irrigation, commercial-use wells) and older wells seeking improvements. Presently, older wells and other wells without water rights are not tagged, e.g., monitoring wells, piezometers, etc. Tags are alpha-numeric (EXAMPLE: “3075B”) and entered into WATERS at OSE. Tag is a QR code on the tag, but the agency does not have a way to use those QR codes yet. The tags are provided for by a Department of Health grant in collaboration with OSE. Contacts are Rose Galbraith at OSE and Jerri Pohl at OSE.
Private domestic wells
Utilized for many purposes. ID begins in OSE ID (see above). Also may have IDs and more extensive time series data in USGS databases, NMBGMR, NMED, and other smaller groups.
Monitoring wells
??Do not have any kind of unique identifier for entities (i.e. wells) outside of a database row ID
Typically these are associated with a location which has a discharge permit, regulated by the Ground Water Quality Bureau at NMED.
Also some attempts to coordinate Monitoring wells in the OSE permit process. These may cross reference.
OTHER types of wells
Most are permitted for water rights under OSE ID system (WATERs)
May have associated data on water quality at NMED under Ground Water Quality Bureau - unclear of ID system.
Federal Agencies
USGS
Typically they make their own ID but are using wells already identified under OSE as public supply wells, domestic or monitoring wells (or others). They collect a wide range of water data such as water quality, water levels, and numerous time series data.
https://newmexicowaterdata.org/dataset/usgs-nm-water-data
US EPA
Regulatory coordination on PWS. The state originates the ID, but it is connected to features hosted at EPA.
DOE
Not super relevant: DOE has their own unique IDs as well: see web application - https://gems.lm.doe.gov/#site=APC
Surface water
OSE ID
https://newmexicowaterdata.org/dataset/ose-points-of-diversion
Surface water may be used for public supply. See above info related to PWSs.
NMED
Regulation of streams, rivers, wetlands, lakes under the Surface Water Quality Bureau.
Incomplete, but one example
https://newmexicowaterdata.org/dataset/total-maximum-daily-loads
US EPA
NPDES permits (number generated at EPA or NMED??
Other fluids
EMNRD - Oil Conservation Division: Produced water
Related to Produced Water in oil/gas industry, the OCD uses the API number for well identification which is a unique identifier tied to the county FIPS code. These are hosted on FTP site.
https://newmexicowaterdata.org/dataset/ocd-data-ftp
They also regulate injection wells, where produced water is re-injected into the subsurface as a disposal mechanism.
NM Tech - Petroleum Recovery Resource Center
Collects data from OCD, hosted on their FTP site. Also collects water quality data directly from oil/gas producing companies on Produced Water.
https://newmexicowaterdata.org/dataset/petroleum-recovery-resource-center