Revize 241e7d2f

refs #6953: Migracni skripty dodelany, chybi tabulka datum. Pridan skript na restornuti databaze.

db/drop-all-tables.sql

@@ +1 @@
+set foreign_key_checks=0;
+drop table if exists mesto;
+drop table if exists ulice;
+drop table if exists zarizeni;
+drop table if exists zaznam_cas;
+drop table if exists zaznam;
+drop table if exists zaznam_prum_den;
+drop table if exists vozidlo;
+drop table if exists vozidla;
+set foreign_key_checks=1;

db/restore-database.sh

@@ +1 @@
+#!/bin/bash 
+
+DB_USR=sem-si-dejte-vaseho-db-uzivatele
+DB_PW=sem-si-dejte-vase-heslo-do-db
+DB_NAME=sem-si-dejte-jmeno-vasi-databaze
+
+mysql -u $DB_USR --password=$DB_PW $DB_NAME < drop-all-tables.sql
+mysql -u $DB_USR --password=$DB_PW $DB_NAME < v01__base_schema.sql
+mysql -u $DB_USR --password=$DB_PW $DB_NAME < v02__data_10_04_2018.sql
+mysql -u $DB_USR --password=$DB_PW $DB_NAME < v03__vozidlo_rename.sql
+mysql -u $DB_USR --password=$DB_PW $DB_NAME < v04__geosouradnice.sql
+mysql -u $DB_USR --password=$DB_PW $DB_NAME < v05__geosouradnice_update.sql
+mysql -u $DB_USR --password=$DB_PW $DB_NAME < v06__zaznam_prum_den.sql
+mysql -u $DB_USR --password=$DB_PW $DB_NAME < v07__data_20_05_2018.sql
+mysql -u $DB_USR --password=$DB_PW $DB_NAME < v08__geosouradnice_cesky.sql

db/v06__zaznam_prum_den.sql

@@ -10 +10 @@
   `datum` date NOT NULL,
   `smer` int(11) NOT NULL,
   `zarizeni_id` varchar(20) NOT NULL,
