About this Dataset

Western Bark Beetle Strategy: Polygon (Feature Layer)

Depicts the area of activities to implement the Western Bark Beetle Strategy. Activities were self-reported by field units, and center around three main objectives: increasing safety to ensure that people and community infrastructure are protected from the hazards of falling bark beetle-killed trees and elevated wildfire potential, facilitating recovery to re-establish forests damaged by bark beetles, and cultivating resiliency to prevent or mitigate future bark beetle impacts. Metadata
Organization: Department of Agriculture
Last updated: 2024-03-30T10:54:13.204593
Tags: activities, beetle, environment, forest-management, fs, open-data, strategy, usfs, wbbs, western-bark

Tables

Table 1

@usgov.usda_gov_western_bark_beetle_strategy_polygon_feature__1f736b65.table_1

5.96 MB
52,304 rows
63 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,
  "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" VARCHAR,
  "data_source_code" DOUBLE,
  "data_source_desc" VARCHAR,
  "crc_value" VARCHAR,
  "uk" VARCHAR,
  "edw_insert_date" TIMESTAMP,
  "etl_modified" VARCHAR,
  "accuracy" DOUBLE,
  "shapearea" DOUBLE,
  "shapelen" DOUBLE
);