| Abstract: | The New Jersey Water-Transfer Data System (NJWaTr) is a database design for the storage and retrieval of water-use data. NJWaTr can manage data encompassing many facets of water use, including (1) the tracking of various types of water-use activities (withdrawals, returns, transfers, distributions, consumptive-use, wastewater collection, and treatment); (2) the storage of descriptions, classifications and locations of places and organizations involved in water-use activities; (3) the storage of details about measured or estimated volumes of water associated with water-use activities; and (4) the storage of information about data sources and water resources associated with water use. In NJWaTr, each water transfer occurs unidirectionally between two site objects, and the sites and conveyances form a water network. The core entities in the NJWaTr model are site, conveyance, transfer/volume, location, and owner. Other important entities include water resource (used for withdrawals and returns), data source, permit, and alias. Multiple water-exchange estimates based on different methods or data sources can be stored for individual transfers. Storage of user-defined details is accommodated for several of the main entities. Many tables contain classification terms to facilitate the detailed description of data items and can be used for routine or custom data summarization. NJWaTr accommodates 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. Data stored in the NJWaTr structure can be retrieved in user-defined combinations to serve visualization and analytical applications. Users can customize and extend the database, link it to other databases, or implement the design in other relational database applications. |
| Genre: | USGS Numbered Series |
| ProdID: | 53573 |
| Citation Author: | Tessler, Steven |
| Citation Contributing Office: | |
| Citation Datum: | |
| Citation Day: | |
| Citation Edition: | - |
| Citation Editor: | |
| Citation End Page: | |
| Citation Issue: | |
| Citation Keywords: | |
| Citation Language: | ENGLISH |
| Citation Larger Work Title: | |
| Citation LatN: | |
| Citation LatS: | |
| Citation LonE: | |
| Citation LonW: | |
| Citation Month: | |
| Citation No Pagination: | |
| Citation Number Of Pages: | |
| Citation Online Only Flag: | |
| Citation Phsyical Description: | 204 p. |
| Citation Projection: | |
| Citation Public Comments: | |
| Citation Publisher: | |
| Citation Series: | Open-File Report |
| Citation Series Code: | OFR |
| Citation Series Number: | 2003-197 |
| Citation Search Results Text: | Data model and relational database design for the New Jersey Water-Transfer Data System (NJWaTr); 2003; OFR; 2003-197; Tessler, Steven |
| Citation Start Page: | |
| Citation Volume: | |
| Citation Year: | 2003 |
| Type: | citation/reference |
| Text: | Data model and relational database design for the New Jersey Water-Transfer Data System (NJWaTr); 2003; OFR; 2003-197; Tessler, Steven |
| URL (THUMBNAIL): | http://pubs.er.usgs.gov/thumbnails/usgs_thumb.jpg |
| URL (INDEX PAGE): | http://pubs.water.usgs.gov/ofr03197 |
| Date Other: | Tue, 1 Jun 2004 00:00 -0500 |
| Publisher: | |
