U.S. Department of Transportation
Federal Highway Administration
1200 New Jersey Avenue, SE
Washington, DC 20590
202-366-4000
Federal Highway Administration Research and Technology
Coordinating, Developing, and Delivering Highway Transportation Innovations
REPORT |
This report is an archived publication and may contain dated technical, contact, and link information |
|
![]() |
Publication Number: FHWA-HRT-13-089 Date: October 2013 |
Publication Number: FHWA-HRT-13-089 Date: October 2013 |
This appendix provides a data dictionary containing field names and descriptions for the tables included in the LTPP PLUG database. This information can aid in understanding the data in the database tables and to facilitate uploading of the additional information (LTPP updates or State-specific information) to the database tables.
Listed below are brief descriptions of the tables present in the database:
Table 21. Field names and descriptions for ALF_DEFAULT_ALS
Field Name |
Data Type |
Description |
---|---|---|
Month |
NUMBER(2,0) |
Code specifying the month in text format (January-December) |
Veh_Class |
NUMBER(2,0) |
Code indicating the 13-bin classification into which trucks have been grouped |
Sum_Axles |
NUMBER(3,0) |
A constant value of 100 populated in each record for ALF file generation |
Axle_Group |
NUMBER(1,0) |
Type of axle for which these percentages of axles apply |
Table 22. Field names and descriptions for ALF_Gen_Axle_Group
Field Name |
Data Type |
Description |
---|---|---|
Veh_Class |
NUMBER(2,0) |
Code indicating the 13-bin classification into which trucks have been grouped |
Axle_Group |
NUMBER(1,0) |
Type of axle for which these percentages of axles apply |
Table 23. Field names and descriptions for DEFAULT_AxlesPerTruck
Field Name |
Data Type |
Description |
---|---|---|
classNumber |
NUMBER(2,0) |
Code indicating the 13-bin classification into which trucks have been grouped |
numberAxle |
NUMBER(1,0) |
Type of axle for which the values in the field "truckAxleConfig" apply |
truckAxleConfig |
NUMBER(2,2) |
Number of this type of axle for a vehicle in this class |
Table 24. Field names and descriptions for DEFAULT_NALS
Field Name |
Data Type |
Description |
---|---|---|
VEH_CLASS |
NUMBER(2,0) |
Code indicating the 13-bin classification into which trucks have been grouped |
AXLE_GROUP |
NUMBER(1,0) |
Type of axle for which these percentages of axles apply |
NALS_CLUSTERS |
VARCHAR2(255) |
Text field indicating the type of NALS cluster |
MEPDG_LG01 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 0-2,999 lb for single axles; 0-5,999 lb for tandem axles; 0-11,999 lb for tridem and quad axles. |
MEPDG_LG02 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 3,000-3,999 lb for single axles; 6,000-7,999 lb for tandem axles; 12,000-14,999 lb for tridem and quad axles. |
MEPDG_LG03 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 4,000-4,999 lb for single axles; 8,000-9,999 lb for tandem axles; 15,000-17,999 lb for tridem and quad axles |
MEPDG_LG04 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 5,000-5,999 lb for single axles; 10,000-11,999 lb for tandem axles; 18,000-20,999 lb for tridem and quad axles |
MEPDG_LG05 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 6,000-6,999 lb for single axles; 12,000-13,999 lb for tandem axles; 21,000-23,999 lb for tridem and quad axles |
MEPDG_LG06 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 7,000-7,999 lb for single axles; 14,000-15,999 lb for tandem axles; 24,000-26,999 lb for tridem and quad axles |
MEPDG_LG07 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 8,000-8,999 lb for single axles; 16,000-17,999 lb for tandem axles; 27,000-29,999 lb for tridem and quad axles |
MEPDG_LG08 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 9,000-9,999 lb for single axles; 18,000-19,999 lb for tandem axles; 30,000-32,999 lb for tridem and quad axles |
MEPDG_LG09 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 10,000-10,999 lb for single axles; 20,000-21,999 lb for tandem axles; 33,000-35,999 lb for tridem and quad axles |
MEPDG_LG10 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 11,000-11,999 lb for single axles; 22,000-23,999 lb for tandem axles; 36,000-38,999 lb for tridem and quad axles |
MEPDG_LG11 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 12,000-12,999 lb for single axles; 24,000-25,999 lb for tandem axles; 39,000-41,999 lb for tridem and quad axles |
MEPDG_LG12 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 13,000-13,999 lb for single axles; 26,000-27,999 lb for tandem axles; 42,000-44,999 lb for tridem and quad axles |
MEPDG_LG13 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 14,000-14,999 lb for single axles; 28,000-29,999 lb for tandem axles; 45,000-47,999 lb for tridem and quad axles |
MEPDG_LG14 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 15,000-15,999 lb for single axles; 30,000-31,999 lb for tandem axles; 48,000-50,999 lb for tridem and quad axles |
MEPDG_LG15 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 16,000-16,999 lb for single axles; 32,000-33,999 lb for tandem axles; 51,000-53,999 lb for tridem and quad axles |
MEPDG_LG16 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 17,000-17,999 lb for single axles; 34,000-35,999 lb for tandem axles; 54,000-56,999 lb for tridem and quad axles |
MEPDG_LG17 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 18,000-18,999 lb for single axles; 36,000-37,999 lb for tandem axles; 57,000-59,999 lb for tridem and quad axles |
MEPDG_LG18 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 19,000-19,999 lb for single axles; 38,000-39,999 lb for tandem axles; 60,000-62,999 lb for tridem and quad axles |
MEPDG_LG19 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 20,000-20,999 lb for single axles; 40,000-41,999 lb for tandem axles; 63,000-65,999 lb for tridem and quad axles |
MEPDG_LG20 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 21000-21999 lb for single axles; 42,000-43,999 lb for tandem axles; 66,000-68,999 lb for tridem and quad axles |
MEPDG_LG21 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 22,000-22,999 lb for single axles; 44,000-45,999 lb for tandem axles; 69,000-71,999 lb for tridem and quad axles |
MEPDG_LG22 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 23,000-23,999 lb for single axles; 46,000-47,999 lb for tandem axles; 72,000-74,999 lb for tridem and quad axles |
MEPDG_LG23 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 24,000-24,999 lb for single axles; 48,000-49,999 lb for tandem axles; 75,000-77,999 lb for tridem and quad axles |
MEPDG_LG2,4 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 25,000-25,999 lb for single axles; 50,000-51,999 lb for tandem axles; 78,000-80,999 lb for tridem and quad axles |
MEPDG_LG25 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 26,000-26,999 lb for single axles; 52,000-53,999 lb for tandem axles; 81,000-83,999 lb for tridem and quad axles |
MEPDG_LG26 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 27,000-27,999 lb for single axles; 54,000-55,999 lb for tandem axles; 84,000-86,999 lb for tridem and quad axles |
MEPDG_LG27 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 28,000-28,999 lb for single axles; 56,000-57,999 lb for tandem axles; 87,000-89,999 lb for tridem and quad axles |
MEPDG_LG28 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 29,000-29,999 lb for single axles; 58,000-59,999 lb for tandem axles; 90000-92,999 lb for tridem and quad axles |
MEPDG_LG29 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 30,000-30,999 lb for single axles; 60,000-61,999 lb for tandem axles; 93,000-95,999 lb for tridem and quad axles |
MEPDG_LG30 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 31,000-31,999 lb for single axles; 62,000-63,999 lb for tandem axles; 96,000-98,999 lb for tridem and quad axles |
MEPDG_LG31 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 32,000-32,999 lb for single axles; 64,000-65,999 lb for tandem axles; 99,000-101,999 lb for tridem and quad axles |
MEPDG_LG32 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 33,000-33,999 lb for single axles; 66,000-67,999 lb for tandem axles |
MEPDG_LG33 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 34,000-34,999 lb for single axles; 68,000-69,999 lb for tandem axles |
MEPDG_LG34 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 35,000-35,999 lb for single axles; 70,000-71,999 lb for tandem axles |
MEPDG_LG35 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 36,000-36,999 lb for single axles; 72,000-73,999 lb for tandem axles |
MEPDG_LG36 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 37,000-37,999 lb for single axles; 74,000-75,999 lb for tandem axles |
MEPDG_LG37 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 38,000-38,999 lb for single axles; 76,000-77,999 lb for tandem axles |
MEPDG_LG38 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 39,000-39,999 lb for single axles; 78,000-79,999 lb for tandem axles |
MEPDG_LG39 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 40,000-40,999 lb for single axles; 80,000-81,999 lb for tandem axles |
Description |
VARCHAR2(255) |
Text description for NALS_CLUSTERS field |
Recommended_Road_Usage |
VARCHAR2(255) |
Text description indicating the recommended road usage for the selected cluster |
Table 25. Field names and descriptions for LTPP_CODES
Field Name |
Data Type |
Description |
---|---|---|
CODETYPE |
VARCHAR2(40) |
Name assigned to a set of codes for a field in another table |
CODE |
NUMBER(2,0) |
Unique text value whose meaning is defined in CODES.DETAIL |
DETAIL |
VARCHAR2(200) |
Textual description defining the meaning of the code |
ADDL_CODE |
VARCHAR2(2) |
Additional code needed to uniquely define the meaning of a code. For example, both State and county code are needed to uniquely identify a county |
ADDL_CODETYPE |
VARCHAR2(20) |
Codetype of the code entered in the ADDL_CODE field |
Table 26. Field names and descriptions for PLUG_LEF_FOR_ESAL
Field Name |
Data Type |
Description |
---|---|---|
PAVEMENT_TYPE |
VARCHAR2(255) |
Code indicating pavement type |
AXLE_TYPE |
NUMBER(1,0) |
Type of axle for which these values apply |
AX_01 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 0.5 times WEIGHT_BIN_SIZE |
AX_02 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 1.5 times WEIGHT_BIN_SIZE |
AX_03 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 3.5 times WEIGHT_BIN_SIZE |
AX_04 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 4.5 times WEIGHT_BIN_SIZE |
AX_05 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 5.5 times WEIGHT_BIN_SIZE |
AX_06 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 6.5 times WEIGHT_BIN_SIZE |
AX_07 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 7.5 times WEIGHT_BIN_SIZE |
AX_08 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 8.5 times WEIGHT_BIN_SIZE |
AX_09 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 9.5 times WEIGHT_BIN_SIZE |
AX_10 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 10.5 times WEIGHT_BIN_SIZE |
AX_11 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 11.5 times WEIGHT_BIN_SIZE |
AX_12 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 12.5 times WEIGHT_BIN_SIZE |
AX_13 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 13.5 times WEIGHT_BIN_SIZE |
AX_14 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 14.5 times WEIGHT_BIN_SIZE |
AX_15 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 15.5 times WEIGHT_BIN_SIZE |
AX_16 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 16.5 times WEIGHT_BIN_SIZE |
AX_17 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 17.5 times WEIGHT_BIN_SIZE |
AX_18 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 18.5 times WEIGHT_BIN_SIZE |
AX_19 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 19.5 times WEIGHT_BIN_SIZE |
AX_20 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 20.5 times WEIGHT_BIN_SIZE |
AX_21 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 21.5 times WEIGHT_BIN_SIZE |
AX_22 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 22.5 times WEIGHT_BIN_SIZE |
AX_23 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 23.5 times WEIGHT_BIN_SIZE |
AX_24 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 24.5 times WEIGHT_BIN_SIZE |
AX_25 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 25.5 times WEIGHT_BIN_SIZE |
AX_26 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 26.5 times WEIGHT_BIN_SIZE |
AX_27 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 27.5 times WEIGHT_BIN_SIZE |
AX_28 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 28.5 times WEIGHT_BIN_SIZE |
AX_29 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 29.5 times WEIGHT_BIN_SIZE |
AX_30 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 30.5 times WEIGHT_BIN_SIZE |
AX_31 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 31.5 times WEIGHT_BIN_SIZE |
AX_32 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 32.5 times WEIGHT_BIN_SIZE |
AX_33 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 33.5 times WEIGHT_BIN_SIZE |
AX_34 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 34.5 times WEIGHT_BIN_SIZE |
AX_35 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 35.5 times WEIGHT_BIN_SIZE |
AX_36 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 36.5 times WEIGHT_BIN_SIZE |
AX_37 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 37.5 times WEIGHT_BIN_SIZE |
AX_38 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 38.5 times WEIGHT_BIN_SIZE |
AX_39 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 39.5 times WEIGHT_BIN_SIZE |
AX_40 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 40.5 times WEIGHT_BIN_SIZE |
AX_41 |
NUMBER(2,20) |
LEF for axles in bin with mid-point weight equal to 41.5 times WEIGHT_BIN_SIZE |
WEIGHT_BIN_SIZE |
NUMBER(4,0) |
Value of the increment for a bin for the axle type as loaded. 1,000 for single axles; 2,000 for tandem axles; 3,000 for tridem axles; 3,000 or 4,000 for quad axles, depending on the software version used to load the data |
Table 27. Field names and descriptions for PLUG_W_FACTORS_FOR_RPPIF
Field Name |
Data Type |
Description |
---|---|---|
Axle_Type |
NUMBER(1, 0) |
Type of axle for which these W-factors apply |
AX_CT_01 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin 0-999 lb for single axles; 0-1,999 lb for tandem axles; 0-2,999 lb for tridem and quad axles |
AX_CT_02 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin 1,000-1,999 lb for single axles; 2,000-3,999 lb for tandem axles; 3,000-5,999 lb for tridem and quad axles |
AX_CT_03 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_04 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_05 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_06 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_07 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_08 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_09 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin 8,000-8,999 lb for single axles; 16,000-17,999 lb for tandem axles; 24,000-26,999 lb for tridem and quad axles |
AX_CT_10 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_11 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_12 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_13 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_14 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_15 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_16 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_17 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_18 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_19 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_20 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_21 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_22 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_23 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_24 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_25 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_26 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_27 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_28 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_29 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_30 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_31 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_32 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_33 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_34 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_35 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_36 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_37 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_38 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_39 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
AX_CT_40 |
NUMBER(2,20) |
W-factors for axles whose weight falls in the lowest bin |
Table 28. Field names and descriptions for SITE_SPECIFIC_AxlesPerTruck
Field Name |
Data Type |
Description |
---|---|---|
STATE_CODE |
NUMBER(2,0) |
Numerical code for State or Province. U.S. codes are consistent with Federal Information Processing Standards |
SHRP_ID |
VARCHAR2(255) |
Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique |
classNumber |
NUMBER(2,0) |
Code indicating the 13-bin classification into which trucks have been grouped |
numberAxle |
NUMBER(1,0) |
Type of axle for which the values in the field "truckAxleConfig" apply |
truckAxleConfig |
NUMBER(1,2) |
Number of this type of axle for a vehicle in this class |
Table 29. Field names and descriptions for SITE_SPECIFIC_NALS
Field Name |
Data Type |
Description |
---|---|---|
STATE_CODE |
NUMBER(2,0) |
Numerical code for State or Province. U.S. codes are consistent with Federal Information Processing Standards |
SHRP_ID |
VARCHAR2(255) |
Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique |
VEH_CLASS |
NUMBER(2,0) |
Code indicating the 13-bin classification into which trucks have been grouped |
AXLE_GROUP |
NUMBER(1,0) |
Type of axle for which these percentages of axles apply |
MEPDG_LG01 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 0-2,999 lb for single axles; 0-5,999 lb for tandem axles; 0-11,999 lb for tridem and quad axles |
MEPDG_LG02 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 3,000-3,999 lb for single axles; 6,000-7,999 lb for tandem axles; 12,000-14,999 lb for tridem and quad axles |
MEPDG_LG03 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 4,000-4,999 lb for single axles; 8,000-9,999 lb for tandem axles; 15,000-17,999 lb for tridem and quad axles |
MEPDG_LG04 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 5,000-5,999 lb for single axles; 10,000-11,999 lb for tandem axles; 18,000-20,999 lb for tridem and quad axles |
MEPDG_LG05 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 6,000-6,999 lb for single axles; 12,000-13,999 lb for tandem axles; 21,000-23,999 lb for tridem and quad axles |
MEPDG_LG06 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 7,000-7,999 lb for single axles; 14,000-15,999 lb for tandem axles; 24,000-26,999 lb for tridem and quad axles |
MEPDG_LG07 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 8,000-8,999 lb for single axles; 16,000-17,999 lb for tandem axles; 27,000-2,9999 lb for tridem and quad axles |
MEPDG_LG08 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 9,000-9,999 lb for single axles; 18,000-19,999 lb for tandem axles; 30,000-32,999 lb for tridem and quad axles |
MEPDG_LG09 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 10,000-10,999 lb for single axles; 20,000-21,999 lb for tandem axles; 33,000-35,999 lb for tridem and quad axles |
MEPDG_LG10 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 11,000-11,999 lb for single axles; 22,000-23,999 lb for tandem axles; 36,000-38,999 lb for tridem and quad axles |
MEPDG_LG11 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 12,000-12,999 lb for single axles; 24,000-25,999 lb for tandem axles; 39,000-41,999 lb for tridem and quad axles |
MEPDG_LG12 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 13,000-13,999 lb for single axles; 26,000-27,999 lb for tandem axles; 42,000-44,999 lb for tridem and quad axles |
MEPDG_LG13 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 14,000-14,999 lb for single axles; 28,000-29,999 lb for tandem axles; 45,000-47,999 lb for tridem and quad axles |
MEPDG_LG14 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 15,000-15,999 lb for single axles; 30,000-31,999 lb for tandem axles; 48,000-50,999 lb for tridem and quad axles |
MEPDG_LG15 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 16,000-16,999 lb for single axles; 32,000-33,999 lb for tandem axles; 51,000-53,999 lb for tridem and quad axles |
MEPDG_LG16 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 17,000-17,999 lb for single axles; 34,000-35,999 lb for tandem axles; 54,000-56,999 lb for tridem and quad axles |
MEPDG_LG17 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 18,000-18,999 lb for single axles; 36,000-37,999 lb for tandem axles; 57,000-5,9999 lb for tridem and quad axles |
MEPDG_LG18 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 19,000-1,9999 lb for single axles; 38,000-39,999 lb for tandem axles; 60,000-62,999 lb for tridem and quad axles |
MEPDG_LG19 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 20,000-20,999 lb for single axles; 4,0000-41,999 lb for tandem axles; 63,000-65,999 lb for tridem and quad axles |
MEPDG_LG20 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 21,000-21,999 lb for single axles; 42,000-43,999 lb for tandem axles; 66,000-68,999 lb for tridem and quad axles |
MEPDG_LG21 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 22,000-22,999 lb for single axles; 44,000-45,999 lb for tandem axles; 69,000-71,999 lb for tridem and quad axles |
MEPDG_LG22 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 23,000-23,999 lb for single axles; 46,000-47,999 lb for tandem axles; 72,000-74,999 lb for tridem and quad axles |
MEPDG_LG23 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 24,000-24,999 lb for single axles; 48,000-49,999 lb for tandem axles; 75,000-77,999 lb for tridem and quad axles |
MEPDG_LG24 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 25,000-25,999 lb for single axles; 50,000-51,999 lb for tandem axles; 78,000-80,999 lb for tridem and quad axles |
MEPDG_LG25 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 26,000-26,999 lb for single axles; 52,000-53,999 lb for tandem axles; 81,000-83,999 lb for tridem and quad axles |
MEPDG_LG26 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 27,000-27,999 lb for single axles; 54,000-55,999 lb for tandem axles; 84,000-86,999 lb for tridem and quad axles |
MEPDG_LG27 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 28,000-28,999 lb for single axles; 56,000-57,999 lb for tandem axles; 87,000-89,999 lb for tridem and quad axles |
MEPDG_LG28 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 29,000-29,999 lb for single axles; 58,000-59,999 lb for tandem axles; 90,000-92,999 lb for tridem and quad axles |
MEPDG_LG29 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 30,000-30,999 lb for single axles; 60,000-61,999 lb for tandem axles; 93,000-95,999 lb for tridem and quad axles |
MEPDG_LG30 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 31,000-31,999 lb for single axles; 62,000-63,999 lb for tandem axles; 96,000-98,999 lb for tridem and quad axles |
MEPDG_LG31 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 32,000-32,999 lb for single axles; 64,000-65,999 lb for tandem axles; 99,000-101,999 lb for tridem and quad axles |
MEPDG_LG32 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 33,000-33,999 lb for single axles; 66,000-67,999 lb for tandem axles |
MEPDG_LG33 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 34,000-34,999 lb for single axles; 68,000-69,999 lb for tandem axles |
MEPDG_LG34 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 35,000-35,999 lb for single axles; 70,000-71,999 lb for tandem axles |
MEPDG_LG35 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 36,000-36,999 lb for single axles; 72,000-73,999 lb for tandem axles |
MEPDG_LG36 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 37,000-37,999 lb for single axles; 74,000-75,999 lb for tandem axles |
MEPDG_LG37 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 38,000-38,999 lb for single axles; 76,000-77,999 lb for tandem axles |
MEPDG_LG38 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 39,000-39,999 lb for single axles; 78,000-79,999 lb for tandem axles |
MEPDG_LG39 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 40,000-40,999 lb for single axles; 80,000-81,999 lb for tandem axles |
Table 30. Field names and descriptions for SITE_SPECIFIC_NVCD
Field Name |
Data Type |
Description |
---|---|---|
STATE_CODE |
NUMBER(2,0) |
Numerical code for State or Province. U.S. codes are consistent with Federal Information Processing Standards |
SHRP_ID |
VARCHAR2(255) |
Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique |
YEAR |
NUMBER(4,0) |
Year for which values apply |
VEHICLE_CLASS |
NUMBER(2,0) |
Code indicating the 13-bin classification into which trucks have been grouped |
Pct_Trucks_Class |
NUMBER(3,2) |
Percentage of the truck population represented by this class |
Table 31. Field names and descriptions for USER_DEFINED_NALS
Field Name |
Data Type |
Description |
---|---|---|
VEH_CLASS |
NUMBER(2,0) |
Code indicating the 13-bin classification into which trucks have been grouped |
AXLE_GROUP |
NUMBER(1,0) |
Type of axle for which these percentages of axles apply |
NALS_CLUSTERS |
VARCHAR2(255) |
Text field indicating the type of NALS cluster |
MEPDG_LG01 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 0-2,999 lb for single axles; 0-5,999 lb for tandem axles; 0-11,999 lb for tridem and quad axles |
MEPDG_LG02 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 3,000-3,999 lb for single axles; 6,000-7,999 lb for tandem axles; 12,000-14,999 lb for tridem and quad axles |
MEPDG_LG03 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 4,000-4,999 lb for single axles; 8,000-9,999 lb for tandem axles; 15,000-17,999 lb for tridem and quad axles |
MEPDG_LG04 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 5,000-5,999 lb for single axles; 10,000-11,999 lb for tandem axles; 18,000-20,999 lb for tridem and quad axles |
MEPDG_LG05 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 6,000-6,999 lb for single axles; 12,000-13,999 lb for tandem axles; 21,000-23,999 lb for tridem and quad axles |
MEPDG_LG06 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 7,000-7,999 lb for single axles; 14,000-15,999 lb for tandem axles; 24,000-26,999 lb for tridem and quad axles |
MEPDG_LG07 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 8,000-8,999 lb for single axles; 16,000-17,999 lb for tandem axles; 27,000-2,9999 lb for tridem and quad axles |
MEPDG_LG08 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 9,000-9,999 lb for single axles; 18,000-19,999 lb for tandem axles; 30,000-32,999 lb for tridem and quad axles |
MEPDG_LG09 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 10,000-10,999 lb for single axles; 20,000-21,999 lb for tandem axles; 33,000-35,999 lb for tridem and quad axles |
MEPDG_LG10 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 11,000-11,999 lb for single axles; 22,000-23,999 lb for tandem axles; 36,000-38,999 lb for tridem and quad axles |
MEPDG_LG11 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 12,000-12,999 lb for single axles; 24,000-25,999 lb for tandem axles; 39,000-41,999 lb for tridem and quad axles |
MEPDG_LG12 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 13,000-13,999 lb for single axles; 26,000-27,999 lb for tandem axles; 42,000-44,999 lb for tridem and quad axles |
MEPDG_LG13 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 14,000-14,999 lb for single axles; 28,000-29,999 lb for tandem axles; 45,000-47,999 lb for tridem and quad axles |
MEPDG_LG14 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 15,000-15,999 lb for single axles; 30,000-31,999 lb for tandem axles; 48,000-50,999 lb for tridem and quad axles |
MEPDG_LG15 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 16,000-16,999 lb for single axles; 32,000-33,999 lb for tandem axles; 51,000-53,999 lb for tridem and quad axles |
MEPDG_LG16 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 17,000-17,999 lb for single axles; 34,000-35,999 lb for tandem axles; 54,000-56,999 lb for tridem and quad axles |
MEPDG_LG17 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 18,000-18,999 lb for single axles; 36,000-37,999 lb for tandem axles; 57,000-5,9999 lb for tridem and quad axles |
MEPDG_LG18 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 19,000-19,999 lb for single axles; 38,000-39,999 lb for tandem axles; 60,000-62,999 lb for tridem and quad axles |
MEPDG_LG19 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 20,000-20,999 lb for single axles; 40,000-41,999 lb for tandem axles; 63,000-65,999 lb for tridem and quad axles |
MEPDG_LG20 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 21,000-21,999 lb for single axles; 42,000-43,999 lb for tandem axles; 66,000-68,999 lb for tridem and quad axles |
MEPDG_LG21 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 22,000-22,999 lb for single axles; 44,000-45,999 lb for tandem axles; 69,000-71,999 lb for tridem and quad axles |
MEPDG_LG22 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 23,000-23,999 lb for single axles; 46,000-47,999 lb for tandem axles; 72,000-74,999 lb for tridem and quad axles |
MEPDG_LG23 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 24,000-24,999 lb for single axles; 48,000-49,999 lb for tandem axles; 75,000-77,999 lb for tridem and quad axles |
MEPDG_LG24 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 25,000-25,999 lb for single axles; 50,000-51,999 lb for tandem axles; 78,000-80,999 lb for tridem and quad axles |
MEPDG_LG25 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 26,000-26,999 lb for single axles; 52,000-53,999 lb for tandem axles; 81,000-83,999 lb for tridem and quad axles |
MEPDG_LG26 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 27,000-27,999 lb for single axles; 54,000-55,999 lb for tandem axles; 84,000-86,999 lb for tridem and quad axles |
MEPDG_LG27 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 28,000-28,999 lb for single axles; 56,000-57,999 lb for tandem axles; 87,000-89,999 lb for tridem and quad axles |
MEPDG_LG28 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 29,000-29,999 lb for single axles; 58,000-59,999 lb for tandem axles; 90,000-92,999 lb for tridem and quad axles |
MEPDG_LG29 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 30,000-30,999 lb for single axles; 60,000-61,999 lb for tandem axles; 93,000-95,999 lb for tridem and quad axles |
MEPDG_LG30 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 31,000-31,999 lb for single axles; 62,000-63,999 lb for tandem axles; 96,000-98,999 lb for tridem and quad axles |
MEPDG_LG31 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 32,000-32,999 lb for single axles; 64,000-65,999 lb for tandem axles; 99,000-101,999 lb for tridem and quad axles |
MEPDG_LG32 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 33,000-33,999 lb for single axles; 66,000-67,999 lb for tandem axles |
MEPDG_LG33 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 34,000-34,999 lb for single axles; 68,000-69,999 lb for tandem axles |
MEPDG_LG34 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 35,000-35,999 lb for single axles; 70,000-71,999 lb for tandem axles |
MEPDG_LG35 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 36,000-36,999 lb for single axles; 72,000-73,999 lb for tandem axles |
MEPDG_LG36 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 37,000-37,999 lb for single axles; 74,000-75,999 lb for tandem axles |
MEPDG_LG37 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 38,000-38,999 lb for single axles; 76,000-77,999 lb for tandem axles |
MEPDG_LG38 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 39,000-39,999 lb for single axles; 78,000-79,999 lb for tandem axles |
MEPDG_LG39 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 40,000-40,999 lb for single axles; 80,000-81,999 lb for tandem axles |
Description |
VARCHAR2(255) |
User-defined description for the NALS |
Cluster_Description |
VARCHAR2(255) |
Text description for NALS_CLUSTERS field |
Recommended_Road_Usage |
VARCHAR2(255) |
Text description indicating the recommended road usage for the selected cluster |
Table 32. Field names and descriptions for XMLGen_AxleLoadDistribution
Field Name |
Data Type |
Description |
---|---|---|
classNumber |
NUMBER(2,0) |
Code indicating the 13-bin classification into which trucks have been grouped |
numberAxle |
NUMBER(1,0) |
Type of axle (1-4) for which these values apply |
month |
NUMBER(2,0) |
Code specifying the month in numeric format (1-12) |
axleLoad |
NUMBER(2,0) |
Code specifying load bins in DARWin-ME (1-39) |
percentTrucksPerLoad |
NUMBER(3,14) |
Percentage of axles whose weight falls in the specified DARWin-ME load bin |
Table 33. Field names and descriptions for XMLGen_AxleLoadMain_Template
Field Name |
Data Type |
Description |
---|---|---|
classNumber |
NUMBER(2,0) |
Code indicating the 13-bin classification into which trucks have been grouped |
numberAxle |
NUMBER(1,0) |
Type of axle (1-4) for which these values apply |
month |
NUMBER(2,0) |
Code specifying the month in numeric format (1-12) |
axleLoad |
NUMBER(2,0) |
Code specifying load bins in DARWin-ME (1-39) |
Table 34. Field names and descriptions for XMLGen_DEFAULT_NALS_By_Loading_Cluster
Field Name |
Data Type |
Description |
---|---|---|
VEH_CLASS |
NUMBER(2,0) |
Code indicating the 13-bin classification into which trucks have been grouped |
AXLE_GROUP |
NUMBER(1,0) |
Type of axle for which these percentages of axles apply |
MEPDG_LG01 |
NUMBER(3,14) |
Percent of axles whose weight falls in the bin 0-2,999 lb for single axles; |
MEPDG_LG02 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 3,000-3,999 lb for single axles; 6,000-7,999 lb for tandem axles; 12,000-14,999 lb for tridem and quad axles |
MEPDG_LG03 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 4,000-4,999 lb for single axles; 8,000-9,999 lb for tandem axles; 15,000-17,999 lb for tridem and quad axles |
MEPDG_LG04 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 5,000-5,999 lb for single axles; 10,000-11,999 lb for tandem axles; 18,000-20999 lb for tridem and quad axles |
MEPDG_LG05 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 6,000-6,999 lb for single axles; 12,000-13,999 lb for tandem axles; 21,000-23999 lb for tridem and quad axles |
MEPDG_LG06 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 7,000-7,999 lb for single axles; 14,000-15,999 lb for tandem axles; 24,000-26,999 lb for tridem and quad axles |
MEPDG_LG07 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 8,000-8,999 lb for single axles; 16,000-17,999 lb for tandem axles; 27,000-29,999 lb for tridem and quad axles |
MEPDG_LG08 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 9,000-9,999 lb for single axles; 18,000-19,999 lb for tandem axles; 30,000-32,999 lb for tridem and quad axles |
MEPDG_LG09 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 10,000-10,999 lb for single axles; 20,000-21,999 lb for tandem axles; 33,000-35,999 lb for tridem and quad axles |
MEPDG_LG10 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 11,000-11,999 lb for single axles; 22,000-23,999 lb for tandem axles; 36,000-38,999 lb for tridem and quad axles |
MEPDG_LG11 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 12,000-12,999 lb for single axles; 24,000-25,999 lb for tandem axles; 39,000-41,999 lb for tridem and quad axles |
MEPDG_LG12 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 13,000-13,999 lb for single axles; 26,000-27,999 lb for tandem axles; 42,000-44,999 lb for tridem and quad axles |
MEPDG_LG13 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 14,000-14,999 lb for single axles; 28,000-29,999 lb for tandem axles; 45,000-47,999 lb for tridem and quad axles |
MEPDG_LG14 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 15,000-15,999 lb for single axles; 30,000-31,999 lb for tandem axles; 48,000-50,999 lb for tridem and quad axles |
MEPDG_LG15 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 16,000-16,999 lb for single axles; 32,000-33,999 lb for tandem axles; 51,000-53,999 lb for tridem and quad axles |
MEPDG_LG16 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 17,000-17,999 lb for single axles; 34,000-35,999 lb for tandem axles; 54,000-56,999 lb for tridem and quad axles |
MEPDG_LG17 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 18,000-18,999 lb for single axles; 36,000-37,999 lb for tandem axles; 57,000-59,999 lb for tridem and quad axles |
MEPDG_LG18 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 19,000-19,999 lb for single axles; 38,000-39,999 lb for tandem axles; 60,000-62,999 lb for tridem and quad axles |
MEPDG_LG19 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 20,000-20,999 lb for single axles; 40,000-41,999 lb for tandem axles; 63,000-65,999 lb for tridem and quad axles |
MEPDG_LG20 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 21,000-21,999 lb for single axles; 42,000-43,999 lb for tandem axles; 66,000-68,999 lb for tridem and quad axles |
MEPDG_LG21 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 22,000-22,999 lb for single axles; 44,000-45,999 lb for tandem axles; 69,000-71,999 lb for tridem and quad axles |
MEPDG_LG22 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 23,000-23,999 lb for single axles; 46,000-47,999 lb for tandem axles; 72,000-74,999 lb for tridem and quad axles |
MEPDG_LG23 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 24,000-24,999 lb for single axles; 48,000-49,999 lb for tandem axles; 75,000-77,999 lb for tridem and quad axles |
MEPDG_LG24 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 25,000-25,999 lb for single axles; 50,000-51,999 lb for tandem axles; 78,000-80,999 lb for tridem and quad axles |
MEPDG_LG25 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 26,000-26,999 lb for single axles; 52,000-53,999 lb for tandem axles; 81,000-83,999 lb for tridem and quad axles |
MEPDG_LG26 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 27,000-27,999 lb for single axles; 54,000-55,999 lb for tandem axles; 84,000-86,999 lb for tridem and quad axles |
MEPDG_LG27 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 28,000-28,999 lb for single axles; 56,000-57,999 lb for tandem axles; 87,000-89,999 lb for tridem and quad axles |
MEPDG_LG28 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 29,000-29,999 lb for single axles; 58,000-59,999 lb for tandem axles; 90,000-92,999 lb for tridem and quad axles |
MEPDG_LG29 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 30,000-30,999 lb for single axles; 60,000-61,999 lb for tandem axles; 93,000-95,999 lb for tridem and quad axles |
MEPDG_LG30 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 31,000-31,999 lb for single axles; 62,000-63,999 lb for tandem axles; 96,000-98,999 lb for tridem and quad axles |
MEPDG_LG31 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 32,000-32,999 lb for single axles; 64,000-65,999 lb for tandem axles; 99,000-101,999 lb for tridem and quad axles |
MEPDG_LG32 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 33,000-33,999 lb for single axles; 66,000-67,999 lb for tandem axles |
MEPDG_LG33 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 34,000-34,999 lb for single axles; 68,000-69,999 lb for tandem axles |
MEPDG_LG34 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 35,000-35,999 lb for single axles; 70,000-71,999 lb for tandem axles |
MEPDG_LG35 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 36,000-36,999 lb for single axles; 72,000-73,999 lb for tandem axles |
MEPDG_LG36 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 37,000-37,999 lb for single axles; 74,000-75,999 lb for tandem axles |
MEPDG_LG37 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 38,000-38,999 lb for single axles; 76,000-77,999 lb for tandem axles |
MEPDG_LG38 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 39,000-39,999 lb for single axles; 78,000-79,999 lb for tandem axles |
MEPDG_LG39 |
NUMBER(3,14) |
Percentage of axles whose weight falls in the bin 4,0000-40,999 lb for single axles; 80,000-81,999 lb for tandem axles |