public-transport/gtfs-via-postgres

add helper table mapping extended to basic route_types

Open

#75 opened on Jan 22, 2026

View on GitHub
 (0 comments) (1 reaction) (0 assignees)JavaScript (21 forks)github user discovery
enhancementgood first issuehelp wanted

Repository metrics

Stars
 (141 stars)
PR merge metrics
 (PR metrics pending)

Description

Working with extended route_type values (both in the Google scheme as well as in the TPEG-PTI scheme) is cumbersome.

For example, most ferries are specified as 4 ("Ferry. Used for short- and long-distance boat service."), while some are specified as 1000 ("Water Transport Service").

gtfs-via-postgres (and gtfs-via-duckdb) should provide a mapping table that maps them to basic route_type values, and maybe also add basic_route_type to arrivals_departures/connections.

Contributor guide

Research direction
Study the GTFS extended route type values (Google and TPEG PTI schemes) and design a mapping table in the project's SQL schema. Then implement the table and integrate it into the arrivals departures/connections views.
Tech stack
sqlpostgresql
Domain
backenddatabase
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
SQLPostgreSQLGTFS
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60