HSLtraffic
Scripts to create a PostgreSQL database for HSL GTFS-data
Install / Use
/learn @markusvalo/HSLtrafficREADME
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.
- video: https://vimeo.com/255089153
- QGIS: https://qgis.org/en/site/
- Time Manager: https://anitagraser.com/projects/time-manager/
Related Skills
oracle
352.0kBest practices for using the oracle CLI (prompt + file bundling, engines, sessions, and file attachment patterns).
prose
352.0kOpenProse VM skill pack. Activate on any `prose` command, .prose files, or OpenProse mentions; orchestrates multi-agent workflows.
Command Development
111.1kThis skill should be used when the user asks to "create a slash command", "add a command", "write a custom command", "define command arguments", "use command frontmatter", "organize commands", "create command with file references", "interactive command", "use AskUserQuestion in command", or needs guidance on slash command structure, YAML frontmatter fields, dynamic arguments, bash execution in commands, user interaction patterns, or command development best practices for Claude Code.
Plugin Structure
111.1kThis skill should be used when the user asks to "create a plugin", "scaffold a plugin", "understand plugin structure", "organize plugin components", "set up plugin.json", "use ${CLAUDE_PLUGIN_ROOT}", "add commands/agents/skills/hooks", "configure auto-discovery", or needs guidance on plugin directory layout, manifest configuration, component organization, file naming conventions, or Claude Code plugin architecture best practices.
Security Score
Audited on Apr 16, 2021