edges.csv

In GeoPressureR, we uses edges (of a graph; See more infomration on the movement model in the GeoPressureManual) to extract flight information from GeoPressureP paths using path2edge().

Edges

Source: edges-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
stap_s*

Identifier of the SOURCE stationary period. Foreign key to staps.stap_id

Constraints
  • required: true

Example: 3

number
stap_t*

Identifier of the TARGET stationary period. Generally stap_s+1 exept if include=FALSE for intermediate stap_id. Foreign key to staps.stap_id.

Constraints
  • required: true

Example: 4

number
lat_s*

Latitude of source the stationay period.

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

Example: 52.70442

number
lon_s*

Longitude of the source stationay period.

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

Example: 23.84995

number
lat_t*

Latitude of the target stationay period.

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

Example: 52.70442

number
lon_t*

Longitude of the target stationay period.

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

Example: 23.84995

number
s

Index of the 2D coordinate of the source stap. See paths.ind for more information

Constraints
  • required: false
  • minimum: 1

Example: 23343

integer
t

Index of the 2D coordinate of the target stap. See paths.ind for more information

Constraints
  • required: false
  • minimum: 1

Example: 23343

integer
j

Unique identifier for each simulated trajectory, integer from 1 to nj as defined in GeoPressureR::graph_simulation()`.

Constraints
  • required: false
  • 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.

Constraints
  • required: true

Example: 2020-04-01T05:50:00Z

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.

Constraints
  • required: true

Example: 2020-04-02T21:18:00Z

datetime
n

Number of flight.

Constraints
  • required: false
  • minimum: 1

Example: 1

integer
distance

distance of the flight in km.

Constraints
  • required: false
  • minimum: 0

Example: 235

number
bearing

Direction of the flight in degree. 0 indicates north, positive indicate eastward direction, and negative indicate westward direction.

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

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).

Constraints
  • required: false

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).

Constraints
  • required: false

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).

Constraints
  • required: false

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).

Constraints
  • required: false

Example: 5.5

number