Storage and Analysis of Georeferenced Geotechnical and Pavements Data

This paper describes the creation of a database to store and provide access to historical geotechnical and pavements information from hundreds of construction projects in Kansas. Records of subgrade soil and pavement information were scanned to an accessible electronic format and key data fields were entered into a database. The geographic coordinates of sampling locations were determined, where possible, and entered into the database. These data may be imported to and analyzed in a geographic information system (GIS). Multiple analyses were conducted using the information from the database, and the accuracy of the data entered was evaluated.