About this Dataset

Odor Control Plans

To better enforce and regulate nuisance odor concerns, DOEE requires certain facilities known to produce odors to develop an Odor Control Plan (OCP) subject to DOEE approval. This data set is available to show the status of OCPs and provide access to the submitted plans. It includes information on the facilities that have submitted plans, the status of approval or disapproval, and links to the plans.
Organization: District of Columbia
Last updated: 2024-06-04T18:41:57.688286
Tags: air-pollution, dc, district-of-columbia, doee, environment, odor, odor-control, washington-dc

Tables

Table 1

@usgov.district_of_columbia_odor_control_plans.table_1

19.55 kB
11 rows
23 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "name" VARCHAR,
  "address" VARCHAR,
  "status" VARCHAR,
  "duedate" TIMESTAMP,
  "submitteddate" TIMESTAMP,
  "disapprovaldate" TIMESTAMP,
  "resubmittalduedate" TIMESTAMP,
  "resubmittaldate" TIMESTAMP,
  "approvaldate" TIMESTAMP,
  "linktoplan" VARCHAR,
  "zipcode" BIGINT,
  "ward" VARCHAR,
  "anc" VARCHAR,
  "mar_id" BIGINT,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "se_anno_cad_data" VARCHAR,
  "objectid" BIGINT,
  "globalid" VARCHAR
);