Loading Switzerland's GTFS Data into an Oracle Database

run.sh is a shell script that

• downloads the data from the Open data platform mobility Switzerland
• extracts the downloaded zip file
• creates the gtfs_ch schema (create-schema.sql) and its tables (create-tables.sql).
• loads the extracted CSV files into these tables using SQL*Loader

Note: the following variables are currently hard coded and need to be modified in run.sh:

• URL (the location of the zip file) and
• admin and connect_identifier (information for connection to the database)

Because SQL*Loader disables foreign key and check constraints and leaves some indexes in an unusable state, the post-process.sql script enables and rebuilds these objects.

TODO: There is a reenable option in SQL*Loader to automatically reenable foreign key constraints.