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

Preview
#
# Table structure for table stations
#

CREATE TABLE `stations` (
  `id` smallint(4) unsigned NOT NULL default '0',
  `latitude` float NOT NULL default '0',
  `longitude` float NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  `display_name` varchar(64) default NULL,
  `zone` float default NULL,
  `total_lines` tinyint(2) unsigned NOT NULL default '0',
  `rail` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

#
# Dumping data for table stations
#

INSERT INTO `stations` VALUES (1,51.5028,-0.2801,'Acton Town','Acton<br />Town',3,2,0);
INSERT INTO `stations` VALUES (2,51.5143,-0.0755,'Aldgate',NULL,1,2,0);
INSERT INTO `stations` VALUES (3,51.5154,-0.0726,'Aldgate East','Aldgate<br />East',1,2,0);
INSERT INTO `stations` VALUES (4,51.5107,-0.013,'All Saints','All<br />Saints',2,1,0);
INSERT INTO `stations` VALUES (5,51.5407,-0.2997,'Alperton',NULL,4,1,0);
INSERT INTO `stations` VALUES (7,51.5322,-0.1058,'Angel',NULL,1,1,0);
INSERT INTO `stations` VALUES (8,51.5653,-0.1353,'Archway',NULL,2.5,1,0);
INSERT INTO `stations` VALUES (9,51.6164,-0.1331,'Arnos Grove','Arnos<br />Grove',4,1,0);
INSERT INTO `stations` VALUES (10,51.5586,-0.1059,'Arsenal',NULL,2,1,0);
INSERT INTO `stations` VALUES (11,51.5226,-0.1571,'Baker Street','Baker<br />Street',1,5,0);
INSERT INTO `stations` VALUES (12,51.4431,-0.1525,'Balham',NULL,3,1,1);
INSERT INTO `stations` VALUES (13,51.5133,-0.0886,'Bank',NULL,1,4,0);
INSERT INTO `stations` VALUES (14,51.5204,-0.0979,'Barbican',NULL,1,3,0);
INSERT INTO `stations` VALUES (15,51.5396,0.081,'Barking',NULL,4,2,1);
INSERT INTO `stations` VALUES (16,51.5856,0.0887,'Barkingside',NULL,5,1,0);
INSERT INTO `stations` VALUES (17,51.4905,-0.2139,'Barons Court','Barons<br />Court',2,2,0);
INSERT INTO `stations` VALUES (18,51.5121,-0.1879,'Bayswater',NULL,1,2,0);
INSERT INTO `stations` VALUES (19,51.5148,0.0613,'Beckton',NULL,3,1,0);
INSERT INTO `stations` VALUES (20,51.5087,0.055,'Beckton Park','Beckton<br />Park',3,1,0);
INSERT INTO `stations` VALUES (21,51.5403,0.127,'Becontree',NULL,5,1,0);
INSERT INTO `stations` VALUES (22,51.5504,-0.1642,'Belsize Park','Belsize<br />Park',2,1,0);
INSERT INTO `stations` VALUES (24,51.527,-0.0549,'Bethnal Green','Bethnal<br />Green',2,1,0);
INSERT INTO `stations` VALUES (25,51.512,-0.1031,'Blackfriars',NULL,1,2,0);
INSERT INTO `stations` VALUES (26,51.5867,-0.0417,'Blackhorse Road','Blackhorse<br />Road
To view the full dump, please login
SQL database dumps

London Stations

Navigation

Popular databases
