Revize 3380c12b

refs #6847: Cron - ziskani geolokace z google locations a ulozeni do databaze

cron/dao/dao.php

@@ -117 +117 @@
             if ($townId < 0) {
                 $query .= "('$id', '".$location->town."');";
             } else {
-                $query .= "('$id', '".$location->street."', '$townId');";
+                // Jestlize ulice v DB jeste neexistuje, nastavit geolokaci (nema smysl zem. sirku a delku zjistovat driv - nejedna se o dulezite informace pro CRON).
+                $location->setGeolocation();
+                $query .= "('$id', '".$location->street."', '$townId', '".$location->lat."', '".$location->lng."');";
             }
             
             // Vlozeni zaznamu do tabulky.

cron/location.php

@@ -11 +11 @@
     // Nepouzivane.
     // public $area;
     
+    // --- ZEMEPISNA SIRKA A DELKA A UDAJE POTREBNE K JEJICH ZJISTENI. ---
+    
+    private $key;
+    private $region;
+    
+    public $lat;
+    public $lng;
+    
     public function __construct($data) {
         $this->name = $data[0];
         $this->town = $data[1];
         $this->street = $data[2];
         $this->device = substr($data[3], 2);
         // $this->area = $data[4];
+        
+        $this->key = "AIzaSyCSx7hyAzQiG5uocJTeZgf1Z3lpDy4kpEk";
+        $this->region = "cz";
+        $this->lat = -1;
+        $this->lng = -1;
+    }
+    
+    // V pripade problemu, se ziskanim souboru protokolem HTTPS, v php.ini odkomentovat "extension=php_openssl.dll".
+    public function setGeolocation() {
+        $address = $this->town;
+        if ($this->town != $this->street) {
+            $address .= " ".$this->street;
+        }
+        $address = str_replace(" ", "+", $address); // Nemusi byt, jen pro jistotu.
+        
+        $json = file_get_contents("https://maps.google.com/maps/api/geocode/json?address=$address&sensor=false&region=".$this->region."&key=".$this->key);
+        $json = json_decode($json, TRUE);
+        if ($json["status"] == "OK") {
+            $this->lat = $json["results"]["0"]["geometry"]["location"]["lat"];
+            $this->lng = $json["results"]["0"]["geometry"]["location"]["lng"];
+        } else {
+            $this->lat = -1;
+            $this->lng = -1;
+        }
     }
     
 }

