pressurepaths.csv

A GeoPressureR pressurepath contains ERA5 variables along the bird trajectory, with one row per pressure measurement of the tag (so at the tag’s sampling interval), using the exact bird location (including flight segments). ERA5 values are taken at the nearest hour. Read more about pressurepaths in the GeoPressureManual

See pressurepaths.type for the supported trajectory types and how they are created.

pressurepath should be used in combination with staps and paths. For stationary rows, join to staps on (tag_id, stap_id). When joining to paths, also match type and j to keep trajectories separate. Decimal stap_id values during flight do not match a stationary-period row in either table.

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

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

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*

Type of trajectory.

Categories

Example: most_likely

string
lat*

Latitude of the trajectory position at this timestamp.

Constraints
  • minimum: -90
  • maximum: 90

Example: 52.70442

number
lon*

Longitude of the trajectory position at this timestamp.

Constraints
  • minimum: -180
  • maximum: 180

Example: 23.84995

number
j*

Trajectory identifier within each combination of tag_id and type. For simulation, use an integer from 1 to nj as defined in GeoPressureR::graph_simulation(). Use 1 for other trajectory types.

Constraints
  • minimum: 1

Example: 1

integer

Table rules

  • Primary key: tag_id, type, j, datetime — together these identify a row.
  • Foreign key: tag_id → tags.tag_id
  • Missing values: an empty cell, NA.
  • Columns: optional columns listed above may be omitted. Additional columns are allowed.
  • Required columns: those marked * must be present and must hold a value in every row.