Repository navigation
Expand file tree
/
Copy pathtransit-stations.sql
More file actions
112 lines (108 loc) · 7.23 KB
/
Copy pathtransit-stations.sql
File metadata and controls
112 lines (108 loc) · 7.23 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
-- 90 synthetic stations on an invented metro network. Invented data; it describes nobody.
-- Portable enough for SQLite, PostgreSQL, and MySQL.
DROP TABLE IF EXISTS transit_stations;
CREATE TABLE transit_stations (
station_id TEXT PRIMARY KEY,
name TEXT NOT NULL,
line TEXT NOT NULL,
zone INTEGER NOT NULL,
opened_year INTEGER NOT NULL,
platforms INTEGER NOT NULL,
grid_x INTEGER NOT NULL,
grid_y INTEGER NOT NULL,
step_free INTEGER NOT NULL,
interchange INTEGER NOT NULL,
daily_boardings INTEGER NOT NULL
);
INSERT INTO transit_stations (station_id, name, line, zone, opened_year, platforms, grid_x, grid_y, step_free, interchange, daily_boardings) VALUES
('ST-001', 'Vellin Halt', 'Crimson', 2, 1978, 2, 45, -10, 1, 0, 24137),
('ST-002', 'Quill Wharf', 'Cobalt', 3, 1993, 2, 45, 11, 1, 0, 447),
('ST-003', 'Quill Green', 'Cobalt', 5, 2000, 6, -26, -33, 1, 0, 5759),
('ST-004', 'Dunmar Cross', 'Violet', 3, 1969, 1, -42, 36, 1, 0, 6288),
('ST-005', 'Eastmoor Fields', 'Violet', 1, 1986, 2, -18, 31, 0, 0, 22686),
('ST-006', 'Elmgate Hill', 'Crimson', 1, 1998, 6, -43, 11, 1, 0, 41339),
('ST-007', 'Harrow Row', 'Amber', 1, 1992, 2, -34, 6, 0, 0, 54867),
('ST-008', 'Glass Halt', 'Crimson', 5, 2023, 4, -3, -32, 1, 1, 1484),
('ST-009', 'Quill Cross', 'Slate', 4, 2001, 4, 33, -34, 0, 1, 3980),
('ST-010', 'Alder Quay', 'Violet', 2, 1993, 3, -8, 33, 1, 0, 8887),
('ST-011', 'Pinfold Fields', 'Violet', 3, 1999, 4, 7, -15, 1, 1, 13962),
('ST-012', 'Pinfold Park', 'Slate', 1, 2020, 2, -37, -6, 0, 0, 45969),
('ST-013', 'Quill End', 'Emerald', 5, 2003, 3, 8, 12, 0, 0, 7225),
('ST-014', 'Foxhollow Vale', 'Amber', 3, 1989, 4, 1, 25, 1, 0, 12051),
('ST-015', 'Eastmoor Central', 'Emerald', 1, 2018, 5, -38, -26, 0, 1, 48982),
('ST-016', 'Nether Wharf', 'Slate', 2, 2009, 4, 13, 15, 1, 1, 24417),
('ST-017', 'Fernway Central', 'Violet', 3, 1976, 2, 23, -25, 0, 0, 15774),
('ST-018', 'Saltwick Locks', 'Slate', 2, 1974, 2, -39, 6, 0, 0, 17643),
('ST-019', 'Vellin Gate', 'Cobalt', 2, 2021, 3, 21, -5, 0, 0, 21019),
('ST-020', 'Juniper Row', 'Crimson', 3, 1976, 1, -20, 30, 0, 0, 9196),
('ST-021', 'Nether Hill', 'Violet', 2, 1973, 4, 16, -9, 1, 0, 22342),
('ST-022', 'Ivory Park', 'Slate', 5, 1993, 3, -31, 34, 0, 1, 10455),
('ST-023', 'Pinfold Halt', 'Cobalt', 3, 1986, 4, 23, -4, 1, 0, 10282),
('ST-024', 'Vellin Junction', 'Emerald', 4, 1976, 2, -42, -6, 0, 0, 10261),
('ST-025', 'Foxhollow Bridge', 'Crimson', 4, 2006, 2, -22, 1, 0, 0, 14252),
('ST-026', 'Ivory Central', 'Emerald', 3, 2018, 3, -2, -7, 0, 0, 1279),
('ST-027', 'Candle Hill', 'Slate', 5, 2008, 2, 22, -35, 1, 0, 10069),
('ST-028', 'Pinfold Green', 'Amber', 2, 2018, 1, 9, 7, 1, 0, 9791),
('ST-029', 'Oakem Central', 'Slate', 3, 2005, 3, -24, 28, 1, 0, 1352),
('ST-030', 'Westing Hill', 'Amber', 1, 1996, 4, 47, 14, 1, 0, 4874),
('ST-031', 'Foxhollow Junction', 'Amber', 2, 1972, 4, -9, -29, 1, 1, 8612),
('ST-032', 'Bramble Wharf', 'Crimson', 4, 1972, 4, -48, 30, 0, 0, 4155),
('ST-033', 'Ravens End', 'Slate', 3, 1999, 4, -28, 10, 1, 0, 7889),
('ST-034', 'Glass Quay', 'Crimson', 1, 1974, 2, -18, -9, 0, 0, 16912),
('ST-035', 'Quill Bridge', 'Slate', 4, 1969, 5, 31, 30, 0, 1, 5836),
('ST-036', 'Bellrow Halt', 'Cobalt', 3, 1991, 4, -18, -22, 1, 1, 3015),
('ST-037', 'Candle Fields', 'Emerald', 4, 1974, 3, 34, 18, 1, 0, 14519),
('ST-038', 'Nether End', 'Slate', 4, 1987, 2, 20, -26, 1, 0, 709),
('ST-039', 'Grangeley Fields', 'Cobalt', 4, 1984, 2, 29, -10, 1, 0, 203),
('ST-040', 'Glass Wharf', 'Crimson', 4, 1975, 2, -14, -12, 1, 0, 11699),
('ST-041', 'Umber Wharf', 'Emerald', 2, 1999, 5, 30, 19, 0, 1, 6528),
('ST-042', 'Ivory Quay', 'Emerald', 4, 2021, 2, -45, 4, 1, 0, 15303),
('ST-043', 'Kestrel Junction', 'Crimson', 3, 2000, 3, -26, 20, 0, 0, 11630),
('ST-044', 'Alder Bridge', 'Cobalt', 2, 2017, 2, -6, 17, 1, 0, 18377),
('ST-045', 'Larch Central', 'Amber', 4, 1994, 4, 46, -32, 1, 1, 14199),
('ST-046', 'Foxhollow Quay', 'Cobalt', 5, 1988, 3, -10, -18, 1, 0, 7130),
('ST-047', 'Fernway Locks', 'Violet', 2, 2023, 1, 38, -16, 1, 0, 8424),
('ST-048', 'Marrow Junction', 'Emerald', 2, 1999, 2, -12, -31, 0, 0, 13078),
('ST-049', 'Nether Fields', 'Amber', 4, 1991, 6, 8, 18, 1, 0, 2034),
('ST-050', 'Larch Park', 'Amber', 2, 2009, 2, -34, 14, 0, 0, 14096);
INSERT INTO transit_stations (station_id, name, line, zone, opened_year, platforms, grid_x, grid_y, step_free, interchange, daily_boardings) VALUES
('ST-051', 'Thistle Green', 'Crimson', 1, 1999, 8, 17, -14, 1, 1, 12912),
('ST-052', 'Bellrow Bridge', 'Violet', 1, 1982, 3, 25, -31, 1, 0, 32392),
('ST-053', 'Yarrow Wharf', 'Emerald', 1, 2009, 4, -15, -21, 1, 1, 35083),
('ST-054', 'Bellrow Vale', 'Emerald', 4, 1990, 4, -32, 28, 0, 1, 12178),
('ST-055', 'Westing Row', 'Slate', 2, 2009, 2, -24, -19, 1, 0, 7264),
('ST-056', 'Larch Quay', 'Amber', 1, 2007, 2, 4, -3, 1, 0, 57354),
('ST-057', 'Larch Wharf', 'Amber', 2, 2008, 4, 22, -5, 1, 1, 18871),
('ST-058', 'Thistle End', 'Cobalt', 3, 1981, 2, -12, 7, 1, 0, 12502),
('ST-059', 'Westing Wharf', 'Crimson', 3, 1981, 4, 41, 18, 0, 0, 12183),
('ST-060', 'Candle Park', 'Violet', 3, 1987, 2, 1, 20, 1, 0, 20372),
('ST-061', 'Bramble End', 'Cobalt', 1, 2016, 3, 28, 9, 1, 0, 48241),
('ST-062', 'Oakem Halt', 'Violet', 4, 2002, 4, 39, 20, 0, 1, 11691),
('ST-063', 'Nether Quay', 'Crimson', 3, 1977, 4, -39, 4, 1, 1, 2428),
('ST-064', 'Larch Halt', 'Cobalt', 1, 2007, 2, 22, -21, 0, 0, 9675),
('ST-065', 'Kestrel Park', 'Emerald', 4, 2013, 2, -24, 10, 1, 0, 6876),
('ST-066', 'Candle End', 'Amber', 2, 2012, 2, -30, -3, 0, 0, 6323),
('ST-067', 'Marrow Bridge', 'Amber', 2, 2008, 2, -15, 16, 1, 0, 2045),
('ST-068', 'Fernway Quay', 'Cobalt', 4, 2007, 3, -38, -10, 1, 0, 9864),
('ST-069', 'Oakem Hill', 'Cobalt', 1, 1974, 2, 37, -30, 1, 0, 42366),
('ST-070', 'Quill Hill', 'Crimson', 2, 1989, 2, 47, -13, 1, 0, 27299),
('ST-071', 'Eastmoor Gate', 'Amber', 3, 1995, 2, -29, 11, 1, 0, 1563),
('ST-072', 'Candle Gate', 'Emerald', 3, 2015, 4, -34, -12, 0, 0, 6021),
('ST-073', 'Westing Central', 'Emerald', 5, 1989, 2, 2, -1, 1, 0, 6337),
('ST-074', 'Elmgate Row', 'Slate', 3, 1973, 5, 12, 26, 1, 1, 15854),
('ST-075', 'Umber Locks', 'Amber', 3, 1999, 3, -46, 29, 1, 0, 11953),
('ST-076', 'Glass Gate', 'Emerald', 3, 1974, 3, -23, -31, 1, 0, 6991),
('ST-077', 'Ivory Cross', 'Amber', 3, 2009, 4, 36, -10, 1, 1, 16140),
('ST-078', 'Saltwick Central', 'Amber', 5, 1996, 2, 38, 19, 0, 0, 5567),
('ST-079', 'Bramble Vale', 'Violet', 2, 2021, 2, 48, 5, 1, 0, 23015),
('ST-080', 'Yarrow Halt', 'Amber', 4, 1973, 4, 9, -26, 0, 1, 12007),
('ST-081', 'Quill Park', 'Amber', 1, 1986, 4, 4, -35, 1, 1, 10391),
('ST-082', 'Alder Halt', 'Violet', 2, 1998, 2, -1, -33, 1, 0, 3250),
('ST-083', 'Pinfold Cross', 'Slate', 2, 2005, 3, 27, 14, 0, 0, 5613),
('ST-084', 'Oakem Fields', 'Slate', 5, 1977, 2, 43, -9, 1, 0, 10984),
('ST-085', 'Dunmar Quay', 'Amber', 3, 1989, 4, -36, -5, 1, 1, 4442),
('ST-086', 'Marrow Vale', 'Amber', 2, 1999, 2, -17, -1, 1, 0, 16374),
('ST-087', 'Nether Halt', 'Crimson', 2, 2024, 1, -19, 9, 1, 0, 2358),
('ST-088', 'Ravens Bridge', 'Cobalt', 3, 1977, 4, -44, 5, 1, 0, 7471),
('ST-089', 'Bramble Quay', 'Amber', 3, 2013, 2, 9, 12, 0, 0, 12055),
('ST-090', 'Grangeley Wharf', 'Cobalt', 1, 1987, 3, -13, 12, 1, 0, 4627);