Silviculture Timber Stand Improvement (Feature Layer) by US Government | Environmental and Climate Sciences

About this Dataset

Silviculture Timber Stand Improvement (Feature Layer)

This layer portrays the area where activities accomplished as a part of the silviculture program of work, funded through the budget allocation process and reported through the Forest Service Activity Tracking System (FACTS) database and are part of the Performance Measures used to rate Agency performance in meeting the Department's Strategic Goals. It is important to note that this layer may not contain all accomplished activities; the spatial portion of the activity description is not currently enforced by FACTS and at this time some are optionally reported by Forest Service units. This layer only represents those activities associated with the performance measure Forest Vegetation Improved (Release, Weeding, and Cleaning, Precommercial Thinning, Pruning and Fertilization). As spatial data reporting is enforced by the application and acceptance of reporting increases for both tabular and spatial we hope to improve the quality and comprehensiveness of the data used for this layer in coming years.�Metadata
Organization: Department of Agriculture
Last updated: 2024-03-30T10:53:18.602800
Tags: activities, ecosystem-restoration, environment, forest-management, improvement, open-data, recovery, resiliency, safety, silviculture, silviculture-timberstand, timber-stand-improvement, u-s-forest-service, vegetation-management

Tables

Table 1

@usgov.usda_gov_silviculture_timber_stand_improvement_feature_f476c289.table_1

38.4 MB
293248 rows
70 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "region_code" BIGINT,
  "admin_forest_code" BIGINT,
  "admin_forest_name" VARCHAR,
  "proclaimed_forest_code" BIGINT,
  "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_awarded" TIMESTAMP,
  "date_completed" TIMESTAMP,
  "fy_planned" BIGINT,
  "fy_awarded" 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" DOUBLE,
  "method_desc" VARCHAR,
  "equipment_code" DOUBLE,
  "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" VARCHAR,
  "land_suitability_class_desc" VARCHAR,
  "ownership_code" VARCHAR,
  "ownership_desc" VARCHAR,
  "aspect" VARCHAR,
  "elevation" DOUBLE,
  "slope" DOUBLE,
  "state_abbr" VARCHAR,
  "au_name" VARCHAR,
  "subunit_name" VARCHAR,
  "treatment_type" VARCHAR,
  "watershed_code" VARCHAR,
  "subunit_cn" BIGINT,
  "subunit_size" DOUBLE,
  "subunit_uom" VARCHAR,
  "stage" BIGINT,
  "stage_desc" VARCHAR,
  "data_source_desc" VARCHAR,
  "accuracy" DOUBLE,
  "crc_value" VARCHAR,
  "gis_acres" DOUBLE,
  "edw_insert_date" TIMESTAMP,
  "etl_modified" VARCHAR,
  "etl_modified_date" VARCHAR,
  "rev_date" VARCHAR,
  "uk_tabular" VARCHAR,
  "uk" VARCHAR,
  "data_source_code" DOUBLE,
  "shapearea" DOUBLE,
  "shapelen" DOUBLE
);