Property talk:P239

Documentation

ICAO airport code
four-character alphanumeric identifier for designating airports (for airlines, see P230)

Description

ICAO code for identifying airports. For airlines, rather use ICAO airline designator (P230).

Represents

ICAO airport code (Q207529)

Has quality

all caps (Q3960579)

Data type

String

Domain

According to this template: places: airports - aerodrome (Q62447), mainly airport (Q1248784)

According to statements in the property:
aerodrome (Q62447)

When possible, data should only be stored as statements

Allowed values

([A-Z]{2}|[CKY][A-Z0-9])([A-Z]{2}|[0-9]{2,4})

Example

Pierrefonds Airport (Q17431) → FMEP
Brisbane Airport (Q45523) → YBBN
Rimouski Airport (Q3912794) → CYXK

Source

ICAO airport code (Q207529) (note: this information should be moved to a property statement; use property source website for the property (P1896))

Tracking: same

no label (Q32085217)

Tracking: differences

no label (Q22013021)

Tracking: usage

Category:Pages using Wikidata property P239 (Q22013028)

Tracking: local yes, WD no

no label (Q22013018)

Lists

Proposal discussion

Current uses

Total	20,600
Main statement	20,597	>99.9% of uses
Qualifier	3	<0.1% of uses

Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Type “aerodrome (Q62447)”: item must contain property “instance of (P31)” with classes “aerodrome (Q62447)” or their subclasses (defined using subclass of (P279)). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P239#Type Q62447, SPARQL

Single value: this property generally contains a single value. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Atarot Airport (Q573379), EuroAirport Basel-Mulhouse-Freiburg (Q156971)
List of violations of this constraint: Database reports/Constraint violations/P239#Single value, SPARQL

Distinct values: this property likely contains a value that is different from all other items. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Berlin Schönefeld Airport (Q9689), Old Ishigaki Airport (Q705963)
List of violations of this constraint: Database reports/Constraint violations/P239#Unique value, SPARQL (every item), SPARQL (by value)

Item “coordinate location (P625)”: Items with this property should also have “coordinate location (P625)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P239#Item P625, SPARQL

Item “country (P17)”: Items with this property should also have “country (P17)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Wright Brothers Field (Q106574534)
List of violations of this constraint: Database reports/Constraint violations/P239#Item P17, search, SPARQL

Scope is as main value (Q54828448): the property must be used by specified way only (Help)

List of violations of this constraint: Database reports/Constraint violations/P239#Scope, hourly updated report, SPARQL

Format “([A-Z]{2}|[CKY][A-Z0-9])([A-Z]{2}|[0-9]{2,4})”: value must be formatted using this pattern (PCRE syntax). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P239#Format, SPARQL

Single best value: this property generally contains a single value. If there are several, one would have preferred rank (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P239#single best value, SPARQL

Item “aerodrome reference point (P2786)”: Items with this property should also have “aerodrome reference point (P2786)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P239#Item P2786, SPARQL

This property is being used by:

Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Request to change en title to ICAO airport code[edit]

I want to have the title changed to ICAO airport code, in order to avoid conflict with the ICAO airline code property. Harryboyles (talk) 10:32, 7 March 2013 (UTC)[reply]

Have done so. Harryboyles (talk) 10:41, 7 March 2013 (UTC)[reply]

format constraint[edit]

i changed it from [A-Z][A-Z][A-Z][A-Z] to ([A-Z][A-Z]|[CKY][A-Z0-9])[A-Z0-9][A-Z0-9], since the locally assigned code parts may contain digits. --Akkakk 23:40, 3 June 2013 (UTC)[reply]

I've changed the regex since there happen to be pseudo codes (very small aerodromes using a country-based ICAO code) for instance Q30738830

testable here ([A-Z]{2}|[CKY][A-Z0-9])([A-Z]{2}|[0-9]{2,4}) Feel free to modify the regex if you find it inappropriate. Bouzinac (talk) 19:44, 23 November 2019 (UTC)[reply]

@Bouzinac: Many small Czech airfields (e. g. Kejžlice Airfield (Q111494366) and Jehnědí Airfield (Q112066471)) has LKABCD-type code. I don't know, whether the airport code has been officially assigned, but those 6-letter codes seem to appear in may aviation maps. — Draceane ^talk_contrib. 21:46, 15 December 2022 (UTC)[reply]

Property constraint concerning IATA code[edit]

The constraint regarding IATA codes should be removed, because not all airfields with an ICAO code even have an IATA code assigned. Cheers --MB-one (talk) 15:13, 12 August 2017 (UTC)[reply]

Done --MB-one (talk) 10:49, 26 September 2017 (UTC)[reply]

ICAO codes being reassigned...[edit]

For example, en:MOD_St_Athan changed ICAO code from EGXD to EGSY (which used to be en:Sheffield City Airport.

This means the warnings on Q3565572 and Q3915754 for ICAO code reuse, and having more than one ICAO code are irritating...

Reedy (talk) 00:10, 28 April 2019 (UTC)[reply]

Distinct values constraint Closed Airport[edit]

Q330015 and Q1436575 have overlapping values for P239. How should this be handled because Q1436575 is closed?

Done with deprecated values. Bouzinac (talk) 19:37, 23 November 2019 (UTC)[reply]

Proposal - Change Data type of ICAO airport code (P239) from String to External identifier[edit]

I think String is the wrong type for ICAO airport code (P239). Can we please change it to be External identifier.

As per Help:Data_type#Changing_datatype please indicate support/opposition below. Iwan.Aucamp (talk) 16:52, 15 October 2019 (UTC)[reply]

Discussion[edit]

Comment See the large number of "Unique value" constraint violations in the constraint report linked above. These should be cleaned up somehow before this is made a real external id, if that is to happen. ArthurPSmith (talk) 17:23, 15 October 2019 (UTC)[reply]