Name: DOB Cellular Antenna Filings
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

DOB Cellular Antenna Filings

An application to work on an Antenna, a device, usually placed at the highest possible height, that transfers electrical signals across air or wires and can receive, transmit, or broadcast signals to singular or multiple locations.
Organization: City of New York
Last updated: 2020-11-10T17:03:38.120484
Tags: buildings, cellular-antenna, dob

Tables

Table 1

@usgov.city_of_new_york_dob_cellular_antenna_filings.table_1

832.55 kB
6,091 rows
55 columns

CREATE TABLE table_1 (
  "job" VARCHAR  -- Job #,
  "doc" VARCHAR  -- Doc #,
  "borough" VARCHAR,
  "house" VARCHAR  -- House #,
  "street_name" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "bin" VARCHAR  -- Bin #,
  "job_type" VARCHAR,
  "job_status" VARCHAR,
  "job_status_descrp" VARCHAR,
  "latest_action_date" VARCHAR,
  "building_type" VARCHAR,
  "community_board" VARCHAR  -- Community - Board,
  "landmarked" VARCHAR,
  "little_e" VARCHAR,
  "pc_filed" VARCHAR,
  "other" VARCHAR,
  "other_description" VARCHAR,
  "applicant_s_first_name" VARCHAR,
  "applicant_s_last_name" VARCHAR,
  "applicant_professional_title" VARCHAR,
  "applicant_license" DOUBLE  -- Applicant License #,
  "professional_cert" VARCHAR,
  "pre_filing_date" VARCHAR  -- Pre- Filing Date,
  "paid" VARCHAR,
  "fully_paid" VARCHAR,
  "assigned" VARCHAR,
  "approved" VARCHAR,
  "fully_permitted" VARCHAR,
  "initial_cost" DOUBLE,
  "total_est_fee" DOUBLE  -- Total Est. Fee,
  "fee_status" VARCHAR,
  "existing_occupancy" VARCHAR,
  "proposed_occupancy" VARCHAR,
  "zoning_distr_1" VARCHAR,
  "zoning_distr_2" VARCHAR,
  "zoning_distr_3" VARCHAR,
  "special_distr_1" VARCHAR,
  "special_distr_2" VARCHAR,
  "owner_type" DOUBLE,
  "owner_type_description" VARCHAR,
  "non_profit" VARCHAR,
  "owner_s_first_name" VARCHAR,
  "owner_s_last_name" VARCHAR,
  "owner_s_business_name" VARCHAR,
  "owner_s_house" VARCHAR  -- Owner's House #,
  "owner_s_house_street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "owner_s_phone" DOUBLE  -- Owner's Phone #,
  "first_permit_date" VARCHAR,
  "job_description" VARCHAR,
  "dobrundate" TIMESTAMP
);