From a 391-row sample across 29 columns.
Has borough codes (`boroughname`) — joinable, but needs boundary shapes to draw.
| object_id | orgname | appronstre | boroughname | apprfromst | apprtostre | apprdayswe | reviewstat | apprmonope | apprmonclo | apprtueope | apprtueclo |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PS 5 | DEISIUS STREET | Staten Island | KINGDOM AVENUE | STECHER STREET | mon,tue,wed,thu,fri | approvedFullSchools | 07:30 | 15:00 | 07:30 | 15:00 |
| 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
object_id | integer | A sequential count of records in the dataset. | 0% | 33204124 |
orgname | text | The name of the organization hosting the open streets program. | 0% | 34th Avenue Open Streets…Merchants of third Avenu…North Brooklyn Open Stre… |
appronstre | text | Name of the street that the application was approved for. | 0% | 34 AVENUE3 AVENUEBERRY STREET |
boroughname | categorical | Full name of the borough the open streets is located in. "Manhattan, Bronx, Brooklyn, Queens, Staten Island" | 0% |
GET /api/datasets/uiay-nctu GET /api/datasets/uiay-nctu/quality GET /api/datasets/uiay-nctu/related GET /api/columns?dataset=uiay-nctu
| Council of Jewish Organizations of Staten Island, a project of the Igud Harabonim of America Inc |
| SUFFOLK AVENUE |
| Staten Island |
| HAROLD STREET |
| QUEEN STREET |
| fri,sat,sun |
| approvedFull |
| — |
| — |
| — |
| — |
| 3 | Council of Jewish Organizations of Staten Island, a project of the Igud Harabonim of America Inc | SUFFOLK AVENUE | Staten Island | HAROLD STREET | QUEEN STREET | fri,sat,sun | approvedFull | — | — | — | — |
| 4 | Council of Jewish Organizations of Staten Island, a project of the Igud Harabonim of America Inc | VERMONT COURT | Staten Island | GANSEVOORT BOULEVARD | SUFFOLK AVENUE | fri,sat,sun | approvedFull | — | — | — | — |
| 5 | New Dorp Lane Management Association | 9 STREET | Staten Island | ROSE AVENUE | NEW DORP LANE | fri,sat,sun | approvedFull | — | — | — | — |
| 6 | Merchants of third Avenue Civic improvement assoc, inc | 3 AVENUE | Brooklyn | 82 STREET | MARINE AVENUE | fri | approvedFull | — | — | — | — |
| 7 | Merchants of third Avenue Civic improvement assoc, inc | 3 AVENUE | Brooklyn | 82 STREET | MARINE AVENUE | fri | approvedFull | — | — | — | — |
| 8 | Merchants of third Avenue Civic improvement assoc, inc | 3 AVENUE | Brooklyn | 82 STREET | MARINE AVENUE | fri | approvedFull | — | — | — | — |
| 9 | Merchants of third Avenue Civic improvement assoc, inc | 3 AVENUE | Brooklyn | 82 STREET | MARINE AVENUE | fri | approvedFull | — | — | — | — |
| 10 | Merchants of third Avenue Civic improvement assoc, inc | 3 AVENUE | Brooklyn | 82 STREET | MARINE AVENUE | fri | approvedFull | — | — | — | — |
Showing 12 of 29 columns. All of them are listed below.
BrooklynManhattanQueensof 5 |
apprfromst | text | Cross-Street that the open streets application starts at | 0% | 69 STREETBROADWAY82 STREET |
apprtostre | text | Cross-Street that the open streets application ends at | 0% | JUNCTION BOULEVARDMARINE AVENUENORTH 12 STREET |
apprdayswe | text | Days of the week the streets are open to pedestrians and cyclists. "mon, tue,wed, thurs, fri, sat, sun" | 0% | mon,tue,wed,thu,fri,sat,…mon,tue,wed,thu,frisun |
reviewstat | categorical | A description of the street closure. | 0% | approvedFullapprovedLimitedapprovedFullSchoolsof 3 |
apprmonope | text | The approved start time of the open streets program. | 50% | 07:0008:0007:30 |
apprmonclo | text | The approved end time of the open streets program. | 50% | 20:0015:0016:30 |
apprtueope | text | The approved start time of the open streets program. | 50% | 07:0008:0007:30 |
apprtueclo | text | The approved end time of the open streets program. | 50% | 20:0015:0017:00 |
apprwedope | text | The approved start time of the open streets program. | 47% | 07:0008:0007:30 |
apprwedclo | text | The approved end time of the open streets program. | 47% | 20:0015:0017:00 |
apprthuope | text | The approved start time of the open streets program. | 45% | 07:0008:0010:00 |
apprthuclo | text | The approved end time of the open streets program. | 45% | 20:0015:0022:00 |
apprfriope | text | The approved start time of the open streets program. | 27% | 07:0008:0016:00 |
apprfriclo | text | The approved end time of the open streets program. | 27% | 20:0022:0023:00 |
apprsatope | categorical | The approved start time of the open streets program. | 48% | 07:0008:0012:00of 15 |
apprsatclo | categorical | The approved end time of the open streets program. | 48% | 20:0022:0023:00of 16 |
apprsunope | categorical | The approved start time of the open streets program. | 43% | 07:0008:0012:00of 15 |
apprsunclo | categorical | The approved end time of the open streets program. | 43% | 20:0021:0018:00of 11 |
apprstartd | datetime | Days of the week the streets are open to pedestrians and cyclists. | 0% | 2024-02-01T00:00:00.0002024-09-05T00:00:00.0002024-07-19T00:00:00.000 |
apprenddat | datetime | Last Day that Open Street permit is active | 0% | 2024-12-31T00:00:00.0002025-06-27T00:00:00.0002024-08-02T00:00:00.000 |
shape_stle | coordinate | The length of the block segment in feet; Auto-generated by ESRI | 0% | 255.981373559260.862342999284.788746049 |
segmentidt | text | The segment unique identifier for apprstreetto based on the LION dataset. | 0% | 007645700345020037091 |
segmentidf | text | The segment unique identifier for apprstreetfrom based on the LION dataset. | 0% | 007645700345020037091 |
lionversion | text | The data version for Department of City Planning LION, versions are based on year/quarter. | 0% | 23Cof 1 |
the_geom | unknown | — | — | — |