About this Dataset

LinkNYC Kiosk Locations

LinkNYC is the City’s program to provide free high-speed Wi-Fi, nationwide calling, a dedicated 911 button, charging ports for mobile devices, and access to social services. The City has recently begun to roll out a new and improved design of the original LinkNYC kiosk: Link5G. This new design will provide all of the amenities of LinkNYC kiosks, with the added benefit of 4G and 5G connectivity to enhance mobile telecommunications networks. This dataset lists locations for LinkNYC kiosks plus four public payphones in the five boroughs.
Organization: City of New York
Last updated: 2020-11-10T17:05:06.404447
Tags: 5g, free-hotspot, free-wi-fi, hotspot-kiosk, kiosk, link, link-kiosk, link-locations, link-nyc, link-nyc-locations, linknyc, wi-fi-kiosk

Tables

Table 1

@usgov.city_of_new_york_linknyc_locations.table_1

257.36 kB
2,233 rows
23 columns

CREATE TABLE table_1 (
  "site_id" VARCHAR,
  "planned_kiosk_type" VARCHAR,
  "installation_status" VARCHAR,
  "ppt_id" VARCHAR,
  "legacy_id" VARCHAR,
  "borough" VARCHAR,
  "council_district" BIGINT,
  "community_board" BIGINT,
  "street_address" VARCHAR,
  "cross_street_1" VARCHAR,
  "cross_street_2" VARCHAR,
  "ixn_corner" VARCHAR,
  "postcode" BIGINT,
  "zoning" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "installation_complete" TIMESTAMP,
  "activation_complete" TIMESTAMP,
  "neighborhood_tabulation_area_nta" VARCHAR  -- Neighborhood Tabulation Area (NTA),
  "building_identification_number_bin" DOUBLE  -- Building Identification Number (BIN),
  "borough_block_lot_bbl" DOUBLE  -- Borough-Block-Lot (BBL),
  "census_tract_ct" DOUBLE  -- Census Tract (CT),
  "location" VARCHAR
);