London Underground geographic maps/SQL

From Wikimedia Commons, the free media repository
Jump to: navigation, search

-- SQL dump for London Underground geographic maps. (Download)

--

--
-- Table structure for table links
--
CREATE TABLE links (
  station1 smallint NOT NULL default '0',
  station2 smallint NOT NULL default '0',
  line smallint NOT NULL default '0',
  UNIQUE (line,station1,station2) 
) ;

--
-- Dumping data for table links
--
INSERT INTO links VALUES (11,163,1);
INSERT INTO links VALUES (11,212,1);
INSERT INTO links VALUES (49,87,1);
INSERT INTO links VALUES (49,197,1);
INSERT INTO links VALUES (82,163,1);
INSERT INTO links VALUES (82,193,1);
INSERT INTO links VALUES (84,148,1);
INSERT INTO links VALUES (87,279,1);
INSERT INTO links VALUES (113,246,1);
INSERT INTO links VALUES (113,298,1);
INSERT INTO links VALUES (114,140,1);
INSERT INTO links VALUES (137,206,1);
INSERT INTO links VALUES (137,298,1);
INSERT INTO links VALUES (140,237,1);
INSERT INTO links VALUES (143,159,1);
INSERT INTO links VALUES (143,206,1);
INSERT INTO links VALUES (148,279,1);
INSERT INTO links VALUES (159,278,1);
INSERT INTO links VALUES (185,237,1);
INSERT INTO links VALUES (185,281,1);
INSERT INTO links VALUES (192,197,1);
INSERT INTO links VALUES (192,212,1);
INSERT INTO links VALUES (193,278,1);
INSERT INTO links VALUES (246,281,1);
INSERT INTO links VALUES (13,156,2);
INSERT INTO links VALUES (13,250,2);
INSERT INTO links VALUES (16,91,2);
INSERT INTO links VALUES (16,173,2);
INSERT INTO links VALUES (24,156,2);
INSERT INTO links VALUES (24,164,2);
INSERT INTO links VALUES (28,162,2);
INSERT INTO links VALUES (28,192,2);
INSERT INTO links VALUES (37,158,2);
INSERT INTO links VALUES (37,301,2);
INSERT INTO links VALUES (48,126,2);
INSERT INTO links VALUES (48,250,2);
INSERT INTO links VALUES (51,103,2);
INSERT INTO links VALUES (51,215,2);
INSERT INTO links VALUES (68,158,2);
INSERT INTO links VALUES (68,256,2);
INSERT INTO links VALUES (72,286,2);
INSERT INTO links VALUES (76,181,2);
INSERT INTO links VALUES (76,296,2);
INSERT INTO links VALUES (88,256,2);
INSERT INTO links VALUES (91,109,2);
INSERT INTO links VALUES (98,173,2);
INSERT INTO links VALUES (98,211,2);
INSERT INTO links VALUES (103,109,2);
INSERT INTO links VALUES (105,177,2);
INSERT INTO links VALUES (105,196,2);
INSERT INTO links VALUES (112,181,2);
INSERT INTO links VALUES (112,196,2);
INSERT INTO links VALUES (126,259,2);
INSERT INTO links VALUES (127,186,2);
INSERT INTO links VALUES (127,226,2);
INSERT INTO links VALUES (149,162,2);
INSERT INTO links VALUES (149,208,2);
INSERT INTO links VALUES (153,154,2);
INSERT INTO links VALUES (153,247,2);
INSERT INTO links VALUES (154,230,2);
INSERT INTO links VALUES (154,275,2);
INSERT INTO links VALUES (164,247,2);
INSERT INTO links VALUES (177,239,2);
INSERT INTO links VALUES (181,286,2);
INSERT INTO links VALUES (186,208,2);
INSERT INTO links VALUES (192,259,2);
INSERT INTO links VALUES (211,275,2);
INSERT INTO links VALUES (215,301,2);
INSERT INTO links VALUES (221,239,2);
INSERT INTO links VALUES (221,294,2);
INSERT INTO links VALUES (226,296,2);
INSERT INTO links VALUES (230,241,2);
INSERT INTO links VALUES (241,301,2);
INSERT INTO links VALUES (2,156,3);
INSERT INTO links VALUES (2,263,3);
INSERT INTO links VALUES (11,83,3);
INSERT INTO links VALUES (11,104,3);
INSERT INTO links VALUES (14,92,3);
INSERT INTO links VALUES (14,167,3);
INSERT INTO links VALUES (18,186,3);
INSERT INTO links VALUES (18,193,3);
INSERT INTO links VALUES (25,161,3);
INSERT INTO links VALUES (25,255,3);
INSERT INTO links VALUES (44,161,3);
INSERT INTO links VALUES (44,166,3);
INSERT INTO links VALUES (83,193,3);
INSERT INTO links VALUES (87,255,3);
INSERT INTO links VALUES (87,285,3);
INSERT INTO links VALUES (90,104,3);
INSERT INTO links VALUES (90,145,3);
INSERT INTO links VALUES (92,145,3);
INSERT INTO links VALUES (99,122,3);
INSERT INTO links VALUES (99,236,3);
INSERT INTO links VALUES (122,186,3);
INSERT INTO links VALUES (156,167,3);
INSERT INTO links VALUES (166,263,3);
INSERT INTO links VALUES (229,236,3);
INSERT INTO links VALUES (229,273,3);
INSERT INTO links VALUES (248,273,3);
INSERT INTO links VALUES (248,285,3);
INSERT INTO links VALUES (3,263,4);
INSERT INTO links VALUES (3,295,4);
INSERT INTO links VALUES (15,78,4);
INSERT INTO links VALUES (15,269,4);
INSERT INTO links VALUES (17,110,4);
INSERT INTO links VALUES (17,293,4);
INSERT INTO links VALUES (18,186,4);
INSERT INTO links VALUES (18,193,4);
INSERT INTO links VALUES (21,67,4);
INSERT INTO links VALUES (21,269,4);
INSERT INTO links VALUES (25,161,4);
INSERT INTO links VALUES (25,255,4);
INSERT INTO links VALUES (33,36,4);
INSERT INTO links VALUES (33,164,4);
INSERT INTO links VALUES (36,289,4);
INSERT INTO links VALUES (44,161,4);
INSERT INTO links VALUES (44,166,4);
INSERT INTO links VALUES (52,1,4);
INSERT INTO links VALUES (52,265,4);
INSERT INTO links VALUES (66,67,4);
INSERT INTO links VALUES (66,85,4);
INSERT INTO links VALUES (72,73,4);
INSERT INTO links VALUES (73,1,4);
INSERT INTO links VALUES (74,99,4);
INSERT INTO links VALUES (74,122,4);
INSERT INTO links VALUES (74,138,4);
INSERT INTO links VALUES (74,287,4);
INSERT INTO links VALUES (74,293,4);
INSERT INTO links VALUES (78,270,4);
INSERT INTO links VALUES (80,205,4);
INSERT INTO links VALUES (80,231,4);
INSERT INTO links VALUES (83,193,4);
INSERT INTO links VALUES (85,129,4);
INSERT INTO links VALUES (87,255,4);
INSERT INTO links VALUES (87,285,4);
INSERT INTO links VALUES (96,195,4);
INSERT INTO links VALUES (96,287,4);
INSERT INTO links VALUES (99,236,4);
INSERT INTO links VALUES (108,141,4);
INSERT INTO links VALUES (108,265,4);
INSERT INTO links VALUES (110,209,4);
INSERT INTO links VALUES (122,186,4);
INSERT INTO links VALUES (129,268,4);
INSERT INTO links VALUES (141,213,4);
INSERT INTO links VALUES (164,244,4);
INSERT INTO links VALUES (166,263,4);
INSERT INTO links VALUES (195,205,4);
INSERT INTO links VALUES (200,270,4);
INSERT INTO links VALUES (200,289,4);
INSERT INTO links VALUES (209,242,4);
INSERT INTO links VALUES (229,236,4);
INSERT INTO links VALUES (229,273,4);
INSERT INTO links VALUES (231,300,4);
INSERT INTO links VALUES (242,265,4);
INSERT INTO links VALUES (244,295,4);
INSERT INTO links VALUES (248,273,4);
INSERT INTO links VALUES (248,285,4);
INSERT INTO links VALUES (267,268,4);
INSERT INTO links VALUES (299,300,4);
INSERT INTO links VALUES (41,216,5);
INSERT INTO links VALUES (41,253,5);
INSERT INTO links VALUES (174,253,5);
INSERT INTO links VALUES (175,253,5);
INSERT INTO links VALUES (216,276,5);
INSERT INTO links VALUES (225,276,5);
INSERT INTO links VALUES (225,295,5);
INSERT INTO links VALUES (228,295,5);
INSERT INTO links VALUES (3,156,6);
INSERT INTO links VALUES (3,295,6);
INSERT INTO links VALUES (11,83,6);
INSERT INTO links VALUES (11,104,6);
INSERT INTO links VALUES (14,92,6);
INSERT INTO links VALUES (14,167,6);
INSERT INTO links VALUES (15,78,6);
INSERT INTO links VALUES (33,36,6);
INSERT INTO links VALUES (33,164,6);
INSERT INTO links VALUES (36,289,6);
INSERT INTO links VALUES (78,270,6);
INSERT INTO links VALUES (83,193,6);
INSERT INTO links VALUES (90,104,6);
INSERT INTO links VALUES (90,145,6);
INSERT INTO links VALUES (92,145,6);
INSERT INTO links VALUES (101,110,6);
INSERT INTO links VALUES (101,227,6);
INSERT INTO links VALUES (147,150,6);
INSERT INTO links VALUES (147,283,6);
INSERT INTO links VALUES (150,227,6);
INSERT INTO links VALUES (156,167,6);
INSERT INTO links VALUES (164,244,6);
INSERT INTO links VALUES (193,218,6);
INSERT INTO links VALUES (200,270,6);
INSERT INTO links VALUES (200,289,6);
INSERT INTO links VALUES (218,283,6);
INSERT INTO links VALUES (244,295,6);
INSERT INTO links VALUES (11,28,7);
INSERT INTO links VALUES (11,249,7);
INSERT INTO links VALUES (23,41,7);
INSERT INTO links VALUES (23,157,7);
INSERT INTO links VALUES (28,107,7);
INSERT INTO links VALUES (41,42,7);
INSERT INTO links VALUES (42,183,7);
INSERT INTO links VALUES (43,183,7);
INSERT INTO links VALUES (43,289,7);
INSERT INTO links VALUES (45,207,7);
INSERT INTO links VALUES (45,243,7);
INSERT INTO links VALUES (71,172,7);
INSERT INTO links VALUES (71,297,7);
INSERT INTO links VALUES (94,254,7);
INSERT INTO links VALUES (94,290,7);
INSERT INTO links VALUES (107,285,7);
INSERT INTO links VALUES (142,290,7);
INSERT INTO links VALUES (142,297,7);
INSERT INTO links VALUES (144,207,7);
INSERT INTO links VALUES (144,282,7);
INSERT INTO links VALUES (157,233,7);
INSERT INTO links VALUES (172,282,7);
INSERT INTO links VALUES (233,279,7);
INSERT INTO links VALUES (247,289,7);
INSERT INTO links VALUES (249,254,7);
INSERT INTO links VALUES (279,285,7);
INSERT INTO links VALUES (2,156,8);
INSERT INTO links VALUES (6,46,8);
INSERT INTO links VALUES (11,94,8);
INSERT INTO links VALUES (11,104,8);
INSERT INTO links VALUES (14,92,8);
INSERT INTO links VALUES (14,167,8);
INSERT INTO links VALUES (46,50,8);
INSERT INTO links VALUES (46,53,8);
INSERT INTO links VALUES (53,214,8);
INSERT INTO links VALUES (62,168,8);
INSERT INTO links VALUES (62,280,8);
INSERT INTO links VALUES (75,210,8);
INSERT INTO links VALUES (75,222,8);
INSERT INTO links VALUES (90,104,8);
INSERT INTO links VALUES (90,145,8);
INSERT INTO links VALUES (92,145,8);
INSERT INTO links VALUES (94,282,8);
INSERT INTO links VALUES (115,178,8);
INSERT INTO links VALUES (115,184,8);
INSERT INTO links VALUES (115,291,8);
INSERT INTO links VALUES (125,134,8);
INSERT INTO links VALUES (125,271,8);
INSERT INTO links VALUES (134,220,8);
INSERT INTO links VALUES (156,167,8);
INSERT INTO links VALUES (168,179,8);
INSERT INTO links VALUES (168,214,8);
INSERT INTO links VALUES (178,202,8);
INSERT INTO links VALUES (179,180,8);
INSERT INTO links VALUES (180,199,8);
INSERT INTO links VALUES (184,199,8);
INSERT INTO links VALUES (202,282,8);
INSERT INTO links VALUES (210,291,8);
INSERT INTO links VALUES (220,222,8);
INSERT INTO links VALUES (7,145,9);
INSERT INTO links VALUES (7,188,9);
INSERT INTO links VALUES (8,124,9);
INSERT INTO links VALUES (8,264,9);
INSERT INTO links VALUES (12,56,9);
INSERT INTO links VALUES (12,257,9);
INSERT INTO links VALUES (13,157,9);
INSERT INTO links VALUES (13,167,9);
INSERT INTO links VALUES (22,47,9);
INSERT INTO links VALUES (22,111,9);
INSERT INTO links VALUES (29,84,9);
INSERT INTO links VALUES (29,157,9);
INSERT INTO links VALUES (34,100,9);
INSERT INTO links VALUES (34,119,9);
INSERT INTO links VALUES (38,58,9);
INSERT INTO links VALUES (38,81,9);
INSERT INTO links VALUES (40,47,9);
INSERT INTO links VALUES (40,89,9);
INSERT INTO links VALUES (40,139,9);
INSERT INTO links VALUES (40,170,9);
INSERT INTO links VALUES (49,87,9);
INSERT INTO links VALUES (49,151,9);
INSERT INTO links VALUES (54,55,9);
INSERT INTO links VALUES (54,56,9);
INSERT INTO links VALUES (55,245,9);
INSERT INTO links VALUES (58,119,9);
INSERT INTO links VALUES (59,240,9);
INSERT INTO links VALUES (59,258,9);
INSERT INTO links VALUES (77,93,9);
INSERT INTO links VALUES (77,124,9);
INSERT INTO links VALUES (84,136,9);
INSERT INTO links VALUES (87,279,9);
INSERT INTO links VALUES (89,145,9);
INSERT INTO links VALUES (89,170,9);
INSERT INTO links VALUES (89,277,9);
INSERT INTO links VALUES (93,165,9);
INSERT INTO links VALUES (93,288,9);
INSERT INTO links VALUES (100,111,9);
INSERT INTO links VALUES (102,259,9);
INSERT INTO links VALUES (102,277,9);
INSERT INTO links VALUES (121,261,9);
INSERT INTO links VALUES (136,191,9);
INSERT INTO links VALUES (136,279,9);
INSERT INTO links VALUES (139,264,9);
INSERT INTO links VALUES (151,259,9);
INSERT INTO links VALUES (167,188,9);
INSERT INTO links VALUES (169,240,9);
INSERT INTO links VALUES (191,245,9);
INSERT INTO links VALUES (257,258,9);
INSERT INTO links VALUES (261,302,9);
INSERT INTO links VALUES (288,302,9);
INSERT INTO links VALUES (1,73,10);
INSERT INTO links VALUES (1,234,10);
INSERT INTO links VALUES (1,265,10);
INSERT INTO links VALUES (5,194,10);
INSERT INTO links VALUES (5,252,10);
INSERT INTO links VALUES (9,31,10);
INSERT INTO links VALUES (9,232,10);
INSERT INTO links VALUES (10,95,10);
INSERT INTO links VALUES (10,128,10);
INSERT INTO links VALUES (17,74,10);
INSERT INTO links VALUES (17,110,10);
INSERT INTO links VALUES (30,176,10);
INSERT INTO links VALUES (30,190,10);
INSERT INTO links VALUES (31,303,10);
INSERT INTO links VALUES (39,128,10);
INSERT INTO links VALUES (39,145,10);
INSERT INTO links VALUES (57,187,10);
INSERT INTO links VALUES (60,126,10);
INSERT INTO links VALUES (60,151,10);
INSERT INTO links VALUES (73,182,10);
INSERT INTO links VALUES (74,99,10);
INSERT INTO links VALUES (75,210,10);
INSERT INTO links VALUES (75,222,10);
INSERT INTO links VALUES (95,160,10);
INSERT INTO links VALUES (99,236,10);
INSERT INTO links VALUES (107,133,10);
INSERT INTO links VALUES (107,197,10);
INSERT INTO links VALUES (110,265,10);
INSERT INTO links VALUES (116,117,10);
INSERT INTO links VALUES (116,118,10);
INSERT INTO links VALUES (116,132,10);
INSERT INTO links VALUES (117,118,10);
INSERT INTO links VALUES (125,134,10);
INSERT INTO links VALUES (125,271,10);
INSERT INTO links VALUES (126,223,10);
INSERT INTO links VALUES (130,131,10);
INSERT INTO links VALUES (130,132,10);
INSERT INTO links VALUES (131,190,10);
INSERT INTO links VALUES (133,146,10);
INSERT INTO links VALUES (134,220,10);
INSERT INTO links VALUES (145,223,10);
INSERT INTO links VALUES (146,236,10);
INSERT INTO links VALUES (151,197,10);
INSERT INTO links VALUES (160,266,10);
INSERT INTO links VALUES (176,234,10);
INSERT INTO links VALUES (182,194,10);
INSERT INTO links VALUES (187,232,10);
INSERT INTO links VALUES (210,235,10);
INSERT INTO links VALUES (220,222,10);
INSERT INTO links VALUES (235,251,10);
INSERT INTO links VALUES (251,252,10);
INSERT INTO links VALUES (266,303,10);
INSERT INTO links VALUES (26,260,11);
INSERT INTO links VALUES (26,274,11);
INSERT INTO links VALUES (35,245,11);
INSERT INTO links VALUES (89,145,11);
INSERT INTO links VALUES (89,277,11);
INSERT INTO links VALUES (95,123,11);
INSERT INTO links VALUES (95,224,11);
INSERT INTO links VALUES (107,192,11);
INSERT INTO links VALUES (107,273,11);
INSERT INTO links VALUES (123,145,11);
INSERT INTO links VALUES (192,277,11);
INSERT INTO links VALUES (198,272,11);
INSERT INTO links VALUES (198,273,11);
INSERT INTO links VALUES (224,260,11);
INSERT INTO links VALUES (245,272,11);
INSERT INTO links VALUES (13,279,12);
INSERT INTO links VALUES (4,70,13);
INSERT INTO links VALUES (4,201,13);
INSERT INTO links VALUES (13,225,13);
INSERT INTO links VALUES (19,97,13);
INSERT INTO links VALUES (20,65,13);
INSERT INTO links VALUES (20,217,13);
INSERT INTO links VALUES (27,79,13);
INSERT INTO links VALUES (27,201,13);
INSERT INTO links VALUES (32,70,13);
INSERT INTO links VALUES (32,204,13);
INSERT INTO links VALUES (42,120,13);
INSERT INTO links VALUES (42,292,13);
INSERT INTO links VALUES (43,79,13);
INSERT INTO links VALUES (43,219,13);
INSERT INTO links VALUES (43,304,13);
INSERT INTO links VALUES (61,171,13);
INSERT INTO links VALUES (61,238,13);
INSERT INTO links VALUES (63,203,13);
INSERT INTO links VALUES (63,219,13);
INSERT INTO links VALUES (64,106,13);
INSERT INTO links VALUES (64,135,13);
INSERT INTO links VALUES (65,97,13);
INSERT INTO links VALUES (69,86,13);
INSERT INTO links VALUES (69,106,13);
INSERT INTO links VALUES (86,152,13);
INSERT INTO links VALUES (120,238,13);
INSERT INTO links VALUES (135,171,13);
INSERT INTO links VALUES (155,225,13);
INSERT INTO links VALUES (155,284,13);
INSERT INTO links VALUES (201,284,13);
INSERT INTO links VALUES (201,292,13);
INSERT INTO links VALUES (203,217,13);
INSERT INTO links VALUES (204,247,13);
INSERT INTO links VALUES (225,262,13);
INSERT INTO links VALUES (284,292,13);
INSERT INTO links VALUES (304,305,13);
INSERT INTO links VALUES (305,306,13);
INSERT INTO links VALUES (306,307,13);
INSERT INTO links VALUES (117,308,10);

