From a 500-row sample across 27 columns.
wt12spc12num_axles+45wheelbaseyeardirection| direction | year | month | day | hour | minute | second | lane | class | speed | num_axles | gvw |
|---|---|---|---|---|---|---|---|---|---|---|---|
| QB | 23 | 5 | 8 | 17 | 53 | 16 | 2 | 2 | 49 | 2 | 4880 |
| QB | 23 | 9 | 13 | 22 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
direction | categorical | The direction the vehicle is traveling toward on the highway. | 0% | QBSIBof 2 |
year | categorical | Two digit code for the year in which the data were collected. | 0% | 202123of 6 |
month | categorical | One or two digit code for the month in which the data were collected. | 0% | 12118of 12 |
day | integer | One or two digit code for the day of the month which the data were collected. | 0% | 272224 |
GET /api/datasets/n5c8-x7x2 GET /api/datasets/n5c8-x7x2/quality GET /api/datasets/n5c8-x7x2/related GET /api/columns?dataset=n5c8-x7x2
direction| 6 |
| 18 |
| 1 |
| 2 |
| 46 |
| 2 |
| 5760 |
| QB | 23 | 8 | 22 | 16 | 6 | 24 | 1 | 2 | 55 | 2 | 5840 |
| QB | 23 | 11 | 27 | 1 | 27 | 23 | 1 | 2 | 45 | 2 | 3760 |
| QB | 23 | 8 | 31 | 17 | 38 | 47 | 1 | 3 | 11 | 2 | 5820 |
| QB | 23 | 7 | 23 | 15 | 50 | 22 | 2 | 2 | 47 | 2 | 3300 |
| QB | 23 | 7 | 20 | 20 | 48 | 41 | 2 | 2 | 48 | 2 | 5180 |
| QB | 23 | 7 | 31 | 3 | 5 | 12 | 1 | 2 | 37 | 2 | 2060 |
| QB | 23 | 7 | 23 | 6 | 15 | 55 | 1 | 2 | 37 | 2 | 2660 |
| QB | 23 | 11 | 1 | 15 | 54 | 46 | 1 | 5 | 49 | 2 | 20080 |
Showing 12 of 17 columns. All of them are listed below.
hour | integer | One or two digit code for the beginning of the hour in which the count was taken. | 0% | 151413 |
minute | integer | One or two digit code of the minute in which the count was taken. | 0% | 444147 |
second | integer | One or two digit code of the second in which the count was taken. | 0% | 293035 |
lane | categorical | The lane which the vehicle is traveling on. Either each lane is considered a separate station or all lanes in each direction are combined. | 0% | 231of 3 |
class | categorical | The class of the vehicle from FHWA Vehicle Classes 1 to 13. | 0% | 235of 15 |
speed | integer | The traveling speed of the truck in miles per hour. | 0% | 272524 |
num_axles | integer | The total number of axles in use by the vehicle including any trailers. | 0% | 253 |
gvw | integer | The gross vehicle weight (GVW) to the nearest pound without a decimal point. This should equal the sum of all the axle weights except for rounding. | 0% | 360030403720 |
wheelbase | float | The distance between the steering and the first device axle of a tractor or a heavy single unit. | 0% | 98.89.3 |
wt1 | integer | Weight of axel to the nearest pound without a decimal point. | 0% | 160015201620 |
spc1 | float | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 0% | 98.89.3 |
wt2 | integer | Weight of axel to the nearest pound without a decimal point. | 0% | 136014601520 |
spc2 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 94% | 4.34.44.6 |
wt3 | text | Weight of axel to the nearest pound without a decimal point. | 94% | 10000990010120 |
spc3 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 96% | 4.19.49.6 |
wt4 | text | Weight of axel to the nearest pound without a decimal point. | 96% | 10000988010120 |
spc4 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 97% | 4.144.2 |
wt5 | text | Weight of axel to the nearest pound without a decimal point. | 97% | 10000101209880 |
spc5 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 4.14.34.2 |
wt6 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 20000181208000 |
spc6 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 4.14.34.2 |
wt7 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 200001904019740 |
spc7 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 9.69.84.2 |
wt8 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 350036803760 |
spc8 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 4.244.1 |
wt9 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 352023805160 |
spc9 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 9.64.14.6 |
wt10 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 372036805340 |
spc10 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 9.69.84.1 |
wt11 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 316035402700 |
spc11 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 9.69.89.7 |
wt12 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 372038202840 |
spc12 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 9.89.69.9 |
wt13 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 236039603400 |
spc13 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 9.89.69.7 |
wt14 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 424036602300 |
spc14 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 9.89.79.6 |
wt15 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 296031202900 |
spc15 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 4.29.84.3 |
wt16 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 296013401560 |
spc16 | coordinate | The spacing between the axles to the nearest tenth of a meter (100 millimeters) without a decimal point. | 100% | 4.34.24.8 |
wt17 | text | Weight of axel to the nearest pound without a decimal point. | 100% | 248019202100 |
dirtravel | coordinate | The direction the vehicle is traveling toward on the highway. Please use the Direction column data. | 100% | 8.89.38.3 |
yearmonth | integer | The year and month of the data in YYYYMM format | 0% | 202001201912201911 |