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: 2024-02-09T04:45:46.930632
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.table_1

5.85 MB
40696 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,
  "n_1st_chemical_brand" VARCHAR,
  "n_1st_chemical_epa_number" VARCHAR,
  "n_1st_chemical_quantity" DOUBLE,
  "n_1st_chemical_unit" VARCHAR,
  "n_1st_applied_acid_equivalent_lbs_per_acre" DOUBLE,
  "n_1st_total_applied_acid_equivalent_lbs" DOUBLE,
  "n_2nd_chemical_name" VARCHAR,
  "n_2nd_chemical_brand" VARCHAR,
  "n_2nd_chemical_epa_number" VARCHAR,
  "n_2nd_chemical_quantity" DOUBLE,
  "n_2nd_chemical_unit" VARCHAR,
  "n_2nd_applied_acid_equivalent_lbs_per_acre" DOUBLE,
  "n_2nd_total_applied_acid_equivalent_lbs" DOUBLE,
  "n_3rd_chemical_name" VARCHAR,
  "n_3rd_chemical_brand" VARCHAR,
  "n_3rd_chemical_epa_number" VARCHAR,
  "n_3rd_chemical_quantity" DOUBLE,
  "n_3rd_chemical_unit" VARCHAR,
  "n_3rd_applied_acid_equivalent_lbs_per_acre" DOUBLE,
  "n_3rd_total_applied_acid_equivalent_lbs" DOUBLE,
  "mix_rate_gallons_per_acre" VARCHAR,
  "diluent" VARCHAR,
  "mix_applied_gallons" DOUBLE,
  "adjuvant" VARCHAR,
  "treatment_target" VARCHAR,
  "weed_target_1" VARCHAR,
  "weed_target_2" VARCHAR,
  "weed_target_3" VARCHAR,
  "phenology" VARCHAR,
  "cover" DOUBLE,
  "wind_speed_mph" DOUBLE,
  "wind_direction" VARCHAR,
  "air_temperature_f" DOUBLE,
  "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
);