About this Dataset

California Spiny Lobster (Panulirus Interruptus), California South Coast MPA Baseline Study, 2012 To 2013

The South Coast Lobster Research Group (SCLRG) was formed in 2011 in response to interest in how MPAs may affect the abundance, size, and behavior of the California spiny lobster (Panulirus interruptus). The SCLRG is a partnership between scientists, managers, stakeholders, and volunteers, and encompasses personnel from the San Diego State University (SDSU), Scripps Institution of Oceanography (SIO), the San Diego Oceans Foundation (SDOF), the California Department of Fish and Wildlife (CDFW), and the California Lobster Trap Fishermen’s Association (CLTFA). We identified five sites in the South Coast Region at which to work, each with a newly established MPA: (1) the Cabrillo SMR in San Diego, (2) the South La Jolla SMR in La Jolla, (3) Swami’s SMCA in Encinitas, (4) the Laguna Beach SMR in Laguna Beach, and (5) the Pt. Vicente SMCA in Palos Verdes. Inside and outside of MPAs at each site, we conducted daytime SCUBA-based transect surveys of rocky reefs (5 – 15 m depth) between May and September of 2012 and 2013. The number of lobsters in four different size categories, as well depth, relief, and benthic habitat features (biogenic and non-biogenic) were recorded on each transect.
Organization: State of California
Last updated: 2021-09-08T16:19:24.673260
Tags: 2012, 2013, algae, baseline, biota, california, california-ocean-protection-council, citizen-science, collaborative-fisheries, ecological-data, environmental, habitat, invertebrates, local-knowledge, marine-protected-area, monitoring, mpa, oceans, panulirus-interuptus, south-coast, spiny-lobster

Tables

Mark And Recapture - Spiny Lobster Site Location Data

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.mark_and_recapture_spiny_lobster_site_location_data

11.69 kB
9 rows
12 columns

CREATE TABLE mark_and_recapture_spiny_lobster_site_location_data (
  "project_short_code_sc_lobster" VARCHAR  -- Project Short Code: SC Lobster,
  "site" VARCHAR,
  "cabrillo_state_marine_reserve" VARCHAR,
  "cabrillo_state_marine_reserve_1" VARCHAR,
  "south_la_jolla_state_marine_reserve" VARCHAR,
  "south_la_jolla_state_marine_reserve_1" VARCHAR,
  "swami_s_state_marine_conservation_area" VARCHAR,
  "swami_s_state_marine_conservation_area_1" VARCHAR,
  "laguna_beach_state_marine_reserve" VARCHAR,
  "laguna_beach_state_marine_reserve_1" VARCHAR,
  "point_vicente_state_marine_conservation_area" VARCHAR,
  "point_vicente_state_marine_conservation_area_1" VARCHAR
);

Mark And Recapture - Spiny Lobster Site Location Data - Metadata

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.mark_and_recapture_spiny_lobster_site_location_metadata

4.06 kB
15 rows
2 columns

CREATE TABLE mark_and_recapture_spiny_lobster_site_location_metadata (
  "n__name_spiny_lobster_site_location_lookup_table_for_t_34d727ab" VARCHAR  -- Table Name: Spiny Lobster Site Location Lookup Table For Tag Recapture,
  "unnamed_1" VARCHAR  -- Unnamed: 1
);

Mark And Recapture - Spiny Lobster Tag Recapture Data

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.mark_and_recapture_spiny_lobster_tag_recapture_data

250.92 kB
27,621 rows
22 columns

CREATE TABLE mark_and_recapture_spiny_lobster_tag_recapture_data (
  "n_2nd_tag" VARCHAR  -- 2nd Tag,
  "cl_mm" DOUBLE,
  "captain" VARCHAR,
  "day" BIGINT,
  "depth_m" DOUBLE,
  "hardness" VARCHAR,
  "inside_outside" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "month" BIGINT,
  "number_of_records" BIGINT,
  "project_code" VARCHAR,
  "repro_color" VARCHAR,
  "repro_cond" VARCHAR,
  "sex" VARCHAR,
  "shell_age" VARCHAR,
  "site" VARCHAR,
  "tw_mm" VARCHAR,
  "tag" VARCHAR,
  "tagging_code" VARCHAR,
  "trap" DOUBLE,
  "year" BIGINT
);

Mark And Recapture - Spiny Lobster Tag Recapture Data - Metadata

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.mark_and_recapture_spiny_lobster_tag_recapture_metadata

29.84 kB
11 rows
42 columns

