From a 220-row sample across 12 columns.
to_streetboroughshape_stle+3the_geomsegmentidthe_geomto_streeton_streetHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| the_geom | objectid | borough | school_nam | on_street | from_stree | to_street | open_date | nhoodname | segmentid | shape_leng | shape_stle |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiLineString","coordinates":[[[-74.24315579878855,40.50835169318708],[-74.24370904323824,40.50823156741367]]]} | 1 | Staten Island | Totten Intermediate School | ACADEMY AVENUE | Yetman Ave | Dead End | 2020-09-19T00:00:00.000 | Tottenville | 0000268 | 0.03029335 | 159.948998941 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | — | — | — |
objectid | integer | — | 0% | 11733204 |
borough | categorical | The borough where the Outdoor Learning – Streets location is located | 0% | ManhattanBrooklynQueensof 5 |
school_nam | text | The name(s) of the school(s) utilizing the Outdoor Learning – Streets location | 0% | Success Academy Bronx Mi…East Elmhurst Community …Sunset Park Avenues Elem… |
on_street |
GET /api/datasets/vtjm-ngnu GET /api/datasets/vtjm-ngnu/quality GET /api/datasets/vtjm-ngnu/related GET /api/columns?dataset=vtjm-ngnu
shape_stlethe_geomshape_lengthe_geomto_streetboroughon_street| {"type":"MultiLineString","coordinates":[[[-74.14371773257703,40.631423994475966],[-74.14499977048843,40.631659599967385]]]} | 2 | Staten Island | Public School 21 | HOOKER PLACE | Trantor Pl | Dead End | 2020-09-19T00:00:00.000 | Port Richmond | 0008960 | 0.06932882 | 366.055965976 |
| {"type":"MultiLineString","coordinates":[[[-74.03871679502488,40.62621587865749],[-74.03607094771861,40.62559885645036]]]} | 3 | Brooklyn | Fort Hamilton High School | 85 STREET | Narrows Ave | Colonial Rd | 2020-09-19T00:00:00.000 | Bay Ridge | 0016648 | 0.14547164 | 768.0902451 |
| {"type":"MultiLineString","coordinates":[[[-74.03225639076072,40.62774027359398],[-74.03255474521677,40.62701006604336]]]} | 4 | Brooklyn | Bay Ridge Preparatory Schiil | RIDGE BOULEVARD | 82 St | 81 St | 2020-09-19T00:00:00.000 | Bay Ridge | 0016945 | 0.05277022 | 278.626914682 |
| {"type":"MultiLineString","coordinates":[[[-74.02509053624937,40.637794557347895],[-74.02262558588863,40.636799031924426]]]} | 5 | Brooklyn | 20K485 | 67 STREET | 3rd Ave | 4th Ave | 2020-09-19T00:00:00.000 | Bay Ridge | 0017646 | 0.14665228 | 774.324087939 |
| {"type":"MultiLineString","coordinates":[[[-74.01556251928179,40.64006662020976],[-74.01335654243415,40.63873529174328]]]} | 6 | Brooklyn | Our Lady of Perpetual Help Catholic Academy of Brooklyn | 59 STREET | 5th Ave | 6th Ave | 2020-09-19T00:00:00.000 | Sunset Park | 0017872 | 0.14793227 | 781.08243948 |
| {"type":"MultiLineString","coordinates":[[[-74.00853689402429,40.63302814447882],[-74.00702287780435,40.63210997842901]]]} | 7 | Brooklyn | The School for Future Leaders | 62 STREET | 9th Ave | Ft Hamilton Pkwy | 2020-09-19T00:00:00.000 | Dyker Heights | 0019578 | 0.10172655 | 537.11619532 |
| {"type":"MultiLineString","coordinates":[[[-74.01415208593413,40.67816166942847],[-74.01565534675609,40.67918719584737]]]} | 8 | Brooklyn | South Brooklyn Community HS | WOLCOTT STREET | Conover St | Ferris St | 2020-09-19T00:00:00.000 | Red Hook | 0021570 | 0.10603582 | 559.86878116 |
| {"type":"MultiLineString","coordinates":[[[-74.01079317867897,40.676834350800604],[-74.01230389544396,40.67786295609778]]]} | 9 | Brooklyn | Patrick F. Daly Magnet School of the Arts | SULLIVAN STREET | Van Brunt | Richards St | 2020-09-19T00:00:00.000 | Red Hook | 0021629 | 0.1064704 | 562.163965447 |
| {"type":"MultiLineString","coordinates":[[[-74.00234460289104,40.67896099218196],[-74.0019473770387,40.678846527092674]]]} | 10 | Brooklyn | The Brooklyn New School and PS 146 | COLES STREET | Henry St | Pedestrian Overpass | 2020-09-19T00:00:00.000 | Carroll Gardens | 0021925 | 0.02231179 | 117.806274807 |
| text |
| Name of the street used for Outdoor Learning – Streets activities |
| 0% |
97 STREETDAWSON STREET41 STREET |
from_stree | text | The closest cross street to one end of the Outdoor Learning – Streets location | 0% | 3rd AvePark AveMadison Ave |
to_street | text | The closest cross street to the other end of the Outdoor Learning – Streets location | 0% | Park Ave4th AveColumbus Ave |
open_date | datetime | The date the Outdoor Learning – Streets location began | 25% | 2020-09-19T00:00:00.0002020-09-28T00:00:00.0002020-11-25T00:00:00.000of 4 |
nhoodname | text | The name of the neighborhood where the Outdoor Learning - Street is located. | 0% | Upper East SideUpper West SideHarlem |
segmentid | text | SegmentID | 0% | 016607400834050175299 |
shape_leng | float | — | 0% | 0.081456220.008973830.19352913 |
shape_stle | float | — | 0% | 562.163965447476.758662585393.094425407 |