Source Database Attributes and Transformations

This chapter offers crucial information on the ETL process of porting all data from the various sources (Olson, Iowa, FHWA, etc.) to the NYU Load Test Warehouse. All available details on all original attributes are summarized in tables along with the new names of the target attributes that each original piece of information was ported to.

Furthermore, and as a tribute to Dr. Roy Olson, parts from his personal notes are presented verbatim (as they could not be paraphrased) in an effort to preserve the insights and design decisions that went in to developing the first advanced pile load test database which led the way for the rest us.

Olson APC Database Attributes

A list of issues identified by Dr. Olson in developing the APC database:

  1. A pile capacity was reported in tons but was entered in the data base in kips but without changing the number.

  2. A pile capacity was reported in “tonnes” with depth in meters and the capacity was interpreted as 2000-pound tons rather than the metric ton of 2205 pounds.

  3. For steel pipe piles, sources often did not indicate whether the pile was open-ended or closed-ended.

  4. For closed-ended pipe piles, authors often did not indicate whether the pile was full of concrete, or water, or was empty.

  5. For closed-ended steel pipe piles, authors rarely indicated whether the base plate had the same diameter as the pile or was oversized.

  6. For open-ended steel pipe piles, authors did not indicate whether or not a driving shoe was used.

  7. For open-ended piles, the authors did not indicate the height of soil plug.

  8. When data from soil borings were presented, it was often difficult to determine which boring was closest to a given pile.

  9. In several cases, soil borings were made and the results reported. However, the pile penetrations made no sense in that the pile tip stopped in soft clay just above a good supporting layer. It was subsequently figured out that they had removed up to thirty feet of soil from the site after soil exploration but prior to pile driving.

  10. We were non-uniform in defining what “plunging capacity” meant. Sometimes it was the peak load and other times it was the load at large settlement. They differed by up to 40% in some cases. I have decided to standardize on the peak load. We may want to add a new entry for the “ultimate” load.

  11. In a number of cases, the authors called the foundation a “pile” but careful reading of the case history led to the conclusion that it was either a “pier” or it could have been a pier. We discarded such data.

  12. The depth to the water table was often not provided. For sands, this was a fatal problem although sometimes we decided to estimate the location of the water table and just demote our rating of data quality. We are now trying to specify effective stresses in clays but we rarely have water tables for clays.

  13. Sand densities were rarely specified so we have assumed values. Different people sometimes assumed substantially different values of total unit weight. We need to figure out some standard unit weight, perhaps as functions of N values and any information provided on gradation, but we have not done so yet and it will require a lot of time.

  14. Japanese N values seem to be considerably different from ours because they have used a hammer of higher efficiency. Norm Dennis worked out a correlation but it is of highly questionable accuracy and this problem needs to be reconsidered.

  15. We had a number of Japanese pile load tests on large diameter (usually 30”) steel pipe piles in sand. Unfortunately, the text is in Japanese. We were able to guess soil profiles based on hatchings used in boring logs and we could read the Arabic numerals to get depths and N values. Subsequently, Tung was able to translate some of the data and he concluded we had made major errors. His corrected data are in other files and will be substituted for data in the database when time permits.


From Dr. Olson’s notes on the APC database:

Most of the values of total unit weight (\(\gamma_t\)) are assumed. If water contents (\(w\)) are shown then they were used to calculate \(\gamma_t\). I used cases in which water contents were measured to calculate total unit weights for all soils and then did a correlation of those values of \(\gamma_t\) with whatever other properties were available, meaning cohesion (\(s_u\)) for cohesive soils, and SPT-N values for all soils, and used these other properties to estimate \(\gamma_t\) for cases in which water contents were not defined. The correlations were often bad but at least they gave a consistent basis for estimating \(\gamma_t\).

The elevation of the water table was usually unknown for profiles of all clay. If I thought a reasonable value could be assumed, I did so and there are typically no notes indicating EWT was assumed (I added notes later when I thought of it). If EWT is to be left undefined, then EWT=+1, which is code that EWT is unknown.

In all soils, I assumed the pore water pressure above the water table was zero. This value is nonsense but it is typically irrelevant in cohesionless soils (they may not even be saturated). In clays, the pore water pressure is relevant but can’t be calculated so I discourage use of effective stress methods for clays.

The wall thickness of steel pipe piles was often an assumed value. The wall thickness is used in calculating pile weight, W, and the pile compressibility, AEOL, but the correction for W is small so the error is even smaller, and AEOL is only used with Davisson’s method, and I usually didn’t use it as a failure criterion.

The tip condition for steel pipe piles was often unknown. Sometimes, I could infer it from discussion in the text or from discussions with engineers who were more familiar with local practice. For closed-ended pipes, I rarely knew the diameter or thickness of the cover plate. Sometimes I could magnify a drawing to estimate whether the cover plate had a larger diameter than the pile or not but that was often not possible. I used a displacement ratio exceeding 1.00 to indicate the presence of an oversized cover plate.

Originally we made data quality factors range from 0 to 5, then we discarded the 0’s, and finally used only DQF=3-5. However, the DQF cannot be used except in the crudest manner. In the common case, we use N to estimate QS. If we have only N values at a clay site the case might warrant a DQF of 5, whereas if we try to use an effective stress method and we know neither EWT nor TUW (common) then the test might be a 1. As work evolved, we started using only data with DQF of 3-5 so I’ve altered DQFs to be at least 3 if the test was good enough to be used.

Originally, working under very adverse conditions (horrible computer problems, need to generate quick results for API for a very crude analytical method, inexperience, etc.) Dave Winter generated a lot of data. Norm Dennis then came in and altered most of the data sets Dave had set up. Subsequently, other MS students Tim Aschenbrenner, Khalil Al Shafie, Kuan Chu, Magued Iskander, etc.) generated some new data. Most of the data so generated had obvious errors due to inexperience. I went through many of the tests and modified all of them. The variable ``REOChk`` was added and made true if I had examined the data. Subsequently, I changed many tests I had done. The result is that all of the data are in question. The main problem is that source documents did not contain critical information, or we did not understand what was critical and get it recorded. In some cases, a single case was reported in several papers with different results, or we talked with someone who knew the case, e.g., Bob Semple regarding West Sole and Kontich, and we were informed that the published data contained errors, but revised data were not available.

The source data forms, and format of the computer database have changed massively over the years. Originally, the entire digital database had to fit on one 360KB 5-1/4” floppy disk, the source forms were written in pencil on typed forms. As the forms evolved, we often, but not always, noted material as notes, and then later rewrote the form to include the needed information, but we never had time to go back to the source documents to extract the new data. The paper documentation now is digital and exceeds 1 GB, and this digital database exceeds 11,000 lines and occupies more than 600 KB. Because of limits on storage (PC’s were limited to 640 KB in RAM), the original data were much compressed, e.g., we might have reported only a single layer of clay being penetrated by the pile whereas there were, in fact, a number of layers.

The cone data are very deficient, mainly because of lack of use in the U.S. at the time of these cases.

Interpretation of the output from the analytical program is difficult unless the user can memorize data for all of the tests, which seems possible only for small subsets of data. To remind users of problems, the data base can have one field of up to 30 columns, starting with an ``*`` and that field is output in the Excel output, typically warning the user of problems. In addition, lines starting with ``!`` are comment lines in the database and are not processed in the analysis. The ``*`` and ``!`` lines come after the LTN BLANK line (needed in order to use the same code with Caltrans data) and before alphanumeric data.

This database has not been updated significantly since 1982 and there have been a lot of results published or provided from company files since then.

The APC database has been partially converted to a format used on a different project but there are a few remnants of material that were relevant to an earlier format so do not anticipate that every item in this database has a use currently.

I followed the LTN BLANK line with an ``*`` to indicate that I had checked this data base against the printed summary form.

We added the field for set-up time much later. I went back to find values for tests but I’m not currently clear (March 2004) as to the code used to indicate that the value is unknown. I suspect that both 0 and -1 were used to indicate lack of information. I will gradually try to convert to -1 for unknown but I lack time to recheck all such cases so I’ll put a note in the data set when I made such a change.

The original N values are quite uncertain because of the lack of data on hammer efficiency and the vague statements in some papers that N was the “standard penetration resistance” but there was no indication that it was the ASTM standard. For example, I suspect that “standard” may have been a local standard, e.g., from a highway department or a consulting firm.

The corrected N values here exceed the uncorrected values but I don’t remember how the correction was made. I suspect I assumed a hammer efficiency less than 60%.

I changed some CONC piles to RayC piles and changed some values of EVSO after looking at source data forms. Most of the piles had D=54 inches.

Defined failure occurs when Davisson’s criterion is satisfied, i.e., when S=+ 0.15” + 0.01Db. Generally, we used 29,000 ksi for the E of steel, 3000 ksi for unreinforced concrete, 4500 ksi for reinforced concrete, and 1700 ksi for timber. For tension tests we should ignore the tip term but it appears that in most cases we did not ignore that term. The ultimate load is the largest load that the pile sustained in the test. For piles in sand, the ultimate load was usually just the final load because plunging failure does not occur. There are some known inconsistencies in the ways we interpreted some data. For example, for a constant rate of penetration (CRP) test in clay, I reported the peak load as both the ultimate and defined failure loads whereas some of the students appear to have used Davisson’s criterion directly (it would come after “failure”) and defined ultimate as the final plunging load (less than the peak). Similarly, if a pile was loaded to failure, unloaded, and reloaded to a larger load than it could sustain the first time, I used the first loading only whereas some of my students may have used the second loading. For piles with a great length above the ground surface, e.g., offshore, we assumed that reported loads were butt loads and we increased the loads by the weight of the pile above the ground surface.

Table 8 Appendix: Olson APC Database Variables

Variable Name

Description

New DB Attribute Name

Comment

Normally a description of the project

projects.description

Warning

A field of up to 30 columns warning the user of problems

projects.warning

LTN

Load test number

projects.source_id

Type

Pile type. Allowed values are TIMB (timber), CIPC (cast-in-place concrete), CONC (precast concrete), STLP (steel pipe), HPIL (H piles) and RAYC (Raymond)

piles.type

Shape

Pile shape. Allowed values are SQRE (square, used for H piles as well as other square piles), CIRC (circular), OCTA (octagonal), and HEXA (hexagonal)

piles.shape

Load

Load direction. Available options: COMP, TENS

load_tests.direction

Len

The entire length of the pile used in the calculation of AE/L (feet)

piles.length

ExpL

Distance from the top of the pile to the exposed soil surface (feet)

piles.exp_length –> piles.emb_length

DR

The ratio of the area of pile material at the tip to the area of the enclosing geometric shape. For open-ended pipe piles it is (D-D)/D. If the pile was driven open ended and then drilled out and filled with concrete, this value was set at 1.0. If the pile has an oversized cover plate, the displacement ratio was set at 1.0 or larger

piles.dratio

Tapr

Boolean (T/F), TRUE for a tapered pile

piles.tapered

AEOL

AE/L in kips/inch

piles.aeol

Wgt

Pile weight (kips), not submerged

piles.weight

Site

Site name

projects.site_name

Loc

The geographic location of the load test

projects.location –> locations.description

PD

Diameter of a circular pile and distance across the flats for a square, octagonal, or hexagonal section (inches)

piles.diameter, taper_dims.diameter

LD(i)

For tapered piles only: Distance from pile butt to point i (feet)

taper_dims.length

CIR

Pile circumference (feet) (steel/soil for HPIL)

piles.circumference, taper_dims.circumference

PROF

Predominant soil. Available options: SAND, CLAY, or SACL

borings.predom_soil

NL

Number of soil layers

borings.layer_count

EWT

Elevation of water table from ground surface (feet), +1 to indicate that EWT was unknown

borings.ewt

SQF

