USGS Science⌕ Search

SEARCH · USGS Science

Results for “Open File”

Search indexed USGS publications on groundwater, aquifers, geologic maps, mineral resources and earthquakes. Explore source records by subject and place.

Quote a phrase for an exact phrase match. Source license links do not imply unrestricted reuse.

At least 1,207 records · Page 67Linked to original sources

Digital Seismic-Reflection Data from Eastern Rhode Island Sound and Vicinity, 1975-1980

During 1975 and 1980, the U.S. Geological Survey (USGS) conducted two seismic-reflection surveys in Rhode Island Sound (RIS) aboard the research vessel Asterias: cruise ASTR75-June surveyed eastern RIS in 1975 and cruise AST-80-6B surveyed southern RIS in 1980. Data from these surveys were recorded in analog form and archived at the USGS Woods Hole Coastal and Marine Science Center's Data Library. In response to recent interest in the geology of RIS and in an effort to make the data more readily accessible while preserving the original paper records, the seismic data from these cruises were scanned and converted to black and white Tagged Image File Format and grayscale Portable Network Graphics images and SEG-Y data files. Navigation data were converted from U.S. Coast Guard Long Range Aids to Navigation time delays to latitudes and longitudes that are available in Environmental Systems Research Institute, Inc., shapefile format and as eastings and northings in space-delimited text format. This report complements two others that contain analog seismic-reflection data from RIS (McMullen and others, 2009) and Long Island and Block Island Sounds (Poppe and others, 2002) and were converted into digital form.

Open-File Report↗

Ground water available in the Davenport area, Oklahoma

This memorandum describes the ground-water resources in the vicinity of Davenport, Lincoln County, Oklahoma. It is based on a one-day trip to Davenport made by the writer on February 11, 1948, to obtain information in addition to that in the ground-water files in Norman on the availability of ground water for public supply or other uses in the Davenport area. Davenport is a town of about 1,000 in east-central Lincoln County, Oklahoma, on U.S. Highway 66, about half way between Oklahoma City and Tulsa. It is in an area of undulating to gently rolling topography underlain by rocks of Pennsylvanian age. The area is drained into Deep Fork of the Canadian River, by Dry Creek and its tributary, Chuckaho Creek.

Oklahoma↗

Geochemical data for samples collected in 2007 near the concealed pebble porphyry Cu-Au-Mo deposit, southwest Alaska

In the summer of 2007, the U.S. Geological Survey (USGS) began an exploration geochemical research study over the Pebble porphyry copper-gold-molydenum (Cu-Au-Mo) deposit in southwest Alaska. The Pebble deposit is extremely large and is almost entirely concealed by tundra, glacial deposits, and post-Cretaceous volcanic and volcaniclastic rocks. The deposit is presently being explored by Northern Dynasty Minerals, Ltd., and Anglo-American LLC. The USGS undertakes unbiased, broad-scale mineral resource assessments of government lands to provide Congress and citizens with information on national mineral endowment. Research on known deposits is also done to refine and better constrain methods and deposit models for the mineral resource assessments. The Pebble deposit was chosen for this study because it is concealed by surficial cover rocks, it is relatively undisturbed (except for exploration company drill holes), it is a large mineral system, and it is fairly well constrained at depth by the drill hole geology and geochemistry. The goals of the USGS study are (1) to determine whether the concealed deposit can be detected with surface samples, (2) to better understand the processes of metal migration from the deposit to the surface, and (3) to test and develop methods for assessing mineral resources in similar concealed terrains. This report presents analytical results for geochemical samples collected in 2007 from the Pebble deposit and surrounding environs. The analytical data are presented digitally both as an integrated Microsoft 2003 Access? database and as Microsoft 2003 Excel? files. The Pebble deposit is located in southwestern Alaska on state lands about 30 km (18 mi) northwest of the village of Illiamna and 320 km (200 mi) southwest of Anchorage (fig. 1). Elevations in the Pebble area range from 287 m (940 ft) at Frying Pan Lake just south of the deposit to 1146 m (3760 ft) on Kaskanak Mountain about 5 km (5 mi) to the west. The deposit is in an area of relatively subdued topographic relief with an elevation of around 300 m (1000 ft). This portion of Alaska is part of the subarctic regime mountains division, Yukon intermontane plateaus-tayga-meadow province ecoregion, as defined by Bailey (U.S. Forest Service, 2007). Between June 28th and July 12th, 2007, scientists from the USGS collected soil, water, stream sediment, vegetation, heavy-mineral concentrate, till, and rock samples from the deposit area. This report contains analytical results for soil, water, stream sediment, and vegetation samples. Analyses for the heavy-mineral concentrate, till, and rock samples are still in progress. The sampling was undertaken during relatively dry and stable weather conditions. Only minor scattered rain showers occurred during the sampling period, so surface conditions were largely unaffected by weather. The predominant sample media collected were soils and surface waters. Soil and water (mostly from ponds and springs, some from small creeks) samples were collected along a single 7.8 km-long (4.8 mi) east-west traverse across the Pebble East and Pebble West zones and from more distal background areas around Koktuli and Kaskanak Mountains. Sample sites are shown on figure 2 and plate 1, and locality coordinates are provided in the accompanying Access and Excel files named FieldSite. Water samples were analyzed by USGS laboratories with one subset analyzed by Activation Laboratories (Actlabs), as indicated below. Soils and stream sediments were analyzed for their total content by SGS Minerals Services under a contract with the USGS. Soil samples were also leached by selected partial-extraction leaching procedures and then analyzed by several commercial laboratories, as described below. Vegetation samples were analyzed as indicated below.

