About this Dataset

Rocky Intertidal Ecosystems, California North Coast MPA Baseline Study

The objectives of this baseline study of rocky intertidal habitats along the North Coast Study Region (NCSR) are to (1) produce a quantitative baseline characterization of the structure of rocky intertidal ecosystems in Marine Protected Areas (MPAs) established by the Marine Life Protection Act (MLPA), (2) provide an initial comparison between rocky intertidal ecosystems inside MPAs and nearby associated (unprotected) reference areas, (3) analytically explore baseline characterizations for potential indicators of the state of rocky intertidal ecosystems, (4) generate a fish biodiversity baseline within rocky tide pools at a few sites inside and outside of MPAs (for the first time) as well as (5) examine rockfish recruitment into these tide pools, and (6) integrate these assessments with other components of the baseline survey, including (7) high resolution topographic geological surveys, to inform the role and design of these programs for future monitoring and evaluation of MPAs.
Organization: State of California
Last updated: 2021-09-08T16:17:59.284582
Tags: baseline, biota, california, california-ocean-protection-council, ecological-data, environmental, fish, marine-protected-area, monitoring, motile-invertabrate, mpa, mussel-bed, mussel-plot, north-coast, oceans, phyllospadix, postelsia, rocky-intertidal, sea-star

Tables

MPA Baseline Boundary Information - Lookup Table

@usgov.ca_gov_rocky_intertidal_ecosystems_california_north_co_550d2c52.mpa_baseline_boundary_information_lookup_table

15.68 kB
91 rows
13 columns

CREATE TABLE mpa_baseline_boundary_information_lookup_table (
  "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 Baseline Boundary Information - Lookup Table Metadata

@usgov.ca_gov_rocky_intertidal_ecosystems_california_north_co_550d2c52.mpa_baseline_boundary_information_lookup_table_metadata

4.83 kB
12 rows
2 columns

CREATE TABLE mpa_baseline_boundary_information_lookup_table_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).
);

MPA Baseline Program Information - Lookup Table Metadata

@usgov.ca_gov_rocky_intertidal_ecosystems_california_north_co_550d2c52.mpa_baseline_program_information_lookup_table_metadata

4.62 kB
14 rows
2 columns

CREATE TABLE mpa_baseline_program_information_lookup_table_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
);

Rocky Intertidal - Fish Species List Lookup Table

@usgov.ca_gov_rocky_intertidal_ecosystems_california_north_co_550d2c52.rocky_intertidal_fish_species_list_lookup_table

8.77 kB
37 rows
10 columns

CREATE TABLE rocky_intertidal_fish_species_list_lookup_table (
  "project_short_code" VARCHAR,
  "species" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "specific_epithet" VARCHAR,
  "notes" VARCHAR
);

Rocky Intertidal - Fish Species List Lookup Table Metadata

@usgov.ca_gov_rocky_intertidal_ecosystems_california_north_co_550d2c52.rocky_intertidal_fish_species_list_lookup_table_metadata

6.88 kB
10 rows
7 columns

CREATE TABLE rocky_intertidal_fish_species_list_lookup_table_metadata (
  "attribute" VARCHAR,
  "attribute_definition" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "project_short_code" VARCHAR,
  "table_name" VARCHAR,
  "table_file_format" VARCHAR,
  "table_description" VARCHAR
);

Rocky Intertidal - Site Coordinate Lookup Table

@usgov.ca_gov_rocky_intertidal_ecosystems_california_north_co_550d2c52.rocky_intertidal_site_coordinate_lookup_table

6.36 kB
10 rows
7 columns

CREATE TABLE rocky_intertidal_site_coordinate_lookup_table (
  "project_short_code" VARCHAR,
  "site_name" VARCHAR,
  "siteid" VARCHAR,
  "northsouthorder" BIGINT,
  "lattitude_wgs84_datum" DOUBLE  -- Lattitude (WGS84 Datum),
  "longitude_wgs84_datum" DOUBLE  -- Longitude (WGS84 Datum),
  "mpa_status" VARCHAR
);

Rocky Intertidal - Site Coordinate Lookup Table Metadata

@usgov.ca_gov_rocky_intertidal_ecosystems_california_north_co_550d2c52.rocky_intertidal_site_coordinate_lookup_table_metadata

3.7 kB
6 rows
2 columns

CREATE TABLE rocky_intertidal_site_coordinate_lookup_table_metadata (
  "project_short_code" VARCHAR,
  "the_short_code_designating_the_project_sampling_was_done_under" VARCHAR
);

Rocky Intertidal - Species List Lookup Table

@usgov.ca_gov_rocky_intertidal_ecosystems_california_north_co_550d2c52.rocky_intertidal_species_list_lookup_table

15.94 kB
132 rows
11 columns

CREATE TABLE rocky_intertidal_species_list_lookup_table (
  "project_short_code" VARCHAR,
  "species_group" VARCHAR,
  "n_6_letter_code" VARCHAR  -- 6 Letter Code,
  "kingdom" VARCHAR,
  "phylum_or_division" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "notes" VARCHAR
);

Rocky Intertidal - Species List Lookup Table Metadata

@usgov.ca_gov_rocky_intertidal_ecosystems_california_north_co_550d2c52.rocky_intertidal_species_list_lookup_table_metadata

7.42 kB
11 rows
7 columns

CREATE TABLE rocky_intertidal_species_list_lookup_table_metadata (
  "attribute" VARCHAR,
  "attribute_explanation" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "project_short_code" VARCHAR,
  "table_name" VARCHAR,
  "table_file_format" VARCHAR,
  "table_description" VARCHAR
);