Name: Maryland Department Of The Environment (MDE) - LMA Oil Control Program - Oil Permits
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Maryland Department Of The Environment (MDE) - LMA Oil Control Program - Oil Permits

Maryland Department of the Environment (MDE) - LMA Oil Control Program Oil Permits
Organization: State of Maryland
Last updated: 2022-06-23T01:42:42.532019
Tags: maryland-department-of-the-environment-mde-land-management-administration-lma-oil-permits, oil, permits

Tables

Table 1

@usgov.state_of_maryland_maryland_department_of_the_environme_d9d2e27b.table_1

161.08 kB
1,446 rows
29 columns

CREATE TABLE table_1 (
  "permit_category" VARCHAR,
  "permit_type" VARCHAR,
  "permit_class" VARCHAR,
  "permit_mode" VARCHAR,
  "permit_status" VARCHAR,
  "site_no" BIGINT,
  "site_name" VARCHAR,
  "oil_control_facility_id" VARCHAR,
  "npdes" VARCHAR,
  "permit_no" VARCHAR,
  "oil_control_facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city_state_zip" VARCHAR  -- CITY, STATE ZIP,
  "county" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "application_received" TIMESTAMP,
  "permit_start_date" TIMESTAMP,
  "permit_end_date" TIMESTAMP,
  "administratively_extended" VARCHAR  -- ADMINISTRATIVELY EXTENDED?,
  "closed_date" TIMESTAMP,
  "permit_terminated" VARCHAR,
  "approval_expired" VARCHAR,
  "application_withdrawn" VARCHAR,
  "application_voided" VARCHAR,
  "application_recieved_for_renewal" VARCHAR,
  "application_voided_for_renewal" VARCHAR,
  "application_withdrawn_for_renewal" VARCHAR,
  "document" VARCHAR
);