pressurepaths.csv

A GeoPressureR pressurepath contains ERA5 variables along the bird trajectory at hourly intervals, using the exact bird location (including flight segments). Read more about pressurepaths in the GeoPressureManual

Similarly to path, there are 4 pressurepath types: tag, most_likely, simulation, and geopressureviz. See pressurepaths.type for more details.

pressurepath should be used in combination with staps and paths. Joins are performed on tag_id and, for stationary rows, stap_id.

Only tag_id is defined as a strict foreign key here. stap_id can be decimal during migration segments, so it cannot be enforced as a strict foreign key to staps in all rows.

The definition below does not list ERA5 variables, which can (and should!) be added to the table as additional columns (e.g., 'altitude' or 'surface_pressure'). Read more about these variables in the documentation of pressurepath_create().

Pressurepaths

Source: pressurepaths-table-schema.json

Foreign key: tag_id → tags.tag_id
Missing values: an empty cell, NA.
Other columns: any column listed below may be left out, and columns not listed below are allowed and kept as they are.
Required columns: those marked * must be present and must hold a value in every row, whatever the rule above allows.

Name	Definition	Type
`tag_id`*	Unique identifier of the tag. Foreign key to `tags.tag_id`. Example: `18LX`	string
`datetime`*	Date and time of the pressure measurement. Formatted as an ISO 8601 string with timezone designator `YYYY-MM-DDThh:mm:ssZ`. Example: `2020-04-01T22:00:00Z` Close to MVB000200	datetime
`stap_id`*	Identifier of the stationary-period index for the trajectory. Integer values correspond to `staps.stap_id` within the same `tag_id`; decimal values indicate pressure measurements taken during migration between two integer stationary periods. For this reason, `stap_id` is not a strict foreign key in this table. Example: `3`	number
`type`*	One of: `tag`: Created with `tag2path()` from a likelihood map. `most_likely`: Created with `graph_most_likely()`. `simulation`: Created by `graph_simulation()`. `geopressureviz`: Created by `geopressureviz()`. Categories `tag` — Tag `most_likely` — Most likely `simulation` — Simulation `geopressureviz` — GeoPressureViz Example: `most_likely`	string
`lat`*	Latitude of the trajectory position at this timestamp. Constraints minimum: `-90` maximum: `90` Example: `52.70442` Same as dwc:decimalLatitude	number
`lon`*	Longitude of the trajectory position at this timestamp. Constraints minimum: `-180` maximum: `180` Example: `23.84995` Same as dwc:decimalLongitude	number
`j`	Only useful for `pressurepaths.type='simulation'`. Unique identifier for each trajectory, integer from `1` to `nj` as defined in `GeoPressureR::graph_simulation()`. Constraints minimum: `1` Example: `1`	integer