-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.4.32-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             12.6.0.6765
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumping structure for table reinis_buls.metter_data
CREATE TABLE IF NOT EXISTS `metter_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Ieraksta ID',
  `number` decimal(12,0) unsigned NOT NULL DEFAULT 0 COMMENT 'Skaitītaja Numurs',
  `obis` int(10) unsigned DEFAULT 180 COMMENT 'OBIS',
  `date` date NOT NULL COMMENT 'Datums',
  `value` decimal(12,0) NOT NULL DEFAULT 0 COMMENT 'Rādījums',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1024 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Skaitītāju mērījumi';

-- Dumping data for table reinis_buls.metter_data: ~633 rows (approximately)
INSERT INTO `metter_data` (`id`, `number`, `obis`, `date`, `value`) VALUES
	(1, 4224014, 154, '2004-03-01', 5633),
	(2, 10498, 155, '2004-03-01', 24256),
	(3, 32687084, 156, '2004-03-01', 7295),
	(4, 32469776, 157, '2004-03-01', 14550),
	(5, 32778874, 158, '2004-03-01', 8994),
	(6, 4547010, 159, '2004-03-01', 8438),
	(7, 110081, 160, '2004-03-01', 47868),
	(8, 50028590, 161, '2004-03-01', 2735),
	(9, 97125, 162, '2004-03-01', 41429),
	(10, 10392, 163, '2004-03-01', 31340),
	(11, 23860702, 164, '2004-03-01', 8649),
	(12, 32996418, 165, '2004-03-01', 12736),
	(13, 291044, 166, '2004-03-01', 663),
	(14, 7950242, 167, '2004-03-01', 41331),
	(15, 556043, 168, '2004-03-01', 17635),
	(16, 3639101, 169, '2004-03-01', 9225),
	(17, 50028646, 170, '2004-03-01', 750),
	(18, 96397, 171, '2004-03-01', 45528),
	(19, 32778527, 172, '2004-03-01', 10885),
	(20, 3493235, 173, '2004-03-01', 6405),
	(21, 32647524, 174, '2004-03-01', 16004),
	(22, 32719941, 175, '2004-03-01', 14565),
	(23, 45723523, 176, '2004-03-01', 283918),
	(24, 62553772, 177, '2004-03-01', 265761),
	(25, 568796, 178, '2013-01-30', 5399),
	(26, 568693, 179, '2013-01-30', 5939),
	(27, 50156373, 180, '2013-01-30', 6576),
	(28, 56993, 182, '2013-01-30', 6379),
	(29, 56993, 184, '2013-01-30', 17374),
	(30, 50135314, 180, '2013-01-30', 5188),
	(31, 29446699, 180, '2013-01-30', 38418),
	(32, 52685418, 180, '2013-01-30', 1962),
	(33, 50028987, 180, '2013-01-30', 5294),
	(34, 32687084, 180, '2013-01-30', 47740),
	(35, 32469776, 180, '2013-01-30', 71640),
	(36, 50089149, 180, '2013-01-30', 4264),
	(37, 32414204, 180, '2013-01-30', 9636),
	(38, 50088638, 180, '2013-01-30', 30228),
	(39, 32778874, 180, '2013-01-30', 69678),
	(40, 50050895, 180, '2013-01-30', 51787),
	(41, 29376210, 180, '2013-01-30', 11316),
	(42, 32647524, 180, '2013-01-30', 71627),
	(43, 32719941, 180, '2013-01-30', 124941),
	(44, 50028646, 180, '2013-01-30', 21116),
	(45, 29376264, 180, '2013-01-30', 42410),
	(46, 32778527, 180, '2013-01-30', 57459),
	(47, 251280, 180, '2013-01-30', 28580),
	(48, 557538, 180, '2013-01-30', 7428),
	(49, 50028590, 180, '2013-01-30', 66842),
	(50, 52685472, 180, '2013-01-30', 2145),
	(51, 29376213, 180, '2013-01-30', 44509),
	(52, 50158093, 180, '2013-01-30', 9795),
	(53, 32996418, 180, '2013-01-30', 73239),
	(54, 580689, 180, '2013-01-30', 6970),
	(55, 32735197, 180, '2013-01-30', 22861),
	(56, 50161280, 180, '2013-01-30', 4466),
	(57, 29376263, 180, '2013-01-30', 22774),
	(58, 29446613, 180, '2013-01-30', 60718),
	(59, 29375625, 180, '2013-01-30', 51061),
	(60, 341236, 180, '2013-01-30', 1046),
	(61, 83543477, 180, '2013-01-30', 9448),
	(62, 34237, 180, '2013-01-30', 4518),
	(63, 34231, 180, '2013-01-30', 5298),
	(64, 32735797, 180, '2013-01-30', 91910),
	(65, 50152351, 180, '2013-01-30', 8281),
	(66, 29376231, 180, '2013-01-30', 6937),
	(67, 50121054, 180, '2013-01-30', 3934),
	(68, 264, 180, '2013-01-30', 152),
	(69, 29446616, 180, '2006-05-01', 2045),
	(70, 29446699, 180, '2006-05-01', 2015),
	(71, 29376219, 180, '2006-05-01', 2084),
	(72, 29376210, 180, '2006-05-01', 357),
	(73, 32778874, 180, '2006-05-01', 22209),
	(74, 50050895, 180, '2006-05-01', 10369),
	(75, 50088638, 180, '2006-05-01', 4083),
	(76, 32687084, 180, '2006-05-01', 16932),
	(77, 32469776, 180, '2006-05-01', 27301),
	(78, 32719941, 180, '2006-05-01', 37999),
	(79, 29376213, 180, '2006-05-01', 1987),
	(80, 50028590, 180, '2006-05-01', 20358),
	(81, 251280, 180, '2006-05-01', 5062),
	(82, 50028646, 180, '2006-05-01', 5069),
	(83, 29376264, 180, '2006-05-01', 1488),
	(84, 32778527, 180, '2006-05-01', 20196),
	(85, 29376231, 180, '2006-05-01', 561),
	(86, 184611011, 180, '2006-05-01', 3279),
	(87, 184611011, 180, '2006-05-01', 2555),
	(88, 29292023, 180, '2006-05-01', 514),
	(89, 556043, 180, '2006-05-01', 35004),
	(90, 32647524, 180, '2006-05-01', 27961),
	(91, 32996418, 180, '2006-05-01', 33637),
	(92, 29292035, 180, '2006-05-01', 5588),
	(93, 29375625, 180, '2006-05-01', 4300),
	(94, 29446613, 180, '2006-05-01', 1867),
	(95, 29376263, 180, '2006-05-01', 1408),
	(96, 29446616, 180, '2008-08-01', 17629),
	(97, 29446699, 180, '2008-08-01', 19214),
	(98, 29376219, 180, '2008-08-01', 9058),
	(99, 29376210, 180, '2008-08-01', 3740),
	(100, 32778874, 180, '2008-08-01', 37361),
	(101, 50050895, 180, '2008-08-01', 24200),
	(102, 50088638, 180, '2008-08-01', 12256),
	(103, 32687084, 180, '2008-08-01', 26918),
	(104, 32469776, 180, '2008-08-01', 41738),
	(105, 32719941, 180, '2008-08-01', 67463),
	(106, 29376213, 180, '2008-08-01', 19881),
	(107, 50028590, 180, '2008-08-01', 38973),
	(108, 251280, 180, '2008-08-01', 21877),
	(109, 50028646, 180, '2008-08-01', 9926),
	(110, 29376264, 180, '2008-08-01', 15024),
	(111, 32778527, 180, '2008-08-01', 34416),
	(112, 29376231, 180, '2008-08-01', 4228),
	(113, 29292037, 180, '2008-08-01', 16313),
	(114, 29292026, 180, '2008-08-01', 14325),
	(115, 29292023, 180, '2008-08-01', 3300),
	(116, 32735797, 180, '2008-08-01', 52299),
	(117, 32647524, 180, '2008-08-01', 43319),
	(118, 32996418, 180, '2008-08-01', 57243),
	(119, 29292035, 180, '2008-08-01', 24492),
	(120, 29375625, 180, '2008-08-01', 20882),
	(121, 29446613, 180, '2008-08-01', 21880),
	(122, 29376263, 180, '2008-08-01', 15644),
	(123, 50121054, 180, '2008-08-01', 1092),
	(124, 50152351, 180, '2008-08-01', 1490),
	(125, 50156373, 180, '2008-08-01', 821),
	(126, 50161280, 180, '2008-08-01', 225),
	(127, 50158093, 180, '2008-08-01', 1122),
	(128, 568796, 180, '2017-07-31', 11317),
	(129, 568693, 180, '2017-07-31', 12393),
	(130, 50156373, 180, '2017-07-31', 13427),
	(131, 1611742, 180, '2017-07-31', 2455),
	(132, 50135314, 180, '2017-07-31', 12291),
	(133, 29446699, 180, '2017-07-31', 44137),
	(134, 32558090, 180, '2017-07-31', 1764),
	(135, 50028987, 180, '2017-07-31', 14408),
	(136, 264, 180, '2017-07-31', 4903),
	(137, 11669109, 180, '2017-07-31', 9550),
	(138, 32199561, 180, '2017-07-31', 12221),
	(139, 50089149, 180, '2017-07-31', 22454),
	(140, 11688670, 180, '2017-07-31', 22454),
	(141, 32245598, 180, '2017-07-31', 2892),
	(142, 50088638, 180, '2017-07-31', 40105),
	(143, 11688670, 180, '2017-07-31', 40105),
	(144, 32778874, 180, '2017-07-31', 82122),
	(145, 50050895, 180, '2017-07-31', 64354),
	(146, 29376210, 180, '2017-07-31', 22477),
	(147, 32295119, 180, '2017-07-31', 4852),
	(148, 32248826, 180, '2017-07-31', 31490),
	(149, 32719941, 180, '2017-07-31', 154588),
	(150, 100145, 180, '2017-07-31', 6667),
	(151, 50028646, 180, '2017-07-31', 31287),
	(152, 29376264, 180, '2017-07-31', 73103),
	(153, 91005292, 180, '2017-07-31', 1296),
	(154, 50086615, 180, '2017-07-31', 2206),
	(155, 251280, 180, '2017-07-31', 0),
	(156, 557538, 180, '2017-07-31', 22889),
	(157, 50028590, 180, '2017-07-31', 81921),
	(158, 33165911, 180, '2017-07-31', 2983),
	(159, 29376213, 180, '2017-07-31', 57132),
	(160, 11669252, 180, '2017-07-31', 7507),
	(161, 11667994, 180, '2017-07-31', 7484),
	(162, 580689, 180, '2017-07-31', 14300),
	(163, 11667895, 180, '2017-07-31', 16832),
	(164, 50161280, 180, '2017-07-31', 9009),
	(165, 32276933, 180, '2017-07-31', 3772),
	(166, 11671877, 180, '2017-07-31', 19993),
	(167, 32202631, 180, '2017-07-31', 12697),
	(168, 341236, 180, '2017-07-31', 6079),
	(169, 11400194, 180, '2017-07-31', 4958),
	(170, 34237, 180, '2017-07-31', 28784),
	(171, 11675292, 180, '2017-07-31', 16434),
	(172, 32735797, 180, '2017-07-31', 130059),
	(173, 50152351, 180, '2017-07-31', 15144),
	(174, 29376231, 180, '2017-07-31', 9982),
	(175, 50121054, 180, '2017-07-31', 7794),
	(176, 32149396, 180, '2017-07-31', 5850),
	(177, 82776, 180, '2017-07-31', 13166),
	(178, 50028987, 180, '2010-10-30', 1150),
	(179, 29446699, 180, '2010-10-30', 35611),
	(180, 29376219, 180, '2010-10-30', 12613),
	(181, 29376210, 180, '2010-10-30', 7618),
	(182, 32778874, 180, '2010-10-30', 54042),
	(183, 50050895, 180, '2010-10-30', 38946),
	(184, 50088638, 180, '2010-10-30', 21210),
	(185, 32687084, 180, '2010-10-30', 37115),
	(186, 32469776, 180, '2010-10-30', 59013),
	(187, 32719941, 180, '2010-10-30', 103578),
	(188, 29376213, 180, '2010-10-30', 37438),
	(189, 50028590, 180, '2010-10-30', 57958),
	(190, 251280, 180, '2010-10-30', 25431),
	(191, 50028646, 180, '2010-10-30', 15300),
	(192, 29376264, 180, '2010-10-30', 28552),
	(193, 32778527, 180, '2010-10-30', 46829),
	(194, 29376231, 180, '2010-10-30', 5370),
	(195, 29292037, 180, '2010-10-30', 28110),
	(196, 29292026, 180, '2010-10-30', 25942),
	(197, 29292023, 180, '2010-10-30', 6385),
	(198, 32735797, 180, '2010-10-30', 74013),
	(199, 32647524, 180, '2010-10-30', 59478),
	(200, 32996418, 180, '2010-10-30', 65618),
	(201, 32735197, 180, '2010-10-30', 4828),
	(202, 29375625, 180, '2010-10-30', 36181),
	(203, 29446613, 180, '2010-10-30', 43327),
	(204, 29376263, 180, '2010-10-30', 19532),
	(205, 50121054, 180, '2010-10-30', 2397),
	(206, 50152351, 180, '2010-10-30', 4882),
	(207, 50156373, 180, '2010-10-30', 3253),
	(208, 50161280, 180, '2010-10-30', 2288),
	(209, 50158093, 180, '2010-10-30', 5247),
	(210, 557538, 180, '2010-10-30', 3489),
	(211, 580689, 180, '2010-10-30', 2974),
	(212, 568796, 180, '2010-10-30', 2616),
	(213, 568693, 180, '2010-10-30', 2149),
	(214, 50135314, 180, '2010-10-30', 1587),
	(215, 32414204, 180, '2010-10-30', 2194),
	(216, 83543477, 180, '2010-10-30', 629),
	(217, 5301873827, 180, '2019-11-01', 813),
	(218, 568796, 180, '2019-10-30', 14350),
	(219, 568693, 180, '2019-10-30', 15856),
	(220, 4109420729, 180, '2019-10-30', 2057),
	(221, 1611742, 180, '2019-10-30', 5968),
	(222, 50135314, 180, '2019-11-01', 16794),
	(223, 29446699, 180, '2019-11-01', 46830),
	(224, 4109420527, 180, '2019-11-01', 2162),
	(225, 50028987, 180, '2019-11-01', 19945),
	(226, 91002891, 180, '2019-11-01', 3353),
	(227, 11669109, 180, '2019-11-01', 19090),
	(228, 32199561, 180, '2019-11-01', 22475),
	(229, 4109420280, 180, '2019-11-01', 6258),
	(230, 11688670, 180, '2019-11-01', 14917),
	(231, 4109420145, 180, '2019-11-01', 3531),
	(232, 50088638, 180, '2019-11-01', 45407),
	(233, 11688670, 180, '2019-10-30', 14897),
	(234, 32778874, 180, '2019-10-30', 89167),
	(235, 4109420471, 180, '2019-11-01', 3918),
	(236, 4109420325, 180, '2019-11-01', 3818),
	(237, 32295119, 180, '2019-10-30', 14610),
	(238, 32248826, 180, '2019-10-30', 9384),
	(239, 5110914629, 180, '2019-11-01', 369),
	(240, 100145, 180, '2019-11-01', 13202),
	(241, 5110833045, 180, '2019-11-11', 128),
	(242, 50028646, 180, '2019-11-01', 33307),
	(243, 29376264, 180, '2019-11-01', 78932),
	(244, 4114492386, 180, '2019-10-30', 7890),
	(245, 50086615, 180, '2019-11-01', 6643),
	(246, 91005292, 180, '2019-11-01', 5576),
	(247, 251280, 180, '2019-10-30', 5898),
	(248, 4114492229, 180, '2019-10-30', 4596),
	(249, 50028590, 180, '2019-10-30', 89894),
	(250, 33165911, 180, '2019-10-30', 8979),
	(251, 29376213, 180, '2019-11-01', 63185),
	(252, 11669252, 180, '2019-10-30', 15070),
	(253, 11667994, 180, '2019-11-01', 14576),
	(254, 580689, 180, '2019-11-01', 17689),
	(255, 11667895, 180, '2019-10-30', 26106),
	(256, 50161280, 180, '2019-11-01', 11486),
	(257, 32276933, 180, '2019-11-01', 6751),
	(258, 11671877, 180, '2019-10-30', 39718),
	(259, 32202631, 180, '2019-11-01', 15896),
	(260, 341236, 180, '2019-10-30', 7600),
	(261, 11400194, 180, '2019-11-01', 12751),
	(262, 34237, 180, '2019-11-01', 32619),
	(263, 11675292, 180, '2019-11-01', 27741),
	(264, 4114492173, 180, '2019-11-01', 4077),
	(265, 41144920227, 180, '2019-11-01', 2107),
	(266, 4109420886, 180, '2019-10-30', 873),
	(267, 50121054, 180, '2019-10-30', 10708),
	(268, 32149396, 180, '2019-10-30', 11750),
	(269, 568796, 180, '2015-02-26', 8106),
	(270, 568693, 180, '2015-02-26', 8911),
	(271, 50156373, 180, '2015-02-26', 9879),
	(272, 56993, 182, '2015-02-26', 8012),
	(273, 56993, 184, '2015-02-26', 18706),
	(274, 50135314, 137, '2015-02-26', 8325),
	(275, 29446699, 138, '2015-02-26', 41140),
	(276, 52685418, 139, '2015-02-26', 5048),
	(277, 50028987, 140, '2015-02-26', 9110),
	(278, 264, 141, '2015-02-26', 2469),
	(279, 32687084, 142, '2015-02-26', 55517),
	(280, 32199561, 143, '2015-02-26', 1749),
	(281, 50089149, 144, '2015-02-26', 12168),
	(282, 32414204, 145, '2015-02-26', 15744),
	(283, 53119305, 146, '2015-02-26', 3508),
	(284, 50088638, 147, '2015-02-26', 34299),
	(285, 32414204, 148, '2015-02-26', 15744),
	(286, 32778874, 149, '2015-02-26', 74644),
	(287, 50050895, 150, '2015-02-26', 57278),
	(288, 29376210, 151, '2015-02-26', 15833),
	(289, 53117522, 152, '2015-02-26', 6387),
	(290, 53117426, 153, '2015-02-26', 4232),
	(291, 32719941, 154, '2015-02-26', 138350),
	(292, 50028646, 155, '2015-02-26', 26307),
	(293, 29376264, 156, '2015-02-26', 56784),
	(294, 32778527, 157, '2015-02-26', 62964),
	(295, 251280, 158, '2015-02-26', 34301),
	(296, 557538, 159, '2015-02-26', 14562),
	(297, 50028590, 160, '2015-02-26', 73424),
	(298, 52685472, 161, '2015-02-26', 8045),
	(299, 29376213, 162, '2015-02-26', 50590),
	(300, 50158093, 163, '2015-02-26', 16087),
	(301, 32996418, 164, '2015-02-26', 80514),
	(302, 580689, 165, '2015-02-26', 10585),
	(303, 32735197, 166, '2015-02-26', 38097),
	(304, 32996418, 167, '2015-02-26', 80514),
	(305, 50161280, 168, '2015-02-26', 6510),
	(306, 32276933, 169, '2015-02-26', 596),
	(307, 29446613, 170, '2015-02-26', 77416),
	(308, 32202631, 171, '2015-02-26', 2797),
	(309, 341236, 172, '2015-02-26', 3171),
	(310, 83543477, 173, '2015-02-26', 17423),
	(311, 83543477, 174, '2015-02-26', 17423),
	(312, 34237, 175, '2015-02-26', 15442),
	(313, 34231, 176, '2015-02-26', 18301),
	(314, 32735797, 177, '2015-02-26', 108003),
	(315, 50152351, 178, '2015-02-26', 11404),
	(316, 29376231, 179, '2015-02-26', 8329),
	(317, 50121054, 180, '2015-02-26', 4763),
	(318, 4224014, 154, '2004-02-01', 4883),
	(319, 10498, 155, '2004-02-01', 23571),
	(320, 32687084, 156, '2004-02-01', 6840),
	(321, 32469776, 157, '2004-02-01', 14039),
	(322, 32778874, 158, '2004-02-01', 8498),
	(323, 4547010, 159, '2004-02-01', 7717),
	(324, 110081, 160, '2004-02-01', 47165),
	(325, 50028590, 161, '2004-02-01', 2117),
	(326, 97125, 162, '2004-02-01', 40751),
	(327, 10392, 163, '2004-02-01', 30659),
	(328, 23860702, 164, '2004-02-01', 8137),
	(329, 32996418, 165, '2004-02-01', 11891),
	(330, 291044, 166, '2004-02-01', 9991),
	(331, 7950242, 167, '2004-02-01', 40761),
	(332, 556043, 168, '2004-02-01', 16886),
	(333, 3639101, 169, '2004-02-01', 8754),
	(334, 50028646, 170, '2004-02-01', 568),
	(335, 96397, 171, '2004-02-01', 44898),
	(336, 32778527, 172, '2004-02-01', 10535),
	(337, 3493235, 173, '2004-02-01', 6103),
	(338, 32647524, 174, '2004-02-01', 15499),
	(339, 32719941, 175, '2004-02-01', 13513),
	(340, 45723523, 176, '2004-02-01', 274683),
	(341, 62553772, 177, '2004-02-01', 260384),
	(342, 568796, 178, '2013-02-28', 6064),
	(343, 568693, 179, '2013-02-28', 5514),
	(344, 50156373, 180, '2013-02-28', 6734),
	(345, 56993, 182, '2013-02-28', 6444),
	(346, 56993, 184, '2013-02-28', 17423),
	(347, 50135314, 180, '2013-02-28', 5320),
	(348, 29446699, 180, '2013-02-28', 38570),
	(349, 52685418, 180, '2013-02-28', 2096),
	(350, 50028987, 180, '2013-02-28', 5452),
	(351, 32687084, 180, '2013-02-28', 47941),
	(352, 32469776, 180, '2013-02-28', 71785),
	(353, 50089149, 180, '2013-02-28', 4454),
	(354, 32414204, 180, '2013-02-28', 9879),
	(355, 50088638, 180, '2013-02-28', 30332),
	(356, 32778874, 180, '2013-02-28', 69678),
	(357, 50050895, 180, '2013-02-28', 51902),
	(358, 29376210, 180, '2013-02-28', 11460),
	(359, 32647524, 180, '2013-02-28', 72090),
	(360, 32719941, 180, '2013-02-28', 125502),
	(361, 50028646, 180, '2013-02-28', 21341),
	(362, 29376264, 180, '2013-02-28', 43010),
	(363, 32778527, 180, '2013-02-28', 57725),
	(364, 251280, 180, '2013-02-28', 28783),
	(365, 557538, 180, '2013-02-28', 7753),
	(366, 50028590, 180, '2013-02-28', 67066),
	(367, 52685472, 180, '2013-02-28', 2359),
	(368, 29376213, 180, '2013-02-28', 44724),
	(369, 50158093, 180, '2013-02-28', 10002),
	(370, 32996418, 180, '2013-02-28', 73561),
	(371, 580689, 180, '2013-02-28', 7138),
	(372, 32735197, 180, '2013-02-28', 23477),
	(373, 50161280, 180, '2013-02-28', 4553),
	(374, 29376263, 180, '2013-02-28', 22909),
	(375, 29446613, 180, '2013-02-28', 61376),
	(376, 29375625, 180, '2013-02-28', 51614),
	(377, 341236, 180, '2013-02-28', 1149),
	(378, 83543477, 180, '2013-02-28', 9806),
	(379, 34237, 180, '2013-02-28', 4961),
	(380, 34231, 180, '2013-02-28', 5811),
	(381, 32735797, 180, '2013-02-28', 92575),
	(382, 50152351, 180, '2013-02-28', 8413),
	(383, 29376231, 180, '2013-02-28', 7014),
	(384, 50121054, 180, '2013-02-28', 3979),
	(385, 264, 180, '2013-02-28', 264),
	(386, 29446616, 180, '2006-06-01', 2709),
	(387, 29446699, 180, '2006-06-01', 2593),
	(388, 29376219, 180, '2006-06-01', 2771),
	(389, 29376210, 180, '2006-06-01', 465),
	(390, 32778874, 180, '2006-06-01', 22713),
	(391, 50050895, 180, '2006-06-01', 10827),
	(392, 50088638, 180, '2006-06-01', 4330),
	(393, 32687084, 180, '2006-06-01', 17274),
	(394, 32469776, 180, '2006-06-01', 27745),
	(395, 32719941, 180, '2006-06-01', 38898),
	(396, 29376213, 180, '2006-06-01', 2568),
	(397, 50028590, 180, '2006-06-01', 20996),
	(398, 251280, 180, '2006-06-01', 5717),
	(399, 50028646, 180, '2006-06-01', 5214),
	(400, 29376264, 180, '2006-06-01', 1988),
	(401, 32778527, 180, '2006-06-01', 20711),
	(402, 29376231, 180, '2006-06-01', 787),
	(403, 184611011, 180, '2006-06-01', 3746),
	(404, 184611011, 180, '2006-06-01', 2968),
	(405, 29292023, 180, '2006-06-01', 606),
	(406, 556043, 180, '2006-06-01', 35601),
	(407, 32647524, 180, '2006-06-01', 28357),
	(408, 32996418, 180, '2006-06-01', 34332),
	(409, 29292035, 180, '2006-06-01', 6241),
	(410, 29375625, 180, '2006-06-01', 4784),
	(411, 29446613, 180, '2006-06-01', 2569),
	(412, 29376263, 180, '2006-06-01', 1914),
	(413, 29446616, 180, '2008-08-01', 18253),
	(414, 29446699, 180, '2008-08-01', 19837),
	(415, 29376219, 180, '2008-08-01', 9195),
	(416, 29376210, 180, '2008-08-01', 3881),
	(417, 32778874, 180, '2008-08-01', 37959),
	(418, 50050895, 180, '2008-08-01', 24763),
	(419, 50088638, 180, '2008-08-01', 12585),
	(420, 32687084, 180, '2008-08-01', 27291),
	(421, 32469776, 180, '2008-08-01', 42346),
	(422, 32719941, 180, '2008-08-01', 68736),
	(423, 29376213, 180, '2008-08-01', 20524),
	(424, 50028590, 180, '2008-08-01', 39569),
	(425, 251280, 180, '2008-08-01', 22221),
	(426, 50028646, 180, '2008-08-01', 10131),
	(427, 29376264, 180, '2008-08-01', 15524),
	(428, 32778527, 180, '2008-08-01', 34874),
	(429, 29376231, 180, '2008-08-01', 4285),
	(430, 29292037, 180, '2008-08-01', 16678),
	(431, 29292026, 180, '2008-08-01', 14728),
	(432, 29292023, 180, '2008-08-01', 3398),
	(433, 32735797, 180, '2008-08-01', 53409),
	(434, 32647524, 180, '2008-08-01', 43902),
	(435, 32996418, 180, '2008-08-01', 57932),
	(436, 29292035, 180, '2008-08-01', 24988),
	(437, 29375625, 180, '2008-08-01', 21544),
	(438, 29446613, 180, '2008-08-01', 22618),
	(439, 29376263, 180, '2008-08-01', 15918),
	(440, 50121054, 180, '2008-08-01', 1166),
	(441, 50152351, 180, '2008-08-01', 1643),
	(442, 50156373, 180, '2008-08-01', 985),
	(443, 50161280, 180, '2008-08-01', 276),
	(444, 50158093, 180, '2008-08-01', 1259),
	(445, 568796, 180, '2017-08-31', 11440),
	(446, 568693, 180, '2017-08-31', 12527),
	(447, 50156373, 180, '2017-08-31', 13578),
	(448, 1611742, 180, '2017-08-31', 2612),
	(449, 50135314, 180, '2017-08-31', 12448),
	(450, 29446699, 180, '2017-08-31', 44242),
	(451, 32558090, 180, '2017-08-31', 1907),
	(452, 50028987, 180, '2017-08-31', 14616),
	(453, 264, 180, '2017-08-31', 4956),
	(454, 11669109, 180, '2017-08-31', 9899),
	(455, 32199561, 180, '2017-08-31', 12626),
	(456, 50089149, 180, '2017-08-31', 22870),
	(457, 11688670, 180, '2017-08-31', 22870),
	(458, 32245598, 180, '2017-08-31', 3128),
	(459, 50088638, 180, '2017-08-31', 40335),
	(460, 11688670, 180, '2017-08-31', 40335),
	(461, 32778874, 180, '2017-08-31', 82408),
	(462, 50050895, 180, '2017-08-31', 64633),
	(463, 29376210, 180, '2017-08-31', 22741),
	(464, 32295119, 180, '2017-08-31', 5256),
	(465, 32248826, 180, '2017-08-31', 3414),
	(466, 32719941, 180, '2017-08-31', 155214),
	(467, 100145, 180, '2017-08-31', 6947),
	(468, 50028646, 180, '2017-08-31', 31356),
	(469, 29376264, 180, '2017-08-31', 73326),
	(470, 91005292, 180, '2017-08-31', 1453),
	(471, 50086615, 180, '2017-08-31', 2377),
	(472, 251280, 180, '2017-08-31', 115),
	(473, 557538, 180, '2017-08-31', 23193),
	(474, 50028590, 180, '2017-08-31', 82240),
	(475, 33165911, 180, '2017-08-31', 3244),
	(476, 29376213, 180, '2017-08-31', 57399),
	(477, 11669252, 180, '2017-08-31', 7812),
	(478, 11667994, 180, '2017-08-31', 7775),
	(479, 580689, 180, '2017-08-31', 14437),
	(480, 11667895, 180, '2017-08-31', 17525),
	(481, 50161280, 180, '2017-08-31', 9144),
	(482, 32276933, 180, '2017-08-31', 3894),
	(483, 11671877, 180, '2017-08-31', 20814),
	(484, 32202631, 180, '2017-08-31', 12829),
	(485, 341236, 180, '2017-08-31', 6121),
	(486, 11400194, 180, '2017-08-31', 5268),
	(487, 34237, 180, '2017-08-31', 28941),
	(488, 11675292, 180, '2017-08-31', 17301),
	(489, 32735797, 180, '2017-08-31', 131006),
	(490, 50152351, 180, '2017-08-31', 15287),
	(491, 29376231, 180, '2017-08-31', 10038),
	(492, 50121054, 180, '2017-08-31', 7909),
	(493, 32149396, 180, '2017-08-31', 6091),
	(494, 82776, 180, '2017-08-31', 13714),
	(495, 50028987, 180, '2010-11-28', 1318),
	(496, 29446699, 180, '2010-11-28', 35360),
	(497, 29376219, 180, '2010-11-28', 12618),
	(498, 29376210, 180, '2010-11-28', 7742),
	(499, 32778874, 180, '2010-11-28', 54733),
	(500, 50050895, 180, '2010-11-28', 39506),
	(501, 50088638, 180, '2010-11-28', 21693),
	(502, 32687084, 180, '2010-11-28', 37537),
	(503, 32469776, 180, '2010-11-28', 59758),
	(504, 32719941, 180, '2010-11-28', 104962),
	(505, 29376213, 180, '2010-11-28', 38099),
	(506, 50028590, 180, '2010-11-28', 58531),
	(507, 251280, 180, '2010-11-28', 25504),
	(508, 50028646, 180, '2010-11-28', 15494),
	(509, 29376264, 180, '2010-11-28', 29050),
	(510, 32778527, 180, '2010-11-28', 47295),
	(511, 29376231, 180, '2010-11-28', 5434),
	(512, 29292037, 180, '2010-11-28', 28330),
	(513, 29292026, 180, '2010-11-28', 26372),
	(514, 29292023, 180, '2010-11-28', 6490),
	(515, 32735797, 180, '2010-11-28', 74682),
	(516, 32647524, 180, '2010-11-28', 60073),
	(517, 32996418, 180, '2010-11-28', 65907),
	(518, 32735197, 180, '2010-11-28', 5493),
	(519, 29375625, 180, '2010-11-28', 36766),
	(520, 29446613, 180, '2010-11-28', 43945),
	(521, 29376263, 180, '2010-11-28', 19657),
	(522, 50121054, 180, '2010-11-28', 2441),
	(523, 50152351, 180, '2010-11-28', 5021),
	(524, 50156373, 180, '2010-11-28', 3397),
	(525, 50161280, 180, '2010-11-28', 2361),
	(526, 50158093, 180, '2010-11-28', 5406),
	(527, 557538, 180, '2010-11-28', 3613),
	(528, 580689, 180, '2010-11-28', 3102),
	(529, 568796, 180, '2010-11-28', 2726),
	(530, 568693, 180, '2010-11-28', 2322),
	(531, 50135314, 180, '2010-11-28', 1716),
	(532, 32414204, 180, '2010-11-28', 2512),
	(533, 83543477, 180, '2010-11-28', 6951),
	(534, 5301873827, 180, '2019-11-30', 1316),
	(535, 568796, 180, '2019-11-30', 14464),
	(536, 568693, 180, '2019-11-30', 15984),
	(537, 4109420729, 180, '2019-11-30', 2148),
	(538, 1611742, 180, '2019-11-30', 6070),
	(539, 50135314, 180, '2019-11-30', 17099),
	(540, 29446699, 180, '2019-11-30', 46918),
	(541, 4109420527, 180, '2019-11-30', 2282),
	(542, 50028987, 180, '2019-11-30', 20137),
	(543, 91002891, 180, '2019-11-30', 3458),
	(544, 11669109, 180, '2019-11-30', 19395),
	(545, 32199561, 180, '2019-11-30', 22829),
	(546, 4109420280, 180, '2019-11-30', 6573),
	(547, 11688670, 180, '2019-11-30', 15166),
	(548, 4109420145, 180, '2019-11-30', 3732),
	(549, 50088638, 180, '2019-11-30', 45586),
	(550, 32778874, 180, '2019-11-30', 89425),
	(551, 4109420471, 180, '2019-11-30', 4118),
	(552, 4109420325, 180, '2019-11-30', 4010),
	(553, 32295119, 180, '2019-11-30', 14942),
	(554, 32248826, 180, '2019-11-30', 9587),
	(555, 5110914629, 180, '2019-11-30', 552),
	(556, 100145, 180, '2019-11-11', 13312),
	(557, 5110833045, 180, '2019-11-30', 128),
	(558, 50028646, 180, '2019-11-30', 33383),
	(559, 29376264, 180, '2019-11-30', 79149),
	(560, 4114492386, 180, '2019-11-30', 8343),
	(561, 50086615, 180, '2019-11-30', 6800),
	(562, 91005292, 180, '2019-11-30', 5754),
	(563, 251280, 180, '2019-11-30', 6093),
	(564, 4114492229, 180, '2019-11-30', 4867),
	(565, 50028590, 180, '2019-11-30', 90191),
	(566, 33165911, 180, '2019-11-30', 9176),
	(567, 29376213, 180, '2019-11-30', 63357),
	(568, 11669252, 180, '2019-11-30', 15354),
	(569, 11667994, 180, '2019-11-30', 14811),
	(570, 580689, 180, '2019-11-30', 17831),
	(571, 11667895, 180, '2019-11-30', 26246),
	(572, 50161280, 180, '2019-11-30', 11568),
	(573, 32276933, 180, '2019-11-30', 6849),
	(574, 11671877, 180, '2019-11-30', 40389),
	(575, 32202631, 180, '2019-11-30', 16016),
	(576, 341236, 180, '2019-11-30', 7656),
	(577, 11400194, 180, '2019-11-30', 13025),
	(578, 34237, 180, '2019-11-30', 32740),
	(579, 11675292, 180, '2019-11-30', 27903),
	(580, 4114492173, 180, '2019-11-30', 4314),
	(581, 41144920227, 180, '2019-11-30', 2226),
	(582, 4109420886, 180, '2019-11-30', 926),
	(583, 50121054, 180, '2019-11-30', 10813),
	(584, 32149396, 180, '2019-11-30', 11947),
	(585, 568796, 180, '2015-03-31', 8228),
	(586, 568693, 180, '2015-03-31', 9045),
	(587, 50156373, 180, '2015-03-31', 10038),
	(588, 56993, 182, '2015-03-31', 8084),
	(589, 56993, 184, '2015-03-31', 18764),
	(590, 50135314, 137, '2015-03-31', 8461),
	(591, 29446699, 138, '2015-03-31', 41258),
	(592, 52685418, 139, '2015-03-31', 5190),
	(593, 50028987, 140, '2015-03-31', 9279),
	(594, 264, 141, '2015-03-31', 2588),
	(595, 32687084, 142, '2015-03-31', 55894),
	(596, 32199561, 143, '2015-03-31', 2116),
	(597, 50089149, 144, '2015-03-31', 12547),
	(598, 32414204, 145, '2015-03-31', 16065),
	(599, 53119305, 146, '2015-03-31', 3750),
	(600, 50088638, 147, '2015-03-31', 34513),
	(601, 32414204, 148, '2015-03-31', 16065),
	(602, 32778874, 149, '2015-03-31', 74934),
	(603, 50050895, 150, '2015-03-31', 57542),
	(604, 29376210, 151, '2015-03-31', 16077),
	(605, 53117522, 152, '2015-03-31', 6787),
	(606, 53117426, 153, '2015-03-31', 4496),
	(607, 32719941, 154, '2015-03-31', 138956),
	(608, 50028646, 155, '2015-03-31', 26539),
	(609, 29376264, 156, '2015-03-31', 57433),
	(610, 32778527, 157, '2015-03-31', 62964),
	(611, 251280, 158, '2015-03-31', 34536),
	(612, 557538, 159, '2015-03-31', 14878),
	(613, 50028590, 160, '2015-03-31', 73741),
	(614, 52685472, 161, '2015-03-31', 8282),
	(615, 29376213, 162, '2015-03-31', 50828),
	(616, 50158093, 163, '2015-03-31', 16393),
	(617, 32996418, 164, '2015-03-31', 80867),
	(618, 580689, 165, '2015-03-31', 10739),
	(619, 32735197, 166, '2015-03-31', 38805),
	(620, 32996418, 167, '2015-03-31', 80867),
	(621, 50161280, 168, '2015-03-31', 6603),
	(622, 32276933, 169, '2015-03-31', 717),
	(623, 29446613, 170, '2015-03-31', 78236),
	(624, 32202631, 171, '2015-03-31', 3401),
	(625, 341236, 172, '2015-03-31', 3285),
	(626, 83543477, 173, '2015-03-31', 17814),
	(627, 83543477, 174, '2015-03-31', 17814),
	(628, 34237, 175, '2015-03-31', 15968),
	(629, 34231, 176, '2015-03-31', 18892),
	(630, 32735797, 177, '2015-03-31', 108760),
	(631, 50152351, 178, '2015-03-31', 11548),
	(632, 29376231, 179, '2015-03-31', 8394),
	(633, 50121054, 180, '2015-03-31', 4841);

-- Dumping structure for table reinis_buls.metter_meter
CREATE TABLE IF NOT EXISTS `metter_meter` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Skaitītāja ID',
  `ch` char(1) DEFAULT '' COMMENT 'Burts',
  `number` decimal(12,0) unsigned NOT NULL COMMENT 'Skaitītaja Numurs',
  `len` tinyint(3) unsigned NOT NULL COMMENT 'Garums',
  `length` tinyint(3) unsigned NOT NULL COMMENT 'Zīmju skaits',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Skaitītāju dati';

-- Dumping data for table reinis_buls.metter_meter: ~112 rows (approximately)
INSERT INTO `metter_meter` (`id`, `ch`, `number`, `len`, `length`) VALUES
	(1, 'W', 264, 6, 3),
	(2, 'W', 264, 6, 6),
	(3, '', 10392, 5, 5),
	(4, '', 10498, 5, 5),
	(5, '', 34231, 5, 4),
	(6, '', 34231, 5, 5),
	(7, '', 34237, 5, 4),
	(8, '', 34237, 5, 5),
	(9, '', 56993, 5, 8),
	(10, '', 82776, 5, 8),
	(11, '', 96397, 5, 5),
	(12, '', 97125, 5, 5),
	(13, '', 100145, 6, 8),
	(14, '', 110081, 6, 5),
	(15, '', 251280, 6, 8),
	(16, '', 291044, 6, 4),
	(17, '', 341236, 6, 4),
	(18, '', 556043, 6, 6),
	(19, '', 557538, 6, 8),
	(20, '', 568693, 6, 8),
	(21, '', 568796, 6, 8),
	(22, '', 580689, 6, 8),
	(23, '', 1611742, 7, 8),
	(24, '', 1611742, 8, 8),
	(25, '', 3493235, 7, 4),
	(26, '', 3639101, 7, 4),
	(27, '', 4224014, 7, 4),
	(28, '', 4547010, 7, 4),
	(29, '', 7950242, 7, 5),
	(30, '', 11400194, 8, 8),
	(31, '', 11667895, 8, 8),
	(32, '', 11667994, 8, 8),
	(33, '', 11669109, 8, 8),
	(34, '', 11669252, 8, 8),
	(35, '', 11671877, 8, 8),
	(36, '', 11675292, 8, 8),
	(37, '', 11688670, 8, 6),
	(38, '', 11688670, 8, 8),
	(39, '', 23860702, 8, 4),
	(40, '', 29292023, 8, 6),
	(41, '', 29292026, 8, 6),
	(42, '', 29292035, 8, 6),
	(43, '', 29292037, 8, 6),
	(44, '', 29375625, 8, 6),
	(45, '', 29376210, 8, 6),
	(46, '', 29376213, 8, 6),
	(47, '', 29376219, 8, 6),
	(48, '', 29376231, 8, 6),
	(49, '', 29376263, 8, 6),
	(50, '', 29376264, 8, 6),
	(51, '', 29446613, 8, 6),
	(52, '', 29446616, 8, 6),
	(53, '', 29446699, 8, 6),
	(54, '', 32149396, 8, 6),
	(55, '', 32199561, 8, 6),
	(56, '', 32202631, 8, 6),
	(57, '', 32202631, 8, 7),
	(58, '', 32245598, 8, 6),
	(59, '', 32248826, 8, 6),
	(60, '', 32276933, 8, 6),
	(61, '', 32295119, 8, 6),
	(62, '', 32414204, 8, 6),
	(63, '', 32469776, 8, 6),
	(64, '', 32558090, 8, 6),
	(65, '', 32647524, 8, 6),
	(66, '', 32687084, 8, 6),
	(67, '', 32719941, 8, 6),
	(68, '', 32735197, 8, 6),
	(69, '', 32735797, 8, 6),
	(70, '', 32778527, 8, 6),
	(71, '', 32778874, 8, 6),
	(72, '', 32996418, 8, 6),
	(73, '', 33165911, 8, 6),
	(74, '', 45723523, 8, 6),
	(75, '', 50028590, 8, 6),
	(76, '', 50028646, 8, 6),
	(77, '', 50028987, 8, 6),
	(78, '', 50050895, 8, 6),
	(79, '', 50086615, 8, 6),
	(80, '', 50088638, 8, 6),
	(81, '', 50089149, 8, 6),
	(82, '', 50121054, 8, 6),
	(83, '', 50135314, 8, 6),
	(84, '', 50152351, 8, 6),
	(85, '', 50156373, 8, 6),
	(86, '', 50158093, 8, 6),
	(87, '', 50161280, 8, 6),
	(88, '', 52685418, 8, 6),
	(89, '', 52685472, 8, 6),
	(90, '', 53117426, 8, 6),
	(91, '', 53117522, 8, 6),
	(92, '', 53119305, 8, 6),
	(93, '', 62553772, 8, 7),
	(94, '', 83543477, 8, 6),
	(95, '', 83543477, 8, 7),
	(96, '', 91002891, 8, 8),
	(97, '', 91005292, 8, 8),
	(98, '', 184611011, 9, 6),
	(99, '', 4109420145, 10, 9),
	(100, '', 4109420280, 10, 9),
	(101, '', 4109420325, 10, 9),
	(102, '', 4109420471, 10, 9),
	(103, '', 4109420527, 10, 9),
	(104, '', 4109420729, 10, 9),
	(105, '', 4109420886, 10, 8),
	(106, '', 4114492173, 10, 9),
	(107, '', 4114492229, 10, 9),
	(108, '', 4114492386, 10, 9),
	(109, '', 5110833045, 10, 8),
	(110, '', 5110914629, 10, 8),
	(111, '', 5301873827, 10, 8),
	(112, '', 41144920227, 11, 9);

-- Dumping structure for table reinis_buls.metter_object_temp
CREATE TABLE IF NOT EXISTS `metter_object_temp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `old_name` varchar(100) NOT NULL COMMENT 'Krustojuma nosaukums',
  `object_id` int(10) unsigned DEFAULT NULL COMMENT 'Krustojuma ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Dati no Excel';

