-- --------------------------------------------------------
-- 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 database structure for lauris_e
CREATE DATABASE IF NOT EXISTS `lauris_e` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `lauris_e`;

-- Dumping structure for table lauris_e.address_index
CREATE TABLE IF NOT EXISTS `address_index` (
  `id` int(10) unsigned NOT NULL COMMENT 'Adreses indeksa ID',
  `number` smallint(5) unsigned NOT NULL COMMENT 'Adreses indekss',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Adreses indeksi';

-- Dumping data for table lauris_e.address_index: ~694 rows (approximately)
INSERT INTO `address_index` (`id`, `number`) VALUES
	(1, 1001),
	(2, 1002),
	(3, 1003),
	(4, 1004),
	(5, 1005),
	(6, 1006),
	(7, 1007),
	(8, 1009),
	(9, 1010),
	(10, 1011),
	(11, 1012),
	(12, 1013),
	(13, 1014),
	(14, 1015),
	(15, 1016),
	(16, 1019),
	(17, 1021),
	(18, 1023),
	(19, 1024),
	(20, 1026),
	(21, 1029),
	(22, 1030),
	(23, 1034),
	(24, 1035),
	(25, 1038),
	(26, 1039),
	(27, 1044),
	(28, 1045),
	(29, 1046),
	(30, 1048),
	(31, 1050),
	(32, 1053),
	(33, 1055),
	(34, 1057),
	(35, 1058),
	(36, 1063),
	(37, 1064),
	(38, 1067),
	(39, 1069),
	(40, 1073),
	(41, 1076),
	(42, 1079),
	(43, 1082),
	(44, 1083),
	(45, 1084),
	(46, 2008),
	(47, 2010),
	(48, 2011),
	(49, 2012),
	(50, 2015),
	(51, 2016),
	(52, 2101),
	(53, 2103),
	(54, 2105),
	(55, 2107),
	(56, 2108),
	(57, 2111),
	(58, 2112),
	(59, 2113),
	(60, 2114),
	(61, 2117),
	(62, 2118),
	(63, 2119),
	(64, 2121),
	(65, 2123),
	(66, 2124),
	(67, 2125),
	(68, 2127),
	(69, 2128),
	(70, 2130),
	(71, 2133),
	(72, 2135),
	(73, 2136),
	(74, 2137),
	(75, 2140),
	(76, 2141),
	(77, 2142),
	(78, 2144),
	(79, 2145),
	(80, 2150),
	(81, 2151),
	(82, 2152),
	(83, 2154),
	(84, 2160),
	(85, 2161),
	(86, 2162),
	(87, 2163),
	(88, 2164),
	(89, 2166),
	(90, 2167),
	(91, 2169),
	(92, 2170),
	(93, 3001),
	(94, 3002),
	(95, 3003),
	(96, 3004),
	(97, 3007),
	(98, 3008),
	(99, 3011),
	(100, 3014),
	(101, 3016),
	(102, 3017),
	(103, 3018),
	(104, 3020),
	(105, 3021),
	(106, 3022),
	(107, 3023),
	(108, 3026),
	(109, 3028),
	(110, 3031),
	(111, 3034),
	(112, 3036),
	(113, 3037),
	(114, 3040),
	(115, 3042),
	(116, 3043),
	(117, 3045),
	(118, 3101),
	(119, 3104),
	(120, 3110),
	(121, 3113),
	(122, 3118),
	(123, 3119),
	(124, 3120),
	(125, 3122),
	(126, 3123),
	(127, 3124),
	(128, 3128),
	(129, 3129),
	(130, 3131),
	(131, 3132),
	(132, 3133),
	(133, 3134),
	(134, 3135),
	(135, 3137),
	(136, 3139),
	(137, 3140),
	(138, 3142),
	(139, 3145),
	(140, 3146),
	(141, 3147),
	(142, 3148),
	(143, 3201),
	(144, 3251),
	(145, 3253),
	(146, 3257),
	(147, 3258),
	(148, 3260),
	(149, 3261),
	(150, 3262),
	(151, 3264),
	(152, 3270),
	(153, 3275),
	(154, 3280),
	(155, 3281),
	(156, 3283),
	(157, 3284),
	(158, 3285),
	(159, 3287),
	(160, 3291),
	(161, 3292),
	(162, 3294),
	(163, 3297),
	(164, 3298),
	(165, 3301),
	(166, 3306),
	(167, 3307),
	(168, 3309),
	(169, 3310),
	(170, 3312),
	(171, 3313),
	(172, 3314),
	(173, 3317),
	(174, 3319),
	(175, 3320),
	(176, 3321),
	(177, 3322),
	(178, 3323),
	(179, 3324),
	(180, 3325),
	(181, 3326),
	(182, 3328),
	(183, 3329),
	(184, 3330),
	(185, 3332),
	(186, 3333),
	(187, 3401),
	(188, 3402),
	(189, 3405),
	(190, 3407),
	(191, 3411),
	(192, 3414),
	(193, 3416),
	(194, 3430),
	(195, 3431),
	(196, 3433),
	(197, 3434),
	(198, 3435),
	(199, 3436),
	(200, 3438),
	(201, 3440),
	(202, 3441),
	(203, 3442),
	(204, 3443),
	(205, 3444),
	(206, 3445),
	(207, 3446),
	(208, 3447),
	(209, 3452),
	(210, 3453),
	(211, 3455),
	(212, 3456),
	(213, 3457),
	(214, 3461),
	(215, 3463),
	(216, 3466),
	(217, 3473),
	(218, 3474),
	(219, 3475),
	(220, 3476),
	(221, 3477),
	(222, 3480),
	(223, 3482),
	(224, 3484),
	(225, 3485),
	(226, 3486),
	(227, 3487),
	(228, 3601),
	(229, 3602),
	(230, 3604),
	(231, 3612),
	(232, 3613),
	(233, 3614),
	(234, 3615),
	(235, 3617),
	(236, 3619),
	(237, 3620),
	(238, 3621),
	(239, 3623),
	(240, 3624),
	(241, 3626),
	(242, 3627),
	(243, 3701),
	(244, 3708),
	(245, 3709),
	(246, 3710),
	(247, 3711),
	(248, 3713),
	(249, 3714),
	(250, 3716),
	(251, 3717),
	(252, 3718),
	(253, 3719),
	(254, 3721),
	(255, 3722),
	(256, 3723),
	(257, 3724),
	(258, 3725),
	(259, 3729),
	(260, 3730),
	(261, 3731),
	(262, 3732),
	(263, 3801),
	(264, 3851),
	(265, 3852),
	(266, 3853),
	(267, 3861),
	(268, 3862),
	(269, 3871),
	(270, 3873),
	(271, 3875),
	(272, 3876),
	(273, 3880),
	(274, 3882),
	(275, 3883),
	(276, 3890),
	(277, 3891),
	(278, 3892),
	(279, 3893),
	(280, 3894),
	(281, 3895),
	(282, 3896),
	(283, 3897),
	(284, 3898),
	(285, 3899),
	(286, 3901),
	(287, 3905),
	(288, 3906),
	(289, 3907),
	(290, 3908),
	(291, 3910),
	(292, 3913),
	(293, 3914),
	(294, 3915),
	(295, 3917),
	(296, 3918),
	(297, 3921),
	(298, 3924),
	(299, 3925),
	(300, 3926),
	(301, 3927),
	(302, 3929),
	(303, 3930),
	(304, 3931),
	(305, 3932),
	(306, 3933),
	(307, 3936),
	(308, 4001),
	(309, 4004),
	(310, 4010),
	(311, 4011),
	(312, 4012),
	(313, 4013),
	(314, 4020),
	(315, 4022),
	(316, 4023),
	(317, 4025),
	(318, 4033),
	(319, 4035),
	(320, 4043),
	(321, 4050),
	(322, 4052),
	(323, 4054),
	(324, 4061),
	(325, 4063),
	(326, 4064),
	(327, 4068),
	(328, 4101),
	(329, 4108),
	(330, 4110),
	(331, 4112),
	(332, 4113),
	(333, 4116),
	(334, 4118),
	(335, 4119),
	(336, 4122),
	(337, 4123),
	(338, 4125),
	(339, 4126),
	(340, 4128),
	(341, 4129),
	(342, 4131),
	(343, 4132),
	(344, 4133),
	(345, 4136),
	(346, 4139),
	(347, 4141),
	(348, 4143),
	(349, 4144),
	(350, 4146),
	(351, 4151),
	(352, 4152),
	(353, 4154),
	(354, 4201),
	(355, 4206),
	(356, 4208),
	(357, 4210),
	(358, 4211),
	(359, 4213),
	(360, 4215),
	(361, 4216),
	(362, 4219),
	(363, 4220),
	(364, 4222),
	(365, 4223),
	(366, 4224),
	(367, 4227),
	(368, 4228),
	(369, 4232),
	(370, 4234),
	(371, 4240),
	(372, 4241),
	(373, 4242),
	(374, 4244),
	(375, 4245),
	(376, 4247),
	(377, 4248),
	(378, 4301),
	(379, 4332),
	(380, 4333),
	(381, 4335),
	(382, 4336),
	(383, 4337),
	(384, 4339),
	(385, 4340),
	(386, 4341),
	(387, 4342),
	(388, 4344),
	(389, 4345),
	(390, 4348),
	(391, 4350),
	(392, 4351),
	(393, 4352),
	(394, 4354),
	(395, 4355),
	(396, 4358),
	(397, 4359),
	(398, 4401),
	(399, 4405),
	(400, 4406),
	(401, 4409),
	(402, 4410),
	(403, 4412),
	(404, 4415),
	(405, 4416),
	(406, 4417),
	(407, 4420),
	(408, 4421),
	(409, 4424),
	(410, 4425),
	(411, 4426),
	(412, 4428),
	(413, 4429),
	(414, 4501),
	(415, 4561),
	(416, 4562),
	(417, 4566),
	(418, 4567),
	(419, 4570),
	(420, 4571),
	(421, 4572),
	(422, 4573),
	(423, 4574),
	(424, 4576),
	(425, 4577),
	(426, 4580),
	(427, 4582),
	(428, 4583),
	(429, 4584),
	(430, 4585),
	(431, 4586),
	(432, 4587),
	(433, 4590),
	(434, 4591),
	(435, 4592),
	(436, 4594),
	(437, 4595),
	(438, 4601),
	(439, 4604),
	(440, 4611),
	(441, 4612),
	(442, 4614),
	(443, 4615),
	(444, 4616),
	(445, 4617),
	(446, 4618),
	(447, 4619),
	(448, 4621),
	(449, 4622),
	(450, 4623),
	(451, 4625),
	(452, 4626),
	(453, 4627),
	(454, 4628),
	(455, 4630),
	(456, 4631),
	(457, 4633),
	(458, 4634),
	(459, 4635),
	(460, 4636),
	(461, 4638),
	(462, 4640),
	(463, 4641),
	(464, 4642),
	(465, 4643),
	(466, 4645),
	(467, 4647),
	(468, 4648),
	(469, 4649),
	(470, 4650),
	(471, 4652),
	(472, 4701),
	(473, 4706),
	(474, 4707),
	(475, 4708),
	(476, 4711),
	(477, 4712),
	(478, 4713),
	(479, 4715),
	(480, 4716),
	(481, 4718),
	(482, 4723),
	(483, 4724),
	(484, 4726),
	(485, 4727),
	(486, 4728),
	(487, 4729),
	(488, 4730),
	(489, 4731),
	(490, 4733),
	(491, 4735),
	(492, 4801),
	(493, 4824),
	(494, 4825),
	(495, 4826),
	(496, 4830),
	(497, 4833),
	(498, 4834),
	(499, 4835),
	(500, 4836),
	(501, 4837),
	(502, 4838),
	(503, 4840),
	(504, 4841),
	(505, 4844),
	(506, 4846),
	(507, 4847),
	(508, 4852),
	(509, 4853),
	(510, 4855),
	(511, 4860),
	(512, 4862),
	(513, 4863),
	(514, 4865),
	(515, 4870),
	(516, 4871),
	(517, 4873),
	(518, 4880),
	(519, 4884),
	(520, 5001),
	(521, 5011),
	(522, 5012),
	(523, 5015),
	(524, 5016),
	(525, 5020),
	(526, 5022),
	(527, 5033),
	(528, 5041),
	(529, 5044),
	(530, 5045),
	(531, 5047),
	(532, 5052),
	(533, 5060),
	(534, 5062),
	(535, 5064),
	(536, 5065),
	(537, 5070),
	(538, 5071),
	(539, 5101),
	(540, 5106),
	(541, 5108),
	(542, 5109),
	(543, 5110),
	(544, 5111),
	(545, 5112),
	(546, 5113),
	(547, 5115),
	(548, 5118),
	(549, 5120),
	(550, 5123),
	(551, 5124),
	(552, 5125),
	(553, 5128),
	(554, 5129),
	(555, 5130),
	(556, 5133),
	(557, 5134),
	(558, 5135),
	(559, 5201),
	(560, 5202),
	(561, 5204),
	(562, 5208),
	(563, 5209),
	(564, 5210),
	(565, 5211),
	(566, 5212),
	(567, 5214),
	(568, 5215),
	(569, 5216),
	(570, 5217),
	(571, 5218),
	(572, 5220),
	(573, 5221),
	(574, 5222),
	(575, 5223),
	(576, 5224),
	(577, 5226),
	(578, 5228),
	(579, 5229),
	(580, 5230),
	(581, 5232),
	(582, 5236),
	(583, 5237),
	(584, 5238),
	(585, 5239),
	(586, 5301),
	(587, 5304),
	(588, 5305),
	(589, 5311),
	(590, 5312),
	(591, 5315),
	(592, 5316),
	(593, 5318),
	(594, 5320),
	(595, 5323),
	(596, 5325),
	(597, 5326),
	(598, 5327),
	(599, 5328),
	(600, 5329),
	(601, 5330),
	(602, 5331),
	(603, 5333),
	(604, 5334),
	(605, 5335),
	(606, 5337),
	(607, 5401),
	(608, 5404),
	(609, 5410),
	(610, 5412),
	(611, 5413),
	(612, 5414),
	(613, 5415),
	(614, 5417),
	(615, 5418),
	(616, 5422),
	(617, 5438),
	(618, 5439),
	(619, 5440),
	(620, 5441),
	(621, 5442),
	(622, 5443),
	(623, 5444),
	(624, 5447),
	(625, 5449),
	(626, 5450),
	(627, 5451),
	(628, 5456),
	(629, 5458),
	(630, 5459),
	(631, 5460),
	(632, 5461),
	(633, 5462),
	(634, 5463),
	(635, 5465),
	(636, 5469),
	(637, 5470),
	(638, 5471),
	(639, 5473),
	(640, 5474),
	(641, 5477),
	(642, 5481),
	(643, 5601),
	(644, 5651),
	(645, 5652),
	(646, 5653),
	(647, 5655),
	(648, 5656),
	(649, 5660),
	(650, 5662),
	(651, 5664),
	(652, 5666),
	(653, 5668),
	(654, 5671),
	(655, 5674),
	(656, 5676),
	(657, 5677),
	(658, 5680),
	(659, 5681),
	(660, 5685),
	(661, 5687),
	(662, 5692),
	(663, 5695),
	(664, 5696),
	(665, 5697),
	(666, 5698),
	(667, 5701),
	(668, 5704),
	(669, 5705),
	(670, 5706),
	(671, 5707),
	(672, 5709),
	(673, 5711),
	(674, 5716),
	(675, 5717),
	(676, 5719),
	(677, 5722),
	(678, 5725),
	(679, 5726),
	(680, 5729),
	(681, 5730),
	(682, 5732),
	(683, 5733),
	(684, 5735),
	(685, 5736),
	(686, 5737),
	(687, 5739),
	(688, 5740),
	(689, 5742),
	(690, 5745),
	(691, 5748),
	(692, 5750),
	(693, 5751),
	(694, 5752);

-- Dumping structure for table lauris_e.address_level
CREATE TABLE IF NOT EXISTS `address_level` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Adreses līmeņa ID',
  `name` varchar(10) NOT NULL COMMENT 'Adreses līmenis',
  `fname` varchar(50) DEFAULT '' COMMENT 'Adreses līmeņa pilnais nosaukums',
  `sname` varchar(5) DEFAULT '' COMMENT 'Adreses līmeņa īsais nosaukums',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Adreses līmenis';

-- Dumping data for table lauris_e.address_level: ~9 rows (approximately)
INSERT INTO `address_level` (`id`, `name`, `fname`, `sname`) VALUES
	(1, 'Valsts', 'Valsts', ''),
	(2, 'Novads', 'Novads', 'nov.'),
	(3, 'Valsts pil', 'Valsts pilsēta', ''),
	(4, 'Pilsēta', 'Pilsēta', ''),
	(5, 'Pagasts', 'Pagasts', 'pag.'),
	(6, 'Ciems/mazc', 'Ciems/mazciems', ''),
	(7, 'Iela', 'Iela', ''),
	(8, 'Ēkas nr./N', 'Ēkas nr./Nosaukums, korpuss', ''),
	(9, 'Telpu grup', 'Telpu grupa (dzīvoklis)', '');

-- Dumping structure for table lauris_e.address_name
CREATE TABLE IF NOT EXISTS `address_name` (
  `id_address_name` int(10) unsigned NOT NULL COMMENT 'Piesaistītās adreses ID',
  `id` int(10) unsigned NOT NULL COMMENT 'Adreses ID',
  `name` varchar(20) NOT NULL COMMENT 'Nosaukums',
  `id_address_level` int(10) unsigned NOT NULL COMMENT 'Adreses līmeņa ID',
  `id_address_index` int(10) unsigned DEFAULT 0 COMMENT 'Pasta indeksa ID',
  PRIMARY KEY (`id`),
  KEY `id_level` (`id_address_level`,`id_address_name`) USING BTREE,
  KEY `FK_address_name_address_name` (`id_address_name`),
  KEY `FK_address_name_address_index` (`id_address_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Adreses';

-- Dumping data for table lauris_e.address_name: ~103 rows (approximately)
INSERT INTO `address_name` (`id_address_name`, `id`, `name`, `id_address_level`, `id_address_index`) VALUES
	(100000000, 100000000, 'Latvija', 1, 0),
	(100016575, 100010548, 'Bārbeles pag.', 5, 0),
	(100000000, 100016575, 'Bauskas nov.', 2, 0),
	(100010548, 101105846, 'Cedelmaņi', 8, 286),
	(100010548, 101112868, 'Alenderkrogs', 8, 286),
	(100010548, 101113074, 'Andriņi', 8, 286),
	(100010548, 103742443, 'Jaunstepiņi', 8, 286),
	(100010548, 104432020, 'Bārbeles', 8, 286),
	(100010548, 104432045, 'Alņi', 8, 286),
	(100010548, 104432053, 'Andersoni', 8, 286),
	(100010548, 104432078, 'Āres', 8, 286),
	(100010548, 104432086, 'Austrumi', 8, 286),
	(100010548, 104432100, 'Avotkrogs', 8, 286),
	(100010548, 104432117, 'Baltrumi', 8, 286),
	(100010548, 104432141, 'Bārbeles pamatskola', 8, 286),
	(100010548, 104432158, 'Bauzas', 8, 286),
	(100010548, 104432182, 'Bērznieki', 8, 286),
	(100010548, 104432221, 'Bračkas', 8, 286),
	(100010548, 104432238, 'Bramaņi', 8, 286),
	(100010548, 104432254, 'Brīvnieki', 8, 286),
	(100010548, 104432262, 'Brusas', 8, 286),
	(100010548, 104432301, 'Čiekuri', 8, 286),
	(100010548, 104432318, 'Čūderi', 8, 286),
	(100010548, 104432350, 'Dravenieki', 8, 286),
	(100010548, 104432367, 'Dreijeri', 8, 286),
	(100010548, 104432406, 'Dzērvēni', 8, 286),
	(100010548, 104432447, 'Eglaines', 8, 286),
	(100010548, 104432463, 'Eglītes', 8, 286),
	(100010548, 104432471, 'Ērgļi', 8, 286),
	(100010548, 104432488, 'Erliķi', 8, 286),
	(100010548, 104432496, 'Everti', 8, 286),
	(100010548, 104432502, 'Ezera Salmiņi', 8, 286),
	(100010548, 104432527, 'Ezernieki', 8, 286),
	(100010548, 104432535, 'Ēzītes', 8, 286),
	(100010548, 104432551, 'Gaidas', 8, 286),
	(100010548, 104433047, 'Garbari', 8, 286),
	(100010548, 104433071, 'Gaujas', 8, 286),
	(100010548, 104433096, 'Gedroviči', 8, 286),
	(100010548, 104433127, 'Glīzdiņi', 8, 286),
	(100010548, 104433151, 'Gobas', 8, 286),
	(100010548, 104433192, 'Grantskalni', 8, 286),
	(100010548, 104433223, 'Grāvīši', 8, 286),
	(100010548, 104433280, 'Grīnbergi', 8, 286),
	(100010548, 104433311, 'Ģeķi', 8, 286),
	(100010548, 104433328, 'Ģērķi', 8, 286),
	(100010548, 104433344, 'Ilgas', 8, 286),
	(100010548, 104433360, 'Ilmiņas', 8, 286),
	(100010548, 104433377, 'Dīķīši', 8, 286),
	(100010548, 104433385, 'Indrāni', 8, 286),
	(100010548, 104433393, 'Jāņkalni', 8, 286),
	(100010548, 104433416, 'Jaunindrāni', 8, 286),
	(100010548, 104433481, 'Jēkapiņi', 8, 286),
	(100010548, 104433504, 'Jobi', 8, 286),
	(100010548, 104433537, 'Jostkalēji', 8, 286),
	(100010548, 104433545, 'Jukatas', 8, 286),
	(100010548, 104433561, 'Jukši', 8, 286),
	(100010548, 104433600, 'Jūrnieki', 8, 286),
	(100010548, 104433625, 'Juši', 8, 286),
	(100010548, 104433746, 'Kalnrūpnieki', 8, 286),
	(100010548, 104434008, 'Kalnieši', 8, 286),
	(100010548, 104434032, 'Kalnzemnieki', 8, 286),
	(100010548, 104434057, 'Kauķi', 8, 286),
	(100010548, 104434073, 'Klāvi', 8, 286),
	(100010548, 104434120, 'Kociņi', 8, 286),
	(100010548, 104434153, 'Kramkalniņi', 8, 286),
	(100010548, 104434178, 'Kraukļi', 8, 286),
	(100010548, 104434186, 'Krieviņi', 8, 286),
	(100010548, 104434522, 'Ķirveļi', 8, 286),
	(100010548, 104434530, 'Ķīseļi', 8, 286),
	(100010548, 104434555, 'Lācīši', 8, 286),
	(100010548, 104434563, 'Langas', 8, 286),
	(100010548, 104434602, 'Lazdas', 8, 286),
	(100010548, 104434610, 'Lazdiņas', 8, 286),
	(100010548, 104434627, 'Leduži', 8, 286),
	(100010548, 104434651, 'Lejas Simsoni', 8, 286),
	(100010548, 104434692, 'Lejnieki', 8, 286),
	(100010548, 104434723, 'Līdumi', 8, 286),
	(100010548, 104434828, 'Līgotņi', 8, 286),
	(100010548, 104434836, 'Limpuči', 8, 286),
	(100010548, 104434893, 'Maigas', 8, 286),
	(100010548, 104434932, 'Mazās Lazdas', 8, 286),
	(100010548, 104434957, 'Mazbleķi', 8, 286),
	(100010548, 104434965, 'Mazbrankūži', 8, 286),
	(100010548, 104434981, 'Mazjuši', 8, 286),
	(100010548, 104434998, 'Mazlazdas', 8, 286),
	(100010548, 104435001, 'Mazpurviņi', 8, 286),
	(100010548, 104435018, 'Mazrušķeri', 8, 286),
	(100010548, 104436977, 'Kalēji', 8, 286),
	(100010548, 104586418, 'Bišu Bērzi', 8, 286),
	(100010548, 104643400, 'Klintas', 8, 286),
	(100010548, 104832837, 'Āži', 8, 286),
	(100010548, 104833180, 'Gundegas', 8, 286),
	(100010548, 104833420, 'Kalna Ķeri', 8, 286),
	(100010548, 104833437, 'Mazputniņi', 8, 286),
	(100010548, 105432434, 'Avotiņi', 8, 286),
	(100010548, 105996420, 'Ausekļu dzirnavas', 8, 286),
	(100010548, 106018615, 'Bāzes stacija 414', 8, 286),
	(100010548, 106307761, 'Ievziedi', 8, 286),
	(100010548, 106380352, 'Alejas 1', 8, 286),
	(100010548, 106428325, 'Mazsaulītes', 8, 286),
	(100010548, 106721254, 'Liepziedi', 8, 286),
	(100010548, 106762652, 'Jaunbērzi', 8, 286),
	(100010548, 106952584, 'Aleksija dārzi', 8, 286);

-- Dumping structure for table lauris_e.lauris_address_index
CREATE TABLE IF NOT EXISTS `lauris_address_index` (
  `id` int(10) unsigned NOT NULL COMMENT 'Adreses indeksa ID',
  `number` smallint(5) unsigned NOT NULL COMMENT 'Adreses indekss',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Adreses indeksi';

-- Dumping data for table lauris_e.lauris_address_index: ~694 rows (approximately)
INSERT INTO `lauris_address_index` (`id`, `number`) VALUES
	(1, 1001),
	(2, 1002),
	(3, 1003),
	(4, 1004),
	(5, 1005),
	(6, 1006),
	(7, 1007),
	(8, 1009),
	(9, 1010),
	(10, 1011),
	(11, 1012),
	(12, 1013),
	(13, 1014),
	(14, 1015),
	(15, 1016),
	(16, 1019),
	(17, 1021),
	(18, 1023),
	(19, 1024),
	(20, 1026),
	(21, 1029),
	(22, 1030),
	(23, 1034),
	(24, 1035),
	(25, 1038),
	(26, 1039),
	(27, 1044),
	(28, 1045),
	(29, 1046),
	(30, 1048),
	(31, 1050),
	(32, 1053),
	(33, 1055),
	(34, 1057),
	(35, 1058),
	(36, 1063),
	(37, 1064),
	(38, 1067),
	(39, 1069),
	(40, 1073),
	(41, 1076),
	(42, 1079),
	(43, 1082),
	(44, 1083),
	(45, 1084),
	(46, 2008),
	(47, 2010),
	(48, 2011),
	(49, 2012),
	(50, 2015),
	(51, 2016),
	(52, 2101),
	(53, 2103),
	(54, 2105),
	(55, 2107),
	(56, 2108),
	(57, 2111),
	(58, 2112),
	(59, 2113),
	(60, 2114),
	(61, 2117),
	(62, 2118),
	(63, 2119),
	(64, 2121),
	(65, 2123),
	(66, 2124),
	(67, 2125),
	(68, 2127),
	(69, 2128),
	(70, 2130),
	(71, 2133),
	(72, 2135),
	(73, 2136),
	(74, 2137),
	(75, 2140),
	(76, 2141),
	(77, 2142),
	(78, 2144),
	(79, 2145),
	(80, 2150),
	(81, 2151),
	(82, 2152),
	(83, 2154),
	(84, 2160),
	(85, 2161),
	(86, 2162),
	(87, 2163),
	(88, 2164),
	(89, 2166),
	(90, 2167),
	(91, 2169),
	(92, 2170),
	(93, 3001),
	(94, 3002),
	(95, 3003),
	(96, 3004),
	(97, 3007),
	(98, 3008),
	(99, 3011),
	(100, 3014),
	(101, 3016),
	(102, 3017),
	(103, 3018),
	(104, 3020),
	(105, 3021),
	(106, 3022),
	(107, 3023),
	(108, 3026),
	(109, 3028),
	(110, 3031),
	(111, 3034),
	(112, 3036),
	(113, 3037),
	(114, 3040),
	(115, 3042),
	(116, 3043),
	(117, 3045),
	(118, 3101),
	(119, 3104),
	(120, 3110),
	(121, 3113),
	(122, 3118),
	(123, 3119),
	(124, 3120),
	(125, 3122),
	(126, 3123),
	(127, 3124),
	(128, 3128),
	(129, 3129),
	(130, 3131),
	(131, 3132),
	(132, 3133),
	(133, 3134),
	(134, 3135),
	(135, 3137),
	(136, 3139),
	(137, 3140),
	(138, 3142),
	(139, 3145),
	(140, 3146),
	(141, 3147),
	(142, 3148),
	(143, 3201),
	(144, 3251),
	(145, 3253),
	(146, 3257),
	(147, 3258),
	(148, 3260),
	(149, 3261),
	(150, 3262),
	(151, 3264),
	(152, 3270),
	(153, 3275),
	(154, 3280),
	(155, 3281),
	(156, 3283),
	(157, 3284),
	(158, 3285),
	(159, 3287),
	(160, 3291),
	(161, 3292),
	(162, 3294),
	(163, 3297),
	(164, 3298),
	(165, 3301),
	(166, 3306),
	(167, 3307),
	(168, 3309),
	(169, 3310),
	(170, 3312),
	(171, 3313),
	(172, 3314),
	(173, 3317),
	(174, 3319),
	(175, 3320),
	(176, 3321),
	(177, 3322),
	(178, 3323),
	(179, 3324),
	(180, 3325),
	(181, 3326),
	(182, 3328),
	(183, 3329),
	(184, 3330),
	(185, 3332),
	(186, 3333),
	(187, 3401),
	(188, 3402),
	(189, 3405),
	(190, 3407),
	(191, 3411),
	(192, 3414),
	(193, 3416),
	(194, 3430),
	(195, 3431),
	(196, 3433),
	(197, 3434),
	(198, 3435),
	(199, 3436),
	(200, 3438),
	(201, 3440),
	(202, 3441),
	(203, 3442),
	(204, 3443),
	(205, 3444),
	(206, 3445),
	(207, 3446),
	(208, 3447),
	(209, 3452),
	(210, 3453),
	(211, 3455),
	(212, 3456),
	(213, 3457),
	(214, 3461),
	(215, 3463),
	(216, 3466),
	(217, 3473),
	(218, 3474),
	(219, 3475),
	(220, 3476),
	(221, 3477),
	(222, 3480),
	(223, 3482),
	(224, 3484),
	(225, 3485),
	(226, 3486),
	(227, 3487),
	(228, 3601),
	(229, 3602),
	(230, 3604),
	(231, 3612),
	(232, 3613),
	(233, 3614),
	(234, 3615),
	(235, 3617),
	(236, 3619),
	(237, 3620),
	(238, 3621),
	(239, 3623),
	(240, 3624),
	(241, 3626),
	(242, 3627),
	(243, 3701),
	(244, 3708),
	(245, 3709),
	(246, 3710),
	(247, 3711),
	(248, 3713),
	(249, 3714),
	(250, 3716),
	(251, 3717),
	(252, 3718),
	(253, 3719),
	(254, 3721),
	(255, 3722),
	(256, 3723),
	(257, 3724),
	(258, 3725),
	(259, 3729),
	(260, 3730),
	(261, 3731),
	(262, 3732),
	(263, 3801),
	(264, 3851),
	(265, 3852),
	(266, 3853),
	(267, 3861),
	(268, 3862),
	(269, 3871),
	(270, 3873),
	(271, 3875),
	(272, 3876),
	(273, 3880),
	(274, 3882),
	(275, 3883),
	(276, 3890),
	(277, 3891),
	(278, 3892),
	(279, 3893),
	(280, 3894),
	(281, 3895),
	(282, 3896),
	(283, 3897),
	(284, 3898),
	(285, 3899),
	(286, 3901),
	(287, 3905),
	(288, 3906),
	(289, 3907),
	(290, 3908),
	(291, 3910),
	(292, 3913),
	(293, 3914),
	(294, 3915),
	(295, 3917),
	(296, 3918),
	(297, 3921),
	(298, 3924),
	(299, 3925),
	(300, 3926),
	(301, 3927),
	(302, 3929),
	(303, 3930),
	(304, 3931),
	(305, 3932),
	(306, 3933),
	(307, 3936),
	(308, 4001),
	(309, 4004),
	(310, 4010),
	(311, 4011),
	(312, 4012),
	(313, 4013),
	(314, 4020),
	(315, 4022),
	(316, 4023),
	(317, 4025),
	(318, 4033),
	(319, 4035),
	(320, 4043),
	(321, 4050),
	(322, 4052),
	(323, 4054),
	(324, 4061),
	(325, 4063),
	(326, 4064),
	(327, 4068),
	(328, 4101),
	(329, 4108),
	(330, 4110),
	(331, 4112),
	(332, 4113),
	(333, 4116),
	(334, 4118),
	(335, 4119),
	(336, 4122),
	(337, 4123),
	(338, 4125),
	(339, 4126),
	(340, 4128),
	(341, 4129),
	(342, 4131),
	(343, 4132),
	(344, 4133),
	(345, 4136),
	(346, 4139),
	(347, 4141),
	(348, 4143),
	(349, 4144),
	(350, 4146),
	(351, 4151),
	(352, 4152),
	(353, 4154),
	(354, 4201),
	(355, 4206),
	(356, 4208),
	(357, 4210),
	(358, 4211),
	(359, 4213),
	(360, 4215),
	(361, 4216),
	(362, 4219),
	(363, 4220),
	(364, 4222),
	(365, 4223),
	(366, 4224),
	(367, 4227),
	(368, 4228),
	(369, 4232),
	(370, 4234),
	(371, 4240),
	(372, 4241),
	(373, 4242),
	(374, 4244),
	(375, 4245),
	(376, 4247),
	(377, 4248),
	(378, 4301),
	(379, 4332),
	(380, 4333),
	(381, 4335),
	(382, 4336),
	(383, 4337),
	(384, 4339),
	(385, 4340),
	(386, 4341),
	(387, 4342),
	(388, 4344),
	(389, 4345),
	(390, 4348),
	(391, 4350),
	(392, 4351),
	(393, 4352),
	(394, 4354),
	(395, 4355),
	(396, 4358),
	(397, 4359),
	(398, 4401),
	(399, 4405),
	(400, 4406),
	(401, 4409),
	(402, 4410),
	(403, 4412),
	(404, 4415),
	(405, 4416),
	(406, 4417),
	(407, 4420),
	(408, 4421),
	(409, 4424),
	(410, 4425),
	(411, 4426),
	(412, 4428),
	(413, 4429),
	(414, 4501),
	(415, 4561),
	(416, 4562),
	(417, 4566),
	(418, 4567),
	(419, 4570),
	(420, 4571),
	(421, 4572),
	(422, 4573),
	(423, 4574),
	(424, 4576),
	(425, 4577),
	(426, 4580),
	(427, 4582),
	(428, 4583),
	(429, 4584),
	(430, 4585),
	(431, 4586),
	(432, 4587),
	(433, 4590),
	(434, 4591),
	(435, 4592),
	(436, 4594),
	(437, 4595),
	(438, 4601),
	(439, 4604),
	(440, 4611),
	(441, 4612),
	(442, 4614),
	(443, 4615),
	(444, 4616),
	(445, 4617),
	(446, 4618),
	(447, 4619),
	(448, 4621),
	(449, 4622),
	(450, 4623),
	(451, 4625),
	(452, 4626),
	(453, 4627),
	(454, 4628),
	(455, 4630),
	(456, 4631),
	(457, 4633),
	(458, 4634),
	(459, 4635),
	(460, 4636),
	(461, 4638),
	(462, 4640),
	(463, 4641),
	(464, 4642),
	(465, 4643),
	(466, 4645),
	(467, 4647),
	(468, 4648),
	(469, 4649),
	(470, 4650),
	(471, 4652),
	(472, 4701),
	(473, 4706),
	(474, 4707),
	(475, 4708),
	(476, 4711),
	(477, 4712),
	(478, 4713),
	(479, 4715),
	(480, 4716),
	(481, 4718),
	(482, 4723),
	(483, 4724),
	(484, 4726),
	(485, 4727),
	(486, 4728),
	(487, 4729),
	(488, 4730),
	(489, 4731),
	(490, 4733),
	(491, 4735),
	(492, 4801),
	(493, 4824),
	(494, 4825),
	(495, 4826),
	(496, 4830),
	(497, 4833),
	(498, 4834),
	(499, 4835),
	(500, 4836),
	(501, 4837),
	(502, 4838),
	(503, 4840),
	(504, 4841),
	(505, 4844),
	(506, 4846),
	(507, 4847),
	(508, 4852),
	(509, 4853),
	(510, 4855),
	(511, 4860),
	(512, 4862),
	(513, 4863),
	(514, 4865),
	(515, 4870),
	(516, 4871),
	(517, 4873),
	(518, 4880),
	(519, 4884),
	(520, 5001),
	(521, 5011),
	(522, 5012),
	(523, 5015),
	(524, 5016),
	(525, 5020),
	(526, 5022),
	(527, 5033),
	(528, 5041),
	(529, 5044),
	(530, 5045),
	(531, 5047),
	(532, 5052),
	(533, 5060),
	(534, 5062),
	(535, 5064),
	(536, 5065),
	(537, 5070),
	(538, 5071),
	(539, 5101),
	(540, 5106),
	(541, 5108),
	(542, 5109),
	(543, 5110),
	(544, 5111),
	(545, 5112),
	(546, 5113),
	(547, 5115),
	(548, 5118),
	(549, 5120),
	(550, 5123),
	(551, 5124),
	(552, 5125),
	(553, 5128),
	(554, 5129),
	(555, 5130),
	(556, 5133),
	(557, 5134),
	(558, 5135),
	(559, 5201),
	(560, 5202),
	(561, 5204),
	(562, 5208),
	(563, 5209),
	(564, 5210),
	(565, 5211),
	(566, 5212),
	(567, 5214),
	(568, 5215),
	(569, 5216),
	(570, 5217),
	(571, 5218),
	(572, 5220),
	(573, 5221),
	(574, 5222),
	(575, 5223),
	(576, 5224),
	(577, 5226),
	(578, 5228),
	(579, 5229),
	(580, 5230),
	(581, 5232),
	(582, 5236),
	(583, 5237),
	(584, 5238),
	(585, 5239),
	(586, 5301),
	(587, 5304),
	(588, 5305),
	(589, 5311),
	(590, 5312),
	(591, 5315),
	(592, 5316),
	(593, 5318),
	(594, 5320),
	(595, 5323),
	(596, 5325),
	(597, 5326),
	(598, 5327),
	(599, 5328),
	(600, 5329),
	(601, 5330),
	(602, 5331),
	(603, 5333),
	(604, 5334),
	(605, 5335),
	(606, 5337),
	(607, 5401),
	(608, 5404),
	(609, 5410),
	(610, 5412),
	(611, 5413),
	(612, 5414),
	(613, 5415),
	(614, 5417),
	(615, 5418),
	(616, 5422),
	(617, 5438),
	(618, 5439),
	(619, 5440),
	(620, 5441),
	(621, 5442),
	(622, 5443),
	(623, 5444),
	(624, 5447),
	(625, 5449),
	(626, 5450),
	(627, 5451),
	(628, 5456),
	(629, 5458),
	(630, 5459),
	(631, 5460),
	(632, 5461),
	(633, 5462),
	(634, 5463),
	(635, 5465),
	(636, 5469),
	(637, 5470),
	(638, 5471),
	(639, 5473),
	(640, 5474),
	(641, 5477),
	(642, 5481),
	(643, 5601),
	(644, 5651),
	(645, 5652),
	(646, 5653),
	(647, 5655),
	(648, 5656),
	(649, 5660),
	(650, 5662),
	(651, 5664),
	(652, 5666),
	(653, 5668),
	(654, 5671),
	(655, 5674),
	(656, 5676),
	(657, 5677),
	(658, 5680),
	(659, 5681),
	(660, 5685),
	(661, 5687),
	(662, 5692),
	(663, 5695),
	(664, 5696),
	(665, 5697),
	(666, 5698),
	(667, 5701),
	(668, 5704),
	(669, 5705),
	(670, 5706),
	(671, 5707),
	(672, 5709),
	(673, 5711),
	(674, 5716),
	(675, 5717),
	(676, 5719),
	(677, 5722),
	(678, 5725),
	(679, 5726),
	(680, 5729),
	(681, 5730),
	(682, 5732),
	(683, 5733),
	(684, 5735),
	(685, 5736),
	(686, 5737),
	(687, 5739),
	(688, 5740),
	(689, 5742),
	(690, 5745),
	(691, 5748),
	(692, 5750),
	(693, 5751),
	(694, 5752);

-- Dumping structure for table lauris_e.lauris_address_level_copy
CREATE TABLE IF NOT EXISTS `lauris_address_level_copy` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Adreses līmeņa ID',
  `name` varchar(10) NOT NULL COMMENT 'Adreses līmenis',
  `fname` varchar(50) DEFAULT '' COMMENT 'Adreses līmeņa pilnais nosaukums',
  `sname` varchar(5) DEFAULT '' COMMENT 'Adreses līmeņa īsais nosaukums',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Adreses līmenis';

-- Dumping data for table lauris_e.lauris_address_level_copy: ~9 rows (approximately)
INSERT INTO `lauris_address_level_copy` (`id`, `name`, `fname`, `sname`) VALUES
	(1, 'Valsts', 'Valsts', ''),
	(2, 'Novads', 'Novads', 'nov.'),
	(3, 'Valsts pil', 'Valsts pilsēta', ''),
	(4, 'Pilsēta', 'Pilsēta', ''),
	(5, 'Pagasts', 'Pagasts', 'pag.'),
	(6, 'Ciems/mazc', 'Ciems/mazciems', ''),
	(7, 'Iela', 'Iela', ''),
	(8, 'Ēkas nr./N', 'Ēkas nr./Nosaukums, korpuss', ''),
	(9, 'Telpu grup', 'Telpu grupa (dzīvoklis)', '');

-- Dumping structure for table lauris_e.lauris_address_name_copy
CREATE TABLE IF NOT EXISTS `lauris_address_name_copy` (
  `id_address_name` int(10) unsigned NOT NULL COMMENT 'Piesaistītās adreses ID',
  `id` int(10) unsigned NOT NULL COMMENT 'Adreses ID',
  `name` varchar(20) NOT NULL COMMENT 'Nosaukums',
  `id_address_level` int(10) unsigned NOT NULL COMMENT 'Adreses līmeņa ID',
  `id_address_index` int(10) unsigned DEFAULT 0 COMMENT 'Pasta indeksa ID',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id_level` (`id_address_level`,`id_address_name`) USING BTREE,
  KEY `FK_address_name_address_name` (`id_address_name`) USING BTREE,
  KEY `FK_address_name_address_index` (`id_address_index`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Adreses';

-- Dumping data for table lauris_e.lauris_address_name_copy: ~103 rows (approximately)
INSERT INTO `lauris_address_name_copy` (`id_address_name`, `id`, `name`, `id_address_level`, `id_address_index`) VALUES
	(100000000, 100000000, 'Latvija', 1, 0),
	(100016575, 100010548, 'Bārbeles pag.', 5, 0),
	(100000000, 100016575, 'Bauskas nov.', 2, 0),
	(100010548, 101105846, 'Cedelmaņi', 8, 286),
	(100010548, 101112868, 'Alenderkrogs', 8, 286),
	(100010548, 101113074, 'Andriņi', 8, 286),
	(100010548, 103742443, 'Jaunstepiņi', 8, 286),
	(100010548, 104432020, 'Bārbeles', 8, 286),
	(100010548, 104432045, 'Alņi', 8, 286),
	(100010548, 104432053, 'Andersoni', 8, 286),
	(100010548, 104432078, 'Āres', 8, 286),
	(100010548, 104432086, 'Austrumi', 8, 286),
	(100010548, 104432100, 'Avotkrogs', 8, 286),
	(100010548, 104432117, 'Baltrumi', 8, 286),
	(100010548, 104432141, 'Bārbeles pamatskola', 8, 286),
	(100010548, 104432158, 'Bauzas', 8, 286),
	(100010548, 104432182, 'Bērznieki', 8, 286),
	(100010548, 104432221, 'Bračkas', 8, 286),
	(100010548, 104432238, 'Bramaņi', 8, 286),
	(100010548, 104432254, 'Brīvnieki', 8, 286),
	(100010548, 104432262, 'Brusas', 8, 286),
	(100010548, 104432301, 'Čiekuri', 8, 286),
	(100010548, 104432318, 'Čūderi', 8, 286),
	(100010548, 104432350, 'Dravenieki', 8, 286),
	(100010548, 104432367, 'Dreijeri', 8, 286),
	(100010548, 104432406, 'Dzērvēni', 8, 286),
	(100010548, 104432447, 'Eglaines', 8, 286),
	(100010548, 104432463, 'Eglītes', 8, 286),
	(100010548, 104432471, 'Ērgļi', 8, 286),
	(100010548, 104432488, 'Erliķi', 8, 286),
	(100010548, 104432496, 'Everti', 8, 286),
	(100010548, 104432502, 'Ezera Salmiņi', 8, 286),
	(100010548, 104432527, 'Ezernieki', 8, 286),
	(100010548, 104432535, 'Ēzītes', 8, 286),
	(100010548, 104432551, 'Gaidas', 8, 286),
	(100010548, 104433047, 'Garbari', 8, 286),
	(100010548, 104433071, 'Gaujas', 8, 286),
	(100010548, 104433096, 'Gedroviči', 8, 286),
	(100010548, 104433127, 'Glīzdiņi', 8, 286),
	(100010548, 104433151, 'Gobas', 8, 286),
	(100010548, 104433192, 'Grantskalni', 8, 286),
	(100010548, 104433223, 'Grāvīši', 8, 286),
	(100010548, 104433280, 'Grīnbergi', 8, 286),
	(100010548, 104433311, 'Ģeķi', 8, 286),
	(100010548, 104433328, 'Ģērķi', 8, 286),
	(100010548, 104433344, 'Ilgas', 8, 286),
	(100010548, 104433360, 'Ilmiņas', 8, 286),
	(100010548, 104433377, 'Dīķīši', 8, 286),
	(100010548, 104433385, 'Indrāni', 8, 286),
	(100010548, 104433393, 'Jāņkalni', 8, 286),
	(100010548, 104433416, 'Jaunindrāni', 8, 286),
	(100010548, 104433481, 'Jēkapiņi', 8, 286),
	(100010548, 104433504, 'Jobi', 8, 286),
	(100010548, 104433537, 'Jostkalēji', 8, 286),
	(100010548, 104433545, 'Jukatas', 8, 286),
	(100010548, 104433561, 'Jukši', 8, 286),
	(100010548, 104433600, 'Jūrnieki', 8, 286),
	(100010548, 104433625, 'Juši', 8, 286),
	(100010548, 104433746, 'Kalnrūpnieki', 8, 286),
	(100010548, 104434008, 'Kalnieši', 8, 286),
	(100010548, 104434032, 'Kalnzemnieki', 8, 286),
	(100010548, 104434057, 'Kauķi', 8, 286),
	(100010548, 104434073, 'Klāvi', 8, 286),
	(100010548, 104434120, 'Kociņi', 8, 286),
	(100010548, 104434153, 'Kramkalniņi', 8, 286),
	(100010548, 104434178, 'Kraukļi', 8, 286),
	(100010548, 104434186, 'Krieviņi', 8, 286),
	(100010548, 104434522, 'Ķirveļi', 8, 286),
	(100010548, 104434530, 'Ķīseļi', 8, 286),
	(100010548, 104434555, 'Lācīši', 8, 286),
	(100010548, 104434563, 'Langas', 8, 286),
	(100010548, 104434602, 'Lazdas', 8, 286),
	(100010548, 104434610, 'Lazdiņas', 8, 286),
	(100010548, 104434627, 'Leduži', 8, 286),
	(100010548, 104434651, 'Lejas Simsoni', 8, 286),
	(100010548, 104434692, 'Lejnieki', 8, 286),
	(100010548, 104434723, 'Līdumi', 8, 286),
	(100010548, 104434828, 'Līgotņi', 8, 286),
	(100010548, 104434836, 'Limpuči', 8, 286),
	(100010548, 104434893, 'Maigas', 8, 286),
	(100010548, 104434932, 'Mazās Lazdas', 8, 286),
	(100010548, 104434957, 'Mazbleķi', 8, 286),
	(100010548, 104434965, 'Mazbrankūži', 8, 286),
	(100010548, 104434981, 'Mazjuši', 8, 286),
	(100010548, 104434998, 'Mazlazdas', 8, 286),
	(100010548, 104435001, 'Mazpurviņi', 8, 286),
	(100010548, 104435018, 'Mazrušķeri', 8, 286),
	(100010548, 104436977, 'Kalēji', 8, 286),
	(100010548, 104586418, 'Bišu Bērzi', 8, 286),
	(100010548, 104643400, 'Klintas', 8, 286),
	(100010548, 104832837, 'Āži', 8, 286),
	(100010548, 104833180, 'Gundegas', 8, 286),
	(100010548, 104833420, 'Kalna Ķeri', 8, 286),
	(100010548, 104833437, 'Mazputniņi', 8, 286),
	(100010548, 105432434, 'Avotiņi', 8, 286),
	(100010548, 105996420, 'Ausekļu dzirnavas', 8, 286),
	(100010548, 106018615, 'Bāzes stacija 414', 8, 286),
	(100010548, 106307761, 'Ievziedi', 8, 286),
	(100010548, 106380352, 'Alejas 1', 8, 286),
	(100010548, 106428325, 'Mazsaulītes', 8, 286),
	(100010548, 106721254, 'Liepziedi', 8, 286),
	(100010548, 106762652, 'Jaunbērzi', 8, 286),
	(100010548, 106952584, 'Aleksija dārzi', 8, 286);

-- Dumping structure for table lauris_e.lauris_full_address_name
CREATE TABLE IF NOT EXISTS `lauris_full_address_name` (
  `id` int(10) unsigned NOT NULL DEFAULT 0,
  `id_address_name` int(10) unsigned NOT NULL DEFAULT 0,
  `NAME` varchar(30) NOT NULL DEFAULT '',
  `id_address_level` int(10) unsigned NOT NULL DEFAULT 0,
  `id_address_index` int(10) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table lauris_e.lauris_full_address_name: ~3 049 rows (approximately)
INSERT INTO `lauris_full_address_name` (`id`, `id_address_name`, `NAME`, `id_address_level`, `id_address_index`) VALUES
	(100003028, 100000000, 'Jelgava', 4, 0),
	(100319328, 100003028, 'Ausekļa iela', 4, 0),
	(100319336, 100003028, 'Ausmas iela', 7, 0),
	(100319352, 100003028, 'Aveņu iela', 7, 0),
	(101154005, 101754450, '17', 8, 93),
	(101754450, 101754450, '12', 8, 93),
	(101754467, 101754450, ' 12A', 8, 93),
	(101754475, 101754450, '16', 8, 93),
	(101754483, 101754450, '19', 8, 93),
	(101754491, 101754450, ' 19A', 8, 93),
	(101754506, 101754450, '21', 8, 93),
	(101754514, 101754450, ' 21A', 8, 93),
	(101754522, 101754450, '23', 8, 93),
	(101754530, 101754450, '28', 8, 93),
	(101754555, 101754450, '32', 8, 93),
	(101754563, 101754450, '34', 8, 93),
	(101754571, 101754450, '36', 8, 93),
	(101754588, 100003028, '4', 8, 97),
	(101754596, 101754450, '40', 8, 93),
	(101754602, 101754450, '42', 8, 93),
	(101754610, 101754450, '48', 8, 93),
	(101754627, 101754450, '52', 8, 93),
	(101754635, 101754450, ' 52A', 8, 93),
	(101754668, 101754450, ' 58A', 8, 93),
	(101754676, 101754450, '6', 8, 97),
	(101754684, 101754450, '60', 8, 93),
	(101754692, 101754450, '64', 8, 93),
	(101754707, 101754450, ' 6A', 8, 93),
	(101754715, 101754450, ' 6B', 8, 93),
	(101754772, 101754450, '9', 8, 93),
	(101754780, 100003028, '1', 8, 98),
	(101754797, 101754780, '10', 8, 98),
	(101754803, 101754780, '11', 8, 98),
	(101754811, 101754780, '12', 8, 98),
	(101754828, 101754780, '13', 8, 98),
	(101754836, 101754780, '14', 8, 98),
	(101754844, 101754780, '15', 8, 98),
	(101754852, 101754780, '16', 8, 98),
	(101754860, 101754780, '18', 8, 98),
	(101754877, 101754780, '2', 8, 98),
	(101754885, 101754780, '20', 8, 98),
	(101754893, 101754780, '24', 8, 98),
	(101754908, 101754780, '26', 8, 98),
	(101754916, 101754780, '28', 8, 98),
	(101754924, 101754780, '3', 8, 98),
	(101754932, 101754780, '30', 8, 98),
	(101754940, 101754780, '32', 8, 98),
	(101754957, 101754780, '34', 8, 98),
	(101754965, 101754780, '4', 8, 98),
	(101754973, 101754780, '40', 8, 98),
	(101754998, 101754780, '5', 8, 98),
	(101755001, 101754780, '6', 8, 98),
	(101755018, 101754780, '8', 8, 98),
	(101755067, 100003028, '1', 8, 93),
	(101755075, 101755067, '10', 8, 93),
	(101755083, 101755067, '11', 8, 93),
	(101755091, 101755067, '12', 8, 93),
	(101755106, 101755067, '13', 8, 93),
	(101755114, 101755067, '14', 8, 93),
	(101755122, 101755067, '15', 8, 93),
	(101755130, 101755067, '17', 8, 93),
	(101755147, 101755067, '18', 8, 93),
	(101755155, 101755067, '19', 8, 93),
	(101755163, 101755067, '2', 8, 93),
	(101755171, 101755067, '20', 8, 93),
	(101755188, 101755067, '21', 8, 93),
	(101755196, 101755067, '22', 8, 93),
	(101755202, 101755067, '23', 8, 93),
	(101755210, 101755067, ' 23A', 8, 93),
	(101755227, 101755067, '24', 8, 93),
	(101755235, 101755067, '25', 8, 93),
	(101755276, 101755067, '3', 8, 93),
	(101755380, 101755067, '4', 8, 93),
	(101755460, 101755067, '5', 8, 93),
	(101755477, 101755067, '7', 8, 93),
	(101755485, 101755067, '9', 8, 93),
	(102495357, 101754450, '11', 8, 93),
	(102495365, 101754450, ' 11A', 8, 93),
	(102495381, 101754450, '15', 8, 93),
	(102495398, 101754450, ' 18/20', 8, 93),
	(102495412, 101754450, '24', 8, 93),
	(102495420, 101754450, '25', 8, 93),
	(102495437, 101754450, '26', 8, 93),
	(102495453, 101754450, '38', 8, 93),
	(102495461, 101754450, '46', 8, 93),
	(102495478, 101754450, '62', 8, 93),
	(102495486, 101754450, '66', 8, 93),
	(102495494, 101754450, '68', 8, 93),
	(102495500, 101754450, ' 6C', 8, 93),
	(102495525, 101754450, '7', 8, 93),
	(102495533, 101754780, '36', 8, 98),
	(102495541, 101754780, '38', 8, 98),
	(102495558, 101754780, '42', 8, 98),
	(102495582, 101755067, '16', 8, 93),
	(102495590, 101755067, '26', 8, 93),
	(102495613, 101755067, '6', 8, 93),
	(102495621, 101755067, '8', 8, 93),
	(102608512, 101754780, '7', 8, 98),
	(102631075, 101754450, '5', 8, 93),
	(102631083, 101754450, '70', 8, 93),
	(102634216, 101754450, '8', 8, 93),
	(102634257, 101754780, '22', 8, 98),
	(102671430, 101754780, '9', 8, 98),
	(106043856, 101754780, '19', 8, 98),
	(106161117, 101754780, '17', 8, 98),
	(106161174, 101754780, ' 17A', 8, 98),
	(106704414, 101754450, ' 62A', 8, 93),
	(106914167, 101754450, ' 58B', 8, 93),
	(100000000, 100000000, 'Latvija', 1, 0),
	(100014668, 100016333, 'Piltenes ', 5, 0),
	(100014676, 100016333, 'Jūrkalnes ', 5, 0),
	(100014684, 100016333, 'Popes ', 5, 0),
	(100014692, 100016333, 'Puzes ', 5, 0),
	(100014707, 100016333, 'Tārgales ', 5, 0),
	(100014715, 100016333, 'Usmas ', 5, 0),
	(100014723, 100016333, 'Užavas ', 5, 0),
	(100014731, 100016333, 'Vārves ', 5, 0),
	(100014748, 100016333, 'Zlēku ', 5, 0),
	(100015130, 100016333, 'Ances ', 5, 0),
	(100015147, 100016333, 'Ugāles ', 5, 0),
	(100015155, 100016333, 'Ziru ', 5, 0),
	(100016333, 100000000, 'Ventspils ', 2, 0),
	(101170688, 100014668, 'Mauriņi', 8, 237),
	(102051262, 100014668, 'Amālnieki', 8, 237),
	(102052297, 100014668, 'Krievciemnieki', 8, 237),
	(102052311, 100014668, 'Krievciems', 8, 237),
	(103141615, 100014668, 'Bērzkaukši', 8, 237),
	(103141697, 100014668, 'Dēdes', 8, 237),
	(103142022, 100014668, 'Dzeņi', 8, 237),
	(103142047, 100014668, 'Dravnieki', 8, 237),
	(103142432, 100014668, 'Liepiņi', 8, 237),
	(103142600, 100014668, 'Jenoti', 8, 237),
	(103142617, 100014668, 'Irši', 8, 237),
	(103142625, 100014668, 'Brieži', 8, 237),
	(103142633, 100014668, 'Palejas', 8, 237),
	(103142674, 100014668, 'Gārzdes ceplis', 8, 237),
	(103142690, 100014668, 'Čunči', 8, 237),
	(103142705, 100014668, 'Eglītes', 8, 237),
	(103142834, 100014668, 'Kalnmaļi', 8, 237),
	(103142996, 100014668, 'Lieparāji', 8, 237),
	(103143057, 100014668, 'Jaunputniņi', 8, 237),
	(103143178, 100014668, 'Brasliņi', 8, 237),
	(103143225, 100014668, 'Lasnieki', 8, 237),
	(103143266, 100014668, 'Jorniņi', 8, 237),
	(103143282, 100014668, 'Alaudas', 8, 237),
	(103143467, 100014668, 'Niedriņi', 8, 237),
	(103143475, 100014668, 'Dižmārtiņi', 8, 237),
	(103143563, 100014668, 'Baloži', 8, 237),
	(103143596, 100014668, 'Druķēni', 8, 237),
	(103144380, 100014668, 'Mierlauki', 8, 237),
	(103144403, 100014668, 'Branči', 8, 237),
	(103144411, 100014668, 'Brenči', 8, 237),
	(103144428, 100014668, 'Danči', 8, 237),
	(103144444, 100014668, 'Lūši', 8, 237),
	(103144452, 100014668, 'Kalni', 8, 237),
	(103144460, 100014668, 'Dižbeltes', 8, 237),
	(103144477, 100014668, 'Bileskalni', 8, 237),
	(103144485, 100014668, 'Dzilnas', 8, 237),
	(103144508, 100014668, 'Jaunrobežnieki', 8, 237),
	(103144516, 100014668, 'Jaunsilnieki', 8, 237),
	(103144532, 100014668, 'Dūdiņi', 8, 237),
	(103144540, 100014668, 'Latlauki', 8, 237),
	(103144565, 100014668, 'Bērzi', 8, 237),
	(103144573, 100014668, 'Aizupes', 8, 237),
	(103144604, 100014668, 'Landzes baznīca', 8, 237),
	(103144653, 100014668, 'Pļaviņas', 8, 237),
	(103144661, 100014668, 'Mazķesteri', 8, 237),
	(103144678, 100014668, 'Pansionāts ""Piltene', 8, 237),
	(103144686, 100014668, 'Ābolkalni', 8, 237),
	(103144717, 100014668, 'Gaiļi', 8, 237),
	(103144725, 100014668, 'Bauļi', 8, 237),
	(103144766, 100014668, 'Klētnieki', 8, 237),
	(103144774, 100014668, 'Jaunzemji', 8, 237),
	(103144782, 100014668, 'Gārzdes skola', 8, 237),
	(103144790, 100014668, 'Ādģēri', 8, 237),
	(103144821, 100014668, 'Mazbraki', 8, 237),
	(103144838, 100014668, 'Muldas', 8, 237),
	(103144846, 100014668, 'Grīvas', 8, 237),
	(103144854, 100014668, 'Jaunarāji 2', 8, 237),
	(103144862, 100014668, 'Dīriķi', 8, 237),
	(103144870, 100014668, 'Mazgaisiņi', 8, 237),
	(103144901, 100014668, 'Dižgaisiņi', 8, 237),
	(103144918, 100014668, 'Muižarāji', 8, 237),
	(103144926, 100014668, 'Alkšņi', 8, 237),
	(103144934, 100014668, 'Kronnieki', 8, 237),
	(103144967, 100014668, 'Cīruļi', 8, 237),
	(103144991, 100014668, 'Jaunbirzes', 8, 237),
	(103145044, 100014668, 'Lejnieki', 8, 237),
	(103145052, 100014668, 'Liepnieki', 8, 237),
	(103145157, 100014668, 'Liepmalas', 8, 237),
	(103145165, 100014668, 'Brūveri', 8, 237),
	(103145173, 100014668, 'Klajumi', 8, 237),
	(103145181, 100014668, 'Gulbīši', 8, 237),
	(103145198, 100014668, 'Mežsargi', 8, 237),
	(103145237, 100014668, 'Jaunpīkas', 8, 237),
	(103145245, 100014668, 'Augstupes', 8, 237),
	(103145253, 100014668, 'Irbes', 8, 237),
	(103145261, 100014668, 'Dzērves', 8, 237),
	(103145278, 100014668, 'Citroni', 8, 237),
	(103145286, 100014668, 'Āboliņi', 8, 237),
	(103145294, 100014668, 'Novadnieki', 8, 237),
	(103145300, 100014668, 'Ozoli', 8, 237),
	(103145317, 100014668, 'Lodiņi', 8, 237),
	(103145325, 100014668, 'Ozollejas', 8, 237),
	(103145333, 100014668, 'Cepļābelnieki', 8, 237),
	(103145341, 100014668, 'Druviņas 2', 8, 237),
	(103145358, 100014668, 'Pīkas', 8, 237),
	(103145405, 100014668, 'Arāji', 8, 237),
	(103145421, 100014668, 'Auziņi', 8, 237),
	(103145518, 100014668, 'Dižābelnieki', 8, 237),
	(103145526, 100014668, 'Mazābelnieki', 8, 237),
	(103145534, 100014668, 'Krastnieki', 8, 237),
	(103145550, 100014668, 'Bolderkrogs', 8, 237),
	(103145567, 100014668, 'Ezerkalni', 8, 237),
	(103145583, 100014668, 'Mālarāji', 8, 237),
	(103145591, 100014668, 'Dzintari', 8, 237),
	(103145614, 100014668, 'Bāliņi', 8, 237),
	(103145622, 100014668, 'Kambarlauki', 8, 237),
	(103146038, 100014668, 'Dimzas', 8, 237),
	(103146087, 100014668, 'Pļavnieki', 8, 237),
	(103146118, 100014668, 'Burtnieki', 8, 237),
	(103146134, 100014668, 'Dangas', 8, 237),
	(103146175, 100014668, 'Lagzdienas Kalni', 8, 237),
	(103146206, 100014668, 'Klintnieki', 8, 237),
	(103148757, 100014668, 'Jaunzemes', 8, 237),
	(104852280, 100014668, 'Apses', 8, 237),
	(104852297, 100014668, 'Ceriņi', 8, 237),
	(104852328, 100014668, 'Gobas', 8, 237),
	(104852498, 100014668, 'Ķirškalni', 8, 237),
	(104852504, 100014668, 'Liepkalni', 8, 237),
	(104852826, 100014668, 'Obe', 8, 237),
	(104853032, 100014668, 'Jaunskaldnieki', 8, 237),
	(105190144, 100014668, 'Lagzdiene', 8, 237),
	(105311380, 100014668, 'Mazkraujmalas', 8, 237),
	(105311397, 100014668, 'Pīkas 1', 8, 237),
	(105311403, 100014668, 'Mazlīči', 8, 237),
	(105311428, 100014668, 'Austrumi', 8, 237),
	(105381728, 100014668, 'Dižakācijas', 8, 237),
	(105381777, 100014668, 'Jaunlauki', 8, 237),
	(105381785, 100014668, 'Jaungaisiņi', 8, 237),
	(105418665, 100014668, 'Grantiņi', 8, 237),
	(105418681, 100014668, 'Jāņi', 8, 237),
	(105418698, 100014668, 'Kalviņi', 8, 237),
	(105439318, 100014668, 'Landznieki', 8, 237),
	(105439326, 100014668, 'Mazklētnieki', 8, 237),
	(105439334, 100014668, 'Daces', 8, 237),
	(105439342, 100014668, 'Mazūsiņi', 8, 237),
	(105572805, 100014668, 'Dupēni', 8, 237),
	(105578744, 100014668, 'Egles', 8, 237),
	(105996888, 100014668, 'Butriki', 8, 237),
	(106268362, 100014668, 'Boitmaņi', 8, 237),
	(106384786, 100014668, 'Kausiņi', 8, 237),
	(106384833, 100014668, 'Kraujas', 8, 237),
	(106442705, 100014668, 'Mežamājas', 8, 237),
	(106555753, 100014668, 'Pīlādži', 8, 237),
	(106576760, 100014668, 'Pīlādžu sūkņu stacij', 8, 237),
	(106611308, 100014668, 'Pirmās Dižbeltes', 8, 237),
	(106731683, 100014668, 'Dižbraki', 8, 237),
	(106750871, 100014668, 'Dzīles', 8, 237),
	(106801674, 100014668, 'Kļavarāji', 8, 237),
	(106995447, 100014668, 'Lauklūši', 8, 237),
	(107017096, 100014668, 'Cērsupes', 8, 237),
	(103144678, 100014668, 'Pansionāts "Piltene"', 8, 237),
	(100011453, 100016534, 'Cenu pag.', 5, 0),
	(100016534, 100000000, 'Jelgavas nov.', 2, 0),
	(100127706, 100011453, 'Āne', 6, 0),
	(100127714, 100011453, 'Brankas', 6, 0),
	(102899850, 100127706, 'Bajāri', 8, 116),
	(102899883, 100127706, 'Tirgoņi', 8, 116),
	(102899955, 100127706, 'Ābelītes', 8, 116),
	(103564173, 100127714, 'Akācijas', 8, 115),
	(103564848, 100127706, 'Alejas', 8, 116),
	(103564897, 100127714, 'Antoni', 8, 116),
	(103564952, 100127714, 'Ataugas', 8, 115),
	(103565013, 100127714, 'Ausmas', 8, 115),
	(103565095, 100127706, 'Ānes muiža', 8, 116),
	(103565206, 100127714, 'Baumaņi', 8, 116),
	(103565247, 100127714, 'Bedres Ozoliņi', 8, 115),
	(103565302, 100127714, 'Bērziņi', 8, 116),
	(103565415, 100127714, 'Bērziņš 2', 8, 115),
	(103565423, 100127714, 'Bērziņš 3', 8, 115),
	(103565431, 100127714, 'Bērziņš 4', 8, 115),
	(103565448, 100127714, 'Bērziņš 5', 8, 115),
	(103565464, 100127714, 'Bērziņš 7', 8, 115),
	(103565472, 100127714, 'Bērziņš 8', 8, 115),
	(103565946, 100127706, 'Cinīši', 8, 116),
	(103566312, 100127706, 'Dzintari', 8, 116),
	(103567090, 100127706, 'Mazozoli', 8, 116),
	(103572494, 100127706, 'Jāņi', 8, 116),
	(103572525, 100127706, 'Puzuri', 8, 116),
	(103572662, 100127706, 'Kamenes', 8, 116),
	(103573213, 100127706, 'Lielupes', 8, 116),
	(103574135, 100127706, 'Otto', 8, 116),
	(103577390, 100127706, 'Mežazaķi', 8, 116),
	(103581864, 100127706, 'Ceļmaļi', 8, 116),
	(103581872, 100127706, 'Ezermalas', 8, 116),
	(103581880, 100127706, 'Kalni', 8, 116),
	(103581897, 100127706, 'Vecā Skola', 8, 116),
	(103582335, 100127706, 'Ieviņas 1', 8, 116),
	(103582351, 100127706, 'Ieviņas 2', 8, 116),
	(103582368, 100127706, 'Ieviņas 3', 8, 116),
	(103582376, 100127706, 'Ieviņas 4', 8, 116),
	(103582384, 100127706, 'Ieviņas 10', 8, 116),
	(103582392, 100127706, 'Ieviņas 11', 8, 116),
	(103582407, 100127706, 'Ieviņas 12', 8, 116),
	(103582415, 100127706, 'Ieviņas 13', 8, 116),
	(103582423, 100127706, 'Ieviņas 14', 8, 116),
	(103582431, 100127706, 'Ieviņas 15', 8, 116),
	(103582448, 100127706, 'Ieviņas 16', 8, 116),
	(103582456, 100127706, 'Ieviņas 17', 8, 116),
	(103582464, 100127706, 'Ieviņas 18', 8, 116),
	(103582472, 100127706, 'Ieviņas 19', 8, 116),
	(103582497, 100127706, 'Ieviņas 20', 8, 116),
	(103582503, 100127706, 'Ieviņas 21', 8, 116),
	(103582511, 100127706, 'Ieviņas 22', 8, 116),
	(103582528, 100127706, 'Ieviņas 23', 8, 116),
	(103582536, 100127706, 'Ieviņas 24', 8, 116),
	(103582544, 100127706, 'Ieviņas 25', 8, 116),
	(103582552, 100127706, 'Ieviņas 26', 8, 116),
	(103582560, 100127706, 'Ieviņas 27', 8, 116),
	(103582577, 100127706, 'Ieviņas 28', 8, 116),
	(103582585, 100127706, 'Ieviņas 29', 8, 116),
	(103582593, 100127706, 'Ieviņas 30', 8, 116),
	(103582608, 100127706, 'Ieviņas 31', 8, 116),
	(103582616, 100127706, 'Ieviņas 32', 8, 116),
	(103582624, 100127706, 'Ieviņas 33', 8, 116),
	(103582632, 100127706, 'Ieviņas 34', 8, 116),
	(103582640, 100127706, 'Ieviņas 35', 8, 116),
	(103582657, 100127706, 'Ieviņas 36', 8, 116),
	(103582665, 100127706, 'Ieviņas 37', 8, 116),
	(103582673, 100127706, 'Ieviņas 38', 8, 116),
	(103582681, 100127706, 'Ieviņas 39', 8, 116),
	(103588040, 100127706, 'Ieviņas 40', 8, 116),
	(103588057, 100127706, 'Ieviņas 41', 8, 116),
	(103588065, 100127706, 'Ieviņas 42', 8, 116),
	(103588073, 100127706, 'Ieviņas 43', 8, 116),
	(103588081, 100127706, 'Ieviņas 44', 8, 116),
	(103588098, 100127706, 'Ieviņas 45', 8, 116),
	(103588104, 100127706, 'Ieviņas 46', 8, 116),
	(103588112, 100127706, 'Ieviņas 47', 8, 116),
	(103588120, 100127706, 'Ieviņas 48', 8, 116),
	(103588137, 100127706, 'Ieviņas 49', 8, 116),
	(103588145, 100127706, 'Ieviņas 5', 8, 116),
	(103588153, 100127706, 'Ieviņas 50', 8, 116),
	(103588161, 100127706, 'Ieviņas 51', 8, 116),
	(103588194, 100127706, 'Ieviņas 6', 8, 116),
	(103588200, 100127706, 'Ieviņas 7', 8, 116),
	(103588217, 100127706, 'Ieviņas 8', 8, 116),
	(103588225, 100127706, 'Ieviņas 9', 8, 116),
	(104169470, 100127714, 'Akmentiņi', 8, 115),
	(104427775, 100127714, 'Astras', 8, 116),
	(104482493, 100127706, 'Lilijas', 8, 116),
	(104726022, 100127714, 'Asarīši', 8, 115),
	(104795312, 100127706, 'Tāles', 8, 116),
	(104968277, 100127706, 'Miglas', 8, 116),
	(105238037, 100127706, 'Lini', 8, 116),
	(105320164, 100127706, 'Jakaiši', 8, 116),
	(105348256, 100127706, 'Ezermājas', 8, 116),
	(105378385, 100127706, 'Asari', 8, 116),
	(105544062, 100127714, 'Ābeļziedi', 8, 115),
	(105575667, 100127714, 'Alises', 8, 116),
	(105757028, 100127714, 'Bāliņi', 8, 115),
	(105790397, 100127706, 'Ezermalas 1', 8, 116),
	(105790403, 100127706, 'Ezermalas 2', 8, 116),
	(105790411, 100127706, 'Ezermalas 3', 8, 116),
	(105790428, 100127706, 'Ezermalas 4', 8, 116),
	(105806462, 100127706, 'Vējiņi', 8, 116),
	(105806487, 100127706, 'Krastmalas', 8, 116),
	(105859096, 100127706, 'Rāmupes', 8, 116),
	(106673512, 100127706, 'Alejnieki', 8, 116),
	(106798550, 100127714, 'Baltijas Ceļš', 8, 116),
	(106805698, 100127706, 'Ūdensrozes', 8, 116),
	(106953393, 100127706, 'Rasa', 8, 116),
	(107029744, 100127706, 'Zandarti', 8, 116),
	(100003470, 100016688, 'Ogre', 4, 0),
	(100016688, 100000000, 'Ogres nov.', 2, 0),
	(100373696, 103341131, 'Aizkraukles 7', 7, 0),
	(100373702, 103341365, 'Akmeņu 7', 7, 0),
	(101351223, 100373696, 'Aizkraukles 710', 8, 520),
	(101351231, 100373696, 'Aizkraukles 711', 8, 520),
	(101351248, 100373696, 'Aizkraukles 712', 8, 520),
	(101351256, 100373696, 'Aizkraukles 713', 8, 520),
	(101351264, 100373696, 'Aizkraukles 714', 8, 520),
	(101351272, 100373696, 'Aizkraukles 716', 8, 520),
	(101351280, 100373696, 'Aizkraukles 717', 8, 520),
	(101351297, 100373696, 'Aizkraukles 718', 8, 520),
	(101351303, 100373696, 'Aizkraukles 72', 8, 520),
	(101351311, 100373696, 'Aizkraukles 73', 8, 520),
	(101351328, 100373696, 'Aizkraukles 74', 8, 520),
	(101351336, 100373696, 'Aizkraukles 75', 8, 520),
	(101351344, 100373696, 'Aizkraukles 79', 8, 520),
	(101351352, 100373702, 'Akmeņu 71', 8, 520),
	(101351360, 100373702, 'Akmeņu 711', 8, 520),
	(101351377, 100373702, 'Akmeņu 713', 8, 520),
	(101351385, 100373702, 'Akmeņu 715', 8, 520),
	(101351393, 100373702, 'Akmeņu 715A', 8, 520),
	(101351408, 100373702, 'Akmeņu 716', 8, 520),
	(101351416, 100373702, 'Akmeņu 716A', 8, 520),
	(101351424, 100373702, 'Akmeņu 716B', 8, 520),
	(101351432, 100373702, 'Akmeņu 717', 8, 520),
	(101351440, 100373702, 'Akmeņu 719', 8, 520),
	(101351457, 100373702, 'Akmeņu 720', 8, 520),
	(101351465, 100373702, 'Akmeņu 721', 8, 520),
	(101351473, 100373702, 'Akmeņu 722', 8, 520),
	(101351481, 100373702, 'Akmeņu 723', 8, 520),
	(101351498, 100373702, 'Akmeņu 724', 8, 520),
	(101351504, 100373702, 'Akmeņu 724A', 8, 520),
	(101351512, 100373702, 'Akmeņu 726', 8, 520),
	(101351520, 100373702, 'Akmeņu 727', 8, 520),
	(101351537, 100373702, 'Akmeņu 728', 8, 520),
	(101351545, 100373702, 'Akmeņu 729', 8, 520),
	(101351553, 100373702, 'Akmeņu 73', 8, 520),
	(101351682, 100373702, 'Akmeņu 75', 8, 520),
	(101351787, 100373702, 'Akmeņu 77', 8, 520),
	(101351801, 100373702, 'Akmeņu 79', 8, 520),
	(102148263, 100373696, 'Aizkraukles 719', 8, 520),
	(102148271, 100373696, 'Aizkraukles 719A', 8, 520),
	(102148288, 100373702, 'Akmeņu 714', 8, 520),
	(102148296, 100373702, 'Akmeņu 714A', 8, 520),
	(102148302, 100373702, 'Akmeņu 722A', 8, 520),
	(102148310, 100373702, 'Akmeņu 726A', 8, 520),
	(102148327, 100373702, 'Akmeņu 728A', 8, 520),
	(102597005, 100373696, 'Aizkraukles 715', 8, 520),
	(102662325, 100373696, 'Aizkraukles 78', 8, 520),
	(102662333, 100373702, 'Akmeņu 725', 8, 520),
	(102807767, 100373696, 'Aizkraukles 77', 8, 520),
	(102807791, 100373696, 'Aizkraukles 76', 8, 520),
	(102807806, 100373696, 'Aizkraukles 78A', 8, 520),
	(103338623, 100003470, 'Karuļi', 8, 520),
	(103340677, 100003470, 'Lībieškalns 1', 8, 520),
	(103341131, 100003470, 'Ataugas', 8, 520),
	(103341365, 100003470, 'Birziņi', 8, 520),
	(103341412, 100003470, 'Bitenieki', 8, 520),
	(103345196, 100003470, 'Kamenes', 8, 520),
	(103346374, 100003470, 'Origone', 8, 520),
	(103348796, 100003470, 'Rieksti', 8, 520),
	(103349250, 100003470, 'Stirnas', 8, 520),
	(103349644, 100003470, 'Vārpas', 8, 520),
	(104594554, 100003470, 'Mežsala', 8, 520),
	(105252378, 100003470, 'Tauriņi', 8, 520),
	(105393478, 100003470, 'Veckalni', 8, 520),
	(105432571, 100003470, 'Lielzari', 8, 520),
	(105522937, 100003470, 'Mazkalni', 8, 520),
	(105620178, 100003470, 'Garāža 11', 8, 520),
	(105708651, 100003470, 'Garāža 7', 8, 520),
	(105708676, 100003470, 'Vecbirziņi', 8, 520),
	(105735951, 100003470, 'Mežmalas 31', 8, 520),
	(105735968, 100003470, 'Mežmalas 32', 8, 520),
	(105980255, 100003470, 'Mežmalas 1', 8, 520),
	(105980263, 100003470, 'Mežmalas 2', 8, 520),
	(105980271, 100003470, 'Mežmalas 3', 8, 520),
	(105980288, 100003470, 'Mežmalas 4', 8, 520),
	(105980296, 100003470, 'Mežmalas 5', 8, 520),
	(105980302, 100003470, 'Mežmalas 6', 8, 520),
	(105980310, 100003470, 'Mežmalas 7', 8, 520),
	(105980327, 100003470, 'Mežmalas 8', 8, 520),
	(105980343, 100003470, 'Mežmalas 10', 8, 520),
	(105980351, 100003470, 'Mežmalas 11', 8, 520),
	(105980368, 100003470, 'Mežmalas 12', 8, 520),
	(105980376, 100003470, 'Mežmalas 13', 8, 520),
	(105980384, 100003470, 'Mežmalas 30', 8, 520),
	(105980392, 100003470, 'Mežmalas 14', 8, 520),
	(105980407, 100003470, 'Mežmalas 15', 8, 520),
	(105980415, 100003470, 'Mežmalas 16', 8, 520),
	(105980423, 100003470, 'Mežmalas 17', 8, 520),
	(105980448, 100003470, 'Mežmalas 19', 8, 520),
	(105980456, 100003470, 'Mežmalas 20', 8, 520),
	(105980464, 100003470, 'Mežmalas 21', 8, 520),
	(105980472, 100003470, 'Mežmalas 22', 8, 520),
	(105980480, 100003470, 'Mežmalas 23', 8, 520),
	(105980497, 100003470, 'Mežmalas 24', 8, 520),
	(105980511, 100003470, 'Mežmalas 27', 8, 520),
	(105980536, 100003470, 'Mežmalas 29', 8, 520),
	(105980544, 100003470, 'Mežmalas 26', 8, 520),
	(106684027, 100373702, 'Akmeņu 724C', 8, 520),
	(106946878, 100373696, 'Aizkraukles 721', 8, 520),
	(106989515, 100003470, 'Jaunbirziņi', 8, 520),
	(100011445, 100016534, 'Kalnciema pag.', 5, 0),
	(100011461, 100016534, 'Elejas pag.', 5, 0),
	(100011478, 100016534, 'Glūdas pag.', 5, 0),
	(100011486, 100016534, 'Jaunsvirlaukas pag.', 5, 0),
	(100011494, 100016534, 'Lielplatones pag.', 5, 0),
	(100011500, 100016534, 'Līvbērzes pag.', 5, 0),
	(100011517, 100016534, 'Ozolnieku pag.', 5, 0),
	(100011525, 100016534, 'Platones pag.', 5, 0),
	(100011533, 100016534, 'Sesavas pag.', 5, 0),
	(100011541, 100016534, 'Salgales pag.', 5, 0),
	(100011558, 100016534, 'Svētes pag.', 5, 0),
	(100011566, 100016534, 'Valgundes pag.', 5, 0),
	(100011574, 100016534, 'Vilces pag.', 5, 0),
	(100011582, 100016534, 'Vircavas pag.', 5, 0),
	(100011590, 100016534, 'Zaļenieku pag.', 5, 0),
	(100127675, 100011453, 'Jaunpēternieki', 5, 0),
	(100127683, 100011453, 'Dalbe', 5, 0),
	(100127691, 100011453, 'Cena', 5, 0),
	(100127706, 100011453, 'Āne', 5, 0),
	(100127714, 100011453, 'Brankas', 5, 0),
	(100127722, 100011453, 'Tetele', 5, 0),
	(100206763, 100011453, 'Raubēni', 5, 0),
	(100208404, 100011453, 'Iecēni', 5, 0),
	(100352615, 100011453, 'Atpūtas 7', 7, 0),
	(100352648, 100011453, 'Celtnieku 7', 7, 0),
	(100352664, 100011453, 'Dārza 7', 7, 0),
	(100352680, 100011453, 'Ezera 7', 7, 0),
	(100352703, 100011453, 'Jaunatnes 7', 7, 0),
	(100352865, 100011453, 'Smilšu 7', 7, 0),
	(100352881, 100011453, 'Sporta 7', 7, 0),
	(100419954, 100011453, 'Pļavu 7', 7, 0),
	(100419962, 100011453, 'Tirgoņu 7', 7, 0),
	(100419970, 100011453, 'Zīļu 7', 7, 0),
	(100419987, 100011453, 'Ziedoņa 7', 7, 0),
	(100428457, 100011453, 'Auto 7', 7, 0),
	(100447524, 100011453, 'Muižnieku 7', 7, 0),
	(100499533, 100011453, 'Mazā Celtnieku 7', 7, 0),
	(101536940, 100352615, 'Atpūtas 7 6', 8, 116),
	(101536957, 100352615, 'Atpūtas 7 7', 8, 116),
	(102243856, 100352615, 'Atpūtas 7 1', 8, 116),
	(102243864, 100352615, 'Atpūtas 7 11', 8, 116),
	(102243872, 100352615, 'Atpūtas 7 12', 8, 116),
	(102243880, 100352615, 'Atpūtas 7 13', 8, 116),
	(102243897, 100352615, 'Atpūtas 7 14', 8, 116),
	(102243903, 100352615, 'Atpūtas 7 16', 8, 116),
	(102243928, 100352615, 'Atpūtas 7 18', 8, 116),
	(102243936, 100352615, 'Atpūtas 7 19', 8, 116),
	(102243944, 100352615, 'Atpūtas 7 1A', 8, 116),
	(102243993, 100352615, 'Atpūtas 7 4', 8, 116),
	(102244005, 100352615, 'Atpūtas 7 5', 8, 116),
	(102244013, 100352615, 'Atpūtas 7 8', 8, 116),
	(102244021, 100352615, 'Atpūtas 7 9', 8, 116),
	(102682283, 100352615, 'Atpūtas 7 3', 8, 116),
	(102899578, 100352615, 'Atpūtas 7 2', 8, 116),
	(103579771, 100352615, 'Atpūtas 7 4A', 8, 116),
	(103580725, 100428457, 'Auto 7 1', 8, 116),
	(103580733, 100428457, 'Auto 7 2', 8, 116),
	(103580741, 100428457, 'Auto 7 3', 8, 116),
	(103580758, 100428457, 'Auto 7 5 k-1', 8, 116),
	(105401996, 100428457, 'Auto 7 5 k-2', 8, 116),
	(105402008, 100428457, 'Auto 7 5 k-3', 8, 116),
	(106853128, 100352615, 'Atpūtas 7 6A', 8, 116),
	(106853136, 100352615, 'Atpūtas 7 6B', 8, 116),
	(115512951, 102243856, 'Atpūtas 7 1 - 18', 9, 116),
	(115513350, 102243856, 'Atpūtas 7 1 - 3', 9, 116),
	(115514110, 102243856, 'Atpūtas 7 1 - 17', 9, 116),
	(115514633, 102243856, 'Atpūtas 7 1 - 6', 9, 116),
	(115516612, 102243856, 'Atpūtas 7 1 - 15', 9, 116),
	(115518134, 102243856, 'Atpūtas 7 1 - 10', 9, 116),
	(115518528, 102243856, 'Atpūtas 7 1 - 13', 9, 116),
	(115518800, 102243856, 'Atpūtas 7 1 - 16', 9, 116),
	(115520477, 102243856, 'Atpūtas 7 1 - 9', 9, 116),
	(115524812, 102243856, 'Atpūtas 7 1 - 12', 9, 116),
	(115524886, 102243856, 'Atpūtas 7 1 - 4', 9, 116),
	(115527971, 102243856, 'Atpūtas 7 1 - 20', 9, 116),
	(115529942, 102243856, 'Atpūtas 7 1 - 11', 9, 116),
	(115530270, 102243856, 'Atpūtas 7 1 - 1', 9, 116),
	(115532104, 102243856, 'Atpūtas 7 1 - 19', 9, 116),
	(115532731, 102243856, 'Atpūtas 7 1 - 2', 9, 116),
	(115532998, 102243856, 'Atpūtas 7 1 - 8', 9, 116),
	(115533188, 102243856, 'Atpūtas 7 1 - 5', 9, 116),
	(115534591, 102243856, 'Atpūtas 7 1 - 7', 9, 116),
	(115776362, 102243856, 'Atpūtas 7 1 - 14', 9, 116),
	(119361102, 103580733, 'Auto 7 2 - 1', 9, 116),
	(119361110, 103580733, 'Auto 7 2 - 2', 9, 116),
	(119364864, 103580725, 'Auto 7 1 - 1', 9, 116),
	(119364872, 103580725, 'Auto 7 1 - 2', 9, 116),
	(119364880, 103580725, 'Auto 7 1 - 3', 9, 116),
	(119364897, 103580725, 'Auto 7 1 - 4', 9, 116),
	(119364903, 103580725, 'Auto 7 1 - 5', 9, 116),
	(119364911, 103580725, 'Auto 7 1 - 6', 9, 116),
	(119364928, 103580725, 'Auto 7 1 - 7', 9, 116),
	(119364936, 103580725, 'Auto 7 1 - 8', 9, 116),
	(119364944, 103580725, 'Auto 7 1 - 9', 9, 116),
	(119364952, 103580725, 'Auto 7 1 - 10', 9, 116),
	(119364960, 103580725, 'Auto 7 1 - 11', 9, 116),
	(119364977, 103580725, 'Auto 7 1 - 12', 9, 116),
	(100015034, 100016542, 'Audriņu pag', 5, 0),
	(100016542, 100000000, 'Rēzeknes nov.', 2, 0),
	(100173021, 100015034, 'Audriņi', 6, 0),
	(100173038, 100015034, 'Asači', 6, 0),
	(100173046, 100015034, 'Aļhovka', 6, 0),
	(100380878, 100173021, 'Krasuhas iela', 7, 0),
	(100380886, 100173021, 'Lidicas iela', 7, 0),
	(100380894, 100173021, 'Piemiņas iela', 7, 0),
	(100380900, 100173021, 'Rēzeknes iela', 7, 0),
	(100380917, 100173021, 'Saules iela', 7, 0),
	(100427945, 100173021, 'Dārzu iela', 7, 0),
	(100499500, 100173021, 'Liepu aleja', 7, 0),
	(101328260, 100380886, 'Lidicas iela 16', 8, 440),
	(101328277, 100380886, 'Lidicas iela 3', 8, 440),
	(101328285, 100380886, 'Lidicas iela 5', 8, 440),
	(101328293, 100380886, 'Lidicas iela 8', 8, 440),
	(101328308, 100380886, 'Lidicas iela 9', 8, 440),
	(101328316, 100380894, 'Piemiņas iela 1', 8, 440),
	(101328324, 100380894, 'Piemiņas iela 10', 8, 440),
	(101328332, 100380894, 'Piemiņas iela 13', 8, 440),
	(101328340, 100380894, 'Piemiņas iela 17', 8, 440),
	(101328357, 100380894, 'Piemiņas iela 17A', 8, 440),
	(101328381, 100380894, 'Piemiņas iela 3', 8, 440),
	(101328398, 100380894, 'Piemiņas iela 8', 8, 440),
	(101328404, 100380917, 'Saules iela 1', 8, 440),
	(102139213, 100380878, 'Krasuhas iela 2', 8, 440),
	(102139221, 100380878, 'Krasuhas iela 2A', 8, 440),
	(102139238, 100380878, 'Krasuhas iela 4', 8, 440),
	(102139246, 100380886, 'Lidicas iela 1', 8, 440),
	(102139254, 100380886, 'Lidicas iela 10', 8, 440),
	(102139262, 100380886, 'Lidicas iela 11', 8, 440),
	(102139270, 100380886, 'Lidicas iela 14', 8, 440),
	(102139287, 100380886, 'Lidicas iela 1A', 8, 440),
	(102139295, 100380886, 'Lidicas iela 2', 8, 440),
	(102139301, 100380886, 'Lidicas iela 4', 8, 440),
	(102139318, 100380886, 'Lidicas iela 6', 8, 440),
	(102139326, 100380886, 'Lidicas iela 7', 8, 440),
	(102139334, 100380894, 'Piemiņas iela 12', 8, 440),
	(102139342, 100380894, 'Piemiņas iela 14', 8, 440),
	(102139350, 100380894, 'Piemiņas iela 16', 8, 440),
	(102139383, 100380894, 'Piemiņas iela 2', 8, 440),
	(102139463, 100380894, 'Piemiņas iela 5', 8, 440),
	(102139471, 100380894, 'Piemiņas iela 7', 8, 440),
	(102139488, 100380900, 'Rēzeknes iela 1', 8, 440),
	(102139496, 100380900, 'Rēzeknes iela 2', 8, 440),
	(102139502, 100380900, 'Rēzeknes iela 3', 8, 440),
	(102139510, 100380917, 'Saules iela 3', 8, 440),
	(102139527, 100380917, 'Saules iela 5', 8, 440),
	(102596325, 100380894, 'Piemiņas iela 11', 8, 440),
	(102621353, 100380900, 'Rēzeknes iela 4', 8, 440),
	(102680013, 100380886, 'Lidicas iela 13', 8, 440),
	(103169908, 100380894, 'Piemiņas iela 4', 8, 440),
	(103454018, 100427945, 'Dārzu iela 12', 8, 440),
	(103454050, 100173038, '"Smilšu kalns"', 8, 440),
	(103454067, 100173038, '"Kravcovu mājas"', 8, 440),
	(103454075, 100173038, '"Filipovka"', 8, 440),
	(103454091, 100173038, '"Asteres"', 8, 440),
	(103454106, 100173038, '"Ivuška"', 8, 440),
	(103454114, 100173046, '"Kārkliņi"', 8, 440),
	(103454862, 100173046, '"Matisiņš"', 8, 440),
	(103456070, 100380894, 'Piemiņas iela 15', 8, 440),
	(103456095, 100427945, 'Dārzu iela 1', 8, 440),
	(103456101, 100427945, 'Dārzu iela 5', 8, 440),
	(103456118, 100380886, 'Lidicas iela 15', 8, 440),
	(104239486, 100380886, 'Lidicas iela 12', 8, 440),
	(104239494, 100427945, 'Dārzu iela 3', 8, 440),
	(104239500, 100427945, 'Dārzu iela 4', 8, 440),
	(104239525, 100173038, '"Pūciņa"', 8, 440),
	(104239533, 100173038, '"Kristīne"', 8, 440),
	(104239541, 100173038, '"Ģimeņu viensēta"', 8, 440),
	(104239558, 100173038, '"Māliņi"', 8, 440),
	(104239566, 100173046, '"Aļhovka"', 8, 440),
	(105549746, 100380878, 'Krasuhas iela 1B', 8, 440),
	(105686613, 100380886, 'Lidicas iela 17', 8, 440),
	(105837698, 100380894, 'Piemiņas iela 9A', 8, 440),
	(105837704, 100499500, 'Liepu aleja 1', 8, 440),
	(105837712, 100380878, 'Krasuhas iela 3', 8, 440),
	(105837753, 100427945, 'Dārzu iela 2', 8, 440),
	(105837962, 100173046, '"Marina"', 8, 440),
	(106048760, 100380886, 'Lidicas iela 2B', 8, 440),
	(106048777, 100380894, 'Piemiņas iela 6', 8, 440),
	(106251597, 100380878, 'Krasuhas iela 1', 8, 440),
	(106434312, 100380886, 'Lidicas iela 16A', 8, 440),
	(106550615, 100380894, 'Piemiņas iela 9', 8, 440),
	(106705248, 100499500, 'Liepu aleja 2', 8, 440),
	(106705256, 100499500, 'Liepu aleja 6', 8, 440),
	(106705264, 100499500, 'Liepu aleja 4', 8, 440),
	(106705272, 100380917, 'Saules iela 2', 8, 440),
	(106718537, 100427945, 'Dārzu iela 12A', 8, 440),
	(106735135, 100173046, '"Saulīte"', 8, 440),
	(106869318, 100173046, '"Mazulīte"', 8, 440),
	(106875973, 100173046, '"Stirāni"', 8, 440),
	(106877300, 100173046, '"Višenka"', 8, 440),
	(106976781, 100380894, 'Piemiņas iela 2A', 8, 440),
	(106976798, 100380900, 'Rēzeknes iela 4A', 8, 440),
	(106976804, 100380900, 'Rēzeknes iela 3A', 8, 440),
	(106976812, 100380900, 'Rēzeknes iela 2A', 8, 440),
	(106976820, 100380900, 'Rēzeknes iela 1A', 8, 440),
	(106985604, 100380878, 'Krasuhas iela 6', 8, 440),
	(106985612, 100380878, 'Krasuhas iela 6A', 8, 440),
	(106987624, 100173046, '"Samtenes"', 8, 440),
	(107006493, 100427945, 'Dārzu iela 2A', 8, 440),
	(107011421, 100173046, '"Vispa"', 8, 440),
	(107012118, 100173046, '"Alkšņi"', 8, 440),
	(107013642, 100173038, '"Skujiņas"', 8, 440),
	(100319063, 100003028, '1. līnija', 7, 0),
	(100319071, 100003028, '2. līnija', 7, 0),
	(101151153, 100319063, ' 4B', 8, 97),
	(101151161, 100319063, ' 4C', 8, 97),
	(101151178, 100319063, ' 4D', 8, 97),
	(101151186, 100319063, ' 4E', 8, 97),
	(101154134, 100319063, ' 4A', 8, 97),
	(101751076, 101751076, '11', 8, 97),
	(101751084, 100319063, '2', 8, 97),
	(101751092, 100319063, '3', 8, 97),
	(101751107, 100319063, '4', 8, 97),
	(101751115, 100319063, '5', 8, 97),
	(101751123, 100319063, '7', 8, 97),
	(101751131, 100319063, ' 7A', 8, 97),
	(101751148, 101751148, '1', 8, 95),
	(101751228, 106261534, '2', 8, 95),
	(101751260, 104001545, '7', 8, 95),
	(101751277, 104001545, ' 7A', 8, 95),
	(101751285, 104001545, '9', 8, 95),
	(102493948, 102493948, '13', 8, 97),
	(102493956, 100319063, ' 2A', 8, 97),
	(102493964, 100319063, '6', 8, 97),
	(102493972, 105328138, '9', 8, 97),
	(102493980, 104001545, '10', 8, 95),
	(102494000, 106261534, '3', 8, 95),
	(102687821, 104001545, '8', 8, 95),
	(103049300, 105328138, ' 9A', 8, 97),
	(104001537, 106261534, ' 3A', 8, 95),
	(104001545, 104001545, ' 3B', 8, 95),
	(104378791, 100319063, ' 3A', 8, 97),
	(104378806, 106261534, ' 2A', 8, 95),
	(104389097, 100319063, ' 4F', 8, 97),
	(104486644, 100319063, ' 4G', 8, 97),
	(104689760, 106261534, ' 2B', 8, 95),
	(104689777, 106261534, ' 2C', 8, 95),
	(104689785, 106261534, ' 2D', 8, 95),
	(104689793, 106261534, ' 2E', 8, 95),
	(104689808, 106261534, ' 2F', 8, 95),
	(104689816, 106261534, ' 2G', 8, 95),
	(104689824, 106261534, ' 2H', 8, 95),
	(104689832, 106261534, ' 2I', 8, 95),
	(104689840, 106261534, ' 2J', 8, 95),
	(104967113, 105328138, ' 9B', 8, 97),
	(104967121, 105328138, ' 9C', 8, 97),
	(104967138, 105328138, ' 9D', 8, 97),
	(104967154, 105328138, ' 9F', 8, 97),
	(104967162, 105328138, ' 9G', 8, 97),
	(104967170, 105328138, ' 9H', 8, 97),
	(104967187, 104967187, ' 9I', 8, 97),
	(104967195, 104967195, ' 9J', 8, 97),
	(104967201, 104967201, ' 9K', 8, 97),
	(104967218, 104967218, ' 9L', 8, 97),
	(105018716, 104001545, ' 8A', 8, 95),
	(105018724, 104001545, ' 8B', 8, 95),
	(105018732, 104001545, ' 8C', 8, 95),
	(105018740, 104001545, ' 8D', 8, 95),
	(105018757, 104001545, ' 8E', 8, 95),
	(105018765, 104001545, ' 8F', 8, 95),
	(105018773, 104001545, ' 8G', 8, 95),
	(105018781, 104001545, ' 8H', 8, 95),
	(105018798, 104001545, ' 8I', 8, 95),
	(105018804, 104001545, ' 8J', 8, 95),
	(105196813, 105328138, ' 7N', 8, 97),
	(105196821, 105328138, ' 7O', 8, 97),
	(105196838, 105328138, ' 7P', 8, 97),
	(105196846, 105328138, ' 7R', 8, 97),
	(105196854, 105328138, ' 7S', 8, 97),
	(105196862, 105328138, ' 7T', 8, 97),
	(105196870, 105328138, ' 7U', 8, 97),
	(105196887, 105328138, ' 7V', 8, 97),
	(105196895, 105196895, ' 9Z', 8, 97),
	(105196901, 105196901, ' 9V', 8, 97),
	(105196918, 105196918, ' 9U', 8, 97),
	(105196926, 105196926, ' 9T', 8, 97),
	(105196934, 105196934, ' 9S', 8, 97),
	(105196942, 105196942, ' 9R', 8, 97),
	(105196950, 105196950, ' 9P', 8, 97),
	(105196967, 105196967, ' 9O', 8, 97),
	(105196975, 105196975, ' 9N', 8, 97),
	(105196983, 105196983, ' 9M', 8, 97),
	(105197300, 105328138, ' 7Z', 8, 97),
	(105218618, 105328138, ' 7M', 8, 97),
	(105328121, 100319063, ' 5A', 8, 97),
	(105328138, 105328138, ' 7B', 8, 97),
	(105382842, 104001545, ' 3C', 8, 95),
	(105398550, 100319063, ' 5B', 8, 97),
	(105398567, 100319063, ' 5C', 8, 97),
	(105446075, 106261534, ' 2K', 8, 95),
	(105523280, 100319063, ' 4I', 8, 97),
	(105587737, 100319063, ' 5D', 8, 97),
	(106166794, 104001545, ' 7B', 8, 95),
	(106166800, 106261534, ' 1C', 8, 95),
	(106166817, 106261534, ' 1B', 8, 95),
	(106180338, 104001545, ' 9A', 8, 95),
	(106261534, 106261534, ' 1A', 8, 95),
	(106620294, 104001545, ' 7C', 8, 95),
	(106870554, 106870554, '15', 8, 97),
	(106870562, 106870562, '17', 8, 97),
	(106870570, 106870570, '19', 8, 97),
	(106870587, 106870587, '21', 8, 97),
	(106870595, 106870595, '23', 8, 97),
	(106870601, 106870595, '25', 8, 97),
	(107008745, 106261534, ' 2L', 8, 95),
	(107008753, 106261534, ' 2M', 8, 95),
	(100000000, 100000000, '1', 1, 0),
	(100011445, 100016534, '5', 5, 0),
	(100011453, 100016534, '5', 5, 0),
	(100011461, 100016534, '5', 5, 0),
	(100011478, 100016534, '5', 5, 0),
	(100011486, 100016534, '5', 5, 0),
	(100011494, 100016534, '5', 5, 0),
	(100011500, 100016534, '5', 5, 0),
	(100011517, 100016534, '5', 5, 0),
	(100011525, 100016534, '5', 5, 0),
	(100011533, 100016534, '5', 5, 0),
	(100011541, 100016534, '5', 5, 0),
	(100011558, 100016534, '5', 5, 0),
	(100011566, 100016534, '5', 5, 0),
	(100011574, 100016534, '5', 5, 0),
	(100011582, 100016534, '5', 5, 0),
	(100011590, 100016534, '5', 5, 0),
	(100016534, 100000000, '2', 2, 0),
	(100127675, 100011453, '5', 6, 0),
	(100127683, 100011453, '5', 6, 0),
	(100127691, 100011453, '5', 6, 0),
	(100127706, 100011453, '5', 6, 0),
	(100127714, 100011453, '5', 6, 0),
	(100127722, 100011453, '5', 6, 0),
	(100206763, 100011453, '5', 6, 0),
	(100208404, 100011453, '5', 6, 0),
	(100352615, 100011453, '7', 7, 0),
	(100352648, 100011453, '7', 7, 0),
	(100352664, 100011453, '7', 7, 0),
	(100352680, 100011453, '7', 7, 0),
	(100352703, 100011453, '7', 7, 0),
	(100352865, 100011453, '7', 7, 0),
	(100352881, 100011453, '7', 7, 0),
	(100419954, 100011453, '7', 7, 0),
	(100419962, 100011453, '7', 7, 0),
	(100419970, 100011453, '7', 7, 0),
	(100419987, 100011453, '7', 7, 0),
	(100428457, 100011453, '7', 7, 0),
	(100447524, 100011453, '7', 7, 0),
	(100499533, 100011453, '7', 7, 0),
	(101536940, 100352615, '8', 8, 116),
	(101536957, 100352615, '8', 8, 116),
	(102243856, 100352615, '8', 8, 116),
	(102243864, 100352615, '8', 8, 116),
	(102243872, 100352615, '8', 8, 116),
	(102243880, 100352615, '8', 8, 116),
	(102243897, 100352615, '8', 8, 116),
	(102243903, 100352615, '8', 8, 116),
	(102243928, 100352615, '8', 8, 116),
	(102243936, 100352615, '8', 8, 116),
	(102243944, 100352615, '8', 8, 116),
	(102243993, 100352615, '8', 8, 116),
	(102244005, 100352615, '8', 8, 116),
	(102244013, 100352615, '8', 8, 116),
	(102244021, 100352615, '8', 8, 116),
	(102682283, 100352615, '8', 8, 116),
	(102899578, 100352615, '8', 8, 116),
	(103579771, 100352615, '8', 8, 116),
	(103580725, 100428457, '8', 8, 116),
	(103580733, 100428457, '8', 8, 116),
	(103580741, 100428457, '8', 8, 116),
	(103580758, 100428457, '8', 8, 116),
	(105401996, 100428457, '8', 8, 116),
	(105402008, 100428457, '8', 8, 116),
	(106853128, 100352615, '8', 8, 116),
	(106853136, 100352615, '8', 8, 116),
	(115512951, 102243856, '9', 8, 116),
	(115513350, 102243856, '9', 8, 116),
	(115514110, 102243856, '9', 8, 116),
	(115514633, 102243856, '9', 8, 116),
	(115516612, 102243856, '9', 8, 116),
	(115518134, 102243856, '9', 8, 116),
	(115518528, 102243856, '9', 8, 116),
	(115518800, 102243856, '9', 8, 116),
	(115520477, 102243856, '9', 8, 116),
	(115524812, 102243856, '9', 8, 116),
	(115524886, 102243856, '9', 8, 116),
	(115527971, 102243856, '9', 8, 116),
	(115529942, 102243856, '9', 8, 116),
	(115530270, 102243856, '9', 8, 116),
	(115532104, 102243856, '9', 8, 116),
	(115532731, 102243856, '9', 8, 116),
	(115532998, 102243856, '9', 8, 116),
	(115533188, 102243856, '9', 8, 116),
	(115534591, 102243856, '9', 8, 116),
	(115776362, 102243856, '9', 8, 116),
	(119361102, 103580733, '9', 8, 116),
	(119361110, 103580733, '9', 8, 116),
	(119364864, 103580725, '9', 8, 116),
	(119364872, 103580725, '9', 8, 116),
	(119364880, 103580725, '9', 8, 116),
	(119364897, 103580725, '9', 8, 116),
	(119364903, 103580725, '9', 8, 116),
	(119364911, 103580725, '9', 8, 116),
	(119364928, 103580725, '9', 8, 116),
	(119364936, 103580725, '9', 8, 116),
	(119364944, 103580725, '9', 8, 116),
	(119364952, 103580725, '9', 8, 116),
	(119364960, 103580725, '9', 8, 116),
	(119364977, 103580725, '9', 8, 116),
	(100014811, 100016487, 'Taurenes', 5, 0),
	(100016487, 100000001, 'Cēsu', 2, 0),
	(100115894, 100014811, 'Taurene', 6, 0),
	(100347010, 100014811, 'Brežģa iela', 7, 0),
	(100347027, 100014811, 'Ezera iela', 7, 0),
	(100347035, 100014811, 'Gaujas iela', 7, 0),
	(100347043, 100014811, 'Krasta iela', 7, 0),
	(100347051, 100014811, 'Meža iela', 7, 0),
	(100347068, 100014811, 'Parka iela', 7, 0),
	(100347076, 100014811, 'Vecpiebalgas iela', 7, 0),
	(102308886, 100347010, '2', 8, 335),
	(102308894, 100347010, '3', 8, 335),
	(102308900, 100347010, '5', 8, 335),
	(102308917, 100347010, '6', 8, 335),
	(102308925, 100347010, '8', 8, 335),
	(102308933, 100347027, '2', 8, 335),
	(102308941, 100347027, '4', 8, 335),
	(102308958, 100347035, '1', 8, 335),
	(102308966, 100347035, '3', 8, 335),
	(102308974, 100347035, '4', 8, 335),
	(102308982, 100347035, '5', 8, 335),
	(102308990, 100347043, '1', 8, 335),
	(102309002, 100347043, '11', 8, 335),
	(102309010, 100347043, '13', 8, 335),
	(102309027, 100347043, '17', 8, 335),
	(102309035, 100347043, '19', 8, 335),
	(102309043, 100347043, '3', 8, 335),
	(102309051, 100347043, '5', 8, 335),
	(102309068, 100347043, '7', 8, 335),
	(102309076, 100347043, '9', 8, 335),
	(102309084, 100347051, '1', 8, 335),
	(102309092, 100347051, '11', 8, 335),
	(102309107, 100347051, '5', 8, 335),
	(102309115, 100347051, '7', 8, 335),
	(102309123, 100347051, '9', 8, 335),
	(102309131, 100347068, '1', 8, 335),
	(102309148, 100347068, '10', 8, 335),
	(102309156, 100347068, '12', 8, 335),
	(102309164, 100347068, '2', 8, 335),
	(102309172, 100347068, '3', 8, 335),
	(102309180, 100347068, '4', 8, 335),
	(102309197, 100347068, '5', 8, 335),
	(102309203, 100347068, '6', 8, 335),
	(102309211, 100347068, '7', 8, 335),
	(102309228, 100347068, '8', 8, 335),
	(102309236, 100347076, '2', 8, 335),
	(102309244, 100347076, '4', 8, 335),
	(102309252, 100347076, '6', 8, 335),
	(102625738, 100347051, '3', 8, 335),
	(102683791, 100347010, '4', 8, 335),
	(102862331, 100014811, 'Kalēji', 8, 335),
	(102862348, 100014811, 'Siltumnīcas', 8, 335),
	(102862364, 100014811, 'Tožas', 8, 335),
	(102862372, 100014811, 'Uguntiņas', 8, 335),
	(102862380, 100014811, 'Lazdiņi', 8, 335),
	(102862411, 100014811, 'Dzirnavas 1', 8, 335),
	(102862428, 100014811, 'Dzirnavas 2', 8, 335),
	(102862452, 100014811, 'Jaunmelderi', 8, 335),
	(102862477, 100014811, 'Ceriņi', 8, 335),
	(102862532, 100014811, 'Upītes', 8, 335),
	(102862557, 100014811, 'Jauntoži', 8, 335),
	(102862565, 100014811, 'Druvas', 8, 335),
	(102862598, 100014811, 'Imantas', 8, 335),
	(102862604, 100014811, 'Bitītes', 8, 335),
	(102862612, 100014811, 'Viesturi', 8, 335),
	(102862637, 100014811, 'Pekas', 8, 335),
	(102862645, 100014811, 'Vizbuļi', 8, 335),
	(102862653, 100014811, 'Gaiduļi', 8, 335),
	(102862678, 100014811, 'Birznieki', 8, 335),
	(102862862, 100014811, 'Nēķins 1', 8, 335),
	(102862870, 100014811, 'Nēķins 2', 8, 335),
	(102862887, 100014811, 'Nēķins', 8, 335),
	(102862901, 100014811, 'Ceļinieki', 8, 335),
	(102862918, 100014811, 'Ielaiņi', 8, 335),
	(102862934, 100014811, 'Biezēkas', 8, 335),
	(102862942, 100014811, 'Vecbiezēkas', 8, 335),
	(102862950, 100014811, 'Siliņi', 8, 335),
	(102862967, 100014811, 'Tālītes', 8, 335),
	(102862975, 100014811, 'Ziediņi', 8, 335),
	(102862983, 100014811, 'Rīti', 8, 335),
	(102862991, 100014811, 'Brīvzemnieki', 8, 335),
	(102863011, 100014811, 'Auseklīši', 8, 335),
	(102863028, 100014811, 'Runtes', 8, 335),
	(102863036, 100014811, 'Veclejas Runtes', 8, 335),
	(102863044, 100014811, 'Lejas Staiņi', 8, 335),
	(102863052, 100014811, 'Lodes Muiža', 8, 335),
	(102863060, 100014811, 'Liepkalni', 8, 335),
	(102863077, 100014811, 'Jaunkrasti', 8, 335),
	(102863085, 100014811, 'Rogas', 8, 335),
	(102863093, 100014811, 'Ezermājiņa', 8, 335),
	(102863108, 100014811, 'Vecžuburi', 8, 335),
	(102863116, 100014811, 'Kalna Žuburi', 8, 335),
	(102863124, 100014811, 'Zaļkalns', 8, 335),
	(102863132, 100014811, 'Stemiķi', 8, 335),
	(102863140, 100014811, 'Ezerkalni', 8, 335),
	(102863157, 100014811, 'Vidus Ramdoti', 8, 335),
	(102863173, 100014811, 'Kalna Ramdoti', 8, 335),
	(102863181, 100014811, 'Aprāni', 8, 335),
	(102863198, 100014811, 'Vidus Aprāni', 8, 335),
	(102863237, 100014811, 'Jaunaprāni', 8, 335),
	(102863261, 100014811, 'Brežģis', 8, 335),
	(102863286, 100014811, 'Egļupes', 8, 335),
	(102863300, 100014811, 'Atpūtas', 8, 335),
	(102863341, 100014811, 'Brežģa Pienotava', 8, 335),
	(102863382, 100014811, 'Vecvīdokšas', 8, 335),
	(102863413, 100014811, 'Vidus Vīdokšas', 8, 335),
	(102863438, 100014811, 'Jaunvīdokšas', 8, 335),
	(102863446, 100014811, 'Ļūdi', 8, 335),
	(102863454, 100014811, 'Kalna Ļūdi', 8, 335),
	(102863462, 100014811, 'Vidus Ļūdi', 8, 335),
	(102863470, 100014811, 'Lejas Ļūdi', 8, 335),
	(102863487, 100014811, 'Gailīši', 8, 335),
	(102863495, 100014811, 'Veclejas Gailīši', 8, 335),
	(102863526, 100014811, 'Lejas Jaungailīši', 8, 335),
	(102864825, 100014811, 'Purmaļi', 8, 335),
	(102864833, 100014811, 'Strautiņi', 8, 335),
	(102864841, 100014811, 'Mežvijas', 8, 335),
	(102864866, 100014811, 'Taurenes', 8, 335),
	(102864882, 100014811, 'Baložkalns', 8, 335),
	(102865111, 100014811, 'Brīvlauki', 8, 335),
	(102865152, 100014811, 'Sauleskalns', 8, 335),
	(102865177, 100014811, 'Bānūži', 8, 335),
	(102865185, 100014811, 'Bānūžu Birznieki', 8, 335),
	(102865193, 100014811, 'Krustiņi', 8, 335),
	(102865232, 100014811, 'Stirnas', 8, 335),
	(102865466, 100014811, 'Cukuri', 8, 335),
	(102865554, 100014811, 'Klētnieki', 8, 335),
	(102865562, 100014811, 'Dravnieki', 8, 335),
	(102865587, 100014811, 'Atoliņi', 8, 335),
	(102865601, 100014811, 'Elkšņi', 8, 335),
	(102865618, 100014811, 'Kalna Robežnieki', 8, 335),
	(102865626, 100014811, 'Priežkalns', 8, 335),
	(102865747, 100014811, 'Mazstintes', 8, 335),
	(102865755, 100014811, 'Stintes', 8, 335),
	(102865763, 100014811, 'Jaunstintes', 8, 335),
	(102865771, 100014811, 'Cieļi', 8, 335),
	(102865788, 100014811, 'Lejas Zemītes', 8, 335),
	(102865796, 100014811, 'Pidriķēni', 8, 335),
	(102865802, 100014811, 'Zemītes', 8, 335),
	(102865810, 100014811, 'Jaunromas', 8, 335),
	(102865827, 100014811, 'Jaunlībieši', 8, 335),
	(102865835, 100014811, 'Lejas Ozoli', 8, 335),
	(102865843, 100014811, 'Kalna Ozoli', 8, 335),
	(102865851, 100014811, 'Krastkalni', 8, 335),
	(102865868, 100014811, 'Stūriņi', 8, 335),
	(102865876, 100014811, 'Tuci', 8, 335),
	(102865884, 100014811, 'Lībieši', 8, 335),
	(102865907, 100014811, 'Lejas Kurmi', 8, 335),
	(102865915, 100014811, 'Kalna Kurmi', 8, 335),
	(102865923, 100014811, 'Kriķēni', 8, 335),
	(102865931, 100014811, 'Akmentiņi', 8, 335),
	(102865948, 100014811, 'Ezeriņi', 8, 335),
	(102865956, 100014811, 'Apši', 8, 335),
	(102865964, 100014811, 'Lodes Skola', 8, 335),
	(102865980, 100014811, 'Lejas Kauliņi', 8, 335),
	(102866025, 100014811, 'Vidus Kauliņi', 8, 335),
	(102866033, 100014811, 'Ausekļi', 8, 335),
	(102866041, 100014811, 'Vilcēni', 8, 335),
	(102866058, 100014811, 'Jāņkalni', 8, 335),
	(102866082, 100014811, 'Sostes', 8, 335),
	(102866113, 100014811, 'Kalnieši', 8, 335),
	(102866138, 100014811, 'Ķīši', 8, 335),
	(102866146, 100014811, 'Cīruļkalns', 8, 335),
	(102866195, 100014811, 'Lodes Dzirnavas', 8, 335),
	(102866267, 100014811, 'Jaņi', 8, 335),
	(102866291, 100014811, 'Stupēni', 8, 335),
	(102866322, 100014811, 'Jaunbrēdiķi', 8, 335),
	(102866371, 100014811, 'Vecbrēdiķi', 8, 335),
	(102866402, 100014811, 'Baltiņi', 8, 335),
	(102866435, 100014811, 'Jaunkalnlejstupi', 8, 335),
	(102866451, 100014811, 'Lejstupi', 8, 335),
	(102866548, 100014811, 'Kalna Dabari', 8, 335),
	(102866572, 100014811, 'Dabari', 8, 335),
	(102866580, 100014811, 'Veclejas Dabari', 8, 335),
	(102866611, 100014811, 'Jaunlejas Dabari', 8, 335),
	(102866628, 100014811, 'Gravas', 8, 335),
	(102866636, 100014811, 'Ķiguņi', 8, 335),
	(102866644, 100014811, 'Grāvnieki', 8, 335),
	(102866660, 100014811, 'Kāmeni', 8, 335),
	(102866677, 100014811, 'Vecbaltiņi', 8, 335),
	(102866685, 100014811, 'Jaunbaltiņi', 8, 335),
	(102866693, 100014811, 'Kalna Cimbuļi', 8, 335),
	(102866708, 100014811, 'Ķīres', 8, 335),
	(102866716, 100014811, 'Liepiņas', 8, 335),
	(102866724, 100014811, 'Apiņi', 8, 335),
	(102866732, 100014811, 'Jāņkalns', 8, 335),
	(102866740, 100014811, 'Dzintari', 8, 335),
	(102866757, 100014811, 'Bērcēni', 8, 335),
	(102866765, 100014811, 'Gundegas', 8, 335),
	(102866773, 100014811, 'Rūķīši', 8, 335),
	(102866781, 100014811, 'Robežnieki', 8, 335),
	(102866798, 100014811, 'Lāčplēši', 8, 335),
	(102866804, 100014811, 'Purgaļi', 8, 335),
	(102866812, 100014811, 'Lejas Purgaļi', 8, 335),
	(102866820, 100014811, 'Palmēni', 8, 335),
	(102866837, 100014811, 'Kalniņi', 8, 335),
	(102866886, 100014811, 'Sīļi', 8, 335),
	(102866894, 100014811, 'Upmaļi', 8, 335),
	(102866900, 100014811, 'Avotiņi', 8, 335),
	(102866917, 100014811, 'Jaunozoli', 8, 335),
	(102866925, 100014811, 'Ozoli', 8, 335),
	(102866933, 100014811, 'Tauriņi', 8, 335),
	(102866941, 100014811, 'Urbiņi', 8, 335),
	(102866958, 100014811, 'Tēmiņkalns', 8, 335),
	(102866966, 100014811, 'Kalna Lipši', 8, 335),
	(102866974, 100014811, 'Jaunlipši', 8, 335),
	(102866982, 100014811, 'Veclipši', 8, 335),
	(102866990, 100014811, 'Katriņkalns', 8, 335),
	(102867002, 100014811, 'Rijnieki', 8, 335),
	(102867010, 100014811, 'Ķieģeļkalns', 8, 335),
	(102867027, 100014811, 'Mežjēči', 8, 335),
	(102867035, 100014811, 'Silnieki', 8, 335),
	(102867043, 100014811, 'Mazbērziņi', 8, 335),
	(102867051, 100014811, 'Kalna Bērziņi', 8, 335),
	(102867068, 100014811, 'Jaunbērziņi', 8, 335),
	(102867308, 100014811, 'Lejas Bērziņi', 8, 335),
	(102867316, 100014811, 'Skrandi', 8, 335),
	(102867324, 100014811, 'Kļavkrusti', 8, 335),
	(102867332, 100014811, 'Strautmaļi', 8, 335),
	(102867340, 100014811, 'Jērūži', 8, 335),
	(102867357, 100014811, 'Vecjērūži', 8, 335),
	(102867373, 100014811, 'Jaungulbji', 8, 335),
	(102867381, 100014811, 'Pļavas', 8, 335),
	(102867398, 100014811, 'Velves', 8, 335),
	(102867404, 100014811, 'RSU sporta bāze', 8, 335),
	(102867412, 100014811, 'Eglāji', 8, 335),
	(102867420, 100014811, 'Ādmiņi', 8, 335),
	(102867437, 100014811, 'Kārkliņi', 8, 335),
	(102867445, 100014811, 'Pīkaņi', 8, 335),
	(102867453, 100014811, 'Ūdensrozes', 8, 335),
	(102867478, 100014811, 'Lāsīte', 8, 335),
	(102867500, 100014811, 'Irbītes', 8, 335),
	(102867517, 100014811, 'Zelleskalns', 8, 335),
	(102867695, 100014811, 'Lejas Bebri', 8, 335),
	(102867718, 100014811, 'Bebri', 8, 335),
	(102867734, 100014811, 'Vidus Bebri', 8, 335),
	(102867767, 100014811, 'Kalna Bebri', 8, 335),
	(102867783, 100014811, 'Kūlaskalns', 8, 335),
	(102867814, 100014811, 'Vidus Gambas', 8, 335),
	(102867822, 100014811, 'Kalna Gambas', 8, 335),
	(102867847, 100014811, 'Kalna Ielaiņi', 8, 335),
	(102867863, 100014811, 'Kalna Laidzi', 8, 335),
	(102867896, 100014811, 'Jaunlaidzi', 8, 335),
	(102867943, 100014811, 'Kalna Jaungailīši', 8, 335),
	(102867951, 100014811, 'Teikmaņi', 8, 335),
	(102867984, 100014811, 'Jaunandrēni', 8, 335),
	(102868004, 100014811, 'Kalna Andrēni', 8, 335),
	(102868020, 100014811, 'Miķēni', 8, 335),
	(102868045, 100014811, 'Vecmiķēni', 8, 335),
	(102868213, 100014811, 'Kampas', 8, 335),
	(102868221, 100014811, 'Arāji', 8, 335),
	(102868238, 100014811, 'Labieši', 8, 335),
	(102868246, 100014811, 'Dekšņi', 8, 335),
	(102868254, 100014811, 'Svelmes', 8, 335),
	(102868262, 100014811, 'Kaplāni', 8, 335),
	(102868270, 100014811, 'Jaunķeizari', 8, 335),
	(102868287, 100014811, 'Kalna Ķeizari', 8, 335),
	(102868295, 100014811, 'Ābeļkalns', 8, 335),
	(102868301, 100014811, 'Oliņi', 8, 335),
	(102868318, 100014811, 'Dravas', 8, 335),
	(102868326, 100014811, 'Naudēļi', 8, 335),
	(102868334, 100014811, 'Zariņi', 8, 335),
	(102868342, 100014811, 'Baloži', 8, 335),
	(102868350, 100014811, 'Taurkalns', 8, 335),
	(102868367, 100014811, 'Nesaulītes', 8, 335),
	(102868375, 100014811, 'Ābelītes', 8, 335),
	(102868383, 100014811, 'Spuļģi', 8, 335),
	(102868391, 100014811, 'Vītoliņi', 8, 335),
	(102868406, 100014811, 'Kāroni', 8, 335),
	(102868414, 100014811, 'Ķekavas', 8, 335),
	(102868422, 100014811, 'Pumpuri', 8, 335),
	(102868430, 100014811, 'Ieviņas', 8, 335),
	(102868447, 100014811, 'Ievkalni', 8, 335),
	(102868455, 100014811, 'Mežandrēni', 8, 335),
	(102868760, 100347043, '2', 8, 335),
	(102868777, 100347043, '15', 8, 335),
	(105012545, 100014811, 'Būvkonstrukcija', 8, 335),
	(105012553, 100014811, 'Cieres', 8, 335),
	(105012561, 100014811, 'Dadzis', 8, 335),
	(105012578, 100014811, 'Dimanti', 8, 335),
	(105012586, 100014811, 'Dispečeri', 8, 335),
	(105012625, 100014811, 'Nēķina muiža', 8, 335),
	(105012633, 100014811, 'Ratnieki', 8, 335),
	(105012641, 100014811, 'Rudiņi', 8, 335),
	(105012658, 100014811, 'Senkrasti', 8, 335),
	(105013467, 100014811, 'Lodes Apšu baznīca', 8, 335),
	(105013475, 100014811, 'Ilzēni', 8, 335),
	(105013483, 100014811, 'Lauras', 8, 335),
	(105013491, 100014811, 'Lejas Andrēni', 8, 335),
	(105013514, 100014811, 'Piekalnes', 8, 335),
	(105013731, 100014811, 'Bānūžu Viesturi', 8, 335),
	(105013811, 100014811, 'Zāles', 8, 335),
	(105013828, 100014811, 'Vidus Staiņi', 8, 335),
	(105013836, 100014811, 'Vējkalni', 8, 335),
	(105013844, 100014811, 'Veispāli', 8, 335),
	(105013852, 100014811, 'Vecpurmaļi', 8, 335),
	(105013860, 100014811, 'Vecmuiža', 8, 335),
	(105013877, 100014811, 'Vecmežrijas', 8, 335),
	(105013885, 100014811, 'Senkalni', 8, 335),
	(105013924, 100014811, 'Jaunzemes', 8, 335),
	(105013932, 100014811, 'Kalna Staiņi', 8, 335),
	(105013940, 100014811, 'Ķīru ferma', 8, 335),
	(105013957, 100014811, 'Lejas Ramdoti', 8, 335),
	(105013965, 100014811, 'Lejas Laidzi', 8, 335),
	(105013973, 100014811, 'Lejas Lejstupi', 8, 335),
	(105013998, 100014811, 'Miķeļi', 8, 335),
	(105014001, 100014811, 'Rozas', 8, 335),
	(105014018, 100014811, 'Sarmas', 8, 335),
	(105014034, 100014811, 'Meijas', 8, 335),
	(105723270, 100014811, 'Strazdiņi', 8, 335),
	(105762503, 100014811, 'Angārs', 8, 335),
	(105762511, 100014811, 'Angāri', 8, 335),
	(105762616, 100014811, 'Attīrīšanas iekārtas', 8, 335),
	(105762624, 100014811, 'Apses', 8, 335),
	(105762632, 100014811, 'Atvari', 8, 335),
	(105762640, 100014811, 'Autobusu pietura', 8, 335),
	(105762657, 100014811, 'SLTP 2615 Taurene', 8, 335),
	(105762665, 100014811, 'Centra ūdenstornis', 8, 335),
	(105762890, 100014811, 'Cimbulīši', 8, 335),
	(105762905, 100014811, 'DUS Nēķins', 8, 335),
	(105762987, 100014811, 'Centrs', 8, 335),
	(105763064, 100014811, 'Kārļavoti', 8, 335),
	(105763072, 100014811, 'Pagrabi', 8, 335),
	(105763080, 100014811, 'Muižas klēts', 8, 335),
	(105763097, 100014811, 'Upmalas', 8, 335),
	(105763103, 100014811, 'Pandera Šķūnis', 8, 335),
	(105763111, 100014811, 'Katlu māja', 8, 335),
	(105763128, 100014811, 'Kalna Roma', 8, 335),
	(105763144, 100014811, 'Lejas Zeltiņi', 8, 335),
	(105763152, 100014811, 'Nēķina muižas kūts', 8, 335),
	(105763193, 100014811, 'SLTP 2715 Kalna Romas', 8, 335),
	(105763208, 100014811, 'SLTP 2762 Kalna Viesturi', 8, 335),
	(105763232, 100014811, 'SLTP 2742 Kalna Kalēji', 8, 335),
	(105763240, 100014811, 'Sudrabi', 8, 335),
	(105763257, 100014811, 'TOTO', 8, 335),
	(105763265, 100014811, 'TOTO Agro', 8, 335),
	(105763298, 100014811, 'Gaujaskrasts', 8, 335),
	(105765621, 100014811, 'Namiņi', 8, 335),
	(105765742, 100014811, 'Ķīru ūdenstornis', 8, 335),
	(105765791, 100014811, 'Ķīru fermas šķūnis', 8, 335),
	(105765814, 100014811, 'Meža Bānūži', 8, 335),
	(105765855, 100014811, 'Dārznieki', 8, 335),
	(105765888, 100014811, 'Avotkalni', 8, 335),
	(105766004, 100014811, 'Lībiešu ferma', 8, 335),
	(105766078, 100014811, 'Lejas Pekšēni', 8, 335),
	(105766086, 100014811, 'Brāļi', 8, 335),
	(105766117, 100014811, 'Apšu kapliča', 8, 335),
	(105766174, 100014811, 'Niedrāji', 8, 335),
	(105766656, 100014811, 'Vecbrežģis', 8, 335),
	(105766664, 100014811, 'LMT Sakari', 8, 335),
	(105766865, 100014811, 'Apaļais šķūnis', 8, 335),
	(105766881, 100014811, 'Lodītes', 8, 335),
	(105766994, 100014811, 'Kalna Urbiņi', 8, 335),
	(105767231, 100014811, 'Ezermalas', 8, 335),
	(105767256, 100014811, 'Kalna Miķeļi', 8, 335),
	(105767264, 100014811, 'Mierturu šķūnis', 8, 335),
	(105767280, 100014811, 'SLTP 2778 Kalna Ķīres', 8, 335),
	(105767297, 100014811, 'Vecaprāni', 8, 335),
	(105871497, 100014811, 'Andrupi', 8, 335),
	(106315182, 100014811, 'Taureņi', 8, 335),
	(106576463, 100014811, 'Jauntētītes', 8, 335),
	(106581014, 100014811, 'Koģenerācijas stacija', 8, 335),
	(106710885, 100014811, 'Podziņas', 8, 335),
	(106726431, 100014811, 'Kalna Jaņi', 8, 335),
	(106732187, 100014811, 'Mīļumi', 8, 335),
	(106801826, 100014811, 'Pēči', 8, 335),
	(106909157, 100014811, 'Magnolijas', 8, 335),
	(106930028, 100014811, 'Rūķi', 8, 335),
	(106949385, 100014811, 'Dukuri', 8, 335),
	(106965246, 100014811, 'Priežkalni', 8, 335),
	(100003614, 100000000, 'Saldus, Saldus nov.', 4, 0),
	(100392634, 100003614, 'Alejas iela', 7, 263),
	(100392843, 100003614, 'Gravas iela', 7, 263),
	(100393041, 100003614, 'Lielā iela', 7, 263),
	(100393218, 100003614, 'Putnu iela', 7, 263),
	(100393402, 100003614, 'Tirgotāju iela', 7, 263),
	(100393853, 100003614, 'Vēju iela', 7, 263),
	(101251312, 100392634, '12 ', 8, 263),
	(101251320, 100392634, '12A ', 8, 263),
	(101251337, 100392634, '2 ', 8, 263),
	(101251345, 100392634, '3 ', 8, 263),
	(101251353, 100392634, '5 ', 8, 263),
	(101251361, 100392634, '5A ', 8, 263),
	(101254543, 100392843, '16', 8, 263),
	(101254551, 100392843, '2', 8, 263),
	(101254568, 100392843, '4', 8, 263),
	(101254576, 100392843, '5', 8, 263),
	(101254584, 100392843, '6', 8, 263),
	(101254592, 100392843, '8', 8, 263),
	(101257364, 100393041, '3', 8, 263),
	(101257411, 100393041, '3A', 8, 263),
	(101257428, 100393041, '4', 8, 263),
	(101257524, 100393041, '4A', 8, 263),
	(101257532, 100393041, '5', 8, 263),
	(101257598, 100393041, '6', 8, 263),
	(101257694, 100393041, '7', 8, 263),
	(101259511, 100393218, '10A', 8, 263),
	(101259528, 100393218, '11', 8, 263),
	(101259577, 100393218, '3', 8, 263),
	(101259585, 100393218, '4', 8, 263),
	(101259593, 100393218, '5', 8, 263),
	(101259608, 100393218, '6', 8, 263),
	(101259616, 100393218, '6A', 8, 263),
	(101259624, 100393218, '7', 8, 263),
	(101259632, 100393218, '7A', 8, 263),
	(101259640, 100393218, '8', 8, 263),
	(101259657, 100393218, '8A', 8, 263),
	(101259665, 100393218, '9', 8, 263),
	(101259673, 100393218, '9A', 8, 263),
	(101259681, 100393218, '9B', 8, 263),
	(101262952, 100393402, '1', 8, 263),
	(101262960, 100393402, '15', 8, 263),
	(101262977, 100393402, '2', 8, 263),
	(101266590, 100393853, '1', 8, 263),
	(101266605, 100393853, '3', 8, 263),
	(101266613, 100393853, '4', 8, 263),
	(101266621, 100393853, '8', 8, 263),
	(102098036, 100392634, '6 ', 8, 263),
	(102098044, 100392634, '7 ', 8, 263),
	(102098784, 100392843, '1', 8, 263),
	(102098792, 100392843, '10', 8, 263),
	(102098807, 100392843, '18', 8, 263),
	(102099577, 100393041, '1', 8, 263),
	(102099624, 100393041, '1A,', 8, 263),
	(102099632, 100393041, '2,', 8, 263),
	(102099681, 100393041, '2A,', 8, 263),
	(102099825, 100393041, '8', 8, 263),
	(102100254, 100393218, '10', 8, 263),
	(102101192, 100393402, '11/13,', 8, 263),
	(102101207, 100393402, '4', 8, 263),
	(102101223, 100393402, '6', 8, 263),
	(102101231, 100393402, '7', 8, 263),
	(102101248, 100393402, '9', 8, 263),
	(102102852, 100393853, '6', 8, 263),
	(102111293, 100393853, '7', 8, 263),
	(103116946, 100393853, '5', 8, 263),
	(103118000, 100392634, '3A ', 8, 263),
	(103118025, 100392634, '4 ', 8, 263),
	(103133608, 100392843, '12', 8, 263),
	(103133616, 100392843, '14', 8, 263),
	(103133624, 100392843, '18A', 8, 263),
	(103133632, 100392843, '2A', 8, 263),
	(103133640, 100392843, '2B', 8, 263),
	(103133657, 100392843, '9', 8, 263),
	(103134730, 100393041, '8A', 8, 263),
	(103134851, 100393041, '4B', 8, 263),
	(103135275, 100393218, '3A', 8, 263),
	(103135283, 100393218, '4A', 8, 263),
	(104439105, 100392634, '19 ', 8, 263),
	(104439113, 100392634, '9A ', 8, 263),
	(104439572, 100392843, '5A', 8, 263),
	(104440132, 100393041, '3B', 8, 263),
	(104440140, 100393041, '2B,', 8, 263),
	(104440462, 100393853, '2', 8, 263),
	(105019478, 100392634, '4A ', 8, 263),
	(105019486, 100392634, '4B ', 8, 263),
	(105019494, 100392634, '4C ', 8, 263),
	(105136485, 100392843, '14A', 8, 263),
	(105228348, 100393041, '6A', 8, 263),
	(105228372, 100392843, '18B', 8, 263),
	(105240556, 100392843, '11', 8, 263),
	(105302564, 100393218, '3B', 8, 263),
	(105302724, 100393041, '8B', 8, 263),
	(106191086, 100392843, '13', 8, 263),
	(106269436, 100393218, '10B', 8, 263),
	(106292206, 100392634, '14 ', 8, 263),
	(106423260, 100392634, '19 k-1 ', 8, 263),
	(106466236, 100393041, '3C', 8, 263),
	(106537237, 100393218, '10C', 8, 263),
	(106616928, 100393041, '6B', 8, 263),
	(106635056, 100392634, '3B ', 8, 263),
	(106845098, 100392634, '9 ', 8, 263),
	(100128363, 100011533, 'Sesava', 6, 0),
	(100128443, 100011533, 'Bērvircava', 6, 0),
	(100354057, 100128443, 'Bērzu iela', 7, 0),
	(100354065, 100128443, 'Dārza iela', 7, 0),
	(100354073, 100128443, 'Kastaņu iela', 7, 0),
	(100354081, 100128443, 'Kļavu iela', 7, 0),
	(100354098, 100128443, 'Liepu iela', 7, 0),
	(100354104, 100128443, 'Līvānu iela', 7, 0),
	(100354112, 100128443, 'Saulstaru iela', 7, 0),
	(100354120, 100128443, 'Upes iela', 7, 0),
	(100354137, 100128443, 'Zvaigžņu iela', 7, 0),
	(100482550, 100128443, 'Pīlādžu iela', 7, 0),
	(100486277, 100128443, 'Tūju iela', 7, 0),
	(101539431, 100354081, '4', 8, 111),
	(101539448, 100354098, '7', 8, 111),
	(101539456, 100354112, '2', 8, 111),
	(101539464, 100354112, '8', 8, 111),
	(101539472, 100354120, '35', 8, 111),
	(101539497, 100354137, '9', 8, 111),
	(102254475, 100128443, '2', 8, 111),
	(102254483, 102254475, '4', 8, 111),
	(102254491, 102254475, '6', 8, 111),
	(102254506, 102254475, '8', 8, 111),
	(102254514, 100354065, '10', 8, 111),
	(102254522, 100354065, '2', 8, 111),
	(102254530, 100354065, '4', 8, 111),
	(102254547, 100354065, '6', 8, 111),
	(102254555, 100354065, '8', 8, 111),
	(102254563, 100354073, '6', 8, 111),
	(102254571, 100354081, '1', 8, 111),
	(102254588, 100354081, '10', 8, 111),
	(102254596, 100354081, '11', 8, 111),
	(102254602, 100354081, '12', 8, 111),
	(102254610, 100354081, '13', 8, 111),
	(102254627, 100354081, '14', 8, 111),
	(102254635, 100354081, '2', 8, 111),
	(102254643, 100354081, '3', 8, 111),
	(102254651, 100354081, '5', 8, 111),
	(102254668, 100354081, '6', 8, 111),
	(102254676, 100354081, '7', 8, 111),
	(102254684, 100354081, '8', 8, 111),
	(102254692, 100354098, '1', 8, 111),
	(102254707, 100354098, '11', 8, 111),
	(102254715, 100354098, '13', 8, 111),
	(102254723, 100354098, '3', 8, 111),
	(102254731, 100354098, '5', 8, 111),
	(102254748, 100354098, '9', 8, 111),
	(102254756, 100354104, '1', 8, 111),
	(102254764, 100354104, '2', 8, 111),
	(102254772, 100354104, '3', 8, 111),
	(102254780, 100354104, '4', 8, 111),
	(102254797, 100354104, '6', 8, 111),
	(102254803, 100354112, '10', 8, 111),
	(102254811, 100354112, '12', 8, 111),
	(102254828, 100354112, '14', 8, 111),
	(102254836, 100354112, '4', 8, 111),
	(102254844, 100354112, '6', 8, 111),
	(102254852, 100354120, '11', 8, 111),
	(102254860, 100354120, '13', 8, 111),
	(102254877, 100354120, '15', 8, 111),
	(102254885, 100354120, '17', 8, 111),
	(102254893, 100354120, '19', 8, 111),
	(102254908, 100354120, '21', 8, 111),
	(102254916, 100354120, '23', 8, 111),
	(102254924, 100354120, '25', 8, 111),
	(102254932, 100354120, '27', 8, 111),
	(102254940, 100354120, '29', 8, 111),
	(102254957, 100354120, '31', 8, 111),
	(102254965, 100354120, '33', 8, 111),
	(102254973, 100354120, '37', 8, 111),
	(102254981, 100354120, '39', 8, 111),
	(102254998, 100354120, '41', 8, 111),
	(102255001, 100354120, '43', 8, 111),
	(102255018, 100354120, '45', 8, 111),
	(102255026, 100354120, '47', 8, 111),
	(102255034, 100354120, '5', 8, 111),
	(102255042, 100354120, '7', 8, 111),
	(102255050, 100354120, '8', 8, 111),
	(102255067, 100354120, '9', 8, 111),
	(102255075, 100354137, '1', 8, 111),
	(102255083, 100354137, '10', 8, 111),
	(102255106, 100486277, '6', 8, 111),
	(102255114, 100486277, '3', 8, 111),
	(102255122, 100486277, '1', 8, 111),
	(102255130, 100486277, '2', 8, 111),
	(102255147, 100354137, '4', 8, 111),
	(102255155, 100354137, '5', 8, 111),
	(102255163, 100354137, '8', 8, 111),
	(102624406, 100354137, '3', 8, 111),
	(102624414, 100354137, '7', 8, 111),
	(102633938, 100354073, '4', 8, 111),
	(102682523, 100354081, '9', 8, 111),
	(102682531, 100486277, '4', 8, 111),
	(103504880, 100011533, 'Annenieki', 8, 111),
	(103509406, 100482550, '10', 8, 111),
	(103509471, 100482550, '6', 8, 111),
	(103509488, 100482550, '4', 8, 111),
	(103509576, 100354120, '10', 8, 111),
	(103509584, 100354137, '2', 8, 111),
	(103509631, 100482550, '2', 8, 111),
	(103509648, 100354137, '6', 8, 111),
	(104920235, 100354104, '1B', 8, 111),
	(105532103, 100354112, ' 2A', 8, 111),
	(105796752, 100354120, '1', 8, 111),
	(105802824, 100011533, 'Amatnieki', 8, 111),
	(106187703, 100482550, '1', 8, 111),
	(106398240, 100354073, '2', 8, 111),
	(106582723, 100354112, '1', 8, 111),
	(106582748, 102254475, '10', 8, 111),
	(106583758, 100482550, '3', 8, 111),
	(106766836, 100482550, '8A', 8, 111),
	(101539431, 100354081, '4', 8, 96),
	(101539448, 100354098, '7', 8, 96),
	(101539456, 100354112, '2', 8, 96),
	(101539464, 100354112, '8', 8, 96),
	(101539472, 100354120, '35', 8, 96),
	(101539497, 100354137, '9', 8, 96),
	(102254475, 100354057, '2', 8, 96),
	(102254483, 100354057, '4', 8, 96),
	(102254491, 100354057, '6', 8, 96),
	(102254506, 100354057, '8', 8, 96),
	(102254514, 100354065, '10', 8, 96),
	(102254522, 100354065, '2', 8, 96),
	(102254530, 100354065, '4', 8, 96),
	(102254547, 100354065, '6', 8, 96),
	(102254555, 100354065, '8', 8, 96),
	(102254563, 100354073, '6', 8, 96),
	(102254571, 100354081, '1', 8, 96),
	(102254588, 100354081, '10', 8, 96),
	(102254596, 100354081, '11', 8, 96),
	(102254602, 100354081, '12', 8, 96),
	(102254610, 100354081, '13', 8, 96),
	(102254627, 100354081, '14', 8, 96),
	(102254635, 100354081, '2', 8, 96),
	(102254643, 100354081, '3', 8, 96),
	(102254651, 100354081, '5', 8, 96),
	(102254668, 100354081, '6', 8, 96),
	(102254676, 100354081, '7', 8, 96),
	(102254684, 100354081, '8', 8, 96),
	(102254692, 100354098, '1', 8, 96),
	(102254707, 100354098, '11', 8, 96),
	(102254715, 100354098, '13', 8, 96),
	(102254723, 100354098, '3', 8, 96),
	(102254731, 100354098, '5', 8, 96),
	(102254748, 100354098, '9', 8, 96),
	(102254756, 100354104, '1', 8, 96),
	(102254764, 100354104, '2', 8, 96),
	(102254772, 100354104, '3', 8, 96),
	(102254780, 100354104, '4', 8, 96),
	(102254797, 100354104, '6', 8, 96),
	(102254803, 100354112, '10', 8, 96),
	(102254811, 100354112, '12', 8, 96),
	(102254828, 100354112, '14', 8, 96),
	(102254836, 100354112, '4', 8, 96),
	(102254844, 100354112, '6', 8, 96),
	(102254852, 100354120, '11', 8, 96),
	(102254860, 100354120, '13', 8, 96),
	(102254877, 100354120, '15', 8, 96),
	(102254885, 100354120, '17', 8, 96),
	(102254893, 100354120, '19', 8, 96),
	(102254908, 100354120, '21', 8, 96),
	(102254916, 100354120, '23', 8, 96),
	(102254924, 100354120, '25', 8, 96),
	(102254932, 100354120, '27', 8, 96),
	(102254940, 100354120, '29', 8, 96),
	(102254957, 100354120, '31', 8, 96),
	(102254965, 100354120, '33', 8, 96),
	(102254973, 100354120, '37', 8, 96),
	(102254981, 100354120, '39', 8, 96),
	(102254998, 100354120, '41', 8, 96),
	(102255001, 100354120, '43', 8, 96),
	(102255018, 100354120, '45', 8, 96),
	(102255026, 100354120, '47', 8, 96),
	(102255034, 100354120, '5', 8, 96),
	(102255042, 100354120, '7', 8, 96),
	(102255050, 100354120, '8', 8, 96),
	(102255067, 100354120, '9', 8, 96),
	(102255075, 100354137, '1', 8, 96),
	(102255083, 100354137, '10', 8, 96),
	(102255106, 100486277, '6', 8, 96),
	(102255114, 100486277, '3', 8, 96),
	(102255122, 100486277, '1', 8, 96),
	(102255130, 100486277, '2', 8, 96),
	(102255147, 100354137, '4', 8, 96),
	(102255155, 100354137, '5', 8, 96),
	(102255163, 100354137, '8', 8, 96),
	(102624406, 100354137, '3', 8, 96),
	(102624414, 100354137, '7', 8, 96),
	(102633938, 100354073, '4', 8, 96),
	(102682523, 100354081, '9', 8, 96),
	(102682531, 100486277, '4', 8, 96),
	(103504848, 100011533, 'Akācijas', 8, 0),
	(103509391, 100128443, 'Rītiņi', 8, 96),
	(103509406, 100482550, '10', 8, 96),
	(103509471, 100482550, '6', 8, 96),
	(103509488, 100482550, '4', 8, 96),
	(103509576, 100354120, '10', 8, 96),
	(103509584, 100354137, '2', 8, 96),
	(103509631, 100482550, '2', 8, 96),
	(103509648, 100354137, '6', 8, 96),
	(104920235, 100354104, ' 1B', 8, 96),
	(105532103, 100354112, ' 2A', 8, 96),
	(105796752, 100354120, '1', 8, 96),
	(105882516, 100128443, 'Nomaļi', 8, 96),
	(106187703, 100482550, '1', 8, 96),
	(106398240, 100354073, '2', 8, 96),
	(106582723, 100354112, '1', 8, 96),
	(106582748, 100354057, '10', 8, 96),
	(106583758, 100482550, '3', 8, 96),
	(106766836, 100482550, ' 8A', 8, 96),
	(106966088, 100011533, 'Akāciju darbnīcas', 8, 0),
	(100010548, 100016575, 'Bārbeles pag.', 5, 0),
	(100016575, 100000000, 'Bauskas nov.', 2, 0),
	(101105846, 100010548, 'Cedelmaņi', 8, 286),
	(101112868, 100010548, 'Alenderkrogs', 8, 286),
	(101113074, 100010548, 'Andriņi', 8, 286),
	(103742443, 100010548, 'Jaunstepiņi', 8, 286),
	(104432020, 100010548, 'Bārbeles', 8, 286),
	(104432045, 100010548, 'Alņi', 8, 286),
	(104432053, 100010548, 'Andersoni', 8, 286),
	(104432078, 100010548, 'Āres', 8, 286),
	(104432086, 100010548, 'Austrumi', 8, 286),
	(104432100, 100010548, 'Avotkrogs', 8, 286),
	(104432117, 100010548, 'Baltrumi', 8, 286),
	(104432141, 100010548, 'Bārbeles pamatskola', 8, 286),
	(104432158, 100010548, 'Bauzas', 8, 286),
	(104432182, 100010548, 'Bērznieki', 8, 286),
	(104432221, 100010548, 'Bračkas', 8, 286),
	(104432238, 100010548, 'Bramaņi', 8, 286),
	(104432254, 100010548, 'Brīvnieki', 8, 286),
	(104432262, 100010548, 'Brusas', 8, 286),
	(104432301, 100010548, 'Čiekuri', 8, 286),
	(104432318, 100010548, 'Čūderi', 8, 286),
	(104432350, 100010548, 'Dravenieki', 8, 286),
	(104432367, 100010548, 'Dreijeri', 8, 286),
	(104432406, 100010548, 'Dzērvēni', 8, 286),
	(104432447, 100010548, 'Eglaines', 8, 286),
	(104432463, 100010548, 'Eglītes', 8, 286),
	(104432471, 100010548, 'Ērgļi', 8, 286),
	(104432488, 100010548, 'Erliķi', 8, 286),
	(104432496, 100010548, 'Everti', 8, 286),
	(104432502, 100010548, 'Ezera Salmiņi', 8, 286),
	(104432527, 100010548, 'Ezernieki', 8, 286),
	(104432535, 100010548, 'Ēzītes', 8, 286),
	(104432551, 100010548, 'Gaidas', 8, 286),
	(104433047, 100010548, 'Garbari', 8, 286),
	(104433071, 100010548, 'Gaujas', 8, 286),
	(104433096, 100010548, 'Gedroviči', 8, 286),
	(104433127, 100010548, 'Glīzdiņi', 8, 286),
	(104433151, 100010548, 'Gobas', 8, 286),
	(104433192, 100010548, 'Grantskalni', 8, 286),
	(104433223, 100010548, 'Grāvīši', 8, 286),
	(104433280, 100010548, 'Grīnbergi', 8, 286),
	(104433311, 100010548, 'Ģeķi', 8, 286),
	(104433328, 100010548, 'Ģērķi', 8, 286),
	(104433344, 100010548, 'Ilgas', 8, 286),
	(104433360, 100010548, 'Ilmiņas', 8, 286),
	(104433377, 100010548, 'Dīķīši', 8, 286),
	(104433385, 100010548, 'Indrāni', 8, 286),
	(104433393, 100010548, 'Jāņkalni', 8, 286),
	(104433416, 100010548, 'Jaunindrāni', 8, 286),
	(104433481, 100010548, 'Jēkapiņi', 8, 286),
	(104433504, 100010548, 'Jobi', 8, 286),
	(104433537, 100010548, 'Jostkalēji', 8, 286),
	(104433545, 100010548, 'Jukatas', 8, 286),
	(104433561, 100010548, 'Jukši', 8, 286),
	(104433600, 100010548, 'Jūrnieki', 8, 286),
	(104433625, 100010548, 'Juši', 8, 286),
	(104433746, 100010548, 'Kalnrūpnieki', 8, 286),
	(104434008, 100010548, 'Kalnieši', 8, 286),
	(104434032, 100010548, 'Kalnzemnieki', 8, 286),
	(104434057, 100010548, 'Kauķi', 8, 286),
	(104434073, 100010548, 'Klāvi', 8, 286),
	(104434120, 100010548, 'Kociņi', 8, 286),
	(104434153, 100010548, 'Kramkalniņi', 8, 286),
	(104434178, 100010548, 'Kraukļi', 8, 286),
	(104434186, 100010548, 'Krieviņi', 8, 286),
	(104434522, 100010548, 'Ķirveļi', 8, 286),
	(104434530, 100010548, 'Ķīseļi', 8, 286),
	(104434555, 100010548, 'Lācīši', 8, 286),
	(104434563, 100010548, 'Langas', 8, 286),
	(104434602, 100010548, 'Lazdas', 8, 286),
	(104434610, 100010548, 'Lazdiņas', 8, 286),
	(104434627, 100010548, 'Leduži', 8, 286),
	(104434651, 100010548, 'Lejas Simsoni', 8, 286),
	(104434692, 100010548, 'Lejnieki', 8, 286),
	(104434723, 100010548, 'Līdumi', 8, 286),
	(104434828, 100010548, 'Līgotņi', 8, 286),
	(104434836, 100010548, 'Limpuči', 8, 286),
	(104434893, 100010548, 'Maigas', 8, 286),
	(104434932, 100010548, 'Mazās Lazdas', 8, 286),
	(104434957, 100010548, 'Mazbleķi', 8, 286),
	(104434965, 100010548, 'Mazbrankūži', 8, 286),
	(104434981, 100010548, 'Mazjuši', 8, 286),
	(104434998, 100010548, 'Mazlazdas', 8, 286),
	(104435001, 100010548, 'Mazpurviņi', 8, 286),
	(104435018, 100010548, 'Mazrušķeri', 8, 286),
	(104436977, 100010548, 'Kalēji', 8, 286),
	(104586418, 100010548, 'Bišu Bērzi', 8, 286),
	(104643400, 100010548, 'Klintas', 8, 286),
	(104832837, 100010548, 'Āži', 8, 286),
	(104833180, 100010548, 'Gundegas', 8, 286),
	(104833420, 100010548, 'Kalna Ķeri', 8, 286),
	(104833437, 100010548, 'Mazputniņi', 8, 286),
	(105432434, 100010548, 'Avotiņi', 8, 286),
	(105996420, 100010548, 'Ausekļu dzirnavas', 8, 286),
	(106018615, 100010548, 'Bāzes stacija 414', 8, 286),
	(106307761, 100010548, 'Ievziedi', 8, 286),
	(106380352, 100010548, 'Alejas 1', 8, 286),
	(106428325, 100010548, 'Mazsaulītes', 8, 286),
	(106721254, 100010548, 'Liepziedi', 8, 286),
	(106762652, 100010548, 'Jaunbērzi', 8, 286),
	(106952584, 100010548, 'Aleksija dārzi', 8, 286),
	(100003044, 100000000, 'Liepāja', 4, 0),
	(100329195, 100003044, 'Ganību iela', 7, 0),
	(101693026, 100329195, '117', 8, 191),
	(101693034, 100329195, '125', 8, 191),
	(101693050, 100329195, '135/141', 8, 191),
	(101693067, 100329195, '142', 8, 191),
	(101693251, 100329195, '23', 8, 187),
	(101693276, 100329195, '29', 8, 187),
	(101693292, 100329195, '31', 8, 187),
	(101693323, 100329195, '49/51', 8, 187),
	(101693356, 100329195, '69/71', 8, 187),
	(101693380, 100329195, '73/75', 8, 191),
	(101693397, 100329195, '74', 8, 191),
	(101693428, 100329195, '78', 8, 191),
	(101693460, 100329195, '92', 8, 191),
	(101693477, 100329195, '93', 8, 191),
	(102407215, 100329195, '101', 8, 191),
	(102407223, 100329195, '102', 8, 191),
	(102407231, 100329195, '103', 8, 191),
	(102407248, 100329195, '104', 8, 191),
	(102407256, 100329195, '105', 8, 191),
	(102407264, 100329195, '106', 8, 191),
	(102407272, 100329195, '107', 8, 191),
	(102407280, 100329195, '109', 8, 191),
	(102407297, 100329195, '111', 8, 191),
	(102407303, 100329195, '113', 8, 191),
	(102407311, 100329195, '115', 8, 191),
	(102407336, 100329195, '119', 8, 191),
	(102407352, 100329195, '12/14', 8, 187),
	(102407360, 100329195, '121', 8, 191),
	(102407377, 100329195, '121A', 8, 191),
	(102407385, 100329195, '123', 8, 191),
	(102407393, 100329195, '123A', 8, 191),
	(102407408, 100329195, '125A', 8, 191),
	(102407416, 100329195, '127', 8, 191),
	(102407424, 100329195, '127A', 8, 191),
	(102407432, 100329195, '129', 8, 191),
	(102407440, 100329195, '132', 8, 191),
	(102407457, 100329195, '134', 8, 191),
	(102407465, 100329195, '134A', 8, 191),
	(102407473, 100329195, '136', 8, 191),
	(102407481, 100329195, '136A', 8, 191),
	(102407498, 100329195, '136B', 8, 191),
	(102407504, 100329195, '136C', 8, 191),
	(102407512, 100329195, '140', 8, 191),
	(102407520, 100329195, '140A', 8, 191),
	(102407553, 100329195, '144', 8, 191),
	(102407561, 100329195, '145', 8, 191),
	(102407578, 100329195, '146', 8, 191),
	(102407746, 100329195, '16/18', 8, 187),
	(102407850, 100329195, '17', 8, 187),
	(102408024, 100329195, '19', 8, 187),
	(102408104, 100329195, '21', 8, 187),
	(102408120, 100329195, '22', 8, 187),
	(102408137, 100329195, '24', 8, 187),
	(102408145, 100329195, '25', 8, 187),
	(102408153, 100329195, '26', 8, 187),
	(102408186, 100329195, '35', 8, 187),
	(102408200, 100329195, '39', 8, 187),
	(102408217, 100329195, '4', 8, 187),
	(102408225, 100329195, '41', 8, 187),
	(102408233, 100329195, '43', 8, 187),
	(102408241, 100329195, '45', 8, 187),
	(102408258, 100329195, '47', 8, 187),
	(102408274, 100329195, '50', 8, 187),
	(102408282, 100329195, '53/55', 8, 187),
	(102408290, 100329195, '54', 8, 187),
	(102408305, 100329195, '56', 8, 187),
	(102408313, 100329195, '57', 8, 187),
	(102408321, 100329195, '58', 8, 187),
	(102408338, 100329195, '60', 8, 187),
	(102408362, 100329195, '64', 8, 187),
	(102408370, 100329195, '66', 8, 187),
	(102408387, 100329195, '68', 8, 187),
	(102408395, 100329195, '70', 8, 191),
	(102408401, 100329195, '72', 8, 191),
	(102408418, 100329195, '76', 8, 191),
	(102408426, 100329195, '77/79', 8, 191),
	(102408434, 100329195, '8/10', 8, 187),
	(102408442, 100329195, '81/83', 8, 191),
	(102408450, 100329195, '82', 8, 191),
	(102408467, 100329195, '85', 8, 191),
	(102408483, 100329195, '87', 8, 191),
	(102408491, 100329195, '89/91', 8, 191),
	(102408506, 100329195, '9/11', 8, 187),
	(102408514, 100329195, '90', 8, 191),
	(102408522, 100329195, '94', 8, 191),
	(102408530, 100329195, '95', 8, 191),
	(102408547, 100329195, '96', 8, 191),
	(102408555, 100329195, '97', 8, 191),
	(102408563, 100329195, '98', 8, 191),
	(102591164, 100329195, '133', 8, 191),
	(102606734, 100329195, '15', 8, 187),
	(102628333, 100329195, '52', 8, 187),
	(102628341, 100329195, '61', 8, 187),
	(102685955, 100329195, ' 119A', 8, 191),
	(102685971, 100329195, '33', 8, 187),
	(104131866, 100329195, '122/128', 8, 191),
	(104131874, 100329195, '131', 8, 191),
	(104131970, 100329195, '34A', 8, 187),
	(104131987, 100329195, '36/48', 8, 187),
	(104131995, 100329195, '63A', 8, 187),
	(104276305, 100329195, '1/3', 8, 187),
	(104332698, 100329195, '20', 8, 187),
	(105181906, 100329195, '145A', 8, 191),
	(105226465, 100329195, '106A', 8, 191),
	(105256416, 100329195, '63/67', 8, 187),
	(106193530, 100329195, '26A', 8, 187),
	(106205935, 100329195, '58A', 8, 187),
	(106205943, 100329195, '58B', 8, 187),
	(106300515, 100329195, '66A', 8, 187),
	(100003044, 100003044, 'Liepāja', 4, 0),
	(100328257, 100003044, '14. novembra bulvāri', 7, 0),
	(100328273, 100328257, 'Abavas iela', 7, 0),
	(100328312, 100328273, 'Airītes iela', 7, 0),
	(100328361, 100328312, 'Aldaru iela', 7, 0),
	(101689428, 100328257, '113', 8, 192),
	(101689436, 100328257, '121', 8, 192),
	(101689444, 100328257, '85', 8, 192),
	(101689620, 100328312, '8', 8, 190),
	(101689686, 100328361, '2', 8, 192),
	(101689717, 100328361, '  36/38  ', 8, 192),
	(102391728, 100328257, '107', 8, 192),
	(102391736, 100328257, '109', 8, 192),
	(102391744, 100328257, '111', 8, 192),
	(102391752, 100328257, '117', 8, 192),
	(102391760, 100328257, '127', 8, 192),
	(102391777, 100328257, '   129/131  ', 8, 192),
	(102391785, 100328257, '133', 8, 192),
	(102391793, 100328257, '135', 8, 192),
	(102391808, 100328257, '139', 8, 192),
	(102391816, 100328257, '141', 8, 192),
	(102391824, 100328257, '143', 8, 192),
	(102391832, 100328257, '145', 8, 192),
	(102391840, 100328257, '147', 8, 192),
	(102391857, 100328257, '149', 8, 192),
	(102391865, 100328257, '17', 8, 192),
	(102391873, 100328257, '18', 8, 192),
	(102391881, 100328257, '19', 8, 192),
	(102391898, 100328257, '   19A  ', 8, 192),
	(102391904, 100328257, '   19C  ', 8, 192),
	(102391912, 100328257, '20', 8, 192),
	(102391920, 100328257, '22', 8, 192),
	(102391937, 100328257, '   22A  ', 8, 192),
	(102391953, 100328257, '26', 8, 192),
	(102391961, 100328257, '29', 8, 192),
	(102391978, 100328257, '   31/33  ', 8, 192),
	(102391986, 100328257, '35', 8, 192),
	(102392006, 100328257, '40', 8, 192),
	(102392014, 100328257, '   40A  ', 8, 192),
	(102392030, 100328257, '54', 8, 192),
	(102392063, 100328257, '28', 8, 192),
	(102392071, 100328257, '67', 8, 192),
	(102392088, 100328257, '30', 8, 192),
	(102392102, 100328257, '71', 8, 192),
	(102392110, 100328257, '73', 8, 192),
	(102392127, 100328257, '75', 8, 192),
	(102392135, 100328257, '   75A  ', 8, 192),
	(102392143, 100328257, '77', 8, 192),
	(102392151, 100328257, '32', 8, 192),
	(102392168, 100328257, '79', 8, 192),
	(102392176, 100328257, '87', 8, 192),
	(102392184, 100328257, '89', 8, 192),
	(102392192, 100328257, '   91/93  ', 8, 192),
	(102392207, 100328257, '97', 8, 192),
	(102392215, 100328257, '99', 8, 192),
	(102392633, 100328273, '1', 8, 192),
	(102392641, 100328273, '11', 8, 192),
	(102392658, 100328273, '13', 8, 192),
	(102392674, 100328273, '2', 8, 192),
	(102392682, 100328273, '3', 8, 192),
	(102392690, 100328273, '  3A  ', 8, 192),
	(102392713, 100328273, '5', 8, 192),
	(102392738, 100328273, '9', 8, 192),
	(102393305, 100328312, '10', 8, 190),
	(102393313, 100328312, '12', 8, 190),
	(102393321, 100328312, ' 1A  ', 8, 190),
	(102393346, 100328312, '3', 8, 190),
	(102393563, 100328361, '  10/12  ', 8, 192),
	(102393571, 100328361, '11', 8, 192),
	(102393588, 100328361, '  14/16  ', 8, 192),
	(102393596, 100328361, '17', 8, 192),
	(102393610, 100328361, '19', 8, 192),
	(102393627, 100328361, '21', 8, 192),
	(102393635, 100328361, '  26/28  ', 8, 192),
	(102393643, 100328361, '  30/32  ', 8, 192),
	(102393651, 100328361, '  31/33  ', 8, 192),
	(102393668, 100328361, '35', 8, 192),
	(102393676, 100328361, '37', 8, 192),
	(102393684, 100328361, '39', 8, 192),
	(102393692, 100328361, '40', 8, 192),
	(102393707, 100328361, '  41/43  ', 8, 192),
	(102393715, 100328361, '42', 8, 192),
	(102393797, 100328361, '8', 8, 192),
	(102393803, 100328361, '9', 8, 192),
	(102422357, 100328257, '165', 8, 192),
	(102627854, 100328257, '137', 8, 192),
	(102627862, 100328257, '151', 8, 192),
	(102627870, 100328273, '10', 8, 192),
	(102627887, 100328312, '1', 8, 190),
	(102627895, 100328312, '6', 8, 190),
	(102685625, 100328257, '   17A  ', 8, 192),
	(102685633, 100328257, '95', 8, 192),
	(104108524, 100328257, '   56/80  ', 8, 192),
	(104108540, 100328257, '   82/86  ', 8, 192),
	(104108565, 100328257, '   88/98  ', 8, 192),
	(104109567, 100328361, '  3/7  ', 8, 192),
	(104764938, 100328361, '  20/24  ', 8, 192),
	(105603008, 100328257, '   19B', 8, 192),
	(105917312, 100328361, '  3A  ', 8, 192),
	(106401758, 100328257, '   19T  ', 8, 192),
	(106591427, 100328257, '14', 8, 192),
	(106882183, 100328312, '14', 8, 190),
	(106882191, 100328312, '16', 8, 190),
	(106945072, 100328312, ' 10A  ', 8, 190),
	(106945080, 100328312, ' 10B  ', 8, 190),
	(100010636, 100016575, 'Rundāles', 5, 0),
	(100010660, 100016575, 'Svitenes', 5, 0),
	(100011533, 100016534, 'Sesavas', 5, 0),
	(100016534, 100000000, 'Jelgavas', 2, 0),
	(100016575, 100000000, 'Bauskas', 2, 0),
	(100111887, 100010636, 'Jāņukrogs', 6, 0),
	(100111895, 100010636, 'Ziedoņi', 6, 0),
	(100111901, 100010636, 'Švirkale', 6, 0),
	(100111918, 100010636, 'Saulaine', 6, 0),
	(100111934, 100010636, 'Priedītes', 6, 0),
	(100111942, 100010636, 'Pilsrundāle', 6, 0),
	(100111950, 100010636, 'Mazmežotne', 6, 0),
	(100111975, 100010636, 'Lepšas', 6, 0),
	(100111983, 100010636, 'Mazbērstele', 6, 0),
	(100111991, 100010636, 'Punslavas', 6, 0),
	(100112132, 100010660, 'Svitene', 6, 0),
	(100197284, 100010660, 'Tīrumi', 6, 0),
	(100205392, 100010636, 'Vecrundāle', 6, 0),
	(100420563, 100112132, 'Ezera iela', 7, 0),
	(100420571, 100112132, 'Upes iela', 7, 0),
	(100420588, 100112132, 'Dārza iela', 7, 0),
	(100420596, 100112132, 'Mazā iela', 7, 0),
	(100420602, 100112132, 'Parka iela', 7, 0),
	(100420610, 100112132, 'Mežmalas iela', 7, 0),
	(100420627, 100112132, 'Centra iela', 7, 0),
	(100420635, 100112132, 'Pagasta iela', 7, 0),
	(100474246, 100112132, 'Muižas iela', 7, 0),
	(100481364, 100111942, 'Lejnieku iela', 7, 0),
	(100481372, 100111942, 'Novadu iela', 7, 0),
	(100481380, 100111942, 'Saulgriežu iela', 7, 0),
	(100481403, 100111942, 'Līvānu iela', 7, 0),
	(100481411, 100111942, 'Bezdelīgu iela', 7, 0),
	(100481428, 100111942, 'Jātnieku iela', 7, 0),
	(100481436, 100111942, 'Dārza iela', 7, 0),
	(100493715, 100111942, 'Upmalas iela', 7, 0),
	(101094427, 100111942, 'Ugunsdzēsēji', 8, 297),
	(101094443, 100111942, 'Vecrozēni', 8, 297),
	(101094451, 100111942, 'Avenes', 8, 297),
	(101094468, 100111942, 'Lauvas', 8, 297),
	(101096383, 100111942, 'Vaski', 8, 297),
	(101096391, 100111942, 'Skalbes', 8, 297),
	(101096414, 100111942, 'Kalmes', 8, 297),
	(101096422, 100111942, 'Saulieši', 8, 297),
	(101096455, 100111942, 'Bezdelīgas', 8, 297),
	(101096488, 100111942, 'Saulstari', 8, 297),
	(101096527, 100010636, 'Malenieki', 8, 297),
	(101096535, 100010636, 'Senčukrogs', 8, 297),
	(101104467, 100111942, 'Rītiņi', 8, 297),
	(101104475, 100111942, 'Astras', 8, 297),
	(101104491, 100111942, 'Senlejas', 8, 297),
	(101141070, 100010660, 'Jauntauriņi', 8, 295),
	(101141118, 100010660, 'Vecpalejas', 8, 295),
	(101141126, 100010660, 'Dzērves', 8, 295),
	(102759383, 100111942, 'Papardes', 8, 297),
	(102759391, 100111942, 'Druviņas', 8, 297),
	(102759414, 100010660, 'Maizītes', 8, 295),
	(103275718, 100111942, 'Pilsrundāles garāža 1', 8, 297),
	(103438011, 100111942, 'Pilsrundāle 2', 8, 297),
	(103462685, 100010660, 'Putekļi', 8, 295),
	(103462716, 100010660, 'Lieparkrastiņi', 8, 295),
	(103504848, 100011533, 'Akācijas', 8, 111),
	(103504856, 100011533, 'Akmentiņi', 8, 111),
	(103504872, 100011533, 'Alejas', 8, 111),
	(103504897, 100011533, 'Anzēni', 8, 111),
	(103504911, 100011533, 'Apiņi', 8, 111),
	(103504928, 100011533, 'Apses', 8, 111),
	(103504936, 100011533, 'Arāji', 8, 111),
	(103504944, 100011533, 'Aronijas', 8, 111),
	(103504952, 100011533, 'Atblāzmas', 8, 111),
	(103504985, 100011533, 'Avotiņi', 8, 111),
	(103504993, 100011533, 'Ābelītes', 8, 111),
	(103505054, 100011533, 'Betānijas', 8, 111),
	(103505062, 100011533, 'Bērzaiņi', 8, 111),
	(103505070, 100011533, 'Birznieki', 8, 111),
	(103505087, 100011533, 'Bites', 8, 111),
	(103505101, 100011533, 'Bliežas', 8, 111),
	(103505118, 100011533, 'Blūdži', 8, 111),
	(103505126, 100011533, 'Blūmfeldi', 8, 111),
	(103505134, 100011533, 'Brakšķi', 8, 111),
	(103505150, 100011533, 'Brieži', 8, 111),
	(103505167, 100011533, 'Brieži 2', 8, 111),
	(103505175, 100011533, 'Briņķi', 8, 111),
	(103505183, 100011533, 'Brīvnieki', 8, 111),
	(103505206, 100011533, 'Buļļi', 8, 111),
	(103505247, 100011533, 'Bumbieres', 8, 111),
	(103505255, 100011533, 'Ceinas', 8, 111),
	(103505271, 100011533, 'Celmi', 8, 111),
	(103505296, 100011533, 'Ciemaldi', 8, 111),
	(103505302, 100011533, 'Cinīši', 8, 111),
	(103505310, 100011533, 'Ciņi', 8, 111),
	(103505335, 100011533, 'Čabūti ferma', 8, 111),
	(103505351, 100011533, 'Čersi', 8, 111),
	(103505368, 100011533, 'Daugavieši', 8, 111),
	(103505376, 100011533, 'Dauguļi', 8, 111),
	(103505665, 100011533, 'Dārznieki', 8, 111),
	(103505673, 100011533, 'Druvas', 8, 111),
	(103505681, 100011533, 'Dūjas', 8, 111),
	(103505698, 100011533, 'Dzidras', 8, 111),
	(103505704, 100011533, 'Dzintari', 8, 111),
	(103505712, 100011533, 'Dzintariņi', 8, 111),
	(103505720, 100011533, 'Eglaiņi', 8, 111),
	(103505737, 100011533, 'Eglāji', 8, 111),
	(103505745, 100011533, 'Eglītes', 8, 111),
	(103505753, 100011533, 'Eiginskusti', 8, 111),
	(103505817, 100011533, 'Eņģeļi', 8, 111),
	(103505825, 100011533, 'Ezeriņi', 8, 111),
	(103505833, 100011533, 'Ezernieki', 8, 111),
	(103505874, 100011533, 'Gaidas', 8, 111),
	(103505946, 100011533, 'Grantiņi', 8, 111),
	(103505987, 100011533, 'Gūtes', 8, 111),
	(103505995, 100011533, 'Gvaldas', 8, 111),
	(103506023, 100011533, 'Ilgas', 8, 111),
	(103506031, 100011533, 'Imanti', 8, 111),
	(103506064, 100011533, 'Jaunābeles', 8, 111),
	(103506072, 100011533, 'Jaunbaloži', 8, 111),
	(103506097, 100011533, 'Jaunceinas', 8, 111),
	(103506208, 100011533, 'Jaunpujas', 8, 111),
	(103506265, 100011533, 'Jaunvircava', 8, 111),
	(103506298, 100011533, 'Jēkabsoni', 8, 111),
	(103506304, 100011533, 'Jordāni', 8, 111),
	(103506320, 100011533, 'Jurdu Jaunzemji', 8, 111),
	(103506337, 100011533, 'Jušķēni', 8, 111),
	(103506353, 100011533, 'Jūtes', 8, 111),
	(103506378, 100011533, 'Kaģi', 8, 111),
	(103506394, 100011533, 'Kaktiņi 2', 8, 111),
	(103506400, 100011533, 'Kalēji', 8, 111),
	(103506417, 100011533, 'Kalnenieki', 8, 111),
	(103506458, 100011533, 'Kārkliņi', 8, 111),
	(103506466, 100011533, 'Kliesti', 8, 111),
	(103506474, 100011533, 'Krastiņi', 8, 111),
	(103506482, 100011533, 'Krūmiņi', 8, 111),
	(103506490, 100011533, 'Kupļi', 8, 111),
	(103506513, 100011533, 'Kūlas', 8, 111),
	(103506546, 100011533, 'Laimītes', 8, 111),
	(103506554, 100011533, 'Lazdas', 8, 111),
	(103506562, 100011533, 'Lazdiņas', 8, 111),
	(103506570, 100011533, 'Laženieki', 8, 111),
	(103506587, 100011533, 'Lācīši', 8, 111),
	(103506595, 100011533, 'Lāči', 8, 111),
	(103506601, 100011533, 'Lediņi', 8, 111),
	(103506618, 100011533, 'Lejnieki', 8, 111),
	(103506626, 100011533, 'Libārti', 8, 111),
	(103506675, 100011533, 'Liepas', 8, 111),
	(103506714, 100011533, 'Līčupes', 8, 111),
	(103506722, 100011533, 'Līvi', 8, 111),
	(103506747, 100011533, 'Lodiņi', 8, 111),
	(103506755, 100011533, 'Ļāveikas', 8, 111),
	(103506771, 100011533, 'Mazceinas', 8, 111),
	(103506835, 100011533, 'Maztālavas', 8, 111),
	(103506851, 100011533, 'Mārsili', 8, 111),
	(103506876, 100011533, 'Medņi', 8, 111),
	(103506892, 100011533, 'Mežāži', 8, 111),
	(103506907, 100011533, 'Mežciemi', 8, 111),
	(103506915, 100011533, 'Mežmales', 8, 111),
	(103506931, 100011533, 'Mežvilki', 8, 111),
	(103506948, 100011533, 'Miltiņi', 8, 111),
	(103506956, 100011533, 'Mucenieki', 8, 111),
	(103506964, 100011533, 'Muižnieki', 8, 111),
	(103506972, 100011533, 'Mūrnieki', 8, 111),
	(103506997, 100011533, 'Narvaiši Upenieki', 8, 111),
	(103507000, 100011533, 'Osīši', 8, 111),
	(103507017, 100011533, 'Ošenieki', 8, 111),
	(103507033, 100011533, 'Ozoliņi', 8, 111),
	(103507041, 100011533, 'Ozolkalni', 8, 111),
	(103507058, 100011533, 'Paegles', 8, 111),
	(103507066, 100011533, 'Pakalniņi', 8, 111),
	(103507082, 100011533, 'Pazari', 8, 111),
	(103507090, 100011533, 'Pārupji', 8, 111),
	(103507105, 100011533, 'Pečāji', 8, 111),
	(103507121, 100011533, 'Pikuļi', 8, 111),
	(103507138, 100011533, 'Piliņi', 8, 111),
	(103507154, 100011533, 'Plūsmaņi', 8, 111),
	(103507187, 100011533, 'Praulišķi', 8, 111),
	(103507195, 100011533, 'Priedes', 8, 111),
	(103507201, 100011533, 'Priedītes', 8, 111),
	(103507218, 100011533, 'Pujas', 8, 111),
	(103507226, 100011533, 'Pumpuri', 8, 111),
	(103507242, 100011533, 'Purviņi', 8, 111),
	(103507250, 100011533, 'Putniņi', 8, 111),
	(103507267, 100011533, 'Pūpoli', 8, 111),
	(103507283, 100011533, 'Rasas', 8, 111),
	(103507291, 100011533, 'Rencēni', 8, 111),
	(103507306, 100011533, 'Robežnieki', 8, 111),
	(103507314, 100011533, 'Rogas', 8, 111),
	(103507347, 100011533, 'Rukaiši', 8, 111),
	(103507355, 100011533, 'Rukšas', 8, 111),
	(103507363, 100011533, 'Ruļļi', 8, 111),
	(103507371, 100011533, 'Rūjas', 8, 111),
	(103507388, 100011533, 'Salvijas', 8, 111),
	(103507396, 100011533, 'Saulīši', 8, 111),
	(103507427, 100011533, 'Sējas', 8, 111),
	(103507443, 100011533, 'Sidrabiņi', 8, 111),
	(103507468, 100011533, 'Sīļi', 8, 111),
	(103507476, 100011533, 'Skudriņas', 8, 111),
	(103507484, 100011533, 'Skujas', 8, 111),
	(103507492, 100011533, 'Skujenieki', 8, 111),
	(103507716, 100011533, 'Sprīdīši', 8, 111),
	(103507724, 100011533, 'Stakles', 8, 111),
	(103507732, 100011533, 'Staltais krogs', 8, 111),
	(103507765, 100011533, 'Stanuļi Dāvi', 8, 111),
	(103507958, 100011533, 'Strautnieki', 8, 111),
	(103507966, 100011533, 'Strazdiņi', 8, 111),
	(103507974, 100011533, 'Stundas', 8, 111),
	(103507990, 100011533, 'Stūrīši', 8, 111),
	(103508035, 100011533, 'Tauriņi', 8, 111),
	(103508043, 100011533, 'Tālavas', 8, 111),
	(103508051, 100011533, 'Teihmaņi', 8, 111),
	(103508076, 100011533, 'Tiltiņi', 8, 111),
	(103508107, 100011533, 'Tīrumi', 8, 111),
	(103508115, 100011533, 'Tīrumnieki', 8, 111),
	(103508131, 100011533, 'Upeskrasti', 8, 111),
	(103508148, 100011533, 'Ūdri', 8, 111),
	(103508164, 100011533, 'Vāveres', 8, 111),
	(103508211, 100011533, 'Vecie Garjāņi', 8, 111),
	(103508228, 100011533, 'Veckūlas', 8, 111),
	(103508236, 100011533, 'Veclati', 8, 111),
	(103508277, 100011533, 'Vēji', 8, 111),
	(103508533, 100011533, 'Vidukļi', 8, 111),
	(103508541, 100011533, 'Madlēnas', 8, 111),
	(103508566, 100011533, 'Vidži', 8, 111),
	(103508590, 100011533, 'Viļņi', 8, 111),
	(103508621, 100011533, 'Vītoli', 8, 111),
	(103508646, 100011533, 'Zālītes', 8, 111),
	(103508662, 100011533, 'Zeilandi', 8, 111),
	(103508687, 100011533, 'Zeķes', 8, 111),
	(103508695, 100011533, 'Zemgalieši', 8, 111),
	(103508701, 100011533, 'Zemnieki', 8, 111),
	(103508734, 100011533, 'Zemzarīši', 8, 111),
	(103508783, 100011533, 'Ziemeļi', 8, 111),
	(103508791, 100011533, 'Zīles', 8, 111),
	(103508814, 100011533, 'Zuši', 8, 111),
	(103508830, 100011533, 'Mežvidi', 8, 111),
	(103508847, 100011533, 'Žagatiņas', 8, 111),
	(103508863, 100011533, 'Žībarti', 8, 111),
	(103508888, 100011533, 'Žubītes', 8, 111),
	(103509414, 100011533, 'Divēji', 8, 111),
	(103509510, 100011533, 'Garjāņi', 8, 111),
	(103509543, 100011533, 'Gaujezeri', 8, 111),
	(103509592, 100011533, 'Rudeņi', 8, 111),
	(103509607, 100011533, 'Saulstari', 8, 111),
	(103509623, 100011533, 'Upmaļi', 8, 111),
	(103510876, 100011533, 'Birztalas', 8, 111),
	(103510972, 100011533, 'Akotiņš', 8, 111),
	(103510980, 100011533, 'Avenes', 8, 111),
	(103510997, 100011533, 'Galamuiža', 8, 111),
	(103511000, 100011533, 'Indrāni', 8, 111),
	(103511017, 100011533, 'Laimdotas', 8, 111),
	(103511025, 100011533, 'Malenieki', 8, 111),
	(103511033, 100011533, 'Rozes', 8, 111),
	(103511041, 100011533, 'Rožkalni', 8, 111),
	(103511058, 100011533, 'Strēlnieki', 8, 111),
	(103511066, 100011533, 'Tukuļi', 8, 111),
	(103511074, 100011533, 'Vīndedži', 8, 111),
	(103511082, 100011533, 'Zemgales', 8, 111),
	(103511090, 100011533, 'Viesturi', 8, 111),
	(103511105, 100011533, 'Vīburi', 8, 111),
	(103511113, 100011533, 'Rotas', 8, 111),
	(103511121, 100011533, 'Sermuļi', 8, 111),
	(103511138, 100011533, 'Silmači', 8, 111),
	(103511146, 100011533, 'Noras', 8, 111),
	(103511154, 100011533, 'Magones', 8, 111),
	(103511162, 100011533, 'Ligzdiņas', 8, 111),
	(103511170, 100011533, 'Kundziņi', 8, 111),
	(103511291, 100011533, 'Kūri', 8, 111),
	(103511306, 100011533, 'Klāvi', 8, 111),
	(103511322, 100011533, 'Veipi', 8, 111),
	(103511330, 100011533, 'Klāvu kalte', 8, 111),
	(103511347, 100011533, 'Klāvu veikals', 8, 111),
	(103511355, 100011533, 'Laipiņas', 8, 111),
	(103511363, 100011533, 'Graši', 8, 111),
	(103511371, 100011533, 'Griezes', 8, 111),
	(103511388, 100011533, 'Atvari', 8, 111),
	(103511396, 100011533, 'Bērzi', 8, 111),
	(103511402, 100011533, 'Apškalni', 8, 111),
	(103511410, 100011533, 'Dravnieki', 8, 111),
	(103511435, 100011533, 'Skursteņi', 8, 111),
	(103511451, 100011533, 'Zemgaļi', 8, 111),
	(103511476, 100011533, 'Upītes', 8, 111),
	(103511492, 100011533, 'Smilgas', 8, 111),
	(103511507, 100011533, 'Sniedzes', 8, 111),
	(103511523, 100011533, 'Strautiņi', 8, 111),
	(103511556, 100011533, 'Rožstrauti', 8, 111),
	(103511564, 100011533, 'Saktas', 8, 111),
	(103511572, 100011533, 'Salnāji', 8, 111),
	(103511597, 100011533, 'Saulkrasti', 8, 111),
	(103511603, 100011533, 'Papardes', 8, 111),
	(103511611, 100011533, 'Liepiņas', 8, 111),
	(103511628, 100011533, 'Klieņi', 8, 111),
	(103511644, 100011533, 'Kļavas', 8, 111),
	(103511660, 100011533, 'Kubuliņi', 8, 111),
	(103511677, 100011533, 'Kalves', 8, 111),
	(103511685, 100011533, 'Gravas', 8, 111),
	(103511693, 100011533, 'Birzītes', 8, 111),
	(103511716, 100011533, 'Melderi', 8, 111),
	(103511732, 100011533, 'Austrumi', 8, 111),
	(103511757, 100011533, 'Ābeļziedi', 8, 111),
	(103511765, 100011533, 'Bērziņi', 8, 111),
	(103511773, 100011533, 'Nātres', 8, 111),
	(103511781, 100011533, 'Siliņi', 8, 111),
	(103511798, 100011533, 'Reņģes', 8, 111),
	(103511837, 100011533, 'Brūžnieki', 8, 111),
	(103511845, 100011533, 'Cerības', 8, 111),
	(103511853, 100011533, 'Dambenieki', 8, 111),
	(103511861, 100011533, 'Kadiķi', 8, 111),
	(103511878, 100011533, 'Kaktusi', 8, 111),
	(103511886, 100011533, 'Kaktusiņi', 8, 111),
	(103511894, 100011533, 'Kapenieki', 8, 111),
	(103511917, 100011533, 'Kļaviņas', 8, 111),
	(103511925, 100011533, 'Lauciņi', 8, 111),
	(103511933, 100011533, 'Lauskas', 8, 111),
	(103511941, 100011533, 'Lielsesava', 8, 111),
	(103511966, 100011533, 'Liepnieki', 8, 111),
	(103511974, 100011533, 'Roņi', 8, 111),
	(103511982, 100011533, 'Smēdes', 8, 111),
	(103511990, 100011533, 'Upenieki', 8, 111),
	(103512027, 100011533, 'Višķeri', 8, 111),
	(103512035, 100011533, 'Kastaņi', 8, 111),
	(103512051, 100011533, 'Šuteņi', 8, 111),
	(103512068, 100011533, 'Šuteņi 2', 8, 111),
	(103512084, 100011533, 'Pūciņi', 8, 111),
	(103512115, 100011533, 'Prīmulas', 8, 111),
	(103512123, 100011533, 'Čivuļi', 8, 111),
	(103512156, 100011533, 'Čivuļi Meiri', 8, 111),
	(103512164, 100011533, 'Pīlādži', 8, 111),
	(103512172, 100011533, 'Stagari', 8, 111),
	(103512308, 100011533, 'Raimondas', 8, 111),
	(103512324, 100011533, 'Saulītes', 8, 111),
	(103599061, 100010660, 'Mazvīburi', 8, 295),
	(103671885, 100011533, 'Ābeles', 8, 111),
	(103671908, 100011533, 'Trani', 8, 111),
	(103944984, 100111942, 'Zelmeņi', 8, 297),
	(103944992, 100111942, 'Ābelītes', 8, 297),
	(103945012, 100111942, 'Kurši', 8, 297),
	(103945020, 100111942, 'Sēļi', 8, 297),
	(103945037, 100111942, 'Zemgaļi', 8, 297),
	(104351082, 100111942, 'Adatas', 8, 297),
	(104351105, 100010636, 'Aizupes', 8, 297),
	(104351154, 100111942, 'Atvari', 8, 297),
	(104351170, 100111942, 'Āboliņi', 8, 297),
	(104351322, 100111942, 'Āmuri', 8, 297),
	(104351371, 100111942, 'Baltā māja', 8, 297),
	(104351443, 100111942, 'Burzmas', 8, 297),
	(104351476, 100111942, 'Celmi', 8, 297),
	(104351523, 100010636, 'Cepļi', 8, 297),
	(104351548, 100111942, 'Ciņi', 8, 297),
	(104351572, 100111942, 'Čiekuri', 8, 297),
	(104351611, 100111942, 'Dimanti', 8, 297),
	(104351628, 100111942, 'Dobuļi', 8, 297),
	(104351644, 100111942, 'Drupas', 8, 297),
	(104351685, 100111942, 'Dzelmes', 8, 297),
	(104351732, 100111942, 'Dzilnas', 8, 297),
	(104351740, 100111942, 'Dzintari', 8, 297),
	(104351757, 100111942, 'Enitēni', 8, 297),
	(104351765, 100111942, 'Ezeri', 8, 297),
	(104351773, 100111942, 'Ēveles', 8, 297),
	(104351781, 100111942, 'Gravas', 8, 297),
	(104351804, 100111942, 'Ieviņas', 8, 297),
	(104351837, 100111942, 'Ilgas', 8, 297),
	(104351853, 100111942, 'Imreiki', 8, 297),
	(104351878, 100111942, 'Īlēni', 8, 297),
	(104352437, 100111942, 'Īves', 8, 297),
	(104352453, 100111942, 'Jasmīni', 8, 297),
	(104352486, 100481428, '7', 8, 297),
	(104352494, 100111942, 'Kamenes', 8, 297),
	(104352517, 100111942, 'Kastaņi', 8, 297),
	(104352558, 100111942, 'Kļavbankas', 8, 297),
	(104352605, 100111942, 'Krasti', 8, 297),
	(104352646, 100111942, 'Krastmalas', 8, 297),
	(104352670, 100111942, 'Kraujas', 8, 297),
	(104352701, 100010636, 'Krūmiņi', 8, 297),
	(104352791, 100111942, 'Kurzemītes', 8, 297),
	(104352814, 100111942, 'Ķildas', 8, 297),
	(104352830, 100111942, 'Laktas', 8, 297),
	(104352847, 100111942, 'Lazdas', 8, 297),
	(104352896, 100111942, 'Lingotāji', 8, 297),
	(104352951, 100111942, 'Līvi', 8, 297),
	(104352984, 100111942, 'Madaras', 8, 297),
	(104353004, 100111942, 'Mazbūras', 8, 297),
	(104353045, 100111942, 'Mazkalēji', 8, 297),
	(104353094, 100111942, 'Mazrundāles muiža', 8, 297),
	(104353117, 100493715, '2', 8, 297),
	(104353125, 100111942, 'Mežmaļi', 8, 297),
	(104353133, 100111942, 'Mucenieki', 8, 297),
	(104353174, 100111942, 'Ozolkrasti', 8, 297),
	(104353262, 100111942, 'Pērkoņi', 8, 297),
	(104353287, 100111942, 'Pīlādži', 8, 297),
	(104353318, 100111942, 'Prīmulas', 8, 297),
	(104353334, 100111942, 'Purviņi', 8, 297),
	(104353383, 100111942, 'Pūpoli', 8, 297),
	(104353414, 100111942, 'Rijnieki', 8, 297),
	(104353430, 100111942, 'Rīti', 8, 297),
	(104353510, 100111942, 'Rozītes', 8, 297),
	(104353592, 100111942, 'Saulgrieži', 8, 297),
	(104353680, 100010636, 'Zilgalvīši', 8, 297),
	(104353744, 100111942, 'Silazvani', 8, 297),
	(104353808, 100111942, 'Sūnas', 8, 297),
	(104353832, 100111942, 'Šalkas', 8, 297),
	(104353873, 100493715, '8', 8, 297),
	(104353912, 100111942, 'Tilti', 8, 297),
	(104353978, 100111942, 'Upeslīči', 8, 297),
	(104354014, 100493715, '22', 8, 297),
	(104354063, 100111942, 'Veldzes', 8, 297),
	(104354102, 100111942, 'Vēji', 8, 297),
	(104354151, 100111942, 'Vētras', 8, 297),
	(104354176, 100111942, 'Vīksnas', 8, 297),
	(104354207, 100111942, 'Vīnkalni', 8, 297),
	(104354223, 100111942, 'Vītoli', 8, 297),
	(104354272, 100111942, 'Zemdegas', 8, 297),
	(104354328, 100111942, 'Zemzari', 8, 297),
	(104354360, 100111942, 'Zvaniņi', 8, 297),
	(104357751, 100010636, 'Bieķi', 8, 286),
	(104357768, 100010636, 'Blušas', 8, 286),
	(104359441, 100010636, 'Jaunkraujas', 8, 286),
	(104359601, 100010636, 'Lielupnieki', 8, 286),
	(104359722, 100010636, 'Ausekļi', 8, 297),
	(104359747, 100010636, 'Kalēji', 8, 297),
	(104359788, 100010636, 'Kalninieki', 8, 297),
	(104359827, 100010636, 'Kalti', 8, 297),
	(104359884, 100010636, 'Kokāļi', 8, 297),
	(104360026, 100010636, 'Līgotņi', 8, 297),
	(104360075, 100010636, 'Mantiņas', 8, 297),
	(104360821, 100010636, 'Mežotnes stacija', 8, 297),
	(104361085, 100010636, 'Pumpuri', 8, 297),
	(104361093, 100010636, 'Rokpeļņi', 8, 297),
	(104361108, 100010636, 'Saulītes', 8, 297),
	(104361124, 100010636, 'Senči', 8, 297),
	(104361317, 100010636, 'Blāzmas', 8, 297),
	(104361366, 100010636, 'Burtnieki', 8, 297),
	(104361374, 100010636, 'Imanti', 8, 297),
	(104361390, 100010636, 'Kraukļi', 8, 297),
	(104361405, 100010636, 'Ķeķīlas', 8, 297),
	(104361470, 100010636, 'Lubiņas', 8, 297),
	(104361792, 100010636, 'Raibiņas', 8, 297),
	(104361977, 100010636, 'Stūpļi', 8, 297),
	(104362255, 100010636, 'Tālavas', 8, 297),
	(104362310, 100010636, 'Vangaļi', 8, 297),
	(104362407, 100010636, 'Ziemeļi', 8, 297),
	(104362431, 100010636, 'Zvēri', 8, 297),
	(104362577, 100010636, 'Žagatas', 8, 297),
	(104367795, 100010636, 'Alejas', 8, 297),
	(104367801, 100010636, 'Brieži', 8, 297),
	(104367826, 100010636, 'Druvas', 8, 297),
	(104367834, 100010636, 'Gundegas', 8, 297),
	(104367842, 100010636, 'Ģēģeri', 8, 297),
	(104367875, 100010636, 'Malenieši', 8, 297),
	(104367906, 100010636, 'Silenieki', 8, 297),
	(104367914, 100010636, 'Ansēni', 8, 297),
	(104368081, 100010636, 'Ošenieki', 8, 286),
	(104368104, 100010636, 'Pīlādžlejas', 8, 286),
	(104368241, 100010636, 'Strautiņi', 8, 286),
	(104368290, 100010636, 'Zadeikas', 8, 286),
	(104368313, 100010636, 'Bērtuži', 8, 297),
	(104368506, 100010636, 'Brenči', 8, 297),
	(104368514, 100010636, 'Mauriņi', 8, 297),
	(104368522, 100010636, 'Mežagas 1', 8, 297),
	(104368530, 100010636, 'Mežagas 2', 8, 297),
	(104368547, 100010636, 'Mežagas 3', 8, 297),
	(104368563, 100010636, 'Štumbergi', 8, 297),
	(104368588, 100010636, 'Grīvas', 8, 297),
	(104368596, 100010636, 'Liepas', 8, 297),
	(104368602, 100010636, 'Līdakas', 8, 297),
	(104368684, 100010636, 'Akmentiņi', 8, 286),
	(104368692, 100010636, 'Bumburi', 8, 286),
	(104368707, 100010636, 'Dziļlejas', 8, 286),
	(104368715, 100010636, 'Egles', 8, 286),
	(104368723, 100010636, 'Eversi', 8, 286),
	(104368731, 100010636, 'Grimmas', 8, 286),
	(104368772, 100010636, 'Kauči', 8, 286),
	(104368797, 100010636, 'Krišjāņi', 8, 286),
	(104368803, 100010636, 'Lakstīgalas', 8, 286),
	(104368811, 100010636, 'Lati', 8, 286),
	(104368828, 100010636, 'Liepiņas', 8, 286),
	(104368836, 100010636, 'Līdumnieki', 8, 286),
	(104368844, 100010636, 'Maiņas', 8, 286),
	(104368852, 100010636, 'Mazolavas', 8, 286),
	(104368860, 100010636, 'Mežarozes', 8, 286),
	(104368877, 100010636, 'Pļavnieki', 8, 286),
	(104368885, 100010636, 'Rutki', 8, 286),
	(104368893, 100010636, 'Silabrieži', 8, 286),
	(104368908, 100010636, 'Silarāji', 8, 286),
	(104368916, 100010636, 'Silarāji 1', 8, 286),
	(104368924, 100010636, 'Skolnieki', 8, 286),
	(104368932, 100010636, 'Straumes', 8, 286),
	(104368957, 100010636, 'Stūrgalvji', 8, 286),
	(104368965, 100010636, 'Sūnāji', 8, 286),
	(104368973, 100010636, 'Uzkalniņi', 8, 286),
	(104368981, 100010636, 'Vītiņi', 8, 286),
	(104369001, 100010636, 'Anteļi', 8, 297),
	(104369018, 100010636, 'Āžeļi', 8, 297),
	(104369026, 100010636, 'Baļči', 8, 297),
	(104369042, 100010636, 'Bangas', 8, 297),
	(104369050, 100010636, 'Bāliņi', 8, 297),
	(104369067, 100010636, 'Beķeri', 8, 286),
	(104369075, 100010636, 'Bērziņi', 8, 297),
	(104369083, 100010636, 'Būčas', 8, 297),
	(104369091, 100010636, 'Cērnes', 8, 297),
	(104369106, 100010636, 'Dāboliņi', 8, 297),
	(104369114, 100010636, 'Eiduki', 8, 297),
	(104369122, 100010636, 'Gādnieki', 8, 297),
	(104369130, 100010636, 'Grantiņi', 8, 297),
	(104369147, 100010636, 'Graudiņi', 8, 297),
	(104369155, 100010636, 'Grāvīši', 8, 297),
	(104369163, 100010636, 'Kalna Vīndedži', 8, 297),
	(104369171, 100010636, 'Kalniņi', 8, 297),
	(104369235, 100010636, 'Kāvi', 8, 297),
	(104369243, 100010636, 'Klibjāņi', 8, 297),
	(104369251, 100010636, 'Lapiņas', 8, 297),
	(104369268, 100010636, 'Lejiņas', 8, 297),
	(104369276, 100010636, 'Lielspricēni', 8, 297),
	(104369284, 100010636, 'Līči', 8, 297),
	(104369292, 100010636, 'Līdumi', 8, 297),
	(104369307, 100010636, 'Maldoņi', 8, 297),
	(104369315, 100010636, 'Maldoņi 1', 8, 297),
	(104369323, 100010636, 'Mazdūmiņi', 8, 297),
	(104369331, 100010636, 'Mazstūrēni', 8, 297),
	(104369348, 100010636, 'Mazumuļi', 8, 297),
	(104369356, 100010636, 'Mazvaļņi', 8, 297),
	(104369364, 100010636, 'Māliņi', 8, 297),
	(104369380, 100010636, 'Miltiņi', 8, 297),
	(104369397, 100010636, 'Nadziņi', 8, 297),
	(104369403, 100010636, 'Pārslas', 8, 297),
	(104369411, 100010636, 'Plostiņi', 8, 297),
	(104369428, 100010636, 'Plūdoņi', 8, 297),
	(104369436, 100010636, 'Priedaiņi', 8, 297),
	(104369444, 100010636, 'Priežpuri', 8, 297),
	(104369452, 100010636, 'Radziņi', 8, 297),
	(104369460, 100010636, 'Riekstiņi', 8, 297),
	(104369477, 100010636, 'Riteņi', 8, 297),
	(104369485, 100010636, 'Robežnieki', 8, 297),
	(104369508, 100010636, 'Sarmas', 8, 297),
	(104369532, 100010636, 'Smedes', 8, 297),
	(104369540, 100010636, 'Spalviņas', 8, 297),
	(104369557, 100010636, 'Spricēni', 8, 297),
	(104369573, 100010636, 'Spuldzes', 8, 297),
	(104369581, 100010636, 'Stari', 8, 297),
	(104369604, 100010636, 'Stiepuļi', 8, 297),
	(104369612, 100010636, 'Stūrēni', 8, 297),
	(104369637, 100010636, 'Stūrīši', 8, 297),
	(104369653, 100010636, 'Umuļi', 8, 297),
	(104369678, 100010636, 'Upmaļi', 8, 297),
	(104369694, 100010636, 'Vairogi', 8, 297),
	(104369725, 100010636, 'Vārpas', 8, 297),
	(104369733, 100010636, 'Veides', 8, 297),
	(104369741, 100010636, 'Virzas', 8, 297),
	(104369758, 100010636, 'Vīndedži', 8, 297),
	(104369766, 100010636, 'Vīstiķi', 8, 297),
	(104369774, 100010636, 'Zariņi', 8, 297),
	(104369782, 100010636, 'Zemītes', 8, 297),
	(104369790, 100010636, 'Kārkliņi', 8, 286),
	(104369805, 100010636, 'Tupiņi', 8, 297),
	(104369813, 100010636, 'Skujukrogs', 8, 293),
	(104406542, 100112132, 'Ainas', 8, 295),
	(104406550, 100420588, 'Aizvēji', 8, 295),
	(104406567, 100112132, 'Alejas', 8, 295),
	(104406575, 100010660, 'Alejnieki', 8, 295),
	(104406583, 100420563, 'Apses', 8, 295),
	(104406591, 100112132, 'Atpūtas', 8, 295),
	(104406606, 100112132, 'Atvari', 8, 295),
	(104406614, 100112132, 'Auziņas', 8, 295),
	(104406622, 100112132, 'Ābeles', 8, 295),
	(104406630, 100420563, 'Baloži', 8, 295),
	(104406647, 100112132, 'Bērzi', 8, 295),
	(104406655, 100010660, 'Bērziņi', 8, 295),
	(104406663, 100112132, 'Caunes', 8, 295),
	(104406671, 100112132, 'Ceļmalas', 8, 295),
	(104406688, 100112132, 'Ceriņi', 8, 295),
	(104406696, 100112132, 'Cirši', 8, 295),
	(104406702, 100112132, 'Dardedzes', 8, 295),
	(104406710, 100112132, 'Dravas', 8, 295),
	(104406727, 100420563, 'Dumbrāji', 8, 295),
	(104406735, 100112132, 'Dzelmes', 8, 295),
	(104406751, 100420563, 'Dzilnas', 8, 295),
	(104406768, 100010660, 'Dzintari', 8, 295),
	(104406792, 100112132, 'Dzirnavnieki', 8, 295),
	(104406815, 100112132, 'Grāvīši', 8, 295),
	(104406928, 100420563, 'Griezes', 8, 295),
	(104406944, 100420563, 'Gundegas', 8, 295),
	(104406977, 100112132, 'Ieviņas', 8, 295),
	(104406985, 100420563, 'Indras', 8, 295),
	(104406993, 100112132, 'Indrāni', 8, 295),
	(104407005, 100112132, 'Induļi', 8, 295),
	(104407021, 100420563, 'Irbītes', 8, 295),
	(104407046, 100420563, 'Jaunkaktiņi', 8, 295),
	(104407062, 100112132, 'Kadiķi', 8, 295),
	(104407070, 100420563, 'Kaijas', 8, 295),
	(104407087, 100112132, 'Kalni', 8, 295),
	(104407095, 100112132, 'Kastaņas', 8, 295),
	(104407101, 100112132, 'Kārlīši', 8, 295),
	(104407142, 100112132, 'Krasti', 8, 295),
	(104407150, 100112132, 'Kraujas', 8, 295),
	(104407167, 100112132, 'Lauras', 8, 295),
	(104407175, 100112132, 'Lejas', 8, 295),
	(104407191, 100112132, 'Lēpītes', 8, 295),
	(104407222, 100112132, 'Liedagas', 8, 295),
	(104407247, 100112132, 'Līdakas', 8, 295),
	(104407310, 100420563, 'Līvi', 8, 295),
	(104417338, 100420588, '23', 8, 295),
	(104417346, 100420563, 'Mārtiņi', 8, 295),
	(104417354, 100112132, 'Meldri', 8, 295),
	(104417362, 100112132, 'Mētras', 8, 295),
	(104417370, 100112132, 'Miglas', 8, 295),
	(104417387, 100420563, 'Niedras', 8, 295),
	(104417401, 100112132, 'Ošēni', 8, 295),
	(104417418, 100112132, 'Ozoliņi', 8, 295),
	(104417426, 100112132, 'Pamati', 8, 295),
	(104417434, 100420563, 'Pārslas', 8, 295),
	(104417442, 100112132, 'Piebalgas', 8, 295),
	(104417450, 100420563, 'Pīlādži', 8, 295),
	(104417467, 100112132, 'Pumpuriņi', 8, 295),
	(104417475, 100420563, 'Rasas', 8, 295),
	(104417483, 100112132, 'Riekstiņi', 8, 295),
	(104417491, 100420563, 'Rudeņi', 8, 295),
	(104417506, 100010660, 'Rukaiši', 8, 295),
	(104417514, 100112132, 'Rūķīši', 8, 295),
	(104417522, 100112132, 'Sargi', 8, 295),
	(104417530, 100112132, 'Sarmas', 8, 295),
	(104417547, 100420563, 'Saulītes', 8, 295),
	(104417555, 100112132, 'Silavas', 8, 295),
	(104417563, 100112132, 'Sniedziņi', 8, 295),
	(104417588, 100112132, 'Sprīdīši', 8, 295),
	(104417596, 100112132, 'Sprīži', 8, 295),
	(104417602, 100112132, 'Straumes', 8, 295),
	(104417610, 100420563, 'Strautiņi', 8, 295),
	(104417627, 100420563, 'Tālavas', 8, 295),
	(104417635, 100112132, 'Upeslīči', 8, 295),
	(104417643, 100420563, 'Vālodzes', 8, 295),
	(104417651, 100112132, 'Vārpas', 8, 295),
	(104417668, 100112132, 'Veldzes', 8, 295),
	(104417676, 100420563, 'Vēsmas', 8, 295),
	(104417684, 100010660, 'Vizbuļi', 8, 295),
	(104417692, 100420563, 'Vītoli', 8, 295),
	(104417707, 100010660, 'Zemdegas', 8, 295),
	(104417715, 100420563, 'Zemītes', 8, 295),
	(104417723, 100112132, 'Ziediņi', 8, 295),
	(104417731, 100420563, 'Zīles', 8, 295),
	(104417748, 100420563, 'Zītari', 8, 295),
	(104417756, 100112132, 'Zvaigznes', 8, 295),
	(104417764, 100420563, 'Zvejnieki', 8, 295),
	(104417772, 100112132, 'Kamenes', 8, 295),
	(104417780, 100420627, 'Ausmas', 8, 295),
	(104417797, 100420627, 'Blāzmas', 8, 295),
	(104417803, 100420627, 'Saules', 8, 295),
	(104417811, 100420627, 'Salnas', 8, 295),
	(104417836, 100112132, 'Gaismas', 8, 295),
	(104417844, 104417860, 'Gaujas', 8, 295),
	(104417852, 104417860, 'Gaujmalas', 8, 295),
	(104417860, 104417860, 'Tīrumi', 8, 295),
	(104417877, 104417860, 'Garvēderi', 8, 295),
	(104417885, 100010660, 'Anzēni', 8, 295),
	(104417893, 100010660, 'Apšenieki', 8, 295),
	(104417908, 100010660, 'Asari', 8, 295),
	(104417916, 100010660, 'Atmodas', 8, 295),
	(104417924, 100010660, 'Atomi', 8, 295),
	(104417932, 100010660, 'Audzes', 8, 295),
	(104417940, 100010660, 'Austrumi', 8, 295),
	(104417957, 100010660, 'Avotiņi', 8, 295),
	(104417965, 100010660, 'Ābelītes', 8, 295),
	(104417973, 100010660, 'Bandenieki', 8, 295),
	(104417981, 100010660, 'Baznīckrogs', 8, 295),
	(104417998, 100010660, 'Brēdiķi', 8, 295),
	(104418001, 100010660, 'Brūveri', 8, 295),
	(104418018, 100010660, 'Bullēni', 8, 295),
	(104418026, 100010660, 'Bumbieres', 8, 295),
	(104418034, 100010660, 'Cielavas', 8, 295),
	(104418042, 100010660, 'Cīruļi', 8, 295),
	(104418067, 100010660, 'Cukuriņi', 8, 295),
	(104418075, 100010660, 'Čiekuri', 8, 295),
	(104418083, 100010660, 'Dambīši', 8, 295),
	(104418114, 100010660, 'Dimanti', 8, 295),
	(104418130, 100010660, 'Dimzēni', 8, 295),
	(104418147, 100010660, 'Dravnieki', 8, 295),
	(104418155, 100010660, 'Druvas', 8, 295),
	(104418163, 100010660, 'Dūmiņi', 8, 295),
	(104418171, 100010660, 'Dzimteņi', 8, 295),
	(104418188, 100010660, 'Ezernieki', 8, 295),
	(104418196, 100010660, 'Gaiķi', 8, 295),
	(104418202, 100010660, 'Galenieki', 8, 295),
	(104418210, 100010660, 'Gravas', 8, 295),
	(104418227, 100010660, 'Grābēni', 8, 295),
	(104418235, 100010660, 'Grundiņi', 8, 295),
	(104418243, 100010660, 'Gubēni', 8, 295),
	(104418251, 100010660, 'Ilgas', 8, 295),
	(104418268, 100010660, 'Jaunaudzes', 8, 295),
	(104418284, 100010660, 'Jaunzemji', 8, 295),
	(104418292, 100010660, 'Kaktiņi', 8, 295),
	(104418307, 100010660, 'Kalna Anzēni', 8, 295),
	(104418315, 100010660, 'Kalniņi', 8, 295),
	(104418323, 100010660, 'Kamoliņi', 8, 295),
	(104418331, 100010660, 'Kārkliņi', 8, 295),
	(104418348, 100010660, 'Klači', 8, 295),
	(104418364, 100010660, 'Kļaviņas', 8, 295),
	(104418372, 100010660, 'Kožeļi', 8, 295),
	(104418397, 100010660, 'Kraukļi', 8, 295),
	(104418403, 100010660, 'Kreņģeļi', 8, 295),
	(104418411, 100010660, 'Krūmales', 8, 295),
	(104418428, 100010660, 'Kukāri', 8, 295),
	(104418436, 100010660, 'Lauciņi', 8, 295),
	(104418444, 100010660, 'Liepiņas', 8, 295),
	(104418452, 100010660, 'Liksmaņi', 8, 295),
	(104418460, 100010660, 'Līdumnieki', 8, 295),
	(104418477, 100010660, 'Līgotņi', 8, 295),
	(104418485, 100010660, 'Ludzenieki', 8, 295),
	(104418493, 100010660, 'Mazbullēni', 8, 295),
	(104418508, 100010660, 'Mellīši', 8, 295),
	(104418516, 100010660, 'Meļļi', 8, 295),
	(104418524, 100010660, 'Mežasīļi', 8, 295),
	(104418532, 100010660, 'Meža Stūrīši', 8, 295),
	(104418540, 100010660, 'Mežiņi', 8, 295),
	(104418557, 100010660, 'Mežmales', 8, 295),
	(104418565, 100010660, 'Mežvidi', 8, 295),
	(104418573, 100010660, 'Pakalni', 8, 295),
	(104418581, 100010660, 'Šķībais krogs', 8, 295),
	(104418598, 100010660, 'Pavasari', 8, 295),
	(104418604, 100010660, 'Pērles', 8, 295),
	(104418612, 100010660, 'Prātnieki', 8, 295),
	(104418637, 100010660, 'Priedītes', 8, 295),
	(104418645, 100010660, 'Putniņi', 8, 295),
	(104418653, 100010660, 'Ratenieki', 8, 295),
	(104418661, 100010660, 'Raudiņas', 8, 295),
	(104418678, 100010660, 'Ražas', 8, 295),
	(104418686, 100010660, 'Rijnieki', 8, 295),
	(104418694, 100010660, 'Rogas', 8, 295),
	(104418700, 100010660, 'Rudzīši', 8, 295),
	(104418717, 100010660, 'Sarkaņi', 8, 295),
	(104418725, 100010660, 'Saujiņas', 8, 295),
	(104418733, 100010660, 'Senči', 8, 295),
	(104418741, 100010660, 'Silasudmalas', 8, 295),
	(104418766, 100010660, 'Skudras', 8, 295),
	(104418774, 100010660, 'Skujēni', 8, 295),
	(104418805, 100010660, 'Skuķi', 8, 295),
	(104418821, 100010660, 'Smildziņas', 8, 295),
	(104418838, 100010660, 'Stiebriņi', 8, 295),
	(104418846, 100010660, 'Strauši', 8, 295),
	(104418854, 100010660, 'Stūrīši', 8, 295),
	(104418862, 100010660, 'Sveņķi', 8, 295),
	(104418870, 100010660, 'Tauriņi', 8, 295),
	(104418887, 100010660, 'Tiltiņi', 8, 295),
	(104418901, 100010660, 'Tiltiņu Krejotava', 8, 295),
	(104418918, 100010660, 'Upmalnieki', 8, 295),
	(104418926, 100010660, 'Upmaļi', 8, 295),
	(104418942, 100010660, 'Urštēni', 8, 295),
	(104418950, 100010660, 'Vaivari', 8, 295),
	(104418967, 100010660, 'Vasariņas', 8, 295),
	(104418975, 100010660, 'Vecbullēni', 8, 295),
	(104418983, 100010660, 'Vecigauņi', 8, 295),
	(104418991, 100010660, 'Veckaupēni', 8, 295),
	(104419003, 100010660, 'Vecmālnieki', 8, 295),
	(104419011, 100010660, 'Veldres', 8, 295),
	(104419028, 100010660, 'Vidukļi', 8, 295),
	(104419036, 100010660, 'Virsīši', 8, 295),
	(104419044, 100010660, 'Virsīte', 8, 295),
	(104419052, 100010660, 'Virzas', 8, 295),
	(104419060, 100010660, 'Vīburi', 8, 295),
	(104419077, 100010660, 'Vīksnas', 8, 295),
	(104419085, 100010660, 'Vīndedži', 8, 295),
	(104419093, 100010660, 'Vītoliņi', 8, 295),
	(104419108, 100010660, 'Zaļlejas', 8, 295),
	(104419116, 100010660, 'Zari', 8, 295),
	(104419124, 100010660, 'Zeltiņi', 8, 295),
	(104419132, 100010660, 'Zemgaļi', 8, 295),
	(104419140, 100010660, 'Ziemeļi', 8, 295),
	(104419157, 100010660, 'Zīlītes', 8, 295),
	(104419165, 100010660, 'Žubītes', 8, 295),
	(104419173, 100010660, 'Kapūnas', 8, 295),
	(104419181, 100010660, 'Gudrunas', 8, 295),
	(104802677, 100112132, 'Ēnas', 8, 295),
	(104802941, 100010660, 'Liepari', 8, 295),
	(104802974, 100010660, 'Lieparvilki', 8, 295),
	(104803814, 100112132, 'Svitenes pamatskola', 8, 295),
	(104803871, 100112132, 'Timermaņi', 8, 295),
	(104803896, 100112132, 'Kļavas', 8, 295),
	(104805633, 100010660, 'Oši', 8, 295),
	(104805641, 100112132, 'Šķesteri', 8, 295),
	(104805658, 100010660, 'Īcēni', 8, 295),
	(104839327, 100010636, 'Margas', 8, 286),
	(104839407, 100010636, 'Ķesteri', 8, 297),
	(104839794, 100111942, 'Avoti', 8, 297),
	(104839800, 100111942, 'Avoti 1', 8, 297),
	(104839817, 100111942, 'Lejnieki 1', 8, 297),
	(104839825, 100111942, 'Lejnieki 2', 8, 297),
	(104839833, 100111942, 'Lejnieki 3', 8, 297),
	(104839841, 100111942, 'Papeles', 8, 297),
	(104839858, 100111942, 'Apses', 8, 297),
	(104839866, 100010636, 'Rundāles Strautiņi', 8, 297),
	(104839874, 100111942, 'Upesmāja', 8, 297),
	(104839905, 100010636, 'Namdari', 8, 286),
	(105150881, 104417860, 'Māliņi', 8, 295),
	(105248048, 100011533, 'Naudiņi', 8, 111),
	(105281946, 100010660, 'Dzintariņi', 8, 295),
	(105281954, 100010660, 'Gubēnu ferma', 8, 295),
	(105281962, 100010660, 'Jaunmeļļi', 8, 295),
	(105281970, 104417860, 'Liniņi 1', 8, 295),
	(105281987, 100010660, 'Lielkrastiņi', 8, 295),
	(105281995, 104417860, 'Ķirši', 8, 295),
	(105282007, 100010660, 'Upmalnieki 1 ērberģis', 8, 295),
	(105282015, 100010660, 'Upmalnieki 1', 8, 295),
	(105282023, 100010660, 'Transformatoru stacija', 8, 295),
	(105282031, 100010660, 'Kodināšanas punkts', 8, 295),
	(105282048, 100112132, 'Bajāri', 8, 295),
	(105282056, 100010660, 'Līdumi', 8, 295),
	(105282064, 100010660, 'Jaunsniedziņi', 8, 295),
	(105291555, 100112132, 'Ošu kalte', 8, 295),
	(105291563, 100010660, 'Rietumi', 8, 295),
	(105291571, 100010660, 'Vecbrūveri', 8, 295),
	(105291596, 100112132, 'Veikals Svitene', 8, 295),
	(105291627, 100112132, 'Spara mītne', 8, 295),
	(105291651, 100112132, 'Mehāniskās darbnīcas', 8, 295),
	(105291668, 100112132, 'Svaru māja', 8, 295),
	(105291748, 100112132, 'Mākoņi', 8, 295),
	(105291756, 100112132, 'Sapņi', 8, 295),
	(105291764, 100112132, 'Attīrīšanas iekārtas', 8, 295),
	(105291772, 100010660, 'Ferma', 8, 295),
	(105291780, 100010660, 'Dunduri', 8, 295),
	(105291797, 100112132, 'Rezerves daļu noliktava', 8, 295),
	(105291803, 100010660, 'Mazkalniņi', 8, 295),
	(105291811, 100112132, 'Dispečeru ēka', 8, 295),
	(105291828, 100112132, 'Poļu kalte', 8, 295),
	(105291836, 100112132, 'Kastaņu kalte', 8, 295),
	(105291844, 100112132, 'Zāģētava', 8, 295),
	(105291852, 100010660, 'Kautuve', 8, 295),
	(105291860, 100112132, 'Minerālmēslu noliktava', 8, 295),
	(105291877, 100112132, 'Dūjas', 8, 295),
	(105291893, 100010660, 'Vīksnas 2', 8, 295),
	(105291908, 100010660, 'Vīksnas 1', 8, 295),
	(105291916, 100010660, 'Jaunbrēdiķi', 8, 295),
	(105291924, 100010660, 'Bērsteles baznīca', 8, 295),
	(105291965, 100010660, 'Kalves', 8, 295),
	(105291981, 100010660, 'Lazdiņas', 8, 295),
	(105293831, 100011533, 'Jaunavotiņi', 8, 111),
	(105393783, 100011533, 'Putni', 8, 111),
	(105445692, 100010660, 'Krastiņi', 8, 295),
	(105447856, 100420563, 'Ezerkrasti', 8, 295),
	(105448046, 100112132, 'Pagastmāja', 8, 295),
	(105544271, 100011533, 'Vēsmas', 8, 111),
	(105601736, 100111942, 'Aizupes', 8, 297),
	(105664725, 104417860, 'Avenes', 8, 295),
	(105664887, 100010660, 'Birzuļi', 8, 295),
	(105665085, 100010660, 'Strēlnieki', 8, 295),
	(105668314, 100010660, 'Derības', 8, 295),
	(105668322, 100010660, 'Kraujiņas', 8, 295),
	(105668347, 100010660, 'Pagrabs Sprīdīši', 8, 295),
	(105746964, 100011533, 'Ežu kapi', 8, 111),
	(105747017, 100011533, 'Bajāru klēts', 8, 111),
	(105747025, 100011533, 'Šuteņu graudu noliktava', 8, 111),
	(105747033, 100011533, 'Degvielas bāze', 8, 111),
	(105797561, 100011533, 'Skursteņskola', 8, 111),
	(105797754, 100011533, 'Baltā māja', 8, 111),
	(105802656, 100011533, 'Lielšuteņi', 8, 111),
	(105817555, 100011533, 'Saules Sapņi', 8, 111),
	(105823856, 100011533, 'Kokles', 8, 111),
	(105845406, 100111942, 'Pilsrundāles katlu māja', 8, 297),
	(105845414, 100111942, 'Pilsrundāles vidusskola', 8, 297),
	(105845422, 100111942, 'Pilsrundāles ūdenstornis', 8, 297),
	(105882524, 100011533, 'Lāses', 8, 111),
	(105882532, 100011533, 'Vecčersi', 8, 111),
	(105882678, 100011533, 'Jaunčabuti', 8, 111),
	(105882686, 100011533, 'Sakarnieki', 8, 111),
	(105885490, 100011533, 'Sieti', 8, 111),
	(105885505, 100011533, 'Vecbērziņi', 8, 111),
	(105885513, 100011533, 'Staltais', 8, 111),
	(105885884, 100011533, 'Arājiņi', 8, 111),
	(105931323, 100111942, 'Pilsrundāle 1', 8, 297),
	(105949445, 100011533, 'Vidusmuiža', 8, 111),
	(105949453, 100011533, 'Stari', 8, 111),
	(105949461, 100011533, 'Slociņas', 8, 111),
	(105949478, 100011533, 'Mazčivulīši', 8, 111),
	(105949486, 100011533, 'Sieksta', 8, 111),
	(105952306, 100011533, 'Līdumnieki', 8, 111),
	(105952740, 100011533, 'Lielsesava 2', 8, 111),
	(105989665, 100011533, 'Transformatora ēka TP-2072', 8, 111),
	(105999893, 100011533, 'Lapas', 8, 111),
	(106031288, 100011533, 'Transformatora ēka TP-2005', 8, 111),
	(106031296, 100011533, 'Transformatora ēka TP-2040', 8, 111),
	(106031302, 100011533, 'Transformatora ēka TP-2053', 8, 111),
	(106031310, 100011533, 'Transformatora ēka TP-2071', 8, 111),
	(106033138, 100011533, 'Klāvu siltumnīca', 8, 111),
	(106034775, 100010636, 'Bite tornis', 8, 297),
	(106050572, 100111942, 'Rundāles pils', 8, 297),
	(106063837, 100111942, 'Transformatora ēka TP-4758', 8, 297),
	(106063845, 100111942, 'Transformatora ēka TP-4745', 8, 297),
	(106063878, 100111942, 'Transformatora ēka TP-4719', 8, 297),
	(106063886, 100010636, 'Transformatora ēka TP-4701', 8, 297),
	(106063894, 100112132, 'Transformatora ēka TP-4215', 8, 295),
	(106063900, 100010660, 'Transformatora ēka TP-4214', 8, 295),
	(106090470, 100011533, 'Transformatora ēka TP-2014', 8, 111),
	(106173228, 100011533, 'Biogāzes stacija Lāses', 8, 111),
	(106178165, 100111942, 'Transformatora ēka TP-4757', 8, 297),
	(106187736, 100011533, 'Transformatora ēka TP-2918', 8, 111),
	(106189514, 100111942, 'Bedrītis', 8, 297),
	(106189530, 100010636, 'Meža Rūķīši', 8, 286),
	(106190123, 100010636, 'Laukari', 8, 297),
	(106190131, 100112132, 'Transformatora ēka TP-4220', 8, 295),
	(106199340, 100010636, 'Vecsaules', 8, 297),
	(106199357, 100010636, 'Dzirnupe', 8, 297),
	(106202368, 100011533, 'Līdumnieki 1', 8, 111),
	(106203482, 100010636, 'Graviņas', 8, 297),
	(106207842, 100011533, 'Lapiņas', 8, 111),
	(106223078, 100010636, 'Mežotnes baznīca', 8, 297),
	(106241473, 100010636, 'Kņadas', 8, 297),
	(106247267, 100010636, 'Urgas', 8, 297),
	(106263956, 100010636, 'Bajāri', 8, 297),
	(106267867, 100010660, 'Zariņi', 8, 295),
	(106276722, 100010636, 'Artas', 8, 297),
	(106284248, 100111942, 'Pilsrundāles garāža 2', 8, 297),
	(106284256, 100111942, 'Pilsrundāles garāža 3', 8, 297),
	(106284264, 100111942, 'Pilsrundāles garāža 4', 8, 297),
	(106284272, 100111942, 'Pilsrundāles garāža 5', 8, 297),
	(106284280, 100111942, 'Pilsrundāles garāža 6', 8, 297),
	(106284297, 100111942, 'Pilsrundāles garāža 7', 8, 297),
	(106284303, 100111942, 'Pilsrundāles garāža 8', 8, 297),
	(106284311, 100111942, 'Pilsrundāles garāža 10', 8, 297),
	(106284328, 100111942, 'Pilsrundāles garāža 11', 8, 297),
	(106284336, 100111942, 'Pilsrundāles garāža 12', 8, 297),
	(106284344, 100111942, 'Pilsrundāles garāža 13', 8, 297),
	(106284352, 100111942, 'Pilsrundāles garāža 14', 8, 297),
	(106284360, 100111942, 'Pilsrundāles garāža 15', 8, 297),
	(106284377, 100111942, 'Pilsrundāles garāža 16', 8, 297),
	(106284385, 100111942, 'Pilsrundāles garāža 17', 8, 297),
	(106284393, 100111942, 'Pilsrundāles garāža 18', 8, 297),
	(106284408, 100111942, 'Pilsrundāles garāža 19', 8, 297),
	(106284416, 100111942, 'Pilsrundāles garāža 20', 8, 297),
	(106284424, 100111942, 'Pilsrundāles garāža 21', 8, 297),
	(106284432, 100111942, 'Pilsrundāles garāža 22', 8, 297),
	(106284440, 100111942, 'Pilsrundāles garāža 23', 8, 297),
	(106284457, 100111942, 'Pilsrundāles garāža 24', 8, 297),
	(106284465, 100111942, 'Pilsrundāles garāža 25', 8, 297),
	(106284473, 100111942, 'Pilsrundāles garāža 26', 8, 297),
	(106284481, 100111942, 'Pilsrundāles garāža 27', 8, 297),
	(106284498, 100111942, 'Pilsrundāles garāža 28', 8, 297),
	(106284504, 100111942, 'Pilsrundāles garāža 29', 8, 297),
	(106284512, 100111942, 'Pilsrundāles garāža 30', 8, 297),
	(106284520, 100111942, 'Pilsrundāles garāža 31', 8, 297),
	(106284537, 100111942, 'Pilsrundāles garāža 32', 8, 297),
	(106284545, 100111942, 'Pilsrundāles garāža 33', 8, 297),
	(106284553, 100111942, 'Pilsrundāles garāža 34', 8, 297),
	(106284561, 100111942, 'Pilsrundāles garāža 35', 8, 297),
	(106284578, 100111942, 'Pilsrundāles garāža 36', 8, 297),
	(106284586, 100111942, 'Pilsrundāles garāža 37', 8, 297),
	(106284594, 100111942, 'Pilsrundāles garāža 38', 8, 297),
	(106284600, 100111942, 'Pilsrundāles garāža 39', 8, 297),
	(106284617, 100111942, 'Pilsrundāles garāža 40', 8, 297),
	(106284625, 100111942, 'Pilsrundāles garāža 41', 8, 297),
	(106284633, 100111942, 'Pilsrundāles garāža 42', 8, 297),
	(106284641, 100111942, 'Pilsrundāles garāža 43', 8, 297),
	(106284658, 100111942, 'Pilsrundāles garāža 44', 8, 297),
	(106284666, 100111942, 'Pilsrundāles garāža 45', 8, 297),
	(106284674, 100111942, 'Pilsrundāles garāža 46', 8, 297),
	(106284682, 100111942, 'Pilsrundāles garāža 47', 8, 297),
	(106284690, 100111942, 'Pilsrundāles garāža 48', 8, 297),
	(106284705, 100111942, 'Pilsrundāles garāža 49', 8, 297),
	(106284713, 100111942, 'Pilsrundāles garāža 50', 8, 297),
	(106284721, 100111942, 'Pilsrundāles garāža 52', 8, 297),
	(106284738, 100111942, 'Pilsrundāles garāža 53', 8, 297),
	(106284746, 100111942, 'Pilsrundāles garāža 54', 8, 297),
	(106284754, 100111942, 'Pilsrundāles garāža 55', 8, 297),
	(106284762, 100111942, 'Pilsrundāles garāža 56', 8, 297),
	(106284770, 100111942, 'Pilsrundāles garāža 57', 8, 297),
	(106284787, 100111942, 'Pilsrundāles garāža 58', 8, 297),
	(106284795, 100111942, 'Pilsrundāles garāža 59', 8, 297),
	(106284801, 100111942, 'Pilsrundāles garāža 60', 8, 297),
	(106284818, 100111942, 'Pilsrundāles garāža 61', 8, 297),
	(106284826, 100111942, 'Pilsrundāles garāža 62', 8, 297),
	(106284834, 100111942, 'Pilsrundāles garāža 63', 8, 297),
	(106284842, 100111942, 'Pilsrundāles garāža 64', 8, 297),
	(106284850, 100111942, 'Pilsrundāles garāža 65', 8, 297),
	(106284867, 100111942, 'Pilsrundāles garāža 66', 8, 297),
	(106284875, 100111942, 'Pilsrundāles garāža 67', 8, 297),
	(106284883, 100111942, 'Pilsrundāles garāža 68', 8, 297),
	(106290604, 100010636, 'Krastiņi', 8, 297),
	(106291116, 100010636, 'Jēdžūni', 8, 297),
	(106291124, 100010636, 'Jaunjēdžūni', 8, 297),
	(106291132, 100010636, 'Jaunstrautiņi', 8, 297),
	(106292640, 100011533, 'Žubes', 8, 111),
	(106377073, 100010660, 'Galiņi', 8, 295),
	(106377081, 100010660, 'Pumpuri', 8, 295),
	(106377098, 100010660, 'Laimdotas', 8, 295),
	(106377104, 100010660, 'Kalvīši', 8, 295),
	(106377178, 100010636, 'Indras', 8, 297),
	(106377194, 100010636, 'Grauži', 8, 297),
	(106400588, 100112132, 'Svitenes muižas kapliča', 8, 295),
	(106401034, 100111942, 'Rudeņi', 8, 297),
	(106401042, 100111942, 'Pilsrundāles veikals', 8, 297),
	(106409241, 100011533, 'Jānīši', 8, 111),
	(106432317, 100010660, 'Bāzes stacija', 8, 295),
	(106434675, 100011533, 'Buķi', 8, 111),
	(106457018, 100011533, 'Stagari-Juri', 8, 111),
	(106465531, 100011533, 'Vilki', 8, 111),
	(106487163, 100011533, 'Saulstariņi', 8, 111),
	(106490258, 100010636, 'Virši', 8, 286),
	(106490274, 100010636, 'Avotiņi', 8, 297),
	(106498578, 100011533, 'Skursteņmuiža', 8, 111),
	(106498586, 100011533, 'Skursteņu kalte', 8, 111),
	(106535362, 100010636, 'Bumburi 1', 8, 286),
	(106535370, 100111942, 'Lauriņi', 8, 297),
	(106535387, 100481428, '5', 8, 297),
	(106535395, 100481428, '9', 8, 297),
	(106535418, 100010636, 'Lielupnieki 1', 8, 286),
	(106535426, 100010660, 'Grābēni 1', 8, 295),
	(106536813, 100010660, 'Grābēni 2', 8, 295),
	(106548916, 100010636, 'Lielupes', 8, 286),
	(106584028, 100111942, 'Dzilgas', 8, 297),
	(106584036, 100111942, 'Virpuļi', 8, 297),
	(106584358, 100111942, 'Pūpolīši', 8, 297),
	(106605232, 100011533, 'Tālaviņas', 8, 111),
	(106621608, 100011533, 'Salnas', 8, 111),
	(106645436, 100011533, 'Melderu torņi', 8, 111),
	(106646550, 100011533, 'Laimas', 8, 111),
	(106669875, 100111942, 'Pilsrundāles kafejnīca', 8, 297),
	(106707942, 100111942, 'Tirgotava', 8, 297),
	(106708438, 100010636, 'Noras', 8, 297),
	(106736225, 100010660, 'Smaidas', 8, 295),
	(106736588, 100111942, 'Rundāles ūdensdzirnavas', 8, 297),
	(106757513, 100011533, 'Atvasaras', 8, 111),
	(106765071, 100111942, 'Vizbulītes', 8, 297),
	(106850485, 100010636, 'Jaungādnieki', 8, 297),
	(106875893, 100112132, 'Lielsvitene', 8, 295),
	(106880155, 100010636, 'Lielpēteri', 8, 286),
	(106880163, 100010636, 'Jaunlejnieki', 8, 286),
	(106881108, 100481403, '11', 8, 297),
	(106908805, 100010636, 'Kamāres', 8, 286),
	(106908934, 100010636, 'Henrieši', 8, 286),
	(106908950, 100010636, 'Gobas', 8, 286),
	(106926245, 100481403, '8', 8, 297),
	(106966088, 100011533, 'Akāciju darbnīcas', 8, 111),
	(106986944, 100111942, 'Klētis', 8, 297),
	(106986952, 100010636, 'Rundāles degvielas bāze', 8, 297),
	(106986960, 100481428, '15', 8, 297),
	(106986977, 100481428, '17', 8, 297),
	(106986985, 100481428, '19', 8, 297),
	(106986993, 100481428, '21', 8, 297),
	(106987005, 100481428, '23', 8, 297),
	(106987021, 100481428, '27', 8, 297),
	(106987288, 100111942, 'Pilsrundāles garāža 47A', 8, 297),
	(106996633, 100481436, '1', 8, 297),
	(106996641, 100481428, '10', 8, 297),
	(107015814, 100010660, 'Jaunapšenieki', 8, 295),
	(100003591, 100000000, 'Siguldas nov.', 4, 0),
	(100016776, 100003591, 'Mālpils pag.', 5, 0),
	(100185220, 100016776, 'Mālpils', 6, 0),
	(100185237, 100016776, 'Sidgunda', 6, 0),
	(100185245, 100016776, 'Upmalas', 6, 0),
	(100390630, 100185220, 'Celtnieku iela', 7, 0),
	(100390647, 100185220, 'Ceriņu iela', 7, 0),
	(100390655, 100185220, 'Ķiršu iela', 7, 0),
	(100390663, 100185220, 'Jaunā iela', 7, 0),
	(100390671, 100185220, 'Kalna iela', 7, 0),
	(100390688, 100185220, 'Kastaņu iela', 7, 0),
	(100390696, 100185220, 'Krasta iela', 7, 0),
	(100390702, 100185220, 'Lapu iela', 7, 0),
	(100390727, 100185220, 'Liepu iela', 7, 0),
	(100390735, 100185220, 'Mergupes iela', 7, 0),
	(100390743, 100185220, 'Nākotnes iela', 7, 0),
	(100390751, 100185220, 'Nītaures iela', 7, 0),
	(100390768, 100185220, 'Ozolu iela', 7, 0),
	(100390776, 100185220, 'Parka iela', 7, 0),
	(100390784, 100185220, 'Rītausmas iela', 7, 0),
	(100390792, 100185220, 'Saules iela', 7, 0),
	(100390807, 100185220, 'Skolas iela', 7, 0),
	(100390815, 100185220, 'Sporta iela', 7, 0),
	(100390823, 100185220, 'Strēlnieku iela', 7, 0),
	(100390831, 100185220, 'Vidus iela', 7, 0),
	(100390848, 100185220, 'Zaļā iela', 7, 0),
	(100390856, 100185220, 'Ziedoņa iela', 7, 0),
	(100390864, 100185220, 'Ziedu iela', 7, 0),
	(100411466, 100185220, 'Alejas iela', 7, 0),
	(100411474, 100185220, 'Dārza iela', 7, 0),
	(100411482, 100185220, 'Dīķu iela', 7, 0),
	(100411490, 100185220, 'Dzirnavu iela', 7, 0),
	(100411505, 100185220, 'Enerģētikas iela', 7, 0),
	(100411513, 100185220, 'Garkalnes iela', 7, 0),
	(100411521, 100185220, 'Klusā iela', 7, 0),
	(100411538, 100185220, 'Lejciema iela', 7, 0),
	(100411546, 100185220, 'Muzeja iela', 7, 0),
	(100411554, 100185220, 'Peldu iela', 7, 0),
	(100411562, 100185220, 'Pils iela', 7, 0),
	(100411570, 100185220, 'Pilskalna iela', 7, 0),
	(100411587, 100185220, 'Pirts iela', 7, 0),
	(100411595, 100185220, 'Pīpeņu iela', 7, 0),
	(100411601, 100185220, 'Rūpniecības iela', 7, 0),
	(100411618, 100185220, 'Salas iela', 7, 0),
	(100411626, 100185220, 'Siguldas iela', 7, 0),
	(100411634, 100185220, 'Smilšu iela', 7, 0),
	(100411650, 100185220, 'Sprīdīša iela', 7, 0),
	(100411667, 100185220, 'Sudas iela', 7, 0),
	(100411675, 100185220, 'Torņa iela', 7, 0),
	(100411683, 100185220, 'Torņkalna iela', 7, 0),
	(100411706, 100185220, 'Vecpils iela', 7, 0),
	(100411714, 100185220, 'Vibrokas iela', 7, 0),
	(100411722, 100185220, 'Vites iela', 7, 0),
	(100411730, 100185220, 'Vīnkalna iela', 7, 0),
	(100411747, 100185220, 'Vītolu iela', 7, 0),
	(100415352, 100185220, 'Sniedzes iela', 7, 0),
	(100484595, 100185220, 'Skulmes iela', 7, 0),
	(100487840, 100185220, 'Zemeņu iela', 7, 0),
	(100487865, 100185220, 'Melioratoru iela', 7, 0),
	(101095131, 100411521, '1', 8, 82),
	(101309964, 100390647, '1', 8, 82),
	(101309972, 100390647, '10', 8, 82),
	(101309980, 100390647, '2', 8, 82),
	(101309997, 100390647, '8', 8, 82),
	(101310001, 100390663, '1', 8, 82),
	(101310018, 100390671, '1', 8, 82),
	(101310026, 100390671, '4', 8, 82),
	(101310034, 100390671, '6', 8, 82),
	(101310042, 100390671, '8', 8, 82),
	(101310050, 100390688, '4', 8, 82),
	(102129001, 100390630, '1', 8, 82),
	(102129018, 100390630, '3', 8, 82),
	(102129026, 100390647, '4', 8, 82),
	(102129034, 100390647, '6', 8, 82),
	(102129091, 100390663, '2', 8, 82),
	(102129106, 100390663, '6', 8, 82),
	(102129114, 100390671, '2', 8, 82),
	(102129122, 100390671, '3', 8, 82),
	(102129130, 100390671, '5', 8, 82),
	(102129147, 100390688, '3', 8, 82),
	(102129155, 100390688, '5', 8, 82),
	(102129163, 100390688, '7', 8, 82),
	(102595846, 100390671, '10', 8, 82),
	(102657171, 100390663, '4', 8, 82),
	(102690112, 100390663, '5', 8, 82),
	(103851724, 100390688, '2B', 8, 82),
	(103852662, 100411513, '15', 8, 82),
	(103852943, 100411474, '1', 8, 82),
	(103853004, 100411474, '2', 8, 82),
	(103853037, 100411474, '4', 8, 82),
	(103853502, 100411505, '3', 8, 82),
	(103853672, 100411513, '5', 8, 82),
	(103853680, 100411513, '8', 8, 82),
	(103853961, 100411513, '3', 8, 82),
	(103853978, 100390663, '3', 8, 82),
	(103853986, 100390663, '5A', 8, 82),
	(103854834, 100390688, '6', 8, 82),
	(103855860, 100411490, '9', 8, 82),
	(103856991, 100411513, '2', 8, 82),
	(103859361, 100411513, '12', 8, 82),
	(104912211, 100411513, '9', 8, 82),
	(104912381, 100390663, '8', 8, 82),
	(104912412, 100411490, '6', 8, 82),
	(104912453, 100411513, '7', 8, 82),
	(105030811, 100390663, '6A', 8, 82),
	(105382746, 100390663, '2A', 8, 82),
	(105382963, 100390688, '2A', 8, 82),
	(105432483, 100390663, '7', 8, 82),
	(105574191, 100411513, '10', 8, 82),
	(105578406, 100390671, '7', 8, 82),
	(105664091, 100411482, '10', 8, 82),
	(105733788, 100411474, '8B', 8, 82),
	(105751195, 100411490, '7', 8, 82),
	(105751218, 100411505, '5', 8, 82),
	(105765943, 100390663, '1A', 8, 82),
	(105879655, 100411466, '1', 8, 82),
	(105959480, 100390688, '1', 8, 82),
	(106256188, 100390663, '10', 8, 82),
	(106292005, 100411521, '3', 8, 82),
	(106308505, 100411505, '7', 8, 82),
	(106520711, 100411490, '1', 8, 82),
	(106624084, 100411505, '2', 8, 82),
	(106641871, 100411474, '12', 8, 82),
	(106649250, 100390663, '3A', 8, 82),
	(106704904, 100411490, '4', 8, 82),
	(106864253, 100411505, '1', 8, 82),
	(106982824, 100411513, '16', 8, 82),
	(107038882, 100411474, '31', 8, 82);

/*!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) */;
