Merging Multiple Existing Geotechnical Databases to New KYTC Geotechnical Report Database (KGS‐Based)

Multiple data sources of geotechnical information reside in the state's District Offices and Central Office and on the University of Kentucky’s campus. There are also undocumented geotechnical data sources at different district offices in individual employee computer files which may soon become unavailable as those individuals retire from or leave the Kentucky Transportation Cabinet. To move this information into a cohesive database, Three agencies will collaborate to populate a preexisting geotechnical database that is currently available as an ArcView product. This will provide access to existing geotechnical field data that will be beneficial when preforming future geotechnical site investigations. The objectives of this research are to: 1) Merge the existing historical geotechnical database from the Cabinet's Oracle Servers with a KGS‐based relational database; 2) Acquire geotechnical district‐level geotechnical database information; and 3) Hold group and individual workshops to the staff in central and district offices to help them understand the procedures of collecting and using data in a web‐based all‐encompassing geotechnical database.


    • English


    • Status: Inactive
    • Funding: $36,5000
    • Contract Numbers:

      SPR 16‐520

    • Sponsor Organizations:

      Kentucky Transportation Cabinet

      200 Mero Street
      Frankfort, KY  United States  40622
    • Managing Organizations:

      Kentucky Transportation Cabinet

      501 High Street
      Frankfort, KY  United States  40622
    • Project Managers:

      Siwula, Jason

    • Performing Organizations:

      University of Kentucky, Lexington

      Kentucky Transportation Center
      College of Engineering, 176 Raymond Building
      Lexington, KY  United States  40506-0281
    • Principal Investigators:

      Sun, Charlie

    • Start Date: 20150701
    • Expected Completion Date: 20190630
    • Actual Completion Date: 0
    • USDOT Program: Transportation, Planning, Research, and Development
    • Subprogram: Research

    Subject/Index Terms

    Filing Info

    • Accession Number: 01675026
    • Record Type: Research project
    • Source Agency: University of Kentucky, Lexington
    • Contract Numbers: SPR 16‐520
    • Files: RIP, STATEDOT
    • Created Date: Jul 16 2018 12:10PM