Mobile Telecommunications Franchise Pole Reservation Locations by US Government | Ecommerce and Consumer Trends

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

680.37 KB
10392 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,
  "y_coord" DOUBLE,
  "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
);