From a 500-row sample across 28 columns.
planned_kiosk_type:@computed_region_sbqj_enih:@computed_region_92fq_4b7q+11latitudelongitudeboro:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_yeji_bk3q+8Mappable — Socrata point column `location`.
Open on the map →| link_site_id | planned_kiosk_type | link_installation_status | boro | council_district | community_board | street_address | cross_street_1 | cross_street_2 | ixn_corner | postcode | zoning |
|---|---|---|---|---|---|---|---|---|---|---|---|
| qu-02-158449 | Link1.0 | Live | Queens | 26 | 402 | 52-19 QUEENS BOULEVARD | 53rd Street | 52nd Street | NW | 11377 | C2-3 |
| qu-12-158710 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
link_site_id | text | The unique ID for each LinkNYC kiosk site in the format: Borough-Community Board-Payphone ID (e.g., mn-03-123265) | 0% | bk-01-108949bk-01-108952bk-01-109091 |
planned_kiosk_type | categorical | Indicates style of kiosk (LINK1.0, LINK5G, and LINK5G_NoAd) or public payphone. | 0% | Link1.0Link5G_AdLink5G_NonAdof 5 |
link_installation_status | categorical | Indicates the current status, including planning for utility connections, DOT permitting, and construction. | 0% | LiveRemoved Pending Reinstal…of 2 |
smallest_ppt | text | An 6-digit ID generated by the database - a unique number for each LINK and Pay Public Telephone (PPT). |
GET /api/datasets/s4kf-3yrf GET /api/datasets/s4kf-3yrf/quality GET /api/datasets/s4kf-3yrf/related GET /api/columns?dataset=s4kf-3yrf
:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_yeji_bk3q:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_yeji_bk3q+3council_districtlatitudelongitude+2:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_yeji_bk3q+8| Link5G_Ad |
| Live |
| Queens |
| 31 |
| 412 |
| 138-02 FARMERS BOULEVARD |
| 138TH AVENUE |
| 139TH ROAD |
| SW |
| 11434 |
| C1-3 |
| mn-04-122583 | Link1.0 | Live | Manhattan | 3 | 104 | 715 8 AVENUE | WEST 45 STREET | WEST 44 STREET | SW | 10036 | C6-4 |
| mn-05-137138 | Link1.0 | Live | Manhattan | 4 | 105 | 130 MADISON AVENUE | EAST 31 STREET | EAST 30 STREET | SW | 10016 | C5-2 |
| bk-02-126506 | Link1.0 | Live | Brooklyn | 33 | 302 | 339 LIVINGSTON STREET | FLATBUSH AVENUE | NEVINS STREET | NW | 11217 | C6-4 |
| bk-16-160026 | Link5G_NonAd | Live | Brooklyn | 41 | 316 | 98 BELMONT AVENUE | MOTHER GASTON BOULEVARD | CHRISTOPHER AVENUE | S | 11212 | R6 |
| mn-08-120978 | Link1.0 | Live | Manhattan | 4 | 108 | 166 EAST 67 STREET | 3 AVENUE | LEXINGTON AVENUE | SW | 10065 | C1-9 |
| mn-12-121455 | Link1.0 | Live | Manhattan | 10 | 112 | 1358 ST. NICHOLAS AVENUE | WEST 178 STREET | WEST 177 STREET | SE | 10033 | C1-4 |
| mn-06-134118 | Link1.0 | Live | Manhattan | 4 | 106 | 892 3 AVENUE | EAST 54 STREET | EAST 53 STREET | SW | 10022 | C6-6 |
| mn-11-120314 | Link1.0 | Live | Manhattan | 8 | 111 | 2256 2 AVENUE | EAST 116 STREET | EAST 115 STREET | NE | 10029 | C1-5 |
Showing 12 of 28 columns. All of them are listed below.
| 7% |
100074100190100200 |
cb_link_id | text | The ID number for the LinkNYC kiosk. | 9% | 101001033010332 |
boro | categorical | The borough where the approved kiosk will be located. | 0% | ManhattanQueensBrooklynof 5 |
council_district | integer | Council District is the lawmaking body of the City of New York. There are 51 districts throughout NYC's five boroughs. | 0% | 432 |
community_board | integer | Community Board: An appointed advisory group from a variety of districts throughout NYC's five boroughs. They deal with issues such as zoning, land usage, and any other matter related to the quality of life of their residents. | 0% | 106107105 |
street_address | text | The address of the building adjacent to the approved kiosk location. | 0% | 845 3 AVENUE133 EAST 40 STREET300 MADISON AVENUE |
cross_street_1 | text | One of the closest streets to the approved kiosk location. | 0% | BROADWAY3 AVENUEMADISON AVENUE |
cross_street_2 | text | One of the closest streets to the approved kiosk location. | 0% | LEXINGTON AVENUEPARK AVENUEAMSTERDAM AVENUE |
ixn_corner | categorical | The direction the Kiosk is facing. | 2% | SENESWof 10 |
postcode | integer | Five (5) digit postal code assigned by the United States Postal Service. | 0% | 100251001610022 |
zoning | text | The type of zoning a kiosk is located in, displayed by its first letter followed by its zone. | 0% | C1-4C2-4C1-5 |
latitude | float | Points that fall North or South of the Equator, expressed in degrees. | 0% | 40.73810940.80383440.784423 |
longitude | float | Points that fall East or West of the Prime Meridian, expressed in degrees. | 0% | -73.986634-73.919006-74.000238 |
link_installation | datetime | Date when LINK kiosk/public pay phone was installed. | 0% | 2017-09-23T00:00:00.0002017-03-11T00:00:00.0002017-10-28T00:00:00.000 |
link_smoke_tested_and_activated_a | datetime | Date when LINK kiosk/public pay phone was activated. | 0% | 2016-07-19T00:00:00.0002016-07-21T00:00:00.0002018-05-17T00:00:00.000 |
neighborhood_tabulation_area_nta | text | Neighborhood Tabulation Areas (NTAs) are aggregates of census tracts that were created to project populations at a small area level, from 2000 to 2030, for PlaNYC, the long-term sustainability plan for New York City. | 0% | Upper West SideMidtown-Midtown SouthTurtle Bay-East Midtown |
building_identification_number_bin | integer | Building Identification Number (BIN) - Every real estate property has an assigned 7-digit number issued by the Department of City Planning. | 3% | 300000010000002000000 |
borough_block_lot_bbl | integer | Borough Block Lot (BBL) - Every real estate property is identified by a set of 3 numbers for taxes, zoning, construction, and other purposes. | 1% | 101140750110087000241011700012 |
census_tract_ct | integer | Census Tract (CT) - Permanent statistical subdivisions to provide a stable set of geographic units for the presentation of statistical data. | 7% | 100400010072001006600 |
location | coordinate | The exact latitude and longitude of each Kiosk. | — | — |