About this Dataset

Timber Harvests (Feature Layer)

Depicts the area planned and accomplished acres treated as a part of the timber harvest program of work, funded through the budget allocation process and reported through the FACTS database. Activities are self-reported by Forest Service Units. Metadata
Organization: Department of Agriculture
Last updated: 2024-03-30T10:53:53.935895
Tags: edw, facts, forest-management, open-data, timber-harvest, usfs, vegetation, vegetation-management

Tables

Table 1

@usgov.usda_gov_timber_harvests_feature_layer_ea8be.table_1

76.32 MB
823,754 rows
70 columns

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