About this Dataset

Characterization Of Nearshore Fish Communities Associated With Rocky Reef Habitats, California North Coast MPA Baseline Study, 2014 To 2015

To characterize the fish communities associated with nearshore rocky reef habitat, we collaborated with commercial passenger fishing vessel (CPFV) captains and volunteer anglers to conduct hook-and-line surveys in four pairs of MPA and reference sites. Sampling was conducted with scientific crews of six: four anglers, a sampler who handled, measured, and tagged fish, and a data recorder. Each of the four anglers used a different combination of baited or un-baited lures that represented gear frequently used by recreational anglers to catch the target species. Sites were sampled by fishing for 45 minutes in each of four, 500 meter by 500 meter sampling cells, which were randomly selected from a set of cells that covered bottom areas containing at least 20 percent rocky reef habitat, by area. Captains were directed to drift within the cells over areas of rocky habitat for a maximum of 15 minutes per drift, so that at least three areas of habitat within each cell would be sampled. Captured fish were identified to species, measured to the nearest millimeter in fork length, tagged with an external t-bar anchor tag, and returned to the water, using a descending device if needed. Each site was sampled five times, three from June-October 2014, and twice from May-August 2015.
Organization: State of California
Last updated: 2021-09-08T16:17:51.467981
Tags: 2014, 2015, baseline, biota, california, california-ocean-protection-council, commercial-fishing-passenger-vessel, cpfv, ecological-data, environmental, fishing, hook-and-line, marine-protected-area, monitoring, mpa, north-coast, oceans, rocky-reefs

Tables

MPA Baseline Program Information - North Coast - Metadata

@usgov.ca_gov_characterization_of_nearshore_fish_communities__caea38fe.mpa_baseline_program_information_north_coast_metadata

4.62 kB
14 rows
2 columns

CREATE TABLE mpa_baseline_program_information_north_coast_metadata (
  "nc_mpa_baselineprograminformation_lookuptable_csv" VARCHAR,
  "lookup_containing_a_list_of_north_coast_sc_marine_prot_f4f7dfc5" VARCHAR  -- Lookup Table Containing A List Of North Coast (SC) Marine Protected Area (MPA) Baseline Program Projects And Associated Information
);

MPA Boundary Details - North Coast

@usgov.ca_gov_characterization_of_nearshore_fish_communities__caea38fe.mpa_boundary_details_north_coast

15.68 kB
91 rows
13 columns

CREATE TABLE mpa_boundary_details_north_coast (
  "mpa_name" VARCHAR,
  "mpa_designation" VARCHAR,
  "mpa_study_region" VARCHAR,
  "subsection" BIGINT,
  "pretext" VARCHAR,
  "coordinate" VARCHAR,
  "posttext" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "latddm" VARCHAR,
  "longddm" VARCHAR,
  "sortorder" BIGINT,
  "positionid" VARCHAR
);

MPA Boundary Details - North Coast - Metadata

@usgov.ca_gov_characterization_of_nearshore_fish_communities__caea38fe.mpa_boundary_details_north_coast_metadata

4.83 kB
12 rows
2 columns

CREATE TABLE mpa_boundary_details_north_coast_metadata (
  "mpa_name" VARCHAR,
  "the_name_of_the_california_marine_protected_area_descr_043f4de7" VARCHAR  -- The Name Of The California Marine Protected Area Described By The Associated Boundary Coordinates. Name Of The MPA As Identified By The California Department Of Fish And Wildlife (CDFW).
);

NC NearFish SurveyData 2014–2015

@usgov.ca_gov_characterization_of_nearshore_fish_communities__caea38fe.nc_nearfish_surveydata_2014_2015

47.72 kB
4,239 rows
16 columns

CREATE TABLE nc_nearfish_surveydata_2014_2015 (
  "project_short_code" VARCHAR,
  "year" DOUBLE,
  "month" DOUBLE,
  "day" DOUBLE,
  "port" VARCHAR,
  "site" VARCHAR,
  "protected_status" VARCHAR,
  "cell" DOUBLE,
  "species" VARCHAR,
  "gear_code" VARCHAR,
  "fork_length_mm" DOUBLE,
  "tag" DOUBLE,
  "condition_1" DOUBLE,
  "condition_2" DOUBLE,
  "condition_3" DOUBLE,
  "condition_4" DOUBLE
);

NC NearFish SurveyData 2014–2015 Metadata

@usgov.ca_gov_characterization_of_nearshore_fish_communities__caea38fe.nc_nearfish_surveydata_2014_2015_metadata

16.93 kB
12 rows
17 columns

CREATE TABLE nc_nearfish_surveydata_2014_2015_metadata (
  "table_name_nc_nearfish_surveydata_2014_2015_csv" VARCHAR  -- Table Name: NC NearFish SurveyData 2014–2015.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

Site Lookup Table

@usgov.ca_gov_characterization_of_nearshore_fish_communities__caea38fe.site_lookup_table

13.16 kB
32 rows
15 columns

CREATE TABLE site_lookup_table (
  "project_short_code" VARCHAR,
  "cell" BIGINT,
  "port" VARCHAR,
  "site" VARCHAR,
  "protected_status" VARCHAR,
  "county" VARCHAR,
  "state_country" VARCHAR,
  "nw_lat" DOUBLE,
  "nw_lon" DOUBLE,
  "ne_lat" DOUBLE,
  "ne_lon" DOUBLE,
  "se_lat" DOUBLE,
  "se_lon" DOUBLE,
  "sw_lat" DOUBLE,
  "sw_lon" DOUBLE
);

Site Lookup Table - Metadata

@usgov.ca_gov_characterization_of_nearshore_fish_communities__caea38fe.site_lookup_table_metadata

14.17 kB
12 rows
16 columns

CREATE TABLE site_lookup_table_metadata (
  "table_name_nc_nearfish_site_lookup_table_csv" VARCHAR  -- Table Name: NC NearFish Site Lookup Table.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

Species Lookup Table

@usgov.ca_gov_characterization_of_nearshore_fish_communities__caea38fe.species_lookup_table

7.53 kB
23 rows
9 columns

CREATE TABLE species_lookup_table (
  "project_short_code" VARCHAR,
  "common_name" VARCHAR,
  "kingdom" VARCHAR,
  "phylum_division" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR
);

Species Lookup Table - Metadata

@usgov.ca_gov_characterization_of_nearshore_fish_communities__caea38fe.species_lookup_table_metadata

9.34 kB
12 rows
10 columns

CREATE TABLE species_lookup_table_metadata (
  "table_name_nc_nearfish_organism_lookup_table_csv" VARCHAR  -- Table Name: NC NearFish Organism Lookup Table.csv,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);