About this Dataset

Mobile Telecommunications Franchise Pole Reservation Locations

Locations of street light poles, traffic light poles and utility poles reserved by companies authorized by the New York City Department of Information Technology and Telecommunications for the potential installation of mobile telecommunications equipment.
Organization: City of New York
Last updated: 2020-11-10T17:05:20.831977
Tags: equipment, poletop, telecommunications

Tables

Table 1

@usgov.city_of_new_york_mobile_telecommunications_franchise_p_37974b1a.table_1

696.7 kB
10,392 rows
23 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "reservation_date" TIMESTAMP,
  "franchisee_name" VARCHAR,
  "status" VARCHAR,
  "installation_date" TIMESTAMP,
  "pole_class" VARCHAR,
  "borough" VARCHAR,
  "x_coord" DOUBLE  -- X Coord.,
  "y_coord" DOUBLE  -- Y Coord.,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "zone" VARCHAR,
  "on_street" VARCHAR,
  "cross_street_1" VARCHAR,
  "cross_street_2" VARCHAR,
  "park_advisory" VARCHAR,
  "historic_landmark_advisory" VARCHAR,
  "scenic_landmark_advisory" VARCHAR,
  "bid_advisory" VARCHAR,
  "school_advisory" VARCHAR,
  "zipcode" BIGINT,
  "community_board" BIGINT,
  "council_district" BIGINT
);