edges.csv - GeoLocator DP

In GeoPressureR, edges (graph edges; see more information on the movement model in the GeoPressureManual) are used to extract flight information from GeoPressureR paths using path2edge().

Edges

Source: edges-table-schema.json

Foreign key: tag_id → tags.tag_id
Foreign key: tag_id, stap_s → staps.tag_id, stap_id
Foreign key: tag_id, stap_t → staps.tag_id, stap_id
Missing values: an empty cell, NA.
Other columns: only the columns listed below are allowed. Any column may be left out.
Required columns: those marked * must be present and must hold a value in every row, whatever the rule above allows.

Name	Definition	Type
`tag_id`*	Unique identifier of the tag. Foreign key to `tags.tag_id`. Example: `18LX`	string
`type`*	Same as `paths.type`. One of: `tag`, `most_likely`, `simulation` or `geopressureviz`. Categories `tag` — Tag `most_likely` — Most likely `simulation` — Simulation `geopressureviz` — GeoPressureViz Example: `tag`	string
`stap_s`*	Identifier of the SOURCE stationary period. Together with `tag_id`, this forms a foreign key to `staps` (`tag_id`, `stap_id`). Example: `3`	number
`stap_t`*	Identifier of the TARGET stationary period. Generally `stap_s+1`, except if `include=FALSE` for intermediate `stap_id` values. Together with `tag_id`, this forms a foreign key to `staps` (`tag_id`, `stap_id`). Example: `4`	number
`lat_s`*	Latitude of the source stationary period. Constraints minimum: `-90` maximum: `90` Example: `52.70442` Same as dwc:decimalLatitude	number
`lon_s`*	Longitude of the source stationary period. Constraints minimum: `-180` maximum: `180` Example: `23.84995` Same as dwc:decimalLongitude	number
`lat_t`*	Latitude of the target stationary period. Constraints minimum: `-90` maximum: `90` Example: `52.70442` Same as dwc:decimalLatitude	number
`lon_t`*	Longitude of the target stationary period. Constraints minimum: `-180` maximum: `180` Example: `23.84995` Same as dwc:decimalLongitude	number
`j`	Same as `paths.j`. Unique identifier for each trajectory. Only useful for `edges.type='simulation'`. Integer from `1` to `nj` as defined in `GeoPressureR::graph_simulation()`. Constraints minimum: `1` Example: `1`	integer
`start`*	Date and time of the start of the flight. Formatted as an ISO 8601 string with timezone designator `YYYY-MM-DDThh:mm:ssZ`. Example: `2020-04-01T05:50:00Z` Close to MVB000200	datetime
`end`*	Date and time of the end of the flight. Formatted as an ISO 8601 string with timezone designator `YYYY-MM-DDThh:mm:ssZ`. Example: `2020-04-02T21:18:00Z` Close to MVB000200	datetime
`n`	Flight number. Constraints minimum: `1` Example: `1`	integer
`distance`	Distance of the flight in km. Constraints minimum: `0` Example: `235`	number
`bearing`	Direction of the flight in degrees. 0 indicates north and values increase clockwise. In general, this should be 0°-360°, but -180° to 180° is also allowed. Constraints minimum: `-180` maximum: `360` Example: `30`	number
`gs_u`	The average groundspeed of the entire flight along the longitudinal axis (east-west direction), measured in kilometers per hour (km/h). Example: `35.5`	number
`gs_v`	The average groundspeed of the entire flight along the latitudinal axis (north-south direction), measured in kilometers per hour (km/h). Example: `45.1`	number
`ws_u`	The average windspeed of the entire flight along the longitudinal axis (east-west direction), measured in kilometers per hour (km/h). Example: `15.1`	number
`ws_v`	The average windspeed of the entire flight along the latitudinal axis (north-south direction), measured in kilometers per hour (km/h). Example: `5.5`	number