USGS

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

Open-File Report 01-328

By Marilee A. Horn

The full report is available in pdf. ONLINE ONLY

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.

TABLE OF CONTENTS

 

Abstract

Introduction

Purpose and Scope

Acknowledgments

NEWUDS Conceptual Model

System

Owner

Address

Location

Site

DataSources

Resource

Conveyance

Transaction/Rate

Alias

User-Defined Detail

Modeling Water-Use Activities

Withdrawal Networks

Withdrawal and Use by a Single User (Network 1)

Withdrawal and Use by an Aggregate of Users (Network 2)

Withdrawal and Distribution by a Simple Community-Water System (Network 3)

Return Networks

Use and Return by a Single User (Network 4)

Use and Return by an Aggregate of Users (Network 5)

Collection and Return by a Simple Community-Wastewater System (Network 6)

User Networks

Withdrawal, Use, and Return by a Simple User (Network 7)

Withdrawal, Distribution from a Community-Water System, Use, Collection to a
Community-Wastewater System, and Return by a Complex User (Network 8)

Complex Community System Networks

Withdrawal and Regional and Local Distribution by a Complex Community-Water System
(Network 9)

Regional and Local Collection and Return by a Complex Community-Wastewater System
(Network 10)

Entering or Transferring Data Into NEWUDS

Required Data Set

Data Compilation

Data Entry Sequence

Create Systems

Establish Ownership and Address

Establish Location

Describe Site

Link to Resource

Link Sites Through Conveyances

Establish Transaction

Establish Rate

Enter Aliases for Sites

Retrievals

Location-Owner-SiteType Query

Owner-Site-Resource Query

Withdrawals-and-Returns-by-Resource Query

Conveyance-Description Query

Summary and Conclusions

References Cited

Glossary

Appendix 1. Case Studies

Appendix 2. Domain Tables

Appendix 3. Worksheets and Input Forms

APPENDIX 1 CASE STUDIES

Appendix 1: Case Studies

Purpose

Organization

Case 1: Withdrawal and Use by a Single User (MSS1)

Case 2: Withdrawal and Use by an Aggregate of Users (Aggregate Use-MCD)

Case 3: Withdrawal and Distribution by a Simple Community-Water System (CWS1)

Case 4: Use and Return by a Single User (MSS2)

Case 5: Use and Return by an Aggregate of Users (Aggregate User-HUC)

Case 6: Collection and Return by a Simple Community-Wastewater System (WTP1)

Case 7: Withdrawal, Use, and Return by a Simple User (MSS1)

Case 8: Withdrawal, Distribution from a Community-Water System, Use, Collection to a
Community-Wastewater System, and Return by a Complex User (MCU1)

Case 9: Withdrawal and Regional and Local Distribution by a Complex Community-Water
System (CWS1, CWS2)

Case 10: Regional and Local Collection and Return by a Complex Community-Wastewater
System (WTP1, WTP2)

APPENDIX 2 TABLES - NEWUDS Domain Table Listings by Subject Area

Table 1. Site Domain tdsSiteTypeCategory

Table 2. Site Domain tdsSiteTypeSubcategory

Table 3. Site Domain tdsSiteType

Table 4. Site Domain tdsUSGSUseType

Table 5. Site Domain tdsNEUseType

Table 6. Site Domain tdsSIC

Table 7. Site Domain tdsNAICS

Table 8. Site Domain tdxSystem

Table 9. Site Domain tdxSystemType

Table 10. Site Domain tdxSiteDetailCategory

Table 11. Site Domain tdxSiteDetailLabel

Table 12. Conveyance Domain tdsConveyanceType

Table 13. Conveyance Domain tdxConveyanceDetailLabel

Table 14. Conveyance Domain tdsConveyanceActionCategory

Table 15. Conveyance Domain tdsConveyanceAction

Table 16. Transaction/Rate Domain tdsRateUnitDecimal

Table 17. Transaction/Rate Domain tdsRateUnitVolume

Table 18. Transaction/Rate Domain tdsRateUnitTime

Table 19. Transaction/Rate Domain tdxRateUnit

Table 20. Transaction/Rate Domain tdsTimeInterval

Table 21. Transaction/Rate Domain tdxStaff

Table 22. Transaction/Rate Domain tdxRateDetailLabel

Table 23. Transaction/Rate Domain tdxRateMethodCategory

Table 24. Transaction/Rate Domain tdxRateMethod

Table 25. Location Domain tdsLocation Scale

Table 26. Location Domain tdxLocationDetMethod

Table 27. Location Domain tdsHUC

Table 28. Location Domain tdsStateBasin

Table 29. Location Domain tdsState

Table 30. Location Domain tdsCounty

Table 31. Location Domain tdsMCD

Table 32. Resource Domain tdsResourceType

Table 33. Resource Domain tdsWaterBodyType

Table 34. Resource Domain tdxResourceDetailLabel

Table 35. Miscellaneous Domain tdsAddress Type

Table 36. Miscellaneous Domain tdsOwnerType

Table 37. Miscellaneous Domain tdxDataSource

Table 38. Miscellaneous Domain tdxAliasLabel

 

APPENDIX 3 FIGURES

Appendix 3_Form 1. Form showing NEWUDS input form for single users

Appendix 3_Form 2a. Form showing explanation of aggregate of users worksheet with formulas and
relations for estimating water use by geographic area

Appendix 3_Form 2b. Form showing worksheet for aggregate of users for estimating water use by
geographic area

Appendix 3_Form 3. Form showing NEWUDS input form for aggregate of users

Appendix 3_Form 4a. Form showing explanation of community system worksheet with formulas and
relation for estimating water use by geographic area with more than one
distribution or collection system

Appendix 3_Form 4b. Form showing worksheet for community systems for estimating water use by
geographic area with more than one distribution or collection system

Appendix 3_Form 5. Form showing worksheet for recording and estimating water use by community-
water systems

Appendix 3_Form 6. Form showing NEWUDS input form for community-water systems

Appendix 3_Form 7. Form showing worksheet for recording and estimating water use by community-
wastewater systems

Appendix 3_Form 8. Form showing NEWUDS input form for community-wastewater systems

Appendix 3_Form 9. Form showing NEWUDS input form for transaction/rate data


For additional information write to:


District Chief
U.S. Geological Survey
New Hampshire/Vermont District
361 Commerce Way
Pembroke, NH 03275-3718
or through our Web site at
http://nh.water.usgs.gov/


 

The text and graphics are presented here in pdf format (print quality):

The full report is available in the following pieces:


The report citation, in USGS format, is as follows:

Horn, M.A., 2002, 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. (pdf is 241MB)


If you have Adobe Acrobat Reader installed on your computer, you may view and/or print the PDF version of this report. If you do not have Acrobat Reader, you may download it here.

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

 


 

FirstGov button  Take Pride in America button