Release of Aggregate Water-Use Data System To: "DA - All Data General System Administrators" cc: "Wayne B Solley, Chief, BWUI, Reston, VA" , "Robert R Pierce, Hydrologist, Atlanta, GA" , "Todd W Augenstein, Comp Spec, Richmond, VA" , "Howard A Perlman, Hydrologist, Atlanta, GA" Subject: Release of Aggregate Water-Use Data System Date: Tue, 07 May 1996 11:05:39 -0400 From: "Michele Y Crouse, Computer Specialist, Reston, VA" The following memorandum announces the release of version 1.0 of the Aggregate Water-Use Data System (AWUDS). AWUDS has been ported from operation on the PR1ME mini-computers to function on the Data General platform. Follow the instructions appended to the memo to install AWUDS at your site. --------------------------------------------------------------------------- MEMORANDUM TO: District Chiefs FROM: Assistant Chief Hydrologist for Technical Support SUBJECT: Release of the Aggregate Water-Use Data System The purpose of this memorandum is to announce the availability and release of the Aggregate Water-Use Data System (AWUDS) for the Data General. The Office of the National Water Information System (NWIS) has completed the modification and conversion of AWUDS, Release 1.0, from the Prime to the Data General. AWUDS is the data-base software package that is used to input, store, analyze, and report District aggregate water-use data. AWUDS will be used as the official data base for the 1995 national water-use compilation and for the preparation of tables for the 1995 Estimated Use of Water in the United States circular. AWUDS was designed to meet the needs of the National Water-Use Information Program to manage aggregate water-use information. Estimates are stored at the county and 8-digit hydrologic cataloging-unit levels. District water-use project chiefs will electronically transmit their 1995 AWUDS files to the national AWUDS located in the Georgia District for national compilation. The deadline for the 1995 water-use estimates to be submitted to Georgia is December 31, 1996. The AWUDS software is being distributed via the World Wide Web. A copy of this memorandum is being distributed to each System Administrator and Water-Use Project Chief. The System Administrator will receive a copy of the installation instructions that includes information on how to get a copy of AWUDS. This software also will be distributed on the next Water Resources Division software applications (WRDAPP) tape to be released in the next couple of weeks by the Hydrologic Analysis Software Support Team (HASS). Each District needs to identify a data-base administrator to be assigned the responsibilities for AWUDS. The duties of the administrator are as follows: 1.) Move data and support files to and from Georgia. 2.) Create (revise) data files as needed. 3.) Coordinate additional data file conversions (if needed). 4.) Make sure data files are being backed-up. These tasks should take only about 2 to 8 hours spread throughout the year, and it is suggested that the water-use project chief be assigned these duties. Michele Crouse developed the distribution web page. Any queries about this software distribution should be directed to: Michele Crouse U.S. Geological Survey Electronic mail: h2osoft@usgs.gov HASS Team Fax: 703-648-5722 437 National Center Phone: 703-648-5228 Reston, Virginia 22092 Howard Perlman wrote the conversion program of AWUDS from the Prime to the Data General for the Office of the National Water Information System (NWIS). For questions on the use of AWUDS contact: Howard Perlman U.S. Geological Survey Electronic mail: hperlman@usgs.gov 3039 Amwiler Road, Suite 13 Fax: 770-903-9199 Atlanta, Georgia 30360-2824 Phone: 770-903-9114 Todd Augenstein is the manager of the water-use data bases for the NWIS office. He is working on the design of the Site-Specific Water-Use Data System (SSWUDS) and is coordinating the AWUDS conversion. General water-use software questions should be directed to: Todd Augenstein U.S. Geological Survey Electronic mail: twaugens@usgs.gov 3600 West Broad Street, Fax: 804-278-4759 Room 606 Phone: 804-278-4750-225 Richmond, Virginia 23230 --------------------------------------------------------------------------- AWUDS Aggregate Water-Use Data System Installation Instructions awuds1.0.tar.gz - Distribution prepared on a Data General AViiON under DG/UX 5.4 TABLE OF CONTENTS A. DESCRIPTION B. INSTALLING AWUDS C. DOCUMENTATION D. CONTACTS A. DESCRIPTION AWUDS is a data-base management system used for the entry, editing, storage, retrieval, and analysis of aggregate water-use data at the state level. The system stores data for multiple years and can store data for multiple states. AWUDS allows water-use personnel in each state to: (a) enter and edit aggregate data by county and water-resources cataloging unit; (b) create various reports; (c) perform quality-assurance procedures on the data; and (d) export the data for use in other applications or for information requests by the general public. B. INSTALLING AWUDS (1) AWUDS is installed in the directory /usr/opt/awuds. It is recommended that AWUDS be a separate file system mounted at /usr/opt/awuds. Disk space required to install AWUDS is about 10,174 blocks (5.1 MB) plus the space required to store the state data files at your site. Each District must install the 1985, 1990, and 1995 data for their state and can optionally install data for other states. Also, the AWUDS data-base administrator can install/create data files for other years. Ask the water-use project chief how many states he/she plans on storing and how many years of data they intend to store, including future years. The disk space needed to store each year of data is estimated by multiplying the number of counties and 8-digit hydrologic units found in the state by 2500 bytes. Use the following formula to estimate the disk space needed for each state's data files to be stored: YRS * 2500 * (#_of_counties + #_of_hydrologic_units) where YRS is the number of total number of years of data to be stored. Using Georgia as an example--where there are 159 counties and 52 8-digit hydrologic units--if 2 future years of data are to be stored in addition to 1985, 1990, and 1995, the disk space needed for Georgia's data files is: 5 * 2500 * (159 + 52) = 2,637,500 bytes Dividing the above total by block size (512 K), the number of blocks needed to store Georgia's data is 2,637,500/512 = 5,152 blocks. Thus, if the Georgia District were to install no other state data files than its own, and allow space for storing 2 additional years of data, the total size of /usr/opt/awuds necessary to store both software and data would be 10,174 + 5,152 = 15,326 blocks (7.7 MB). (2) The user account "awudsdba" must be established for use by the AWUDS data-base administrator, typically the water-use project chief. The user identification number (UID) and group identification number (GID) must both be 31906. The account home area should be /usr/opt/awuds. Any password and login shell can be used. For example, if the AWUDS data-base administrator uses the C shell then a line similar to the following should be added to the passwd file: awudsdba::31906:31906:AWUDS DBA:/usr/opt/awuds:/bin/csh Then copy the system '.cshrc' and '.login' files to the /usr/opt/awuds directory. Or, if the AWUDS data-base administrator uses the Korn shell, then a line similar to the following should be added to the passwd file: awudsdba::31906:31906:AWUDS DBA:/usr/opt/awuds:/bin/ksh Then copy the system '.kshrc' and '.login' files to the /usr/opt/awuds directory. Assign a password for the awudsdba account as soon as possible and provide the password to the AWUDS data-base administrator. (3) The account group "awudswr" must be established; only users which are members of the group "awudswr" have write access to AWUDS data files. The group identification number (GID) must be 31906. Ask the water-use project chief which users need write access to AWUDS and assign these users to the "awudswr" group. The group file should contain a line similar to: awudswr::31906:awudsdba,user1,user2 where user1 and user2 are user IDs of users that need write access to AWUDS. (4) AWUDS has been compiled for the Data General AViiON. AWUDS has been tarred and compressed with the gzip utility. A file by the name of 'awuds1.0.tar.gz' can be obtained by selecting "AWUDS compiled for the Data General AViiON" on the following World Wide Web page: http://hassrvares.er.usgs.gov/awuds.html (5) Logged in as root, type the following command; note that the command below will work whether the tar file is compressed or uncompressed: gzcat -f awuds1.0.tar.gz | tar xvf - This creates the following directory structure (the contents of each directory are shown to the right): /usr/opt/awuds ; hidden file needed by servepackage `-----bin ; executable AWUDS programs `-----catman ; AWUDS man page `-----data ; empty; AWUDS state data files to be installed here `-----doc ; AWUDS information and documentation files `-----sbin ; installation scripts `-----support ; files read by the AWUDS programs (6) Make sure directory permissions and user and group ownership are set as follows: $ cd /usr/opt/awuds $ ls -l drwxr-xr-x 2 root root 512 Apr 2 07:08 bin drwxr-xr-x 3 root root 512 Nov 30 09:40 catman drwxr-xr-x 2 awudsdba awudswr 0 Apr 16 14:34 data drwxr-xr-x 2 root root 512 Apr 3 14:49 doc drwxr-xr-x 3 root root 512 Nov 29 18:03 sbin drwxr-xr-x 2 awudsdba root 2560 Apr 16 14:34 support (7) Run asysadm setuppackage to link the executable files to /usr/opt/bin and to link the man page directory to /usr/catman: asysadm setuppackage (Type "awuds" at the "Package Name(s):" prompt.) (8) Run servepackage to install AWUDS on each client workstation: servepackage awuds (9) Have the AWUDS data-base administrator follow the steps listed in the following file: /usr/opt/awuds/doc/dba.instructions (10)Print copies of the AWUDS User's Manual--the FrameMaker file /usr/opt/awuds/doc/awuds.users.manual.doc--for those who will be using AWUDS. Instruct them to follow steps 1-3 of the User Installation Procedure before running AWUDS for the first time. C. DOCUMENTATION The documentation for AWUDS can be found on-line in the /usr/opt/awuds/doc directory. The documentation addresses the following subjects (file names ending in '.doc' are FrameMaker files, the other two files are ASCII): File name ------------------------ Installation Instructions install.instructions Data Base Administrator Instructions dba.instructions AWUDS User's Manual awuds.users.manual.doc Data Dictionary data.dictionary.doc "Expanded" Elements Data Dictionary expanded.dictionary.doc The AWUDS "Data-Collection" Form data.collection.form.doc D. CONTACTS Inquiries about this software distribution should be directed to: U.S. Geological Survey Electronic mail: h2osoft@usgs.gov Hydrologic Analysis Software Support Team Fax: 703-648-5722 Michele Crouse Phone: 703-648-5228 437 National Center Reston, VA 22092 Howard Perlman wrote the conversion program of AWUDS from the Prime to the Data General for the Office of the National Water Information System (NWIS). For questions on the use of AWUDS contact: U.S. Geological Survey Electronic mail: hperlman@usgs.gov Howard Perlman Fax: 770-903-9199 3039 Amwiler Road, Suite 130 Phone: 770-903-9114 Atlanta, GA 30360-2824 Todd Augenstein is the manager of the water-use data bases for the NWIS office. He is working on the design of the Site-Specific Water-Use Data System (SSWUDS) and is coordinating the AWUDS conversion. General water-use software questions should be directed to: U.S. Geological Survey Electronic mail: twaugens@usgs.gov Todd Augenstein Fax: 804-278-4759 3600 West Broad Street, Room 606 Phone: 804-278-4750-225 Richmond, VA 23230