From a 500-row sample across 10 columns.
objectiddistrictobjectiddistrictobjectiddistrictobjectidHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| borough | district | physicalid | roadwaytype | segmentlength | shape__length | snowpriority | streetname | line | objectid |
|---|---|---|---|---|---|---|---|---|---|
| 10 | QW04 | 13281 | 1 | 357.38846361 | 357.388463615209 | V | MERIDIAN RD | NaN, NaN | 11567 |
| 10 | QW04 | 13279 | 1 | 81.4901061 | 81.490106109176 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | New York City’s boroughs are five county-level administrative divisions, with each one also being a state county. 1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island. | 0% | 1125of 7 |
district | text | District abbreviation as defined by DSNY. | 0% | QE13SI03SI01 |
physicalid | integer | Unique ID for each street segment that comes from CSCL (Citywide Street Center Line). | 0% | 4849816544365792 |
roadwaytype | categorical | Type of roadway. 1=Street; 2=Highway; 3=Bridge; 4=Tunnel; 5=Boardwalk; 6=Path/Trail; 7=Step Street; 8=Driveway; 9=Ramp; 10=Alley; 11=Unknown; 12=Non-physical street segment; 13=U-turn; 14=Ferry route | 0% |
GET /api/datasets/sh4i-rsb8 GET /api/datasets/sh4i-rsb8/quality GET /api/datasets/sh4i-rsb8/related GET /api/columns?dataset=sh4i-rsb8
objectiddistrictborough| C |
| MERIDIAN RD |
| NaN, NaN |
| 11566 |
| 11 | QE07 | 13277 | 1 | 338.46822208 | 338.468222084926 | C | MERIDIAN RD | NaN, NaN | 11565 |
| 10 | QW02 | 13274 | 1 | 311.73479747 | 311.734797469271 | S | LAUREL HILL BLVD | NaN, NaN | 11564 |
| 10 | QW02 | 13273 | 1 | 244.75873802 | 244.75873803252 | S | 47 ST | NaN, NaN | 11563 |
| 10 | QW02 | 13271 | 1 | 614.9830775 | 614.98307750248 | S | 47 ST | NaN, NaN | 11562 |
| 10 | QW02 | 13270 | 1 | 578.84613036 | 578.846130356523 | C | 47 ST | NaN, NaN | 11561 |
| 10 | QW02 | 13269 | 1 | 63.6366616 | 63.6366615919178 | C | 47 ST | NaN, NaN | 11560 |
| 10 | QW02 | 13268 | 1 | 56.61476365 | 56.6147636560448 | C | 47 ST | NaN, NaN | 11559 |
| 10 | QW02 | 13267 | 1 | 141.32849177 | 141.328491772926 | C | 47 ST | NaN, NaN | 11558 |
129of 9 |
segmentlength | float | Length in feet of the geographic segment. | 0% | 82.11149186446.52963188794.77866565 |
shape__length | float | Length in feet of the geographic feature. | 0% | 96.9223899387447149.543622692165149.052809187719 |
snowpriority | categorical | Snow priority designation: Critical Routes C, Sector Routes S, Haulster Routes H, Non-DSNY V. | 0% | CSHof 4 |
streetname | text | Street name which comes from CSCL. | 0% | BROADWAYCONNECTORLINDEN BLVD |
line | unknown | — | — | — |
objectid | integer | Unique ID for each record that is autogenerated. | 0% | 4849810579665792 |