About this Dataset

Monarch Butterfly Habitat Restoration: Polygon (Feature Layer)

Activities meeting the Monarch Butterfly Habitat Restoration initiative are a subset of activities that benefit native plants, and in doing so, benefit pollinators. Activities such as thinning, prescribed fire and other methods of fuel removal, treating invasive species and acres of native plantings can benefit Monarchs. Activities are self-reported by Forest Service Units and are reported when completed. This layer does not contain all activities that benefit Monarchs because this is a relatively new requirement for the program. The quality and comprehensiveness of this data will increase over time. Metadata
Organization: Department of Agriculture
Last updated: 2024-03-30T10:46:31.858220
Tags: activities, activity, butterflies, fiscal-year, forest-service, habitat, mbhr, monarch, open-data, restoration, usfs

Tables

Table 1

@usgov.usda_gov_monarch_butterfly_habitat_restoration_polygon_f330b7bf.table_1

103.34 kB
443 rows
61 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "activity_code" BIGINT,
  "activity_name" VARCHAR,
  "treatment_type" VARCHAR,
  "fund_codes" VARCHAR,
  "nbr_units_planned" DOUBLE,
  "nbr_units_accomplished" DOUBLE,
  "uom" VARCHAR,
  "date_planned" TIMESTAMP,
  "date_accomplished" TIMESTAMP,
  "date_completed" TIMESTAMP,
  "fy_planned" BIGINT,
  "fy_accomplished" BIGINT,
  "fy_completed" DOUBLE,
  "activity_unit_org" BIGINT,
  "region_code" BIGINT,
  "admin_forest_code" BIGINT,
  "district_code" BIGINT,
  "home_org" BIGINT,
  "admin_forest_name" VARCHAR,
  "admin_district_name" VARCHAR,
  "proclaimed_forest_code" BIGINT,
  "ownership_code" VARCHAR,
  "ownership_desc" VARCHAR,
  "alpcounty" VARCHAR,
  "state_abbr" VARCHAR,
  "watershed_code" DOUBLE,
  "slope" DOUBLE,
  "elevation" DOUBLE,
  "aspect" VARCHAR,
  "method_code" BIGINT,
  "method_desc" VARCHAR,
  "equipment_code" BIGINT,
  "equipment_desc" VARCHAR,
  "cost_per_uom" DOUBLE,
  "nepa_project_id" VARCHAR,
  "nepa_doc_name" VARCHAR,
  "implementation_project_names" VARCHAR,
  "implementation_project_numbers" VARCHAR,
  "implementation_project_types" VARCHAR,
  "work_agent_codes" VARCHAR,
  "subunit_size" DOUBLE,
  "subunit_uom" VARCHAR,
  "gis_acres" DOUBLE,
  "activity_unit_cn" VARCHAR,
  "subunit_cn" BIGINT,
  "facts_id" VARCHAR,
  "suid" VARCHAR,
  "subunit" VARCHAR,
  "subunit_name" VARCHAR,
  "activity_cn" VARCHAR,
  "nepa_project_cn" BIGINT,
  "stage" BIGINT,
  "stage_desc" VARCHAR,
  "rev_date" TIMESTAMP,
  "data_source_code" DOUBLE,
  "data_source_desc" VARCHAR,
  "uk" VARCHAR,
  "accuracy" DOUBLE,
  "shapearea" DOUBLE,
  "shapelen" DOUBLE
);