Alaska↗

Hydrogeology of the Islamic Republic of Mauritania

Hydrogeologic maps were constructed for the Islamic Republic of Mauritania. The ground-water flow system in the country can best be described as two interconnected regional systems: the porous Continental Terminal coastal system and the interior, fractured sedimentary Taoudeni Basin system. In these systems, ground-water flow occurs in fill deposits and carbonate, clastic, metasedimentary, and metavolcanic rocks. Based on an evaluation of the potentiometric surface, there are three areas of ground-water recharge in the Taoudeni Basin system. One region occurs in the northwest at the edge of the Shield, one occurs to the south overlying the Tillites, and one is centered at the city of Tidjikdja. In contrast to the flow system in the Taoudeni Basin, the potentiometric surfaces reveal two areas of discharge in the Continental Terminal system but no localized recharge areas; the recharge is more likely to be areal. In addition to these recharge and discharge areas, ground water flows across the country's borders. Specifically, ground water from the Atlantic Ocean flows into Mauritania, transporting dissolved sodium from the west as a salt water intrusion, whereas fresh ground water discharges from the east into Mali. To the north, there is a relatively low gradient with inflow of fresh water to Mauritania, whereas ground-water flow discharges to the Senegal River to the south. A geographical information system (GIS) was used to digitize, manage, store, and analyze geologic data used to develop the hydrogeologic map. The data acquired for map development included existing digital GIS files, published maps, tabulated data in reports and public-access files, and the SIPPE2 Access database. Once in digital formats, regional geologic and hydrologic features were converted to a common coordinate system and combined into one map. The 42 regional geologic map units were then reclassified into 13 hydrogeologic units, each having considerable lateral extent and distinct hydrologic properties. Because the hydrologic properties of these units are also influenced by depth and degree of fracturing, the hydraulic conductivity values of these hydrogeologic units can range over many orders of magnitude.

Open-File Report↗

Geologic map and digital database of the Porcupine Wash 7.5 minute Quadrangle, Riverside County, southern California

