Characterization Of Seabirds, California North Coast MPA Baseline Study, 2014 To 2015 by US Government | Environmental and Climate Sciences

About this Dataset

Characterization Of Seabirds, California North Coast MPA Baseline Study, 2014 To 2015

We completed four distinct projects to collect baseline data at varying spatial and temporal scales. First, we used data from aerial photographic surveys conducted from 1989-2014 to investigate region-wide trends in the populations of Common Murres and Brandt’s Cormorants. We used 173 observations of Common Murre colony abundance at 14 colonies and 123 observations of Brandt’s Cormorant nest abundance at 10 colonies over the 26-year study period. Additionally, aerial photographic surveys conducted in 2014 were used to document location and abundance of Common Murre, Brandt’s Cormorant, and Double-crested Cormorant across the NCSR.

Second, at a more localized scale, we monitored Common Murre reproduction, foraging effort, and diet in 2014 at Castle Rock National Wildlife Refuge using a robotic, remotely-controlled video recording system. Although this is only one of the seabird colonies in the NCSR, it the largest and served to inform our understanding of the mechanisms of population change across the region. Common Murre are very visible and thus ideal for monitoring fine scale patterns in reproduction and changing diet. We measured date of nest initiation, hatching success, fledging success, overall reproductive success, time allocation, provisioning rate, and diet composition via the video. Information gained from these surveys were combined with comparable data from 2007-2013 at Castle Rock to assess baseline condition and variability of these metrics over an 8-year period.

Third, in 2014-2015 we conducted ground-based surveys of coastally breeding seabirds inside and outside of six MPAs to establish a framework for continued MPA monitoring. For this, we conducted intensive monitoring of six species likely to benefit from MPA establishment: Pigeon Guillemot, Brandt’s Cormorant, Pelagic Cormorant, Double-crested Cormorant, Western Gull, and Black Oystercatcher. We collected data on breeding population size, breeding productivity, foraging rates and rates of human-caused disturbance inside and outside of each MPA. We monitored productivity by following individual nests visible from land and calculated annual breeding productivity as number of fledglings produced per breeding pair. We monitored foraging from land-based observation points, recording all birds foraging within a 1 km radius of an observation point. We calculated foraging rates as number of birds foraging per hour of observation. We recorded all human-caused disturbances observed during any land-based survey and calculated disturbance rates as number of disturbances per hour of observation.
Organization: State of California
Last updated: 2021-09-08T16:17:58.843031
Tags: 2014, 2015, baseline, biota, california, california-ocean-protection-council, ecological-data, environmental, marine-protected-area, monitoring, mpa, north-coast, oceans, seabirds

Tables

MPA Baseline Program Information - North Coast

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.mpa_baseline_program_information_north_coast

23.67 KB
11 rows
14 columns


CREATE TABLE mpa_baseline_program_information_north_coast (
  "nc_project_short_code" VARCHAR,
  "nc_project_title" VARCHAR,
  "consumptive" BIGINT,
  "nonconsumptive" BIGINT,
  "deep" BIGINT,
  "estuarinewetland" BIGINT,
  "kelpshallowrock" BIGINT,
  "middepthrock" BIGINT,
  "nearshorepelagic" BIGINT,
  "rockyintertidal" BIGINT,
  "softintertidal" BIGINT,
  "softsubtidal" BIGINT,
  "contextual" BIGINT,
  "sc_project_description" VARCHAR
);

MPA Baseline Program Information - North Coast - Metadata

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.mpa_baseline_program_information_north_coast_metadata

4.51 KB
14 rows
2 columns


CREATE TABLE mpa_baseline_program_information_north_coast_metadata (
  "nc_mpa_baselineprograminformation_lookuptable_csv" VARCHAR,
  "lookup_containing_a_list_of_north_coast_sc_marine_prot_f4f7dfc5" VARCHAR
);

MPA Boundary Details - North Coast

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.mpa_boundary_details_north_coast

15.31 KB
91 rows
13 columns


CREATE TABLE mpa_boundary_details_north_coast (
  "mpa_name" VARCHAR,
  "mpa_designation" VARCHAR,
  "mpa_study_region" VARCHAR,
  "subsection" BIGINT,
  "pretext" VARCHAR,
  "coordinate" VARCHAR,
  "posttext" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "latddm" VARCHAR,
  "longddm" VARCHAR,
  "sortorder" BIGINT,
  "positionid" VARCHAR
);

MPA Boundary Details - North Coast - Metadata

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.mpa_boundary_details_north_coast_metadata

4.71 KB
12 rows
2 columns


CREATE TABLE mpa_boundary_details_north_coast_metadata (
  "mpa_name" VARCHAR,
  "the_name_of_the_california_marine_protected_area_descr_043f4de7" VARCHAR
);

