About this Dataset

Characterization Of Sandy Beaches And Adjacent Surf Zones, California North Coast MPA Baseline Study, 2014 To 2015

We combined taxonomically detailed surveys of macroinvertebrates and birds with targeted sampling of regionally important focal taxa including surf zone fishes, kelp and sand crabs; physical and biological metrics of the habitat; and activities of people on the beaches to develop an integrated understanding of the important ecosystem processes structuring northern California beaches. Our baseline study program consisted of the following components:

Nine monthly surveys (from September 2014 through May 2015) of birds, macrophyte wrack (detached marine vegetation such as seaweeds, surfgrasses and seagrasses that are deposited on the beach), human use and physical characteristics of 12 sandy beaches and their adjacent surf zones (6 MPA and 6 reference sites);

A one-time, comprehensive survey of intertidal invertebrate biodiversity during summer 2014 of the 12 focal sandy beaches;

A comprehensive baseline survey of redtail surfperch (Amphistichus rhodoterus), including diet analysis, at nine sandy beaches (4 MPA, 5 reference sites) over two years;

Targeted monthly surveys of sand crabs (Emerita analoga) done concurrently with redtail surfperch surveys on three long beaches for three months; and

Sampling of night smelt (Spirinchus starksi) spawning aggregations from nine beaches (5 MPA, 4 reference) during spring and summer over two years.
Organization: State of California
Last updated: 2021-09-08T16:18:00.930952
Tags: 2014, 2015, baseline, beaches, biota, california, california-ocean-protection-council, ecological-data, environmental, marine-protected-area, monitoring, mpa, north-coast, oceans, surf-zones

Tables

MPA Baseline Program Information - North Coast - Metadata

@usgov.ca_gov_characterization_of_sandy_beaches_and_adjacent__b5f41859.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_sandy_beaches_and_adjacent__b5f41859.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_sandy_beaches_and_adjacent__b5f41859.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).
);

Sand Crab Size - Data

@usgov.ca_gov_characterization_of_sandy_beaches_and_adjacent__b5f41859.sand_crab_size_data

9.99 kB
9 rows
13 columns

CREATE TABLE sand_crab_size_data (
  "nc_project_short_code" VARCHAR,
  "site" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "transect" VARCHAR,
  "no_crabs_sml_10mm" BIGINT  -- No Crabs Sml <10mm,
  "no_crabs_med_10_15mm" BIGINT,
  "no_crabs_lrg_15mm" BIGINT  -- No Crabs Lrg >15mm,
  "no_crabs_tot" BIGINT,
  "core_spacing" DOUBLE,
  "cores_per_transect" BIGINT,
  "core_area" DOUBLE
);

Sand Crab Size - Data - Metadata

@usgov.ca_gov_characterization_of_sandy_beaches_and_adjacent__b5f41859.sand_crab_size_data_metadata

12.15 kB
11 rows
14 columns

CREATE TABLE sand_crab_size_data_metadata (
  "table_name" VARCHAR  -- Table Name:,
  "nc_sandcrab_mpa_crab_size_csv" VARCHAR,
  "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
);

Sand Crab Weight And Length - Data

@usgov.ca_gov_characterization_of_sandy_beaches_and_adjacent__b5f41859.sand_crab_weight_and_length_data

3.94 kB
77 rows
3 columns

CREATE TABLE sand_crab_weight_and_length_data (
  "nc_project_short_code" VARCHAR,
  "length_mm" DOUBLE  -- Length (mm),
  "weight_g" DOUBLE  -- Weight (g)
);

Sand Crab Weight And Length - Data - Metadata

@usgov.ca_gov_characterization_of_sandy_beaches_and_adjacent__b5f41859.sand_crab_weight_and_length_data_metadata

4.42 kB
11 rows
4 columns

CREATE TABLE sand_crab_weight_and_length_data_metadata (
  "table_name" VARCHAR  -- Table Name:,
  "nc_sandcrab_weightlength_data_csv" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3
);

Sand Profile - Data Table

@usgov.ca_gov_characterization_of_sandy_beaches_and_adjacent__b5f41859.sand_profile_data_table

7.73 kB
8 rows
10 columns

CREATE TABLE sand_profile_data_table (
  "nc_project_short_code" VARCHAR,
  "site" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "pcchange" DOUBLE,
  "g_mean" DOUBLE,
  "g_sort" DOUBLE,
  "g_skew" DOUBLE,
  "g_kurt" DOUBLE
);

Sand Profile - Data Table - Metadata

@usgov.ca_gov_characterization_of_sandy_beaches_and_adjacent__b5f41859.sand_profile_data_table_metadata

9.9 kB
11 rows
11 columns

CREATE TABLE sand_profile_data_table_metadata (
  "table_name" VARCHAR  -- Table Name:,
  "nc_sandcrab_sand_csv" VARCHAR,
  "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
);

Surf Perch Diet - Data

@usgov.ca_gov_characterization_of_sandy_beaches_and_adjacent__b5f41859.surf_perch_diet_data

14.68 kB
490 rows
11 columns

CREATE TABLE surf_perch_diet_data (
  "nc_project_short_code" VARCHAR,
  "species" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "site" VARCHAR,
  "sl_mm" DOUBLE  -- SL (mm),
  "idnum" BIGINT,
  "tax1" VARCHAR,
  "numperfish" BIGINT,
  "wtperfish_g" DOUBLE  -- WTPERFISH (g)
);

Surf Perch Diet - Data - Metadata

@usgov.ca_gov_characterization_of_sandy_beaches_and_adjacent__b5f41859.surf_perch_diet_data_metadata

10.24 kB
12 rows
12 columns

CREATE TABLE surf_perch_diet_data_metadata (
  "project_short_code" VARCHAR  -- Project Short Code:,
  "nc_sbeach" VARCHAR,
  "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
);