Water Conservation Data Jam Dataset
Sandoval County, NM
The Water Use and Conservation Bureau of the New Mexico Office of the State Engineer publishes the New Mexico Water Use by Categories Report every five years (https://www.ose.state.nm.us/WUC/wuc_waterUseData.php). The purpose of the report is to make water use data available to the public. Data from the report are used by community planners, legislators, scientists, and individuals. This dataset includes data from the New Mexico Water Use by Categories Reports from the last 20 years (1995-2015).
|Water Use Variables from the NM Water Use by Categories Report:
- Residential water use: This includes all water supplied by community water systems that have common collection, treatment, and distribution facilities to provide water to multiple locations. For example, Rio Rancho Sewer and Wastewater Services is a major public water supplier in Sandoval County. Most public water suppliers report the meter records of water use to the NM Office of the State Engineer. It also includes domestic, self-supplied water, which would include single family houses with their own well. The domestic, self-supplied water withdrawals are calculated by multiplying water use per person per day (currently estimated at 80-100 gallons, depending on the county) by the number of people served by self-supplied water.
- While we call this “residential use,” this public water supply category would also capture water supplied by public water suppliers to golf courses, parks, and athletic fields.
- Irrigated agricultural water use: This category includes all withdrawals of water for the irrigation of crops grown on farms, ranches, and wildlife refuges. This value is estimated using a multi-step process that includes:
- Calculating the total acreage of irrigated acreage by crop and by irrigation system (drip, flood, or sprinkler) using a Geographic Information System (GIS) to integrate map layers showing the entire state. Information from agencies like the USDA Farm Service Agency and county extension agents was used to validate the values determined using maps and aerial images.
- Obtaining temperature and precipitation data from the state.
- Determining the irrigation season for each crop.
- Using the information from above to calculate the “weighted consumptive irrigation requirement” for each crop.
- Livestock use: This category includes water used to raise livestock, maintain livestock facilities, and provide for on-farm processing of poultry and dairy products. These values are estimated using two pieces of information:
- The number of livestock by species per county – These values come primarily from the New Mexico Department of Agriculture.
- Water withdrawals – Metered water withdrawals are used when available. When the water use is not metered, these values are estimated using water requirements per animal per day for each livestock species (e.g., 65 gallons per dairy cow per day and 3 gallons per hog per day).
- Commercial use: This category includes use by self-supplied businesses (e.g. motels, restaurants), schools, hospitals, and self-supplied golf courses. The values are calculated by combining metered withdrawals and estimating non-metered withdrawals based on earlier records.
- Industrial and mining use: Industrial water use includes businesses that process raw materials or manufacture goods. The industrial category also includes water used for construction of highways and buildings. Mining use includes water used for oil and gas production, quarrying, and milling. The values are calculated by combining metered withdrawals and estimating non-metered withdrawals based on earlier records.
- Power use: This category includes all self-supplied power generating facilities, including coal-mining operations associated with a power generating facility. The values are calculated by combining metered withdrawals and contacting non-metered facilities.
|Other Variables Included in the Dataset (please note that these can be included in your data trend, but your data trend MUST also include one or more of the water use variables listed above):
- Precipitation: Data were collected by the NOAA National Centers for Environmental Information from a network of rain gauges located at a variety of land-based stations across the county. This dataset includes total precipitation from across Sandoval County.
- Human Population: Data were collected by the US Census Bureau for Sandoval County. A complete population census is conducted every 10 years, and populations are estimated in between.
CODAP is a free educational software for data analysis, a product of The Concord Consortium (https://concord.org) and funded by NSF grants.