About this Dataset

2023 Three-Pass Depletion Fish Census Surveys

These data represent fish census surveys in Great Smoky Mountains National Park conducted using the Delury Method of Three-Pass Depletion electrofishing. In 2023, fish were collected, sorted by species, and weighed at 34 unique sites from a total of 21 streams ranging in size from first to third-order waterways. These streams are surveyed on an annual basis to monitor population trends over time.
Organization: Department of the Interior
Last updated: 2025-09-14T21:03:22.816921
Tags: 3-pass-depletion, electrofishing, fish-census, fish-surveys, fisheries, three-pass

Tables

Onion Bed Branch - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.onion_bed_branch_2023_yoy

4.75 kB
20 rows
5 columns

CREATE TABLE onion_bed_branch_2023_yoy (
  "onion_bed_branch_2023_yoy_site1_1" BIGINT  -- Onion Bed Branch - 2023 - YOY - Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Porters Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.porters_creek_2023_adult

4.86 kB
25 rows
5 columns

CREATE TABLE porters_creek_2023_adult (
  "porters_creek_2023_adult_site1_2" BIGINT  -- Porters Creek - 2023 - Adult - Site1=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Porters Creek - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.porters_creek_2023_total

5.22 kB
85 rows
5 columns

CREATE TABLE porters_creek_2023_total (
  "porters_creek_2023_total_site1_2" BIGINT  -- Porters Creek - 2023 - Total Site1=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Porters Creek - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.porters_creek_2023_yoy

4.91 kB
60 rows
5 columns

CREATE TABLE porters_creek_2023_yoy (
  "porters_creek_2023_yoy_site1_2" BIGINT  -- Porters Creek - 2023 - YOY - Site1=2,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Pretty Hollow Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.pretty_hollow_creek_2023_adult

5.21 kB
63 rows
5 columns

CREATE TABLE pretty_hollow_creek_2023_adult (
  "pretty_hollow_creek_2023_adult_site1_1" BIGINT  -- Pretty Hollow Creek - 2023 - Adult - Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Pretty Hollow Creek - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.pretty_hollow_creek_2023_total

5.54 kB
105 rows
5 columns

CREATE TABLE pretty_hollow_creek_2023_total (
  "pretty_hollow_creek_2023_total_site1_1" BIGINT  -- Pretty Hollow Creek - 2023 - Total - Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Pretty Hollow Creek - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.pretty_hollow_creek_2023_yoy

4.94 kB
42 rows
5 columns

CREATE TABLE pretty_hollow_creek_2023_yoy (
  "pretty_hollow_creek_2023_yoy_site1_1" BIGINT  -- Pretty Hollow Creek - 2023 - YOY - Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Rock Creek - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.rock_creek_2023_adult

4.87 kB
21 rows
5 columns

CREATE TABLE rock_creek_2023_adult (
  "rock_creek_2023_adult_site1_3_site2_7" BIGINT  -- Rock Creek - 2023 - Adult - Site1=3 Site2=7,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Rock Creek - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.rock_creek_2023_total

6.56 kB
90 rows
7 columns

CREATE TABLE rock_creek_2023_total (
  "rock_creek_2023_total_site1_3_site2_7" BIGINT  -- Rock Creek - 2023 - Total - Site1=3 Site2=7,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" DOUBLE  -- Unnamed: 5,
  "unnamed_6" DOUBLE  -- Unnamed: 6
);

Rock Creek - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.rock_creek_2023_yoy

4.95 kB
60 rows
5 columns

CREATE TABLE rock_creek_2023_yoy (
  "rock_creek_2023_yoy_site1_3_site2_7" BIGINT  -- Rock Creek - 2023 - YOY - Site1=3 Site2=7,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Rough Fork - 2023 - Adult

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.rough_fork_2023_adult

5.15 kB
59 rows
5 columns

CREATE TABLE rough_fork_2023_adult (
  "rough_fork_2023_adult_site1_1" BIGINT  -- Rough Fork - 2023 - Adult - Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);

Rough Fork - 2023 - Total

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.rough_fork_2023_total

6.84 kB
118 rows
7 columns

CREATE TABLE rough_fork_2023_total (
  "rough_fork_2023_total_site1_1" BIGINT  -- Rough Fork - 2023 - Total - Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" DOUBLE  -- Unnamed: 5,
  "unnamed_6" DOUBLE  -- Unnamed: 6
);

Rough Fork - 2023 - YOY

@usgov.doi_gov_2023_three_pass_depletion_fish_census_surveys.rough_fork_2023_yoy

4.94 kB
56 rows
5 columns

CREATE TABLE rough_fork_2023_yoy (
  "rough_fork_2023_yoy_site1_1" BIGINT  -- Rough Fork - 2023 - YOY - Site1=1,
  "unnamed_1" BIGINT  -- Unnamed: 1,
  "unnamed_2" BIGINT  -- Unnamed: 2,
  "unnamed_3" BIGINT  -- Unnamed: 3,
  "unnamed_4" DOUBLE  -- Unnamed: 4
);