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.48 MB
15,288 rows
72 columns

CREATE TABLE table_1 (
  "job" BIGINT  -- Job #,
  "doc" BIGINT  -- Doc #,
  "borough" VARCHAR,
  "house" VARCHAR  -- House #,
  "street_name" VARCHAR,
  "block" BIGINT,
  "lot" BIGINT,
  "bin" BIGINT  -- Bin #,
  "job_type" VARCHAR,
  "job_status" VARCHAR,
  "job_status_descrp" VARCHAR,
  "latest_action_date" TIMESTAMP,
  "building_type" VARCHAR,
  "community_board" VARCHAR  -- Community - Board,
  "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  -- Applicant License #,
  "professional_cert" VARCHAR,
  "pre_filing_date" VARCHAR  -- Pre- Filing Date,
  "paid" VARCHAR,
  "fully_paid" VARCHAR,
  "plan_assigned_date" VARCHAR,
  "approved" VARCHAR,
  "fully_permitted" VARCHAR,
  "initial_cost" BIGINT,
  "total_est_fee" DOUBLE  -- Total Est. Fee,
  "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 #,
  "owner_s_house_street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "owner_s_phone" DOUBLE  -- Owner's Phone #,
  "zoning_distr_1" VARCHAR,
  "zoning_distr_2" VARCHAR,
  "zoning_distr_3" VARCHAR,
  "special_dist_name" VARCHAR,
  "job_description" VARCHAR,
  "dobrundate" VARCHAR
);