-- Dumping data for table reinis_buls.metter_object_temp: ~177 rows (approximately)
INSERT INTO `metter_object_temp` (`id`, `old_name`, `object_id`) VALUES
	(1, 'Dambja - Lielās ielas krust.', NULL),
	(2, 'Dobeles - Brieža ielas krust.', NULL),
	(3, 'Lielās - Akadēmijas ielas krust.', NULL),
	(4, 'Lielā iela - Driksas tilts', NULL),
	(5, 'Lielās - Mātera ielas krust.', NULL),
	(6, 'Lielās - Pasta ielas krust.', NULL),
	(7, 'Lielās - Pētera ielas krust.', NULL),
	(8, 'Raiņa - Katoļu ielas krust.', NULL),
	(9, 'Raiņa - Pasta ielas krust.', NULL),
	(10, 'Raiņa - Akadēmijas ielas krust.', NULL),
	(11, 'Rīgas - Strazdu ielas krust.', NULL),
	(12, 'Rīgas - Garozas ielas krust.', NULL),
	(13, 'Rīgas - Loka maģistr. krust.', NULL),
	(14, 'Rīgas - Pērnavas ielas krust.', NULL),
	(15, 'Tērvetes - Rūpniecības ielas kr.', NULL),
	(16, 'Pasta - Sudrabu Edžus ielas kr.', NULL),
	(17, 'Pasta - Driksas gājēju pāreja', NULL),
	(18, 'Dobeles - Satiksmes ielas krust.', NULL),
	(19, 'Stacijas ielas  gājēju pāreja', NULL),
	(20, 'Uzvaras ielas gājēju pāreja', NULL),
	(21, 'Lietuvas šos. - Miera ielas kr.', NULL),
	(22, 'Mātera - Svētes krust.', NULL),
	(23, 'Vaļņu  iela 8', NULL),
	(24, 'Bērnudārzs Vaļņu iela 6', NULL),
	(25, 'Brīvības-Garozas', NULL),
	(26, 'Brīvības-Lāčplēša', NULL),
	(27, 'Dobeles-4. Līnija', NULL),
	(28, 'Dobeles-5. Līnija', NULL),
	(29, 'Dobeles-Atmodas', NULL),
	(30, 'Dobeles-Brieža', NULL),
	(31, 'Dobeles-Pasta-Blaumaņa', NULL),
	(32, 'Dobeles-Satiksmes', NULL),
	(33, 'Lielā-Akadēmija ', NULL),
	(34, 'Lielā-Čakstes', NULL),
	(35, 'Lielā-Dambja-Barona', NULL),
	(36, 'Lielā-IKI', NULL),
	(37, 'Lielā-Katoļu', NULL),
	(38, 'Lielā-Māras-Dobeles', NULL),
	(39, 'Lielā-Mātera', NULL),
	(40, 'Lielā-Pasta', NULL),
	(41, 'Lielā-Pētera', NULL),
	(42, 'Lietuvas-Miera', NULL),
	(43, 'Mātera-Svētes', NULL),
	(44, 'Pasta-Driksas gājēju pāreja', NULL),
	(45, 'Pasta-Edžus', NULL),
	(46, 'Pasta-Stacijas gājēju pāreja', NULL),
	(47, 'Raiņa-Akadēmijas', NULL),
	(48, 'Raiņa-Kalpaka', NULL),
	(49, 'Raiņa-Katoļu', NULL),
	(50, 'Raiņa-Mātera', NULL),
	(51, 'Raiņa-Pasta', NULL),
	(52, 'Raiņa-Tērvetes-Sarmas-Filozofu', NULL),
	(53, 'Rīga-Kalnciema-Garozas', NULL),
	(54, 'Rīgas-Brīvības', NULL),
	(55, 'Rīgas-Institūta-Lāčplēša', NULL),
	(56, 'Rīgas-Izstādes', NULL),
	(57, 'Rīgas-Keramika', NULL),
	(58, 'Rīgas-Loka', NULL),
	(59, 'Rīgas-Pērnavas', NULL),
	(60, 'Rīgas-Strazdu', NULL),
	(61, 'Rūpniecības gājēju pāreja', NULL),
	(62, 'Rūpniecības-Dambja-Atmodas', NULL),
	(63, 'Rūpniecības-Filozofu', NULL),
	(64, 'Rūpniecības-Kalpaka', NULL),
	(65, 'Rūpniecības-Mātera', NULL),
	(66, 'Rūpniecības-Tērvetes', NULL),
	(67, 'Satiksmes-Meiju-Zvejnieku', NULL),
	(68, 'Uzvaras-Barona gājēju pāreja', NULL),
	(69, 'Zemgales-Jāņa gājēju pāreja', NULL),
	(70, 'Zemgales-Stacijas gājēju pāreja', NULL),
	(71, 'Dobeles-Uzvaras', NULL),
	(72, 'Dobeles - Satiksmes ', NULL),
	(73, 'Dobeles - Brieža ', NULL),
	(74, 'Lielās - Dambja iela', NULL),
	(75, 'Lielās - Pētera ielas', NULL),
	(76, 'Lielās - Katoļu ielas krust.', NULL),
	(77, 'Lielā iela - Čakstes bulv.', NULL),
	(78, 'Mātera-Svētes krustojums', NULL),
	(79, 'Raiņa-Mātera krustojums', NULL),
	(80, 'Raiņa - Pasta ielas krustojums', NULL),
	(81, 'Raiņa - Katoļu ielas krustojums', NULL),
	(82, 'Pasta - Stacijas gājēju pāreja', NULL),
	(83, 'Rūpniecības Mātera ielu krust.', NULL),
	(84, 'Rūpniecības Kalpaka ielu kr.', NULL),
	(85, 'Rūpniecības ielas gājēju pāreja', NULL),
	(86, 'Rīgas - Brīvības bulv. Kr.', NULL),
	(87, 'Rīga - Garozas ielas krust.', NULL),
	(88, 'Rīgas - Izstādes', NULL),
	(89, 'Rīgas - Strazdu ', NULL),
	(90, 'Rīgas - Pērnavas', NULL),
	(91, 'Rīgas - Loka maģistr. ', NULL),
	(92, 'Mātera -Svētes krustojums', NULL),
	(93, 'Zemgales prospekts', NULL),
	(94, 'Meiju ceļš', NULL),
	(95, '4. Līnija', NULL),
	(96, 'Keramika', NULL),
	(97, 'Tērvetes-Raiņa-Sarmas-Filozofu', NULL),
	(98, 'Dobeles-Satiksmes-Azpāzijas', NULL),
	(99, 'Lielā-Akadēmijas-Uzvaras', NULL),
	(100, 'Lielā-Kalpaka', NULL),
	(101, 'Lielā-Pētera-Barona', NULL),
	(102, 'Lietuvas-Miera-Platones', NULL),
	(103, 'Lietuvas-Savienības', NULL),
	(104, 'Mātera-Zirgu', NULL),
	(105, 'Pasta-Driksas', NULL),
	(106, 'Pasta-Stacijas', NULL),
	(107, 'Rīgas-Kalnciema-Garozas', NULL),
	(108, 'Rīgas-Keramikas', NULL),
	(109, 'Rīgas-Pērnavas-Pumpura', NULL),
	(110, 'Rūpniecības', NULL),
	(111, 'Rūpniecības-Kalpaka-Dzelzsceļnieku', NULL),
	(112, 'Uzvaras-Barona', NULL),
	(113, 'Zemgales-Jāņa-Palīdzības', NULL),
	(114, 'Zemgales-Sporta', NULL),
	(115, 'Pasta-Sporta-Zirgu', NULL),
	(116, 'Lielā-Dambja', NULL),
	(117, 'Lielā-Pastas', NULL),
	(118, 'Lielā-Katoļus', NULL),
	(119, 'Raiņa-Katoļus', NULL),
	(120, 'Stacijas gājēju pāreja', NULL),
	(121, 'Uzvaras gājēju pāreja', NULL),
	(122, 'Tērvetes-Rūpniecības', NULL),
	(123, 'Rīga-Garozas', NULL),
	(124, 'Dobeles 4. Līnija', NULL),
	(125, 'Raiņa Kalpaka', NULL),
	(126, 'Dobeles Atmodas', NULL),
	(127, 'Lielā-Māras', NULL),
	(128, 'Rūpniecības Filozofu', NULL),
	(129, 'Atmodas-Asteru', NULL),
	(130, 'Dobeles-4.Līnija', NULL),
	(131, 'Dobeles-5.Līnija', NULL),
	(132, 'Dobeles-Satiksmes-Aspazijas', NULL),
	(133, 'Mātera -Svētes', NULL),
	(134, 'Rūpniecības-Kalpaka-Dzelzceļnieku', NULL),
	(135, 'Brīvības Garozas', NULL),
	(136, 'Brīvības Lāčplēša', NULL),
	(137, 'Dobeles 5. Līnija', NULL),
	(138, 'Dobeles Brieža', NULL),
	(139, 'Dobeles Pasta Blaumaņa', NULL),
	(140, 'Dobeles Satiksmes Azpāzijas', NULL),
	(141, 'Dobeles Uzvaras', NULL),
	(142, 'Lielā Akadēmijas Uzvaras', NULL),
	(143, 'Lielā Čakstes', NULL),
	(144, 'Lielā Dambja-Barona', NULL),
	(145, 'Lielā IKI', NULL),
	(146, 'Lielā Kalpaka', NULL),
	(147, 'Lielā Katoļu', NULL),
	(148, 'Lielā Māras Dobeles', NULL),
	(149, 'Lielā Mātera', NULL),
	(150, 'Lielā Pasta', NULL),
	(151, 'Lielā Pētera Barona', NULL),
	(152, 'Lietuvas Miera Platones', NULL),
	(153, 'Lietuvas Savienības', NULL),
	(154, 'Mātera Svētes', NULL),
	(155, 'Pasta Driksas', NULL),
	(156, 'Pasta Edžus', NULL),
	(157, 'Pasta Stacijas', NULL),
	(158, 'Raiņa Akadēmijas Čakstes', NULL),
	(159, 'Raiņa Katoļu', NULL),
	(160, 'Raiņa Mātera', NULL),
	(161, 'Raiņa Pasta', NULL),
	(162, 'Raiņa Tērvetes Sarmas Filozofu', NULL),
	(163, 'Rīgas Brīvības', NULL),
	(164, 'Rīgas Institūta Lāčplēša', NULL),
	(165, 'Rīgas Izstādes', NULL),
	(166, 'Rīgas Kalnciema Garozas', NULL),
	(167, 'Rīgas Keramikas', NULL),
	(168, 'Rīgas Loka', NULL),
	(169, 'Rīgas Pērnavas Pumpura', NULL),
	(170, 'Rīgas Strazdu', NULL),
	(171, 'Rūpniecības Dambja Atmodas', NULL),
	(172, 'Rūpniecības Kalpaka Dzelzsceļnieku', NULL),
	(173, 'Rūpniecības Mātera', NULL),
	(174, 'Rūpniecības Tērvetes', NULL),
	(175, 'Satiksmes Meiju Zvejnieku', NULL),
	(176, 'Uzvaras Barona', NULL),
	(177, 'Zemgales Jāņa Palīdzības', NULL);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
