London Routes SQL Database Dump for MySQL, Microsoft Access and Oracle

London Routes

Description:

Routes of London's underground. Including line colour for display purposes.

Rows: 13

Keywords: london,england,trains,routes

Download:

london-routes.gz |

london-routes.zip |

london-routes.sql

Preview

#
# Table structure for table routes
#

CREATE TABLE `routes` (
  `line` tinyint(3) unsigned NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  `colour` varchar(6) NOT NULL default '',
  `stripe` varchar(6) default NULL,
  PRIMARY KEY  (`line`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table routes
#

INSERT INTO `routes` VALUES (1,'Bakerloo Line','ab6612',NULL);
INSERT INTO `routes` VALUES (3,'Circle Line','f7dc00',NULL);
INSERT INTO `routes` VALUES (6,'Hammersmith & City Line','f5a6b3',NULL);
INSERT INTO `routes` VALUES (7,'Jubilee Line','767b7f',NULL);
INSERT INTO `routes` VALUES (11,'Victoria Line','0076bd',NULL);
INSERT INTO `routes` VALUES (2,'Central Line','df002c',NULL);
INSERT INTO `routes` VALUES (4,'District Line','0d6928',NULL);
INSERT INTO `routes` VALUES (5,'East London Line','f3ba22',NULL);
INSERT INTO `routes` VALUES (8,'Metropolitan Line','8b004c',NULL);
INSERT INTO `routes` VALUES (9,'Northern Line','000000',NULL);
INSERT INTO `routes` VALUES (10,'Piccadilly Line','002d73',NULL);
INSERT INTO `routes` VALUES (12,'Waterloo & City Line','89cbc1',NULL);
INSERT INTO `routes` VALUES (13,'Docklands Light Railway','00A77E','FFFFFF');

To view the full dump, please login

SQL database dumps

London Routes

Navigation

Popular databases