About this Dataset

Collaborative Forest Landscape Restoration Program: Point (Feature Layer)

The Forest Service's Natural Resource Manager (NRM) Forest Activity Tracking System (FACTS) is the agency standard for managing information aboutactivities related to fire/fuels, silviculture, and invasive species. FACTS is an activity tracking application for all levels of the Forest Service. The application allows tracking and monitoring of NEPA decisions as well as the ability to create and manage KV trust fund plans at the timber sale level. This application complements its companion NRM applications, which cover the spectrum of living and non-living natural resource information. This layer represents Collaborative Forest Landscape Restoration (CFLR) Program project activities. Also included are other High Priority Restoration projects that are funded outside of CFLR. It is important to note that this layer does not contain all of the approved project activities. Instead, these are the accomplishments that project groups uploaded to the Forest Service corporate data holdings in FACTS. As spatial data is a new requirement for the program, improvements to the quality and comprehensiveness of this data is expected in coming years. Metadata
Organization: Department of Agriculture
Last updated: 2024-03-30T10:45:22.952956
Tags: cflr, environment, hrp, lands-and-realty, open-data

Tables

Table 1

@usgov.usda_gov_collaborative_forest_landscape_restoration_pr_1e0cc406.table_1

73.88 KB
303 rows
60 columns


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