GIS Geotechnical Database Guide
GIS Geotechnical Database Guide
RESEARCH PROGRAM
INDIANA DEPARTMENT OF TRANSPORTATION
AND PURDUE UNIVERSITY
Field/Lab tests
AUTHORS
Rameez Ali Raja
Graduate Research Assistant
Lyles School of Civil Engineering
Purdue University
Vidushi Toshniwal
Graduate Research Assistant
Lyles School of Civil Engineering
Purdue University
Published reports of the Joint Transportation Research Program are available at http://docs.lib.purdue.edu/jtrp/.
NOTICE
The contents of this report reflect the views of the authors, who are responsible for the facts and the accuracy of the
data presented herein. The contents do not necessarily reflect the official views and policies of the Indiana Depart-
ment of Transportation or the Federal Highway Administration. The report does not constitute a standard, specifica-
tion or regulation.
ACKNOWLEDGEMENT
The work presented in this paper was funded by the Joint Transportation Research Program (JTRP) administered by
the Indiana Department of Transportation (INDOT) and Purdue University through contract SPR-4616. The support
of the Indiana Department of Transportation (INDOT) and the Federal Highway Administration (FHWA) are grate-
fully acknowledged. The authors are very grateful for the support received from the project advisor, Boonam Shin,
the business owner, Athar Khan, and in particular, the support received from the Study Advisory Committee mem-
bers (Sung Min Yoon, Peter Becker, Irfan Alvi, Derek Fuller, and Christa Phelps) is much appreciated. The authors are
thankful to graduate student Daniel Goldstein Fridman for his comments on early draft of the report.
Technical Report Documentation Page
1. INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
1.1 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
1.2 Project Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
1.3 Report Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
2. APPLICATIONS COVERED BY THE DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
2.1 Foundation Design. . . . . . . . . . . . . .......... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
2.2 Retaining Wall Design . . . . . . . . . . .......... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
2.3 Slope Stability Analysis. . . . . . . . . . .......... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
2.4 Ground Improvement . . . . . . . . . . . .......... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
2.5 Pavement Design . . . . . . . . . . . . . . .......... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
3. FIELD, LABORATORY, AND VERIFICATION TESTS PERFORMED BY INDOT . . . . . . . . . . . . 3
3.1 Field Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . ........................... . . . . . . . . . . . . 3
3.2 Laboratory Tests . . . . . . . . . . . . . . . . . . . . . . ........................... . . . . . . . . . . . . 6
3.3 Verification Tests . . . . . . . . . . . . . . . . . . . . . . ........................... . . . . . . . . . . . . 9
4. VARIABLES TO BE INCLUDED IN THE DATABASE AND METHODS OF INTERPRETATION. 9
4.1 Shallow Foundation Design . . . . . . . . . . . . . . . . . . . . . . . . ............................ 10
4.2 Deep Foundation Design . . . . . . . . . . . . . . . . . . . . . . . . . . ............................ 11
4.3 Retaining Wall Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................ 12
4.4 Slope Stability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................ 13
4.5 Ground Improvement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................ 14
4.6 Pavement Works . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............................ 14
5. PROPOSED DATABASE STRUCTURE AND EXAMPLE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
5.1 Database Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
5.2 User Workflow Example. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
6. CONCLUSIONS AND RECOMMENDATIONS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
REFERENCES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
LIST OF TABLES
Figure 4.1 Variables required in the engineering analysis and design of shallow foundations and related geotechnical tests 11
Figure 4.2 Variables required in the engineering analysis and design of drilled shaft foundation and related geotechnical tests performed for
deep foundations 12
Figure 4.3 Variables required in the engineering analysis of (a) open-ended pipe pile foundation design under axial loads, (b) closed-ended
pipe pile foundation design under axial loads, and (c) pile foundation design under lateral loads 13
Figure 4.4 Variables required in the engineering analysis of MSE wall design and related geotechnical tests 14
Figure 4.5 Variables required to perform slope stability analysis and related geotechnical tests 14
Figure 4.6 Geotechnical tests required to establish the need for ground improvement and variables related to different ground improvement
techniques 15
Figure 4.7 Variables required in the pavement design and related geotechnical tests 15
Figure 5.2 User workflow example for bearing capacity analysis of a shallow foundation 17
Figure 5.3 Bearing capacity analysis of strip footing (extracted from the geotechnical report of the project: Smith Valley Road over I-69) 18
1. INTRODUCTION 1.3 Report Structure
1.1 Background Section 1 introduces the project and its scope.
Civil engineering projects rely on geotechnical Section 2 presents an overview of the different
reports, which are formulated based on geotechnical geotechnical applications that will be covered by the
data obtained from site investigations, which include database.
both in situ and laboratory testing performed on either Section 3 presents the details of different laboratory
remolded or undisturbed samples. The geotechnical and field tests performed by INDOT.
reports are prepared on a project-by-project basis, and Section 4 presents different geotechnical variables
thus an abundance of geotechnical data is gathered that are obtained from geotechnical testing and their
from a site investigation planned specifically for a project. linkages with the design of selected applications.
These reports are mostly submitted in the form of a hard Section 5 presents the proposed structure of the
copy and, in some cases, electronically in the form of database and an interactive user workflow example.
portable document format (PDF). Storage, archiving,
and transferability of geotechnical reports submitted in 2. APPLICATIONS COVERED BY THE DATABASE
hard copy is challenging and time consuming. Hard
copies of the submitted geotechnical reports are placed in A comprehensive list of services that the INDOT
geotechnical office provides in support of civil engineer-
their respective project files, which are generally disposed
ing projects was formulated to finalize the scope of the
of after a certain time period. When the reports are
applications that will be covered in the database. The
submitted electronically, this is done in the form of file
applications shortlisted for inclusion in the database are
types that are proprietary and display information perti-
discussed below.
nent to the focus of each company, or otherwise not
easily amenable to electronic processing. However, as the
number of files increases, it becomes more advantageous 2.1 Foundation Design
to place all the geotechnical data at one location and use
a database system to manage the reports. An electronic 2.1.1 Shallow Foundation Design
database system provides several advantages over the
conventional reporting system by allowing the users to Shallow foundations are preferred when a competent
store, query, access and distribute geotechnical reports soil layer, which can support the applied loads without
and related documents in a convenient manner. undergoing excessive settlement, exists at a shallow
INDOT spends at least 8 million dollars annually on depth. They are cost effective option as they require
geotechnical site investigations, not including amounts excavation to shallow depths and are also easy to
spent by contractors as part of contracts. The laborious construct. Depending on how dense or stiff the under-
job of data collection in geotechnical practice dictates lying soil layer is, shallow foundations can support not
the need to efficiently store and organize the valuable only building structures but can also be used to support
data to develop correlations and trends in spatially bridges. The different types of shallow foundations
varying geotechnical data. The INDOT geotechnical include spread footings, isolated footings, mat footings,
office is pursuing means to improve the efficiency of and strap footings. The selection of an appropriate type
their operations by developing a geotechnical database of footing depends on site conditions, supporting soil
properties, applied loads and the type of structure that
for secure storage, easy retrieval, and flexible sharing of
is to be supported. Shallow foundations are propor-
geotechnical data to enhance their decision-making. It
tioned and designed in accordance with the Load
is intended to reduce the need to perform investigations
Resistance Factor Design (LRFD) framework as
when the data already exists and would also serve as a
prescribed by AASHTO (2020), such that they perform
tool for effective engineering analysis based on which
satisfactorily under all applicable limit states. Design of
design decisions can be made. This one-year project was
foundations at ultimate limit states include considera-
envisioned as the first step towards the development of
tion of the nominal bearing resistance, overturning or
a geotechnical data management system.
excessive loss of contact, and overall stability of the
structure and its part. Foundation design at the service
1.2 Project Overview limit state shall consider all foundation movements
(vertical, horizontal, and rotation) based upon structure
The current research aimed at laying out the tolerance to total and differential movements. The
conceptual basis for the development of an object- geotechnical investigation planned for a shallow
oriented, relational geotechnical database that best fit foundation design should identify the properties and
the current needs of INDOT geotechnical office. In this behavior of the soil and/or rock, the groundwater
project, important decisions such as the types of conditions, and other subsurface conditions that might
geotechnical applications, field and laboratory tests, affect the foundation design and performance. SPT
and variables required for engineering analysis that will and/or CPT results are generally used to obtain the
be covered by the database were made. foundation design parameters through correlations
In this section, we discuss the inventory that we 3.1.3 Seismic Cone Penetration Test (SCPT)
compiled of the geotechnical tests that are performed
by the INDOT geotechnical office. We categorize the The test is performed in accordance with ASTM D
geotechnical tests into field, laboratory, and verification 7400 (2019) to determine compression (P) and shear (S)
tests. Table 3.1, Table 3.2, and Table 3.3 provide a wave velocity profiles in geotechnical earthquake
consolidated list of these tests along with their engineering investigations. Since certain counties in
TABLE 3.2
Summary of the laboratory tests performed by INDOT
Indiana fall within the seismic zones, this test is the in situ soil. This test is performed by driving a metal
routinely performed by INDOT. During the test, travel cone into the ground by repeatedly striking it with a
times of the seismic waves are analyzed, and seismic hammer of standard weight dropped from a fixed
velocity is calculated. The P-wave and S-wave velocities height. The use of DCPT fundamentally started with
are directly related to the important geotechnical elastic pavement applications where it was used as a proxy test
constants such as Poisson’s ratio n, shear modulus G, for the determination of the California Bearing Ratio
bulk modulus K, and Young’s modulus E. These (CBR). However, considering the portability of the
parameters are used in analysis of soil behavior under apparatus it is also used as a verification test to check
both static and dynamic loads. The shear wave velocity compaction standards. The DCPT blow count mea-
determined in this test is also used in the liquefaction sured during the test can be correlated with in situ DR, c,
assessment of the soils. resilient modulus MR, and bearing capacity of the soils.
3.1.4 Dynamic Cone Penetrometer Test (DCPT) 3.1.5 Light Weight Deflectometer (LWD)
The test is performed in accordance with ITM 509 The test is performed in accordance with ITM 508
(INDOT, 2022a) and is used to estimate the strength of (INDOT, 2019a) and ASTM E 2583 (2020) and is used
Static pile load test (SPLT) ASTM D 1143 Load-settlement curve, load-transfer curves, limit unit shaft
resistance vs. depth plot, limit shaft capacity, ultimate
base capacity, ultimate load capacity
Dynamic pile load test (DPLT) ASTM D 4945 Estimated pile load-carrying capacity, estimated shaft
resistance, estimated base resistance, driving/restrike
records, parameters used to describe pile-soil static and
dynamic stress-strain response, pile set
Pile integrity test ASTM D 5882 Discontinuity, consistency, interpreted pile length, pile
diameter vs depth plot, velocity signals
Pile lateral load test ASTM D 3966 Flexural stiffness, lateral deflection, bending moment, shear
force, load and displacement at failure, soil resistance
Proofrolling INDOT Standard Specification, Subgrade deformation and standard acceptance testing
Section 203.26
Light weight deflectometer (LWD) ITM 508, ASTM E 2583 Ed
Falling weight deflectometer (FWD) ASTM D 4694 E
Dynamic cone penetrometer test (DCPT) ITM 509 Penetration index, blow count for 6 in. or 12 in. of
penetration
as a quick non-destructive method for determining the sive strength of soils. This lightweight, hand-held, and
stiffness of the subgrade and unbound base layers, direct reading penetration device consists of a cali-
granular layers, and backfilling materials. In this test brated spring and 0.25-in.-diameter piston encased
the deflection of the paved and unpaved pavement inside a metal casing. INDOT uses pocket penetrometer
surfaces is measured under the falling weights to only as a supplementary test to more precise strength
estimate the soil modulus. The deflections are corre- determinations.
lated to pavement performance and in situ material
parameters of the pavement layers. INDOT uses this 3.1.8 Dilatometer Test (DMT)
test for sands, aggregates, and chemically modified
soils. The test data is useful for quality assurance of This test is performed in accordance with ASTM D
compacted layers, structural evaluation of load-carry- 6635 (2001) and is used to determine the strength and
ing capacity and determination of thickness require- deformation characteristics of fine-grained soils. The
ments for highway and airfield pavements. main part of the flat dilatometer consists of a flat
stainless thin steel blade with a circular expandable steel
3.1.6 Falling Weight Deflectometer (FWD) membrane of 60-mm diameter on one side. The test
involves driving the steel blade into the ground, inflate
The test is performed in accordance with ASTM D the steel membrane and measure the corresponding
4694 (2020). The falling weight deflectometer is used to pressure and deformation. The corrected DMT pres-
simulate deflection of a pavement surface in response to sures readings are used to estimate the in situ lateral
an impulse load applied by a fast-moving truck. The stress and lateral soil stiffness.
resulting deflections are measured at the center of the
applied load and at various distances away from the 3.1.9 Pressuremeter Test (PMT)
load. Knowing the thickness of individual pavement
layers the deflection can be related to the stiffness The pressuremeter test is performed in accordance
of the pavement using various computational methods. with ASTM D 4719 (2020). In principle the pressure-
The measured deflections are an indicator of pave- meter test is performed by applying pressure to the side
ment performance and could be used to determine walls of a borehole and observing the corresponding
the modulus of pavement layers and subgrade soils. deformations. In this test, a cylindrical probe is lowered
The result of this test could be used to evaluate into a pre-drilled borehole and then pressure within it is
structural load-carrying capacity and determine over- increased by inflating a flexible membrane in the lateral
lay thickness requirements for highway and airfield direction in about 10 increments. For each increment,
pavements. the change in volume of the measuring cell is recorded
until the volume is equal to twice its initial deflated
3.1.7 Pocket Penetrometer Test (PP) volume. The test is best used for dense sands, hard
clays, and weathered rock. The limit pressure is
This test is performed in accordance with ASTM obtained through which soil shear strength could be
WK 27337 (2010) and is used to determine consistency, estimated using cylindrical cavity expansion analysis.
shear strength, and approximate unconfined compres- The results of this test are used to estimate the soil
This test is performed in accordance with ITM 511 The pile integrity test is performed in accordance
(INDOT, 2013). It is used to determine the reaction of with ASTM D 5882 (2016). This non-destructive, low-
weak rock material to water during a certain time strain pile testing method is used for the assessment of
period. A quantitative jar slake index Ij value is then the integrity of piles and reveals potential pile defects,
assigned to the tested rock. The index Ij has implica- such as major cracks, necking, soil inclusions or voids.
tions on the porosity, grains, interactions, and density In this test the velocity induced on the pile by an impact
of the weak rock. device is measured. The impact device is usually applied
axially and perpendicularly to the pile head surface.
3.3 Verification Tests During the test, the accelerometer attached to the test
pile measures a plot of acceleration versus time that can
The verification tests performed by INDOT to be integrated to produce a plot of velocity versus time.
comply with their quality control procedures relevant This plot reveals any significant changes in cross-
to different geotechnical applications are discussed section that may exist along the pile shaft. If major
below. defects exist, test results may be interpreted to estimate
their magnitude and location. The test results help
3.3.1 Static Pile Load Test (SPLT) determine pile integrity and continuity; consistency of
pile materials and pile cross-sectional area; and length.
The test is performed in accordance with ASTM D
1143 (1994). Static load tests are performed during the 3.3.5 Proof Rolling
test phase of each contract to verify the design assump-
tions and the load carrying capacity of piles. During the Proof rolling is performed in accordance with
test, a static load is applied on the test pile using INDOT Standard Specifications 2022, Section 203.26
a hydraulic jack and measured using a load cell. (INDOT, 2022b). The test results are used to check the
A reaction frame sufficient to take the pile load test subgrade compaction and to locate soft areas. The
to the desired load or settlements must be designed. deformation of subgrade is measured during the test by
Loads are applied in increments and each increment driving a dump truck weighing at least 15 tons at a
is held for a predetermined time interval. The pile maximum speed of 2 mph over designated areas of the
response to the applied load is measured throughout soil surface. Proof rolling has the potential to reveal
the test to determine the pile capacity and ultimate issues with subgrade drainage. There is no ASTM
failure load. standard for this procedure.
3.3.2 Static Pile Lateral Load Test 3.3.6 Light Weight Deflectometer (LWD)
This test is performed in accordance with ASTM D The LWD test described above under the field tests is
3966 (2022). This test measures the lateral deflection also used by INDOT as a verification test.
of an individual pile or group of piles when subjected
to static lateral loading. The test results provide a 3.3.7 Falling Weight Deflectometer (FWD)
relationship between the static lateral load applied to a
deep foundation and the resulting lateral movement. The FWD test described above under the field tests is
The results could be useful to assess the distribution of also used by INDOT as a verification test.
lateral resistance along the element and the long-term
load-deflection behavior. The test results could be 3.3.8 Dynamic Cone Penetration Test (DCPT)
analyzed to evaluate pile-soil interaction properties
such as coefficient of horizontal subgrade reaction to The DCPT test described above under the field tests
estimate bending stresses and flexural stiffness. is also used by INDOT as a verification test.
Figure 4.1 Variables required in the engineering analysis and design of shallow foundations and related geotechnical tests.
Figure 4.2 describes the site investigation tests and Laterally loaded piles are usually analyzed using the p-y
lab tests performed by INDOT and the obtained soil method. In this method, the horizontal soil resistance
variables and their use in engineering design. Founda- along the piles is modeled using suitable p-y curves, as
tion design relies upon the SPT and/or qc results shown in Figure 4.3c.
obtained during the field exploration and also on
independent data obtained by visual descriptions of the 4.3 Retaining Wall Design
soil/rock encountered, possibly laboratory tests and
general knowledge of local geology. The design of retaining walls is done in accordance
with AASHTO LRFD Bridge Design Specifications as
4.2.2 Driven Pile Foundations prescribed by AASHTO (2020). In Figure 4.4 the design
of MSE walls is shown as an example for retaining
A pile derives its load-carrying capacity from the walls as they are designed as any conventional retaining
shear stress that develops along the pile shaft with the wall but have some additional design considerations to
surrounding soil—known as the unit shaft resistance— meet the internal stability requirements. Furthermore,
and from the compressive resistance that develops at in current design practice, MSE walls are an important
the contact of the pile base with the underlying soil. component of transportation infrastructure that can
Driven piles may be open-ended or closed-ended. The serve not only as a retaining structure but also as bridge
performance of open-ended driven pile foundation abutments and wing walls. The main components
depends on the plugging response during pile driving. of MSE wall are the retained backfill, reinforced fill,
Figure 4.3a and Figure 4.3b discuss variables reinforcing elements (e.g., steel strips, steel grids, or
required for limit state design of open-ended and planar geosynthetics), wall facing (e.g., precast concrete
closed-ended steel pipe piles. Engineering analysis of panels, modular blocks, and welded wire mesh) and
pile foundation is a crucial step in ensuring the stability foundation soil. MSE walls are designed for external
and safety of the structure. It is necessary to ensure that stability (bearing capacity failure, overturning, sliding,
the foundation does not reach its limit states— and global stability) of the wall as well as internal
serviceability limit states (SLS) and ultimate limit states stability (reinforcement rupture, reinforcement pullout,
(ULS). SLS includes excessive deformation or settle- and reinforcement-facing connection strength) of the
ment that affects the performance of the structure, and reinforced soil mass behind the facing.
an ULS is reached when a pile foundation is no longer Figure 4.4 shows the details of the engineering ana-
able to support the load of the structure due to bearing lysis required in the design of MSE walls. The variables
capacity failure or excessive settlement. Engineering required to perform the design checks are linked with
analyses are performed to evaluate bearing capacity the geotechnical tests from which they are obtained.
and settlement for pile foundation. It is also essential to A thorough classification of the foundation soil,
consider the effects of downdrag (DD) and scour when retained soil, and reinforced soil is required as engi-
designing piles to ensure their stability and safety over neering properties of each of these soils to perform
time. Downdrag load is the load applied on the pile by various design checks. Considering that INDOT
soil consolidating around it. Scour, on the other hand, typically uses metallic strips as reinforcement, soil cor-
refers to the erosion of soil around the pile due to water rosiveness is also analyzed thorough different physio-
flow, which can cause the pile to become unstable. chemical parameters. The values obtained from these
tests are needed to take preventive measure against ple locations and depths. Selection of soil shear strength
long-term corrosion and degradation of the reinforce- parameters used as input to the analysis will vary
ment being exposed to corrosive and contaminated depending on whether short-term or long-term stability
environment. analysis must be performed. For short-term analysis,
undrained shear strength parameters are required; for
4.4 Slope Stability long-term stability analysis, drained shear strength
parameters are required.
Detailed assessment of soil and rock stratigraphy is Slope stability is mostly performed using limit
critical to the proper assessment of slope stability. The equilibrium methods—modified Bishop, simplified
site investigation and laboratory tests carried out for Janbu, or Spencer method being the most common.
slope stability analysis are listed in Figure 4.5. The key The factor of safety calculation resulting from the
in situ tests often used in analysis are the standard analysis requires that the slope geometry be completely
penetration test, cone penetration test, and vane shear defined, and the soils in the slope adequately char-
test. The groundwater regime beneath the slope will acterized. Figure 4.5 shows the field and laboratory
also be determined through piezometric data at multi- tests performed to obtain the soil parameters used in
Figure 4.5 Variables required to perform slope stability analysis and related geotechnical tests.
slope stability analysis calculations. The resistance In general terms, there are three typical modes of soil
factors and load factors are required to perform the improvement: densification, reinforcement, and drain-
design check specified in LRFD Bridge Design age enhancement. The selection of methods is based on
Specifications AASHTO (2020). Slope stability checks site conditions, improvement objectives, equipment
may also be done using the finite element method or availability, cost, construction period, skills, and past
other more sophisticated methods. experiences.
Depending on the ground improvement method
4.5 Ground Improvement adopted, there are certain variables that are directly asso-
ciated with the method. In Figure 4.6, as an example,
One of the major tasks a geotechnical engineer may we show three methods for ground improvement. When
have to undertake is to design, evaluate, and implement wick drains (PVDs) are used as a ground improvement
ground modification schemes for infrastructure pro- method in a project, variables of interest associated are
jects. Before the start of any construction project, the size, shape, and length of the PVDs, the vertical and
properties of the soil on site are evaluated to check its horizontal spacing between the PVDs, vertical and
suitability for construction. Ground improvement is horizontal drainage, and the total discharge rate of the
necessary when poor soil conditions are encountered. PVDs. These details should be included in the database.
Ground improvement is carried out for various In addition, pertinent details such as information regard-
objectives, including improving bearing capacity, redu- ing the smear zones, well resistance, and splicing may also
cing settlement of soft ground, preventing soil liquefac- be included in the database.
tion, controlling groundwater flow, stabilizing
excavations, preventing deformation of surrounding 4.6 Pavement Works
ground, or mitigating erodibility. There are many
different ground improvement systems adaptable to a Pavement works include subgrade modification and
wide array of site conditions, soils, and structure types. stabilization to improve the strength and stability of the
Figure 4.7 Variables required in the pavement design and related geotechnical tests.
subgrade to improve performance and longevity of the parameters of soil, hydraulic conductivity, Atterberg
pavement structure. Proper characterization and eva- limits, minimum and maximum void ratio.
luation of the subgrade soil is crucial to ensure the
overall stability and durability of pavement structures. 5. PROPOSED DATABASE STRUCTURE AND
The properties of the subgrade soil are also used as EXAMPLE
input parameters for other pavement layers. The site
investigation and laboratory tests carried out by 5.1 Database Structure
INDOT for the same are listed in Figure 4.7. The Figure 5.1 shows the proposed database structure,
FWD and the LWD are the important in situ tests. The designed following the object-oriented paradigm. It will
resilient modulus measures the stiffness of the subgrade be a user-friendly web-based GIS application helpful
and is an important parameter used in the design of for engineers using the database. The purpose of the
pavement structures. Other important lab tests to obtain database is to organize the data in a structured manner
pavement design input parameters include strength for easy retrieval of information associated with any
tests, consolidation test to assess the compressibility design step of any INDOT project. This would allow
for remote access without operating robust GIS soft- The Test table has fields describing a geotechnical
ware. It is a fully integrated relational database. The test such as test name, test type, test standard and
database is organized in the form of tables and output soil type, and soil variables from the test. The
associated relations between them. Each table in the variable field in the Test table can be used to query its
database corresponds to a separate class and the detailed description from the Variable table. This table
different entries in the table will be the various objects stores the information related to the soil variables and
of the respective class. For example, the applications has corresponding fields—name, identification if it is a
table is responsible for storing the Application class. state variable or profile variable, and relevant tests. The
The fields of the table are the class attributes, and each test field in the Variable table also acts as a foreign key
row of the table is a separate Application object. Each into the Test table. The variables required would vary
table also has a primary key that uniquely identifies an depending on the analysis being performed. The soil
object of that table. This primary key is used to profile variables would be, for example, ground surface
establish relations between tables. For example, the elevation, depth to water table, depth to bedrock,
design analysis field in Application table holds the list of number of soil layers, layer thickness and soil type for
design checks to be performed. These names can be each layer. The soil state variables would store the soil
directly used to query the detailed description in the properties like void ratio, relative density, unit weight,
Design Analysis table. and hydraulic conductivity. Variables are direct input
We identified the basic building blocks for identify- for design analysis to be performed for any given
ing the geotechnical applications design in a project as application.
follows: Project, Application, Test, Variable, and Design The Design Analysis table has fields describing a
Analysis. The Project table has fields for project des- design method. These include, for example, name,
cription (project name, number, location, county, AASHTO/INDOT standard it follows, soil type it is
contract, consultant, engineer) and the associated applicable for, and the soil variables required to
applications based on the project scope. The applica- perform the analysis. The soil variable field in the
tions field in the project table acts as a foreign key into design analysis table acts as a foreign key into the
the Application table. Variable table to find the description and tests
The Application table has fields for its description performed to obtain the required soil variable for an
(name, location, geometry), the design analysis to be engineering analysis. There are complex relationships
performed, and the tests required (gives details about existing between all the classes but defined rigorously in
site investigation and laboratory tests performed for a logical manner.
an application). The test field in the application table One of the ways in which the database will be useful
acts as a foreign key into the Test table and the will be when the user is looking for specific type of
design analysis field acts as a foreign key into the data in a certain area. This database design will enable
Design Analysis table. the users to make complex queries on the design of
Figure 5.2 User workflow example for bearing capacity analysis of a shallow foundation.
regarding the field and laboratory tests performed data stored in the database would be beneficial for the
during the project and the geotechnical variables engineer in making any preliminary design decisions
obtained from the tests are stored in Test table. The and planning a geotechnical investigation.
soil variables obtained from the geotechnical tests are
used as input to perform the required design analysis. 6. CONCLUSIONS AND RECOMMENDATIONS
The Design Analysis table has fields describing the
standard and calculation methods used to perform The scope of the proposed geotechnical database was
the engineering analysis and the output obtained from discussed in the context of the geotechnical applications,
the design analysis. The proposed database structure is tests, and variables that will be included in the database.
designed to separately store the information regarding In addition, the proposed database structure and user
the design checks for ultimate limit states and service- workflow was presented. The proposed database struc-
ability limit states. ture is designed following the object-oriented paradigm.
In Figure 5.2, an ultimate bearing capacity analysis It is organized in a manner that enables the user to retrieve
is performed to check the bearing capacity of a strip specific information related to a particular project in an
footing in sand using LRFD Bridge Design efficient manner. The database classes include project,
Specifications as prescribed by AASHTO (2020) with application, test, variable, and design analysis. The
a resistance factor of 0.45. The required soil variables associated relations between the classes provide a clear
are also included in the design analysis table and are understanding of the data flow. The primary objective
linked with the geotechnical tests from which they are of the proposed database is to reduce the need to
obtained. Three different methods (Terzaghi (1943), perform geotechnical investigations when the data
Meyerhof (1963), and Vesic (1973)) are used to already exists. If implemented, this approach will save
calculate the factored bearing resistance which is stored time, resources, and improve the efficiency of INDOT
as the design output in the Design Analysis table. geotechnical office operations. Moreover, the database
As the information in the database is distributed into can also serve as a tool for effective engineering analysis
several classes that are linked in a logical manner, and decision-making. It can provide significant benefits
a database user can easily extract the required to geotechnical engineers, geologists, and other pro-
information by querying the database. In this form, fessionals who deal with geotechnical data regularly.
the user can retrieve desired geotechnical data or use By providing a centralized location for storing and
some criteria (county, applications, project ID, work accessing data, the database can improve collaboration,
type) to narrow down the search. Such an interface is consistency, and accuracy of geotechnical data, leading
useful when a user is just looking for a specific type of towards better design solutions.
data available in a certain area. If a future project is While this project has provided the conceptual basis
planned in the vicinity of a previous project, the existing for the design of a geotechnical database system that
The first studies of JHRP were concerned with Test Road No. 1 — evaluation of the weathering
characteristics of stabilized materials. After World War II, the JHRP program grew substantially
and was regularly producing technical reports. Over 1,600 technical reports are now available,
published as part of the JHRP and subsequently JTRP collaborative venture between Purdue
University and what is now the Indiana Department of Transportation.
Free online access to all reports is provided through a unique collaboration between JTRP and
Purdue Libraries. These are available at http://docs.lib.purdue.edu/jtrp.
Further information about JTRP and its current research program is available at
http://www.purdue.edu/jtrp.
Raja, R. A., Toshniwal, V., & Salgado, R. (2023). GIS-based geotechnical database for collaborative
GIS (Joint Transportation Research Program Publication No. FHWA/IN/JTRP-2023/14). West
Lafayette, IN: Purdue University. https://doi.org/10.5703/1288284317637