Data Normalization and User Interface Design for the Nevada Department of Transportation Deep Foundation Load Test Database

"A recent study calibrated Load and Resistance Factor Design (LRFD) resistance factors for local soil conditions in the Las Vegas Valley. As a part of this calibration, an extensive database of drilled shaft load tests and associated subsurface soil information were collected and compiled. This database, deemed the Nevada Department of Transportation Deep Foundation Load Test Database or NDFLTD, was designed with the presentation of load test data, the subsurface soil conditions, and the spatial distribution of the data in mind. In addition, the NDFLTD was developed in a way that allows additional data to be added as it becomes available. As such, the rules of database normalization were followed to allow for additional and different types of data to be added to the database and reports. Microsoft Access was chosen to present the data because it is easily accessible to anyone with Microsoft office software, it has a quick learning curve, and it has the ability to present a relational database. The largest obstacle faced when creating the NDFLTD was normalizing the data used in the LRFD calibration, with the goal of reaching the 5th normal form.INTRODUCTIONLRFD is based on statistical performance of engineering components, as opposed to the more traditional Allowable Strength Design (ASD), which divides the strength of a component by a safety factor. Calibration of resistance factors for LRFD requires a robust statistical analysis of past performance. For drilled shafts this requires a database of full scale load tests (Abu-Hejleh et al. 2014). The FHWA developed the largest US based deep foundation load test database, deemed the DFLTD, collecting data from 1985 to 2003 when funds ran out (Abu-Hejleh et al. 2014). Recently, the DFLTD has been updated to modern standards (Petek et al. 2016). In October of 2007, the FHWA mandated state department of transportations (DOTs) to follow AAHSTO LRFD guidelines for their highway foundation designs (Abu-Hejleh et al. 2014). Since then multiple state DOTs have developed their own, region specific deep foundation load test databases. Florida has a long history of developing databases for deep foundation LRFD resistance factor calibration, with the two main databases being the FL database, and The Deep Foundations Database (Abu-Hejleh et al. 2014). Iowa developed a Microsoft Access based database in 2014 (Garder et al. 2014). Oregon developed a database compiling pertinent data from the DFLTD, Florida DOT’s Deep Foundation Database, as well as from other databases (Smith et al. 2011). Illinois developed the “International Database” for static and dynamic reliability based calibration (Long et al. 2009). Louisiana developed a database for LRFD Calibration of driven piles in 2009 (Abu-Farsakh et al. 2009). The California Department of Transportation has its own internal foundation database, which is housed within the Foundation Testing Branch archive (Smith et al. 2011). In 2016, the Nevada Department of Transportation (NDOT) presented its own LRFD calibration for the Las Vegas Valley (Stanton et al. 2017), and the NDFLTD was developed as a part of that project (Motamed et al. 2016)."