Data dictionary¶
Auto-generated from SQLMesh model metadata and Soda contracts. Regenerate with uv run python scripts/generate_docs.py.
- Models: 18
- Soda contracts: 25
- Lineage: browse the dependency graph
analytics¶
Operational analytics models retained outside the CDM, such as platform health.
| Model | Contract | Description |
|---|---|---|
analytics.platform_health |
yes | Per-source load observability — most recent dlt load id, completion time, status, and row volume |
birding_agent¶
Planner-ready SQL interfaces for the Birding Trip Copilot agent and local product.
| Model | Contract | Description |
|---|---|---|
birding_agent.arizona_species_catalog |
yes | One row per taxon from the single latest complete eBird US-AZ snapshot, with latest complete taxonomy, exact AVONET traits, and coherent public evidence aggregates. |
birding_agent.gbif_occurrence_evidence |
yes | Planner-ready GBIF bird occurrence evidence conformed to eBird-first species names with location, license, and source provenance. |
birding_agent.recent_observation_evidence |
yes | Planner-ready recent eBird observation evidence from the environmental observations CDM. |
birding_agent.species_lookup |
yes | Planner-ready bird species lookup from the conformed environmental observations species dimension. |
birding_agent.xeno_canto_media_evidence |
yes | Planner-ready Xeno-canto bird sound metadata with media links, license, attribution, and provenance. |
environmental_observations¶
Canonical environmental-observations CDM models generated from the .schema workflow.
| Model | Contract | Description |
|---|---|---|
environmental_observations.dim_bird_hotspot |
yes | CDM eBird hotspot dimension. |
environmental_observations.dim_bird_species_traits |
yes | Exact scientific-name-conformed AVONET v7 species-average bird traits with measurement and dataset provenance. |
environmental_observations.dim_species |
yes | Conformed CDM species dimension from eBird taxonomy, GBIF occurrence taxonomy, and Xeno-canto recording metadata. |
environmental_observations.dim_streamgage_site |
yes | CDM USGS streamgage site dimension. |
environmental_observations.dim_weather_station |
yes | CDM NOAA weather station dimension. |
environmental_observations.fact_bird_observation |
yes | CDM fact: one row per eBird observation submission id across recent and notable feeds. |
environmental_observations.fact_bird_occurrence |
yes | CDM fact: one row per GBIF bird occurrence key. |
environmental_observations.fact_bird_sound_recording |
yes | CDM fact: one row per Xeno-canto bird sound recording id; media remains externally linked. |
environmental_observations.fact_earthquake_event |
yes | CDM fact: one row per USGS earthquake event id. |
environmental_observations.fact_region_daily_stats |
yes | CDM fact: one row per eBird region per calendar date. |
environmental_observations.fact_streamflow_observation |
yes | CDM fact: one row per USGS streamgage site per observation date per parameter code. |
environmental_observations.fact_weather_observation |
yes | CDM fact: one row per NOAA station per observation date per datatype. |