From a 500-row sample across 31 columns.
directionsegmentidsegmentid| id | segmentid | roadway_name | from | to | direction | date | _12_00_1_00_am | _1_00_2_00am | _2_00_3_00am | _3_00_4_00am | _4_00_5_00am |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 15540 | BEACH STREET | UNION PLACE | VAN DUZER STREET | NB | 2012-01-09T00:00:00.000 | 20 | 10 | 11 | 14 | 13 |
| 2 | 15540 | BEACH STREET |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
id | text | Count ID | 0% | 18615302 |
segmentid | integer | LION Segment ID. Called "GIS ID' in the 2011-12 dataset, "Segment ID" in the 2012-13 dataset. | 0% | 720267742476510 |
roadway_name | text | Street name | 0% | BROADWAYBroadway3 AVENUE |
from | text | Intersecting street name at one end of street | 0% | Dead EndGrand ConcourseNorthern Boulevard |
to |
GET /api/datasets/btm5-ppia GET /api/datasets/btm5-ppia/quality GET /api/datasets/btm5-ppia/related GET /api/columns?dataset=btm5-ppia
id| UNION PLACE |
| VAN DUZER STREET |
| NB |
| 2012-01-10T00:00:00.000 |
| 21 |
| 16 |
| 8 |
| 6 |
| 13 |
| 3 | 15540 | BEACH STREET | UNION PLACE | VAN DUZER STREET | NB | 2012-01-11T00:00:00.000 | 27 | 14 | 6 | 5 | 12 |
| 4 | 15540 | BEACH STREET | UNION PLACE | VAN DUZER STREET | NB | 2012-01-12T00:00:00.000 | 22 | 7 | 7 | 8 | 11 |
| 5 | 15540 | BEACH STREET | UNION PLACE | VAN DUZER STREET | NB | 2012-01-13T00:00:00.000 | 31 | 17 | 7 | 5 | 13 |
| 6 | 15540 | BEACH STREET | UNION PLACE | VAN DUZER STREET | NB | 2012-01-14T00:00:00.000 | 42 | 27 | 21 | 18 | 21 |
| 7 | 15540 | BEACH STREET | UNION PLACE | VAN DUZER STREET | SB | 2012-01-09T00:00:00.000 | 27 | 12 | 12 | 4 | 22 |
| 8 | 15540 | BEACH STREET | UNION PLACE | VAN DUZER STREET | SB | 2012-01-10T00:00:00.000 | 26 | 16 | 11 | 13 | 16 |
| 9 | 15540 | BEACH STREET | UNION PLACE | VAN DUZER STREET | SB | 2012-01-11T00:00:00.000 | 32 | 16 | 8 | 9 | 15 |
| 10 | 15540 | BEACH STREET | UNION PLACE | VAN DUZER STREET | SB | 2012-01-12T00:00:00.000 | 24 | 12 | 7 | 18 | 11 |
Showing 12 of 31 columns. All of them are listed below.
| text |
| Intersecting street name at other end of street |
| 0% |
Dead EndDead endGlenwood Road |
direction | categorical | Compass direction | 0% | NBSBEBof 14 |
date | datetime | Date of the traffic count | 0% | 2019-10-12T00:00:00.0002019-10-13T00:00:00.0002020-11-14T00:00:00.000 |
_12_00_1_00_am | integer | Count for the clock hour | 0% | 436753 |
_1_00_2_00am | integer | Count for the clock hour | 0% | 204225 |
_2_00_3_00am | integer | Count for the clock hour | 0% | 222420 |
_3_00_4_00am | integer | Count for the clock hour | 0% | 211822 |
_4_00_5_00am | integer | Count for the clock hour | 0% | 292621 |
_5_00_6_00am | integer | Count for the clock hour | 0% | 333930 |
_6_00_7_00am | integer | Count for the clock hour | 0% | 466774 |
_7_00_8_00am | integer | Count for the clock hour | 0% | 010496 |
_8_00_9_00am | integer | Count for the clock hour | 0% | 0140161 |
_9_00_10_00am | integer | Count for the clock hour | 0% | 0218186 |
_10_00_11_00am | integer | Count for the clock hour | 0% | 0197213 |
_11_00_12_00pm | integer | Count for the clock hour | 0% | 0238275 |
_12_00_1_00pm | integer | Count for the clock hour | 1% | 0233234 |
_1_00_2_00pm | integer | Count for the clock hour | 1% | 0274239 |
_2_00_3_00pm | integer | Count for the clock hour | 1% | 0294316 |
_3_00_4_00pm | integer | Count for the clock hour | 1% | 0267303 |
_4_00_5_00pm | integer | Count for the clock hour | 1% | 0251329 |
_5_00_6_00pm | integer | Count for the clock hour | 1% | 0347295 |
_6_00_7_00pm | integer | Count for the clock hour | 1% | 0287251 |
_7_00_8_00pm | integer | Count for the clock hour | 1% | 0182214 |
_8_00_9_00pm | integer | Count for the clock hour | 1% | 0215159 |
_9_00_10_00pm | integer | Count for the clock hour | 1% | 0119132 |
_10_00_11_00pm | integer | Count for the clock hour | 1% | 0128130 |
_11_00_12_00am | integer | Count for the clock hour | 1% | 086103 |