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.
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
References Cited
Glossary
Appendix 1. Case Studies
Appendix 2. Domain Tables
Appendix 3. Worksheets and Input Forms
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)
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_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.
| AccessibilityFOIAPrivacyPolicies and Notices | |
  |
|