pressurepaths.csv

A GeoPressureR pressurepath constains the ERA5 variables along the trajectory of the bird on an hourly interval and using the exact location of the bird (accounting of flight). Read more about pressurepath on the GeoPressureManual

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

pressurepath should be used in combinaison with staps and paths which can be JOIN by tag_id and stap_id.

The definition below does not list the ERA5 variables which can (and should!) be added to the table as additional columns (e.g. 'altitude' or 'surface_pressure'). Read more about these variable 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

datetime
stap_id*

Identifier of the stationary period. Foreign key to staps.stap_id. A main different with pressurepath is that stap_id can have decimal value indicating a pressure measurement taken while in migration between two ‘integer’ stationary periods.

Constraints
  • required: true

Example: 3

number
type*

One of:

Constraints
  • required: true
  • enum: tag, most_likely, simulation, geopressureviz

Example: 3

string
lat*

Latitude of the stationay period.

Constraints
  • required: true
  • minimum: -90
  • maximum: 90

Example: 52.70442

number
lon*

Longitude of the stationay period.

Constraints
  • required: true
  • minimum: -180
  • maximum: 180

Example: 23.84995

number
ind

Indices of the 2D coordinate of the spatial map defined in GeoPressureR::tag_set_map() (see also GeoPressureR::map_expand(). Useful to retrieve information on the graph (e.g. GeoPressureR::path2edge(). This value is the main way to create a path in GeoPressureR through GeoPressureR::ind2path().

Constraints
  • required: false
  • minimum: 1

Example: 23343

integer
j

Only useful for paths.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