edges.csv

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

Name Definition Type
tag_id*

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

Constraints
  • required: true

Example: 18LX

 string
type*

Same as paths.type. One of: tag, most_likely, simulation or geopressureviz.

Constraints
  • required: true
  • enum: tag, most_likely, simulation, 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).

Constraints
  • required: true

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

Constraints
  • required: true

Example: 4

 number
lat_s*

Latitude of the source stationary period.

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

Example: 52.70442

 number
lon_s*

Longitude of the source stationary period.

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

Example: 23.84995

 number
lat_t*

Latitude of the target stationary period.

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

Example: 52.70442

 number
lon_t*

Longitude of the target stationary period.

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

Example: 23.84995

 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
  • 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

Flight number.

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 degrees. 0 indicates north and values increase clockwise. In general, this should be 0°-360°, but -180° to 180° is also allowed.

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

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