About this Dataset

Mid-Depth Rocky & Soft-Bottom Ecosystems, California South Coast MPA Baseline Study, 2011 To 2012

Seafloor habitats deeper than 100 meters make up an estimated 29% (1840 km2) of state waters in southern California, yet they are sampled with far less frequency when compared to shallower waters due to the many challenges associated with sampling in deep water. This difference in the frequency of sampling is concerning given the many economically and ecologically important organisms, along with the unique and productive habitats in which they occur, that are found below 100 m. With the creation of the new network of marine protected areas, over 35% (330 km2) of the State’s shelf and slope deeper than 100 m are now protected within State Marine Reserves and
Conservation Areas.

This dataset represents a multi-year study (September 2011 – January 2015) to characterize mid-depth rocky reef and soft bottom ecosystems in the California Marine Life Protection Act’s South Coast (SC) Study Region. The specific objective was to characterize the seafloor habitats and associated biological communities within and adjacent to the State Marine Reserves (SMRs) and Conservation Areas (SMCAs) at the time of implementation.
Organization: State of California
Last updated: 2021-09-08T16:19:24.331877
Tags: baseline, biota, california, california-ocean-protection-council, ecological-data, environmental, fishes, gis-layers, habitat, habitats, invertebrates, maps, marine-protected-area, mid-depth-rocky, monitoring, mpa, oceans, rov, soft-bottom, south-coast, subtidal

Tables

MPA Baseline Program - Boundary Information Lookup Table Metadata

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.mpa_baseline_program_boundary_information_lookup_metadata

5.21 kB
13 rows
2 columns

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

MPA Baseline Program - Boundary Information Lookup Table

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.mpa_baseline_program_boundary_information_lookup_table

22.63 kB
204 rows
13 columns

CREATE TABLE mpa_baseline_program_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,
  "longddm" VARCHAR,
  "latddm" VARCHAR,
  "sortorder" BIGINT,
  "positionid" VARCHAR
);

MPA Baseline Program - Lookup Table

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.mpa_baseline_program_lookup_table

23.1 kB
10 rows
13 columns