-  `vozidla_id` bigint(20) NOT NULL,
+  `vozidlo_id` bigint(20) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `zarizeni_id` (`zarizeni_id`),
-  KEY `vozidla_id` (`vozidla_id`)
+  KEY `vozidlo_id` (`vozidlo_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 --
 -- Omezení pro tabulku `zaznam_prum_den`
 --
 ALTER TABLE `zaznam_prum_den`
-  ADD CONSTRAINT `zaznam_prum_den_ibfk_2` FOREIGN KEY (`vozidla_id`) REFERENCES `vozidla` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
+  ADD CONSTRAINT `zaznam_prum_den_ibfk_2` FOREIGN KEY (`vozidlo_id`) REFERENCES `vozidlo` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
   ADD CONSTRAINT `zaznam_prum_den_ibfk_1` FOREIGN KEY (`zarizeni_id`) REFERENCES `zarizeni` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

db/v07__data_20_05_2018.sql

@@ -1 +1 @@
 -- tento script vlozi data do tabulky zaznam_prum_den, zaznam a zaznam_cas za den 20. 5. 2015
 
-INSERT INTO `zaznam_prum_den` (`id`, `vozidla_pocet`, `rychlost_prumer`, `datum`, `smer`, `zarizeni_id`, `vozidla_id`) VALUES
-(1, 6759, 42.284509542832, '2018-05-20', 1, '096', 2),
-(2, 63, 33.15873015873, '2018-05-20', 1, '096', 4),
-(3, 34, 29.852941176471, '2018-05-20', 1, '096', 6),
-(4, 15, 35.533333333333, '2018-05-20', 1, '096', 8),
-(5, 2512, 31.803742038217, '2018-05-20', 2, '096', 2),
-(6, 723, 21.600276625173, '2018-05-20', 2, '096', 4),
-(7, 39, 15.538461538462, '2018-05-20', 2, '096', 6),
-(8, 28, 22.928571428571, '2018-05-20', 2, '096', 8),
-(9, 7075, 44.723250883392, '2018-05-20', 1, '107', 2),
-(10, 34, 46.911764705882, '2018-05-20', 1, '107', 4),
-(11, 16, 43.75, '2018-05-20', 1, '107', 6),
-(12, 21, 42.238095238095, '2018-05-20', 1, '107', 8),
-(13, 5501, 44.735866206144, '2018-05-20', 2, '107', 2),
-(14, 16, 30.375, '2018-05-20', 2, '107', 4),
-(15, 30, 31, '2018-05-20', 2, '107', 6),
-(16, 21, 44.142857142857, '2018-05-20', 2, '107', 8),
-(17, 2075, 53.026024096386, '2018-05-20', 1, '123', 2),
-(18, 20, 50.15, '2018-05-20', 1, '123', 4),
-(19, 14, 50.714285714286, '2018-05-20', 1, '123', 6),
-(20, 25, 47.04, '2018-05-20', 1, '123', 8),
-(21, 2420, 58.268181818182, '2018-05-20', 2, '123', 2),
-(22, 20, 24.2, '2018-05-20', 2, '123', 4),
-(23, 10, 22.5, '2018-05-20', 2, '123', 6),
-(24, 24, 32.916666666667, '2018-05-20', 2, '123', 8),
-(25, 9821, 48.444964871194, '2018-05-20', 1, '051', 2),
-(26, 14, 47.642857142857, '2018-05-20', 1, '051', 4),
-(27, 42, 47.690476190476, '2018-05-20', 1, '051', 6),
-(28, 24, 45.875, '2018-05-20', 1, '051', 8),
-(29, 7777, 45.702584544169, '2018-05-20', 2, '051', 2),
-(30, 7, 30, '2018-05-20', 2, '051', 4),
-(31, 6, 7.6666666666667, '2018-05-20', 2, '051', 6),
-(32, 4, 36.5, '2018-05-20', 2, '051', 8),
-(33, 9711, 44.101019462465, '2018-05-20', 1, '100', 2),
-(34, 138, 45.528985507246, '2018-05-20', 1, '100', 4),
-(35, 45, 45.4, '2018-05-20', 1, '100', 6),
-(36, 78, 44.269230769231, '2018-05-20', 1, '100', 8),
-(37, 9085, 37.213208585581, '2018-05-20', 2, '100', 2),
-(38, 140, 28.707142857143, '2018-05-20', 2, '100', 4),
-(39, 73, 29.945205479452, '2018-05-20', 2, '100', 6),
-(40, 43, 33.651162790698, '2018-05-20', 2, '100', 8),
-(41, 11864, 47.591790289953, '2018-05-20', 1, '124', 2),
-(42, 38, 48.657894736842, '2018-05-20', 1, '124', 4),
-(43, 24, 46.875, '2018-05-20', 1, '124', 6),
-(44, 42, 46.690476190476, '2018-05-20', 1, '124', 8),
-(45, 6965, 42.445656855707, '2018-05-20', 2, '124', 2),
-(46, 90, 29.077777777778, '2018-05-20', 2, '124', 4),
-(47, 50, 23.68, '2018-05-20', 2, '124', 6),
-(48, 34, 30, '2018-05-20', 2, '124', 8),
-(49, 2, 66, '2018-05-20', 2, '076', 2),
-(50, 10740, 48.088547486034, '2018-05-20', 1, '118', 2),
-(51, 63, 46.412698412698, '2018-05-20', 1, '118', 4),
-(52, 84, 48.130952380952, '2018-05-20', 1, '118', 6),
-(53, 262, 49.103053435115, '2018-05-20', 1, '118', 8),
-(54, 6770, 40.879911373708, '2018-05-20', 2, '118', 2),
-(55, 49, 27.285714285714, '2018-05-20', 2, '118', 4),
-(56, 33, 28.030303030303, '2018-05-20', 2, '118', 6),
-(57, 92, 30.804347826087, '2018-05-20', 2, '118', 8),
-(58, 12889, 48.135619520521, '2018-05-20', 1, '194', 2),
-(59, 48, 47.645833333333, '2018-05-20', 1, '194', 4),
-(60, 32, 50.25, '2018-05-20', 1, '194', 6),
-(61, 138, 46.884057971014, '2018-05-20', 1, '194', 8),
-(62, 4235, 49.578512396694, '2018-05-20', 2, '194', 2),
-(63, 18, 36.555555555556, '2018-05-20', 2, '194', 4),
-(64, 31, 27.741935483871, '2018-05-20', 2, '194', 6),
-(65, 41, 31.80487804878, '2018-05-20', 2, '194', 8),
-(66, 5221, 52.877992721701, '2018-05-20', 1, '203', 2),
-(67, 2177, 73.354616444649, '2018-05-20', 2, '203', 2),
-(68, 9088, 47.226012323944, '2018-05-20', 1, '052', 2),
-(69, 36, 48.416666666667, '2018-05-20', 1, '052', 4),
-(70, 1, 29, '2018-05-20', 1, '052', 6),
-(71, 98, 46.367346938776, '2018-05-20', 1, '052', 8),
-(72, 6414, 42.538197692548, '2018-05-20', 2, '052', 2),
-(73, 45, 23.244444444444, '2018-05-20', 2, '052', 4),
-(74, 21, 22.047619047619, '2018-05-20', 2, '052', 6),
-(75, 18, 30.944444444444, '2018-05-20', 2, '052', 8),
-(76, 9071, 47.353654503362, '2018-05-20', 1, '101', 2),
-(77, 81, 47.16049382716, '2018-05-20', 1, '101', 4),
-(78, 20, 46.55, '2018-05-20', 1, '101', 6),
-(79, 167, 47.299401197605, '2018-05-20', 1, '101', 8),
-(80, 9297, 45.218457566957, '2018-05-20', 2, '101', 2),
-(81, 103, 29.941747572816, '2018-05-20', 2, '101', 4),
-(82, 15, 26.733333333333, '2018-05-20', 2, '101', 6),
-(83, 43, 31.488372093023, '2018-05-20', 2, '101', 8),
-(84, 9724, 49.764397367339, '2018-05-20', 1, '191', 2),
-(85, 20, 45.05, '2018-05-20', 1, '191', 4),
-(86, 29, 52.172413793103, '2018-05-20', 1, '191', 6),
-(87, 43, 50.186046511628, '2018-05-20', 1, '191', 8),
-(88, 7460, 50.707774798928, '2018-05-20', 2, '191', 2),
-(89, 52, 24.269230769231, '2018-05-20', 2, '191', 4),
-(90, 40, 38.4, '2018-05-20', 2, '191', 6),
-(91, 30, 37.7, '2018-05-20', 2, '191', 8),
-(92, 13042, 50.897255022236, '2018-05-20', 1, '206', 2),
-(93, 20, 52.65, '2018-05-20', 1, '206', 4),
-(94, 8, 50.875, '2018-05-20', 1, '206', 6),
-(95, 41, 46.829268292683, '2018-05-20', 1, '206', 8),
-(96, 8781, 52.119918004783, '2018-05-20', 2, '206', 2),
-(97, 26, 28.076923076923, '2018-05-20', 2, '206', 4),
-(98, 13, 32.538461538462, '2018-05-20', 2, '206', 6),
-(99, 31, 46.612903225806, '2018-05-20', 2, '206', 8),
-(100, 1837, 51.350571584105, '2018-05-20', 1, '125', 2),
-(101, 74, 51.621621621622, '2018-05-20', 1, '125', 4),
-(102, 13, 45.615384615385, '2018-05-20', 1, '125', 6),
-(103, 133, 46.744360902256, '2018-05-20', 1, '125', 8),
-(104, 1138, 48.408611599297, '2018-05-20', 2, '125', 2),
-(105, 85, 31.2, '2018-05-20', 2, '125', 4),
-(106, 22, 34.681818181818, '2018-05-20', 2, '125', 6),
-(107, 25, 18.28, '2018-05-20', 2, '125', 8),
-(108, 19537, 49.594154680862, '2018-05-20', 1, '192', 2),
-(109, 75, 48.333333333333, '2018-05-20', 1, '192', 4),
-(110, 52, 49.653846153846, '2018-05-20', 1, '192', 6),
-(111, 52, 48.788461538462, '2018-05-20', 1, '192', 8),
-(112, 14574, 45.530602442706, '2018-05-20', 2, '192', 2),
-(113, 112, 33.910714285714, '2018-05-20', 2, '192', 4),
-(114, 59, 25.966101694915, '2018-05-20', 2, '192', 6),
-(115, 84, 38.071428571429, '2018-05-20', 2, '192', 8),
-(116, 12139, 46.328857401763, '2018-05-20', 1, '200', 2),
-(117, 34, 52.794117647059, '2018-05-20', 1, '200', 4),
-(118, 10, 46.6, '2018-05-20', 1, '200', 6),
-(119, 25, 44.28, '2018-05-20', 1, '200', 8),
-(120, 6398, 39.678180681463, '2018-05-20', 2, '200', 2),
-(121, 39, 27.051282051282, '2018-05-20', 2, '200', 4),
-(122, 23, 30.565217391304, '2018-05-20', 2, '200', 6),
-(123, 25, 35.92, '2018-05-20', 2, '200', 8),
-(124, 3445, 43.402031930334, '2018-05-20', 1, '072', 2),
-(125, 39, 46.076923076923, '2018-05-20', 1, '072', 4),
-(126, 11, 35.818181818182, '2018-05-20', 1, '072', 6),
-(127, 29, 43.241379310345, '2018-05-20', 1, '072', 8),
-(128, 4566, 40.307271134472, '2018-05-20', 2, '072', 2),
-(129, 18, 42.666666666667, '2018-05-20', 2, '072', 4),
-(130, 9, 37.444444444444, '2018-05-20', 2, '072', 6),
-(131, 7, 37.857142857143, '2018-05-20', 2, '072', 8),
-(132, 8135, 46.444253226798, '2018-05-20', 1, '063', 2),
-(133, 19, 45.684210526316, '2018-05-20', 1, '063', 4),
-(134, 6, 41.5, '2018-05-20', 1, '063', 6),
-(135, 9, 34.888888888889, '2018-05-20', 1, '063', 8),
-(136, 5746, 45.135224504003, '2018-05-20', 2, '063', 2),
-(137, 100, 27.4, '2018-05-20', 2, '063', 4),
-(138, 18, 37.111111111111, '2018-05-20', 2, '063', 6),
-(139, 4, 25.75, '2018-05-20', 2, '063', 8),
-(140, 10951, 49.610172586978, '2018-05-20', 1, '112', 2),
-(141, 85, 48.423529411765, '2018-05-20', 1, '112', 4),
-(142, 40, 45, '2018-05-20', 1, '112', 6),
-(143, 90, 46.088888888889, '2018-05-20', 1, '112', 8),
-(144, 5328, 47.863926426426, '2018-05-20', 2, '112', 2),
-(145, 307, 32.231270358306, '2018-05-20', 2, '112', 4),
-(146, 52, 30.192307692308, '2018-05-20', 2, '112', 6),
-(147, 67, 32.731343283582, '2018-05-20', 2, '112', 8),
-(148, 6336, 47.076231060606, '2018-05-20', 1, '081', 2),
-(149, 2395, 49.55866388309, '2018-05-20', 2, '081', 2),
-(150, 3010, 24.157142857143, '2018-05-20', 1, '069', 2),
-(151, 34, 0, '2018-05-20', 1, '069', 4),
-(152, 28, 0, '2018-05-20', 1, '069', 6),
-(153, 30, 0, '2018-05-20', 1, '069', 8),
-(154, 1509, 0, '2018-05-20', 2, '069', 2),
-(155, 45, 0, '2018-05-20', 2, '069', 4),
-(156, 47, 0, '2018-05-20', 2, '069', 6),
-(157, 37, 0, '2018-05-20', 2, '069', 8),
-(158, 7486, 45.779054234571, '2018-05-20', 1, '105', 2),
-(159, 67, 44.776119402985, '2018-05-20', 1, '105', 4),
-(160, 23, 40.95652173913, '2018-05-20', 1, '105', 6),
-(161, 66, 43.363636363636, '2018-05-20', 1, '105', 8),
-(162, 4174, 35.684475323431, '2018-05-20', 2, '105', 2),
-(163, 20, 25.85, '2018-05-20', 2, '105', 4),
-(164, 58, 22.120689655172, '2018-05-20', 2, '105', 6),
-(165, 54, 18.407407407407, '2018-05-20', 2, '105', 8),
-(166, 4092, 45.261241446725, '2018-05-20', 1, '134', 2),
-(167, 9, 44.111111111111, '2018-05-20', 1, '134', 4),
-(168, 17, 44.294117647059, '2018-05-20', 1, '134', 6),
-(169, 17, 43.588235294118, '2018-05-20', 1, '134', 8),
-(170, 3462, 42.559214326979, '2018-05-20', 2, '134', 2),
-(171, 68, 23.588235294118, '2018-05-20', 2, '134', 4),
-(172, 27, 26.407407407407, '2018-05-20', 2, '134', 6),
-(173, 5, 26.8, '2018-05-20', 2, '134', 8),
-(174, 5319, 44.409475465313, '2018-05-20', 1, '054', 2),
-(175, 6, 44.666666666667, '2018-05-20', 1, '054', 4),
-(176, 1, 35, '2018-05-20', 1, '054', 6),
-(177, 4, 39, '2018-05-20', 1, '054', 8),
-(178, 3403, 42.721422274464, '2018-05-20', 2, '054', 2),
-(179, 10, 19, '2018-05-20', 2, '054', 4),
-(180, 3, 0, '2018-05-20', 2, '054', 6),
-(181, 4, 39.75, '2018-05-20', 2, '054', 8),
-(182, 8533, 52.809328489394, '2018-05-20', 1, '126', 2),
-(183, 31, 46.451612903226, '2018-05-20', 1, '126', 4),
-(184, 31, 39.096774193548, '2018-05-20', 1, '126', 6),
-(185, 19, 39.526315789474, '2018-05-20', 1, '126', 8),
-(186, 5214, 36.463367855773, '2018-05-20', 2, '126', 2),
-(187, 16, 28.1875, '2018-05-20', 2, '126', 4),
-(188, 16, 19, '2018-05-20', 2, '126', 6),
-(189, 13, 55.461538461538, '2018-05-20', 2, '126', 8),
-(190, 16148, 41.546073817191, '2018-05-20', 1, '193', 2),
-(191, 491, 40.997963340122, '2018-05-20', 1, '193', 4),
-(192, 162, 41.876543209877, '2018-05-20', 1, '193', 6),
-(193, 486, 41.592592592593, '2018-05-20', 1, '193', 8),
-(194, 12501, 44.261979041677, '2018-05-20', 2, '193', 2),
-(195, 160, 32.25625, '2018-05-20', 2, '193', 4),
-(196, 67, 33.567164179104, '2018-05-20', 2, '193', 6),
-(197, 73, 34.123287671233, '2018-05-20', 2, '193', 8),
-(198, 14248, 48.512001684447, '2018-05-20', 1, '205', 2),
-(199, 11, 51.272727272727, '2018-05-20', 1, '205', 4),
-(200, 11, 50.090909090909, '2018-05-20', 1, '205', 6),
-(201, 41, 54, '2018-05-20', 1, '205', 8),
-(202, 9884, 44.923917442331, '2018-05-20', 2, '205', 2),
-(203, 15, 28.333333333333, '2018-05-20', 2, '205', 4),
-(204, 24, 17.833333333333, '2018-05-20', 2, '205', 6),
-(205, 48, 36.270833333333, '2018-05-20', 2, '205', 8),
-(206, 1845, 44.586449864499, '2018-05-20', 1, '061', 2),
-(207, 20, 45.6, '2018-05-20', 1, '061', 4),
-(208, 5, 52.8, '2018-05-20', 1, '061', 6),
-(209, 11, 38.454545454545, '2018-05-20', 1, '061', 8),
-(210, 1192, 34.25, '2018-05-20', 2, '061', 2),
-(211, 21, 16.285714285714, '2018-05-20', 2, '061', 4),
-(212, 12, 15.916666666667, '2018-05-20', 2, '061', 6),
-(213, 9, 32.222222222222, '2018-05-20', 2, '061', 8),
-(214, 1522, 46.831143232589, '2018-05-20', 1, '127', 2),
-(215, 6, 43.833333333333, '2018-05-20', 1, '127', 4),
-(216, 1, 48, '2018-05-20', 1, '127', 6),
-(217, 6, 38.666666666667, '2018-05-20', 1, '127', 8),
-(218, 1580, 42.976582278481, '2018-05-20', 2, '127', 2),
-(219, 1, 38, '2018-05-20', 2, '127', 4),
-(220, 3, 38, '2018-05-20', 2, '127', 6),
-(221, 16, 41.1875, '2018-05-20', 2, '127', 8),
-(222, 18933, 39.078645750805, '2018-05-20', 1, '109', 2),
-(223, 24, 38.333333333333, '2018-05-20', 1, '109', 4),
-(224, 40, 35.675, '2018-05-20', 1, '109', 6),
-(225, 73, 36.684931506849, '2018-05-20', 1, '109', 8),
-(226, 10036, 29.692008768434, '2018-05-20', 2, '109', 2),
-(227, 42, 25.285714285714, '2018-05-20', 2, '109', 4),
-(228, 53, 26.471698113208, '2018-05-20', 2, '109', 6),
-(229, 58, 28.034482758621, '2018-05-20', 2, '109', 8),
-(230, 1568, 47.938775510204, '2018-05-20', 1, '122', 2),
-(231, 21, 47.809523809524, '2018-05-20', 1, '122', 4),
-(232, 2, 51, '2018-05-20', 1, '122', 6),
-(233, 13, 41.846153846154, '2018-05-20', 1, '122', 8),
-(234, 1049, 47.804575786463, '2018-05-20', 2, '122', 2),
-(235, 17, 11.823529411765, '2018-05-20', 2, '122', 4),
-(236, 5, 20.4, '2018-05-20', 2, '122', 6),
-(237, 4, 28.5, '2018-05-20', 2, '122', 8),
-(238, 8581, 43.664025171891, '2018-05-20', 1, '092', 2),
-(239, 37, 47.432432432432, '2018-05-20', 1, '092', 4),
-(240, 6, 49.833333333333, '2018-05-20', 1, '092', 6),
-(241, 22, 44.181818181818, '2018-05-20', 1, '092', 8),
-(242, 6365, 40.557109190888, '2018-05-20', 2, '092', 2),
-(243, 11, 31.181818181818, '2018-05-20', 2, '092', 4),
-(244, 5, 34.8, '2018-05-20', 2, '092', 6),
-(245, 8, 42.125, '2018-05-20', 2, '092', 8),
-(246, 5595, 42.910813226095, '2018-05-20', 1, '114', 2),
-(247, 498, 42.859437751004, '2018-05-20', 1, '114', 4),
-(248, 50, 41.8, '2018-05-20', 1, '114', 6),
-(249, 22, 42.590909090909, '2018-05-20', 1, '114', 8),
-(250, 3431, 40.843194403964, '2018-05-20', 2, '114', 2),
-(251, 141, 28.510638297872, '2018-05-20', 2, '114', 4),
-(252, 86, 27.488372093023, '2018-05-20', 2, '114', 6),
-(253, 11, 10.090909090909, '2018-05-20', 2, '114', 8),
-(254, 5124, 42.202966432475, '2018-05-20', 1, '097', 2),
-(255, 19, 43.842105263158, '2018-05-20', 1, '097', 4),
-(256, 7, 55.142857142857, '2018-05-20', 1, '097', 6),
-(257, 17, 41.647058823529, '2018-05-20', 1, '097', 8),
-(258, 3720, 39.529569892473, '2018-05-20', 2, '097', 2),
-(259, 23, 28.782608695652, '2018-05-20', 2, '097', 4),
-(260, 3, 26, '2018-05-20', 2, '097', 6),
-(261, 4, 41.5, '2018-05-20', 2, '097', 8),
-(262, 766, 49.323759791123, '2018-05-20', 1, '117', 2),
-(263, 8, 49.875, '2018-05-20', 1, '117', 4),
-(264, 3, 44.666666666667, '2018-05-20', 1, '117', 6),
-(265, 138, 48.608695652174, '2018-05-20', 1, '117', 8),
-(266, 734, 44.905994550409, '2018-05-20', 2, '117', 2),
-(267, 6, 38.666666666667, '2018-05-20', 2, '117', 4),
-(268, 5, 18.8, '2018-05-20', 2, '117', 6),
-(269, 40, 28.325, '2018-05-20', 2, '117', 8),
-(270, 3670, 23.965940054496, '2018-05-20', 1, '130', 2),
-(271, 29, 19.068965517241, '2018-05-20', 1, '130', 4),
-(272, 3, 14.333333333333, '2018-05-20', 1, '130', 6),
-(273, 2, 18, '2018-05-20', 1, '130', 8),
-(274, 1606, 43.427148194271, '2018-05-20', 2, '130', 2),
-(275, 14014, 49.563436563437, '2018-05-20', 1, '086', 2),
-(276, 87, 49.540229885057, '2018-05-20', 1, '086', 4),
-(277, 49, 51, '2018-05-20', 1, '086', 6),
-(278, 29, 43.724137931034, '2018-05-20', 1, '086', 8),
-(279, 10786, 46.038661227517, '2018-05-20', 2, '086', 2),
-(280, 27, 35.074074074074, '2018-05-20', 2, '086', 4),
-(281, 22, 43.227272727273, '2018-05-20', 2, '086', 6),
-(282, 34, 32.911764705882, '2018-05-20', 2, '086', 8),
-(283, 6294, 42.495392437242, '2018-05-20', 1, '110', 2),
-(284, 82, 39.536585365854, '2018-05-20', 1, '110', 4),
-(285, 29, 37.655172413793, '2018-05-20', 1, '110', 6),
-(286, 9, 31.888888888889, '2018-05-20', 1, '110', 8),
-(287, 4536, 38.434082892416, '2018-05-20', 2, '110', 2),
-(288, 107, 15.532710280374, '2018-05-20', 2, '110', 4),
-(289, 37, 19.27027027027, '2018-05-20', 2, '110', 6),
-(290, 10, 26.2, '2018-05-20', 2, '110', 8),
-(291, 3839, 36.425371190414, '2018-05-20', 1, '133', 2),
-(292, 646, 36.363777089783, '2018-05-20', 2, '133', 2),
-(293, 2520, 39.661507936508, '2018-05-20', 1, '099', 2),
-(294, 1, 42, '2018-05-20', 1, '099', 4),
-(295, 10, 39.5, '2018-05-20', 1, '099', 8),
-(296, 1795, 44.769359331476, '2018-05-20', 2, '099', 2),
-(297, 4, 9, '2018-05-20', 2, '099', 4),
-(298, 4, 10.75, '2018-05-20', 2, '099', 6),
-(299, 2, 0, '2018-05-20', 2, '099', 8),
-(300, 1150, 43.31652173913, '2018-05-20', 1, '068', 2),
-(301, 40, 45.75, '2018-05-20', 1, '068', 4),
-(302, 3, 42, '2018-05-20', 1, '068', 6),
-(303, 12, 41, '2018-05-20', 1, '068', 8),
-(304, 913, 39.697699890471, '2018-05-20', 2, '068', 2),
-(305, 3, 8.3333333333333, '2018-05-20', 2, '068', 4),
-(306, 4, 20, '2018-05-20', 2, '068', 6),
-(307, 4138, 44.370710488159, '2018-05-20', 1, '073', 2),
-(308, 80, 40.2875, '2018-05-20', 1, '073', 4),
-(309, 24, 36.708333333333, '2018-05-20', 1, '073', 6),
-(310, 21, 36.047619047619, '2018-05-20', 1, '073', 8),
-(311, 2058, 29.938775510204, '2018-05-20', 2, '073', 2),
-(312, 253, 13.04743083004, '2018-05-20', 2, '073', 4),
-(313, 33, 16.242424242424, '2018-05-20', 2, '073', 6),
-(314, 22, 18.045454545455, '2018-05-20', 2, '073', 8),
-(315, 10075, 48.793349875931, '2018-05-20', 1, '199', 2),
-(316, 78, 47.628205128205, '2018-05-20', 1, '199', 4),
-(317, 74, 46.283783783784, '2018-05-20', 1, '199', 6),
-(318, 31, 47.387096774194, '2018-05-20', 1, '199', 8),
-(319, 7214, 39.343637371777, '2018-05-20', 2, '199', 2),
-(320, 369, 26.311653116531, '2018-05-20', 2, '199', 4),
-(321, 92, 26.586956521739, '2018-05-20', 2, '199', 6),
-(322, 53, 36.11320754717, '2018-05-20', 2, '199', 8),
-(323, 12088, 46.285572468564, '2018-05-20', 1, '196', 2),
-(324, 8, 44.75, '2018-05-20', 1, '196', 4),
-(325, 12, 48, '2018-05-20', 1, '196', 6),
-(326, 101, 45.50495049505, '2018-05-20', 1, '196', 8),
-(327, 10448, 43.54039050536, '2018-05-20', 2, '196', 2),
-(328, 31, 38.806451612903, '2018-05-20', 2, '196', 4),
-(329, 23, 11.782608695652, '2018-05-20', 2, '196', 6),
-(330, 54, 32.962962962963, '2018-05-20', 2, '196', 8),
-(331, 1802, 40.253607103219, '2018-05-20', 1, '121', 2),
-(332, 1446, 39.69571230982, '2018-05-20', 2, '121', 2),
-(333, 3141, 47.083094555874, '2018-05-20', 1, '128', 2),
-(334, 22, 48.5, '2018-05-20', 1, '128', 4),
-(335, 10, 46.8, '2018-05-20', 1, '128', 6),
-(336, 18, 45.666666666667, '2018-05-20', 1, '128', 8),
-(337, 2934, 48.255282890252, '2018-05-20', 2, '128', 2),
-(338, 12, 22.5, '2018-05-20', 2, '128', 4),
-(339, 14, 18.928571428571, '2018-05-20', 2, '128', 6),
-(340, 36, 23.027777777778, '2018-05-20', 2, '128', 8),
-(341, 8500, 46.697764705882, '2018-05-20', 1, '095', 2),
-(342, 21, 46.285714285714, '2018-05-20', 1, '095', 4),
-(343, 6, 48.166666666667, '2018-05-20', 1, '095', 6),
-(344, 35, 44.314285714286, '2018-05-20', 1, '095', 8),
-(345, 6630, 39.897737556561, '2018-05-20', 2, '095', 2),
-(346, 40, 32.425, '2018-05-20', 2, '095', 4),
-(347, 17, 20.647058823529, '2018-05-20', 2, '095', 6),
-(348, 17, 31.058823529412, '2018-05-20', 2, '095', 8),
-(349, 5668, 45.871030345801, '2018-05-20', 1, '094', 2),
-(350, 20, 44.9, '2018-05-20', 1, '094', 4),
-(351, 6, 41.333333333333, '2018-05-20', 1, '094', 6),
-(352, 20, 43.3, '2018-05-20', 1, '094', 8),
-(353, 5098, 47.743232640251, '2018-05-20', 2, '094', 2),
-(354, 45, 29, '2018-05-20', 2, '094', 4),
-(355, 13, 22.615384615385, '2018-05-20', 2, '094', 6),
-(356, 12, 23, '2018-05-20', 2, '094', 8),
-(357, 1022, 19.47553816047, '2018-05-20', 1, '055', 2),
-(358, 2, 0, '2018-05-20', 1, '055', 4),
-(359, 2, 0, '2018-05-20', 1, '055', 6),
-(360, 19, 0, '2018-05-20', 1, '055', 8),
-(361, 599, 0, '2018-05-20', 2, '055', 2),
-(362, 1, 0, '2018-05-20', 2, '055', 4),
-(363, 3, 0, '2018-05-20', 2, '055', 6),
-(364, 3, 0, '2018-05-20', 2, '055', 8),
-(365, 6792, 44.60777385159, '2018-05-20', 1, '201', 2),
-(366, 9, 43.333333333333, '2018-05-20', 1, '201', 4),
-(367, 24, 38.916666666667, '2018-05-20', 1, '201', 6),
-(368, 22, 37, '2018-05-20', 1, '201', 8),
-(369, 5043, 38.138211382114, '2018-05-20', 2, '201', 2),
-(370, 13, 24.615384615385, '2018-05-20', 2, '201', 4),
-(371, 16, 30.9375, '2018-05-20', 2, '201', 6),
-(372, 25, 30.04, '2018-05-20', 2, '201', 8),
-(373, 12928, 52.989248143564, '2018-05-20', 1, '204', 2),
-(374, 44, 48.090909090909, '2018-05-20', 1, '204', 4),
-(375, 45, 49.066666666667, '2018-05-20', 1, '204', 6),
-(376, 112, 49.696428571429, '2018-05-20', 1, '204', 8),
-(377, 16587, 51.860372580937, '2018-05-20', 2, '204', 2),
-(378, 340, 38.123529411765, '2018-05-20', 2, '204', 4),
-(379, 210, 35.9, '2018-05-20', 2, '204', 6),
-(380, 104, 38.576923076923, '2018-05-20', 2, '204', 8),
-(381, 8667, 45.234914041768, '2018-05-20', 1, '106', 2),
-(382, 18, 45.166666666667, '2018-05-20', 1, '106', 4),
-(383, 21, 47.190476190476, '2018-05-20', 1, '106', 6),
-(384, 55, 46.163636363636, '2018-05-20', 1, '106', 8),
-(385, 7842, 42.176613108901, '2018-05-20', 2, '106', 2),
-(386, 33, 31.939393939394, '2018-05-20', 2, '106', 4),
-(387, 54, 23.407407407407, '2018-05-20', 2, '106', 6),
-(388, 39, 30.051282051282, '2018-05-20', 2, '106', 8),
-(389, 6803, 46.324709686903, '2018-05-20', 1, '082', 2),
-(390, 46, 45.630434782609, '2018-05-20', 1, '082', 4),
-(391, 55, 48.6, '2018-05-20', 1, '082', 6),
-(392, 66, 45.893939393939, '2018-05-20', 1, '082', 8),
-(393, 4631, 35.4867199309, '2018-05-20', 2, '082', 2),
-(394, 35, 25.057142857143, '2018-05-20', 2, '082', 4),
-(395, 35, 26.342857142857, '2018-05-20', 2, '082', 6),
-(396, 59, 23.152542372881, '2018-05-20', 2, '082', 8),
-(397, 6954, 48.428242737993, '2018-05-20', 1, '111', 2),
-(398, 34, 48.029411764706, '2018-05-20', 1, '111', 4),
-(399, 34, 45.176470588235, '2018-05-20', 1, '111', 6),
-(400, 55, 43.345454545455, '2018-05-20', 1, '111', 8),
-(401, 4932, 47.715531224655, '2018-05-20', 2, '111', 2),
-(402, 53, 27.849056603774, '2018-05-20', 2, '111', 4),
-(403, 64, 26.25, '2018-05-20', 2, '111', 6),
-(404, 66, 21.19696969697, '2018-05-20', 2, '111', 8),
-(405, 5397, 50.982212340189, '2018-05-20', 1, '084', 2),
-(406, 30, 48.6, '2018-05-20', 1, '084', 4),
-(407, 5, 36.6, '2018-05-20', 1, '084', 6),
-(408, 37, 39.837837837838, '2018-05-20', 1, '084', 8),
-(409, 3212, 42.324719800747, '2018-05-20', 2, '084', 2),
-(410, 14, 27.5, '2018-05-20', 2, '084', 4),
-(411, 13, 18.769230769231, '2018-05-20', 2, '084', 6),
-(412, 26, 39.730769230769, '2018-05-20', 2, '084', 8),
-(413, 5058, 43.734480031633, '2018-05-20', 1, '062', 2),
-(414, 1, 41, '2018-05-20', 1, '062', 4),
-(415, 8, 38.625, '2018-05-20', 1, '062', 6),
-(416, 33, 39.909090909091, '2018-05-20', 1, '062', 8),
-(417, 4288, 41.943097014925, '2018-05-20', 2, '062', 2),
-(418, 21, 31.952380952381, '2018-05-20', 2, '062', 4),
-(419, 17, 25.705882352941, '2018-05-20', 2, '062', 6),
-(420, 4, 25.25, '2018-05-20', 2, '062', 8),
-(421, 2413, 49.86241193535, '2018-05-20', 1, '132', 2),
-(422, 1, 48, '2018-05-20', 1, '132', 4),
-(423, 3, 49.333333333333, '2018-05-20', 1, '132', 6),
-(424, 1, 41, '2018-05-20', 1, '132', 8),
-(425, 2158, 40.799814643188, '2018-05-20', 2, '132', 2),
-(426, 1, 20, '2018-05-20', 2, '132', 4),
-(427, 3, 0, '2018-05-20', 2, '132', 6),
-(428, 3126, 46.50575815739, '2018-05-20', 1, '136', 2),
-(429, 33, 43.393939393939, '2018-05-20', 1, '136', 4),
-(430, 6, 43.333333333333, '2018-05-20', 1, '136', 6),
-(431, 35, 43.942857142857, '2018-05-20', 1, '136', 8),
-(432, 2613, 47.346727898967, '2018-05-20', 2, '136', 2),
-(433, 9, 15.888888888889, '2018-05-20', 2, '136', 4),
-(434, 4, 19.75, '2018-05-20', 2, '136', 6),
-(435, 16, 33.25, '2018-05-20', 2, '136', 8),
-(436, 1990, 40.204522613065, '2018-05-20', 1, '056', 2),
-(437, 5, 36.6, '2018-05-20', 1, '056', 4),
-(438, 3, 35.666666666667, '2018-05-20', 1, '056', 6),
-(439, 23, 36.869565217391, '2018-05-20', 1, '056', 8),
-(440, 1456, 31.87293956044, '2018-05-20', 2, '056', 2),
-(441, 10, 20.3, '2018-05-20', 2, '056', 4),
-(442, 4, 14.75, '2018-05-20', 2, '056', 6),
-(443, 2, 21.5, '2018-05-20', 2, '056', 8),
-(444, 4833, 48.936892199462, '2018-05-20', 1, '057', 2),
-(445, 33, 48.030303030303, '2018-05-20', 1, '057', 4),
-(446, 14, 46.285714285714, '2018-05-20', 1, '057', 6),
-(447, 33, 44.878787878788, '2018-05-20', 1, '057', 8),
-(448, 2234, 44.579230080573, '2018-05-20', 2, '057', 2),
-(449, 7, 42.142857142857, '2018-05-20', 2, '057', 4),
-(450, 4, 17.5, '2018-05-20', 2, '057', 6),
-(451, 3, 61.333333333333, '2018-05-20', 2, '057', 8),
-(452, 1380, 43.426811594203, '2018-05-20', 1, '065', 2),
-(453, 5, 42.4, '2018-05-20', 1, '065', 4),
-(454, 3, 39.333333333333, '2018-05-20', 1, '065', 6),
-(455, 3, 38.666666666667, '2018-05-20', 1, '065', 8),
-(456, 1028, 32.790856031128, '2018-05-20', 2, '065', 2),
-(457, 40, 15.65, '2018-05-20', 2, '065', 4),
-(458, 14, 14, '2018-05-20', 2, '065', 6),
-(459, 10213, 45.497796925487, '2018-05-20', 1, '059', 2),
-(460, 32, 47.375, '2018-05-20', 1, '059', 4),
-(461, 6, 45.166666666667, '2018-05-20', 1, '059', 6),
-(462, 162, 44.895061728395, '2018-05-20', 1, '059', 8),
-(463, 9181, 37.068837817231, '2018-05-20', 2, '059', 2),
-(464, 81, 18.271604938272, '2018-05-20', 2, '059', 4),
-(465, 49, 19.163265306122, '2018-05-20', 2, '059', 6),
-(466, 30, 31.2, '2018-05-20', 2, '059', 8),
-(467, 9887, 48.612218064125, '2018-05-20', 1, '198', 2),
-(468, 22, 45.409090909091, '2018-05-20', 1, '198', 4),
-(469, 46, 47.869565217391, '2018-05-20', 1, '198', 6),
-(470, 10, 46.8, '2018-05-20', 1, '198', 8),
-(471, 6510, 53.404301075269, '2018-05-20', 2, '198', 2),
-(472, 1603, 25.306924516532, '2018-05-20', 2, '198', 4),
-(473, 394, 24.969543147208, '2018-05-20', 2, '198', 6),
-(474, 43, 29.558139534884, '2018-05-20', 2, '198', 8),
-(475, 242, 25.173553719008, '2018-05-20', 1, '078', 2),
-(476, 149, 15.114093959732, '2018-05-20', 2, '078', 2),
-(477, 1794, 43.229096989967, '2018-05-20', 1, '071', 2),
-(478, 13, 45.307692307692, '2018-05-20', 1, '071', 4),
-(479, 1, 39, '2018-05-20', 1, '071', 6),
-(480, 17, 40.823529411765, '2018-05-20', 1, '071', 8),
-(481, 1416, 37.727401129944, '2018-05-20', 2, '071', 2),
-(482, 1, 56, '2018-05-20', 2, '071', 8),
-(483, 2379, 62.196721311475, '2018-05-20', 1, '060', 2),
-(484, 16, 60, '2018-05-20', 1, '060', 4),
-(485, 14, 52.142857142857, '2018-05-20', 1, '060', 6),
-(486, 1, 67, '2018-05-20', 1, '060', 8),
-(487, 2193, 51.091199270406, '2018-05-20', 2, '060', 2),
-(488, 21, 23.904761904762, '2018-05-20', 2, '060', 4),
-(489, 17, 39.529411764706, '2018-05-20', 2, '060', 6),
-(490, 4, 22.75, '2018-05-20', 2, '060', 8),
-(491, 9334, 47.721127062353, '2018-05-20', 1, '103', 2),
-(492, 51, 46.450980392157, '2018-05-20', 1, '103', 4),
-(493, 48, 49.0625, '2018-05-20', 1, '103', 6),
-(494, 34, 42.558823529412, '2018-05-20', 1, '103', 8),
-(495, 7950, 43.954716981132, '2018-05-20', 2, '103', 2),
-(496, 105, 30.590476190476, '2018-05-20', 2, '103', 4),
-(497, 55, 32.454545454545, '2018-05-20', 2, '103', 6),
-(498, 20, 27.8, '2018-05-20', 2, '103', 8),
-(499, 7537, 47.604219185352, '2018-05-20', 1, '113', 2),
-(500, 9, 51.444444444444, '2018-05-20', 1, '113', 4),
-(501, 17, 50.176470588235, '2018-05-20', 1, '113', 6),
-(502, 48, 48.291666666667, '2018-05-20', 1, '113', 8),
-(503, 5327, 37.439271635067, '2018-05-20', 2, '113', 2),
-(504, 15, 27.266666666667, '2018-05-20', 2, '113', 4),
-(505, 24, 16.708333333333, '2018-05-20', 2, '113', 6),
-(506, 32, 30.0625, '2018-05-20', 2, '113', 8),
-(507, 1929, 37.439606013478, '2018-05-20', 1, '087', 2),
-(508, 12, 39, '2018-05-20', 1, '087', 4),
-(509, 9, 37.555555555556, '2018-05-20', 1, '087', 8),
-(510, 1925, 30.925194805195, '2018-05-20', 2, '087', 2),
-(511, 2, 6.5, '2018-05-20', 2, '087', 6),
-(512, 1, 31, '2018-05-20', 2, '087', 8),
-(513, 5926, 47.180053999325, '2018-05-20', 1, '075', 2),
-(514, 21, 45.571428571429, '2018-05-20', 1, '075', 4),
-(515, 17, 44.882352941176, '2018-05-20', 1, '075', 6),
-(516, 19, 46, '2018-05-20', 1, '075', 8),
-(517, 5438, 39.231702831923, '2018-05-20', 2, '075', 2),
-(518, 37, 18.72972972973, '2018-05-20', 2, '075', 4),
-(519, 35, 20.771428571429, '2018-05-20', 2, '075', 6),
-(520, 24, 32, '2018-05-20', 2, '075', 8),
-(521, 4855, 46.315139031926, '2018-05-20', 1, '058', 2),
-(522, 12, 43.583333333333, '2018-05-20', 1, '058', 4),
-(523, 3, 36.333333333333, '2018-05-20', 1, '058', 6),
-(524, 29, 47, '2018-05-20', 1, '058', 8),
-(525, 4267, 40.309116475275, '2018-05-20', 2, '058', 2),
-(526, 18, 20.888888888889, '2018-05-20', 2, '058', 4),
-(527, 9, 19.111111111111, '2018-05-20', 2, '058', 6),
-(528, 7, 30.571428571429, '2018-05-20', 2, '058', 8),
-(529, 6942, 48.832180927687, '2018-05-20', 1, '195', 2),
-(530, 19, 48.947368421053, '2018-05-20', 1, '195', 4),
-(531, 5, 40, '2018-05-20', 1, '195', 6),
-(532, 32, 47.15625, '2018-05-20', 1, '195', 8),
-(533, 5386, 42.088934274044, '2018-05-20', 2, '195', 2),
-(534, 57, 27.929824561404, '2018-05-20', 2, '195', 4),
-(535, 29, 26.758620689655, '2018-05-20', 2, '195', 6),
-(536, 39, 31.25641025641, '2018-05-20', 2, '195', 8),
-(537, 1413, 48.524416135881, '2018-05-20', 1, '131', 2),
-(538, 5, 42.2, '2018-05-20', 1, '131', 4),
-(539, 20, 45.2, '2018-05-20', 1, '131', 8),
-(540, 929, 41.501614639397, '2018-05-20', 2, '131', 2),
-(541, 8, 23.25, '2018-05-20', 2, '131', 4),
-(542, 3, 11.333333333333, '2018-05-20', 2, '131', 6),
-(543, 4, 38, '2018-05-20', 2, '131', 8),
-(544, 4075, 42.564417177914, '2018-05-20', 1, '129', 2),
-(545, 10, 37.1, '2018-05-20', 1, '129', 4),
-(546, 5, 31.2, '2018-05-20', 1, '129', 6),
-(547, 2, 32.5, '2018-05-20', 1, '129', 8),
-(548, 3854, 39.928386092372, '2018-05-20', 2, '129', 2),
-(549, 21, 24.142857142857, '2018-05-20', 2, '129', 4),
-(550, 13, 20.461538461538, '2018-05-20', 2, '129', 6),
-(551, 3, 49.333333333333, '2018-05-20', 2, '129', 8),
-(552, 625, 0, '2018-05-20', 1, '083', 2),
-(553, 7, 0, '2018-05-20', 1, '083', 4),
-(554, 4, 0, '2018-05-20', 1, '083', 6),
-(555, 9, 0, '2018-05-20', 1, '083', 8),
-(556, 788, 0, '2018-05-20', 2, '083', 2),
-(557, 1, 0, '2018-05-20', 2, '083', 4),
-(558, 13, 0, '2018-05-20', 2, '083', 6),
-(559, 8, 0, '2018-05-20', 2, '083', 8),
-(560, 1754, 46.469783352338, '2018-05-20', 1, '091', 2),
-(561, 6, 47.833333333333, '2018-05-20', 1, '091', 4),
-(562, 11, 44.636363636364, '2018-05-20', 1, '091', 6),
-(563, 6, 41.5, '2018-05-20', 1, '091', 8),
-(564, 1256, 40.180732484076, '2018-05-20', 2, '091', 2),
-(565, 22, 27.272727272727, '2018-05-20', 2, '091', 4),
-(566, 9, 18.333333333333, '2018-05-20', 2, '091', 6),
-(567, 4, 17, '2018-05-20', 2, '091', 8),
-(568, 3065, 44.14779771615, '2018-05-20', 1, '202', 2),
-(569, 3, 52.333333333333, '2018-05-20', 1, '202', 4),
-(570, 21, 41.238095238095, '2018-05-20', 1, '202', 8),
-(571, 2575, 42.126990291262, '2018-05-20', 2, '202', 2),
-(572, 1, 0, '2018-05-20', 2, '202', 4),
-(573, 5, 28.6, '2018-05-20', 2, '202', 6),
-(574, 7, 47.571428571429, '2018-05-20', 2, '202', 8),
-(575, 3623, 43.553132762904, '2018-05-20', 1, '135', 2),
-(576, 17, 43.235294117647, '2018-05-20', 1, '135', 4),
-(577, 2, 39, '2018-05-20', 1, '135', 6),
-(578, 15, 35, '2018-05-20', 1, '135', 8),
-(579, 2447, 34.178994687372, '2018-05-20', 2, '135', 2),
-(580, 31, 20.129032258065, '2018-05-20', 2, '135', 4),
-(581, 12, 14.583333333333, '2018-05-20', 2, '135', 6),
-(582, 15, 22.733333333333, '2018-05-20', 2, '135', 8),
-(583, 2453, 47.473705666531, '2018-05-20', 1, '120', 2),
-(584, 11, 48.363636363636, '2018-05-20', 1, '120', 4),
-(585, 7, 47, '2018-05-20', 1, '120', 6),
-(586, 15, 44.933333333333, '2018-05-20', 1, '120', 8),
-(587, 1485, 41.398653198653, '2018-05-20', 2, '120', 2),
-(588, 36, 17.25, '2018-05-20', 2, '120', 4),
-(589, 14, 20.428571428571, '2018-05-20', 2, '120', 6),
-(590, 4, 33.5, '2018-05-20', 2, '120', 8),
-(591, 1924, 34.283783783784, '2018-05-20', 1, '088', 2),
-(592, 6, 33.333333333333, '2018-05-20', 1, '088', 4),
-(593, 5, 38, '2018-05-20', 1, '088', 6),
-(594, 1232, 35.254058441558, '2018-05-20', 2, '088', 2),
-(595, 76, 17.789473684211, '2018-05-20', 2, '088', 4),
-(596, 9, 28.777777777778, '2018-05-20', 2, '088', 6),
-(597, 5, 26, '2018-05-20', 2, '088', 8),
-(598, 1434, 41.903068340307, '2018-05-20', 1, '064', 2),
-(599, 4, 25.75, '2018-05-20', 1, '064', 6),
-(600, 35, 46.314285714286, '2018-05-20', 1, '064', 8),
-(601, 1081, 36.369102682701, '2018-05-20', 2, '064', 2),
-(602, 1, 0, '2018-05-20', 2, '064', 4),
-(603, 4, 39.75, '2018-05-20', 2, '064', 6),
-(604, 1, 30, '2018-05-20', 2, '064', 8),
-(605, 2392, 48.484531772575, '2018-05-20', 1, '093', 2),
-(606, 7, 49.142857142857, '2018-05-20', 1, '093', 4),
-(607, 10, 44.3, '2018-05-20', 1, '093', 6),
-(608, 13, 44.769230769231, '2018-05-20', 1, '093', 8),
-(609, 1757, 43.182697780307, '2018-05-20', 2, '093', 2),
-(610, 46, 26.608695652174, '2018-05-20', 2, '093', 4),
-(611, 15, 20.2, '2018-05-20', 2, '093', 6),
-(612, 9, 18.777777777778, '2018-05-20', 2, '093', 8),
-(613, 766, 49.293733681462, '2018-05-20', 1, '077', 2),
-(614, 4, 45.25, '2018-05-20', 1, '077', 4),
-(615, 2, 49.5, '2018-05-20', 1, '077', 6),
-(616, 2, 50, '2018-05-20', 1, '077', 8),
-(617, 511, 35.3228962818, '2018-05-20', 2, '077', 2),
-(618, 3, 38.666666666667, '2018-05-20', 2, '077', 4),
-(619, 2868, 31.097280334728, '2018-05-20', 1, '108', 2),
-(620, 16, 32.875, '2018-05-20', 1, '108', 4),
-(621, 3, 32, '2018-05-20', 1, '108', 6),
-(622, 5, 25.8, '2018-05-20', 1, '108', 8),
-(623, 2228, 26.108168761221, '2018-05-20', 2, '108', 2),
-(624, 17, 21.117647058824, '2018-05-20', 2, '108', 4),
-(625, 6, 4.3333333333333, '2018-05-20', 2, '108', 6),
-(626, 5, 25.2, '2018-05-20', 2, '108', 8),
-(627, 1901, 42.588111520252, '2018-05-20', 1, '119', 2),
-(628, 14, 42.857142857143, '2018-05-20', 1, '119', 4),
-(629, 9, 38.444444444444, '2018-05-20', 1, '119', 6),
-(630, 11, 37.272727272727, '2018-05-20', 1, '119', 8),
-(631, 1456, 41.980082417582, '2018-05-20', 2, '119', 2),
-(632, 15, 23.733333333333, '2018-05-20', 2, '119', 4),
-(633, 4, 17.25, '2018-05-20', 2, '119', 6),
-(634, 6, 24.333333333333, '2018-05-20', 2, '119', 8),
-(635, 1959, 53.086268504339, '2018-05-20', 1, '074', 2),
-(636, 9, 45.333333333333, '2018-05-20', 1, '074', 4),
-(637, 12, 50.583333333333, '2018-05-20', 1, '074', 6),
-(638, 6, 46.5, '2018-05-20', 1, '074', 8),
-(639, 1266, 47.185624012638, '2018-05-20', 2, '074', 2),
-(640, 20, 12.9, '2018-05-20', 2, '074', 4),
-(641, 7, 19.142857142857, '2018-05-20', 2, '074', 6),
-(642, 4, 49, '2018-05-20', 2, '074', 8),
-(643, 1968, 45.131097560976, '2018-05-20', 1, '067', 2),
-(644, 12, 38.75, '2018-05-20', 1, '067', 4),
-(645, 2, 21, '2018-05-20', 1, '067', 6),
-(646, 10, 34.7, '2018-05-20', 1, '067', 8),
-(647, 1351, 32.59881569208, '2018-05-20', 2, '067', 2),
-(648, 5, 5.8, '2018-05-20', 2, '067', 6),
-(649, 4, 23.5, '2018-05-20', 2, '067', 8),
-(650, 2286, 49.347769028871, '2018-05-20', 1, '070', 2),
-(651, 13, 46.230769230769, '2018-05-20', 1, '070', 4),
-(652, 8, 36.125, '2018-05-20', 1, '070', 6),
-(653, 20, 48, '2018-05-20', 1, '070', 8),
-(654, 1632, 49.178921568627, '2018-05-20', 2, '070', 2),
-(655, 27, 28.111111111111, '2018-05-20', 2, '070', 4),
-(656, 25, 21.52, '2018-05-20', 2, '070', 6),
-(657, 8, 28.5, '2018-05-20', 2, '070', 8),
-(658, 603, 48.117744610282, '2018-05-20', 1, '104', 2),
-(659, 4, 48.5, '2018-05-20', 1, '104', 4),
-(660, 2, 41, '2018-05-20', 1, '104', 6),
-(661, 4, 39.5, '2018-05-20', 1, '104', 8),
-(662, 791, 39.685208596713, '2018-05-20', 2, '104', 2),
-(663, 4, 33, '2018-05-20', 2, '104', 4),
-(664, 3, 21, '2018-05-20', 2, '104', 6),
-(665, 2, 22.5, '2018-05-20', 2, '104', 8),
-(666, 4003, 47.602797901574, '2018-05-20', 1, '102', 2),
-(667, 23, 48.260869565217, '2018-05-20', 1, '102', 4),
-(668, 14, 44.071428571429, '2018-05-20', 1, '102', 6),
-(669, 15, 45.6, '2018-05-20', 1, '102', 8),
-(670, 2835, 40.379541446208, '2018-05-20', 2, '102', 2),
-(671, 21, 32.809523809524, '2018-05-20', 2, '102', 4),
-(672, 14, 21.142857142857, '2018-05-20', 2, '102', 6),
-(673, 4, 32.75, '2018-05-20', 2, '102', 8),
-(674, 1991, 32.957307885485, '2018-05-20', 1, '115', 2),
-(675, 6, 27, '2018-05-20', 1, '115', 4),
-(676, 3, 33.666666666667, '2018-05-20', 1, '115', 6),
-(677, 1, 30, '2018-05-20', 1, '115', 8),
-(678, 1832, 29.853165938865, '2018-05-20', 2, '115', 2),
-(679, 7, 19.571428571429, '2018-05-20', 2, '115', 4),
-(680, 3, 6.6666666666667, '2018-05-20', 2, '115', 6),
-(681, 2, 0, '2018-05-20', 2, '115', 8),
-(682, 517, 30.878143133462, '2018-05-20', 1, '090', 2),
-(683, 7, 31.142857142857, '2018-05-20', 1, '090', 4),
-(684, 2, 19, '2018-05-20', 1, '090', 6),
-(685, 1, 34, '2018-05-20', 1, '090', 8),
-(686, 282, 26.992907801418, '2018-05-20', 2, '090', 2),
-(687, 1, 29, '2018-05-20', 2, '090', 6),
-(688, 928, 46.621767241379, '2018-05-20', 1, '089', 2),
-(689, 9, 39.333333333333, '2018-05-20', 1, '089', 4),
-(690, 1, 51, '2018-05-20', 1, '089', 6),
-(691, 2, 43, '2018-05-20', 1, '089', 8),
-(692, 1021, 37.391772771792, '2018-05-20', 2, '089', 2),
-(693, 39, 18.923076923077, '2018-05-20', 2, '089', 4),
-(694, 8, 24.25, '2018-05-20', 2, '089', 6),
-(695, 55, 40.927272727273, '2018-05-20', 1, '066', 2),
-(696, 98, 25.816326530612, '2018-05-20', 2, '066', 2);
+INSERT INTO `zaznam_prum_den` (`vozidla_pocet`, `rychlost_prumer`, `datum`, `smer`, `zarizeni_id`, `vozidlo_id`) VALUES
+(6759, 42.284509542832, '2018-05-20', 1, '096', 2),
+(63, 33.15873015873, '2018-05-20', 1, '096', 4),
+(34, 29.852941176471, '2018-05-20', 1, '096', 6),
+(15, 35.533333333333, '2018-05-20', 1, '096', 8),
+(2512, 31.803742038217, '2018-05-20', 2, '096', 2),
+(723, 21.600276625173, '2018-05-20', 2, '096', 4),
+(39, 15.538461538462, '2018-05-20', 2, '096', 6),
+(28, 22.928571428571, '2018-05-20', 2, '096', 8),
+(7075, 44.723250883392, '2018-05-20', 1, '107', 2),
+(34, 46.911764705882, '2018-05-20', 1, '107', 4),
+(16, 43.75, '2018-05-20', 1, '107', 6),
+(21, 42.238095238095, '2018-05-20', 1, '107', 8),
+(5501, 44.735866206144, '2018-05-20', 2, '107', 2),
+(16, 30.375, '2018-05-20', 2, '107', 4),
+(30, 31, '2018-05-20', 2, '107', 6),
+(21, 44.142857142857, '2018-05-20', 2, '107', 8),
+(2075, 53.026024096386, '2018-05-20', 1, '123', 2),
+(20, 50.15, '2018-05-20', 1, '123', 4),
+(14, 50.714285714286, '2018-05-20', 1, '123', 6),
+(25, 47.04, '2018-05-20', 1, '123', 8),
+(2420, 58.268181818182, '2018-05-20', 2, '123', 2),
+(20, 24.2, '2018-05-20', 2, '123', 4),
+(10, 22.5, '2018-05-20', 2, '123', 6),
+(24, 32.916666666667, '2018-05-20', 2, '123', 8),
+(9821, 48.444964871194, '2018-05-20', 1, '051', 2),
+(14, 47.642857142857, '2018-05-20', 1, '051', 4),
+(42, 47.690476190476, '2018-05-20', 1, '051', 6),
+(24, 45.875, '2018-05-20', 1, '051', 8),
+(7777, 45.702584544169, '2018-05-20', 2, '051', 2),
+(7, 30, '2018-05-20', 2, '051', 4),
+(6, 7.6666666666667, '2018-05-20', 2, '051', 6),
+(4, 36.5, '2018-05-20', 2, '051', 8),
+(9711, 44.101019462465, '2018-05-20', 1, '100', 2),
+(138, 45.528985507246, '2018-05-20', 1, '100', 4),
+(45, 45.4, '2018-05-20', 1, '100', 6),
+(78, 44.269230769231, '2018-05-20', 1, '100', 8),
+(9085, 37.213208585581, '2018-05-20', 2, '100', 2),
+(140, 28.707142857143, '2018-05-20', 2, '100', 4),
+(73, 29.945205479452, '2018-05-20', 2, '100', 6),
+(43, 33.651162790698, '2018-05-20', 2, '100', 8),
+(11864, 47.591790289953, '2018-05-20', 1, '124', 2),
+(38, 48.657894736842, '2018-05-20', 1, '124', 4),
+(24, 46.875, '2018-05-20', 1, '124', 6),
+(42, 46.690476190476, '2018-05-20', 1, '124', 8),
+(6965, 42.445656855707, '2018-05-20', 2, '124', 2),
+(90, 29.077777777778, '2018-05-20', 2, '124', 4),
+(50, 23.68, '2018-05-20', 2, '124', 6),
+(34, 30, '2018-05-20', 2, '124', 8),
+(2, 66, '2018-05-20', 2, '076', 2),
+(10740, 48.088547486034, '2018-05-20', 1, '118', 2),
+(63, 46.412698412698, '2018-05-20', 1, '118', 4),
+(84, 48.130952380952, '2018-05-20', 1, '118', 6),
+(262, 49.103053435115, '2018-05-20', 1, '118', 8),
+(6770, 40.879911373708, '2018-05-20', 2, '118', 2),
+(49, 27.285714285714, '2018-05-20', 2, '118', 4),
+(33, 28.030303030303, '2018-05-20', 2, '118', 6),
+(92, 30.804347826087, '2018-05-20', 2, '118', 8),
+(12889, 48.135619520521, '2018-05-20', 1, '194', 2),
+(48, 47.645833333333, '2018-05-20', 1, '194', 4),
+(32, 50.25, '2018-05-20', 1, '194', 6),
+(138, 46.884057971014, '2018-05-20', 1, '194', 8),
+(4235, 49.578512396694, '2018-05-20', 2, '194', 2),
+(18, 36.555555555556, '2018-05-20', 2, '194', 4),
+(31, 27.741935483871, '2018-05-20', 2, '194', 6),
+(41, 31.80487804878, '2018-05-20', 2, '194', 8),
+(5221, 52.877992721701, '2018-05-20', 1, '203', 2),
+(2177, 73.354616444649, '2018-05-20', 2, '203', 2),
+(9088, 47.226012323944, '2018-05-20', 1, '052', 2),
+(36, 48.416666666667, '2018-05-20', 1, '052', 4),
+(1, 29, '2018-05-20', 1, '052', 6),
+(98, 46.367346938776, '2018-05-20', 1, '052', 8),
+(6414, 42.538197692548, '2018-05-20', 2, '052', 2),
+(45, 23.244444444444, '2018-05-20', 2, '052', 4),
+(21, 22.047619047619, '2018-05-20', 2, '052', 6),
+(18, 30.944444444444, '2018-05-20', 2, '052', 8),
+(9071, 47.353654503362, '2018-05-20', 1, '101', 2),
+(81, 47.16049382716, '2018-05-20', 1, '101', 4),
+(20, 46.55, '2018-05-20', 1, '101', 6),
+(167, 47.299401197605, '2018-05-20', 1, '101', 8),
+(9297, 45.218457566957, '2018-05-20', 2, '101', 2),
+(103, 29.941747572816, '2018-05-20', 2, '101', 4),
+(15, 26.733333333333, '2018-05-20', 2, '101', 6),
+(43, 31.488372093023, '2018-05-20', 2, '101', 8),
+(9724, 49.764397367339, '2018-05-20', 1, '191', 2),
+(20, 45.05, '2018-05-20', 1, '191', 4),
+(29, 52.172413793103, '2018-05-20', 1, '191', 6),
+(43, 50.186046511628, '2018-05-20', 1, '191', 8),
+(7460, 50.707774798928, '2018-05-20', 2, '191', 2),
+(52, 24.269230769231, '2018-05-20', 2, '191', 4),
+(40, 38.4, '2018-05-20', 2, '191', 6),
+(30, 37.7, '2018-05-20', 2, '191', 8),
+(13042, 50.897255022236, '2018-05-20', 1, '206', 2),
+(20, 52.65, '2018-05-20', 1, '206', 4),
+(8, 50.875, '2018-05-20', 1, '206', 6),
+(41, 46.829268292683, '2018-05-20', 1, '206', 8),
+(8781, 52.119918004783, '2018-05-20', 2, '206', 2),
+(26, 28.076923076923, '2018-05-20', 2, '206', 4),
+(13, 32.538461538462, '2018-05-20', 2, '206', 6),
+(31, 46.612903225806, '2018-05-20', 2, '206', 8),
+(1837, 51.350571584105, '2018-05-20', 1, '125', 2),
+(74, 51.621621621622, '2018-05-20', 1, '125', 4),
+(13, 45.615384615385, '2018-05-20', 1, '125', 6),
+(133, 46.744360902256, '2018-05-20', 1, '125', 8),
+(1138, 48.408611599297, '2018-05-20', 2, '125', 2),
+(85, 31.2, '2018-05-20', 2, '125', 4),
+(22, 34.681818181818, '2018-05-20', 2, '125', 6),
+(25, 18.28, '2018-05-20', 2, '125', 8),
+(19537, 49.594154680862, '2018-05-20', 1, '192', 2),
+(75, 48.333333333333, '2018-05-20', 1, '192', 4),
+(52, 49.653846153846, '2018-05-20', 1, '192', 6),
+(52, 48.788461538462, '2018-05-20', 1, '192', 8),
+(14574, 45.530602442706, '2018-05-20', 2, '192', 2),
+(112, 33.910714285714, '2018-05-20', 2, '192', 4),
+(59, 25.966101694915, '2018-05-20', 2, '192', 6),
+(84, 38.071428571429, '2018-05-20', 2, '192', 8),
+(12139, 46.328857401763, '2018-05-20', 1, '200', 2),
+(34, 52.794117647059, '2018-05-20', 1, '200', 4),
+(10, 46.6, '2018-05-20', 1, '200', 6),
+(25, 44.28, '2018-05-20', 1, '200', 8),
+(6398, 39.678180681463, '2018-05-20', 2, '200', 2),
+(39, 27.051282051282, '2018-05-20', 2, '200', 4),
+(23, 30.565217391304, '2018-05-20', 2, '200', 6),
+(25, 35.92, '2018-05-20', 2, '200', 8),
+(3445, 43.402031930334, '2018-05-20', 1, '072', 2),
+(39, 46.076923076923, '2018-05-20', 1, '072', 4),
+(11, 35.818181818182, '2018-05-20', 1, '072', 6),
+(29, 43.241379310345, '2018-05-20', 1, '072', 8),
+(4566, 40.307271134472, '2018-05-20', 2, '072', 2),
+(18, 42.666666666667, '2018-05-20', 2, '072', 4),
+(9, 37.444444444444, '2018-05-20', 2, '072', 6),
+(7, 37.857142857143, '2018-05-20', 2, '072', 8),
+(8135, 46.444253226798, '2018-05-20', 1, '063', 2),
+(19, 45.684210526316, '2018-05-20', 1, '063', 4),
+(6, 41.5, '2018-05-20', 1, '063', 6),
+(9, 34.888888888889, '2018-05-20', 1, '063', 8),
+(5746, 45.135224504003, '2018-05-20', 2, '063', 2),
+(100, 27.4, '2018-05-20', 2, '063', 4),
+(18, 37.111111111111, '2018-05-20', 2, '063', 6),
+(4, 25.75, '2018-05-20', 2, '063', 8),
+(10951, 49.610172586978, '2018-05-20', 1, '112', 2),
+(85, 48.423529411765, '2018-05-20', 1, '112', 4),
+(40, 45, '2018-05-20', 1, '112', 6),
+(90, 46.088888888889, '2018-05-20', 1, '112', 8),
+(5328, 47.863926426426, '2018-05-20', 2, '112', 2),
+(307, 32.231270358306, '2018-05-20', 2, '112', 4),
+(52, 30.192307692308, '2018-05-20', 2, '112', 6),
+(67, 32.731343283582, '2018-05-20', 2, '112', 8),
+(6336, 47.076231060606, '2018-05-20', 1, '081', 2),
+(2395, 49.55866388309, '2018-05-20', 2, '081', 2),
+(3010, 24.157142857143, '2018-05-20', 1, '069', 2),
+(34, 0, '2018-05-20', 1, '069', 4),
+(28, 0, '2018-05-20', 1, '069', 6),
+(30, 0, '2018-05-20', 1, '069', 8),
+(1509, 0, '2018-05-20', 2, '069', 2),
+(45, 0, '2018-05-20', 2, '069', 4),
+(47, 0, '2018-05-20', 2, '069', 6),
+(37, 0, '2018-05-20', 2, '069', 8),
+(7486, 45.779054234571, '2018-05-20', 1, '105', 2),
+(67, 44.776119402985, '2018-05-20', 1, '105', 4),
+(23, 40.95652173913, '2018-05-20', 1, '105', 6),
+(66, 43.363636363636, '2018-05-20', 1, '105', 8),
+(4174, 35.684475323431, '2018-05-20', 2, '105', 2),
+(20, 25.85, '2018-05-20', 2, '105', 4),
+(58, 22.120689655172, '2018-05-20', 2, '105', 6),
+(54, 18.407407407407, '2018-05-20', 2, '105', 8),
+(4092, 45.261241446725, '2018-05-20', 1, '134', 2),
+(9, 44.111111111111, '2018-05-20', 1, '134', 4),
+(17, 44.294117647059, '2018-05-20', 1, '134', 6),
+(17, 43.588235294118, '2018-05-20', 1, '134', 8),
+(3462, 42.559214326979, '2018-05-20', 2, '134', 2),
+(68, 23.588235294118, '2018-05-20', 2, '134', 4),
+(27, 26.407407407407, '2018-05-20', 2, '134', 6),
+(5, 26.8, '2018-05-20', 2, '134', 8),
+(5319, 44.409475465313, '2018-05-20', 1, '054', 2),
+(6, 44.666666666667, '2018-05-20', 1, '054', 4),
+(1, 35, '2018-05-20', 1, '054', 6),
+(4, 39, '2018-05-20', 1, '054', 8),
+(3403, 42.721422274464, '2018-05-20', 2, '054', 2),
+(10, 19, '2018-05-20', 2, '054', 4),
+(3, 0, '2018-05-20', 2, '054', 6),
+(4, 39.75, '2018-05-20', 2, '054', 8),
+(8533, 52.809328489394, '2018-05-20', 1, '126', 2),
+(31, 46.451612903226, '2018-05-20', 1, '126', 4),
+(31, 39.096774193548, '2018-05-20', 1, '126', 6),
+(19, 39.526315789474, '2018-05-20', 1, '126', 8),
+(5214, 36.463367855773, '2018-05-20', 2, '126', 2),
+(16, 28.1875, '2018-05-20', 2, '126', 4),
+(16, 19, '2018-05-20', 2, '126', 6),
+(13, 55.461538461538, '2018-05-20', 2, '126', 8),
+(16148, 41.546073817191, '2018-05-20', 1, '193', 2),
+(491, 40.997963340122, '2018-05-20', 1, '193', 4),
+(162, 41.876543209877, '2018-05-20', 1, '193', 6),
+(486, 41.592592592593, '2018-05-20', 1, '193', 8),
+(12501, 44.261979041677, '2018-05-20', 2, '193', 2),
+(160, 32.25625, '2018-05-20', 2, '193', 4),
+(67, 33.567164179104, '2018-05-20', 2, '193', 6),
+(73, 34.123287671233, '2018-05-20', 2, '193', 8),
+(14248, 48.512001684447, '2018-05-20', 1, '205', 2),
+(11, 51.272727272727, '2018-05-20', 1, '205', 4),
+(11, 50.090909090909, '2018-05-20', 1, '205', 6),
+(41, 54, '2018-05-20', 1, '205', 8),
+(9884, 44.923917442331, '2018-05-20', 2, '205', 2),
+(15, 28.333333333333, '2018-05-20', 2, '205', 4),
+(24, 17.833333333333, '2018-05-20', 2, '205', 6),
+(48, 36.270833333333, '2018-05-20', 2, '205', 8),
+(1845, 44.586449864499, '2018-05-20', 1, '061', 2),
+(20, 45.6, '2018-05-20', 1, '061', 4),
+(5, 52.8, '2018-05-20', 1, '061', 6),
+(11, 38.454545454545, '2018-05-20', 1, '061', 8),
+(1192, 34.25, '2018-05-20', 2, '061', 2),
+(21, 16.285714285714, '2018-05-20', 2, '061', 4),
+(12, 15.916666666667, '2018-05-20', 2, '061', 6),
+(9, 32.222222222222, '2018-05-20', 2, '061', 8),
+(1522, 46.831143232589, '2018-05-20', 1, '127', 2),
+(6, 43.833333333333, '2018-05-20', 1, '127', 4),
+(1, 48, '2018-05-20', 1, '127', 6),
+(6, 38.666666666667, '2018-05-20', 1, '127', 8),
+(1580, 42.976582278481, '2018-05-20', 2, '127', 2),
+(1, 38, '2018-05-20', 2, '127', 4),
+(3, 38, '2018-05-20', 2, '127', 6),
+(16, 41.1875, '2018-05-20', 2, '127', 8),
+(18933, 39.078645750805, '2018-05-20', 1, '109', 2),
+(24, 38.333333333333, '2018-05-20', 1, '109', 4),
+(40, 35.675, '2018-05-20', 1, '109', 6),
+(73, 36.684931506849, '2018-05-20', 1, '109', 8),
+(10036, 29.692008768434, '2018-05-20', 2, '109', 2),
+(42, 25.285714285714, '2018-05-20', 2, '109', 4),
+(53, 26.471698113208, '2018-05-20', 2, '109', 6),
+(58, 28.034482758621, '2018-05-20', 2, '109', 8),
+(1568, 47.938775510204, '2018-05-20', 1, '122', 2),
+(21, 47.809523809524, '2018-05-20', 1, '122', 4),
+(2, 51, '2018-05-20', 1, '122', 6),
+(13, 41.846153846154, '2018-05-20', 1, '122', 8),
+(1049, 47.804575786463, '2018-05-20', 2, '122', 2),
+(17, 11.823529411765, '2018-05-20', 2, '122', 4),
+(5, 20.4, '2018-05-20', 2, '122', 6),
+(4, 28.5, '2018-05-20', 2, '122', 8),
+(8581, 43.664025171891, '2018-05-20', 1, '092', 2),
+(37, 47.432432432432, '2018-05-20', 1, '092', 4),
+(6, 49.833333333333, '2018-05-20', 1, '092', 6),
+(22, 44.181818181818, '2018-05-20', 1, '092', 8),
+(6365, 40.557109190888, '2018-05-20', 2, '092', 2),
+(11, 31.181818181818, '2018-05-20', 2, '092', 4),
+(5, 34.8, '2018-05-20', 2, '092', 6),
+(8, 42.125, '2018-05-20', 2, '092', 8),
+(5595, 42.910813226095, '2018-05-20', 1, '114', 2),
+(498, 42.859437751004, '2018-05-20', 1, '114', 4),
+(50, 41.8, '2018-05-20', 1, '114', 6),
+(22, 42.590909090909, '2018-05-20', 1, '114', 8),
+(3431, 40.843194403964, '2018-05-20', 2, '114', 2),
+(141, 28.510638297872, '2018-05-20', 2, '114', 4),
+(86, 27.488372093023, '2018-05-20', 2, '114', 6),
+(11, 10.090909090909, '2018-05-20', 2, '114', 8),
+(5124, 42.202966432475, '2018-05-20', 1, '097', 2),
+(19, 43.842105263158, '2018-05-20', 1, '097', 4),
+(7, 55.142857142857, '2018-05-20', 1, '097', 6),
+(17, 41.647058823529, '2018-05-20', 1, '097', 8),
+(3720, 39.529569892473, '2018-05-20', 2, '097', 2),
+(23, 28.782608695652, '2018-05-20', 2, '097', 4),
+(3, 26, '2018-05-20', 2, '097', 6),
+(4, 41.5, '2018-05-20', 2, '097', 8),
+(766, 49.323759791123, '2018-05-20', 1, '117', 2),
+(8, 49.875, '2018-05-20', 1, '117', 4),
+(3, 44.666666666667, '2018-05-20', 1, '117', 6),
+(138, 48.608695652174, '2018-05-20', 1, '117', 8),
+(734, 44.905994550409, '2018-05-20', 2, '117', 2),
+(6, 38.666666666667, '2018-05-20', 2, '117', 4),
+(5, 18.8, '2018-05-20', 2, '117', 6),
+(40, 28.325, '2018-05-20', 2, '117', 8),
+(3670, 23.965940054496, '2018-05-20', 1, '130', 2),
+(29, 19.068965517241, '2018-05-20', 1, '130', 4),
+(3, 14.333333333333, '2018-05-20', 1, '130', 6),
+(2, 18, '2018-05-20', 1, '130', 8),
+(1606, 43.427148194271, '2018-05-20', 2, '130', 2),
+(14014, 49.563436563437, '2018-05-20', 1, '086', 2),
+(87, 49.540229885057, '2018-05-20', 1, '086', 4),
+(49, 51, '2018-05-20', 1, '086', 6),
+(29, 43.724137931034, '2018-05-20', 1, '086', 8),
+(10786, 46.038661227517, '2018-05-20', 2, '086', 2),
+(27, 35.074074074074, '2018-05-20', 2, '086', 4),
+(22, 43.227272727273, '2018-05-20', 2, '086', 6),
+(34, 32.911764705882, '2018-05-20', 2, '086', 8),
+(6294, 42.495392437242, '2018-05-20', 1, '110', 2),
+(82, 39.536585365854, '2018-05-20', 1, '110', 4),
+(29, 37.655172413793, '2018-05-20', 1, '110', 6),
+(9, 31.888888888889, '2018-05-20', 1, '110', 8),
+(4536, 38.434082892416, '2018-05-20', 2, '110', 2),
+(107, 15.532710280374, '2018-05-20', 2, '110', 4),
+(37, 19.27027027027, '2018-05-20', 2, '110', 6),
+(10, 26.2, '2018-05-20', 2, '110', 8),
+(3839, 36.425371190414, '2018-05-20', 1, '133', 2),
+(646, 36.363777089783, '2018-05-20', 2, '133', 2),
+(2520, 39.661507936508, '2018-05-20', 1, '099', 2),
+(1, 42, '2018-05-20', 1, '099', 4),
+(10, 39.5, '2018-05-20', 1, '099', 8),
+(1795, 44.769359331476, '2018-05-20', 2, '099', 2),
+(4, 9, '2018-05-20', 2, '099', 4),
+(4, 10.75, '2018-05-20', 2, '099', 6),
+(2, 0, '2018-05-20', 2, '099', 8),
+(1150, 43.31652173913, '2018-05-20', 1, '068', 2),
+(40, 45.75, '2018-05-20', 1, '068', 4),
+(3, 42, '2018-05-20', 1, '068', 6),
+(12, 41, '2018-05-20', 1, '068', 8),
+(913, 39.697699890471, '2018-05-20', 2, '068', 2),
+(3, 8.3333333333333, '2018-05-20', 2, '068', 4),
+(4, 20, '2018-05-20', 2, '068', 6),
+(4138, 44.370710488159, '2018-05-20', 1, '073', 2),
+(80, 40.2875, '2018-05-20', 1, '073', 4),
+(24, 36.708333333333, '2018-05-20', 1, '073', 6),
+(21, 36.047619047619, '2018-05-20', 1, '073', 8),
+(2058, 29.938775510204, '2018-05-20', 2, '073', 2),
+(253, 13.04743083004, '2018-05-20', 2, '073', 4),
+(33, 16.242424242424, '2018-05-20', 2, '073', 6),
+(22, 18.045454545455, '2018-05-20', 2, '073', 8),
+(10075, 48.793349875931, '2018-05-20', 1, '199', 2),
+(78, 47.628205128205, '2018-05-20', 1, '199', 4),
+(74, 46.283783783784, '2018-05-20', 1, '199', 6),
+(31, 47.387096774194, '2018-05-20', 1, '199', 8),
+(7214, 39.343637371777, '2018-05-20', 2, '199', 2),
+(369, 26.311653116531, '2018-05-20', 2, '199', 4),
+(92, 26.586956521739, '2018-05-20', 2, '199', 6),
+(53, 36.11320754717, '2018-05-20', 2, '199', 8),
+(12088, 46.285572468564, '2018-05-20', 1, '196', 2),
+(8, 44.75, '2018-05-20', 1, '196', 4),
+(12, 48, '2018-05-20', 1, '196', 6),
+(101, 45.50495049505, '2018-05-20', 1, '196', 8),
+(10448, 43.54039050536, '2018-05-20', 2, '196', 2),
+(31, 38.806451612903, '2018-05-20', 2, '196', 4),
+(23, 11.782608695652, '2018-05-20', 2, '196', 6),
+(54, 32.962962962963, '2018-05-20', 2, '196', 8),
+(1802, 40.253607103219, '2018-05-20', 1, '121', 2),
+(1446, 39.69571230982, '2018-05-20', 2, '121', 2),
+(3141, 47.083094555874, '2018-05-20', 1, '128', 2),
+(22, 48.5, '2018-05-20', 1, '128', 4),
+(10, 46.8, '2018-05-20', 1, '128', 6),
+(18, 45.666666666667, '2018-05-20', 1, '128', 8),
+(2934, 48.255282890252, '2018-05-20', 2, '128', 2),
+(12, 22.5, '2018-05-20', 2, '128', 4),
+(14, 18.928571428571, '2018-05-20', 2, '128', 6),
+(36, 23.027777777778, '2018-05-20', 2, '128', 8),
+(8500, 46.697764705882, '2018-05-20', 1, '095', 2),
+(21, 46.285714285714, '2018-05-20', 1, '095', 4),
+(6, 48.166666666667, '2018-05-20', 1, '095', 6),
+(35, 44.314285714286, '2018-05-20', 1, '095', 8),
+(6630, 39.897737556561, '2018-05-20', 2, '095', 2),
+(40, 32.425, '2018-05-20', 2, '095', 4),
+(17, 20.647058823529, '2018-05-20', 2, '095', 6),
+(17, 31.058823529412, '2018-05-20', 2, '095', 8),
+(5668, 45.871030345801, '2018-05-20', 1, '094', 2),
+(20, 44.9, '2018-05-20', 1, '094', 4),
+(6, 41.333333333333, '2018-05-20', 1, '094', 6),
+(20, 43.3, '2018-05-20', 1, '094', 8),
+(5098, 47.743232640251, '2018-05-20', 2, '094', 2),
+(45, 29, '2018-05-20', 2, '094', 4),
+(13, 22.615384615385, '2018-05-20', 2, '094', 6),
+(12, 23, '2018-05-20', 2, '094', 8),
+(1022, 19.47553816047, '2018-05-20', 1, '055', 2),
+(2, 0, '2018-05-20', 1, '055', 4),
+(2, 0, '2018-05-20', 1, '055', 6),
+(19, 0, '2018-05-20', 1, '055', 8),
+(599, 0, '2018-05-20', 2, '055', 2),
+(1, 0, '2018-05-20', 2, '055', 4),
+(3, 0, '2018-05-20', 2, '055', 6),
+(3, 0, '2018-05-20', 2, '055', 8),
+(6792, 44.60777385159, '2018-05-20', 1, '201', 2),
+(9, 43.333333333333, '2018-05-20', 1, '201', 4),
+(24, 38.916666666667, '2018-05-20', 1, '201', 6),
+(22, 37, '2018-05-20', 1, '201', 8),
+(5043, 38.138211382114, '2018-05-20', 2, '201', 2),
+(13, 24.615384615385, '2018-05-20', 2, '201', 4),
+(16, 30.9375, '2018-05-20', 2, '201', 6),
+(25, 30.04, '2018-05-20', 2, '201', 8),
+(12928, 52.989248143564, '2018-05-20', 1, '204', 2),
+(44, 48.090909090909, '2018-05-20', 1, '204', 4),
+(45, 49.066666666667, '2018-05-20', 1, '204', 6),
+(112, 49.696428571429, '2018-05-20', 1, '204', 8),
+(16587, 51.860372580937, '2018-05-20', 2, '204', 2),
+(340, 38.123529411765, '2018-05-20', 2, '204', 4),
+(210, 35.9, '2018-05-20', 2, '204', 6),
+(104, 38.576923076923, '2018-05-20', 2, '204', 8),
+(8667, 45.234914041768, '2018-05-20', 1, '106', 2),
+(18, 45.166666666667, '2018-05-20', 1, '106', 4),
+(21, 47.190476190476, '2018-05-20', 1, '106', 6),
+(55, 46.163636363636, '2018-05-20', 1, '106', 8),
+(7842, 42.176613108901, '2018-05-20', 2, '106', 2),
+(33, 31.939393939394, '2018-05-20', 2, '106', 4),
+(54, 23.407407407407, '2018-05-20', 2, '106', 6),
+(39, 30.051282051282, '2018-05-20', 2, '106', 8),
+(6803, 46.324709686903, '2018-05-20', 1, '082', 2),
+(46, 45.630434782609, '2018-05-20', 1, '082', 4),
+(55, 48.6, '2018-05-20', 1, '082', 6),
+(66, 45.893939393939, '2018-05-20', 1, '082', 8),
+(4631, 35.4867199309, '2018-05-20', 2, '082', 2),
+(35, 25.057142857143, '2018-05-20', 2, '082', 4),
+(35, 26.342857142857, '2018-05-20', 2, '082', 6),
+(59, 23.152542372881, '2018-05-20', 2, '082', 8),
+(6954, 48.428242737993, '2018-05-20', 1, '111', 2),
+(34, 48.029411764706, '2018-05-20', 1, '111', 4),
+(34, 45.176470588235, '2018-05-20', 1, '111', 6),
+(55, 43.345454545455, '2018-05-20', 1, '111', 8),
+(4932, 47.715531224655, '2018-05-20', 2, '111', 2),
+(53, 27.849056603774, '2018-05-20', 2, '111', 4),
+(64, 26.25, '2018-05-20', 2, '111', 6),
+(66, 21.19696969697, '2018-05-20', 2, '111', 8),
+(5397, 50.982212340189, '2018-05-20', 1, '084', 2),
+(30, 48.6, '2018-05-20', 1, '084', 4),
+(5, 36.6, '2018-05-20', 1, '084', 6),
+(37, 39.837837837838, '2018-05-20', 1, '084', 8),
+(3212, 42.324719800747, '2018-05-20', 2, '084', 2),
+(14, 27.5, '2018-05-20', 2, '084', 4),
+(13, 18.769230769231, '2018-05-20', 2, '084', 6),
+(26, 39.730769230769, '2018-05-20', 2, '084', 8),
+(5058, 43.734480031633, '2018-05-20', 1, '062', 2),
+(1, 41, '2018-05-20', 1, '062', 4),
+(8, 38.625, '2018-05-20', 1, '062', 6),
+(33, 39.909090909091, '2018-05-20', 1, '062', 8),
+(4288, 41.943097014925, '2018-05-20', 2, '062', 2),
+(21, 31.952380952381, '2018-05-20', 2, '062', 4),
+(17, 25.705882352941, '2018-05-20', 2, '062', 6),
+(4, 25.25, '2018-05-20', 2, '062', 8),
+(2413, 49.86241193535, '2018-05-20', 1, '132', 2),
+(1, 48, '2018-05-20', 1, '132', 4),
+(3, 49.333333333333, '2018-05-20', 1, '132', 6),
+(1, 41, '2018-05-20', 1, '132', 8),
+(2158, 40.799814643188, '2018-05-20', 2, '132', 2),
+(1, 20, '2018-05-20', 2, '132', 4),
+(3, 0, '2018-05-20', 2, '132', 6),
+(3126, 46.50575815739, '2018-05-20', 1, '136', 2),
+(33, 43.393939393939, '2018-05-20', 1, '136', 4),
+(6, 43.333333333333, '2018-05-20', 1, '136', 6),
+(35, 43.942857142857, '2018-05-20', 1, '136', 8),
+(2613, 47.346727898967, '2018-05-20', 2, '136', 2),
+(9, 15.888888888889, '2018-05-20', 2, '136', 4),
+(4, 19.75, '2018-05-20', 2, '136', 6),
+(16, 33.25, '2018-05-20', 2, '136', 8),
+(1990, 40.204522613065, '2018-05-20', 1, '056', 2),
+(5, 36.6, '2018-05-20', 1, '056', 4),
+(3, 35.666666666667, '2018-05-20', 1, '056', 6),
+(23, 36.869565217391, '2018-05-20', 1, '056', 8),
+(1456, 31.87293956044, '2018-05-20', 2, '056', 2),
+(10, 20.3, '2018-05-20', 2, '056', 4),
+(4, 14.75, '2018-05-20', 2, '056', 6),
+(2, 21.5, '2018-05-20', 2, '056', 8),
+(4833, 48.936892199462, '2018-05-20', 1, '057', 2),
+(33, 48.030303030303, '2018-05-20', 1, '057', 4),
+(14, 46.285714285714, '2018-05-20', 1, '057', 6),
+(33, 44.878787878788, '2018-05-20', 1, '057', 8),
+(2234, 44.579230080573, '2018-05-20', 2, '057', 2),
+(7, 42.142857142857, '2018-05-20', 2, '057', 4),
+(4, 17.5, '2018-05-20', 2, '057', 6),
+(3, 61.333333333333, '2018-05-20', 2, '057', 8),
+(1380, 43.426811594203, '2018-05-20', 1, '065', 2),
+(5, 42.4, '2018-05-20', 1, '065', 4),
+(3, 39.333333333333, '2018-05-20', 1, '065', 6),
+(3, 38.666666666667, '2018-05-20', 1, '065', 8),
+(1028, 32.790856031128, '2018-05-20', 2, '065', 2),
+(40, 15.65, '2018-05-20', 2, '065', 4),
+(14, 14, '2018-05-20', 2, '065', 6),
+(10213, 45.497796925487, '2018-05-20', 1, '059', 2),
+(32, 47.375, '2018-05-20', 1, '059', 4),
+(6, 45.166666666667, '2018-05-20', 1, '059', 6),
+(162, 44.895061728395, '2018-05-20', 1, '059', 8),
+(9181, 37.068837817231, '2018-05-20', 2, '059', 2),
+(81, 18.271604938272, '2018-05-20', 2, '059', 4),
+(49, 19.163265306122, '2018-05-20', 2, '059', 6),
+(30, 31.2, '2018-05-20', 2, '059', 8),
+(9887, 48.612218064125, '2018-05-20', 1, '198', 2),
+(22, 45.409090909091, '2018-05-20', 1, '198', 4),
+(46, 47.869565217391, '2018-05-20', 1, '198', 6),
+(10, 46.8, '2018-05-20', 1, '198', 8),
+(6510, 53.404301075269, '2018-05-20', 2, '198', 2),
+(1603, 25.306924516532, '2018-05-20', 2, '198', 4),
+(394, 24.969543147208, '2018-05-20', 2, '198', 6),
+(43, 29.558139534884, '2018-05-20', 2, '198', 8),
+(242, 25.173553719008, '2018-05-20', 1, '078', 2),
+(149, 15.114093959732, '2018-05-20', 2, '078', 2),
+(1794, 43.229096989967, '2018-05-20', 1, '071', 2),
+(13, 45.307692307692, '2018-05-20', 1, '071', 4),
+(1, 39, '2018-05-20', 1, '071', 6),
+(17, 40.823529411765, '2018-05-20', 1, '071', 8),
+(1416, 37.727401129944, '2018-05-20', 2, '071', 2),
+(1, 56, '2018-05-20', 2, '071', 8),
+(2379, 62.196721311475, '2018-05-20', 1, '060', 2),
+(16, 60, '2018-05-20', 1, '060', 4),
+(14, 52.142857142857, '2018-05-20', 1, '060', 6),
+(1, 67, '2018-05-20', 1, '060', 8),
+(2193, 51.091199270406, '2018-05-20', 2, '060', 2),
+(21, 23.904761904762, '2018-05-20', 2, '060', 4),
+(17, 39.529411764706, '2018-05-20', 2, '060', 6),
+(4, 22.75, '2018-05-20', 2, '060', 8),
+(9334, 47.721127062353, '2018-05-20', 1, '103', 2),
+(51, 46.450980392157, '2018-05-20', 1, '103', 4),
+(48, 49.0625, '2018-05-20', 1, '103', 6),
+(34, 42.558823529412, '2018-05-20', 1, '103', 8),
+(7950, 43.954716981132, '2018-05-20', 2, '103', 2),
+(105, 30.590476190476, '2018-05-20', 2, '103', 4),
+(55, 32.454545454545, '2018-05-20', 2, '103', 6),
+(20, 27.8, '2018-05-20', 2, '103', 8),
+(7537, 47.604219185352, '2018-05-20', 1, '113', 2),
+(9, 51.444444444444, '2018-05-20', 1, '113', 4),
+(17, 50.176470588235, '2018-05-20', 1, '113', 6),
+(48, 48.291666666667, '2018-05-20', 1, '113', 8),
+(5327, 37.439271635067, '2018-05-20', 2, '113', 2),
+(15, 27.266666666667, '2018-05-20', 2, '113', 4),
+(24, 16.708333333333, '2018-05-20', 2, '113', 6),
+(32, 30.0625, '2018-05-20', 2, '113', 8),
+(1929, 37.439606013478, '2018-05-20', 1, '087', 2),
+(12, 39, '2018-05-20', 1, '087', 4),
+(9, 37.555555555556, '2018-05-20', 1, '087', 8),
+(1925, 30.925194805195, '2018-05-20', 2, '087', 2),
+(2, 6.5, '2018-05-20', 2, '087', 6),
+(1, 31, '2018-05-20', 2, '087', 8),
+(5926, 47.180053999325, '2018-05-20', 1, '075', 2),
+(21, 45.571428571429, '2018-05-20', 1, '075', 4),
+(17, 44.882352941176, '2018-05-20', 1, '075', 6),
+(19, 46, '2018-05-20', 1, '075', 8),
+(5438, 39.231702831923, '2018-05-20', 2, '075', 2),
+(37, 18.72972972973, '2018-05-20', 2, '075', 4),
+(35, 20.771428571429, '2018-05-20', 2, '075', 6),
+(24, 32, '2018-05-20', 2, '075', 8),
+(4855, 46.315139031926, '2018-05-20', 1, '058', 2),
+(12, 43.583333333333, '2018-05-20', 1, '058', 4),
+(3, 36.333333333333, '2018-05-20', 1, '058', 6),
+(29, 47, '2018-05-20', 1, '058', 8),
+(4267, 40.309116475275, '2018-05-20', 2, '058', 2),
+(18, 20.888888888889, '2018-05-20', 2, '058', 4),
+(9, 19.111111111111, '2018-05-20', 2, '058', 6),
+(7, 30.571428571429, '2018-05-20', 2, '058', 8),
+(6942, 48.832180927687, '2018-05-20', 1, '195', 2),
+(19, 48.947368421053, '2018-05-20', 1, '195', 4),
+(5, 40, '2018-05-20', 1, '195', 6),
+(32, 47.15625, '2018-05-20', 1, '195', 8),
+(5386, 42.088934274044, '2018-05-20', 2, '195', 2),
+(57, 27.929824561404, '2018-05-20', 2, '195', 4),
+(29, 26.758620689655, '2018-05-20', 2, '195', 6),
+(39, 31.25641025641, '2018-05-20', 2, '195', 8),
+(1413, 48.524416135881, '2018-05-20', 1, '131', 2),
+(5, 42.2, '2018-05-20', 1, '131', 4),
+(20, 45.2, '2018-05-20', 1, '131', 8),
+(929, 41.501614639397, '2018-05-20', 2, '131', 2),
+(8, 23.25, '2018-05-20', 2, '131', 4),
+(3, 11.333333333333, '2018-05-20', 2, '131', 6),
+(4, 38, '2018-05-20', 2, '131', 8),
+(4075, 42.564417177914, '2018-05-20', 1, '129', 2),
+(10, 37.1, '2018-05-20', 1, '129', 4),
+(5, 31.2, '2018-05-20', 1, '129', 6),
+(2, 32.5, '2018-05-20', 1, '129', 8),
+(3854, 39.928386092372, '2018-05-20', 2, '129', 2),
+(21, 24.142857142857, '2018-05-20', 2, '129', 4),
+(13, 20.461538461538, '2018-05-20', 2, '129', 6),
+(3, 49.333333333333, '2018-05-20', 2, '129', 8),
+(625, 0, '2018-05-20', 1, '083', 2),
+(7, 0, '2018-05-20', 1, '083', 4),
+(4, 0, '2018-05-20', 1, '083', 6),
+(9, 0, '2018-05-20', 1, '083', 8),
+(788, 0, '2018-05-20', 2, '083', 2),
+(1, 0, '2018-05-20', 2, '083', 4),
+(13, 0, '2018-05-20', 2, '083', 6),
+(8, 0, '2018-05-20', 2, '083', 8),
+(1754, 46.469783352338, '2018-05-20', 1, '091', 2),
+(6, 47.833333333333, '2018-05-20', 1, '091', 4),
+(11, 44.636363636364, '2018-05-20', 1, '091', 6),
+(6, 41.5, '2018-05-20', 1, '091', 8),
+(1256, 40.180732484076, '2018-05-20', 2, '091', 2),
+(22, 27.272727272727, '2018-05-20', 2, '091', 4),
+(9, 18.333333333333, '2018-05-20', 2, '091', 6),
+(4, 17, '2018-05-20', 2, '091', 8),
+(3065, 44.14779771615, '2018-05-20', 1, '202', 2),
+(3, 52.333333333333, '2018-05-20', 1, '202', 4),
+(21, 41.238095238095, '2018-05-20', 1, '202', 8),
+(2575, 42.126990291262, '2018-05-20', 2, '202', 2),
+(1, 0, '2018-05-20', 2, '202', 4),
+(5, 28.6, '2018-05-20', 2, '202', 6),
+(7, 47.571428571429, '2018-05-20', 2, '202', 8),
+(3623, 43.553132762904, '2018-05-20', 1, '135', 2),
+(17, 43.235294117647, '2018-05-20', 1, '135', 4),
+(2, 39, '2018-05-20', 1, '135', 6),
+(15, 35, '2018-05-20', 1, '135', 8),
+(2447, 34.178994687372, '2018-05-20', 2, '135', 2),
+(31, 20.129032258065, '2018-05-20', 2, '135', 4),
+(12, 14.583333333333, '2018-05-20', 2, '135', 6),
+(15, 22.733333333333, '2018-05-20', 2, '135', 8),
+(2453, 47.473705666531, '2018-05-20', 1, '120', 2),
+(11, 48.363636363636, '2018-05-20', 1, '120', 4),
+(7, 47, '2018-05-20', 1, '120', 6),
+(15, 44.933333333333, '2018-05-20', 1, '120', 8),
+(1485, 41.398653198653, '2018-05-20', 2, '120', 2),
+(36, 17.25, '2018-05-20', 2, '120', 4),
+(14, 20.428571428571, '2018-05-20', 2, '120', 6),
+(4, 33.5, '2018-05-20', 2, '120', 8),
+(1924, 34.283783783784, '2018-05-20', 1, '088', 2),
+(6, 33.333333333333, '2018-05-20', 1, '088', 4),
+(5, 38, '2018-05-20', 1, '088', 6),
+(1232, 35.254058441558, '2018-05-20', 2, '088', 2),
+(76, 17.789473684211, '2018-05-20', 2, '088', 4),
+(9, 28.777777777778, '2018-05-20', 2, '088', 6),
+(5, 26, '2018-05-20', 2, '088', 8),
+(1434, 41.903068340307, '2018-05-20', 1, '064', 2),
+(4, 25.75, '2018-05-20', 1, '064', 6),
+(35, 46.314285714286, '2018-05-20', 1, '064', 8),
+(1081, 36.369102682701, '2018-05-20', 2, '064', 2),
+(1, 0, '2018-05-20', 2, '064', 4),
+(4, 39.75, '2018-05-20', 2, '064', 6),
+(1, 30, '2018-05-20', 2, '064', 8),
+(2392, 48.484531772575, '2018-05-20', 1, '093', 2),
+(7, 49.142857142857, '2018-05-20', 1, '093', 4),
+(10, 44.3, '2018-05-20', 1, '093', 6),
+(13, 44.769230769231, '2018-05-20', 1, '093', 8),
+(1757, 43.182697780307, '2018-05-20', 2, '093', 2),
+(46, 26.608695652174, '2018-05-20', 2, '093', 4),
+(15, 20.2, '2018-05-20', 2, '093', 6),
+(9, 18.777777777778, '2018-05-20', 2, '093', 8),
+(766, 49.293733681462, '2018-05-20', 1, '077', 2),
+(4, 45.25, '2018-05-20', 1, '077', 4),
+(2, 49.5, '2018-05-20', 1, '077', 6),
+(2, 50, '2018-05-20', 1, '077', 8),
+(511, 35.3228962818, '2018-05-20', 2, '077', 2),
+(3, 38.666666666667, '2018-05-20', 2, '077', 4),
+(2868, 31.097280334728, '2018-05-20', 1, '108', 2),
+(16, 32.875, '2018-05-20', 1, '108', 4),
+(3, 32, '2018-05-20', 1, '108', 6),
+(5, 25.8, '2018-05-20', 1, '108', 8),
+(2228, 26.108168761221, '2018-05-20', 2, '108', 2),
+(17, 21.117647058824, '2018-05-20', 2, '108', 4),
+(6, 4.3333333333333, '2018-05-20', 2, '108', 6),
+(5, 25.2, '2018-05-20', 2, '108', 8),
+(1901, 42.588111520252, '2018-05-20', 1, '119', 2),
+(14, 42.857142857143, '2018-05-20', 1, '119', 4),
+(9, 38.444444444444, '2018-05-20', 1, '119', 6),
+(11, 37.272727272727, '2018-05-20', 1, '119', 8),
+(1456, 41.980082417582, '2018-05-20', 2, '119', 2),
+(15, 23.733333333333, '2018-05-20', 2, '119', 4),
+(4, 17.25, '2018-05-20', 2, '119', 6),
+(6, 24.333333333333, '2018-05-20', 2, '119', 8),
+(1959, 53.086268504339, '2018-05-20', 1, '074', 2),
+(9, 45.333333333333, '2018-05-20', 1, '074', 4),
+(12, 50.583333333333, '2018-05-20', 1, '074', 6),
+(6, 46.5, '2018-05-20', 1, '074', 8),
+(1266, 47.185624012638, '2018-05-20', 2, '074', 2),
+(20, 12.9, '2018-05-20', 2, '074', 4),
+(7, 19.142857142857, '2018-05-20', 2, '074', 6),
+(4, 49, '2018-05-20', 2, '074', 8),
+(1968, 45.131097560976, '2018-05-20', 1, '067', 2),
+(12, 38.75, '2018-05-20', 1, '067', 4),
+(2, 21, '2018-05-20', 1, '067', 6),
+(10, 34.7, '2018-05-20', 1, '067', 8),
+(1351, 32.59881569208, '2018-05-20', 2, '067', 2),
+(5, 5.8, '2018-05-20', 2, '067', 6),
+(4, 23.5, '2018-05-20', 2, '067', 8),
+(2286, 49.347769028871, '2018-05-20', 1, '070', 2),
+(13, 46.230769230769, '2018-05-20', 1, '070', 4),
+(8, 36.125, '2018-05-20', 1, '070', 6),
+(20, 48, '2018-05-20', 1, '070', 8),
+(1632, 49.178921568627, '2018-05-20', 2, '070', 2),
+(27, 28.111111111111, '2018-05-20', 2, '070', 4),
+(25, 21.52, '2018-05-20', 2, '070', 6),
+(8, 28.5, '2018-05-20', 2, '070', 8),
+(603, 48.117744610282, '2018-05-20', 1, '104', 2),
+(4, 48.5, '2018-05-20', 1, '104', 4),
+(2, 41, '2018-05-20', 1, '104', 6),
+(4, 39.5, '2018-05-20', 1, '104', 8),
+(791, 39.685208596713, '2018-05-20', 2, '104', 2),
+(4, 33, '2018-05-20', 2, '104', 4),
+(3, 21, '2018-05-20', 2, '104', 6),
+(2, 22.5, '2018-05-20', 2, '104', 8),
+(4003, 47.602797901574, '2018-05-20', 1, '102', 2),
+(23, 48.260869565217, '2018-05-20', 1, '102', 4),
+(14, 44.071428571429, '2018-05-20', 1, '102', 6),
+(15, 45.6, '2018-05-20', 1, '102', 8),
+(2835, 40.379541446208, '2018-05-20', 2, '102', 2),
+(21, 32.809523809524, '2018-05-20', 2, '102', 4),
+(14, 21.142857142857, '2018-05-20', 2, '102', 6),
+(4, 32.75, '2018-05-20', 2, '102', 8),
+(1991, 32.957307885485, '2018-05-20', 1, '115', 2),
+(6, 27, '2018-05-20', 1, '115', 4),
+(3, 33.666666666667, '2018-05-20', 1, '115', 6),
+(1, 30, '2018-05-20', 1, '115', 8),
+(1832, 29.853165938865, '2018-05-20', 2, '115', 2),
+(7, 19.571428571429, '2018-05-20', 2, '115', 4),
+(3, 6.6666666666667, '2018-05-20', 2, '115', 6),
+(2, 0, '2018-05-20', 2, '115', 8),
+(517, 30.878143133462, '2018-05-20', 1, '090', 2),
+(7, 31.142857142857, '2018-05-20', 1, '090', 4),
+(2, 19, '2018-05-20', 1, '090', 6),
+(1, 34, '2018-05-20', 1, '090', 8),
+(282, 26.992907801418, '2018-05-20', 2, '090', 2),
+(1, 29, '2018-05-20', 2, '090', 6),
+(928, 46.621767241379, '2018-05-20', 1, '089', 2),
+(9, 39.333333333333, '2018-05-20', 1, '089', 4),
+(1, 51, '2018-05-20', 1, '089', 6),
+(2, 43, '2018-05-20', 1, '089', 8),
+(1021, 37.391772771792, '2018-05-20', 2, '089', 2),
+(39, 18.923076923077, '2018-05-20', 2, '089', 4),
+(8, 24.25, '2018-05-20', 2, '089', 6),
+(55, 40.927272727273, '2018-05-20', 1, '066', 2),
+(98, 25.816326530612, '2018-05-20', 2, '066', 2);
 
 
 INSERT INTO `zaznam_cas` (`id`, `datetime_od`, `datetime_do`, `smer`, `zarizeni_id`) VALUES
-(1, '2018-05-20 00:00:00', '2018-05-20 00:15:00', 1, '096'),
-(2, '2018-05-20 00:00:00', '2018-05-20 00:15:00', 2, '096'),
-(3, '2018-05-20 00:15:00', '2018-05-20 00:30:00', 1, '096'),
-(4, '2018-05-20 00:15:00', '2018-05-20 00:30:00', 2, '096'),
-(5, '2018-05-20 00:30:00', '2018-05-20 00:45:00', 1, '096'),
-(6, '2018-05-20 00:30:00', '2018-05-20 00:45:00', 2, '096'),
-(7, '2018-05-20 00:45:00', '2018-05-20 01:00:00', 1, '096'),
-(8, '2018-05-20 00:45:00', '2018-05-20 01:00:00', 2, '096'),
-(9, '2018-05-20 01:00:00', '2018-05-20 01:15:00', 1, '096'),
-(10, '2018-05-20 01:00:00', '2018-05-20 01:15:00', 2, '096'),
-(11, '2018-05-20 01:15:00', '2018-05-20 01:30:00', 1, '096'),
-(12, '2018-05-20 01:15:00', '2018-05-20 01:30:00', 2, '096'),
-(13, '2018-05-20 01:30:00', '2018-05-20 01:45:00', 1, '096'),
-(14, '2018-05-20 01:30:00', '2018-05-20 01:45:00', 2, '096'),
-(15, '2018-05-20 01:45:00', '2018-05-20 02:00:00', 1, '096'),
-(16, '2018-05-20 01:45:00', '2018-05-20 02:00:00', 2, '096'),
-(17, '2018-05-20 02:00:00', '2018-05-20 02:15:00', 1, '096'),
-(18, '2018-05-20 02:00:00', '2018-05-20 02:15:00', 2, '096'),
-(19, '2018-05-20 02:15:00', '2018-05-20 02:30:00', 1, '096'),
-(20, '2018-05-20 02:15:00', '2018-05-20 02:30:00', 2, '096'),
-(21, '2018-05-20 02:30:00', '2018-05-20 02:45:00', 1, '096'),
-(22, '2018-05-20 02:30:00', '2018-05-20 02:45:00', 2, '096'),
-(23, '2018-05-20 02:45:00', '2018-05-20 03:00:00', 1, '096'),
-(24, '2018-05-20 02:45:00', '2018-05-20 03:00:00', 2, '096'),
-(25, '2018-05-20 03:00:00', '2018-05-20 03:15:00', 1, '096'),
-(26, '2018-05-20 03:00:00', '2018-05-20 03:15:00', 2, '096'),
-(27, '2018-05-20 03:15:00', '2018-05-20 03:30:00', 1, '096'),
-(28, '2018-05-20 03:15:00', '2018-05-20 03:30:00', 2, '096'),
-(29, '2018-05-20 03:30:00', '2018-05-20 03:45:00', 1, '096'),
-(30, '2018-05-20 03:30:00', '2018-05-20 03:45:00', 2, '096'),
-(31, '2018-05-20 03:45:00', '2018-05-20 04:00:00', 1, '096'),