NWDTW 2024

The Water Use Data Management Function provides support for water-use data acquisition, review, management, and storage for Water Enterprise water-use data needs. This support includes developing or contributing to water use related policies, technical memos, training, and data review tools. This presentation will give an overview of the Water Use Data Management Function activities; provide an overview of water-use data available to USGS studies and how to access these data; and highlight several national and local water use projects.

The Water Use Data System (WUDS) is the replacement for the current Site-Specific Water Use Data System (SWUDS) database and is being developed under the NWIS Modernization effort. WUDS is planned for release by the end of September 2024, and will include retrieval access to the full Monitoring Location Registry contents and the modernized Permit and Other Identifier tables, as well as all water-use specific data from SWUDS. Batch input will support all water-use data, permits, and other identifiers.

This demo will go over the retrieval and batch-entry workflows and discuss a few of the changes from SWUDS to WUDS.

This presentation will demonstrate the Data Entry and Status tools of the Water Use Toolkit. State agency reported water-use data are provided to USGS staff in many formats. To improve efficiency in entry of data into USGS site-specific water use databases, the Data Entry tool uses several crosswalk tables and translates the state agency provided data into USGS input template format.

The Status tool was developed to allow USGS staff to easily find out what data are in the USGS site-specific water use databases. This tool provides graphs, maps, and counts of the number of water use sites and the category of water use, and the number of monthly and annual data values for the country and by state. A Tableau dashboard allows users to filter by date, category, and state, and is useful for identifying available water-use data for studies with different spatial and temporal extents.

The Water Use Toolkit is a new USGS multiple component tool that was designed to improve efficiency in entering site-specific water-use data, avoid duplication of sites, and provide graphical interfaces for reviewing water quantity data in USGS databases.

This presentation will demonstrate the Site Comparison tool of the Water Use Toolkit. Each year, USGS staff create and enter large numbers of new water use sites in order to enter site-specific water use data into USGS databases. Limited site information from the source agency can make it difficult to determine if a site already exists in USGS databases. The Site Comparison tool was developed to compare source agency information with current NWIS site information. The tool allows the user to select different data components for comparison, such as name, latitude and longitude, etc. and outputs a likely match score table for the user to evaluate. This tool also has application to any new site creation in NWIS, not just water use sites.

The Water Use Toolkit is a new USGS multiple component tool that was designed to improve efficiency in entering site-specific water-use data, avoid duplication of sites, and provide graphical interfaces for reviewing water quantity data in USGS databases.

This presentation will demonstrate the Data Review and Outlier Detection tool of the Water Use Toolkit. State agency reported water-use data often contain erroneous data and outliers, and current USGS water use databases do not have graphical user interfaces for easily reviewing these data. The Data Review and Outlier Detection tool of the Water Use Toolkit allows USGS staff to interactively review time series plots of annual and monthly water-use data, and provides the users a .csv file of potential outliers and data anomalies. The Water Use Toolkit is a new USGS multiple component tool that was designed to improve efficiency in entering site-specific water-use data, avoid duplication of sites, and provide graphical interfaces for reviewing water quantity data in USGS databases.