The Urban Energy-Water Nexus: Utility-Level Water Flows and Embedded Energy
There are limited open source data available for determining water production/treatment and required energy for cities across the United States. This database represents the culmination of a two-year effort to obtain data from cities across the United States via open records requests in order to determine the state of the U.S. urban energy-water nexus. Data were requested at the daily or monthly scale when available for 127 cities across the United States, represented by 253 distinct water and sewer districts. Data were requested from cities larger than 100,000 people and from each state. In the case of states that did not have cities that met these criteria, the largest cities in those states were selected. The resulting database represents a drinking water service population of 81.4 million and a wastewater service population of 86.2 million people. Average daily demands for the United States were calculated to be 560 liters per capita for drinking water and 500 liters per capita of wastewater. The embedded energy within each of these resources is 340 kWh/1000 m3 and 430 kWh/1000 m3, respectively. Drinking water data at the annual scale are available for production volume (89 cities) and for embedded energy (73 cities). Annual wastewater data are available for treated volume (104 cities) and embedded energy (90 cities). Monthly data are available for drinking water volume and embedded energy (73 and 56 cities) and wastewater volume and embedded energy (88 and 70 cities). Please see the two related papers for this metadata are included with this submission.
Each folder name is a city that contributed data to the collection effort (City+State Abbreviation). Within each
folder is a .csv file with drinking water and wastewater volume and energy data. A READ-ME file within each folder
details the contents of the folder within any relevant information pertaining to data collection. Data are on the
order of a monthly timescale when available, and yearly if not.
Please cite the following papers when using the database:
Chini, C.M. and Stillwell, A.S. (2017). The State of U.S. Urban Water: Data and the Energy-Water Nexus. Water Resources Research. 54(3). DOI: https://doi.org/10.1002/2017WR022265
Chini, C.M., and Stillwell, A. (2016). Where are all the data? The case for a comprehensive water and wastewater utility database. Journal of Water Resources Planning and Management. 143(3). DOI: 10.1061/(ASCE)WR.1943-5452.0000739
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| bureauCode |
[
"019:20"
]
|
| contactPoint |
{
"fn": "Christopher Chini ",
"@type": "vcard:Contact",
"hasEmail": "mailto:christopher.chini@afit.edu"
}
|
| dataQuality |
true
|
| description | There are limited open source data available for determining water production/treatment and required energy for cities across the United States. This database represents the culmination of a two-year effort to obtain data from cities across the United States via open records requests in order to determine the state of the U.S. urban energy-water nexus. Data were requested at the daily or monthly scale when available for 127 cities across the United States, represented by 253 distinct water and sewer districts. Data were requested from cities larger than 100,000 people and from each state. In the case of states that did not have cities that met these criteria, the largest cities in those states were selected. The resulting database represents a drinking water service population of 81.4 million and a wastewater service population of 86.2 million people. Average daily demands for the United States were calculated to be 560 liters per capita for drinking water and 500 liters per capita of wastewater. The embedded energy within each of these resources is 340 kWh/1000 m3 and 430 kWh/1000 m3, respectively. Drinking water data at the annual scale are available for production volume (89 cities) and for embedded energy (73 cities). Annual wastewater data are available for treated volume (104 cities) and embedded energy (90 cities). Monthly data are available for drinking water volume and embedded energy (73 and 56 cities) and wastewater volume and embedded energy (88 and 70 cities). Please see the two related papers for this metadata are included with this submission. Each folder name is a city that contributed data to the collection effort (City+State Abbreviation). Within each folder is a .csv file with drinking water and wastewater volume and energy data. A READ-ME file within each folder details the contents of the folder within any relevant information pertaining to data collection. Data are on the order of a monthly timescale when available, and yearly if not. Please cite the following papers when using the database: Chini, C.M. and Stillwell, A.S. (2017). The State of U.S. Urban Water: Data and the Energy-Water Nexus. Water Resources Research. 54(3). DOI: https://doi.org/10.1002/2017WR022265 Chini, C.M., and Stillwell, A. (2016). Where are all the data? The case for a comprehensive water and wastewater utility database. Journal of Water Resources Planning and Management. 143(3). DOI: 10.1061/(ASCE)WR.1943-5452.0000739 |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "01_Open Source Data Published on HydroShare",
"format": "HTML",
"accessURL": "https://www.hydroshare.org/resource/df04c29d0ff64de0ace2d29145dd7680/",
"mediaType": "text/html",
"description": "The metadata in this submission have all been pulled from HydroShare, a collaborative environment for sharing hydrologic data and models for hydrologists to address critical water issues. This resource was created using funding from the National Science Foundation."
},
{
"@type": "dcat:Distribution",
"title": "SeattleWA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water Flows and Energy for FY2006; Daily Wastewater Flows and Energy for FY2012 in Seattle, WA",
"downloadURL": "https://data.openei.org/files/6461/SeattleWA.zip"
},
{
"@type": "dcat:Distribution",
"title": "AlbanyNY.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water Flows and Energy for FY2015; Annual Wastewater Flows and Energy for FY2012 in Albany, NY",
"downloadURL": "https://data.openei.org/files/6461/AlbanyNY.zip"
},
{
"@type": "dcat:Distribution",
"title": "OgdenUT.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water Flows and Monthly Energy for FY2012; Monthly Wastewater Flows and Energy for FY2015 in Ogden, UT",
"downloadURL": "https://data.openei.org/files/6461/OgdenUT.zip"
},
{
"@type": "dcat:Distribution",
"title": "SanFranciscoCA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water Flows; Daily Wastewater Flows and Annual Electricity for FY2012 in San Francisco, CA",
"downloadURL": "https://data.openei.org/files/6461/SanFranciscoCA.zip"
},
{
"@type": "dcat:Distribution",
"title": "SalemOR.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water Flows; Daily Wastewater Flows and Daily Energy for FY2012 in Salem, OR",
"downloadURL": "https://data.openei.org/files/6461/SalemOR.zip"
},
{
"@type": "dcat:Distribution",
"title": "SanJoseCA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water Flows; Daily Wastewater Flows and Monthly Energy for FY2012 in San Jose, CA",
"downloadURL": "https://data.openei.org/files/6461/SanJoseCA.zip"
},
{
"@type": "dcat:Distribution",
"title": "CharlestonSC.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water Volume (no energy), Daily Wastewater Flows (Monthly Energy) for FY2012 in Charleston, SC",
"downloadURL": "https://data.openei.org/files/6461/CharlestonSC.zip"
},
{
"@type": "dcat:Distribution",
"title": "DuluthMN.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water and Monthly Energy, Daily Wastewater Flow, NG and Monthly Electricity for FY2012 in Duluth, MN",
"downloadURL": "https://data.openei.org/files/6461/DuluthMN.zip"
},
{
"@type": "dcat:Distribution",
"title": "BaltimoreMD.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water and Wastewater Data for FY2012 in Baltimore, MD",
"downloadURL": "https://data.openei.org/files/6461/BaltimoreMD.zip"
},
{
"@type": "dcat:Distribution",
"title": "CharlotteNC.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water and Wastewater Flows and Energy for FY2012 in Charlotte, NC",
"downloadURL": "https://data.openei.org/files/6461/CharlotteNC.zip"
},
{
"@type": "dcat:Distribution",
"title": "LosAngelesCA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water and Wastewater Flows and Energy for FY2012 in Los Angeles, CA",
"downloadURL": "https://data.openei.org/files/6461/LosAngelesCA.zip"
},
{
"@type": "dcat:Distribution",
"title": "NashvilleTN.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water and Wastewater Flows, Monthly Energy for FY2012 in Nashville, TN",
"downloadURL": "https://data.openei.org/files/6461/NashvilleTN.zip"
},
{
"@type": "dcat:Distribution",
"title": "AmarilloTX.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Drinking Water and Wastewater Flows; Annual Wastewater Electricity for FY2012 in Amarillo, TX",
"downloadURL": "https://data.openei.org/files/6461/AmarilloTX.zip"
},
{
"@type": "dcat:Distribution",
"title": "LittleRockAR.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Wastewater Flows and Energy for FY2012 in Little Rock, AR",
"downloadURL": "https://data.openei.org/files/6461/LittleRockAR.zip"
},
{
"@type": "dcat:Distribution",
"title": "ProvoUT.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Wastewater Flows and Energy for FY2012 in Provo, UT",
"downloadURL": "https://data.openei.org/files/6461/ProvoUT.zip"
},
{
"@type": "dcat:Distribution",
"title": "StPaulMN.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Wastewater Flows and Energy for FY2012 in St. Paul, MN",
"downloadURL": "https://data.openei.org/files/6461/StPaulMN.zip"
},
{
"@type": "dcat:Distribution",
"title": "NorfolkVA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Wastewater Flows and Monthly Energy for FY2012 in Norfolk, VA",
"downloadURL": "https://data.openei.org/files/6461/NorfolkVA.zip"
},
{
"@type": "dcat:Distribution",
"title": "WashingtonDC.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Annual Water Flows and Annual Energy for FY2010 Drinking Water and FY2012 Wastewater in Washington, DC",
"downloadURL": "https://data.openei.org/files/6461/WashingtonDC.zip"
},
{
"@type": "dcat:Distribution",
"title": "StLouisMO.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flow and Monthly Energy; Annual Wastewater Flows and Energy for FY2012 in St. Louis, MO",
"downloadURL": "https://data.openei.org/files/6461/StLouisMO.zip"
},
{
"@type": "dcat:Distribution",
"title": "KnoxvilleTN.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows and Energy for FY2016; Daily Wastewater Flows for FY2012 in Knoxville, TN",
"downloadURL": "https://data.openei.org/files/6461/KnoxvilleTN.zip"
},
{
"@type": "dcat:Distribution",
"title": "HoustonTX.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows and Monthly Drinking Water Energy; Daily Wastewater Flows for FY2012 in Houston, TX",
"downloadURL": "https://data.openei.org/files/6461/HoustonTX.zip"
},
{
"@type": "dcat:Distribution",
"title": "WichitaKS.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows and Monthly Energy, Daily Wastewater Flows and Monthly Energy for FY2012 in Wichita, KS",
"downloadURL": "https://data.openei.org/files/6461/WichitaKS.zip"
},
{
"@type": "dcat:Distribution",
"title": "SacramentoCA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows and Monthly Energy; Annual Wastewater Flows and Monthly Energy for FY2012 in Sacramento, CA",
"downloadURL": "https://data.openei.org/files/6461/SacramentoCA.zip"
},
{
"@type": "dcat:Distribution",
"title": "SaltLakeCityUT.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows and Monthly Energy; Annual Wastewater Flows and Monthly Energy for FY2012 in Salt Lake City, UT",
"downloadURL": "https://data.openei.org/files/6461/SaltLakeCityUT.zip"
},
{
"@type": "dcat:Distribution",
"title": "SpokaneWA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows and Monthly Energy; Daily Wastewater Flows and Energy for FY2012 in Spokane, WA",
"downloadURL": "https://data.openei.org/files/6461/SpokaneWA.zip"
},
{
"@type": "dcat:Distribution",
"title": "SantaFeNM.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows and Monthly Energy; Monthly Wastewater Flows and Energy for FY2012 in Santa Fe, NM",
"downloadURL": "https://data.openei.org/files/6461/SantaFeNM.zip"
},
{
"@type": "dcat:Distribution",
"title": "CorpusChristiTX.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows and Monthly Wastewater Flows for FY2012 in Corpus Christi, TX",
"downloadURL": "https://data.openei.org/files/6461/CorpusChristiTX.zip"
},
{
"@type": "dcat:Distribution",
"title": "JacksonvilleFL.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows and Monthly Wastewater Flows for FY2012 in Jacksonville, FL",
"downloadURL": "https://data.openei.org/files/6461/JacksonvilleFL.zip"
},
{
"@type": "dcat:Distribution",
"title": "DesMoinesIA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows with Monthly Energy for FY2012 in Des Moines, IA",
"downloadURL": "https://data.openei.org/files/6461/DesMoinesIA.zip"
},
{
"@type": "dcat:Distribution",
"title": "MiamiFL.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows, Annual Wastewater Flows, Monthly Electricity for Drinking Water and Wastewater for FY2012 in Miami, FL",
"downloadURL": "https://data.openei.org/files/6461/MiamiFL.zip"
},
{
"@type": "dcat:Distribution",
"title": "North Texas.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows, Monthly Wastewater Flows and Energy for FY2012 in the North Texas Municipal Water District, which covers several large cities in Texas just north of Dallas including Plano and Frisco, TX",
"downloadURL": "https://data.openei.org/files/6461/North%20Texas.zip"
},
{
"@type": "dcat:Distribution",
"title": "GreenvilleSC.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water Flows; Daily Wastewater Flows and Monthly Energy for FY2012 in Greenville, SC",
"downloadURL": "https://data.openei.org/files/6461/GreenvilleSC.zip"
},
{
"@type": "dcat:Distribution",
"title": "FortCollinsCO.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows and Drinking Water Energy, Monthly Wastewater Energy for FY2012 in Fort Collins, CO",
"downloadURL": "https://data.openei.org/files/6461/FortCollinsCO.zip"
},
{
"@type": "dcat:Distribution",
"title": "OklahomaCityOK.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows and Energy for FY2012 in Oklahoma City, OK",
"downloadURL": "https://data.openei.org/files/6461/OklahomaCityOK.zip"
},
{
"@type": "dcat:Distribution",
"title": "FortWayneIN.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows and Monthly Drinking Water and Wastewater Energy for FY2012 in Fort Wayne, IN",
"downloadURL": "https://data.openei.org/files/6461/FortWayneIN.zip"
},
{
"@type": "dcat:Distribution",
"title": "ColumbusOH.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Columbus, OH",
"downloadURL": "https://data.openei.org/files/6461/ColumbusOH.zip"
},
{
"@type": "dcat:Distribution",
"title": "DaytonOH.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Dayton, OH",
"downloadURL": "https://data.openei.org/files/6461/DaytonOH.zip"
},
{
"@type": "dcat:Distribution",
"title": "DetroitMI.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Detroit, MI",
"downloadURL": "https://data.openei.org/files/6461/DetroitMI.zip"
},
{
"@type": "dcat:Distribution",
"title": "GreensboroNC.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Greensboro, NC",
"downloadURL": "https://data.openei.org/files/6461/GreensboroNC.zip"
},
{
"@type": "dcat:Distribution",
"title": "PhoenixAZ.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Phoenix, AZ",
"downloadURL": "https://data.openei.org/files/6461/PhoenixAZ.zip"
},
{
"@type": "dcat:Distribution",
"title": "ClevelandOH.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows, Monthly Energy for FY2012 in Cleveland, OH",
"downloadURL": "https://data.openei.org/files/6461/ClevelandOH.zip"
},
{
"@type": "dcat:Distribution",
"title": "ProvidenceRI.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows, Monthly Energy for FY2012 in Providence, RI",
"downloadURL": "https://data.openei.org/files/6461/ProvidenceRI.zip"
},
{
"@type": "dcat:Distribution",
"title": "SpringfieldMA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows; Annual Energy for FY2012 in Springfield, MA",
"downloadURL": "https://data.openei.org/files/6461/SpringfieldMA.zip"
},
{
"@type": "dcat:Distribution",
"title": "PortlandOR.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows; Monthly Drinking Water Energy for FY2012 in Portland, OR",
"downloadURL": "https://data.openei.org/files/6461/PortlandOR.zip"
},
{
"@type": "dcat:Distribution",
"title": "SanAntonioTX.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Drinking Water and Wastewater Flows; Monthly Energy for FY2012 in San Antonio, TX",
"downloadURL": "https://data.openei.org/files/6461/SanAntonioTX.zip"
},
{
"@type": "dcat:Distribution",
"title": "LincolnNE.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Flows and Electricity, Monthly Natural Gas for FY2012 in Lincoln, NE",
"downloadURL": "https://data.openei.org/files/6461/LincolnNE.zip"
},
{
"@type": "dcat:Distribution",
"title": "MadisonWI.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Flows, Daily Wastewater Electricity, Monthly Drinking Water Electricity, Natural Gas, and Wastewater NG for FY2012 in Madison, WI",
"downloadURL": "https://data.openei.org/files/6461/MadisonWI.zip"
},
{
"@type": "dcat:Distribution",
"title": "BurlingtonVT.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flow and Electricity for FY2012 in Burlington, VT",
"downloadURL": "https://data.openei.org/files/6461/BurlingtonVT.zip"
},
{
"@type": "dcat:Distribution",
"title": "BuffaloNY.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flow and Natural Gas, Monthly Electricity and Biogas for FY2012 in Buffalo, NY",
"downloadURL": "https://data.openei.org/files/6461/BuffaloNY.zip"
},
{
"@type": "dcat:Distribution",
"title": "ChicagoIL.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flow, Monthly Drinking Water Flow, Annual Drinking Water Energy, Annual and Daily Energy for Wastewater (depending on WWTP) for FY2012 in Chicago, IL",
"downloadURL": "https://data.openei.org/files/6461/ChicagoIL.zip"
},
{
"@type": "dcat:Distribution",
"title": "BridgeportCT.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flow, Monthly Energy for FY2012 in Bridgeport, CT",
"downloadURL": "https://data.openei.org/files/6461/BridgeportCT.zip"
},
{
"@type": "dcat:Distribution",
"title": "CharlestonWV.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flow, Monthly Energy for FY2012 in Charleston, WV",
"downloadURL": "https://data.openei.org/files/6461/CharlestonWV.zip"
},
{
"@type": "dcat:Distribution",
"title": "MemphisTN.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flows and Electricity, Monthly Biogas for FY2012 in Memphis, TN",
"downloadURL": "https://data.openei.org/files/6461/MemphisTN.zip"
},
{
"@type": "dcat:Distribution",
"title": "KalamazooMI.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flows and Energy for FY2012 in Kalamazoo, MI",
"downloadURL": "https://data.openei.org/files/6461/KalamazooMI.zip"
},
{
"@type": "dcat:Distribution",
"title": "NewarkNJ.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flows and Monthly Energy for FY2012 in Newark, NJ",
"downloadURL": "https://data.openei.org/files/6461/NewarkNJ.zip"
},
{
"@type": "dcat:Distribution",
"title": "PeoriaIL.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flows and Monthly Energy for FY2012 in Peoria, IL",
"downloadURL": "https://data.openei.org/files/6461/PeoriaIL.zip"
},
{
"@type": "dcat:Distribution",
"title": "SyracuseNY.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flows and Monthly Energy for FY2012 in Syracuse, NY",
"downloadURL": "https://data.openei.org/files/6461/SyracuseNY.zip"
},
{
"@type": "dcat:Distribution",
"title": "ToledoOH.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flows and Monthly Energy for FY2012 in Toledo, OH",
"downloadURL": "https://data.openei.org/files/6461/ToledoOH.zip"
},
{
"@type": "dcat:Distribution",
"title": "OmahaNE.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flows and Monthly Energy; Monthly Drinking Water Flow and Energy for 2012 in Omaha, NE",
"downloadURL": "https://data.openei.org/files/6461/OmahaNE.zip"
},
{
"@type": "dcat:Distribution",
"title": "MinneapolisMN.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flows, Monthly Drinking Water Flows and Energy",
"downloadURL": "https://data.openei.org/files/6461/MinneapolisMN.zip"
},
{
"@type": "dcat:Distribution",
"title": "BakersfieldCA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flows, Monthly Drinking Water Flows and Energy for FY2012 in Bakersfield, CA",
"downloadURL": "https://data.openei.org/files/6461/BakersfieldCA.zip"
},
{
"@type": "dcat:Distribution",
"title": "MilwaukeeWI.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater Flows, Monthly Drinking Water Flows and Energy for FY2012 in Milwaukee, WI",
"downloadURL": "https://data.openei.org/files/6461/MilwaukeeWI.zip"
},
{
"@type": "dcat:Distribution",
"title": "FargoND.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater and Biogas for FY2012 in Fargo, ND",
"downloadURL": "https://data.openei.org/files/6461/FargoND.zip"
},
{
"@type": "dcat:Distribution",
"title": "ElPasoTX.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Daily Wastewater and Monthly Energy for FY2012 in El Paso, TX",
"downloadURL": "https://data.openei.org/files/6461/ElPasoTX.zip"
},
{
"@type": "dcat:Distribution",
"title": "AugustaGA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Drinking Water and Wastewater Flows and Energy data for FY2012 in Augusta, GA",
"downloadURL": "https://data.openei.org/files/6461/AugustaGA.zip"
},
{
"@type": "dcat:Distribution",
"title": "AlbuquerqueNM.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Drinking Water and Wastewater Flows and Energy for FY2012 in Albuquerque, NM",
"downloadURL": "https://data.openei.org/files/6461/AlbuquerqueNM.zip"
},
{
"@type": "dcat:Distribution",
"title": "PittsburghPA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "FY2014 Daily Drinking Water; FY2012 Wastewater Flows and Monthly Wastewater Energy in Pittsburgh, PA",
"downloadURL": "https://data.openei.org/files/6461/PittsburghPA.zip"
},
{
"@type": "dcat:Distribution",
"title": "IndianapolisIN.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Data and Annual Wastewater Data for FY2012 in Indianapolis, IN",
"downloadURL": "https://data.openei.org/files/6461/IndianapolisIN.zip"
},
{
"@type": "dcat:Distribution",
"title": "NewYorkNY.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Energy and Annual Flows; Monthly Wastewater Flows and Energy for FY2012 in New York, NY",
"downloadURL": "https://data.openei.org/files/6461/NewYorkNY.zip"
},
{
"@type": "dcat:Distribution",
"title": "FresnoCA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Energy and Flows, Daily Wastewater Flows for FY2012 in Fresno, CA",
"downloadURL": "https://data.openei.org/files/6461/FresnoCA.zip"
},
{
"@type": "dcat:Distribution",
"title": "RenoNV.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flow and Energy; Daily Wastewater Flows and Monthly/Annual Energy for FY2012 in Reno, NV",
"downloadURL": "https://data.openei.org/files/6461/RenoNV.zip"
},
{
"@type": "dcat:Distribution",
"title": "JacksonMS.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Annual Energy for FY2012 in Jackson, MS",
"downloadURL": "https://data.openei.org/files/6461/JacksonMS.zip"
},
{
"@type": "dcat:Distribution",
"title": "NewOrleansLA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Annual Energy; Monthly Wastewater Flows and Energy for FY2012 in New Oreleans, LA",
"downloadURL": "https://data.openei.org/files/6461/NewOrleansLA.zip"
},
{
"@type": "dcat:Distribution",
"title": "OaklandCA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Annual Energy; Monthly Wastewater Flows and Energy for FY2012 in Oakland, CA",
"downloadURL": "https://data.openei.org/files/6461/OaklandCA.zip"
},
{
"@type": "dcat:Distribution",
"title": "AlexandriaVA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Energy for FY2012 in Alexandria, VA",
"downloadURL": "https://data.openei.org/files/6461/AlexandriaVA.zip"
},
{
"@type": "dcat:Distribution",
"title": "BirminghamAL.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Energy for FY2012 in Birmingham, AL",
"downloadURL": "https://data.openei.org/files/6461/BirminghamAL.zip"
},
{
"@type": "dcat:Distribution",
"title": "SiouxFallsSD.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Energy for FY2012 in Sioux Falls, SD",
"downloadURL": "https://data.openei.org/files/6461/SiouxFallsSD.zip"
},
{
"@type": "dcat:Distribution",
"title": "LasVegasNV.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Energy for FY2013; Monthly Wastewater Flows and Energy for FY2012 in Las Vegas, NV",
"downloadURL": "https://data.openei.org/files/6461/LasVegasNV.zip"
},
{
"@type": "dcat:Distribution",
"title": "ColoradoSpringsCO.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Energy, Daily Wastewater Flows, Monthly Wastewater Energy for FY2012 in Colorado Springs, CO",
"downloadURL": "https://data.openei.org/files/6461/ColoradoSpringsCO.zip"
},
{
"@type": "dcat:Distribution",
"title": "TampaFL.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Energy; Monthly Wastewater Flows and Energy for FY2012 in Tampa, FL",
"downloadURL": "https://data.openei.org/files/6461/TampaFL.zip"
},
{
"@type": "dcat:Distribution",
"title": "TucsonAZ.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Energy; Monthly Wastewater Flows and Energy; Monthly Reclaimed Water and Energy for FY2012 in Tuscon, AZ",
"downloadURL": "https://data.openei.org/files/6461/TucsonAZ.zip"
},
{
"@type": "dcat:Distribution",
"title": "SavannahGA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Energy; Daily Wastewater Flows for FY2012 in Savannah, GA",
"downloadURL": "https://data.openei.org/files/6461/SavannahGA.zip"
},
{
"@type": "dcat:Distribution",
"title": "TulsaOK.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Energy; Daily Wastewater Flows for FY2012 in Tulsa, OK",
"downloadURL": "https://data.openei.org/files/6461/TulsaOK.zip"
},
{
"@type": "dcat:Distribution",
"title": "WorcesterMA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows and Monthly Energy for FY2012 in Worcester, MA",
"downloadURL": "https://data.openei.org/files/6461/WorcesterMA.zip"
},
{
"@type": "dcat:Distribution",
"title": "TallahasseeFL.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water Flows; Monthly Wastewater Flows and Energy for FY2012 in Tallahassee, FL",
"downloadURL": "https://data.openei.org/files/6461/TallahasseeFL.zip"
},
{
"@type": "dcat:Distribution",
"title": "DenverCO.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Annual Energy, Daily Wastewater Flows and Electricity with Monthly NG for FY2012 in Denver, CO",
"downloadURL": "https://data.openei.org/files/6461/DenverCO.zip"
},
{
"@type": "dcat:Distribution",
"title": "EugeneOR.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Energy, Daily Wastewater Flow and Energy for FY2012 in Eugene, OR",
"downloadURL": "https://data.openei.org/files/6461/EugeneOR.zip"
},
{
"@type": "dcat:Distribution",
"title": "DallasTX.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Energy, Daily Wastewater Flows with Monthly Energy for FY2012 in Dallas, TX",
"downloadURL": "https://data.openei.org/files/6461/DallasTX.zip"
},
{
"@type": "dcat:Distribution",
"title": "SanDiegoCA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Energy; Daily Wastewater Flows and Monthly Energy for FY2012 in San Diego, CA",
"downloadURL": "https://data.openei.org/files/6461/SanDiegoCA.zip"
},
{
"@type": "dcat:Distribution",
"title": "KansasCityMO.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Annual Energy for FY2012 in Kansas City, MO",
"downloadURL": "https://data.openei.org/files/6461/KansasCityMO.zip"
},
{
"@type": "dcat:Distribution",
"title": "AnchorageAk.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Anchorage, AK",
"downloadURL": "https://data.openei.org/files/6461/AnchorageAk.zip"
},
{
"@type": "dcat:Distribution",
"title": "AustinTX.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Austin, TX",
"downloadURL": "https://data.openei.org/files/6461/AustinTX.zip"
},
{
"@type": "dcat:Distribution",
"title": "BeaumontTX.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Beaumont, TX",
"downloadURL": "https://data.openei.org/files/6461/BeaumontTX.zip"
},
{
"@type": "dcat:Distribution",
"title": "BillingsMT.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Billings, MT",
"downloadURL": "https://data.openei.org/files/6461/BillingsMT.zip"
},
{
"@type": "dcat:Distribution",
"title": "ColumbiaSC.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Columbia, SC",
"downloadURL": "https://data.openei.org/files/6461/ColumbiaSC.zip"
},
{
"@type": "dcat:Distribution",
"title": "FortWorthTX.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Fort Worth, TX",
"downloadURL": "https://data.openei.org/files/6461/FortWorthTX.zip"
},
{
"@type": "dcat:Distribution",
"title": "LouisvilleKY.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Louisville, KY",
"downloadURL": "https://data.openei.org/files/6461/LouisvilleKY.zip"
},
{
"@type": "dcat:Distribution",
"title": "PhiladelphiaPA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Philadelphia, PA",
"downloadURL": "https://data.openei.org/files/6461/PhiladelphiaPA.zip"
},
{
"@type": "dcat:Distribution",
"title": "PortlandME.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Portland, ME",
"downloadURL": "https://data.openei.org/files/6461/PortlandME.zip"
},
{
"@type": "dcat:Distribution",
"title": "TacomaWA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Tacoma, WA",
"downloadURL": "https://data.openei.org/files/6461/TacomaWA.zip"
},
{
"@type": "dcat:Distribution",
"title": "HarrisburgPA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Harrisburg, PA",
"downloadURL": "https://data.openei.org/files/6461/HarrisburgPA.zip"
},
{
"@type": "dcat:Distribution",
"title": "HonoluluHI.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Honolulu, HI",
"downloadURL": "https://data.openei.org/files/6461/HonoluluHI.zip"
},
{
"@type": "dcat:Distribution",
"title": "CheyenneWY.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows for FY2012 in Cheyenne, WY
",
"downloadURL": "https://data.openei.org/files/6461/CheyenneWY.zip"
},
{
"@type": "dcat:Distribution",
"title": "LakeCharlesLA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows for FY2012 in Lake Charles, LA",
"downloadURL": "https://data.openei.org/files/6461/LakeCharlesLA.zip"
},
{
"@type": "dcat:Distribution",
"title": "LubbockTX.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows for FY2012 in Lubbock, TX",
"downloadURL": "https://data.openei.org/files/6461/LubbockTX.zip"
},
{
"@type": "dcat:Distribution",
"title": "RaleighNC.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water and Wastewater Flows for FY2012 in Raleigh, NC",
"downloadURL": "https://data.openei.org/files/6461/RaleighNC.zip"
},
{
"@type": "dcat:Distribution",
"title": "BostonMA.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water, Daily Wastewater (flows and electric) for FY2012 in Boston, MA",
"downloadURL": "https://data.openei.org/files/6461/BostonMA.zip"
},
{
"@type": "dcat:Distribution",
"title": "CincinnatiOH.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Drinking Water, Daily Wastewater (flows and electric) for FY2012 in Cincinnati, OH",
"downloadURL": "https://data.openei.org/files/6461/CincinnatiOH.zip"
},
{
"@type": "dcat:Distribution",
"title": "BoiseID.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Wastewater Flows and Energy for FY2012 in Boise, ID",
"downloadURL": "https://data.openei.org/files/6461/BoiseID.zip"
},
{
"@type": "dcat:Distribution",
"title": "ManchesterNH.zip",
"format": "zip",
"mediaType": "application/zip",
"description": "Monthly Wastewater Flows and Energy for FY2012 in Manchester, NH",
"downloadURL": "https://data.openei.org/files/6461/ManchesterNH.zip"
},
{
"@type": "dcat:Distribution",
"title": "00_READ-ME.txt",
"format": "txt",
"mediaType": "text/plain",
"description": "Overall readme to reference with the data included in the submission.",
"downloadURL": "https://data.openei.org/files/6461/Overall_READ-ME.txt"
},
{
"@type": "dcat:Distribution",
"title": "02_The State of U.S. Urban Water - Data and the Energy-Water Nexus 2018. Water Resources Research.pdf",
"format": "pdf",
"mediaType": "application/pdf",
"description": "The content of this submission serves as the data for: The State of U.S. Urban Water: Data and the Energy-Water Nexus (2018). Water Resources Research. 54(3). DOI: https://doi.org/10.1002/2017WR022265",
"downloadURL": "https://data.openei.org/files/6461/2017WR022265.pdf"
},
{
"@type": "dcat:Distribution",
"title": "03_Where Are All the Data - The Case for a Comprehensive Water and Wastewater Utility Database.pdf",
"format": "pdf",
"mediaType": "application/pdf",
"description": "The content of this submission serves as the data for: Where are all the data? The case for a comprehensive water and wastewater utility database (2017). Journal of Water Resources Planning and Management. 143(3). DOI: https://doi.org/10.1061/(ASCE)WR.1943-5452.0000739",
"downloadURL": "https://data.openei.org/files/6461/%28ASCE%29WR.1943-5452.0000739.pdf"
}
]
|
| DOI | 10.7481/1787483 |
| identifier | https://data.openei.org/submissions/6461 |
| issued | 2018-02-20T07:00:00Z |
| keyword |
[
"NAWI",
"biogas",
"desalination",
"drinking water",
"electricity",
"energy",
"energy-water nexus",
"flow",
"industrial",
"reuse",
"urban",
"utility",
"wastewater",
"water",
"water treatment"
]
|
| landingPage | https://data.openei.org/submissions/6461 |
| license | https://creativecommons.org/licenses/by/4.0/ |
| modified | 2025-08-13T14:16:20Z |
| programCode |
[
"019:000",
"019:009"
]
|
| projectNumber |
"36496"
|
| projectTitle | NAWI Integrated Data and Analysis |
| publisher |
{
"name": "University of Illinois at Urbana-Champaign",
"@type": "org:Organization"
}
|
| spatial |
"{"type":"Polygon","coordinates":[[[-172.56077500000004,14.158105459124451],[-53.8316,14.158105459124451],[-53.8316,71.66169671170795],[-172.56077500000004,71.66169671170795],[-172.56077500000004,14.158105459124451]]]}"
|
| title | The Urban Energy-Water Nexus: Utility-Level Water Flows and Embedded Energy |