search

jpatokal / openflights

Website for storing flight information, rendering paths on a zoomable world map and calculating statistics, with plenty of free airline, airport and route data.
http://openflights.org
GNU Affero General Public License v3.0
1.4k stars 393 forks source link

Update airport EuroAirport Basel-Mulhouse-Freiburg (MLH/LFSB) #753

Open jpatokal opened 7 years ago

jpatokal commented 7 years ago

New airport edit suggestion submitted by ibz:

UPDATE airports SET name='EuroAirport Basel-Mulhouse-Freiburg', city='Basel', country='Switzerland', iata='MLH', icao='LFSB', x=7.529167, y=47.590, elevation=885, timezone=1, dst='E' WHERE apid=4053;

Existing, potentially conflicting airport information:

Array
(
    [name] => EuroAirport Basel-Mulhouse-Freiburg Airport
    [city] => Mulhouse
    [country] => France
    [iata] => BSL
    [icao] => LFSB
    [x] => 7.5291667
    [y] => 47.59
    [elevation] => 885
    [apid] => 1423
    [uid] => 
    [timezone] => 1
    [dst] => E
    [tz_id] => Europe/Paris
    [type] => airport
    [source] => OurAirports
)

Array
(
    [name] => EuroAirport Basel-Mulhouse-Freiburg
    [city] => Basel
    [country] => Switzerland
    [iata] => 
    [icao] => 
    [x] => 7.529167
    [y] => 47.59
    [elevation] => 885
    [apid] => 4053
    [uid] => 87
    [timezone] => 1
    [dst] => E
    [tz_id] => Europe/Paris
    [type] => airport
    [source] => User
)

Cross-check this edit on other sites with compatible licensing:

jpatokal commented 6 years ago

New airport edit suggestion submitted by foxyankee:

INSERT INTO airports(name,city,country,iata,icao,x,y,elevation,timezone,dst,uid) VALUES('Basel-Mulhouse', 'Mulhouse', 'France', 'MLH', 'LFSB', 7.529167, 47.590000, 885, -2, 'E', 51261);

Existing, potentially conflicting airport information:

Array
(
    [name] => EuroAirport Basel-Mulhouse-Freiburg Airport
    [city] => Mulhouse
    [country] => France
    [iata] => BSL
    [icao] => LFSB
    [x] => 7.5291667
    [y] => 47.59
    [elevation] => 885
    [apid] => 1423
    [uid] => 
    [timezone] => 1
    [dst] => E
    [tz_id] => Europe/Paris
    [type] => airport
    [source] => OurAirports
)

Cross-check this edit on other sites with compatible licensing:

foxyankee commented 6 years ago

The problem is:

This particular airport has tow or even three codes as this airport is built ON THE border between Switzerland (Basel) and France (Mulhouse).

This means: The ICAO Code stays the same: LFSB But IATA Code is different because you can fly within France / or towards the french arrival sector to Mulhouse (not touching Switzerland). On the other hand you can fly to Basel Switzerland BSL not touching France.

Can we move the MLH airport towards the north by 10 Meters? This does not change anything important but we can have the airport of MLH in the database!

Thank you!