About this Dataset

Aquatic Organism Passage Miles Habitat Improved (Feature Layer)

This dataset displays miles of habitat improved upstream from an Aquatic Organism Passage (AOP) structure that was improved by an on the ground activity. Data includes the completed fiscal year and lists species that benefit from the habitat improvement. The miles of habitat improved are displayed as a line or multi-line. Data are from USFS Natural Resource Manager Watershed Improvement Tracking (WIT) database.

Metadata and Downloads
Organization: Department of Agriculture
Last updated: 2024-03-30T10:44:27.964599
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_miles_habitat_improv_0282a40e.table_1

447.1 kB
2,032 rows
23 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "region" BIGINT,
  "fs_unit_id" BIGINT,
  "fs_unit_name" VARCHAR,
  "activity_id" VARCHAR,
  "activity_name" VARCHAR,
  "activity_type_class" VARCHAR,
  "activity_type_code" VARCHAR,
  "habitat_improved_name" VARCHAR,
  "habitat_improved_miles" DOUBLE,
  "accomplished_fiscal_year" BIGINT,
  "accomplished_date" TIMESTAMP,
  "completed_fiscal_year" DOUBLE,
  "completed_date" TIMESTAMP,
  "significant_recovery_action" VARCHAR,
  "affected_zone_spatial_id" VARCHAR,
  "activity_cn" VARCHAR,
  "plan_phase_cn" VARCHAR,
  "esa_species_habitat" VARCHAR,
  "habitat_benefit_esa_species" VARCHAR,
  "avg_strm_buffer_width_ft" BIGINT,
  "habitat_benefit_nonesa_species" VARCHAR,
  "shapelen" DOUBLE
);