Sandy Beach Ecosystems, California South Coast MPA Baseline Study, 2011 To 2013 by US Government | Environmental and Climate Sciences

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.626047
Tags: algae, baseline, biota, california, california-ocean-protection-council, ecological-data, environmental, marine-protected-area, monitoring, mpa, oceans, sandy-beaches, south-coast

Tables

MPA Baseline Program - Lookup Table

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.mpa_baseline_program_lookup_table

22.55 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_sandy_beach_ecosystems_california_south_coast_m_a6031238.mpa_baseline_program_lookup_table_metadata

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

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.5 KB
12 rows
2 columns


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

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.34 KB
9 rows
6 columns


CREATE TABLE mpa_basline_program_beach_site_name_lookup_table_metadata (
  "table_name" VARCHAR,
  "scmpabeachwrackcovermonthly2011_2013_csv" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR
);

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.1 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 - Boundary Information Lookup Table Metadata

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.mpa_baseline_program_boundary_information_lookup_metadata

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

Biodiversity Surveys - Taxonomy Lookup Table

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.biodiversity_surveys_taxonomy_lookup_table

8.23 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.21 KB
10 rows
11 columns


CREATE TABLE biodiversity_surveys_taxonomy_lookup_table_metadata (
  "table_name" VARCHAR,
  "sc_beach_biodiversity_taxonomy_lookup_table_csv" 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
);

Biodiversity Surveys, Intertidal - Data, 2011

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.biodiversity_surveys_intertidal_data_2011

20.66 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,
  "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.08 KB
10 rows
23 columns


CREATE TABLE biodiversity_surveys_intertidal_metadata_2011 (
  "table_name" VARCHAR,
  "sc_beach_biodiversity_2011_csv" 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
);

Biodiversity Surveys - Physical Characteristics Data, 2011

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.biodiversity_surveys_physical_characteristics_data_2011

17.06 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

19.55 KB
9 rows
25 columns


CREATE TABLE biodiversity_surveys_physical_characteristics_metadata_2011 (
  "table_name" VARCHAR,
  "sc_beach_physical_characteristics_biodiversity_surveys_2011_csv" 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
);

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.32 KB
1008 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,
  "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.11 KB
10 rows
23 columns


CREATE TABLE indicator_taxa_surveys_emerita_metadata_2012_2013 (
  "table_name" VARCHAR,
  "sc_beach_emerita_data_2012_13_csv" 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
);

Indicator Taxa Surveys - Lookup Table Data

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.indicator_taxa_surveys_lookup_table_data

4.49 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

30.46 KB
1145 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_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
);

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

11.97 KB
9 rows
15 columns


CREATE TABLE indicator_taxa_surveys_sticky_trap_metadata_2011_2013 (
  "table_name" VARCHAR,
  "sc_beach_sticky_traps_2011_2013_csv" 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
);

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

19.68 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,
  "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.27 KB
10 rows
22 columns


CREATE TABLE indicator_taxa_surveys_talitrid_cores_metadata_2012 (
  "table_name" VARCHAR,
  "sc_beach_talitrid_cores_2012_csv" 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
);

Macrophyte Wrack - Species Lookup Table

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.macrophyte_wrack_species_lookup_table

10.07 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.68 KB
10 rows
16 columns


CREATE TABLE macrophyte_wrack_species_lookup_table_metadata (
  "table_name" VARCHAR,
  "sc_mpa_beachwrack_macrophyte_species_lookup_table_csv" 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
);

Macrophyte Wrack, Surveys - Data, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.macrophyte_wrack_surveys_data_2011_2013

55.42 KB
5195 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

12.78 KB
9 rows
16 columns


CREATE TABLE macrophyte_wrack_surveys_metadata_2011_2013 (
  "table_name" VARCHAR,
  "scmpabeachwrackcovermonthly2011_2013_csv" 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
);

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

55.42 KB
5195 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
);

