Data Model and Relational Database Design for the New England Water-Use Data System (NEWUDS)Open-File Report 01-359
By Steven Tessler
The New England Water-Use Data System (NEWUDS) is a database for the storage and retrieval of water-use data. NEWUDS can handle data covering many facets of water use, including (1) tracking various types of water-use activities (withdrawals, returns, transfers, distributions, consumptive-use, wastewater collection, and treatment); (2) the description, classification and location of places and organizations involved in water-use activities; (3) details about measured or estimated volumes of water associated with water-use activities; and (4) information about data sources and water resources associated with water use. In NEWUDS, each water transaction occurs unidirectionally between two site objects, and the sites and conveyances form a water network. The core entities in the NEWUDS model are site, conveyance, transaction/rate, location, and owner. Other important entities include water resources (used for withdrawals and returns), data sources, and aliases. Multiple water-exchange estimates can be stored for individual transactions based on different methods or data sources. Storage of user-defined details is accommodated for several of the main entities. Numerous tables containing classification terms facilitate detailed descriptions of data items and can be used for routine or custom data summarization. NEWUDS handles single-user and aggregate-user water-use data, can be used for large or small water-network projects, and is available as a stand-alone Microsoft® Access database structure. Users can customize and extend the database, link it to other databases, or implement the design in other relational database applications.
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.
Obtain the database (zip archive files)
Outside Cover (68 KB) --1 page
Inside Cover (20 KB) --2 pages
Table of Contents (48 KB) --2 pages
Body of Report (868 KB) --70 pages
Appendix 1 (588 KB) --66 pages
Appendix 2 (716 KB) --23 pages
Plate (240 KB) --1 sheet
Whole report (2 MB) --164 pages
The report citation, in USGS format, is as follows:Tessler, Steven, 2002, Data model and relational database design for the New England water-use data system (NEWUDS): U.S. Geological Survey Open-File Report 01-359, 70 p., 1 pl., + 2 appendixes, on 1 CD-ROM.
|AccessibilityFOIAPrivacyPolicies and Notices|
|U.S. Department of the Interior, U.S. Geological Survey
Page Contact Information: Contact USGS
Last modified: Wednesday, December 07 2016, 06:25:58 PM