From a 500-row sample across 14 columns.
boroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| cmt_corner_id | street_name1 | street_name2 | borough | community_district | block | lot | complaint_id | complaint_date | temp_repair_feasible | second_temp_repair_needed | bulkcomplaint |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1068314 | 78 AVENUE | 153 STREET | QUEENS | 408 | 6710 | 2 | 311-23925250 | 2025-08-05T00:00:00.000 | No | No | No |
| 1068447 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
cmt_corner_id | integer | Unique numeric identifier assigned to a corner point. A corner may contain more than one ramp. | 0% | 200089810876671106912 |
street_name1 | text | The first street name where the corner is located. | 0% | BROADWAY1 AVENUEBEND |
street_name2 | text | The second street name where the corner is located. | 0% | UNION TURNPIKENYCTA SUBWAYMAIN STREET |
borough | categorical | Borough where the corner is located. | 0% | BROOKLYNQUEENS |
GET /api/datasets/jagj-gttd GET /api/datasets/jagj-gttd/quality GET /api/datasets/jagj-gttd/related GET /api/columns?dataset=jagj-gttd
borough| 167 STREET |
| UNION TURNPIKE |
| QUEENS |
| 408 |
| 7002 |
| 32 |
| 311-23922628 |
| 2025-08-05T00:00:00.000 |
| No |
| No |
| No |
| 1090385 | 3 AVENUE | EAST 31 STREET | MANHATTAN | 106 | 912 | 1 | 1-1-1722172971 | 2019-06-05T00:00:00.000 | Yes | No | — |
| 1069216 | 76 ROAD | VLEIGH PLACE | QUEENS | 408 | 6628 | 98 | 311-23925512 | 2025-08-05T00:00:00.000 | No | No | No |
| 1059957 | 11 AVENUE | 157 STREET | QUEENS | 407 | 4547 | 67 | DOT-710523-S3X0 | 2025-08-21T00:00:00.000 | No | No | No |
| 1069495 | 76 ROAD | 137 STREET | QUEENS | 408 | 6606 | 2 | 311-24050487 | 2025-08-15T00:00:00.000 | No | No | No |
| 1068499 | 171 STREET | UNION TURNPIKE | QUEENS | 408 | 7006 | 1 | 311-23925118 | 2025-08-05T00:00:00.000 | No | No | No |
| 1068504 | 172 STREET | UNION TURNPIKE | QUEENS | 408 | 7008 | 43 | 311-23925095 | 2025-08-05T00:00:00.000 | No | No | No |
| 1029246 | 58 AVENUE | 76 STREET | QUEENS | 405 | 2823 | 2 | DOT-424661-R3K3 | 2019-07-23T00:00:00.000 | Yes | No | — |
| 1085781 | 2 AVENUE | EAST 2 STREET | MANHATTAN | 103 | 457 | 128 | 311-23998994 | 2025-08-11T00:00:00.000 | Yes | No | No |
Showing 12 of 14 columns. All of them are listed below.
MANHATTANcommunity_district | integer | The three digit community district number to identify the community district the corner is located in. | 0% | 408204101 |
block | integer | Tax Block identification number adjacent to the corner. | 0% | 278811171171 |
lot | integer | Tax Lot identification number adjacent to the corner. | 0% | 175016 |
complaint_id | text | Unique identification number for each complaint record. | 0% | Claremont Park Area (BUL…DOT Internal1-1-1717718341 |
complaint_date | datetime | The date the complaint was made. | 2% | 2022-04-18T00:00:00.0002019-11-12T00:00:00.0002025-08-05T00:00:00.000 |
temp_repair_feasible | categorical | If a temporary repair is feasible. | 2% | NoYesPending Determinationof 3 |
temp_repair_date | datetime | The date the temporary repair was completed. | 54% | 2019-08-21T00:00:00.0002019-11-14T00:00:00.0002019-07-30T00:00:00.000 |
temp_repair_type | categorical | What type of temporary repair was done on the corner or pedestrian ramp. | 53% | OtherAsphalt Rampof 2 |
second_temp_repair_needed | categorical | If a second temporary repair is needed for a corner or pedestrian ramp. | 0% | NoYesof 2 |
date_second_temp_repair | datetime | The date of the second temporary repair. | 100% | 1899-12-30T00:00:00.0002019-11-14T05:00:00.0002021-06-17T04:00:00.000of 12 |
bulkcomplaint | categorical | If the complaint involves multiple corners. | 12% | NoYesof 2 |