CREATE TABLE mark_and_recapture_spiny_lobster_tag_recapture_metadata (
  "table_name_sc_spiny_lobster_tag_recapture" VARCHAR  -- Table Name: SC Spiny Lobster Tag Recapture,
  "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,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

MPA Baseline Program Information - South Coast - Metadata

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.mpa_baseline_program_information_south_coast_metadata

4.55 kB
13 rows
2 columns

CREATE TABLE mpa_baseline_program_information_south_coast_metadata (
  "sc_mpa_baselineprograminformation_lookuptable_csv" VARCHAR,
  "lookup_containing_a_list_of_south_coast_sc_marine_prot_fadf387a" VARCHAR  -- Lookup Table Containing A List Of South Coast (SC) Marine Protected Area (MPA) Baseline Program Projects And Associated Information
);

MPA Boundary Details - South Coast

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.mpa_boundary_details_south_coast

23.47 kB
204 rows
14 columns

CREATE TABLE mpa_boundary_details_south_coast (
  "coordinate" VARCHAR,
  "lat_ddm" VARCHAR,
  "lat" DOUBLE,
  "long_ddm" VARCHAR,
  "long" DOUBLE,
  "mpa_name" VARCHAR,
  "mpa_designation" VARCHAR,
  "mpa_study_region" VARCHAR,
  "number_of_records" BIGINT,
  "position_id" VARCHAR,
  "post_text" VARCHAR,
  "pre_text" VARCHAR,
  "sort_order" BIGINT,
  "sub_section" BIGINT
);

MPA Boundary Details - South Coast - Metadata

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.mpa_boundary_details_south_coast_metadata

5.21 kB
13 rows
2 columns

CREATE TABLE mpa_boundary_details_south_coast_metadata (
  "sc_mpa_boundaryinformation_lookuptable_csv" VARCHAR,
  "lookup_containing_a_list_of_south_coast_sc_marine_prot_4102ddf0" VARCHAR  -- Lookup Table Containing A List Of South Coast (SC) Marine Protected Area (MPA) Boundary Coordinates. The Boundary Coordinates In This Table Were Provided By Paulo Serpa, California Department Of Fish And Wildlife.
);

Transect Surveys - Organism Lookup Table

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.transect_surveys_organism_lookup_table

12.41 kB
9 rows
19 columns

CREATE TABLE transect_surveys_organism_lookup_table (
  "f10" VARCHAR,
  "f11" VARCHAR,
  "f12" VARCHAR,
  "f13" VARCHAR,
  "f14" VARCHAR,
  "f15" VARCHAR,
  "f16" VARCHAR,
  "f17" VARCHAR,
  "f18" VARCHAR,
  "f1" VARCHAR,
  "f2" VARCHAR,
  "f3" VARCHAR,
  "f4" VARCHAR,
  "f5" VARCHAR,
  "f6" VARCHAR,
  "f7" VARCHAR,
  "f8" VARCHAR,
  "f9" VARCHAR,
  "number_of_records" BIGINT
);

Transect Surveys - Organism Lookup Table - Metadata

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.transect_surveys_organism_lookup_table_metadata

13.21 kB
13 rows
20 columns

CREATE TABLE transect_surveys_organism_lookup_table_metadata (
  "n__name_sc_spiny_lobster_transect_survey_organism_lookup_table" VARCHAR  -- Table Name: SC Spiny Lobster Transect Survey Organism Lookup Table,
  "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,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19
);

Transect Surveys - Spiny Lobster Site Location Data

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.transect_surveys_spiny_lobster_site_location_data

9.74 kB
10 rows
13 columns

CREATE TABLE transect_surveys_spiny_lobster_site_location_data (
  "f10" VARCHAR,
  "f11" VARCHAR,
  "f12" VARCHAR,
  "f1" VARCHAR,
  "f2" VARCHAR,
  "f3" VARCHAR,
  "f4" VARCHAR,
  "f5" VARCHAR,
  "f6" VARCHAR,
  "f7" VARCHAR,
  "f8" VARCHAR,
  "f9" VARCHAR,
  "number_of_records" BIGINT
);

Transect Surveys - Spiny Lobster Site Location Data - Metadata

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.transect_surveys_spiny_lobster_site_location_data_metadata

4.07 kB
15 rows
2 columns

CREATE TABLE transect_surveys_spiny_lobster_site_location_data_metadata (
  "n__name_spiny_lobster_site_location_lookup_table_for_transects" VARCHAR  -- Table Name: Spiny Lobster Site Location Lookup Table For Transects,
  "unnamed_1" VARCHAR  -- Unnamed: 1
);

Transect Surveys - Spiny Lobster Transect Data

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.transect_surveys_spiny_lobster_transect_data

29.59 kB
162 rows
28 columns

CREATE TABLE transect_surveys_spiny_lobster_transect_data (
  "project_code" VARCHAR,
  "mpa" VARCHAR,
  "year" BIGINT,
  "transect" BIGINT,
  "inside_outside" VARCHAR,
  "depth_m" DOUBLE,
  "relief_cm" DOUBLE,
  "flat_rock" DOUBLE,
  "cobble" DOUBLE,
  "boulder" DOUBLE,
  "sand" DOUBLE,
  "macro_count" DOUBLE,
  "macro_dens" DOUBLE,
  "pterygophora" DOUBLE,
  "laminaria" DOUBLE,
  "eisenia" DOUBLE,
  "egregia" DOUBLE,
  "cystoseira" DOUBLE,
  "plocamium" DOUBLE,
  "other_red" DOUBLE,
  "coralline" DOUBLE,
  "surfgrass" DOUBLE,
  "lob_50" BIGINT,
  "lob_50_65" BIGINT,
  "lob_65_80" BIGINT,
  "lob_legal" BIGINT,
  "lob_total" BIGINT,
  "lob_dens" DOUBLE
);

Transect Surveys - Spiny Lobster Transect Data - Metadata

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.transect_surveys_spiny_lobster_transect_data_metadata

38.85 kB
11 rows
56 columns

CREATE TABLE transect_surveys_spiny_lobster_transect_data_metadata (
  "table_name_sc_spiny_lobster_transect_survey" VARCHAR  -- Table Name: SC Spiny Lobster Transect Survey,
  "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,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55
);