--
-- Table structure for table routes
--
CREATE TABLE routes (
  line smallint NOT NULL default '0' PRIMARY KEY,
  name varchar(64) NOT NULL default '',
  colour varchar(6) NOT NULL default '',
  stripe varchar(6) default NULL,
  UNIQUE (line)
);

--
-- 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');

--
-- Table structure for table stations
--
CREATE TABLE stations (
  id smallint NOT NULL default '0' UNIQUE,
  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 smallint NOT NULL default '0',
  rail smallint NOT NULL default '0',
  PRIMARY KEY (id)
);

--
-- 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',3,1,1);
INSERT INTO stations VALUES (27,51.5079,-0.0066,'Blackwall',NULL,2,1,0);
INSERT INTO stations VALUES (28,51.5142,-0.1494,'Bond Street','Bond<br />Street',1,2,0);
INSERT INTO stations VALUES (29,51.5011,-0.0943,'Borough',NULL,1,1,0);
INSERT INTO stations VALUES (30,51.4956,-0.325,'Boston Manor','Boston<br />Manor',4,1,0);
INSERT INTO stations VALUES (31,51.6071,-0.1243,'Bounds Green','Bounds<br />Green',3.5,1,0);
INSERT INTO stations VALUES (32,51.5273,-0.0208,'Bow Church','Bow<br />Church',2,1,0);
INSERT INTO stations VALUES (33,51.5269,-0.0247,'Bow Road','Bow<br />Road',2,2,0);
INSERT INTO stations VALUES (34,51.5766,-0.2136,'Brent Cross','Brent<br />Cross',3,1,0);
INSERT INTO stations VALUES (36,51.5248,-0.0119,'Bromley-By-Bow',NULL,2.5,2,0);
INSERT INTO stations VALUES (38,51.6028,-0.2641,'Burnt Oak','Burnt<br />Oak',4,1,0);
INSERT INTO stations VALUES (39,51.5481,-0.1188,'Caledonian Road','Caledonian<br />Road',2,1,0);
INSERT INTO stations VALUES (40,51.5392,-0.1426,'Camden Town','Camden<br />Town',2,1,0);
INSERT INTO stations VALUES (42,51.5051,-0.0209,'Canary Wharf','Canary<br />Wharf',2,2,0);
INSERT INTO stations VALUES (44,51.5113,-0.0904,'Cannon Street','Cannon<br />Street',1,2,0);
INSERT INTO stations VALUES (45,51.6078,-0.2947,'Canons Park','Canons<br />Park',5,1,0);
INSERT INTO stations VALUES (47,51.5441,-0.1538,'Chalk Farm','Chalk<br />Farm',2,1,0);
INSERT INTO stations VALUES (48,51.5185,-0.1111,'Chancery Lane','Chancery<br />Lane',1,1,0);
INSERT INTO stations VALUES (49,51.508,-0.1247,'Charing Cross','Charing<br />Cross',1,2,1);
INSERT INTO stations VALUES (51,51.6177,0.0755,'Chigwell',NULL,5,1,0);
INSERT INTO stations VALUES (52,51.4946,-0.2678,'Chiswick Park','Chiswick<br />Park',3,1,0);
INSERT INTO stations VALUES (54,51.4618,-0.1384,'Clapham Common','Clapham<br />Common',2,1,0);
INSERT INTO stations VALUES (55,51.4649,-0.1299,'Clapham North','Clapham<br />North',2,1,0);
INSERT INTO stations VALUES (56,51.4527,-0.148,'Clapham South','Clapham<br />South',2.5,1,0);
INSERT INTO stations VALUES (58,51.5955,-0.2502,'Colindale',NULL,4,1,0);
INSERT INTO stations VALUES (59,51.418,-0.1778,'Colliers Wood','Colliers<br />Wood',3,1,0);
INSERT INTO stations VALUES (60,51.5129,-0.1243,'Covent Garden','Covent<br />Garden',1,1,0);
INSERT INTO stations VALUES (61,51.4957,-0.0144,'Crossharbour & London Arena','Crossharbour &<br />London Arena',2,1,0);
INSERT INTO stations VALUES (63,51.5095,0.0276,'Custom House','Custom<br />House',3,1,0);
INSERT INTO stations VALUES (65,51.5085,0.064,'Cyprus',NULL,3,1,0);
INSERT INTO stations VALUES (66,51.5443,0.1655,'Dagenham East','Dagenham<br />East',5,1,0);
INSERT INTO stations VALUES (67,51.5417,0.1469,'Dagenham Heathway','Dagenham<br />Heathway',5,1,0);
INSERT INTO stations VALUES (70,51.5223,-0.0173,'Devons Road','Devons<br />Road',2,1,0);
INSERT INTO stations VALUES (71,51.552,-0.2387,'Dollis Hill','Dollis<br />Hill',3,1,0);
INSERT INTO stations VALUES (72,51.5152,-0.3017,'Ealing Broadway','Ealing<br />Broadway',3,2,1);
INSERT INTO stations VALUES (73,51.5101,-0.2882,'Ealing Common','Ealing<br />Common',3,2,0);
INSERT INTO stations VALUES (74,51.492,-0.1973,'Earl\'s Court','Earl\'s<br />Court',1.5,2,0);
INSERT INTO stations VALUES (75,51.5765,-0.397,'Eastcote',NULL,5,2,0);
INSERT INTO stations VALUES (76,51.5168,-0.2474,'East Acton','East<br />Acton',2,1,0);
INSERT INTO stations VALUES (77,51.5874,-0.165,'East Finchley','East<br />Finchley',3,1,0);
INSERT INTO stations VALUES (78,51.5394,0.0518,'East Ham','East<br />Ham',3.5,2,0);
INSERT INTO stations VALUES (79,51.5093,-0.0021,'East India','East<br />India',2.5,1,0);
INSERT INTO stations VALUES (80,51.4586,-0.2112,'East Putney','East<br />Putney',2.5,1,0);
INSERT INTO stations VALUES (81,51.6137,-0.275,'Edgware',NULL,5,1,0);
INSERT INTO stations VALUES (82,51.5199,-0.1679,'Edgware Road (B)','Edgware<br />Road',1,1,0);
INSERT INTO stations VALUES (83,51.5203,-0.17,'Edgware Road (C)','Edgware<br />Road',1,3,0);
INSERT INTO stations VALUES (84,51.4943,-0.1001,'Elephant & Castle','Elephant &<br />Castle',1.5,2,1);
INSERT INTO stations VALUES (85,51.5496,0.1977,'Elm Park','Elm<br />Park',6,1,0);
INSERT INTO stations VALUES (87,51.5074,-0.1223,'Embankment',NULL,1,4,0);
INSERT INTO stations VALUES (89,51.5282,-0.1337,'Euston',NULL,1,2,1);
INSERT INTO stations VALUES (90,51.526,-0.1359,'Euston Square','Euston<br />Square',1,3,0);
INSERT INTO stations VALUES (91,51.596,0.0912,'Fairlop',NULL,5,1,0);
INSERT INTO stations VALUES (92,51.5203,-0.1053,'Farringdon',NULL,1,3,1);
INSERT INTO stations VALUES (93,51.6012,-0.1932,'Finchley Central','Finchley<br />Central',4,1,0);
INSERT INTO stations VALUES (94,51.5472,-0.1803,'Finchley Road','Finchley<br />Road',2,2,0);
INSERT INTO stations VALUES (95,51.5642,-0.1065,'Finsbury Park','Finsbury<br />Park',2,1,1);
INSERT INTO stations VALUES (96,51.4804,-0.195,'Fulham Broadway','Fulham<br />Broadway',2,1,0);
INSERT INTO stations VALUES (97,51.5096,0.0716,'Gallions Reach','Gallions<br />Reach',3,1,0);
INSERT INTO stations VALUES (98,51.5765,0.0663,'Gants Hill','Gants<br />Hill',4,1,0);
INSERT INTO stations VALUES (99,51.4945,-0.1829,'Gloucester Road','Gloucester<br />Road',1,3,0);
INSERT INTO stations VALUES (100,51.5724,-0.1941,'Golders Green','Golders<br />Green',3,1,0);
INSERT INTO stations VALUES (101,51.5018,-0.2267,'Goldhawk Road','Goldhawk<br />Road',2,1,0);
INSERT INTO stations VALUES (102,51.5205,-0.1347,'Goodge Street','Goodge<br />Street',1,1,0);
INSERT INTO stations VALUES (103,51.6132,0.0923,'Grange Hill','Grange<br />Hill',5,1,0);
INSERT INTO stations VALUES (104,51.5238,-0.1439,'Great Portland Street','Great<br />Portland<br />Street',1,3,0);
INSERT INTO stations VALUES (105,51.5423,-0.3456,'Greenford',NULL,4,1,1);
INSERT INTO stations VALUES (107,51.5067,-0.1428,'Green Park','Green<br />Park',1,3,0);
INSERT INTO stations VALUES (108,51.4915,-0.2754,'Gunnersbury',NULL,3,1,0);
INSERT INTO stations VALUES (109,51.603,0.0933,'Hainault',NULL,5,1,0);
INSERT INTO stations VALUES (110,51.4936,-0.2251,'Hammersmith',NULL,2,3,0);
INSERT INTO stations VALUES (111,51.5568,-0.178,'Hampstead',NULL,2.5,1,0);
INSERT INTO stations VALUES (112,51.5302,-0.2933,'Hanger Lane','Hanger<br />Lane',3,1,0);
INSERT INTO stations VALUES (113,51.5362,-0.2575,'Harlesden',NULL,3,1,0);
INSERT INTO stations VALUES (114,51.5925,-0.3351,'Harrow & Wealdstone','Harrow &<br />Wealdstone',5,1,1);
INSERT INTO stations VALUES (115,51.5793,-0.3366,'Harrow-on-the-Hill','Harrow-<br />on-the-Hill',5,1,1);
INSERT INTO stations VALUES (116,51.4669,-0.4227,'Hatton Cross','Hatton<br />Cross',5.5,1,0);
INSERT INTO stations VALUES (117,51.4713,-0.4524,'Heathrow Terminals 1, 2 & 3','Heathrow<br />Terminals<br />1, 2 & 3',6,1,0);
INSERT INTO stations VALUES (118,51.4598,-0.4476,'Heathrow Terminal 4','Heathrow<br />Terminal 4',6,1,0);
INSERT INTO stations VALUES (119,51.5829,-0.2259,'Hendon Central','Hendon<br />Central',3.5,1,0);
INSERT INTO stations VALUES (120,51.5033,-0.0215,'Heron Quays','Heron<br />Quays',2,1,0);
INSERT INTO stations VALUES (122,51.5009,-0.1925,'High Street Kensington','High<br />Street<br />Kensington',1,2,0);
INSERT INTO stations VALUES (123,51.546,-0.104,'Highbury & Islington','Highbury &<br />Islington',2,1,1);
INSERT INTO stations VALUES (124,51.5777,-0.1458,'Highgate',NULL,3,1,0);
INSERT INTO stations VALUES (125,51.5538,-0.4499,'Hillingdon',NULL,6,2,0);
INSERT INTO stations VALUES (126,51.5174,-0.12,'Holborn',NULL,1,2,0);
INSERT INTO stations VALUES (127,51.5075,-0.206,'Holland Park','Holland<br />Park',2,1,0);
INSERT INTO stations VALUES (128,51.5526,-0.1132,'Holloway Road','Holloway<br />Road',2,1,0);
INSERT INTO stations VALUES (129,51.5539,0.2184,'Hornchurch',NULL,6,1,0);
INSERT INTO stations VALUES (130,51.4713,-0.3665,'Hounslow Central','Hounslow<br />Central',4,1,0);
INSERT INTO stations VALUES (131,51.4733,-0.3564,'Hounslow East','Hounslow<br />East',4,1,0);
INSERT INTO stations VALUES (132,51.4734,-0.3855,'Hounslow West','Hounslow<br />West',5,1,0);
INSERT INTO stations VALUES (133,51.5027,-0.1527,'Hyde Park Corner','Hyde<br />Park<br />Corner',1,1,0);
INSERT INTO stations VALUES (134,51.5619,-0.4421,'Ickenham',NULL,6,2,0);
INSERT INTO stations VALUES (135,51.4871,-0.0101,'Island Gardens','Island<br />Gardens',2,1,0);
INSERT INTO stations VALUES (136,51.4884,-0.1053,'Kennington',NULL,2,1,0);
INSERT INTO stations VALUES (137,51.5304,-0.225,'Kensal Green','Kensal<br />Green',2,1,0);
INSERT INTO stations VALUES (138,51.4983,-0.2106,'Kensington (Olympia)','Kensington<br />(Olympia)',2,1,1);
INSERT INTO stations VALUES (139,51.5507,-0.1402,'Kentish Town','Kentish<br />Town',2,1,1);
INSERT INTO stations VALUES (140,51.5816,-0.3162,'Kenton',NULL,4,1,0);
INSERT INTO stations VALUES (141,51.477,-0.285,'Kew Gardens','Kew<br />Gardens',3.5,1,0);
INSERT INTO stations VALUES (142,51.5471,-0.2047,'Kilburn',NULL,2,1,0);
INSERT INTO stations VALUES (143,51.5351,-0.1939,'Kilburn Park','Kilburn<br />Park',2,1,0);
INSERT INTO stations VALUES (144,51.5846,-0.2786,'Kingsbury',NULL,4,1,0);
INSERT INTO stations VALUES (145,51.5308,-0.1238,'King\'s Cross St. Pancras','King\'s Cross<br />St. Pancras',1,6,1);
INSERT INTO stations VALUES (146,51.5015,-0.1607,'Knightsbridge',NULL,1,1,0);
INSERT INTO stations VALUES (147,51.5172,-0.2107,'Ladbroke Grove','Ladbroke<br />Grove',2,1,0);
INSERT INTO stations VALUES (148,51.4991,-0.1115,'Lambeth North','Lambeth<br />North',1,1,0);
INSERT INTO stations VALUES (149,51.5119,-0.1756,'Lancaster Gate','Lancaster<br />Gate',1,1,0);
INSERT INTO stations VALUES (150,51.5139,-0.2172,'Latimer Road','Latimer<br />Road',2,1,0);
INSERT INTO stations VALUES (151,51.5113,-0.1281,'Leicester Square','Leicester<br />Square',1,2,0);
INSERT INTO stations VALUES (153,51.5566,-0.0053,'Leyton',NULL,3,1,0);
INSERT INTO stations VALUES (154,51.5683,0.0083,'Leytonstone',NULL,3.5,1,0);
INSERT INTO stations VALUES (155,51.5123,-0.0396,'Limehouse',NULL,2,1,1);
INSERT INTO stations VALUES (156,51.5178,-0.0823,'Liverpool Street','Liverpool<br />Street',1,4,1);
INSERT INTO stations VALUES (157,51.5052,-0.0864,'London Bridge','London<br />Bridge',1,2,1);
INSERT INTO stations VALUES (159,51.53,-0.1854,'Maida Vale','Maida<br />Vale',2,1,0);
INSERT INTO stations VALUES (160,51.5712,-0.0958,'Manor House','Manor<br />House',2.5,1,0);
INSERT INTO stations VALUES (161,51.5122,-0.094,'Mansion House','Mansion<br />House',1,2,0);
INSERT INTO stations VALUES (162,51.5136,-0.1586,'Marble Arch','Marble<br />Arch',1,1,0);
INSERT INTO stations VALUES (163,51.5225,-0.1631,'Marylebone',NULL,1,1,1);
INSERT INTO stations VALUES (164,51.5249,-0.0332,'Mile End','Mile<br />End',2,3,0);
INSERT INTO stations VALUES (165,51.6082,-0.2103,'Mill Hill East','Mill<br />Hill<br />East',4,1,0);
INSERT INTO stations VALUES (166,51.5108,-0.0863,'Monument',NULL,1,2,0);
INSERT INTO stations VALUES (167,51.5186,-0.0886,'Moorgate',NULL,1,4,1);
INSERT INTO stations VALUES (168,51.6294,-0.432,'Moor Park','Moor<br />Park',6.5,1,0);
INSERT INTO stations VALUES (169,51.4022,-0.1948,'Morden',NULL,4,1,0);
INSERT INTO stations VALUES (170,51.5342,-0.1387,'Mornington Crescent','Mornington<br />Crescent',2,1,0);
INSERT INTO stations VALUES (171,51.4902,-0.0145,'Mudchute',NULL,2,1,0);
INSERT INTO stations VALUES (172,51.5542,-0.2503,'Neasden',NULL,3,1,0);
INSERT INTO stations VALUES (173,51.5756,0.0899,'Newbury Park','Newbury<br />Park',4,1,0);
INSERT INTO stations VALUES (176,51.4995,-0.3142,'Northfields',NULL,3,1,0);
INSERT INTO stations VALUES (177,51.5483,-0.3687,'Northolt',NULL,5,1,0);
INSERT INTO stations VALUES (178,51.5784,-0.3184,'Northwick Park','Northwick<br />Park',4,1,0);
INSERT INTO stations VALUES (179,51.6111,-0.424,'Northwood',NULL,6,1,0);
INSERT INTO stations VALUES (180,51.6004,-0.4092,'Northwood Hills','Northwood<br />Hills',6,1,0);
INSERT INTO stations VALUES (181,51.5237,-0.2597,'North Acton','North<br />Acton',2.5,1,0);
INSERT INTO stations VALUES (182,51.5175,-0.2887,'North Ealing','North<br />Ealing',3,1,0);
INSERT INTO stations VALUES (184,51.5846,-0.3626,'North Harrow','North<br />Harrow',5,1,0);
INSERT INTO stations VALUES (185,51.5621,-0.3034,'North Wembley','North<br />Wembley',4,1,0);
INSERT INTO stations VALUES (186,51.5094,-0.1967,'Notting Hill Gate','Notting<br />Hill Gate',1.5,3,0);
INSERT INTO stations VALUES (188,51.5263,-0.0873,'Old Street','Old<br />Street',1,1,1);
INSERT INTO stations VALUES (190,51.4813,-0.3522,'Osterley',NULL,4,1,0);
INSERT INTO stations VALUES (191,51.4819,-0.113,'Oval',NULL,2,1,0);
INSERT INTO stations VALUES (192,51.515,-0.1415,'Oxford Circus','Oxford<br />Circus',1,3,0);
INSERT INTO stations VALUES (193,51.5154,-0.1755,'Paddington',NULL,1,4,1);
INSERT INTO stations VALUES (194,51.527,-0.2841,'Park Royal','Park<br />Royal',3,1,0);
INSERT INTO stations VALUES (195,51.4753,-0.2011,'Parsons Green','Parsons<br />Green',2,1,0);
INSERT INTO stations VALUES (196,51.5366,-0.3232,'Perivale',NULL,4,1,0);
INSERT INTO stations VALUES (197,51.5098,-0.1342,'Piccadilly Circus','Piccadilly<br />Circus',1,2,0);
INSERT INTO stations VALUES (198,51.4893,-0.1334,'Pimlico',NULL,1,1,0);
INSERT INTO stations VALUES (199,51.5926,-0.3805,'Pinner',NULL,5,1,0);
INSERT INTO stations VALUES (200,51.5313,0.0172,'Plaistow',NULL,3,2,0);
INSERT INTO stations VALUES (201,51.5077,-0.0173,'Poplar',NULL,2,1,0);
INSERT INTO stations VALUES (202,51.572,-0.2954,'Preston Road','Preston<br />Road',4,1,0);
INSERT INTO stations VALUES (203,51.5093,0.0336,'Prince Regent','Prince<br />Regent',3,1,0);
INSERT INTO stations VALUES (205,51.4682,-0.2089,'Putney Bridge','Putney<br />Bridge',2,1,0);
INSERT INTO stations VALUES (206,51.5341,-0.2047,'Queen\'s Park','Queens<br />Park',2,1,1);
INSERT INTO stations VALUES (207,51.5942,-0.2861,'Queensbury',NULL,4,1,0);
INSERT INTO stations VALUES (208,51.5107,-0.1877,'Queensway',NULL,1,1,0);
INSERT INTO stations VALUES (209,51.4942,-0.2359,'Ravenscourt Park','Ravenscourt<br />Park',2,1,0);
INSERT INTO stations VALUES (210,51.5753,-0.3714,'Rayners Lane','Rayners<br />Lane',5,2,0);
INSERT INTO stations VALUES (211,51.5763,0.0454,'Redbridge',NULL,4,1,0);
INSERT INTO stations VALUES (212,51.5234,-0.1466,'Regent\'s Park','Regent\'s<br />Park',1,1,0);
INSERT INTO stations VALUES (213,51.4633,-0.3013,'Richmond',NULL,4,1,1);
INSERT INTO stations VALUES (215,51.6171,0.0439,'Roding Valley','Roding<br />Valley',5,1,0);
INSERT INTO stations VALUES (216,51.501,-0.0525,'Rotherhithe',NULL,2,1,0);
INSERT INTO stations VALUES (217,51.5084,0.0465,'Royal Albert','Royal<br />Albert',3,1,0);
INSERT INTO stations VALUES (218,51.519,-0.188,'Royal Oak','Royal<br />Oak',2,1,0);
INSERT INTO stations VALUES (219,51.5091,0.0181,'Royal Victoria','Royal<br />Victoria',3,1,0);
INSERT INTO stations VALUES (220,51.5715,-0.4213,'Ruislip',NULL,6,2,0);
INSERT INTO stations VALUES (222,51.5732,-0.4125,'Ruislip Manor','Ruislip<br />Manor',6,2,0);
INSERT INTO stations VALUES (223,51.523,-0.1244,'Russell Square','Russell<br />Square',1,1,0);
INSERT INTO stations VALUES (224,51.5822,-0.0749,'Seven Sisters','Seven<br />Sisters',3,1,1);
INSERT INTO stations VALUES (225,51.5117,-0.056,'Shadwell',NULL,2,2,0);
INSERT INTO stations VALUES (226,51.5046,-0.2187,'Shepherd\'s Bush (C)','Shepherd\'s<br />Bush',2,1,0);
INSERT INTO stations VALUES (227,51.5058,-0.2265,'Shepherd\'s Bush (H)','Shepherd\'s<br />Bush',2,1,0);
INSERT INTO stations VALUES (228,51.5227,-0.0708,'Shoreditch',NULL,2,1,0);
INSERT INTO stations VALUES (229,51.4924,-0.1565,'Sloane Square','Sloane<br />Square',1,2,0);
INSERT INTO stations VALUES (230,51.5808,0.0216,'Snaresbrook',NULL,4,1,0);
INSERT INTO stations VALUES (231,51.4454,-0.2066,'Southfields',NULL,3,1,0);
INSERT INTO stations VALUES (234,51.5011,-0.3072,'South Ealing','South<br />Ealing',3,1,0);
INSERT INTO stations VALUES (235,51.5646,-0.3521,'South Harrow','South<br />Harrow',5,1,0);
INSERT INTO stations VALUES (236,51.4941,-0.1738,'South Kensington','South<br />Kensington',1,3,0);
INSERT INTO stations VALUES (237,51.5701,-0.3081,'South Kenton','South<br />Kenton',4,1,0);
INSERT INTO stations VALUES (238,51.5007,-0.0191,'South Quay','South<br />Quay',2,1,0);
INSERT INTO stations VALUES (239,51.5569,-0.3988,'South Ruislip','South<br />Ruislip',5,1,1);
INSERT INTO stations VALUES (240,51.4154,-0.1919,'South Wimbledon','South<br />Wimbledon',3.5,1,0);
INSERT INTO stations VALUES (241,51.5917,0.0275,'South Woodford','South<br />Woodford',4,1,0);
INSERT INTO stations VALUES (242,51.495,-0.2459,'Stamford Brook','Stamford<br />Brook',2,1,0);
INSERT INTO stations VALUES (243,51.6194,-0.3028,'Stanmore',NULL,5,1,0);
INSERT INTO stations VALUES (244,51.5221,-0.047,'Stepney Green','Stepney<br />Green',2,2,0);
INSERT INTO stations VALUES (245,51.4723,-0.123,'Stockwell',NULL,2,2,0);
INSERT INTO stations VALUES (246,51.5439,-0.2759,'Stonebridge Park','Stonebridge<br />Park',3,1,0);
INSERT INTO stations VALUES (247,51.5416,-0.0042,'Stratford',NULL,3,3,1);
INSERT INTO stations VALUES (248,51.4994,-0.1335,'St. James\'s Park','St. James\'s<br />Park',1,2,0);
INSERT INTO stations VALUES (249,51.5347,-0.174,'St. John\'s Wood','St. John\'s<br />Wood',2,1,0);
INSERT INTO stations VALUES (250,51.5146,-0.0973,'St. Paul\'s','St. Paul\'s',1,1,0);
INSERT INTO stations VALUES (251,51.5569,-0.3366,'Sudbury Hill','Sudbury<br />Hill',4,1,0);
INSERT INTO stations VALUES (252,51.5507,-0.3156,'Sudbury Town','Sudbury<br />Town',4,1,0);
INSERT INTO stations VALUES (253,51.4933,-0.0478,'Surrey Quays','Surrey<br />Quays',2,1,0);
INSERT INTO stations VALUES (254,51.5432,-0.1738,'Swiss Cottage','Swiss<br />Cottage',2,2,0);
INSERT INTO stations VALUES (255,51.5111,-0.1141,'Temple',NULL,1,2,0);
INSERT INTO stations VALUES (257,51.4361,-0.1598,'Tooting Bec','Tooting<br />Bec',3,1,0);
INSERT INTO stations VALUES (258,51.4275,-0.168,'Tooting Broadway','Tooting<br />Broadway',3,1,0);
INSERT INTO stations VALUES (259,51.5165,-0.131,'Tottenham Court Road','Tottenham<br />Court<br />Road',1,2,0);
INSERT INTO stations VALUES (260,51.5882,-0.0594,'Tottenham Hale','Tottenham<br />Hale',3,1,1);
INSERT INTO stations VALUES (262,51.5106,-0.0743,'Tower Gateway','Tower<br />Gateway',1,1,0);
INSERT INTO stations VALUES (263,51.5098,-0.0766,'Tower Hill','Tower<br />Hill',1,2,0);
INSERT INTO stations VALUES (264,51.5567,-0.1374,'Tufnell Park','Tufnell<br />Park',2,1,0);
INSERT INTO stations VALUES (265,51.4951,-0.2547,'Turnham Green','Turnham<br />Green',2.5,2,0);
INSERT INTO stations VALUES (266,51.5904,-0.1028,'Turnpike Lane','Turnpike<br />Lane',3,1,0);
INSERT INTO stations VALUES (267,51.559,0.251,'Upminster',NULL,6,1,1);
INSERT INTO stations VALUES (268,51.5582,0.2343,'Upminster Bridge','Upminster<br />Bridge',6,1,0);
INSERT INTO stations VALUES (269,51.5385,0.1014,'Upney',NULL,4,1,0);
INSERT INTO stations VALUES (270,51.5352,0.0343,'Upton Park','Upton<br />Park',3,2,0);
INSERT INTO stations VALUES (271,51.5463,-0.4786,'Uxbridge',NULL,6,2,0);
INSERT INTO stations VALUES (272,51.4861,-0.1253,'Vauxhall',NULL,1.5,1,1);
INSERT INTO stations VALUES (273,51.4965,-0.1447,'Victoria',NULL,1,3,1);
INSERT INTO stations VALUES (274,51.583,-0.0195,'Walthamstow Central','Walthamstow<br />Central',3,1,1);
INSERT INTO stations VALUES (275,51.5775,0.0288,'Wanstead',NULL,4,1,0);
INSERT INTO stations VALUES (276,51.5043,-0.0558,'Wapping',NULL,2,1,0);
INSERT INTO stations VALUES (277,51.5247,-0.1384,'Warren Street','Warren<br />Street',1,2,0);
INSERT INTO stations VALUES (278,51.5235,-0.1835,'Warwick Avenue','Warwick<br />Avenue',2,1,0);
INSERT INTO stations VALUES (279,51.5036,-0.1143,'Waterloo',NULL,1,4,1);
INSERT INTO stations VALUES (281,51.5519,-0.2963,'Wembley Central','Wembley<br />Central',4,1,1);
INSERT INTO stations VALUES (282,51.5635,-0.2795,'Wembley Park','Wembley<br />Park',4,2,0);
INSERT INTO stations VALUES (283,51.521,-0.2011,'Westbourne Park','Westbourne<br />Park',2,1,0);
INSERT INTO stations VALUES (284,51.5097,-0.0265,'Westferry',NULL,2,1,0);
INSERT INTO stations VALUES (285,51.501,-0.1254,'Westminster',NULL,1,3,0);
INSERT INTO stations VALUES (286,51.518,-0.2809,'West Acton','West<br />Acton',3,1,0);
INSERT INTO stations VALUES (287,51.4872,-0.1953,'West Brompton','West<br />Brompton',2,1,1);
INSERT INTO stations VALUES (288,51.6095,-0.1883,'West Finchley','West<br />Finchley',4,1,0);
INSERT INTO stations VALUES (289,51.5287,0.0056,'West Ham','West<br />Ham',3,3,1);
INSERT INTO stations VALUES (290,51.5469,-0.1906,'West Hampstead','West<br />Hampstead',2,1,1);
INSERT INTO stations VALUES (291,51.5795,-0.3533,'West Harrow','West<br />Harrow',5,1,0);
INSERT INTO stations VALUES (292,51.507,-0.0203,'West India Quay','West<br />India<br />Quay',2,1,0);
INSERT INTO stations VALUES (293,51.4907,-0.2065,'West Kensington','West<br />Kensington',2,1,0);
INSERT INTO stations VALUES (294,51.5696,-0.4376,'West Ruislip','West<br />Ruislip',6,1,1);
INSERT INTO stations VALUES (295,51.5194,-0.0612,'Whitechapel',NULL,2,3,0);
INSERT INTO stations VALUES (296,51.512,-0.2239,'White City','White<br />City',2,1,0);
INSERT INTO stations VALUES (297,51.5492,-0.2215,'Willesden Green','Willesden<br />Green',2.5,1,0);
INSERT INTO stations VALUES (298,51.5326,-0.2478,'Willesden Junction','Willesden<br />Junction',3,1,1);
INSERT INTO stations VALUES (299,51.4214,-0.2064,'Wimbledon',NULL,3,1,1);
INSERT INTO stations VALUES (300,51.4343,-0.1992,'Wimbledon Park','Wimbledon<br />Park',3,1,0);
INSERT INTO stations VALUES (301,51.607,0.0341,'Woodford',NULL,4,1,0);
INSERT INTO stations VALUES (302,51.6179,-0.1856,'Woodside Park','Woodside<br />Park',4,1,0);
INSERT INTO stations VALUES (303,51.5975,-0.1097,'Wood Green','Wood<br />Green',3,1,0);
INSERT INTO stations VALUES (35,51.4627,-0.1145,'Brixton',NULL,2,1,1);
INSERT INTO stations VALUES (6,51.6736,-0.607,'Amersham',NULL,10,1,1);
INSERT INTO stations VALUES (23,51.4979,-0.0637,'Bermondsey',NULL,2,1,0);
INSERT INTO stations VALUES (50,51.7052,-0.611,'Chesham',NULL,10,1,0);
INSERT INTO stations VALUES (46,51.6679,-0.561,'Chalfont & Latimer','Chalfont &<br />Latimer',9,1,1);
INSERT INTO stations VALUES (53,51.6543,-0.5183,'Chorleywood',NULL,8,1,0);
INSERT INTO stations VALUES (214,51.6404,-0.4733,'Rickmansworth',NULL,7,1,0);
INSERT INTO stations VALUES (62,51.647,-0.4412,'Croxley',NULL,7,1,0);
INSERT INTO stations VALUES (280,51.6573,-0.4177,'Watford',NULL,8,1,0);
INSERT INTO stations VALUES (221,51.5606,-0.4103,'Ruislip Gardens','Ruislip<br />Gardens',5,1,0);
INSERT INTO stations VALUES (121,51.6503,-0.1943,'High Barnet','High<br />Barnet',5,1,0);
INSERT INTO stations VALUES (261,51.6302,-0.1791,'Totteridge & Whetstone','Totteridge<br />& Whetstone',4,1,0);
INSERT INTO stations VALUES (57,51.6517,-0.1496,'Cockfosters',NULL,5,1,0);
INSERT INTO stations VALUES (187,51.6476,-0.1318,'Oakwood',NULL,5,1,0);
INSERT INTO stations VALUES (232,51.6322,-0.128,'Southgate',NULL,4,1,0);
INSERT INTO stations VALUES (88,51.6937,0.1139,'Epping',NULL,6,1,0);
INSERT INTO stations VALUES (256,51.6717,0.1033,'Theydon Bois','Theydon<br />Bois',6,1,0);
INSERT INTO stations VALUES (68,51.6455,0.0838,'Debden',NULL,6,1,0);
INSERT INTO stations VALUES (158,51.6412,0.0558,'Loughton',NULL,6,1,0);
INSERT INTO stations VALUES (37,51.6266,0.0471,'Buckhurst Hill','Buckhurst<br />Hill',5,1,0);
INSERT INTO stations VALUES (204,51.5343,-0.0139,'Pudding Mill Lane','Pudding<br />Mill Lane',2.5,1,0);
INSERT INTO stations VALUES (233,51.504,-0.1052,'Southwark',NULL,1,1,0);
INSERT INTO stations VALUES (41,51.4982,-0.0502,'Canada Water','Canada<br />Water',2,2,0);
INSERT INTO stations VALUES (43,51.5147,0.0082,'Canning Town','Canning<br />Town',3,2,1);
INSERT INTO stations VALUES (183,51.5005,0.0039,'North Greenwich','North<br />Greenwich',2.5,1,0);
INSERT INTO stations VALUES (64,51.4827,-0.0096,'Cutty Sark','Cutty<br />Sark',2.5,1,0);
INSERT INTO stations VALUES (106,51.4781,-0.0149,'Greenwich',NULL,2.5,1,1);
INSERT INTO stations VALUES (69,51.474,-0.0216,'Deptford Bridge','Deptford<br />Bridge',2.5,1,0);
INSERT INTO stations VALUES (86,51.4693,-0.0174,'Elverson Road','Elverson<br />Road',2.5,1,0);
INSERT INTO stations VALUES (152,51.4657,-0.0142,'Lewisham',NULL,2.5,1,1);
INSERT INTO stations VALUES (174,51.4767,-0.0327,'New Cross','New<br />Cross',2,1,1);
INSERT INTO stations VALUES (175,51.4757,-0.0402,'New Cross Gate','New<br />Cross<br />Gate',2,1,1);
INSERT INTO stations VALUES (304,51.5027,0.0226,'West Silvertown','West<br />Silvertown',3,1,0);
INSERT INTO stations VALUES (307,51.502,0.0627,'King George V','King<br />George V',3,1,0);
INSERT INTO stations VALUES (305,51.5021,0.0319,'Pontoon Dock','Pontoon<br />Dock',3,1,0);
INSERT INTO stations VALUES (306,51.5037,0.0488,'London City Airport','London<br />City<br />Airport',3,1,0);
INSERT INTO stations VALUES (308,51.47006,-0.49108,'Heathrow Terminal 5','Heathrow<br /> Terminal 5',6,1,1);

-- 

--