About this Dataset

Aquatic Organism Passage Activities (Feature Layer)

This dataset provides USFS watershed improvement activities to barriers to upstream migration. This includes improving existing passage structures or removing them entirely. Structures include culverts, dams, diversion dams. Also included are where structures have been added to purposely create barriers to protect native populations from invasive species. Data include the planned fiscal year and planned cost, the completed fiscal year, approximate completed cost, and partners involved. Each AOP activity is displayed as a single point.

Metadata and Downloads
Organization: Department of Agriculture
Last updated: 2024-03-30T10:44:27.870717
Tags: activities, aop, aquatic, aquatic-organism-passage, assessments, edw, fish, habitat, measures, nrm, open-data, survey, usda-forest-service, wit

Tables

Table 1

@usgov.usda_gov_aquatic_organism_passage_activities_feature_layer.table_1

1.34 MB
5,896 rows
39 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "region" BIGINT,
  "fs_unit_id" BIGINT,
  "fs_unit_name" VARCHAR,
  "activity_id" VARCHAR,
  "activity_name" VARCHAR,
  "activity_type_code" VARCHAR,
  "site_name" VARCHAR,
  "planned_fiscal_year" BIGINT,
  "planned_cost" VARCHAR,
  "planned_habitat_improved_miles" DOUBLE,
  "accomplished_fiscal_year" VARCHAR,
  "accomplished_date" TIMESTAMP,
  "completed_fiscal_year" VARCHAR,
  "completed_date" TIMESTAMP,
  "habitat_improved_miles" DOUBLE,
  "total_cost_approximate" DOUBLE,
  "fs_cost_approximate" DOUBLE,
  "partner_cost_approximate" DOUBLE,
  "partner_in_kind_cost_approx" DOUBLE,
  "partners_contributed" VARCHAR,
  "partner_names" VARCHAR,
  "nepa_completed" VARCHAR,
  "wyden_auth" VARCHAR,
  "significant_recovery_action" VARCHAR,
  "planning_rule" VARCHAR,
  "essential_activity_status" VARCHAR,
  "sourcetype" VARCHAR,
  "route_no" VARCHAR,
  "rte_cn" VARCHAR,
  "rte_measure" DOUBLE,
  "nhdreachcode" DOUBLE,
  "nhd_measure" DOUBLE,
  "plan_phase_type" VARCHAR,
  "site_spatial_id" VARCHAR,
  "activity_cn" VARCHAR,
  "plan_phase_cn" VARCHAR
);