LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SITE_EQUIPMENT_INFO

Field NameCodesData TypeUnitsTest ProtocolDescription
STATE_CODE
STATE_PROVINCENUMBER(2)


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

DATE


Last date for which this equipment was installed at the site with the characteristics identified.
CLASS_SCHEME
CLASS_SCHEMENUMBER(1)


Methodology used to segregate vehicles into different groups.
TRF_MANUFACTURER

VARCHAR2(20)


Traffic Equipment manufacturer's name.
TRF_MODEL

VARCHAR2(20)


Model of equipment installed at site.
LATITUDE

NUMBER(7,5)
deg

Latitude of the beginning point of a test section at the outside land edge_shoulder point.
LONGITUDE

NUMBER(8,5)
deg

Longitude of the beginning point of a test section on the outside lane edge_shoulder point.
MEASUREMENT_ACCURACY

NUMBER(3,1)
m

Accuracy of the location measurement from global position satellite receiver measurements - Not available for all locations.
DATUM
MAP_DATUMVARCHAR2(1)


Code indicating the map datum used for coordinate locations.
DATUM_OTHER

VARCHAR2(64)


Map datum used for coordinate locations if other than specified.
COORDINATE_DETERMINATION
COORD_DETERMINEVARCHAR2(1)


Code indicating the method used to determine location coordinates.
SHRP_ID

VARCHAR2(4)


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

DATE


Date for which the equipment at this site was installed in service with the specified characteristics in the record.
TRF_DATA_TYPE
TRF_DATA_TYPENUMBER(1)


Type of data being collected with this equipment.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
ROUTE

VARCHAR2(15)


Route number for the road on which this equipment is installed.
TRF_SENSOR
TRF_SENSORNUMBER(2)


Type of sensor the equipment uses to perform its principal function.
MILEPOST

NUMBER(4,1)


The location of the site on the route using the agency's mile post location convention.
TRF_LOCATION

VARCHAR2(60)


Description or comments that further explain the location of the traffic equipment.