About this Dataset

DOB Sign Application Filings

Outdoor advertising regulations and zoning laws reduce visual clutter and protect people from dangerous and illegally installed signs. Signs must comply with regulations outlined in the NYC Construction Codes and the NYC Zoning Resolution. This dataset lists all sign applications filed in New York City.
Organization: City of New York
Last updated: 2020-11-10T17:04:29.124243
Tags: buildings, dob, signs

Tables

Table 1

@usgov.city_of_new_york_dob_sign_application_filings.table_1

1.41 MB
15288 rows
72 columns


CREATE TABLE table_1 (
  "job" BIGINT,
  "doc" BIGINT,
  "borough" VARCHAR,
  "house" VARCHAR,
  "street_name" VARCHAR,
  "block" BIGINT,
  "lot" BIGINT,
  "bin" BIGINT,
  "job_type" VARCHAR,
  "job_status" VARCHAR,
  "job_status_descrp" VARCHAR,
  "latest_action_date" TIMESTAMP,
  "building_type" VARCHAR,
  "community_board" VARCHAR,
  "landmarked" VARCHAR,
  "adult_estab" VARCHAR,
  "property_city_owned" VARCHAR,
  "little_e" VARCHAR,
  "efiling_filed" VARCHAR,
  "equipment" VARCHAR,
  "other" VARCHAR,
  "other_description" VARCHAR,
  "applicant_s_first_name" VARCHAR,
  "applicant_s_last_name" VARCHAR,
  "applicant_professional_title" VARCHAR,
  "applicant_license" BIGINT,
  "professional_cert" VARCHAR,
  "pre_filing_date" VARCHAR,
  "paid" VARCHAR,
  "fully_paid" VARCHAR,
  "plan_assigned_date" VARCHAR,
  "approved" VARCHAR,
  "fully_permitted" VARCHAR,
  "initial_cost" BIGINT,
  "total_est_fee" DOUBLE,
  "fee_status" VARCHAR,
  "sign_illumination" VARCHAR,
  "sign_illumination_type" VARCHAR,
  "sign_type" VARCHAR,
  "sign_height_roof" BIGINT,
  "sign_height_curb" BIGINT,
  "sign_weight" BIGINT,
  "sign_projection" BIGINT,
  "sign_sq_footage" BIGINT,
  "sign_const_type" VARCHAR,
  "inside_building_line" VARCHAR,
  "sign_non_conforming" VARCHAR,
  "sign_advertising" VARCHAR,
  "sign_changeable_copy" VARCHAR,
  "sign_near_park" VARCHAR,
  "sign_near_highway" VARCHAR,
  "sign_dist_from_highway" BIGINT,
  "sign_dist_from_park" BIGINT,
  "sign_oac_no" VARCHAR,
  "sign_oac_registration" VARCHAR,
  "text_on_sign" VARCHAR,
  "owner_type" DOUBLE,
  "non_profit" VARCHAR,
  "owner_s_first_name" VARCHAR,
  "owner_s_last_name" VARCHAR,
  "owner_s_house" VARCHAR,
  "owner_s_house_street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "owner_s_phone" DOUBLE,
  "zoning_distr_1" VARCHAR,
  "zoning_distr_2" VARCHAR,
  "zoning_distr_3" VARCHAR,
  "special_dist_name" VARCHAR,
  "job_description" VARCHAR,
  "dobrundate" VARCHAR
);