This data set maps and describes the geology of the Porcupine Wash 7.5 minute quadrangle, Riverside County, southern California. The quadrangle, situated in Joshua Tree National Park in the eastern Transverse Ranges physiographic and structural province, encompasses parts of the Hexie Mountains, Cottonwood Mountains, northern Eagle Mountains, and south flank of Pinto Basin. It is underlain by a basement terrane comprising Proterozoic metamorphic rocks, Mesozoic plutonic rocks, and Mesozoic and Mesozoic or Cenozoic hypabyssal dikes. The basement terrane is capped by a widespread Tertiary erosion surface preserved in remnants in the Eagle and Cottonwood Mountains and buried beneath Cenozoic deposits in Pinto Basin. Locally, Miocene basalt overlies the erosion surface. A sequence of at least three Quaternary pediments is planed into the north piedmont of the Eagle and Hexie Mountains, each in turn overlain by successively younger residual and alluvial deposits. The Tertiary erosion surface is deformed and broken by north-northwest-trending, high-angle, dip-slip faults and an east-west trending system of high-angle dip- and left-slip faults. East-west trending faults are younger than and perhaps in part coeval with faults of the northwest-trending set. The Porcupine Wash database was created using ARCVIEW and ARC/INFO, which are geographical information system (GIS) software products of Envronmental Systems Research Institute (ESRI). The database consists of the following items: (1) a map coverage showing faults and geologic contacts and units, (2) a separate coverage showing dikes, (3) a coverage showing structural data, (4) a scanned topographic base at a scale of 1:24,000, and (5) attribute tables for geologic units (polygons and regions), contacts (arcs), and site-specific data (points). The database, accompanied by a pamphlet file and this metadata file, also includes the following graphic and text products: (1) A portable document file (.pdf) containing a navigable graphic of the geologic map on a 1:24,000 topographic base. The map is accompanied by a marginal explanation consisting of a Description of Map and Database Units (DMU), a Correlation of Map and Database Units (CMU), and a key to point-and line-symbols. (2) Separate .pdf files of the DMU and CMU, individually. (3) A PostScript graphic-file containing the geologic map on a 1:24,000 topographic base accompanied by the marginal explanation. (4) A pamphlet that describes the database and how to access it. Within the database, geologic contacts , faults, and dikes are represented as lines (arcs), geologic units as polygons and regions, and site-specific data as points. Polygon, arc, and point attribute tables (.pat, .aat, and .pat, respectively) uniquely identify each geologic datum and link it to other tables (.rel) that provide more detailed geologic information.

California↗

Geologic map and digital database of the Conejo Well 7.5 minute quadrangle, Riverside County, southern California

This data set maps and describes the geology of the Conejo Well 7.5 minute quadrangle, Riverside County, southern California. The quadrangle, situated in Joshua Tree National Park in the eastern Transverse Ranges physiographic and structural province, encompasses part of the northern Eagle Mountains and part of the south flank of Pinto Basin. It is underlain by a basement terrane comprising Proterozoic metamorphic rocks, Mesozoic plutonic rocks, and Mesozoic and Mesozoic or Cenozoic hypabyssal dikes. The basement terrane is capped by a widespread Tertiary erosion surface preserved in remnants in the Eagle Mountains and buried beneath Cenozoic deposits in Pinto Basin. Locally, Miocene basalt overlies the erosion surface. A sequence of at least three Quaternary pediments is planed into the north piedmont of the Eagle Mountains, each in turn overlain by successively younger residual and alluvial deposits. The Tertiary erosion surface is deformed and broken by north-northwest-trending, high-angle, dip-slip faults in the Eagle Mountains and an east-west trending system of high-angle dip- and left-slip faults. In and adjacent to the Conejo Well quadrangle, faults of the northwest-trending set displace Miocene sedimentary rocks and basalt deposited on the Tertiary erosion surface and Pliocene and (or) Pleistocene deposits that accumulated on the oldest pediment. Faults of this system appear to be overlain by Pleistocene deposits that accumulated on younger pediments. East-west trending faults are younger than and perhaps in part coeval with faults of the northwest-trending set. The Conejo Well database was created using ARCVIEW and ARC/INFO, which are geographical information system (GIS) software products of Envronmental Systems Research Institute (ESRI). The database consists of the following items: (1) a map coverage showing faults and geologic contacts and units, (2) a separate coverage showing dikes, (3) a coverage showing structural data, (4) a point coverage containing line ornamentation, and (5) a scanned topographic base at a scale of 1:24,000. The coverages include attribute tables for geologic units (polygons and regions), contacts (arcs), and site-specific data (points). The database, accompanied by a pamphlet file and this metadata file, also includes the following graphic and text products: (1) A portable document file (.pdf) containing a navigable graphic of the geologic map on a 1:24,000 topographic base. The map is accompanied by a marginal explanation consisting of a Description of Map and Database Units (DMU), a Correlation of Map and Database Units (CMU), and a key to point-and line-symbols. (2) Separate .pdf files of the DMU and CMU, individually. (3) A PostScript graphic-file containing the geologic map on a 1:24,000 topographic base accompanied by the marginal explanation. (4) A pamphlet that describes the database and how to access it. Within the database, geologic contacts , faults, and dikes are represented as lines (arcs), geologic units as polygons and regions, and site-specific data as points. Polygon, arc, and point attribute tables (.pat, .aat, and .pat, respectively) uniquely identify each geologic datum and link it to other tables (.rel) that provide more detailed geologic information.

