Stations query

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

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 https://amsterdam.jira.com/wiki/spaces/MAN/pages/2445049868.

Example shown:

  • Settings: ShowBarCodeOnEveryRow=true; MultipleValuesSeparator=" | "

  • Columns: ICAO code, IATA code, Name, Country

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