annotate db_schema/stammdaten_data_staat.sql @ 1224:73ad827faa81

Rename validation of Ortszuordnung.
author Tom Gottfried <tom@intevation.de>
date Fri, 09 Dec 2016 15:34:15 +0100
parents 9b8b18c00804
children 5549c214e816
rev   line source
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
1 \set ON_ERROR_STOP on
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
3 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
4 -- PostgreSQL database dump
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
5 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
7 -- Dumped from database version 9.5.1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
8 -- Dumped by pg_dump version 9.5.0
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
9
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
10 -- Started on 2016-03-31 11:38:13
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
11
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
12 SET statement_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
13 SET lock_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
14 SET client_encoding = 'UTF8';
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
15 SET standard_conforming_strings = on;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
16 SET check_function_bodies = false;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
17 SET client_min_messages = warning;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
18
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
19 SET search_path = stammdaten, pg_catalog;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
20
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
21
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
22 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
23 -- TOC entry 4719 (class 0 OID 535836)
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
24 -- Dependencies: 285
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
25 -- Data for Name: staat; Type: TABLE DATA; Schema: stammdaten; Owner: lada
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
26 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
27
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
28 COPY staat (id, staat, hkl_id, staat_iso, staat_kurz, eu, koord_x_extern, koord_y_extern, kda_id) FROM stdin;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
29 346 Haiti 346 HT RH 0 -72,343109 18,526617 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
30 231 Cote d'Ivoire 231 CI CI 0 -5,272778 6,806667 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
31 365 Uruguay 365 UY ROU 0 -56,169998 -34,919998 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
32 355 Jamaika 355 JM JA 0 -76,797302 18,015713 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
33 236 Gabun 236 GA G 0 9,490457 -0,504145 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
34 238 Ghana 238 GH GH 0 -0,200924 5,558563 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
35 243 Kenia 243 KE EAK 0 36,830002 -1,17 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
36 247 Liberia 247 LR LB 0 -10,77 6,517439 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
37 369 St. Vincent und die Grenadinen 369 VC WV 0 -61,226111 13,160833 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
38 125 Bulgarien 125 BG BG 1 23,331871 42,707264 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
39 128 Finnland 128 FI FIN 1 24,9767 60,196423 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
40 136 Island 136 IS IS 0 -21,336821 64,313263 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
41 138 Jugoslawien, Bundesrepublik 138 YU YU 0 20,412556 44,799683 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
42 143 Luxemburg 143 LU L 1 6,273256 49,740406 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
43 147 Monaco 147 MC MC 0 7,416667 43,733333 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
44 153 Portugal 153 PT P 1 -9,13 38,73 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
45 158 Schweiz 158 CH CH 0 7,445736 46,948208 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
46 161 Spanien 161 ES E 1 -3,690969 40,442219 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
47 167 Vatikanstadt 167 VA V 0 12,52 41,880001 4
1221
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
48 195 Britisch abhängige Gebiete in Europa 195 \N \N 0 0 0 4
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
49 199 übriges Europa 199 \N \N 0 0 0 4
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
50 221 Algerien 221 DZ DZ 0 2,993693 36,596493 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
51 229 Benin 229 BJ BJ 0 2,632503 6,601096 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
52 122 Bosnien und Herzegowina 122 BA BIH 0 18,43 43,869999 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
53 224 Eritrea 224 ER ER 0 38,970001 15,33 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
54 422 Armenien 422 AM ARM 0 44,532669 40,208023 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
55 450 Kirgisistan 450 KG KS 0 74,566667 42,866667 4
1221
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
56 527 Cookinseln 527 CK \N 0 -161 -15 4
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
57 537 Palau 537 PW PAL 0 134,634167 7,493333 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
58 545 Mikronesien 545 FM FSM 0 158,158333 6,917778 4
1221
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
59 661 Niue 533 NU \N 0 -169,869722 -19,063333 4
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
60 680 Kosovo 133 XK KOS 0 20,835278 42,551944 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
61 681 Montenegro 170 ME MNE 0 19,216667 42,766667 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
62 682 Serbien 171 RS SB 0 20,933333 43,95 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
63 461 Pakistan 461 PK PK 0 73,060547 33,718151 4
1223
9b8b18c00804 Make all state identifiers unique.
Tom Gottfried <tom@intevation.de>
parents: 1221
diff changeset
64 465 Taiwan 465 TW TW 0 121,506729 25,035091 4
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
65 467 Korea, Republik 467 KR ROK 0 126,935249 37,542351 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
66 472 Saudi-Arabien 472 SA KSA 0 46,77 24,65 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
67 475 Syrien 475 SY SYR 0 36,313454 33,519302 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
68 479 China 479 CN RC 0 116,388039 39,906193 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
69 248 Libyen 248 LY LAR 0 13,211823 32,751617 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
70 367 Venezuela 367 VE YV 0 -66,898285 10,496049 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
71 251 Mali 251 ML RMM 0 -7,986482 12,65295 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
72 253 Mauritius 253 MU MS 0 57,5 -20,166667 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
73 255 Niger 255 NE RN 0 2,08345 13,604544 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
74 256 Malawi 256 MW MW 0 33,82 -13,92 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
75 258 Burkina Faso 258 BF BF 0 -1,67 12,48 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
76 261 Guinea 261 GN RG 0 -12,8 9,52 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
77 262 Kamerun 262 CM CAM 0 11,513641 3,865123 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
78 265 Ruanda 265 RW RWA 0 29,991486 -2,117935 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
79 269 Senegal 269 SN SN 0 -16,848095 14,63 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
80 272 Sierra Leone 272 SL WAL 0 -12,910276 8,382771 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
81 274 Äquatorialguinea 274 GQ GQ 0 8,82 3,644685 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
82 281 Swasiland 281 SZ SD 0 31,191298 -26,303381 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
83 283 Togo 283 TG TG 0 1,35 6,28 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
84 284 Tschad 284 TD TD 0 15,240824 12,104139 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
85 286 Uganda 286 UG EAU 0 32,580002 0,32 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
86 289 Zentralafrikanische Republik 289 CF RCA 0 18,562342 4,365856 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
87 320 Antigua und Barbuda 320 AG AG 0 -61,844722 17,121111 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
88 323 Argentinien 323 AR RA 0 -58,409592 -34,665401 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
89 326 Bolivien 326 BO BOL 0 -68,146248 -16,499006 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
90 328 Guyana 328 GY GUY 0 -58,169998 6,77 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
91 332 Chile 332 CL RCH 0 -70,647514 -33,475025 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
92 334 Costa Rica 334 CR CR 0 -84,078613 9,930476 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
93 335 Dominikanische Republik 335 DO DOM 0 -69,910492 18,499729 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
94 340 Grenada 340 GD WG 0 -61,741667 12,044444 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
95 345 Guatemala 345 GT GCA 0 -90,524902 14,618008 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
96 347 Honduras 347 HN HN 0 -87,203094 14,099051 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
97 349 Kolumbien 349 CO CO 0 -74,080513 4,63022 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
98 361 Peru 361 PE PE 0 -76,823555 -12,067996 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
99 364 Suriname 364 SR SME 0 -55,23 5,93 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
100 351 Kuba 351 CU C 0 -82,41645 23,048952 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
101 543 Samoa 543 WS WS 0 -171,751811 -13,831386 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
102 230 Dschibuti 230 DJ DJI 0 43,099998 11,5 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
103 237 Gambia 237 GM WAG 0 -16,494616 13,445272 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
104 239 Mauretanien 239 MR RIM 0 -15,782861 18,030001 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
105 245 Kongo, Republik 245 CG RCB 0 15,285149 -4,285187 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
106 0 Deutschland 0 DE D 1 13,327573 52,516273 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
107 124 Belgien 124 BE B 1 4,367612 50,837048 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
108 126 Dänemark 126 DK DK 1 12,55 55,720001 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
109 129 Frankreich 129 FR F 1 2,432833 48,881554 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
110 135 Irland 135 IE IRL 1 -6,257347 53,34156 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
111 139 Lettland 139 LV LV 1 24,049999 56,880001 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
112 142 Litauen 142 LT LT 1 25,275967 54,688568 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
113 148 Niederlande 148 NL NL 1 4,894833 52,373043 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
114 151 Österreich 151 AT A 1 16,320986 48,202118 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
115 154 Rumänien 154 RO ROM 1 26,122976 44,430485 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
116 157 Schweden 157 SE S 1 18,084269 59,244633 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
117 162 Tschechische Republik 164 CZ CZ 1 14,45652 50,105896 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
118 165 Ungarn 165 HU H 1 19,09425 47,514626 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
119 181 Zypern 181 CY CY 1 33,385162 35,16507 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
120 225 Äthiopien 225 ET ETH 0 38,700001 9,03 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
121 227 Botsuana 227 BW RB 0 25,794802 -24,661442 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
122 130 Kroatien 130 HR HR 0 15,964386 45,807076 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
123 131 Slowenien 131 SI SLO 1 14,639612 46,068302 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
124 425 Aserbaidschan 425 AZ AZ 0 49,816238 40,324299 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
125 470 Tadschikistan 470 TJ TJ 0 68,900002 38,630001 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
126 477 Usbekistan 477 UZ UZ 0 69,349869 41,247932 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
127 354 Nicaragua 354 NI NIC 0 -86,273033 12,151473 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
128 233 Simbabwe 233 ZW ZW 0 31,02 -17,83 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
129 244 Komoren 244 KM COM 0 43,253611 -11,703611 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
130 121 Albanien 121 AL AL 0 19,831804 41,331654 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
131 127 Estland 127 EE EST 1 24,752056 59,277573 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
132 137 Italien 137 IT I 1 12,52 41,880001 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
133 145 Malta 145 MT M 1 14,514722 35,899722 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
134 152 Polen 152 PL PL 1 21,011879 52,244946 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
135 159 Russische Föderation 160 RU RUS 0 37,700001 55,75 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
136 160 Ukraine 166 UA UA 0 30,502111 50,448158 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
137 146 Moldau, Republik 146 MD MD 0 28,83 47 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
138 444 Kasachstan 444 KZ KZ 0 76,912628 43,255062 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
139 544 Marshallinseln 544 MH MH 0 171,366667 7,116667 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
140 620 Weißrussland 169 BY BY 0 27,575567 53,899937 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
141 523 Australien 523 AU AUS 0 149,041626 -35,349926 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
142 526 Fidschi 526 FJ FJI 0 178,433333 -18,133333 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
143 532 Vanuatu 532 VU VAN 0 168,3 -17,75 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
144 538 Papua-Neuguinea 538 PG PNG 0 147,41452 -9,55 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
145 357 Panama 357 PA PA 0 -79,400002 8,95 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
146 541 Tonga 541 TO TON 0 -175,208331 -21,134644 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
147 371 Trinidad und Tobago 371 TT TT 0 -61,490063 10,639734 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
148 423 Afghanistan 423 AF AFG 0 69,136757 34,530907 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
149 427 Myanmar 427 MM MYA 0 96,124893 16,872223 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
150 432 Vietnam 432 VN VN 0 105,819908 21,031948 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
151 436 Indien 436 IN IND 0 77,216751 28,568726 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
152 439 Iran, Islamische Republik 439 IR IR 0 51,447651 35,774475 4
1221
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
153 660 Timor-Leste 483 TL \N 0 125,75 -8,966667 4
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
154 446 Kambodscha 446 KH K 0 104,913193 11,564736 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
155 448 Kuwait 448 KW KWT 0 48,002777 29,19499 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
156 454 Malediven 454 MV MV 0 73,509444 4,174444 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
157 457 Mongolei 457 MN MGL 0 106,912354 47,928596 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
158 462 Philippinen 462 PH RP 0 121,173409 14,55 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
159 476 Thailand 476 TH T 0 100,552666 13,745571 4
1221
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
160 595 Britisch abhängige Gebiete in Australien/Ozeanien 595 \N \N 0 0 0 4
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
161 368 Vereinigte Staaten 368 US USA 0 -76,953835 38,890911 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
162 257 Sambia 257 ZM Z 0 28,17 -15,43 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
163 263 Südafrika 263 ZA ZA 0 28,218372 -25,731346 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
164 273 Somalia 273 SO SO 0 45,344143 2,041178 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
165 285 Tunesien 285 TN TN 0 10,16596 36,818813 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
166 291 Burundi 291 BI RU 0 29,533587 -3,269084 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
167 324 Bahamas 324 BS BS 0 -77,333333 25,066667 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
168 330 Belize 330 BZ BZ 0 -88,800003 17,120001 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
169 337 El Salvador 337 SV ES 0 -89,200233 13,701412 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
170 348 Kanada 348 CA CDN 0 -75,650749 45,374218 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
171 353 Mexiko 353 MX MEX 0 -99,127571 19,427046 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
172 232 Nigeria 232 NG WAN 0 3,3 6,45 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
173 242 Kap Verde 242 CV CV 0 -23,516667 14,916667 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
174 246 Kongo, Demokratische Republik 246 CD CGO 0 15,469294 -4,388675 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
175 123 Andorra 123 AD AND 0 1,5225 42,5075 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
176 134 Griechenland 134 GR GR 1 23,654863 38,121601 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
177 141 Liechtenstein 141 LI FL 0 9,521804 47,139651 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
178 149 Norwegen 149 NO N 0 10,72 59,93 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
179 156 San Marino 156 SM RSM 0 12,457123 43,938451 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
180 163 Türkei 163 TR TR 0 32,853271 39,929329 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
181 168 Vereinigtes Königreich 168 GB GB 1 -0,177998 51,487911 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
182 226 Lesotho 226 LS LS 0 27,890388 -29,25671 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
183 144 Mazedonien 144 MK MK 0 21,530001 42 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
184 430 Georgien 430 GE GE 0 44,783127 41,721809 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
185 471 Turkmenistan 471 TM TM 0 58,390133 37,95042 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
186 640 Serbien und Montenegro 132 CS SCG 0 20,412556 44,799683 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
187 169 Slowakei 155 SK SK 1 17,269806 48,274509 4
1221
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
188 499 Übriges Asien 499 \N \N 0 0 0 4
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
189 524 Salomonen 524 SB SOL 0 159,95 -9,433333 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
190 530 Kiribati 530 KI KIR 0 172,971111 1,4075 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
191 531 Nauru 531 NR NAU 0 166,919608 -0,543425 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
192 536 Neuseeland 536 NZ NZ 0 175,144943 -41,210396 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
193 540 Tuvalu 540 TV TUV 0 179,123056 -8,504167 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
194 249 Madagaskar 249 MG RM 0 47,5 -18,870001 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
195 359 Paraguay 359 PY PY 0 -57,669998 -25,219999 4
1221
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
196 996 unbekanntes Ausland 996 \N \N 0 0 0 4
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
197 998 ungeklärt 998 \N \N 0 0 0 4
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
198 999 ohne Angabe 999 \N \N 0 0 0 4
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
199 370 St. Kitts und Nevis 370 KN KAN 0 -62,734167 17,298333 4
1221
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
200 395 Britisch abhängige Gebiete in Amerika 395 \N \N 0 0 0 4
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
201 399 übriges Amerika (Grönland, Guadeloupe, Martinique) 399 \N \N 0 0 0 4
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
202 421 Jemen 421 YE YEM 0 44,209503 15,361444 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
203 424 Bahrain 424 BH BRN 0 50,583056 26,236111 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
204 426 Bhutan 426 BT BHT 0 89,667328 27,442606 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
205 429 Brunei Darussalam 429 BN BRU 0 114,967003 4,933 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
206 431 Sri Lanka 431 LK CL 0 80,088333 7,02 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
207 434 Korea, Demokratische Volksrepublik 434 KP KP 0 125,757515 39,028515 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
208 437 Indonesien 437 ID RI 0 106,762466 -6,293904 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
209 438 Irak 438 IQ IRQ 0 44,397835 33,334038 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
210 441 Israel 441 IL IL 0 34,856834 31,917198 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
211 442 Japan 442 JP J 0 139,809189 35,683056 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
212 445 Jordanien 445 JO JOR 0 35,932907 31,949383 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
213 447 Katar 447 QA Q 0 51,497234 25,203642 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
214 449 Laos 449 LA LAO 0 102,680237 18,001732 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
215 451 Libanon 451 LB RL 0 35,657944 33,779999 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
216 456 Oman 456 OM OM 0 58,62748 23,51664 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
217 282 Tansania 282 TZ EAT 0 39,253349 -6,817359 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
218 223 Angola 223 AO ANG 0 13,461779 -9 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
219 287 Ägypten 287 EG ET 0 31,250797 30,077911 4
1221
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
220 295 Britisch abhängige Gebiete in Afrika 295 \N \N 0 0 0 4
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
221 299 übriges Afrika (Mayotte, Reunion) 299 \N \N 0 0 0 4
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
222 322 Barbados 322 BB BDS 0 -59,583333 13,2 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
223 327 Brasilien 327 BR BR 0 -47,897747 -15,792109 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
224 333 Dominica 333 DM WD 0 -61,391111 15,298333 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
225 336 Ecuador 336 EC EC 0 -78,524284 -0,229498 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
226 267 Namibia 267 NA NAM 0 17,1 -22,57 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
227 458 Nepal 458 NP NEP 0 85,31295 27,712017 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
228 460 Bangladesch 460 BD BD 0 90,407143 23,709919 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
229 469 Vereinigte Arabische Emirate 469 AE UAE 0 54,61927 24,236008 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
230 474 Singapur 474 SG SGP 0 104,177116 1,229794 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
231 482 Malaysia 482 MY MAL 0 101,707672 3,15021 4
1221
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
232 495 Britisch abhängige Gebiete in Asien 495 \N \N 0 0 0 4
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
233 599 übriges Ozeanien 599 \N \N 0 0 0 4
59b0e54426d4 Use NULL instead of '-' for missing values.
Tom Gottfried <tom@intevation.de>
parents: 1191
diff changeset
234 994 von/nach See 994 \N \N 0 0 0 4
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
235 366 St. Lucia 366 LC WL 0 -60,977222 14,025278 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
236 252 Marokko 252 MA MA 0 -6,748041 33,920197 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
237 254 Mosambik 254 MZ MOC 0 32,573692 -25,962154 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
238 259 Guinea-Bissau 259 GW GUB 0 -15,65 11,91099 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
239 268 Sao Tome und Principe 268 ST STP 0 6,731389 0,336111 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
240 271 Seychellen 271 SC SY 0 55,461944 -4,630833 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
241 276 Sudan 276 SD SUD 0 32,529999 15,55 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
242 \.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)