istanbul-buses

A dataset containing every IETT line's stop, timetable, and route information.

Table of contents

Information

License: Istanbul Metropolitan Municipality Open Data License

Downloads:

• lines.parquet
• line_stops.parquet
• routes.parquet
• stops.parquet
• timetables.parquet
• all tables zipped

Known problems

• The first stop of a route (the ordering of stops in a route is denoted by the route_order field in line_stops table) and the second stop of a route both have a route_order of 1. The first stop should have a route_order of 0. The first two stops are always ordered correctly in query results.

Explore the dataset!

The DuckDB shell can be used to explore the dataset. Load the Parquet files to start querying!

CREATE TABLE lines 
    AS SELECT * FROM 'https://kurt.town/datasets/istanbul-buses/lines.parquet';
CREATE TABLE line_stops 
    AS SELECT * FROM 'https://kurt.town/datasets/istanbul-buses/line_stops.parquet';
CREATE TABLE routes 
    AS SELECT * FROM 'https://kurt.town/datasets/istanbul-buses/routes.parquet';
CREATE TABLE stops 
    AS SELECT * FROM 'https://kurt.town/datasets/istanbul-buses/stops.parquet';
CREATE TABLE timetables 
    AS SELECT * FROM 'https://kurt.town/datasets/istanbul-buses/timetables.parquet';