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

172.65 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  -- REGISTRATION NO.,
  "site_name" VARCHAR,
  "street_address" VARCHAR,
  "city_state_zip" VARCHAR  -- CITY, STATE ZIP,
  "mailing_street_address" VARCHAR,
  "mailing_city_state_zip" VARCHAR  -- MAILING CITY, STATE ZIP,
  "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. RECEIVED,
  "initial_renewal_notif_reviewed" TIMESTAMP  -- INITIAL RENEWAL NOTIF. REVIEWED,
  "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  -- CHICKENS- NOT LAYING HENS-DRY,
  "laying_hens_dry_manure" DOUBLE  -- LAYING HENS - DRY MANURE,
  "chickens_liquid_manure" VARCHAR  -- CHICKENS - LIQUID MANURE,
  "dairy_cattle" DOUBLE,
  "cattle_includes_heifers" DOUBLE  -- CATTLE - INCLUDES HEIFERS,
  "veal" VARCHAR,
  "sheep_and_lambs" DOUBLE,
  "ducks_dry_manure" VARCHAR  -- DUCKS - DRY MANURE,
  "ducks_liquid_manure" DOUBLE  -- DUCKS - LIQUID MANURE,
  "horses" DOUBLE,
  "swine_55_lbs" DOUBLE  -- SWINE >= 55 LBS,
  "swine_55_lbs_d85f71" DOUBLE  -- SWINE < 55 LBS,
  "turkeys" DOUBLE,
  "farm_name" VARCHAR,
  "permit_category" VARCHAR,
  "permit_status" VARCHAR,
  "administratively_extended" VARCHAR  -- ADMINISTRATIVELY EXTENDED?
);