From a 500-row sample across 13 columns.
corneridthe_geomborough+4borough:@computed_region_92fq_4b7q:@computed_region_sbqj_enih+2Mappable — Socrata point column `the_geom`.
Open on the map →| the_geom | objectid | cornerid | street_nam | street_n_1 | borough | constructi | construc_1 | construc_2 | :@computed_region_f5dn_yrer | :@computed_region_yeji_bk3q | :@computed_region_sbqj_enih |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.75425, -73.90920 | 32572 | 1039268 | 51 STREET | BROADWAY | QUEENS | Upgrade | 2024/12/17 | Constructed | 39 | 3 | 72 |
| 40.71524, -73.83919 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | Geometry column used for mapping | 0% | {'coordinates': [-73.896…{'coordinates': [-73.966…{'coordinates': [-73.754… |
objectid | integer | A system-managed value that uniquely identifies a record or feature | 0% | 171123187518117562 |
cornerid | integer | Unique numeric identifier assigned to a corner point. A corner may contain more than one ramp. | 0% | 102679710308211090787 |
street_nam | text | The first street name where the corner is located. | 0% |
GET /api/datasets/e7gc-ub6z GET /api/datasets/e7gc-ub6z/quality GET /api/datasets/e7gc-ub6z/related GET /api/columns?dataset=e7gc-ub6z
boroughobjectid:@computed_region_92fq_4b7q+3borough:@computed_region_92fq_4b7q:@computed_region_sbqj_enih+2| 29177 |
| 1035640 |
| 75 ROAD |
| BEECHKNOLL ROAD |
| QUEENS |
| — |
| — |
| Not Required |
| 40 |
| 3 |
| 70 |
| 40.83434, -73.82751 | 14222 | 1018904 | DEAD END | MEYERS STREET | BRONX | New Install | — | Planned Construction | 43 | 5 | 28 |
| 40.83247, -73.81872 | 2164 | 1003765 | LAFAYETTE AVENUE | WILCOX AVENUE | BRONX | Upgrade | — | Complex Planned Construction | 43 | 5 | 28 |
| 40.90425, -73.90634 | 8608 | 1011794 | NETHERLAND AVENUE | WEST 256 STREET | BRONX | Upgrade | 2022/07/06 | Constructed | 48 | 5 | 33 |
| 40.72261, -73.89383 | 25696 | 1031917 | 59 ROAD | 69 STREET | QUEENS | Upgrade | 2025/03/08 | Constructed | 54 | 3 | 62 |
| 40.71502, -73.81635 | 646 | 1001455 | COOLIDGE AVENUE | MAIN STREET | QUEENS | New Install | 2024/08/13 | Constructed | 25 | 3 | 65 |
| 40.83811, -73.82234 | 13951 | 1018543 | THROGMORTON AVENUE | WATERBURY AVENUE | BRONX | — | — | Planned Construction | 43 | 5 | 28 |
| 40.75215, -73.94275 | 31844 | 1038518 | 22 STREET | QUEENS PLAZA | QUEENS | New Install | 2020/06/30 | Constructed | 39 | 3 | 72 |
| 40.74229, -73.85878 | 20874 | 1026806 | 51 AVENUE | 103 STREET | QUEENS | — | — | Planned Construction | 66 | 3 | 68 |
Showing 12 of 13 columns. All of them are listed below.
BENDBROADWAY3 AVENUE |
street_n_1 | text | The second street name where the corner is located. | 0% | NYCTA SUBWAYLINDEN BOULEVARDBEND |
borough | categorical | Borough where the corner is located. | 0% | QUEENSBROOKLYNSTATEN ISLANDof 5 |
constructi | categorical | If the construction type is a pedestrian ramp upgrade or new installation. | 39% | UpgradeNew Installof 2 |
construc_1 | text | The date the corner construction was completed. | 68% | 2026/06/302026/06/292020/06/05 |
construc_2 | categorical | The status for the corner. | 0% | Planned ConstructionConstructedNot Assignedof 6 |