xv95fWUi

· 6 years ago · Mar 05, 2019, 08:08 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Aug 15, 2018 at 02:23 AM
7-- Server version: 5.5.50-0+deb8u1
8-- PHP Version: 5.6.24-0+deb8u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `kd_user01`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `Bevoelkerung`
27--
28
29CREATE TABLE IF NOT EXISTS `Bevoelkerung` (
30  `Schluesselnummer` int(11) NOT NULL,
31  `maennlich` int(11) DEFAULT NULL,
32  `weiblich` int(11) DEFAULT NULL,
33  `gesamt` int(11) DEFAULT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
35
36--
37-- Dumping data for table `Bevoelkerung`
38--
39
40INSERT INTO `Bevoelkerung` (`Schluesselnummer`, `maennlich`, `weiblich`, `gesamt`) VALUES
41(2, 847783, 898559, 1746342),
42(11, 1669853, 1751976, 3421829),
43(1001, 41322, 42649, 83971),
44(1002, 116951, 124582, 241533),
45(1003, 101734, 111224, 212958),
46(1004, 37606, 39452, 77058),
47(1051, 65124, 67541, 132665),
48(1053, 92291, 96752, 189043),
49(1054, 78853, 83070, 161923),
50(1055, 95235, 102600, 197835),
51(1056, 146892, 154331, 301223),
52(1057, 61181, 65462, 126643),
53(1058, 131328, 136747, 268075),
54(1059, 96268, 98867, 195135),
55(1060, 129249, 133953, 263202),
56(1061, 63915, 66102, 130017),
57(1062, 114044, 120630, 234674),
58(3101, 121376, 125851, 247227),
59(3102, 47873, 50324, 98197),
60(3103, 60349, 62108, 122457),
61(3151, 85335, 86140, 171475),
62(3152, 121071, 127178, 248249),
63(3153, 67603, 70230, 137833),
64(3154, 44586, 45837, 90423),
65(3155, 65926, 68735, 134661),
66(3156, 36275, 38092, 74367),
67(3157, 64003, 66144, 130147),
68(3158, 58993, 60907, 119900),
69(3241, 543339, 576187, 1119526),
70(3251, 104085, 105870, 209955),
71(3252, 70939, 76816, 147755),
72(3254, 132832, 141687, 274519),
73(3255, 35354, 36523, 71877),
74(3256, 59209, 60639, 119848),
75(3257, 75626, 79973, 155599),
76(3351, 85778, 89774, 175552),
77(3352, 96090, 100517, 196607),
78(3353, 118324, 124547, 242871),
79(3354, 23949, 24721, 48670),
80(3355, 85766, 90961, 176727),
81(3356, 54355, 56527, 110882),
82(3357, 80823, 80485, 161308),
83(3358, 67473, 68778, 136251),
84(3359, 97880, 98636, 196516),
85(3360, 44952, 47404, 92356),
86(3361, 64637, 67822, 132459),
87(3401, 36407, 37645, 74052),
88(3402, 24477, 25313, 49790),
89(3403, 75754, 83856, 159610),
90(3404, 74822, 81493, 156315),
91(3405, 36936, 38792, 75728),
92(3451, 58158, 60707, 118865),
93(3452, 91632, 95426, 187058),
94(3453, 80598, 79578, 160176),
95(3454, 158523, 155166, 313689),
96(3455, 47212, 49881, 97093),
97(3456, 66473, 67205, 133678),
98(3457, 81696, 83096, 164792),
99(3458, 62342, 63436, 125778),
100(3459, 172950, 177352, 350302),
101(3460, 67362, 66826, 134188),
102(3461, 44181, 44650, 88831),
103(3462, 27490, 28910, 56400),
104(4011, 267621, 280926, 548547),
105(4012, 53611, 55233, 108844),
106(5111, 288114, 310572, 598686),
107(5112, 237743, 249112, 486855),
108(5113, 273982, 295902, 569884),
109(5114, 107084, 114974, 222058),
110(5116, 124452, 130978, 255430),
111(5117, 79425, 87215, 166640),
112(5119, 101827, 107270, 209097),
113(5120, 53172, 55783, 108955),
114(5122, 74822, 80946, 155768),
115(5124, 166113, 177375, 343488),
116(5154, 149466, 153232, 302698),
117(5158, 229018, 247615, 476633),
118(5162, 213436, 227166, 440602),
119(5166, 143168, 151753, 294921),
120(5170, 221795, 235238, 457033),
121(5314, 147304, 163983, 311287),
122(5315, 501577, 532598, 1034175),
123(5316, 77865, 82954, 160819),
124(5334, 272493, 272574, 545067),
125(5354, NULL, NULL, NULL),
126(5358, 127307, 131078, 258385),
127(5362, 222057, 234545, 456602),
128(5366, 92289, 95148, 187437),
129(5370, 122114, 126119, 248233),
130(5374, 132055, 138235, 270290),
131(5378, 134690, 143750, 278440),
132(5382, 283675, 298605, 582280),
133(5512, 56061, 59994, 116055),
134(5513, 126979, 130871, 257850),
135(5515, 143029, 156679, 299708),
136(5554, 181075, 183196, 364271),
137(5558, 105691, 109591, 215282),
138(5562, 298151, 315727, 613878),
139(5566, 214563, 219918, 434481),
140(5570, 133849, 138774, 272623),
141(5711, 158461, 170403, 328864),
142(5754, 174654, 177680, 352334),
143(5758, 121285, 127703, 248988),
144(5762, 70709, 72079, 142788),
145(5766, 167812, 177562, 345374),
146(5770, 151399, 157957, 309356),
147(5774, 147341, 149347, 296688),
148(5911, 174396, 187338, 361734),
149(5913, 281116, 294828, 575944),
150(5914, 89907, 96089, 185996),
151(5915, 85813, 90235, 176048),
152(5916, 74675, 79742, 154417),
153(5954, 155738, 166993, 322731),
154(5958, 129615, 132384, 261999),
155(5962, 203569, 212671, 416240),
156(5966, 67266, 67681, 134947),
157(5970, 135077, 139827, 274904),
158(5974, 144777, 150194, 294971),
159(5978, 189556, 202066, 391622),
160(6411, 75275, 74468, 149743),
161(6412, 344952, 356398, 701350),
162(6413, 58963, 60240, 119203),
163(6414, 130760, 143111, 273871),
164(6431, 128647, 133675, 262322),
165(6432, 140871, 144536, 285407),
166(6433, 127204, 130097, 257301),
167(6434, 110265, 118902, 229167),
168(6435, 198091, 206904, 404995),
169(6436, 110818, 117203, 228021),
170(6437, 47380, 48821, 96201),
171(6438, 165651, 172649, 338300),
172(6439, 88594, 92596, 181190),
173(6440, 145084, 150324, 295408),
174(6531, 124134, 129686, 253820),
175(6532, 123096, 128231, 251327),
176(6533, 83781, 86183, 169964),
177(6534, 117854, 123802, 241656),
178(6535, 52712, 53671, 106383),
179(6611, 93967, 100120, 194087),
180(6631, 106118, 110196, 216314),
181(6632, 59158, 60493, 119651),
182(6633, 113798, 119554, 233352),
183(6634, 89142, 90287, 179429),
184(6635, 77326, 79281, 156607),
185(6636, 48909, 51447, 100356),
186(7111, 53188, 57455, 110643),
187(7131, 61536, 64566, 126102),
188(7132, 63240, 65133, 128373),
189(7133, 75420, 79877, 155297),
190(7134, 39697, 40976, 80673),
191(7135, 31485, 31717, 63202),
192(7137, 102901, 106884, 209785),
193(7138, 87750, 91704, 179454),
194(7140, 49780, 50990, 100770),
195(7141, 59764, 61611, 121375),
196(7143, 98331, 100373, 198704),
197(7211, 51782, 55451, 107233),
198(7231, 54811, 55832, 110643),
199(7232, 47973, 48185, 96158),
200(7233, 30112, 30653, 60765),
201(7235, 70958, 73379, 144337),
202(7311, 22864, 24468, 47332),
203(7312, 48493, 48669, 97162),
204(7313, 20609, 23216, 43825),
205(7314, 79764, 81754, 161518),
206(7315, 98529, 105739, 204268),
207(7316, 25308, 27092, 52400),
208(7317, 19242, 20859, 40101),
209(7318, 23906, 25834, 49740),
210(7319, 38946, 41350, 80296),
211(7320, 16676, 17408, 34084),
212(7331, 62185, 63028, 125213),
213(7332, 64062, 66979, 131041),
214(7333, 37059, 38133, 75192),
215(7334, 62243, 63191, 125434),
216(7335, 50998, 53119, 104117),
217(7336, 35163, 35935, 71098),
218(7337, 53691, 55335, 109026),
219(7338, 72974, 76094, 149068),
220(7339, 99855, 103483, 203338),
221(7340, 47641, 48958, 96599),
222(8111, 298413, 305884, 604297),
223(8115, 182704, 187688, 370392),
224(8116, 252108, 260171, 512279),
225(8117, 122731, 126082, 248813),
226(8118, 257080, 264553, 521633),
227(8119, 201855, 209170, 411025),
228(8121, 58440, 59682, 118122),
229(8125, 161934, 164101, 326035),
230(8126, 53969, 53897, 107866),
231(8127, 93657, 94025, 187682),
232(8128, 64015, 65842, 129857),
233(8135, 63283, 64664, 127947),
234(8136, 151882, 155051, 306933),
235(8211, 24893, 28119, 53012),
236(8212, 150451, 148652, 299103),
237(8215, 211795, 217391, 429186),
238(8216, 109963, 113348, 223311),
239(8221, 72422, 79691, 152113),
240(8222, 146345, 150345, 296690),
241(8225, 70441, 71143, 141584),
242(8226, 258970, 272043, 531013),
243(8231, 57147, 60607, 117754),
244(8235, 75016, 76445, 151461),
245(8236, 95032, 97779, 192811),
246(8237, 56630, 58163, 114793),
247(8311, 103982, 116304, 220286),
248(8315, 122249, 127888, 250137),
249(8316, 77608, 80569, 158177),
250(8317, 203550, 209128, 412678),
251(8325, 66921, 68398, 135319),
252(8326, 100855, 104235, 205090),
253(8327, 66204, 66994, 133198),
254(8335, 132172, 141235, 273407),
255(8336, 108111, 113832, 221943),
256(8337, 80674, 83591, 164265),
257(8415, 135326, 140693, 276019),
258(8416, 105212, 111323, 216535),
259(8417, 90722, 93893, 184615),
260(8421, 58341, 60877, 119218),
261(8425, 93867, 94025, 187892),
262(8426, 94063, 94633, 188696),
263(8435, 101660, 105790, 207450),
264(8436, 134892, 138648, 273540),
265(8437, 62980, 64121, 127101),
266(9161, 64731, 64405, 129136),
267(9162, 683126, 724710, 1407836),
268(9163, 29546, 30918, 60464),
269(9171, 52378, 54587, 106965),
270(9172, 49891, 52455, 102346),
271(9173, 59850, 62268, 122118),
272(9174, 71636, 72771, 144407),
273(9175, 65811, 67196, 133007),
274(9176, 63300, 62558, 125858),
275(9177, 65192, 65046, 130238),
276(9178, 85466, 83544, 169010),
277(9179, 101205, 107067, 208272),
278(9180, 41154, 44289, 85443),
279(9181, 56988, 57938, 114926),
280(9182, 46565, 49484, 96049),
281(9183, 54591, 54636, 109227),
282(9184, 162383, 167598, 329981),
283(9185, 46418, 46282, 92700),
284(9186, 60632, 59355, 119987),
285(9187, 123049, 126761, 249810),
286(9188, 62863, 67948, 130811),
287(9189, 83288, 87076, 170364),
288(9190, 64322, 66065, 130387),
289(9261, 31659, 34520, 66179),
290(9262, 23239, 26215, 49454),
291(9263, 22636, 22866, 45502),
292(9271, 57071, 58303, 115374),
293(9272, 38426, 39200, 77626),
294(9273, 57764, 57468, 115232),
295(9274, 75767, 74549, 150316),
296(9275, 91391, 94280, 185671),
297(9276, 37813, 38444, 76257),
298(9277, 58380, 59274, 117654),
299(9278, 48597, 48726, 97323),
300(9279, 47210, 45355, 92565),
301(9361, 20353, 21239, 41592),
302(9362, 67035, 73241, 140276),
303(9363, 19765, 21961, 41726),
304(9371, 51248, 51826, 103074),
305(9372, 62483, 63070, 125553),
306(9373, 64011, 63815, 127826),
307(9374, 47339, 48108, 95447),
308(9375, 92504, 93476, 185980),
309(9376, 71491, 71569, 143060),
310(9377, 36343, 37114, 73457),
311(9461, 33421, 37746, 71167),
312(9462, 34364, 37208, 71572),
313(9463, 19715, 21279, 40994),
314(9464, 21080, 23442, 44522),
315(9471, 71904, 72521, 144425),
316(9472, 51537, 53100, 104637),
317(9473, 42685, 44034, 86719),
318(9474, 55927, 57497, 113424),
319(9475, 47063, 50033, 97096),
320(9476, 33604, 34880, 68484),
321(9477, 35570, 37328, 72898),
322(9478, 32663, 33981, 66644),
323(9479, 35495, 38288, 73783),
324(9561, 18895, 20944, 39839),
325(9562, 51877, 53747, 105624),
326(9563, 58052, 61756, 119808),
327(9564, 240640, 258236, 498876),
328(9565, 19126, 20420, 39546),
329(9571, 89141, 89773, 178914),
330(9572, 65421, 66591, 132012),
331(9573, 55631, 58882, 114513),
332(9574, 80818, 84182, 165000),
333(9575, 48296, 49186, 97482),
334(9576, 61021, 62410, 123431),
335(9577, 45817, 46514, 92331),
336(9661, 32509, 35335, 67844),
337(9662, 24974, 26877, 51851),
338(9663, 58690, 66008, 124698),
339(9671, 85792, 86999, 172791),
340(9672, 50217, 52648, 102865),
341(9673, 39598, 40367, 79965),
342(9674, 42012, 42078, 84090),
343(9675, 43821, 44276, 88097),
344(9676, 63644, 64265, 127909),
345(9677, 62782, 63513, 126295),
346(9678, 56262, 56745, 113007),
347(9679, 78529, 80051, 158580),
348(9761, 134549, 141993, 276542),
349(9762, 20258, 21501, 41759),
350(9763, 31905, 33139, 65044),
351(9764, 20371, 21401, 41772),
352(9771, 63741, 64694, 128435),
353(9772, 119037, 121874, 240911),
354(9773, 46180, 46949, 93129),
355(9774, 60320, 60376, 120696),
356(9775, 82229, 84414, 166643),
357(9776, 38653, 40286, 78939),
358(9777, 66693, 68078, 134771),
359(9778, 68733, 68751, 137484),
360(9779, 65203, 64219, 129422),
361(9780, 73788, 76690, 150478),
362(10041, 158386, 167592, 325978),
363(10042, 50638, 52497, 103135),
364(10043, 64864, 68358, 133222),
365(10044, 95367, 100609, 195976),
366(10045, 69614, 74237, 143851),
367(10046, 43540, 45016, 88556),
368(12051, 34852, 36180, 71032),
369(12052, 48907, 50688, 99595),
370(12053, 27733, 30285, 58018),
371(12054, 77383, 84085, 161468),
372(12060, 85935, 87819, 173754),
373(12061, 79404, 81389, 160793),
374(12062, 52428, 53729, 106157),
375(12063, 76018, 77856, 153874),
376(12064, 92972, 94696, 187668),
377(12065, 99944, 103068, 203012),
378(12066, 55726, 58116, 113842),
379(12067, 87048, 89802, 176850),
380(12068, 49145, 49799, 98944),
381(12069, 101665, 103855, 205520),
382(12070, 38513, 39480, 77993),
383(12071, 58576, 60323, 118899),
384(12072, 79653, 80795, 160448),
385(12073, 59519, 61807, 121326),
386(13001, NULL, NULL, NULL),
387(13002, NULL, NULL, NULL),
388(13003, 99559, 103872, 203431),
389(13004, 43536, 48047, 91583),
390(13005, NULL, NULL, NULL),
391(13006, NULL, NULL, NULL),
392(13051, NULL, NULL, NULL),
393(13052, NULL, NULL, NULL),
394(13053, NULL, NULL, NULL),
395(13054, NULL, NULL, NULL),
396(13055, NULL, NULL, NULL),
397(13056, NULL, NULL, NULL),
398(13057, NULL, NULL, NULL),
399(13058, NULL, NULL, NULL),
400(13059, NULL, NULL, NULL),
401(13060, NULL, NULL, NULL),
402(13061, NULL, NULL, NULL),
403(13062, NULL, NULL, NULL),
404(13071, 128641, 133771, 262412),
405(13072, 104956, 105599, 210555),
406(13073, 109655, 113454, 223109),
407(13074, 77288, 77977, 155265),
408(13075, 116949, 121236, 238185),
409(13076, 105749, 106216, 211965),
410(14161, NULL, NULL, NULL),
411(14166, NULL, NULL, NULL),
412(14167, NULL, NULL, NULL),
413(14171, NULL, NULL, NULL),
414(14173, NULL, NULL, NULL),
415(14177, NULL, NULL, NULL),
416(14178, NULL, NULL, NULL),
417(14181, NULL, NULL, NULL),
418(14182, NULL, NULL, NULL),
419(14188, NULL, NULL, NULL),
420(14191, NULL, NULL, NULL),
421(14193, NULL, NULL, NULL),
422(14262, NULL, NULL, NULL),
423(14263, NULL, NULL, NULL),
424(14264, NULL, NULL, NULL),
425(14272, NULL, NULL, NULL),
426(14280, NULL, NULL, NULL),
427(14284, NULL, NULL, NULL),
428(14285, NULL, NULL, NULL),
429(14286, NULL, NULL, NULL),
430(14287, NULL, NULL, NULL),
431(14290, NULL, NULL, NULL),
432(14292, NULL, NULL, NULL),
433(14365, NULL, NULL, NULL),
434(14374, NULL, NULL, NULL),
435(14375, NULL, NULL, NULL),
436(14379, NULL, NULL, NULL),
437(14383, NULL, NULL, NULL),
438(14389, NULL, NULL, NULL),
439(14511, 117495, 124527, 242022),
440(14521, 171418, 179891, 351309),
441(14522, 155331, 159260, 314591),
442(14523, 113382, 120588, 233970),
443(14524, 158462, 168600, 327062),
444(14612, 261664, 269090, 530754),
445(14625, 151839, 156511, 308350),
446(14626, 127915, 134253, 262168),
447(14627, 119570, 124146, 243716),
448(14628, 121119, 124820, 245939),
449(14713, 257414, 274148, 531562),
450(14729, 126061, 131535, 257596),
451(14730, 97518, 99828, 197346),
452(15001, 40428, 43188, 83616),
453(15002, 110632, 120933, 231565),
454(15003, 112495, 118526, 231021),
455(15081, 43061, 43251, 86312),
456(15082, 81533, 85295, 166828),
457(15083, 86004, 86951, 172955),
458(15084, 90995, 93961, 184956),
459(15085, 107757, 113286, 221043),
460(15086, 45624, 46097, 91721),
461(15087, 70402, 72844, 143246),
462(15088, 92599, 95091, 187690),
463(15089, 96699, 102016, 198715),
464(15090, 56882, 58589, 115471),
465(15091, 63457, 65981, 129438),
466(15101, NULL, NULL, NULL),
467(15151, NULL, NULL, NULL),
468(15153, NULL, NULL, NULL),
469(15154, NULL, NULL, NULL),
470(15159, NULL, NULL, NULL),
471(15171, NULL, NULL, NULL),
472(15202, NULL, NULL, NULL),
473(15256, NULL, NULL, NULL),
474(15260, NULL, NULL, NULL),
475(15261, NULL, NULL, NULL),
476(15265, NULL, NULL, NULL),
477(15266, NULL, NULL, NULL),
478(15268, NULL, NULL, NULL),
479(15303, NULL, NULL, NULL),
480(15352, NULL, NULL, NULL),
481(15355, NULL, NULL, NULL),
482(15357, NULL, NULL, NULL),
483(15358, NULL, NULL, NULL),
484(15362, NULL, NULL, NULL),
485(15363, NULL, NULL, NULL),
486(15364, NULL, NULL, NULL),
487(15367, NULL, NULL, NULL),
488(15369, NULL, NULL, NULL),
489(15370, NULL, NULL, NULL),
490(16051, 98751, 106129, 204880),
491(16052, 45497, 49480, 94977),
492(16053, 53190, 54489, 107679),
493(16054, 17212, 18453, 35665),
494(16055, 30402, 32913, 63315),
495(16056, 20118, 21449, 41567),
496(16061, 50650, 50301, 100951),
497(16062, 42138, 43242, 85380),
498(16063, 63070, 63213, 126283),
499(16064, 51406, 52839, 104245),
500(16065, 38431, 39225, 77656),
501(16066, 62616, 62958, 125574),
502(16067, 66902, 68253, 135155),
503(16068, 35281, 35552, 70833),
504(16069, 32383, 32649, 65032),
505(16070, 54387, 54571, 108958),
506(16071, 40414, 41290, 81704),
507(16072, 28002, 29250, 57252),
508(16073, 54020, 56287, 110307),
509(16074, 41645, 42356, 84001),
510(16075, 41176, 42478, 83654),
511(16076, 50178, 51989, 102167),
512(16077, 45795, 47810, 93605),
513(3241001, 250415, 267971, 518386),
514(5334002, 124192, 117491, 241683),
515(10041100, 86706, 90495, 177201);
516
517-- --------------------------------------------------------
518
519--
520-- Table structure for table `Bundesland`
521--
522
523CREATE TABLE IF NOT EXISTS `Bundesland` (
524  `bl_ID` int(11) NOT NULL,
525  `BundeslandName` varchar(22) COLLATE utf8_unicode_ci NOT NULL,
526  `Temperatur` float DEFAULT NULL
527) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
528
529--
530-- Dumping data for table `Bundesland`
531--
532
533INSERT INTO `Bundesland` (`bl_ID`, `BundeslandName`, `Temperatur`) VALUES
534(1, 'Schleswig-Holstein', 9.7),
535(2, 'Hamburg', 10.3),
536(3, 'Niedersachsen', 10.1),
537(4, 'Bremen', 10.3),
538(5, 'Nordrhein-Westfalen', 10.3),
539(6, 'Hessen', 9.9),
540(7, 'Rheinland-Pfalz', 10.2),
541(8, 'Baden-Wï¿½rttemberg', 9.9),
542(9, 'Bayern', 9.5),
543(10, 'Saarland', 10.3),
544(11, 'Berlin', 10.9),
545(12, 'Brandenburg', 10.4),
546(13, 'Mecklenburg-Vorpommern', 9.8),
547(14, 'Freistaat Sachsen', 10),
548(15, 'Sachsen-Anhalt', 10.4),
549(16, 'Thï¿½ringen', 9.7);
550
551-- --------------------------------------------------------
552
553--
554-- Table structure for table `Kreisflaeche`
555--
556
557CREATE TABLE IF NOT EXISTS `Kreisflaeche` (
558  `Schluesselnummer` int(11) NOT NULL,
559  `Flaeche` decimal(7,2) DEFAULT NULL
560) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
561
562--
563-- Dumping data for table `Kreisflaeche`
564--
565
566INSERT INTO `Kreisflaeche` (`Schluesselnummer`, `Flaeche`) VALUES
567(2, 755.22),
568(11, 891.68),
569(1001, 56.74),
570(1002, 118.65),
571(1003, 214.21),
572(1004, 71.63),
573(1051, 1428.09),
574(1053, 1262.97),
575(1054, 2082.82),
576(1055, 1392.68),
577(1056, 664.25),
578(1057, 1083.19),
579(1058, 2186.23),
580(1059, 2071.35),
581(1060, 1344.41),
582(1061, 1056.14),
583(1062, 766.29),
584(3101, 192.17),
585(3102, 223.92),
586(3103, 204.06),
587(3151, 1562.83),
588(3152, 1117.24),
589(3153, 965.29),
590(3154, 674.00),
591(3155, 1267.06),
592(3156, 636.02),
593(3157, 534.93),
594(3158, 722.55),
595(3241, 2290.77),
596(3251, 1987.94),
597(3252, 796.14),
598(3254, 1205.95),
599(3255, 692.58),
600(3256, 1398.97),
601(3257, 675.57),
602(3351, 1545.18),
603(3352, 2057.78),
604(3353, 1244.97),
605(3354, 1220.65),
606(3355, 1323.50),
607(3356, 650.80),
608(3357, 2070.30),
609(3358, 1873.67),
610(3359, 1266.02),
611(3360, 1454.14),
612(3361, 787.95),
613(3401, 62.36),
614(3402, 112.36),
615(3403, 102.99),
616(3404, 119.80),
617(3405, 106.91),
618(3451, 728.36),
619(3452, 1287.31),
620(3453, 1418.40),
621(3454, 2882.04),
622(3455, 607.90),
623(3456, 980.86),
624(3457, 1086.02),
625(3458, 1063.12),
626(3459, 2121.59),
627(3460, 812.59),
628(3461, 821.90),
629(3462, 656.66),
630(4011, 325.56),
631(4012, 93.82),
632(5111, 217.41),
633(5112, 232.80),
634(5113, 210.34),
635(5114, 137.78),
636(5116, 170.45),
637(5117, 91.28),
638(5119, 77.10),
639(5120, 74.52),
640(5122, 89.54),
641(5124, 168.39),
642(5154, 1232.99),
643(5158, 407.22),
644(5162, 576.52),
645(5166, 563.28),
646(5170, 1042.80),
647(5314, 141.06),
648(5315, 405.01),
649(5316, 78.87),
650(5334, 706.95),
651(5354, NULL),
652(5358, 941.37),
653(5362, 704.62),
654(5366, 1248.73),
655(5370, 627.99),
656(5374, 918.85),
657(5378, 437.32),
658(5382, 1153.20),
659(5512, 100.61),
660(5513, 104.94),
661(5515, 303.28),
662(5554, 1420.98),
663(5558, 1112.04),
664(5562, 760.45),
665(5566, 1795.76),
666(5570, 1319.41),
667(5711, 258.82),
668(5754, 969.21),
669(5758, 450.41),
670(5762, 1201.42),
671(5766, 1246.21),
672(5770, 1152.41),
673(5774, 1246.80),
674(5911, 145.66),
675(5913, 280.71),
676(5914, 160.35),
677(5915, 226.43),
678(5916, 51.42),
679(5954, 408.44),
680(5958, 1960.17),
681(5962, 1061.06),
682(5966, 712.14),
683(5970, 1132.89),
684(5974, 1328.64),
685(5978, 543.21),
686(6411, 122.09),
687(6412, 248.31),
688(6413, 44.89),
689(6414, 203.93),
690(6431, 719.52),
691(6432, 658.65),
692(6433, 453.05),
693(6434, 482.02),
694(6435, 1397.56),
695(6436, 222.39),
696(6437, 623.98),
697(6438, 356.30),
698(6439, 811.48),
699(6440, 1100.73),
700(6531, 854.64),
701(6532, 1066.52),
702(6533, 738.48),
703(6534, 1262.56),
704(6535, 1458.99),
705(6611, 106.78),
706(6631, 1380.39),
707(6632, 1097.13),
708(6633, 1292.92),
709(6634, 1538.49),
710(6635, 1848.44),
711(6636, 1024.70),
712(7111, 105.13),
713(7131, 786.99),
714(7132, 642.00),
715(7133, 863.70),
716(7134, 776.55),
717(7135, 719.97),
718(7137, 817.26),
719(7138, 626.88),
720(7140, 963.39),
721(7141, 782.34),
722(7143, 988.97),
723(7211, 117.13),
724(7231, 1167.59),
725(7232, 1626.26),
726(7233, 911.05),
727(7235, 1101.49),
728(7311, 43.76),
729(7312, 139.73),
730(7313, 82.96),
731(7314, 77.55),
732(7315, 97.74),
733(7316, 117.10),
734(7317, 61.37),
735(7318, 42.60),
736(7319, 108.73),
737(7320, 70.64),
738(7331, 588.14),
739(7332, 594.79),
740(7333, 645.49),
741(7334, 463.35),
742(7335, 639.88),
743(7336, 573.35),
744(7337, 639.83),
745(7338, 304.94),
746(7339, 605.73),
747(7340, 953.65),
748(8111, 207.35),
749(8115, 617.82),
750(8116, 641.48),
751(8117, 642.36),
752(8118, 686.82),
753(8119, 858.14),
754(8121, 99.88),
755(8125, 1099.93),
756(8126, 776.76),
757(8127, 1484.00),
758(8128, 1304.41),
759(8135, 627.12),
760(8136, 1511.57),
761(8211, 140.21),
762(8212, 173.46),
763(8215, 1084.94),
764(8216, 738.75),
765(8221, 108.83),
766(8222, 144.96),
767(8225, 1126.25),
768(8226, 1061.71),
769(8231, 98.00),
770(8235, 797.51),
771(8236, 573.69),
772(8237, 870.67),
773(8311, 153.06),
774(8315, 1378.34),
775(8316, 679.88),
776(8317, 1850.84),
777(8325, 769.43),
778(8326, 1025.26),
779(8327, 734.35),
780(8335, 817.97),
781(8336, 806.77),
782(8337, 1131.15),
783(8415, 1028.09),
784(8416, 519.19),
785(8417, 917.71),
786(8421, 118.69),
787(8425, 1358.67),
788(8426, 1409.75),
789(8435, 664.80),
790(8436, 1631.82),
791(8437, 1204.34),
792(9161, 133.37),
793(9162, 310.74),
794(9163, 37.22),
795(9171, 569.35),
796(9172, 839.92),
797(9173, 1110.69),
798(9174, 579.18),
799(9175, 549.37),
800(9176, 1214.06),
801(9177, 870.72),
802(9178, 799.82),
803(9179, 434.79),
804(9180, 1012.23),
805(9181, 804.38),
806(9182, 866.23),
807(9183, 805.31),
808(9184, 664.25),
809(9185, 739.80),
810(9186, 761.14),
811(9187, 1439.54),
812(9188, 487.71),
813(9189, 1534.00),
814(9190, 966.38),
815(9261, 65.81),
816(9262, 69.57),
817(9263, 67.58),
818(9271, 861.30),
819(9272, 984.14),
820(9273, 1065.98),
821(9274, 1347.91),
822(9275, 1530.29),
823(9276, 974.91),
824(9277, 1281.42),
825(9278, 1201.94),
826(9279, 877.79),
827(9361, 50.13),
828(9362, 80.70),
829(9363, 70.54),
830(9371, 1255.76),
831(9372, 1520.16),
832(9373, 1344.12),
833(9374, 1427.67),
834(9375, 1391.90),
835(9376, 1464.98),
836(9377, 1084.23),
837(9461, 54.62),
838(9462, 66.90),
839(9463, 48.29),
840(9464, 58.03),
841(9471, 1167.84),
842(9472, 1273.78),
843(9473, 590.47),
844(9474, 642.79),
845(9475, 892.52),
846(9476, 651.53),
847(9477, 658.34),
848(9478, 519.95),
849(9479, 606.43),
850(9561, 99.91),
851(9562, 76.95),
852(9563, 63.35),
853(9564, 186.37),
854(9565, 40.82),
855(9571, 1971.84),
856(9572, 564.66),
857(9573, 307.55),
858(9574, 799.57),
859(9575, 1267.55),
860(9576, 895.39),
861(9577, 970.91),
862(9661, 62.47),
863(9662, 35.70),
864(9663, 87.63),
865(9671, 699.15),
866(9672, 1136.96),
867(9673, 1021.77),
868(9674, 956.38),
869(9675, 684.19),
870(9676, 715.86),
871(9677, 1321.42),
872(9678, 841.46),
873(9679, 968.40),
874(9761, 146.84),
875(9762, 40.03),
876(9763, 63.28),
877(9764, 70.14),
878(9771, 780.33),
879(9772, 1071.12),
880(9773, 792.22),
881(9774, 762.44),
882(9775, 515.87),
883(9776, 323.44),
884(9777, 1394.92),
885(9778, 1230.06),
886(9779, 1274.68),
887(9780, 1528.01),
888(10041, 410.63),
889(10042, 555.16),
890(10043, 249.25),
891(10044, 459.03),
892(10045, 418.39),
893(10046, 476.23),
894(12051, 229.71),
895(12052, 165.15),
896(12053, 147.85),
897(12054, 188.25),
898(12060, 1479.69),
899(12061, 2274.28),
900(12062, 1899.57),
901(12063, 1727.30),
902(12064, 2158.65),
903(12065, 1808.20),
904(12066, 1223.08),
905(12067, 2256.75),
906(12068, 2526.56),
907(12069, 2592.00),
908(12070, 2138.59),
909(12071, 1657.43),
910(12072, 2104.20),
911(12073, 3076.90),
912(13001, NULL),
913(13002, NULL),
914(13003, 181.26),
915(13004, 130.52),
916(13005, NULL),
917(13006, NULL),
918(13051, NULL),
919(13052, NULL),
920(13053, NULL),
921(13054, NULL),
922(13055, NULL),
923(13056, NULL),
924(13057, NULL),
925(13058, NULL),
926(13059, NULL),
927(13060, NULL),
928(13061, NULL),
929(13062, NULL),
930(13071, 5470.03),
931(13072, 3422.23),
932(13073, 3207.22),
933(13074, 2118.45),
934(13075, 3929.48),
935(13076, 4751.86),
936(14161, NULL),
937(14166, NULL),
938(14167, NULL),
939(14171, NULL),
940(14173, NULL),
941(14177, NULL),
942(14178, NULL),
943(14181, NULL),
944(14182, NULL),
945(14188, NULL),
946(14191, NULL),
947(14193, NULL),
948(14262, NULL),
949(14263, NULL),
950(14264, NULL),
951(14272, NULL),
952(14280, NULL),
953(14284, NULL),
954(14285, NULL),
955(14286, NULL),
956(14287, NULL),
957(14290, NULL),
958(14292, NULL),
959(14365, NULL),
960(14374, NULL),
961(14375, NULL),
962(14379, NULL),
963(14383, NULL),
964(14389, NULL),
965(14511, 220.86),
966(14521, 1828.43),
967(14522, 2113.40),
968(14523, 1411.90),
969(14524, 949.27),
970(14612, 328.31),
971(14625, 2390.74),
972(14626, 2106.30),
973(14627, 1452.39),
974(14628, 1653.70),
975(14713, 297.39),
976(14729, 1647.12),
977(14730, 2020.35),
978(15001, 244.74),
979(15002, 135.01),
980(15003, 201.00),
981(15081, 2293.05),
982(15082, 1453.51),
983(15083, 2366.64),
984(15084, 1413.69),
985(15085, 2104.55),
986(15086, 1576.77),
987(15087, 1448.82),
988(15088, 1433.66),
989(15089, 1426.68),
990(15090, 2423.15),
991(15091, 1930.30),
992(15101, NULL),
993(15151, NULL),
994(15153, NULL),
995(15154, NULL),
996(15159, NULL),
997(15171, NULL),
998(15202, NULL),
999(15256, NULL),
1000(15260, NULL),
1001(15261, NULL),
1002(15265, NULL),
1003(15266, NULL),
1004(15268, NULL),
1005(15303, NULL),
1006(15352, NULL),
1007(15355, NULL),
1008(15357, NULL),
1009(15358, NULL),
1010(15362, NULL),
1011(15363, NULL),
1012(15364, NULL),
1013(15367, NULL),
1014(15369, NULL),
1015(15370, NULL),
1016(16051, 269.15),
1017(16052, 151.92),
1018(16053, 114.48),
1019(16054, 102.71),
1020(16055, 84.19),
1021(16056, 103.84),
1022(16061, 940.13),
1023(16062, 711.02),
1024(16063, 1304.87),
1025(16064, 975.56),
1026(16065, 1035.19),
1027(16066, 1210.13),
1028(16067, 935.62),
1029(16068, 804.21),
1030(16069, 937.27),
1031(16070, 843.14),
1032(16071, 803.04),
1033(16072, 433.48),
1034(16073, 1034.63),
1035(16074, 816.97),
1036(16075, 1148.39),
1037(16076, 843.54),
1038(16077, 569.09),
1039(3241001, 204.15),
1040(5334002, 160.85),
1041(10041100, 167.09);
1042
1043-- --------------------------------------------------------
1044
1045--
1046-- Table structure for table `Stadtkreis`
1047--
1048
1049CREATE TABLE IF NOT EXISTS `Stadtkreis` (
1050  `Schluesselnummer` int(11) NOT NULL,
1051  `bl_ID` int(11) NOT NULL,
1052  `Kreisname` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
1053  `TYP` varchar(45) COLLATE utf8_unicode_ci NOT NULL
1054) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1055
1056--
1057-- Dumping data for table `Stadtkreis`
1058--
1059
1060INSERT INTO `Stadtkreis` (`Schluesselnummer`, `bl_ID`, `Kreisname`, `TYP`) VALUES
1061(2, 2, 'Hamburg', 'Landeshauptstadt'),
1062(11, 11, 'Berlin', 'Landeshauptstadt'),
1063(1001, 1, 'Flensburg', 'Kreisfreie Stadt'),
1064(1002, 1, 'Kiel', 'Landeshauptstadt'),
1065(1003, 1, 'Lï¿½beck', 'Hansestadt'),
1066(1004, 1, 'Neumï¿½nster', 'Kreisfreie Stadt'),
1067(1051, 1, 'Dithmarschen', 'Landkreis'),
1068(1053, 1, 'Herzogtum Lauenburg', 'LandKreis'),
1069(1054, 1, 'Nordfriesland', 'Landkreis'),
1070(1055, 1, 'Ostholstein', 'Landkreis'),
1071(1056, 1, 'Pinneberg', 'Landkreis'),
1072(1057, 1, 'Plï¿½n', 'Landkreis'),
1073(1058, 1, 'Rendsburg-Eckernfï¿½rde', 'Landkreis'),
1074(1059, 1, 'Schleswig-Flensburg', 'Landkreis'),
1075(1060, 1, 'Segeberg', 'Landkreis'),
1076(1061, 1, 'Steinburg', 'Landkreis'),
1077(1062, 1, 'Stormarn', 'Landkreis'),
1078(3101, 3, 'Braunschweig', 'Kreisfreie Stadt'),
1079(3102, 3, 'Salzgitter', 'Kreisfreie Stadt'),
1080(3103, 3, 'Wolfsburg', 'Kreisfreie Stadt'),
1081(3151, 3, 'Gifhorn', 'Landkreis'),
1082(3152, 3, 'Gï¿½ttingen', 'Landkreis'),
1083(3153, 3, 'Goslar', 'Landkreis'),
1084(3154, 3, 'Helmstedt', 'Landkreis'),
1085(3155, 3, 'Northeim ', 'Landkreis'),
1086(3156, 3, 'Osterode am Harz ', 'Landkreis'),
1087(3157, 3, 'Peine ', 'Landkreis'),
1088(3158, 3, 'Wolfenbï¿½ttel ', 'Landkreis'),
1089(3241, 3, 'Region Hannover', 'Landkreis'),
1090(3251, 3, 'Diepholz', 'Landkreis'),
1091(3252, 3, 'Hameln-Pyrmont', 'Landkreis'),
1092(3254, 3, 'Hildesheim', 'Landkreis'),
1093(3255, 3, 'Holzminden', 'Landkreis'),
1094(3256, 3, 'Nienburg (Weser)', 'Landkreis'),
1095(3257, 3, 'Schaumburg', 'Landkreis'),
1096(3351, 3, 'Celle', 'Landkreis'),
1097(3352, 3, 'Cuxhaven', 'Landkreis'),
1098(3353, 3, 'Harburg', 'Landkreis'),
1099(3354, 3, 'Lï¿½chow-Dannenberg', 'Landkreis'),
1100(3355, 3, 'Lï¿½neburg', 'Landkreis'),
1101(3356, 3, 'Osterholz', 'Landkreis'),
1102(3357, 3, 'Rotenburg (Wï¿½mme)', 'Landkreis'),
1103(3358, 3, 'HeideKreis', 'Landkreis'),
1104(3359, 3, 'Stade', 'Landkreis'),
1105(3360, 3, 'Uelzen', 'Landkreis'),
1106(3361, 3, 'Verden', 'Landkreis'),
1107(3401, 3, 'Delmenhorst', 'Kreisfreie Stadt'),
1108(3402, 3, 'Emden', 'Kreisfreie Stadt'),
1109(3403, 3, 'Oldenburg (Oldenburg)', 'Kreisfreie Stadt'),
1110(3404, 3, 'Osnabrï¿½ck', 'Kreisfreie Stadt'),
1111(3405, 3, 'Wilhelmshaven', 'Kreisfreie Stadt'),
1112(3451, 3, 'Ammerland', 'Landkreis'),
1113(3452, 3, 'Aurich', 'Landkreis'),
1114(3453, 3, 'Cloppenburg', 'Landkreis'),
1115(3454, 3, 'Emsland', 'Landkreis'),
1116(3455, 3, 'Friesland', 'Landkreis'),
1117(3456, 3, 'Grafschaft Bentheim', 'Landkreis'),
1118(3457, 3, 'Leer', 'Landkreis'),
1119(3458, 3, 'Oldenburg', 'Landkreis'),
1120(3459, 3, 'Osnabrï¿½ck', 'Landkreis'),
1121(3460, 3, 'Vechta', 'Landkreis'),
1122(3461, 3, 'Wesermarsch', 'Landkreis'),
1123(3462, 3, 'Wittmund', 'Landkreis'),
1124(4011, 4, 'Bremen', 'Kreisfreie Stadt'),
1125(4012, 4, 'Bremerhaven', 'Kreisfreie Stadt'),
1126(5111, 5, 'Dï¿½sseldorf', 'Kreisfreie Stadt'),
1127(5112, 5, 'Duisburg', 'Kreisfreie Stadt'),
1128(5113, 5, 'Essen', 'Kreisfreie Stadt'),
1129(5114, 5, 'Krefeld', 'Kreisfreie Stadt'),
1130(5116, 5, 'Mï¿½nchengladbach', 'Kreisfreie Stadt'),
1131(5117, 5, 'Mï¿½lheim an der Ruhr', 'Kreisfreie Stadt'),
1132(5119, 5, 'Oberhausen', 'Kreisfreie Stadt'),
1133(5120, 5, 'Remscheid', 'Kreisfreie Stadt'),
1134(5122, 5, 'Solingen', 'Kreisfreie Stadt'),
1135(5124, 5, 'Wuppertal', 'Kreisfreie Stadt'),
1136(5154, 5, 'Kleve', 'Kreis'),
1137(5158, 5, 'Mettmann', 'Kreis'),
1138(5162, 5, 'Rhein-Kreis Neuss', 'Kreis'),
1139(5166, 5, 'Viersen', 'Kreis'),
1140(5170, 5, 'Wesel', 'Kreis'),
1141(5314, 5, 'Bonn', 'Kreisfreie Stadt'),
1142(5315, 5, 'Kï¿½ln', 'Kreisfreie Stadt'),
1143(5316, 5, 'Leverkusen', 'Kreisfreie Stadt'),
1144(5334, 5, 'Stï¿½dteregion Aachen', '(einschl. Stadt Aachen)'),
1145(5354, 5, 'Aachen', 'Kreis'),
1146(5358, 5, 'Dï¿½ren', 'Kreis'),
1147(5362, 5, 'Rhein-Erft-Kreis', 'Kreis'),
1148(5366, 5, 'Euskirchen', 'Kreis'),
1149(5370, 5, 'Heinsberg', 'Kreis'),
1150(5374, 5, 'Oberbergischer Kreis', 'Kreis'),
1151(5378, 5, 'Rheinisch-Bergischer Kreis', 'Kreis'),
1152(5382, 5, 'Rhein-Sieg-Kreis', 'Kreis'),
1153(5512, 5, 'Bottrop', 'Kreisfreie Stadt'),
1154(5513, 5, 'Gelsenkirchen', 'Kreisfreie Stadt'),
1155(5515, 5, 'Mï¿½nster', 'Kreisfreie Stadt'),
1156(5554, 5, 'Borken', 'Kreis'),
1157(5558, 5, 'Coesfeld', 'Kreis'),
1158(5562, 5, 'Recklinghausen', 'Kreis'),
1159(5566, 5, 'Steinfurt', 'Kreis'),
1160(5570, 5, 'Warendorf', 'Kreis'),
1161(5711, 5, 'Bielefeld', 'Kreisfreie Stadt'),
1162(5754, 5, 'Gï¿½tersloh', 'Kreis'),
1163(5758, 5, 'Herford', 'Kreis'),
1164(5762, 5, 'Hï¿½xter', 'Kreis'),
1165(5766, 5, 'Lippe', 'Kreis'),
1166(5770, 5, 'Minden-Lï¿½bbecke', 'Kreis'),
1167(5774, 5, 'Paderborn', 'Kreis'),
1168(5911, 5, 'Bochum', 'Kreisfreie Stadt'),
1169(5913, 5, 'Dortmund', 'Kreisfreie Stadt'),
1170(5914, 5, 'Hagen', 'Kreisfreie Stadt'),
1171(5915, 5, 'Hamm', 'Kreisfreie Stadt'),
1172(5916, 5, 'Herne', 'Kreisfreie Stadt'),
1173(5954, 5, 'Ennepe-Ruhr-Kreis', 'Kreis'),
1174(5958, 5, 'Hochsauer Landkreis', 'Landkreis'),
1175(5962, 5, 'Mï¿½rkischer Kreis', 'Kreis'),
1176(5966, 5, 'Olpe', 'Kreis'),
1177(5970, 5, 'Siegen-Wittgenstein', 'Kreis'),
1178(5974, 5, 'Soest', 'Kreis'),
1179(5978, 5, 'Unna', 'Kreis'),
1180(6411, 6, 'Darmstadt', 'Kreisfreie Stadt'),
1181(6412, 6, 'Frankfurt am Main', 'Kreisfreie Stadt'),
1182(6413, 6, 'Offenbach am Main', 'Kreisfreie Stadt'),
1183(6414, 6, 'Wiesbaden', 'Landeshauptstadt'),
1184(6431, 6, 'Bergstraï¿½e', 'Landkreis'),
1185(6432, 6, 'Darmstadt-Dieburg', 'Landkreis'),
1186(6433, 6, 'Groï¿½-Gerau', 'Landkreis'),
1187(6434, 6, 'HochtaunusKreis', 'Kreis'),
1188(6435, 6, 'Main-Kinzig-Kreis', 'Kreis'),
1189(6436, 6, 'Main-Taunus-Kreis', 'Kreis'),
1190(6437, 6, 'OdenwaldKreis', 'Kreis'),
1191(6438, 6, 'Offenbach', 'Landkreis'),
1192(6439, 6, 'Rheingau-Taunus-Kreis', 'Kreis'),
1193(6440, 6, 'WetterauKreis', 'Kreis'),
1194(6531, 6, 'Gieï¿½en', 'Landkreis'),
1195(6532, 6, 'Lahn-Dill-Kreis', 'Kreis'),
1196(6533, 6, 'Limburg-Weilburg', 'Landkreis'),
1197(6534, 6, 'Marburg-Biedenkopf', 'Landkreis'),
1198(6535, 6, 'VogelsbergKreis', 'Kreis'),
1199(6611, 6, 'Kassel', 'Kreisfreie Stadt'),
1200(6631, 6, 'Fulda', 'Landkreis'),
1201(6632, 6, 'Hersfeld-Rotenburg', 'Landkreis'),
1202(6633, 6, 'Kassel', 'Landkreis'),
1203(6634, 6, 'Schwalm-Eder-Kreis', 'Kreis'),
1204(6635, 6, 'Waldeck-Frankenberg', 'Landkreis'),
1205(6636, 6, 'Werra-Meiï¿½ner-Kreis', 'Kreis'),
1206(7111, 7, 'Koblenz', 'Kreisfreie Stadt'),
1207(7131, 7, 'Ahrweiler', 'Landkreis'),
1208(7132, 7, 'Altenkirchen (Westerwald)', 'Landkreis'),
1209(7133, 7, 'Bad Kreuznach', 'Landkreis'),
1210(7134, 7, 'Birkenfeld', 'Landkreis'),
1211(7135, 7, 'Cochem-Zell', 'Landkreis'),
1212(7137, 7, 'Mayen-Koblenz', 'Landkreis'),
1213(7138, 7, 'Neuwied', 'Landkreis'),
1214(7140, 7, 'Rhein-Hunsrï¿½ck-Kreis', 'Kreis'),
1215(7141, 7, 'Rhein-Lahn-Kreis', 'Kreis'),
1216(7143, 7, 'WesterwaldKreis', 'Kreis'),
1217(7211, 7, 'Trier', 'Kreisfreie Stadt'),
1218(7231, 7, 'Bernkastel-Wittlich', 'Landkreis'),
1219(7232, 7, 'Eifelkreis Bitburg-Prï¿½m', 'Kreis'),
1220(7233, 7, 'Vulkaneifel', 'Landkreis'),
1221(7235, 7, 'Trier-Saarburg', 'Landkreis'),
1222(7311, 7, 'Frankenthal (Pfalz)', 'Kreisfreie Stadt'),
1223(7312, 7, 'Kaiserslautern', 'Kreisfreie Stadt'),
1224(7313, 7, 'Landau in der Pfalz', 'Kreisfreie Stadt'),
1225(7314, 7, 'Ludwigshafen am Rhein', 'Kreisfreie Stadt'),
1226(7315, 7, 'Mainz', 'Kreisfreie Stadt'),
1227(7316, 7, 'Neustadt an der Weinstraï¿½e', 'Kreisfreie Stadt'),
1228(7317, 7, 'Pirmasens', 'Kreisfreie Stadt'),
1229(7318, 7, 'Speyer', 'Kreisfreie Stadt'),
1230(7319, 7, 'Worms', 'Kreisfreie Stadt'),
1231(7320, 7, 'Zweibrï¿½cken', 'Kreisfreie Stadt'),
1232(7331, 7, 'Alzey-Worms', 'Landkreis'),
1233(7332, 7, 'Bad Dï¿½rkheim', 'Landkreis'),
1234(7333, 7, 'DonnersbergKreis', 'Kreis'),
1235(7334, 7, 'Germersheim', 'Landkreis'),
1236(7335, 7, 'Kaiserslautern', 'Landkreis'),
1237(7336, 7, 'Kusel', 'Landkreis'),
1238(7337, 7, 'Sï¿½dliche Weinstraï¿½e', 'Landkreis'),
1239(7338, 7, 'Rhein-Pfalz-Kreis', 'Kreis'),
1240(7339, 7, 'Mainz-Bingen', 'Landkreis'),
1241(7340, 7, 'Sï¿½dwestpfalz', 'Landkreis'),
1242(8111, 8, 'Stuttgart', 'Landeshauptstadt'),
1243(8115, 8, 'Bï¿½blingen', 'Landkreis'),
1244(8116, 8, 'Esslingen', 'Landkreis'),
1245(8117, 8, 'Gï¿½ppingen', 'Landkreis'),
1246(8118, 8, 'Ludwigsburg', 'Landkreis'),
1247(8119, 8, 'Rems-Murr-Kreis', 'Kreis'),
1248(8121, 8, 'Heilbronn', 'Kreisfreie Stadt'),
1249(8125, 8, 'Heilbronn', 'Landkreis'),
1250(8126, 8, 'HohenloheKreis', 'Kreis'),
1251(8127, 8, 'Schwï¿½bisch Hall', 'Landkreis'),
1252(8128, 8, 'Main-Tauber-Kreis', 'Kreis'),
1253(8135, 8, 'Heidenheim', 'Landkreis'),
1254(8136, 8, 'OstalbKreis', 'Kreis'),
1255(8211, 8, 'Baden-Baden', 'Kreisfreie Stadt'),
1256(8212, 8, 'Karlsruhe', 'Kreisfreie Stadt'),
1257(8215, 8, 'Karlsruhe', 'Landkreis'),
1258(8216, 8, 'Rastatt', 'Landkreis'),
1259(8221, 8, 'Heidelberg', 'Kreisfreie Stadt'),
1260(8222, 8, 'Mannheim, Universitï¿½tsstadt', 'Kreisfreie Stadt'),
1261(8225, 8, 'Neckar-Odenwald-Kreis', 'Kreis'),
1262(8226, 8, 'Rhein-Neckar-Kreis', 'Kreis'),
1263(8231, 8, 'Pforzheim', 'Kreisfreie Stadt'),
1264(8235, 8, 'Calw', 'Landkreis'),
1265(8236, 8, 'EnzKreis', 'Kreis'),
1266(8237, 8, 'Freudenstadt', 'Landkreis'),
1267(8311, 8, 'Freiburg im Breisgau', 'Kreisfreie Stadt'),
1268(8315, 8, 'Breisgau-Hochschwarzwald', 'Landkreis'),
1269(8316, 8, 'Emmendingen', 'Landkreis'),
1270(8317, 8, 'OrtenauKreis', 'Kreis'),
1271(8325, 8, 'Rottweil', 'Landkreis'),
1272(8326, 8, 'Schwarzwald-Baar-Kreis', 'Kreis'),
1273(8327, 8, 'Tuttlingen', 'Landkreis'),
1274(8335, 8, 'Konstanz', 'Landkreis'),
1275(8336, 8, 'Lï¿½rrach', 'Landkreis'),
1276(8337, 8, 'Waldshut', 'Landkreis'),
1277(8415, 8, 'Reutlingen', 'Landkreis'),
1278(8416, 8, 'Tï¿½bingen', 'Landkreis'),
1279(8417, 8, 'ZollernalbKreis', 'Kreis'),
1280(8421, 8, 'Ulm, Universitï¿½tsstadt', 'Kreisfreie Stadt'),
1281(8425, 8, 'Alb-Donau-Kreis', 'Kreis'),
1282(8426, 8, 'Biberach', 'Landkreis'),
1283(8435, 8, 'BodenseeKreis', 'Kreis'),
1284(8436, 8, 'Ravensburg', 'Landkreis'),
1285(8437, 8, 'Sigmaringen', 'Landkreis'),
1286(9161, 9, 'Ingolstadt', 'kreisfreie GroÃŸstadt'),
1287(9162, 9, 'Mï¿½nchen', 'Landeshauptstadt'),
1288(9163, 9, 'Rosenheim', 'kreisfreie Stadt'),
1289(9171, 9, 'Altï¿½tting', 'Landkreis'),
1290(9172, 9, 'Berchtesgadener Land', 'Landkreis'),
1291(9173, 9, 'Bad Tï¿½lz-Wolfratshausen', 'Landkreis'),
1292(9174, 9, 'Dachau', 'Landkreis'),
1293(9175, 9, 'Ebersberg', 'Landkreis'),
1294(9176, 9, 'Eichstï¿½tt', 'Landkreis'),
1295(9177, 9, 'Erding', 'Landkreis'),
1296(9178, 9, 'Freising', 'Landkreis'),
1297(9179, 9, 'Fï¿½rstenfeldbruck', 'Landkreis'),
1298(9180, 9, 'Garmisch-Partenkirchen', 'Landkreis'),
1299(9181, 9, 'Landsberg am Lech', 'Landkreis'),
1300(9182, 9, 'Miesbach', 'Landkreis'),
1301(9183, 9, 'Mï¿½hldorf a.Inn', 'Landkreis'),
1302(9184, 9, 'Mï¿½nchen', 'Landkreis'),
1303(9185, 9, 'Neuburg-Schrobenhausen', 'Landkreis'),
1304(9186, 9, 'Pfaffenhofen a.d.Ilm', 'Landkreis'),
1305(9187, 9, 'Rosenheim', 'Landkreis'),
1306(9188, 9, 'Starnberg', 'Landkreis'),
1307(9189, 9, 'Traunstein', 'Landkreis'),
1308(9190, 9, 'Weilheim-Schongau', 'Landkreis'),
1309(9263, 9, 'Straubing', 'kreisfreie Stad'),
1310(9271, 9, 'Deggendorf', 'Landkreis'),
1311(9272, 9, 'Freyung-Grafenau', 'Landkreis'),
1312(9273, 9, 'Kelheim', 'Landkreis'),
1313(9274, 9, 'Landshut', 'Landkreis'),
1314(9275, 9, 'Passau', 'Landkreis'),
1315(9276, 9, 'Regen', 'Landkreis'),
1316(9277, 9, 'Rottal-Inn', 'Landkreis'),
1317(9278, 9, 'Straubing-Bogen', 'Landkreis'),
1318(9279, 9, 'Dingolfing-Landau', 'Landkreis'),
1319(9361, 9, 'Amberg', 'Landkreis'),
1320(9363, 9, 'Weiden i.d.OPf.', 'kreisfreie Stadt'),
1321(9371, 9, 'Amberg-Sulzbach', 'Landkreis'),
1322(9372, 9, 'Cham', 'Landkreis'),
1323(9373, 9, 'Neumarkt i.d.OPf.', 'Landkreis'),
1324(9374, 9, 'Neustadt a.d.Waldnaab', 'Landkreis'),
1325(9375, 9, 'Regensburg', 'Landkreis'),
1326(9376, 9, 'Schwandorf', 'Landkreis'),
1327(9377, 9, 'Tirschenreuth', 'Landkreis'),
1328(9471, 9, 'Bamberg', 'Landkreis'),
1329(9472, 9, 'Bayreuth', 'Landkreis'),
1330(9473, 9, 'Coburg', 'Landkreis'),
1331(9474, 9, 'Forchheim', 'Landkreis'),
1332(9475, 9, 'Hof', 'Landkreis'),
1333(9476, 9, 'Kronach', 'Landkreis'),
1334(9477, 9, 'Kulmbach', 'Landkreis'),
1335(9478, 9, 'Lichtenfels', 'Landkreis'),
1336(9479, 9, 'Wunsiedel i.Fichtelgebirge', 'Landkreis'),
1337(9571, 9, 'Ansbach', 'Landkreis'),
1338(9572, 9, 'Erlangen-Hï¿½chstadt', 'Landkreis'),
1339(9573, 9, 'Fï¿½rth', 'Landkreis'),
1340(9574, 9, 'Nï¿½rnberger Land', 'Landkreis'),
1341(9575, 9, 'Neustadt a.d.Aisch-Bad Windsheim', 'Landkreis'),
1342(9576, 9, 'Roth', 'Landkreis'),
1343(9577, 9, 'Weiï¿½enburg-Gunzenhausen', 'Landkreis'),
1344(9671, 9, 'Aschaffenburg', 'Landkreis'),
1345(9672, 9, 'Bad Kissingen', 'Landkreis'),
1346(9673, 9, 'Rhï¿½n-Grabfeld', 'Landkreis'),
1347(9674, 9, 'Haï¿½berge', 'Landkreis'),
1348(9675, 9, 'Kitzingen', 'Landkreis'),
1349(9676, 9, 'Miltenberg', 'Landkreis'),
1350(9677, 9, 'Main-Spessart', 'Landkreis'),
1351(9678, 9, 'Schweinfurt', 'Landkreis'),
1352(9679, 9, 'Wï¿½rzburg', 'Landkreis'),
1353(9762, 9, 'Kaufbeuren ', 'kreisfreie Stadt'),
1354(9763, 9, 'Kempten (Allgï¿½u)', 'kreisfreie Stadt'),
1355(9764, 9, 'Memmingen', 'kreisfreise Stadt'),
1356(9771, 9, 'Aichach-Friedberg', 'Landkreis'),
1357(9772, 9, 'Augsburg', 'Landkreis'),
1358(9773, 9, 'Dillingen a.d.Donau', 'Landkreis'),
1359(9774, 9, 'Gï¿½nzburg', 'Landkreis'),
1360(9775, 9, 'Neu-Ulm', 'Landkreis'),
1361(9776, 9, 'Lindau (Bodensee)', 'Landkreis'),
1362(9777, 9, 'Ostallgï¿½u', 'Landkreis'),
1363(9778, 9, 'Unterallgï¿½u', 'Landkreis'),
1364(9779, 9, 'Donau-Ries', 'Landkreis'),
1365(9780, 9, 'Oberallgï¿½u', 'Landkreis'),
1366(10041, 10, 'Saarbrï¿½cken', 'Regionalverband'),
1367(10042, 10, 'Merzig-Wadern', 'Landkreis'),
1368(10043, 10, 'Neunkirchen', 'Landkreis'),
1369(10044, 10, 'Saarlouis', 'Landkreis'),
1370(10045, 10, 'Saarpfalz-Kreis', 'Kreis'),
1371(10046, 10, 'St. Wendel', 'Landkreis'),
1372(12051, 12, 'Brandenburg an der Havel', 'Kreisfreie Stadt'),
1373(12052, 12, 'Cottbus', 'Kreisfreie Stadt'),
1374(12053, 12, 'Frankfurt (Oder)', 'Kreisfreie Stadt'),
1375(12054, 12, 'Potsdam', 'Kreisfreie Stadt'),
1376(12060, 12, 'Barnim', 'Landkreis'),
1377(12061, 12, 'Dahme-Spreewald', 'Landkreis'),
1378(12062, 12, 'Elbe-Elster', 'Landkreis'),
1379(12063, 12, 'Havelland', 'Landkreis'),
1380(12064, 12, 'Mï¿½rkisch-Oderland', 'Landkreis'),
1381(12065, 12, 'Oberhavel', 'Landkreis'),
1382(12066, 12, 'Oberspreewald-Lausitz', 'Landkreis'),
1383(12067, 12, 'Oder-Spree', 'Landkreis'),
1384(12068, 12, 'Ostprignitz-Ruppin', 'Landkreis'),
1385(12069, 12, 'Potsdam-Mittelmark', 'Landkreis'),
1386(12070, 12, 'Prignitz', 'Landkreis'),
1387(12071, 12, 'Spree-Neiï¿½e', 'Landkreis'),
1388(12072, 12, 'Teltow-Flï¿½ming', 'Landkreis'),
1389(12073, 12, 'Uckermark', 'Landkreis'),
1390(13001, 13, 'Kreisfreie Stadt Greifswald', 'Hansestadt'),
1391(13002, 13, 'Neubrandenburg', 'Kreisfreie Stadt'),
1392(13003, 13, 'Kreisfreie Stadt Rostock', 'Hansestadt'),
1393(13004, 13, 'Kreisfreie Stadt Schwerin', 'Landeshauptstadt'),
1394(13005, 13, 'Kreisfreie Stadt Stralsund', 'Hansestadt'),
1395(13006, 13, 'Kreisfreie Stadt Wismar', 'Hansestadt'),
1396(13051, 13, 'Bad Doberan', 'Landkreis'),
1397(13052, 13, 'Demmin', 'Landkreis'),
1398(13053, 13, 'Gï¿½strow', 'Landkreis'),
1399(13054, 13, 'Ludwigslust', 'Landkreis'),
1400(13055, 13, 'Mecklenburg-Strelitz', 'Landkreis'),
1401(13056, 13, 'Mï¿½ritz', 'Landkreis'),
1402(13057, 13, 'Nordvorpommern', 'Landkreis'),
1403(13058, 13, 'Nordwestmecklenburg', 'Landkreis'),
1404(13059, 13, 'Ostvorpommern', 'Landkreis'),
1405(13060, 13, 'Parchim', 'Landkreis'),
1406(13061, 13, 'Rï¿½gen', 'Landkreis'),
1407(13062, 13, 'Uecker-Randow', 'Landkreis'),
1408(13071, 13, 'Mecklenburgische Seenplatte', 'Landkreis'),
1409(13072, 13, 'Rostock', 'Landkreis'),
1410(13073, 13, 'Vorpommern-Rï¿½gen', 'Landkreis'),
1411(13074, 13, 'Nordwestmecklenburg', 'Landkreis'),
1412(13075, 13, 'Vorpommern-Greifswald', 'Landkreis'),
1413(13076, 13, 'Ludwigslust-Parchim', 'Landkreis'),
1414(14161, 14, 'Chemnitz', 'Kreisfreie Stadt'),
1415(14166, 14, 'Plauen', 'Kreisfreie Stadt'),
1416(14167, 14, 'Zwickau', 'Kreisfreie Stadt'),
1417(14171, 14, 'Annaberg', 'Landkreis'),
1418(14173, 14, 'Chemnitzer Land', 'Landkreis'),
1419(14177, 14, 'Freiberg', 'Landkreis'),
1420(14178, 14, 'Vogt', 'Landkreis'),
1421(14181, 14, 'Mittlerer ErzgebirgsKreis', 'Kreis'),
1422(14182, 14, 'Mittweida', 'Landkreis'),
1423(14188, 14, 'Stollberg', 'Landkreis'),
1424(14191, 14, 'Aue-Schwarzenberg', 'Landkreis'),
1425(14193, 14, 'Zwickauer Land', 'Landkreis'),
1426(14262, 14, 'Dresden', 'Kreisfreie Stadt'),
1427(14263, 14, 'Gï¿½rlitz', 'Kreisfreie Stadt'),
1428(14264, 14, 'Hoyerswerda', 'Kreisfreie Stadt'),
1429(14272, 14, 'Bautzen', 'Landkreis'),
1430(14280, 14, 'Meiï¿½en', 'Landkreis'),
1431(14284, 14, 'Niederschlesischer OberlausitzKreis', 'Kreis'),
1432(14285, 14, 'Riesa-Groï¿½enhain', 'Landkreis'),
1433(14286, 14, 'Lï¿½bau-Zittau', 'Landkreis'),
1434(14287, 14, 'Sï¿½chsische Schweiz', 'Landkreis'),
1435(14290, 14, 'Weiï¿½eritzKreis', 'Kreis'),
1436(14292, 14, 'Kamenz', 'Landkreis'),
1437(14365, 14, 'Leipzig', 'Kreisfreie Stadt'),
1438(14374, 14, 'Delitzsch', 'Landkreis'),
1439(14375, 14, 'Dï¿½beln', 'Landkreis'),
1440(14379, 14, 'Leipziger Land', 'Landkreis'),
1441(14383, 14, 'MuldentalKreis', 'Kreis'),
1442(14389, 14, 'Torgau-Oschatz', 'Landkreis'),
1443(14511, 14, 'Chemnitz', 'Kreisfrei Stadt'),
1444(14521, 14, 'ErzgebirgsKreis', 'Kreis'),
1445(14522, 14, 'Mittelsachsen', 'Landkreis'),
1446(14523, 14, 'Vogt', 'Landkreis'),
1447(14524, 14, 'Zwickau', 'Landkreis'),
1448(14612, 14, 'Dresden', 'Stadt'),
1449(14625, 14, 'Bautzen', 'Landkreis'),
1450(14626, 14, 'Gï¿½rlitz', 'Landkreis'),
1451(14627, 14, 'Meiï¿½en', 'Landkreis'),
1452(14628, 14, 'Sï¿½chsische Schweiz-Osterzgebirge', 'Landkreis'),
1453(14713, 14, 'Leipzig', 'Stadt'),
1454(14729, 14, 'Leipzig', 'Landkreis'),
1455(14730, 14, 'Nordsachsen', 'Landkreis'),
1456(15001, 15, 'Dessau-Roï¿½lau', 'Kreisfreie Stadt'),
1457(15002, 15, 'Halle (Saale)', 'Kreisfreie Stadt'),
1458(15003, 15, 'Magdeburg', 'Kreisfreie Stadt'),
1459(15081, 15, 'Altmarkkreis Salzwedel', 'Landkreis'),
1460(15082, 15, 'Anhalt-Bitterfeld', 'Landkreis'),
1461(15083, 15, 'Bï¿½rde', 'Landkreis'),
1462(15084, 15, 'Burgen ', 'Landkreis'),
1463(15085, 15, 'Harz', 'Landkreis'),
1464(15086, 15, 'Jerichower Land', 'Landkreis'),
1465(15087, 15, 'Mansfeld-Sï¿½dharz', 'Landkreis'),
1466(15088, 15, 'SaaleKreis', 'Kreis'),
1467(15089, 15, '', 'Salz Landkreis'),
1468(15090, 15, 'Stendal', 'Landkreis'),
1469(15091, 15, 'Wittenberg', 'Landkreis'),
1470(15101, 15, 'Dessau', 'Kreisfreie Stadt'),
1471(15151, 15, 'Anhalt-Zerbst', 'Kreis'),
1472(15153, 15, 'Bernburg', 'Kreis'),
1473(15154, 15, 'Bitterfeld', 'Kreis'),
1474(15159, 15, 'Kï¿½then', 'Kreis'),
1475(15171, 15, 'Wittenberg', 'Kreis'),
1476(15202, 15, 'Halle (Saale)', 'Kreisfreie Stadt'),
1477(15256, 15, '', 'Burgen Landkreis'),
1478(15260, 15, 'Mansfelder Land', 'Kreis'),
1479(15261, 15, 'Merseburg-Querfurt', 'Kreis'),
1480(15265, 15, 'SaalKreis', 'Kreis'),
1481(15266, 15, 'Sangerhausen', 'Kreis'),
1482(15268, 15, 'Weiï¿½enfels', 'Kreis'),
1483(15303, 15, 'Magdeburg', 'Kreisfreie Stadt'),
1484(15352, 15, 'Aschersleben-Staï¿½furt', 'Kreis'),
1485(15355, 15, 'Bï¿½rdeKreis', 'Kreis'),
1486(15357, 15, 'Halberstadt', 'Kreis'),
1487(15358, 15, 'Jerichower Land', 'Kreis'),
1488(15362, 15, 'OhreKreis', 'Kreis'),
1489(15363, 15, 'Stendal', 'Kreis'),
1490(15364, 15, 'Quedlinburg', 'Kreis'),
1491(15367, 15, 'Schï¿½nebeck', 'Kreis'),
1492(15369, 15, 'Wernigerode', 'Kreis'),
1493(15370, 15, 'Altmarkkreis Salzwedel', 'Kreis'),
1494(16051, 16, 'Erfurt', 'kreisfreie Stadt'),
1495(16052, 16, 'Gera', 'kreisfreie Stadt'),
1496(16053, 16, 'Jena', 'kreisfreie Stadt'),
1497(16054, 16, 'Suhl', 'kreisfreie Stadt'),
1498(16055, 16, 'Weimar', 'kreisfreie Stadt'),
1499(16056, 16, 'Eisenach', 'kreisfreie Stadt'),
1500(16061, 16, 'Eichsfeld', 'Kreis'),
1501(16062, 16, 'Nordhausen', 'Kreis'),
1502(16063, 16, 'WartburgKreis', 'Kreis'),
1503(16064, 16, 'Unstrut-Hainich-Kreis', 'Kreis'),
1504(16065, 16, 'Kyffhï¿½userKreis', 'Kreis'),
1505(16066, 16, 'Schmalkalden-Meiningen', 'Kreis'),
1506(16067, 16, 'Gotha', 'Kreis'),
1507(16068, 16, 'Sï¿½mmerda', 'Kreis'),
1508(16069, 16, 'Hildburghausen', 'Kreis'),
1509(16070, 16, 'Ilm-Kreis', 'Kreis'),
1510(16071, 16, 'Weimarer Land', 'Kreis'),
1511(16072, 16, 'Sonneberg', 'Kreis'),
1512(16073, 16, 'Saalfeld-Rudolstadt', 'Kreis'),
1513(16074, 16, 'Saale-Holzland-Kreis', 'Kreis'),
1514(16075, 16, 'Saale-Orla-Kreis', 'Kreis'),
1515(16076, 16, 'Greiz', 'Kreis'),
1516(16077, 16, 'Altenburger Land', 'Kreis'),
1517(3241001, 3, 'Hannover', 'Landeshauptstadt'),
1518(5334002, 5, 'Aachen', 'kreisfreie Stadt'),
1519(10041100, 10, 'Saarbrï¿½cken', 'Landeshauptstadt');
1520
1521--
1522-- Indexes for dumped tables
1523--
1524
1525--
1526-- Indexes for table `Bevoelkerung`
1527--
1528ALTER TABLE `Bevoelkerung`
1529 ADD PRIMARY KEY (`Schluesselnummer`);
1530
1531--
1532-- Indexes for table `Bundesland`
1533--
1534ALTER TABLE `Bundesland`
1535 ADD PRIMARY KEY (`bl_ID`);
1536
1537--
1538-- Indexes for table `Kreisflaeche`
1539--
1540ALTER TABLE `Kreisflaeche`
1541 ADD PRIMARY KEY (`Schluesselnummer`);
1542
1543--
1544-- Indexes for table `Stadtkreis`
1545--
1546ALTER TABLE `Stadtkreis`
1547 ADD PRIMARY KEY (`Schluesselnummer`);
1548
1549/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1550/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1551/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;