About this Dataset

Aquatic Organism Passage Surveys (Feature Layer)

This dataset provides USFS Aquatic Organism Passage (AOP) survey data. It shows stream passage locations, passage measurements, and passability assessment categories from AOP field surveys. Structure included: culverts, dams, diversion dams, fords, and natural features such as waterfalls.

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

3.15 MB
30,830 rows
51 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "region" BIGINT,
  "fs_unit_id" BIGINT,
  "fs_unit_name" VARCHAR,
  "passage_survey_year" DOUBLE,
  "passage_survey_start_date" VARCHAR,
  "passage_sample_date" VARCHAR,
  "passage_survey_name" VARCHAR,
  "passage_protocol_name" VARCHAR,
  "passage_sample_name" VARCHAR,
  "passage_type" VARCHAR,
  "passage_material" VARCHAR,
  "passage_functionality" VARCHAR,
  "jump_distance_measured_m" DOUBLE,
  "spill_pool_depth_measured_m" DOUBLE,
  "structure_height_measured_m" DOUBLE,
  "avg_bf_width_measured_m" DOUBLE,
  "avg_bf_width_calc_m" DOUBLE,
  "long_profile_survey_direction" VARCHAR,
  "stream_gradient_above_calc_pct" DOUBLE,
  "inlet_gradient_calc_pct" DOUBLE,
  "culvert_length_calc_m" DOUBLE,
  "culvert_slope_calc_pct" DOUBLE,
  "culvert_slope_calc_decdeg" DOUBLE,
  "exhaustion_coeff" DOUBLE,
  "inlet_resid_depth_m" DOUBLE,
  "jump_distance_calc_m" DOUBLE,
  "jump_height_calc_m" DOUBLE,
  "outlet_drop_calc_m" DOUBLE,
  "spill_pool_depth_calc_m" DOUBLE,
  "spill_pool_resid_depth_calc_m" DOUBLE,
  "stream_gradient_below_calc_pct" DOUBLE,
  "passability_assess_survey_name" VARCHAR,
  "passability_assess_protocol" VARCHAR,
  "last_passability_assess_date" VARCHAR,
  "passability_assess_year" BIGINT,
  "latin_name" VARCHAR,
  "common_name" VARCHAR,
  "life_stage" VARCHAR,
  "passability_assess" VARCHAR,
  "passability_direction_assessed" VARCHAR,
  "passage_survey_cn" VARCHAR,
  "passage_sample_cn" VARCHAR,
  "passage_survey_spatial_id" VARCHAR,
  "passage_smpl_spatial_id" VARCHAR,
  "passability_assess_survey_cn" VARCHAR,
  "passability_assess_local_name" VARCHAR,
  "passage_location_name" VARCHAR,
  "passability_assess_spatial_id" VARCHAR
);