| 1 | set search_path = project;
|
|---|
| 2 |
|
|---|
| 3 | -- Insert stops from Skopje to Ohrid
|
|---|
| 4 | INSERT 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)
|
|---|
| 12 | INSERT 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
|
|---|
| 21 | INSERT 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)
|
|---|
| 29 | INSERT 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
|
|---|
| 37 | INSERT 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)
|
|---|
| 44 | INSERT 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
|
|---|
| 51 | INSERT 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)
|
|---|
| 58 | INSERT 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
|
|---|
| 66 | INSERT 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)
|
|---|
| 74 | INSERT 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
|
|---|
| 81 | INSERT 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)
|
|---|
| 88 | INSERT 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
|
|---|
| 95 | INSERT 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)
|
|---|
| 103 | INSERT 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
|
|---|
| 111 | INSERT 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)
|
|---|
| 119 | INSERT 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 |
|
|---|
