etisplus air transport data collection & selected results oliver schnell mkmetric gmbh...

15
ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH [email protected] www.mkm.de 05.11.2012- Brussels

Upload: jovan-below

Post on 31-Mar-2015

223 views

Category:

Documents


4 download

TRANSCRIPT

Page 1: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

ETISplus

Air transport

Data collection & selected resultsOliver Schnell

MKmetric [email protected]

www.mkm.de05.11.2012- Brussels

Page 2: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

2

Fields of Data Collection in Air Transport• Air network (WP7), consisting of

- Airports, including supply indicators- Air links between airports generated- Impedances calculated=> In principal data validation already takes place within the process of generating the air network=> But internal ETIS+ evaluation showed some need for improving check algorithms for flight schedule input (times, daylight saving times, stopovers)

• Air passenger (WP9) and air cargo (WP8) flows- link loads- node loads=> In principal data validation already takes place within the process of generating the air passenger and cargo flows

-

Page 3: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

Approach to built the air networks (2005&2010)

Harmonised Statistics for links (airport pairs) in tons /

passengers from EUROSTAT & other sources

Flights from airlines, airports, tour operators and commercial schedule data provider

Flight database to calculate paths airport <-> airport

MKmetric Connection builder

Airport-airport-connections

Additional (charter) flights not covered by OAG

mn aggregation tool (MKm)

Regionalisation for ETISplus Europe: NUTS3, US etc: Federal States, Rest of World: countries / states (NEA)

Airports to be considered as O & D

