Citizen Scientist Monitoring Of Rocky Reefs And Kelp Forests, California South Coast MPA Baseline Study, 2011 To 2012 by US Government | Academic Research

About this Dataset

Citizen Scientist Monitoring Of Rocky Reefs And Kelp Forests, California South Coast MPA Baseline Study, 2011 To 2012

Reef Check California has surveyed rocky reefs and kelp forests in southern California since 2006 and has up to nine years of data from the MLPA South Coast Study Region (SCSR). The goal of this baseline monitoring project is to quantify key attributes of species, populations, communities and habitat variables that constitute representative kelp forest ecosystems within and outside of many of the MPAs in the South Coast Study Region. The sampling design, selected response variables (i.e. key species) and analytical approaches are intended to provide scientists, managers, stakeholders and policymakers with a baseline for future assessment of the effectiveness of the SCSR MPAs. Further, the outcomes from this study will also provide recommendations for long-term monitoring metrics and cost-effective survey protocols for the SCSR. Specific objectives are:

Provide a quantitative baseline characterization of the rocky reef and kelp forest ecosystem feature inside and outside of MPAs in the SCSR.
Provide pre-MPA implementation data and historical context to ongoing data collection by analyzing RCCA’s existing dataset in the context of the new MPAs.
Explore the baseline characterizations for potential indicators of the state of the kelp forest ecosystem (i.e. ecosystem indicators) and make recommendations for long-term monitoring.
Build capacity for cost-effective, long-term MPA monitoring through the continued involvement of community members in the monitoring of MPAs.
Expand existing public online data dissemination and illustration tool (NED) to inform managers, stakeholders, policymakers and the public about the status of the marine environment in the SCSR.
Organization: State of California
Last updated: 2021-09-08T16:17:46.053738
Tags: 2011, 2012, algae, baseline, biota, california, california-ocean-protection-council, citizen-science, ecological-data, environmental, fishes, invertebrates, kelp-forest, marine-protected-area, monitoring, mpa, oceans, rocky-reef, south-coast

Tables

MPA Baseline Program Information - North Coast

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.mpa_baseline_program_information_north_coast

22.55 KB
10 rows
13 columns


CREATE TABLE mpa_baseline_program_information_north_coast (
  "sc_project_short_code" VARCHAR,
  "sc_project_title" VARCHAR,
  "consumptive" BIGINT,
  "nonconsumptive" BIGINT,
  "deep" BIGINT,
  "estuarinewetland" BIGINT,
  "kelpshallowrock" BIGINT,
  "middepthrock" BIGINT,
  "nearshorepelagic" BIGINT,
  "rockyintertidal" BIGINT,
  "softintertidal" BIGINT,
  "softsubtidal" BIGINT,
  "sc_project_description" VARCHAR
);

MPA Baseline Program Information - North Coast - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.mpa_baseline_program_information_north_coast_metadata

4.44 KB
13 rows
2 columns


CREATE TABLE mpa_baseline_program_information_north_coast_metadata (
  "sc_mpa_baselineprograminformation_lookuptable_csv" VARCHAR,
  "lookup_containing_a_list_of_south_coast_sc_marine_prot_fadf387a" VARCHAR
);

MPA Boundary Details - North Coast

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.mpa_boundary_details_north_coast

22.1 KB
204 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,
  "longddm" VARCHAR,
  "latddm" VARCHAR,
  "sortorder" BIGINT,
  "positionid" VARCHAR
);

MPA Boundary Details - North Coast - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.mpa_boundary_details_north_coast_metadata

5.09 KB
13 rows
2 columns


CREATE TABLE mpa_boundary_details_north_coast_metadata (
  "sc_mpa_boundaryinformation_lookuptable_csv" VARCHAR,
  "lookup_containing_a_list_of_south_coast_sc_marine_prot_4102ddf0" VARCHAR
);

Survey Sites Lookup Table

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.survey_sites_lookup_table

6.02 KB
46 rows
5 columns


CREATE TABLE survey_sites_lookup_table (
  "project_short_code" VARCHAR,
  "site" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "mpa_name" VARCHAR
);

Survey Sites Lookup Table - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.survey_sites_lookup_table_metadata

4.18 KB
11 rows
3 columns


CREATE TABLE survey_sites_lookup_table_metadata (
  "table_name_sc_rcca_site_lookup_table" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR
);

Algae Survey - Data Table 2011-2012

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.algae_survey_data_table_2011_2012

37.87 KB
7439 rows
16 columns


CREATE TABLE algae_survey_data_table_2011_2012 (
  "sc_project_short_code" VARCHAR,
  "site" VARCHAR,
  "newsurvey" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "transectnumber" BIGINT,
  "classcode" VARCHAR,
  "amount" DOUBLE,
  "stipes" DOUBLE,
  "distance" DOUBLE,
  "visibility" DOUBLE,
  "depthstart_m" DOUBLE,
  "depthend_m" DOUBLE,
  "timestart" VARCHAR,
  "timeend" VARCHAR
);

Algae Survey - Data Table 2011-2012 - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.algae_survey_data_table_2011_2012_metadata

5.67 KB
22 rows
3 columns


