From a 500-row sample across 53 columns.
l_low_hnbike_laner_high_hn+15post_typepre_typethe_geom+11statusstreet_nameHas borough codes (`boroughcode`) — joinable, but needs boundary shapes to draw.
| the_geom | physicalid | l_low_hn | l_high_hn | r_low_hn | r_high_hn | l_zip | r_zip | status | trafdir | rw_type | pre_type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiLineString","coordinates":[[[-73.965287415722,40.615000858808],[-73.964359884699,40.615102135719]]]} | 46810 | 901 | 999 | 900 | 998 | 11230 | 11230 | 2 | FT | 1 | AVE |
| {"type":"MultiLineString","coordinates":[[[-73.857805049963,40.863044490364],[-73.857734247232,40.865485912644]]]} |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | — | — | — |
physicalid | integer | — | 0% | 206286192746105787 |
l_low_hn | text | — | 31% | 012 |
l_high_hn | text | — | 31% | 099199 |
r_low_hn | text | — | 31% | 02 |
GET /api/datasets/inkn-q76z GET /api/datasets/inkn-q76z/quality GET /api/datasets/inkn-q76z/related GET /api/columns?dataset=inkn-q76z
street_namethe_geomobjectidshape_length| 86757 |
| 2501 |
| 2599 |
| 2500 |
| 2598 |
| 10469 |
| 10469 |
| 2 |
| TW |
| 1 |
| — |
| {"type":"MultiLineString","coordinates":[[[-73.901047993134,40.769320483382],[-73.902742096389,40.767935194633]]]} | 84282 | 22-001 | 22-099 | 22-000 | 22-098 | 11105 | 11105 | 2 | TF | 1 | — |
| {"type":"MultiLineString","coordinates":[[[-74.010562603546,40.7222098984],[-74.011631470957,40.72231827029]]]} | 79741 | 79 | 107 | 78 | 100 | 10013 | 10013 | 2 | FT | 1 | — |
| NaN, NaN | 184200 | 0 | 0 | 74 | 86 | 10306 | 10306 | 2 | TW | 1 | — |
| NaN, NaN | 170796 | — | — | — | — | 10458 | 10458 | 2 | NV | 6 | — |
| {"type":"MultiLineString","coordinates":[[[-73.847747786294,40.841891419062],[-73.847927934989,40.841746892882],[-73.847980520427,40.841726845082]]]} | 108922 | — | — | — | — | 10461 | 10461 | 2 | TW | 10 | — |
| {"type":"MultiLineString","coordinates":[[[-73.745632289534,40.703875995602],[-73.745025168896,40.70252654448]]]} | 31380 | 113-001 | 113-099 | 113-000 | 113-098 | 11429 | 11429 | 2 | TW | 1 | — |
| {"type":"MultiLineString","coordinates":[[[-73.807299636673,40.742002029035],[-73.806356512929,40.742058970803]]]} | 10217 | 161-001 | 161-099 | 161-000 | 161-098 | 11365 | 11365 | 2 | TW | 1 | — |
| {"type":"MultiLineString","coordinates":[[[-73.754133474341,40.608115396585],[-73.755165930404,40.608317264715]]]} | 16336 | 22-001 | 22-025 | 22-000 | 22-026 | 11691 | 11691 | 2 | TW | 1 | — |
Showing 12 of 39 columns. All of them are listed below.
1r_high_hn | text | — | 31% | 09899 |
l_zip | text | — | 1% | 103141031210306 |
r_zip | text | — | 1% | 103141031210306 |
status | categorical | — | 0% | 254of 3 |
bike_lane | categorical | — | 86% | 213of 10 |
trafdir | categorical | — | 0% | TWFTTFof 4 |
rw_type | categorical | — | 0% | 162of 13 |
pre_type | categorical | — | 98% | AVEBCHPATHof 7 |
post_type | text | — | 11% | AVESTRD |
objectid | integer | — | 0% | 4849810579665792 |
fcc | text | — | 100% | 10of 1 |
l_blockfaceid | integer | — | 10% | 0822604061322600033 |
r_blockfaceid | integer | — | 10% | 02226104882260409 |
avgtravtime | numeric | — | 100% | — |
rwjurisdiction | categorical | — | 96% | 35of 2 |
nominaldir | text | — | 100% | — |
accessible | categorical | — | 100% | 234of 4 |
nonped | categorical | — | 88% | VDof 2 |
boroughcode | categorical | — | 0% | 432of 5 |
borough_indicator | categorical | — | 100% | 21of 2 |
seglocstatus | categorical | — | 76% | XHIof 5 |
sandist_ind | categorical | — | 99% | 21of 2 |
lsubsect | text | — | 14% | 1C2C1B |
rsubsect | text | — | 14% | 1C2C1B |
continuous_parity_flag | categorical | — | 99% | 21of 2 |
twisted_parity_flag | categorical | — | 0% | NYof 2 |
posted_speed | categorical | — | 18% | 253050of 8 |
segmentlength | float | — | 2% | 350.6634408778.18711981253.76569674 |
streetwidth | integer | — | 7% | 304034 |
streetwidth_irr | text | — | 100% | — |
special_disaster | text | — | 100% | — |
fire_lane | text | — | 100% | — |
created_date | datetime | — | 0% | 2007-11-29T00:00:00.000Z2009-06-16T00:00:00.000Z2017-10-12T11:38:17.000Z |
modified_date | datetime | — | 0% | 2020-08-28T20:49:50.000Z2024-04-10T13:15:28.000Z2025-10-14T12:37:33.000Z |
within_bndy_dist | categorical | — | 99% | 43of 2 |
truck_route_type | categorical | — | 81% | 231of 3 |
collectionmethod | text | — | 89% | Fof 1 |
from_level_code | categorical | — | 0% | 13179of 19 |
to_level_code | categorical | — | 0% | 13179of 19 |
b5sc | text | — | 0% | 413170312025213770 |
snow_priority | categorical | — | 7% | CSVof 4 |
joinid | text | — | 100% | — |
bphys_id | numeric | — | 100% | — |
carto_display_level | categorical | — | 90% | 102030of 3 |
number_travel_lanes | categorical | — | 7% | 214of 10 |
number_park_lanes | categorical | — | 7% | 201of 4 |
number_total_lanes | categorical | — | 7% | 432of 10 |
pre_modifier | categorical | — | 100% | OLDLITTLEof 2 |
pre_directional | categorical | — | 92% | EWNof 4 |
post_directional | categorical | — | 99% | SWEof 5 |
post_modifier | text | — | 100% | BRIDGEBOULEVARDEXTENSION |
full_street_name | text | — | 0% | ALLEYBROADWAYCONNECTOR |
bike_trafdir | categorical | — | 86% | TWFTTFof 3 |
shape_length | float | — | 0% | 61.69517688174828298.264181606943993153.90559569420276 |
globalid | text | — | 0% | 5b659666-ded9-427d-9c0d-…c732cdfa-ba69-416c-aa06-…cf75a4b1-6ebf-4a10-86e5-… |
segment_type | text | — | 100% | — |
segment_type_value | text | — | 100% | — |
street_name | text | — | 0% | ALLEYBROADWAY3 |
stname_label | text | — | 0% | ALLEYBROADWAYCONNECTOR |