About this Dataset

Integrated Resource Restoration (IRR): Line (Feature Layer)

Depicts the area of activities funded through the NFRR Budget Line Item and reported through the FACTS database. (The activities fall under number of acres treated annually to sustain or restore watershed function: acres of forestlands treated using timber sales, acres of forestland vegetation improved, acres of forestland vegetation established, acres of rangeland vegetation improved, acres treated for noxious weeds/invasive plants on NFS lands, and acres of hazardous fuels treated outside the wildland/urban interface (WUI) to reduce the risk of catastrophic wildland fire) and are self-reported by Forest Service Units. Metadata
Organization: Department of Agriculture
Last updated: 2024-03-30T10:50:57.555251
Tags: activities, collaborative-forest-landscape-restoration, ecosystem-resoration, environment, forest-management, open-data, priority-forest-landscapes, us-forest-service, vegetation-management

Tables

Table 1

@usgov.usda_gov_integrated_resource_restoration_irr_line_feat_28908949.table_1

47.64 KB
19 rows
62 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "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" BIGINT,
  "admin_forest_code" BIGINT,
  "district_code" BIGINT,
  "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" BIGINT,
  "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" BIGINT,
  "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,
  "uk" VARCHAR,
  "edw_insert_date" TIMESTAMP,
  "gis_miles" DOUBLE,
  "accuracy" DOUBLE,
  "etl_modified" VARCHAR,
  "shapelen" DOUBLE
);