The Urban Energy-Water Nexus: Utility-Level Water Flows and Embedded Energy

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

Resources

Name Format Description Link
57 Annual Water Flows and Annual Energy for FY2010 Drinking Water and FY2012 Wastewater in Washington, DC https://waterdams.nawihub.org/files/3/WashingtonDC.zip
57 Monthly Drinking Water Flows and Monthly Energy for FY2012 in Worcester, MA https://waterdams.nawihub.org/files/3/WorcesterMA.zip
57 Daily Drinking Water Flows and Monthly Energy, Daily Wastewater Flows and Monthly Energy for FY2012 in Wichita, KS https://waterdams.nawihub.org/files/3/WichitaKS.zip
57 Monthly Drinking Water Flows and Energy; Daily Wastewater Flows for FY2012 in Tulsa, OK https://waterdams.nawihub.org/files/3/TulsaOK.zip
57 Monthly Drinking Water Flows and Energy; Monthly Wastewater Flows and Energy; Monthly Reclaimed Water and Energy for FY2012 in Tuscon, AZ https://waterdams.nawihub.org/files/3/TucsonAZ.zip
57 Monthly Drinking Water Flows and Energy; Monthly Wastewater Flows and Energy for FY2012 in Tampa, FL https://waterdams.nawihub.org/files/3/TampaFL.zip
57 Daily Wastewater Flows and Monthly Energy for FY2012 in Toledo, OH https://waterdams.nawihub.org/files/3/ToledoOH.zip
57 Drinking Water and Wastewater Flows and Energy data for FY2012 in Augusta, GA https://waterdams.nawihub.org/files/3/AugustaGA.zip
57 Monthly Drinking Water Flows; Monthly Wastewater Flows and Energy for FY2012 in Tallahassee, FL https://waterdams.nawihub.org/files/3/TallahasseeFL.zip
57 Daily Wastewater Flows and Monthly Energy for FY2012 in Syracuse, NY https://waterdams.nawihub.org/files/3/SyracuseNY.zip
57 Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Tacoma, WA https://waterdams.nawihub.org/files/3/TacomaWA.zip
57 Monthly Drinking Water Flows and Energy for FY2012 in Sioux Falls, SD https://waterdams.nawihub.org/files/3/SiouxFallsSD.zip
57 Annual Drinking Water Flows and Energy for FY2006; Daily Wastewater Flows and Energy for FY2012 in Seattle, WA https://waterdams.nawihub.org/files/3/SeattleWA.zip
57 Annual Wastewater Flows and Energy for FY2012 in St. Paul, MN https://waterdams.nawihub.org/files/3/StPaulMN.zip
57 Annual Drinking Water Flows; Daily Wastewater Flows and Monthly Energy for FY2012 in San Jose, CA https://waterdams.nawihub.org/files/3/SanJoseCA.zip
57 Daily Drinking Water Flow and Monthly Energy; Annual Wastewater Flows and Energy for FY2012 in St. Louis, MO https://waterdams.nawihub.org/files/3/StLouisMO.zip
57 Daily Drinking Water and Wastewater Flows; Annual Energy for FY2012 in Springfield, MA https://waterdams.nawihub.org/files/3/SpringfieldMA.zip
57 Daily Drinking Water Flows and Monthly Energy; Daily Wastewater Flows and Energy for FY2012 in Spokane, WA https://waterdams.nawihub.org/files/3/SpokaneWA.zip
57 Monthly Drinking Water Flows and Energy; Daily Wastewater Flows for FY2012 in Savannah, GA https://waterdams.nawihub.org/files/3/SavannahGA.zip
57 Daily Drinking Water Flows and Monthly Energy; Monthly Wastewater Flows and Energy for FY2012 in Santa Fe, NM https://waterdams.nawihub.org/files/3/SantaFeNM.zip
57 Annual Drinking Water Flows; Daily Wastewater Flows and Annual Electricity for FY2012 in San Francisco, CA https://waterdams.nawihub.org/files/3/SanFranciscoCA.zip
57 Daily Drinking Water Flows and Monthly Energy; Annual Wastewater Flows and Monthly Energy for FY2012 in Salt Lake City, UT https://waterdams.nawihub.org/files/3/SaltLakeCityUT.zip
57 Monthly Drinking Water and Energy; Daily Wastewater Flows and Monthly Energy for FY2012 in San Diego, CA https://waterdams.nawihub.org/files/3/SanDiegoCA.zip
57 Daily Drinking Water and Wastewater Flows; Monthly Energy for FY2012 in San Antonio, TX https://waterdams.nawihub.org/files/3/SanAntonioTX.zip
57 Monthly Drinking Water Flow and Energy; Daily Wastewater Flows and Monthly/Annual Energy for FY2012 in Reno, NV https://waterdams.nawihub.org/files/3/RenoNV.zip
57 Annual Drinking Water Flows; Daily Wastewater Flows and Daily Energy for FY2012 in Salem, OR https://waterdams.nawihub.org/files/3/SalemOR.zip
57 Daily Drinking Water Flows and Monthly Energy; Annual Wastewater Flows and Monthly Energy for FY2012 in Sacramento, CA https://waterdams.nawihub.org/files/3/SacramentoCA.zip
57 Monthly Drinking Water and Wastewater Flows for FY2012 in Raleigh, NC https://waterdams.nawihub.org/files/3/RaleighNC.zip
57 Daily Drinking Water and Wastewater Flows, Monthly Energy for FY2012 in Providence, RI https://waterdams.nawihub.org/files/3/ProvidenceRI.zip
57 Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Portland, ME https://waterdams.nawihub.org/files/3/PortlandME.zip
57 FY2014 Daily Drinking Water; FY2012 Wastewater Flows and Monthly Wastewater Energy in Pittsburgh, PA https://waterdams.nawihub.org/files/3/PittsburghPA.zip
57 Daily Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Phoenix, AZ https://waterdams.nawihub.org/files/3/PhoenixAZ.zip
57 Daily Drinking Water and Wastewater Flows; Monthly Drinking Water Energy for FY2012 in Portland, OR https://waterdams.nawihub.org/files/3/PortlandOR.zip
57 Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Philadelphia, PA https://waterdams.nawihub.org/files/3/PhiladelphiaPA.zip
57 Daily Wastewater Flows and Monthly Energy; Monthly Drinking Water Flow and Energy for 2012 in Omaha, NE https://waterdams.nawihub.org/files/3/OmahaNE.zip
57 Daily Wastewater Flows and Monthly Energy for FY2012 in Peoria, IL https://waterdams.nawihub.org/files/3/PeoriaIL.zip
57 Annual Drinking Water Flows and Monthly Energy for FY2012; Monthly Wastewater Flows and Energy for FY2015 in Ogden, UT https://waterdams.nawihub.org/files/3/OgdenUT.zip
57 Annual Wastewater Flows and Energy for FY2012 in Provo, UT https://waterdams.nawihub.org/files/3/ProvoUT.zip
57 Monthly Drinking Water Flows and Annual Energy; Monthly Wastewater Flows and Energy for FY2012 in Oakland, CA https://waterdams.nawihub.org/files/3/OaklandCA.zip
57 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 https://waterdams.nawihub.org/files/3/North%20Texas.zip
57 Monthly Drinking Water Energy and Annual Flows; Monthly Wastewater Flows and Energy for FY2012 in New York, NY https://waterdams.nawihub.org/files/3/NewYorkNY.zip
57 Annual Drinking Water and Wastewater Flows, Monthly Energy for FY2012 in Nashville, TN https://waterdams.nawihub.org/files/3/NashvilleTN.zip
57 Monthly Drinking Water Flows and Annual Energy; Monthly Wastewater Flows and Energy for FY2012 in New Oreleans, LA https://waterdams.nawihub.org/files/3/NewOrleansLA.zip
57 Daily Wastewater Flows and Monthly Energy for FY2012 in Newark, NJ https://waterdams.nawihub.org/files/3/NewarkNJ.zip
57 Daily Wastewater Flows, Monthly Drinking Water Flows and Energy for FY2012 in Milwaukee, WI https://waterdams.nawihub.org/files/3/MilwaukeeWI.zip
57 Daily Wastewater Flows, Monthly Drinking Water Flows and Energy https://waterdams.nawihub.org/files/3/MinneapolisMN.zip
57 Daily Wastewater Flows and Electricity, Monthly Biogas for FY2012 in Memphis, TN https://waterdams.nawihub.org/files/3/MemphisTN.zip
57 Monthly Wastewater Flows and Energy for FY2012 in Manchester, NH https://waterdams.nawihub.org/files/3/ManchesterNH.zip
57 Daily Flows, Daily Wastewater Electricity, Monthly Drinking Water Electricity, Natural Gas, and Wastewater NG for FY2012 in Madison, WI https://waterdams.nawihub.org/files/3/MadisonWI.zip
57 Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Louisville, KY https://waterdams.nawihub.org/files/3/LouisvilleKY.zip
57 Daily Drinking Water and Wastewater Flows and Energy for FY2012 in Oklahoma City, OK https://waterdams.nawihub.org/files/3/OklahomaCityOK.zip
57 Monthly Drinking Water and Wastewater Flows for FY2012 in Lubbock, TX https://waterdams.nawihub.org/files/3/LubbockTX.zip
57 Daily Drinking Water Flows, Annual Wastewater Flows, Monthly Electricity for Drinking Water and Wastewater for FY2012 in Miami, FL https://waterdams.nawihub.org/files/3/MiamiFL.zip
57 Annual Drinking Water and Wastewater Flows and Energy for FY2012 in Los Angeles, CA https://waterdams.nawihub.org/files/3/LosAngelesCA.zip
57 Annual Wastewater Flows and Energy for FY2012 in Little Rock, AR https://waterdams.nawihub.org/files/3/LittleRockAR.zip
57 Annual Wastewater Flows and Monthly Energy for FY2012 in Norfolk, VA https://waterdams.nawihub.org/files/3/NorfolkVA.zip
57 Monthly Drinking Water Flows and Energy for FY2013; Monthly Wastewater Flows and Energy for FY2012 in Las Vegas, NV https://waterdams.nawihub.org/files/3/LasVegasNV.zip
57 Daily Drinking Water Flows and Energy for FY2016; Daily Wastewater Flows for FY2012 in Knoxville, TN https://waterdams.nawihub.org/files/3/KnoxvilleTN.zip
57 Monthly Drinking Water and Wastewater Flows for FY2012 in Lake Charles, LA https://waterdams.nawihub.org/files/3/LakeCharlesLA.zip
57 Daily Wastewater Flows and Energy for FY2012 in Kalamazoo, MI https://waterdams.nawihub.org/files/3/KalamazooMI.zip
57 Monthly Drinking Water and Wastewater Flows and Annual Energy for FY2012 in Kansas City, MO https://waterdams.nawihub.org/files/3/KansasCityMO.zip
57 Monthly Drinking Water Flows and Annual Energy for FY2012 in Jackson, MS https://waterdams.nawihub.org/files/3/JacksonMS.zip
57 Monthly Drinking Water Data and Annual Wastewater Data for FY2012 in Indianapolis, IN https://waterdams.nawihub.org/files/3/IndianapolisIN.zip
57 Daily Flows and Electricity, Monthly Natural Gas for FY2012 in Lincoln, NE https://waterdams.nawihub.org/files/3/LincolnNE.zip
57 Daily Drinking Water Flows and Monthly Wastewater Flows for FY2012 in Jacksonville, FL https://waterdams.nawihub.org/files/3/JacksonvilleFL.zip
57 Daily Drinking Water Flows and Monthly Drinking Water Energy; Daily Wastewater Flows for FY2012 in Houston, TX https://waterdams.nawihub.org/files/3/HoustonTX.zip
57 Monthly Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Harrisburg, PA https://waterdams.nawihub.org/files/3/HarrisburgPA.zip
57 Daily Drinking Water Flows; Daily Wastewater Flows and Monthly Energy for FY2012 in Greenville, SC https://waterdams.nawihub.org/files/3/GreenvilleSC.zip
57 Daily Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Greensboro, NC https://waterdams.nawihub.org/files/3/GreensboroNC.zip
57 Monthly Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Honolulu, HI https://waterdams.nawihub.org/files/3/HonoluluHI.zip
57 Monthly Drinking Water Energy and Flows, Daily Wastewater Flows for FY2012 in Fresno, CA https://waterdams.nawihub.org/files/3/FresnoCA.zip
57 Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Fort Worth, TX https://waterdams.nawihub.org/files/3/FortWorthTX.zip
57 Daily Drinking Water and Wastewater Flows and Monthly Drinking Water and Wastewater Energy for FY2012 in Fort Wayne, IN https://waterdams.nawihub.org/files/3/FortWayneIN.zip
57 Daily Wastewater and Biogas for FY2012 in Fargo, ND https://waterdams.nawihub.org/files/3/FargoND.zip
57 Daily Drinking Water and Wastewater Flows and Drinking Water Energy, Monthly Wastewater Energy for FY2012 in Fort Collins, CO https://waterdams.nawihub.org/files/3/FortCollinsCO.zip
57 Monthly Drinking Water and Energy, Daily Wastewater Flow and Energy for FY2012 in Eugene, OR https://waterdams.nawihub.org/files/3/EugeneOR.zip
57 Annual Drinking Water and Monthly Energy, Daily Wastewater Flow, NG and Monthly Electricity for FY2012 in Duluth, MN https://waterdams.nawihub.org/files/3/DuluthMN.zip
57 Daily Wastewater and Monthly Energy for FY2012 in El Paso, TX https://waterdams.nawihub.org/files/3/ElPasoTX.zip
57 Daily Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Detroit, MI https://waterdams.nawihub.org/files/3/DetroitMI.zip
57 Daily Drinking Water Flows with Monthly Energy for FY2012 in Des Moines, IA https://waterdams.nawihub.org/files/3/DesMoinesIA.zip
57 Monthly Drinking Water and Annual Energy, Daily Wastewater Flows and Electricity with Monthly NG for FY2012 in Denver, CO https://waterdams.nawihub.org/files/3/DenverCO.zip
57 Daily Drinking Water Flows and Monthly Wastewater Flows for FY2012 in Corpus Christi, TX https://waterdams.nawihub.org/files/3/CorpusChristiTX.zip
57 Monthly Drinking Water and Energy, Daily Wastewater Flows with Monthly Energy for FY2012 in Dallas, TX https://waterdams.nawihub.org/files/3/DallasTX.zip
57 Daily Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Columbus, OH https://waterdams.nawihub.org/files/3/ColumbusOH.zip
57 Daily Drinking Water and Wastewater Flows and Monthly Energy for FY2012 in Dayton, OH https://waterdams.nawihub.org/files/3/DaytonOH.zip
57 Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Columbia, SC https://waterdams.nawihub.org/files/3/ColumbiaSC.zip
57 Monthly Drinking Water Flows and Energy, Daily Wastewater Flows, Monthly Wastewater Energy for FY2012 in Colorado Springs, CO https://waterdams.nawihub.org/files/3/ColoradoSpringsCO.zip
57 Monthly Drinking Water, Daily Wastewater (flows and electric) for FY2012 in Cincinnati, OH https://waterdams.nawihub.org/files/3/CincinnatiOH.zip
57 Daily Drinking Water and Wastewater Flows, Monthly Energy for FY2012 in Cleveland, OH https://waterdams.nawihub.org/files/3/ClevelandOH.zip
57 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 https://waterdams.nawihub.org/files/3/ChicagoIL.zip
57 Annual Drinking Water and Wastewater Flows and Energy for FY2012 in Charlotte, NC https://waterdams.nawihub.org/files/3/CharlotteNC.zip
57 Daily Wastewater Flow, Monthly Energy for FY2012 in Charleston, WV https://waterdams.nawihub.org/files/3/CharlestonWV.zip
57 Monthly Drinking Water and Wastewater Flows for FY2012 in Cheyenne, WY https://waterdams.nawihub.org/files/3/CheyenneWY.zip
57 Daily Wastewater Flow and Electricity for FY2012 in Burlington, VT https://waterdams.nawihub.org/files/3/BurlingtonVT.zip
57 Annual Drinking Water Volume (no energy), Daily Wastewater Flows (Monthly Energy) for FY2012 in Charleston, SC https://waterdams.nawihub.org/files/3/CharlestonSC.zip
57 Daily Wastewater Flow and Natural Gas, Monthly Electricity and Biogas for FY2012 in Buffalo, NY https://waterdams.nawihub.org/files/3/BuffaloNY.zip
57 Monthly Drinking Water, Daily Wastewater (flows and electric) for FY2012 in Boston, MA https://waterdams.nawihub.org/files/3/BostonMA.zip
57 Daily Wastewater Flow, Monthly Energy for FY2012 in Bridgeport, CT https://waterdams.nawihub.org/files/3/BridgeportCT.zip
57 Monthly Drinking Water Flows and Energy for FY2012 in Birmingham, AL https://waterdams.nawihub.org/files/3/BirminghamAL.zip
57 Monthly Wastewater Flows and Energy for FY2012 in Boise, ID https://waterdams.nawihub.org/files/3/BoiseID.zip
57 Annual Drinking Water and Wastewater Data for FY2012 in Baltimore, MD https://waterdams.nawihub.org/files/3/BaltimoreMD.zip
57 Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Beaumont, TX https://waterdams.nawihub.org/files/3/BeaumontTX.zip
57 Daily Wastewater Flows, Monthly Drinking Water Flows and Energy for FY2012 in Bakersfield, CA https://waterdams.nawihub.org/files/3/BakersfieldCA.zip
57 Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Billings, MT https://waterdams.nawihub.org/files/3/BillingsMT.zip
57 Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Austin, TX https://waterdams.nawihub.org/files/3/AustinTX.zip
57 Monthly Drinking Water Flows and Energy for FY2012 in Alexandria, VA https://waterdams.nawihub.org/files/3/AlexandriaVA.zip
57 Monthly Drinking Water and Wastewater Flows and Energy for FY2012 in Anchorage, AK https://waterdams.nawihub.org/files/3/AnchorageAk.zip
47 Overall readme to reference with the data included in the submission. https://waterdams.nawihub.org/files/3/Overall_READ-ME.txt
57 Drinking Water and Wastewater Flows and Energy for FY2012 in Albuquerque, NM https://waterdams.nawihub.org/files/3/AlbuquerqueNM.zip
57 Annual Drinking Water Flows and Energy for FY2015; Annual Wastewater Flows and Energy for FY2012 in Albany, NY https://waterdams.nawihub.org/files/3/AlbanyNY.zip
57 Annual Drinking Water and Wastewater Flows; Annual Wastewater Electricity for FY2012 in Amarillo, TX https://waterdams.nawihub.org/files/3/AmarilloTX.zip
21 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. https://www.hydroshare.org/resource/df04c29d0ff64de0ace2d29145dd7680/
33 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 https://waterdams.nawihub.org/files/3/2017WR022265.pdf
33 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 https://waterdams.nawihub.org/files/3/%28ASCE%29WR.1943-5452.0000739.pdf

Tags

  • desalination
  • water-treatment
  • utility
  • wastewater
  • electricity
  • urban
  • drinking-water
  • energy-water-nexus
  • flow
  • industrial
  • biogas
  • nawi
  • reuse
  • water
  • energy

Topics

Categories