California↗

Water-quality data from oil and gas wells in part of the Permian Basin, southeastern New Mexico and western Texas

Approximately 8,000 chemical analyses of water produced from formations of several geologic ages in south eastern New Mexico and western Texas are tabulated by both geographic location and geologic formation. Empirical and mathematical relationships between (1) the dissolved solids and the measured and computed resistivity of water, the chloride-ion concentration and the density, and (2) the concentration of chloride-ion and the density and the resistivity of water, were established. Resistivities of water computed following a method developed by Moore, Szasz, and Whitney (1966) using the concentration of the six most common constituents dissolved in natural water correlate favorably with the measured resistivities of natural water. The water analyses were obtained chiefly from oil companies and oil-service companies operating in the western part of the Permian basin. The data were associated with the proper well by searching location, operator, and reference number cross indexes prepared from the Permian Basin Well Data System files. The cross indexes were determined to be essential to efficient data processing operations. After preliminary screening for nonrepresentative data, all data were indexed to the Permian Basin Well Data System magnetic tape file scout records by the unique reference number. The data were then coded, punched into tabulating cards, and stored on magnetic tape for computer operations. Data verification steps not normally required when using data received from a laboratory following standardized analytical techniques on samples obtained under standardized and controlled procedures were performed in order to upgrade reliability of the information. Data errors detected included poorly located or identified samples; mistakes including reproducing, or key punching; laboratory errors; inconsistent reporting; and nonrepresentative or contaminated samples.

New Mexico, Texas↗

Streamflow and cross-section data for the Tombigbee River between Aliceville and Gainesville locks and dams

A review of records and historical research of floods for the Tombigbee River near Cochrane, Alabama, show that the flood of 1892 was the highest since 1818. In 1962 the U.S. Army Corps of Engineers estimated a peak discharge of 235,000 cu ft/sec for this flood. This estimated discharge is more than 40% > the next highest flood peak; that of 1973. Limit curves developed for the tailwater of Aliceville Lock and Dam, based on 61 computed discharge and 24 discharge measurements, show the range in stage for a given discharge at this site. Similarly, limit curves developed for Gainesville Lock and Dam pool were developed based on 49 computed discharges and 10 mean daily discharges. Data from hydrographic surveys that were made for more than 100 ranges in 1937 and 1971 are on file with the U.S. Army Corps of Engineers. Presently 49 sedimentation ranges between Aliceville Lock and Dam and Gainesville Lock and Dam are surveyed routinely. Comparison of these and other data may be made to identify changes occurring along this reach of the river as a result of natural and man-made causes. These and other hydrologic data collected along the reach of the Tombigbee River between Aliceville Lock and Dam and Gainesville Lock and Dam are presented in tables. (USGS)

Open-File Report↗

A literature survey of information on well installation and sample collection procedures used in investigations of ground-water contamination by organic compounds

