About this Dataset

Sandy Beach Ecosystems, California South Coast MPA Baseline Study, 2011 To 2013

Sandy beaches are among the most intensely used coastal ecosystems for human recreation and are vitally important to coastal economies. Beaches support unique biodiversity and provide essential ecosystem functions and services including endemic invertebrate communities and food webs that are prey for birds and fish, buffering and absorption of wave energy by stored sand, filtration of large volumes of seawater, extensive detrital processing and nutrient recycling, and the provision of critical habitat and resources for declining and endangered wildlife, such as shorebirds and pinnipeds. Sandy beaches compose 36% of the 693 km of shoreline in the South Coast (SC) region, including the California Channel Islands. The goal of this ecological characterization study is to provide a quantitative, baseline description of sandy beach ecosystems in the region from which future ecological changes may be assessed, and to document any differences that may already exist between sandy beaches located within and outside of Marine Protected Areas (MPAs). We also evaluated potential ecological indicators for monitoring and developed and tested new protocols for potential use by citizen-scientists and educators.
Organization: State of California
Last updated: 2021-09-08T16:19:26.626050
Tags: algae, baseline, biota, california, california-ocean-protection-council, ecological-data, environmental, marine-protected-area, monitoring, mpa, oceans, sandy-beaches, south-coast

Tables

Biodiversity Surveys, Intertidal - Data, 2011

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.biodiversity_surveys_intertidal_data_2011

21.16 kB
639 rows
20 columns

CREATE TABLE biodiversity_surveys_intertidal_data_2011 (
  "project" VARCHAR,
  "site" VARCHAR,
  "site_code" VARCHAR,
  "date" TIMESTAMP,
  "month" VARCHAR,
  "month_a3599b" BIGINT  -- Month #,
  "day" BIGINT,
  "year" BIGINT,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "transect" VARCHAR,
  "level" BIGINT,
  "count" BIGINT,
  "wet_weight" DOUBLE,
  "notes" VARCHAR
);

Biodiversity Surveys, Intertidal - Metadata, 2011

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.biodiversity_surveys_intertidal_metadata_2011

18.51 kB
10 rows
23 columns

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

Biodiversity Surveys - Physical Characteristics Data, 2011

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.biodiversity_surveys_physical_characteristics_data_2011

17.47 kB
39 rows
23 columns

CREATE TABLE biodiversity_surveys_physical_characteristics_data_2011 (
  "project" VARCHAR,
  "num" BIGINT,
  "site_code" VARCHAR,
  "site" VARCHAR,
  "yr" BIGINT,
  "month" VARCHAR,
  "mon" BIGINT,
  "day" BIGINT,
  "transect" VARCHAR,
  "hts" DOUBLE,
  "htsslope" DOUBLE,
  "bermcr" DOUBLE,
  "bermslope" DOUBLE,
  "hiswash" DOUBLE,
  "wto" DOUBLE,
  "wtoslope" DOUBLE,
  "lowswash" DOUBLE,
  "swashes" DOUBLE,
  "wtoxings" DOUBLE,
  "surflimit" DOUBLE,
  "breakerht" DOUBLE,
  "breakerper" DOUBLE,
  "breakswash" DOUBLE
);

Biodiversity Surveys - Physical Characteristics Metadata, 2011

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.biodiversity_surveys_physical_characteristics_metadata_2011

20.02 kB
9 rows
25 columns

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

Biodiversity Surveys - Taxonomy Lookup Table

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.biodiversity_surveys_taxonomy_lookup_table

8.43 kB
110 rows
8 columns

CREATE TABLE biodiversity_surveys_taxonomy_lookup_table (
  "project" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR
);

Biodiversity Surveys - Taxonomy Lookup Table Metadata

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.biodiversity_surveys_taxonomy_lookup_table_metadata

9.43 kB
10 rows
11 columns

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

Indicator Taxa Surveys - Emerita Data, 2012-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.indicator_taxa_surveys_emerita_data_2012_2013

17.74 kB
1,008 rows
20 columns

