Name: Transit Systems Of World
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

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.56 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

55.93 kB
1,343 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
);

Station Lines

@kaggle.citylines_city_lines.station_lines

364.2 kB
16,242 rows
6 columns

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

Stations

@kaggle.citylines_city_lines.stations

699.02 kB
15,794 rows
7 columns

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

Systems

@kaggle.citylines_city_lines.systems

10.34 kB
488 rows
3 columns

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

Track Lines

@kaggle.citylines_city_lines.track_lines

243.02 kB
9,757 rows
6 columns

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

Tracks

@kaggle.citylines_city_lines.tracks

3.81 MB
9,271 rows
7 columns

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