A survey of literature on well installation and water-quality sampling, particularly as they relate to investigations of ground-water contamination by organic compounds, has been conducted. Library card files and computerized data bases were searched to identify journal articles, conference proceedings, technical reports, books, and other publications. Pertinent information has been extracted from 105 references; each reference is listed in a bibliography. Material contained in the report is organized by topical categories that include drilling methods and equipment, well construction, well development, sampling materials and equipment, decontamination of equipment, and sampling techniques and procedures. Unpublished data of the U.S. Geological Survey on sample collection are briefly cited also.

Open-File Report↗

Environmental flow allocation and statistics calculator

The Environmental Flow Allocation and Statistics Calculator (EFASC) is a computer program that calculates hydrologic statistics based on a time series of daily streamflow values. EFASC will calculate statistics for daily streamflow in an input file or will generate synthetic daily flow series from an input file based on rules for allocating and protecting streamflow and then calculate statistics for the synthetic time series. The program reads dates and daily streamflow values from input files. The program writes statistics out to a series of worksheets and text files. Multiple sites can be processed in series as one run. EFASC is written in MicrosoftRegistered Visual BasicCopyright for Applications and implemented as a macro in MicrosoftOffice Excel 2007Registered. EFASC is intended as a research tool for users familiar with computer programming. The code for EFASC is provided so that it can be modified for specific applications. All users should review how output statistics are calculated and recognize that the algorithms may not comply with conventions used to calculate streamflow statistics published by the U.S. Geological Survey.

Open-File Report↗

User's guide for U.S. Geological Survey rainfall-runoff models; revised 1977

Modified versions of the rainfall-runoff model described by Dawdy, Lichty, and Bergmann (1972) (see W72-11754) are used in the U.S. Geological Survey as a means of synthesizing flood discharges for small drainage areas. Synthesized flood discharges derived through use of long-term (60-70 year) rainfall and evaporation data, provide a more representative time base than do short-term (5-15 year) discharge records obtained by conventional stream gaging techniques. The rainfall, discharge, and evaporation data for use with rainfall-runoff models are stored in the Unit and Daily Values Files. Any of these data which were collected during the current or immediately preceding water year are stored on direct access, online disk files. Older data are stored in sequential files on magnetic tapes. Both the disks and tapes contain short-term data collected by the U.S. Geological Survey for calibration of models and long-term data for use in synthesis of long-term flood records. Information in this report provides guidelines for the assembly, storage, and retrieval of data needed to use these models, and also provides description and documentation of computer programs for model calibration and flood-record synthesis. (See also W74-11234) (Woodard-USGS)

Open-File Report↗

A compilation of ground water quality data for Kentucky

This report provides most of the data in the files of the U.S. Geological Survey on the quality of groundwater in Kentucky. All analyses through 1979 are included except for some special purpose repetitive analyses and some with a very limited number of constituents. County location maps are included with the analyses. These include location, distribution, and density of sampling sites in each county. Most of the data in this report resulted from cooperative studies made with the Kentucky Geological Survey and with other Federal, State, and local agencies. (USGS)

Open-File Report↗

Selected micrometeorological and soil-moisture data at Amargosa Desert Research Site in Nye County near Beatty, Nevada, 1998-2000

Selected micrometeorological and soil-moisture data were collected at the Amargosa Desert Research Site adjacent to a low-level radioactive waste and hazardous chemical waste facility near Beatty, Nev., 1998-2000. Data were collected in support of ongoing research studies to improve the understanding of hydrologic and contaminant-transport processes in arid environments. Micrometeorological data include precipitation, air temperature, solar radiation, net radiation, relative humidity, ambient vapor pressure, wind speed and direction, barometric pressure, soil temperature, and soil-heat flux. All micrometeorological data were collected using a 10-second sampling interval by data loggers that output daily mean, maximum, and minimum values, and hourly mean values. For precipitation, data output consisted of daily, hourly, and 5-minute totals. Soil-moisture data included periodic measurements of soil-water content at nine neutron-probe access tubes with measurable depths ranging from 5.25 to 29.75 meters. The computer data files included in this report contain the complete micrometeorological and soil-moisture data sets. The computer data consists of seven files with about 14 megabytes of information. The seven files are in tabular format: (1) one file lists daily mean, maximum, and minimum micrometeorological data and daily total precipitation; (2) three files list hourly mean micrometeorological data and hourly precipitation for each year (1998-2000); (3) one file lists 5-minute precipitation data; (4) one file lists mean soil-water content by date and depth at four experimental sites; and (5) one file lists soil-water content by date and depth for each neutron-probe access tube. This report highlights selected data contained in the computer data files using figures, tables, and brief discussions. Instrumentation used for data collection also is described. Water-content profiles are shown to demonstrate variability of water content with depth. Time-series data are plotted to illustrate temporal variations in micrometeorological and soil-water content data. Substantial precipitation at the end of an El Ni?o cycle in early 1998 resulted in measurable water penetration to a depth of 1.25 meters at one of the four experimental soil-monitoring sites.

