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

Name	Definition	Type
`tag_id`*	Unique identifier of the tag. Foreign key to `tags.tag_id`. Constraints required: `true` 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`. Constraints required: `true` Example: `2020-04-01T22:00:00Z` Close to http://vocab.nerc.ac.uk/collection/MVB/current/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. Constraints required: `true` 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()`. Constraints required: `true` enum: `tag, most_likely, simulation, geopressureviz` Example: `3`	string
`lat`*	Latitude of the trajectory position at this timestamp. Constraints required: `true` minimum: `-90` maximum: `90` Example: `52.70442` Same as http://rs.tdwg.org/dwc/terms/decimalLatitude	number
`lon`*	Longitude of the trajectory position at this timestamp. Constraints required: `true` minimum: `-180` maximum: `180` Example: `23.84995` Same as http://rs.tdwg.org/dwc/terms/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 required: `false` minimum: `1` Example: `1`	integer