Aerial Surveys - Site Location Lookup Table 2014

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.aerial_surveys_site_location_lookup_table_2014

7.04 KB
35 rows
7 columns


CREATE TABLE aerial_surveys_site_location_lookup_table_2014 (
  "project_short_code" VARCHAR,
  "colony_name" VARCHAR,
  "mpa_name" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "ccn" VARCHAR,
  "usfwscn" VARCHAR
);

Aerial Surveys - Site Location Lookup Table 2014 - Metadata

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.aerial_surveys_site_location_lookup_table_2014_metadata

7.92 KB
10 rows
8 columns


CREATE TABLE aerial_surveys_site_location_lookup_table_2014_metadata (
  "n__name_nc_seabirds_2014_aerial_photographic_surveys_c_e2c138f7" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR
);

Aerial Surveys - Colony Counts Baseline 2014

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.aerial_surveys_colony_counts_baseline_2014

11.88 KB
35 rows
15 columns


CREATE TABLE aerial_surveys_colony_counts_baseline_2014 (
  "project_short_code" VARCHAR,
  "colony_name" VARCHAR,
  "ccn" VARCHAR,
  "usfwscn" VARCHAR,
  "date" VARCHAR,
  "comu_birds" VARCHAR,
  "brac_nests" VARCHAR,
  "brac_sites" VARCHAR,
  "brac_birds" VARCHAR,
  "dcco_nests" VARCHAR,
  "dcco_sites" VARCHAR,
  "dcco_birds" VARCHAR,
  "brpe_birds" DOUBLE,
  "brpe_adults" DOUBLE,
  "brpe_imms" DOUBLE
);

Aerial Surveys - Colony Counts Baseline 2014 - Metadata

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.aerial_surveys_colony_counts_baseline_2014_metadata

13.72 KB
10 rows
16 columns


CREATE TABLE aerial_surveys_colony_counts_baseline_2014_metadata (
  "table_name_nc_seabirds_aerial_colony_counts_baseline_2014" 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
);

Aerial Surveys - Colony Counts Trends 2000 - 2014

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.aerial_surveys_colony_counts_trends_2000_2014

15.03 KB
17 rows
20 columns


CREATE TABLE aerial_surveys_colony_counts_trends_2000_2014 (
  "project_short_code" VARCHAR,
  "colony_name" VARCHAR,
  "date" TIMESTAMP,
  "comu_east" DOUBLE,
  "comu_west" DOUBLE,
  "comu_birds" DOUBLE,
  "brac_nests" BIGINT,
  "brac_sites" BIGINT,
  "brac_birds" BIGINT,
  "dcco_nests" DOUBLE,
  "dcco_sites" DOUBLE,
  "dcco_birds" DOUBLE,
  "peco_nests" DOUBLE,
  "peco_sites" DOUBLE,
  "peco_birds" DOUBLE,
  "brpe_birds" DOUBLE,
  "brpe_adults" DOUBLE,
  "brpe_imms" DOUBLE,
  "wegu_nests" DOUBLE,
  "wegu_birds" DOUBLE
);

Aerial Surveys - Colony Counts Trends 2000 - 2014 - Metadata

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.aerial_surveys_colony_counts_trends_2000_2014_metadata

17.27 KB
10 rows
21 columns


CREATE TABLE aerial_surveys_colony_counts_trends_2000_2014_metadata (
  "table_name_nc_seabirds_aerial_colony_counts_trends_2000_2014" 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
);

Aerial Surveys - Taxon Lookup Table

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.aerial_surveys_taxon_lookup_table

7.33 KB
7 rows
10 columns


CREATE TABLE aerial_surveys_taxon_lookup_table (
  "project_short_code" VARCHAR,
  "species_code" VARCHAR,
  "species_common_name" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "family" VARCHAR,
  "order" VARCHAR,
  "class" VARCHAR,
  "phylum" VARCHAR,
  "kingdom" VARCHAR
);

Aerial Surveys - Taxon Lookup Table - Metadata

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.aerial_surveys_taxon_lookup_table_metadata

9.77 KB
10 rows
11 columns


CREATE TABLE aerial_surveys_taxon_lookup_table_metadata (
  "n__name_nc_seabirds_aerial_photographic_surveys_specie_904864a0" 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
);

Reproduction Time - Diet - 2014

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.reproduction_time_diet_2014

15.97 KB
852 rows
13 columns


CREATE TABLE reproduction_time_diet_2014 (
  "nc_project_short_code" VARCHAR,
  "speciesid" VARCHAR,
  "areaid" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "julian_date" BIGINT,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "id" BIGINT,
  "bill_load" BIGINT,
  "prey_id_scientific" VARCHAR,
  "prey_id_common" VARCHAR
);

Reproduction Time - Nesting Success - 2014

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.reproduction_time_nesting_success_2014

