About this Dataset

Citizen Scientist Monitoring Of Rocky Reefs And Kelp Forests, California North Coast MPA Baseline Study, 2014 To 2016

RCCA volunteer citizen scientists conducted 18 visual scuba transects at each monitoring site to survey densities and sizes of ecologically and economically important fish, invertebrate and algal species and to characterize the physical habitats. Transects were 30-meters long and 2-meters wide swaths above the rocky reef substrate. Divers counted and sized key species of fish (35 species), counted invertebrates (33 species) and algae (9 species), and estimated the percent cover of substrate types and vertical relief of the seafloor. Over the baseline monitoring of 2014-2015, RCCA conducted 18 surveys at eight monitoring sites in the NCSR. Three of these sites have been surveyed since 2007. The data from these surveys were analyzed at multiple scales to provide baseline characterization of the kelp forest ecosystems at the time of MPA implementation. We characterized the biological community at the RCCA monitoring sites by summarizing the physical and biological characteristics of each of the sites. These summaries will serve as a reference point in the future as long-term monitoring continues.
Organization: State of California
Last updated: 2021-09-08T16:17:46.341709
Tags: algae, baseline, biota, california, california-ocean-protection-council, ecological-data, environmental, fishes, invertebrates, kelp-forest, marine-protected-area, monitoring, mpa, north-coast, oceans, rocky-reef

Tables

Fish Survey - Data Table 2014 - 2015

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.fish_survey_data_table_2014_2015

24.47 kB
9,260 rows
15 columns

CREATE TABLE fish_survey_data_table_2014_2015 (
  "nc_project_short_code" VARCHAR,
  "site" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "transectnumber" BIGINT,
  "classcode" VARCHAR,
  "sex" VARCHAR,
  "amount" DOUBLE,
  "size_cm" DOUBLE,
  "size_min_cm" DOUBLE,
  "size_max_cm" DOUBLE,
  "depth_m" DOUBLE,
  "visibility" DOUBLE,
  "temp10m" BIGINT
);

Fish Survey - Data Table 2014 - 2015 - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.fish_survey_data_table_2014_2015_metadata

5.62 kB
21 rows
3 columns

CREATE TABLE fish_survey_data_table_2014_2015_metadata (
  "table_name_nc_rcca_fish_data_table" VARCHAR  -- Table Name: NC RCCA Fish Data Table,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2
);

Fish Survey - Fish Species Lookup Table

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.fish_survey_fish_species_lookup_table

7.92 kB
34 rows
9 columns

CREATE TABLE fish_survey_fish_species_lookup_table (
  "nc_project_short_code" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "classcode" VARCHAR
);

Fish Survey - Fish Species Lookup Table - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.fish_survey_fish_species_lookup_table_metadata

5.15 kB
15 rows
3 columns

CREATE TABLE fish_survey_fish_species_lookup_table_metadata (
  "table_name_nc_rcca_fish_species_lookup_table" VARCHAR  -- Table Name: NC RCCA Fish Species Lookup Table,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2
);

Invertebrate Survey - Abalone Sizes 2014 - 2015

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.invertebrate_survey_abalone_sizes_2014_2015

10.99 kB
2,322 rows
11 columns

CREATE TABLE invertebrate_survey_abalone_sizes_2014_2015 (
  "nc_project_short_code" VARCHAR,
  "site" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "transectnumber" BIGINT,
  "species" VARCHAR,
  "size" BIGINT,
  "depth_m" DOUBLE,
  "visibility" DOUBLE,
  "temp10m" BIGINT
);

Invertebrate Survey - Abalone Sizes 2014 - 2015 - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.invertebrate_survey_abalone_sizes_2014_2015_metadata

5.31 kB
17 rows
3 columns

CREATE TABLE invertebrate_survey_abalone_sizes_2014_2015_metadata (
  "table_name_nc_rcca_abalone_sizes_data_table" VARCHAR  -- Table Name: NC RCCA Abalone Sizes Data Table,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2
);

