-- -------------------------------------------------------- -- 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 m.metter_data CREATE TABLE IF NOT EXISTS `metter_data` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Ieraksta ID', `number` int(10) unsigned NOT NULL 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=253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Skaitītāju mērījumi'; -- Dumping data for table m.metter_data: ~252 rows (approximately) INSERT INTO `metter_data` (`id`, `number`, `obis`, `date`, `value`) VALUES (1, 10498, 180, '2004-08-01', 26675), (2, 32687084, 180, '2004-08-01', 9086), (3, 32469776, 180, '2004-08-01', 16897), (4, 32778874, 180, '2004-08-01', 10997), (5, 4547010, 180, '2004-08-01', 1912), (6, 110081, 180, '2004-08-01', 51621), (7, 50028590, 180, '2004-08-01', 6134), (8, 97125, 180, '2004-08-01', 45052), (9, 10392, 180, '2004-08-01', 35115), (10, 23860702, 180, '2004-08-01', 948), (11, 32996418, 180, '2004-08-01', 16747), (12, 291044, 180, '2004-08-01', 4126), (13, 7950242, 180, '2004-08-01', 44239), (14, 556043, 180, '2004-08-01', 21454), (15, 3639101, 180, '2004-08-01', 1979), (16, 50028646, 180, '2004-08-01', 1569), (17, 96397, 180, '2004-08-01', 48065), (18, 32778527, 180, '2004-08-01', 12535), (19, 3493235, 180, '2004-08-01', 7420), (20, 32647524, 180, '2004-08-01', 18208), (21, 32719941, 180, '2004-08-01', 19406), (22, 45723523, 180, '2004-08-01', 309703), (23, 62553772, 180, '2004-08-01', 286700), (24, 29446616, 180, '2006-10-01', 5408), (25, 29446699, 180, '2006-10-01', 5336), (26, 29376219, 180, '2006-10-01', 5808), (27, 29376210, 180, '2006-10-01', 949), (28, 32778874, 180, '2006-10-01', 24974), (29, 50050895, 180, '2006-10-01', 12912), (30, 50088638, 180, '2006-10-01', 5424), (31, 32687084, 180, '2006-10-01', 18772), (32, 32469776, 180, '2006-10-01', 29697), (33, 32719941, 180, '2006-10-01', 42785), (34, 29376213, 180, '2006-10-01', 5363), (35, 50028590, 180, '2006-10-01', 23733), (36, 251280, 180, '2006-10-01', 8449), (37, 50028646, 180, '2006-10-01', 5911), (38, 29376264, 180, '2006-10-01', 4060), (39, 32778527, 180, '2006-10-01', 22986), (40, 29376231, 180, '2006-10-01', 1952), (41, 184611011, 180, '2006-10-01', 5864), (42, 29292026, 180, '2006-10-01', 4771), (43, 29292023, 180, '2006-10-01', 1012), (44, 32735797, 180, '2006-10-01', 38117), (45, 32647524, 180, '2006-10-01', 30297), (46, 32996418, 180, '2006-10-01', 37597), (47, 29292035, 180, '2006-10-01', 9282), (48, 29375625, 180, '2006-10-01', 7021), (49, 29446613, 180, '2006-10-01', 5629), (50, 29376263, 180, '2006-10-01', 4187), (51, 50121054, 180, '2006-10-01', 46), (52, 29446616, 180, '2008-12-17', 20258), (53, 29446699, 180, '2008-12-17', 22121), (54, 29376219, 180, '2008-12-17', 9780), (55, 29376210, 180, '2008-12-17', 4397), (56, 32778874, 180, '2008-12-17', 40093), (57, 50050895, 180, '2008-12-17', 26703), (58, 50088638, 180, '2008-12-17', 13775), (59, 32687084, 180, '2008-12-17', 28696), (60, 32469776, 180, '2008-12-17', 44575), (61, 32719941, 180, '2008-12-17', 73643), (62, 29376213, 180, '2008-12-17', 22926), (63, 50028590, 180, '2008-12-17', 42116), (64, 251280, 180, '2008-12-17', 22776), (65, 50028646, 180, '2008-12-17', 10895), (66, 29376264, 180, '2008-12-17', 17225), (67, 32778527, 180, '2008-12-17', 36581), (68, 29376231, 180, '2008-12-17', 4402), (69, 29292037, 180, '2008-12-17', 18559), (70, 29292026, 180, '2008-12-17', 16248), (71, 29292023, 180, '2008-12-17', 3764), (72, 32735797, 180, '2008-12-17', 55988), (73, 32647524, 180, '2008-12-17', 46068), (74, 32996418, 180, '2008-12-17', 59366), (75, 29292035, 180, '2008-12-17', 26880), (76, 29375625, 180, '2008-12-17', 23833), (77, 29446613, 180, '2008-12-17', 25460), (78, 29376263, 180, '2008-12-17', 16607), (79, 50121054, 180, '2008-12-17', 1326), (80, 50152351, 180, '2008-12-17', 2102), (81, 50156373, 180, '2008-12-17', 1175), (82, 50161280, 180, '2008-12-17', 557), (83, 50158093, 180, '2008-12-17', 1795), (84, 557538, 180, '2008-12-17', 488), (85, 580689, 180, '2008-12-17', 137), (86, 568796, 180, '2008-12-17', 200), (87, 568693, 180, '2008-12-17', 88), (88, 50028987, 180, '2011-03-28', 1931), (89, 29446699, 180, '2011-03-28', 35970), (90, 50089149, 180, '2011-03-28', 187), (91, 29376210, 180, '2011-03-28', 8285), (92, 32778874, 180, '2011-03-28', 57273), (93, 50050895, 180, '2011-03-28', 41791), (94, 50088638, 180, '2011-03-28', 23507), (95, 32687084, 180, '2011-03-28', 39218), (96, 32469776, 180, '2011-03-28', 62441), (97, 32719941, 180, '2011-03-28', 110570), (98, 29376213, 180, '2011-03-28', 40643), (99, 50028590, 180, '2011-03-28', 60780), (100, 251280, 180, '2011-03-28', 25876), (101, 50028646, 180, '2011-03-28', 16488), (102, 29376264, 180, '2011-03-28', 31286), (103, 32778527, 180, '2011-03-28', 49174), (104, 29376231, 180, '2011-03-28', 5794), (105, 29292037, 180, '2011-03-28', 29404), (106, 29292026, 180, '2011-03-28', 28119), (107, 29292023, 180, '2011-03-28', 6891), (108, 32735797, 180, '2011-03-28', 77438), (109, 32647524, 180, '2011-03-28', 61903), (110, 32996418, 180, '2011-03-28', 67189), (111, 32735197, 180, '2011-03-28', 8100), (112, 29375625, 180, '2011-03-28', 38983), (113, 29446613, 180, '2011-03-28', 46535), (114, 29376263, 180, '2011-03-28', 20051), (115, 50121054, 180, '2011-03-28', 2628), (116, 50152351, 180, '2011-03-28', 5523), (117, 50156373, 180, '2011-03-28', 3645), (118, 50161280, 180, '2011-03-28', 2674), (119, 50158093, 180, '2011-03-28', 6131), (120, 557538, 180, '2011-03-28', 4232), (121, 580689, 180, '2011-03-28', 3715), (122, 568796, 180, '2011-03-28', 3169), (123, 568693, 180, '2011-03-28', 3136), (124, 50135314, 180, '2011-03-28', 2318), (125, 32414204, 180, '2011-03-28', 3587), (126, 83543477, 180, '2011-03-28', 2191), (127, 10498, 180, '2004-07-01', 26267), (128, 32687084, 180, '2004-07-01', 8716), (129, 32469776, 180, '2004-07-01', 16441), (130, 32778874, 180, '2004-07-01', 10751), (131, 4547010, 180, '2004-07-01', 1217), (132, 110081, 180, '2004-07-01', 50878), (133, 50028590, 180, '2004-07-01', 5471), (134, 97125, 180, '2004-07-01', 44345), (135, 10392, 180, '2004-07-01', 34402), (136, 23860702, 180, '2004-07-01', 471), (137, 32996418, 180, '2004-07-01', 15961), (138, 291044, 180, '2004-07-01', 3468), (139, 7950242, 180, '2004-07-01', 43681), (140, 556043, 180, '2004-07-01', 20675), (141, 3639101, 180, '2004-07-01', 1430), (142, 50028646, 180, '2004-07-01', 1412), (143, 96397, 180, '2004-07-01', 47513), (144, 32778527, 180, '2004-07-01', 12200), (145, 3493235, 180, '2004-07-01', 7212), (146, 32647524, 180, '2004-07-01', 17720), (147, 32719941, 180, '2004-07-01', 18441), (148, 45723523, 180, '2004-07-01', 306566), (149, 62553772, 180, '2004-07-01', 283700), (150, 29446616, 180, '2006-11-01', 6033), (151, 29446699, 180, '2006-11-01', 5947), (152, 29376219, 180, '2006-11-01', 5904), (153, 29376210, 180, '2006-11-01', 1061), (154, 32778874, 180, '2006-11-01', 25492), (155, 50050895, 180, '2006-11-01', 13409), (156, 50088638, 180, '2006-11-01', 5675), (157, 32687084, 180, '2006-11-01', 19139), (158, 32469776, 180, '2006-11-01', 30138), (159, 32719941, 180, '2006-11-01', 43675), (160, 29376213, 180, '2006-11-01', 6008), (161, 50028590, 180, '2006-11-01', 24392), (162, 251280, 180, '2006-11-01', 9073), (163, 50028646, 180, '2006-11-01', 6088), (164, 29376264, 180, '2006-11-01', 4507), (165, 32778527, 180, '2006-11-01', 23516), (166, 29376231, 180, '2006-11-01', 2222), (167, 184611011, 180, '2006-11-01', 6352), (168, 29292026, 180, '2006-11-01', 5194), (169, 29292023, 180, '2006-11-01', 1105), (170, 32735797, 180, '2006-11-01', 38691), (171, 32647524, 180, '2006-11-01', 30874), (172, 32996418, 180, '2006-11-01', 38421), (173, 29292035, 180, '2006-11-01', 9968), (174, 29375625, 180, '2006-11-01', 7536), (175, 29446613, 180, '2006-11-01', 6332), (176, 29376263, 180, '2006-11-01', 4717), (177, 50121054, 180, '2006-11-01', 90), (178, 29446616, 180, '2009-02-01', 20697), (179, 29446699, 180, '2009-02-01', 22981), (180, 29376219, 180, '2009-02-01', 10042), (181, 29376210, 180, '2009-02-01', 4600), (182, 32778874, 180, '2009-02-01', 40926), (183, 50050895, 180, '2009-02-01', 27444), (184, 50088638, 180, '2009-02-01', 14240), (185, 32687084, 180, '2009-02-01', 29208), (186, 32469776, 180, '2009-02-01', 45437), (187, 32719941, 180, '2009-02-01', 75461), (188, 29376213, 180, '2009-02-01', 23849), (189, 50028590, 180, '2009-02-01', 43095), (190, 251280, 180, '2009-02-01', 22996), (191, 50028646, 180, '2009-02-01', 11196), (192, 29376264, 180, '2009-02-01', 17950), (193, 32778527, 180, '2009-02-01', 37240), (194, 29376231, 180, '2009-02-01', 4447), (195, 29292037, 180, '2009-02-01', 19240), (196, 29292026, 180, '2009-02-01', 16845), (197, 29292023, 180, '2009-02-01', 3896), (198, 32735797, 180, '2009-02-01', 57103), (199, 32647524, 180, '2009-02-01', 46878), (200, 32996418, 180, '2009-02-01', 59874), (201, 29292035, 180, '2009-02-01', 27665), (202, 29375625, 180, '2009-02-01', 24553), (203, 29446613, 180, '2009-02-01', 26544), (204, 29376263, 180, '2009-02-01', 16792), (205, 50121054, 180, '2009-02-01', 1387), (206, 50152351, 180, '2009-02-01', 2277), (207, 50156373, 180, '2009-02-01', 1277), (208, 50161280, 180, '2009-02-01', 664), (209, 50158093, 180, '2009-02-01', 2006), (210, 557538, 180, '2009-02-01', 721), (211, 580689, 180, '2009-02-01', 316), (212, 568796, 180, '2009-02-01', 351), (213, 568693, 180, '2009-02-01', 151), (214, 50028987, 180, '2011-04-29', 2079), (215, 29446699, 180, '2011-04-29', 36087), (216, 50089149, 180, '2011-04-29', 366), (217, 29376210, 180, '2011-04-29', 8423), (218, 32778874, 180, '2011-04-29', 57910), (219, 50050895, 180, '2011-04-29', 42255), (220, 50088638, 180, '2011-04-29', 23903), (221, 32687084, 180, '2011-04-29', 39622), (222, 32469776, 180, '2011-04-29', 63093), (223, 32719941, 180, '2011-04-29', 111889), (224, 29376213, 180, '2011-04-29', 41294), (225, 50028590, 180, '2011-04-29', 61346), (226, 251280, 180, '2011-04-29', 25970), (227, 50028646, 180, '2011-04-29', 16690), (228, 29376264, 180, '2011-04-29', 31801), (229, 32778527, 180, '2011-04-29', 49652), (230, 29376231, 180, '2011-04-29', 5840), (231, 29292037, 180, '2011-04-29', 29820), (232, 29292026, 180, '2011-04-29', 28540), (233, 29292023, 180, '2011-04-29', 6988), (234, 32735797, 180, '2011-04-29', 78100), (235, 32647524, 180, '2011-04-29', 62364), (236, 32996418, 180, '2011-04-29', 67492), (237, 32735197, 180, '2011-04-29', 8733), (238, 29375625, 180, '2011-04-29', 39518), (239, 29446613, 180, '2011-04-29', 47190), (240, 29376263, 180, '2011-04-29', 20117), (241, 50121054, 180, '2011-04-29', 2672), (242, 50152351, 180, '2011-04-29', 5649), (243, 50156373, 180, '2011-04-29', 3793), (244, 50161280, 180, '2011-04-29', 2753), (245, 50158093, 180, '2011-04-29', 6298), (246, 557538, 180, '2011-04-29', 4373), (247, 580689, 180, '2011-04-29', 3851), (248, 568796, 180, '2011-04-29', 3275), (249, 568693, 180, '2011-04-29', 3330), (250, 50135314, 180, '2011-04-29', 2454), (251, 32414204, 180, '2011-04-29', 3850), (252, 83543477, 180, '2011-04-29', 2500); -- Dumping structure for table m.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=512 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Skaitītāju dati'; -- Dumping data for table m.metter_meter: ~274 rows (approximately) INSERT INTO `metter_meter` (`id`, `ch`, `number`, `len`, `length`) VALUES (1, '', 10498, 7, 5), (2, '', 32687084, 8, 6), (3, '', 32469776, 8, 6), (4, '', 32778874, 8, 6), (5, '', 4547010, 7, 4), (6, '', 110081, 7, 5), (7, '', 50028590, 8, 6), (8, '', 97125, 7, 5), (9, '', 10392, 7, 5), (10, '', 23860702, 8, 4), (11, '', 32996418, 8, 6), (12, '', 291044, 6, 4), (13, '', 7950242, 7, 5), (14, '', 556043, 7, 6), (15, '', 3639101, 7, 4), (16, '', 50028646, 8, 6), (17, '', 96397, 7, 5), (18, '', 32778527, 8, 6), (19, '', 3493235, 7, 4), (20, '', 32647524, 8, 6), (21, '', 32719941, 8, 6), (22, '', 45723523, 8, 6), (23, '', 62553772, 8, 7), (24, '', 29446616, 8, 6), (25, '', 29446699, 8, 6), (26, '', 29376219, 8, 6), (27, '', 29376210, 8, 6), (28, '', 32778874, 8, 6), (29, '', 50050895, 8, 6), (30, '', 50088638, 8, 6), (31, '', 32687084, 8, 6), (32, '', 32469776, 8, 6), (33, '', 32719941, 8, 6), (34, '', 32719941, 8, 6), (35, '', 29376213, 8, 6), (36, '', 50028590, 8, 6), (37, '', 251280, 6, 8), (38, '', 50028646, 8, 6), (39, '', 29376264, 8, 6), (40, '', 32778527, 8, 6), (41, '', 32778527, 8, 6), (42, '', 29376231, 8, 6), (43, '', 184611011, 9, 6), (44, '', 29292026, 8, 6), (45, '', 29292023, 8, 6), (46, '', 32735797, 8, 6), (47, '', 32647524, 8, 6), (48, '', 32996418, 8, 6), (49, '', 32996418, 8, 6), (50, '', 29292035, 8, 6), (51, '', 29375625, 8, 6), (52, '', 29446613, 8, 6), (53, '', 29376263, 8, 6), (54, '', 50121054, 8, 6), (55, '', 29446616, 8, 6), (56, '', 29446699, 8, 6), (57, '', 29376219, 8, 6), (58, '', 29376210, 8, 6), (59, '', 32778874, 8, 6), (60, '', 50050895, 8, 6), (61, '', 50088638, 8, 6), (62, '', 32687084, 8, 6), (63, '', 32469776, 8, 6), (64, '', 32719941, 8, 6), (65, '', 32719941, 8, 6), (66, '', 29376213, 8, 6), (67, '', 50028590, 8, 6), (68, '', 251280, 6, 8), (69, '', 50028646, 8, 6), (70, '', 29376264, 8, 6), (71, '', 32778527, 8, 6), (72, '', 32778527, 8, 6), (73, '', 29376231, 8, 6), (74, '', 29292037, 8, 6), (75, '', 29292026, 8, 6), (76, '', 29292023, 8, 6), (77, '', 32735797, 8, 6), (78, '', 32647524, 8, 6), (79, '', 32996418, 8, 6), (80, '', 32996418, 8, 6), (81, '', 29292035, 8, 6), (82, '', 29375625, 8, 6), (83, '', 29446613, 8, 6), (84, '', 29376263, 8, 6), (85, '', 50121054, 8, 6), (86, '', 50152351, 8, 6), (87, '', 50156373, 8, 6), (88, '', 50161280, 8, 6), (89, '', 50158093, 8, 6), (90, '', 557538, 6, 8), (91, '', 580689, 6, 8), (92, '', 568796, 6, 8), (93, '', 568693, 6, 8), (94, '', 50028987, 8, 6), (95, '', 29446699, 8, 6), (96, '', 50089149, 8, 6), (97, '', 29376210, 8, 6), (98, '', 32778874, 8, 6), (99, '', 50050895, 8, 6), (100, '', 50088638, 8, 6), (101, '', 32687084, 8, 6), (102, '', 32469776, 8, 6), (103, '', 32719941, 8, 6), (104, '', 32719941, 8, 6), (105, '', 29376213, 8, 6), (106, '', 50028590, 8, 6), (107, '', 251280, 6, 8), (108, '', 50028646, 8, 6), (109, '', 29376264, 8, 6), (110, '', 32778527, 8, 6), (111, '', 32778527, 8, 6), (112, '', 29376231, 8, 6), (113, '', 29292037, 8, 6), (114, '', 29292026, 8, 6), (115, '', 29292023, 8, 6), (116, '', 32735797, 8, 6), (117, '', 32647524, 8, 6), (118, '', 32996418, 8, 6), (119, '', 32996418, 8, 6), (120, '', 32735197, 8, 6), (121, '', 29375625, 8, 6), (122, '', 29446613, 8, 6), (123, '', 29376263, 8, 6), (124, '', 50121054, 8, 6), (125, '', 50152351, 8, 6), (126, '', 50156373, 8, 6), (127, '', 50161280, 8, 6), (128, '', 50158093, 8, 6), (129, '', 557538, 6, 8), (130, '', 580689, 6, 8), (131, '', 568796, 6, 8), (132, '', 568693, 6, 8), (133, '', 50135314, 8, 6), (134, '', 32414204, 8, 6), (135, '', 32414204, 8, 6), (136, '', 83543477, 8, 6), (137, '', 83543477, 8, 6), (138, '', 10498, 7, 5), (139, '', 32687084, 8, 6), (140, '', 32469776, 8, 6), (141, '', 32778874, 8, 6), (142, '', 4547010, 7, 4), (143, '', 110081, 7, 5), (144, '', 50028590, 8, 6), (145, '', 97125, 7, 5), (146, '', 10392, 7, 5), (147, '', 23860702, 8, 4), (148, '', 32996418, 8, 6), (149, '', 291044, 6, 4), (150, '', 7950242, 7, 5), (151, '', 556043, 7, 6), (152, '', 3639101, 7, 4), (153, '', 50028646, 8, 6), (154, '', 96397, 7, 5), (155, '', 32778527, 8, 6), (156, '', 3493235, 7, 4), (157, '', 32647524, 8, 6), (158, '', 32719941, 8, 6), (159, '', 45723523, 8, 6), (160, '', 62553772, 8, 7), (161, '', 29446616, 8, 6), (162, '', 29446699, 8, 6), (163, '', 29376219, 8, 6), (164, '', 29376210, 8, 6), (165, '', 32778874, 8, 6), (166, '', 50050895, 8, 6), (167, '', 50088638, 8, 6), (168, '', 32687084, 8, 6), (169, '', 32469776, 8, 6), (170, '', 32719941, 8, 6), (171, '', 32719941, 8, 6), (172, '', 29376213, 8, 6), (173, '', 50028590, 8, 6), (174, '', 251280, 6, 8), (175, '', 50028646, 8, 6), (176, '', 29376264, 8, 6), (177, '', 32778527, 8, 6), (178, '', 32778527, 8, 6), (179, '', 29376231, 8, 6), (180, '', 184611011, 9, 6), (181, '', 29292026, 8, 6), (182, '', 29292023, 8, 6), (183, '', 32735797, 8, 6), (184, '', 32647524, 8, 6), (185, '', 32996418, 8, 6), (186, '', 32996418, 8, 6), (187, '', 29292035, 8, 6), (188, '', 29375625, 8, 6), (189, '', 29446613, 8, 6), (190, '', 29376263, 8, 6), (191, '', 50121054, 8, 6), (192, '', 29446616, 8, 6), (193, '', 29446699, 8, 6), (194, '', 29376219, 8, 6), (195, '', 29376210, 8, 6), (196, '', 32778874, 8, 6), (197, '', 50050895, 8, 6), (198, '', 50088638, 8, 6), (199, '', 32687084, 8, 6), (200, '', 32469776, 8, 6), (201, '', 32719941, 8, 6), (202, '', 32719941, 8, 6), (203, '', 29376213, 8, 6), (204, '', 50028590, 8, 6), (205, '', 251280, 6, 8), (206, '', 50028646, 8, 6), (207, '', 29376264, 8, 6), (208, '', 32778527, 8, 6), (209, '', 32778527, 8, 6), (210, '', 29376231, 8, 6), (211, '', 29292037, 8, 6), (212, '', 29292026, 8, 6), (213, '', 29292023, 8, 6), (214, '', 32735797, 8, 6), (215, '', 32647524, 8, 6), (216, '', 32996418, 8, 6), (217, '', 32996418, 8, 6), (218, '', 29292035, 8, 6), (219, '', 29375625, 8, 6), (220, '', 29446613, 8, 6), (221, '', 29376263, 8, 6), (222, '', 50121054, 8, 6), (223, '', 50152351, 8, 6), (224, '', 50156373, 8, 6), (225, '', 50161280, 8, 6), (226, '', 50158093, 8, 6), (227, '', 557538, 6, 8), (228, '', 580689, 6, 8), (229, '', 568796, 6, 8), (230, '', 568693, 6, 8), (231, '', 50028987, 8, 6), (232, '', 29446699, 8, 6), (233, '', 50089149, 8, 6), (234, '', 29376210, 8, 6), (235, '', 32778874, 8, 6), (236, '', 50050895, 8, 6), (237, '', 50088638, 8, 6), (238, '', 32687084, 8, 6), (239, '', 32469776, 8, 6), (240, '', 32719941, 8, 6), (241, '', 32719941, 8, 6), (242, '', 29376213, 8, 6), (243, '', 50028590, 8, 6), (244, '', 251280, 6, 8), (245, '', 50028646, 8, 6), (246, '', 29376264, 8, 6), (247, '', 32778527, 8, 6), (248, '', 32778527, 8, 6), (249, '', 29376231, 8, 6), (250, '', 29292037, 8, 6), (251, '', 29292026, 8, 6), (252, '', 29292023, 8, 6), (253, '', 32735797, 8, 6), (254, '', 32647524, 8, 6), (255, '', 32996418, 8, 6), (256, '', 32996418, 8, 6), (257, '', 32735197, 8, 6), (258, '', 29375625, 8, 6), (259, '', 29446613, 8, 6), (260, '', 29376263, 8, 6), (261, '', 50121054, 8, 6), (262, '', 50152351, 8, 6), (263, '', 50156373, 8, 6), (264, '', 50161280, 8, 6), (265, '', 50158093, 8, 6), (266, '', 557538, 6, 8), (267, '', 580689, 6, 8), (268, '', 568796, 6, 8), (269, '', 568693, 6, 8), (270, '', 50135314, 8, 6), (271, '', 32414204, 8, 6), (272, '', 32414204, 8, 6), (273, '', 83543477, 8, 6), (274, '', 83543477, 8, 6); -- Dumping structure for table m.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=99 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Dati no Excel'; -- Dumping data for table m.metter_object_temp: ~98 rows (approximately) INSERT INTO `metter_object_temp` (`id`, `old_name`, `object_id`) VALUES (1, 'Bērnudārzs Vaļņu iela 6', NULL), (2, 'Brīvības-Garozas', NULL), (3, 'Brīvības-Lāčplēša', NULL), (4, 'Dobeles - Brieža ielas krust.', NULL), (5, 'Dobeles - Satiksmes ielas krust.', NULL), (6, 'Dobeles – Brieža ', NULL), (7, 'Dobeles – Satiksmes ', NULL), (8, 'Dobeles 4. Līnija', NULL), (9, 'Dobeles Atmodas', NULL), (10, 'Dobeles-Brieža', NULL), (11, 'Dobeles-Satiksmes', NULL), (12, 'Keramika', NULL), (13, 'Lielā iela - Čakstes bulv.', NULL), (14, 'Lielā iela - Driksas tilts', NULL), (15, 'Lielā IKI', NULL), (16, 'Lielā-Akadēmija ', NULL), (17, 'Lielā-Čakstes', NULL), (18, 'Lielā-Dambja', NULL), (19, 'Lielā-Katoļus', NULL), (20, 'Lielā-Māras', NULL), (21, 'Lielā-Mātera', NULL), (22, 'Lielā-Pastas', NULL), (23, 'Lielā-Pētera', NULL), (24, 'Lielās - Akadēmijas ielas krust.', NULL), (25, 'Lielās - Mātera ielas krust.', NULL), (26, 'Lielās - Pasta ielas krust.', NULL), (27, 'Lielās - Pētera ielas', NULL), (28, 'Lielās - Pētera ielas krust.', NULL), (29, 'Lielās – Akadēmijas ielas krust.', NULL), (30, 'Lielās – Dambja iela', NULL), (31, 'Lielās – Katoļu ielas krust.', NULL), (32, 'Lielās-Akadēmija ', NULL), (33, 'Lielās-Dambja', NULL), (34, 'Lielās-Katoļus', NULL), (35, 'Lielās-Māteras', NULL), (36, 'Lielās-Pastas', NULL), (37, 'Lielās-Pēteras', NULL), (38, 'Lietuvas šos. - Miera ielas kr. ', NULL), (39, 'Lietuvas šos. – Miera ielas kr. ', NULL), (40, 'Lietuvas-Miera', NULL), (41, 'Lietuvas-Mieras', NULL), (42, 'Mātera - Svētes krust. ', NULL), (43, 'Mātera -Svētes krustojums ', NULL), (44, 'Mātera-Svētes', NULL), (45, 'Meiju ceļš', NULL), (46, 'Pasta - Sudrabu Edžus ielas kr.', NULL), (47, 'Pasta – Driksas gājēju pāreja', NULL), (48, 'Pasta – Stacijas gājēju pāreja', NULL), (49, 'Pasta-Driksas gājēju pāreja', NULL), (50, 'Pasta-Edžus', NULL), (51, 'Pasta-Stacijas gājēju pāreja', NULL), (52, 'Raiņa - Akadēmijas ielas krust.', NULL), (53, 'Raiņa - Katoļu ielas krust.', NULL), (54, 'Raiņa - Katoļu ielas krustojums', NULL), (55, 'Raiņa - Pasta ielas krust.', NULL), (56, 'Raiņa - Pasta ielas krustojums', NULL), (57, 'Raiņa – Akadēmijas ielas krust.', NULL), (58, 'Raiņa Kalpaka', NULL), (59, 'Raiņa-Akadēmijas', NULL), (60, 'Raiņa-Katoļus', NULL), (61, 'Raiņa-Mātera', NULL), (62, 'Raiņa-Mātera krustojums', NULL), (63, 'Raiņa-Pasta', NULL), (64, 'Rīga - Garozas ielas krust.', NULL), (65, 'Rīga-Garozas', NULL), (66, 'Rīgas - Garozas ielas krust.', NULL), (67, 'Rīgas - Loka maģistr. krust.', NULL), (68, 'Rīgas - Pērnavas ielas krust.', NULL), (69, 'Rīgas - Strazdu ielas krust.', NULL), (70, 'Rīgas – Brīvības bulv. Kr.', NULL), (71, 'Rīgas – Izstādes', NULL), (72, 'Rīgas – Loka maģistr. ', NULL), (73, 'Rīgas – Pērnavas', NULL), (74, 'Rīgas – Strazdu ', NULL), (75, 'Rīgas-Brīvības', NULL), (76, 'Rīgas-Institūta-Lāčplēša', NULL), (77, 'Rīgas-Izstādes', NULL), (78, 'Rīgas-Loka', NULL), (79, 'Rīgas-Pērnavas', NULL), (80, 'Rīgas-Strazdu', NULL), (81, 'Rūpniecības Dambju Atmodas', NULL), (82, 'Rūpniecības Filozofu', NULL), (83, 'Rūpniecības gājēju pāreja', NULL), (84, 'Rūpniecības ielas gājēju pāreja', NULL), (85, 'Rūpniecības Kalpaka ielu kr.', NULL), (86, 'Rūpniecības Mātera ielu krust.', NULL), (87, 'Rūpniecības-Kalpaka', NULL), (88, 'Rūpniecības-Mātera', NULL), (89, 'Stacijas gājēju pāreja', NULL), (90, 'Stacijas ielas gājēju pāreja', NULL), (91, 'Tērvetes - Rūpniecības ielas kr.', NULL), (92, 'Tērvetes – Rūpniecības ielas kr.', NULL), (93, 'Tērvetes-Raiņa-Sarmas-Filozofu', NULL), (94, 'Tērvetes-Rūpniecības', NULL), (95, 'Uzvaras gājēju pāreja', NULL), (96, 'Uzvaras ielas gājēju pāreja', NULL), (97, 'Vaļņu iela 8', NULL), (98, 'Zemgales prospekts', NULL); -- Dumping structure for table m.skaititaji CREATE TABLE IF NOT EXISTS `skaititaji` ( `name` varchar(100) NOT NULL COMMENT 'Krustojuma nosaukums', `number` varchar(12) NOT NULL COMMENT 'Skaitītaja Numurs', `obis` varchar(12) DEFAULT '180' COMMENT 'koeficents', `date_from` date NOT NULL COMMENT 'Datums no', `value_from` varchar(15) NOT NULL COMMENT 'Vērtības no', `date_to` date NOT NULL COMMENT 'Datums līdz', `value_to` varchar(15) NOT NULL COMMENT 'Vērtības lidz', `different` int(10) unsigned NOT NULL COMMENT 'Patēriņš', `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Ieraksta ID', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=648 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Dati no Excel'; -- Dumping data for table m.skaititaji: ~274 rows (approximately) INSERT INTO `skaititaji` (`name`, `number`, `obis`, `date_from`, `value_from`, `date_to`, `value_to`, `different`, `id`) VALUES ('Dobeles - Brieža ielas krust.', '0010498', '180', '2004-08-01', '26675', '2004-07-01', '26267', 408, 256), ('Lielās - Akadēmijas ielas krust.', '32687084', '180', '2004-08-01', '009086', '2004-07-01', '008716', 370, 257), ('Lielā iela - Driksas tilts', '32469776', '180', '2004-08-01', '016897', '2004-07-01', '016441', 456, 258), ('Lielās - Mātera ielas krust.', '32778874', '180', '2004-08-01', '010997', '2004-07-01', '010751', 246, 259), ('Lielās - Pasta ielas krust.', '4547010', '180', '2004-08-01', '1912', '2004-07-01', '1217', 695, 260), ('Lielās - Pētera ielas krust.', '0110081', '180', '2004-08-01', '51621', '2004-07-01', '50878', 743, 261), ('Raiņa - Katoļu ielas krust.', '50028590', '180', '2004-08-01', '006134', '2004-07-01', '005471', 663, 262), ('Raiņa - Pasta ielas krust.', '0097125', '180', '2004-08-01', '45052', '2004-07-01', '44345', 707, 263), ('Raiņa - Akadēmijas ielas krust.', '0010392', '180', '2004-08-01', '35115', '2004-07-01', '34402', 713, 264), ('Rīgas - Strazdu ielas krust.', '23860702', '180', '2004-08-01', '0948', '2004-07-01', '0471', 477, 265), ('Rīgas - Garozas ielas krust.', '32996418', '180', '2004-08-01', '016747', '2004-07-01', '015961', 786, 266), ('Rīgas - Loka maģistr. krust.', '291044', '180', '2004-08-01', '4126', '2004-07-01', '3468', 658, 267), ('Rīgas - Pērnavas ielas krust.', '7950242', '180', '2004-08-01', '44239', '2004-07-01', '43681', 558, 268), ('Tērvetes - Rūpniecības ielas kr.', '0556043', '180', '2004-08-01', '021454', '2004-07-01', '020675', 779, 269), ('Pasta - Sudrabu Edžus ielas kr.', '3639101', '180', '2004-08-01', '1979', '2004-07-01', '1430', 549, 270), ('Pasta – Driksas gājēju pāreja', '50028646', '180', '2004-08-01', '001569', '2004-07-01', '001412', 157, 271), ('Dobeles - Satiksmes ielas krust.', '0096397', '180', '2004-08-01', '48065', '2004-07-01', '47513', 552, 272), ('Stacijas ielas gājēju pāreja', '32778527', '180', '2004-08-01', '012535', '2004-07-01', '012200', 335, 273), ('Uzvaras ielas gājēju pāreja', '3493235', '180', '2004-08-01', '7420', '2004-07-01', '7212', 208, 274), ('Lietuvas šos. - Miera ielas kr. ', '32647524', '180', '2004-08-01', '018208', '2004-07-01', '017720', 488, 275), ('Mātera - Svētes krust. ', '32719941', '180', '2004-08-01', '019406', '2004-07-01', '018441', 965, 276), ('Vaļņu iela 8', '45723523', '180', '2004-08-01', '309703', '2004-07-01', '306566', 3137, 277), ('Bērnudārzs Vaļņu iela 6', '62553772', '180', '2004-08-01', '0286700', '2004-07-01', '0283700', 3000, 278), ('Dobeles – Satiksmes ', '29446616', '180', '2006-10-01', '005408', '2006-11-01', '006033', 625, 279), ('Dobeles – Brieža ', '29446699', '180', '2006-10-01', '005336', '2006-11-01', '005947', 611, 280), ('Lielās – Dambja iela', '29376219', '180', '2006-10-01', '005808', '2006-11-01', '005904', 96, 281), ('Lielās - Pētera ielas', '29376210', '180', '2006-10-01', '000949', '2006-11-01', '001061', 112, 282), ('Lielās - Mātera ielas krust.', '32778874', '180', '2006-10-01', '024974', '2006-11-01', '025492', 518, 283), ('Lielās - Pasta ielas krust.', '50050895', '180', '2006-10-01', '012912', '2006-11-01', '013409', 497, 284), ('Lielās – Katoļu ielas krust.', '50088638', '180', '2006-10-01', '005424', '2006-11-01', '005675', 251, 285), ('Lielās – Akadēmijas ielas krust.', '32687084', '180', '2006-10-01', '018772', '2006-11-01', '019139', 367, 286), ('Lielā iela - Čakstes bulv.', '32469776', '180', '2006-10-01', '029697', '2006-11-01', '030138', 441, 287), ('Mātera -Svētes krustojums ', '32719941', '180', '2006-10-01', '042785', '2006-11-01', '043675', 890, 288), ('Raiņa-Mātera krustojums', '32719941', '180', '2006-10-01', '042785', '2006-11-01', '043675', 890, 289), ('Raiņa - Pasta ielas krustojums', '29376213', '180', '2006-10-01', '005363', '2006-11-01', '006008', 645, 290), ('Raiņa - Katoļu ielas krustojums', '50028590', '180', '2006-10-01', '023733', '2006-11-01', '024392', 659, 291), ('Raiņa – Akadēmijas ielas krust.', '251280', '180', '2006-10-01', '00008449', '2006-11-01', '00009073', 624, 292), ('Pasta – Driksas gājēju pāreja', '50028646', '180', '2006-10-01', '005911', '2006-11-01', '006088', 177, 293), ('Pasta - Sudrabu Edžus ielas kr.', '29376264', '180', '2006-10-01', '004060', '2006-11-01', '004507', 447, 294), ('Pasta – Stacijas gājēju pāreja', '32778527', '180', '2006-10-01', '022986', '2006-11-01', '023516', 530, 295), ('Stacijas ielas gājēju pāreja', '32778527', '180', '2006-10-01', '022986', '2006-11-01', '023516', 530, 296), ('Uzvaras ielas gājēju pāreja', '29376231', '180', '2006-10-01', '001952', '2006-11-01', '002222', 270, 297), ('Rūpniecības Mātera ielu krust.', '184611011', '180', '2006-10-01', '005864', '2006-11-01', '006352', 488, 298), ('Rūpniecības Kalpaka ielu kr.', '29292026', '180', '2006-10-01', '004771', '2006-11-01', '005194', 423, 299), ('Rūpniecības ielas gājēju pāreja', '29292023', '180', '2006-10-01', '001012', '2006-11-01', '001105', 93, 300), ('Tērvetes – Rūpniecības ielas kr.', '32735797', '180', '2006-10-01', '038117', '2006-11-01', '038691', 574, 301), ('Lietuvas šos. – Miera ielas kr. ', '32647524', '180', '2006-10-01', '030297', '2006-11-01', '030874', 577, 302), ('Rīgas – Brīvības bulv. Kr.', '32996418', '180', '2006-10-01', '037597', '2006-11-01', '038421', 824, 303), ('Rīga - Garozas ielas krust.', '32996418', '180', '2006-10-01', '037597', '2006-11-01', '038421', 824, 304), ('Rīgas – Izstādes', '29292035', '180', '2006-10-01', '009282', '2006-11-01', '009968', 686, 305), ('Rīgas – Strazdu ', '29375625', '180', '2006-10-01', '007021', '2006-11-01', '007536', 515, 306), ('Rīgas – Pērnavas', '29446613', '180', '2006-10-01', '005629', '2006-11-01', '006332', 703, 307), ('Rīgas – Loka maģistr. ', '29376263', '180', '2006-10-01', '004187', '2006-11-01', '004717', 530, 308), ('Zemgales prospekts', '50121054', '180', '2006-10-01', '000046', '2006-11-01', '000090', 44, 309), ('Dobeles-Satiksmes', '29446616', '180', '2008-12-17', '020258', '2009-02-01', '020697', 439, 310), ('Dobeles-Brieža', '29446699', '180', '2008-12-17', '022121', '2009-02-01', '022981', 860, 311), ('Lielās-Dambja', '29376219', '180', '2008-12-17', '009780', '2009-02-01', '010042', 262, 312), ('Lielās-Pēteras', '29376210', '180', '2008-12-17', '004397', '2009-02-01', '004600', 203, 313), ('Lielās-Māteras', '32778874', '180', '2008-12-17', '040093', '2009-02-01', '040926', 833, 314), ('Lielās-Pastas', '50050895', '180', '2008-12-17', '026703', '2009-02-01', '027444', 741, 315), ('Lielās-Katoļus', '50088638', '180', '2008-12-17', '013775', '2009-02-01', '014240', 465, 316), ('Lielās-Akadēmija ', '32687084', '180', '2008-12-17', '028696', '2009-02-01', '029208', 512, 317), ('Lielā-Čakstes', '32469776', '180', '2008-12-17', '044575', '2009-02-01', '045437', 862, 318), ('Mātera-Svētes', '32719941', '180', '2008-12-17', '073643', '2009-02-01', '075461', 1818, 319), ('Raiņa-Mātera', '32719941', '180', '2008-12-17', '073643', '2009-02-01', '075461', 1818, 320), ('Raiņa-Pasta', '29376213', '180', '2008-12-17', '022926', '2009-02-01', '023849', 923, 321), ('Raiņa-Katoļus', '50028590', '180', '2008-12-17', '042116', '2009-02-01', '043095', 979, 322), ('Raiņa-Akadēmijas', '251280', '180', '2008-12-17', '00022776', '2009-02-01', '00022996', 220, 323), ('Pasta-Driksas gājēju pāreja', '50028646', '180', '2008-12-17', '010895', '2009-02-01', '011196', 301, 324), ('Pasta-Edžus', '29376264', '180', '2008-12-17', '017225', '2009-02-01', '017950', 725, 325), ('Pasta-Stacijas gājēju pāreja', '32778527', '180', '2008-12-17', '036581', '2009-02-01', '037240', 659, 326), ('Stacijas gājēju pāreja', '32778527', '180', '2008-12-17', '036581', '2009-02-01', '037240', 659, 327), ('Uzvaras gājēju pāreja', '29376231', '180', '2008-12-17', '004402', '2009-02-01', '004447', 45, 328), ('Rūpniecības-Mātera', '29292037', '180', '2008-12-17', '018559', '2009-02-01', '019240', 681, 329), ('Rūpniecības-Kalpaka', '29292026', '180', '2008-12-17', '016248', '2009-02-01', '016845', 597, 330), ('Rūpniecības gājēju pāreja', '29292023', '180', '2008-12-17', '003764', '2009-02-01', '003896', 132, 331), ('Tērvetes-Rūpniecības', '32735797', '180', '2008-12-17', '055988', '2009-02-01', '057103', 1115, 332), ('Lietuvas-Mieras', '32647524', '180', '2008-12-17', '046068', '2009-02-01', '046878', 810, 333), ('Rīgas-Brīvības', '32996418', '180', '2008-12-17', '059366', '2009-02-01', '059874', 508, 334), ('Rīga-Garozas', '32996418', '180', '2008-12-17', '059366', '2009-02-01', '059874', 508, 335), ('Rīgas-Izstādes', '29292035', '180', '2008-12-17', '026880', '2009-02-01', '027665', 785, 336), ('Rīgas-Strazdu', '29375625', '180', '2008-12-17', '023833', '2009-02-01', '024553', 720, 337), ('Rīgas-Pērnavas', '29446613', '180', '2008-12-17', '025460', '2009-02-01', '026544', 1084, 338), ('Rīgas-Loka', '29376263', '180', '2008-12-17', '016607', '2009-02-01', '016792', 185, 339), ('Zemgales prospekts', '50121054', '180', '2008-12-17', '001326', '2009-02-01', '001387', 61, 340), ('Meiju ceļš', '50152351', '180', '2008-12-17', '002102', '2009-02-01', '002277', 175, 341), ('Dobeles 4. Līnija', '50156373', '180', '2008-12-17', '001175', '2009-02-01', '001277', 102, 342), ('Keramika', '50161280', '180', '2008-12-17', '000557', '2009-02-01', '000664', 107, 343), ('Tērvetes-Raiņa-Sarmas-Filozofu', '50158093', '180', '2008-12-17', '001795', '2009-02-01', '002006', 211, 344), ('Raiņa Kalpaka', '557538', '180', '2008-12-17', '00000488', '2009-02-01', '00000721', 233, 345), ('Rīgas-Institūta-Lāčplēša', '580689', '180', '2008-12-17', '00000137', '2009-02-01', '00000316', 179, 346), ('Brīvības-Garozas', '568796', '180', '2008-12-17', '00000200', '2009-02-01', '00000351', 151, 347), ('Brīvības-Lāčplēša', '568693', '180', '2008-12-17', '00000088', '2009-02-01', '00000151', 63, 348), ('Dobeles-Satiksmes', '50028987', '180', '2011-03-28', '001931', '2011-04-29', '002079', 148, 349), ('Dobeles-Brieža', '29446699', '180', '2011-03-28', '035970', '2011-04-29', '036087', 117, 350), ('Lielā-Dambja', '50089149', '180', '2011-03-28', '000187', '2011-04-29', '000366', 179, 351), ('Lielā-Pētera', '29376210', '180', '2011-03-28', '008285', '2011-04-29', '008423', 138, 352), ('Lielā-Mātera', '32778874', '180', '2011-03-28', '057273', '2011-04-29', '057910', 637, 353), ('Lielā-Pastas', '50050895', '180', '2011-03-28', '041791', '2011-04-29', '042255', 464, 354), ('Lielā-Katoļus', '50088638', '180', '2011-03-28', '023507', '2011-04-29', '023903', 396, 355), ('Lielā-Akadēmija ', '32687084', '180', '2011-03-28', '039218', '2011-04-29', '039622', 404, 356), ('Lielā-Čakstes', '32469776', '180', '2011-03-28', '062441', '2011-04-29', '063093', 652, 357), ('Mātera-Svētes', '32719941', '180', '2011-03-28', '110570', '2011-04-29', '111889', 1319, 358), ('Raiņa-Mātera', '32719941', '180', '2011-03-28', '110570', '2011-04-29', '111889', 1319, 359), ('Raiņa-Pasta', '29376213', '180', '2011-03-28', '040643', '2011-04-29', '041294', 651, 360), ('Raiņa-Katoļus', '50028590', '180', '2011-03-28', '060780', '2011-04-29', '061346', 566, 361), ('Raiņa-Akadēmijas', '251280', '180', '2011-03-28', '00025876', '2011-04-29', '00025970', 94, 362), ('Pasta-Driksas gājēju pāreja', '50028646', '180', '2011-03-28', '016488', '2011-04-29', '016690', 202, 363), ('Pasta-Edžus', '29376264', '180', '2011-03-28', '031286', '2011-04-29', '031801', 515, 364), ('Pasta-Stacijas gājēju pāreja', '32778527', '180', '2011-03-28', '049174', '2011-04-29', '049652', 478, 365), ('Stacijas gājēju pāreja', '32778527', '180', '2011-03-28', '049174', '2011-04-29', '049652', 478, 366), ('Uzvaras gājēju pāreja', '29376231', '180', '2011-03-28', '005794', '2011-04-29', '005840', 46, 367), ('Rūpniecības-Mātera', '29292037', '180', '2011-03-28', '029404', '2011-04-29', '029820', 416, 368), ('Rūpniecības-Kalpaka', '29292026', '180', '2011-03-28', '028119', '2011-04-29', '028540', 421, 369), ('Rūpniecības gājēju pāreja', '29292023', '180', '2011-03-28', '006891', '2011-04-29', '006988', 97, 370), ('Tērvetes-Rūpniecības', '32735797', '180', '2011-03-28', '077438', '2011-04-29', '078100', 662, 371), ('Lietuvas-Miera', '32647524', '180', '2011-03-28', '061903', '2011-04-29', '062364', 461, 372), ('Rīgas-Brīvības', '32996418', '180', '2011-03-28', '067189', '2011-04-29', '067492', 303, 373), ('Rīga-Garozas', '32996418', '180', '2011-03-28', '067189', '2011-04-29', '067492', 303, 374), ('Rīgas-Izstādes', '32735197', '180', '2011-03-28', '008100', '2011-04-29', '008733', 633, 375), ('Rīgas-Strazdu', '29375625', '180', '2011-03-28', '038983', '2011-04-29', '039518', 535, 376), ('Rīgas-Pērnavas', '29446613', '180', '2011-03-28', '046535', '2011-04-29', '047190', 655, 377), ('Rīgas-Loka', '29376263', '180', '2011-03-28', '020051', '2011-04-29', '020117', 66, 378), ('Zemgales prospekts', '50121054', '180', '2011-03-28', '002628', '2011-04-29', '002672', 44, 379), ('Meiju ceļš', '50152351', '180', '2011-03-28', '005523', '2011-04-29', '005649', 126, 380), ('Dobeles 4. Līnija', '50156373', '180', '2011-03-28', '003645', '2011-04-29', '003793', 148, 381), ('Keramika', '50161280', '180', '2011-03-28', '002674', '2011-04-29', '002753', 79, 382), ('Tērvetes-Raiņa-Sarmas-Filozofu', '50158093', '180', '2011-03-28', '006131', '2011-04-29', '006298', 167, 383), ('Raiņa Kalpaka', '557538', '180', '2011-03-28', '00004232', '2011-04-29', '00004373', 141, 384), ('Rīgas-Institūta-Lāčplēša', '580689', '180', '2011-03-28', '00003715', '2011-04-29', '00003851', 136, 385), ('Brīvības-Garozas', '568796', '180', '2011-03-28', '00003169', '2011-04-29', '00003275', 106, 386), ('Brīvības-Lāčplēša', '568693', '180', '2011-03-28', '00003136', '2011-04-29', '00003330', 194, 387), ('Dobeles Atmodas', '50135314', '180', '2011-03-28', '002318', '2011-04-29', '002454', 136, 388), ('Lielā-Māras', '32414204', '180', '2011-03-28', '003587', '2011-04-29', '003850', 263, 389), ('Lielā IKI', '32414204', '180', '2011-03-28', '003587', '2011-04-29', '003850', 263, 390), ('Rūpniecības Filozofu', '83543477', '180', '2011-03-28', '002191', '2011-04-29', '002500', 309, 391), ('Rūpniecības Dambju Atmodas', '83543477', '180', '2011-03-28', '002191', '2011-04-29', '002500', 309, 392), ('Dobeles - Brieža ielas krust.', '0010498', '180', '2004-08-01', '26675', '2004-07-01', '26267', 408, 511), ('Lielās - Akadēmijas ielas krust.', '32687084', '180', '2004-08-01', '009086', '2004-07-01', '008716', 370, 512), ('Lielā iela - Driksas tilts', '32469776', '180', '2004-08-01', '016897', '2004-07-01', '016441', 456, 513), ('Lielās - Mātera ielas krust.', '32778874', '180', '2004-08-01', '010997', '2004-07-01', '010751', 246, 514), ('Lielās - Pasta ielas krust.', '4547010', '180', '2004-08-01', '1912', '2004-07-01', '1217', 695, 515), ('Lielās - Pētera ielas krust.', '0110081', '180', '2004-08-01', '51621', '2004-07-01', '50878', 743, 516), ('Raiņa - Katoļu ielas krust.', '50028590', '180', '2004-08-01', '006134', '2004-07-01', '005471', 663, 517), ('Raiņa - Pasta ielas krust.', '0097125', '180', '2004-08-01', '45052', '2004-07-01', '44345', 707, 518), ('Raiņa - Akadēmijas ielas krust.', '0010392', '180', '2004-08-01', '35115', '2004-07-01', '34402', 713, 519), ('Rīgas - Strazdu ielas krust.', '23860702', '180', '2004-08-01', '0948', '2004-07-01', '0471', 477, 520), ('Rīgas - Garozas ielas krust.', '32996418', '180', '2004-08-01', '016747', '2004-07-01', '015961', 786, 521), ('Rīgas - Loka maģistr. krust.', '291044', '180', '2004-08-01', '4126', '2004-07-01', '3468', 658, 522), ('Rīgas - Pērnavas ielas krust.', '7950242', '180', '2004-08-01', '44239', '2004-07-01', '43681', 558, 523), ('Tērvetes - Rūpniecības ielas kr.', '0556043', '180', '2004-08-01', '021454', '2004-07-01', '020675', 779, 524), ('Pasta - Sudrabu Edžus ielas kr.', '3639101', '180', '2004-08-01', '1979', '2004-07-01', '1430', 549, 525), ('Pasta – Driksas gājēju pāreja', '50028646', '180', '2004-08-01', '001569', '2004-07-01', '001412', 157, 526), ('Dobeles - Satiksmes ielas krust.', '0096397', '180', '2004-08-01', '48065', '2004-07-01', '47513', 552, 527), ('Stacijas ielas gājēju pāreja', '32778527', '180', '2004-08-01', '012535', '2004-07-01', '012200', 335, 528), ('Uzvaras ielas gājēju pāreja', '3493235', '180', '2004-08-01', '7420', '2004-07-01', '7212', 208, 529), ('Lietuvas šos. - Miera ielas kr. ', '32647524', '180', '2004-08-01', '018208', '2004-07-01', '017720', 488, 530), ('Mātera - Svētes krust. ', '32719941', '180', '2004-08-01', '019406', '2004-07-01', '018441', 965, 531), ('Vaļņu iela 8', '45723523', '180', '2004-08-01', '309703', '2004-07-01', '306566', 3137, 532), ('Bērnudārzs Vaļņu iela 6', '62553772', '180', '2004-08-01', '0286700', '2004-07-01', '0283700', 3000, 533), ('Dobeles – Satiksmes ', '29446616', '180', '2006-10-01', '005408', '2006-11-01', '006033', 625, 534), ('Dobeles – Brieža ', '29446699', '180', '2006-10-01', '005336', '2006-11-01', '005947', 611, 535), ('Lielās – Dambja iela', '29376219', '180', '2006-10-01', '005808', '2006-11-01', '005904', 96, 536), ('Lielās - Pētera ielas', '29376210', '180', '2006-10-01', '000949', '2006-11-01', '001061', 112, 537), ('Lielās - Mātera ielas krust.', '32778874', '180', '2006-10-01', '024974', '2006-11-01', '025492', 518, 538), ('Lielās - Pasta ielas krust.', '50050895', '180', '2006-10-01', '012912', '2006-11-01', '013409', 497, 539), ('Lielās – Katoļu ielas krust.', '50088638', '180', '2006-10-01', '005424', '2006-11-01', '005675', 251, 540), ('Lielās – Akadēmijas ielas krust.', '32687084', '180', '2006-10-01', '018772', '2006-11-01', '019139', 367, 541), ('Lielā iela - Čakstes bulv.', '32469776', '180', '2006-10-01', '029697', '2006-11-01', '030138', 441, 542), ('Mātera -Svētes krustojums ', '32719941', '180', '2006-10-01', '042785', '2006-11-01', '043675', 890, 543), ('Raiņa-Mātera krustojums', '32719941', '180', '2006-10-01', '042785', '2006-11-01', '043675', 890, 544), ('Raiņa - Pasta ielas krustojums', '29376213', '180', '2006-10-01', '005363', '2006-11-01', '006008', 645, 545), ('Raiņa - Katoļu ielas krustojums', '50028590', '180', '2006-10-01', '023733', '2006-11-01', '024392', 659, 546), ('Raiņa – Akadēmijas ielas krust.', '251280', '180', '2006-10-01', '00008449', '2006-11-01', '00009073', 624, 547), ('Pasta – Driksas gājēju pāreja', '50028646', '180', '2006-10-01', '005911', '2006-11-01', '006088', 177, 548), ('Pasta - Sudrabu Edžus ielas kr.', '29376264', '180', '2006-10-01', '004060', '2006-11-01', '004507', 447, 549), ('Pasta – Stacijas gājēju pāreja', '32778527', '180', '2006-10-01', '022986', '2006-11-01', '023516', 530, 550), ('Stacijas ielas gājēju pāreja', '32778527', '180', '2006-10-01', '022986', '2006-11-01', '023516', 530, 551), ('Uzvaras ielas gājēju pāreja', '29376231', '180', '2006-10-01', '001952', '2006-11-01', '002222', 270, 552), ('Rūpniecības Mātera ielu krust.', '184611011', '180', '2006-10-01', '005864', '2006-11-01', '006352', 488, 553), ('Rūpniecības Kalpaka ielu kr.', '29292026', '180', '2006-10-01', '004771', '2006-11-01', '005194', 423, 554), ('Rūpniecības ielas gājēju pāreja', '29292023', '180', '2006-10-01', '001012', '2006-11-01', '001105', 93, 555), ('Tērvetes – Rūpniecības ielas kr.', '32735797', '180', '2006-10-01', '038117', '2006-11-01', '038691', 574, 556), ('Lietuvas šos. – Miera ielas kr. ', '32647524', '180', '2006-10-01', '030297', '2006-11-01', '030874', 577, 557), ('Rīgas – Brīvības bulv. Kr.', '32996418', '180', '2006-10-01', '037597', '2006-11-01', '038421', 824, 558), ('Rīga - Garozas ielas krust.', '32996418', '180', '2006-10-01', '037597', '2006-11-01', '038421', 824, 559), ('Rīgas – Izstādes', '29292035', '180', '2006-10-01', '009282', '2006-11-01', '009968', 686, 560), ('Rīgas – Strazdu ', '29375625', '180', '2006-10-01', '007021', '2006-11-01', '007536', 515, 561), ('Rīgas – Pērnavas', '29446613', '180', '2006-10-01', '005629', '2006-11-01', '006332', 703, 562), ('Rīgas – Loka maģistr. ', '29376263', '180', '2006-10-01', '004187', '2006-11-01', '004717', 530, 563), ('Zemgales prospekts', '50121054', '180', '2006-10-01', '000046', '2006-11-01', '000090', 44, 564), ('Dobeles-Satiksmes', '29446616', '180', '2008-12-17', '020258', '2009-02-01', '020697', 439, 565), ('Dobeles-Brieža', '29446699', '180', '2008-12-17', '022121', '2009-02-01', '022981', 860, 566), ('Lielās-Dambja', '29376219', '180', '2008-12-17', '009780', '2009-02-01', '010042', 262, 567), ('Lielās-Pēteras', '29376210', '180', '2008-12-17', '004397', '2009-02-01', '004600', 203, 568), ('Lielās-Māteras', '32778874', '180', '2008-12-17', '040093', '2009-02-01', '040926', 833, 569), ('Lielās-Pastas', '50050895', '180', '2008-12-17', '026703', '2009-02-01', '027444', 741, 570), ('Lielās-Katoļus', '50088638', '180', '2008-12-17', '013775', '2009-02-01', '014240', 465, 571), ('Lielās-Akadēmija ', '32687084', '180', '2008-12-17', '028696', '2009-02-01', '029208', 512, 572), ('Lielā-Čakstes', '32469776', '180', '2008-12-17', '044575', '2009-02-01', '045437', 862, 573), ('Mātera-Svētes', '32719941', '180', '2008-12-17', '073643', '2009-02-01', '075461', 1818, 574), ('Raiņa-Mātera', '32719941', '180', '2008-12-17', '073643', '2009-02-01', '075461', 1818, 575), ('Raiņa-Pasta', '29376213', '180', '2008-12-17', '022926', '2009-02-01', '023849', 923, 576), ('Raiņa-Katoļus', '50028590', '180', '2008-12-17', '042116', '2009-02-01', '043095', 979, 577), ('Raiņa-Akadēmijas', '251280', '180', '2008-12-17', '00022776', '2009-02-01', '00022996', 220, 578), ('Pasta-Driksas gājēju pāreja', '50028646', '180', '2008-12-17', '010895', '2009-02-01', '011196', 301, 579), ('Pasta-Edžus', '29376264', '180', '2008-12-17', '017225', '2009-02-01', '017950', 725, 580), ('Pasta-Stacijas gājēju pāreja', '32778527', '180', '2008-12-17', '036581', '2009-02-01', '037240', 659, 581), ('Stacijas gājēju pāreja', '32778527', '180', '2008-12-17', '036581', '2009-02-01', '037240', 659, 582), ('Uzvaras gājēju pāreja', '29376231', '180', '2008-12-17', '004402', '2009-02-01', '004447', 45, 583), ('Rūpniecības-Mātera', '29292037', '180', '2008-12-17', '018559', '2009-02-01', '019240', 681, 584), ('Rūpniecības-Kalpaka', '29292026', '180', '2008-12-17', '016248', '2009-02-01', '016845', 597, 585), ('Rūpniecības gājēju pāreja', '29292023', '180', '2008-12-17', '003764', '2009-02-01', '003896', 132, 586), ('Tērvetes-Rūpniecības', '32735797', '180', '2008-12-17', '055988', '2009-02-01', '057103', 1115, 587), ('Lietuvas-Mieras', '32647524', '180', '2008-12-17', '046068', '2009-02-01', '046878', 810, 588), ('Rīgas-Brīvības', '32996418', '180', '2008-12-17', '059366', '2009-02-01', '059874', 508, 589), ('Rīga-Garozas', '32996418', '180', '2008-12-17', '059366', '2009-02-01', '059874', 508, 590), ('Rīgas-Izstādes', '29292035', '180', '2008-12-17', '026880', '2009-02-01', '027665', 785, 591), ('Rīgas-Strazdu', '29375625', '180', '2008-12-17', '023833', '2009-02-01', '024553', 720, 592), ('Rīgas-Pērnavas', '29446613', '180', '2008-12-17', '025460', '2009-02-01', '026544', 1084, 593), ('Rīgas-Loka', '29376263', '180', '2008-12-17', '016607', '2009-02-01', '016792', 185, 594), ('Zemgales prospekts', '50121054', '180', '2008-12-17', '001326', '2009-02-01', '001387', 61, 595), ('Meiju ceļš', '50152351', '180', '2008-12-17', '002102', '2009-02-01', '002277', 175, 596), ('Dobeles 4. Līnija', '50156373', '180', '2008-12-17', '001175', '2009-02-01', '001277', 102, 597), ('Keramika', '50161280', '180', '2008-12-17', '000557', '2009-02-01', '000664', 107, 598), ('Tērvetes-Raiņa-Sarmas-Filozofu', '50158093', '180', '2008-12-17', '001795', '2009-02-01', '002006', 211, 599), ('Raiņa Kalpaka', '557538', '180', '2008-12-17', '00000488', '2009-02-01', '00000721', 233, 600), ('Rīgas-Institūta-Lāčplēša', '580689', '180', '2008-12-17', '00000137', '2009-02-01', '00000316', 179, 601), ('Brīvības-Garozas', '568796', '180', '2008-12-17', '00000200', '2009-02-01', '00000351', 151, 602), ('Brīvības-Lāčplēša', '568693', '180', '2008-12-17', '00000088', '2009-02-01', '00000151', 63, 603), ('Dobeles-Satiksmes', '50028987', '180', '2011-03-28', '001931', '2011-04-29', '002079', 148, 604), ('Dobeles-Brieža', '29446699', '180', '2011-03-28', '035970', '2011-04-29', '036087', 117, 605), ('Lielā-Dambja', '50089149', '180', '2011-03-28', '000187', '2011-04-29', '000366', 179, 606), ('Lielā-Pētera', '29376210', '180', '2011-03-28', '008285', '2011-04-29', '008423', 138, 607), ('Lielā-Mātera', '32778874', '180', '2011-03-28', '057273', '2011-04-29', '057910', 637, 608), ('Lielā-Pastas', '50050895', '180', '2011-03-28', '041791', '2011-04-29', '042255', 464, 609), ('Lielā-Katoļus', '50088638', '180', '2011-03-28', '023507', '2011-04-29', '023903', 396, 610), ('Lielā-Akadēmija ', '32687084', '180', '2011-03-28', '039218', '2011-04-29', '039622', 404, 611), ('Lielā-Čakstes', '32469776', '180', '2011-03-28', '062441', '2011-04-29', '063093', 652, 612), ('Mātera-Svētes', '32719941', '180', '2011-03-28', '110570', '2011-04-29', '111889', 1319, 613), ('Raiņa-Mātera', '32719941', '180', '2011-03-28', '110570', '2011-04-29', '111889', 1319, 614), ('Raiņa-Pasta', '29376213', '180', '2011-03-28', '040643', '2011-04-29', '041294', 651, 615), ('Raiņa-Katoļus', '50028590', '180', '2011-03-28', '060780', '2011-04-29', '061346', 566, 616), ('Raiņa-Akadēmijas', '251280', '180', '2011-03-28', '00025876', '2011-04-29', '00025970', 94, 617), ('Pasta-Driksas gājēju pāreja', '50028646', '180', '2011-03-28', '016488', '2011-04-29', '016690', 202, 618), ('Pasta-Edžus', '29376264', '180', '2011-03-28', '031286', '2011-04-29', '031801', 515, 619), ('Pasta-Stacijas gājēju pāreja', '32778527', '180', '2011-03-28', '049174', '2011-04-29', '049652', 478, 620), ('Stacijas gājēju pāreja', '32778527', '180', '2011-03-28', '049174', '2011-04-29', '049652', 478, 621), ('Uzvaras gājēju pāreja', '29376231', '180', '2011-03-28', '005794', '2011-04-29', '005840', 46, 622), ('Rūpniecības-Mātera', '29292037', '180', '2011-03-28', '029404', '2011-04-29', '029820', 416, 623), ('Rūpniecības-Kalpaka', '29292026', '180', '2011-03-28', '028119', '2011-04-29', '028540', 421, 624), ('Rūpniecības gājēju pāreja', '29292023', '180', '2011-03-28', '006891', '2011-04-29', '006988', 97, 625), ('Tērvetes-Rūpniecības', '32735797', '180', '2011-03-28', '077438', '2011-04-29', '078100', 662, 626), ('Lietuvas-Miera', '32647524', '180', '2011-03-28', '061903', '2011-04-29', '062364', 461, 627), ('Rīgas-Brīvības', '32996418', '180', '2011-03-28', '067189', '2011-04-29', '067492', 303, 628), ('Rīga-Garozas', '32996418', '180', '2011-03-28', '067189', '2011-04-29', '067492', 303, 629), ('Rīgas-Izstādes', '32735197', '180', '2011-03-28', '008100', '2011-04-29', '008733', 633, 630), ('Rīgas-Strazdu', '29375625', '180', '2011-03-28', '038983', '2011-04-29', '039518', 535, 631), ('Rīgas-Pērnavas', '29446613', '180', '2011-03-28', '046535', '2011-04-29', '047190', 655, 632), ('Rīgas-Loka', '29376263', '180', '2011-03-28', '020051', '2011-04-29', '020117', 66, 633), ('Zemgales prospekts', '50121054', '180', '2011-03-28', '002628', '2011-04-29', '002672', 44, 634), ('Meiju ceļš', '50152351', '180', '2011-03-28', '005523', '2011-04-29', '005649', 126, 635), ('Dobeles 4. Līnija', '50156373', '180', '2011-03-28', '003645', '2011-04-29', '003793', 148, 636), ('Keramika', '50161280', '180', '2011-03-28', '002674', '2011-04-29', '002753', 79, 637), ('Tērvetes-Raiņa-Sarmas-Filozofu', '50158093', '180', '2011-03-28', '006131', '2011-04-29', '006298', 167, 638), ('Raiņa Kalpaka', '557538', '180', '2011-03-28', '00004232', '2011-04-29', '00004373', 141, 639), ('Rīgas-Institūta-Lāčplēša', '580689', '180', '2011-03-28', '00003715', '2011-04-29', '00003851', 136, 640), ('Brīvības-Garozas', '568796', '180', '2011-03-28', '00003169', '2011-04-29', '00003275', 106, 641), ('Brīvības-Lāčplēša', '568693', '180', '2011-03-28', '00003136', '2011-04-29', '00003330', 194, 642), ('Dobeles Atmodas', '50135314', '180', '2011-03-28', '002318', '2011-04-29', '002454', 136, 643), ('Lielā-Māras', '32414204', '180', '2011-03-28', '003587', '2011-04-29', '003850', 263, 644), ('Lielā IKI', '32414204', '180', '2011-03-28', '003587', '2011-04-29', '003850', 263, 645), ('Rūpniecības Filozofu', '83543477', '180', '2011-03-28', '002191', '2011-04-29', '002500', 309, 646), ('Rūpniecības Dambju Atmodas', '83543477', '180', '2011-03-28', '002191', '2011-04-29', '002500', 309, 647); /*!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) */;