Km4City Data Ingestion Guidelines and ETL Examples

Data Ingestion Guidelines

• Sii-Mobility: DE4.2a-Sistema di acquisizione e Aggregazione dati, dal concetto al dato, dal dato al database con ETL, e dal database al modello ontologico (ITA, ENG)
• Guidelines: Programmazione ETL per Data Warehouse
• Link to download the Virtual Machine
• Link to have more detailed information on the ETL development

ETL Examples:

• You find as attachments a set of ETL samples related to the following contexts:
  • Point of Interest, POI (Farmacie, Aeroporti, etc.)
  • Events (Eventi)
  • Public transport lines containing infdormation related to timetables, stops, paths, etc. and  based on the GTFs Standard (TPL)
  • ...