From a 500-row sample across 42 columns.
boroughboroughcboftHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| projectcode | groupowner | locationdescription | borough | projectstatus | dateadded | bctsnum | closeddate | speedcushion | requestdate | segmentid | onstreet |
|---|---|---|---|---|---|---|---|---|---|---|---|
| SR-20260625-41730 | Brooklyn BC | HURON STREET from MANHATTAN AVENUE to FRANKLIN STREET | Brooklyn | Accept planning proposal of Not Feasible, Closed | 2026-06-25T14:50:41.000 | DOT-754257-B4K8 | 2026-07-07T11:14:00.000 | No | 2026-06-23T00:00:00.000 | 35027 | HURON STREET |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
projectcode | text | — | 0% | SR-20160824-12197SR-20260903-42149SR-20100708-4681 |
groupowner | categorical | — | 0% | Queens BCBrooklyn BCSI BCof 6 |
locationdescription | text | — | 0% | SHORE PARKWAY from KNAPP…CROSS ISLAND PARKWAY fro…HORACE HARDING EXPRESSWA… |
borough | categorical | — | 0% | Queens |
GET /api/datasets/9n6h-pt9g GET /api/datasets/9n6h-pt9g/quality GET /api/datasets/9n6h-pt9g/related GET /api/columns?dataset=9n6h-pt9g
borough| SR-20240212-31334 | SI BC | RICHMOND TERRACE from BARD AVENUE to SNUG HARBOR ROAD | Staten Island | Planning denied Pre-inspection, Closed | 2024-02-12T11:25:21.000 | DOT-635885-P4C9 | 2024-06-20T12:11:00.000 | Yes | 2024-02-12T00:00:00.000 | 13759 | RICHMOND TERRACE |
| SR-20240212-31334 | SI BC | RICHMOND TERRACE from BARD AVENUE to SNUG HARBOR ROAD | Staten Island | Planning denied Pre-inspection, Closed | 2024-02-12T11:25:21.000 | DOT-635885-P4C9 | 2024-06-20T12:11:00.000 | Yes | 2024-02-12T00:00:00.000 | 9008983 | RICHMOND TERRACE |
| SR-20231130-31085 | Queens BC | 87 AVENUE from QUEENS BOULEVARD to 148 STREET | Queens | Accept planning proposal of Not Feasible, Closed | 2023-11-30T11:18:55.000 | DOT-500500-H4R5 | 2024-06-21T11:01:00.000 | No | 2021-04-27T00:00:00.000 | 56907 | 87 AVENUE |
| SR-20231115-30998 | Brooklyn BC | BENSON AVENUE from BAY 43 STREET to BAY 37 STREET | Brooklyn | Accept planning proposal of Not Feasible, Closed | 2023-11-15T13:31:49.000 | DOT-624580-H5B9 | 2024-06-21T10:56:00.000 | No | 2023-11-11T00:00:00.000 | 18896 | BENSON AVENUE |
| SR-20231122-31054 | Queens BC | SPRINGFIELD BOULEVARD from 53 AVENUE to 56 AVENUE | Queens | Accept planning proposal of Not Feasible, Closed | 2023-11-22T12:17:12.000 | DOT-624843-N4M3 | 2024-06-21T10:58:00.000 | No | 2023-11-14T00:00:00.000 | 101083 | SPRINGFIELD BOULEVARD |
| SR-20230927-30657 | Queens BC | 140 STREET from 135 AVENUE to 142 STREET | Queens | Accept planning proposal of Not Feasible, Closed | 2023-09-27T14:37:27.000 | DOT-613090-G0F8 | 2024-06-21T10:44:00.000 | No | 2023-08-30T00:00:00.000 | 58630 | 140 STREET |
| SR-20250131-35734 | Queens BC | 107 STREET from ATLANTIC AVENUE to JAMAICA AVENUE | Queens | Accept planning proposal of Not Feasible, Closed | 2025-01-31T11:23:44.000 | DOT-682760-Q0G4 | 2025-02-20T13:28:00.000 | No | 2025-01-30T00:00:00.000 | 169523 | 107 STREET |
| SR-20250127-35723 | Queens BC | 134 ROAD from 219 STREET to 220 STREET | Queens | Accept planning proposal of Not Feasible, Closed | 2025-01-27T11:20:13.000 | DOT-682238-B9P9 | 2025-02-20T13:26:00.000 | No | 2025-01-26T00:00:00.000 | 63321 | 134 ROAD |
| SR-20230606-29865 | SI BC | CROWN AVENUE from ROW PLACE to EVAN PLACE | Staten Island | Accept planning proposal of Not Feasible, Closed | 2023-06-06T15:17:15.000 | DOT-599332-L9N9 | 2024-06-21T10:40:00.000 | No | 2023-06-06T00:00:00.000 | 4026 | CROWN AVENUE |
Showing 12 of 27 columns. All of them are listed below.
BrooklynStaten Islandprojectstatus | text | — | 0% | Accept planning proposal…Study Completed, ClosedReject planning proposal… |
nextstep | categorical | — | 93% | Awaiting Pre-installatio…2nd inspection requestedAwaiting final markings …of 13 |
dateadded | datetime | — | 0% | 2005-11-01T00:00:00.0002016-08-24T11:14:38.0002026-09-03T14:03:02.000 |
bctsnum | text | — | 14% | BBC13-1033DOT-307591-W7Y7DOT-650484-C8J9 |
ccunum | text | — | 88% | 10-520711-12371DOT-267775-S1Z8 |
requestorletterreplydate | datetime | — | 36% | 2022-10-06T00:00:00.0002022-11-16T00:00:00.0002015-05-05T00:00:00.000 |
cbletterrequestdate | datetime | — | 78% | 2015-12-12T00:00:00.0002023-06-02T00:00:00.0002019-03-26T00:00:00.000 |
cbletterrecieveddate | datetime | — | 78% | 2015-12-12T00:00:00.0002022-11-30T00:00:00.0002021-03-12T00:00:00.000 |
oldsign | text | — | 98% | 1980-121801458 |
newsign | text | — | 100% | — |
markingsdate | datetime | — | 85% | 2014-09-04T00:00:00.0002015-07-11T00:00:00.0002019-07-16T00:00:00.000 |
installationdate | datetime | — | 84% | 2014-08-28T00:00:00.0002015-07-08T00:00:00.0002019-07-10T00:00:00.000 |
secondstudycode | text | — | 99% | SR-20150127-9683SR-20120521-6491SR-20120514-6479 |
closeddate | datetime | — | 9% | 2016-08-24T11:16:00.0002026-09-03T14:03:00.0002010-07-08T13:02:00.000 |
speedcushion | categorical | — | 0% | NoYesof 2 |
requestdate | datetime | — | 0% | 2013-08-26T00:00:00.0002019-03-12T00:00:00.0002016-08-24T00:00:00.000 |
requestortype | text | — | 42% | CitizenCouncil MemberDOT Internal |
segmentid | text | — | 0% | 2790927879122067 |
onstreet | text | — | 0% | SHORE PARKWAYGRAND CENTRAL PARKWAYCROSS ISLAND PARKWAY |
fromstreet | text | — | 0% | BENDDEAD ENDBROADWAY |
tostreet | text | — | 0% | BENDDEAD ENDBROADWAY |
geoboroughname | categorical | — | 0% | QueensBrooklynStaten Islandof 5 |
lionkey | text | — | 0% | 359840082035984008103598400830 |
fromlatitude | coordinate | — | 0% | 40.71932799999999740.63613300000000140.717368 |
fromlongitude | coordinate | — | 0% | -73.920237999999998-73.972735999999998-73.884097999999994 |
tolatitude | coordinate | — | 0% | 40.71932799999999740.71736840.636133000000001 |
tolongitude | coordinate | — | 0% | -73.920237999999998-73.884097999999994-73.972735999999998 |
oft | text | — | 0% | 377030318950318950447390435780435780410740435780435780 |
cb | text | — | 0% | 413501412 |
segmentstatus | categorical | — | 3% | NoYesof 2 |
segmentstatusdescription | categorical | — | 0% | Not FeasibleFeasibleof 2 |
denialreason | text | — | 41% | Does not qualify; Radar …multiple impeding drivew…street too short |
numsrproposed | categorical | — | 85% | 120of 9 |
trafficdirection | categorical | — | 0% | TAWof 4 |
trafficdirectiondesc | categorical | — | 0% | Two-wayOne-wayPedestrian Pathof 3 |
oldsign1 | text | — | 94% | SIMSN/An/a |
newsign1 | text | — | 93% | NO INSTALLATIONN/ASIMS |
oldsign2 | text | — | 98% | N/ASIMSn/a |
newsign2 | text | — | 97% | N/AB-01549194B-01591984 |