About this Dataset

California Least Tern Monitoring Sites Generalized - CDFW [ds3146] Extended Table

California least tern colonies are monitored during nesting season along the California Coast and data is reported to California Department of Fish and Wildlife. The colonies in this dataset range from the Tijuana river mouth near the Mexico border to Sacramento. Locations and data include both present and historic sites. Locations are approximate and can have variation over time. These approximate locations were overlaid with a statewide hexagon layer (ds675) and then a buffer was created in order to mask exact nesting locations. Some additional sites without location information can be found in the related table. The related table includes nesting data by year from 1990 - 2019. Its anticipated to update this dataset to include earlier and newer records. Monitoring data includes estimated fledglings, estimated breeding pairs, total number of nests, and predator information when included in site reports. Annual reports 2017 and earlier can also be found by searching in California Department of Fish and Wildlifes document library (nrm.dfg.ca.gov/documents/docViewer.aspx).A version of this data, summarized by region, has been made available in BIOS as California Least Tern Monitoring Sites by Region - CDFW [ds3147]. This is a publicly available dataset.
Organization: State of California
Last updated: 2024-03-30T03:20:58.451279
Tags: authcdfw, beach, biota, bird, breeding, california-department-of-fish-and-wildlife, california-least-tern, california-natural-resources-agency, caopendata, cdfw, chronology, coast, colony, ds314620240130wm, environment, estuary, least-tern, nesting, productivity, reproduction, sternula-antillarum-browni, tern

Tables

Table 1

@usgov.ca_gov_california_least_tern_monitoring_sites_generali_c0ef4e40.table_1

87.88 KB
989 rows
46 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "year" BIGINT,
  "site_report_name" VARCHAR,
  "updated_site_name" VARCHAR,
  "f2013_2018_data_site_name" VARCHAR,
  "f1988_2001_data_site_name" VARCHAR,
  "sitename_abbr" VARCHAR,
  "region_3" VARCHAR,
  "region_4" VARCHAR,
  "index_site" VARCHAR,
  "event" VARCHAR,
  "bp_min" DOUBLE,
  "bp_max" DOUBLE,
  "fl_min" DOUBLE,
  "fl_max" DOUBLE,
  "total_nests" VARCHAR,
  "nonpred_eggs" VARCHAR,
  "nonpred_chicks" VARCHAR,
  "nonpred_fl" VARCHAR,
  "nonpred_ad" VARCHAR,
  "pred_control" VARCHAR,
  "pred_eggs" VARCHAR,
  "pred_chicks" VARCHAR,
  "pred_fl" VARCHAR,
  "pred_ad" VARCHAR,
  "pred_pefa" VARCHAR,
  "pred_coy_fox" VARCHAR,
  "pred_meso" VARCHAR,
  "pred_owlspp" VARCHAR,
  "pred_corvid" VARCHAR,
  "pred_other_raptor" VARCHAR,
  "pred_other_avian" VARCHAR,
  "pred_misc" VARCHAR,
  "total_pefa" VARCHAR,
  "total_coy_fox" VARCHAR,
  "total_meso" VARCHAR,
  "total_owlspp" VARCHAR,
  "total_corvid" VARCHAR,
  "total_other_raptor" VARCHAR,
  "total_other_avian" VARCHAR,
  "total_misc" VARCHAR,
  "first_observed" TIMESTAMP,
  "last_observed" TIMESTAMP,
  "first_nest" TIMESTAMP,
  "first_chick" TIMESTAMP,
  "first_fledge" TIMESTAMP
);