About this Dataset

Snowy Plover Monitoring Point Reyes National Seashore And The San Francisco Bay Area Inventory And Monitoring Network: 2009-2024 – Data Package

This data package contains Snowy Plover monitoring data collected at Point Reyes National Seashore. It includes the following datasets: Snowy Plover Observations, Banding , Nesting, Predator, Chick Band, and Event Metadata.
Organization: Department of the Interior
Last updated: 2025-09-14T19:17:47.946620
Tags: ecological-data, ecological-framework-biological-integrity-at-risk-biota-te-species-and-communities, ecological-framework-biological-integrity-focal-species-or-communities-birds, ecological-monitoring, landbirds, long-term-monitoring, snowy-plovers, snpl-pore-data-package

Tables

SFAN SNPL Bands

@usgov.doi_gov_snowy_plover_monitoring_point_reyes_national_s_646c27f7.sfan_snpl_bands

401.61 kB
9,469 rows
22 columns

CREATE TABLE sfan_snpl_bands (
  "id" BIGINT,
  "snpl_band_idint" BIGINT,
  "snpl_data_id" VARCHAR,
  "event_id" VARCHAR,
  "type" VARCHAR,
  "basis_of_record" VARCHAR,
  "unit_code" VARCHAR,
  "location_id" VARCHAR,
  "loc_code" VARCHAR,
  "loc_name" VARCHAR,
  "start_year" BIGINT,
  "start_date" TIMESTAMP,
  "nest_id" VARCHAR,
  "qcflag" VARCHAR,
  "qcnotes" VARCHAR,
  "leftlegcode" VARCHAR,
  "leftlegdesc" VARCHAR,
  "right_leg" VARCHAR,
  "rightlegdesc" VARCHAR,
  "snpl_sex" VARCHAR,
  "snpl_age" VARCHAR,
  "band_notes" VARCHAR
);

SFAN SNPL ChickBands

@usgov.doi_gov_snowy_plover_monitoring_point_reyes_national_s_646c27f7.sfan_snpl_chickbands

26.87 kB
370 rows
20 columns

CREATE TABLE sfan_snpl_chickbands (
  "id" BIGINT,
  "chick_banddata_idint" BIGINT,
  "nest_id" VARCHAR,
  "snpl_data_id" VARCHAR,
  "type" VARCHAR,
  "basis_of_record" VARCHAR,
  "unit_code" VARCHAR,
  "location_id" VARCHAR,
  "loc_code" VARCHAR,
  "loc_name" VARCHAR,
  "year" BIGINT,
  "scientific_name" VARCHAR,
  "bandcombination" VARCHAR,
  "qcflag" VARCHAR,
  "qcnotes" VARCHAR,
  "chickweight_g" DOUBLE,
  "pctdryness" DOUBLE,
  "eggtoothpresence" VARCHAR,
  "yolksacpresence" VARCHAR,
  "notes" VARCHAR
);

SFAN SNPL Events

@usgov.doi_gov_snowy_plover_monitoring_point_reyes_national_s_646c27f7.sfan_snpl_events

312.09 kB
3,339 rows
37 columns

CREATE TABLE sfan_snpl_events (
  "id" BIGINT,
  "event_id" VARCHAR,
  "type" VARCHAR,
  "basis_of_record" VARCHAR,
  "unit_code" VARCHAR,
  "location_id" VARCHAR,
  "loc_code" VARCHAR,
  "loc_name" VARCHAR,
  "protocol_name" VARCHAR,
  "protocol_description" VARCHAR,
  "start_year" BIGINT,
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "start_time_local" VARCHAR,
  "end_time" VARCHAR,
  "end_time_local" VARCHAR,
  "local_time_zone" VARCHAR,
  "observers" VARCHAR,
  "updated_date" TIMESTAMP,
  "updated_by" VARCHAR,
  "eventqcflag" VARCHAR,
  "eventqcnotes" VARCHAR,
  "event_notes" VARCHAR,
  "survey_direction" VARCHAR,
  "wind_spd_mph" DOUBLE,
  "wind_max_mph" DOUBLE,
  "wind_dir" VARCHAR,
  "air_temp_degf" DOUBLE,
  "rel_hum_per" DOUBLE,
  "cloud_cover" DOUBLE,
  "tide_cond" VARCHAR,
  "incomplete_survey" VARCHAR,
  "eventdetailsqcflag" VARCHAR,
  "eventdetailsqcnotes" VARCHAR,
  "dataprocessinglevel" VARCHAR,
  "dataprocessingleveldate" TIMESTAMP,
  "dataprocessingleveluser" VARCHAR
);

SFAN SNPL Nesting

@usgov.doi_gov_snowy_plover_monitoring_point_reyes_national_s_646c27f7.sfan_snpl_nesting

129.73 kB
846 rows
68 columns

