An Interactive, Web-based Relational Database Portal for Subsurface Geotechnical Data

The proposed work significantly extends our effort to establish a computer-based framework for the management and analysis of subsurface data as they pertain to the maintenance and planning of transportation networks in Rhode Island. The resultant product will serve not only RI, but also serve as a national model. The proposal is a logical follow-up to three previously funded RI Transportation Center projects. In the first of those projects we developed a CD-ROM and an interactive, website-based borehole library that addressed two vexing and costly aspects of highway planning and maintenance: (1) the storage of borehole logs in an easily retrievable form; and (2) the inclusion of that information into a GIS-based framework that permits the efficient integration of subsurface geology with other data sets, such as those pertaining to environmental or land-use issues. These early efforts culminated in the development of a website where one may access borehole logs from the Providence and URI regions, sample profiles of the subsurface geology, and RIGIS data. Additionally, that project provided for on-line data entry direct from the driller or geotechnical contractor. However, this database did not provide access to the complete borehole record (e.g., the downhole record of blow counts, sediment or rock composition, soil properties, ground-water chemistry, etc). The goal of the next phase of our work was to expand our 2-dimensional core library into a multi-dimensional relational database, with the ability to store a complete subsurface record (layer-by-layer visual descriptions, blow counts, etc.) and associated data (laboratory analyses and geologic/geotechnical interpretations) in a unified database that provides real-time access and interactive capabilities. The resultant relational database allows a much more complete and sophisticated analysis of subsurface data. Moreover, it was designed to accept and incorporate new datasets as they are acquired in the future. The proposed work takes this project to its logical conclusion. Here we request funds to tightly link the relational database to the website, in a manner that permits the easy and graphical manipulation of borehole data for Rhode Island. Among other tasks, the proposed work will allow one to generate simple cross sections "on the fly" for the Providence area, if one has access to software that has been designed and modified for this project. Specifically, the completion of the proposed work will place Rhode Island in the forefront of GIS- oriented analysis of subsurface data in the context of transportation planning, and will serve as a model for other transportation agencies throughout the country.


    • English


    • Status: Active
    • Funding: $70000.00
    • Contract Numbers:



    • Sponsor Organizations:

      University of Rhode Island, Kingston

      Transportation Center, 85 Briar Lane
      Kingston, RI  United States  02881

      Rhode Island Department of Transportation

      State Office Building, 2 Capitol Hill
      Providence, RI  United States  02903
    • Project Managers:

      Franco, Collin

    • Performing Organizations:

      University of Rhode Island, Kingston

      College of Engineering
      Kingston, RI  United States  02881
    • Principal Investigators:

      Hamidzada, Nasir

      Boothroyd, Jon

      Hermes, O

      Murray, Daniel

      Veeger, Anne

    • Start Date: 20030701
    • Expected Completion Date: 0
    • Actual Completion Date: 0
    • Source Data: RiP Project 9413

    Subject/Index Terms

    Filing Info

    • Accession Number: 01458813
    • Record Type: Research project
    • Source Agency: Rhode Island Department of Transportation
    • Contract Numbers: SPR-2(28)-2202, 04-2
    • Files: RIP, STATEDOT
    • Created Date: Jan 3 2013 12:50PM