Carrier & airport specific minimum connecting / transhipment times to collectAir network (i.e. Airport-airport-legs including path information (sequence of nodes)

Region-Region impedances (time, distance, ...)

KIT

(Mixed) links region <-> airport

APC Airport / route choice tool (MKm) as part of the calibration process (WP9) for costs

Dark green: external input

Light green: adjusted external input

Light blue: intermediate output to be further used in the approach

Dark blue: Ouput

Orange: MKmetric internal tools

As schedule and statistics are published regularly: repeatable process feasible year by year!

Page 4: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

4

Checks done when generating the network

• Flight schedules may vary day by day, but calculating airport-airport connections for each day of a year is not feasible. Solution: use schedules of “typical week” (2nd week in June). Resulting in:- enrich typical week by flights between airports where statistics exist but no schedules - transfer those flights offered only seasonally or ceased / introduced during the year into typical week with representative frequency (7/7 5 months => 3/7 avg.)

• Internal validation showed:- for some flights incorrect schedules were provided from commercial sources(flight times to long / to short in opposite direction (e.g. Manchester – Goa, India)- variants in country specific period when daylight saving times apply, may cause to short / to long flight times, when transferring flights into typical week- multi-stop flights may cause “suspicious” flight times (to long for given distance),

so procedures for automatic corrections of flight times must deal with intermediate stopsSolution: check flight schedules on air link speed, minimum / maximum times, arrival day info.

Page 5: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

Air passenger: Approach schemeHarmonised passenger statistics for links and nodes (Eurostat, national statistics e.g. US, DE)

Data base for calibration process

Iterative calibration process to balance economic weights of regions, link loads, 3-point or destination statistics, node loads and impedances

Regionalisation and corresponding socio-economic data (trip generation)

Air passenger matrix between ETISplus regions

for three trip purposes according to regional data

Feeder links region <-> airport (combined of rail & road feeders

Additional “statistics” according to flights

Air passenger network airport<->airport

Air transport impedances region<->region

WP7

Passengers surveys for trip purpose split and route choice

• On base of a start-up matrix (year before), building the matrix is a repeatable process

Page 6: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

Iterative calibration process

Distribution

Generation

Route Choice

Assignment Link Load Assessment

Matrix Evaluation

Airport / Route Choice Assessment

Basic Statistic Evaluation

Matrix Bounding

Model / Input Adjustment

Statistic Evaluation

• Continuous validation is the core part of the matrix generating process

• The iterative process results in a flow matrix, where the overall sum of deviations between assigned link / node loads and link / airport statistics is minimal (but not 0)

• The same principal approach has been done for air cargo

Page 7: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

7

Resulting networks delivered, Terminals

• The air networks delivered consists of three components:• airport file, for each airport consisting of

DATA_GROUP Metadata on dataset level, since the DB-system only supports metadata on table level. Observed, estimated, modeled data

SOURCE Metadata on dataset level, since the DB-system only supports metadata on table level. Data provider, e.g. UN, EUROSTAT, NEA, IWW, MKm, TRT, …

FROMDATE effective in time range; YEAR or period Fromdate, Todate , e.g. Fromdate 20090101, todate20091231 is preferred

TODATE effective in time range; YEAR or period Fromdate, Todate , e.g. Fromdate 20090101, todate20091231 is preferred

SEASON effective in time range; WINTER | SUMMER | ALL; so that this information need not be deduced by client programs

NoteID Numeric IdentifierTLC Origin [TLC) e.g. FRAAirport Name X_coordinate decimal longitude coordinateY_coordinate decimal latitude coordinateNumerous indicators Supply side finished, demand finished, all delivered

Page 8: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

Demand indicators air transport

• Outcome of the projects TOOLQIT, ETIS Base and WORLDNET has been scanned for indicators to be derived directly or indirectly from the networks.

• Further input came from the modeller workshop, Brussels, 14.3.2011 The following terminal indicators for the demand side of air transport have

been derived based on the passenger / cargo matrices:- total number of passengers- total number of domestic passengers- total number of intercontinental passengers- total number of Schengen passengers- total number of European passengers- total number of North American passengers- total number of South and Middle American passengers- total number of Asian, Australian / Oceania passengers- total number of African passengers- total number of Middle East passengers

- total number of air cargo tons

Page 9: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

International Air Passengers 2010

Intercontinental Air TravelDeparting Passengers 2010 [mill.]

20

10

2

North AmericaSouth AmericaAfricaAsiaOcenaia

European Air TravelDeparting passengers 2010 [mill.]

0 to 11 to 22 to 55 to 10

10 to 2525 to 5050 to 75

Page 10: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

10

Supply indicators air transport

The following terminal indicators for the supply side of air transport were derived:

- total number of aircraft movements passenger transport (PAS_CAF of EUROSTAT) - total number of air cargo liner movements (TOT_CAF \ PASS_CAF of EUROSTAT)- largest airplane (MTOW) which landed/started (MKm network)- total seat capacity offered (PAS_ST of EUROSTAT) - total cargo capacity offered (MKm network)- number of destinations offered (MKm network)- number of domestic destinations (MKm network)- number of intercontinental destinations (MKm network)- number of European destinations (MKm network)- number of Schengen destinations (MKm network)- airlines market position, by seats for top ten & other (MKm network)- alliance market position by seats Oneworld, Sky team, Star Alliance, Low Cost, other

(MKm network)

Page 11: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

Example: Airports by Carrier Type

AALAALAALAALAALAALAALAALAAL

AARAARAARAARAARAARAARAARAAR

ABCABCABCABCABCABCABCABCABC

ABZABZABZABZABZABZABZABZABZ

ACHACHACHACHACHACHACHACHACH

ADBADBADBADBADBADBADBADBADB

AGBAGBAGBAGBAGBAGBAGBAGBAGB

AGFAGFAGFAGFAGFAGFAGFAGFAGF

AGHAGHAGHAGHAGHAGHAGHAGHAGH

AHOAHOAHOAHOAHOAHOAHOAHOAHO

AJAAJAAJAAJAAJAAJAAJAAJAAJA

ALCALCALCALCALCALCALCALCALC

ALLALLALLALLALLALLALLALLALL

AMSAMSAMSAMSAMSAMSAMSAMSAMS

ANEANEANEANEANEANEANEANEANE

ANGANGANGANGANGANGANGANGANG

ANRANRANRANRANRANRANRANRANRAOCAOCAOCAOCAOCAOCAOCAOCAOC

AOEAOEAOEAOEAOEAOEAOEAOEAOE

AOIAOIAOIAOIAOIAOIAOIAOIAOI

AOTAOTAOTAOTAOTAOTAOTAOTAOT

ARNARNARNARNARNARNARNARNARN

ARWARWARWARWARWARWARWARWARW

ATHATHATHATHATHATHATHATHATH

AURAURAURAURAURAURAURAURAUR

AVNAVNAVNAVNAVNAVNAVNAVNAVN

AXDAXDAXDAXDAXDAXDAXDAXDAXD

BAYBAYBAYBAYBAYBAYBAYBAYBAY

BBUBBUBBUBBUBBUBBUBBUBBUBBU

BCMBCMBCMBCMBCMBCMBCMBCMBCM

BCNBCNBCNBCNBCNBCNBCNBCNBCN

BDSBDSBDSBDSBDSBDSBDSBDSBDS

BEGBEGBEGBEGBEGBEGBEGBEGBEG

BESBESBESBESBESBESBESBESBES

BFSBFSBFSBFSBFSBFSBFSBFSBFS

BGCBGCBGCBGCBGCBGCBGCBGCBGC

BGOBGOBGOBGOBGOBGOBGOBGOBGO

BGYBGYBGYBGYBGYBGYBGYBGYBGY

BHDBHDBHDBHDBHDBHDBHDBHDBHD

BHXBHXBHXBHXBHXBHXBHXBHXBHX

BIABIABIABIABIABIABIABIABIA

BIOBIOBIOBIOBIOBIOBIOBIOBIOBIQBIQBIQBIQBIQBIQBIQBIQBIQ

BJVBJVBJVBJVBJVBJVBJVBJVBJV

BJZBJZBJZBJZBJZBJZBJZBJZBJZ

BLEBLEBLEBLEBLEBLEBLEBLEBLE

BLKBLKBLKBLKBLKBLKBLKBLKBLK

BLLBLLBLLBLLBLLBLLBLLBLLBLL

BLQBLQBLQBLQBLQBLQBLQBLQBLQ

BMABMABMABMABMABMABMABMABMA

BNXBNXBNXBNXBNXBNXBNXBNXBNXBODBODBODBODBODBODBODBODBOD

BOHBOHBOHBOHBOHBOHBOHBOHBOH

BOJBOJBOJBOJBOJBOJBOJBOJBOJ

BQTBQTBQTBQTBQTBQTBQTBQTBQT

BREBREBREBREBREBREBREBREBRE

BRIBRIBRIBRIBRIBRIBRIBRIBRI

BRNBRNBRNBRNBRNBRNBRNBRNBRN

BRQBRQBRQBRQBRQBRQBRQBRQBRQ

BRSBRSBRSBRSBRSBRSBRSBRSBRS

BRUBRUBRUBRUBRUBRUBRUBRUBRUBSHBSHBSHBSHBSHBSHBSHBSHBSH

BSLBSLBSLBSLBSLBSLBSLBSLBSL

BTSBTSBTSBTSBTSBTSBTSBTSBTS

BUDBUDBUDBUDBUDBUDBUDBUDBUD

BVABVABVABVABVABVABVABVABVA

BVEBVEBVEBVEBVEBVEBVEBVEBVE

BWEBWEBWEBWEBWEBWEBWEBWEBWE

BWKBWKBWKBWKBWKBWKBWKBWKBWK

BZGBZGBZGBZGBZGBZGBZGBZGBZG

BZOBZOBZOBZOBZOBZOBZOBZOBZO

BZRBZRBZRBZRBZRBZRBZRBZRBZR

BZZBZZBZZBZZBZZBZZBZZBZZBZZ

CAGCAGCAGCAGCAGCAGCAGCAGCAG

CALCALCALCALCALCALCALCALCAL

CBGCBGCBGCBGCBGCBGCBGCBGCBG

CCFCCFCCFCCFCCFCCFCCFCCFCCF

CDGCDGCDGCDGCDGCDGCDGCDGCDG

CEGCEGCEGCEGCEGCEGCEGCEGCEG

CERCERCERCERCERCERCERCERCER

CFECFECFECFECFECFECFECFECFE

CFNCFNCFNCFNCFNCFNCFNCFNCFN

CFRCFRCFRCFRCFRCFRCFRCFRCFR

CFUCFUCFUCFUCFUCFUCFUCFUCFU

CGNCGNCGNCGNCGNCGNCGNCGNCGN

CIACIACIACIACIACIACIACIACIA

CKZCKZCKZCKZCKZCKZCKZCKZCKZ

CLJCLJCLJCLJCLJCLJCLJCLJCLJ

CLYCLYCLYCLYCLYCLYCLYCLYCLY

CMFCMFCMFCMFCMFCMFCMFCMFCMF

CNDCNDCNDCNDCNDCNDCNDCNDCND

CPHCPHCPHCPHCPHCPHCPHCPHCPH

CQMCQMCQMCQMCQMCQMCQMCQMCQM

CRACRACRACRACRACRACRACRACRA

CRLCRLCRLCRLCRLCRLCRLCRLCRL

CRVCRVCRVCRVCRVCRVCRVCRVCRV

CTACTACTACTACTACTACTACTACTA

CUFCUFCUFCUFCUFCUFCUFCUFCUF

CVTCVTCVTCVTCVTCVTCVTCVTCVT

CWCCWCCWCCWCCWCCWCCWCCWCCWC

CWLCWLCWLCWLCWLCWLCWLCWLCWL

DBVDBVDBVDBVDBVDBVDBVDBVDBV

DCMDCMDCMDCMDCMDCMDCMDCMDCM

DEBDEBDEBDEBDEBDEBDEBDEBDEBDIJDIJDIJDIJDIJDIJDIJDIJDIJ

DNDDNDDNDDNDDNDDNDDNDDNDDND

DNRDNRDNRDNRDNRDNRDNRDNRDNR

DNZDNZDNZDNZDNZDNZDNZDNZDNZ

DOLDOLDOLDOLDOLDOLDOLDOLDOL

DRSDRSDRSDRSDRSDRSDRSDRSDRS

DSADSADSADSADSADSADSADSADSA

DTMDTMDTMDTMDTMDTMDTMDTMDTM

DUBDUBDUBDUBDUBDUBDUBDUBDUB

DUSDUSDUSDUSDUSDUSDUSDUSDUS

EASEASEASEASEASEASEASEASEAS

EBAEBAEBAEBAEBAEBAEBAEBAEBA

EBJEBJEBJEBJEBJEBJEBJEBJEBJ

EBUEBUEBUEBUEBUEBUEBUEBUEBU

EDIEDIEDIEDIEDIEDIEDIEDIEDI

EFLEFLEFLEFLEFLEFLEFLEFLEFL

EGCEGCEGCEGCEGCEGCEGCEGCEGC

EINEINEINEINEINEINEINEINEIN

EMAEMAEMAEMAEMAEMAEMAEMAEMA

ENSENSENSENSENSENSENSENSENS

EPLEPLEPLEPLEPLEPLEPLEPLEPL

ERFERFERFERFERFERFERFERFERFESHESHESHESHESHESHESHESHESH

ETZETZETZETZETZETZETZETZETZ

EXTEXTEXTEXTEXTEXTEXTEXTEXT

FCOFCOFCOFCOFCOFCOFCOFCOFCO

FDEFDEFDEFDEFDEFDEFDEFDEFDE

FDHFDHFDHFDHFDHFDHFDHFDHFDH

FKBFKBFKBFKBFKBFKBFKBFKBFKB

FLRFLRFLRFLRFLRFLRFLRFLRFLR

FMMFMMFMMFMMFMMFMMFMMFMMFMM

FMOFMOFMOFMOFMOFMOFMOFMOFMO

FNIFNIFNIFNIFNIFNIFNIFNIFNI

FOGFOGFOGFOGFOGFOGFOGFOGFOG

FRAFRAFRAFRAFRAFRAFRAFRAFRA

FRLFRLFRLFRLFRLFRLFRLFRLFRL

FROFROFROFROFROFROFROFROFRO

FSCFSCFSCFSCFSCFSCFSCFSCFSC

FZOFZOFZOFZOFZOFZOFZOFZOFZO

GCIGCIGCIGCIGCIGCIGCIGCIGCI

GDNGDNGDNGDNGDNGDNGDNGDNGDN

GLAGLAGLAGLAGLAGLAGLAGLAGLA

GLOGLOGLOGLOGLOGLOGLOGLOGLO

GMEGMEGMEGMEGMEGMEGMEGMEGME

GNAGNAGNAGNAGNAGNAGNAGNAGNA

GNBGNBGNBGNBGNBGNBGNBGNBGNB

GOAGOAGOAGOAGOAGOAGOAGOAGOA

GOTGOTGOTGOTGOTGOTGOTGOTGOT

GPAGPAGPAGPAGPAGPAGPAGPAGPA

GROGROGROGROGROGROGROGROGRO

GRQGRQGRQGRQGRQGRQGRQGRQGRQ

GRZGRZGRZGRZGRZGRZGRZGRZGRZ

GSEGSEGSEGSEGSEGSEGSEGSEGSE

GVAGVAGVAGVAGVAGVAGVAGVAGVA

GVXGVXGVXGVXGVXGVXGVXGVXGVX

GWTGWTGWTGWTGWTGWTGWTGWTGWT

GWYGWYGWYGWYGWYGWYGWYGWYGWY

HADHADHADHADHADHADHADHADHAD

HAJHAJHAJHAJHAJHAJHAJHAJHAJ

HAMHAMHAMHAMHAMHAMHAMHAMHAM

HAUHAUHAUHAUHAUHAUHAUHAUHAU

HDFHDFHDFHDFHDFHDFHDFHDFHDF

HELHELHELHELHELHELHELHELHEL

HHNHHNHHNHHNHHNHHNHHNHHNHHN

HMJHMJHMJHMJHMJHMJHMJHMJHMJ

HOQHOQHOQHOQHOQHOQHOQHOQHOQ

HSKHSKHSKHSKHSKHSKHSKHSKHSK

HUYHUYHUYHUYHUYHUYHUYHUYHUY

IASIASIASIASIASIASIASIASIAS

IBZIBZIBZIBZIBZIBZIBZIBZIBZ

IEGIEGIEGIEGIEGIEGIEGIEGIEG

IEVIEVIEVIEVIEVIEVIEVIEVIEV

IFOIFOIFOIFOIFOIFOIFOIFOIFO

ILZILZILZILZILZILZILZILZILZ

INIINIINIINIINIINIINIINIINI

INNINNINNINNINNINNINNINNINN

INVINVINVINVINVINVINVINVINV

IOAIOAIOAIOAIOAIOAIOAIOAIOA

IOMIOMIOMIOMIOMIOMIOMIOMIOM

ISEISEISEISEISEISEISEISEISE

ISTISTISTISTISTISTISTISTIST

JERJERJERJERJERJERJERJERJER

JKGJKGJKGJKGJKGJKGJKGJKGJKG

JKHJKHJKHJKHJKHJKHJKHJKHJKH

JMKJMKJMKJMKJMKJMKJMKJMKJMK

JSIJSIJSIJSIJSIJSIJSIJSIJSI

KBPKBPKBPKBPKBPKBPKBPKBPKBP

KDLKDLKDLKDLKDLKDLKDLKDLKDL

KELKELKELKELKELKELKELKELKEL

KGDKGDKGDKGDKGDKGDKGDKGDKGD

KIDKIDKIDKIDKIDKIDKIDKIDKID

KIRKIRKIRKIRKIRKIRKIRKIRKIR

KIVKIVKIVKIVKIVKIVKIVKIVKIV

KLRKLRKLRKLRKLRKLRKLRKLRKLR

KLUKLUKLUKLUKLUKLUKLUKLUKLU

KLVKLVKLVKLVKLVKLVKLVKLVKLV

KOIKOIKOIKOIKOIKOIKOIKOIKOI

KRKKRKKRKKRKKRKKRKKRKKRKKRK

KRPKRPKRPKRPKRPKRPKRPKRPKRP

KRSKRSKRSKRSKRSKRSKRSKRSKRS

KSCKSCKSCKSCKSCKSCKSCKSCKSC

KSDKSDKSDKSDKSDKSDKSDKSDKSD

KSFKSFKSFKSFKSFKSFKSFKSFKSF

KSOKSOKSOKSOKSOKSOKSOKSOKSO

KTWKTWKTWKTWKTWKTWKTWKTWKTW

KUNKUNKUNKUNKUNKUNKUNKUNKUN

KVAKVAKVAKVAKVAKVAKVAKVAKVA

KYAKYAKYAKYAKYAKYAKYAKYAKYA

KZIKZIKZIKZIKZIKZIKZIKZIKZI

LAILAILAILAILAILAILAILAILAI

LBALBALBALBALBALBALBALBALBA LBCLBCLBCLBCLBCLBCLBCLBCLBC

LCGLCGLCGLCGLCGLCGLCGLCGLCG

LCJLCJLCJLCJLCJLCJLCJLCJLCJLCYLCYLCYLCYLCYLCYLCYLCYLCY

LDELDELDELDELDELDELDELDELDE

LDYLDYLDYLDYLDYLDYLDYLDYLDY

LEDLEDLEDLEDLEDLEDLEDLEDLED

LEHLEHLEHLEHLEHLEHLEHLEHLEH

LEJLEJLEJLEJLEJLEJLEJLEJLEJ

LENLENLENLENLENLENLENLENLEN

LGGLGGLGGLGGLGGLGGLGGLGGLGG

LGWLGWLGWLGWLGWLGWLGWLGWLGWLHRLHRLHRLHRLHRLHRLHRLHRLHR

LIGLIGLIGLIGLIGLIGLIGLIGLIG

LILLILLILLILLILLILLILLILLIL

LINLINLINLINLINLINLINLINLIN

LISLISLISLISLISLISLISLISLIS

LJULJULJULJULJULJULJULJULJU

LNZLNZLNZLNZLNZLNZLNZLNZLNZ

LPILPILPILPILPILPILPILPILPI

LPLLPLLPLLPLLPLLPLLPLLPLLPL

LPPLPPLPPLPPLPPLPPLPPLPPLPP

LPXLPXLPXLPXLPXLPXLPXLPXLPX

LPYLPYLPYLPYLPYLPYLPYLPYLPY

LRHLRHLRHLRHLRHLRHLRHLRHLRH

LRTLRTLRTLRTLRTLRTLRTLRTLRT

LSILSILSILSILSILSILSILSILSI

LTNLTNLTNLTNLTNLTNLTNLTNLTN

LTQLTQLTQLTQLTQLTQLTQLTQLTQ

LUGLUGLUGLUGLUGLUGLUGLUGLUG

LUXLUXLUXLUXLUXLUXLUXLUXLUXLWOLWOLWOLWOLWOLWOLWOLWOLWO

LYSLYSLYSLYSLYSLYSLYSLYSLYS

LYXLYXLYXLYXLYXLYXLYXLYXLYX

MADMADMADMADMADMADMADMADMAD

MAHMAHMAHMAHMAHMAHMAHMAHMAH

MANMANMANMANMANMANMANMANMAN

MBXMBXMBXMBXMBXMBXMBXMBXMBX

MGLMGLMGLMGLMGLMGLMGLMGLMGL

MHGMHGMHGMHGMHGMHGMHGMHGMHG

MHPMHPMHPMHPMHPMHPMHPMHPMHP

MHQMHQMHQMHQMHQMHQMHQMHQMHQ

MJTMJTMJTMJTMJTMJTMJTMJTMJT

MJVMJVMJVMJVMJVMJVMJVMJVMJV

MMEMMEMMEMMEMMEMMEMMEMMEMME

MMXMMXMMXMMXMMXMMXMMXMMXMMX

MPLMPLMPLMPLMPLMPLMPLMPLMPL MRSMRSMRSMRSMRSMRSMRSMRSMRS

MSEMSEMSEMSEMSEMSEMSEMSEMSE

MSQMSQMSQMSQMSQMSQMSQMSQMSQ

MSTMSTMSTMSTMSTMSTMSTMSTMST

MUCMUCMUCMUCMUCMUCMUCMUCMUC

MXPMXPMXPMXPMXPMXPMXPMXPMXP

MXXMXXMXXMXXMXXMXXMXXMXXMXX

NAPNAPNAPNAPNAPNAPNAPNAPNAP

NCENCENCENCENCENCENCENCENCE

NCLNCLNCLNCLNCLNCLNCLNCLNCL

NCYNCYNCYNCYNCYNCYNCYNCYNCY

NLVNLVNLVNLVNLVNLVNLVNLVNLV

NOCNOCNOCNOCNOCNOCNOCNOCNOC

NQYNQYNQYNQYNQYNQYNQYNQYNQY

NRKNRKNRKNRKNRKNRKNRKNRKNRK

NRNNRNNRNNRNNRNNRNNRNNRNNRN

NTENTENTENTENTENTENTENTENTE

NUENUENUENUENUENUENUENUENUE

NWINWINWINWINWINWINWINWINWI

NYONYONYONYONYONYONYONYONYO

OBFOBFOBFOBFOBFOBFOBFOBFOBF

ODEODEODEODEODEODEODEODEODE

ODSODSODSODSODSODSODSODSODS

OHDOHDOHDOHDOHDOHDOHDOHDOHDOLBOLBOLBOLBOLBOLBOLBOLBOLB

OMOOMOOMOOMOOMOOMOOMOOMOOMO

OMROMROMROMROMROMROMROMROMR

OPOOPOOPOOPOOPOOPOOPOOPOOPO

ORBORBORBORBORBORBORBORBORB

ORKORKORKORKORKORKORKORKORK

ORYORYORYORYORYORYORYORYORY

OSIOSIOSIOSIOSIOSIOSIOSIOSI

OSLOSLOSLOSLOSLOSLOSLOSLOSL

OSROSROSROSROSROSROSROSROSR

OSTOSTOSTOSTOSTOSTOSTOSTOST

OSZOSZOSZOSZOSZOSZOSZOSZOSZ

OTPOTPOTPOTPOTPOTPOTPOTPOTP

OVDOVDOVDOVDOVDOVDOVDOVDOVD

OXFOXFOXFOXFOXFOXFOXFOXFOXF PADPADPADPADPADPADPADPADPAD

PDVPDVPDVPDVPDVPDVPDVPDVPDV

PEDPEDPEDPEDPEDPEDPEDPEDPED

PEGPEGPEGPEGPEGPEGPEGPEGPEGPGFPGFPGFPGFPGFPGFPGFPGFPGF

PGXPGXPGXPGXPGXPGXPGXPGXPGX

PIKPIKPIKPIKPIKPIKPIKPIKPIK

PISPISPISPISPISPISPISPISPIS

PKVPKVPKVPKVPKVPKVPKVPKVPKV

PLHPLHPLHPLHPLHPLHPLHPLHPLH

PLQPLQPLQPLQPLQPLQPLQPLQPLQ

PMFPMFPMFPMFPMFPMFPMFPMFPMF

PMIPMIPMIPMIPMIPMIPMIPMIPMI

PMOPMOPMOPMOPMOPMOPMOPMOPMO

PNAPNAPNAPNAPNAPNAPNAPNAPNA

PORPORPORPORPORPORPORPORPOR

POXPOXPOXPOXPOXPOXPOXPOXPOX

POZPOZPOZPOZPOZPOZPOZPOZPOZ

PRGPRGPRGPRGPRGPRGPRGPRGPRG

PRNPRNPRNPRNPRNPRNPRNPRNPRN

PRVPRVPRVPRVPRVPRVPRVPRVPRV

PSAPSAPSAPSAPSAPSAPSAPSAPSA

PSRPSRPSRPSRPSRPSRPSRPSRPSR

PUFPUFPUFPUFPUFPUFPUFPUFPUF

PUYPUYPUYPUYPUYPUYPUYPUYPUY

PVKPVKPVKPVKPVKPVKPVKPVKPVK

PZYPZYPZYPZYPZYPZYPZYPZYPZY

QSRQSRQSRQSRQSRQSRQSRQSRQSR

RDZRDZRDZRDZRDZRDZRDZRDZRDZ

REGREGREGREGREGREGREGREGREG

REUREUREUREUREUREUREUREUREU

RGSRGSRGSRGSRGSRGSRGSRGSRGS

RHERHERHERHERHERHERHERHERHE

RIXRIXRIXRIXRIXRIXRIXRIXRIX

RJKRJKRJKRJKRJKRJKRJKRJKRJK

RJLRJLRJLRJLRJLRJLRJLRJLRJL

RKERKERKERKERKERKERKERKERKE

RLGRLGRLGRLGRLGRLGRLGRLGRLG

RMIRMIRMIRMIRMIRMIRMIRMIRMI

RNBRNBRNBRNBRNBRNBRNBRNBRNB

RNNRNNRNNRNNRNNRNNRNNRNNRNN

RNSRNSRNSRNSRNSRNSRNSRNSRNS

RTMRTMRTMRTMRTMRTMRTMRTMRTM

RYGRYGRYGRYGRYGRYGRYGRYGRYG

RZERZERZERZERZERZERZERZERZE

SAWSAWSAWSAWSAWSAWSAWSAWSAW

SBKSBKSBKSBKSBKSBKSBKSBKSBK

SBZSBZSBZSBZSBZSBZSBZSBZSBZ

SCNSCNSCNSCNSCNSCNSCNSCNSCN

SCQSCQSCQSCQSCQSCQSCQSCQSCQ

SCVSCVSCVSCVSCVSCVSCVSCVSCV

SDRSDRSDRSDRSDRSDRSDRSDRSDR

SENSENSENSENSENSENSENSENSEN

SGDSGDSGDSGDSGDSGDSGDSGDSGD

SIRSIRSIRSIRSIRSIRSIRSIRSIR

SJJSJJSJJSJJSJJSJJSJJSJJSJJ

SKESKESKESKESKESKESKESKESKE

SKGSKGSKGSKGSKGSKGSKGSKGSKG

SKPSKPSKPSKPSKPSKPSKPSKPSKP

SKUSKUSKUSKUSKUSKUSKUSKUSKU

SLDSLDSLDSLDSLDSLDSLDSLDSLD

SLMSLMSLMSLMSLMSLMSLMSLMSLM

SMISMISMISMISMISMISMISMISMI

SNNSNNSNNSNNSNNSNNSNNSNNSNN

SNRSNRSNRSNRSNRSNRSNRSNRSNR

SOBSOBSOBSOBSOBSOBSOBSOBSOB

SOFSOFSOFSOFSOFSOFSOFSOFSOF

SOUSOUSOUSOUSOUSOUSOUSOUSOU

SPUSPUSPUSPUSPUSPUSPUSPUSPU

STNSTNSTNSTNSTNSTNSTNSTNSTN

STRSTRSTRSTRSTRSTRSTRSTRSTR

SUFSUFSUFSUFSUFSUFSUFSUFSUF

SUJSUJSUJSUJSUJSUJSUJSUJSUJ

SVGSVGSVGSVGSVGSVGSVGSVGSVG

SVQSVQSVQSVQSVQSVQSVQSVQSVQ

SXBSXBSXBSXBSXBSXBSXBSXBSXB

SXFSXFSXFSXFSXFSXFSXFSXFSXF

SXLSXLSXLSXLSXLSXLSXLSXLSXL

SYYSYYSYYSYYSYYSYYSYYSYYSYY

SZGSZGSZGSZGSZGSZGSZGSZGSZG

SZWSZWSZWSZWSZWSZWSZWSZWSZW SZYSZYSZYSZYSZYSZYSZYSZYSZYSZZSZZSZZSZZSZZSZZSZZSZZSZZ

TATTATTATTATTATTATTATTATTAT

TAYTAYTAYTAYTAYTAYTAYTAYTAY

TEQTEQTEQTEQTEQTEQTEQTEQTEQ

TGDTGDTGDTGDTGDTGDTGDTGDTGD

TGMTGMTGMTGMTGMTGMTGMTGMTGM

THFTHFTHFTHFTHFTHFTHFTHFTHF

THNTHNTHNTHNTHNTHNTHNTHNTHN

TIATIATIATIATIATIATIATIATIA

TIVTIVTIVTIVTIVTIVTIVTIVTIV

TKUTKUTKUTKUTKUTKUTKUTKUTKU

TLLTLLTLLTLLTLLTLLTLLTLLTLL

TLNTLNTLNTLNTLNTLNTLNTLNTLN

TLSTLSTLSTLSTLSTLSTLSTLSTLS

TMPTMPTMPTMPTMPTMPTMPTMPTMP

TNLTNLTNLTNLTNLTNLTNLTNLTNL

TPSTPSTPSTPSTPSTPSTPSTPSTPS

TRFTRFTRFTRFTRFTRFTRFTRFTRF

TRNTRNTRNTRNTRNTRNTRNTRNTRN

TRSTRSTRSTRSTRSTRSTRSTRSTRSTSFTSFTSFTSFTSFTSFTSFTSFTSFTSRTSRTSRTSRTSRTSRTSRTSRTSR

TTBTTBTTBTTBTTBTTBTTBTTBTTB

TUFTUFTUFTUFTUFTUFTUFTUFTUF

TXLTXLTXLTXLTXLTXLTXLTXLTXL

TZLTZLTZLTZLTZLTZLTZLTZLTZL

UDJUDJUDJUDJUDJUDJUDJUDJUDJ

UIPUIPUIPUIPUIPUIPUIPUIPUIP

UREUREUREUREUREUREUREUREURE

UROUROUROUROUROUROUROUROURO

USQUSQUSQUSQUSQUSQUSQUSQUSQ

VARVARVARVARVARVARVARVARVAR

VBSVBSVBSVBSVBSVBSVBSVBSVBS

VBYVBYVBYVBYVBYVBYVBYVBYVBY

VCEVCEVCEVCEVCEVCEVCEVCEVCE

VDBVDBVDBVDBVDBVDBVDBVDBVDB

VGOVGOVGOVGOVGOVGOVGOVGOVGO

VIEVIEVIEVIEVIEVIEVIEVIEVIE

VITVITVITVITVITVITVITVITVIT

VLCVLCVLCVLCVLCVLCVLCVLCVLC

VLLVLLVLLVLLVLLVLLVLLVLLVLL

VLYVLYVLYVLYVLYVLYVLYVLYVLY

VNOVNOVNOVNOVNOVNOVNOVNOVNO

VOLVOLVOLVOLVOLVOLVOLVOLVOL

VRLVRLVRLVRLVRLVRLVRLVRLVRL

VRNVRNVRNVRNVRNVRNVRNVRNVRN

VSTVSTVSTVSTVSTVSTVSTVSTVST

VXOVXOVXOVXOVXOVXOVXOVXOVXO

WATWATWATWATWATWATWATWATWAT WAWWAWWAWWAWWAWWAWWAWWAWWAW

WICWICWICWICWICWICWICWICWIC

WROWROWROWROWROWROWROWROWRO

XCRXCRXCRXCRXCRXCRXCRXCRXCR

YEIYEIYEIYEIYEIYEIYEIYEIYEI

ZADZADZADZADZADZADZADZADZAD

ZAGZAGZAGZAGZAGZAGZAGZAGZAG

ZAZZAZZAZZAZZAZZAZZAZZAZZAZ

ZQWZQWZQWZQWZQWZQWZQWZQWZQW

ZRHZRHZRHZRHZRHZRHZRHZRHZRH

ZTHZTHZTHZTHZTHZTHZTHZTHZTH

Demand Structure by Carrier Type% of Seats Offered in 2005

1005010

LowcostStarOneworldSkyteamOther

AARAARAARAARAARAARAARAARAAR

ACHACHACHACHACHACHACHACHACH

AGBAGBAGBAGBAGBAGBAGBAGBAGB

AGHAGHAGHAGHAGHAGHAGHAGHAGH

AMSAMSAMSAMSAMSAMSAMSAMSAMS

ANEANEANEANEANEANEANEANEANE

ANGANGANGANGANGANGANGANGANG

ANRANRANRANRANRANRANRANRANR

AOCAOCAOCAOCAOCAOCAOCAOCAOC

AOTAOTAOTAOTAOTAOTAOTAOTAOT

BESBESBESBESBESBESBESBESBES

BFSBFSBFSBFSBFSBFSBFSBFSBFS

BGYBGYBGYBGYBGYBGYBGYBGYBGY

BHDBHDBHDBHDBHDBHDBHDBHDBHD

BHXBHXBHXBHXBHXBHXBHXBHXBHX

BLKBLKBLKBLKBLKBLKBLKBLKBLK

BLLBLLBLLBLLBLLBLLBLLBLLBLL

BOHBOHBOHBOHBOHBOHBOHBOHBOH

BREBREBREBREBREBREBREBREBRE

BRNBRNBRNBRNBRNBRNBRNBRNBRN

BRSBRSBRSBRSBRSBRSBRSBRSBRS

BRUBRUBRUBRUBRUBRUBRUBRUBRUBSHBSHBSHBSHBSHBSHBSHBSHBSH

BSLBSLBSLBSLBSLBSLBSLBSLBSL

BVABVABVABVABVABVABVABVABVA

BVEBVEBVEBVEBVEBVEBVEBVEBVE

BWEBWEBWEBWEBWEBWEBWEBWEBWE

BZOBZOBZOBZOBZOBZOBZOBZOBZO

BZZBZZBZZBZZBZZBZZBZZBZZBZZ

CALCALCALCALCALCALCALCALCAL

CBGCBGCBGCBGCBGCBGCBGCBGCBG

CDGCDGCDGCDGCDGCDGCDGCDGCDG

CEGCEGCEGCEGCEGCEGCEGCEGCEG

CERCERCERCERCERCERCERCERCER

CFECFECFECFECFECFECFECFECFE

CFNCFNCFNCFNCFNCFNCFNCFNCFN

CFRCFRCFRCFRCFRCFRCFRCFRCFR

CGNCGNCGNCGNCGNCGNCGNCGNCGN

CMFCMFCMFCMFCMFCMFCMFCMFCMF

CPHCPHCPHCPHCPHCPHCPHCPHCPH

CRLCRLCRLCRLCRLCRLCRLCRLCRL

CVTCVTCVTCVTCVTCVTCVTCVTCVT

CWLCWLCWLCWLCWLCWLCWLCWLCWL

DIJDIJDIJDIJDIJDIJDIJDIJDIJ

DNDDNDDNDDNDDNDDNDDNDDNDDND

DNRDNRDNRDNRDNRDNRDNRDNRDNR

DOLDOLDOLDOLDOLDOLDOLDOLDOL

DRSDRSDRSDRSDRSDRSDRSDRSDRS

DSADSADSADSADSADSADSADSADSA

DTMDTMDTMDTMDTMDTMDTMDTMDTM

DUBDUBDUBDUBDUBDUBDUBDUBDUB

DUSDUSDUSDUSDUSDUSDUSDUSDUS

EBJEBJEBJEBJEBJEBJEBJEBJEBJ

EBUEBUEBUEBUEBUEBUEBUEBUEBU

EDIEDIEDIEDIEDIEDIEDIEDIEDI

EINEINEINEINEINEINEINEINEIN

EMAEMAEMAEMAEMAEMAEMAEMAEMA

ENSENSENSENSENSENSENSENSENS

EPLEPLEPLEPLEPLEPLEPLEPLEPL

ERFERFERFERFERFERFERFERFERFESHESHESHESHESHESHESHESHESH

ETZETZETZETZETZETZETZETZETZ

EXTEXTEXTEXTEXTEXTEXTEXTEXT

FDHFDHFDHFDHFDHFDHFDHFDHFDH

FKBFKBFKBFKBFKBFKBFKBFKBFKB

FMMFMMFMMFMMFMMFMMFMMFMMFMM

FMOFMOFMOFMOFMOFMOFMOFMOFMO

FRAFRAFRAFRAFRAFRAFRAFRAFRA

FZOFZOFZOFZOFZOFZOFZOFZOFZO

GCIGCIGCIGCIGCIGCIGCIGCIGCI

GLAGLAGLAGLAGLAGLAGLAGLAGLA

GLOGLOGLOGLOGLOGLOGLOGLOGLO

GNBGNBGNBGNBGNBGNBGNBGNBGNB

GRQGRQGRQGRQGRQGRQGRQGRQGRQ

GVAGVAGVAGVAGVAGVAGVAGVAGVA

GWTGWTGWTGWTGWTGWTGWTGWTGWT

HADHADHADHADHADHADHADHADHAD

HAJHAJHAJHAJHAJHAJHAJHAJHAJ

HAMHAMHAMHAMHAMHAMHAMHAMHAM

HDFHDFHDFHDFHDFHDFHDFHDFHDF

HHNHHNHHNHHNHHNHHNHHNHHNHHN

HOQHOQHOQHOQHOQHOQHOQHOQHOQ

HUYHUYHUYHUYHUYHUYHUYHUYHUY

INNINNINNINNINNINNINNINNINN

IOMIOMIOMIOMIOMIOMIOMIOMIOM

JERJERJERJERJERJERJERJERJER

KELKELKELKELKELKELKELKELKEL

KIDKIDKIDKIDKIDKIDKIDKIDKID

KLUKLUKLUKLUKLUKLUKLUKLUKLU

KLVKLVKLVKLVKLVKLVKLVKLVKLV

KRPKRPKRPKRPKRPKRPKRPKRPKRP

KSFKSFKSFKSFKSFKSFKSFKSFKSF

LAILAILAILAILAILAILAILAILAI

LBALBALBALBALBALBALBALBALBA LBCLBCLBCLBCLBCLBCLBCLBCLBC

LCYLCYLCYLCYLCYLCYLCYLCYLCY

LDYLDYLDYLDYLDYLDYLDYLDYLDY

LEHLEHLEHLEHLEHLEHLEHLEHLEH

LEJLEJLEJLEJLEJLEJLEJLEJLEJ

LGGLGGLGGLGGLGGLGGLGGLGGLGG

LGWLGWLGWLGWLGWLGWLGWLGWLGW

LHRLHRLHRLHRLHRLHRLHRLHRLHR

LIGLIGLIGLIGLIGLIGLIGLIGLIG

LILLILLILLILLILLILLILLILLIL

LINLINLINLINLINLINLINLINLIN

LJULJULJULJULJULJULJULJULJU

LNZLNZLNZLNZLNZLNZLNZLNZLNZ

LPLLPLLPLLPLLPLLPLLPLLPLLPL

LRHLRHLRHLRHLRHLRHLRHLRHLRH

LRTLRTLRTLRTLRTLRTLRTLRTLRT

LTNLTNLTNLTNLTNLTNLTNLTNLTN

LTQLTQLTQLTQLTQLTQLTQLTQLTQ

LUGLUGLUGLUGLUGLUGLUGLUGLUG

LUXLUXLUXLUXLUXLUXLUXLUXLUX

LYSLYSLYSLYSLYSLYSLYSLYSLYS

LYXLYXLYXLYXLYXLYXLYXLYXLYX

MANMANMANMANMANMANMANMANMAN

MGLMGLMGLMGLMGLMGLMGLMGLMGL

MHGMHGMHGMHGMHGMHGMHGMHGMHG

MMEMMEMMEMMEMMEMMEMMEMMEMME

MMXMMXMMXMMXMMXMMXMMXMMXMMX

MSEMSEMSEMSEMSEMSEMSEMSEMSE

MSTMSTMSTMSTMSTMSTMSTMSTMST

MUCMUCMUCMUCMUCMUCMUCMUCMUC

MXPMXPMXPMXPMXPMXPMXPMXPMXP

NCLNCLNCLNCLNCLNCLNCLNCLNCL

NCYNCYNCYNCYNCYNCYNCYNCYNCY

NQYNQYNQYNQYNQYNQYNQYNQYNQY

NRNNRNNRNNRNNRNNRNNRNNRNNRN

NTENTENTENTENTENTENTENTENTE

NUENUENUENUENUENUENUENUENUE

NWINWINWINWINWINWINWINWINWI

OBFOBFOBFOBFOBFOBFOBFOBFOBF

ODEODEODEODEODEODEODEODEODE

ORKORKORKORKORKORKORKORKORK

ORYORYORYORYORYORYORYORYORY

OSTOSTOSTOSTOSTOSTOSTOSTOST

OXFOXFOXFOXFOXFOXFOXFOXFOXFPADPADPADPADPADPADPADPADPAD

PGXPGXPGXPGXPGXPGXPGXPGXPGX

PIKPIKPIKPIKPIKPIKPIKPIKPIK

PISPISPISPISPISPISPISPISPIS

PLHPLHPLHPLHPLHPLHPLHPLHPLH

POXPOXPOXPOXPOXPOXPOXPOXPOX

PRGPRGPRGPRGPRGPRGPRGPRGPRG

RHERHERHERHERHERHERHERHERHE

RJKRJKRJKRJKRJKRJKRJKRJKRJK

RKERKERKERKERKERKERKERKERKE

RLGRLGRLGRLGRLGRLGRLGRLGRLG

RNNRNNRNNRNNRNNRNNRNNRNNRNN

RNSRNSRNSRNSRNSRNSRNSRNSRNS

RTMRTMRTMRTMRTMRTMRTMRTMRTM

SBKSBKSBKSBKSBKSBKSBKSBKSBK

SCNSCNSCNSCNSCNSCNSCNSCNSCN

SENSENSENSENSENSENSENSENSEN

SGDSGDSGDSGDSGDSGDSGDSGDSGD

SIRSIRSIRSIRSIRSIRSIRSIRSIR

SNRSNRSNRSNRSNRSNRSNRSNRSNR

SOUSOUSOUSOUSOUSOUSOUSOUSOU

STNSTNSTNSTNSTNSTNSTNSTNSTN

STRSTRSTRSTRSTRSTRSTRSTRSTRSXBSXBSXBSXBSXBSXBSXBSXBSXB

SXFSXFSXFSXFSXFSXFSXFSXFSXF

SZGSZGSZGSZGSZGSZGSZGSZGSZG

SZWSZWSZWSZWSZWSZWSZWSZWSZWSZZSZZSZZSZZSZZSZZSZZSZZSZZ

THFTHFTHFTHFTHFTHFTHFTHFTHF

TRNTRNTRNTRNTRNTRNTRNTRNTRN

TRSTRSTRSTRSTRSTRSTRSTRSTRSTSFTSFTSFTSFTSFTSFTSFTSFTSF

TUFTUFTUFTUFTUFTUFTUFTUFTUF

TXLTXLTXLTXLTXLTXLTXLTXLTXL

UIPUIPUIPUIPUIPUIPUIPUIPUIP

UROUROUROUROUROUROUROUROURO

VBSVBSVBSVBSVBSVBSVBSVBSVBSVCEVCEVCEVCEVCEVCEVCEVCEVCE

VLYVLYVLYVLYVLYVLYVLYVLYVLY

VRNVRNVRNVRNVRNVRNVRNVRNVRN

WATWATWATWATWATWATWATWATWAT

XCRXCRXCRXCRXCRXCRXCRXCRXCR

ZQWZQWZQWZQWZQWZQWZQWZQWZQW

ZRHZRHZRHZRHZRHZRHZRHZRHZRH

Demand Structure by Carrier Type% of Seats Offered in 2005

1005010

LowcostStarOneworldSkyteamOther

Seats offered by Alliance / carrier type gives information e.g. on competition issues

Page 12: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

12

Resulting network delivered, Air Links

• Air links consisting of

- Notes: - links include surface connections (e.g. LHR <-> LGW)

- Air connections like Frankfurt – Amsterdam – Manila may have different impedances concerning time

frequency, price, etc. than the corresponding values

added for Frankfurt – Amsterdam and Amsterdam – Manila!For that reason for each pair of airports the network consists of the direct link (if existing) or otherwise of

the leg connecting it within shortest travel / transport time when requiring in maximum two stopover airports.

Indicator Verbal description of indicator

DATA_GROUPMetadata on dataset level, since the DB-system only supports metadata on table level. Observed, estimated, modeled data

SOURCEMetadata on dataset level, since the DB-system only supports metadata on table level. Observed, modeled data

FROMDATEeffective in time range; YEAR or period Fromdate, Todate , e.g. Fromdate 20050101, todate20051231 is preferred

TODATEeffective in time range; YEAR or period Fromdate, Todate , e.g. Fromdate 20090501, todate20051231 is preferred

SEASON effective in time range; WINTER | SUMMER | ALL; so that this information need not be deduced by client programs

ObjectID Identifier used by ArcGISShape ArcGIS geometryID A unique identifier for each linkFromNodelD Fromnode for the linkToNodelD Tonode for the link

OpenForIndicates whether the air link is open or not in the forward direction (fromnode to tonode) (0 or 1)

OpenBackIndicates whether the air link is open or not in the backward direction (tonode to fromnode) (0 or 1)

FreeSpeed 1, not applicableQueueSpeed 1, not applicableLanesFor 1, not applicableLanesBack 1, not applicableLinkTypelD Type [cargo/pax/both]LaneHCFor -1, not applicableLaneHCBack -1, not applicable

ActiveIndicates whether the link is included in the calculations or not (1=active, 0=inactive)

Length distance [km]Orig IATA-Code for origin airport. Not used in calculationsOrig_Name Origin airport name. Not used in calculationsDest IATA-Code for destination airport. Not used in calculationsDest_Name Destination airport name. Not used in calculationsCostB Ticket fare for business trips (Euro)CostP Ticket fare for private trips (Euro)CostH Ticket fare for holiday trips (Euro)

LinkTime Flight time on link (Minutes)TransferTime Extra transfer time on link (Minutes)TotalTravelTime Total_time [minutes]Annual_Depart Number of flights per year (Departures per year)Daily_Depart Number of flights per day (Departures per year)

HeadwayTime

Average waiting time due to frequency. Calculated based on Daily_Depart as: HeadwayTime = >2*(20/Daily_Depart)*60. Minimum 60 minutes and maximum 240 minutes (minutes)

LinkClass

Network type (FLC=Flight Connection, ETR=External Transfer between nearby airports). Not used in calculations

LowCost Share of low cost connections [0 -> 100]

Shape_LengthArcGIS link length. Unit determined by data projection. Default is degrees

Transfer1node for the link Transfer1node for the link [0 if n.a.]

Transfer2node for the link Transfer2node for the link [0 if n.a.)Transfer1 Transfer 1 [TLC) "---" id n.a.Transfer2 Transfer 2 [TLC) "---" if n.a.FrequencyPax frequency passenger [connections/week]FrequencyCargo frequency cargo [connections/week]

Page 13: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

13

Resulting impedances delivered

• Concerning air transport, the impedances consist of the average values from up to 16 different routings considered in the APC routine and for which choice probabilities are calculated.

• For that reason we concentrate on- travel time (total and in vehicle)- cost (not for air cargo, as WORLDNET approach doesn’t cope with)- frequency- distance

• Impedances have been used to calculate air accessibility.

Indicator Description of indicatorDATA_GROUP Metadata on dataset level: type of dataSOURCE Metadata on dataset level: data providerFROMDATE Operating time. Year or starting dateTODATE Operating time. Year or ending dateSEASON Season of operating timeID Unique identifierFromReg Origin ETISZone3_IDToReg Destination ETISZone3_IDPurpose Trip purpose (only for passenger)TotalTime Total travel timeAccessTime Access timeFlightTime Flight time (including transfer times, check-in/-out etc.)AccessCost Access costs (only for passenger)FlightCost Flight costs (only for passenger)Frequency Connections per weekAccessDistance Access distanceFlightDistance Distance of flight

Page 14: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

Application: Air transport accessibility 2010

• Displayed is the average travel-time for each NUTS3 region in Europe needed to reach another European region by air transport, including time for surface access / egress.

• Travel-times have been weighted by the population of each destination region; i.e. travel-time to reach a region in the North of Finland has a lower weight than the time to reach the city of London

Page 15: ETISplus Air transport Data collection & selected results Oliver Schnell MKmetric GmbH schnell@mkm.de  05.11.2012- Brussels

MKmetric Gesellschaft für Systemplanung mbHOliver SchnellRüppurrer Straße 476137 KarlsruheGermanyPhone: 0049 - 721-96160 - 0Fax: 0049 - 721 96160 - 99email: [email protected] webpage: www.mkm.de

Thank you for your attention