Skip to content

Scripts to create a PostgreSQL database for HSL GTFS-data

Notifications You must be signed in to change notification settings

markusvalo/HSLtraffic

Repository files navigation

HSLtraffic

Scripts to create a PostgreSQL database for HSL GTFS-data.

STEPS TO FOLLOW

  • 1_CREATE_SCHEMA_HSL.sql drops existing tables and anything related to them (cascade). It then creates empty tables for raw data.
  • 2_UPLOAD_gtfs_csv.sql copies data from .txt-files into the tables.
  • 3_CREATE_TABLES_hslstoptimes_parsed.sql creates table(s) with some additional parsing in order to help filtering when utilizing the data. Tables probably to be combined in the future to make maintenance easier. They are now created by transport type (train/tram/metro/ferry/bus).

Data can be downloaded as zip-archives from https://transitfeeds.com/p/helsinki-regional-transport/735.

The files inside zip follow Google's GTFS-guidelines for public transport (at least to some level), descriptions here: https://developers.google.com/transit/gtfs/reference/

A rough schema diagram can be found in this directory.

I tested these and created a sample video with QGIS Time Manager -plugin, going to add the route segments between stops to get a bit more calm animation as next version.