From a 500-row sample across 22 columns.
crossstreet1crossstreet2mainstreet+3statusHas street addresses (`housenumber`) — needs geocoding before it can be drawn.
| requestnumber | divisionname | status | channel | category | requesttype | priority | multiple | requestdetail | requestortypes | datereceived | datecreated |
|---|---|---|---|---|---|---|---|---|---|---|---|
| MBE9576 | Manhattan Borough Engineering | Closed | Letter | PARKING | Other | N | N | School signs | Citizen | 2011-12-13T00:00:00.000 | 2011-12-13T00:00:00.000 |
| MBE9578 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
requestnumber | text | — | 0% | BBE14754BBE14751BBE15139 |
divisionname | categorical | — | 0% | Brooklyn Borough Enginee…Manhattan Borough Engine…Queens Borough Engineeri…of 6 |
status | categorical | — | 0% | ClosedReferredDeletedof 9 |
channel | categorical | — | 0% | LetterEmailARTSof 8 |
GET /api/datasets/4twk-9yq2 GET /api/datasets/4twk-9yq2/quality GET /api/datasets/4twk-9yq2/related GET /api/columns?dataset=4twk-9yq2
| Manhattan Borough Engineering |
| Closed |
| Letter |
| INTERSECTIONS |
| Other |
| N |
| N |
| Remove SW-621/SR-777 |
| DOT Internal |
| 2011-12-13T00:00:00.000 |
| 2011-12-13T00:00:00.000 |
| MBE9580 | Manhattan Borough Engineering | Closed | Letter | PARKING | Other | N | N | Resurvey | DOT Internal | 2011-12-13T00:00:00.000 | 2011-12-13T00:00:00.000 |
| SBE7868 | Staten Island Borough Engineering | Closed | Phone Call | INTERSECTIONS | Other | N | N | Install SR-1837 Delayed Green sign | DOT Internal | 2011-12-13T00:00:00.000 | 2011-12-13T00:00:00.000 |
| BSM2406 | Bus Stop Management | Closed | FAX | SUPPORT LITIGATION | FOIL/Litigation | N | N | REQUESTING SIGN ORDERS & MAINTENANCE& COMPLAINTS RE B/S SIGNS POSTED AT THE INTERSECTION. | DOT Internal | 2011-12-13T00:00:00.000 | 2011-12-13T00:00:00.000 |
| BSM2407 | Bus Stop Management | Closed | Letter | PARKING | Bus Stop | N | N | REQUESTING CLARIFICATION ON PANELS TO IDENTIFY WHICH Q-46 ROUTE IS GOING TO WHICH DESTINATION. | Elected Official | 2011-12-13T00:00:00.000 | 2011-12-13T00:00:00.000 |
| KBE10548 | Brooklyn Borough Engineering | Closed | PARKING | School Regulations | N | N | requesting no parking school days | DOT Internal | 2011-12-13T00:00:00.000 | 2011-12-13T00:00:00.000 |
| KBE10550 | Brooklyn Borough Engineering | Closed | Letter | PARKING | No Parking Zone | N | N | Req (2) No Parking (1) ASP reg and the relocation existing parking reg | Organization/Business | 2011-12-13T00:00:00.000 | 2011-12-13T00:00:00.000 |
| KBE10551 | Brooklyn Borough Engineering | Closed | Letter | PARKING | Hotel Loading Zone | N | N | req hotel loading zone (2) signs | Organization/Business | 2011-12-13T00:00:00.000 | 2011-12-13T00:00:00.000 |
| MBE9540 | Manhattan Borough Engineering | Closed | Letter | PARKING | Other | N | N | Check visibility daylight Intersection as if needed | Police Department | 2011-12-13T00:00:00.000 | 2011-12-13T00:00:00.000 |
Showing 12 of 21 columns. All of them are listed below.
category | categorical | — | 0% | PARKINGINTERSECTIONSSPECIAL STUDIESof 5 |
requesttype | text | — | 0% | OtherNo Parking ZoneNo Standing Zone |
priority | categorical | — | 0% | NYof 2 |
multiple | categorical | — | 0% | NYof 2 |
requestdetail | text | — | 26% | RESURVEYResurveyUPDATE STATUS |
requestortypes | text | — | 0% | DOT Internal Citizen DOT Commissioner |
datereceived | datetime | — | 0% | 2022-12-08T00:00:00.0002022-03-15T00:00:00.0002006-03-14T00:00:00.000 |
datecreated | datetime | — | 0% | 2003-07-28T00:00:00.0002006-03-14T00:00:00.0002003-10-30T00:00:00.000 |
duedate | datetime | — | 32% | 2022-06-30T00:00:00.0002018-11-30T00:00:00.0002018-08-31T00:00:00.000 |
dateclosed | datetime | — | 1% | 2003-12-31T00:00:00.0002002-12-31T00:00:00.0002023-07-11T00:00:00.000 |
dateassigned | datetime | — | 58% | 2003-07-28T00:00:00.0002003-05-27T00:00:00.0002022-03-15T10:30:58.000 |
datereferred | datetime | — | 100% | 2003-08-08T00:00:00.0002003-09-05T00:00:00.0002003-09-26T00:00:00.000 |
datereferredtoccu | datetime | — | 100% | 2003-07-02T00:00:00.0002003-05-12T14:51:08.0002002-08-28T14:41:00.000of 7 |
housenumber | text | — | 79% | 50120100 |
mainstreet | text | — | 0% | BROADWAYHYLAN BOULEVARDPARK AVENUE |
mainstreetcode | text | — | 0% | M1361001010S3410001010Q5999001010 |
crossstreet1 | text | — | 3% | BROADWAY3 AVENUE5 AVENUE |
crossstreet1code | text | — | 3% | M1361001010M1041001010M1011001010 |
crossstreet2 | text | — | 47% | DEAD END3 AVENUEBROADWAY |
crossstreet2code | text | — | 47% | M1011001010M1361001010M1021001010 |