61.54 KB
52 rows
102 columns


CREATE TABLE reproduction_time_nesting_success_2014 (
  "nc_project_short_code" VARCHAR,
  "speciesid" VARCHAR,
  "areaid" VARCHAR,
  "julian_date" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "site_1" VARCHAR,
  "site_2" VARCHAR,
  "site_3" VARCHAR,
  "site_4" VARCHAR,
  "site_5" VARCHAR,
  "site_6" VARCHAR,
  "site_7" VARCHAR,
  "site_9" VARCHAR,
  "site_10" VARCHAR,
  "site_11" VARCHAR,
  "site_12" VARCHAR,
  "site_13" VARCHAR,
  "site_14" VARCHAR,
  "site_15" VARCHAR,
  "site_16" VARCHAR,
  "site_17" VARCHAR,
  "site_18" VARCHAR,
  "site_19" VARCHAR,
  "site_20" VARCHAR,
  "site_21" VARCHAR,
  "site_22" VARCHAR,
  "site_23" VARCHAR,
  "site_24" VARCHAR,
  "site_25" VARCHAR,
  "site_26" VARCHAR,
  "site_27" VARCHAR,
  "site_28" VARCHAR,
  "site_29" VARCHAR,
  "site_30" VARCHAR,
  "site_31" VARCHAR,
  "site_32" VARCHAR,
  "site_33" VARCHAR,
  "site_34" VARCHAR,
  "site_35" VARCHAR,
  "site_36" VARCHAR,
  "site_37" VARCHAR,
  "site_38" VARCHAR,
  "site_39" VARCHAR,
  "site_40" VARCHAR,
  "site_41" VARCHAR,
  "site_42" VARCHAR,
  "site_43" VARCHAR,
  "site_44" VARCHAR,
  "site_45" VARCHAR,
  "site_46" VARCHAR,
  "site_47" VARCHAR,
  "site_48" VARCHAR,
  "site_49" VARCHAR,
  "site_50" VARCHAR,
  "site_51" VARCHAR,
  "site_52" VARCHAR,
  "site_53" VARCHAR,
  "site_54" VARCHAR,
  "site_55" VARCHAR,
  "site_56" VARCHAR,
  "site_57" VARCHAR,
  "site_58" VARCHAR,
  "site_59" VARCHAR,
  "site_60" VARCHAR,
  "site_61" VARCHAR,
  "site_62" VARCHAR,
  "site_63" VARCHAR,
  "site_64" VARCHAR,
  "site_65" VARCHAR,
  "site_66" VARCHAR,
  "site_67" VARCHAR,
  "site_68" VARCHAR,
  "site_69" VARCHAR,
  "site_70" VARCHAR,
  "site_71" VARCHAR,
  "site_72" VARCHAR,
  "site_73" VARCHAR,
  "site_74" VARCHAR,
  "site_75" VARCHAR,
  "site_76" VARCHAR,
  "site_77" VARCHAR,
  "site_78" VARCHAR,
  "site_79" VARCHAR,
  "site_80" VARCHAR,
  "site_81" VARCHAR,
  "site_82" VARCHAR,
  "site_83" VARCHAR,
  "site_84" VARCHAR,
  "site_85" VARCHAR,
  "site_86" VARCHAR,
  "site_87" VARCHAR,
  "site_88" VARCHAR,
  "site_91" VARCHAR,
  "site_92" VARCHAR,
  "site_93" VARCHAR,
  "site_94" VARCHAR,
  "site_95" VARCHAR,
  "site_96" VARCHAR
);

Reproduction Time - Prey Taxonomy Lookup Table

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.reproduction_time_prey_taxonomy_lookup_table

7.06 KB
12 rows
9 columns


CREATE TABLE reproduction_time_prey_taxonomy_lookup_table (
  "nc_project_short_code" VARCHAR,
  "species_common_name" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR
);

Reproduction Time - Site Location Lookup Table

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.reproduction_time_site_location_lookup_table

6.27 KB
1 row
8 columns


CREATE TABLE reproduction_time_site_location_lookup_table (
  "nc_project_short_code" VARCHAR,
  "site_name" VARCHAR,
  "mpa_name" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "county" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR
);

Reproduction Time - Time Budget

@usgov.ca_gov_characterization_of_seabirds_california_north_c_ce29a490.reproduction_time_time_budget

15.13 KB
963 rows
13 columns


CREATE TABLE reproduction_time_time_budget (
  "nc_project_short_code" VARCHAR,
  "speciesid" VARCHAR,
  "areaid" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "time" VARCHAR,
  "site" BIGINT,
  "status" BIGINT,
  "event" VARCHAR,
  "prey" VARCHAR,
  "fish_size" VARCHAR,
  "fate" VARCHAR
);