About this Dataset

Asbestos Control Program (ACP7)

ACP7 form is an asbestos project notification. Any time asbestos abatement is perform on quantities greater than a minor project amount, the applicant has to file this form with DEP Asbestos Control Program (ACP). All asbestos documents are filed through the Asbestos Reporting and Tracking System (ARTS) E-file system. This system is web based and entirely paperless. All information on the ACP7 is essential to meet the requirements setforth in the asbestos rules and regulations Title15, Chapter 1 (RCNY). ACP enforcement staff utilizes this form for inspection of asbestos abatement activities.
Organization: City of New York
Last updated: 2020-11-10T17:05:47.928916

Tables

Table 1

@usgov.city_of_new_york_asbestos_control_program_acp7.table_1

16.78 MB
276,375 rows
35 columns

CREATE TABLE table_1 (
  "tru" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "status_description" VARCHAR,
  "street_activity" VARCHAR,
  "premise_no" VARCHAR,
  "street_name" VARCHAR,
  "borough" VARCHAR,
  "zip_code" BIGINT,
  "facility_aka" VARCHAR,
  "facility_type" VARCHAR,
  "bin" DOUBLE,
  "block" DOUBLE,
  "lot" DOUBLE,
  "cross_street_on" VARCHAR,
  "cross_street_between" VARCHAR,
  "cross_street_and" VARCHAR,
  "building_owner_name" VARCHAR,
  "contractor_name" VARCHAR,
  "air_monitor_name" VARCHAR,
  "entire_floor" VARCHAR,
  "floor" VARCHAR,
  "section" VARCHAR,
  "acm_type" VARCHAR,
  "acm_amount" BIGINT,
  "acm_unit" VARCHAR,
  "abatement_type" VARCHAR,
  "procedure_name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);