CREATE TABLE sfan_snpl_nesting (
  "id" BIGINT,
  "nest_id" VARCHAR,
  "type" VARCHAR,
  "basis_of_record" VARCHAR,
  "unit_code" VARCHAR,
  "location_id" VARCHAR,
  "loc_code" VARCHAR,
  "loc_name" VARCHAR,
  "year" BIGINT,
  "qcflag" VARCHAR,
  "qcnotes" VARCHAR,
  "decimal_longitude" DOUBLE,
  "decimal_latitude" DOUBLE,
  "coord_system" VARCHAR,
  "datum" VARCHAR,
  "gpsunit" VARCHAR,
  "date_found" TIMESTAMP,
  "date_exclosure" TIMESTAMP,
  "exclosuretype" VARCHAR,
  "microcodes" VARCHAR,
  "microsand" VARCHAR,
  "microcoarse" VARCHAR,
  "microseaweedkelp" VARCHAR,
  "microwoody" VARCHAR,
  "microhumantrash" VARCHAR,
  "microvegetation" VARCHAR,
  "microsmooth" VARCHAR,
  "microsteep" VARCHAR,
  "microhumandogprints" VARCHAR,
  "microhorseprints" VARCHAR,
  "microvehicletracks" VARCHAR,
  "restored_area" VARCHAR,
  "restored_adjacent" VARCHAR,
  "init_date" TIMESTAMP,
  "initiationdateunk" VARCHAR,
  "hatching_date" TIMESTAMP,
  "fledging_date" TIMESTAMP,
  "chickband_date" TIMESTAMP,
  "eggs" DOUBLE,
  "hatchlings" DOUBLE,
  "fledglings" DOUBLE,
  "failure_date" TIMESTAMP,
  "failure_reason" VARCHAR,
  "predator_type" VARCHAR,
  "chickloss_date1" TIMESTAMP,
  "chickloss_age1" DOUBLE,
  "chickloss_weekend1" VARCHAR,
  "chickloss_date2" TIMESTAMP,
  "chickloss_age2" DOUBLE,
  "chickloss_weekend2" VARCHAR,
  "chickloss_date3" TIMESTAMP,
  "chickloss_age3" DOUBLE,
  "chickloss_weekend3" VARCHAR,
  "disturbance" VARCHAR,
  "f_band" VARCHAR,
  "m_band" VARCHAR,
  "eggs_when" TIMESTAMP,
  "eggs_where" VARCHAR,
  "eggs_results" VARCHAR,
  "comment" VARCHAR,
  "created_date" TIMESTAMP,
  "created_by" VARCHAR,
  "updated_date" TIMESTAMP,
  "updated_by" VARCHAR,
  "quality_notes" VARCHAR,
  "dataprocessinglevelnestmaster" VARCHAR,
  "dataprocessingleveldatenestmaster" TIMESTAMP,
  "dataprocessinglevelusernestmaster" VARCHAR
);

SFAN SNPL Observations

@usgov.doi_gov_snowy_plover_monitoring_point_reyes_national_s_646c27f7.sfan_snpl_observations

1.05 MB
13,220 rows
43 columns

CREATE TABLE sfan_snpl_observations (
  "id" BIGINT,
  "snpl_data_id" VARCHAR,
  "event_id" VARCHAR,
  "type" VARCHAR,
  "basis_of_record" VARCHAR,
  "unit_code" VARCHAR,
  "location_id" VARCHAR,
  "loc_code" VARCHAR,
  "loc_name" VARCHAR,
  "start_year" BIGINT,
  "start_date" TIMESTAMP,
  "nest_id" VARCHAR,
  "snpl_time" VARCHAR,
  "snpl_time_local" VARCHAR,
  "local_time_zone" VARCHAR,
  "qcflag" VARCHAR,
  "qcnotes" VARCHAR,
  "waypoint" VARCHAR,
  "decimal_latitude" DOUBLE,
  "decimal_longitude" DOUBLE,
  "coord_system" VARCHAR,
  "datum" VARCHAR,
  "scientific_name" VARCHAR,
  "snpl_male" DOUBLE,
  "snpl_female" DOUBLE,
  "snpl_unk" DOUBLE,
  "snpl_hatchlings" DOUBLE,
  "snpl_fledglings" DOUBLE,
  "snpl_bands" DOUBLE,
  "number_eggs" DOUBLE,
  "behaviorterritorycc" VARCHAR,
  "behaviorterritorylw" VARCHAR,
  "behaviorterritorymd" VARCHAR,
  "behaviorterritorysc" VARCHAR,
  "behaviorterritorycp" VARCHAR,
  "behaviornestcp" VARCHAR,
  "behaviornestdc" VARCHAR,
  "behaviornestai" VARCHAR,
  "behaviornestfn" VARCHAR,
  "behaviorchicksac" VARCHAR,
  "behaviorchicksna" VARCHAR,
  "behaviorotherfg" VARCHAR,
  "snpl_notes" VARCHAR
);