CREATE TABLE mpa_baseline_program_lookup_table (
  "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 - Lookup Table Metadata

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.mpa_baseline_program_lookup_table_metadata

4.55 kB
13 rows
2 columns

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

ROV Fish Observations - Data, 2011-2012

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_fish_observations_data_2011_2012

587.7 kB
20,610 rows
19 columns

CREATE TABLE rov_fish_observations_data_2011_2012 (
  "year" BIGINT,
  "site" VARCHAR,
  "pdt_date" TIMESTAMP,
  "dive" BIGINT,
  "transect" VARCHAR,
  "transecttype" VARCHAR,
  "timecode" VARCHAR,
  "fish_id" BIGINT,
  "fish_code" VARCHAR,
  "size_class" VARCHAR,
  "count" BIGINT,
  "prim_sub" VARCHAR,
  "sec_sub" VARCHAR,
  "prim_relief" VARCHAR,
  "sec_relief" VARCHAR,
  "id_quality" VARCHAR,
  "x_coordinate" VARCHAR,
  "y_coordinate" VARCHAR,
  "depth" VARCHAR
);

ROV Fish Observations - Lookup Table

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_fish_observations_lookup_table

17.21 kB
120 rows
14 columns

CREATE TABLE rov_fish_observations_lookup_table (
  "fish_id" BIGINT,
  "fish_code" VARCHAR,
  "fish_comm" VARCHAR,
  "fish_sci" VARCHAR,
  "group1" VARCHAR,
  "group2" VARCHAR,
  "idlevel" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR
);

ROV Fish Observations - Metadata, 2011-2012

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_fish_observations_metadata_2011_2012

26.07 kB
10 rows
38 columns

CREATE TABLE rov_fish_observations_metadata_2011_2012 (
  "table_name_sc_rovfishobs_data_csv" VARCHAR  -- Table Name: SC ROVFishObs Data.csv,
  "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
);

ROV GPS Tracking - Data, 2011-2012

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_gps_tracking_data_2011_2012

7.39 MB
352,166 rows
9 columns

CREATE TABLE rov_gps_tracking_data_2011_2012 (
  "site" VARCHAR,
  "gmt_date" TIMESTAMP,
  "dive" BIGINT,
  "transect_id" VARCHAR,
  "timecode" VARCHAR,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "depth" DOUBLE,
  "gmt_dt_id" TIMESTAMP
);

ROV GPS Tracking - Metadata, 2011-2012

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_gps_tracking_metadata_2011_2012

13.2 kB
10 rows
18 columns

CREATE TABLE rov_gps_tracking_metadata_2011_2012 (
  "table_name_sc_rovgpstracking_data_csv" VARCHAR  -- Table Name: SC ROVGPSTracking Data.csv,
  "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
);

ROV GPS Tracking - Transect Lookup Table

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_gps_tracking_transect_lookup_table

9 kB
117 rows
8 columns

CREATE TABLE rov_gps_tracking_transect_lookup_table (
  "year" BIGINT,
  "site" VARCHAR,
  "pdt_date" TIMESTAMP,
  "dive" BIGINT,
  "transect" VARCHAR,
  "transecttype" VARCHAR,
  "btc" VARCHAR,
  "etc" VARCHAR
);

ROV GPS Tracking - Transect Lookup Table Metadata

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_gps_tracking_transect_lookup_table_metadata

11.8 kB
10 rows
16 columns

CREATE TABLE rov_gps_tracking_transect_lookup_table_metadata (
  "table_name_sc_rovtransect_data_csv" VARCHAR  -- Table Name: SC ROVTransect Data.csv,
  "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
);

ROV Habitat Patch - Data, 2011-2012

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_habitat_patch_data_2011_2012

2.22 MB
1,037,981 rows
10 columns

CREATE TABLE rov_habitat_patch_data_2011_2012 (
  "transect" VARCHAR,
  "datetime" TIMESTAMP,
  "habitat" VARCHAR,
  "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
);

ROV Invertebrate Observations - Data, 2011-2012

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_invertebrate_observations_data_2011_2012

118.05 kB
3,711 rows
14 columns

CREATE TABLE rov_invertebrate_observations_data_2011_2012 (
  "year" DOUBLE,
  "divenumber" DOUBLE,
  "site" VARCHAR,
  "pdt_date" TIMESTAMP,
  "transect" VARCHAR,
  "transecttype" VARCHAR,
  "timecode" VARCHAR,
  "mobinv_id" DOUBLE,
  "mobinv_code" VARCHAR,
  "size_class" VARCHAR,
  "count" DOUBLE,
  "x_coordinate" VARCHAR,
  "y_coordinate" VARCHAR,
  "depth" VARCHAR
);

ROV Invertebrate Observations - Lookup Table

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_invertebrate_observations_lookup_table

9.66 kB
12 rows
13 columns

CREATE TABLE rov_invertebrate_observations_lookup_table (
  "id" BIGINT,
  "mobinv_code" VARCHAR,
  "mobinv_comm" VARCHAR,
  "mobinv_sci" VARCHAR,
  "group1" VARCHAR,
  "idlevel" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR
);

ROV Invertebrate Observations - Lookup Table Metadata

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_invertebrate_observations_lookup_table_metadata

17.07 kB
10 rows
24 columns

CREATE TABLE rov_invertebrate_observations_lookup_table_metadata (
  "table_name_sc_rovmobinvobs_lookup_csv" VARCHAR  -- Table Name: SC ROVMobInvObs Lookup.csv,
  "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
);

ROV Invertebrate Observations - Metadata, 2011-2012

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_invertebrate_observations_metadata_2011_2012

19.55 kB
10 rows
28 columns

CREATE TABLE rov_invertebrate_observations_metadata_2011_2012 (
  "table_name_sc_rovmobinvobs_data_csv" VARCHAR  -- Table Name: SC ROVMobInvObs Data.csv,
  "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
);

ROV Sessile Invertebrate Patch - Data, 2011-2012

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_sessile_invertebrate_patch_data_2011_2012

50.45 kB
260,897 rows
3 columns

CREATE TABLE rov_sessile_invertebrate_patch_data_2011_2012 (
  "transect_id" VARCHAR,
  "datetime" VARCHAR,
  "sessileinverts" VARCHAR
);

ROV Sessile Invertebrate Patch - Transect Lookup Table

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_sessile_invertebrate_patch_transect_lookup_table

9 kB
117 rows
8 columns

CREATE TABLE rov_sessile_invertebrate_patch_transect_lookup_table (
  "year" BIGINT,
  "site" VARCHAR,
  "pdt_date" TIMESTAMP,
  "dive" BIGINT,
  "transect" VARCHAR,
  "transecttype" VARCHAR,
  "btc" VARCHAR,
  "etc" VARCHAR
);

ROV Sessile Invertebrate Patch - Transect Lookup Table Metadata

@usgov.ca_gov_mid_depth_rocky_soft_bottom_ecosystems_californ_25714379.rov_sessile_invertebrate_patch_transect_lookup_table_metadata

11.8 kB
10 rows
16 columns

CREATE TABLE rov_sessile_invertebrate_patch_transect_lookup_table_metadata (
  "table_name_sc_rovtransect_data_csv" VARCHAR  -- Table Name: SC ROVTransect Data.csv,
  "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
);