Physical Characteristics, Monthly Surveys - Data, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.physical_characteristics_monthly_surveys_data_2011_2013

31.79 KB
864 rows
22 columns


CREATE TABLE physical_characteristics_monthly_surveys_data_2011_2013 (
  "project" VARCHAR,
  "site_code" VARCHAR,
  "site" VARCHAR,
  "yr" BIGINT,
  "mon" VARCHAR,
  "mon_1" 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
);

Physical Characteristics, Monthly Surveys - Metadata, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.physical_characteristics_monthly_surveys_metadata_2011_2013

19.49 KB
11 rows
25 columns


CREATE TABLE physical_characteristics_monthly_surveys_metadata_2011_2013 (
  "table_name" VARCHAR,
  "sc_beach_physical_characteristics_monthlysurveys_2011_2013_csv" 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
);

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

97.65 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,
  "day" DOUBLE,
  "date" VARCHAR,
  "transect" VARCHAR,
  "level" VARCHAR,
  "phi_2_5" DOUBLE,
  "n__phi_2" DOUBLE,
  "n__phi_1_5" DOUBLE,
  "n__phi_1" DOUBLE,
  "n__phi_0_5" DOUBLE,
  "n__phi_0" DOUBLE,
  "n__phi_0_5_993891" DOUBLE,
  "n__phi_1_b2e102" DOUBLE,
  "n__phi_1_5_3275e2" DOUBLE,
  "n__phi_2_1f0a9b" DOUBLE,
  "phi_2_5_f1ab71" DOUBLE,
  "n__phi_3" DOUBLE,
  "n__phi_3_5" DOUBLE,
  "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

21.69 KB
9 rows
30 columns


CREATE TABLE physical_characteristics_beach_sediment_metadata_2011_2013 (
  "table_name" VARCHAR,
  "sc_beach_sediment_2011_2013all_csv" 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
);

Rapid Surveys, Birds, Kelp, People, Dog, Kelp - Data 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.rapid_surveys_birds_kelp_people_dog_kelp_data_2011_2013

11.04 KB
2304 rows
10 columns


CREATE TABLE rapid_surveys_birds_kelp_people_dog_kelp_data_2011_2013 (
  "project" VARCHAR,
  "site" VARCHAR,
  "site_code" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "month_a3599b" BIGINT,
  "day" BIGINT,
  "type" VARCHAR,
  "count" BIGINT,
  "species" DOUBLE
);

Rapid Surveys, Birds, Kelp, People, Dog, Kelp - Metadata 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.rapid_surveys_birds_kelp_people_dog_kelp_metadata_2011_2013

9.99 KB
10 rows
12 columns


CREATE TABLE rapid_surveys_birds_kelp_people_dog_kelp_metadata_2011_2013 (
  "table_name" VARCHAR,
  "sc_beach_rapid_surveys_birds_people_dogs_kelpplants_2011_2013" 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
);

Rapid Surveys, Weather - Data, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.rapid_surveys_weather_data_2011_2013

10.92 KB
288 rows
11 columns


CREATE TABLE rapid_surveys_weather_data_2011_2013 (
  "project" VARCHAR,
  "site" VARCHAR,
  "site_code" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "month_a3599b" BIGINT,
  "day" BIGINT,
  "wind_speed" DOUBLE,
  "max_wind_speed" DOUBLE,
  "air_temp" DOUBLE,
  "wind_chill" DOUBLE
);

Rapid Surveys, Weather - Metadata, 2011-2013

@usgov.ca_gov_sandy_beach_ecosystems_california_south_coast_m_a6031238.rapid_surveys_weather_metadata_2011_2013

11.29 KB
10 rows
14 columns


CREATE TABLE rapid_surveys_weather_metadata_2011_2013 (
  "table_name" VARCHAR,
  "sc_beach_rapid_surveys_weather_2011_2013_csv" 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
);