db/v3__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: Pon 21. kvě 2018, 10:23
+-- 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`
+--
+
+-- --------------------------------------------------------
+
+--
+-- 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.3830033, 13.2964474),
+(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.6367883, 13.1659718),
+(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 `vozidla`
+--
+
+CREATE TABLE IF NOT EXISTS `vozidla` (
+  `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 `vozidla`
+--
+
+INSERT INTO `vozidla` (`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, 4.1666666666667, 2, 1),
+(2, 13, 0, 2, 2),
+(3, 7, 14.285714285714, 2, 3),
+(4, 4, 0, 2, 4),
+(5, 6, 16.666666666667, 2, 5),
+(6, 8, 0, 2, 6),
+(7, 6, 16.666666666667, 2, 7),
+(8, 7, 0, 2, 8),
+(9, 1, 0, 8, 8),
+(10, 6, 0, 2, 9),
+(11, 4, 0, 2, 10),
+(12, 3, 16.666666666667, 2, 11),
+(13, 11, 0, 2, 12),
+(14, 3, 0, 2, 13),
+(15, 5, 0, 2, 14),
+(16, 7, 14.285714285714, 2, 15),
+(17, 3, 0, 2, 16),
+(18, 2, 0, 2, 17),
+(19, 12, 0, 2, 18),
+(20, 5, 0, 2, 19),
+(21, 7, 0, 2, 20),
+(22, 1, 0, 2, 21),
+(23, 7, 0, 2, 22),
+(24, 1, 0, 8, 22),
+(25, 3, 0, 2, 23),
+(26, 5, 0, 2, 24),
+(27, 3, 0, 2, 25),
+(28, 3, 0, 2, 26),
+(29, 3, 0, 2, 27),
+(30, 3, 0, 2, 28),
+(31, 1, 0, 2, 29),
+(32, 6, 0, 2, 30),
+(33, 10, 10, 2, 31),
+(34, 10, 0, 2, 32),
+(35, 4, 12.5, 2, 33),
+(36, 7, 0, 2, 34),
+(37, 4, 0, 2, 35),
+(38, 4, 0, 2, 36),
+(39, 1, 0, 6, 37),
+(40, 2, 0, 2, 38),
+(41, 3, 0, 6, 38),
+(42, 1, 0, 2, 39),
+(43, 1, 0, 6, 39),
+(44, 1, 0, 2, 40),
+(45, 5, 20, 2, 41),
+(46, 8, 0, 2, 42),
+(47, 2, 0, 4, 42),
+(48, 1, 0, 8, 42),
+(49, 10, 35, 2, 43),
+(50, 1, 0, 4, 43),
+(51, 2, 0, 2, 44),
+(52, 3, 0, 4, 44),
+(53, 7, 28.571428571429, 2, 45),
+(54, 2, 0, 2, 46),
+(55, 3, 0, 4, 46),
+(56, 10, 25, 2, 47),
+(57, 4, 0, 2, 48),
+(58, 1, 0, 4, 48),
+(59, 3, 50, 2, 49),
+(60, 2, 0, 4, 49),
+(61, 1, 0, 6, 49),
+(62, 3, 0, 2, 50),
+(63, 4, 0, 4, 50),
+(64, 11, 27.272727272727, 2, 51),
+(65, 1, 0, 2, 52),
+(66, 6, 0, 4, 52),
+(67, 23, 26.086956521739, 2, 53),
+(68, 2, 0, 2, 54),
+(69, 6, 0, 4, 54),
+(70, 1, 0, 6, 54),
+(71, 2, 0, 8, 54),
+(72, 34, 29.411764705882, 2, 55),
+(73, 2, 0, 4, 55),
+(74, 2, 0, 6, 55),
+(75, 2, 0, 2, 56),
+(76, 3, 0, 4, 56),
+(77, 2, 0, 6, 56),
+(78, 11, 27.272727272727, 2, 57),
+(79, 1, 0, 4, 57),
+(80, 4, 0, 2, 58),
+(81, 9, 0, 4, 58),
+(82, 2, 0, 6, 58),
+(83, 1, 0, 8, 58),
+(84, 19, 26.315789473684, 2, 59),
+(85, 1, 0, 2, 60),
+(86, 5, 0, 4, 60),
+(87, 23, 28.260869565217, 2, 61),
+(88, 1, 0, 6, 61),
+(89, 1, 0, 8, 61),
+(90, 2, 0, 2, 62),
+(91, 5, 0, 4, 62),
+(92, 16, 28.125, 2, 63),
+(93, 1, 0, 4, 63),
+(94, 9, 0, 4, 64),
+(95, 34, 42.794117647059, 2, 65),
+(96, 3, 18, 6, 65),
+(97, 5, 10.8, 2, 66),
+(98, 5, 0, 4, 66),
+(99, 1, 0, 6, 66),
+(100, 172, 48.78488372093, 2, 67),
+(101, 2, 42.5, 4, 67),
+(102, 13, 38.230769230769, 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, 31.428571428571, 4, 70),
+(108, 1, 0, 6, 70),
+(109, 41, 47.951219512195, 2, 71),
+(110, 35, 36, 2, 72),
+(111, 4, 25, 4, 72),
+(112, 107, 46.859813084112, 2, 73),
+(113, 1, 29, 4, 73),
+(114, 40, 45.025, 2, 74),
+(115, 4, 24, 4, 74),
+(116, 43, 47.093023255814, 2, 75),
+(117, 45, 39.266666666667, 2, 76),
+(118, 5, 13.8, 4, 76),
+(119, 2, 25.5, 6, 76),
+(120, 61, 48.360655737705, 2, 77),
+(121, 1, 43, 4, 77),
+(122, 46, 44.913043478261, 2, 78),
+(123, 6, 41.666666666667, 4, 78),
+(124, 1, 43, 6, 78),
+(125, 117, 43.461538461538, 2, 79),
+(126, 62, 45.516129032258, 2, 80),
+(127, 1, 38, 4, 80),
+(128, 111, 42.054054054054, 2, 81),
+(129, 2, 36.5, 4, 81),
+(130, 86, 36.558139534884, 2, 82),
+(131, 12, 22.083333333333, 4, 82),
+(132, 1, 48, 8, 82),
+(133, 112, 46.357142857143, 2, 83),
+(134, 1, 46, 6, 83),
+(135, 57, 45.105263157895, 2, 84),
+(136, 7, 28.142857142857, 4, 84),
+(137, 84, 43.928571428571, 2, 85),
+(138, 2, 45.5, 4, 85),
+(139, 1, 47, 6, 85),
+(140, 85, 41.223529411765, 2, 86),
+(141, 8, 18.25, 4, 86),
+(142, 102, 43.745098039216, 2, 87),
+(143, 1, 47, 6, 87),
+(144, 79, 41.544303797468, 2, 88),
+(145, 4, 0, 4, 88),
+(146, 1, 0, 6, 88),
+(147, 1, 52, 8, 88),
+(148, 128, 42.921875, 2, 89),
+(149, 77, 41.428571428571, 2, 90),
+(150, 15, 37.466666666667, 4, 90),
+(151, 1, 0, 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, 36.066666666667, 2, 92),
+(157, 16, 27.875, 4, 92),
+(158, 1, 0, 6, 92),
+(159, 129, 44.426356589147, 2, 93),
+(160, 1, 48, 4, 93),
+(161, 2, 47, 6, 93),
+(162, 114, 33.561403508772, 2, 94),
+(163, 17, 16.823529411765, 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, 38.079207920792, 2, 96),
+(169, 23, 19.608695652174, 4, 96),
+(170, 1, 0, 6, 96),
+(171, 149, 42.637583892617, 2, 97),
+(172, 2, 22, 4, 97),
+(173, 1, 42, 6, 97),
+(174, 89, 35.685393258427, 2, 98),
+(175, 24, 17.5, 4, 98),
+(176, 1, 32, 8, 98),
+(177, 100, 34.79, 2, 99),
+(178, 2, 20, 4, 99),
+(179, 60, 27.983333333333, 2, 100),
+(180, 21, 9.3333333333333, 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, 29.847457627119, 2, 102),
+(187, 18, 16.833333333333, 4, 102),
+(188, 1, 0, 6, 102),
+(189, 118, 42.864406779661, 2, 103),
+(190, 1, 50, 6, 103),
+(191, 55, 25.036363636364, 2, 104),
+(192, 16, 18.75, 4, 104),
+(193, 1, 39, 6, 104),
+(194, 97, 42.319587628866, 2, 105),
+(195, 2, 44.5, 4, 105),
+(196, 49, 23.265306122449, 2, 106),
+(197, 21, 27, 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, 28.352941176471, 2, 108),
+(204, 13, 29.307692307692, 4, 108),
+(205, 137, 45.693430656934, 2, 109),
+(206, 1, 42, 6, 109),
+(207, 50, 30.82, 2, 110),
+(208, 27, 29.074074074074, 4, 110),
+(209, 1, 40, 6, 110),
+(210, 2, 0, 8, 110),
+(211, 180, 45.766666666667, 2, 111),
+(212, 1, 44, 6, 111),
+(213, 44, 24.159090909091, 2, 112),
+(214, 21, 33.952380952381, 4, 112),
+(215, 1, 0, 6, 112),
+(216, 155, 43.967741935484, 2, 113),
+(217, 1, 44, 4, 113),
+(218, 1, 46, 8, 113),
+(219, 37, 25.837837837838, 2, 114),
+(220, 24, 26.583333333333, 4, 114),
+(221, 1, 47, 6, 114),
+(222, 188, 41.43085106383, 2, 115),
+(223, 2, 41.5, 6, 115),
+(224, 39, 25.230769230769, 2, 116),
+(225, 21, 19.666666666667, 4, 116),
+(226, 1, 0, 6, 116),
+(227, 1, 45, 8, 116),
+(228, 193, 43.844559585492, 2, 117),
+(229, 47, 28.191489361702, 2, 118),
+(230, 15, 28.066666666667, 4, 118),
+(231, 1, 0, 6, 118),
+(232, 156, 43.410256410256, 2, 119),
+(233, 1, 31, 4, 119),
+(234, 1, 29, 6, 119),
+(235, 52, 34.903846153846, 2, 120),
+(236, 14, 17.785714285714, 4, 120),
+(237, 2, 21, 6, 120),
+(238, 161, 45.142857142857, 2, 121),
+(239, 1, 40, 8, 121),
+(240, 54, 31.777777777778, 2, 122),
+(241, 27, 28.592592592593, 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, 38.027027027027, 2, 124),
+(247, 25, 30.32, 4, 124),
+(248, 1, 40, 6, 124),
+(249, 197, 45.61421319797, 2, 125),
+(250, 2, 45.5, 4, 125),
+(251, 38, 42.263157894737, 2, 126),
+(252, 15, 27.4, 4, 126),
+(253, 1, 42, 8, 126),
+(254, 215, 43.037209302326, 2, 127),
+(255, 1, 49, 4, 127),
+(256, 1, 38, 8, 127),
+(257, 39, 36.615384615385, 2, 128),
+(258, 20, 35.45, 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, 37.918918918919, 2, 130),
+(265, 17, 20.117647058824, 4, 130),
+(266, 1, 41, 6, 130),
+(267, 1, 0, 8, 130),
+(268, 177, 44.542372881356, 2, 131),
+(269, 1, 40, 4, 131),
+(270, 1, 46, 8, 131),
+(271, 44, 39.090909090909, 2, 132),
+(272, 15, 34.533333333333, 4, 132),
+(273, 161, 43.739130434783, 2, 133),
+(274, 1, 40, 6, 133),
+(275, 1, 38, 8, 133),
+(276, 32, 42.75, 2, 134),
+(277, 13, 22.692307692308, 4, 134),
+(278, 1, 25, 6, 134),
+(279, 2, 20.5, 8, 134),
+(280, 138, 43.565217391304, 2, 135),
+(281, 1, 44, 4, 135),
+(282, 1, 38, 8, 135),
+(283, 26, 37.846153846154, 2, 136),
+(284, 9, 30.222222222222, 4, 136),
+(285, 1, 39, 6, 136),
+(286, 176, 43.926136363636, 2, 137),
+(287, 1, 42, 8, 137),
+(288, 51, 38.470588235294, 2, 138),
+(289, 22, 24.045454545455, 4, 138),
+(290, 1, 0, 8, 138),
+(291, 162, 45.246913580247, 2, 139),
+(292, 3, 46, 4, 139),
+(293, 2, 46.5, 8, 139),
+(294, 43, 34.372093023256, 2, 140),
+(295, 23, 16.086956521739, 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, 38.853658536585, 2, 142),
+(302, 21, 21.142857142857, 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, 46.121212121212, 2, 144),
+(310, 15, 30.066666666667, 4, 144),
+(311, 143, 43.811188811189, 2, 145),
+(312, 1, 49, 4, 145),
+(313, 38, 39.447368421053, 2, 146),
+(314, 9, 34.444444444444, 4, 146),
+(315, 1, 0, 6, 146),
+(316, 111, 42.621621621622, 2, 147),
+(317, 2, 45.5, 4, 147),
+(318, 1, 19, 6, 147),
+(319, 22, 47.818181818182, 2, 148),
+(320, 13, 28.153846153846, 4, 148),
+(321, 1, 0, 6, 148),
+(322, 132, 42.818181818182, 2, 149),
+(323, 4, 45.75, 4, 149),
+(324, 1, 34, 8, 149),
+(325, 20, 31.6, 2, 150),
+(326, 10, 30.4, 4, 150),
+(327, 90, 45.322222222222, 2, 151),
+(328, 2, 47, 4, 151),
+(329, 20, 38.65, 2, 152),
+(330, 5, 20.6, 4, 152),
+(331, 1, 0, 8, 152),
+(332, 66, 45.863636363636, 2, 153),
+(333, 26, 37.769230769231, 2, 154),
+(334, 3, 14, 4, 154),
+(335, 1, 0, 6, 154),
+(336, 46, 42.630434782609, 2, 155),
+(337, 20, 27.55, 2, 156),
+(338, 2, 19, 4, 156),
+(339, 45, 41.288888888889, 2, 157),
+(340, 1, 37, 4, 157),
+(341, 1, 37, 6, 157),
+(342, 16, 22.9375, 2, 158),
+(343, 1, 0, 4, 158),
+(344, 51, 27.313725490196, 2, 159),
+(345, 9, 0, 2, 160),
+(346, 1, 0, 4, 160),
+(347, 1, 46, 6, 160),
+(348, 38, 28.947368421053, 2, 161),
+(349, 11, 0, 2, 162),
+(350, 5, 0, 4, 162),
+(351, 57, 26.315789473684, 2, 163),
+(352, 2, 0, 4, 163),
+(353, 1, 0, 6, 163),
+(354, 5, 0, 2, 164),
+(355, 7, 0, 4, 164),
+(356, 55, 30, 2, 165),
+(357, 2, 0, 4, 165),
+(358, 5, 0, 2, 166),
+(359, 12, 0, 4, 166),
+(360, 29, 31.034482758621, 2, 167),
+(361, 2, 0, 4, 167),
+(362, 7, 0, 2, 168),
+(363, 4, 0, 4, 168),
+(364, 1, 0, 6, 168),
+(365, 18, 22.222222222222, 2, 169),
+(366, 10, 0, 2, 170),
+(367, 2, 0, 4, 170),
+(368, 11, 0, 2, 171),
+(369, 21, 0, 2, 172),
+(370, 17, 8.8235294117647, 2, 173),
+(371, 9, 0, 2, 174),
+(372, 8, 6.25, 2, 175),
+(373, 4, 0, 2, 176),
+(374, 7, 14.285714285714, 2, 177),
+(375, 7, 0, 2, 178),
+(376, 2, 0, 2, 179),
+(377, 10, 0, 2, 180),
+(378, 5, 10, 2, 181),
+(379, 10, 0, 2, 182),
+(380, 1, 0, 8, 182),
+(381, 9, 16.666666666667, 2, 183),
+(382, 9, 0, 2, 184),
+(383, 6, 16.666666666667, 2, 185),
+(384, 5, 0, 2, 186),
+(385, 10, 10, 2, 187),
+(386, 7, 0, 2, 188),
+(387, 3, 0, 2, 189),
+(388, 8, 0, 2, 190),
+(389, 7, 14.285714285714, 2, 191),
+(390, 1, 0, 8, 191),
+(391, 4, 0, 2, 192),
+(392, 20, 36.8, 2, 193),
+(393, 11, 33.454545454545, 2, 194),
+(394, 11, 38.181818181818, 2, 195),
+(395, 11, 44.272727272727, 2, 196),
+(396, 15, 33.733333333333, 2, 197),
+(397, 11, 54.545454545455, 2, 198),
+(398, 14, 44.357142857143, 2, 199),
+(399, 7, 37.714285714286, 2, 200),
+(400, 7, 57.857142857143, 2, 201),
+(401, 8, 39.125, 2, 202),
+(402, 14, 52.5, 2, 203),
+(403, 14, 45.357142857143, 2, 204),
+(404, 18, 38.888888888889, 2, 205),
+(405, 21, 52.428571428571, 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, 0, 8, 219),
+(421, 4, 36.25, 2, 220),
+(422, 1, 0, 2, 221),
+(423, 1, 50, 2, 222),
+(424, 19, 45.210526315789, 2, 223),
+(425, 10, 32.5, 2, 224),
+(426, 12, 40.166666666667, 2, 225),
+(427, 14, 48.285714285714, 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, 46.916666666667, 2, 230),
+(433, 17, 52.823529411765, 2, 231),
+(434, 1, 63, 4, 231),
+(435, 1, 51, 8, 231),
+(436, 25, 45.76, 2, 232),
+(437, 2, 25.5, 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, 0, 8, 234),
+(443, 30, 50.733333333333, 2, 235),
+(444, 25, 50.56, 2, 236),
+(445, 15, 45.8, 2, 237),
+(446, 29, 47.758620689655, 2, 238),
+(447, 40, 41.45, 2, 239),
+(448, 1, 32, 8, 239),
+(449, 43, 42.186046511628, 2, 240),
+(450, 1, 0, 6, 240),
+(451, 39, 45.948717948718, 2, 241),
+(452, 2, 35.5, 8, 241),
+(453, 54, 45.666666666667, 2, 242),
+(454, 2, 45.5, 8, 242),
+(455, 28, 42.464285714286, 2, 243),
+(456, 59, 40.949152542373, 2, 244),
+(457, 1, 45, 6, 244),
+(458, 44, 47.454545454545, 2, 245),
+(459, 38, 50.315789473684, 2, 246),
+(460, 1, 50, 6, 246),
+(461, 20, 46.3, 2, 247),
+(462, 53, 50.88679245283, 2, 248),
+(463, 1, 46, 6, 248),
+(464, 85, 43.505882352941, 2, 249),
+(465, 1, 49, 4, 249),
+(466, 35, 48.571428571429, 2, 250),
+(467, 54, 47.018518518519, 2, 251),
+(468, 1, 44, 8, 251),
+(469, 63, 43.460317460317, 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, 40.245283018868, 2, 254),
+(475, 52, 47.115384615385, 2, 255),
+(476, 89, 43.550561797753, 2, 256),
+(477, 1, 0, 8, 256),
+(478, 51, 44.627450980392, 2, 257),
+(479, 1, 36, 8, 257),
+(480, 56, 43.625, 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, 48.677083333333, 2, 260),
+(487, 2, 0, 6, 260),
+(488, 138, 45.246376811594, 2, 261),
+(489, 78, 45.897435897436, 2, 262),
+(490, 1, 48, 8, 262),
+(491, 105, 41.628571428571, 2, 263),
+(492, 2, 43, 4, 263),
+(493, 116, 42.370689655172, 2, 264),
+(494, 1, 39, 8, 264),
+(495, 100, 44.79, 2, 265),
+(496, 114, 43.929824561404, 2, 266),
+(497, 1, 53, 6, 266),
+(498, 114, 43.956140350877, 2, 267),
+(499, 1, 51, 6, 267),
+(500, 76, 41.973684210526, 2, 268),
+(501, 103, 40.300970873786, 2, 269),
+(502, 1, 18, 8, 269),
+(503, 94, 42.765957446809, 2, 270),
+(504, 93, 43.268817204301, 2, 271),
+(505, 1, 50, 6, 271),
+(506, 79, 47.569620253165, 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, 43.112676056338, 2, 274),
+(513, 107, 46.392523364486, 2, 275),
+(514, 2, 44.5, 4, 275),
+(515, 3, 48, 6, 275),
+(516, 92, 44.913043478261, 2, 276),
+(517, 1, 0, 6, 276),
+(518, 136, 43.970588235294, 2, 277),
+(519, 122, 46.975409836066, 2, 278),
+(520, 3, 18.666666666667, 4, 278),
+(521, 95, 44.736842105263, 2, 279),
+(522, 1, 52, 4, 279),
+(523, 1, 33, 6, 279),
+(524, 121, 39.95867768595, 2, 280),
+(525, 1, 47, 8, 280),
+(526, 126, 49.293650793651, 2, 281),
+(527, 2, 65, 4, 281),
+(528, 85, 48, 2, 282),
+(529, 1, 49, 4, 282),
+(530, 110, 45.481818181818, 2, 283),
+(531, 99, 42.737373737374, 2, 284),
+(532, 2, 57.5, 6, 284),
+(533, 110, 47.718181818182, 2, 285),
+(534, 127, 45.527559055118, 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, 44.166666666667, 2, 288),
+(540, 3, 27.666666666667, 4, 288),
+(541, 1, 47, 6, 288),
+(542, 101, 47.544554455446, 2, 289),
+(543, 1, 47, 8, 289),
+(544, 112, 45.553571428571, 2, 290),
+(545, 165, 43.690909090909, 2, 291),
+(546, 1, 49, 4, 291),
+(547, 1, 44, 6, 291),
+(548, 87, 43.850574712644, 2, 292),
+(549, 176, 44.971590909091, 2, 293),
+(550, 2, 47.5, 4, 293),
+(551, 124, 44.806451612903, 2, 294),
+(552, 1, 69, 4, 294),
+(553, 1, 23, 6, 294),
+(554, 124, 39.645161290323, 2, 295),
+(555, 119, 40.36974789916, 2, 296),
+(556, 1, 0, 4, 296),
+(557, 147, 43.299319727891, 2, 297),
+(558, 2, 41, 4, 297),
+(559, 86, 42.395348837209, 2, 298),
+(560, 141, 43.219858156028, 2, 299),
+(561, 105, 42.657142857143, 2, 300),
+(562, 142, 45.232394366197, 2, 301),
+(563, 2, 42, 4, 301),
+(564, 107, 46.570093457944, 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, 42.865079365079, 2, 304),
+(570, 1, 45, 6, 304),
+(571, 138, 44.789855072464, 2, 305),
+(572, 2, 44, 4, 305),
+(573, 106, 41.632075471698, 2, 306),
+(574, 1, 0, 4, 306),
+(575, 1, 43, 8, 306),
+(576, 189, 42.555555555556, 2, 307),
+(577, 1, 42, 8, 307),
+(578, 122, 47.672131147541, 2, 308),
+(579, 1, 40, 6, 308),
+(580, 151, 44.887417218543, 2, 309),
+(581, 1, 47, 4, 309),
+(582, 64, 43.296875, 2, 310),
+(583, 1, 55, 8, 310),
+(584, 155, 43.296774193548, 2, 311),
+(585, 90, 43.477777777778, 2, 312),
+(586, 142, 46.80985915493, 2, 313),
+(587, 145, 41.331034482759, 2, 314),
+(588, 2, 22.5, 4, 314),
+(589, 157, 45.108280254777, 2, 315),
+(590, 3, 43.666666666667, 6, 315),
+(591, 123, 45.569105691057, 2, 316),
+(592, 1, 41, 6, 316),
+(593, 140, 43.828571428571, 2, 317),
+(594, 1, 44, 4, 317),
+(595, 106, 42.537735849057, 2, 318),
+(596, 1, 20, 6, 318),
+(597, 145, 42.606896551724, 2, 319),
+(598, 130, 45.015384615385, 2, 320),
+(599, 1, 0, 6, 320),
+(600, 160, 45.8, 2, 321),
+(601, 2, 46, 4, 321),
+(602, 79, 44.493670886076, 2, 322),
+(603, 1, 62, 8, 322),
+(604, 167, 42.676646706587, 2, 323),
+(605, 103, 44.747572815534, 2, 324),
+(606, 204, 45.578431372549, 2, 325),
+(607, 1, 49, 4, 325),
+(608, 2, 37.5, 6, 325),
+(609, 83, 47.963855421687, 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, 39.65, 2, 328),
+(615, 123, 47.536585365854, 2, 329),
+(616, 2, 42.5, 4, 329),
+(617, 1, 38, 6, 329),
+(618, 136, 43.911764705882, 2, 330),
+(619, 4, 23.25, 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, 42.784810126582, 2, 332),
+(625, 1, 37, 4, 332),
+(626, 1, 0, 6, 332),
+(627, 99, 44.646464646465, 2, 333),
+(628, 93, 44.236559139785, 2, 334),
+(629, 93, 45.494623655914, 2, 335),
+(630, 93, 44.795698924731, 2, 336),
+(631, 1, 52, 6, 336),
+(632, 103, 45.922330097087, 2, 337),
+(633, 93, 47.354838709677, 2, 338),
+(634, 133, 44.984962406015, 2, 339),
+(635, 61, 54.098360655738, 2, 340),
+(636, 84, 46.678571428571, 2, 341),
+(637, 73, 48.835616438356, 2, 342),
+(638, 93, 42.784946236559, 2, 343),
+(639, 1, 44, 6, 343),
+(640, 1, 42, 8, 343),
+(641, 75, 42.08, 2, 344),
+(642, 117, 45.905982905983, 2, 345),
+(643, 1, 44, 8, 345),
+(644, 41, 42.780487804878, 2, 346),
+(645, 80, 45.4875, 2, 347),
+(646, 49, 45.163265306122, 2, 348),
+(647, 2, 53, 8, 348),
+(648, 87, 45.597701149425, 2, 349),
+(649, 55, 47.127272727273, 2, 350),
+(650, 61, 44.55737704918, 2, 351),
+(651, 2, 49, 4, 351),
+(652, 38, 45.026315789474, 2, 352),
+(653, 52, 48.288461538462, 2, 353),
+(654, 31, 51.41935483871, 2, 354),
+(655, 93, 40.752688172043, 2, 355),
+(656, 38, 45.763157894737, 2, 356),
+(657, 57, 44.631578947368, 2, 357),
+(658, 60, 51.85, 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, 47.185185185185, 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, 50.153846153846, 2, 367),
+(671, 7, 47.428571428571, 2, 368),
+(672, 16, 54.6875, 2, 369),
+(673, 1, 45, 8, 369),
+(674, 22, 48.636363636364, 2, 370),
+(675, 10, 47.7, 2, 371),
+(676, 6, 54.166666666667, 2, 372),
+(677, 3, 63, 2, 373),
+(678, 62, 48.870967741935, 2, 374),
+(679, 27, 62.962962962963, 2, 375),
+(680, 39, 53.102564102564, 2, 376),
+(681, 1, 46, 8, 376),
+(682, 40, 64.2, 2, 377),
+(683, 1, 57, 8, 377),
+(684, 28, 51.285714285714, 2, 378),
+(685, 3, 44.666666666667, 8, 378),
+(686, 31, 63.322580645161, 2, 379),
+(687, 1, 70, 8, 379),
+(688, 39, 51.410256410256, 2, 380),
+(689, 1, 44, 8, 380),
+(690, 24, 60.041666666667, 2, 381),
+(691, 1, 0, 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, 64.230769230769, 2, 385),
+(697, 20, 48.75, 2, 386),
+(698, 1, 50, 8, 386),
+(699, 15, 51.4, 2, 387),
+(700, 28, 51.785714285714, 2, 388),
+(701, 18, 59.5, 2, 389),
+(702, 1, 44, 8, 389),
+(703, 15, 45.933333333333, 2, 390),
+(704, 17, 58.823529411765, 2, 391),
+(705, 20, 56.8, 2, 392),
+(706, 26, 66.730769230769, 2, 393),
+(707, 18, 46.555555555556, 2, 394),
+(708, 1, 40, 8, 394),
+(709, 17, 56.588235294118, 2, 395),
+(710, 13, 54.307692307692, 2, 396),
+(711, 1, 49, 8, 396),
+(712, 10, 71.3, 2, 397),
+(713, 1, 0, 8, 397),
+(714, 16, 59.125, 2, 398),
+(715, 19, 60.052631578947, 2, 399),
+(716, 1, 0, 8, 399),
+(717, 13, 52.384615384615, 2, 400),
+(718, 1, 47, 8, 400),
+(719, 11, 53.545454545455, 2, 401),
+(720, 13, 54.230769230769, 2, 402),
+(721, 1, 0, 8, 402),
+(722, 11, 55.636363636364, 2, 403),
+(723, 11, 54.818181818182, 2, 404),
+(724, 6, 65.166666666667, 2, 405),
+(725, 1, 53, 8, 405),
+(726, 10, 50.1, 2, 406),
+(727, 14, 57.142857142857, 2, 407),
+(728, 9, 61.777777777778, 2, 408),
+(729, 1, 0, 6, 408),
+(730, 9, 68.222222222222, 2, 409),
+(731, 2, 44, 8, 409),
+(732, 16, 62.25, 2, 410),
+(733, 11, 54.727272727273, 2, 411),
+(734, 1, 47, 6, 411),
+(735, 1, 60, 8, 411),
+(736, 18, 64.166666666667, 2, 412),
+(737, 1, 0, 6, 412),
+(738, 21, 51.571428571429, 2, 413),
+(739, 1, 48, 4, 413),
+(740, 18, 70.611111111111, 2, 414),
+(741, 1, 0, 4, 414),
+(742, 19, 58.789473684211, 2, 415),
+(743, 1, 44, 4, 415),
+(744, 1, 75, 6, 415),
+(745, 31, 63.838709677419, 2, 416),
+(746, 2, 23, 4, 416),
+(747, 1, 0, 8, 416),
+(748, 14, 54.857142857143, 2, 417),
+(749, 1, 45, 8, 417),
+(750, 34, 54.735294117647, 2, 418),
+(751, 1, 0, 4, 418),
+(752, 1, 0, 8, 418),
+(753, 19, 49.526315789474, 2, 419),
+(754, 30, 54.533333333333, 2, 420),
+(755, 16, 53.375, 2, 421),
+(756, 1, 51, 4, 421),
+(757, 36, 57.333333333333, 2, 422),
+(758, 2, 0, 4, 422),
+(759, 19, 51, 2, 423),
+(760, 1, 48, 4, 423),
+(761, 38, 60.473684210526, 2, 424),
+(762, 1, 46, 4, 424),
+(763, 1, 0, 6, 424),
+(764, 39, 55, 2, 425),
+(765, 1, 36, 4, 425),
+(766, 1, 43, 6, 425),
+(767, 48, 65.729166666667, 2, 426),
+(768, 1, 0, 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, 58.790322580645, 2, 428),
+(776, 1, 0, 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, 61.340659340659, 2, 430),
+(782, 2, 20.5, 4, 430),
+(783, 2, 23, 6, 430),
+(784, 1, 58, 8, 430),
+(785, 74, 52.905405405405, 2, 431),
+(786, 2, 49.5, 4, 431),
+(787, 43, 69.558139534884, 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, 63.837209302326, 2, 434),
+(793, 1, 56, 4, 434),
+(794, 1, 46, 6, 434),
+(795, 70, 59.442857142857, 2, 435),
+(796, 2, 63.5, 4, 435),
+(797, 103, 60, 2, 436),
+(798, 2, 23.5, 4, 436),
+(799, 110, 56.018181818182, 2, 437),
+(800, 1, 44, 4, 437),
+(801, 2, 49.5, 8, 437),
+(802, 130, 58.7, 2, 438),
+(803, 3, 35.666666666667, 4, 438),
+(804, 98, 52.102040816327, 2, 439),
+(805, 3, 49.666666666667, 4, 439),
+(806, 5, 47.2, 6, 439),
+(807, 107, 58.084112149533, 2, 440),
+(808, 1, 41, 4, 440),
+(809, 3, 38.333333333333, 8, 440),
+(810, 91, 55.043956043956, 2, 441),
+(811, 1, 50, 4, 441),
+(812, 2, 55, 6, 441),
+(813, 175, 54.748571428571, 2, 442),
+(814, 3, 33.333333333333, 4, 442),
+(815, 1, 85, 6, 442),
+(816, 111, 52.702702702703, 2, 443),
+(817, 2, 54.5, 4, 443),
+(818, 2, 52, 8, 443),
+(819, 156, 55.75641025641, 2, 444),
+(820, 1, 53, 8, 444),
+(821, 123, 51.414634146341, 2, 445),
+(822, 1, 48, 6, 445),
+(823, 165, 49.436363636364, 2, 446),
+(824, 115, 53.652173913043, 2, 447),
+(825, 2, 51.5, 4, 447),
+(826, 179, 53.608938547486, 2, 448),
+(827, 1, 0, 6, 448),
+(828, 53, 56.584905660377, 2, 449),
+(829, 64, 45, 2, 450),
+(830, 75, 50.573333333333, 2, 451),
+(831, 106, 60.669811320755, 2, 452),
+(832, 73, 52.095890410959, 2, 453),
+(833, 98, 56.510204081633, 2, 454),
+(834, 1, 0, 8, 454),
+(835, 56, 51.160714285714, 2, 455),
+(836, 53, 56.905660377358, 2, 456),
+(837, 52, 53, 2, 457),
+(838, 51, 66, 2, 458),
+(839, 37, 48.513513513514, 2, 459),
+(840, 20, 54.8, 2, 460),
+(841, 63, 50.587301587302, 2, 461),
+(842, 20, 67.6, 2, 462),
+(843, 52, 50.076923076923, 2, 463),
+(844, 25, 61.24, 2, 464),
+(845, 22, 46.318181818182, 2, 465),
+(846, 33, 57.272727272727, 2, 466),
+(847, 2, 48, 8, 466),
+(848, 36, 52.75, 2, 467),
+(849, 1, 58, 8, 467),
+(850, 25, 67, 2, 468),
+(851, 1, 0, 8, 468),
+(852, 32, 55.3125, 2, 469),
+(853, 1, 46, 8, 469),
+(854, 13, 60.692307692308, 2, 470),
+(855, 29, 53.620689655172, 2, 471),
+(856, 1, 47, 8, 471),
+(857, 18, 71.388888888889, 2, 472),
+(858, 2, 0, 8, 472),
+(859, 43, 48, 2, 473),
+(860, 24, 59.875, 2, 474),
+(861, 43, 50.511627906977, 2, 475),
+(862, 15, 54.6, 2, 476),
+(863, 32, 48.6875, 2, 477),
+(864, 21, 56.428571428571, 2, 478),
+(865, 19, 45.315789473684, 2, 479),
+(866, 27, 50.037037037037, 2, 480),
+(867, 33, 46.515151515152, 2, 481),
+(868, 16, 55.6875, 2, 482),
+(869, 33, 44.787878787879, 2, 483),
+(870, 8, 55.375, 2, 484),
+(871, 20, 47.9, 2, 485),
+(872, 15, 58.733333333333, 2, 486),
+(873, 23, 50.608695652174, 2, 487),
+(874, 6, 55.5, 2, 488),
+(875, 31, 48.548387096774, 2, 489),
+(876, 15, 53.4, 2, 490),
+(877, 13, 44.307692307692, 2, 491),
+(878, 11, 51.090909090909, 2, 492),
+(879, 10, 53.3, 2, 493),
+(880, 6, 61.5, 2, 494),
+(881, 10, 51.6, 2, 495),
+(882, 8, 56.125, 2, 496),
+(883, 18, 48.722222222222, 2, 497),
+(884, 10, 67.3, 2, 498),
+(885, 18, 56.277777777778, 2, 499),
+(886, 13, 65.461538461538, 2, 500),
+(887, 3, 53, 2, 501),
+(888, 7, 57, 2, 502),
+(889, 15, 52.533333333333, 2, 503),
+(890, 4, 58.25, 2, 504),
+(891, 10, 56, 2, 505),
+(892, 9, 59.222222222222, 2, 506),
+(893, 6, 53.166666666667, 2, 507),
+(894, 6, 48.666666666667, 2, 508),
+(895, 17, 55.529411764706, 2, 509),
+(896, 21, 43.857142857143, 2, 510),
+(897, 19, 52.894736842105, 2, 511),
+(898, 34, 48.205882352941, 2, 512),
+(899, 26, 51.538461538462, 2, 513),
+(900, 1, 61, 4, 513),
+(901, 1, 43, 8, 513),
+(902, 25, 53.96, 2, 514),
+(903, 15, 48.8, 2, 515),
+(904, 1, 48, 6, 515),
+(905, 61, 40.032786885246, 2, 516),
+(906, 1, 93, 4, 516),
+(907, 15, 46.866666666667, 2, 517),
+(908, 56, 43.946428571429, 2, 518),
+(909, 4, 44.5, 2, 519),
+(910, 56, 42.982142857143, 2, 520),
+(911, 10, 53.8, 2, 521),
+(912, 27, 42.666666666667, 2, 522),
+(913, 50, 45.5, 2, 523),
+(914, 33, 53.787878787879, 2, 524),
+(915, 45, 48.333333333333, 2, 525),
+(916, 46, 54.108695652174, 2, 526),
+(917, 27, 51.962962962963, 2, 527),
+(918, 49, 49.163265306122, 2, 528),
+(919, 43, 53.790697674419, 2, 529),
+(920, 1, 54, 6, 529),
+(921, 1, 51, 8, 529),
+(922, 32, 46.46875, 2, 530),
+(923, 58, 50.948275862069, 2, 531),
+(924, 1, 50, 6, 531),
+(925, 60, 45.583333333333, 2, 532),
+(926, 103, 51.427184466019, 2, 533),
+(927, 60, 43.85, 2, 534),
+(928, 86, 52.511627906977, 2, 535),
+(929, 61, 49.409836065574, 2, 536),
+(930, 86, 49.56976744186, 2, 537),
+(931, 2, 40, 4, 537),
+(932, 91, 43.142857142857, 2, 538),
+(933, 68, 51.764705882353, 2, 539),
+(934, 1, 43, 6, 539),
+(935, 65, 47.769230769231, 2, 540),
+(936, 72, 50.138888888889, 2, 541),
+(937, 1, 53, 8, 541),
+(938, 70, 38.614285714286, 2, 542),
+(939, 97, 50.278350515464, 2, 543),
+(940, 2, 51, 6, 543),
+(941, 2, 44, 8, 543),
+(942, 148, 39.810810810811, 2, 544),
+(943, 104, 48.317307692308, 2, 545),
+(944, 2, 48.5, 6, 545),
+(945, 132, 40.340909090909, 2, 546),
+(946, 143, 48.713286713287, 2, 547),
+(947, 1, 42, 6, 547),
+(948, 2, 41.5, 8, 547),
+(949, 103, 45.242718446602, 2, 548),
+(950, 116, 48.76724137931, 2, 549),
+(951, 1, 48, 4, 549),
+(952, 1, 48, 8, 549),
+(953, 135, 42.318518518519, 2, 550),
+(954, 136, 49.941176470588, 2, 551),
+(955, 1, 47, 6, 551),
+(956, 2, 41.5, 8, 551),
+(957, 161, 39.614906832298, 2, 552),
+(958, 92, 48.04347826087, 2, 553),
+(959, 164, 38.548780487805, 2, 554),
+(960, 130, 51.130769230769, 2, 555),
+(961, 1, 48, 4, 555),
+(962, 147, 40.496598639456, 2, 556),
+(963, 1, 0, 8, 556),
+(964, 139, 45.179856115108, 2, 557),
+(965, 1, 48, 6, 557),
+(966, 1, 47, 8, 557),
+(967, 135, 41.244444444444, 2, 558),
+(968, 1, 0, 4, 558),
+(969, 128, 49.6875, 2, 559),
+(970, 154, 42.62987012987, 2, 560),
+(971, 133, 48.353383458647, 2, 561),
+(972, 1, 45, 6, 561),
+(973, 118, 37.796610169492, 2, 562),
+(974, 125, 48.272, 2, 563),
+(975, 1, 42, 4, 563),
+(976, 1, 43, 6, 563),
+(977, 2, 50.5, 8, 563),
+(978, 116, 41.956896551724, 2, 564),
+(979, 160, 48.23125, 2, 565),
+(980, 1, 61, 4, 565),
+(981, 2, 43, 6, 565),
+(982, 2, 49, 8, 565),
+(983, 128, 42.6015625, 2, 566),
+(984, 1, 0, 6, 566),
+(985, 169, 49.609467455621, 2, 567),
+(986, 3, 46.333333333333, 8, 567),
+(987, 143, 40.167832167832, 2, 568),
+(988, 148, 50.216216216216, 2, 569),
+(989, 1, 45, 8, 569),
+(990, 170, 40.970588235294, 2, 570),
+(991, 121, 51.884297520661, 2, 571),
+(992, 4, 64.75, 6, 571),
+(993, 1, 36, 8, 571),
+(994, 157, 41.611464968153, 2, 572),
+(995, 113, 49.663716814159, 2, 573),
+(996, 3, 50, 6, 573),
+(997, 1, 52, 8, 573),
+(998, 152, 41.769736842105, 2, 574),
+(999, 138, 47.927536231884, 2, 575),
+(1000, 1, 46, 6, 575),
+(1001, 1, 50, 8, 575),
+(1002, 120, 42.675, 2, 576),
+(1003, 150, 50.04, 2, 577),
+(1004, 1, 50, 6, 577),
+(1005, 1, 36, 8, 577),
+(1006, 162, 41.296296296296, 2, 578),
+(1007, 189, 47.417989417989, 2, 579),
+(1008, 1, 52, 4, 579),
+(1009, 4, 39.5, 6, 579),
+(1010, 1, 48, 8, 579),
+(1011, 109, 46.963302752294, 2, 580),
+(1012, 153, 45.928104575163, 2, 581),
+(1013, 1, 44, 6, 581),
+(1014, 198, 40.111111111111, 2, 582),
+(1015, 160, 47.9, 2, 583),
+(1016, 148, 44.986486486486, 2, 584),
+(1017, 106, 48.198113207547, 2, 585),
+(1018, 144, 42.701388888889, 2, 586),
+(1019, 179, 48.748603351955, 2, 587),
+(1020, 134, 47.985074626866, 2, 588),
+(1021, 163, 48.484662576687, 2, 589),
+(1022, 1, 47, 4, 589),
+(1023, 156, 41.467948717949, 2, 590),
+(1024, 1, 0, 6, 590),
+(1025, 134, 49.097014925373, 2, 591),
+(1026, 158, 44.601265822785, 2, 592),
+(1027, 166, 49.228915662651, 2, 593),
+(1028, 1, 47, 6, 593),
+(1029, 139, 44.726618705036, 2, 594),
+(1030, 199, 47.391959798995, 2, 595),
+(1031, 2, 51, 6, 595),
+(1032, 134, 47.649253731343, 2, 596),
+(1033, 177, 48.350282485876, 2, 597),
+(1034, 1, 43, 4, 597),
+(1035, 148, 45.722972972973, 2, 598),
+(1036, 174, 48.764367816092, 2, 599),
+(1037, 2, 47.5, 4, 599),
+(1038, 145, 46.551724137931, 2, 600),
+(1039, 170, 46.594117647059, 2, 601),
+(1040, 1, 46, 4, 601),
+(1041, 2, 41, 6, 601),