README

Very draft version :)
Ruby version: 1.9
Gems required: sqlite3, nokogiri, open-uri, htmlentities

Basic Rake steps workflow (run rake -T for the whole list of available tasks)

# Create cache folders and SQLite DB
rake setup:init

# OPTIONAL step: by default whole Switzerland timetables are fetched
#           if you want it only for a smaller area, run the following command
#           'bounds' parameter contains 4 values, separated by comma:
#               corner SW longitude,corner SW latitude,corner NE longitude,corner NE latitude
rake station:set_bounds bounds=8.53,47.41,8.61,47.46

# Discovers the stations in the studied area
rake station:fetch

# OPTIONAL step: exports the stations in tmp/station.csv for visualizing data (i.e. in QGIS)
rake station:export

# OPTIONAL step(although recommended): remove the stations outside of Switzerland's borders
rake station:geo_clean

# Fetches from SBB, the files containing departures for each station
rake departure:fetch

# Removes the files that contains errors. If any files are mentioned, you have to run again the previous step
rake departure:files_clean

# Inserts the timetables in DB  
rake timetable:parse

# Remove timetable duplicates (based on departure, vehicle_id, destination)
rake timetable:remove_duplicates

# Remove stops of the stations that are now known (outside of Switzerland)
rake timetable:remove_notknown_stations

# Determine the station type from the timetables
rake station:parse_type

# OPTIONAL step: exports the stations in tmp/station.csv for visualizing data (i.e. in QGIS)
rake station:export

# Build the vehicle table based on departures
rake vehicle:insert

# Update the vehicle table with info for each vehicle and insert arrivals at destination in the timetables 
rake vehicle:build

# Remove again stops of the stations that are now known (outside of Switzerland), which may be inserted by the previous step
rake timetable:remove_notknown_stations

# Remove vehicles that have only one station in Switzerland and the rest outside (like TGVs leaving  to France from the border)
rake vehicle:remove_onestopper

# Run this step again because me might have stations without vehicle stops, so we don't want to display this station
rake station:parse_type

# Remove the stops of the vehicles that have duplicate consecutive stations but with different departure times. A bit similar with 'timetable:remove_duplicates' task
rake vehicle:check_duplicate_stations