LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_HOLE_LOG

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
DIAMETER

NUMBER(2)
in

Core/Bore hole diameter
LENGTH

NUMBER(3,1)
ft

Length of the test pit
WIDTH

NUMBER(3,1)
ft

Width of the test pit.
GAUGE_ID

VARCHAR2(20)


Identification number of the nuclear density gauge.
REFUSAL_DEPTH

NUMBER(3,1)
ft

Depth at which shoulder auger probe was refused.
RECOVERED
Y_NVARCHAR2(1)


Code indicating whether a core was recovered during field sampling operations.
REPL_LOC_NO

VARCHAR2(5)


Field location number of a replacement core.
REFUSAL
Y_NVARCHAR2(1)


Code indicating whether split spoon sample was refused or shoulder auger probe refused within 20ft.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
FIELD_SET

NUMBER(2)


Sequential number indicating the field sampling event. Assigned 1 for first sample event and incremented by 1 for subsequent events.
LOC_NO

VARCHAR2(6)


Unique code number assigned to each sampling location indicating the sample type. The single character prefix indicates the sample type. The numeric suffix is the unique project location for the sample type.
CONSTRUCTION_NO

NUMBER(2)


Event number used to relate changes in pavement structure with other time dependent data elements. This field is set to 1 when a test section is initially accepted into LTPP and is incremented with each change to the layer structure.
SAMPLE_AREA_NO

VARCHAR2(5)


Number used to reference all samples taken from one area of the project - used only for SPS-5, 6, and 7 project.
HOLE_DATE

DATE


Date the core, bore, exploration, test, or auger was performed.
POINT_DISTANCE

NUMBER(6,1)
ft

Distance from the beginning or end of the test section to where the hole is made or sample is retrieved.
TRANS_POS

NUMBER(3,1)
ft

Offset distance of the core, bore, or shoulder probe from the shoulder of the pavement.