Water Resources Research Act Program

Details for Project ID 2002RI1B

Hydrologic Relational Database for Rhode Island

Institute: Rhode Island
Year Established: 2002 Start Date: 2002-03-01 End Date: 2003-02-28
Total Federal Funds: $20,093 Total Non-Federal Funds: $40,652

Principal Investigators: Anne Veeger, Nasir Hamidzada

Project Summary: The ability to store, retrieve and analyze hydrologic data is a key component of efficient planning and environmental management. In Rhode Island, existing hydrologic data are stored in a variety of U.S. Geological Survey, RI DEM, RI Department of Health, and individual investigator files and databases. Data collected through RI Water Resources (RIWRC) Center funded research for example, is stored in paper format in the form of a final report. This limits the potential application and usefulness of the data to State and local agencies and other investigators. The development of a multi-dimensional relational database management system, which will permit storage and retrieval of hydrologic data for sampling sites is proposed to address the need for unified and accessible data storage. The database will incorporate both spatial and non-spatial data by using a GIS approach. The spatial data will be stored in an ArcInfo Coverage and the non-spatial data will be stored in Access. Querying, display and analysis of data (including site location, field data, laboratory data) will be possible, thereby creating the capacity to complete spatial analysis of the data in a geographic information system (GIS). This database can be used by future investigators to submit hydrologic data in electronic format as part of their reporting procedure. This will ensure continued population of the relational database with up-to-date hydrologic information. The resulting Rhode Island hydrologic data coverages will be compatible with existing RIGIS coverages and will be an important planning and assessment tool for the State.