About this Dataset

BLM OR Chemical Treatments Polygon Hub

CHEM_POLY: This dataset represents completed chemical land treatments on BLM managed lands in the states of Oregon and Washington. Chemical treatments are applications of herbicide or pesticide, to control or kill pests and invasive plants, or fertilizer to enhance plant growth.
Organization: Department of the Interior
Last updated: 2025-09-25T02:15:21.583775
Tags: biota, chem, chemical, environment, geospatial, land-use-planning, management, oregon, planningcadastre, treatments, vegetation, washington

Tables

Table 1

@usgov.doi_gov_blm_or_chemical_treatments_polygon_hub_06ed6.table_1

5.51 MB
40,992 rows
102 columns

CREATE TABLE table_1 (
  "globalid" VARCHAR,
  "unit_number" VARCHAR,
  "forestry_treatment" VARCHAR,
  "form" VARCHAR,
  "weed_targ4" VARCHAR,
  "weed_targ5" VARCHAR,
  "phenology1" VARCHAR,
  "phenology2" VARCHAR,
  "phenology3" VARCHAR,
  "phenology4" VARCHAR,
  "phenology5" VARCHAR,
  "treatment_date_accuracy" VARCHAR,
  "contracts_unique_identifier" VARCHAR,
  "vmap_treatment_identifier" DOUBLE,
  "national_flag_code" VARCHAR,
  "program_area" VARCHAR,
  "treatments_unique_identifier" VARCHAR,
  "chem4" VARCHAR,
  "chem4_brand" VARCHAR,
  "chem4_epa" VARCHAR,
  "chem4_qty" DOUBLE,
  "chem4_unit" VARCHAR,
  "chem4_ae_ac_lbs" DOUBLE,
  "chem4_ap_ae_lbs" DOUBLE,
  "chem5" VARCHAR,
  "chem5_brand" VARCHAR,
  "chem5_epa" VARCHAR,
  "chem5_qty" DOUBLE,
  "chem5_unit" VARCHAR,
  "chem5_ae_ac_lbs" DOUBLE,
  "chem5_ap_ae_lbs" DOUBLE,
  "equip_cal_rt_nm" VARCHAR,
  "objectid" BIGINT,
  "treatment_name" VARCHAR,
  "project_name" VARCHAR,
  "chemical_type" VARCHAR,
  "method" VARCHAR,
  "n_1st_chemical_name" VARCHAR  -- 1st Chemical Name,
  "n_1st_chemical_brand" VARCHAR  -- 1st Chemical Brand,
  "n_1st_chemical_epa_number" VARCHAR  -- 1st Chemical EPA Number,
  "n_1st_chemical_quantity" DOUBLE  -- 1st Chemical Quantity,
  "n_1st_chemical_unit" VARCHAR  -- 1st Chemical Unit,
  "n_1st_applied_acid_equivalent_lbs_per_acre" DOUBLE  -- 1st Applied Acid Equivalent (lbs Per Acre),
  "n_1st_total_applied_acid_equivalent_lbs" DOUBLE  -- 1st Total Applied Acid Equivalent (lbs),
  "n_2nd_chemical_name" VARCHAR  -- 2nd Chemical Name,
  "n_2nd_chemical_brand" VARCHAR  -- 2nd Chemical Brand,
  "n_2nd_chemical_epa_number" VARCHAR  -- 2nd Chemical EPA Number,
  "n_2nd_chemical_quantity" DOUBLE  -- 2nd Chemical Quantity,
  "n_2nd_chemical_unit" VARCHAR  -- 2nd Chemical Unit,
  "n_2nd_applied_acid_equivalent_lbs_per_acre" DOUBLE  -- 2nd Applied Acid Equivalent (lbs Per Acre),
  "n_2nd_total_applied_acid_equivalent_lbs" DOUBLE  -- 2nd Total Applied Acid Equivalent (lbs),
  "n_3rd_chemical_name" VARCHAR  -- 3rd Chemical Name,
  "n_3rd_chemical_brand" VARCHAR  -- 3rd Chemical Brand,
  "n_3rd_chemical_epa_number" VARCHAR  -- 3rd Chemical EPA Number,
  "n_3rd_chemical_quantity" DOUBLE  -- 3rd Chemical Quantity,
  "n_3rd_chemical_unit" VARCHAR  -- 3rd Chemical Unit,
  "n_3rd_applied_acid_equivalent_lbs_per_acre" DOUBLE  -- 3rd Applied Acid Equivalent (lbs Per Acre),
  "n_3rd_total_applied_acid_equivalent_lbs" DOUBLE  -- 3rd Total Applied Acid Equivalent (lbs),
  "mix_rate_gallons_per_acre" VARCHAR  -- Mix Rate (gallons Per Acre),
  "diluent" VARCHAR,
  "mix_applied_gallons" DOUBLE  -- Mix Applied (gallons),
  "adjuvant" VARCHAR,
  "treatment_target" VARCHAR,
  "weed_target_1" VARCHAR,
  "weed_target_2" VARCHAR,
  "weed_target_3" VARCHAR,
  "phenology" VARCHAR,
  "cover" DOUBLE  -- Cover %,
  "wind_speed_mph" DOUBLE  -- Wind Speed (mph),
  "wind_direction" VARCHAR,
  "air_temperature_f" DOUBLE  -- Air Temperature (F),
  "distance_to_water" VARCHAR,
  "pesticide_use_proposal_area_id" VARCHAR,
  "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  -- Accuracy (ft)
);