About this Dataset

Brush Disposal Funded Activities (Feature Layer)

Depicts the area of activities funded through BDBD and PPPP budget line item and reported through the FACTS database. The objective of the BD Program is to dispose of unwanted slash or other debris created by timber purchaser operations on timber sale contracts, stewardship contracts and permits, not disposed of by the purchaser. Activities are self-reported by Forest Service Units. The Brush Disposal Program (BD) objective of the BD Program was established in 1916. It requires all purchasers of National Forest timber make deposits to the United States for the estimated cost of disposing of brush and other debris resulting from its cutting operations. Brush disposal activities must be consistent with direction established in forest land and resource management plans, identified in environmental documents developed in accordance with the National Environmental Policy Act of 1969 (NEPA). Metadata
Organization: Department of Agriculture
Last updated: 2024-03-30T10:44:40.501379
Tags: activities, brush-disposal, edw, forest-management, funded-activities, open-data, usfs

Tables

Table 1

@usgov.usda_gov_brush_disposal_funded_activities_feature_layer_c4329.table_1

33.33 MB
372600 rows
69 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "region_code" BIGINT,
  "admin_forest_code" BIGINT,
  "admin_forest_name" VARCHAR,
  "proclaimed_forest_code" DOUBLE,
  "admin_district_name" VARCHAR,
  "district_code" BIGINT,
  "home_org" BIGINT,
  "activity_unit_org" BIGINT,
  "suid" VARCHAR,
  "facts_id" VARCHAR,
  "subunit" VARCHAR,
  "sale_name" VARCHAR,
  "activity_code" BIGINT,
  "activity_name" VARCHAR,
  "activity_cn" VARCHAR,
  "nbr_units_planned" DOUBLE,
  "uom" VARCHAR,
  "nbr_units_accomplished" DOUBLE,
  "date_planned" TIMESTAMP,
  "date_completed" TIMESTAMP,
  "fy_planned" BIGINT,
  "fy_completed" DOUBLE,
  "fund_codes" VARCHAR,
  "cost_per_uom" DOUBLE,
  "nepa_project_id" VARCHAR,
  "nepa_doc_name" VARCHAR,
  "nepa_project_cn" DOUBLE,
  "method_code" BIGINT,
  "method_desc" VARCHAR,
  "equipment_code" BIGINT,
  "equipment_desc" VARCHAR,
  "implementation_project_names" VARCHAR,
  "implementation_project_numbers" VARCHAR,
  "implementation_project_types" VARCHAR,
  "work_agent_codes" VARCHAR,
  "productivity_class_code" DOUBLE,
  "productivity_class_desc" VARCHAR,
  "land_suitability_class_code" DOUBLE,
  "land_suitability_class_desc" VARCHAR,
  "ownership_code" VARCHAR,
  "ownership_desc" VARCHAR,
  "aspect" VARCHAR,
  "elevation" DOUBLE,
  "slope" DOUBLE,
  "state_abbr" VARCHAR,
  "subunit_name" VARCHAR,
  "treatment_type" VARCHAR,
  "watershed_code" DOUBLE,
  "subunit_cn" BIGINT,
  "subunit_size" DOUBLE,
  "subunit_uom" VARCHAR,
  "stage" BIGINT,
  "stage_desc" VARCHAR,
  "data_source_code" DOUBLE,
  "data_source_desc" VARCHAR,
  "accuracy" DOUBLE,
  "crc_value" VARCHAR,
  "gis_acres" DOUBLE,
  "edw_insert_date" TIMESTAMP,
  "etl_modified" VARCHAR,
  "etl_modified_date" TIMESTAMP,
  "rev_date" VARCHAR,
  "uk_tabular" VARCHAR,
  "uk" VARCHAR,
  "date_awarded" TIMESTAMP,
  "fy_awarded" BIGINT,
  "shapearea" DOUBLE,
  "shapelen" DOUBLE
);