Invertebrate Survey - Data Table 2014 - 2015

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.invertebrate_survey_data_table_2014_2015

12.43 kB
2,352 rows
12 columns

CREATE TABLE invertebrate_survey_data_table_2014_2015 (
  "nc_project_short_code" VARCHAR,
  "site" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "transectnumber" BIGINT,
  "classcode" VARCHAR,
  "amount" BIGINT,
  "distance" BIGINT,
  "depth_m" DOUBLE,
  "visibility" DOUBLE,
  "temp10m" BIGINT
);

Invertebrate Survey - Data Table 2014 - 2015 - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.invertebrate_survey_data_table_2014_2015_metadata

5.5 kB
18 rows
3 columns

CREATE TABLE invertebrate_survey_data_table_2014_2015_metadata (
  "table_name_nc_rcca_invertebrate_data_table" VARCHAR  -- Table Name: NC RCCA Invertebrate Data Table,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2
);

Invertebrate Survey - Species Lookup Table

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.invertebrate_survey_species_lookup_table

8.19 kB
27 rows
9 columns

CREATE TABLE invertebrate_survey_species_lookup_table (
  "nc_project_short_code" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "classcode" VARCHAR
);

Invertebrate Survey - Species Lookup Table - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.invertebrate_survey_species_lookup_table_metadata

5.27 kB
15 rows
3 columns

CREATE TABLE invertebrate_survey_species_lookup_table_metadata (
  "table_name_nc_rcca_invertebrate_species_lookup_table" VARCHAR  -- Table Name: NC RCCA Invertebrate Species Lookup Table,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2
);

MPA Baseline Program Information - North Coast - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.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_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.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_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.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).
);

Site Lookup Table

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.site_lookup_table

4.83 kB
8 rows
5 columns

CREATE TABLE site_lookup_table (
  "nc_project_short_code" VARCHAR,
  "site" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "mpa" VARCHAR
);

Site Lookup Table - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.site_lookup_table_metadata

4.28 kB
11 rows
3 columns

CREATE TABLE site_lookup_table_metadata (
  "table_name_nc_rcca_site_lookup_table" VARCHAR  -- Table Name: NC RCCA Site Lookup Table,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2
);

Uniform Point Contact - Data Table 2014 - 2015

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.uniform_point_contact_data_table_2014_2015

11.48 kB
1,596 rows
12 columns

CREATE TABLE uniform_point_contact_data_table_2014_2015 (
  "nc_project_short_code" VARCHAR,
  "site" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "transectnumber" BIGINT,
  "category" VARCHAR,
  "classcode" VARCHAR,
  "amount" BIGINT,
  "depth_m" DOUBLE,
  "visibility" DOUBLE,
  "temp10m" BIGINT
);

Uniform Point Contact - Data Table 2014 - 2015 - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.uniform_point_contact_data_table_2014_2015_metadata

5.36 kB
18 rows
3 columns

CREATE TABLE uniform_point_contact_data_table_2014_2015_metadata (
  "table_name_nc_rcca_upc_data_table" VARCHAR  -- Table Name: NC RCCA UPC Data Table,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2
);

Uniform Point Contact - Lookup Table

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.uniform_point_contact_lookup_table

8.28 kB
19 rows
9 columns

CREATE TABLE uniform_point_contact_lookup_table (
  "nc_project_short_code" VARCHAR,
  "classcode" VARCHAR,
  "category" VARCHAR,
  "definition" VARCHAR,
  "kingdom" VARCHAR,
  "phylum_division" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

Uniform Point Contact - Lookup Table - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a738febe.uniform_point_contact_lookup_table_metadata

4.74 kB
10 rows
3 columns

CREATE TABLE uniform_point_contact_lookup_table_metadata (
  "table_name_nc_rcca_upc_lookup_table" VARCHAR  -- Table Name: NC RCCA UPC Lookup Table,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2
);