The Stations query is used to show station data, showing each station per row.
You can download the stations using the default ‘Stations’ report.
Contents
Filters
There are no required filters for this query.
Data provider settings
There are no data provider settings for this query.
Columns
|
Column |
Description |
Example |
|---|---|---|
|
Airport authority |
The Airport authority contact for this Station. See Airport authority (Glossary). |
Amsterdam Airport Schiphol |
|
Airport authority contact ID |
The Airport authority contact’s unique ID in GUID format. |
4b61e582-bd5b-401d-a845-42ba2d479f72 |
|
Country |
The country for the station. See ‘Description’ field in Countries (Administration). |
Netherlands |
|
Country code |
The country code for the station. See ‘Unofficial 2 letter code' field in Countries (Administration). |
NL |
|
Country ID |
The country’s unique ID in GUID format. |
92965af3-db72-4bdd-bf17-c15372e50480 |
|
IATA code |
The station’s IATA airport code. |
AMS |
|
ICAO code |
The station’s ICAO airport code. |
EHAM |
|
Name |
The station name. |
Schiphol, Amsterdam |
|
Place |
The station place name. |
Amsterdam |
|
QRCode |
Allows generating a QR code using data from other columns, see How to add a QR code to a report. Example shown:
|
|
|
Station groups |
The Station groups (Administration) the station is a member of. Note: If multiple, then each station group is separated by a comma. |
Europe, Netherlands, Schengen |
|
Station ID |
The Station’s unique ID in GUID format. |
bcc7b473-195a-4724-9ae7-700d2dd7a71f |
|
Time zone code |
The station’s time zone code. See ‘TimeZoneCode’ field in Time zones (Administration). |
W. Europe |
|
Time zone offset |
The station’s time zone offset number. See ‘Offset’ field in Time zones (Administration). Info: The difference in hours and minutes (as a decimal) from UTC. For example 8.00 for China, or -10.00 for Hawaii. See List of UTC time offsets. |
1 |
Comments
0 comments
Please sign in to leave a comment.