Link to USGS home page

Thumbnail of cover and link to full-size cover.

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.

U.S. Department of the Interior, U.S. Geological Survey
Persistent URL:
Page Contact Information: Contact USGS
Last modified: Wednesday, December 07 2016, 06:25:58 PM
FirstGov button  Take Pride in America button