Ruta SITP Bogotá — GTFS Open Router

Transportation Web Application Open Data
Case Study · Public Transportation Platform

Ruta SITP Bogotá — GTFS Open Router

Appspring implemented a pioneering transit solution to digitize Bogotá's public bus route database. At the time, no public digital tools calculated optimal routes and transfer times between stops, so the team manually curated large route datasets and built an Open Router instance.

2015 – 2015 Public Transportation Platform Dedicated Project Team
Business Challenge

Problem and context

This section describes the situation before the engagement, so prospective clients can determine whether it corresponds to their current position.

Consider this project if: your team recognizes one or more of the conditions described alongside this panel.

Bus route information exists only in fragmented operational records.

Travelers cannot calculate optimal routes with transfers between stops.

Public data lacks a standardized digital format.

A routing engine must operate on curated, reliable inputs.

Solution

Delivery scope

Each item below states what was delivered and the operational reason for that decision.

Step 0101

GTFS and KML data foundation

Structured route information under Google Transit Feed Specification with KML references and manual curation.

Why this approach: Benefit: the city gains a standardized digital route inventory.
Step 0202

Open Router for optimal routes

Evolved the platform into a router that calculates routes from origin, destination, and transfer times with JavaScript search algorithms and Google Maps API.

Why this approach: Benefit: users plan trips with realistic transfer estimates.

Technologies and stack

GTFS KML Files Open Router Engine JavaScript Route Algorithms HTML5 / CSS3 Google Maps API

Engagement summary

Period
2015 – 2015
Model
Dedicated project team
Channel
Direct engagement
Category
Public Transportation Platform
Outcome

Result

Bogotá obtained an early functional reference for digital transit routing built on open specifications.

Discuss a similar requirement

If your organization faces a comparable situation, the team can review scope, constraints, and delivery options.

Ready to start your next project?

Let our team build a custom solution for you.