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 Example: |
string |
type*
|
Type of trajectory. Categories
Example: |
string |
stap_id*
|
Identifier of the stationary period. Together with Example: |
number |
lat
|
Latitude of the stationary period. Constraints
Example:
|
number |
lon
|
Longitude of the stationary period. Constraints
Example:
|
number |
j*
|
Trajectory identifier within each combination of
Example: |
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.