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.673257
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.41 KB
9 rows
12 columns


CREATE TABLE mark_and_recapture_spiny_lobster_site_location_data (
  "project_short_code_sc_lobster" VARCHAR,
  "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

3.96 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,
  "unnamed_1" VARCHAR
);

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

245.04 KB
27621 rows
22 columns


CREATE TABLE mark_and_recapture_spiny_lobster_tag_recapture_data (
  "n_2nd_tag" VARCHAR,
  "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.14 KB
11 rows
42 columns


CREATE TABLE mark_and_recapture_spiny_lobster_tag_recapture_metadata (
  "table_name_sc_spiny_lobster_tag_recapture" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR
);

MPA Baseline Program Information - South Coast

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.mpa_baseline_program_information_south_coast

23.38 KB
10 rows
14 columns


CREATE TABLE mpa_baseline_program_information_south_coast (
  "consumptive" BIGINT,
  "deep" BIGINT,
  "estuarine_wetland" BIGINT,
  "kelp_shallow_rock" BIGINT,
  "mid_depth_rock" BIGINT,
  "nearshore_pelagic" BIGINT,
  "non_consumptive" BIGINT,
  "number_of_records" BIGINT,
  "rocky_intertidal" BIGINT,
  "sc_project_description" VARCHAR,
  "sc_project_short_code" VARCHAR,
  "sc_project_title" VARCHAR,
  "soft_intertidal" BIGINT,
  "soft_subtidal" BIGINT
);

MPA Baseline Program Information - South Coast - Metadata

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.mpa_baseline_program_information_south_coast_metadata

4.44 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
);

MPA Boundary Details - South Coast

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.mpa_boundary_details_south_coast

22.92 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.09 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
);

Transect Surveys - Organism Lookup Table

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.transect_surveys_organism_lookup_table

12.12 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

12.9 KB
13 rows
20 columns


CREATE TABLE transect_surveys_organism_lookup_table_metadata (
  "n__name_sc_spiny_lobster_transect_survey_organism_lookup_table" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR
);

Transect Surveys - Spiny Lobster Site Location Data

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.transect_surveys_spiny_lobster_site_location_data

9.51 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

3.97 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,
  "unnamed_1" VARCHAR
);

Transect Surveys - Spiny Lobster Transect Data

@usgov.ca_gov_california_spiny_lobster_panulirus_interruptus__39d70a4c.transect_surveys_spiny_lobster_transect_data

28.9 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

37.94 KB
11 rows
56 columns


CREATE TABLE transect_surveys_spiny_lobster_transect_data_metadata (
  "table_name_sc_spiny_lobster_transect_survey" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR
);