Dataset: Transit Systems Of World

About this Dataset

Transit Systems Of World

Context

What did the expansion of the London Underground, the world’s first underground railway which opened in 1863, look like? What about the transportation system in your home city? Citylines collects data on transportation lines across the world so you can answer questions like these and more.

Content

This dataset, originally shared and updated here, includes transportation line data from a number of cities from around the world including London, Berlin, Mexico City, Barcelona, Washington D.C., and others covering many thousands of kilometers of lines.

Inspiration

You can explore geometries to generate maps and even see how lines have changed over time based on historical records. Want to include shapefiles with your analysis? Simply publish a shapefile dataset here and then create a new kernel (R or Python script/notebook), adding your shapefile as an additional datasource.

Tables

Cities

@kaggle.citylines_city_lines.cities

21.06 KB
334 rows
7 columns


CREATE TABLE cities (
  "id" BIGINT,
  "name" VARCHAR,
  "coords" VARCHAR,
  "start_year" DOUBLE,
  "url_name" VARCHAR,
  "country" VARCHAR,
  "country_state" VARCHAR
);

Lines

@kaggle.citylines_city_lines.lines

54.62 KB
1343 rows
7 columns


CREATE TABLE lines (
  "id" BIGINT,
  "city_id" BIGINT,
  "name" VARCHAR,
  "url_name" VARCHAR,
  "color" VARCHAR,
  "system_id" BIGINT,
  "transport_mode_id" DOUBLE
);

Stations

@kaggle.citylines_city_lines.stations

682.64 KB
15794 rows
7 columns


CREATE TABLE stations (
  "id" BIGINT,
  "name" VARCHAR,
  "geometry" VARCHAR,
  "buildstart" DOUBLE,
  "opening" DOUBLE,
  "closure" DOUBLE,
  "city_id" BIGINT
);

Station Lines

@kaggle.citylines_city_lines.station_lines

355.66 KB
16242 rows
6 columns


CREATE TABLE station_lines (
  "id" BIGINT,
  "station_id" BIGINT,
  "line_id" BIGINT,
  "city_id" BIGINT,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP
);

Systems

@kaggle.citylines_city_lines.systems

10.09 KB
488 rows
3 columns


CREATE TABLE systems (
  "id" BIGINT,
  "city_id" BIGINT,
  "name" VARCHAR
);

Tracks

@kaggle.citylines_city_lines.tracks

3.63 MB
9271 rows
7 columns


CREATE TABLE tracks (
  "id" BIGINT,
  "geometry" VARCHAR,
  "buildstart" DOUBLE,
  "opening" DOUBLE,
  "closure" DOUBLE,
  "length" BIGINT,
  "city_id" BIGINT
);

Track Lines

@kaggle.citylines_city_lines.track_lines

237.33 KB
9757 rows
6 columns


CREATE TABLE track_lines (
  "id" BIGINT,
  "section_id" BIGINT,
  "line_id" BIGINT,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP,
  "city_id" BIGINT
);