environmental_observations.fact_bird_observation¶
CDM fact: one row per eBird checklist submission and species across recent and notable feeds.
Overview¶
| Field | Value |
|---|---|
| Schema | environmental_observations |
| Name | fact_bird_observation |
| Kind | FULL |
| Soda contract | soda/contracts/environmental_observations/fact_bird_observation.yaml |
Columns¶
| Column | Type | Checks | Notes |
|---|---|---|---|
bird_hotspot_sk |
UNKNOWN |
missing (must_be=0) | — |
bird_observation_sk |
TEXT |
missing (must_be=0), duplicate (must_be=0) | — |
count_display |
TEXT |
— | — |
dlt_id |
UNKNOWN |
— | — |
dlt_load_id |
UNKNOWN |
— | — |
exotic_category |
UNKNOWN |
— | — |
is_location_private |
UNKNOWN |
— | — |
is_notable |
UNKNOWN |
— | — |
is_reviewed |
UNKNOWN |
— | — |
is_valid |
UNKNOWN |
— | — |
latitude |
UNKNOWN |
— | — |
loaded_at |
UNKNOWN |
— | — |
location_id |
UNKNOWN |
— | — |
location_name |
UNKNOWN |
— | — |
longitude |
UNKNOWN |
— | — |
observation_count |
UNKNOWN |
— | — |
observation_date |
DATE |
— | — |
observation_datetime |
UNKNOWN |
— | — |
observation_day |
BIGINT |
— | — |
observation_hour |
BIGINT |
— | — |
observation_month |
BIGINT |
— | — |
observation_year |
BIGINT |
— | — |
region_code |
UNKNOWN |
— | — |
source_observation_id |
TEXT |
missing (must_be=0), duplicate (must_be=0) | — |
source_pipeline |
TEXT |
— | — |
source_table |
UNKNOWN |
— | — |
species_code |
UNKNOWN |
— | — |
species_sk |
UNKNOWN |
missing (must_be=0) | — |
Table-level checks¶
- row_count — must_be_greater_than=0
Lineage¶
Upstream
environmental_observations.dim_bird_hotspotenvironmental_observations.dim_speciesraw_ebird.notable_observations(external)raw_ebird.recent_observations(external)
Example query¶
SELECT * FROM environmental_observations.fact_bird_observation LIMIT 100;