About this Dataset

BLM OR Mechanical Treatments Polygon Hub

MECH_POLY: This dataset represents completed mechanical treatments on BLM managed lands in the states of Oregon and Washington. Mechanical treatments are 1.) machine and manual methods of area treatment; 2.) pulling, piling, chopping, grinding, or mowing treatments to consolidate, reduce or clear live or dead vegetation (might be grass, brush, small trees, stump removal), as well as "Cut-Leave" of trees, and soil preparation such as plowing or ripping.
Organization: Department of the Interior
Last updated: 2024-02-09T04:56:59.964456
Tags: biota, completed, environment, geospatial, management, mech, mechanical, oregon, treatments, vegetation, washington

Tables

Table 1

@usgov.doi_gov_blm_or_mechanical_treatments_polygon_hub.table_1

13.81 MB
109632 rows
55 columns


CREATE TABLE table_1 (
  "forestry_treatment" VARCHAR,
  "weed_targ4" VARCHAR,
  "weed_targ5" VARCHAR,
  "phenology1" VARCHAR,
  "phenology2" VARCHAR,
  "phenology3" VARCHAR,
  "phenology4" VARCHAR,
  "phenology5" VARCHAR,
  "treatment_date_accuracy" VARCHAR,
  "vmap_treatment_identifier" DOUBLE,
  "national_flag_code" VARCHAR,
  "program_area" VARCHAR,
  "treatments_unique_identifier" VARCHAR,
  "globalid" VARCHAR,
  "objectid" BIGINT,
  "treatment_name" VARCHAR,
  "project_name" VARCHAR,
  "unit_number" VARCHAR,
  "mechanical_type" VARCHAR,
  "method" VARCHAR,
  "treatment_target" VARCHAR,
  "weed_target_1" VARCHAR,
  "weed_target_2" VARCHAR,
  "weed_target_3" VARCHAR,
  "phenology" VARCHAR,
  "cover" DOUBLE,
  "status" VARCHAR,
  "treatment_date" VARCHAR,
  "treatment_date_fy" VARCHAR,
  "blm_organization_code" VARCHAR,
  "plan_id" VARCHAR,
  "workagent" VARCHAR,
  "budget_code" VARCHAR,
  "program_element" VARCHAR,
  "gis_acres" DOUBLE,
  "treatment_acres" DOUBLE,
  "reason" VARCHAR,
  "reason_2" VARCHAR,
  "initiative" VARCHAR,
  "initiative_2" VARCHAR,
  "contract_id" VARCHAR,
  "contractor" VARCHAR,
  "local_link" VARCHAR,
  "nfpors_treatment_identifier" DOUBLE,
  "nfpors_project_identifier" DOUBLE,
  "rips_key" VARCHAR,
  "nisims_identifier" VARCHAR,
  "monitoring" VARCHAR,
  "archaeological_clearance_date" VARCHAR,
  "botany_clearance_date" VARCHAR,
  "wildlife_clearance_date" VARCHAR,
  "coordinate_source" VARCHAR,
  "accuracy_ft" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);