CREATE TABLE indicator_taxa_surveys_emerita_data_2012_2013 (
  "project" VARCHAR,
  "site" VARCHAR,
  "site_code" VARCHAR,
  "month" VARCHAR,
  "month_num" BIGINT,
  "day" BIGINT,
  "year" BIGINT,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "transect" VARCHAR,
  "type_count" VARCHAR,
  "count" BIGINT,
  "type_mass" VARCHAR,
  "n__wet_mass" DOUBLE  -- Wet Mass,
  "notes" VARCHAR
);

Indicator Taxa Surveys - Emerita Metadata, 2012-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.indicator_taxa_surveys_emerita_metadata_2012_2013

18.55 kB
10 rows
23 columns

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

Indicator Taxa Surveys - Lookup Table Data

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.indicator_taxa_surveys_lookup_table_data

4.6 kB
103 rows
5 columns

CREATE TABLE indicator_taxa_surveys_lookup_table_data (
  "project" VARCHAR,
  "type_count" VARCHAR,
  "count_definition" VARCHAR,
  "type_mass" VARCHAR,
  "mass_definition" VARCHAR
);

Indicator Taxa Surveys - Sticky Trap Data, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.indicator_taxa_surveys_sticky_trap_data_2011_2013

31.19 kB
1,145 rows
42 columns

CREATE TABLE indicator_taxa_surveys_sticky_trap_data_2011_2013 (
  "project" VARCHAR,
  "site" VARCHAR,
  "site_code" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "month_1" BIGINT,
  "day" BIGINT,
  "date" TIMESTAMP,
  "transect" VARCHAR,
  "trap" BIGINT,
  "taxa" VARCHAR,
  "count" BIGINT,
  "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
);

Indicator Taxa Surveys - Sticky Trap Metadata, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.indicator_taxa_surveys_sticky_trap_metadata_2011_2013

12.26 kB
9 rows
15 columns

