Stewardship Contracting: Point (Feature Layer) by US Government | Environmental and Climate Sciences

About this Dataset

Stewardship Contracting: Point (Feature Layer)

Depicts the locations of activities within Stewardship Contracting Project Boundary. Activities are implemented through stewardship contracts or agreements and are self-reported by Forest Service Units through the FACTS database. Metadata
Organization: Department of Agriculture
Last updated: 2024-03-30T10:48:45.665159
Tags: activities, environment, forest-management, open-data, recovery, resiliency, safety, stewardship-contracting

Tables

Table 1

@usgov.usda_gov_stewardship_contracting_point_feature_layer_f70c1.table_1

49.26 KB
57 rows
60 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "activity_code" BIGINT,
  "activity_name" VARCHAR,
  "treatment_type" VARCHAR,
  "fund_codes" VARCHAR,
  "nbr_units_planned" BIGINT,
  "nbr_units_accomplished" BIGINT,
  "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" VARCHAR,
  "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_name_38" VARCHAR,
  "implementation_project_numb_39" VARCHAR,
  "implementation_project_type_40" VARCHAR,
  "work_agent_codes" VARCHAR,
  "subunit_size" BIGINT,
  "subunit_uom" VARCHAR,
  "activity_unit_cn" VARCHAR,
  "subunit_cn" BIGINT,
  "facts_id" VARCHAR,
  "suid" VARCHAR,
  "subunit" VARCHAR,
  "subunit_name" VARCHAR,
  "activity_cn" BIGINT,
  "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,
  "accuracy" VARCHAR,
  "etl_modified" VARCHAR
);