About this Dataset

Maryland Department Of The Environment - LMA Resource Management Program, Animal Feeding Operations Division(AFO) - Permits

Maryland Department of the Environment - LMA Resource Management Program, Animal Feeding Operations Division(AFO) Permits
Organization: State of Maryland
Last updated: 2022-06-23T01:42:45.777962
Tags: afo, cafo, land-management, lma, mafo, maryland-department-of-the-environment-land-management-administration-lma-afo-permits, mde, permit, permits

Tables

Table 1

@usgov.state_of_maryland_maryland_department_of_the_environme_8f11c1bf.table_1

168.61 KB
678 rows
61 columns


CREATE TABLE table_1 (
  "document" VARCHAR,
  "site_no" BIGINT,
  "permit_type_activity" VARCHAR,
  "permit_class" VARCHAR,
  "alternate_ai_id" VARCHAR,
  "npdes" VARCHAR,
  "registration_no" VARCHAR,
  "site_name" VARCHAR,
  "street_address" VARCHAR,
  "city_state_zip" VARCHAR,
  "mailing_street_address" VARCHAR,
  "mailing_city_state_zip" VARCHAR,
  "county" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "new_technology" VARCHAR,
  "organic" VARCHAR,
  "noi_received" TIMESTAMP,
  "permit_start_date" TIMESTAMP,
  "permit_end_date" TIMESTAMP,
  "withdrawn_date" TIMESTAMP,
  "cnmp_received" TIMESTAMP,
  "cnmp_expires" TIMESTAMP,
  "nmp_received" TIMESTAMP,
  "nmp_expires" TIMESTAMP,
  "conservation_plan_received" TIMESTAMP,
  "web_registration_status" VARCHAR,
  "deadline_to_submit_written_comments" TIMESTAMP,
  "deadline_to_request_hearing" TIMESTAMP,
  "public_hearing_date" TIMESTAMP,
  "public_hearing_location" VARCHAR,
  "contested_case_hearing_expires" VARCHAR,
  "contested_case_hearing_requested" VARCHAR,
  "contested_case_hearing_date" VARCHAR,
  "contested_case_hearing_location" VARCHAR,
  "initial_renewal_notif_received" TIMESTAMP,
  "initial_renewal_notif_reviewed" TIMESTAMP,
  "date_fee_paid" TIMESTAMP,
  "amount_paid" VARCHAR,
  "date_fee_reimbursed" VARCHAR,
  "amount_reimbursed" VARCHAR,
  "proposed_building_qty" DOUBLE,
  "existing_building_qty" DOUBLE,
  "acres_controlled" BIGINT,
  "chickens_not_laying_hens_dry" DOUBLE,
  "laying_hens_dry_manure" DOUBLE,
  "chickens_liquid_manure" VARCHAR,
  "dairy_cattle" DOUBLE,
  "cattle_includes_heifers" DOUBLE,
  "veal" VARCHAR,
  "sheep_and_lambs" DOUBLE,
  "ducks_dry_manure" VARCHAR,
  "ducks_liquid_manure" DOUBLE,
  "horses" DOUBLE,
  "swine_55_lbs" DOUBLE,
  "swine_55_lbs_d85f71" DOUBLE,
  "turkeys" DOUBLE,
  "farm_name" VARCHAR,
  "permit_category" VARCHAR,
  "permit_status" VARCHAR,
  "administratively_extended" VARCHAR
);