source: bus-n-go-pavel-216049/bus-n-go-backend/src/main/resources/db/migration/V1.2__additional_data.sql

Last change on this file was baf4cc4, checked in by ppaunovski <paunovskipavel@…>, 3 months ago

split group project and individual project into two separate folders
  • Property mode set to 100644
File size: 11.9 KB
Line 
1set search_path = project;
2
3-- Insert stops from Skopje to Ohrid
4INSERT INTO Postojka (lat, lon, ime, opis) VALUES
5 (41.9981, 21.4254, 'Skopje', 'Capital city of North Macedonia'),
6 (41.8770, 21.0720, 'Tetovo', 'City in western North Macedonia'),
7 (41.7150, 20.9620, 'Gostivar', 'City in western North Macedonia'),
8 (41.5886, 20.6305, 'Kicevo', 'City in western North Macedonia'),
9 (41.5120, 20.2690, 'Struga', 'City in southwestern North Macedonia'),
10 (41.1136, 20.8016, 'Ohrid', 'City in southwestern North Macedonia');
11-- Insert stops for Line 2 (Skopje - Ohrid)
12INSERT INTO Postojka_Na_Linija (linija_id, postojka_id, reden_broj, pravec_id) VALUES
13 (2, 25, 1, 3), -- Skopje
14 (2, 26, 2, 3), -- Tetovo
15 (2, 27, 3, 3), -- Gostivar
16 (2, 28, 4, 3), -- Kicevo
17 (2, 29, 5, 3), -- Struga
18 (2, 30, 6, 3); -- Ohrid
19
20-- Insert stops from Ohrid to Skopje
21INSERT INTO Postojka (lat, lon, ime, opis) VALUES
22 (41.1136, 20.8016, 'Ohrid', 'City in southwestern North Macedonia'),
23 (41.5910, 20.6520, 'Debarca', 'Municipality near Ohrid'),
24 (41.6340, 20.8940, 'Makedonski Brod', 'Town in central North Macedonia'),
25 (41.6980, 21.1290, 'Samokov', 'Village in western North Macedonia'),
26 (41.7820, 21.3340, 'Tetovo', 'City in western North Macedonia'),
27 (41.9981, 21.4254, 'Skopje', 'Capital city of North Macedonia');
28-- Insert stops for Line 2 (Ohrid - Skopje)
29INSERT INTO Postojka_Na_Linija (linija_id, postojka_id, reden_broj, pravec_id) VALUES
30 (2, 31, 1, 4), -- Ohrid
31 (2, 32, 2, 4), -- Debarca
32 (2, 33, 3, 4), -- Makedonski Brod
33 (2, 34, 4, 4), -- Samokov
34 (2, 35, 5, 4), -- Tetovo
35 (2, 36, 6, 4); -- Skopje
36-- Insert stops from Skopje to Bitola
37INSERT INTO Postojka (lat, lon, ime, opis) VALUES
38 (41.9981, 21.4254, 'Skopje', 'Capital city of North Macedonia'), -- id 37
39 (41.9202, 21.5511, 'Veles', 'City in central North Macedonia'), -- id 38
40 (41.7361, 21.7744, 'Prilep', 'City in southern North Macedonia'), -- id 39
41 (41.6130, 21.5523, 'Krushevo', 'Town in southern North Macedonia'), -- id 40
42 (41.4442, 21.2761, 'Bitola', 'City in southwestern North Macedonia'); -- id 41
43-- Insert stops for Line 3 (Skopje - Bitola)
44INSERT INTO Postojka_Na_Linija (linija_id, postojka_id, reden_broj, pravec_id) VALUES
45 (3, 37, 1, 5), -- Skopje
46 (3, 38, 2, 5), -- Veles
47 (3, 39, 3, 5), -- Prilep
48 (3, 40, 4, 5), -- Krushevo
49 (3, 41, 5, 5); -- Bitola
50-- Insert stops from Bitola to Skopje
51INSERT INTO Postojka (lat, lon, ime, opis) VALUES
52 (41.4442, 21.2761, 'Bitola', 'City in southwestern North Macedonia'), -- id 42
53 (41.6130, 21.5523, 'Krushevo', 'Town in southern North Macedonia'), -- id 43
54 (41.7361, 21.7744, 'Prilep', 'City in southern North Macedonia'), -- id 44
55 (41.9202, 21.5511, 'Veles', 'City in central North Macedonia'), -- id 45
56 (41.9981, 21.4254, 'Skopje', 'Capital city of North Macedonia'); -- id 46
57-- Insert stops for Line 3 (Bitola - Skopje)
58INSERT INTO Postojka_Na_Linija (linija_id, postojka_id, reden_broj, pravec_id) VALUES
59 (3, 42, 1, 6), -- Bitola
60 (3, 43, 2, 6), -- Krushevo
61 (3, 44, 3, 6), -- Prilep
62 (3, 45, 4, 6), -- Veles
63 (3, 46, 5, 6); -- Skopje
64
65-- Insert stops from Skopje to Kumanovo
66INSERT INTO Postojka (lat, lon, ime, opis) VALUES
67 (41.9981, 21.4254, 'Skopje', 'Capital city of North Macedonia'), -- id 47
68 (41.9945, 21.5770, 'Butel', 'Municipality in Skopje'), -- id 48
69 (42.0153, 21.7000, 'Aracinovo', 'Village near Skopje'), -- id 49
70 (42.0892, 21.7184, 'Lipkovo', 'Village in northeastern North Macedonia'), -- id 50
71 (42.1322, 21.7144, 'Kumanovo', 'City in northeastern North Macedonia'); -- id 51
72
73-- Insert stops for Line 4 (Skopje - Kumanovo)
74INSERT INTO Postojka_Na_Linija (linija_id, postojka_id, reden_broj, pravec_id) VALUES
75 (4, 47, 1, 7), -- Skopje
76 (4, 48, 2, 7), -- Butel
77 (4, 49, 3, 7), -- Aracinovo
78 (4, 50, 4, 7), -- Lipkovo
79 (4, 51, 5, 7); -- Kumanovo
80-- Insert stops from Kumanovo to Skopje
81INSERT INTO Postojka (lat, lon, ime, opis) VALUES
82 (42.1322, 21.7144, 'Kumanovo', 'City in northeastern North Macedonia'), -- id 52
83 (42.0892, 21.7184, 'Lipkovo', 'Village in northeastern North Macedonia'), -- id 53
84 (42.0153, 21.7000, 'Aracinovo', 'Village near Skopje'), -- id 54
85 (41.9945, 21.5770, 'Butel', 'Municipality in Skopje'), -- id 55
86 (41.9981, 21.4254, 'Skopje', 'Capital city of North Macedonia'); -- id 56
87-- Insert stops for Line 4 (Kumanovo - Skopje)
88INSERT INTO Postojka_Na_Linija (linija_id, postojka_id, reden_broj, pravec_id) VALUES
89 (4, 52, 1, 8), -- Kumanovo
90 (4, 53, 2, 8), -- Lipkovo
91 (4, 54, 3, 8), -- Aracinovo
92 (4, 55, 4, 8), -- Butel
93 (4, 56, 5, 8); -- Skopje
94-- Insert stops from Skopje to Strumica
95INSERT INTO Postojka (lat, lon, ime, opis) VALUES
96 (41.9981, 21.4254, 'Skopje', 'Capital city of North Macedonia'), -- id 57
97 (41.8833, 21.5065, 'Katlanovo', 'Village near Skopje'), -- id 58
98 (41.7466, 21.3600, 'Veles Rest Area', 'Rest area near Veles'), -- id 59
99 (41.6165, 22.1796, 'Demir Kapija', 'Town in central North Macedonia'), -- id 60
100 (41.3472, 22.5533, 'Radovish', 'Town in southeastern North Macedonia'), -- id 61
101 (41.4378, 22.6431, 'Strumica', 'City in southeastern North Macedonia'); -- id 62
102-- Insert stops for Line 5 (Skopje - Strumica)
103INSERT INTO Postojka_Na_Linija (linija_id, postojka_id, reden_broj, pravec_id) VALUES
104 (5, 57, 1, 9), -- Skopje
105 (5, 58, 2, 9), -- Katlanovo
106 (5, 59, 3, 9), -- Veles Rest Area
107 (5, 60, 4, 9), -- Demir Kapija
108 (5, 61, 5, 9), -- Radovish
109 (5, 62, 6, 9); -- Strumica
110-- Insert stops from Strumica to Skopje
111INSERT INTO Postojka (lat, lon, ime, opis) VALUES
112 (41.4380, 22.6429, 'Strumica', 'City in southeastern North Macedonia'), -- id 63
113 (41.3480, 22.5525, 'Radovish Park', 'Park in Radovish'), -- id 64
114 (41.6170, 22.1802, 'Demir Kapija South', 'Southern part of Demir Kapija'), -- id 65
115 (41.7470, 21.3610, 'Veles South Rest Area', 'Rest area south of Veles'), -- id 66
116 (41.8840, 21.5070, 'Katlanovo East', 'Eastern part of Katlanovo'), -- id 67
117 (41.9985, 21.4260, 'Skopje Center', 'Center of Skopje'); -- id 68
118-- Insert stops for Line 5 (Strumica - Skopje)
119INSERT INTO Postojka_Na_Linija (linija_id, postojka_id, reden_broj, pravec_id) VALUES
120 (5, 63, 1, 10), -- Strumica
121 (5, 64, 2, 10), -- Radovish Park
122 (5, 65, 3, 10), -- Demir Kapija South
123 (5, 66, 4, 10), -- Veles South Rest Area
124 (5, 67, 5, 10), -- Katlanovo East
125 (5, 68, 6, 10); -- Skopje Center
126
Note: See TracBrowser for help on using the repository browser.