Nevada↗

SEGY to ASCII: Conversion and Plotting Program

This report documents a computer program to convert standard 4 byte, IBM floating point SEGY files to ASCII xyz format. The program then optionally plots the seismic data using the GMT plotting package. The material for this publication is contained in a standard tar file (of99-126.tar) that is uncompressed and 726 K in size. It can be downloaded by any Unix machine. Move the tar file to the directory you wish to use it in, then type 'tar xvf of99-126.tar' The archive files (and diskette) contain a NOTE file, a README file, a version-history file, source code, a makefile for easy compilation, and an ASCII version of the documentation. The archive files (and diskette) also contain example test files, including a typical SEGY file along with the resulting ASCII xyz and postscript files. Requirements for compiling the source code into an executable are a C++ compiler. The program has been successfully compiled using Gnu's g++ version 2.8.1, and use of other compilers may require modifications to the existing source code. The g++ compiler is a free, high quality C++ compiler and may be downloaded from the ftp site: ftp://ftp.gnu.org/gnu Requirements for plotting the seismic data is the existence of the GMT plotting package. The GMT plotting package may be downloaded from the web site: http://www.soest.hawaii.edu/gmt/

Open-File Report↗

Annotated bibliography of selected references on PCB and the Kalamazoo River Superfund Site, Michigan, 1982-2002

Fifty six publications pertaining to the Kalamazoo River Superfund Site Publications stored in the Michigan Department of Environmental Quality Environmental Response Division site files are summarized. Publications are presented chronologically within four categories: PCB releases, PCB remediation, PCB safety, and PCB testing and cleanup. The text consists of bibliographical information and brief summaries of various published documents pertaining to PCB contamination of the Kalamazoo River. Numerous investigators such as the Michigan Department of Natural Resources, Georgia Pacific, and various contractors have demonstrated that multiple and at times continuous releases and re-releases of PCBs have occurred as a result of operations at papermill facilities owned and operated by the 'Potential Responsible Parties'.

Michigan↗

Planning and design of studies for river-quality assessment in the Truckee and Carson River basins, California and Nevada

The objectives of the Geological Survey 's river-quality assessment in the Truckee and Carson River basins in California and Nevada are to identify the significant resource management problems; to develop techniques to assess the problems; and to effectively communicate results to responsible managers. Six major elements of the assessment to be completed by October 1981 are (1) a detailing of the legal, institutional, and structural development of water resources in the basins and the current problems and conflicts; (2) a compilation and synthesis of the physical hydrology of the basins; (3) development of a special workshop approach to involve local management in the direction and results of the study; (4) development of a comprehensive streamflow model emcompassing both basins to provide a quantitative hydrologic framework for water-quality analysis; (5) development of a water-quality transport model for selected constituents and characteristics on selected reaches of the Truckee River; and (6) a detailed examination of selected fish habitats for specified reaches of the Truckee River. Progress will be periodically reported in reports, maps, computer data files, mathematical models, a bibliography, and public presentations. In building a basic framework to develop techniques, the basins were viewed as a single hydrologic unit because of interconnecting diversion structures. The framework comprises 13 hydrographic subunits to facilitate modeling and sampling. Several significant issues beyond the scope of the assessment were considered as supplementary proposals; water-quality loadings in Truckee and Carson Rivers, urban runoff in Reno and management alternatives, and a model of limnological processes in Lahontan Reservoir. (USGS)

