DatabaseCreation: dml.sql

File dml.sql, 97.6 KB (added by 231003, 6 days ago)
Line 
1------------------------------------------------------------------------------------------------------------------------
2-- INSERT INTO TABLES:
3
4CREATE TEMP TABLE temp_male_names
5(
6 id SERIAL PRIMARY KEY,
7 name TEXT NOT NULL
8);
9
10CREATE TEMP TABLE temp_female_names
11(
12 id SERIAL PRIMARY KEY,
13 name TEXT NOT NULL
14);
15
16CREATE TEMP TABLE temp_surnames
17(
18 id SERIAL PRIMARY KEY,
19 surname TEXT NOT NULL
20);
21
22CREATE TEMP TABLE temp_streets
23(
24 id SERIAL PRIMARY KEY,
25 street_name TEXT NOT NULL
26);
27
28CREATE TEMP TABLE temp_stations
29(
30 id SERIAL PRIMARY KEY,
31 station_name TEXT NOT NULL
32);
33
34INSERT INTO temp_male_names (name)
35VALUES ('Aleksandar'),
36 ('Stefan'),
37 ('Martin'),
38 ('Nikola'),
39 ('Filip'),
40 ('David'),
41 ('Marko'),
42 ('Viktor'),
43 ('Luka'),
44 ('Andrej'),
45 ('Bojan'),
46 ('Ivan'),
47 ('Jovan'),
48 ('Petar'),
49 ('Damjan'),
50 ('Kristijan'),
51 ('Boris'),
52 ('Teodor'),
53 ('Milan'),
54 ('Goran'),
55 ('Toni'),
56 ('Trajce'),
57 ('Vlatko'),
58 ('Zoran'),
59 ('Dragan'),
60 ('Igor'),
61 ('Dimitar'),
62 ('Mihail'),
63 ('Kiril'),
64 ('Gjorgji'),
65 ('Blagoj'),
66 ('Riste'),
67 ('Saso'),
68 ('Nenad'),
69 ('Ognen'),
70 ('Vasko'),
71 ('Dejan'),
72 ('Darko'),
73 ('Emil'),
74 ('Daniel'),
75 ('Mario'),
76 ('Leon'),
77 ('Matej'),
78 ('Pavel'),
79 ('Kosta'),
80 ('Todor'),
81 ('Ilija'),
82 ('Marjan'),
83 ('Slavko'),
84 ('Vladimir'),
85 ('Goce'),
86 ('Hristijan'),
87 ('Robert'),
88 ('Oliver'),
89 ('Branko'),
90 ('Simeon'),
91 ('Tihomir'),
92 ('Dario'),
93 ('Aleksej'),
94 ('Maksim'),
95 ('Arijan'),
96 ('Alen'),
97 ('Emir'),
98 ('Ferat'),
99 ('Agron'),
100 ('Besnik'),
101 ('Bujar'),
102 ('Artan'),
103 ('Driton'),
104 ('Fatmir'),
105 ('Mentor'),
106 ('Shpend'),
107 ('Valon'),
108 ('Arben'),
109 ('Jeton'),
110 ('Samir'),
111 ('Adnan'),
112 ('Nermin'),
113 ('Edis'),
114 ('Ervin'),
115 ('Ismail'),
116 ('Bekim'),
117 ('Faton'),
118 ('Ilir'),
119 ('Flamur'),
120 ('Arian'),
121 ('Visar'),
122 ('Blerim'),
123 ('Enis'),
124 ('Dino'),
125 ('Vedran'),
126 ('Damir'),
127 ('Haris'),
128 ('Kenan'),
129 ('Ardit'),
130 ('Noel'),
131 ('Jan'),
132 ('Leo'),
133 ('Maks'),
134 ('Timotej');
135
136INSERT INTO temp_female_names (name)
137VALUES ('Ana'),
138 ('Elena'),
139 ('Sara'),
140 ('Maja'),
141 ('Ivana'),
142 ('Sofija'),
143 ('Katerina'),
144 ('Monika'),
145 ('Jana'),
146 ('Emilija'),
147 ('Bojana'),
148 ('Daniela'),
149 ('Milena'),
150 ('Tatjana'),
151 ('Vesna'),
152 ('Biljana'),
153 ('Marija'),
154 ('Teodora'),
155 ('Simona'),
156 ('Lidija'),
157 ('Irena'),
158 ('Jasmina'),
159 ('Nadica'),
160 ('Olivera'),
161 ('Silvana'),
162 ('Dragica'),
163 ('Cvetanka'),
164 ('Natasha'),
165 ('Hristina'),
166 ('Gordana'),
167 ('Kristina'),
168 ('Magdalena'),
169 ('Tamara'),
170 ('Angela'),
171 ('Mila'),
172 ('Lara'),
173 ('Matea'),
174 ('Klara'),
175 ('Leona'),
176 ('Mia'),
177 ('Andrijana'),
178 ('Anastasija'),
179 ('Ema'),
180 ('Eva'),
181 ('Elizabeta'),
182 ('Viktorija'),
183 ('Aleksandra'),
184 ('Stefanija'),
185 ('Martina'),
186 ('Nikolina'),
187 ('Filipina'),
188 ('Davina'),
189 ('Petra'),
190 ('Jovana'),
191 ('Damjana'),
192 ('Kirilina'),
193 ('Ilina'),
194 ('Marina'),
195 ('Slavica'),
196 ('Violeta'),
197 ('Arta'),
198 ('Blerta'),
199 ('Drita'),
200 ('Fitnete'),
201 ('Gzime'),
202 ('Hajrie'),
203 ('Igballe'),
204 ('Mimoza'),
205 ('Shqipe'),
206 ('Valdete'),
207 ('Flutura'),
208 ('Arlinda'),
209 ('Besiana'),
210 ('Elira'),
211 ('Liridona'),
212 ('Teuta'),
213 ('Vjosa'),
214 ('Albina'),
215 ('Adelina'),
216 ('Ariana'),
217 ('Samira'),
218 ('Amina'),
219 ('Lejla'),
220 ('Nora'),
221 ('Edona'),
222 ('Erjona'),
223 ('Dafina'),
224 ('Era'),
225 ('Melisa'),
226 ('Rina'),
227 ('Dina'),
228 ('Hana'),
229 ('Irina'),
230 ('Kalina'),
231 ('Nina'),
232 ('Una'),
233 ('Zara'),
234 ('Lena'),
235 ('Tea'),
236 ('Mina');
237
238INSERT INTO temp_surnames (surname)
239VALUES ('Ilievski'),
240 ('Petrovski'),
241 ('Jovanovski'),
242 ('Stojanov'),
243 ('Trajkovski'),
244 ('Nikolov'),
245 ('Dimitrovski'),
246 ('Angelov'),
247 ('Stefanovski'),
248 ('Todorov'),
249 ('Markovski'),
250 ('Ivanov'),
251 ('Georgievski'),
252 ('Mitev'),
253 ('Spasov'),
254 ('Velkovski'),
255 ('Kostov'),
256 ('Ristovski'),
257 ('Janevski'),
258 ('Kolevski'),
259 ('Popovski'),
260 ('Atanasov'),
261 ('Bogdanovski'),
262 ('Damjanovski'),
263 ('Filipovski'),
264 ('Gavrilovski'),
265 ('Karanfilov'),
266 ('Mladenov'),
267 ('Pavlovski'),
268 ('Simeonov'),
269 ('Stankovski'),
270 ('Vasilevski'),
271 ('Zdravkovski'),
272 ('Zlatev'),
273 ('Cvetkovski'),
274 ('Kitanoski'),
275 ('Kuzmanovski'),
276 ('Nikolovski'),
277 ('Panovski'),
278 ('Sokolov'),
279 ('Temelkovski'),
280 ('Ugrinovski'),
281 ('Vitanovski'),
282 ('Zafirovski'),
283 ('Zografski'),
284 ('Arsovski'),
285 ('Bajramovski'),
286 ('Chakarovski'),
287 ('Danevski'),
288 ('Eftimov'),
289 ('Fidanovski'),
290 ('Gligorovski'),
291 ('Hristovski'),
292 ('Ilioski'),
293 ('Jankulovski'),
294 ('Kojic'),
295 ('Lazarevski'),
296 ('Manaskovski'),
297 ('Naumovski'),
298 ('Ognjanovski'),
299 ('Pandevski'),
300 ('Radevski'),
301 ('Stoilkovski'),
302 ('Tasevski'),
303 ('Urosevski'),
304 ('Veljanovski'),
305 ('Zarkov'),
306 ('Andonov'),
307 ('Borcev'),
308 ('Cvetanov'),
309 ('Dojcinovski'),
310 ('Efremov'),
311 ('Gligorov'),
312 ('Hristov'),
313 ('Ilijovski'),
314 ('Jovanov'),
315 ('Kolev'),
316 ('Lazarov'),
317 ('Manev'),
318 ('Nikolov'),
319 ('Petrov'),
320 ('Ristov'),
321 ('Stojanov'),
322 ('Todorov'),
323 ('Vasilev'),
324 ('Zdravkov'),
325 ('Aleksovski'),
326 ('Blazevski'),
327 ('Angelovski'),
328 ('Cakoski'),
329 ('Dimeski'),
330 ('Eminovski'),
331 ('Fetai'),
332 ('Gashi'),
333 ('Hoxha'),
334 ('Iseni'),
335 ('Jashari'),
336 ('Krasniqi'),
337 ('Luma'),
338 ('Morina'),
339 ('Nimani'),
340 ('Osmani'),
341 ('Pajaziti'),
342 ('Qerimi'),
343 ('Rexhepi'),
344 ('Selmani'),
345 ('Uka'),
346 ('Veliu'),
347 ('Xhaferi'),
348 ('Zeqa'),
349 ('Ademi'),
350 ('Berisha'),
351 ('Dauti'),
352 ('Elezaj'),
353 ('Fazliu'),
354 ('Ganiu'),
355 ('Hasani'),
356 ('Ibrahimi'),
357 ('Jakupi'),
358 ('Kadriu'),
359 ('Latifi'),
360 ('Mustafi'),
361 ('Neziri'),
362 ('Peci'),
363 ('Ramadani'),
364 ('Shabani'),
365 ('Tahiri'),
366 ('Ukshini'),
367 ('Veseli'),
368 ('Zeqiri'),
369 ('Arifi'),
370 ('Beqiri'),
371 ('Cami'),
372 ('Dervishi'),
373 ('Elezi'),
374 ('Ferati'),
375 ('Gashi'),
376 ('Hoti'),
377 ('Islami'),
378 ('Jusufi'),
379 ('Kastrati'),
380 ('Limani'),
381 ('Mehmeti'),
382 ('Nuhiji'),
383 ('Osmani'),
384 ('Pacolli'),
385 ('Rama'),
386 ('Sahiti'),
387 ('Thaci'),
388 ('Uka'),
389 ('Vokshi'),
390 ('Xhemaili'),
391 ('Zogaj');
392
393INSERT INTO temp_streets (street_name)
394VALUES ('bul. Partizanski Odredi'),
395 ('bul. Ilinden'),
396 ('Vodnjanska'),
397 ('Leninova'),
398 ('Orce Nikolov'),
399 ('Dame Gruev'),
400 ('bul. Goce Delchev'),
401 ('Krste Misirkov'),
402 ('Dimitar Vlahov'),
403 ('Nikola Vapcarov'),
404 ('Boris Trajkovski'),
405 ('bul. Jane Sandanski'),
406 ('Metodija Shatorov Sharlo'),
407 ('Anton Popov'),
408 ('Hristo Tatarchev'),
409 ('Vasil Glavinov'),
410 ('bul. Kiro Gligorov'),
411 ('Makedonija'),
412 ('11 Oktomvri'),
413 ('29 Noemvri'),
414 ('Prvomajska'),
415 ('Bitolska'),
416 ('Ohridska'),
417 ('Kumanovska'),
418 ('Tetovska'),
419 ('Debarska'),
420 ('Strumicka'),
421 ('Veleska'),
422 ('Prilepska'),
423 ('Gostivarska'),
424 ('Kichevska'),
425 ('Resenska'),
426 ('Radovishka'),
427 ('Shtipska'),
428 ('Kocho Racin'),
429 ('Pitu Guli'),
430 ('Mirche Acev'),
431 ('Blagoja Stefkovski'),
432 ('Aleksandar Makedonski'),
433 ('bul. Srbija'),
434 ('bul. ASNOM'),
435 ('bul. VMRO'),
436 ('bul. 8 Septemvri'),
437 ('bul. 17 Makedonska Brigada'),
438 ('bul. Metropolit Teodosij Gologanov'),
439 ('bul. Metodija Andonov Chento'),
440 ('bul. Kuzman Josifovski Pitu'),
441 ('bul. Nikola Karev'),
442 ('bul. Koco Racin'),
443 ('Pirinska'),
444 ('Ruzvletova'),
445 ('Maksim Gorki'),
446 ('Mito Hadzi Vasilev'),
447 ('Filip Vtori'),
448 ('Luj Paster');
449
450INSERT INTO temp_stations (station_name)
451VALUES ('Kisela Voda Centar 2534'),
452 ('st. ASNOM sever'),
453 ('ASNOM jug'),
454 ('bul. Vodno sever 981'),
455 ('ul. Karposh zapad 1024'),
456 ('st. Jane Sandanski zapad 1032'),
457 ('ul. Makedonska Brigada jug 3738'),
458 ('ul. Rekord most 1734'),
459 ('ul. Makedonska Brigada 1'),
460 ('st. ASNOM Centar'),
461 ('st. Goce Delchev most 2417'),
462 ('Srbija jug'),
463 ('ul. Goce Delchev 2 3293'),
464 ('Kuzman Josifovski Pitu Centar 3718'),
465 ('ul. Partizanski Odredi 3'),
466 ('st. Vodnjanska 3'),
467 ('Mito Hadzi Vasilev'),
468 ('bul. 8 Septemvri kraj'),
469 ('Makedonska Brigada 3'),
470 ('ul. Jane Sandanski sever 181'),
471 ('Partizanski Odredi Krste Misirkov'),
472 ('Ilinden istok 3726'),
473 ('Debar Maalo Vasil Glavinov'),
474 ('bul. ASNOM most 2748'),
475 ('ul. Karposh kraj 2516'),
476 ('Butel jug 2081'),
477 ('bul. Kiro Gligorov sever'),
478 ('bul. ASNOM kraj'),
479 ('ul. Taftalidze 3 1138'),
480 ('Debar Maalo sever'),
481 ('ul. Aerodrom 3 2535'),
482 ('bul. Kisela Voda istok 3649'),
483 ('Goce Delchev Nikola Karev'),
484 ('Lisiche Filip Vtori'),
485 ('ul. Butel zapad'),
486 ('Chair sever 3569'),
487 ('ul. Makedonija 1 2998'),
488 ('ul. Ilinden most 1017'),
489 ('bul. Makedonska Brigada kraj 1323'),
490 ('ul. Debar Maalo zapad 3399'),
491 ('st. Rekord 2 3181'),
492 ('ul. Debar Maalo 3'),
493 ('Chair most'),
494 ('st. Srbija 1'),
495 ('st. Aerodrom 1'),
496 ('Kiro Gligorov zapad 2549'),
497 ('ul. Aerodrom 3 267'),
498 ('bul. Vodno 2 2655'),
499 ('bul. Srbija sever'),
500 ('Vodnjanska 3'),
501 ('st. Kapishtec most 1951'),
502 ('ul. Kapishtec zapad 3103'),
503 ('ul. Karposh jug 1347'),
504 ('ul. 8 Septemvri 1 3176'),
505 ('Taftalidze Vasil Glavinov'),
506 ('ul. Ilinden sever'),
507 ('Makedonija Kocho Racin'),
508 ('st. Butel 2'),
509 ('Vodno Boris Trajkovski'),
510 ('st. Chair sever 3039'),
511 ('Karposh Vasil Glavinov'),
512 ('st. Makedonija Centar 476'),
513 ('Aerodrom Filip Vtori'),
514 ('bul. Butel jug 541'),
515 ('bul. Partizanski Odredi sever 882'),
516 ('ul. 8 Septemvri sever 1882'),
517 ('bul. Lisiche sever 493'),
518 ('st. Debar Maalo zapad 367'),
519 ('bul. Lisiche Centar'),
520 ('st. 8 Septemvri 3'),
521 ('bul. Vodno 2 3343'),
522 ('Vodnjanska Boris Trajkovski'),
523 ('ul. ASNOM Centar 3408'),
524 ('st. Debar Maalo 2'),
525 ('Kapishtec istok 28'),
526 ('Ilinden Krste Misirkov'),
527 ('Drachevo 1'),
528 ('ul. Makedonija istok'),
529 ('st. Rekord 2'),
530 ('st. Chair kraj 265'),
531 ('ul. Gjorce Petrov most'),
532 ('ul. Kuzman Josifovski Pitu 2'),
533 ('st. Karposh zapad 2088'),
534 ('bul. Karposh zapad 671'),
535 ('st. Makedonija zapad 2523'),
536 ('Lisiche jug 1764'),
537 ('Butel jug 3065'),
538 ('st. Vodno jug 272'),
539 ('st. Filip Vtori'),
540 ('bul. Jane Sandanski Centar'),
541 ('Chair Krste Misirkov'),
542 ('st. Kiro Gligorov jug'),
543 ('bul. Drachevo kraj'),
544 ('ul. Jane Sandanski istok 1901'),
545 ('Partizanski Odredi Nikola Karev'),
546 ('st. Taftalidze Centar 2222'),
547 ('ul. Kiro Gligorov 1'),
548 ('Srbija jug 3851'),
549 ('ul. Makedonija 1'),
550 ('8 Septemvri Orce Nikolov'),
551 ('st. Jane Sandanski most 2538'),
552 ('ul. Aerodrom 1'),
553 ('st. Drachevo jug'),
554 ('ul. Jane Sandanski 1 869'),
555 ('bul. 8 Septemvri jug 3684'),
556 ('Jane Sandanski Boris Trajkovski'),
557 ('bul. ASNOM Centar 324'),
558 ('bul. Gjorce Petrov sever 3067'),
559 ('bul. Makedonija Centar 2397'),
560 ('Kiro Gligorov Krste Misirkov'),
561 ('ul. Karposh jug 2812'),
562 ('bul. Kuzman Josifovski Pitu 3 1555'),
563 ('Aerodrom Boris Trajkovski'),
564 ('bul. Butel sever 2280'),
565 ('ul. Jane Sandanski istok 2052'),
566 ('ul. Drachevo Centar 1574'),
567 ('bul. 8 Septemvri kraj 2282'),
568 ('bul. Chair sever 2774'),
569 ('Drachevo 1 2587'),
570 ('Gjorce Petrov 1'),
571 ('st. ASNOM jug'),
572 ('ul. Gjorce Petrov 2'),
573 ('ul. Makedonija 2 2143'),
574 ('Makedonska Brigada Centar 1948'),
575 ('Kisela Voda Nikola Karev'),
576 ('Partizanski Odredi 1'),
577 ('st. Butel most 596'),
578 ('ul. Butel sever'),
579 ('bul. Kapishtec 2 1690'),
580 ('bul. Debar Maalo 1'),
581 ('Chair 3'),
582 ('Ilinden Nikola Karev'),
583 ('ul. Makedonija istok 2886'),
584 ('Lisiche Mito Hadzi Vasilev'),
585 ('st. Kuzman Josifovski Pitu 3 148'),
586 ('st. Taftalidze zapad 3513'),
587 ('bul. Vodno sever'),
588 ('bul. Kuzman Josifovski Pitu jug 1508'),
589 ('st. Debar Maalo 2 1533'),
590 ('Kapishtec zapad 1255'),
591 ('8 Septemvri Centar'),
592 ('st. Kapishtec most'),
593 ('bul. Lisiche 2 1042'),
594 ('st. Vodnjanska most 1728'),
595 ('ul. Kisela Voda sever'),
596 ('Aerodrom 2'),
597 ('ul. Lisiche 1 822'),
598 ('Chair Boris Trajkovski'),
599 ('ul. Kuzman Josifovski Pitu most'),
600 ('Drachevo istok 2350'),
601 ('Kapishtec Nikola Karev'),
602 ('st. ASNOM zapad'),
603 ('st. Karposh 2 1285'),
604 ('Kisela Voda 3 2170'),
605 ('bul. Karposh most 801'),
606 ('Taftalidze 3'),
607 ('Karposh Centar 1335'),
608 ('st. Partizanski Odredi 2 3314'),
609 ('st. ASNOM 3 696'),
610 ('ul. Srbija 2 513'),
611 ('Partizanski Odredi jug'),
612 ('bul. Jane Sandanski 1 363'),
613 ('Vodno zapad 2583'),
614 ('bul. ASNOM sever 859'),
615 ('ul. Rekord 2'),
616 ('bul. Kuzman Josifovski Pitu kraj 2651'),
617 ('bul. Jane Sandanski 3 1896'),
618 ('st. Gjorce Petrov 2 3107'),
619 ('Kisela Voda Centar 3019'),
620 ('Goce Delchev Orce Nikolov'),
621 ('ul. Karposh zapad 1295'),
622 ('st. Srbija 3 320'),
623 ('Karposh 2 598'),
624 ('Orce Nikolov'),
625 ('bul. Rekord sever 1041'),
626 ('Goce Delchev Dame Gruev'),
627 ('st. Chair 3'),
628 ('st. Drachevo kraj 72'),
629 ('ul. Ilinden kraj'),
630 ('Srbija Orce Nikolov'),
631 ('Lisiche Centar 2125'),
632 ('bul. Karposh jug 2348'),
633 ('Jane Sandanski Vasil Glavinov'),
634 ('ul. Rekord sever'),
635 ('ul. Chair Centar 1367'),
636 ('st. Makedonska Brigada most 2201'),
637 ('bul. Karposh jug 1523'),
638 ('ul. ASNOM 2'),
639 ('st. Kisela Voda Centar 2140'),
640 ('bul. Vodno most 3761'),
641 ('bul. Karposh most'),
642 ('Debar Maalo 1'),
643 ('ul. Butel jug 3633'),
644 ('bul. Goce Delchev kraj 2783'),
645 ('Makedonija Filip Vtori'),
646 ('ul. Rekord 1 2975'),
647 ('Chair Kocho Racin'),
648 ('ul. Vodno Centar 3531'),
649 ('Vodno 2 590'),
650 ('bul. Aerodrom most'),
651 ('bul. Rekord 3'),
652 ('Kuzman Josifovski Pitu 3 1815'),
653 ('bul. Butel kraj'),
654 ('Jane Sandanski zapad'),
655 ('Kiro Gligorov most 546'),
656 ('ul. Goce Delchev most'),
657 ('Aerodrom sever 2907'),
658 ('st. Aerodrom most 1980'),
659 ('Kiro Gligorov zapad 1407'),
660 ('Kiro Gligorov Boris Trajkovski'),
661 ('Jane Sandanski Luj Paster'),
662 ('ul. Vodnjanska 2'),
663 ('st. Kiro Gligorov jug 385'),
664 ('st. Vodno Centar 2921'),
665 ('st. Kisela Voda 3 2465'),
666 ('Ilinden kraj 3630'),
667 ('Kiro Gligorov 2 1412'),
668 ('st. Kuzman Josifovski Pitu sever 2060'),
669 ('Kiro Gligorov 1 2844'),
670 ('st. Kisela Voda kraj'),
671 ('bul. Kiro Gligorov 3'),
672 ('ul. Jane Sandanski most 3596'),
673 ('Ilinden zapad 3894'),
674 ('bul. Chair kraj 2746'),
675 ('Ilinden Orce Nikolov'),
676 ('ul. Debar Maalo zapad 543'),
677 ('bul. Partizanski Odredi 3 389'),
678 ('st. Aerodrom Centar'),
679 ('ul. Srbija most 371'),
680 ('ul. Chair 2'),
681 ('ul. Makedonska Brigada zapad 737'),
682 ('bul. Kisela Voda kraj'),
683 ('ul. Partizanski Odredi sever 1509'),
684 ('st. Kapishtec Centar'),
685 ('st. Debar Maalo kraj 319'),
686 ('bul. ASNOM Centar 378'),
687 ('ul. Karposh jug'),
688 ('bul. Rekord 1'),
689 ('st. 8 Septemvri 1 1119'),
690 ('ul. Taftalidze kraj 3212'),
691 ('ul. 8 Septemvri most 2682'),
692 ('ul. Chair sever'),
693 ('bul. Ilinden most 1857'),
694 ('bul. Taftalidze kraj 3412'),
695 ('Vodno zapad 938'),
696 ('st. Drachevo 3 1627'),
697 ('st. Debar Maalo 3'),
698 ('Debar Maalo Filip Vtori'),
699 ('bul. Jane Sandanski sever'),
700 ('st. Kiro Gligorov Centar 2565'),
701 ('Debar Maalo Centar 1262'),
702 ('ul. Vodno 3 910'),
703 ('8 Septemvri istok'),
704 ('bul. Taftalidze jug 321'),
705 ('Makedonija istok'),
706 ('Kapishtec Krste Misirkov'),
707 ('st. Srbija istok 1177'),
708 ('ul. Kapishtec istok 1833'),
709 ('bul. Vodno Centar 2273'),
710 ('ul. Kisela Voda istok'),
711 ('ul. Taftalidze kraj 2735'),
712 ('Goce Delchev Vasil Glavinov'),
713 ('bul. Goce Delchev 1'),
714 ('Chair kraj 2072'),
715 ('Srbija Centar 3213'),
716 ('Partizanski Odredi Boris Trajkovski'),
717 ('ul. Taftalidze most'),
718 ('st. Makedonija 3'),
719 ('bul. Vodnjanska zapad 781'),
720 ('ul. Taftalidze 2'),
721 ('Debar Maalo jug 526'),
722 ('Debar Maalo istok 2369'),
723 ('ul. Srbija zapad'),
724 ('ul. Kisela Voda zapad'),
725 ('bul. Jane Sandanski 2 1429'),
726 ('Goce Delchev sever 1742'),
727 ('ul. Partizanski Odredi istok 1877'),
728 ('Makedonska Brigada zapad'),
729 ('ul. Maksim Gorki'),
730 ('Drachevo 3 3698'),
731 ('bul. Debar Maalo 2 2719'),
732 ('bul. Butel 3 1832'),
733 ('bul. Gjorce Petrov sever'),
734 ('st. Debar Maalo kraj 3307'),
735 ('st. Jane Sandanski Centar 3395'),
736 ('Gjorce Petrov jug 819'),
737 ('bul. Makedonija 3'),
738 ('st. Debar Maalo zapad 1168'),
739 ('Jane Sandanski istok 249'),
740 ('st. Vodno istok 3186'),
741 ('Kuzman Josifovski Pitu Vasil Glavinov'),
742 ('st. Butel jug 1807'),
743 ('bul. Lisiche 2 1011'),
744 ('Vodnjanska Nikola Karev'),
745 ('bul. Karposh 3 2852'),
746 ('Kiro Gligorov kraj'),
747 ('Jane Sandanski Mito Hadzi Vasilev'),
748 ('Kapishtec 3'),
749 ('bul. Debar Maalo 3'),
750 ('bul. Srbija 1 2680'),
751 ('st. Makedonska Brigada sever 2224'),
752 ('Chair Nikola Karev'),
753 ('ul. Karposh most 2499'),
754 ('Vodno zapad'),
755 ('Chair Filip Vtori'),
756 ('st. Kapishtec zapad'),
757 ('Srbija most'),
758 ('st. Jane Sandanski most'),
759 ('ul. Kuzman Josifovski Pitu jug'),
760 ('bul. Kisela Voda kraj 3311'),
761 ('st. Taftalidze sever'),
762 ('bul. Lisiche 2 1902'),
763 ('ul. Kisela Voda jug'),
764 ('bul. Karposh zapad 713'),
765 ('ul. Vodno zapad 3015'),
766 ('bul. Gjorce Petrov 3 1843'),
767 ('st. Vodnjanska most 2841'),
768 ('Makedonija 2 1809'),
769 ('st. Vodno jug 1534'),
770 ('st. Karposh sever'),
771 ('Kapishtec Orce Nikolov'),
772 ('Taftalidze Luj Paster'),
773 ('Drachevo sever 2568'),
774 ('bul. Vodnjanska 3 483'),
775 ('st. Debar Maalo 2 1088'),
776 ('ul. Debar Maalo 1 1223'),
777 ('Taftalidze Orce Nikolov'),
778 ('Debar Maalo kraj 3337'),
779 ('ul. Kiro Gligorov sever 1656'),
780 ('bul. Butel Centar 2209'),
781 ('Vodnjanska Filip Vtori'),
782 ('Butel Mito Hadzi Vasilev'),
783 ('st. Kisela Voda most'),
784 ('st. Jane Sandanski 3 26'),
785 ('st. Gjorce Petrov Centar'),
786 ('st. Vodnjanska istok'),
787 ('st. Rekord most 840'),
788 ('ul. Aerodrom istok 3782'),
789 ('bul. Taftalidze 2'),
790 ('ul. ASNOM sever'),
791 ('bul. Krste Misirkov'),
792 ('bul. Karposh zapad'),
793 ('bul. Aerodrom 1'),
794 ('Makedonija jug'),
795 ('Rekord istok 3614'),
796 ('Vodnjanska Krste Misirkov'),
797 ('st. Kuzman Josifovski Pitu kraj'),
798 ('bul. 8 Septemvri kraj 1046'),
799 ('st. Kocho Racin'),
800 ('Ilinden Centar 717'),
801 ('st. Partizanski Odredi most'),
802 ('Ilinden kraj 1245'),
803 ('ul. Rekord sever 2574'),
804 ('st. Gjorce Petrov most 591'),
805 ('st. Butel jug 2510'),
806 ('bul. Partizanski Odredi zapad 2258'),
807 ('bul. Taftalidze sever'),
808 ('Butel Centar 2271'),
809 ('Butel 2 815'),
810 ('ul. Drachevo kraj 766'),
811 ('st. Boris Trajkovski'),
812 ('Kuzman Josifovski Pitu sever 157'),
813 ('Karposh sever'),
814 ('bul. Makedonska Brigada 2'),
815 ('st. Kuzman Josifovski Pitu zapad 2745'),
816 ('Makedonska Brigada Krste Misirkov'),
817 ('ul. Kapishtec most 1221'),
818 ('8 Septemvri Nikola Karev'),
819 ('Karposh Mirche Acev'),
820 ('st. Srbija Centar 3595'),
821 ('Kapishtec 2 1158'),
822 ('st. Taftalidze jug 2110'),
823 ('bul. Vodnjanska istok 3060'),
824 ('st. Karposh istok 506'),
825 ('Gjorce Petrov Luj Paster'),
826 ('st. Debar Maalo kraj 1014'),
827 ('Kuzman Josifovski Pitu Krste Misirkov'),
828 ('Makedonska Brigada zapad 3679'),
829 ('Drachevo Orce Nikolov'),
830 ('Makedonska Brigada Filip Vtori'),
831 ('bul. Kiro Gligorov jug 1859'),
832 ('ASNOM sever 3335'),
833 ('ul. 8 Septemvri zapad 3713'),
834 ('Kisela Voda Orce Nikolov'),
835 ('bul. Makedonija sever 2434'),
836 ('Nikola Karev'),
837 ('ul. Taftalidze kraj 3553'),
838 ('Makedonska Brigada most'),
839 ('ul. Butel zapad 1336'),
840 ('st. Partizanski Odredi istok'),
841 ('ul. Vodno 1 2447'),
842 ('ul. Jane Sandanski 2'),
843 ('Gjorce Petrov Krste Misirkov'),
844 ('8 Septemvri Maksim Gorki'),
845 ('st. Taftalidze jug 1504'),
846 ('bul. Drachevo kraj 1731'),
847 ('st. 8 Septemvri 2'),
848 ('bul. Vodnjanska 1 2879'),
849 ('ul. Vodnjanska 1'),
850 ('st. Kuzman Josifovski Pitu most'),
851 ('ul. Butel 1 2869'),
852 ('st. Mirche Acev'),
853 ('ul. Kapishtec zapad 2758'),
854 ('st. Partizanski Odredi 3'),
855 ('bul. Aerodrom kraj 402'),
856 ('Ilinden Mito Hadzi Vasilev'),
857 ('ul. Jane Sandanski kraj 1302'),
858 ('bul. Ilinden kraj'),
859 ('st. Kapishtec istok'),
860 ('st. Taftalidze zapad 756'),
861 ('Maksim Gorki'),
862 ('bul. Karposh zapad 2424'),
863 ('bul. Drachevo zapad'),
864 ('bul. Jane Sandanski most'),
865 ('ul. Butel 3'),
866 ('Butel Dame Gruev'),
867 ('st. Karposh Centar 1050'),
868 ('st. Lisiche sever'),
869 ('bul. Kisela Voda jug'),
870 ('st. Srbija 1 3892'),
871 ('Rekord Mirche Acev'),
872 ('ASNOM kraj 3549'),
873 ('st. Makedonska Brigada sever 210'),
874 ('Kisela Voda 2 2813'),
875 ('Vodnjanska kraj'),
876 ('Makedonska Brigada Maksim Gorki'),
877 ('st. Aerodrom most'),
878 ('Kisela Voda Centar 645'),
879 ('st. Vodnjanska sever 1348'),
880 ('Goce Delchev kraj 1461'),
881 ('st. Lisiche 3'),
882 ('st. Kuzman Josifovski Pitu istok 3472'),
883 ('ul. Karposh istok'),
884 ('Ilinden 3 156'),
885 ('bul. Lisiche istok 2291'),
886 ('ul. Kiro Gligorov sever 3344'),
887 ('ul. Gjorce Petrov zapad'),
888 ('st. Taftalidze 1'),
889 ('Srbija zapad'),
890 ('Srbija Maksim Gorki'),
891 ('bul. Ilinden jug 1113'),
892 ('bul. Karposh jug 772'),
893 ('Gjorce Petrov Centar 1655'),
894 ('ul. Kuzman Josifovski Pitu 3 1935'),
895 ('bul. 8 Septemvri most'),
896 ('ul. Butel 3 160'),
897 ('bul. Goce Delchev 1 1472'),
898 ('Ilinden 1 960'),
899 ('ASNOM most'),
900 ('Goce Delchev Maksim Gorki'),
901 ('bul. Debar Maalo istok'),
902 ('ul. Drachevo istok'),
903 ('Srbija kraj 3268'),
904 ('st. Taftalidze sever 567'),
905 ('ul. Gjorce Petrov Centar 702'),
906 ('st. Drachevo sever 1931'),
907 ('bul. ASNOM most 2307'),
908 ('Partizanski Odredi zapad 3885'),
909 ('st. Rekord jug 3803'),
910 ('Ilinden zapad'),
911 ('st. Ilinden Centar'),
912 ('Kapishtec Filip Vtori'),
913 ('st. Srbija 3 3755'),
914 ('bul. Rekord zapad 2983'),
915 ('bul. Chair jug 124'),
916 ('bul. Partizanski Odredi sever 216'),
917 ('Jane Sandanski Nikola Karev'),
918 ('ul. Goce Delchev 2 107'),
919 ('Jane Sandanski jug 2403'),
920 ('Lisiche zapad 2658'),
921 ('bul. Jane Sandanski 3 682'),
922 ('Rekord Luj Paster'),
923 ('bul. Kapishtec 1 1846'),
924 ('ul. Kiro Gligorov Centar'),
925 ('bul. Jane Sandanski istok'),
926 ('Partizanski Odredi sever 793'),
927 ('st. Kisela Voda Centar 2246'),
928 ('st. Luj Paster'),
929 ('st. Vodnjanska Centar 3733'),
930 ('Kisela Voda Mirche Acev'),
931 ('Debar Maalo istok'),
932 ('Rekord 1 1918'),
933 ('Ilinden Centar 2406'),
934 ('Makedonska Brigada Dame Gruev'),
935 ('bul. Aerodrom 3'),
936 ('Taftalidze Dame Gruev'),
937 ('Butel kraj 3497'),
938 ('Butel 3 266'),
939 ('st. Debar Maalo 1 949'),
940 ('ul. Makedonija 3 2670'),
941 ('st. Rekord zapad'),
942 ('bul. Aerodrom sever 122'),
943 ('bul. Kuzman Josifovski Pitu zapad 2650'),
944 ('st. Gjorce Petrov sever 1353'),
945 ('Aerodrom Centar 1090'),
946 ('Kuzman Josifovski Pitu Nikola Karev'),
947 ('st. Kapishtec kraj 3862'),
948 ('Lisiche istok'),
949 ('st. Makedonska Brigada 2 1499'),
950 ('Rekord Maksim Gorki'),
951 ('Drachevo Centar'),
952 ('Karposh jug 327'),
953 ('st. Taftalidze kraj 1281'),
954 ('ul. Drachevo istok 2540'),
955 ('bul. Vodno 1 3673'),
956 ('st. Srbija istok 3869'),
957 ('Debar Maalo Boris Trajkovski'),
958 ('Drachevo 2'),
959 ('Ilinden 2'),
960 ('ul. Lisiche sever'),
961 ('ul. Drachevo 1 754'),
962 ('bul. Vodno 1 3610'),
963 ('Aerodrom 1 3218'),
964 ('Makedonija Dame Gruev'),
965 ('Lisiche most 2522'),
966 ('st. Vodnjanska sever 2472'),
967 ('bul. Vodno 3 1744'),
968 ('ul. Taftalidze sever 2563'),
969 ('bul. Rekord zapad 3026'),
970 ('st. Makedonska Brigada zapad 2675'),
971 ('Karposh 2'),
972 ('bul. Boris Trajkovski'),
973 ('ul. Goce Delchev 2'),
974 ('st. ASNOM istok 1904'),
975 ('st. Debar Maalo zapad 253'),
976 ('Partizanski Odredi Luj Paster'),
977 ('Jane Sandanski zapad 1425'),
978 ('Srbija Vasil Glavinov'),
979 ('Makedonija Mito Hadzi Vasilev'),
980 ('Aerodrom Vasil Glavinov'),
981 ('Kuzman Josifovski Pitu Maksim Gorki'),
982 ('ul. Rekord jug'),
983 ('st. Goce Delchev kraj'),
984 ('8 Septemvri 3 1325'),
985 ('ul. Boris Trajkovski'),
986 ('st. Aerodrom sever 1629'),
987 ('ul. Karposh istok 1701'),
988 ('st. Srbija 3 3518'),
989 ('Drachevo Dame Gruev'),
990 ('Partizanski Odredi 3 795'),
991 ('Debar Maalo 3 2705'),
992 ('Taftalidze Mito Hadzi Vasilev'),
993 ('Drachevo kraj 1952'),
994 ('Partizanski Odredi Filip Vtori'),
995 ('st. Chair sever'),
996 ('ul. Lisiche zapad'),
997 ('Debar Maalo most'),
998 ('ul. Chair kraj'),
999 ('bul. Aerodrom istok'),
1000 ('st. Gjorce Petrov istok 1447'),
1001 ('bul. ASNOM 2 1104'),
1002 ('Lisiche Luj Paster'),
1003 ('Vodno 1'),
1004 ('Ilinden Mirche Acev'),
1005 ('ul. Goce Delchev jug'),
1006 ('st. Chair jug'),
1007 ('bul. Vodno 1 1476'),
1008 ('st. Butel sever 3564'),
1009 ('ul. Chair 1'),
1010 ('bul. Makedonija kraj 3394'),
1011 ('ASNOM sever 837'),
1012 ('bul. Vodnjanska 2 725'),
1013 ('bul. Ilinden jug'),
1014 ('Kisela Voda istok'),
1015 ('st. Aerodrom zapad'),
1016 ('Gjorce Petrov jug 677'),
1017 ('ul. Luj Paster'),
1018 ('bul. Goce Delchev 3'),
1019 ('bul. Aerodrom istok 2054'),
1020 ('ul. Aerodrom sever'),
1021 ('Ilinden 3'),
1022 ('Drachevo Nikola Karev'),
1023 ('8 Septemvri Luj Paster'),
1024 ('st. Vodno kraj 628'),
1025 ('st. Kuzman Josifovski Pitu zapad'),
1026 ('8 Septemvri kraj'),
1027 ('st. Chair jug 1381'),
1028 ('st. Karposh sever 3345'),
1029 ('ul. Butel kraj 2739'),
1030 ('bul. Partizanski Odredi 1 743'),
1031 ('bul. Chair kraj'),
1032 ('ul. Vodnjanska Centar 3378'),
1033 ('Karposh 1'),
1034 ('Lisiche istok 1112'),
1035 ('st. Butel Centar 1751'),
1036 ('Kapishtec Maksim Gorki'),
1037 ('bul. Vodnjanska Centar'),
1038 ('Chair Centar'),
1039 ('st. Kuzman Josifovski Pitu istok'),
1040 ('bul. Srbija 3 1480'),
1041 ('Kapishtec zapad'),
1042 ('Karposh Filip Vtori'),
1043 ('bul. Lisiche Centar 2441'),
1044 ('Kisela Voda Kocho Racin'),
1045 ('bul. Lisiche Centar 395'),
1046 ('Kuzman Josifovski Pitu 1 2080'),
1047 ('Chair Vasil Glavinov'),
1048 ('st. Partizanski Odredi 3 3887'),
1049 ('Vodnjanska sever'),
1050 ('Srbija Mito Hadzi Vasilev'),
1051 ('8 Septemvri jug'),
1052 ('ul. 8 Septemvri 1 3868'),
1053 ('bul. Vasil Glavinov'),
1054 ('st. Karposh most'),
1055 ('Vodno 3 3575'),
1056 ('Karposh Nikola Karev'),
1057 ('ul. Debar Maalo 1 1350'),
1058 ('Ilinden Filip Vtori'),
1059 ('Karposh Kocho Racin'),
1060 ('bul. Butel 3 2483'),
1061 ('Taftalidze most 3517'),
1062 ('bul. Aerodrom zapad'),
1063 ('Kisela Voda Luj Paster'),
1064 ('bul. Nikola Karev'),
1065 ('ul. Lisiche 2'),
1066 ('8 Septemvri 3 2469'),
1067 ('bul. Kuzman Josifovski Pitu jug'),
1068 ('st. Debar Maalo zapad 1366'),
1069 ('Rekord most'),
1070 ('Kisela Voda Vasil Glavinov'),
1071 ('Vodnjanska Mito Hadzi Vasilev'),
1072 ('st. Taftalidze 3 1536'),
1073 ('bul. 8 Septemvri sever 2902'),
1074 ('bul. Partizanski Odredi 3 2229'),
1075 ('Kuzman Josifovski Pitu Dame Gruev'),
1076 ('bul. Karposh 3 1236'),
1077 ('Lisiche Orce Nikolov'),
1078 ('ul. Lisiche 3 844'),
1079 ('Kuzman Josifovski Pitu zapad 2422'),
1080 ('ASNOM Centar'),
1081 ('ul. Vodnjanska 3'),
1082 ('st. Vodnjanska jug'),
1083 ('ul. Gjorce Petrov kraj 2849'),
1084 ('bul. Maksim Gorki'),
1085 ('ul. Lisiche istok 1002'),
1086 ('ul. 8 Septemvri kraj 3488'),
1087 ('st. Butel 2 2287'),
1088 ('ul. Makedonija kraj'),
1089 ('Lisiche istok 1657'),
1090 ('st. Kuzman Josifovski Pitu most 1707'),
1091 ('ul. Vodnjanska most 2944'),
1092 ('ul. Karposh sever 449'),
1093 ('Kuzman Josifovski Pitu kraj'),
1094 ('bul. Vodno 1 3637'),
1095 ('ul. Vodno most 2511'),
1096 ('Taftalidze kraj 2254'),
1097 ('bul. Srbija 1'),
1098 ('Kapishtec Boris Trajkovski'),
1099 ('8 Septemvri Mirche Acev'),
1100 ('bul. Lisiche most'),
1101 ('Goce Delchev 3 2723'),
1102 ('st. Goce Delchev zapad 3267'),
1103 ('st. Drachevo Centar'),
1104 ('Karposh jug 2444'),
1105 ('st. Vodnjanska most'),
1106 ('bul. Rekord 1 357'),
1107 ('Karposh zapad'),
1108 ('bul. Gjorce Petrov 1 1372'),
1109 ('st. Jane Sandanski istok'),
1110 ('ul. Taftalidze 1 1698'),
1111 ('bul. Aerodrom kraj'),
1112 ('st. Partizanski Odredi 2 3228'),
1113 ('st. Chair Centar 1811'),
1114 ('ul. Taftalidze 1 434'),
1115 ('bul. Debar Maalo most'),
1116 ('Debar Maalo sever 2260'),
1117 ('st. Jane Sandanski 1 2190'),
1118 ('ul. Debar Maalo kraj 83'),
1119 ('Gjorce Petrov jug 742'),
1120 ('ul. Taftalidze jug 574'),
1121 ('Gjorce Petrov kraj 2996'),
1122 ('st. 8 Septemvri kraj'),
1123 ('Goce Delchev most 732'),
1124 ('ul. Partizanski Odredi Centar 1490'),
1125 ('Goce Delchev Krste Misirkov'),
1126 ('bul. Rekord jug'),
1127 ('bul. Rekord most 3502'),
1128 ('ul. Goce Delchev 1 2133'),
1129 ('Gjorce Petrov most 689'),
1130 ('st. Kuzman Josifovski Pitu 1 84'),
1131 ('Chair jug'),
1132 ('Kapishtec most'),
1133 ('st. Gjorce Petrov jug 3600'),
1134 ('st. Drachevo 1 929'),
1135 ('ul. Drachevo zapad'),
1136 ('bul. Partizanski Odredi istok'),
1137 ('bul. Srbija Centar 1894'),
1138 ('ul. Aerodrom zapad'),
1139 ('bul. Srbija jug 2364'),
1140 ('ul. Debar Maalo kraj 2960'),
1141 ('ul. Makedonija most 3247'),
1142 ('ul. Nikola Karev'),
1143 ('Taftalidze Kocho Racin'),
1144 ('bul. 8 Septemvri jug 2509'),
1145 ('ul. Gjorce Petrov jug'),
1146 ('Karposh 3 31'),
1147 ('st. Debar Maalo 3 446'),
1148 ('ul. Aerodrom istok'),
1149 ('ul. Debar Maalo 3 3506'),
1150 ('Makedonska Brigada jug'),
1151 ('st. Kuzman Josifovski Pitu Centar'),
1152 ('st. Gjorce Petrov istok 1991'),
1153 ('Drachevo Vasil Glavinov'),
1154 ('Ilinden jug 2878'),
1155 ('Partizanski Odredi Mirche Acev'),
1156 ('ul. Makedonija 1 3004'),
1157 ('ul. Chair istok 134'),
1158 ('Kuzman Josifovski Pitu Filip Vtori'),
1159 ('st. Lisiche zapad'),
1160 ('ul. Kiro Gligorov 2 1990'),
1161 ('Kisela Voda Maksim Gorki'),
1162 ('Jane Sandanski Filip Vtori'),
1163 ('ul. Debar Maalo 1'),
1164 ('ul. Makedonska Brigada sever 1860'),
1165 ('ul. Lisiche most'),
1166 ('Lisiche most'),
1167 ('ul. Kisela Voda 2 1326'),
1168 ('Karposh jug 3561'),
1169 ('Ilinden kraj 3712'),
1170 ('Butel kraj 556'),
1171 ('st. Jane Sandanski 3'),
1172 ('ul. Kiro Gligorov sever 558'),
1173 ('Drachevo zapad'),
1174 ('Rekord zapad 397'),
1175 ('Aerodrom Mito Hadzi Vasilev'),
1176 ('Kisela Voda Mito Hadzi Vasilev'),
1177 ('bul. Karposh kraj 3037'),
1178 ('Butel Orce Nikolov'),
1179 ('Taftalidze jug'),
1180 ('ul. Kiro Gligorov jug 1528'),
1181 ('bul. 8 Septemvri 2 3317'),
1182 ('Kuzman Josifovski Pitu Mito Hadzi Vasilev'),
1183 ('Ilinden kraj'),
1184 ('st. Aerodrom 2'),
1185 ('ul. Jane Sandanski kraj 1339'),
1186 ('ul. Srbija sever 3036'),
1187 ('st. Gjorce Petrov 1 1748'),
1188 ('bul. Kapishtec zapad'),
1189 ('Jane Sandanski Centar'),
1190 ('Debar Maalo 1 3184'),
1191 ('st. Lisiche sever 3884'),
1192 ('Makedonska Brigada istok'),
1193 ('bul. Goce Delchev jug 922'),
1194 ('ul. Makedonska Brigada kraj 614'),
1195 ('ul. Butel Centar'),
1196 ('Lisiche zapad 3279'),
1197 ('ul. Chair sever 583'),
1198 ('Aerodrom most 1774'),
1199 ('Jane Sandanski 2'),
1200 ('Vodno 3'),
1201 ('Vodnjanska Centar'),
1202 ('bul. Jane Sandanski Centar 2346'),
1203 ('bul. Taftalidze Centar 2597'),
1204 ('st. 8 Septemvri sever 248'),
1205 ('8 Septemvri Krste Misirkov'),
1206 ('bul. Kisela Voda 3'),
1207 ('Taftalidze Maksim Gorki'),
1208 ('bul. Vodno 3'),
1209 ('bul. Goce Delchev 3 52'),
1210 ('bul. Goce Delchev Centar 662'),
1211 ('Srbija 1 3807'),
1212 ('ul. Aerodrom jug 3774'),
1213 ('ul. Makedonija zapad'),
1214 ('st. Makedonska Brigada most'),
1215 ('bul. Srbija istok'),
1216 ('st. Karposh 2 1406'),
1217 ('Lisiche Krste Misirkov'),
1218 ('8 Septemvri most 2834'),
1219 ('Kuzman Josifovski Pitu Kocho Racin'),
1220 ('st. Jane Sandanski zapad 400'),
1221 ('Kisela Voda kraj 2366'),
1222 ('bul. Kapishtec 3 3707'),
1223 ('bul. Kapishtec kraj 1995'),
1224 ('st. Jane Sandanski zapad'),
1225 ('Kuzman Josifovski Pitu zapad 524'),
1226 ('Goce Delchev sever'),
1227 ('st. Karposh istok 1311'),
1228 ('ul. Vodno istok'),
1229 ('ul. Kuzman Josifovski Pitu zapad 3748'),
1230 ('ul. Kisela Voda 2 1915'),
1231 ('Kiro Gligorov Nikola Karev'),
1232 ('Aerodrom istok 2236'),
1233 ('bul. Makedonska Brigada jug 3838'),
1234 ('Lisiche Vasil Glavinov'),
1235 ('Lisiche Mirche Acev'),
1236 ('Karposh Dame Gruev'),
1237 ('Partizanski Odredi istok 3717'),
1238 ('bul. Ilinden Centar 3326'),
1239 ('st. Dame Gruev'),
1240 ('bul. Vodno istok 275'),
1241 ('ul. Drachevo most'),
1242 ('st. Chair kraj 269'),
1243 ('ul. Goce Delchev 3'),
1244 ('ul. Rekord 3 1672'),
1245 ('ul. Goce Delchev most 1914'),
1246 ('bul. Karposh sever'),
1247 ('Vodnjanska Centar 231'),
1248 ('ul. Partizanski Odredi 3 2949'),
1249 ('st. Drachevo 2 2197'),
1250 ('st. Lisiche jug'),
1251 ('Vodno Mito Hadzi Vasilev'),
1252 ('ul. Karposh 1'),
1253 ('bul. 8 Septemvri istok 2906'),
1254 ('Kuzman Josifovski Pitu jug 1056'),
1255 ('st. Maksim Gorki'),
1256 ('ul. Debar Maalo istok 1802'),
1257 ('Jane Sandanski Krste Misirkov'),
1258 ('ul. Partizanski Odredi istok'),
1259 ('bul. Debar Maalo jug'),
1260 ('st. Partizanski Odredi 1 2843'),
1261 ('ul. Kapishtec 2 1074'),
1262 ('ul. ASNOM 1 482'),
1263 ('bul. Kapishtec most'),
1264 ('Srbija sever'),
1265 ('Debar Maalo Maksim Gorki'),
1266 ('ul. Goce Delchev istok 2485'),
1267 ('st. Vodno istok 2969'),
1268 ('ul. Kapishtec istok 1691'),
1269 ('st. Vodno sever 2503'),
1270 ('Kiro Gligorov most 2107'),
1271 ('ul. Drachevo 1 2714'),
1272 ('ul. Makedonija zapad 1199'),
1273 ('ul. Jane Sandanski 2 2933'),
1274 ('st. Taftalidze most'),
1275 ('Taftalidze Boris Trajkovski'),
1276 ('ul. Butel Centar 1194'),
1277 ('Goce Delchev 1 1919'),
1278 ('ul. Vodnjanska Centar'),
1279 ('st. Lisiche kraj'),
1280 ('ul. Vodno sever'),
1281 ('st. Kuzman Josifovski Pitu kraj 3063'),
1282 ('Debar Maalo istok 814'),
1283 ('Vodno jug 3890'),
1284 ('ul. Kiro Gligorov most'),
1285 ('ul. Gjorce Petrov 2 3764'),
1286 ('8 Septemvri most 700'),
1287 ('bul. Karposh Centar'),
1288 ('Aerodrom Luj Paster'),
1289 ('Kapishtec kraj'),
1290 ('bul. Kiro Gligorov jug 1361'),
1291 ('st. Drachevo 1'),
1292 ('st. Jane Sandanski jug'),
1293 ('bul. Debar Maalo zapad'),
1294 ('bul. Butel 3'),
1295 ('Kisela Voda kraj'),
1296 ('ul. Vodno 2'),
1297 ('st. Partizanski Odredi 1 2765'),
1298 ('Lisiche 2 3309'),
1299 ('st. Taftalidze sever 2261'),
1300 ('st. Makedonska Brigada kraj'),
1301 ('Kuzman Josifovski Pitu Centar 3772'),
1302 ('Kisela Voda most 1745'),
1303 ('ul. Mirche Acev'),
1304 ('Vodno Mirche Acev'),
1305 ('ul. Srbija istok 3371'),
1306 ('Debar Maalo Orce Nikolov'),
1307 ('bul. Rekord 2 588'),
1308 ('8 Septemvri Mito Hadzi Vasilev'),
1309 ('Gjorce Petrov jug'),
1310 ('ul. Ilinden 2'),
1311 ('st. Goce Delchev 3 1442'),
1312 ('Jane Sandanski sever 3347'),
1313 ('ul. Kisela Voda 2 1318'),
1314 ('Partizanski Odredi istok 3417'),
1315 ('ul. Partizanski Odredi jug'),
1316 ('Vodno Kocho Racin'),
1317 ('ul. Lisiche 1 328'),
1318 ('Vodno Krste Misirkov'),
1319 ('bul. Karposh 3'),
1320 ('Kuzman Josifovski Pitu sever'),
1321 ('st. Vodno most 3780'),
1322 ('ul. Karposh zapad'),
1323 ('bul. Kuzman Josifovski Pitu 2 1647'),
1324 ('ul. Makedonska Brigada jug 920'),
1325 ('Taftalidze Centar'),
1326 ('ul. Ilinden jug 76'),
1327 ('st. Makedonska Brigada zapad 3622'),
1328 ('Butel sever 3322'),
1329 ('Kiro Gligorov Dame Gruev'),
1330 ('st. Makedonska Brigada most 121'),
1331 ('Debar Maalo Luj Paster'),
1332 ('ul. Chair istok'),
1333 ('bul. Butel zapad'),
1334 ('ul. Gjorce Petrov 3 2435'),
1335 ('ul. Partizanski Odredi most 1596'),
1336 ('ul. Drachevo sever'),
1337 ('bul. Partizanski Odredi zapad 1988'),
1338 ('ul. Partizanski Odredi kraj 2184'),
1339 ('8 Septemvri Filip Vtori'),
1340 ('bul. Goce Delchev zapad 3000'),
1341 ('ul. Vodno 2 2618'),
1342 ('Vodnjanska Orce Nikolov'),
1343 ('bul. Butel most'),
1344 ('st. Rekord jug 2210'),
1345 ('Aerodrom sever'),
1346 ('ul. ASNOM zapad 2315'),
1347 ('ASNOM zapad 2181'),
1348 ('ul. Makedonska Brigada 3'),
1349 ('Srbija kraj'),
1350 ('st. Butel 1 752'),
1351 ('Kapishtec Dame Gruev'),
1352 ('st. Partizanski Odredi kraj'),
1353 ('Partizanski Odredi Orce Nikolov'),
1354 ('bul. Chair istok 643'),
1355 ('Vodno kraj 3447'),
1356 ('ul. Lisiche kraj 1635'),
1357 ('st. Vasil Glavinov'),
1358 ('Rekord istok'),
1359 ('Aerodrom Maksim Gorki'),
1360 ('st. Ilinden 1 1937'),
1361 ('8 Septemvri Kocho Racin'),
1362 ('Kiro Gligorov Centar 3056'),
1363 ('st. Kapishtec jug 2113'),
1364 ('Drachevo Boris Trajkovski'),
1365 ('ul. Partizanski Odredi istok 3227'),
1366 ('bul. Goce Delchev istok'),
1367 ('Debar Maalo zapad'),
1368 ('Makedonska Brigada Vasil Glavinov'),
1369 ('st. Srbija sever 1779'),
1370 ('ul. Makedonija istok 150'),
1371 ('st. Aerodrom most 2194'),
1372 ('bul. Vodnjanska Centar 2728'),
1373 ('ul. Karposh 1 331'),
1374 ('bul. Makedonija istok'),
1375 ('bul. Debar Maalo Centar 1064'),
1376 ('bul. Aerodrom Centar'),
1377 ('st. Makedonija zapad 2819'),
1378 ('Butel Mirche Acev'),
1379 ('Taftalidze istok'),
1380 ('Kiro Gligorov istok'),
1381 ('8 Septemvri 2 1890'),
1382 ('st. Partizanski Odredi sever 303'),
1383 ('Goce Delchev 2'),
1384 ('Chair jug 1449'),
1385 ('bul. Ilinden 1'),
1386 ('bul. ASNOM jug 1780'),
1387 ('bul. Butel Centar 2399'),
1388 ('bul. Kiro Gligorov jug 1249'),
1389 ('st. Srbija 2 3082'),
1390 ('ul. Kiro Gligorov most 1706'),
1391 ('bul. 8 Septemvri jug 3127'),
1392 ('ul. Kapishtec jug 962'),
1393 ('bul. Makedonija Centar'),
1394 ('Partizanski Odredi Vasil Glavinov'),
1395 ('bul. Vodno Centar'),
1396 ('Kuzman Josifovski Pitu Boris Trajkovski'),
1397 ('st. Lisiche most'),
1398 ('bul. Kuzman Josifovski Pitu istok'),
1399 ('Kapishtec 1'),
1400 ('Srbija Centar'),
1401 ('Vodnjanska Maksim Gorki'),
1402 ('Vodno kraj 3612'),
1403 ('ASNOM Mito Hadzi Vasilev'),
1404 ('ul. Makedonska Brigada istok 3508'),
1405 ('ul. Rekord zapad'),
1406 ('Vodno Centar 193'),
1407 ('ul. Srbija most'),
1408 ('Butel Luj Paster'),
1409 ('Lisiche Nikola Karev'),
1410 ('st. Taftalidze zapad'),
1411 ('Partizanski Odredi Centar 707'),
1412 ('st. Srbija zapad'),
1413 ('ul. 8 Septemvri 3 2685'),
1414 ('bul. Gjorce Petrov sever 2381'),
1415 ('st. Goce Delchev Centar'),
1416 ('Kiro Gligorov 2'),
1417 ('Gjorce Petrov Centar 100'),
1418 ('ul. Srbija istok'),
1419 ('ul. Karposh 3 956'),
1420 ('bul. Karposh 2'),
1421 ('Srbija istok 2248'),
1422 ('ul. Rekord 3 154'),
1423 ('st. Rekord jug'),
1424 ('ul. Gjorce Petrov 2 58'),
1425 ('bul. Taftalidze 3 2874'),
1426 ('st. Debar Maalo zapad'),
1427 ('Kisela Voda sever'),
1428 ('st. Jane Sandanski 3 3389'),
1429 ('ul. Rekord istok 497'),
1430 ('bul. Orce Nikolov'),
1431 ('st. Makedonija 2 3058'),
1432 ('ul. Lisiche 3 2137'),
1433 ('ul. Butel 3 1996'),
1434 ('bul. Srbija Centar 3896'),
1435 ('ul. Lisiche jug 587'),
1436 ('bul. Kapishtec sever'),
1437 ('ul. Kuzman Josifovski Pitu 1'),
1438 ('Vodno Maksim Gorki'),
1439 ('st. Rekord kraj 2674'),
1440 ('Partizanski Odredi Mito Hadzi Vasilev'),
1441 ('ul. Kuzman Josifovski Pitu istok'),
1442 ('Jane Sandanski Maksim Gorki'),
1443 ('Gjorce Petrov Filip Vtori'),
1444 ('st. Partizanski Odredi zapad 2610'),
1445 ('Vodno 2 2014'),
1446 ('ul. Drachevo 3 2927'),
1447 ('bul. Goce Delchev jug'),
1448 ('st. Taftalidze sever 2192'),
1449 ('Aerodrom Mirche Acev'),
1450 ('bul. Karposh most 2700'),
1451 ('Debar Maalo Mito Hadzi Vasilev'),
1452 ('Partizanski Odredi 2'),
1453 ('bul. Makedonska Brigada Centar 2335'),
1454 ('st. Lisiche most 871'),
1455 ('Kiro Gligorov sever 1912'),
1456 ('Ilinden Maksim Gorki'),
1457 ('bul. Debar Maalo Centar'),
1458 ('Lisiche Centar'),
1459 ('st. Jane Sandanski jug 1023'),
1460 ('ul. Chair 1 2684'),
1461 ('bul. Debar Maalo sever'),
1462 ('ul. Kocho Racin'),
1463 ('st. Mito Hadzi Vasilev'),
1464 ('ul. Jane Sandanski sever'),
1465 ('st. Gjorce Petrov Centar 35'),
1466 ('bul. Srbija zapad 3577'),
1467 ('ul. ASNOM Centar 1853'),
1468 ('Karposh 2 3467'),
1469 ('Makedonska Brigada most 3236'),
1470 ('Goce Delchev 3 657'),
1471 ('Taftalidze sever'),
1472 ('Karposh Boris Trajkovski'),
1473 ('ul. Rekord Centar 2277'),
1474 ('st. Kiro Gligorov most'),
1475 ('Chair Maksim Gorki'),
1476 ('bul. Debar Maalo jug 256'),
1477 ('st. Kuzman Josifovski Pitu istok 447'),
1478 ('Goce Delchev Filip Vtori'),
1479 ('Makedonska Brigada Mito Hadzi Vasilev'),
1480 ('ul. Makedonija sever 3895'),
1481 ('ASNOM Nikola Karev'),
1482 ('bul. Jane Sandanski Centar 3287'),
1483 ('bul. Gjorce Petrov 2'),
1484 ('Kuzman Josifovski Pitu Luj Paster'),
1485 ('Vodno sever 841'),
1486 ('st. Gjorce Petrov kraj 1243'),
1487 ('Kiro Gligorov Maksim Gorki'),
1488 ('st. Makedonija jug 1344'),
1489 ('Makedonija Boris Trajkovski'),
1490 ('ul. Ilinden 2 1229'),
1491 ('Debar Maalo 2 2858'),
1492 ('Gjorce Petrov jug 771'),
1493 ('Ilinden Luj Paster'),
1494 ('ul. Lisiche Centar 3419'),
1495 ('st. Ilinden jug'),
1496 ('Kuzman Josifovski Pitu Orce Nikolov'),
1497 ('Kisela Voda Dame Gruev'),
1498 ('ul. 8 Septemvri 1 3735'),
1499 ('ASNOM kraj'),
1500 ('st. Kapishtec 1'),
1501 ('Vodno Dame Gruev'),
1502 ('ul. Vodno 1'),
1503 ('bul. Gjorce Petrov istok 1478'),
1504 ('st. Butel 1'),
1505 ('ul. Goce Delchev istok 293'),
1506 ('ul. Rekord Centar'),
1507 ('Vodno 2'),
1508 ('ul. Kisela Voda 1'),
1509 ('bul. Chair zapad 1977'),
1510 ('st. Karposh sever 3672'),
1511 ('Vodno most 3675'),
1512 ('ul. Karposh sever 2186'),
1513 ('st. Taftalidze Centar 1162'),
1514 ('bul. Gjorce Petrov 3 144'),
1515 ('ul. Drachevo sever 635'),
1516 ('st. Kuzman Josifovski Pitu 3'),
1517 ('Makedonija Centar 329'),
1518 ('ul. Makedonija most 3680'),
1519 ('st. 8 Septemvri istok 2208'),
1520 ('st. Ilinden 3 388'),
1521 ('st. Makedonska Brigada 1'),
1522 ('ul. Ilinden most 3003'),
1523 ('bul. Makedonija 3 3574'),
1524 ('Makedonija sever'),
1525 ('Lisiche kraj'),
1526 ('Goce Delchev Mito Hadzi Vasilev'),
1527 ('st. Kiro Gligorov kraj'),
1528 ('st. Gjorce Petrov most 3721'),
1529 ('Taftalidze Filip Vtori'),
1530 ('Partizanski Odredi Centar 1539'),
1531 ('Gjorce Petrov Kocho Racin'),
1532 ('bul. Taftalidze Centar'),
1533 ('ul. Vodnjanska zapad 1749'),
1534 ('ul. Kapishtec istok'),
1535 ('bul. Gjorce Petrov 3'),
1536 ('ul. Makedonska Brigada kraj'),
1537 ('st. Krste Misirkov'),
1538 ('Gjorce Petrov Centar 1398'),
1539 ('bul. Karposh jug'),
1540 ('bul. Vodno most'),
1541 ('Vodno Luj Paster'),
1542 ('st. Jane Sandanski 2 2263'),
1543 ('Partizanski Odredi Kocho Racin'),
1544 ('ul. 8 Septemvri istok 3792'),
1545 ('Lisiche 3'),
1546 ('Vodno Centar 1830'),
1547 ('Kiro Gligorov Kocho Racin'),
1548 ('Vodnjanska 2'),
1549 ('ul. Chair most 2567'),
1550 ('Aerodrom zapad'),
1551 ('ul. Chair istok 784'),
1552 ('ul. Makedonska Brigada 3 2999'),
1553 ('bul. Partizanski Odredi sever'),
1554 ('ul. Vodnjanska zapad'),
1555 ('ul. Kiro Gligorov 3 2981'),
1556 ('Drachevo Centar 200'),
1557 ('st. Kapishtec 1 2373'),
1558 ('st. Kiro Gligorov zapad'),
1559 ('bul. Vodno zapad 3591'),
1560 ('ul. Kapishtec sever 1240'),
1561 ('st. Taftalidze 1 2885'),
1562 ('Lisiche Dame Gruev'),
1563 ('bul. Vodno kraj 986'),
1564 ('ul. Taftalidze 2 1957'),
1565 ('Jane Sandanski 1 2966'),
1566 ('ul. Kuzman Josifovski Pitu most 549'),
1567 ('Vodnjanska jug'),
1568 ('ul. Goce Delchev Centar 2945'),
1569 ('ul. Taftalidze kraj 1513'),
1570 ('Makedonija 3'),
1571 ('st. Lisiche 1'),
1572 ('ul. Debar Maalo 1 473'),
1573 ('Makedonija Centar 1913'),
1574 ('bul. Kapishtec 1 3021'),
1575 ('Srbija 3'),
1576 ('ul. Vodno zapad'),
1577 ('ul. Drachevo 3 1191'),
1578 ('Karposh kraj 3205'),
1579 ('st. Karposh 2 1278'),
1580 ('st. Makedonija 1 911'),
1581 ('Vodno istok'),
1582 ('Chair 2 3495'),
1583 ('bul. Kuzman Josifovski Pitu 3'),
1584 ('Chair jug 426'),
1585 ('Kisela Voda sever 3406'),
1586 ('Drachevo Mito Hadzi Vasilev'),
1587 ('Kapishtec jug'),
1588 ('Rekord Boris Trajkovski'),
1589 ('ul. Rekord kraj'),
1590 ('ul. Vodnjanska kraj 3711'),
1591 ('ul. Kapishtec most'),
1592 ('st. ASNOM istok 2928'),
1593 ('ul. Partizanski Odredi most'),
1594 ('st. Ilinden 1 721'),
1595 ('ul. Kiro Gligorov 3'),
1596 ('Rekord zapad 886'),
1597 ('ASNOM Krste Misirkov'),
1598 ('bul. Vodnjanska 3'),
1599 ('Kapishtec Vasil Glavinov'),
1600 ('ASNOM Boris Trajkovski'),
1601 ('ul. Vodno Centar'),
1602 ('st. Kisela Voda zapad'),
1603 ('Butel 2 1678'),
1604 ('Kiro Gligorov kraj 2071'),
1605 ('st. Drachevo kraj'),
1606 ('Karposh Mito Hadzi Vasilev'),
1607 ('Vodnjanska zapad 3557'),
1608 ('Srbija 1'),
1609 ('ul. Lisiche 3'),
1610 ('bul. Makedonija zapad 1624'),
1611 ('Chair Mirche Acev'),
1612 ('st. Partizanski Odredi 1'),
1613 ('Jane Sandanski most'),
1614 ('ul. Srbija 2 1825'),
1615 ('bul. Srbija 3'),
1616 ('st. Vodno zapad 3480'),
1617 ('st. Aerodrom istok 2367'),
1618 ('st. Kuzman Josifovski Pitu Centar 2631'),
1619 ('st. Taftalidze kraj 1345'),
1620 ('ul. Jane Sandanski jug 1145'),
1621 ('st. Goce Delchev kraj 2718'),
1622 ('ul. Butel sever 1066'),
1623 ('ul. Kuzman Josifovski Pitu 3 637'),
1624 ('st. Jane Sandanski 2'),
1625 ('Gjorce Petrov most'),
1626 ('ul. Butel most 3071'),
1627 ('st. 8 Septemvri 3 3112'),
1628 ('bul. ASNOM 2'),
1629 ('Goce Delchev istok'),
1630 ('st. Aerodrom sever 1754'),
1631 ('bul. Vodnjanska sever'),
1632 ('bul. ASNOM 1 503'),
1633 ('st. Goce Delchev sever'),
1634 ('8 Septemvri 3 451'),
1635 ('bul. Jane Sandanski Centar 2456'),
1636 ('Kapishtec Luj Paster'),
1637 ('ul. Partizanski Odredi sever'),
1638 ('Makedonska Brigada Centar 3404'),
1639 ('bul. Butel 2 1838'),
1640 ('ul. Kisela Voda kraj'),
1641 ('st. Kapishtec 2'),
1642 ('Jane Sandanski istok 1176'),
1643 ('ul. Kiro Gligorov zapad 2662'),
1644 ('bul. Partizanski Odredi 3'),
1645 ('Kuzman Josifovski Pitu zapad'),
1646 ('ul. Ilinden zapad 613'),
1647 ('Jane Sandanski sever 242'),
1648 ('bul. Chair 3 2114'),
1649 ('st. Chair kraj'),
1650 ('Jane Sandanski Mirche Acev'),
1651 ('st. Lisiche zapad 61'),
1652 ('ul. Mito Hadzi Vasilev'),
1653 ('Butel kraj 2512'),
1654 ('ASNOM Mirche Acev'),
1655 ('Srbija istok 691'),
1656 ('Srbija Luj Paster'),
1657 ('ul. Srbija 1 2860'),
1658 ('Kisela Voda jug 420'),
1659 ('ul. Butel zapad 1566'),
1660 ('bul. Kapishtec 2'),
1661 ('st. Gjorce Petrov sever'),
1662 ('Aerodrom zapad 652'),
1663 ('ul. Kuzman Josifovski Pitu zapad'),
1664 ('ul. Debar Maalo most'),
1665 ('Makedonija Vasil Glavinov'),
1666 ('st. Rekord sever 2040'),
1667 ('bul. Aerodrom zapad 3397'),
1668 ('st. Rekord zapad 1763'),
1669 ('Kisela Voda most'),
1670 ('ul. Taftalidze 2 827'),
1671 ('Goce Delchev zapad 2371'),
1672 ('Makedonska Brigada kraj 2233'),
1673 ('ul. Kiro Gligorov 2'),
1674 ('st. Rekord 3 3224'),
1675 ('Makedonska Brigada Orce Nikolov'),
1676 ('ul. Makedonija 1 3811'),
1677 ('ASNOM istok'),
1678 ('ul. Srbija Centar 1019'),
1679 ('ul. Vodnjanska istok'),
1680 ('st. Jane Sandanski zapad 1564'),
1681 ('Kiro Gligorov Mito Hadzi Vasilev'),
1682 ('st. Vodnjanska sever'),
1683 ('bul. Karposh sever 1422'),
1684 ('ul. Makedonska Brigada jug'),
1685 ('Makedonska Brigada 3 2666'),
1686 ('Lisiche zapad 3080'),
1687 ('Drachevo zapad 3529'),
1688 ('ul. Lisiche jug'),
1689 ('bul. Makedonska Brigada 2 1250'),
1690 ('bul. Srbija 2 2807'),
1691 ('ul. Rekord zapad 2189'),
1692 ('ul. Partizanski Odredi kraj 3525'),
1693 ('Luj Paster'),
1694 ('Taftalidze 2'),
1695 ('Gjorce Petrov 3 199'),
1696 ('Ilinden istok'),
1697 ('ul. 8 Septemvri Centar'),
1698 ('st. ASNOM 3 2751'),
1699 ('st. Drachevo 3'),
1700 ('Goce Delchev Luj Paster'),
1701 ('Debar Maalo jug'),
1702 ('Srbija 2'),
1703 ('bul. Gjorce Petrov kraj 2792'),
1704 ('Kuzman Josifovski Pitu jug'),
1705 ('Chair Orce Nikolov'),
1706 ('Kiro Gligorov Mirche Acev'),
1707 ('Lisiche sever 190'),
1708 ('Taftalidze Centar 464'),
1709 ('bul. Makedonska Brigada 3'),
1710 ('bul. Makedonija 2'),
1711 ('ul. Rekord kraj 3468'),
1712 ('Kapishtec sever 3759'),
1713 ('st. Rekord istok 1184'),
1714 ('bul. Chair 2'),
1715 ('ul. Butel zapad 59'),
1716 ('Ilinden 3 2027'),
1717 ('ul. Gjorce Petrov 3 1263'),
1718 ('Srbija Centar 3393'),
1719 ('bul. Butel 3 3854'),
1720 ('Partizanski Odredi most'),
1721 ('Rekord 3 3697'),
1722 ('8 Septemvri Vasil Glavinov'),
1723 ('st. Partizanski Odredi zapad 1256'),
1724 ('bul. Chair Centar 3446'),
1725 ('st. Karposh sever 3599'),
1726 ('Makedonija Orce Nikolov'),
1727 ('st. Partizanski Odredi 2 7'),
1728 ('ul. Vodnjanska kraj 3273'),
1729 ('st. Gjorce Petrov istok'),
1730 ('bul. Drachevo istok'),
1731 ('bul. Jane Sandanski kraj 1356'),
1732 ('Debar Maalo Mirche Acev'),
1733 ('ul. Chair 3 2043'),
1734 ('ul. Jane Sandanski Centar 2592'),
1735 ('Ilinden most'),
1736 ('Butel Centar'),
1737 ('bul. Butel istok'),
1738 ('st. Srbija Centar 2777'),
1739 ('Kiro Gligorov Luj Paster'),
1740 ('bul. Partizanski Odredi jug 3551'),
1741 ('Jane Sandanski Kocho Racin'),
1742 ('Vodno 3 273'),
1743 ('ul. Karposh 1 1491'),
1744 ('ul. Chair jug'),
1745 ('st. Kiro Gligorov zapad 2109'),
1746 ('st. Rekord sever'),
1747 ('bul. Partizanski Odredi Centar 3801'),
1748 ('ul. Drachevo 3'),
1749 ('Makedonija istok 1999'),
1750 ('bul. 8 Septemvri istok 3521'),
1751 ('bul. Partizanski Odredi jug 708'),
1752 ('bul. Karposh 3 917'),
1753 ('st. Vodno 1'),
1754 ('Debar Maalo 2 276'),
1755 ('st. Partizanski Odredi 2'),
1756 ('st. Makedonija sever 2202'),
1757 ('ul. Makedonska Brigada jug 2990'),
1758 ('Jane Sandanski Dame Gruev'),
1759 ('Boris Trajkovski'),
1760 ('Makedonija Maksim Gorki'),
1761 ('Butel kraj 3619'),
1762 ('ul. Partizanski Odredi zapad 2162'),
1763 ('st. Gjorce Petrov 1'),
1764 ('st. Kuzman Josifovski Pitu most 177'),
1765 ('Chair 1'),
1766 ('bul. Jane Sandanski 2 3047'),
1767 ('bul. Debar Maalo kraj 3874'),
1768 ('st. Kapishtec istok 283'),
1769 ('Rekord Filip Vtori'),
1770 ('ul. Srbija kraj'),
1771 ('st. Drachevo istok 133'),
1772 ('ul. Taftalidze zapad 3075'),
1773 ('ul. Vodnjanska most 758'),
1774 ('st. Gjorce Petrov istok 1501'),
1775 ('st. Rekord Centar 1401'),
1776 ('Rekord Vasil Glavinov'),
1777 ('st. Drachevo 2 3783'),
1778 ('st. Lisiche 2'),
1779 ('st. Karposh 3'),
1780 ('ul. Gjorce Petrov 3'),
1781 ('bul. Filip Vtori'),
1782 ('st. Partizanski Odredi zapad'),
1783 ('bul. Lisiche istok 2863'),
1784 ('ul. Jane Sandanski istok 280'),
1785 ('bul. Lisiche 2 3303'),
1786 ('st. Lisiche 2 586'),
1787 ('st. Goce Delchev jug 2829'),
1788 ('ul. Gjorce Petrov sever'),
1789 ('st. Kisela Voda jug 965'),
1790 ('bul. Goce Delchev Centar'),
1791 ('ul. Drachevo Centar'),
1792 ('Gjorce Petrov sever'),
1793 ('bul. ASNOM sever 3770'),
1794 ('Vodno Orce Nikolov'),
1795 ('Makedonska Brigada 2 2166'),
1796 ('Rekord Dame Gruev'),
1797 ('Rekord Mito Hadzi Vasilev'),
1798 ('st. Srbija 2'),
1799 ('bul. Goce Delchev Centar 1319'),
1800 ('bul. Chair most'),
1801 ('Taftalidze 2 3829'),
1802 ('st. Vodno sever'),
1803 ('ul. Gjorce Petrov sever 3665'),
1804 ('Lisiche 3 3787'),
1805 ('bul. Kiro Gligorov kraj 259'),
1806 ('bul. Vodno 2 2740'),
1807 ('st. Vodno kraj'),
1808 ('st. Kisela Voda 1 1309'),
1809 ('ul. 8 Septemvri 2 291'),
1810 ('bul. 8 Septemvri sever'),
1811 ('Taftalidze most 2480'),
1812 ('Makedonska Brigada Nikola Karev'),
1813 ('st. Kiro Gligorov Centar 1340'),
1814 ('st. Jane Sandanski jug 185'),
1815 ('Ilinden Vasil Glavinov'),
1816 ('st. Partizanski Odredi 1 118'),
1817 ('st. Goce Delchev istok'),
1818 ('Vodno Filip Vtori'),
1819 ('bul. Makedonska Brigada 2 2056'),
1820 ('bul. Taftalidze 3'),
1821 ('bul. Makedonija jug 3240'),
1822 ('bul. Karposh kraj'),
1823 ('bul. Kuzman Josifovski Pitu sever 1530'),
1824 ('bul. Goce Delchev 3 660'),
1825 ('Kuzman Josifovski Pitu jug 2545'),
1826 ('Taftalidze Krste Misirkov'),
1827 ('bul. Ilinden sever'),
1828 ('st. Rekord 2 620'),
1829 ('bul. Kuzman Josifovski Pitu sever 734'),
1830 ('Makedonska Brigada 1 2560'),
1831 ('ul. Taftalidze sever 1047'),
1832 ('bul. Butel 1 3121'),
1833 ('ul. Drachevo 2 3253'),
1834 ('ASNOM 3 73'),
1835 ('bul. Drachevo sever'),
1836 ('st. Aerodrom kraj 128'),
1837 ('Karposh Maksim Gorki'),
1838 ('Gjorce Petrov Boris Trajkovski'),
1839 ('bul. Aerodrom 2'),
1840 ('Butel Kocho Racin'),
1841 ('Butel Boris Trajkovski'),
1842 ('ul. Kisela Voda sever 1697'),
1843 ('Vodnjanska Kocho Racin'),
1844 ('ul. ASNOM Centar 142'),
1845 ('Ilinden 1'),
1846 ('Goce Delchev Centar 1481'),
1847 ('ul. Makedonska Brigada 1 1550'),
1848 ('st. 8 Septemvri istok 194'),
1849 ('st. ASNOM most'),
1850 ('Karposh Luj Paster'),
1851 ('st. Kisela Voda zapad 225'),
1852 ('bul. Makedonija jug'),
1853 ('st. Rekord 1'),
1854 ('ul. Kiro Gligorov kraj 2272'),
1855 ('bul. Mirche Acev'),
1856 ('ul. Kiro Gligorov most 1755'),
1857 ('Vodnjanska Dame Gruev'),
1858 ('st. Karposh 3 1571'),
1859 ('bul. Makedonska Brigada istok'),
1860 ('Drachevo Krste Misirkov'),
1861 ('ul. Butel 1'),
1862 ('st. ASNOM Centar 1967'),
1863 ('Vodno zapad 2075'),
1864 ('st. Rekord zapad 240'),
1865 ('Kuzman Josifovski Pitu Centar 1628'),
1866 ('ul. Ilinden 3'),
1867 ('Lisiche Maksim Gorki'),
1868 ('bul. Lisiche 3 850'),
1869 ('Vodnjanska istok 2653'),
1870 ('bul. Partizanski Odredi jug'),
1871 ('ul. Karposh 1 3696'),
1872 ('st. Kuzman Josifovski Pitu kraj 1287'),
1873 ('Kisela Voda Centar'),
1874 ('ul. Jane Sandanski most 730'),
1875 ('st. Makedonska Brigada Centar 646'),
1876 ('bul. ASNOM zapad'),
1877 ('Makedonija Centar 2095'),
1878 ('bul. Drachevo Centar'),
1879 ('st. Goce Delchev 1'),
1880 ('st. 8 Septemvri sever'),
1881 ('ul. Kuzman Josifovski Pitu 3'),
1882 ('st. Drachevo istok'),
1883 ('st. Kiro Gligorov sever'),
1884 ('st. Vodno 2'),
1885 ('st. Ilinden kraj'),
1886 ('bul. Karposh Centar 3791'),
1887 ('st. Taftalidze jug'),
1888 ('st. Aerodrom istok'),
1889 ('st. Nikola Karev'),
1890 ('bul. Aerodrom zapad 34'),
1891 ('Goce Delchev zapad 791'),
1892 ('ul. 8 Septemvri zapad'),
1893 ('ASNOM 2 1622'),
1894 ('ul. Ilinden sever 958'),
1895 ('Vodnjanska istok'),
1896 ('bul. Luj Paster'),
1897 ('Lisiche Kocho Racin'),
1898 ('Drachevo Filip Vtori'),
1899 ('bul. Lisiche most 187'),
1900 ('Chair Dame Gruev'),
1901 ('ul. Kisela Voda istok 2785'),
1902 ('Kuzman Josifovski Pitu Mirche Acev'),
1903 ('st. Debar Maalo Centar 3260'),
1904 ('bul. Kuzman Josifovski Pitu zapad 2238'),
1905 ('bul. Vodno zapad'),
1906 ('ul. Debar Maalo 3 584'),
1907 ('st. Drachevo kraj 940'),
1908 ('Chair sever 2276'),
1909 ('bul. Chair 1 1819'),
1910 ('Ilinden Kocho Racin'),
1911 ('bul. 8 Septemvri 3'),
1912 ('bul. Makedonska Brigada jug 2935'),
1913 ('ul. Partizanski Odredi zapad'),
1914 ('bul. Kuzman Josifovski Pitu zapad 1669'),
1915 ('bul. Lisiche 2'),
1916 ('st. Goce Delchev zapad'),
1917 ('bul. Butel 2 2953'),
1918 ('Debar Maalo sever 411'),
1919 ('8 Septemvri sever 733'),
1920 ('Vodno istok 3476'),
1921 ('bul. Srbija istok 469'),
1922 ('Makedonija kraj'),
1923 ('Vodno Nikola Karev'),
1924 ('ul. Lisiche kraj'),
1925 ('bul. Vodnjanska 1'),
1926 ('bul. Makedonija sever 1189'),
1927 ('Mirche Acev'),
1928 ('Aerodrom Nikola Karev'),
1929 ('st. Rekord 1 2141'),
1930 ('bul. Gjorce Petrov Centar 3280'),
1931 ('Makedonska Brigada Boris Trajkovski'),
1932 ('bul. 8 Septemvri sever 1288'),
1933 ('bul. Partizanski Odredi sever 261'),
1934 ('Karposh Orce Nikolov'),
1935 ('ul. Filip Vtori'),
1936 ('ul. 8 Septemvri Centar 3607'),
1937 ('bul. Goce Delchev kraj'),
1938 ('bul. Aerodrom most 1048'),
1939 ('ASNOM Maksim Gorki'),
1940 ('st. Makedonija zapad 1054'),
1941 ('Ilinden Centar 1305'),
1942 ('ul. Vodno istok 2204'),
1943 ('st. Ilinden 3 1301'),
1944 ('ul. Ilinden most'),
1945 ('Rekord Kocho Racin'),
1946 ('ul. Srbija Centar 2978'),
1947 ('ul. Lisiche Centar 2384'),
1948 ('Srbija Boris Trajkovski'),
1949 ('st. ASNOM 2 3823'),
1950 ('st. Vodnjanska 2'),
1951 ('st. Ilinden istok 3208'),
1952 ('Kuzman Josifovski Pitu sever 779'),
1953 ('bul. ASNOM jug 277'),
1954 ('bul. Taftalidze 2 505'),
1955 ('Kapishtec Mito Hadzi Vasilev'),
1956 ('st. Partizanski Odredi 2 1488'),
1957 ('Makedonska Brigada Kocho Racin'),
1958 ('Rekord kraj'),
1959 ('ul. Lisiche Centar 2320'),
1960 ('ul. Jane Sandanski 2 1771'),
1961 ('ul. Kapishtec 3'),
1962 ('ul. Srbija sever'),
1963 ('ul. Vodnjanska kraj'),
1964 ('Makedonska Brigada Mirche Acev'),
1965 ('ul. Vodnjanska zapad 2515'),
1966 ('Partizanski Odredi Maksim Gorki'),
1967 ('st. Vodno zapad'),
1968 ('Srbija 3 2607'),
1969 ('ul. Kapishtec kraj 2931'),
1970 ('ul. ASNOM jug'),
1971 ('st. Kapishtec 2 1652'),
1972 ('Kuzman Josifovski Pitu kraj 450'),
1973 ('bul. Chair 3'),
1974 ('8 Septemvri Boris Trajkovski'),
1975 ('ul. Kapishtec Centar 2627'),
1976 ('st. Butel jug'),
1977 ('Vodno 1 786'),
1978 ('Drachevo Mirche Acev'),
1979 ('st. Vodnjanska kraj 206'),
1980 ('bul. Rekord most 2720'),
1981 ('Kisela Voda jug'),
1982 ('Kapishtec istok 3471'),
1983 ('st. Makedonija 2'),
1984 ('Butel Maksim Gorki'),
1985 ('st. Ilinden kraj 3530'),
1986 ('Srbija Nikola Karev'),
1987 ('Kiro Gligorov Orce Nikolov'),
1988 ('bul. Kuzman Josifovski Pitu most 2044'),
1989 ('Vodnjanska Luj Paster'),
1990 ('Taftalidze jug 3198'),
1991 ('Kuzman Josifovski Pitu 3'),
1992 ('st. ASNOM 1 2967'),
1993 ('Ilinden 3 257'),
1994 ('Kapishtec kraj 414'),
1995 ('Vodno 2 490'),
1996 ('ul. Srbija 2'),
1997 ('Aerodrom 1 1131'),
1998 ('bul. Goce Delchev 2'),
1999 ('ul. Butel most 1947'),
2000 ('bul. Lisiche 1'),
2001 ('bul. Butel jug 1939'),
2002 ('bul. Chair Centar'),
2003 ('bul. Rekord jug 2615'),
2004 ('bul. Vodnjanska istok 1810'),
2005 ('Jane Sandanski 3'),
2006 ('ul. Makedonska Brigada 2'),
2007 ('bul. Vodno sever 396'),
2008 ('st. Karposh zapad'),
2009 ('Vodno Centar 2446'),
2010 ('ul. Srbija Centar'),
2011 ('st. ASNOM kraj 658'),
2012 ('Srbija Mirche Acev'),
2013 ('bul. 8 Septemvri 2'),
2014 ('Chair istok 1785'),
2015 ('ul. Drachevo jug 1773'),
2016 ('bul. Makedonska Brigada kraj 38'),
2017 ('st. ASNOM 2'),
2018 ('Chair sever 1519'),
2019 ('Gjorce Petrov 1 3702'),
2020 ('bul. Chair 2 1312'),
2021 ('st. Lisiche 3 1897'),
2022 ('st. Lisiche Centar 1209'),
2023 ('ul. Rekord istok'),
2024 ('st. Gjorce Petrov Centar 561'),
2025 ('Karposh jug 491'),
2026 ('bul. Kuzman Josifovski Pitu Centar'),
2027 ('bul. Kiro Gligorov 3 2513'),
2028 ('Makedonija Mirche Acev'),
2029 ('st. 8 Septemvri Centar'),
2030 ('st. Goce Delchev kraj 1820'),
2031 ('Srbija Krste Misirkov'),
2032 ('Vodnjanska 2 1984'),
2033 ('st. Rekord sever 3086'),
2034 ('bul. Debar Maalo 1 62'),
2035 ('ul. Jane Sandanski kraj'),
2036 ('Aerodrom Orce Nikolov'),
2037 ('Vodno zapad 3002'),
2038 ('Aerodrom istok'),
2039 ('Taftalidze 2 3038'),
2040 ('bul. Ilinden 3'),
2041 ('Goce Delchev Boris Trajkovski'),
2042 ('bul. Makedonija zapad 3161'),
2043 ('ul. Debar Maalo kraj 3061'),
2044 ('Gjorce Petrov Vasil Glavinov'),
2045 ('bul. Jane Sandanski zapad 557'),
2046 ('ul. Rekord jug 2353'),
2047 ('bul. Kapishtec sever 1101'),
2048 ('Gjorce Petrov Dame Gruev'),
2049 ('bul. Drachevo most'),
2050 ('ul. Goce Delchev 1 1313'),
2051 ('ul. Debar Maalo sever'),
2052 ('Taftalidze istok 384'),
2053 ('st. Goce Delchev Centar 3366'),
2054 ('bul. Aerodrom jug'),
2055 ('Gjorce Petrov jug 2973'),
2056 ('ul. Karposh kraj'),
2057 ('st. Partizanski Odredi sever'),
2058 ('ul. Rekord istok 1142'),
2059 ('ul. Kuzman Josifovski Pitu 2 1565'),
2060 ('bul. ASNOM Centar 3464'),
2061 ('ul. Butel 3 2347'),
2062 ('Ilinden Centar 2076'),
2063 ('Lisiche jug'),
2064 ('st. Drachevo 2'),
2065 ('Rekord 1 3308'),
2066 ('st. Makedonska Brigada zapad 1869'),
2067 ('Filip Vtori'),
2068 ('bul. Vodno zapad 2096'),
2069 ('st. Ilinden sever'),
2070 ('ul. Kisela Voda Centar 1790'),
2071 ('Aerodrom Kocho Racin'),
2072 ('Kocho Racin'),
2073 ('Butel Nikola Karev'),
2074 ('st. Kuzman Josifovski Pitu jug'),
2075 ('Butel Filip Vtori'),
2076 ('bul. Butel 1'),
2077 ('st. Ilinden sever 706'),
2078 ('ul. Chair istok 617'),
2079 ('ul. ASNOM 3 2656'),
2080 ('bul. Dame Gruev'),
2081 ('ul. Lisiche 3 1604'),
2082 ('ul. Vodno 2 1106'),
2083 ('Karposh 3'),
2084 ('bul. Kiro Gligorov Centar'),
2085 ('Karposh Centar 3728'),
2086 ('Vodnjanska Mirche Acev'),
2087 ('Gjorce Petrov Mirche Acev'),
2088 ('Ilinden Centar'),
2089 ('ul. Drachevo 1'),
2090 ('bul. Gjorce Petrov kraj 13'),
2091 ('ul. Ilinden 1 1012'),
2092 ('st. Vodnjanska 1 3306'),
2093 ('Ilinden 1 3299'),
2094 ('st. Makedonija istok'),
2095 ('Aerodrom Dame Gruev'),
2096 ('st. Gjorce Petrov zapad 1003'),
2097 ('ul. Chair 3 2284'),
2098 ('Kiro Gligorov jug'),
2099 ('Lisiche Boris Trajkovski'),
2100 ('bul. 8 Septemvri most 2717'),
2101 ('Rekord Orce Nikolov'),
2102 ('st. Partizanski Odredi 3 647'),
2103 ('bul. Gjorce Petrov Centar'),
2104 ('Kisela Voda 3'),
2105 ('bul. Kiro Gligorov kraj'),
2106 ('ul. Ilinden sever 3664'),
2107 ('Goce Delchev 2 1460'),
2108 ('bul. Butel 1 1378'),
2109 ('bul. Lisiche jug 1917'),
2110 ('Vasil Glavinov'),
2111 ('bul. Vodnjanska istok'),
2112 ('Chair kraj'),
2113 ('bul. Butel sever'),
2114 ('st. Vodnjanska 3 3249'),
2115 ('ul. Dame Gruev'),
2116 ('ASNOM sever 1985'),
2117 ('bul. Ilinden 3 1594'),
2118 ('bul. Chair jug'),
2119 ('ASNOM Kocho Racin'),
2120 ('Rekord Centar'),
2121 ('bul. Kisela Voda 3 176'),
2122 ('Kapishtec 3 609'),
2123 ('ul. Karposh Centar'),
2124 ('bul. Kiro Gligorov istok 3092'),
2125 ('Rekord zapad 2970'),
2126 ('ul. Taftalidze kraj 512'),
2127 ('Kisela Voda 3 1031'),
2128 ('Srbija Filip Vtori'),
2129 ('Debar Maalo 1 3381'),
2130 ('Drachevo Kocho Racin'),
2131 ('ul. Partizanski Odredi most 1283'),
2132 ('bul. Taftalidze most 1998'),
2133 ('st. Rekord Centar 1524'),
2134 ('st. Butel sever'),
2135 ('st. Kisela Voda 2 2770'),
2136 ('ul. Kisela Voda most'),
2137 ('ul. Rekord istok 3051'),
2138 ('bul. Makedonska Brigada kraj'),
2139 ('ASNOM Orce Nikolov'),
2140 ('8 Septemvri sever 1161'),
2141 ('Chair sever'),
2142 ('ul. Lisiche 2 188'),
2143 ('st. Partizanski Odredi kraj 731'),
2144 ('bul. Gjorce Petrov most 3527'),
2145 ('bul. ASNOM Centar 3723'),
2146 ('bul. Makedonska Brigada 3 3694'),
2147 ('st. Srbija most'),
2148 ('ul. 8 Septemvri most'),
2149 ('st. Gjorce Petrov 1 453'),
2150 ('Rekord Krste Misirkov'),
2151 ('Taftalidze Nikola Karev'),
2152 ('bul. Partizanski Odredi most 2601'),
2153 ('bul. Partizanski Odredi istok 2187'),
2154 ('st. Gjorce Petrov zapad'),
2155 ('Butel 1'),
2156 ('Makedonska Brigada kraj'),
2157 ('ul. Karposh most'),
2158 ('st. Karposh Centar'),
2159 ('bul. Rekord 2'),
2160 ('st. Ilinden 1 3670'),
2161 ('Makedonija Luj Paster'),
2162 ('Kapishtec most 988'),
2163 ('st. Kisela Voda 1 2097'),
2164 ('bul. Kuzman Josifovski Pitu 3 825'),
2165 ('Kuzman Josifovski Pitu istok'),
2166 ('Chair 3 2621'),
2167 ('ul. Makedonija jug 48'),
2168 ('ul. Chair most'),
2169 ('ul. Taftalidze sever 130'),
2170 ('Gjorce Petrov Maksim Gorki'),
2171 ('st. Ilinden Centar 97'),
2172 ('bul. ASNOM kraj 2846'),
2173 ('bul. Kisela Voda zapad'),
2174 ('bul. Goce Delchev 3 3398'),
2175 ('bul. 8 Septemvri Centar'),
2176 ('Lisiche 1 360'),
2177 ('Kiro Gligorov Vasil Glavinov'),
2178 ('ul. Butel zapad 2269'),
2179 ('ul. Makedonska Brigada istok'),
2180 ('Srbija istok'),
2181 ('st. Butel istok'),
2182 ('bul. Vodno kraj'),
2183 ('st. Rekord Centar 2665'),
2184 ('st. Kuzman Josifovski Pitu kraj 2084'),
2185 ('ul. Kapishtec zapad'),
2186 ('bul. Butel Centar 3120'),
2187 ('ul. Jane Sandanski most 3134'),
2188 ('bul. Vodno jug 282'),
2189 ('ul. Orce Nikolov'),
2190 ('bul. Taftalidze kraj 1552'),
2191 ('ul. Vodnjanska zapad 673'),
2192 ('bul. Makedonska Brigada Centar'),
2193 ('Butel 2'),
2194 ('st. Ilinden 3 3682'),
2195 ('bul. Makedonska Brigada istok 3857'),
2196 ('8 Septemvri 2 1434'),
2197 ('st. Drachevo kraj 298'),
2198 ('bul. Kiro Gligorov Centar 3191'),
2199 ('st. Makedonija istok 1147'),
2200 ('Makedonija zapad'),
2201 ('Goce Delchev 3 1732'),
2202 ('bul. Vodno Centar 2464'),
2203 ('Jane Sandanski kraj'),
2204 ('ul. Kisela Voda zapad 3044'),
2205 ('bul. Jane Sandanski Centar 2026'),
2206 ('bul. Rekord 3 2098'),
2207 ('bul. Srbija 2 2893'),
2208 ('bul. Jane Sandanski jug'),
2209 ('bul. Debar Maalo zapad 1036'),
2210 ('st. Makedonska Brigada sever'),
2211 ('Taftalidze Mirche Acev'),
2212 ('Debar Maalo istok 2178'),
2213 ('Ilinden Boris Trajkovski'),
2214 ('Makedonija Nikola Karev'),
2215 ('bul. Vodnjanska kraj 2362'),
2216 ('ASNOM 3'),
2217 ('Gjorce Petrov Orce Nikolov'),
2218 ('st. Kapishtec 2 2407'),
2219 ('8 Septemvri istok 147'),
2220 ('st. Aerodrom Centar 3765'),
2221 ('st. Kapishtec kraj 508'),
2222 ('Goce Delchev Centar 1993'),
2223 ('Karposh jug'),
2224 ('ul. Ilinden sever 2504'),
2225 ('bul. 8 Septemvri 2 1532'),
2226 ('st. ASNOM 1 2175'),
2227 ('ul. ASNOM 3 2561'),
2228 ('Chair zapad 3136'),
2229 ('st. Ilinden 3 486'),
2230 ('st. 8 Septemvri 1 2482'),
2231 ('st. Jane Sandanski 1'),
2232 ('ul. Aerodrom Centar 70'),
2233 ('ul. Karposh istok 1925'),
2234 ('st. Kisela Voda istok'),
2235 ('st. Aerodrom istok 1045'),
2236 ('st. Vodno kraj 845'),
2237 ('ASNOM Dame Gruev'),
2238 ('bul. Vodno most 1682'),
2239 ('bul. Karposh sever 3173'),
2240 ('ASNOM Luj Paster'),
2241 ('ul. Vasil Glavinov'),
2242 ('ul. Ilinden istok'),
2243 ('bul. Ilinden istok'),
2244 ('st. Karposh 1 824'),
2245 ('st. Jane Sandanski istok 3661'),
2246 ('st. Taftalidze Centar'),
2247 ('ul. ASNOM most'),
2248 ('Drachevo jug 2316'),
2249 ('ul. Rekord most 1342'),
2250 ('st. Makedonska Brigada most 314'),
2251 ('ul. Taftalidze zapad'),
2252 ('Drachevo jug'),
2253 ('st. Jane Sandanski sever 1987'),
2254 ('Aerodrom Centar'),
2255 ('ul. Krste Misirkov'),
2256 ('st. Makedonija 2 8'),
2257 ('Srbija Kocho Racin'),
2258 ('Kapishtec Mirche Acev'),
2259 ('Makedonska Brigada sever'),
2260 ('Kapishtec Kocho Racin'),
2261 ('bul. Karposh 3 3094'),
2262 ('st. Lisiche istok'),
2263 ('ul. Ilinden sever 3846'),
2264 ('bul. Vodno 1'),
2265 ('Goce Delchev Mirche Acev'),
2266 ('Karposh 3 3779'),
2267 ('bul. Vodno 1 2803'),
2268 ('ul. Lisiche jug 1346'),
2269 ('Goce Delchev jug 663'),
2270 ('8 Septemvri Dame Gruev'),
2271 ('bul. 8 Septemvri 3 2554'),
2272 ('ul. Goce Delchev 3 2715'),
2273 ('bul. Ilinden 2'),
2274 ('ul. Makedonija 1 2199'),
2275 ('Drachevo Maksim Gorki'),
2276 ('Jane Sandanski jug'),
2277 ('st. Kisela Voda 1 719'),
2278 ('bul. Kuzman Josifovski Pitu kraj'),
2279 ('ul. Butel 2'),
2280 ('Chair Mito Hadzi Vasilev'),
2281 ('Karposh 2 3083'),
2282 ('bul. 8 Septemvri istok'),
2283 ('Debar Maalo 3'),
2284 ('Jane Sandanski istok 770'),
2285 ('st. Rekord 1 632'),
2286 ('ul. Chair 1 3196'),
2287 ('ul. ASNOM kraj'),
2288 ('Butel 1 2211'),
2289 ('ul. Kapishtec Centar 3646'),
2290 ('bul. Kocho Racin'),
2291 ('ul. Makedonska Brigada zapad'),
2292 ('ul. Kisela Voda 3'),
2293 ('st. Makedonija 1'),
2294 ('Kisela Voda most 3251'),
2295 ('ul. Kisela Voda 2'),
2296 ('st. Srbija 2 1343'),
2297 ('st. Vodno jug'),
2298 ('bul. Debar Maalo 2 2321'),
2299 ('ul. Partizanski Odredi kraj 2400'),
2300 ('bul. Kuzman Josifovski Pitu Centar 1073'),
2301 ('st. Debar Maalo 1'),
2302 ('st. Gjorce Petrov sever 1183'),
2303 ('ul. Makedonska Brigada jug 3582'),
2304 ('bul. Jane Sandanski 3'),
2305 ('st. Karposh kraj'),
2306 ('st. Orce Nikolov'),
2307 ('st. Rekord 1 2768'),
2308 ('bul. Gjorce Petrov istok 3368'),
2309 ('Ilinden Dame Gruev'),
2310 ('Makedonija Krste Misirkov'),
2311 ('bul. Lisiche kraj'),
2312 ('ul. Srbija 2 2559'),
2313 ('Kuzman Josifovski Pitu most'),
2314 ('Gjorce Petrov Nikola Karev'),
2315 ('ul. Kiro Gligorov kraj'),
2316 ('Makedonija most 3737'),
2317 ('Partizanski Odredi Dame Gruev'),
2318 ('ul. Butel zapad 3833'),
2319 ('ul. ASNOM most 1562'),
2320 ('ul. Aerodrom Centar'),
2321 ('Kapishtec 2 3832'),
2322 ('ul. ASNOM jug 2351'),
2323 ('st. Ilinden most 2816'),
2324 ('Aerodrom jug'),
2325 ('Chair Luj Paster'),
2326 ('Kuzman Josifovski Pitu 3 1376'),
2327 ('ul. Kuzman Josifovski Pitu 2 2989'),
2328 ('Kiro Gligorov Filip Vtori'),
2329 ('Rekord sever 1772'),
2330 ('Partizanski Odredi sever'),
2331 ('ul. Lisiche 2 65'),
2332 ('Lisiche sever'),
2333 ('bul. Kiro Gligorov jug'),
2334 ('bul. Makedonija 2 1371'),
2335 ('bul. Mito Hadzi Vasilev'),
2336 ('bul. Gjorce Petrov kraj'),
2337 ('ASNOM Filip Vtori'),
2338 ('ul. 8 Septemvri most 554'),
2339 ('Jane Sandanski 1 839'),
2340 ('Makedonija Centar 3041'),
2341 ('bul. Debar Maalo 3 335'),
2342 ('st. Kisela Voda jug'),
2343 ('Debar Maalo Kocho Racin'),
2344 ('st. Kapishtec sever'),
2345 ('bul. Partizanski Odredi 2'),
2346 ('Krste Misirkov'),
2347 ('Makedonska Brigada zapad 2156'),
2348 ('Kuzman Josifovski Pitu sever 1560'),
2349 ('Partizanski Odredi zapad 955'),
2350 ('ul. Butel most'),
2351 ('st. Srbija 1 3496'),
2352 ('Vodnjanska Vasil Glavinov'),
2353 ('Aerodrom 1 3802'),
2354 ('bul. Srbija most 1239'),
2355 ('st. ASNOM 2 1546'),
2356 ('st. Gjorce Petrov 2 881'),
2357 ('ASNOM Vasil Glavinov'),
2358 ('Vodno Vasil Glavinov'),
2359 ('st. Rekord 3'),
2360 ('ul. Makedonija sever'),
2361 ('st. Kuzman Josifovski Pitu kraj 1634'),
2362 ('st. Debar Maalo istok'),
2363 ('bul. Jane Sandanski most 3739'),
2364 ('ul. Makedonska Brigada 1 2508'),
2365 ('st. Debar Maalo most'),
2366 ('Drachevo Luj Paster'),
2367 ('Kapishtec kraj 2681'),
2368 ('bul. Makedonija 1 2155'),
2369 ('Kuzman Josifovski Pitu 2 2649'),
2370 ('Drachevo zapad 3140'),
2371 ('bul. Kuzman Josifovski Pitu zapad'),
2372 ('st. Gjorce Petrov most'),
2373 ('ul. Goce Delchev Centar'),
2374 ('st. Drachevo zapad'),
2375 ('Kuzman Josifovski Pitu kraj 3879'),
2376 ('ul. Drachevo most 2818'),
2377 ('ul. Vodno Centar 1468'),
2378 ('Butel zapad'),
2379 ('ul. Vodno zapad 762'),
2380 ('ul. Gjorce Petrov 3 49'),
2381 ('ul. Kisela Voda Centar'),
2382 ('st. Lisiche 2 1767'),
2383 ('st. Butel Centar 578'),
2384 ('Goce Delchev Kocho Racin'),
2385 ('bul. Gjorce Petrov istok 2732'),
2386 ('st. Taftalidze kraj'),
2387 ('Aerodrom Krste Misirkov'),
2388 ('ul. Debar Maalo 2'),
2389 ('Kisela Voda Krste Misirkov'),
2390 ('ul. Debar Maalo kraj 802'),
2391 ('st. Drachevo most 1433'),
2392 ('bul. Partizanski Odredi 2 2421'),
2393 ('ul. Partizanski Odredi jug 2111'),
2394 ('ul. Gjorce Petrov zapad 3101'),
2395 ('Jane Sandanski Centar 2240'),
2396 ('Butel Vasil Glavinov'),
2397 ('bul. 8 Septemvri jug'),
2398 ('ul. Srbija 3'),
2399 ('ASNOM 2'),
2400 ('ul. Rekord 3'),
2401 ('Dame Gruev'),
2402 ('Chair most 623'),
2403 ('Makedonija sever 2349'),
2404 ('st. 8 Septemvri Centar 218'),
2405 ('8 Septemvri 1'),
2406 ('st. Debar Maalo jug'),
2407 ('bul. Srbija jug'),
2408 ('ul. Kiro Gligorov sever'),
2409 ('ul. Karposh 3'),
2410 ('bul. Makedonija kraj 511'),
2411 ('ul. Taftalidze istok'),
2412 ('ul. Drachevo jug 271'),
2413 ('bul. Jane Sandanski 2'),
2414 ('bul. Partizanski Odredi jug 1080'),
2415 ('Jane Sandanski Centar 3331'),
2416 ('bul. Makedonija sever'),
2417 ('bul. Makedonija istok 799'),
2418 ('Kuzman Josifovski Pitu 1'),
2419 ('bul. Goce Delchev zapad'),
2420 ('ul. Vodnjanska zapad 2286'),
2421 ('st. Karposh 2'),
2422 ('ul. Kuzman Josifovski Pitu jug 1059'),
2423 ('st. 8 Septemvri istok 2635'),
2424 ('bul. Partizanski Odredi 1 776'),
2425 ('bul. Gjorce Petrov zapad 1632'),
2426 ('ul. Rekord 3 714'),
2427 ('st. 8 Septemvri most'),
2428 ('bul. Rekord 2 3465'),
2429 ('bul. Kuzman Josifovski Pitu 2 3281'),
2430 ('st. Butel sever 2062'),
2431 ('bul. Drachevo 2'),
2432 ('Debar Maalo Dame Gruev'),
2433 ('Jane Sandanski istok'),
2434 ('st. Makedonska Brigada Centar'),
2435 ('st. Srbija kraj'),
2436 ('Goce Delchev most'),
2437 ('Gjorce Petrov Mito Hadzi Vasilev'),
2438 ('ul. Kiro Gligorov jug'),
2439 ('Partizanski Odredi kraj 3583'),
2440 ('bul. Ilinden 1 2130'),
2441 ('bul. Kisela Voda istok'),
2442 ('Chair kraj 2063'),
2443 ('st. 8 Septemvri most 380'),
2444 ('Kisela Voda Filip Vtori'),
2445 ('ul. ASNOM 3'),
2446 ('ul. Kiro Gligorov jug 601'),
2447 ('bul. Chair 1'),
2448 ('bul. Aerodrom most 1297'),
2449 ('st. Makedonija jug 1040'),
2450 ('bul. Vodno istok');
2451
2452
2453-- ApplicationUser
2454INSERT INTO ApplicationUser
2455(name, surname, email, password, address, date_of_birth, phone_number, id_card)
2456SELECT CASE
2457 WHEN gs.i % 2 = 0 THEN mn.name
2458 ELSE fn.name
2459 END AS name,
2460
2461 sn.surname AS surname,
2462
2463 lower(CASE
2464 WHEN gs.i % 2 = 0 THEN mn.name
2465 ELSE fn.name
2466 END)
2467 || '.'
2468 || lower(sn.surname)
2469 || gs.i
2470 || '@'
2471 || (ARRAY ['gmail.com','hotmail.com','yahoo.com','outlook.com','live.com'])[(gs.i % 5) + 1]
2472 AS email,
2473
2474 md5('password_' || gs.i) AS password,
2475
2476 'ul. ' || st.street_name || ' br. ' || ((gs.i % 200) + 1) AS address,
2477
2478 (CURRENT_DATE - INTERVAL '14 years' - ((gs.i % 20000) * INTERVAL '1 day'))::date AS date_of_birth,
2479
2480 '07'
2481 || (ARRAY ['0','1','2','5','6','7','8'])[(gs.i % 7) + 1]
2482 || lpad(gs.i::text, 7, '0')
2483 AS phone_number,
2484
2485 'ID' || lpad(gs.i::text, 9, '0') AS id_card
2486
2487FROM generate_series(1, 1000000) AS gs(i)
2488
2489 JOIN temp_male_names mn
2490 ON mn.id = ((gs.i - 1) % (SELECT COUNT(*) FROM temp_male_names)) + 1
2491
2492 JOIN temp_female_names fn
2493 ON fn.id = ((gs.i - 1) % (SELECT COUNT(*) FROM temp_female_names)) + 1
2494
2495 JOIN temp_surnames sn
2496 ON sn.id = ((gs.i - 1) % (SELECT COUNT(*) FROM temp_surnames)) + 1
2497
2498 JOIN temp_streets st
2499 ON st.id = ((gs.i - 1) % (SELECT COUNT(*) FROM temp_streets)) + 1;
2500
2501
2502-- Admin
2503INSERT INTO Admin (user_id, verification_code, employment_date, status)
2504SELECT user_id,
2505 md5(user_id::text),
2506 CURRENT_DATE - ((ROW_NUMBER() OVER () % 3650) * INTERVAL '1 day'),
2507 'Active'
2508FROM ApplicationUser
2509WHERE date_of_birth <= CURRENT_DATE - INTERVAL '18 years'
2510ORDER BY RANDOM()
2511LIMIT 100;
2512
2513
2514-- Driver
2515INSERT INTO Driver (user_id, driver_license, employment_date, status, verification_code)
2516SELECT user_id,
2517 'LIC-' || lpad(row_number() OVER ()::text, 6, '0'),
2518 CURRENT_DATE - ((floor(random() * 3650)) * INTERVAL '1 day'),
2519 'Active',
2520 md5(user_id::text)
2521FROM ApplicationUser
2522WHERE date_of_birth <= CURRENT_DATE - INTERVAL '18 years'
2523 AND user_id NOT IN (SELECT user_id
2524 FROM Admin)
2525ORDER BY RANDOM()
2526LIMIT 4500;
2527
2528
2529-- Conductor
2530INSERT INTO Conductor (user_id, employment_date, status, verification_code)
2531SELECT user_id,
2532 CURRENT_DATE - ((floor(random() * 3650)) * INTERVAL '1 day'),
2533 'Active',
2534 md5(user_id::text)
2535FROM ApplicationUser
2536WHERE date_of_birth <= CURRENT_DATE - INTERVAL '18 years'
2537 AND user_id NOT IN (SELECT user_id
2538 FROM Admin
2539 UNION
2540 SELECT user_id
2541 FROM Driver)
2542ORDER BY RANDOM()
2543LIMIT 700;
2544
2545
2546-- Maintenance
2547CREATE OR REPLACE FUNCTION random_bus_chassis()
2548 RETURNS VARCHAR(255) AS
2549$$
2550BEGIN
2551 RETURN (SELECT chassis_number
2552 FROM Bus_instance
2553 ORDER BY random()
2554 LIMIT 1);
2555END;
2556$$ LANGUAGE plpgsql;
2557
2558INSERT INTO Maintenance
2559 (chassis_number, maintenance_date, description, cost, maintenance_name)
2560SELECT random_bus_chassis(),
2561 CURRENT_DATE - ((i % 365) * INTERVAL '1 day'),
2562 'Regular maintenance check #' || i,
2563 1000 + (i % 9000),
2564 (ARRAY ['Oil change', 'Brake inspection', 'Electrical system check', 'Tire replacement', 'Engine diagnostics'])[(i % 5) + 1]
2565FROM generate_series(1, 100) AS gs(i);
2566
2567
2568-- Maintainer
2569INSERT INTO Maintainer (user_id, employment_date, status, maintenance_id, verification_code)
2570SELECT u.user_id,
2571 CURRENT_DATE - ((floor(random() * 3650)) * INTERVAL '1 day'),
2572 'Active'::employee_status,
2573 m.maintenance_id,
2574 'MNT-' || lpad(row_number() OVER ()::text, 6, '0')
2575FROM ApplicationUser u
2576 JOIN (SELECT maintenance_id,
2577 ROW_NUMBER() OVER (ORDER BY RANDOM()) AS rn
2578 FROM Maintenance) m ON TRUE
2579WHERE u.date_of_birth <= CURRENT_DATE - INTERVAL '18 years'
2580 AND u.user_id NOT IN (SELECT user_id
2581 FROM Admin
2582 UNION
2583 SELECT user_id
2584 FROM Driver
2585 UNION
2586 SELECT user_id
2587 FROM Conductor)
2588ORDER BY RANDOM()
2589LIMIT 100;
2590
2591
2592-- Customer
2593INSERT INTO Customer (user_id, type)
2594SELECT user_id,
2595 CASE
2596 WHEN age BETWEEN 18 AND 26 THEN 'Student'::customer_type
2597 WHEN age >= 65 THEN 'Retiree'::customer_type
2598 ELSE 'Regular'::customer_type
2599 END
2600FROM (SELECT user_id,
2601 DATE_PART('year', AGE(CURRENT_DATE, date_of_birth)) AS age
2602 FROM ApplicationUser
2603 WHERE user_id NOT IN (SELECT user_id
2604 FROM Admin
2605 UNION
2606 SELECT user_id
2607 FROM Driver
2608 UNION
2609 SELECT user_id
2610 FROM Conductor
2611 UNION
2612 SELECT user_id
2613 FROM Maintainer)) x;
2614
2615
2616-- Bus
2617INSERT INTO Bus (brand)
2618VALUES ('Mercedes-Benz'),
2619 ('MAN'),
2620 ('Solaris'),
2621 ('Volvo'),
2622 ('Iveco'),
2623 ('Scania'),
2624 ('Temsa'),
2625 ('Isuzu'),
2626 ('VDL'),
2627 ('Setra');
2628
2629
2630-- Bus_instance
2631CREATE OR REPLACE FUNCTION random_bus_id()
2632 RETURNS INTEGER AS
2633$$
2634BEGIN
2635 RETURN (SELECT bus_id FROM Bus ORDER BY RANDOM() LIMIT 1);
2636END;
2637$$ LANGUAGE plpgsql;
2638
2639INSERT INTO Bus_instance
2640(chassis_number, bus_id, capacity, model, registration_number, date_of_manufacture, fuel_type, status)
2641SELECT 'CHS' || LPAD(gs::text, 6, '0'),
2642 random_bus_id(),
2643
2644 CASE
2645 WHEN RANDOM() < 0.6 THEN (50 + FLOOR(RANDOM() * 20))::int
2646 WHEN RANDOM() < 0.9 THEN (30 + FLOOR(RANDOM() * 20))::int
2647 ELSE (25 + FLOOR(RANDOM() * 10))::int
2648 END,
2649
2650 (ARRAY [
2651 'MAN Lion City',
2652 'Mercedes Citaro',
2653 'Solaris Urbino',
2654 'Isuzu Novociti',
2655 'Volvo 7700',
2656 'Scania Citywide'
2657 ])[FLOOR(RANDOM() * 6 + 1)],
2658
2659 'SK-'
2660 || LPAD((gs % 10000)::text, 4, '0')
2661 || '-'
2662 || CHR(65 + ((gs / 26) % 26))
2663 || CHR(65 + (gs % 26)),
2664
2665 DATE '2008-01-01' + (RANDOM() * 6000)::int,
2666
2667 CASE
2668 WHEN RANDOM() < 0.7 THEN 'Diesel'::fuel_type
2669 WHEN RANDOM() < 0.9 THEN 'Petrol'::fuel_type
2670 ELSE 'Electric'::fuel_type
2671 END,
2672
2673 CASE
2674 WHEN RANDOM() < 0.75 THEN 'Active'::bus_status
2675 WHEN RANDOM() < 0.9 THEN 'Inactive'::bus_status
2676 ELSE 'Under_maintenance'::bus_status
2677 END
2678FROM generate_series(1, 2000) gs;
2679
2680
2681-- Station
2682INSERT INTO Station (ordinal_number, station_name, address)
2683SELECT gs.i,
2684 ts.station_name,
2685 'ul. ' || st.street_name || ' br. ' || ((gs.i % 200) + 1)
2686FROM generate_series(1, 2000) AS gs(i)
2687 JOIN temp_stations ts ON ts.id = gs.i
2688 JOIN temp_streets st ON st.id = ((gs.i - 1) % (SELECT COUNT(*) FROM temp_streets)) + 1;
2689
2690
2691-- Line
2692CREATE OR REPLACE FUNCTION random_start_station()
2693 RETURNS INTEGER AS
2694$$
2695BEGIN
2696 RETURN (SELECT station_id FROM Station ORDER BY RANDOM() LIMIT 1);
2697END;
2698$$ LANGUAGE plpgsql;
2699
2700CREATE OR REPLACE FUNCTION random_end_station(start_id INTEGER)
2701 RETURNS INTEGER AS
2702$$
2703BEGIN
2704 RETURN (SELECT station_id FROM Station WHERE station_id != start_id ORDER BY RANDOM() LIMIT 1);
2705END;
2706$$ LANGUAGE plpgsql;
2707
2708INSERT INTO Line (start_station_id, end_station_id, line_number, is_active)
2709SELECT random_start_station(),
2710 random_end_station(random_start_station()),
2711 gs,
2712 RANDOM() < 0.8
2713FROM generate_series(1, 150) gs;
2714
2715
2716-- Position
2717INSERT INTO Position (station_id, line_id, num_of_station)
2718SELECT s.station_id,
2719 l.line_id,
2720 ROW_NUMBER() OVER (PARTITION BY l.line_id ORDER BY s.rn) as num_of_station
2721FROM Line l
2722 CROSS JOIN LATERAL (
2723 SELECT station_id,
2724 ROW_NUMBER() OVER (ORDER BY RANDOM()) as rn
2725 FROM Station
2726 ORDER BY RANDOM()
2727 LIMIT 15
2728 ) s;
2729
2730
2731-- Schedule
2732INSERT INTO Schedule (line_id, departure_time, arrival_time, day_of_week)
2733SELECT l.line_id,
2734 dep_time,
2735 dep_time + INTERVAL '1 hour 30 minutes',
2736 day_name
2737FROM (SELECT (SELECT line_id
2738 FROM Line
2739 ORDER BY RANDOM()
2740 LIMIT 1) as line_id,
2741 TIME '06:00:00' + (RANDOM() * INTERVAL '16 hours') as dep_time,
2742 (ARRAY ['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday'])[FLOOR(RANDOM() * 7 + 1)] as day_name
2743 FROM generate_series(1, 1500) gs) l
2744WHERE dep_time <= TIME '22:30:00';
2745
2746
2747-- Line_assignment
2748CREATE TEMP TABLE temp_drivers AS
2749SELECT user_id
2750FROM Driver;
2751
2752CREATE TEMP TABLE temp_admins AS
2753SELECT user_id
2754FROM Admin;
2755
2756CREATE TEMP TABLE temp_buses AS
2757SELECT chassis_number
2758FROM Bus_instance
2759WHERE status = 'Active';
2760
2761INSERT INTO Line_assignment (driver_id, admin_id, chassis_number, schedule_id, start_time, end_time)
2762SELECT driver_id,
2763 admin_id,
2764 chassis_number,
2765 schedule_id,
2766 start_time,
2767 end_time
2768FROM (SELECT d.user_id as driver_id,
2769 (SELECT user_id
2770 FROM temp_admins
2771 OFFSET floor(random() * (SELECT count(*) FROM temp_admins)) LIMIT 1) as admin_id,
2772 (SELECT chassis_number
2773 FROM temp_buses
2774 OFFSET floor(random() * (SELECT count(*) FROM temp_buses)) LIMIT 1) as chassis_number,
2775 s.schedule_id,
2776 s.schedule_date + s.departure_time as start_time,
2777 s.schedule_date + s.arrival_time as end_time,
2778 ROW_NUMBER()
2779 OVER (PARTITION BY d.user_id, s.schedule_date + s.departure_time, s.schedule_date + s.arrival_time ORDER BY random()) as rn
2780 FROM Driver d
2781 CROSS JOIN (SELECT schedule_id,
2782 departure_time,
2783 arrival_time,
2784 CURRENT_DATE + (FLOOR(RANDOM() * 60) - 30)::int as schedule_date
2785 FROM Schedule
2786 CROSS JOIN generate_series(1,
2787 CEIL(3000000.0 / (SELECT count(*) FROM Driver))::int)) s
2788 WHERE d.user_id IS NOT NULL) t
2789WHERE t.rn = 1
2790LIMIT 3000000;
2791
2792
2793-- Pass_type
2794INSERT INTO Pass_type (type, valid_from, valid_until, amount)
2795VALUES ('Daily_Regular', CURRENT_DATE, CURRENT_DATE + 1, 120),
2796 ('Daily_Retiree', CURRENT_DATE, CURRENT_DATE + 1, 120),
2797
2798 ('Weekly_Regular', CURRENT_DATE, CURRENT_DATE + 7, 500),
2799 ('Weekly_Retiree', CURRENT_DATE, CURRENT_DATE + 7, 500),
2800
2801 ('Monthly_Regular', CURRENT_DATE, CURRENT_DATE + 30, 900),
2802 ('Monthly_Retiree', CURRENT_DATE, CURRENT_DATE + 30, 900),
2803
2804 ('Quarterly_Regular', CURRENT_DATE, CURRENT_DATE + 90, 2400),
2805 ('Quarterly_Retiree', CURRENT_DATE, CURRENT_DATE + 90, 2400),
2806
2807 ('Annual_Regular', CURRENT_DATE, CURRENT_DATE + 365, 7800),
2808 ('Annual_Retiree', CURRENT_DATE, CURRENT_DATE + 365, 7800),
2809
2810 ('Annual_Student', CURRENT_DATE, CURRENT_DATE + 365, 1000);
2811
2812
2813-- Ticket
2814CREATE TEMP TABLE customer_map AS
2815SELECT row_number() OVER () AS rn,
2816 user_id
2817FROM Customer;
2818
2819-- 1M
2820INSERT INTO Ticket (user_id)
2821SELECT cm.user_id
2822FROM generate_series(1, 1000000) gs(i)
2823 JOIN customer_map cm
2824 ON cm.rn = ((gs.i - 1) % 900000) + 1;
2825-- 2M
2826INSERT INTO Ticket (user_id)
2827SELECT cm.user_id
2828FROM generate_series(1000001, 2000000) gs(i)
2829 JOIN customer_map cm
2830 ON cm.rn = ((gs.i - 1) % 900000) + 1;
2831-- 3M
2832INSERT INTO Ticket (user_id)
2833SELECT cm.user_id
2834FROM generate_series(2000001, 3000000) gs(i)
2835 JOIN customer_map cm
2836 ON cm.rn = ((gs.i - 1) % 900000) + 1;
2837-- 4M
2838INSERT INTO Ticket (user_id)
2839SELECT cm.user_id
2840FROM generate_series(3000001, 4000000) gs(i)
2841 JOIN customer_map cm
2842 ON cm.rn = ((gs.i - 1) % 900000) + 1;
2843-- 5M
2844INSERT INTO Ticket (user_id)
2845SELECT cm.user_id
2846FROM generate_series(4000001, 5000000) gs(i)
2847 JOIN customer_map cm
2848 ON cm.rn = ((gs.i - 1) % 900000) + 1;
2849-- 6M
2850INSERT INTO Ticket (user_id)
2851SELECT cm.user_id
2852FROM generate_series(5000001, 6000000) gs(i)
2853 JOIN customer_map cm
2854 ON cm.rn = ((gs.i - 1) % 900000) + 1;
2855-- 7M
2856INSERT INTO Ticket (user_id)
2857SELECT cm.user_id
2858FROM generate_series(6000001, 7000000) gs(i)
2859 JOIN customer_map cm
2860 ON cm.rn = ((gs.i - 1) % 900000) + 1;
2861-- 8M
2862INSERT INTO Ticket (user_id)
2863SELECT cm.user_id
2864FROM generate_series(7000001, 8000000) gs(i)
2865 JOIN customer_map cm
2866 ON cm.rn = ((gs.i - 1) % 900000) + 1;
2867-- 9M
2868INSERT INTO Ticket (user_id)
2869SELECT cm.user_id
2870FROM generate_series(8000001, 9000000) gs(i)
2871 JOIN customer_map cm
2872 ON cm.rn = ((gs.i - 1) % 900000) + 1;
2873-- 10M
2874INSERT INTO Ticket (user_id)
2875SELECT cm.user_id
2876FROM generate_series(9000001, 10000000) gs(i)
2877 JOIN customer_map cm
2878 ON cm.rn = ((gs.i - 1) % 900000) + 1;
2879
2880
2881-- Pass_ticket
2882CREATE TEMP TABLE pass_type_map AS
2883SELECT ROW_NUMBER() OVER (ORDER BY id) AS rn,
2884 id,
2885 COUNT(*) OVER () AS total
2886FROM Pass_type;
2887
2888INSERT INTO Pass_ticket (ticket_id, type_id)
2889WITH total_types AS (SELECT MAX(total) as total_count
2890 FROM pass_type_map),
2891 randomized_tickets AS (SELECT ticket_id,
2892 ROW_NUMBER() OVER (ORDER BY RANDOM()) AS random_rn
2893 FROM Ticket
2894 LIMIT 3000000)
2895SELECT rt.ticket_id,
2896 (SELECT ptm.id
2897 FROM pass_type_map ptm
2898 WHERE ptm.rn = ((rt.random_rn - 1) % (SELECT total_count FROM total_types)) + 1) AS type_id
2899FROM randomized_tickets rt;
2900
2901
2902-- Single_ticket
2903CREATE TEMP TABLE assignment_map AS
2904SELECT ROW_NUMBER() OVER (ORDER BY assignment_id) AS rn,
2905 assignment_id
2906FROM (SELECT DISTINCT assignment_id
2907 FROM Line_assignment) a;
2908
2909INSERT INTO Single_ticket (ticket_id, amount, assignment_id)
2910SELECT t.ticket_id,
2911 50 AS amount,
2912 am.assignment_id
2913FROM (SELECT t.ticket_id,
2914 ROW_NUMBER() OVER (ORDER BY t.ticket_id) AS rn
2915 FROM Ticket t
2916 LEFT JOIN Pass_ticket pt
2917 ON t.ticket_id = pt.ticket_id
2918 WHERE pt.ticket_id IS NULL) t
2919 JOIN assignment_map am
2920 ON am.rn = (
2921 ((t.rn - 1) %
2922 (SELECT COUNT(*) FROM assignment_map)
2923 ) + 1
2924 );
2925
2926
2927-- Payment_type
2928INSERT INTO Payment_type (type, description)
2929VALUES ('Card', 'Payment made with debit or credit card'),
2930 ('Cash', 'Cash payment at kiosk or counter'),
2931 ('Online', 'Online or mobile application payment');
2932
2933
2934-- Payment
2935WITH payment_data AS (SELECT gs.i,
2936 CASE
2937 WHEN gs.i % 100 < 40 THEN 1 -- Card
2938 WHEN gs.i % 100 < 75 THEN 2 -- Cash
2939 ELSE 3 -- Online
2940 END AS type_id,
2941
2942 random() AS r,
2943
2944 CASE
2945 WHEN gs.i % 100 < 80 THEN
2946 CURRENT_DATE - (gs.i % 180)
2947 ELSE
2948 CURRENT_DATE - (180 + (gs.i % 550))
2949 END AS payment_date
2950
2951 FROM generate_series(1, 15000000) AS gs(i))
2952INSERT
2953INTO Payment (type_id, status, payment_date, transaction_number)
2954SELECT type_id,
2955
2956 CASE
2957 WHEN r < 0.67 THEN 'Completed'::payment_status
2958 WHEN r < 0.90 THEN 'Failed'::payment_status
2959 ELSE 'Pending'::payment_status
2960 END,
2961
2962 payment_date,
2963
2964 CASE
2965 WHEN type_id IN (1, 3) THEN
2966 (ARRAY ['210', '300', '310', '320', '330', '340'])[(i % 6) + 1]
2967 || lpad(i::text, 12, '0')
2968 END AS transaction_number
2969FROM payment_data;
2970
2971
2972-- Customer_Payment_Ticket
2973INSERT INTO Customer_Payment_Ticket
2974 (payment_id, ticket_id, user_id)
2975
2976SELECT p.payment_id,
2977 t.ticket_id,
2978 t.user_id
2979FROM (SELECT payment_id,
2980 ROW_NUMBER() OVER (ORDER BY payment_id) AS rn
2981 FROM Payment
2982 WHERE status = 'Completed') p
2983 JOIN (SELECT ticket_id,
2984 user_id,
2985 ROW_NUMBER() OVER (ORDER BY ticket_id) AS rn
2986 FROM Ticket) t
2987 ON t.rn = p.rn;
2988
2989
2990-- Validation
2991WITH params AS (SELECT 0.90::float AS active_ratio -- active tickets
2992),
2993 conductors AS (SELECT user_id,
2994 ROW_NUMBER() OVER (ORDER BY user_id) AS rn
2995 FROM Conductor),
2996 assignments AS (SELECT assignment_id,
2997 start_time,
2998 end_time,
2999 ROW_NUMBER() OVER (ORDER BY assignment_id) AS rn
3000 FROM Line_assignment),
3001 total_counts AS (SELECT (SELECT COUNT(*) FROM conductors) AS c_cnt,
3002 (SELECT COUNT(*) FROM assignments) AS a_cnt),
3003 base AS (SELECT pt.ticket_id,
3004 t.user_id,
3005 CASE
3006 WHEN pt.type_id IN (1, 2) THEN 2
3007 WHEN pt.type_id IN (3, 4) THEN 3
3008 WHEN pt.type_id IN (5, 6) THEN 3
3009 WHEN pt.type_id IN (7, 8) THEN 3
3010 WHEN pt.type_id IN (9, 10, 11) THEN 3
3011 ELSE 0
3012 END AS total_uses
3013 FROM Pass_ticket pt
3014 JOIN Ticket t ON t.ticket_id = pt.ticket_id
3015 CROSS JOIN params p
3016 WHERE pt.type_id IS NOT NULL
3017 AND random() < p.active_ratio),
3018 expanded AS (SELECT b.ticket_id,
3019 gs.i AS usage_index
3020 FROM base b
3021 JOIN LATERAL generate_series(1, b.total_uses) gs(i) ON TRUE)
3022INSERT
3023INTO Validation (conductor_id, ticket_id, assignment_id, validation_time)
3024SELECT c.user_id,
3025 e.ticket_id,
3026 a.assignment_id,
3027
3028 a.start_time +
3029 (random() * (a.end_time - a.start_time))
3030FROM expanded e
3031 CROSS JOIN total_counts tc
3032 JOIN conductors c
3033 ON c.rn = ((e.usage_index - 1) % tc.c_cnt) + 1
3034 JOIN assignments a
3035 ON a.rn = ((e.usage_index - 1) % tc.a_cnt) + 1
3036WHERE tc.c_cnt > 0
3037 AND tc.a_cnt > 0;
3038