paths.csv

A GeoPressureR path contains positions along a bird trajectory.

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

path should always be used in combination with staps, joined by the composite key (tag_id, stap_id).

Paths

Source: paths-table-schema.json

Name Definition Type
tag_id*

Unique identifier of the tag. Foreign key to tags.tag_id.

Example: 18LX

string
type*

Type of trajectory.

Categories

Example: most_likely

string
stap_id*

Identifier of the stationary period. Together with tag_id, this forms a foreign key to staps (tag_id, stap_id).

Example: 3

number
lat

Latitude of the stationary period.

Constraints
  • minimum: -90
  • maximum: 90

Example: 52.70442

number
lon

Longitude of the stationary period.

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, stap_id — together these identify a row.
  • Foreign key: tag_id → tags.tag_id
  • Foreign key: tag_id, stap_id → staps.(tag_id, stap_id)
  • Missing values: an empty cell, NA.
  • Columns: optional columns listed above may be omitted. Additional columns are not allowed.
  • Required columns: those marked * must be present and must hold a value in every row.