Link back to NH/Vt home page
Water Resources of New Hampshire and Vermont

 

User's Manual for the New England
Water-Use Data System (NEWUDS)

Open-File Report 01-328


By Marilee A. Horn

Image of the Cover of User's Manual for the New England Water-Use Data System (NEWUDS)

Abstract

Water is used in a variety of ways that need to be understood for effective management of water resources. Water-use activities need to be categorized and included in a database management system to understand current water uses and to provide information to water-resource management policy decisionmakers.

The New England Water-Use Data System (NEWUDS) is a complex database developed to store water-use information that allows water to be tracked from a point of water-use activity (called a "Site"), such as withdrawal from a resource (reservoir or aquifer), to a second Site, such as distribution to a user (business or irrigator). NEWUDS conceptual model consists of 10 core entities: system, owner, address, location, site, data source, resource, conveyance, transaction/rate, and alias, with tables available to store user-defined details. Three components--site (with both a From Site and a To Site), a conveyance that connects them, and a transaction/rate associated with the movement of water over a specific time interval form the core of the basic NEWUDS network model.

The most important step in correctly translating real-world water-use activities into a storable format in NEWUDS depends on choosing the appropriate sites and linking them correctly in a network to model the flow of water from the initial From Site to the final To Site. Ten water-use networks representing real-world activities are described--three withdrawal networks, three return networks, two user networks, two complex community-system networks. Ten case studies of water use, one for each network, also are included in this manual to illustrate how to compile, store, and retrieve the appropriate data.

The sequence of data entry into tables is critical because there are many foreign keys. The recommended core entity sequence is (1) system, (2) owner, (3) address, (4) location, (5) site, (6) data source, (7) resource, (8) conveyance, (9) transaction, and (10) rate; with (11) alias and (12) user-defined detail subject areas populated as needed. After each step in data entry, quality-assurance queries should be run to ensure the data are correctly entered so that it can be retrieved accurately. The point of data storage is retrieval. Several retrieval queries that focus on retrieving only relevant data to specific questions are presented in this manual as examples for the NEWUDS user.


Availability

This report is presented in Portable Document Format (PDF).
To view and print report you need to use Adobe Acrobat Reader, available as freeware.

Users with visual disabilities can visit this site for conversion tools and information to help make PDF files accessible.

Outside Cover (3.29 MB) --1 page
Inside Cover (37 KB) --2 pages
Table of Contents(TOC) (38 KB) --4 pages
Body of Report (3.42 MB) --47 pages
Appendix 1(TOC) (44 KB) --4 pages
Appendix 1 Body (4.85 MB) --124 pages
Appendix 2(TOC) (23 KB) --1 pages
Appendix 2 Body (17.85 MB) --158 pages
Appendix 3(TOC) (95 KB) --3 pages
Appendix 3 Body (181 KB) --33 pages
Glossary (85 KB) --5 pages

The report citation, in USGS format, is as follows:
Horn, M.A., 2003, User's Manual for the New England Water-Use Data System (NEWUDS): U. S. Geological Survey Open-File Report 01-328, 392 p.

Also available is a companion report for NEWUDS:
Data Model and Relational Database Design for the New England Water-Use Data System (NEWUDS)
Open-File Report 01-359

Plate showing the NEWUDS database structure.


USGS Home Water Climate Change Core Science Ecosystems Energy and Minerals Env. Health Hazards

Accessibility FOIA Privacy Policies and Notices

Take Pride in America logo USA.gov logo U.S. Department of the Interior | U.S. Geological Survey
URL: http://nh.water.usgs.gov/Publications/OFR01-328/index.html
Page Contact Information:
Page Last Modified: Thursday, 26-Mar-2015 14:43:17 EDT