Transcript Data retrieval from the ETISPLUS KB

Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
ETIS+ knowledge base
Data viewing and retrieval
Poul Grashoff, Demis bv
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
What is the ETIS+ KB?
• Knowledge base with on-line viewing
and editing of transport related
information, consisting of:
 Transport document repository www.etisplus.eu
 Registered users have edit rights & access to the
restricted documents
 Viewing / editing of OD flow and regional data
 Viewing / editing of network node/link data and
topology
 Bulk download location when data are final
31/01/2012
Workshop ETIS+
2
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
Access to the knowledge base
• Public (anonymous access)
 Public document repository & portal
 OD flow and regional data viewer (table / chart
/ map)
 Network node/link attribute data thematic
maps & tables
 Bulk data download links when data are final
• Registered user access (partners)
 Restricted document repositories
 Editing of table data by check-out/-in
 Editing of network data and topology in GIS
31/01/2012
Workshop ETIS+
3
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+ KB status
• Changes in deliverable D4 have resulted in a new
2005 data model, with seperate data collections
for Observed, Modelled, Harmonised. The ‘empty
shelves’ are now *ready* to receive data uploads
from partners (assisted by Demis).
• Until that is completed, refer to collection
ETISPLUS 2005 to view the previously uploaded
data (note these data are not yet up to date!).
• 2010 Data model definition is not yet complete,
so it is not yet included in any collection.
• Software for editing/viewing is *complete*
31/01/2012
e.g. 3 dimensional cube
Location 
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
Workshop ETIS+
Parameter 
4
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
‘Empty shelves’ table overview
31/01/2012
5
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
Viewing options for table data
• Flat view – listing of table records.
• Cube view – data slice in 2 selected
dimensions for columns/rows.
• Chart view – series and categories
for line/bar/column charts
• Map view – thematic maps for a
single selected geo-dimension
31/01/2012
Workshop ETIS+
6
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
31/01/2012
Flat view air freight by OD
Workshop ETIS+
7
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
31/01/2012
Cube view air freight by OD
Workshop ETIS+
8
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
31/01/2012
Chart view air freight Finland-Holland
Workshop ETIS+
9
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
31/01/2012
Thematic map air freight Finland-Holland
Workshop ETIS+
10
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
Funded by the European Commission through
the 7th Framework Programme for Research
http://www.etisplus.eu/
31/01/2012
Workshop ETIS+
11
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
Network viewing and editing
• ETIS-NETTER:
 All 2005 network node and link data
have now been received (but not final..)
 Is fully operational and now also used in
RETRACK for corridor data editing
 Functionality is the same as in the
WorldNet editor “WorldNetter”
 Data fields as specified in D4 are
implemented
31/01/2012
Workshop ETIS+
12
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
Network node and link data
31/01/2012
Workshop ETIS+
13
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
31/01/2012
Retrack corridor red/green
Workshop ETIS+
14
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
Retrieval of data
• Table data:
 Direct in ETIS-VIEW for selections of
data (MS Access; MS Excel)
 Bulk download site on Data tab (once
data is final, MS Access / CSV)
• Network data and topology
 On bulk download site, updated
automatically when necessary as other
projects are also using ETIS-NETTER
31/01/2012
Workshop ETIS+
15
Funded by the European Commission through
the 7th Framework Programme for Research
ETIS+: European Transport Policy Information System - Development and
Implementation of Data Collection Methodology for EU Transport Modelling
http://www.etisplus.eu/
“Bulk data” download site
• Full datasets by collection in MSAccess format or CSV format
(compressed to reduce file size) with
HTTP link pointing to FTP site (i.e.
anonymous access is allowed)
• Upon request (and provision of IP
adress) access to the FTP site itself
(e.g. in case http download fails due
to the file size)
31/01/2012
Workshop ETIS+
16