California, Nevada↗

Streamflow and cross-section data for the Tombigbee River between Gainesville and Demopolis locks and dams

A review of records and historical research of floods indicate that the flood of April 15-18, 1979, was the highest recorded this century along the reach of the Tombigbee River that is now bounded upstream by Gainesville Lock and Dam and downstream by Demopolis Lock and Dam. The peak discharge during this flood ranged from 247,000 cu ft/sec at Epes to 343,000 cu ft/sec at Demopolis Lock and Dam. Limit curves developed for the tailwater of Gainesville Dam, based on 105 computed discharges for four flood events since April 1979, show the range in stage for a given discharge at this site. Data from hydrographic surveys that were made for more than 100 sedimentation ranges in 1971 are on file with the U.S. Army Corps of Engineers. Presently 42 sedimentation ranges between Gainesville Lock and Dam and Demopolis Lock and Dam are surveyed routinely. Comparison of these and other data can be made in order to observe what changes have occurred along this reach of the river, as a result of natural and man-made causes. These and other hydrologic data collected along the reach of the Tombigbee River between Gainesville Lock and Dam and Demopolis Lock and Dam are presented in tables. (USGS)

Open-File Report↗

Rhode Island Water Supply System Management Plan Database (WSSMP-Version 1.0)

In Rhode Island, the availability of water of sufficient quality and quantity to meet current and future environmental and economic needs is vital to life and the State's economy. Water suppliers, the Rhode Island Water Resources Board (RIWRB), and other State agencies responsible for water resources in Rhode Island need information about available resources, the water-supply infrastructure, and water use patterns. These decision makers need historical, current, and future water-resource information. In 1997, the State of Rhode Island formalized a system of Water Supply System Management Plans (WSSMPs) to characterize and document relevant water-supply information. All major water suppliers (those that obtain, transport, purchase, or sell more than 50 million gallons of water per year) are required to prepare, maintain, and carry out WSSMPs. An electronic database for this WSSMP information has been deemed necessary by the RIWRB for water suppliers and State agencies to consistently document, maintain, and interpret the information in these plans. Availability of WSSMP data in standard formats will allow water suppliers and State agencies to improve the understanding of water-supply systems and to plan for future needs or water-supply emergencies. In 2002, however, the Rhode Island General Assembly passed a law that classifies some of the WSSMP information as confidential to protect the water-supply infrastructure from potential terrorist threats. Therefore the WSSMP database was designed for an implementation method that will balance security concerns with the information needs of the RIWRB, suppliers, other State agencies, and the public. A WSSMP database was developed by the U.S. Geological Survey in cooperation with the RIWRB. The database was designed to catalog WSSMP information in a format that would accommodate synthesis of current and future information about Rhode Island's water-supply infrastructure. This report documents the design and implementation of the WSSMP database. All WSSMP information in the database is, ultimately, linked to the individual water suppliers and to a WSSMP 'cycle' (which is currently a 5-year planning cycle for compiling WSSMP information). The database file contains 172 tables - 47 data tables, 61 association tables, 61 domain tables, and 3 example import-link tables. This database is currently implemented in the Microsoft Access database software because it is widely used within and outside of government and is familiar to many existing and potential customers. Design documentation facilitates current use and potential modification for future use of the database. Information within the structure of the WSSMP database file (WSSMPv01.mdb), a data dictionary file (WSSMPDD1.pdf), a detailed database-design diagram (WSSMPPL1.pdf), and this database-design report (OFR2004-1231.pdf) documents the design of the database. This report includes a discussion of each WSSMP data structure with an accompanying database-design diagram. Appendix 1 of this report is an index of the diagrams in the report and on the plate; this index is organized by table name in alphabetical order. Each of these products is included in digital format on the enclosed CD-ROM to facilitate use or modification of the database.

Open-File Report↗