DOI: 10.5066/p9fhvy03
title: Watershed Data Management (WDM) Database (SC19.WDM) for Salt Creek Streamflow Simulation, DuPage County, Illinois, January 1, 1997, through September 30, 2019 (ver. 1.1, September 2024)

description: The watershed data management (WDM) database SC18.WDM is updated with the processed data for the period October 1, 2018, through September 30, 2019. The precipitation data are collected from a tipping-bucket rain-gage network and the hydrologic data (stage and discharge) are collected at USGS streamflow-gaging stations in and around DuPage County, Illinois. Hourly precipitation and hydrologic data for the period October 1, 2018, through September 30, 2019, are processed following the guidelines described in Bera (2014) and Murphy and Ishii (2006) and appended to SC18.WDM and renamed as SC19.WDM. Meteorological data (wind speed, solar radiation, air temperature, dewpoint temperature, and potential evapotranspiration) from October 1, 2018, through September 30, 2019, are copied from ARGN19.WDM and appended to SC19.WDM.

Data in dataset number (DSN) 107 and 801–810 are used in comparisons of precipitation data. DSN 107 contains hourly precipitation data collected at Argonne National Laboratory at Argonne, Illinois. DSN 801-810 contains the processed Next Generation Weather Radar (NEXRAD)-multisensor precipitation estimates (MPE) data from 10 NEXRAD–MPE subbasins in the Salt Creek watershed as described in Bera and Ortel (2018). Data in these DSNs are not quality-assured and quality-controlled. The data are downloaded and uploaded daily into a WDM database that is used for the real-time streamflow simulation system. Data from DSN 107 and 801-810 are copied from this WDM and stored in SC19.WDM. DSN 107 and 801-810 are updated with the data through September 30, 2019. Data in DSN 5400 (water-surface elevation at the quarry) and 5700 (water surface elevation at Thorndale) are updated through September 30, 2019, similarly (Murphy and Ishii, 2006). The WDM database that is used for the real-time streamflow simulation system has added six hourly data series with new dataset numbers 7020-7025. These data series are used for storing the HSPF computed snow variables for snow depth and snow water equivalent. The new data series with the DSN 7020-7025 are added in SC19.WDM similarly and no data is added to any of these data series. The detail of the attributes for each of these data series are given in the table, attribute-table (available in csv format).

Errors have been found in each of ARGNXX.WDM prior to Water Year (WY) 2023. XX represents last two digits of a WY. A WY is the 12-month period, October 1 through September 30, in which it ends. SC19.wdm
contains erroneous meteorological data and related flag values thereby. SC19.WDM is removed. User is advised to download SC22.WDM from https://doi.org/10.5066/P14D6FRA. SC22.WDM contains corrected meteorological data from ARGN23.WDM (Bera, 2024a) for the period from January 1, 1997, through September 30, 2022. This database file also contains the quality-assured and quality-controlled hydrologic data for the period January 1, 1997, through September 30, 2022, processed following the guidelines documented in Bera (2014). While SC19.WDM is available from the author, all the records in SC19.WDM can be found in SC22.WDM as well.

The complete list of missing precipitation data periods and the nearby stations used to fill in those missing periods from October 1, 2018, through September 30, 2019, is given in the table, missing_data.csv. The list of snow affected days of precipitation data and the missing and estimated period of the stage and flow data in SC22.WDM database during the period October 1, 2018, through September 30, 2019, are given in the USGS annual Water Data Report at https://waterdata.usgs.gov/nwis.

To open the WDM database SC22.WDM user needs to install Sara Timeseries utility described in the section "Related External Resources".

First posted - February 26, 2021 (available from author)

Revised - September 2024

References Cited:

Bera, M., 2024a, Meteorological Database, Argonne National Laboratory, Illinois: U.S. Geological Survey data release, https://doi.org/10.5066/P146RBHK.

____ 2024b, Watershed Data Management (WDM) Database (SC22.WDM) for Salt Creek Streamflow Simulation, DuPage County, Illinois, January 1, 1997, through September 30, 2022: U.S. Geological Survey, https://doi.org/10.5066/P14D6FRA.

Bera, M., 2014, Watershed Data Management (WDM) database for Salt Creek streamflow simulation, DuPage County, Illinois, water years 2005–11: U.S. Geological Survey Data Series 870, 18 p., http://dx.doi.org/10.3133/ds870.

Murphy, E.A., and Ishii, A.L., 2006, Watershed Data Management (WDM) database for Salt Creek streamflow simulation, DuPage County, Illinois: U.S. Geological Survey Open-File Report 2006–1248, 34 p.