Sample quality factor (0: nature of the sampler is unknown; 1: driven heavy-walled samplers, e.g., the standard sampler; 2: driven samplers of higher quality than for #1, e.g., offshore wireline samplers and Dames and Moore (D&M) sampler; 3: pushed 2” shelby tube (ST) samplers, driven 3” ST, Swedish foil sampler; 4: pushed thin-walled samplers, generally fixed piston, 3” or more; 5: top quality samples, generally trimmed samples taken using a fixed-piston thin-walled sampler, often 5” diameter; hand carved from blocks)

borings.sqf

IC

=0 if EVSO is fixed (perhaps a cased off upperlayer was left out of the compressed database but the EVSO values were calculated for the real profile which is not shown here), =1 if EVSO can be changed (means the whole profile is shown)

misc.i_code

Vib

Boolean (T/F), TRUE if any part of driving was by vibration

piles.vibro

REO

Boolean (T/F), TRUE if data was checked by Dr. Olson

misc.reo_check

TS

Boolean (T/F), TRUE if checked by an unknown party

misc.ts_check

UTB

Boolean (T/F), TRUE if University of Texas (UT) Boring

misc.ut_boring

UTS

Boolean (T/F), TRUE if University of Texas (UT) Sounding

misc.ut_sound

Case

Boolean (T/F), TRUE if cased

piles.cased

PDr

Boolean (T/F), TRUE if predrilled. The later data forms show evidence of preboring, where appropriate. In some cases, we suspect that the authors of the reports simply neglected to mention preboring. In other cases, they mentioned it in obscure places in the report (we found such cases). In many cases, piles were probably prebored and no mention is made in the report.

piles.predrilled

RDr

Boolean (T/F), TRUE if relief drilled

piles.relief_drilled

Jet

Boolean (T/F), TRUE if jetted

piles.jetted

Soil

Soil type (COBB, SICL, etc.)

layers.soil_type

HL

Soil layer thickness (feet)

layers.height

EVSO

Mean vertical effective stress (ksf)

layers.evso

TUW

Total unit weight (kcf)

layers.tuw

WC

Water content (%)

layers.water_content

LL

Liquid limit (%)

layers.liquid_limit

PI

Plasticity index (%)

layers.plasticity

UU

Unconfined shearing strength (ksf)

layers.ssuu

FV

Field vane shearing strength (ksf)

layers.ssfv

MS

Shearing strength from Torvane, penetrometer, etc. (ksf)

layers.ssms

QT

Shearing strength from Q triaxials (ksf)

layers.ssqt

N

Measured (uncorrected) N value (bpf). This is all we have now because details of the techniques were rarely reported and the data were never reported by us. Most of the older data used a manual drop hammer (low efficiency) and the rods were 3/4 in. heavy duty water pipe (low efficiency)

layers.nval

Nc

N values corrected to 60% efficiency (bpf).

layers.cnval

QC

Cone tip resistance (ksf)

layers.qc

FSL

Cone sleeve shear (ksf)

layers.fsl

QCT

Measured capacity at 0.5-inch butt settlement (kips)

interp_capacities

QMDT

Measured capacity at Davisson’s point (kips)

interp_capacities

QMP

Peak applied load (kips)

interp_capacities

QBF

Capacity extrapolated per Brown-Fleming (kips)

interp_capacities

SFD

Butt settlement at Davisson’s failure point (inches)

interp_capacities

SFP

Butt settlement at 95% of the peak applied load (inches)

interp_capacities

DQF

Data quality factor. The DQF represents our qualitative view of the overall quality of the data. (5) indicates outstanding data. Generally we knew the author. There were soil borings very close to the pile and numerous soil tests were performed. The SQF was high. The soil profile was uniform enough that we thought the soil conditions at the load test point were well known. There was a reasonable set-up time for the pile. The pile was often instrumented. (1) indicates major uncertainties. For example, the soil profile may vary widely from place to place on a site and there is no boring right next to the pile. In other cases the only measure of clay strength is an N value. In some cases the measured soil properties scattered greatly with respect to depth. In some cases the driving record did not compare with the soil profile, e.g., a sudden increase in driving resistance at the end when there was no evidence of a stronger layer at that depth.

projects.dqf

SetUpTm

Set up time (days)

load_tests.setup_time

Ref

The reference number (reference to a paper, report, etc.) from the reference list in a separate file

projects.source_ref

Iowa PILOT Database Tables and Attributes

Table 9 Appendix: Iowa PILOT Database Pile Load Test Records Table Attributes

Original Attribute

Description

Sample Record

New Attribute

ID

A unique cataloging number automatically assigned by Microsoft Office Access to each record within PILOT.

269

projects.source_id

Test Folder

A database field that specifies the location of the pile load test records for each load test contained within the database. The directory housing these various pile load test records, the Pile Load Tests Records Directory, is organized by three volumes. Volume 1 consists of pile load test records for steel H-piles, Volume 2 consists of pile load test records for prestressed concrete, Monotube, and steel pipe piles, Volume 3 consists of pile load test records for timber piles, and Volume 4 consists of pile load test records for those piles tested as a part of IHRB Project TR-583 (Ng et al., 2010). Therefore, the possible entries into this database field are as follows: Volume 1, Volume 2, Volume 3, or Volume 4.

Volume 4

misc.iowa_test_folder

Lab Number

The identification number used by the Iowa DOT to distinguish between the various test piles (e.g., AXP0-1, AXP1-9, etc.).

ISU5

misc.iowa_lab_number

Contractor

The name of the contracting company responsible for the construction of the specified bridge project including driving of the test pile.

Herberger Construction Co., Inc.

projects.contractor

Project Number

The unique Iowa DOT cataloging number assigned to each construction project.

BRFIMX-035-1(105)33–14-20

projects.number

Design Number

This database field goes hand in hand with the previously described field (Project Number). For every construction project in the State of Iowa, in addition to assigning a unique project number, each bridge project within the construction project is assigned a unique design number. The bridge design number corresponding to a specified pile load test is entered into this database field.

109

misc.iowa_design_number

County

This database field utilizes a drop-down menu for simple selection of the Iowa County in which the specified bridge construction project is located.

Clarke

locations.county

Township

This field allows one to manually enter the name of the township corresponding to the location of the specified Iowa bridge construction project.

Ward (T-72-N R-26-W)

locations.township

Section

This numerical database field allows one to manually enter the section number in which the specified Iowa bridge construction project is located.

24

misc.iowa_section

Pile Location

This text database field allows one to manually enter a short description of the test pile location in relation to the features of the bridge under construction. For instance, a typical description will specify if the test pile was located near an abutment or a pier. Furthermore, either the pile number or a detailed narrative identifying the exact location of the pile within the abutment or pier is usually provided.

South Side of U.S. 34 Median - East of the East Abutments

locations.description

Tested By

This text database field allows one to manually enter the names of those people who were responsible for carrying out the pile load test on the specified pile.

AbdelSalam - Ng - Roling

load_tests.tested_by

Date Tested

In this database field, which has been formatted to accept dated entries of the form: Month/Day/Year (e.g., 3/8/1984), the date on which the pile static load test was conducted on the specified pile is specified.

5/28/2009

load_tests.date_tested

Date Reported

In this database field, which has been formatted to accept dated entries of the form: Month/Day/Year (e.g., 3/8/1984), the date on which the pile load test results for the specified pile were reported to the Iowa DOT is specified.

4/27/2010

misc.iowa_date_reported

Pile Type

This database field utilizes a drop-down menu for simple selection of the test pile type and size. The options available for selection in this database field are as follows: Steel H-Piles (10X42, 10X57, 12X53, 12X74, 14X73, 14X89, and Steel H – a generic option that may be utilized for instances where the exact Steel H pile size is unknown), Monotube Piles, Steel Pipe Piles (10-in, 12-in, 16-in, and 18-in outside diameter), and Timber Piles (18-ft, 20-ft, 25-ft, 30-ft, 34-ft, 35-ft, 40-ft, 45-ft, 50-ft, 55-ft, and 60-ft length or Timber – a generic option that may be utilized for instances where the exact timber pile length is unknown).

HP 10X42

piles.type and piles.shape

Date Driven

In this database field, which has been formatted to accept dated entries of the form Month/Day/Year (e.g., 3/8/1984), the date on which the specified test pile was driven is included.

5/19/2009

piles.date_driven

Design Load

(TONS) This database field specifies the total sum of all design loads for which any given pile in the structure is anticipated to support based on the superstructure loading evaluation accomplished using either WSD or LRFD principles. In other words, the given pile must possess a bearing resistance equal to or greater than this value to ensure the safety of the structure. For all piles driven prior to October 1, 2007, the reported value in this field corresponds to the WSD design load while LRFD design load is included for all piles driven after this date, since it corresponds to the FHWA’s mandate on the use of LRFD for all new bridge construction.

N/A

piles.design_load

Formula Bearing (TONS)

This database field specifies the anticipated bearing resistance for a given pile as determined through the use of the Iowa DOT Modified ENR dynamic pile driving formula, which is supplied in Article 2501.13 of the Iowa Department of Transportation Standard Specifications, Series 2008 (Iowa DOT, 2008) and is discussed in more detail in Chapter 3 of AbdelSalam et al. (2010).

38.3

calc_capacities.load of type ‘Bearing Iowa DOT Modified ENR’

Hammer Type

This database field contains information about the type of hammer used for driving the test pile. Examples of possible entries into this database field include: Gravity, Kobe K-13, and Delmag D-12; the last two examples specify both a brand and series number.

Delmag D16-32

installations.hammer_type

Initial Bored Hole Depth (FEET)

Depth of Hole Bored before Driving Pile (ft): The depth, in feet, of the hole bored to initiate pile driving of the specified test pile. (A value of zero in this field indicates that no hole was bored prior to driving.)

0

piles.predrill_depth

Embedded Pile Length (FEET)

Length of Test Pile in Contact with the Soil (ft): The length, in feet, of the test pile in direct contact with the soil

55

piles.emb_length

Pile Toe Elevation (FEET)

Elevation at the Bottom Tip of the Test Pile (ft): The elevation, in feet, at which the toe of the driven test pile resides with reference to the mean sea level datum.

N/A

piles.toe_elevation

Maximum Applied Load (TONS)

Highest Gauge Reading Under ### Ton Load (in): Based upon the SLT results for the specified pile, the maximum load experienced by the pile is recorded where the number signs (i.e., ###) appear in the above statement and the displacement gauge reading, in inches, corresponding to this maximum applied load is included in the database.

131.5

interp_capacities.load of type ‘Maximum Load’

Highest Gauge Reading (INCHES)

(description as above)

0.53

interp_capacities.displacement of type ‘Maximum Load’

Rebound Time Duration (MINUTES)

Gauge Reading after Load Released for ### Minutes (in): The final entry into each record’s static load test table shows a load of zero tons and a corresponding non-zero gauge reading. This gauge reading represents the rebound of the specified pile after the release of the maximum applied vertical load for a given period of time. The time between the release of the maximum applied load to the pile and the subsequent recording of the final gauge reading is added where the number signs (i.e., ###) appear in the above statement. The final gauge reading, in inches, is then specified in the database.

10

load_tests.rebound_time

Rebound Gauge Reading (INCHES)

(description as above)

0.558

load_tests.rebound_displacements

Record Complete

All Record Data Entered?: This yes/no database field was created mostly for the one(s) responsible for the data entry procedures, so that an easy distinction could be made between those records still requiring data to be entered and those that had been termed complete. When all available information has been entered for a specific record, this field receives a check mark.

YES

misc.iowa_record_complete

Record Comments

Any pertinent additional information regarding the record as a whole is included in this text database field.

N/A

Attachments (1)

These six hyperlink database fields were created so that important information related to each pile load test could be easily accessed from the PLTRF. The hyperlinked text descriptions found within these database fields maintain a direct path to the file of interest.

(hyperlink)

attachments.file_name and attachments.file_url

Attachments (2)

(description as above)

N/A

attachments.file_name and attachments.file_url

Attachments (3)

(description as above)

N/A

attachments.file_name and attachments.file_url

Attachments (4)

(description as above)

N/A

attachments.file_name and attachments.file_url

Attachments (5)

(description as above)

N/A

attachments.file_name and attachments.file_url

Attachments (6)

(description as above)

N/A

attachments.file_name and attachments.file_url

Davisson Pile Capacity (TONS)

Utilizing the static load test results supplied for each pile, the Davisson failure criterion was utilized to determine the ultimate pile capacity (i.e., the dependable pile resistance). The Davisson failure criterion states that the ultimate load of a pile subjected to a vertical load test is the load which the displacement of the pile exceeds the elastic compression of the pile by 0.15 + D/120 inches, where D is the pile depth or diameter (Davisson, 1972). The elastic compression of the pile is simply the length of the pile divided by its elastic modulus and cross-sectional area (i.e., the pile stiffness), then multiplied by the applied load. The Davisson pile capacity established for each pile SLT is provided in this numerical database field.

121

interp_capacities.load of type ‘Standard Davisson’

Static Load Test Remarks

Any additional comments or information relating to the pile SLT results are supplied in this text database field. Examples of information presented in this database field include the time duration step used for each load increment and pertinent test reliability information such as observed pile punching, pulling out of anchor piles, or no observed yielding of the test pile.

N/A

load_tests.remarks

Load Test Reliability Classification

This yes/no database field receives a checkmark if the SLT data for the specified pile is considered reliable. A reliable test is one in which the test pile reached its displacement-based capacity (i.e., the Davisson pile capacity) with no anchor piles being pulled out prior to its achievement. If the SLT data for a specified test pile does not meet this criterion, then the test is considered unreliable and this database field is left unchecked.

YES

load_tests.reliable

Total Soil Profile Thickness (FEET)

This database field refers to the average soil profile table. Based upon the average soil layer data found in this table, the sum of the thicknesses of the various soil strata identified in the table is reported in this field.

55

(skipped, can be calculated)

Total Skin Friction (TONS)

Calculated Total Skin Friction Using Design Charts (Tons): This field refers to the average soil profile table. Based upon the average soil layer data found in this table, the sum of the total skin friction values listed for each of the various soil strata identified in the table is reported in this database field.

71.2

(skipped, can be calculated)

Theoretical End Bearing (TONS)

Calculated End Bearing Using Design Charts (Tons): The value input into this field is determined through the use of the average soil profile table and the design chart found in the Iowa LRFD Bridge Design Manual (Iowa DOT, 2010). Based upon the average blow count (i.e., NAVG) value obtained for the soil layer in which the test pile toe resides and the aforementioned design chart, a nominal end bearing value is established and recorded into this database field.

3.1

calc_capacities.load of type ‘Iowa Theoretical End Bearing’

Theoretical Pile Capacity (TONS)

Total Pile Capacity Using Design Charts (Tons): The value input into this database field is the result of the addition of the value for Calculated Total Skin Friction Using Design Charts and the value for Calculated End Bearing Using Design Charts.

74.3

calc_capacities.load of type ‘Iowa Theoretical Capacity’

Factor of Safety

Capacity Ratio: The value entered into this database field is the result of dividing the value for Davisson Pile Capacity by the value for Design Load.

N/A

(skipped, can be calculated)

Test Site Soil Classification

This database field holds the predominant soil medium (i.e., sand, clay, or, mixed) encountered along the shaft of the test pile. When at least two soil types are present along the shaft of the test pile and none account for 70 percent or more of the soil profile encountered along the shaft of the test pile, then a mixed soil classification is used to describe the predominant soil medium.

Clay

borings.predom_soil

Total Number of Boreholes

The total number of boreholes drilled for the corresponding construction project. This information is taken from the relevant project Situation Plan Sheet.

9

misc.iowa_borehole_count

Boreholes With SPT Data

Total Number of Borehole with SPT Data: The total number of boreholes possessing soil penetration data or SPT N-values. This information is taken from the relevant project Sounding Data Plan Sheet.

2

misc.iowa_spt_count

Borehole at Test Pile Location

Borehole(s) near Test Pile Location: This yes/no database field receives a checkmark if a borehole is located within 100 feet of the specified test pile location. If no borehole is located within 100 feet of the test pile location, the field is left without a checkmark.

YES

misc.iowa_borehole_near_pile

Borehole Numbers at Test Pile Location

When the Borehole(s) at Test Pile Location database field is checked, the identification number associated with each of the boreholes located within 100 feet of the test pile location is reported in this text database field. Otherwise, if no boreholes are located within 100 feet the test pile location, the word ‘None’ is entered into this database field.

ISU5 - Conducted by TEAM Services

borings.remarks added with attribute name

SPT at Test Pile Location

SPT Data Available near Test Pile Location: When any of the boreholes listed in the Borehole(s) at Test Pile Location database field possess SPT data, then the identification number of such boreholes is repeated in this database field. If none of the boreholes listed in the Borehole(s) at Test Pile Location database field have SPT data, then the word ‘None’ appears in this database field. Although, if the soil profile at the test pile location matches that of any of the boreholes with SPT data, even though these boreholes are not located at or within 100 feet of the test pile location, the resulting information for such boreholes is also provided in the soil profile table.

ISU5 - Conducted by TEAM Services

borings.remarks added with attribute name

Usable-Static Test

This yes/no database field receives a checkmark if a checkmark already exists in the Reliable Load Test? database field and if there is acceptable SPT data available at or within 100 feet of the test pile location.

YES

(skipped)

Water Table Location (FEET??)

The elevation at which the groundwater table is encountered at the site of the test pile is included in this database field. Such information is taken from the relevant Sounding Data Plan Sheet.

36 feet Below Ground Surface

borings.remarks added with attribute name; infer from toe elevation and enter in borings.ewt

Pile Length (FEET)

The total length of pile, in units of feet, placed in the leads of the pile driving rig is inserted into this database field.

60

piles.length

Pile Cross-Sectional Area (SQ. INCHES)

The total cross-sectional area, in units of square inches, of the pile driven for load testing purposes is inserted into this database field.

12.4

piles.cross_area

Weight of Pile (LBS)

The total weight, in units of pounds, of the pile driven for load testing purposes is inserted into this database field. This pile weight should be in agreement with the length of pile specified in the database field Driven Pile Length.

2520

piles.weight

Effective Weight of Hammer (LBS)

Hammer (Ram) Weight (lb): This numerical database field presents the total dynamic weight, in units of pounds, of the hammer used for driving the test pile. The dynamic weight of the hammer is determined by taking the total static weight of the hammer less such deductions resulting from air resistance, lead friction, etc.

3520

installations.ram_weight

Weight of Cap (LBS)

The total weight of the cap, in units of pounds, used while driving the test pile is inserted into this database field.

2050

installations.cap_weight

Weight of Anvil (LBS)

The total weight of the anvil, in units of pounds, used while driving the test pile is inserted into this database field.

810

installations.anvil_weight

Hammer Stroke (FEET)

The average height above the pile head, in units of feet, from which the hammer is dropped during the final five to ten blows of driving is recorded in this database field.

6.97

installations.hammer_stroke

Hammer Energy (FT-TONS)

Developed Hammer Energy (ft-tons): The total developed energy, in units of foot-pounds, imparted by the hammer to the test pile is recorded in this database field. Simply put, the total developed energy is determined by multiplying the hammer (ram) weight with the hammer stroke.

12.32

installations.hammer_energy

Number of Hammer Blows per Foot of Pile Penetration (BLOWS/FT)

Average Number of Blows per Foot of Pile Penetration (blows/ft): The average number of blows needed to advance the test pile tip one foot near the end of driving is recorded in this database field. This value is determined from the average penetration of the test pile over the last five to ten blows (i.e., five blows for gravity hammers and 10 blows for steam or diesel hammers) as recorded on the Log of Piling Driven record.

42.86

installations.hammer_blows

Usable-Dynamic Test

This yes/no database field receives a checkmark if a checkmark already exists in the Usable-Static Test? database field and if complete driving records and information concerning characteristics of the pile driving equipment are available for the test pile.

YES

(skipped)

Blue Book Capacity (TONS)

Pile Capacity by Iowa Blue Book Method (Tons): The nominal pile capacity, in tons, predicted by the Iowa Blue Book static analysis method (Dirks and Kam 1989, revised 1994; AbdelSalam et al. 2010) is placed in this field.

102.5

calc_capacities.load of type ‘Iowa Blue Book Method’

SPT Capacity (TONS)

Pile Capacity by SPT Method (Tons): The nominal pile capacity, in tons, predicted by the SPT-Meyerhof static analysis method (Meyerhof, 1976) is placed in this field.

44

calc_capacities.load of type ‘Meyerhof’

Alpha Capacity (TONS)

Pile Capacity by Alpha-API Method (Tons): The nominal pile capacity, in tons, predicted by the alpha-API (American Petroleum Institute) static analysis method (API, 1984) is placed in this field.

76.5

calc_capacities.load of type ‘API 1984’

Beta Capacity (TONS)

Pile Capacity by Beta Method (Tons): The nominal pile capacity, in tons, predicted by the beta static analysis method (Burland, 1973) is placed in this field.

139.5

calc_capacities.load of type ‘Beta Burland 1973’

Nordland Capacity (TONS)

Pile Capacity by Nordlund Method (Tons): The nominal pile capacity, in tons, predicted by the Nordlund static analysis method (Nordlund, 1963) is placed in this field.

97

calc_capacities.load of type ‘Nordlund’

WEAP Capacity (TONS)

Pile Capacity by WEAP (Tons): The nominal pile capacity, in tons, as predicted by the Wave Equation Analysis Program (Pile Dynamics, Inc., 2005) is placed in this field.

N/A

installations.weap_capacity (no data)

WEAP Quake (Shaft)

Shaft Quake used in WEAP Analysis: The elastic compression limit or quake, in units of inches, for soil located along the shaft of the test pile that was used to determine the WEAP pile capacity is placed in this field.

N/A

installations.weap_shaft_quake (no data)

WEAP Quake (Tip)

Toe Quake used in WEAP Analysis: The elastic compression limit or quake, in units of inches, for soil located at the toe of the test pile that was used to determine the WEAP pile resistance is placed in this field.

N/A

installations.weap_tip_quake (no data)

WEAP Damping (Shaft)

Shaft Damping Factor used in WEAP Analysis: The damping factor for soil located along the shaft of the test pile that was used to determine the WEAP pile resistance is placed in this field.

N/A

installations.weap_shaft_damping (no data)

WEAP Damping (Tip)

Toe Damping Factor used in WEAP Analysis: The damping factor for soil located at the toe of the test pile that was used to determine the WEAP pile capacity is placed in this field.

N/A

installations.weap_tip_damping (no data)

PDA Capacity (TONS)

Pile Capacity from PDA (Tons): The nominal pile capacity, in tons, as predicted by PDA (Pile Dynamics, Inc., 1992) is placed in this field.

N/A

installations.pda_capacity (no data)

PDA Case Damping

Case Damping Factor used by PDA: The Case damping factor utilized by PDA to predict the ultimate capacity of the test pile is reported in this field.

N/A

installations.pda_case_damping (no data)

CAPWAP Capacity (TONS)

Pile Capacity from CAPWAP (Tons): The nominal pile capacity, in tons, as predicted by the CAse Pile Wave Analysis Program (Pile Dynamics, Inc., 2000) is placed in this field.

N/A

installations.capwap_capacity (no data)

Smith Damping Factor (Shaft)

Smith Shaft Damping Factor Calculated by CAPWAP: The damping factor for soil located along the shaft of the test pile that was calculated by CAPWAP in predicting the pile capacity is placed in this field.

N/A

installations.smith_shaft_factor (no data)

Smith Damping Factor (Toe)

Smith Toe Damping Factor Calculated by CAPWAP: The damping factor for soil located at the toe of the test pile that was calculated by CAPWAP in predicting the pile capacity is placed in this field.

N/A

installations.smith_toe_factor (no data)

Quake (Shaft) (INCHES)

Shaft Quake Calculated by CAPWAP: The elastic compression limit or quake, in units of inches, for soil located along the shaft of the test pile that was calculated by CAPWAP in predicting the pile capacity is placed in this field.

N/A

installations.capwap_shaft_quake (no data)

Quake (Toe) (INCHES)

Toe Quake Calculated by CAPWAP: The elastic compression limit or quake, in units of inches, for soil located at the toe of the test pile that was calculated by CAPWAP in predicting the pile capacity is placed in this field.

N/A

installations.capwap_toe_quake (no data)

Case Damping Factor (Shaft)

Case Shaft Damping Factor Calculated by CAPWAP: The Case damping factor for soil located along the shaft of the test pile that was calculated by CAPWAP in predicting the pile capacity is reported in this field.

N/A

installations.capwap_shaft_factor (no data)

Case Damping Factor (Toe)

Case Toe Damping Factor Calculated by CAPWAP: The Case damping factor for soil located at the toe of the test pile that was calculated by CAPWAP in predicting the pile capacity is reported in this field.

N/A

installations.capwap_toe_factor (no data)

ENR Capacity (TONS)

Pile Capacity by ENR Formula (Tons): The nominal pile capacity, in tons, as predicted by the Engineering News Record formula (Wellington, 1893) is reported in this field.

387

calc_capacities.load of type ‘ENR Formula’

Modified ENR Capacity (TONS)

Pile Capacity by Iowa DOT Modified ENR Formula (Tons): The nominal pile capacity, in tons, as predicted by the Iowa DOT Modified Engineering News Record formula (Iowa DOT, 2008) is reported in this field.

153

calc_capacities.load of type ‘Iowa DOT Modified ENR’

Gates Capacity (TONS)

Pile Capacity by Gates Formula (Tons): The nominal pile capacity, in tons, as predicted by the Gates formula (Gates, 1957) is reported in this field.

96

calc_capacities.load of type ‘Gates Formula’

FHWA Modified Gates Capacity (TONS)

Pile Capacity by FHWA Modified Gates Formula (Tons): The nominal pile capacity, in tons, as predicted by the FHWA Modified Gates formula (AASHTO, 2007) is reported in this field.

163

calc_capacities.load of type ‘FHWA Modified Gates Formula’

Janbu Capacity (TONS)

Pile Capacity by Janbu Formula (Tons): The nominal pile capacity, in tons, as predicted by the Janbu formula (Bowles, 1996) is reported in this field.

122

calc_capacities.load of type ‘Janbu Formula’

PCUBC Capacity (TONS)

Pile Capacity by Pacific Coast Uniform Building Code Formula (Tons): The nominal pile capacity, in tons, as predicted by the Pacific Coast Uniform Building Code formula (Bowles, 1996) is reported in this field.

100

calc_capacities.load of type ‘Pacific Coast Uniform Building Code Formula’

WSDOT Capacity (TONS)

Pile Capacity by Washington Department of Transportation Formula (Tons): The nominal pile capacity, in tons, as predicted by the Washington State Department of Transportation formula (Allen, 2005) is reported in this field.

136

calc_capacities.load of type ‘Washington DOT Formula’

PDA Monitoring

Was PDA used to monitor the pile during driving or restrike?: This yes/no database field receives a checkmark when the PDA device is used to monitor the installation of the test pile, which must be instrumented with accelerometers and strain transducers near the pile head, and assess its bearing resistance at either the EOD or BOR conditions; otherwise, this database field is left unchecked.

YES

(skipped; data will be available if true)

EOD Date/Time

EOD Date/Time: In this database field, which has been formatted to accept dated entries of the form: Month/Day/Year Time-of-Day (e.g., 3/8/1984 10:12:55 AM), the date and time at which the EOD condition was achieved is input.

5/19/2009 12:11:55

installations.pda_eod_date

EOD Capacity (KIPS)

EOD Capacity (kips): The maximum static pile resistance estimate, in units of kips, provided by PDA at the EOD (i.e., RMX).

195

installations.pda_eod_capacity

1st Restrike Date/Time

In this database field, which has been formatted to accept dated entries of the form: Month/Day/Year Time-of-Day (e.g., 3/8/1984 10:12:55 AM), the date and time corresponding to the beginning of the first restrike are added.

5/19/2009 12:19:40

pda_restrikes.date_time

Capacity After 1st Restrike (KIPS)

This field represents the maximum static pile resistance estimate, in units of kips, provided by PDA at the beginning of the first restrike (i.e., RMX).

220

pda_restrikes.capacity

2nd Restrike Date/Time

In this database field, which has been formatted to accept dated entries of the form: Month/Day/Year Time-of-Day (e.g., 3/8/1984 10:12:55 AM), the date and time corresponding to the beginning of the second restrike are inserted.

5/19/2009 12:30:00

pda_restrikes.date_time

Capacity After 2nd Restrike (KIPS)

This field represents the maximum static pile resistance estimate, in units of kips, provided by PDA at the beginning of the second restrike (i.e., RMX).

222

pda_restrikes.capacity

3rd Restrike Date/Time

In this database field, which has been formatted to accept dated entries of the form: Month/Day/Year Time-of-Day (e.g., 3/8/1984 10:12:55 AM), the date and time corresponding to the beginning of the third restrike are input.

5/19/2009 13:20:39

pda_restrikes.date_time

Capacity After 3rd Restrike (KIPS)

This field represents the maximum static pile resistance estimate, in units of kips, provided by PDA at the beginning of the third restrike (i.e., RMX).

243

pda_restrikes.capacity

4th Restrike Date/Time

In this database field, which has been formatted to accept dated entries of the form: Month/Day/Year Time-of-Day (e.g., 3/8/1984 10:12:55 AM), the date and time corresponding to the fourth restrike are added.

5/20/2009 10:13:04

pda_restrikes.date_time

Capacity After 4th Restrike (KIPS)

This field represents the maximum static pile resistance estimate, in units of kips, provided by PDA at the beginning of the fourth restrike (i.e., RMX).

330

pda_restrikes.capacity

5th Restrike Date/Time

In this database field, which has been formatted to accept dated entries of the form: Month/Day/Year Time-of-Day (e.g., 3/8/1984 10:12:55 AM), the date and time corresponding to the fifth restrike are inserted.

5/22/2009 9:52:09

pda_restrikes.date_time

Capacity After 5th Restrike (KIPS)

This field represents the maximum static pile resistance estimate, in units of kips, provided by PDA at the beginning of the fifth restrike (i.e., RMX).

374

pda_restrikes.capacity

6th Restrike Date/Time

In this database field, which has been formatted to accept dated entries of the form: Month/Day/Year Time-of-Day (e.g., 3/8/1984 10:12:55 AM), the date and time corresponding to the sixth restrike are input.

5/27/2009 10:09:46

pda_restrikes.date_time

Capacity After 6th Restrike (KIPS)

This field represents the maximum static pile resistance estimate, in units of kips, provided by PDA at the beginning of the sixth restrike (i.e., RMX).

402

pda_restrikes.capacity

Pressure Cells

Were Push-In Pressure Cells used to monitor lateral earth and porewater pressure?: This yes/no database field receives a checkmark if one or more push-in pressure cells were installed near the location of the test pile for acquisition of horizontal stress and porewater pressure data; otherwise, this database field is left unchecked.

YES

(skipped; data referenced but not available)

Number of Pressure Cells Used

When the database field Were Push-In Pressure Cells used to monitor lateral earth and porewater pressure? is true, the total number of push-in pressure cells installed near the location of the test pile is reported in this text database field.

2

(skipped; data referenced but not available)

Depths of Pressure Cells

When the database field Were Push-In Pressure Cells used to monitor lateral earth and porewater pressure? is true, the depths to which each of the push-in pressure cells identified in the database field *Number of Pressure Cells Used were installed are reported in this text database field.

Cell #1: 23.17 ft; Cell #2: 23.25 ft

(skipped; data referenced but not available)

Pressure Cell Data

Complete Pressure Cell Data: This hyperlink database field allows for the establishment of a direct path to the file(s) holding all data acquired from the installed push-in pressure cells.

(link to local directory)

(skipped; data referenced but not available)

CPT Test

Was a Cone Penetration Test (CPT) Performed?: This yes/no database field receives a checkmark if one or more CPTs were performed near the location of the test pile; otherwise, this database field is left unchecked.

YES

(skipped; data referenced but not available)

Number of CPT Soundings

When the database field Was a Cone Penetration Test (CPT) Performed? is true, the total number of soundings performed near the location of the test pile is reported in this text database field.

3

(skipped; data referenced but not available)

Number of Pore Pressure Dissipation Tests

When the database field Was a Cone Penetration Test (CPT) Performed? is true, the number of pore pressure dissipation tests conducted in conjunction with each of the CPT soundings identified in the database field Number of CPT Soundings is reported in this text database field.

1

(skipped; data referenced but not available)

Cone Penetration Test (CPT) Data

This hyperlink database field allows for the establishment of a direct path to the file(s) holding all data acquired from the various CPTs performed near the location of the test pile.

(link to local directory)

(skipped; data referenced but not available)

BST

Was a Borehole Shear Test (BST) Performed?: This yes/no database field receives a checkmark if one or more BSTs were performed near the location of the test pile; otherwise, this database field is left unchecked.

YES

(skipped; data referenced but not available)

Number of BSTs

Number of BSTs Performed: When the database field Was a Borehole Shear Test (BST) Performed? is true, the total number of BSTs performed near the location of the test pile is reported in this text database field.

1

(skipped; data referenced but not available)

Depths of BSTs

When the database field Was a Borehole Shear Test (BST) Performed? is true, the depths at which each of the BSTs identified in the database field Number of BSTs Performed were performed are reported in this text database field.

Test #1: 8.83 ft, 23.83 ft, 35.83 ft

(skipped; data referenced but not available)

Borehole Shear Test (BST) Data

This hyperlink database field allows for the establishment of a direct path to the file(s) holding all data acquired from the various BSTs performed near the location of the test pile.

(link to local directory)

(skipped; data referenced but not available)

Table 10 Appendix: Iowa PILOT Database Average Soil Profile Table Attributes

Original Attribute

Description

Sample Record

New Attribute

ID

Unique identifier for the table.

[1923, 1924, …]

layers.id

Record ID

Field that references the project ID.

[269, 269, …]

referenced through borings

Soil Layer

Soil layer index.

[1, 2, …]

layers.index

Material Description

Description of soil conditions.

[Clay, Silty Clay to Clay, …]

layers.description

Thickness (FEET)

Layer thickness, in feet.

[25, 4, …]

layers.height

NAVG (BLOWS/FT)

Average SPT blow count.

[12, N/A, …]

layers.nval

Unit Friction (KIPS/FT)

Nominal unit skin friction value specified by the design chart found in the Iowa LRFD Bridge Design Manual (Iowa DOT, 2010) for each soil layer.

[1.2, 1.2, …]

layers.iowa_unit_friction

Total Friction (KIPS/FT)

Total soil layer nominal skin friction value resulting from the multiplication of the soil layer thickness by the nominal unit skin friction value.

[30, 4.8, …]

layers.iowa_total_friction

Table 11 Appendix: Iowa PILOT Database Borehole/SPT Information Table Attributes

Original Attribute

Description

Sample Record

New Attribute

ID

Unique identifier for the table.

[5582, 5583, …]

spt_data.id

Record ID

Field that references the project ID.

[269, 269, …]

referenced through borings

Borehole Number

[ISU5, …]

borings.name

Soil Layer

Soil layer index.

[1, 2, …]

spt_data.index

Description

Description of soil conditions.

[Dark Brown SLC, Gray-Olive SLC, …]

spt_data.description

Depth (FEET)

Layer thickness, in feet.

[2, 8, …]

spt_data.depth

Average SPT Value (BLOWS/FT)

Average SPT blow count.

[N/A, 6, …]

spt_data.nval

Table 12 Appendix: Iowa PILOT Database Static Load Test Results Table Attributes

Original Attribute

Description

Sample Record

New Attribute

ID

Unique identifier for the table.

[8657, 8658, 8659, 8660, 8661, 8662, 8663, 8664, 8665, 8666, …]

static_tests.id

Record ID

Field that references the project ID.

[269, 269, …]

referenced through load_tests

Load (TONS)

[0, 6.82, 14.41, 21.43, 29.05, 35.95, 44.8, 51.23, 59.08, 66.66, …]

static_tests.load

Gauge Reading (INCHES)

[0, 0.008, 0.02, 0.03, 0.05, 0.07, 0.09, 0.11, 0.14, 0.16, …]

static_tests.displacement

FHWA DFLTD v.2 Tables and Attributes

Note

All information in this section comes from Petek et al., 2016 and Shannon & Wilson, 2015.

Hint

The units based on which values were stored in relevant columns had to be determined from stored data, there was no mention in existing documentation.

Project Table

Name:

tbl_Project

Description:

Project descriptive data, e.g. project name, data provider, consultant etc.

Table 13 Appendix: FHWA DFLTD v.2 tbl_Project Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

projects.source_id

txt_SourceDb

nvarchar(15)

YES

projects.source_db

txt_ProjectName

nvarchar(255)

YES

projects.site_name

txt_Address

nvarchar(255)

YES

locations.address

txt_City

nvarchar(255)

YES

locations.city

txt_County

nvarchar(55)

YES

locations.county

txt_StateCode

nvarchar(2)

YES

locations.state

txt_CountryCode

nvarchar(5)

YES

locations.country

txt_USCSPredominant

nvarchar(25)

YES

txt_ASTMPredominant

nvarchar(25)

YES

(empty)

txt_ASTMLegacy

nvarchar(80)

YES

dbl_Latitude

float

YES

locations.latitude

dbl_Longitude

float

YES

locations.longitude

txt_VerticalDatumCode

nvarchar(25)

YES

(mostly empty)

txt_HorizontalDatumCode

nvarchar(25)

YES

(empty)

txt_GeologicProvinceCode

nvarchar(25)

YES

txt_GeologicUnit

nvarchar(255)

YES

txt_GeneralSoilDescription

nvarchar(50)

YES

borings.predom_soil

txt_ProjectID

nvarchar(100)

YES

projects.number

txt_Title

nvarchar(100)

YES

projects.title

mem_Remarks

nvarchar(-1)

YES

projects.description

txt_Owner

nvarchar(255)

YES

(empty)

txt_DataSourceCompanyAgency

nvarchar(255)

YES

txt_DataSourceFirstname

nvarchar(50)

YES

txt_DataSourceLastname

nvarchar(50)

YES

txt_DataSourcePhone

nvarchar(20)

YES

txt_DataSourceEmail

nvarchar(255)

YES

txt_PrimeConsultant

nvarchar(50)

YES

txt_GeotechnicalConsultant

nvarchar(50)

YES

txt_GeneralContractor

nvarchar(50)

YES

projects.contractor

txt_Publication

nvarchar(-1)

YES

projects.source_ref

txt_CreatedBy

nvarchar(20)

YES

(unusable)

dte_AddDate

datetime2

YES

projects.date_added

txt_ModifiedBy

nvarchar(20)

YES

(unusable)

dte_ModifiedDate

datetime2

YES

projects.date_modified

Exploration Tables

Name:

tbl_Exploration

Description:

Exploration general descriptive data, e.g. exploration type, location, date, predominant soil unit, etc.

tbl_Exploration.png

Fig. 9 Appendix: DFLTD v.2 tbl_Exploration Table Relationships

Table 14 Appendix: FHWA DFLTD v.2 tbl_Exploration Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

borings.name

txt_KeyExplorationType (PK)

nvarchar(12)

NO

txt_ExplorationSubType

nvarchar(255)

YES

dte_ExplorationDate

datetime2

YES

(LDOEP only)

txt_ExplorationHammerTypeCode

nvarchar(10)

YES

(LDOEP only and mostly unknown)

dbl_HammerEfficiency

float

YES

%

(mostly empty)

dbl_ConeDiameter

float

YES

mm

(mostly empty)

dbl_ConeAngle

float

YES

deg

dbl_ConeBaseArea

float

YES

mm2

(empty)

dbl_RodDiameter

float

YES

mm

(empty)

txt_ConeType

nvarchar(255)

YES

dbl_CPTRatioa

float

YES

n/a

(empty)

dbl_CPTRatiob

float

YES

n/a

(empty)

txt_PMTInstallMethodCode

nvarchar(255)

YES

(empty)

txt_PMTDeviceTypeCode

nvarchar(5)

YES

(empty)

mem_Remarks

nvarchar(255)

YES

borings.remarks

dbl_DepthToWaterStatic

float

YES

mm

borings.ewt

dbl_MeasuringDepthWaterStatic

float

YES

mm

(empty)

dbl_DepthToWaterArtesian

float

YES

mm

(empty)

dbl_ArtesianMeasuringDepth

float

YES

mm

(empty)

txt_FreshOrSaltWater

nvarchar(25)

YES

(LDOEP only)

dbl_GroundElevation

float

YES

mm

dbl_Easting

float

YES

mm

dbl_Northing

float

YES

mm

dbl_Latitude

float

YES

deg

dbl_Longitude

float

YES

deg

dbl_Station

float

YES

mm

dbl_Offset

float

YES

mm

txt_USCSCodePredominant

nvarchar(255)

YES

borings.predom_soil

txt_ASTMCodePredominant

nvarchar(255)

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_ExplorationBoring

Description:

Soil or rock boring data by depth, e.g. blow counts, USCS designation, etc.

tbl_ExplorationBoring.png

Fig. 10 Appendix: DFLTD v.2 tbl_ExplorationBoring Table Relationships

Table 15 Appendix: FHWA DFLTD v.2 tbl_ExplorationBoring Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dbl_KeyDepth (PK)

float

NO

mm

txt_SamplerTypeCode

nvarchar(12)

YES

dbl_FieldBlowCount

float

YES

bl/ft

layers.nval (averaged)

dbl_BlowIncrement

float

YES

mm

dbl_BlowEquivalent

int

YES

n/a

dbl_RQD

float

YES

%

(mostly empty)

txt_USCSCodeLegacy

nvarchar(6)

YES

txt_ASTMCodeLegacy

nvarchar(20)

YES

txt_GeologicUnitCodeLegacy

nvarchar(20)

YES

(empty)

dbl_SptPhiLegacy

float

YES

deg

(mostly empty)

dbl_SptCohesLegacy

float

YES

Pa

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_ExplorationPressuremeter

Description:

Pressuremeter data by depth, measurements, and interpreted results.

tbl_ExplorationPressuremeter.png

Fig. 11 Appendix: DFLTD v.2 tbl_ExplorationPressuremeter Table Relationships

Table 16 Appendix: FHWA DFLTD v.2 tbl_ExplorationPressuremeter Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dbl_KeyDepth (PK)

float

NO

mm

dbl_PressureLimiting

float

YES

Pa

dbl_LateralStress

float

YES

Pa

dbl_K0

float

YES

n/a

dbl_InitialModulus

float

YES

Pa

dbl_ReloadModulus

float

YES

Pa

dbl_ShearModulus

float

YES

Pa

dbl_UndrainedShearStrength

float

YES

Pa

dbl_FrictionAngle

float

YES

deg

dbl_DilationAngle

float

YES

deg

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_ExplorationVaneField

Description:

Field vane shear test data by depth, measurements, and interpreted results.

tbl_ExplorationVaneField.png

Fig. 12 Appendix: DFLTD v.2 tbl_ExplorationVaneField Table Relationships

Table 17 Appendix: FHWA DFLTD v.2 tbl_ExplorationVaneField Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dbl_KeyDepth (PK)

float

NO

mm

dbl_PeakShearStrength

float

YES

Pa

dbl_ResidualShearStrength

float

YES

Pa

dbl_RemoldedShearStrength

float

YES

Pa

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_ExplorationVaneStepBlade

Description:

Step blade vane shear test data by depth, measurements, and interpreted results.

tbl_ExplorationVaneStepBlade.png

Fig. 13 Appendix: DFLTD v.2 tbl_ExplorationVaneStepBlade Table Relationships

Table 18 Appendix: FHWA DFLTD v.2 tbl_ExplorationVaneStepBlade Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dbl_KeyDepth (PK)

float

NO

mm

dbl_LateralPressure

float

YES

Pa

dbl_K0

float

YES

n/a

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES

Warning

Table tbl_ExplorationGroundwaterMonitoring is empty.

Name:

tbl_ExplorationGroundwaterMonitoring

Description:

Groundwater measurements from a monitoring well or VWP, including date-time, depth to water.

tbl_ExplorationGroundwaterMonitoring.png

Fig. 14 Appendix: DFLTD v.2 tbl_ExplorationGroundwaterMonitoring Table Relationships

Table 19 Appendix: FHWA DFLTD v.2 tbl_ExplorationGroundwaterMonitoring Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dte_KeyDateTime (PK)

datetime2

NO

dbl_DepthToWater

float

YES

mm

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES

Warning

Table tbl_ExplorationDynamicMeasurements is empty.

Name:

tbl_ExplorationDynamicMeasurements

Description:

Shear and compression wave velocity data by depth, measurements and interpreted results.

tbl_ExplorationDynamicMeasurements.png

Fig. 15 Appendix: DFLTD v.2 tbl_ExplorationDynamicMeasurements Table Relationships

Table 20 Appendix: FHWA DFLTD v.2 tbl_ExplorationDynamicMeasurements Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dbl_KeyDepth (PK)

float

NO

mm

dbl_ShearVelocity

float

YES

??

dbl_CompressionVelocity

float

YES

??

dbl_ShearModulus

float

YES

??

dbl_BulkModulus

float

YES

??

dbl_YoungsModulus

float

YES

??

dbl_PoissonsRatio

float

YES

??

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_ExplorationLabResults

Description:

Laboratory test results by depth.

tbl_ExplorationLabResults.png

Fig. 16 Appendix: DFLTD v.2 tbl_ExplorationLabResults Table Relationships

Table 21 Appendix: FHWA DFLTD v.2 tbl_ExplorationLabResults Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dbl_KeyDepth (PK)

float

NO

mm

txt_USCSCode

nvarchar(18)

YES

txt_ASTMCode

nvarchar(18)

YES

dbl_MoistureContent

float

YES

%

layers.water_content (averaged)

dbl_TotalUnitWeight

float

YES

kg/m3

layers.tuw (averaged)

dbl_DryDensity

float

YES

kg/m3

(mostly empty)

dbl_RelativeDensity

float

YES

%

(empty)

dbl_UnitWeightMax

float

YES

kg/m3

(mostly empty)

dbl_UnitWeightMin

float

YES

kg/m3

(mostly empty)

dbl_LiquidLimit

float

YES

%

layers.liquid_limit (averaged)

dbl_PlasticLimit

float

YES

%

dbl_PlasticityIndex

float

YES

%

layers.plasticity (averaged)

dbl_D10

float

YES

mm

(mostly empty)

dbl_D30

float

YES

mm

(mostly empty)

dbl_D60

float

YES

mm

(mostly empty)

dbl_PercentGravel

float

YES

%

(mostly empty)

dbl_PercentSand

float

YES

%

(mostly empty)

dbl_PercentFines

float

YES

%

dbl_percentClayFraction

float

YES

%

dbl_Permeability

float

YES

m/s

(empty)

dbl_Saturation

float

YES

%

(empty)

dbl_CompressionIndex

float

YES

n/a

(mostly empty)

dbl_ReCompressionIndex

float

YES

n/a

(mostly empty)

dbl_VoidRatio

float

YES

n/a

(empty)

dbl_CoefficientOfConsolidation

float

YES

??

(empty)

dbl_CoeffficientOfCompression

float

YES

??

(empty)

dbl_T90

float

YES

min

(empty)

dbl_PreconsolidationPressure

float

YES

Pa

(empty)

dbl_OCR

float

YES

n/a

txt_ShearTestCode

nvarchar(6)

YES

dbl_Cohesion

float

YES

Pa

layers.ssuu (averaged)

dbl_Phi

float

YES

deg

(mostly empty)

dbl_EffectCohesion

float

YES

Pa

(mostly empty)

dbl_EffectPhi

float

YES

deg

(mostly empty)

dbl_ShearStrLegacy

float

YES

Pa

dbl_ModulusLegacy

float

YES

Pa

txt_TypeModLegacy

nvarchar(20)

YES

(mostly empty)

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_ExplorationSoilLayerBoring

Description:

Interpreted soil layering at exploration location.

tbl_ExplorationSoilLayerBoring.png

Fig. 17 Appendix: DFLTD v.2 tbl_ExplorationSoilLayerBoring Table Relationships

Table 22 Appendix: FHWA DFLTD v.2 tbl_ExplorationSoilLayerBoring Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dbl_KeyDepthToBottom (PK)

float

NO

layers.height (converted from depth)

txt_USCSCode

nvarchar(20)

YES

layers.soil_type

txt_ASTMCode

nvarchar(20)

YES

txt_PrimarySoilDescriptionCode

nvarchar(5)

YES

layers.soil_type

txt_SecondarySoilDescriptionCode

nvarchar(5)

YES

txt_PlasticityDescriptionCode

nvarchar(5)

YES

(mostly empty)

txt_LayerDescription

nvarchar(255)

YES

layers.description

txt_GeologicUnit

nvarchar(255)

YES

(mostly empty)

dbl_BlowCountInterpreted

float

YES

layers.nval (LDOEP only)

dbl_BlowIncrement

float

YES

dbl_CohesionInterpreted

float

YES

Pa

layers.ssuu

dbl_FrictionAngleInterpreted

float

YES

deg

layers.friction_angle

dbl_CptqcInterpreted

float

YES

(empty)

dbl_CptfsInterpreted

float

YES

(empty)

dbl_UnitWeightInterpreted

float

YES

kg/m3

layers.tuw (LDOEP only)

dbl_ShearVelocityInterpreted

float

YES

(mostly empty)

dbl_YoungsModulusInterpreted

float

YES

(mostly empty)

dbl_ShearModulusInterpreted

float

YES

(empty)

dbl_KoInterpreted

float

YES

(empty)

dbl_OCRInterpreted

float

YES

(empty)

dbl_WaterContentInterpreted

float

YES

(mostly empty)

dbl_LLInterpreted

float

YES

(mostly empty)

dbl_PLInterpreted

float

YES

(mostly empty)

dbl_PIInterpreted

float

YES

(mostly empty)

dbl_RQDInterpreted

nvarchar(20)

YES

(mostly empty)

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES

Warning

Table tbl_ExplorationSoilLayerCPT is missing description and in MS Access.

Name:

tbl_ExplorationSoilLayerCPT

Description:

Interpreted soil layering at exploration location.

Table 23 Appendix: FHWA DFLTD v.2 tbl_ExplorationSoilLayerCPT Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dbl_KeyDepthToBottom (PK)

float

NO

txt_USCSCode

nvarchar(6)

YES

txt_ASTMCode

nvarchar(20)

YES

txt_PrimarySoilDescriptionCode

nvarchar(5)

YES

txt_SecondarySoilDescriptionCode

nvarchar(5)

YES

txt_PlasticityDescriptionCode

nvarchar(5)

YES

txt_LayerDescription

nvarchar(255)

YES

txt_GeologicUnit

nvarchar(255)

YES

dbl_BlowCountInterpreted

float

YES

dbl_BlowIncrement

float

YES

dbl_CohesionInterpreted

float

YES

dbl_FrictionAngleInterpreted

float

YES

dbl_CptqcInterpreted

float

YES

dbl_CptfsInterpreted

float

YES

dbl_UnitWeightInterpreted

float

YES

dbl_ShearVelocityInterpreted

float

YES

dbl_YoungsModulusInterpreted

float

YES

dbl_ShearModulusInterpreted

float

YES

dbl_KoInterpreted

float

YES

dbl_OCRInterpreted

float

YES

dbl_WaterContentInterpreted

float

YES

dbl_LLInterpreted

float

YES

dbl_PLInterpreted

float

YES

dbl_PIInterpreted

float

YES

dbl_RQDInterpreted

nvarchar(20)

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_ExplorationCPT

Description:

Cone penetrometer data by depth, e.g. measured tip resistance, interpreted soil behavior type, etc.

tbl_ExplorationCPT.png

Fig. 18 Appendix: DFLTD v.2 tbl_ExplorationCPT Table Relationships

Table 24 Appendix: FHWA DFLTD v.2 tbl_ExplorationCPT Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dbl_KeyDepth (PK)

float

NO

dbl_UncorrectedTipResistance

float

YES

dbl_SleeveFriction

float

YES

dbl_MeasuredPorePressure

float

YES

dbl_RFFrictionRatio

float

YES

dbl_qtCorrectedConeTipResistance

float

YES

dbl_uSteadyStatePorePressure

float

YES

dbl_QtNormalizedConeTipResistance

float

YES

dbl_FrNormalizedFrictionRatio

float

YES

dbl_BqPorePressureParameterRatio

float

YES

dbl_IcSoilBehaviorIndex

float

YES

dbl_SBTSoilBehaviorType

float

YES

dbl_OCR

float

YES

dbl_FrictionAngle

float

YES

dbl_UndrainedShearStrength

float

YES

lng_EquivalentSPTBlowCount

int

YES

txt_USCSCodeLegacy

nvarchar(6)

YES

txt_ASTMCodeLegacy

nvarchar(20)

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_ExplorationDilatometer

Description:

Dilatometer data by depth, measurements and interpreted results.

tbl_ExplorationDilatometer.png

Fig. 19 Appendix: DFLTD v.2 tbl_ExplorationDilatometer Table Relationships

Table 25 Appendix: FHWA DFLTD v.2 tbl_ExplorationDilatometer Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dbl_KeyDepth (PK)

float

NO

dbl_P0

float

YES

dbl_P1

float

YES

dbl_P2

float

YES

dbl_IdMaterialIndex

float

YES

dbl_KdHorizStressIndex

float

YES

dbl_EdDilatometerModulus

float

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES

Deep Foundation Tables

Name:

tbl_DeepFoundation

Description:

Deep foundation general descriptive data, e.g. type, length, location, etc.

tbl_DeepFoundation.png

Fig. 20 Appendix: DFLTD v.2 tbl_DeepFoundation Table Relationships

Table 26 Appendix: FHWA DFLTD v.2 tbl_DeepFoundation Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

txt_PileDesignation

nvarchar(255)

YES

piles.name

txt_PileType

nvarchar(255)

YES

piles.type & piles.shape

txt_ConstructionMethodCode

nvarchar(255)

YES

piles.vibro & piles.jetted

txt_StructureNumber

nvarchar(255)

YES

piles.remarks

txt_PierGroupNumber

nvarchar(255)

YES

piles.remarks

txt_SacrificialOrProductionPile

nvarchar(255)

YES

(LDOEP only)

lng_NumberOfSections

int

YES

(all values = 1; a few = 2)

txt_GeometryCode

nvarchar(255)

YES

piles.tapered

txt_TipTreatmentCode

nvarchar(255)

YES

dbl_GroundElevation

float

YES

dbl_DepthToWater

float

YES

(LDOEP only)

txt_SoilTypeGen

nvarchar(50)

YES

(LDOEP only)

txt_SoilTypeSide

nvarchar(50)

YES

(LDOEP only)

txt_SoilTypeTip

nvarchar(50)

YES

(LDOEP only)

dbl_TopElevation

float

YES

mm

piles.head_elevation

dbl_TipElevation

float

YES

mm

piles.toe_elevation

dbl_TotalLength

float

YES

mm

piles.length

dbl_EmbeddedLength

float

YES

mm

piles.emb_length

dbl_PermanentCasedLength

float

YES

(empty)

dbl_PermanentCasingBottomElevation

float

YES

(empty)

dbl_DistanceToReactionPile1

float

YES

(mostly empty)

dbl_DistanceToReactionPile2

float

YES

(mostly empty)

dbl_DistanceToReactionPile3

float

YES

(mostly empty)

dbl_DistanceToReactionPile4

float

YES

(mostly empty)

dbl_BatterAngle

float

YES

(mostly empty; all other values zero)

dte_InstallStartDate

datetime2

YES

(empty)

dte_InstallEndDate

datetime2

YES

(empty)

txt_InstallationSubcontractor

nvarchar(255)

YES

(empty)

dbl_Easting

float

YES

(mostly empty)

dbl_Northing

float

YES

(mostly empty)

dbl_Station

float

YES

(empty)

dbl_Offset

float

YES

(mostly empty)

dbl_Latitude

float

YES

(mostly empty)

dbl_Longitude

float

YES

(mostly empty)

txt_Remarks

nvarchar(-1)

YES

(mostly empty)

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_DeepFoundationDistToExploration

Description:

Distance from deep foundation element to each site exploration.

tbl_DeepFoundationDistToExploration.png

Fig. 21 Appendix: DFLTD v.2 tbl_DeepFoundationDistToExploration Table Relationships

Table 27 Appendix: FHWA DFLTD v.2 tbl_DeepFoundationDistToExploration Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

txt_KeyExplorationName (PK)

nvarchar(25)

NO

dbl_DistanceToExploration

float

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_DeepFoundationSoilLayer

Description:

Interpreted soil layering at deep foundation location.

tbl_DeepFoundationSoilLayer.png

Fig. 22 Appendix: DFLTD v.2 tbl_DeepFoundationSoilLayer Table Relationships

Table 28 Appendix: FHWA DFLTD v.2 tbl_DeepFoundationSoilLayer Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_KeyDepthToBottom (PK)

float

NO

dbl_DepthToWater

float

YES

txt_USCSCodeInterpreted

nvarchar(6)

YES

txt_ASTMCodeInterpreted

nvarchar(20)

YES

txt_PrimarySoilDescriptionCode

nvarchar(5)

YES

txt_SecondarySoilDescriptionCode

nvarchar(5)

YES

txt_PlasticityDescriptionCode

nvarchar(5)

YES

mem_LayerDescription

nvarchar(255)

YES

txt_GeologicUnit

nvarchar(255)

YES

dbl_BlowCountInterpreted

float

YES

dbl_BlowIncrement

float

YES

dbl_CohesionInterpreted

float

YES

dbl_FrictionAngleInterpreted

float

YES

dbl_CptqcInterpreted

float

YES

dbl_CptfsInterpreted

float

YES

dbl_UnitWeightInterpreted

float

YES

dbl_ShearVelocityInterpreted

float

YES

dbl_YoungsModulusInterpreted

float

YES

dbl_ShearModulusInterpreted

float

YES

dbl_KoInterpreted

float

YES

dbl_OCRInterpreted

float

YES

dbl_WaterContentInterpreted

float

YES

dbl_LLInterpreted

float

YES

dbl_PLInterpreted

float

YES

dbl_PIInterpreted

float

YES

dbl_RQDInterpreted

float

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_DescriptionAugerCast

Description:

Auger cast pile descriptive data, e.g. diameter, reinforcement, etc.

tbl_DescriptionAugerCast.png

Fig. 23 Appendix: DFLTD v.2 tbl_DescriptionAugerCast Table Relationships

Table 29 Appendix: FHWA DFLTD v.2 tbl_DescriptionAugerCast Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_Diameter

float

YES

mm

piles.diameter

dbl_CrossSectionArea

float

YES

(empty)

dbl_MomentInertia

float

YES

(empty)

dbl_ConcreteStrength

float

YES

(empty)

dbl_ConcreteModulus

float

YES

(empty)

dbl_WeightPerUnitLength

float

YES

(empty)

txt_ReinforcementCode

nvarchar(25)

YES

(empty)

dbl_ReinforcementTotalXArea

float

YES

(empty)

dbl_ReinforcementYieldStrength

float

YES

(empty)

dbl_ReinforcementModulus

float

YES

(empty)

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_DescriptionCylinderConcrete

Description:

Concrete cylinder pile descriptive data, e.g. diameter, prestress pressure, etc.

tbl_DescriptionCylinderConcrete.png

Fig. 24 Appendix: DFLTD v.2 tbl_DescriptionCylinderConcrete Table Relationships

Note

Properties for pile types “CC”, “RC”, “SC”

Table 30 Appendix: FHWA DFLTD v.2 tbl_DescriptionCylinderConcrete Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_OuterDiameter

float

YES

mm

piles.diameter

dbl_InnerDiameter

float

YES

mm

(skipped; rely on thickness)

dbl_WallThickness

float

YES

mm

piles.wall_thickness

dbl_CrossSectionArea

float

YES

??

(skipped; erroneous data)

dbl_MomentInertia

float

YES

(empty or erroneous)

dbl_WeightPerUnitLength

float

YES

kg/m

piles.weight (multiply by length)

dbl_CompositeModulus

float

YES

Pa

piles.modulus

dbl_ConcreteStrength

float

YES

Pa

dbl_PrestressPressure

float

YES

dbl_PostTensionStress

float

YES

txt_PrestressYN

nvarchar(1)

YES

txt_PostTensionYN

nvarchar(1)

YES

txt_ReinforcementYN

nvarchar(1)

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_DescriptionDrilledShaft

Description:

Drilled shaft descriptive data, e.g. diameter, casing length, etc.

tbl_DescriptionDrilledShaft.png

Fig. 25 Appendix: DFLTD v.2 tbl_DescriptionDrilledShaft Table Relationships

Note

Properties for pile types “MI”, “BC”, “AC”, “FC”, “SP”

Table 31 Appendix: FHWA DFLTD v.2 tbl_DescriptionDrilledShaft Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_DiameterMain

float

YES

mm

piles.diameter

dbl_DiameterSocket

float

YES

mm

(mostly empty)

dbl_PermanentCasingInnerDiameter

float

YES

mm

(empty)

dbl_PermanentCasingThickness

float

YES

mm

(empty)

dbl_PermanentCasingOuterDiameter

float

YES

mm

(empty)

dbl_CrossSectionArea

float

YES

mm2

piles.cross_area

dbl_MomentInertia

float

YES

dbl_ConcreteStrength

float

YES

Pa

(empty)

dbl_ConcreteModulus

float

YES

Pa

piles.modulus

dbl_WeightPerUnitLength

float

YES

(empty)

txt_ReinforcementCode

nvarchar(25)

YES

(empty)

dbl_ReinforcementTotalXArea

float

YES

(empty)

dbl_ReinforcementPctXArea

float

YES

(empty)

dbl_ReinforcementYieldStrength

float

YES

(empty)

dbl_ReinforcementModulus

float

YES

(empty)

txt_ModifiedBy

nvarchar(18)

YES

dte_AddDate

datetime2

YES

dte_ModifiedDate

datetime2

YES

txt_CreatedBy

nvarchar(16)

YES
Name:

tbl_DescriptionHPile

Description:

H pile descriptive data, e.g. area, flange width, etc.

tbl_DescriptionHPile.png

Fig. 26 Appendix: DFLTD v.2 tbl_DescriptionHPile Table Relationships

Table 32 Appendix: FHWA DFLTD v.2 tbl_DescriptionHPile Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

txt_HpileCode

nvarchar(10)

YES

piles.shape

txt_HpileCodeOld

nvarchar(10)

YES

dbl_WeightPerUnitLength

float

YES

kg/m

piles.weight (multiply by length)

dbl_CrossSectionArea

float

YES

mm2

piles.cross_area

dbl_DepthSection

float

YES

mm

used for piles.square_circ

dbl_FlangeWidth

float

YES

mm

piles.diameter

dbl_FlangeDepth

float

YES

mm

dbl_WebThickness

float

YES

mm

piles.wall_thickness

dbl_CoatingArea

float

YES

mm2/mm

piles.circumference

dbl_MomentInertiaXX

float

YES

dbl_MomentInertiaYY

float

YES

dbl_SteelModulus

float

YES

Pa

piles.modulus

dbl_SteelYieldStrength

float

YES

(empty)

txt_ModifiedBy

nvarchar(18)

YES

dte_AddDate

datetime2

YES

dte_ModifiedDate

datetime2

YES

txt_CreatedBy

nvarchar(16)

YES
Name:

tbl_DescriptionMonotube

Description:

Monotube pile descriptive data, e.g. diameter (butt and tip), gauge, etc.

tbl_DescriptionMonotube.png

Fig. 27 Appendix: DFLTD v.2 tbl_DescriptionMonotube Table Relationships

Table 33 Appendix: FHWA DFLTD v.2 tbl_DescriptionMonotube Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_TopDiameter

float

YES

mm

piles.diameter

dbl_TipDiameter

float

YES

mm

(inconsistent; toe > head)

dbl_Gauge

float

YES

mm

piles.wall_thickness

dbl_TaperAngle

float

YES

(empty)

dbl_Modulus

float

YES

(empty)

txt_ModifiedBy

nvarchar(18)

YES

dte_AddDate

datetime2

YES

dte_ModifiedDate

datetime2

YES

txt_CreatedBy

nvarchar(16)

YES
Name:

tbl_DescriptionPolyconcrete

Description:

Concrete pile (square, octagonal) descriptive data, e.g. number of sides, side length, etc.

tbl_DescriptionPolyconcrete.png

Fig. 28 Appendix: DFLTD v.2 tbl_DescriptionPolyconcrete Table Relationships

Note

Properties for pile types “OC”, “SC”

Table 34 Appendix: FHWA DFLTD v.2 tbl_DescriptionPolyconcrete Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_CoreDiameter

float

YES

lng_NumberOfSides

int

YES

dbl_SideLength

float

YES

mm

piles.diameter for ‘SC’

dbl_EquivalentDiameter

float

YES

mm

piles.diameter for ‘OC’

dbl_Perimeter

float

YES

mm

piles.circumference

dbl_CrossSectionArea

float

YES

mm2

piles.cross_area

dbl_MomentInertia

float

YES

dbl_WeightPerUnitLength

float

YES

kg/m

piles.weight

dbl_ConcreteModulus

float

YES

Pa

piles.modulus

dbl_ConcreteStrength

float

YES

(empty)

dbl_PrestressPressure

float

YES

(empty)

txt_PrestressLegacy

nvarchar(1)

YES

txt_ReinforceLegacy

nvarchar(18)

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_DescriptionSteelPipe

Description:

Steel pipe pile descriptive data, e.g. wall thickness, concrete filled (Y/N), etc.

tbl_DescriptionSteelPipe.png

Fig. 29 Appendix: DFLTD v.2 tbl_DescriptionSteelPipe Table Relationships

Table 35 Appendix: FHWA DFLTD v.2 tbl_DescriptionSteelPipe Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_WallThickness

float

YES

mm

piles.wall_thickness

dbl_OuterDiameter

float

YES

mm

piles.diameter

dbl_InnerDiameter

float

YES

dbl_CrossSectionArea

float

YES

mm2

piles.cross_area

dbl_EndArea

float

YES

(empty)

dbl_MomentInertia

float

YES

dbl_WeightPerUnitLength

float

YES

kg/m

piles.weight

dbl_SteelModulus

float

YES

Pa

piles.modulus

dbl_SteelYieldStrength

float

YES

txt_ConcreteFilledYN

nvarchar(8)

YES

piles.remarks

dbl_ConcreteDepth

float

YES

(mostly empty)

dbl_ConcreteStrength

float

YES

(mostly empty)

dbl_ConcreteModulus

float

YES

(mostly empty)

dbl_ReinforcementTotalXArea

float

YES

(mostly empty)

dbl_ReinforcementPctXArea

float

YES

(empty)

dbl_ReinforcementYieldStrength

float

YES

(empty)

dbl_ReinforcementModulus

float

YES

dbl_CompositeModulus

float

YES

Pa

piles.modulus

txt_ArtificialPlugYN

nvarchar(8)

YES

txt_ArtificialPlugNote

nvarchar(255)

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_DescriptionStepTaper

Description:

Step taper pile descriptive data, e.g. diameter, concrete filled (Y/N), etc.

tbl_DescriptionStepTaper.png

Fig. 30 Appendix: DFLTD v.2 tbl_DescriptionStepTaper Table Relationships

Table 36 Appendix: FHWA DFLTD v.2 tbl_DescriptionStepTaper Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_Diameter

float

YES

mm

piles.diameter

dbl_Gauge

float

YES

(empty)

txt_ConcreteFilledYN

nvarchar(1)

YES

piles.remarks

dbl_SurfaceArea

float

YES

dbl_CrossSectionArea

float

YES

mm2

piles.cross_area

dbl_MomentInertia

float

YES

dbl_Modulus

float

YES

Pa

piles.modulus

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_DescriptionTimber

Description:

Timber pile descriptive data, e.g. diameter (butt and tip), wood type, etc.

tbl_DescriptionTimber.png

Fig. 31 Appendix: DFLTD v.2 tbl_DescriptionTimber Table Relationships

Table 37 Appendix: FHWA DFLTD v.2 tbl_DescriptionTimber Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_TopDiameter

float

YES

mm

piles.diameter

dbl_TipDiameter

float

YES

mm

dbl_MomentInertia

float

YES

(empty)

dbl_Modulus

float

YES

Pa

piles.modulus

dbl_TaperAngle

float

YES

(empty)

txt_WoodTypeCode

nvarchar(5)

YES

dbl_Strength

float

YES

(empty)

dbl_UnitWeight

float

YES

(empty)

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES

Deep Foundation Installation Tables

Name:

tbl_InstallAugerCast

Description:

Auger cast pile installation summary data, e.g. total concrete volume, time, etc.

tbl_InstallAugerCast.png

Fig. 32 Appendix: DFLTD v.2 tbl_InstallAugerCast Table Relationships

Table 38 Appendix: FHWA DFLTD v.2 tbl_InstallAugerCast Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_AugerDiameter

float

YES

dbl_AugerPitch

float

YES

dbl_TotalTheoreticalVolume

float

YES

dbl_TotalGroutVolume

float

YES

dbl_TimeDrilling

float

YES

dbl_TimeGrouting

float

YES

txt_InstallationRemarks

nvarchar(255)

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES

Warning

Table tbl_InstallAugerCastConcreteVolume is empty.

Name:

tbl_InstallAugerCastConcreteVolume

Description:

Auger cast pile installation detail, concrete volume by depth.

tbl_InstallAugerCastConcreteVolume.png

Fig. 33 Appendix: DFLTD v.2 tbl_InstallAugerCastConcreteVolume Table Relationships

Table 39 Appendix: FHWA DFLTD v.2 tbl_InstallAugerCastConcreteVolume Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_KeyDeepFoundationDepth (PK)

float

NO

dbl_TheoreticalVolume

float

YES

dbl_MeasuredVolume

float

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_InstallDrilledShaft

Description:

Drilled shaft installation summary data, e.g. concrete placement method, concrete volume, etc.

tbl_InstallDrilledShaft.png

Fig. 34 Appendix: DFLTD v.2 tbl_InstallDrilledShaft Table Relationships

Table 40 Appendix: FHWA DFLTD v.2 tbl_InstallDrilledShaft Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

txt_ConcretePlacementCode

nvarchar(10)

YES

txt_BottomCleanOutCode

nvarchar(6)

YES

txt_ShaftCaliperYN

nvarchar(1)

YES

txt_ConcreteVolumeYN

nvarchar(1)

YES

txt_InstallationRemarks

nvarchar(255)

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_InstallDrilledShaftCaliper

Description:

Osterberg load test caliper measurements by depth.

tbl_InstallDrilledShaftCaliper.png

Fig. 35 Appendix: DFLTD v.2 tbl_InstallDrilledShaftCaliper Table Relationships

Table 41 Appendix: FHWA DFLTD v.2 tbl_InstallDrilledShaftCaliper Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_KeyDeepFoundationDepth (PK)

float

NO

dbl_Diameter

float

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_InstallDrilledShaftConcreteVolume

Description:

Drilled shaft installation detail, concrete volume by depth.

tbl_InstallDrilledShaftConcreteVolume.png

Fig. 36 Appendix: DFLTD v.2 tbl_InstallDrilledShaftConcreteVolume Table Relationships

Table 42 Appendix: FHWA DFLTD v.2 tbl_InstallDrilledShaftConcreteVolume Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_KeyDeepFoundationDepth (PK)

float

NO

dbl_TheoreticalVolume

float

YES

dbl_MeasuredVolume

float

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_InstallDrivenPile

Description:

Driven pile installation summary data, e.g. hammer type(s), final blows and set, etc.

tbl_InstallDrivenPile.png

Fig. 37 Appendix: DFLTD v.2 tbl_InstallDrivenPile Table Relationships

Table 43 Appendix: FHWA DFLTD v.2 tbl_InstallDrivenPile Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

txt_InstallationRemark

nvarchar(255)

YES

txt_VibratoryHammerCode

nvarchar(255)

YES

dbl_VibratoryStartDepth

float

YES

dbl_VibratoryEndDepth

float

YES

dte_VibratoryStartDate

datetime2

YES

dte_VibratoryEndDate

datetime2

YES

dbl_VibratoryTotalTime

float

YES

dbl_VibratoryPenetrationRatePer305mm

float

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_InstallDrivenPileHeader

Description:

N/A

tbl_InstallDrivenPileHeader.png

Fig. 38 Appendix: DFLTD v.2 tbl_InstallDrivenPileHeader Table Relationships

Table 44 Appendix: FHWA DFLTD v.2 tbl_InstallDrivenPileHeader Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

txt_KeyDriveSequenceCode (PK)

nvarchar(5)

NO

txt_ImpactHammerCode

nvarchar(255)

YES

txt_ImpactHammerName

nvarchar(255)

YES

dbl_RatedEnergyEng

float

YES

dbl_RatedEnergyMet

float

YES

txt_PDAYN

nvarchar(8)

YES

txt_PDASubcontractor

nvarchar(255)

YES

dte_DateDriveStart

datetime2

YES

dte_DateDriveEnd

datetime2

YES

dbl_DriveNumberOfDays

int

YES

dbl_DepthDriveStart

float

YES

dbl_DepthDriveEnd

float

YES

lng_NumberBlowsBOD

int

YES

dbl_SetBOD

float

YES

lng_NumberBlowsEOD

int

YES

dbl_SetEOD

float

YES

dbl_HelmetWeight

float

YES

txt_PileCushionMaterial

nvarchar(18)

YES

dbl_PileCushionArea

float

YES

dbl_PileCushionThickness

float

YES

dbl_PileCushionModulus

float

YES

txt_InstallationRemark

nvarchar(255)

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_InstallDrivenPileDriveRecord

Description:

Driven pile installation detail, e.g. driving resistance hammer blows and set, PDA data, etc.

tbl_InstallDrivenPileDriveRecord.png

Fig. 39 Appendix: DFLTD v.2 tbl_InstallDrivenPileDriveRecord Table Relationships

Table 45 Appendix: FHWA DFLTD v.2 tbl_InstallDrivenPileDriveRecord Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

txt_KeyDriveSequenceCode (PK)

nvarchar(5)

NO

dbl_KeyDeepFoundationDepth (PK)

float

NO

dbl_TimeMeasured

float

YES

dbl_BlowsPerIncrement

float

YES

dbl_BlowIncrement

float

YES

dbl_Stroke

float

YES

dbl_PDABlowDepth

float

YES

dbl_PDABlowNumber

float

YES

dbl_PDABlows

float

YES

dbl_PDACSXStress

float

YES

dbl_PDACSIStress

float

YES

dbl_PDAFMXForce

float

YES

dbl_PDAMaxTransferedEnergy

float

YES

dbl_PDAETREnergyTransferRatio

float

YES

dbl_PDAETHPotentialEnergyTransferRatio

float

YES

dbl_PDACaseCapacityJc0

float

YES

dbl_PDACaseCapacityJc1

float

YES

dbl_PDACaseCapacityJc2

float

YES

dbl_PDACaseCapacityJc3

float

YES

dbl_PDACaseCapacityJc4

float

YES

dbl_PDACaseCapacityJc5

float

YES

dbl_PDACaseCapacityJc6

float

YES

dbl_PDACaseCapacityJc7

float

YES

dbl_PDACaseCapacityJc8

float

YES

dbl_PDACaseCapacityJc9

float

YES

txt_Remarks

nvarchar(255)

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_AddDate

datetime2

YES

dte_ModifiedDate

datetime2

YES

txt_CreatedBy

nvarchar(16)

YES
Name:

tbl_InstallDrivenPilePlug

Description:

N/A

Table 46 Appendix: FHWA DFLTD v.2 tbl_InstallDrivenPilePlug Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

dbl_DrivingShoeInnerDiameter

float

YES

dbl_DrivingShoeOuterDiameter

float

YES

txt_PlugLengthRatioYN

nvarchar(5)

YES

txt_IncrementalFillingRatioYN

nvarchar(5)

YES

txt_FinalFillingRatioYN

nvarchar(5)

YES

txt_PlugRemarks

nvarchar(255)

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_DeepFoundationDynamicTest

Description:

N/A

tbl_DeepFoundationDynamicTest.png

Fig. 40 Appendix: DFLTD v.2 tbl_DeepFoundationDynamicTest Table Relationships

Table 47 Appendix: FHWA DFLTD v.2 tbl_DeepFoundationDynamicTest Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_Capwap

Description:

CAPWAP analysis summary data per blow number.

tbl_Capwap.png

Fig. 41 Appendix: DFLTD v.2 tbl_Capwap Table Relationships

Table 48 Appendix: FHWA DFLTD v.2 tbl_Capwap Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

txt_KeyBODEODCode (PK)

nvarchar(6)

NO

lng_KeyBlowNumber (PK)

int

NO

txt_Remarks

nvarchar(255)

YES

dbl_SetupDays

float

YES

dbl_CapacityTotal

float

YES

dbl_CapacityShaft

float

YES

dbl_CapacityToe

float

YES

dbl_UnitResistanceToe

float

YES

dbl_CaseDampingShaft

float

YES

dbl_CaseDampingToe

float

YES

dbl_SmithDampingShaft

float

YES

dbl_SmithDampingToe

float

YES

dbl_QuakeShaft

float

YES

dbl_QuakeToe

float

YES

dbl_UnldLegacy

float

YES

dbl_CsknLegacy

float

YES

dbl_CtoeLegacy

float

YES

dbl_LsknLegacy

float

YES

dbl_LtoeLegacy

float

YES

dbl_SkdpLegacy

float

YES

dbl_BtdpLegacy

float

YES

dbl_MsknLegacy

float

YES

dbl_MtoeLegacy

float

YES

dbl_TgapLegacy

float

YES

dbl_PlugLegacy

float

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_CapwapDetail

Description:

CAPWAP analysis details at each analysis depth.

tbl_CapwapDetail.png

Fig. 42 Appendix: DFLTD v.2 tbl_CapwapDetail Table Relationships

Table 49 Appendix: FHWA DFLTD v.2 tbl_CapwapDetail Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

txt_KeyBODEODCode (PK)

nvarchar(6)

NO

lng_KeyBlowNumber (PK)

int

NO

int_KeySegment (PK)

int

NO

dbl_DistanceBelowGages

float

YES

dbl_DepthBelowGrade

float

YES

dbl_RuForceInSegment

float

YES

dbl_ForceInPile

float

YES

dbl_SumRuSumSegmentForcesSide

float

YES

dbl_SegmentUnitResistance

float

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES

Load Test Tables

Name:

tbl_LoadTest

Description:

Load test general descriptive data, e.g. test type, date, etc.

tbl_LoadTest.png

Fig. 43 Appendix: DFLTD v.2 tbl_LoadTest Table Relationships

Table 50 Appendix: FHWA DFLTD v.2 tbl_LoadTest Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

lng_KeyLoadTest (PK)

int

NO

dte_TestDate

datetime2

YES

date

load_tests.date_tested

dbl_SetupDays

float

YES

days

load_tests.setup_time

txt_LoadTestSubcontractor

nvarchar(255)

YES

load_tests.tested_by

txt_LoadTestCode

nvarchar(255)

YES

load_tests.direction

txt_LoadTypeCode

nvarchar(255)

YES

load_tests.direction

txt_LoadDirectionCode

nvarchar(225)

YES

(empty)

txt_ASTMProcedureCode

nvarchar(255)

YES

load_tests.static_type

txt_MaxLoadCriteriaCode

nvarchar(255)

YES

(LDOEP only)

txt_FailCriteriaYN

nvarchar(255)

YES

txt_CyclicTestYN

nvarchar(255)

YES

txt_LoadXferDataYN

nvarchar(255)

YES

txt_MeasuredSideYN

nvarchar(255)

YES

txt_MeasuredTipYN

nvarchar(255)

YES

dbl_PileTopElevAtTest

float

YES

dbl_GroundElevAtTest

float

YES

dbl_WaterTableAtTest

float

YES

dbl_StaticTotalLoadApplied

float

YES

dbl_StaticTotalDisplacement

float

YES

dbl_StaticSideForce

float

YES

dbl_StaticBaseForce

float

YES

dbl_StaticSideForceWithResidual

float

YES

(empty)

dbl_StaticBaseForceWithResidual

float

YES

(empty)

dbl_StaticBaseDisplacement

float

YES

(empty)

txt_StatnamicTestIDLegacy

nvarchar(255)

YES

(empty)

dbl_StatnamicDevice

float

YES

txt_StatnamicCatchSystem

nvarchar(5)

YES

dbl_StatnamicTotTime

float

YES

(empty)

dbl_StatnamicPreLoad

float

YES

(empty)

dbl_StatnamicPreDisplacement

float

YES

(empty)

dbl_StatnamicMaxLoad

float

YES

dbl_StatnamicMaxDisplacement

float

YES

dbl_StatnamicMaxLoadMiddendorp

float

YES

dbl_StatnamicMaxDisplacementMiddendorp

float

YES

dbl_StatnamicMaxLoadSUP

float

YES

dbl_StatnamicMaxDisplacementSUP

float

YES

dbl_StatnamicMaxLoadMUP

float

YES

dbl_StatnamicMaxDisplacementMUP

float

YES

dbl_MaxUnitBaseResistance

float

YES

(empty)

dbl_OCell1RatedCapacity

float

YES

(empty)

dbl_OCell1Depth

float

YES

(empty)

dbl_OCell1MaxUniDirectionalForce

float

YES

(empty)

dbl_OCell1MaxUpDisplacement

float

YES

(empty)

dbl_OCell1MaxDownDisplacement

float

YES

(empty)

txt_OCell1Remarks

nvarchar(255)

YES

(empty)

dbl_OCell2RatedCapacity

float

YES

(empty)

dbl_OCell2Depth

float

YES

(empty)

dbl_OCell2MaxUniDirectionalForce

float

YES

(empty)

dbl_OCell2MaxUpDisplacement

float

YES

(empty)

dbl_OCell2MaxDownDisplacement

float

YES

(empty)

txt_OCell2Remarks

nvarchar(255)

YES

(empty)

dbl_OCell3RatedCapacity

float

YES

(empty)

dbl_OCell3Depth

float

YES

(empty)

dbl_OCell3MaxUniDirectionalForce

float

YES

(empty)

dbl_OCell3MaxUpDisplacement

float

YES

(empty)

dbl_OCell3MaxDownDisplacement

float

YES

(empty)

txt_OCell3Remarks

nvarchar(255)

YES

(empty)

dbl_OCellMaxTopLoad

float

YES

(almost empty)

dbl_OCellMaxTopDisplacement

float

YES

(almost empty)

dbl_OCellMaxTipLoad

float

YES

(almost empty)

dbl_OCellMaxTipDisplacement

float

YES

(almost empty)

txt_StaticLegacy

nvarchar(1)

YES

(empty)

txt_LoadTestRemarks

nvarchar(255)

YES

(empty)

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_LoadTestStatic

Description:

Static load test force displacement data by load number and time.

tbl_LoadTestStatic.png

Fig. 44 Appendix: DFLTD v.2 tbl_LoadTestStatic Table Relationships

Table 51 Appendix: FHWA DFLTD v.2 tbl_LoadTestStatic Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

lng_KeyLoadTest (PK)

int

NO

lng_KeyLoadStep (PK)

int

NO

dte_ReadTime

datetime2

YES

(empty)

dbl_ElapsedTime

float

YES

(empty)

dbl_TotalAppliedLoadGeneric

float

YES

N

static_tests.load and static_tests.load_type

dbl_TotalAppliedLoadCell

float

YES

N

static_tests.load and static_tests.load_type

dbl_TotalAppliedLoadJack

float

YES

N

static_tests.load and static_tests.load_type

dbl_TotalAppliedLoadStrainGage

float

YES

N

static_tests.load and static_tests.load_type

dbl_DisplGeneric

float

YES

mm

static_tests.displacement and static_tests.displ_type

dbl_DisplPileHeadSurvey

float

YES

mm

static_tests.displacement and static_tests.displ_type

dbl_DisplDialGage

float

YES

mm

static_tests.displacement and static_tests.displ_type

dbl_DisplWireLine

float

YES

(empty)

dbl_DisplLiquidLevelGage

float

YES

mm

static_tests.displacement and static_tests.displ_type

txt_CreatedBy

nvarchar(20)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(20)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_LoadTestStaticInclinometer

Description:

Static load test inclinometer measurements, depth and inclination.

tbl_LoadTestStaticInclinometer.png

Fig. 45 Appendix: DFLTD v.2 tbl_LoadTestStaticInclinometer Table Relationships

Table 52 Appendix: FHWA DFLTD v.2 tbl_LoadTestStaticInclinometer Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

lng_KeyLoadTest (PK)

int

NO

lng_KeyLoadStep (PK)

int

NO

dbl_KeyProbeDepth (PK)

float

NO

dbl_Displacement

float

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_AddDate

datetime2

YES

dte_ModifiedDate

datetime2

YES

txt_CreatedBy

nvarchar(16)

YES
Name:

tbl_LoadTestStatnamic

Description:

Statnamic load test force displacement and force distribution data by load number and time, including derived results from Middendorp and SUP methods.

tbl_LoadTestStatnamic.png

Fig. 46 Appendix: DFLTD v.2 tbl_LoadTestStatnamic Table Relationships

Table 53 Appendix: FHWA DFLTD v.2 tbl_LoadTestStatnamic Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

lng_KeyLoadTest (PK)

int

NO

lng_KeyLoadStep (PK)

int

NO

dte_ReadTime

float

YES

dbl_ElapsedTIme

float

YES

dbl_StatnamicForce

float

YES

dbl_StatnamicDisplacement

float

YES

dbl_StatnamicForceMiddendorp

float

YES

dbl_StatnamicDisplacementMiddendorp

float

YES

dbl_StatnamicForceSUP

float

YES

dbl_StatnamicDisplacementSUP

float

YES

dbl_StatnamicForceMUP

float

YES

dbl_StatnamicDisplacementMUP

float

YES

dbl_StatnamicForceBase

float

YES

dbl_StatnamicDisplacementBase

float

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_AddDate

datetime2

YES

dte_ModifiedDate

datetime2

YES

txt_CreatedBy

nvarchar(16)

YES
Name:

tbl_LoadTestOsterberg

Description:

Osterberg load test force displacement data by load number and time.

tbl_LoadTestOsterberg.png

Fig. 47 Appendix: DFLTD v.2 tbl_LoadTestOsterberg Table Relationships

Table 54 Appendix: FHWA DFLTD v.2 tbl_LoadTestOsterberg Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

lng_KeyLoadTest (PK)

int

NO

lng_KeyLoadStep (PK)

int

NO

dte_ReadTime

datetime2

YES

dbl_ElapsedTime

float

YES

dbl_TopLoad

float

YES

dbl_TopDisplacement

float

YES

dbl_TipLoad

float

YES

dbl_TipDisplacement

float

YES

dbl_OCell1Load

float

YES

dbl_OCell1NetLoad

float

YES

dbl_OCell1Expansion

float

YES

dbl_OCell1UpDisplacement

float

YES

dbl_OCell1DownDisplacement

float

YES

dbl_OCell2Load

float

YES

dbl_OCell2NetLoad

float

YES

dbl_OCell2Expansion

float

YES

dbl_OCell2UpDisplacement

float

YES

dbl_OCell2DownDisplacement

float

YES

dbl_OCell3Load

float

YES

dbl_OCell3NetLoad

float

YES

dbl_OCell3Expansion

float

YES

dbl_OCell3UpDisplacement

float

YES

dbl_OCell3DownDisplacement

float

YES

dbl_EquivalentMaxTopLoad

float

YES

dbl_EquivalentMaxTopDisplacement

float

YES

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_LoadTestSegmentBase

Description:

Segment base resistance results.

tbl_LoadTestSegmentBase.png

Fig. 48 Appendix: DFLTD v.2 tbl_LoadTestSegmentBase Table Relationships

Table 55 Appendix: FHWA DFLTD v.2 tbl_LoadTestSegmentBase Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

lng_KeyLoadTest (PK)

int

NO

lng_KeySequence (PK)

int

NO

dbl_BaseForce

float

YES

dbl_BaseForceWithResidual

float

YES

dbl_UnitBaseResistance

float

YES

dbl_BaseDisplacement

float

YES

txt_CreatedBy

nvarchar(15)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(15)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_LoadTestSegment

Description:

Segment definition for load transfer data (side and base resistance) from all test types.

tbl_LoadTestSegment.png

Fig. 49 Appendix: DFLTD v.2 tbl_LoadTestSegment Table Relationships

Table 56 Appendix: FHWA DFLTD v.2 tbl_LoadTestSegment Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

lng_KeyLoadTest (PK)

int

NO

lng_KeyLevel (PK)

int

NO

dbl_TopElevation

float

YES

dbl_BottomElevation

float

YES

dbl_MaxUnitSideResistance

float

YES

dbl_DisplAtMaxSideResistance

float

YES

txt_DisplLocationCode

nvarchar(5)

YES

txt_CreatedBy

nvarchar(15)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(15)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_LoadTestSegmentSide

Description:

Segment side resistance results.

tbl_LoadTestSegmentSide.png

Fig. 50 Appendix: DFLTD v.2 tbl_LoadTestSegmentSide Table Relationships

Table 57 Appendix: FHWA DFLTD v.2 tbl_LoadTestSegmentSide Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

lng_KeyLoadTest (PK)

int

NO

lng_KeyLevel (PK)

int

NO

lng_KeySequence (PK)

int

NO

dbl_UnitSideResistance

float

YES

dbl_SegmentDisplacement

float

YES

txt_CreatedBy

nvarchar(15)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(15)

YES

dte_ModifiedDate

datetime2

YES
Name:

tbl_LoadTestForceDistributionGage

Description:

N/A

tbl_LoadTestForceDistributionGage.png

Fig. 51 Appendix: DFLTD v.2 tbl_LoadTestForceDistributionGage Table Relationships

Table 58 Appendix: FHWA DFLTD v.2 tbl_LoadTestForceDistributionGage Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

lng_KeyLoadTest (PK)

int

NO

lng_KeyLevel (PK)

int

NO

str_KeyStrainGageName

nvarchar(255)

NO

dbl_StrainGageElevation

float

YES

dbl_ResidualForce

float

YES

dte_AddDate

datetime2

YES

txt_CreatedBy

nvarchar(50)

YES

dte_ModifiedDate

datetime2

YES

txt_ModifiedBy

nvarchar(50)

YES
Name:

tbl_LoadTestForceDistributionData

Description:

N/A

tbl_LoadTestForceDistributionData.png

Fig. 52 Appendix: DFLTD v.2 tbl_LoadTestForceDistributionData Table Relationships

Table 59 Appendix: FHWA DFLTD v.2 tbl_LoadTestForceDistributionData Table Attributes

Column

Type

Null

Units

NYU GPLTD-W Field

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

lng_KeyLoadTest (PK)

int

NO

dbl_KeyTotalAppliedLoad (PK)

float

NO

dbl_Ptr

float

YES

dbl_Force01

float

YES

dbl_Force02

float

YES

dbl_Force03

float

YES

dbl_Force04

float

YES

dbl_Force05

float

YES

dbl_Force06

float

YES

dbl_Force07

float

YES

dbl_Force08

float

YES

dbl_Force09

float

YES

dbl_Force10

float

YES

dbl_Force11

float

YES

dbl_Force12

float

YES

dbl_Force13

float

YES

dbl_Force14

float

YES

dbl_Force15

float

YES

dbl_Force16

float

YES

dte_AddDate

datetime2

YES

txt_CreatedBy

nvarchar(50)

YES

dte_ModifiedDate

datetime2

YES

txt_ModifiedBy

nvarchar(50)

YES
Name:

tbl_LoadTestNominalResistance

Description:

Load test nominal resistance for one or more failure criteria, e.g. failure load, displacement, etc.

tbl_LoadTestNominalResistance.png

Fig. 53 Appendix: DFLTD v.2 tbl_LoadTestNominalResistance Table Relationships

Table 60 Appendix: FHWA DFLTD v.2 tbl_LoadTestNominalResistance Table Attributes

Original Attribute

Type

Null

Units

New Attribute

lng_KeyProject (PK)

int

NO

lng_KeyDeepFoundation (PK)

int

NO

lng_KeyLoadTest (PK)

int

NO

txt_KeyFailureCriteriaCode (PK)

nvarchar(5)

NO

interp_capacities.type

dbl_FailureLoad

float

YES

interp_capacities.load

dbl_SideResistance

float

YES

(almost empty)

dbl_BaseResistance

float

YES

(almost empty)

dbl_Displacement

float

YES

interp_capacities.displacement

txt_CreatedBy

nvarchar(16)

YES

dte_AddDate

datetime2

YES

txt_ModifiedBy

nvarchar(18)

YES

dte_ModifiedDate

datetime2

YES

Attachments Table

Name:

tbl_Attachments

Description:

N/A

Table 61 Appendix: FHWA DFLTD v.2 tbl_Attachments Table Attributes

Original Attributes

Type

Null

Units

New Attributes

lng_KeyProject (PK)

int

NO

(empty)

txt_KeyPathAndFile (PK)

nvarchar(255)

NO

(empty)

txt_FileName

nvarchar(255)

YES

(empty)

txt_FileDescription

nvarchar(255)

YES

(empty)

txt_Category

nvarchar(255)

YES

(empty)

txt_KeyExplorationName

nvarchar(25)

YES

(empty)

txt_KeyExplorationType

nvarchar(25)

YES

(empty)

lng_KeyDeepFoundation

int

YES

(empty)

lng_KeyLoadTest

int

YES

(empty)

txt_CreatedBy

nvarchar(255)

YES

(empty)

dte_AddDate

datetime2

YES

(empty)

txt_ModifiedBy

nvarchar(255)

YES

(empty)

dte_ModifiedDate

datetime2

YES

(empty)

LAPLTD Tables and Attributes

Table 62 Appendix: LTRC LAPLTD dtProjects Table Attributes

Original Attribute

Description

Units

New Attribute

ID

Project_Num_H

H Number

projects.number

Project_Num_old

Project number (old)

projects.number

Project_Name

Project Name

projects.title

Route

Route foundation supports

projects.site_name

_OldID

Totals_TP

Test Pile Records

Path_Network

Location of file folder on T:\ drive

_OldID2

Contractor

Contractor performing foundation work

projects.contractor

Parish_1

Primary parish in which the project is located

locations.county

Parish_2

Secondary parish in which the project is located

Date_Latest

Drive date of latest test pile

Totals_MP

Monitor Pile Records

Totals_IP

Indicator Pile Records

Totals_Other

Other Pile Type Records

Totals_TS

Test Shaft Records

Source

Source

projects.source_ref

Notes

(empty)

Table 63 Appendix: LTRC LAPLTD dtStaticData Table Attributes

Original Attribute

Description

Units

New Attribute

ID

lt_Time

Elapsed time

minutes

lt_Load

Applied Load

tons

static_tests.load

lt_Deflection

Pile top deflection

inches

static_tests.displacement

_OldID

(empty)

Notes

Loading increment notes

lt_Event

Test Event

Table 64 Appendix: LTRC LAPLTD dtTestEvents Table Attributes

Original Attribute

Description

Units

New Attribute

ID

Date_Tested

Date of test event

Time_Elapsed

Elapsed time since EOD

hours

Capacity_Ult

Ultimate capacity derived from test event

tons

interp_capacities.load

Capacity_End

End bearing capacity derived from test event

tons

Capacity_Skin

Skin Friction capacity derived from test event

tons

Stroke

Observed stroke

feet

Blow_Count

Observed blow count at time of event

bl/ft

Jc

Damping constant associated with PDA capacity associated with Rx method

JRs

Damping constant associated with PDA capacity associated with Rs method

MQ

Match quality from CAPWAP analysis

Failure

Did static load test fail the pile?

boolean

Ult_Cap_Method

Butler-Hoy, Davisson (piles up to 24”), Modified Davisson (piles larger than 24”)

interp_capacities.type

Notes

Field testing notes

load_tests.remarks

_OldID

EMX

Hammer Enargy

kip-ft

_OldID2

Pile_Name

Name of the test pile

Event_Type

Type of test event used

Loc_Boring_Log

Location of File: Boring Log

(empty)

Loc_Pile_Install _Records

Location of File: Pile Installation Records

(empty)

Loc_Load_Test _Records

Location of File: Load Testing Records

(empty)

SP_Weight

Striker Plate Weight

kips

SP_Diameter

Striker Plate Diameter

inches

SP_Thickness

Striker Plate Thickness

inches

HC1_Material

Hammer Cushion 1 Material

HC1_Layers

Hammer Cushion 1 Layers

HC1_Thickness

Hammer Cushion 1 Thickness

inches

HC2_Material

Hammer Cushion 2 Material

HC2_Layers

Hammer Cushion 2 Layers

HC2_Thickness

Hammer Cushion 2 Thickness

inches

HC_Modulus_OR

Hammer Cushion Modulus of Elasticity OVERRIDE

ksi

(empty)

HC_CoR_OR

Hammer Cushion Coefficient of Restitution OVERRIDE

(empty)

M1_M2_Ratio

M1/M2 Thickness Ratio

Helmet_Dimension

Helmet (Pile Cap) Dimension

(empty)

Helmet_Weight

Helmet (Pile Cap) Weight

kips

Helmet_Ins_Weight

Helmet (Pile Cap) Inserts Weight

kips

(empty)

PC_Material

Pile Cushion Material

PC_Thickness

Pile Cushion Thickness

inches

PC_Area

Pile Cushion Area

sq.in.

Pile_Cushion

Pile Cushion

PC_Modulus_OR

Pile Cushion Modulus OVERRIDE

ksi

(empty)

PC_CoR_OR

Pile Cushion Coefficient of Restitution OVERRIDE

(empty)

Hammer_Cushion

Hammer Cushion

Quake_AvgSkin

Avg. Skin Quake

inches

Quake_AvgToe

Avg. Toe Quake

inches

Damping_AvgSkin

Avg. Skin Smith Damping

s/ft

Damping_AvgToe

Avg. Toe Smith Damping

s/ft

Percentage_Shaft _Resistance

Shaft Resistance Percentage

%

(empty)

Dist_Shape_Number

Distribution Shape Number

(empty)

Resistance _Distribution_Opt

Resistance Distribution Option

(empty)

Ult_Capacity_1

Ultimate Capacity 1

kips

(empty)

Ult_Capacity_2

Ultimate Capacity 2

kips

(empty)

Ult_Capacity_3

Ultimate Capacity 3

kips

(empty)

Ult_Capacity_4

Ultimate Capacity 4

kips

(empty)

Ult_Capacity_5

Ultimate Capacity 5

kips

(empty)

Ult_Capacity_6

Ultimate Capacity 6

kips

(empty)

Ult_Capacity_7

Ultimate Capacity 7

kips

(empty)

Ult_Capacity_8

Ultimate Capacity 8

kips

(empty)

Ult_Capacity_9

Ultimate Capacity 9

kips

(empty)

Ult_Capacity_10

Ultimate Capacity 10

kips

(empty)

Hammer

WEAP_Hammer _Option

Diesel Hammer Operation Option

(empty)

WEAP_Pressure_FS

Diesel Hammer Pressure Fuel Setting

(empty)

Override_Pressure _FS

Override Diesel Hammer Pressure for Fuel Setting

(empty)

Override_Efficiency

Override Hammer Efficiency

(empty)

Override_Stroke

Hammer Equivalent Maximum Stroke

feet

(empty)

Override_Frequency

Frequency for VIB hammer

Hz

(empty)

Elev_TipEOD

Pile tip elevation at end-of-drive

feet

Quake_Shaft

Soil Parameter: Shaft Quake

inches

(empty)

Quake_Toe

Soil Parameter: Toe Quake

inches

(empty)

Damping_Shaft

Soil Parameter: Damping Shaft

s/ft

(empty)

Damping_Toe

Soil Parameter: Toe Damping

s/ft

(empty)

Table 65 Appendix: LTRC LAPLTD dtTestPiles Table Attributes

Original Attribute

Description

Units

New Attribute

ID

Pile_Name

Test pile name

piles.name

Latitude

Latitude

decimal degrees

locations.latitude

Longitude

Longitude

decimal degrees

locations.longitude

Station

Station

feet

Sta_offset

Station Offset

Near_Boring

Name of the nearest soil boring

borings.name

Near_CPT

Name of the nearest CPT sounding

borings.name

Date_Driven

Date initial pile driving completed

piles.date_driven

Length

Total pile length

feet

piles.length

Elev_Reference

Reference Elevation: Measured, Estimated, or Unknown?

Elev_GS

Ground surface elevation

feet

borings.elevation

Elev_Casing

Elevation of bottom of casing

feet

Elev_Cutoff

Pile cutoff elevation

feet

Elev_Splice

Pile splice elevation

feet

(empty)

Elev_TipEOD

Pile tip elevation at end-of-drive

feet

Elev_TipDesign

Design pile tip elevation

feet

Notes

Test pile notes

piles.remarks

LRFD

Pile designed according to LRFD?

boolean

Load_Factored

Factored load used in LRFD design

tons

Resist_Factor

Resistance factor used in LRFD design

Load_Design

Design load used in ASD design

tons

piles.design_load

Load_Target

Ultimate pile resistance needed to verify design

tons

Setup_Factor

Pile setup factor

Designer

EOR for pile design

_OldID

Instrumented

Was the pile instrumented?

boolean

Elev_Scour

Scour Elevation

feet

Modulus

Elastic modulus of pile

ksi

piles.modulus

_OldID2

Project_ID

Project name

Hammer

Type of hammer used to drive pile

Pile_Type

Type/Size of pile

TP_Category

Type of test pile

Soil_Type

Type of soil pile is tipped into

borings.predom_soil

Steel_Yield_Strength

Steel Pile Yield Strength, Fy

ksi

(empty)

Concrete_Strength

Concrete Pile Yield Strength, Fy

ksi

(empty)

Pile_Splice

Is the pile spliced?

boolean

Stroke_EOID

Stroke [ft] closest available data to EOID

feet

Blowcount_EOID

Blow Count - closest available data to EOID

bl/ft

StokeBlCnt_Notes

Notes for Stroke and Blow Count Values