Revize c1f55562

refs #6942: Upraveni struktury, pridani tabulky DATUM

Pridano schema a sql s naplnenou databazi daty ze dne 20.05.2018.

db/v4__base_schema.sql

@@ +1 @@
+-- phpMyAdmin SQL Dump
+-- version 3.5.2.2
+-- http://www.phpmyadmin.net
+--
+-- Počítač: 127.0.0.1
+-- Vygenerováno: Pon 21. kvě 2018, 22:56
+-- Verze MySQL: 5.5.27-log
+-- Verze PHP: 5.4.6
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+SET time_zone = "+00:00";
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Databáze: `prujezd_vozidel`
+--
+CREATE DATABASE `prujezd_vozidel` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
+USE `prujezd_vozidel`;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `datum`
+--
+
+CREATE TABLE IF NOT EXISTS `datum` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `od` datetime NOT NULL,
+  `do` datetime NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `mesto`
+--
+
+CREATE TABLE IF NOT EXISTS `mesto` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `nazev` varchar(100) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `ulice`
+--
+
+CREATE TABLE IF NOT EXISTS `ulice` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `nazev` varchar(255) NOT NULL,
+  `mesto_id` bigint(20) NOT NULL,
+  `zem_sirka` double NOT NULL DEFAULT '-1' COMMENT 'Zemepisna sirka podle GOOGLE.',
+  `zem_delka` double NOT NULL DEFAULT '-1' COMMENT 'Zemepisna delka podle GOOGLE.',
+  PRIMARY KEY (`id`),
+  KEY `fk_ulice_mesto_idx` (`mesto_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `vozidlo`
+--
+
+CREATE TABLE IF NOT EXISTS `vozidlo` (
+  `id` bigint(20) NOT NULL COMMENT 'Odpovídá číslu skupiny vozidla (TypVozidla10 v csv souboru s daty). Hodnoty 0-10.',
+  `nazev` varchar(45) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `zarizeni`
+--
+
+CREATE TABLE IF NOT EXISTS `zarizeni` (
+  `id` varchar(20) NOT NULL COMMENT 'Odpovídá idDevice v location.csv.',
+  `smer_popis` varchar(255) NOT NULL COMMENT 'Odpovídá Name v locations.csv.',
+  `stav` int(11) NOT NULL,
+  `ulice_id` bigint(20) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `fk_zarizeni_ulice1_idx` (`ulice_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `zaznam`
+--
+
+CREATE TABLE IF NOT EXISTS `zaznam` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `vozidla_pocet` int(11) NOT NULL,
+  `rychlost_prumer` double NOT NULL,
+  `vozidla_id` bigint(20) NOT NULL,
+  `zaznam_cas_id` bigint(20) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `fk_zaznam_vozidla1_idx` (`vozidla_id`),
+  KEY `fk_zaznam_zaznam_cas1_idx` (`zaznam_cas_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `zaznam_cas`
+--
+
+CREATE TABLE IF NOT EXISTS `zaznam_cas` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `smer` int(11) NOT NULL COMMENT '1 nebo 2 viz struktura idDetektor v csv souboru s daty.',
+  `zarizeni_id` varchar(20) NOT NULL,
+  `datum_id` bigint(20) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `fk_zaznam_cas_zarizeni1_idx` (`zarizeni_id`),
+  KEY `datum_id` (`datum_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `zaznam_prum_den`
+--
+
+CREATE TABLE IF NOT EXISTS `zaznam_prum_den` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `vozidla_pocet` int(11) NOT NULL,
+  `rychlost_prumer` double NOT NULL,
+  `smer` int(11) NOT NULL,
+  `zarizeni_id` varchar(20) NOT NULL,
+  `vozidla_id` bigint(20) NOT NULL,
+  `datum_id` bigint(20) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `zarizeni_id` (`zarizeni_id`),
+  KEY `vozidla_id` (`vozidla_id`),
+  KEY `datum_id` (`datum_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Omezení pro exportované tabulky
+--
+
+--
+-- Omezení pro tabulku `ulice`
+--
+ALTER TABLE `ulice`
+  ADD CONSTRAINT `fk_ulice_mesto` FOREIGN KEY (`mesto_id`) REFERENCES `mesto` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
+
+--
+-- Omezení pro tabulku `zarizeni`
+--
+ALTER TABLE `zarizeni`
+  ADD CONSTRAINT `fk_zarizeni_ulice1` FOREIGN KEY (`ulice_id`) REFERENCES `ulice` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
+
+--
+-- Omezení pro tabulku `zaznam`
+--
+ALTER TABLE `zaznam`
+  ADD CONSTRAINT `fk_zaznam_vozidla1` FOREIGN KEY (`vozidla_id`) REFERENCES `vozidlo` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
+  ADD CONSTRAINT `fk_zaznam_zaznam_cas1` FOREIGN KEY (`zaznam_cas_id`) REFERENCES `zaznam_cas` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
+
+--
+-- Omezení pro tabulku `zaznam_cas`
+--
+ALTER TABLE `zaznam_cas`
+  ADD CONSTRAINT `zaznam_cas_ibfk_1` FOREIGN KEY (`datum_id`) REFERENCES `datum` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
+  ADD CONSTRAINT `fk_zaznam_cas_zarizeni1` FOREIGN KEY (`zarizeni_id`) REFERENCES `zarizeni` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
+
+--
+-- Omezení pro tabulku `zaznam_prum_den`
+--
+ALTER TABLE `zaznam_prum_den`
+  ADD CONSTRAINT `zaznam_prum_den_ibfk_3` FOREIGN KEY (`datum_id`) REFERENCES `datum` (`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,
+  ADD CONSTRAINT `zaznam_prum_den_ibfk_2` FOREIGN KEY (`vozidla_id`) REFERENCES `vozidlo` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
+
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

db/v5__20_05_2018.sql

@@ +1 @@
+-- phpMyAdmin SQL Dump
+-- version 3.5.2.2
+-- http://www.phpmyadmin.net
+--
+-- Počítač: 127.0.0.1
+-- Vygenerováno: Úte 22. kvě 2018, 02:50
+-- Verze MySQL: 5.5.27-log
+-- Verze PHP: 5.4.6
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+SET time_zone = "+00:00";
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Databáze: `prujezd_vozidel`
+--
+CREATE DATABASE `prujezd_vozidel` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
+USE `prujezd_vozidel`;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `datum`
+--
+
+CREATE TABLE IF NOT EXISTS `datum` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `od` datetime NOT NULL,
+  `do` datetime NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=98 ;
+
+--
+-- Vypisuji data pro tabulku `datum`
+--
+
+INSERT INTO `datum` (`id`, `od`, `do`) VALUES
+(1, '2018-05-20 00:00:00', '2018-05-20 00:15:00'),
+(2, '2018-05-20 00:15:00', '2018-05-20 00:30:00'),
+(3, '2018-05-20 00:30:00', '2018-05-20 00:45:00'),
+(4, '2018-05-20 00:45:00', '2018-05-20 01:00:00'),
+(5, '2018-05-20 01:00:00', '2018-05-20 01:15:00'),
+(6, '2018-05-20 01:15:00', '2018-05-20 01:30:00'),
+(7, '2018-05-20 01:30:00', '2018-05-20 01:45:00'),
+(8, '2018-05-20 01:45:00', '2018-05-20 02:00:00'),
+(9, '2018-05-20 02:00:00', '2018-05-20 02:15:00'),
+(10, '2018-05-20 02:15:00', '2018-05-20 02:30:00'),
+(11, '2018-05-20 02:30:00', '2018-05-20 02:45:00'),
+(12, '2018-05-20 02:45:00', '2018-05-20 03:00:00'),
+(13, '2018-05-20 03:00:00', '2018-05-20 03:15:00'),
+(14, '2018-05-20 03:15:00', '2018-05-20 03:30:00'),
+(15, '2018-05-20 03:30:00', '2018-05-20 03:45:00'),
+(16, '2018-05-20 03:45:00', '2018-05-20 04:00:00'),
+(17, '2018-05-20 04:00:00', '2018-05-20 04:15:00'),
+(18, '2018-05-20 04:15:00', '2018-05-20 04:30:00'),
+(19, '2018-05-20 04:30:00', '2018-05-20 04:45:00'),
+(20, '2018-05-20 04:45:00', '2018-05-20 05:00:00'),
+(21, '2018-05-20 05:00:00', '2018-05-20 05:15:00'),
+(22, '2018-05-20 05:15:00', '2018-05-20 05:30:00'),
+(23, '2018-05-20 05:30:00', '2018-05-20 05:45:00'),
+(24, '2018-05-20 05:45:00', '2018-05-20 06:00:00'),
+(25, '2018-05-20 06:00:00', '2018-05-20 06:15:00'),
+(26, '2018-05-20 06:15:00', '2018-05-20 06:30:00'),
+(27, '2018-05-20 06:30:00', '2018-05-20 06:45:00'),
+(28, '2018-05-20 06:45:00', '2018-05-20 07:00:00'),
+(29, '2018-05-20 07:00:00', '2018-05-20 07:15:00'),
+(30, '2018-05-20 07:15:00', '2018-05-20 07:30:00'),
+(31, '2018-05-20 07:30:00', '2018-05-20 07:45:00'),
+(32, '2018-05-20 07:45:00', '2018-05-20 08:00:00'),
+(33, '2018-05-20 08:00:00', '2018-05-20 08:15:00'),
+(34, '2018-05-20 08:15:00', '2018-05-20 08:30:00'),
+(35, '2018-05-20 08:30:00', '2018-05-20 08:45:00'),
+(36, '2018-05-20 08:45:00', '2018-05-20 09:00:00'),
+(37, '2018-05-20 09:00:00', '2018-05-20 09:15:00'),
+(38, '2018-05-20 09:15:00', '2018-05-20 09:30:00'),
+(39, '2018-05-20 09:30:00', '2018-05-20 09:45:00'),
+(40, '2018-05-20 09:45:00', '2018-05-20 10:00:00'),
+(41, '2018-05-20 10:00:00', '2018-05-20 10:15:00'),
+(42, '2018-05-20 10:15:00', '2018-05-20 10:30:00'),
+(43, '2018-05-20 10:30:00', '2018-05-20 10:45:00'),
+(44, '2018-05-20 10:45:00', '2018-05-20 11:00:00'),
+(45, '2018-05-20 11:00:00', '2018-05-20 11:15:00'),
+(46, '2018-05-20 11:15:00', '2018-05-20 11:30:00'),
+(47, '2018-05-20 11:30:00', '2018-05-20 11:45:00'),
+(48, '2018-05-20 11:45:00', '2018-05-20 12:00:00'),
+(49, '2018-05-20 12:00:00', '2018-05-20 12:15:00'),
+(50, '2018-05-20 12:15:00', '2018-05-20 12:30:00'),
+(51, '2018-05-20 12:30:00', '2018-05-20 12:45:00'),
+(52, '2018-05-20 12:45:00', '2018-05-20 13:00:00'),
+(53, '2018-05-20 13:00:00', '2018-05-20 13:15:00'),
+(54, '2018-05-20 13:15:00', '2018-05-20 13:30:00'),
+(55, '2018-05-20 13:30:00', '2018-05-20 13:45:00'),
+(56, '2018-05-20 13:45:00', '2018-05-20 14:00:00'),
+(57, '2018-05-20 14:00:00', '2018-05-20 14:15:00'),
+(58, '2018-05-20 14:15:00', '2018-05-20 14:30:00'),
+(59, '2018-05-20 14:30:00', '2018-05-20 14:45:00'),
+(60, '2018-05-20 14:45:00', '2018-05-20 15:00:00'),
+(61, '2018-05-20 15:00:00', '2018-05-20 15:15:00'),
+(62, '2018-05-20 15:15:00', '2018-05-20 15:30:00'),
+(63, '2018-05-20 15:30:00', '2018-05-20 15:45:00'),
+(64, '2018-05-20 15:45:00', '2018-05-20 16:00:00'),
+(65, '2018-05-20 16:00:00', '2018-05-20 16:15:00'),
+(66, '2018-05-20 16:15:00', '2018-05-20 16:30:00'),
+(67, '2018-05-20 16:30:00', '2018-05-20 16:45:00'),
+(68, '2018-05-20 16:45:00', '2018-05-20 17:00:00'),
+(69, '2018-05-20 17:00:00', '2018-05-20 17:15:00'),
+(70, '2018-05-20 17:15:00', '2018-05-20 17:30:00'),
+(71, '2018-05-20 17:30:00', '2018-05-20 17:45:00'),
+(72, '2018-05-20 17:45:00', '2018-05-20 18:00:00'),
+(73, '2018-05-20 18:00:00', '2018-05-20 18:15:00'),
+(74, '2018-05-20 18:15:00', '2018-05-20 18:30:00'),
+(75, '2018-05-20 18:30:00', '2018-05-20 18:45:00'),
+(76, '2018-05-20 18:45:00', '2018-05-20 19:00:00'),
+(77, '2018-05-20 19:00:00', '2018-05-20 19:15:00'),
+(78, '2018-05-20 19:15:00', '2018-05-20 19:30:00'),
+(79, '2018-05-20 19:30:00', '2018-05-20 19:45:00'),
+(80, '2018-05-20 19:45:00', '2018-05-20 20:00:00'),
+(81, '2018-05-20 20:00:00', '2018-05-20 20:15:00'),
+(82, '2018-05-20 20:15:00', '2018-05-20 20:30:00'),
+(83, '2018-05-20 20:30:00', '2018-05-20 20:45:00'),
+(84, '2018-05-20 20:45:00', '2018-05-20 21:00:00'),
+(85, '2018-05-20 21:00:00', '2018-05-20 21:15:00'),
+(86, '2018-05-20 21:15:00', '2018-05-20 21:30:00'),
+(87, '2018-05-20 21:30:00', '2018-05-20 21:45:00'),
+(88, '2018-05-20 21:45:00', '2018-05-20 22:00:00'),
+(89, '2018-05-20 22:00:00', '2018-05-20 22:15:00'),
+(90, '2018-05-20 22:15:00', '2018-05-20 22:30:00'),
+(91, '2018-05-20 22:30:00', '2018-05-20 22:45:00'),
+(92, '2018-05-20 22:45:00', '2018-05-20 23:00:00'),
+(93, '2018-05-20 23:00:00', '2018-05-20 23:15:00'),
+(94, '2018-05-20 23:15:00', '2018-05-20 23:30:00'),
+(95, '2018-05-20 23:30:00', '2018-05-20 23:45:00'),
+(96, '2018-05-20 23:45:00', '2018-05-21 00:00:00'),
+(97, '2018-05-20 00:00:00', '2018-05-21 00:00:00');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `mesto`
+--
+
+CREATE TABLE IF NOT EXISTS `mesto` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `nazev` varchar(100) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=57 ;
+
+--
+-- Vypisuji data pro tabulku `mesto`
+--
+
+INSERT INTO `mesto` (`id`, `nazev`) VALUES
+(1, 'Česká Kubice'),
+(2, 'Holýšov'),
+(3, 'Horšovský Týn'),
+(4, 'Klenčí pod Čerchovem'),
+(5, 'Libkov'),
+(6, 'Poběžovice'),
+(7, 'Staňkov'),
+(8, 'Běšiny'),
+(9, 'Červené Poříčí'),
+(10, 'Dlouhá Ves'),
+(11, 'Kolinec'),
+(12, 'Benešovice'),
+(13, 'Broumov'),
+(14, 'Tachov'),
+(15, 'Domažlice'),
+(16, 'Hostouň'),
+(17, 'Mířkov'),
+(18, 'Nemanice'),
+(19, 'Všeruby'),
+(20, 'Janovice nad Úhlavou'),
+(21, 'Mochtín'),
+(22, 'Plánice'),
+(23, 'Stráž - Bonětice'),
+(24, 'Bělá nad Radbuzou'),
+(25, 'Horažďovice'),
+(26, 'Kašperské Hory'),
+(27, 'Modrava'),
+(28, 'Nýrsko'),
+(29, 'Sušice'),
+(30, 'Železná Ruda'),
+(31, 'Bor'),
+(32, 'Chodová Planá'),
+(33, 'Planá'),
+(34, 'Rozvadov'),
+(35, 'Stříbro'),
+(36, 'Babylon'),
+(37, 'Brnířov'),
+(38, 'Pocinovice'),
+(39, 'Klatovy'),
+(40, 'Přimda'),
+(41, 'Srní'),
+(42, 'Halže - Branka'),
+(43, 'Horní Folmava'),
+(44, 'Losiná'),
+(45, 'Starý Plzenec'),
+(46, 'Stod'),
+(47, 'Nepomuk'),
+(48, 'Nezvěstice'),
+(49, 'Kaznějov'),
+(50, 'Kralovice '),
+(51, 'Kozolupy '),
+(52, 'Zbůch '),
+(53, 'Dobřany'),
+(54, 'Plasy'),
+(55, 'Vejprnice'),
+(56, 'Přeštice ');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `ulice`
+--
+
+CREATE TABLE IF NOT EXISTS `ulice` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `nazev` varchar(255) NOT NULL,
+  `mesto_id` bigint(20) NOT NULL,
+  `zem_sirka` double NOT NULL DEFAULT '-1' COMMENT 'Zemepisna sirka podle GOOGLE.',
+  `zem_delka` double NOT NULL DEFAULT '-1' COMMENT 'Zemepisna delka podle GOOGLE.',
+  PRIMARY KEY (`id`),
+  KEY `fk_ulice_mesto_idx` (`mesto_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=88 ;
+
+--
+-- Vypisuji data pro tabulku `ulice`
+--
+
+INSERT INTO `ulice` (`id`, `nazev`, `mesto_id`, `zem_sirka`, `zem_delka`) VALUES
+(1, 'Česká Kubice', 1, 49.369388, 12.8588044),
+(2, 'Jiráskova třída', 2, 49.5942514, 13.1005736),
+(3, 'Masarykova', 3, 49.5325795, 12.9329223),
+(4, 'Gorkého', 3, 49.5331401, 12.9446972),
+(5, 'Nová Ves', 3, 49.5290441, 12.9241819),
+(6, 'Klenčí pod Čerchovem', 4, 49.4348481, 12.8147347),
+(7, 'Libkov', 5, 49.8417332, 15.7563096),
+(8, 'Slovanská', 6, 49.5073853, 12.8018405),
+(9, 'Americká', 7, 49.5511106, 13.0653981),
+(10, 'Běšiny', 8, 49.3016091, 13.3125767),
+(11, 'Červené Poříčí', 9, 49.5012041, 13.2953108),
+(12, 'Dlouhá Ves', 10, 49.1962834, 13.5092601),
+(13, 'Kolinec', 11, 49.2989568, 13.4390062),
+(14, 'Benenšovice', 12, 49.726864, 12.901699),
+(15, 'Broumov', 13, 50.5856582, 16.3318151),
+(16, 'Sokolovská', 14, 49.8067796, 12.6424884),
+(17, 'Plzeňská', 14, 49.7911169, 12.6486672),
+(18, 'Moravská', 14, 49.8030504, 12.6348077),
+(19, 'Masarykova', 15, 49.4329948, 12.9514853),
+(20, 'Petra Bezruče', 16, 49.5615961, 12.7771514),
+(21, 'Mířkov', 17, 49.5891548, 12.8815116),
+(22, 'Nemanice', 18, 49.4365627, 12.720542),
+(23, 'Brůdek', 19, 49.3667667, 13.0098458),
+(24, 'Všeruby', 19, 49.8416809, 13.2294411),
+(25, 'Nýrská', 20, 49.3451571, 13.218139),
+(26, 'Kocourov', 21, 49.3590594, 13.3840423),
+(27, 'Mochtín', 21, 49.3603773, 13.3569046),
+(28, 'Klatovská', 22, 49.3909746, 13.4687327),
+(29, 'Stráž - Bonětice', 23, 49.6655193, 12.8273937),
+(30, 'Dlouhá', 24, 49.591775, 12.7052529),
+(31, 'Nádražní', 24, 49.5893638, 12.7200799),
+(32, 'Komenského', 25, 49.3247489, 13.6906175),
+(33, 'Strakonická', 25, 49.3195422, 13.7108108),
+(34, 'Plzeňská', 25, 49.3249767, 13.7007432),
+(35, 'Vimperská', 26, 49.1460905, 13.5644524),
+(36, 'Modrava', 27, 49.0240725, 13.4993175),
+(37, 'Modrava (Filipova Huť)', 27, 49.0285263, 13.5177405),
+(38, 'Klostermanova', 28, 49.2881779, 13.1435618),
+(39, 'Palackého', 28, 49.2863376, 13.1296931),
+(40, 'Komenského', 28, 49.293581, 13.1257046),
+(41, 'U Banky', 28, 49.2951762, 13.1501412),
+(42, 'Dlouhovesská', 29, 49.2276062, 13.5204784),
+(43, 'Volšovská', 29, 49.2234632, 13.5112689),
+(44, 'Nádražní', 29, 49.2424941, 13.5325336),
+(45, 'Železná Ruda', 30, 49.1374427, 13.2352046),
+(46, 'Nádražní', 31, 49.7173149, 12.7778928),
+(47, 'Pohraniční stráže', 32, 49.893186, 12.7300727),
+(48, 'Tachovská', 33, 49.8681673, 12.7437969),
+(49, 'Rozvadov', 34, 49.6681792, 12.5518982),
+(50, '5. května', 35, 49.752874, 12.9896153),
+(51, 'Plzeňská', 35, 49.7511035, 13.0050148),
+(52, 'Babylon', 36, 50.5308443, 15.370152),
+(53, 'Brnířov', 37, 49.3825977, 13.04959),
+(54, 'Náměstí', 24, 49.5914956, 12.7159024),
+(55, 'P. Velikého', 15, 49.4462758, 12.9322682),
+(56, '28. října', 15, 49.4417745, 12.9174921),
+(57, 'Na Přeložce', 3, 49.5316687, 12.9514746),
+(58, 'Nádražní', 3, 49.5256309, 12.9384663),
+(59, 'Nemanice - Lísková', 18, 49.4188422, 12.7162983),
+(60, 'Pocinovice', 38, 49.3434229, 13.1334973),
+(61, 'Štěpánovice', 39, 49.4249957, 13.2853496),
+(62, 'Puškinova', 39, 49.3858178, 13.3042743),
+(63, '5. května Luby', 39, 49.3831621, 13.2971914),
+(64, 'Plzeňská', 39, 49.4024071, 13.2930274),
+(65, 'Domažlická', 39, 49.3939022, 13.2820308),
+(66, 'Koldinova', 39, 49.402985, 13.2811252),
+(67, 'Plánická', 39, 49.3954174, 13.3048485),
+(68, 'Přimdská', 31, 49.7114696, 12.772997),
+(69, 'Plzeňská', 31, 49.7088027, 12.7827857),
+(70, 'Borská', 40, 49.6789359, 12.6537936),
+(71, 'Srní', 41, 49.0871919, 13.4804477),
+(72, 'Halže - Branka', 42, 49.8255089, 12.523725),
+(73, 'Horní Folmava', 43, 49.348875, 12.8552785),
+(74, 'Sušice', 29, 49.2316758, 13.5204093),
+(75, 'Losiná', 44, 49.6692003, 13.4483423),
+(76, 'Bezručova ulice', 45, 49.696732, 13.4598939),
+(77, 'Plzeňská I/26', 46, 49.5645901, 13.0760652),
+(78, 'Nepomuk', 47, 49.4861699, 13.5822609),
+(79, 'Nezvěstice', 48, 49.6404353, 13.5196266),
+(80, 'Kaznějov', 49, 49.8931387, 13.3829583),
+(81, 'Kralovice', 50, 49.981924, 13.4874835),
+(82, 'Kozolupy', 51, 49.7638017, 13.2521138),
+(83, 'Zbůch', 52, 49.6784086, 13.2256544),
+(84, 'Dobřany', 53, 49.6548327, 13.2930773),
+(85, 'Plasy', 54, 49.9344975, 13.390365),
+(86, 'Vejprnice', 55, 49.7298911, 13.2762859),
+(87, 'Přeštice', 56, 49.5729906, 13.3335071);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `vozidlo`
+--
+
+CREATE TABLE IF NOT EXISTS `vozidlo` (
+  `id` bigint(20) NOT NULL COMMENT 'Odpovídá číslu skupiny vozidla (TypVozidla10 v csv souboru s daty). Hodnoty 0-10.',
+  `nazev` varchar(45) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `vozidlo`
+--
+
+INSERT INTO `vozidlo` (`id`, `nazev`) VALUES
+(0, 'Neznámé vozidlo'),
+(1, 'Motocykl'),
+(2, 'Auto'),
+(3, 'Auto s přívěsem'),
+(4, 'Dodávka'),
+(5, 'Dodávka s přívěsem'),
+(6, 'Lehký nákladní automobil'),
+(7, 'Lehký nákladní automobil s přívěsem'),
+(8, 'Nákladní automobil'),
+(9, 'Nákladní automobil s přívěsem'),
+(10, 'Autobus');
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `zarizeni`
+--
+
+CREATE TABLE IF NOT EXISTS `zarizeni` (
+  `id` varchar(20) NOT NULL COMMENT 'Odpovídá idDevice v location.csv.',
+  `smer_popis` varchar(255) NOT NULL COMMENT 'Odpovídá Name v locations.csv.',
+  `stav` int(11) NOT NULL,
+  `ulice_id` bigint(20) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `fk_zarizeni_ulice1_idx` (`ulice_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Vypisuji data pro tabulku `zarizeni`
+--
+
+INSERT INTO `zarizeni` (`id`, `smer_popis`, `stav`, `ulice_id`) VALUES
+('051', 'Holýšov, směr od Plzně', 0, 2),
+('052', 'Tachov, směr od Plzně', 0, 17),
+('053', 'Staňkov, směr od H.Týna', 0, 9),
+('054', 'Tachov, směr od Halže', 0, 18),
+('055', 'Česká Kubice, směr od Německa', 0, 1),
+('056', 'Česká Kubice, směr od Babylonu', 0, 1),
+('057', 'Kolinec, směr od Sušice', 0, 13),
+('058', 'Dlouhá Ves, směr od Sušice', 0, 12),
+('059', 'Červené Poříčí, směr od Plzně', 0, 11),
+('060', 'Benešovice, směr od Stříbra', 0, 14),
+('061', 'Klenčí pod Čerchovem, směr od Německa', 0, 6),
+('062', 'Klenčí pod Čerchovem, směr od Domažlic', 0, 6),
+('063', 'Tachov, směr od Plané', 0, 16),
+('064', 'Broumov, směr od Německa', 0, 15),
+('065', 'Broumov, směr od Plané', 0, 15),
+('066', 'Horšovský Týn, směr od Boru', 0, 3),
+('067', 'Horšovský Týn, směr od Stříbra', 0, 4),
+('068', 'Horšovský Týn, směr od Bělé', 0, 5),
+('069', 'Libkov, směr od Klatov', 0, 7),
+('070', 'Mířkov, směr od Boru', 0, 21),
+('071', 'Poběžovice, směr od Klenčí', 0, 8),
+('072', 'Běšiny, směr od Klatov', 0, 10),
+('073', 'Běšiny, směr od l/27', 0, 10),
+('074', 'Stráž - Bonětice, směr od H. Týna', 0, 29),
+('075', 'Janovice nad Úhlavou, směr od Klatov', 0, 25),
+('076', 'Janovice nad Úhlavou, směr od Německa', 0, 25),
+('077', 'Všeruby - Brůdek, směr od Kdyně', 0, 23),
+('078', 'Všeruby, směr od Německa', 0, 24),
+('079', 'Mochtín - Kocourov, směr od Horažďovic', 0, 26),
+('080', 'Mochtín, směr od Klatov', 0, 27),
+('081', 'Domažlice, směr od Klatov', 0, 19),
+('082', 'Brnířov od Kdyně', 0, 53),
+('083', 'Nýrsko Klostermannova', 0, 38),
+('084', 'Nýrsko, směr od Ž.Rudy', 0, 41),
+('085', 'Planá, směr do Chebu', 0, 48),
+('086', 'Stříbro, směr od centra', 0, 51),
+('087', 'Plánice, směr od Klatov', 0, 28),
+('088', 'Modrava, směr od Srní', 0, 36),
+('089', 'Modrava - Filipova Huť, směr od Kvildy', 0, 37),
+('090', 'Nemanice, směr od Poběžovic', 0, 22),
+('091', 'Hostouň, směr od Bělé', 0, 20),
+('092', 'Železná Ruda - Alžbětín, směr od Německa', 0, 45),
+('093', 'Železná Ruda - Špičák, směr od Nýrska', 0, 45),
+('094', 'Bor, směr od D5', 0, 46),
+('095', 'Rozvadov, směr od Německa', 0, 49),
+('096', 'Rozvadov, směr od Přimdy', 0, 49),
+('097', 'Stříbro, směr od Boru', 0, 50),
+('098', 'Nýrsko, směr od Svaté Kateřiny', 0, 39),
+('099', 'Nýrsko, směr od Chudenína', 0, 40),
+('100', 'Chodová Planá, směr od Chebu', 0, 47),
+('101', 'Planá, směr do Plzně', 0, 48),
+('102', 'Kašperské Hory, směr od Vimperka ', 0, 35),
+('103', 'Sušice, směr od Horažďovic', 0, 44),
+('104', 'Halže - Branka, II/199 od Německa', 0, 72),
+('105', 'Horšovský Týn, směr na přechodu od Německa', 0, 57),
+('106', 'Horšovský Týn, směr na přechodu od Plzně', 0, 58),
+('107', 'Bor, II/200 Plzeňská', 0, 69),
+('108', 'Bělá nad Radbuzou, směr od náměstí', 0, 54),
+('109', 'Horní Folmava, I/26, směr od Německa', 0, 73),
+('110', 'Domažlice, směr od od H.Týna', 0, 55),
+('111', 'Domažlice, směr od Draženova', 0, 56),
+('112', 'Horažďovice, směr od Klatov', 0, 32),
+('113', 'Horažďovice, směr od Strakonic', 0, 33),
+('114', 'Horažďovice, směr od Velkého Boru', 0, 34),
+('115', 'Srní, směr od Rejštejna ', 0, 71),
+('116', 'Bor, směr od Přimdy', 0, 68),
+('117', 'Babylon ve směru od Německa', 0, 52),
+('118', 'Babylon ve směru od H.Týna', 0, 52),
+('119', 'Bělá nad Radbuzou, směr od Německa', 0, 30),
+('120', 'Bělá nad Radbuzou, směr od H. Týna', 0, 31),
+('121', 'Nemanice, směr od Německa Lísková', 0, 59),
+('122', 'Pocinovice ve směru od Nýrska', 0, 60),
+('123', 'Klatovy - Štěpánovice, směr od Plzně', 0, 61),
+('124', 'Klatovy směr od Horažďovic', 0, 62),
+('125', 'Klatovy směr od Železné Rudy', 0, 63),
+('126', 'Klatovy - Plzeňská, směr z centra', 0, 64),
+('127', 'Klatovy - Domažlická, směr z centra', 0, 65),
+('128', 'Klatovy směr od Domažlic', 0, 65),
+('129', 'Klatovy směr od Dolan', 0, 66),
+('130', 'Klatovy směr od Plánice', 0, 67),
+('131', 'Sušice, směr od Dlouhé Vsi', 0, 42),
+('132', 'Sušice, směr od Petrovic', 0, 43),
+('133', 'Sušice, Hrádecká ul. u nákupních center', 0, 74),
+('134', 'Železná Ruda - město, Klatovská na I/27 od Klatov', 0, 45),
+('135', 'Přimda směr od Boru', 0, 70),
+('136', 'Přimda směr od Rozvadova', 0, 70),
+('191', 'Starý Plzenec, II/180, Bezručova ulice', 0, 76),
+('192', 'Losiná I/20, směr Nepomuk', 0, 75),
+('193', 'Losiná I/20, směr Plzeň', 0, 75),
+('194', 'Stod, Plzeňská I/26', 0, 77),
+('195', 'Plasy', 0, 85),
+('196', 'Nepomuk I/20, směr Blatná', 0, 78),
+('197', 'Vejprnice', 0, 86),
+('198', 'Nezvěstice I/19, směr Spálené Poříčí', 0, 79),
+('199', 'Kaznějov I/20 směr od Plzně', 0, 80),
+('200', 'Kaznějov I/20 směr od Plas', 0, 80),
+('201', 'Kralovice', 0, 81),
+('202', 'Kralovice', 0, 81),
+('203', 'Kozolupy II/605 od Plzně', 0, 82),
+('204', 'Přeštice', 0, 87),
+('205', 'Zbůch silnice I/26 od Stodu', 0, 83),
+('206', 'Zbůch silnice I/26 od Plzně', 0, 83),
+('229', 'Dobřany', 0, 84);
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `zaznam`
+--
+
+CREATE TABLE IF NOT EXISTS `zaznam` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `vozidla_pocet` int(11) NOT NULL,
+  `rychlost_prumer` double NOT NULL,
+  `vozidla_id` bigint(20) NOT NULL,
+  `zaznam_cas_id` bigint(20) NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `fk_zaznam_vozidla1_idx` (`vozidla_id`),
+  KEY `fk_zaznam_zaznam_cas1_idx` (`zaznam_cas_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25231 ;
+
+--
+-- Vypisuji data pro tabulku `zaznam`
+--
+
+INSERT INTO `zaznam` (`id`, `vozidla_pocet`, `rychlost_prumer`, `vozidla_id`, `zaznam_cas_id`) VALUES
+(1, 12, 50, 2, 1),
+(2, 13, -1, 2, 2),
+(3, 7, 50, 2, 3),
+(4, 4, -1, 2, 4),
+(5, 6, 50, 2, 5),
+(6, 8, -1, 2, 6),
+(7, 6, 50, 2, 7),
+(8, 7, -1, 2, 8),
+(9, 1, -1, 8, 8),
+(10, 6, -1, 2, 9),
+(11, 4, -1, 2, 10),
+(12, 3, 50, 2, 11),
+(13, 11, -1, 2, 12),
+(14, 3, -1, 2, 13),
+(15, 5, -1, 2, 14),
+(16, 7, 50, 2, 15),
+(17, 3, -1, 2, 16),
+(18, 2, -1, 2, 17),
+(19, 12, -1, 2, 18),
+(20, 5, -1, 2, 19),
+(21, 7, -1, 2, 20),
+(22, 1, -1, 2, 21),
+(23, 7, -1, 2, 22),
+(24, 1, -1, 8, 22),
+(25, 3, -1, 2, 23),
+(26, 5, -1, 2, 24),
+(27, 3, -1, 2, 25),
+(28, 3, -1, 2, 26),
+(29, 3, -1, 2, 27),
+(30, 3, -1, 2, 28),
+(31, 1, -1, 2, 29),
+(32, 6, -1, 2, 30),
+(33, 10, 50, 2, 31),
+(34, 10, -1, 2, 32),
+(35, 4, 50, 2, 33),
+(36, 7, -1, 2, 34),
+(37, 4, -1, 2, 35),
+(38, 4, -1, 2, 36),
+(39, 1, -1, 6, 37),
+(40, 2, -1, 2, 38),
+(41, 3, -1, 6, 38),
+(42, 1, -1, 2, 39),
+(43, 1, -1, 6, 39),
+(44, 1, -1, 2, 40),
+(45, 5, 50, 2, 41),
+(46, 8, -1, 2, 42),
+(47, 2, -1, 4, 42),
+(48, 1, -1, 8, 42),
+(49, 10, 50, 2, 43),
+(50, 1, -1, 4, 43),
+(51, 2, -1, 2, 44),
+(52, 3, -1, 4, 44),
+(53, 7, 50, 2, 45),
+(54, 2, -1, 2, 46),
+(55, 3, -1, 4, 46),
+(56, 10, 50, 2, 47),
+(57, 4, -1, 2, 48),
+(58, 1, -1, 4, 48),
+(59, 3, 50, 2, 49),
+(60, 2, -1, 4, 49),
+(61, 1, -1, 6, 49),
+(62, 3, -1, 2, 50),
+(63, 4, -1, 4, 50),
+(64, 11, 50, 2, 51),
+(65, 1, -1, 2, 52),
+(66, 6, -1, 4, 52),
+(67, 23, 50, 2, 53),
+(68, 2, -1, 2, 54),
+(69, 6, -1, 4, 54),
+(70, 1, -1, 6, 54),
+(71, 2, -1, 8, 54),
+(72, 34, 50, 2, 55),
+(73, 2, -1, 4, 55),
+(74, 2, -1, 6, 55),
+(75, 2, -1, 2, 56),
+(76, 3, -1, 4, 56),
+(77, 2, -1, 6, 56),
+(78, 11, 50, 2, 57),
+(79, 1, -1, 4, 57),
+(80, 4, -1, 2, 58),
+(81, 9, -1, 4, 58),
+(82, 2, -1, 6, 58),
+(83, 1, -1, 8, 58),
+(84, 19, 50, 2, 59),
+(85, 1, -1, 2, 60),
+(86, 5, -1, 4, 60),
+(87, 23, 50, 2, 61),
+(88, 1, -1, 6, 61),
+(89, 1, -1, 8, 61),
+(90, 2, -1, 2, 62),
+(91, 5, -1, 4, 62),
+(92, 16, 50, 2, 63),
+(93, 1, -1, 4, 63),
+(94, 9, -1, 4, 64),
+(95, 34, 50.172413793103, 2, 65),
+(96, 3, 54, 6, 65),
+(97, 5, 54, 2, 66),
+(98, 5, -1, 4, 66),
+(99, 1, -1, 6, 66),
+(100, 172, 48.78488372093, 2, 67),
+(101, 2, 42.5, 4, 67),
+(102, 13, 45.181818181818, 2, 68),
+(103, 2, 35.5, 4, 68),
+(104, 80, 48.1, 2, 69),
+(105, 1, 29, 4, 69),
+(106, 14, 50.642857142857, 2, 70),
+(107, 7, 44, 4, 70),
+(108, 1, -1, 6, 70),
+(109, 41, 47.951219512195, 2, 71),
+(110, 35, 50.4, 2, 72),
+(111, 4, 50, 4, 72),
+(112, 107, 46.859813084112, 2, 73),
+(113, 1, 29, 4, 73),
+(114, 40, 47.394736842105, 2, 74),
+(115, 4, 32, 4, 74),
+(116, 43, 47.093023255814, 2, 75),
+(117, 45, 50.485714285714, 2, 76),
+(118, 5, 34.5, 4, 76),
+(119, 2, 51, 6, 76),
+(120, 61, 48.360655737705, 2, 77),
+(121, 1, 43, 4, 77),
+(122, 46, 46.954545454545, 2, 78),
+(123, 6, 50, 4, 78),
+(124, 1, 43, 6, 78),
+(125, 117, 43.461538461538, 2, 79),
+(126, 62, 47.830508474576, 2, 80),
+(127, 1, 38, 4, 80),
+(128, 111, 42.054054054054, 2, 81),
+(129, 2, 36.5, 4, 81),
+(130, 86, 46.925373134328, 2, 82),
+(131, 12, 37.857142857143, 4, 82),
+(132, 1, 48, 8, 82),
+(133, 112, 46.357142857143, 2, 83),
+(134, 1, 46, 6, 83),
+(135, 57, 48.509433962264, 2, 84),
+(136, 7, 49.25, 4, 84),
+(137, 84, 43.928571428571, 2, 85),
+(138, 2, 45.5, 4, 85),
+(139, 1, 47, 6, 85),
+(140, 85, 48.666666666667, 2, 86),
+(141, 8, 36.5, 4, 86),
+(142, 102, 44.178217821782, 2, 87),
+(143, 1, 47, 6, 87),
+(144, 79, 48.985074626866, 2, 88),
+(145, 4, -1, 4, 88),
+(146, 1, -1, 6, 88),
+(147, 1, 52, 8, 88),
+(148, 128, 42.921875, 2, 89),
+(149, 77, 49.076923076923, 2, 90),
+(150, 15, 46.833333333333, 4, 90),
+(151, 1, -1, 6, 90),
+(152, 1, 36, 8, 90),
+(153, 146, 43.452054794521, 2, 91),
+(154, 3, 48, 4, 91),
+(155, 1, 41, 6, 91),
+(156, 90, 47.735294117647, 2, 92),
+(157, 16, 44.6, 4, 92),
+(158, 1, -1, 6, 92),
+(159, 129, 44.426356589147, 2, 93),
+(160, 1, 48, 4, 93),
+(161, 2, 47, 6, 93),
+(162, 114, 46.658536585366, 2, 94),
+(163, 17, 40.857142857143, 4, 94),
+(164, 1, 36, 8, 94),
+(165, 167, 44.730538922156, 2, 95),
+(166, 1, 46, 4, 95),
+(167, 1, 44, 6, 95),
+(168, 101, 46.33734939759, 2, 96),
+(169, 23, 41, 4, 96),
+(170, 1, -1, 6, 96),
+(171, 149, 42.925675675676, 2, 97),
+(172, 2, 22, 4, 97),
+(173, 1, 42, 6, 97),
+(174, 89, 48.121212121212, 2, 98),
+(175, 24, 38.181818181818, 4, 98),
+(176, 1, 32, 8, 98),
+(177, 100, 40.453488372093, 2, 99),
+(178, 2, 40, 4, 99),
+(179, 60, 44.184210526316, 2, 100),
+(180, 21, 32.666666666667, 4, 100),
+(181, 1, 46, 6, 100),
+(182, 1, 39, 8, 100),
+(183, 147, 43.659863945578, 2, 101),
+(184, 2, 42, 4, 101),
+(185, 1, 35, 6, 101),
+(186, 59, 44.025, 2, 102),
+(187, 18, 43.285714285714, 4, 102),
+(188, 1, -1, 6, 102),
+(189, 118, 42.864406779661, 2, 103),
+(190, 1, 50, 6, 103),
+(191, 55, 44.41935483871, 2, 104),
+(192, 16, 42.857142857143, 4, 104),
+(193, 1, 39, 6, 104),
+(194, 97, 42.319587628866, 2, 105),
+(195, 2, 44.5, 4, 105),
+(196, 49, 43.846153846154, 2, 106),
+(197, 21, 40.5, 4, 106),
+(198, 1, 38, 8, 106),
+(199, 166, 45.78313253012, 2, 107),
+(200, 3, 47.333333333333, 4, 107),
+(201, 1, 43, 6, 107),
+(202, 1, 46, 8, 107),
+(203, 51, 45.1875, 2, 108),
+(204, 13, 42.333333333333, 4, 108),
+(205, 137, 46.029411764706, 2, 109),
+(206, 1, 42, 6, 109),
+(207, 50, 46.69696969697, 2, 110),
+(208, 27, 43.611111111111, 4, 110),
+(209, 1, 40, 6, 110),
+(210, 2, -1, 8, 110),
+(211, 180, 45.766666666667, 2, 111),
+(212, 1, 44, 6, 111),
+(213, 44, 40.884615384615, 2, 112),
+(214, 21, 44.5625, 4, 112),
+(215, 1, -1, 6, 112),
+(216, 155, 43.967741935484, 2, 113),
+(217, 1, 44, 4, 113),
+(218, 1, 46, 8, 113),
+(219, 37, 43.454545454545, 2, 114),
+(220, 24, 42.533333333333, 4, 114),
+(221, 1, 47, 6, 114),
+(222, 188, 41.43085106383, 2, 115),
+(223, 2, 41.5, 6, 115),
+(224, 39, 41, 2, 116),
+(225, 21, 41.3, 4, 116),
+(226, 1, -1, 6, 116),
+(227, 1, 45, 8, 116),
+(228, 193, 44.072916666667, 2, 117),
+(229, 47, 45.689655172414, 2, 118),
+(230, 15, 42.1, 4, 118),
+(231, 1, -1, 6, 118),
+(232, 156, 43.410256410256, 2, 119),
+(233, 1, 31, 4, 119),
+(234, 1, 29, 6, 119),
+(235, 52, 44.268292682927, 2, 120),
+(236, 14, 41.5, 4, 120),
+(237, 2, 42, 6, 120),
+(238, 161, 45.142857142857, 2, 121),
+(239, 1, 40, 8, 121),
+(240, 54, 45.157894736842, 2, 122),
+(241, 27, 42.888888888889, 4, 122),
+(242, 2, 44.5, 8, 122),
+(243, 179, 43.156424581006, 2, 123),
+(244, 1, 44, 4, 123),
+(245, 1, 37, 8, 123),
+(246, 37, 46.9, 2, 124),
+(247, 25, 39.894736842105, 4, 124),
+(248, 1, 40, 6, 124),
+(249, 197, 45.61421319797, 2, 125),
+(250, 2, 45.5, 4, 125),
+(251, 38, 45.885714285714, 2, 126),
+(252, 15, 41.1, 4, 126),
+(253, 1, 42, 8, 126),
+(254, 215, 43.238317757009, 2, 127),
+(255, 1, 49, 4, 127),
+(256, 1, 38, 8, 127),
+(257, 39, 44.625, 2, 128),
+(258, 20, 44.3125, 4, 128),
+(259, 1, 30, 6, 128),
+(260, 1, 45, 8, 128),
+(261, 169, 45.840236686391, 2, 129),
+(262, 1, 36, 4, 129),
+(263, 2, 41.5, 6, 129),
+(264, 37, 45.258064516129, 2, 130),
+(265, 17, 38, 4, 130),
+(266, 1, 41, 6, 130),
+(267, 1, -1, 8, 130),
+(268, 177, 44.542372881356, 2, 131),
+(269, 1, 40, 4, 131),
+(270, 1, 46, 8, 131),
+(271, 44, 49.142857142857, 2, 132),
+(272, 15, 39.846153846154, 4, 132),
+(273, 161, 43.739130434783, 2, 133),
+(274, 1, 40, 6, 133),
+(275, 1, 38, 8, 133),
+(276, 32, 48.857142857143, 2, 134),
+(277, 13, 42.142857142857, 4, 134),
+(278, 1, 25, 6, 134),
+(279, 2, 41, 8, 134),
+(280, 138, 43.565217391304, 2, 135),
+(281, 1, 44, 4, 135),
+(282, 1, 38, 8, 135),
+(283, 26, 49.2, 2, 136),
+(284, 9, 45.333333333333, 4, 136),
+(285, 1, 39, 6, 136),
+(286, 176, 43.926136363636, 2, 137),
+(287, 1, 42, 8, 137),
+(288, 51, 47.853658536585, 2, 138),
+(289, 22, 37.785714285714, 4, 138),
+(290, 1, -1, 8, 138),
+(291, 162, 45.246913580247, 2, 139),
+(292, 3, 46, 4, 139),
+(293, 2, 46.5, 8, 139),
+(294, 43, 46.1875, 2, 140),
+(295, 23, 41.111111111111, 4, 140),
+(296, 1, 39, 6, 140),
+(297, 1, 45, 8, 140),
+(298, 188, 44.452127659574, 2, 141),
+(299, 1, 36, 4, 141),
+(300, 2, 27, 6, 141),
+(301, 41, 41.921052631579, 2, 142),
+(302, 21, 37, 4, 142),
+(303, 1, 38, 6, 142),
+(304, 1, 54, 8, 142),
+(305, 191, 44.586387434555, 2, 143),
+(306, 2, 47.5, 4, 143),
+(307, 1, 41, 6, 143),
+(308, 1, 35, 8, 143),
+(309, 33, 49.096774193548, 2, 144),
+(310, 15, 41, 4, 144),
+(311, 143, 43.811188811189, 2, 145),
+(312, 1, 49, 4, 145),
+(313, 38, 49.966666666667, 2, 146),
+(314, 9, 44.285714285714, 4, 146),
+(315, 1, -1, 6, 146),
+(316, 111, 42.621621621622, 2, 147),
+(317, 2, 45.5, 4, 147),
+(318, 1, 19, 6, 147),
+(319, 22, 50.095238095238, 2, 148),
+(320, 13, 45.75, 4, 148),
+(321, 1, -1, 6, 148),
+(322, 132, 42.818181818182, 2, 149),
+(323, 4, 45.75, 4, 149),
+(324, 1, 34, 8, 149),
+(325, 20, 45.142857142857, 2, 150),
+(326, 10, 43.428571428571, 4, 150),
+(327, 90, 45.322222222222, 2, 151),
+(328, 2, 47, 4, 151),
+(329, 20, 48.3125, 2, 152),
+(330, 5, 34.333333333333, 4, 152),
+(331, 1, -1, 8, 152),
+(332, 66, 45.863636363636, 2, 153),
+(333, 26, 49.1, 2, 154),
+(334, 3, 42, 4, 154),
+(335, 1, -1, 6, 154),
+(336, 46, 42.630434782609, 2, 155),
+(337, 20, 45.916666666667, 2, 156),
+(338, 2, 38, 4, 156),
+(339, 45, 47.641025641026, 2, 157),
+(340, 1, 37, 4, 157),
+(341, 1, 37, 6, 157),
+(342, 16, 45.875, 2, 158),
+(343, 1, -1, 4, 158),
+(344, 51, 49.75, 2, 159),
+(345, 9, -1, 2, 160),
+(346, 1, -1, 4, 160),
+(347, 1, 46, 6, 160),
+(348, 38, 50, 2, 161),
+(349, 11, -1, 2, 162),
+(350, 5, -1, 4, 162),
+(351, 57, 50, 2, 163),
+(352, 2, -1, 4, 163),
+(353, 1, -1, 6, 163),
+(354, 5, -1, 2, 164),
+(355, 7, -1, 4, 164),
+(356, 55, 50, 2, 165),
+(357, 2, -1, 4, 165),
+(358, 5, -1, 2, 166),
+(359, 12, -1, 4, 166),
+(360, 29, 50, 2, 167),
+(361, 2, -1, 4, 167),
+(362, 7, -1, 2, 168),
+(363, 4, -1, 4, 168),
+(364, 1, -1, 6, 168),
+(365, 18, 50, 2, 169),
+(366, 10, -1, 2, 170),
+(367, 2, -1, 4, 170),
+(368, 11, -1, 2, 171),
+(369, 21, -1, 2, 172),
+(370, 17, 50, 2, 173),
+(371, 9, -1, 2, 174),
+(372, 8, 50, 2, 175),
+(373, 4, -1, 2, 176),
+(374, 7, 50, 2, 177),
+(375, 7, -1, 2, 178),
+(376, 2, -1, 2, 179),
+(377, 10, -1, 2, 180),
+(378, 5, 50, 2, 181),
+(379, 10, -1, 2, 182),
+(380, 1, -1, 8, 182),
+(381, 9, 50, 2, 183),
+(382, 9, -1, 2, 184),
+(383, 6, 50, 2, 185),
+(384, 5, -1, 2, 186),
+(385, 10, 50, 2, 187),
+(386, 7, -1, 2, 188),
+(387, 3, -1, 2, 189),
+(388, 8, -1, 2, 190),
+(389, 7, 50, 2, 191),
+(390, 1, -1, 8, 191),
+(391, 4, -1, 2, 192),
+(392, 20, 36.8, 2, 193),
+(393, 11, 36.8, 2, 194),
+(394, 11, 38.181818181818, 2, 195),
+(395, 11, 48.7, 2, 196),
+(396, 15, 33.733333333333, 2, 197),
+(397, 11, 66.666666666667, 2, 198),
+(398, 14, 44.357142857143, 2, 199),
+(399, 7, 44, 2, 200),
+(400, 7, 57.857142857143, 2, 201),
+(401, 8, 44.714285714286, 2, 202),
+(402, 14, 52.5, 2, 203),
+(403, 14, 48.846153846154, 2, 204),
+(404, 18, 38.888888888889, 2, 205),
+(405, 21, 57.947368421053, 2, 206),
+(406, 21, 48.380952380952, 2, 207),
+(407, 11, 41.090909090909, 2, 208),
+(408, 9, 49.555555555556, 2, 209),
+(409, 1, 58, 8, 209),
+(410, 13, 43.923076923077, 2, 210),
+(411, 9, 47.111111111111, 2, 211),
+(412, 9, 52.222222222222, 2, 212),
+(413, 5, 55.2, 2, 213),
+(414, 9, 43.111111111111, 2, 214),
+(415, 4, 49.5, 2, 215),
+(416, 13, 46.615384615385, 2, 216),
+(417, 3, 64.333333333333, 2, 217),
+(418, 1, 60, 2, 218),
+(419, 6, 63.5, 2, 219),
+(420, 1, -1, 8, 219),
+(421, 4, 36.25, 2, 220),
+(422, 1, -1, 2, 221),
+(423, 1, 50, 2, 222),
+(424, 19, 57.266666666667, 2, 223),
+(425, 10, 46.428571428571, 2, 224),
+(426, 12, 40.166666666667, 2, 225),
+(427, 14, 56.333333333333, 2, 226),
+(428, 31, 46.225806451613, 2, 227),
+(429, 4, 63, 2, 228),
+(430, 21, 44.809523809524, 2, 229),
+(431, 1, 41, 4, 229),
+(432, 12, 51.181818181818, 2, 230),
+(433, 17, 52.823529411765, 2, 231),
+(434, 1, 63, 4, 231),
+(435, 1, 51, 8, 231),
+(436, 25, 49.739130434783, 2, 232),
+(437, 2, 51, 6, 232),
+(438, 47, 48.574468085106, 2, 233),
+(439, 1, 45, 4, 233),
+(440, 1, 45, 8, 233),
+(441, 19, 51.473684210526, 2, 234),
+(442, 1, -1, 8, 234),
+(443, 30, 50.733333333333, 2, 235),
+(444, 25, 57.454545454545, 2, 236),
+(445, 15, 45.8, 2, 237),
+(446, 29, 55.4, 2, 238),
+(447, 40, 41.45, 2, 239),
+(448, 1, 32, 8, 239),
+(449, 43, 47.736842105263, 2, 240),
+(450, 1, -1, 6, 240),
+(451, 39, 45.948717948718, 2, 241),
+(452, 2, 35.5, 8, 241),
+(453, 54, 50.326530612245, 2, 242),
+(454, 2, 45.5, 8, 242),
+(455, 28, 42.464285714286, 2, 243),
+(456, 59, 47.372549019608, 2, 244),
+(457, 1, 45, 6, 244),
+(458, 44, 47.454545454545, 2, 245),
+(459, 38, 51.675675675676, 2, 246),
+(460, 1, 50, 6, 246),
+(461, 20, 46.3, 2, 247),
+(462, 53, 58.630434782609, 2, 248),
+(463, 1, 46, 6, 248),
+(464, 85, 43.505882352941, 2, 249),
+(465, 1, 49, 4, 249),
+(466, 35, 54.838709677419, 2, 250),
+(467, 54, 47.018518518519, 2, 251),
+(468, 1, 44, 8, 251),
+(469, 63, 47.206896551724, 2, 252),
+(470, 1, 85, 8, 252),
+(471, 55, 46.454545454545, 2, 253),
+(472, 1, 53, 4, 253),
+(473, 1, 39, 8, 253),
+(474, 53, 47.4, 2, 254),
+(475, 52, 47.115384615385, 2, 255),
+(476, 89, 49.063291139241, 2, 256),
+(477, 1, -1, 8, 256),
+(478, 51, 44.627450980392, 2, 257),
+(479, 1, 36, 8, 257),
+(480, 56, 46.980769230769, 2, 258),
+(481, 1, 53, 4, 258),
+(482, 1, 53, 8, 258),
+(483, 79, 40.126582278481, 2, 259),
+(484, 1, 25, 4, 259),
+(485, 1, 39, 8, 259),
+(486, 96, 53.102272727273, 2, 260),
+(487, 2, -1, 6, 260),
+(488, 138, 45.246376811594, 2, 261),
+(489, 78, 47.733333333333, 2, 262),
+(490, 1, 48, 8, 262),
+(491, 105, 41.628571428571, 2, 263),
+(492, 2, 43, 4, 263),
+(493, 116, 46.809523809524, 2, 264),
+(494, 1, 39, 8, 264),
+(495, 100, 44.79, 2, 265),
+(496, 114, 47.695238095238, 2, 266),
+(497, 1, 53, 6, 266),
+(498, 114, 43.956140350877, 2, 267),
+(499, 1, 51, 6, 267),
+(500, 76, 46.911764705882, 2, 268),
+(501, 103, 40.300970873786, 2, 269),
+(502, 1, 18, 8, 269),
+(503, 94, 47.857142857143, 2, 270),
+(504, 93, 43.268817204301, 2, 271),
+(505, 1, 50, 6, 271),
+(506, 79, 50.106666666667, 2, 272),
+(507, 1, 48, 4, 272),
+(508, 1, 51, 6, 272),
+(509, 118, 44.584745762712, 2, 273),
+(510, 1, 46, 6, 273),
+(511, 1, 38, 8, 273),
+(512, 71, 46.378787878788, 2, 274),
+(513, 107, 46.392523364486, 2, 275),
+(514, 2, 44.5, 4, 275),
+(515, 3, 48, 6, 275),
+(516, 92, 51.65, 2, 276),
+(517, 1, -1, 6, 276),
+(518, 136, 43.970588235294, 2, 277),
+(519, 122, 49.834782608696, 2, 278),
+(520, 3, 56, 4, 278),
+(521, 95, 44.736842105263, 2, 279),
+(522, 1, 52, 4, 279),
+(523, 1, 33, 6, 279),
+(524, 121, 47.871287128713, 2, 280),
+(525, 1, 47, 8, 280),
+(526, 126, 49.293650793651, 2, 281),
+(527, 2, 65, 4, 281),
+(528, 85, 51.645569620253, 2, 282),
+(529, 1, 49, 4, 282),
+(530, 110, 45.481818181818, 2, 283),
+(531, 99, 48.632183908046, 2, 284),
+(532, 2, 57.5, 6, 284),
+(533, 110, 47.718181818182, 2, 285),
+(534, 127, 50.719298245614, 2, 286),
+(535, 1, 16, 6, 286),
+(536, 116, 44.068965517241, 2, 287),
+(537, 1, 44, 6, 287),
+(538, 1, 43, 8, 287),
+(539, 126, 50.135135135135, 2, 288),
+(540, 3, 41.5, 4, 288),
+(541, 1, 47, 6, 288),
+(542, 101, 47.544554455446, 2, 289),
+(543, 1, 47, 8, 289),
+(544, 112, 49.533980582524, 2, 290),
+(545, 165, 43.690909090909, 2, 291),
+(546, 1, 49, 4, 291),
+(547, 1, 44, 6, 291),
+(548, 87, 47.6875, 2, 292),
+(549, 176, 44.971590909091, 2, 293),
+(550, 2, 47.5, 4, 293),
+(551, 124, 49.16814159292, 2, 294),
+(552, 1, 69, 4, 294),
+(553, 1, 23, 6, 294),
+(554, 124, 39.645161290323, 2, 295),
+(555, 119, 45.320754716981, 2, 296),
+(556, 1, -1, 4, 296),
+(557, 147, 43.299319727891, 2, 297),
+(558, 2, 41, 4, 297),
+(559, 86, 46.151898734177, 2, 298),
+(560, 141, 43.219858156028, 2, 299),
+(561, 105, 45.242424242424, 2, 300),
+(562, 142, 45.232394366197, 2, 301),
+(563, 2, 42, 4, 301),
+(564, 107, 49.336633663366, 2, 302),
+(565, 2, 47.5, 6, 302),
+(566, 158, 45.740506329114, 2, 303),
+(567, 1, 48, 4, 303),
+(568, 1, 46, 8, 303),
+(569, 126, 47.377192982456, 2, 304),
+(570, 1, 45, 6, 304),
+(571, 138, 44.789855072464, 2, 305),
+(572, 2, 44, 4, 305),
+(573, 106, 46.946808510638, 2, 306),
+(574, 1, -1, 4, 306),
+(575, 1, 43, 8, 306),
+(576, 189, 42.555555555556, 2, 307),
+(577, 1, 42, 8, 307),
+(578, 122, 49.709401709402, 2, 308),
+(579, 1, 40, 6, 308),
+(580, 151, 44.887417218543, 2, 309),
+(581, 1, 47, 4, 309),
+(582, 64, 44.693548387097, 2, 310),
+(583, 1, 55, 8, 310),
+(584, 155, 43.296774193548, 2, 311),
+(585, 90, 44.465909090909, 2, 312),
+(586, 142, 46.80985915493, 2, 313),
+(587, 145, 47.188976377953, 2, 314),
+(588, 2, 45, 4, 314),
+(589, 157, 45.108280254777, 2, 315),
+(590, 3, 43.666666666667, 6, 315),
+(591, 123, 50.954545454545, 2, 316),
+(592, 1, 41, 6, 316),
+(593, 140, 43.828571428571, 2, 317),
+(594, 1, 44, 4, 317),
+(595, 106, 47.968085106383, 2, 318),
+(596, 1, 20, 6, 318),
+(597, 145, 42.606896551724, 2, 319),
+(598, 130, 47.967213114754, 2, 320),
+(599, 1, -1, 6, 320),
+(600, 160, 45.8, 2, 321),
+(601, 2, 46, 4, 321),
+(602, 79, 48.819444444444, 2, 322),
+(603, 1, 62, 8, 322),
+(604, 167, 42.676646706587, 2, 323),
+(605, 103, 47.030612244898, 2, 324),
+(606, 204, 45.578431372549, 2, 325),
+(607, 1, 49, 4, 325),
+(608, 2, 37.5, 6, 325),
+(609, 83, 49.7625, 2, 326),
+(610, 1, 46, 4, 326),
+(611, 1, 47, 6, 326),
+(612, 134, 45.820895522388, 2, 327),
+(613, 1, 44, 8, 327),
+(614, 80, 46.647058823529, 2, 328),
+(615, 123, 47.536585365854, 2, 329),
+(616, 2, 42.5, 4, 329),
+(617, 1, 38, 6, 329),
+(618, 136, 48.161290322581, 2, 330),
+(619, 4, 31, 6, 330),
+(620, 1, 73, 8, 330),
+(621, 120, 45.308333333333, 2, 331),
+(622, 2, 50.5, 4, 331),
+(623, 1, 45, 8, 331),
+(624, 79, 46.301369863014, 2, 332),
+(625, 1, 37, 4, 332),
+(626, 1, -1, 6, 332),
+(627, 99, 44.646464646465, 2, 333),
+(628, 93, 49.566265060241, 2, 334),
+(629, 93, 45.494623655914, 2, 335),
+(630, 93, 48.441860465116, 2, 336),
+(631, 1, 52, 6, 336),
+(632, 103, 45.922330097087, 2, 337),
+(633, 93, 51.811764705882, 2, 338),
+(634, 133, 44.984962406015, 2, 339),
+(635, 61, 56.896551724138, 2, 340),
+(636, 84, 46.678571428571, 2, 341),
+(637, 73, 51.666666666667, 2, 342),
+(638, 93, 42.784946236559, 2, 343),
+(639, 1, 44, 6, 343),
+(640, 1, 42, 8, 343),
+(641, 75, 48.553846153846, 2, 344),
+(642, 117, 45.905982905983, 2, 345),
+(643, 1, 44, 8, 345),
+(644, 41, 48.722222222222, 2, 346),
+(645, 80, 45.4875, 2, 347),
+(646, 49, 49.177777777778, 2, 348),
+(647, 2, 53, 8, 348),
+(648, 87, 45.597701149425, 2, 349),
+(649, 55, 50.823529411765, 2, 350),
+(650, 61, 44.55737704918, 2, 351),
+(651, 2, 49, 4, 351),
+(652, 38, 47.527777777778, 2, 352),
+(653, 52, 48.288461538462, 2, 353),
+(654, 31, 54.965517241379, 2, 354),
+(655, 93, 40.752688172043, 2, 355),
+(656, 38, 45.763157894737, 2, 356),
+(657, 57, 44.631578947368, 2, 357),
+(658, 60, 52.728813559322, 2, 358),
+(659, 3, 46, 8, 358),
+(660, 44, 45.431818181818, 2, 359),
+(661, 9, 43.444444444444, 2, 360),
+(662, 1, 42, 8, 360),
+(663, 56, 39.803571428571, 2, 361),
+(664, 27, 53.083333333333, 2, 362),
+(665, 20, 49.65, 2, 363),
+(666, 1, 63, 8, 363),
+(667, 4, 47.75, 2, 364),
+(668, 5, 42.6, 2, 365),
+(669, 3, 79.666666666667, 2, 366),
+(670, 13, 54.333333333333, 2, 367),
+(671, 7, 47.428571428571, 2, 368),
+(672, 16, 58.333333333333, 2, 369),
+(673, 1, 45, 8, 369),
+(674, 22, 48.636363636364, 2, 370),
+(675, 10, 53, 2, 371),
+(676, 6, 54.166666666667, 2, 372),
+(677, 3, 63, 2, 373),
+(678, 62, 48.870967741935, 2, 374),
+(679, 27, 73.913043478261, 2, 375),
+(680, 39, 53.102564102564, 2, 376),
+(681, 1, 46, 8, 376),
+(682, 40, 71.333333333333, 2, 377),
+(683, 1, 57, 8, 377),
+(684, 28, 51.285714285714, 2, 378),
+(685, 3, 44.666666666667, 8, 378),
+(686, 31, 67.689655172414, 2, 379),
+(687, 1, 70, 8, 379),
+(688, 39, 51.410256410256, 2, 380),
+(689, 1, 44, 8, 380),
+(690, 24, 68.619047619048, 2, 381),
+(691, 1, -1, 8, 381),
+(692, 39, 56.564102564103, 2, 382),
+(693, 3, 42.333333333333, 8, 382),
+(694, 7, 62.142857142857, 2, 383),
+(695, 19, 49.052631578947, 2, 384),
+(696, 13, 69.583333333333, 2, 385),
+(697, 20, 48.75, 2, 386),
+(698, 1, 50, 8, 386),
+(699, 15, 59.307692307692, 2, 387),
+(700, 28, 51.785714285714, 2, 388),
+(701, 18, 66.9375, 2, 389),
+(702, 1, 44, 8, 389),
+(703, 15, 45.933333333333, 2, 390),
+(704, 17, 62.5, 2, 391),
+(705, 20, 56.8, 2, 392),
+(706, 26, 78.863636363636, 2, 393),
+(707, 18, 46.555555555556, 2, 394),
+(708, 1, 40, 8, 394),
+(709, 17, 60.125, 2, 395),
+(710, 13, 54.307692307692, 2, 396),
+(711, 1, 49, 8, 396),
+(712, 10, 71.3, 2, 397),
+(713, 1, -1, 8, 397),
+(714, 16, 59.125, 2, 398),
+(715, 19, 71.3125, 2, 399),
+(716, 1, -1, 8, 399),
+(717, 13, 52.384615384615, 2, 400),
+(718, 1, 47, 8, 400),
+(719, 11, 65.444444444444, 2, 401),
+(720, 13, 64.090909090909, 2, 402),
+(721, 1, -1, 8, 402),
+(722, 11, 55.636363636364, 2, 403),
+(723, 11, 60.3, 2, 404),
+(724, 6, 78.2, 2, 405),
+(725, 1, 53, 8, 405),
+(726, 10, 50.1, 2, 406),
+(727, 14, 72.727272727273, 2, 407),
+(728, 9, 69.5, 2, 408),
+(729, 1, -1, 6, 408),
+(730, 9, 68.222222222222, 2, 409),
+(731, 2, 44, 8, 409),
+(732, 16, 83, 2, 410),
+(733, 11, 54.727272727273, 2, 411),
+(734, 1, 47, 6, 411),
+(735, 1, 60, 8, 411),
+(736, 18, 72.1875, 2, 412),
+(737, 1, -1, 6, 412),
+(738, 21, 51.571428571429, 2, 413),
+(739, 1, 48, 4, 413),
+(740, 18, 74.764705882353, 2, 414),
+(741, 1, -1, 4, 414),
+(742, 19, 58.789473684211, 2, 415),
+(743, 1, 44, 4, 415),
+(744, 1, 75, 6, 415),
+(745, 31, 70.678571428571, 2, 416),
+(746, 2, 46, 4, 416),
+(747, 1, -1, 8, 416),
+(748, 14, 54.857142857143, 2, 417),
+(749, 1, 45, 8, 417),
+(750, 34, 64.172413793103, 2, 418),
+(751, 1, -1, 4, 418),
+(752, 1, -1, 8, 418),
+(753, 19, 49.526315789474, 2, 419),
+(754, 30, 65.44, 2, 420),
+(755, 16, 53.375, 2, 421),
+(756, 1, 51, 4, 421),
+(757, 36, 73.714285714286, 2, 422),
+(758, 2, -1, 4, 422),
+(759, 19, 51, 2, 423),
+(760, 1, 48, 4, 423),
+(761, 38, 69.636363636364, 2, 424),
+(762, 1, 46, 4, 424),
+(763, 1, -1, 6, 424),
+(764, 39, 55, 2, 425),
+(765, 1, 36, 4, 425),
+(766, 1, 43, 6, 425),
+(767, 48, 70.111111111111, 2, 426),
+(768, 1, -1, 4, 426),
+(769, 1, 48, 6, 426),
+(770, 1, 110, 8, 426),
+(771, 49, 56.979591836735, 2, 427),
+(772, 1, 48, 4, 427),
+(773, 1, 58, 6, 427),
+(774, 1, 49, 8, 427),
+(775, 62, 67.5, 2, 428),
+(776, 1, -1, 6, 428),
+(777, 1, 88, 8, 428),
+(778, 45, 56.933333333333, 2, 429),
+(779, 1, 47, 4, 429),
+(780, 1, 49, 6, 429),
+(781, 91, 68.073170731707, 2, 430),
+(782, 2, 41, 4, 430),
+(783, 2, 46, 6, 430),
+(784, 1, 58, 8, 430),
+(785, 74, 52.905405405405, 2, 431),
+(786, 2, 49.5, 4, 431),
+(787, 43, 74.775, 2, 432),
+(788, 1, 46, 8, 432),
+(789, 52, 50.5, 2, 433),
+(790, 1, 44, 6, 433),
+(791, 1, 43, 8, 433),
+(792, 86, 71.298701298701, 2, 434),
+(793, 1, 56, 4, 434),