From a 500-row sample across 24 columns.
longitudelatitudeborolongitudelatitudesite_idlegacy_idppt_id+2longitudelatitudeMappable — Socrata point column `the_geom`.
Open on the map →| boro | legacy_id | community | the_geom | council_di | latitude | longitude | installati | ppt_id | street_add | cross_1 | cross_2 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bronx | LINK-019315 | 205 | 40.85017, -73.91028 | 14 | 40.850173 | -73.91028173 | Live | 146097 | 1 EAST 177 STREET | JEROME AVENUE | WALTON AVENUE |
| Manhattan | LINK-008842 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
boro | categorical | — | 0% | ManhattanQueensBrooklynof 5 |
legacy_id | text | — | 0% | LINK-000120LINK-010946LINK-000987 |
community | integer | — | 0% | 106107105 |
the_geom | coordinate | — | 0% | {'coordinates': [-73.950…{'coordinates': [-73.936…{'coordinates': [-73.993… |
GET /api/datasets/5mv6-f76y GET /api/datasets/5mv6-f76y/quality GET /api/datasets/5mv6-f76y/related GET /api/columns?dataset=5mv6-f76y
longitudelatitudelongitudelatitudelongitudelatitudelongitudelatitude| 105 |
| 40.74711, -73.98524 |
| 4 |
| 40.74711441 |
| -73.98524463 |
| Live |
| 121611 |
| 1 EAST 32 STREET |
| 5 AVENUE |
| MADISON AVENUE |
| Manhattan | LINK-008843 | 105 | 40.74774, -73.98483 | 4 | 40.74773664 | -73.98483344 | Live | 121613 | 1 EAST 33 STREET | 5 AVENUE | MADISON AVENUE |
| Manhattan | LINK-000186 | 105 | 40.73415, -73.98874 | 2 | 40.73414765 | -73.98873983 | Live | 134620 | 1 IRVING PLACE | EAST 14 STREET | EAST 15 STREET |
| Manhattan | LINK-010750 | 102 | 40.73026, -74.00663 | 3 | 40.73025769 | -74.00662855 | Live | 123600 | 1 ST. LUKE'S PLACE | HUDSON STREET | 7 AVENUE |
| Brooklyn | LINK-021138 | 301 | 40.70957, -73.95071 | 34 | 40.70957163 | -73.95070637 | Live | 146047 | 1 TEN EYCK STREET | UNION AVENUE | LORIMER STREET |
| Manhattan | LINK-000214 | 105 | 40.73804, -73.99238 | 3 | 40.73803969 | -73.9923767 | Live | 123023 | 1 WEST 17 STREET | 5 AVENUE | 6 AVENUE |
| Manhattan | LINK-010173 | 105 | 40.76247, -73.97473 | 4 | 40.76246755 | -73.97473228 | Live | 122853 | 1 WEST 56 STREET | 5 AVENUE | 6 AVENUE |
| Bronx | LINK-011588 | 205 | 40.85393, -73.90750 | 14 | 40.85393036 | -73.90750182 | Live | 119613 | 1 WEST BURNSIDE AVENUE | JEROME AVENUE | DAVIDSON AVENUE |
| Manhattan | LINK-012181 | 105 | 40.73681, -73.99351 | 3 | 40.736806 | -73.993513 | Live | 137100 | 10 WEST 15 STREET | 5 AVENUE | 6 AVENUE |
Showing 12 of 24 columns. All of them are listed below.
council_di | integer | — | 0% | 432 |
latitude | float | — | 0% | 40.817141240.81867640.86063 |
longitude | float | — | 0% | -73.953007-73.99011216-73.96153957 |
installati | categorical | — | 0% | LiveInstalledReady for Activationof 3 |
ppt_id | integer | — | 0% | 126609145931111577 |
street_add | address | — | 0% | 46 3 AVENUE205 3 AVENUE90-20 QUEENS BOULEVARD |
cross_1 | text | — | 0% | BROADWAY3 AVENUEMADISON AVENUE |
cross_2 | text | — | 0% | LEXINGTON AVENUEPARK AVENUEAMSTERDAM AVENUE |
ix_n_corner | categorical | — | 0% | SENESWof 8 |
zip_code | integer | — | 0% | 100251001610022 |
site_id | text | — | 0% | bk-01-126673mn-04-142000mn-04-122580 |
activation | datetime | — | 0% | 1899-11-30T00:00:00.000Z2016-07-19T00:00:00.000Z2016-07-21T00:00:00.000Z |
install_co | datetime | — | 0% | 2017-09-23T00:00:00.000Z2017-03-11T00:00:00.000Z2017-03-04T00:00:00.000Z |
neighborho | text | — | 0% | Upper West SideMidtown-Midtown SouthTurtle Bay-East Midtown |
building_i | integer | — | 0% | 300000010000002000000 |
borough_bl | integer | — | 0% | 101140750110087000241009340001 |
census_tra | integer | — | 0% | 100400010153001006600 |
gf_permit | integer | — | 0% | 08154981922 |
x2 | float | — | 0% | 1012442.98067986045.137317985993.640435 |
y2 | float | — | 0% | 182114.587868228401.015827181995.866247 |