About this Dataset

BLM OR Biological Treatments Polygon Hub

BIO_POLY: This dataset represents completed biological land treatments for BLM managed lands in the states of Oregon and Washington. Biological treatments are the introduction of foraging species, predators or parasites to control plant or animal pests, or to selectively suppress or remove vegetation.
Organization: Department of the Interior
Last updated: 2024-02-09T05:04:20.529017
Tags: bio, biological, biota, completed, environment, geospatial, management, oregon, treatments, vegetation, washington, wildlife

Tables

Table 1

@usgov.doi_gov_blm_or_biological_treatments_polygon_hub.table_1

84.47 kB
354 rows
52 columns

CREATE TABLE table_1 (
  "unit_number" VARCHAR,
  "weed_target_2" VARCHAR,
  "weed_target_3" 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,
  "biological_type" VARCHAR,
  "biological_agent" VARCHAR,
  "biological_agent_number" DOUBLE,
  "biological_agent_source" VARCHAR,
  "wind_speed_mph" DOUBLE  -- Wind Speed (mph),
  "wind_direction" VARCHAR,
  "air_temperature_f" DOUBLE  -- Air Temperature (F),
  "treatment_target" VARCHAR,
  "weed_target_1" VARCHAR,
  "phenology" VARCHAR,
  "cover" DOUBLE  -- Cover %,
  "status" VARCHAR,
  "treatment_date" VARCHAR,
  "treatment_date_fy" BIGINT,
  "blm_organization_code" VARCHAR,
  "plan_id" VARCHAR,
  "workagent" VARCHAR,
  "budget_code" VARCHAR,
  "program_element" VARCHAR,
  "treatment_acres" DOUBLE,
  "gis_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  -- Accuracy (ft),
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);