CREATE TABLE indicator_taxa_surveys_sticky_trap_metadata_2011_2013 (
  "table_name" VARCHAR  -- Table Name:,
  "sc_beach_sticky_traps_2011_2013_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,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);

Indicator Taxa Surveys - Talitrid Cores Data, 2012

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.indicator_taxa_surveys_talitrid_cores_data_2012

20.16 kB
496 rows
19 columns

CREATE TABLE indicator_taxa_surveys_talitrid_cores_data_2012 (
  "project" VARCHAR,
  "site" VARCHAR,
  "site_code" VARCHAR,
  "date" TIMESTAMP,
  "month" VARCHAR,
  "month_a3599b" BIGINT  -- Month #,
  "day" BIGINT,
  "year" BIGINT,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "transect" VARCHAR,
  "count" DOUBLE,
  "wet_weight" DOUBLE,
  "notes" VARCHAR
);

Indicator Taxa Surveys - Talitrid Cores Metadata, 2012

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.indicator_taxa_surveys_talitrid_cores_metadata_2012

17.68 kB
10 rows
22 columns

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

Macrophyte Wrack, Monthly Surveys - Data, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.macrophyte_wrack_monthly_surveys_data_2011_2013

56.75 kB
5,195 rows
13 columns

CREATE TABLE macrophyte_wrack_monthly_surveys_data_2011_2013 (
  "project" VARCHAR,
  "year" DOUBLE,
  "month" VARCHAR,
  "date" DOUBLE,
  "site" VARCHAR,
  "site_code" VARCHAR,
  "transect" VARCHAR,
  "start" DOUBLE,
  "end" DOUBLE,
  "type" VARCHAR,
  "dep" DOUBLE,
  "investigator" VARCHAR,
  "notes" VARCHAR
);

Macrophyte Wrack - Species Lookup Table

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.macrophyte_wrack_species_lookup_table

10.31 kB
30 rows
13 columns

CREATE TABLE macrophyte_wrack_species_lookup_table (
  "project" VARCHAR,
  "type" VARCHAR,
  "taxon_genus" VARCHAR,
  "taxon_species" VARCHAR,
  "description" VARCHAR,
  "taxon_group" VARCHAR,
  "survey" VARCHAR,
  "taxon_kingdom" VARCHAR,
  "taxon_phylum" VARCHAR,
  "taxon_class" VARCHAR,
  "taxon_order" VARCHAR,
  "taxon_family" VARCHAR,
  "common_name" VARCHAR
);

Macrophyte Wrack - Species Lookup Table Metadata

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.macrophyte_wrack_species_lookup_table_metadata

11.96 kB
10 rows
16 columns

CREATE TABLE macrophyte_wrack_species_lookup_table_metadata (
  "table_name" VARCHAR  -- Table Name:,
  "sc_mpa_beachwrack_macrophyte_species_lookup_table_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,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

Macrophyte Wrack, Surveys - Data, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.macrophyte_wrack_surveys_data_2011_2013

56.75 kB
5,195 rows
13 columns

CREATE TABLE macrophyte_wrack_surveys_data_2011_2013 (
  "project" VARCHAR,
  "year" DOUBLE,
  "month" VARCHAR,
  "date" DOUBLE,
  "site" VARCHAR,
  "site_code" VARCHAR,
  "transect" VARCHAR,
  "start" DOUBLE,
  "end" DOUBLE,
  "type" VARCHAR,
  "dep" DOUBLE,
  "investigator" VARCHAR,
  "notes" VARCHAR
);

Macrophyte Wrack, Surveys - Metadata, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.macrophyte_wrack_surveys_metadata_2011_2013

13.09 kB
9 rows
16 columns

CREATE TABLE macrophyte_wrack_surveys_metadata_2011_2013 (
  "table_name" VARCHAR  -- Table Name:,
  "scmpabeachwrackcovermonthly2011_2013_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,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

MPA Baseline Program - Beach Site Name Lookup Table

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.mpa_baseline_program_beach_site_name_lookup_table

2.56 kB
12 rows
2 columns

CREATE TABLE mpa_baseline_program_beach_site_name_lookup_table (
  "site_name" VARCHAR,
  "site_code" VARCHAR
);

MPA Baseline Program - Boundary Information Lookup Table Metadata

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.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_sandy_beach_ecosystems_california_south_coast_m_a6031238.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 Metadata

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

MPA Basline Program - Beach Site Name Lookup Table Metadata

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.mpa_basline_program_beach_site_name_lookup_table_metadata

5.46 kB
9 rows
6 columns

CREATE TABLE mpa_basline_program_beach_site_name_lookup_table_metadata (
  "table_name" VARCHAR  -- Table Name:,
  "scmpabeachwrackcovermonthly2011_2013_csv" VARCHAR,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Physical Characteristics, Beach Sediment - Data, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.physical_characteristics_beach_sediment_data_2011_2013

99.99 kB
826 rows
27 columns

CREATE TABLE physical_characteristics_beach_sediment_data_2011_2013 (
  "project" VARCHAR,
  "site_code" VARCHAR,
  "site" VARCHAR,
  "year" DOUBLE,
  "month" VARCHAR,
  "month_a3599b" DOUBLE  -- Month #,
  "day" DOUBLE,
  "date" VARCHAR,
  "transect" VARCHAR,
  "level" VARCHAR,
  "phi_2_5" DOUBLE  -- Phi -2.5,
  "n__phi_2" DOUBLE  -- Phi -2,
  "n__phi_1_5" DOUBLE  -- Phi -1.5,
  "n__phi_1" DOUBLE  -- Phi-1,
  "n__phi_0_5" DOUBLE  -- Phi -0.5,
  "n__phi_0" DOUBLE  -- Phi 0,
  "n__phi_0_5_993891" DOUBLE  -- Phi 0.5,
  "n__phi_1_b2e102" DOUBLE  -- Phi 1,
  "n__phi_1_5_3275e2" DOUBLE  -- Phi 1.5,
  "n__phi_2_1f0a9b" DOUBLE  -- Phi 2,
  "phi_2_5_f1ab71" DOUBLE  -- Phi 2.5,
  "n__phi_3" DOUBLE  -- Phi 3,
  "n__phi_3_5" DOUBLE  -- Phi 3.5,
  "phi_4" DOUBLE,
  "phi_4_5" DOUBLE,
  "bottom_pan" DOUBLE,
  "total" DOUBLE
);

Physical Characteristics, Beach Sediment - Metadata, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.physical_characteristics_beach_sediment_metadata_2011_2013

22.21 kB
9 rows
30 columns

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