1 / 21

ETIS+ knowledge base Data viewing and retrieval

ETIS+ knowledge base Data viewing and retrieval. Poul Grashoff, Demis bv. 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

binh
Download Presentation

ETIS+ knowledge base Data viewing and retrieval

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ETIS+ knowledge base Data viewing and retrieval Poul Grashoff, Demisbv

  2. 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 Final Workshop ETIS+

  3. 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 Final Workshop ETIS+

  4. ETIS+ KB status • Tabular data for 2005 and 2010 have been uploaded and are nowbeingvalidated • Final network data are nowavailable, the on-line viewer/editor ETISNetteris in the proces of beingupdated to the latetst version. • Software for editing/viewingiscomplete e.g. 3 dimensional cube Location  Time Parameter  Final Workshop ETIS+

  5. ETISPLUS knowledge base design Data Exchange formats External data store MS SQL server based with a multidimensional data model approach for flexibility Check in / out Example of data cubes Header MDB External data store Data dictionary ETIS-PLUS KB Collection Header TXT Bulk data upload Data wiki: Check-in / check-out External data store Extraction Transformation Scrubbing Header XLS External data store Viewing of data External data store Table Map Chart External data store

  6. 2. Tabled Data Warehouse • Contains OD flows and regional data tables • Based on a multidimensionaldata model • Visualisation of data as tables / charts / thematic maps • DATA-WIKI: Community of registered users can edit data via the check-out / check-in procedure (just like a source safe) • Metadata is based on Dublin core ++ • History is stored of data and people responsible

  7. Editing table data: check-out-check-in mechanism 1. Check-out (and download) data 2. Edit and save data locally 3. Check-in data

  8. Data Space View 2 View 1 Viewing multi-dimensional (tabled) data Views are orthogonal slices through multidimensional data cubes Spatial and temporal slices through the data are most common

  9. Table overview

  10. 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 Final Workshop ETIS+

  11. Flat view air freight by OD Final Workshop ETIS+

  12. Cube view air freight by OD Final Workshop ETIS+

  13. Chart view air freight Finland-Holland Final Workshop ETIS+

  14. Thematic map air freight Finland-Holland Final Workshop ETIS+

  15. Missing data versus zero values Real zero values (white) shown separately from missing values (transparent)

  16. Network viewing and editing • ETIS-NETTER: • Final network node and link data have been received, in process of uploading • Is fully operational and now also used in RETRACK for corridor data editing • Functionality is the same as in the WorldNet editor “WorldNetter” Final Workshop ETIS+

  17. Network node and link data Final Workshop ETIS+

  18. Retrack corridor red/green Final Workshop ETIS+

  19. Network Editing tool • thematic maps example: • Link color used for maximum speed (km/h) • Link width used for Freight Tonnage Count (T)

  20. 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 Final Workshop ETIS+

  21. “Bulk data” download site • Full dataset in MS SQL server 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) Final Workshop ETIS+

More Related