CREATE TABLE algae_survey_data_table_2011_2012_metadata (
  "table_name_sc_rcca_fish_data_table" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR
);

Algae Survey - Species Lookup Table

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.algae_survey_species_lookup_table

6.65 KB
5 rows
9 columns


CREATE TABLE algae_survey_species_lookup_table (
  "sc_project_short_code" VARCHAR,
  "kingdom" VARCHAR,
  "division" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "classcode" VARCHAR
);

Algae Survey - Species Lookup Table - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.algae_survey_species_lookup_table_metadata

5.06 KB
15 rows
3 columns


CREATE TABLE algae_survey_species_lookup_table_metadata (
  "table_name_sc_rcca_algae_species_lookup_table" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR
);

Fish Survey - Data Table 2011-2012

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.fish_survey_data_table_2011_2012

97.22 KB
199521 rows
15 columns


CREATE TABLE fish_survey_data_table_2011_2012 (
  "sc_project_short_code" VARCHAR,
  "site" VARCHAR,
  "newsurvey" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "transectnumber" BIGINT,
  "classcode" VARCHAR,
  "size" VARCHAR,
  "amount" DOUBLE,
  "visibility" DOUBLE,
  "depthstart_m" DOUBLE,
  "depthend_m" DOUBLE,
  "timestart" VARCHAR,
  "timeend" VARCHAR
);

Fish Survey - Data Table 2011-2012 - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.fish_survey_data_table_2011_2012_metadata

5.49 KB
21 rows
3 columns


CREATE TABLE fish_survey_data_table_2011_2012_metadata (
  "table_name_sc_rcca_fish_data_table" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR
);

Fish Survey - Fish Species Lookup Table

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.fish_survey_fish_species_lookup_table

7.79 KB
42 rows
9 columns


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

Fish Survey - Fish Species Lookup Table - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.fish_survey_fish_species_lookup_table_metadata

5.05 KB
15 rows
3 columns


CREATE TABLE fish_survey_fish_species_lookup_table_metadata (
  "table_name_sc_rcca_fish_species_lookup_table" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR
);

Invertebrate Survey - Data Table 2011-2012

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.invertebrate_survey_data_table_2011_2012

38.45 KB
15176 rows
15 columns


CREATE TABLE invertebrate_survey_data_table_2011_2012 (
  "sc_project_short_code" VARCHAR,
  "site" VARCHAR,
  "newsurvey" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "transectnumber" BIGINT,
  "classcode" VARCHAR,
  "amount" DOUBLE,
  "distance" DOUBLE,
  "visibility" DOUBLE,
  "depthstart_m" DOUBLE,
  "depthend_m" DOUBLE,
  "timestart" VARCHAR,
  "timeend" VARCHAR
);

Invertebrate Survey - Data Table 2011-2012 - Metatdata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.invertebrate_survey_data_table_2011_2012_metatdata

5.49 KB
21 rows
3 columns


CREATE TABLE invertebrate_survey_data_table_2011_2012_metatdata (
  "table_name_sc_rcca_invertebrate_data_table" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR
);

Invertebrate Survey - Species Lookup Table

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.invertebrate_survey_species_lookup_table

8 KB
27 rows
9 columns


CREATE TABLE invertebrate_survey_species_lookup_table (
  "sc_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_a80d9b5a.invertebrate_survey_species_lookup_table_metadata

5.17 KB
15 rows
3 columns


CREATE TABLE invertebrate_survey_species_lookup_table_metadata (
  "table_name_sc_rcca_invertebrate_species_lookup_table" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR
);

Uniform Point Contact - Data Table 2011-2012

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.uniform_point_contact_data_table_2011_2012

33.55 KB
10286 rows
15 columns


CREATE TABLE uniform_point_contact_data_table_2011_2012 (
  "sc_project_short_code" VARCHAR,
  "site" VARCHAR,
  "newsurvey" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "transectnumber" BIGINT,
  "category" VARCHAR,
  "classcode" VARCHAR,
  "amount" DOUBLE,
  "visibility" DOUBLE,
  "depthstart_m" DOUBLE,
  "depthend_m" DOUBLE,
  "timestart" VARCHAR,
  "timeend" VARCHAR
);

Uniform Point Contact - Data Table 2011-2012 - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.uniform_point_contact_data_table_2011_2012_metadata

5.59 KB
22 rows
3 columns


CREATE TABLE uniform_point_contact_data_table_2011_2012_metadata (
  "table_name_sc_rcca_upc_data_table" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR
);

Uniform Point Contact - Lookup Table

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.uniform_point_contact_lookup_table

5.16 KB
19 rows
4 columns


CREATE TABLE uniform_point_contact_lookup_table (
  "sc_project_short_code" VARCHAR,
  "classcode" VARCHAR,
  "category" VARCHAR,
  "definition" VARCHAR
);

Uniform Point Contact - Lookup Table - Metadata

@usgov.ca_gov_citizen_scientist_monitoring_of_rocky_reefs_and_a80d9b5a.uniform_point_contact_lookup_table_metadata

4.7 KB
10 rows
3 columns


CREATE TABLE uniform_point_contact_lookup_table_metadata (
  "table_name_sc_rcca_upc_lookup_table" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR
);