From a 500-row sample across 10 columns.
n_samplespolylinemedian_calculation_timestamp+7boroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| sid | link_name | borough | polyline | link_length_ft | aggregation_period_sec | n_samples | median_calculation_timestamp | median_tt_sec | median_speed_fps |
|---|---|---|---|---|---|---|---|---|---|
| 1004 | 42nd Street - Eastbound - Lexington Ave to 3rd Ave | Manhattan | agvwFxmobMfCeI | 514.26 | 900 | 4 | 2024-07-08T04:01:16.000 | 16.5 | 31.17 |
| 1004 | 42nd Street - Eastbound - Lexington Ave to 3rd Ave | Manhattan | agvwFxmobMfCeI |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
sid | integer | the unique id assigned to the street block(s) and/or segment. | 0% | 13016300215018 |
link_name | text | The street name/description of the segment. | 0% | 34th Street - Eastbound …3rd Avenue - Northbound …49th Street - Westbound … |
borough | categorical | The borough where the segment is created | 0% | ManhattanQueensBrooklynof 4 |
polyline | text | Google algorithm encoded polyline for the street block(s) and/or segment. | 0% |
GET /api/datasets/6a2s-2t65 GET /api/datasets/6a2s-2t65/quality GET /api/datasets/6a2s-2t65/related GET /api/columns?dataset=6a2s-2t65
| 514.26 |
| 900 |
| 5 |
| 2024-07-08T11:53:16.000 |
| 63.0 |
| 8.16 |
| 1004 | 42nd Street - Eastbound - Lexington Ave to 3rd Ave | Manhattan | agvwFxmobMfCeI | 514.26 | 900 | 6 | 2024-07-08T01:22:20.000 | 26.5 | 19.41 |
| 1004 | 42nd Street - Eastbound - Lexington Ave to 3rd Ave | Manhattan | agvwFxmobMfCeI | 514.26 | 900 | 12 | 2024-07-08T19:37:16.000 | 158.0 | 3.25 |
| 1004 | 42nd Street - Eastbound - Lexington Ave to 3rd Ave | Manhattan | agvwFxmobMfCeI | 514.26 | 900 | 13 | 2024-07-08T17:25:16.000 | 218.0 | 2.36 |
| 1004 | 42nd Street - Eastbound - Lexington Ave to 3rd Ave | Manhattan | agvwFxmobMfCeI | 514.26 | 900 | 14 | 2024-07-08T14:17:16.000 | 354.0 | 1.45 |
| 1004 | 42nd Street - Eastbound - Lexington Ave to 3rd Ave | Manhattan | agvwFxmobMfCeI | 514.26 | 900 | 17 | 2024-07-08T09:55:16.000 | 26.0 | 19.78 |
| 1004 | 42nd Street - Eastbound - Lexington Ave to 3rd Ave | Manhattan | agvwFxmobMfCeI | 514.26 | 900 | 17 | 2024-07-08T18:06:20.000 | 79.0 | 6.51 |
| 1011 | 42nd Street - Westbound - Lexington Ave to Madison Ave | Manhattan | _hvwF|lobMmGhS | 1024.34 | 0 | 0 | 2024-07-08T05:36:20.000 | 0.0 | 0.0 |
| 1011 | 42nd Street - Westbound - Lexington Ave to Madison Ave | Manhattan | _hvwF|lobMmGhS | 1024.34 | 0 | 0 | 2024-07-08T06:28:20.000 | 0.0 | 0.0 |
ukwwFfmobMk^{UaoxwFr`obMtAkEp@uBicvwFhcobMgCyAoVgPlink_length_ft | float | Google algorithm encoded polyline for the street block(s) and/or segment. | 0% | 711.89910.152092.07 |
aggregation_period_sec | categorical | The number of seconds used to aggregate records to compute the median travel time | 0% | 9000of 2 |
n_samples | integer | The number of samples in the aggregation period used to calculate the median travel time | 0% | 024 |
median_calculation_timestamp | datetime | The calculated median of the segment over the aggregation period | 0% | 2024-11-03T01:59:38.0002024-07-08T00:03:16.0002024-07-08T09:58:20.000 |
median_tt_sec | integer | The calculated median speed, in feet-per-second, for the segment from the “link_length_ft” divided by the “median_tt_sec” fields | 0% | 0.064.065.0 |
median_speed_fps | float | — | 0% | 0.027.1824.46 |