Mercurial > gemma
annotate schema/demo-data/responsibility_areas.sql @ 4319:0d516bac1aae
bottleneck fairway availability: minor layout adjustments
author | Thomas Junk <thomas.junk@intevation.de> |
---|---|
date | Wed, 04 Sep 2019 12:21:36 +0200 |
parents | 1fe3b378544a |
children |
rev | line source |
---|---|
1318
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
1 -- This is Free Software under GNU Affero General Public License v >= 3.0 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
2 -- without warranty, see README.md and license for details. |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
3 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
4 -- SPDX-License-Identifier: AGPL-3.0-or-later |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
5 -- License-Filename: LICENSES/AGPL-3.0.txt |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
6 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
7 -- Copyright (C) 2018 by via donau |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
8 -- – Österreichische Wasserstraßen-Gesellschaft mbH |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
9 -- Software engineering by Intevation GmbH |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
10 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
11 -- Author(s): |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
12 -- * Sascha Wilde <sascha.wilde@intevation.de> |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
13 -- * Tom Gottfried <tom@intevation.de> |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
14 |
50dd4ff7907e
Added missing copyright headers and authors in schema related files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
1129
diff
changeset
|
15 |
211
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
16 -- Setup Country Codes |
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
17 COPY countries (country_code) FROM stdin; |
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
18 RO |
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
19 HU |
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
20 SK |
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
21 AT |
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
22 HR |
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
23 BG |
3394
72108f093371
Added preliminary responsibility area for RS.
Sascha Wilde <wilde@intevation.de>
parents:
1318
diff
changeset
|
24 RS |
211
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
25 \. |
e7826710d9c4
Make responsibility area mandatory
Tom Gottfried <tom@intevation.de>
parents:
208
diff
changeset
|
26 |
208
87f21b9a1292
Adapt demo-data to schema changes
Tom Gottfried <tom@intevation.de>
parents:
137
diff
changeset
|
27 COPY users.responsibility_areas (country, area) FROM stdin; |
3661
1fe3b378544a
Added handcrafted responsibility areas and matching stretches.
Sascha Wilde <wilde@intevation.de>
parents:
3394
diff
changeset
|
28 RO 0106000020E6100000010000000103000000020000005C000000D37ADD691F3238408F54CAE990D44540ACC4737D1F323840729F490790D445407D67576B721238403D49490F43D44540984C3A80341238405D9E7F16A6D6454006284723FA0638403B4C4A308BD64540C6C1DCEF54F237406C85831843D645405436284EE8F13740F6316D0B52DA454008FF942A51D237409E5461C7DAD94540354866E7E0D13740CADD40BA1BDE4540F1F89D2633B23740D6B5CF74C0DD4540293E13AA70B13740D818B51E5CE44540162B4476949137409188DF5EE3E3454059363A538D913740F8DAE0E93AE44540577CD157907E3740AFAF5A99F0E345409667FACD067E3740B0715C5485E84540EA0E630B415E37404F4703780BE84540739967D77D3E374006B067BD87E7454090C635E3D93E37403D7D665AACE445402E2784471B1F3740AD24F3C81FE44540B3288EF11A1F3740A1A2057822E4454012C746205EFF36404421B58993E34540111D8FB542FF3640860130365BE4454030AA36829EDF3640A92C8084BCE345406187635DDCDE364031C1B2D2A4E84540DA07BFD4CFCB3640133BAFB14BE8454077B6BDA431CA3640CFD2AE42CAF345405559DCF0DED03640EAD0C075E9F34540927AC7CE80CF36400A579C20A0FD4540900A2F2D8FCE364000A687A1D50246409B36AD80E7E136405BE0534A190346401CE88F286EE0364046807328A70D464025A8825149CD3640DC391E33500D4640A5A3A30189CC364048958375991246407F13BD8C62B936400E594C6C3E124640624017F87BB836405AE7DC547318464042648CD651A5364006E04048161846405186628621A5364027EB245B5D1946405A4C9352D0AF36407633D131311C464089114AA995B73640A7BA1F5CA61E464023554CB6CBCA36400E6522B6051F4640ECC84F7FA9CB364000A133BDCE1846401DE54385E5DE3640DC36940726194640845E4EC5A8DF3640200FF8E2A3134640591ED82AC1F23640DA1F7BBDFB134640AEC5AE2662F33640B32DF661620F4640461D166A4D1337407D5C2041F10F4640BB71A301BC153740314E452A8CFD45402CCFB1BCAB023740520F6E7C37FD4540F4A9A0A2EA03374020554843D7F445408159980865FD3640012CC203B9F44540B7A740FA81FE364093405BBD79EA4540662CA3F43D1E37403A0191CA08EB4540D5295AA8EB1D3740A8DA18969AED4540C8D24B31AC3D3740A130FDA60BEE45405E0E8F9B377D37407F8305026CEF4540D4D0E3F7367D374023218E7571EF4540EA1192054C903740A102B2D7BBEF4540CCD21D4CDD90374086E6D34CCAEA4540F298E61DA7B037408D02309E41EB45404BCA35FBCAB037404CC8079EFFE94540D28AD9379CD03740235C3D8276EA4540D75536BDD5D03740DA9A50D20DE845409F5CF5CA06D13740558F9D013FE64540A44FE6C4C3F03740E6AC5C03B6E6454003224F9025F1374029EFD68317E34540DC8A1260FD103840335A73918CE34540DA3A7B655C113840329276F49BDF45409358BADD263138400029EA16CBDF45409673DD0A5D313840B8D7A99958DD4540D21367672C513840BD385C5084DD45403387AD56DC5038402A3996C162E2454011E03983757038408940C7B370E24540ACD3C56D34703840447D8CB96BE54540340D238447833840D3075DC2A1E54540B0DFDF437F9638408E578638D6E545403A664F1FB0963840FA6032E074E34540442B9485AFA9384056E59C7D8AE34540C21D2DFBF1A938400677D599F2DF4540C581D38894BC384038306CE829E0454076EFAE7AC0BC38402878C02B38D8454014D6A93CCBBB384022231521D0D645406D87ADD9CABB3840262D58F498D64540406AF47BACAA38408BD1381E7DD6454061008BC3999738406C4D158C4AD64540A452270D4797384059EE8E0352DA4540FB66614F3B8438400460764F1EDA454015AF2E793071384010BCC23EE8D94540CEF774E1AC7138400C64E822CFD54540190524E4CD51384060FF0758ABD54540E38399EFE051384015EBB314DAD44540E94291FF134338407E0214D9BDD44540D37ADD691F3238408F54CAE990D44540040000004BCA35FBCAB037404CC8079EFFE945406D5B9BB5CAB037405FB2039DFFE94540006E8B08CBB03740C33F4F26FFE945404BCA35FBCAB037404CC8079EFFE94540 |
1fe3b378544a
Added handcrafted responsibility areas and matching stretches.
Sascha Wilde <wilde@intevation.de>
parents:
3394
diff
changeset
|
29 HU 0106000020E610000001000000010300000001000000DC0000003A75DB3B59AC32404C65D652400347400CFE092E56AC32402A8D87F71C044740034077499CAD32408405C765DC0447407013B8AE98B53240B029EFE368064740CF73EB6E9ECE324090A546E867124740ACD4BCAAB3D23240DAB292567C1547402586C476F7DC3240BDCEA96400184740B3FA0DDAABE53240215E398C931847407B78E09C11E53240B69344F6411C4740DC2AF52C08E53240D26AFC1DE52347407B8310902FE532407EE4F8A1D22647405953BEA085E03240FC6ACB80B32E47404212F96706DD324012AAB9DC60324740F5514ACFF4E63240AD66CEFA943B474062D116105ADB32409155116E324A47407544E4BB94D63240034DA7751B4E4740716CFF14D8D73240C4DC82B6E64E4740D915D1764CDD32403BD7D47954524740084D711C78F13240F48978EBFC534740882745F295FC3240A12D944C4E594740D83215E291FC3240C39ED497A55B474045D1BBA074FA3240CFB647252B5D47408EA69927D7F43240A43D96880161474050378CBB41F43240E70A82C7B76147404192D6BDBAEF3240FB4C90227C6447407C4024F900ED3240FE0FD2095766474001D3842689E932409199B5149068474012244F92AEE93240EE28ED0DBE6E47401F07B08F4EED3240E41F037976714740DDDF0A6135F232400F7F3A1E33744740546BF1F09EF332401DF4C0C7607747405B2357B1F8F13240513BA8C4757A47401ABDD364C6EF32408A6058FE7C7D4740BE1292CCEAF13240FC818769DF804740D88CD61874F23240537FC7F0D883474069C1E3A25AF03240601A0E4B03854740BC33CBF9BDEC3240AC258A35018647406B17AC38D5E2324046C4CBD3B98847405E5B717154DE3240B0A59718CB8E4740589EE8BAF0DB32400C5DACA8C194474097E666B801DF32409747E867EA994740F65EA9D326E33240B7D9F40C869C4740A28C2A8A57E53240028697E0D49D4740880D6CCEC1E7324013BAD573D2A14740A0A197512CE7324019843C821BA54740CDB62BBB60EC3240F1E84999D4A84740F2A8897780EF32407809DE9046AB474036F59C2D20F03240022126E142AE47400349DC63E9F33240C4104C35B3B047404A857C3C99F83240D7A8209AD4B14740F1818C800AFB32408A65DB696BB247402F07A359D902334097EF48BC3CB34740A0A57004A90833402EF529C764B54740FC816165D90A3340D7417EECE4B84740FE401B800D0C334023F8C77BD5BA4740E22B910BCE0C3340C680E84999BC47400B01341136083340DB6A6116DABF47406ADF1115AA0733409AAF8EE387C24740D85C0FA9B3083340D3A94885B1C34740B4B972F6CE0E3340565F4F8589CA4740BE2731CF4A123340C991E34EE9CE474040449C87131433406BDE240681CF4740FA98B67F6511334095BEDC2747D34740CAA7D898D7153340804E5DF92CDD474031BAC9A8321433400E4B0ED8D5DE47406879F69507113340952288F370E047403FF68F85E810334032B5C876BEE14740B954DFF94511334029250B98C0E34740D1B3B794F3FD324028E0B37570E64740A29A776341FD3240FE67244223E64740A70E859675F73240C0C47AA356E24740337020240BF03240CB63B48EAAE047404D858A71FEEA3240E4605AD427E14740340590A163E73240845EAE450BE24740311FE010AAE432402EE386DF4DE547406999CFB9DBDD3240C39EFEB3E6E5474022FD9979B6D8324060E08BB062E74740398F2441B8D03240D81430815BE74740A6CB54C1A8CA32403CCC40C0B5E747404C2AEBCB2DC63240BEDEA9807BE74740A4681B13BDC1324081CC3BF317E74740D5196FBFD7BF324074095D1D5BE64740391CEF22A7BC3240657D52EDD3E4474063B75D2F4DBD324097E6806E79E4474016FBF33460B63240AAC32DD5BBE24740B5BB0BB66CB232401B7A58A835E147405418D533CEB0324077BCF8A23DE04740F8B3931C0BAF3240B7F3B798FADF47404D4C9E1E80A93240788949B890DF474087A1CD27E1A03240201E9E25C8DF474009CBCE3692933240664ED944C1E04740435C6A73528C3240E77B15191DE14740EDEA4548388432403501344A97DF4740FD1D62CD127A32407D830CD3ADDF4740E3FC625BAB7632402C10D8309EE0474004F3A92A347232403B7C832F4CE04740BAD53384636C3240E2FEB5BC72DF47400C0BBD36705B3240C3DF6D999ADD474077A510B6DD57324056961C6B63E0474017428AF0E56A3240114D327216E247408645825FD96F3240544364ECDFE2474009194B0E8E7A3240499C20A0B1E24740894EB3F62D833240AD25851ED6E14740C012FAE307863240E1C9BFE0E4E1474086E2911DC08B324021AB9C514EE34740B6E59AA7DF96324075017C0107E34740663C68C06A9A3240DE1D9AC3FFE14740F08073EBDA9D3240D1BD6257A4E1474064539632BAA932405209B5954DE24740E30AB2AF86AF324081CE44227EE34740C70B118134B33240DD359B7DD4E44740DC6E826F9AB43240B7EE4284C9E54740F353A70359B73240EC4747286CE747408FDC1B4300BC32401CE76C01A1E9474097F37C72B9BE3240AF440BD0B6E947404279E008F7C532403C87BEBB95E94740B8853EFD0CCC32406BC4D0EAE4E9474099B53A00E2D23240B6E5BE8BADE947408FC2D63384D932401F7C9A9317E94740BA85D9C477D93240C86B9C5D13E947409A4DE78A52E63240FA41E8A04BE84740901B6CEA3CEA32403F114C35B3E647408A76DB85E6EA324035359F73B7E347401CED3191D2EC3240516C1CB116E347402E1688D7F5EF32402634FD12F1E24740F8DDC1887DF63240187B008BFCE64740BCCE22145BFD324040C0FF56B2E947408B75914259083340C18B9DF012EA474084FDA5457D1633406CE7818FC1E8474061C05DBD8A20334022E7F9D346E5474075531F813F243340E5EE073C30E24740653ACAFACD2433402AE87E4E41DE4740289E779CA22333405D6FDBF7A8D74740E4AD74779D2133401E5F27F565D347403042CCECF31C33401A42058717CE47406961D7ACE91A3340B558ACE122CD4740BB81DBDAC217334048F377EFA8CB4740D04E28339417334062D3C6116BCB474043B5B0A71D1633405CDC9C4A06CA4740503330F2B214334000ED7E7099C747408618200A6614334000124F7633C74740C2549B38B90F3340E9012269DCC247400F9D4C158C0E3340560290DAC4C14740C30417F2080E3340DF3EB48F15C0474055C4C859D81333405CA0F831E6BC474005F09FA7011333405E471CB281B84740748E7637AA123340BCD804734FB84740ACA77B9DD40F334072E7B985AEB64740732CD027F20C3340B2ECC6BB23B3474091C000FBE80433404C73A25D85B04740009F887E6DFD32400AF4E505D8AF474038A405E56CFC3240385F549CB4AF474004734DBA2DF93240C45BAFE941AF4740B5C420E9D3F6324086E464E256AD474049CA703C9FF53240992DCBD765AA4740C56B456282F23240A8EB6F09C0A7474070C493A46BEE32403907EC6AF2A44740947315527EEE3240F808E57D1CA14740CE89E6C8CAEB324027A19927D79C47408AB7483547E932409DA09163469B47404EED5D83BEE83240471A5245F19A47409CA603594FE532406247E00F3F994740B0367AFCDEE2324008BAE2E2A8944740163C4C3448E532406244183F8D8F4740D1CA0A45BAE73240ED6C1CB1168B4740CF6D30D461F5324035B34813EF8647405D1C8524B3FA3240A81C1CEC4D844740D7FA083543FA3240D235272F3281474094B57EFACFF632407894490D6D7E47406D8736C7B9F93240818EDFDBF4774740B3F2E15982F83240484ED0268773474067A50D87A5F5324006273273817147404626EA059FF232405B32E884D06F474020D0ED5EEEEF3240C0C0DB83106E4740635A0C5707F032405A1F5F4205694740FD597D2BC8F13240C60675914268474041CEB2EE1FF3324066B21875AD67474036B0F1608BF53240A12666BD186847406D17D57D5B033340F64B66BCAD5E47408900D6AA5D033340C5B5A2CD715E4740F85CE333D9073340DC7912D89C5B47400E22DBF97E063340E8EAE1CB4457474020AFA6EB89FE3240B7FCD13769544740B44BAE51C5F932405E8C2CF41C52474000910D6B2AF732408870AC8BDB504740FF887F1134F632409993F947DF504740B208D9B27CE53240265B70067F4F4740F200B34291E2324085486C770F4E4740FCFE3669BFE23240B736A1FFD44D47400F698CD651ED32409BF7EB4E774047407AF7E12021F232408D4912842B3C47405CB53BA418E83240CDEEE192E3324740604A4BD4C1F0324027DA23E538244740B8C8957A16F03240270D8E925723474038363AAE46F03240E56FC50FDF22474096794276DEEE324048662783A32047401C18FF3EE3EE32402662FA5E431C47408367882AFCF1324017922232AC1847403332F5BA45EC3240CBF48079C8144740E84F08E412EB3240867E1CCD91134740D3DAAB8F87DE3240F39AAF928F13474009C78D6CF8DD32400475835781134740BC6AF12093DD3240FF305368831347405A4F172994DD32406CEFB25F77134740FE8EEC4ACBDC324096F711BF621347405165696E85BC3240BFA5C4AEED0347409C038C67D0B4324057C54FE3DE0247409A77FD82DDB43240F293ED43DE0047409E871057CED2324084DAC2F352F54640CA5F350296D532409D1CEA1CA8F44640437ADC1214D432407E12E2CAD9F34640E743C362D4D33240486001A7D2F34640041B42959AD33240F7E9A9C42BF44640FBD833DF1CD33240DCBAF55091F44640596F9B4E57D23240BC09ADF314F54640EB998B1AA7CE3240D63B9AD99DF346400094DD38CECE32403AC5A0B888F346409585BC9B5DCD3240CBA463BD07F34640B13A3DB665AC324012F23FF9BBFF46403A75DB3B59AC32404C65D65240034740 |
1fe3b378544a
Added handcrafted responsibility areas and matching stretches.
Sascha Wilde <wilde@intevation.de>
parents:
3394
diff
changeset
|
30 SK 0106000020E6100000010000000103000000010000007B000000AC158524B30E3140FA3EA3193012484027321B2B310D3140A401BFFC041448408C1D9F4610153140ECF5087FD01348403134CF4A5A1B31405FF47B07E41248401CD9B210782331409A136B4CE3124840C12977B00F283140A3DD27A2BA1248404947AC7B1A2A3140390BFFD8DA10484051D1E9E51C2B31406C6745798B0E4840094FB2C4B9283140BE7046DE830D4840DCB8DFA1282C31405F8CD0BEA80948405996373DDE3431403F151340D6084840B3B974EED13A314016A5D535FF0748408294C899814131407B917BBABA06484016C316BB7D42314094701706D10448402FC3F572E94F31409D4548934102484034A01441F7583140018C7B9862014840F65B8DB3E95E31402D0EE7751F0048401D93E634B0623140E0495D328EFF474012E3B9ADE3843140AD2E90A0F8F44740C27B69519F8C31400971A4D876F24740E756DB4DF08F314032276431FBEF47400B78D65D8F9E3140BE301FB52EEA4740175B09FF7DAB3140016D4C3E2CE6474019903A4BDAAE3140C464E54D34E64740E895CB7F48B131400D5EA80D98E5474055BB78AB53B631408E87D4B48BE34740A42649D74CBA314035B6DAC35EE247409D715EF7B1BF3140261B3AE235E14740CF7CD360BFC431404CC55455C3E04740AB6CF7729FC6314080157C2EAEE0474060D14DF62ACB3140E7635BABE2E047400D9B899FB5CD3140EEFBFC9C27E04740AD0B044BBFD031404026D6A9F2DF474054D5318C60D431408BFA0681F0DF4740CBC1D2C08FDC3140C598006839E04740469CBFE72CE43140E1C8D644B0DF474079FB4FA335EB31401D302306CBE04740A25C43A9BDFA31403806D2C5A6E14740271CD2CA18FE31408E2FEC1FFAE047400AC63AE9D8003240C3639A9FD1E0474049B4802B3403324083676AC82EE1474070649588A60A32408D3242D36DE2474088CD2C095015324061A92FF081E247408A3CDBC58F263240B5F4E967A0E1474040550B47EB293240DD38F64773E04740A8A8B24A442D32403D624B4519E04740481612691B3132403032F8FBC5DF47409A11D8D5E43B32400CC853FB19E047400EFC1274C5463240FC31DF6696DF47406D16F6C5EF4B3240B2B0D82615DF474052D0D8976C5232406F75E107E7DF474077A510B6DD57324056961C6B63E047400C0BBD36705B3240C3DF6D999ADD4740B4076C8434553240356258B4EFDC474034BE29519B453240691CC6EE4CDC4740316451C71941324049EEC62709DD47407A6FEC8FE630324095DBC36F54DD474052297AE063163240AF35A44055DF4740E2BEA15CBF093240D9656B7D91DF474083344690EF073240054C4E9253DF4740BDE76D7DA20232402F9738A8B3DE4740E6A299492F013240A00FEDBEBEDE47406BA19D1DBA0032402E11ADBAB3DE47405292B0B9B4FF3140199B0D9EAEDE4740F9C7D81A5BFF3140BE689A0BB7DE47406684ED71F0FE3140133C97F3D6DE474047F3DEAC1CF93140FAC5C37B0EDF4740181CCF786CF331407D43EE3378DE474060F686A00FE73140FAFD1DF6E7DD4740854D266E15E231408B8FD442C9DD47403F3CE34570DD3140EE64ED0099DD474041E2787764DC3140D18EDF2582DD47407F7E8B9823D93140DC012AC187DD47402FC3B68F26D831403A0341DBC5DD474017FE37AC5FD53140099BF46338DE4740B01B9E149CD43140C20B99863CDE4740FC6C70D86CD331401D3587B542DE4740F8A097D41AD231400B2C33B621DE4740EFC721D1BACE31408A4E6738AFDE4740906EA9A514C93140BA1D53D21EDE474092BD58CE94C4314036588BF447DE4740E60F337E2BC1314033FCF8A644DF474014F1EF8EE7B83140B38D691261DF47400DD021CBDDB63140F78D5940B2DF47400C431E1C47B5314058471273FFDF47401C1F4D17BDB43140A11D8CD827E047408019AF1E9CB2314090354E9E0DE147406BA18092A7B13140311ABC0A84E1474057242F21D5B03140820862EAF8E147401FF331699DB03140D1075B913DE2474081451FF301AD3140A719272AC0E24740E47ACA8C12AB31405DB5C71C15E34740C0CF36267AA93140C157800063E34740E8DEED30DCA73140287DD179E8E34740EDE3F54F26A0314027560E886BE44740E8B80ACE859C31408001B672E5E44740215EE74B149C3140355842D202E547403B1BA8531E9B3140F6DF5916A7E54740CA72465B959A31408B5A40683DE647403E592140E1993140B478A1CA7AE64740056C65E487973140E07076210CE8474009C66427729731400334F0A31AE84740B8687FEA699331402E64A1421AEA4740BB06C078068D3140273CD285FDEC47405D83CD001784314068D5BF907AF04740FE3E32891F7E3140A183A570F3F247404458F87D4972314048C5A75BD1F64740E075ECB13E5F3140B45674907CFC47406A3B1680EB59314028CCE78134FD474088590F4EFA4F3140D28B6A1151FE47404392FA6827453140B09A035F2CFE47401F444A69EC33314009E51B1BCB0348401A977B8159313140344AF95AE10448409F0CF38A4C2B314097B8EDD68D0648402B05961238223140CF5018EF220A4840C7D1927D46203140FAEC8046440C48404588F23E8E20314035E8A4F78D0E484037D64D3ADB213140AEF8BB1C1B104840839E0AA7BB213140424106E1C0104840C5D4ED258D1B31402BDD0D58281148404C5C9E077717314035D3872EA80F4840BE8A916F0011314048FFB1B5630F4840AC158524B30E3140FA3EA31930124840 |
1fe3b378544a
Added handcrafted responsibility areas and matching stretches.
Sascha Wilde <wilde@intevation.de>
parents:
3394
diff
changeset
|
31 AT 0106000020E6100000010000000103000000010000007000000038CCAFF72C192D4064C625D8C91F48404D11C550F32E2D4035A50705A51E48402434C61BF44C2D40818048BF7D184840BE00254FA35A2D40179249FC4017484051785B3343A82D407333C346591A48400A6466D828AB2D40155CA049071B4840379B1D9892AB2D40521577BCC91D48400960B13CFEB92D406A3A003D681F48403A03D58915EB2D40C5B5B9313D1F4840472063FF86F62D403942D1E1C61B4840AB18D11B93262E401685AC133C1B48402A0817D9022F2E40466E8283141A48404C82244795482E407E485C6CFF1D484042CEB216558D2E404533BDC4581F4840AA677C5F5CBA2E407905F29139244840111F59D70DC42E40CB8399000D2F4840D10EEB49AAF82E40C2D58E2CAA364840EC0BCAA65C3D2F40CBF2572316364840607F52488DC82F405FC9DAF005364840038B34BE8AEF2F40E16B984638304840AB04AFF1F4193040677AA5D18930484002D80940ED293040EF6DC1525D3248408929F64D50393040ADC9900832324840C5380ECD864C30409BEC4F87BA304840B269E9C028573040722405604D2D4840EEA86840185D304043BBB612152948401B28885F566B3040B3B2B15C801F4840DC67AC58578230407DCE89986D1748402DD451E6309D3040F514720058134840098225FCF7BD3040A768273916134840D2C72D0840DB30404678561C181348406A10C17119E130406B60BD512B174840389807C1F4EF3040EF8ADEA980194840539814C4E5EF3040AD727E2F2A1D4840DE39331C2AF73040D7BA3B212A1D4840431202F22500314075FBE362B116484027321B2B310D3140A401BFFC04144840BE8A916F0011314048FFB1B5630F48403E0734B67C0B3140BCDB89ED490E4840B459D00F7EF93040984F7AF024114840F9713C0BE7E13040E421ED35F30B48400AC0C7F4DFBA3040D72D15C0390C4840A5F9F818079A3040F240F8AB5B0D484064A45247228730407CD8C68E7C0F484053A8260BA97430409E61ADEB61124840ECA033B3E05730402A19F8F6531A4840F53604E9BD483040B0F2D24D622648404E2A617EB83D30402275B5CB6D2848407CD8E044F4193040FEA53627E52748406C65A2E073F12F4099794375CE274840675023BBD2AE2F40DA02DC3D8A2D48400FEC32DA4F772F406A0C0929892D4840939B8CA7D43F2F406E923F7331304840EF81BD8921FD2E40B9AE986C972E48400FB918366FE52E4033685B72812B48402257C19778DE2E4096EA04D95724484057A2A5530DD12E4018E06E490E2148403E0B7DFA19A42E401CE66E7C921A4840BC242BF86D742E40A53A05AF4C194840D80ACFCEB34B2E40EEEB212B091948401EA57713D7482E40EDEE65474F1548403FA28526E43A2E4098CEEEDAEF13484008700305DE292E40F8EAF81EE4134840F81360FD441A2E409B8E8653E6164840C469B72407182E406026497C93164840EBE5396C6CE82D4030995DF7561748407247300851DB2D405B134BDB091B484056990B3AC6C22D40AA8A0C61EB1A4840E66AD630E8BD2D408BE5C589AF174840F7D4D545C0632D407C6C2FFDA61248408ACF4CF73A3D2D404689A2AC841448405702810129122D400144381C4C1A4840188C5DC4D2CF2C40869EB8D2211D484054BF85D09CAC2C408CA167B3EA1D4840413FF0BF95982C40A4C1CAB271204840D443CD7921902C407C4B647A1D25484056E31C97CC6C2C40ACDA780B7F2548401228605D70392C404E71546EA22448407C004C052A352C4072286F1FE52548406D3982F3F3242C405E7E7D19312648408D0F38A682FD2B407642C5387F2A4840914F00DCD1002C4023E360CA1B2F48400A1B6F5E41EB2B40C519D5E9403248402088CBF10AD82B40498139C489314840EFEBC28CDFBE2B4028C4F1D7BF334840FC37AF230E892B4042BE4E45853A4840CF7E4B5BB76C2B40C6E05F4E1A3F48402C111A8FAF6E2B4023F2E70E393F4840B5CB0CA9A2402B4024B7E9190C4348406CD52181500C2B403EFE8062BF4748408F63FEF08E0C2B4080DD7619CF49484085E59DF1DBDB2A40578D11F21B4C4840290561DADCDD2A4084CBBF4CCA4C484020ACB118D0162B40FFD3C622974C4840639956D11F4A2B402FC2621E43484840F74B32DEFB7C2B40FC09F4D3C9434840D299D906C47A2B401487A18D14434840E13F975FBC852B40E763A6B4FE424840EC5C273974872B40D3188ABCBB404840A0030C6872B52B40C9CFE648353A484095B557B329BE2B40237C336ABE3B48400051907758E22B409B89FC9F683C48407A8492B87DE92B40150F0753DE374840D8070EC3A2012C40E016CDB9CA3748404B2C06FEA61A2C407152572D9F304840FE97572BC9182C404395A13BD22D4840C2EC284B633E2C4070021F285C2A4840831CC32ADE642C40D03558DD8F2C48403C6688E64B992C4023E184F8762B484060C0D4BE6FB22C4000B51666A1294840237723A93BBD2C40330355489E24484038CCAFF72C192D4064C625D8C91F4840 |
1fe3b378544a
Added handcrafted responsibility areas and matching stretches.
Sascha Wilde <wilde@intevation.de>
parents:
3394
diff
changeset
|
32 HR 0106000020E6100000010000000103000000010000004C0000007C884A5CED6933408030B0A6EB9F4640A399029F2D6A334039693E1EE69B46404D6EE45F70523340069A53138E9B464032D53E671C403340CB219EDB3A9D46409F8C4061F5343340F3A69828E79E4640C3646E9CB91C33407719BB44F5A24640FF46814FBD1933408CE84482A9A3464032C519B270143340EE08EAEF00A64640CB41F2182F113340B277DCF0BBA846403D2D503008FF32400676BB5E9AAA4640DE56DEFA55F53240F85AA038DBAD4640494542B687F032403853ECC3D5B14640BF0CAC996BF53240CE14C49B90B44640BF3D9FB767F83240A06BFBB20FB84640788FBE38A7F6324022E1DEA1CDC04640CFA51EB3FD0B3340E21ACDDB22C1464057C84D68ED133340BAEE37DA71C1464005980D7C56033340145B6622B6C34640360F9DF930FC324011910A630BC346400AA53193A8F33240D4C6116BF1C14640B66A1679A3E8324005FFA5FBEFC34640E8664BFB8BDB32407132BE2F2EC74640A1D082F524E132400F40BE2951CD464099F62098FEE232409D3C95D39ED0464069FEE9060AEC3240FF2468DD50D44640AA55B6FE4CEB324017C469D2B7D54640491A7C9A93E53240674DD7135DD746405AA3C28EB5E13240054496163FDA46409481EE5FB4E03240C369F7AB00DB4640CF5D64027EDF3240A654BCDB06DF4640936D664F5DDE32403C7DCE3868E146409B0AE9F010D832408F4FF454E2E24640B40C9EF820D43240D60A372A81E546408CD932CF00D3324021F145C549EC46406C0664F904D032409406F41D57ED4640D9EE083B20CA324017F4328AE5F146400094DD38CECE32403AC5A0B888F34640EB998B1AA7CE3240D63B9AD99DF34640596F9B4E57D23240BC09ADF314F54640FBD833DF1CD33240DCBAF55091F44640041B42959AD33240F7E9A9C42BF44640E743C362D4D33240486001A7D2F34640437ADC1214D432407E12E2CAD9F34640A906259353D73240EE3D624F96F54640CB128CEF30DC3240C4B7489000F1464070A4DD5449DF32402A394206F2ED46402A99A0979BDF32409D9A155113EC464061392CC36EE432404B358012FAE5464082272E8ECAE9324004F50192FAE1464057822B346BEE324003A8902BF5DB4640591C37A1B5FF324059DBF9D923D746401A8C190346FE3240E4864E2A75D3464060AB2E85ACF532407B3274A213D1464073A62CC02DEC32408757169689C94640F73CE60302F932408E85BB0E30C7464084D7193AD1FB3240CFB79388F0C846409F806973F70233401F1A434AFDC846401AE064F95F0B3340F0B997A02BC84640BE56A5F44C173340B1E8BC7CA1C54640802F575062193340810C93043CC4464079CF6A26841D33405E1293814DC346403387E7C7BA1D3340DEAD923424BF4640D26C4D98D5163340560A51CFCCBC46405C832760E0043340D31ABC653DBD4640B20DDEFC2B0633409BE85C514ABA46403E882DA97F0B3340DC023054B4B44640B86830B209093340B2F830C566B24640FDBF7AEDE30033401E59C345EEB04640CF8352D6CA09334092A433D538AF46402B7C0239721A3340DBF875960FAD464040D79E0F85233340687AFF1F27A74640C2316EED8E3A33406A7DAF7CF1A246400B0EE7F2304833406ADC3D40F7A046403B09AB56CB5433403BB06CD564A04640913D80FBF0623340958A99D8D79F46407C884A5CED6933408030B0A6EB9F4640 |
1fe3b378544a
Added handcrafted responsibility areas and matching stretches.
Sascha Wilde <wilde@intevation.de>
parents:
3394
diff
changeset
|
33 BG 0106000020E610000001000000010300000002000000FC000000A8B02017E6E03B40ED669082A75446409379512745F43B406B57009D93544640A5D416E824F33B403DB11C21033246409B65B7F124F33B4054D47416152F4640EF743C2D3F043C4017F26F97FD2E4640F9E1EE737C043C40A5FA7DFFE63546402ADA9EFE58113C40E639A3F7D7354640B84B943AB7113C40DC69E624EF3F4640FFE9F10FB6113C4080CDD94CCF3F46400C3B8CB564FE3B4003A986A2E53F4640D41F4F26C9FE3B400C85752D6B4B4640F8EE7D271CFA3B4087B15758704B464096FA3F3D6CFA3B40A67AF1EAC154464030EC1C5E6BFA3B4092EE7CF5A754464006AAF1C121DA3B40DFE70313C9544640383B88AE55DA3B404944FDD3B25B4640A65BF93DFBC93B40F50133DFC15B464072680586ACCA3B403BD13DEB1A754640E0B02AB121DE3B4058570DD3087546404FBB9BE09BDE3B40263FE76ED7844640940A5A48C0E43B40E007D15AD1844640401F904B1CE53B409FBB41B456904640A9A5BA18AEEE3B40ED93ACDF4C904640BAC0BD326FEF3B406DE1C56757A746405B12770657FA3B4099B6B7B64BA74640DBD5F5B0BCFA3B4080C8A1D9D0B2464061F4BF6DB7023C40BCF71FF4C7B24640526CFC9AF6023C40BA386865B1B94640E6555826B2233C4001EB85F189B94640182037B2E1233C407047478325BE4640BD31D65988373C404F7AA98E0BBE46402F353C6299373C406D4D35B396BF46407189AF1B5B583C408F030AAB67BF4640D7BA1A457B573C407EF0BC9EF9AC464024B6F270A7673C40E14F3DD2E0AC46408A48212466673C40CB69458AB7A74640071D41CF0B883C405FDA430C85A7464048446667D1873C402F1518FC47A346408570295371A83C406A6C3EAE0DA346409EF4614040A83C4089392971C29F4640074E7A956BDC3C40648E49905B9F4640AFED545458DC3C400BADA8C1349E464057DF2D35E7EF3C400034411E0B9E46408B9038BFBCEF3C40E05287269A9B46401E91F9FD51103D40014B9C15519B46401AEF2A4943103D40F4D2109F859A464036FB3905F9713D4067AECFE682994640DAFDEC9117B33D40F36C3E09C798464064653EB4EAB23D404A658FABEC9646407CE7C2ED75D33D40DFB722D687964640551EA32BC7D23D40DFD0B52FA08F464013A8ACC843B23D40AC167BD404904640A2DA7A8670B23D40825EAE34DF9146406582ECAB61713D40E609D0B69A9246400CE2386F49233D40523738BA62934640A1E456ADF1223D401FC37F5FC88E4640C92F63D174363D40DA61F888988E46408F6AD0A4D5353D4046EE4975898646405EE1B06D51563D40C646088F36864640A5648412C1553D40D5C4419D4D7F46400A62A54929903D40BFC090D5AD7E4640CD0252AC648F3D408571709F0B764640FE2C3A92CBAF3D4011471B47AC7546400295A46B26AF3D407477B471C46E4640DCFEAD64C78E3D40650BAB78236F464000E6CBC1228F3D406409E3022B73464044A1C2D842683D400A5474249773464018FA2955A2683D403D78F52A3278464049E1B8533A483D407677F35487784640FAB9A0F7C6483D40017472D06F7F46406C60EAE74D353D40346C09F9A07F4640952B206A91353D401278431A15834640CD754F1E16223D407487299144834640B0261AEE6D223D409D2F478FDF8746401C6102B7EE0E3D402D4D546F0D88464008EC7ECB520F3D40938599B67F8D4640A709A14ACDEE3C4029364F75C88D4640366D804B1FEF3C409686FA25879246408C410E4A98DB3C409217D3A7B092464072B0B673ABDB3C40337B2178D7934640FFD9F35723C83C40FC165B52FF9346409DA816EF6CC83C407ED9CE9C9A984640A0385A7AD9A73C4071433866D9984640F84D9C700AA83C4004F5FAA4249C464036AB256772873C4019ADFCD75E9C4640879661A3AC873C4014F3D5E99BA04640D5422D060F673C40E2F16F86D1A046409354C90050673C4070B0D69AF7A54640394826CFAB463C40DA795B9F28A64640D17F7C75FA463C4041117DE310AD46409C11BED5DF433C40E6798D1315AD464004AE57DB5E443C40769406239BB84640CE2C2D454D373C4017772865ADB84640DD701FA809373C407B080DB386B24640003175C35B0E3C408B320D79BAB246405BE7E225EE0D3C4051D8C06735A7464065EA42739D163C4057480C022BA746403F2C73BA2C163C405BF953E3A59B464025C825C79D023C40F3855AD3BC9B464039CEF38535023C40CAF667AB37904640CF290AD7A3F83B40708D254A42904640E91090F63FF83B40EAAC7D01BD84464027C91F971BF23B40A5AC667EC3844640019E59A6BAF13B406530293E3E794640B742B10408F13B40F3568A2EB96D46401752A4C2D8023C401C8C62B9A56D4640BC59F754A6023C40849BD8530068464060D2B359F5113C403AAB09A2EE674640982EA7CB62123C4045D3A41474734640DC70F5F146163C40AE25D53A6F734640D692A46B26173C40ADC1ADBB798A4640BCC02E8350203C40A5AD40306E8A46409A4F378941203C40FB79AA436E8A46400C2A0C88B5203C4000C2024DF39546408BA796ADF5153C40EE16B7D100964640B165666666163C40A16A6FF085A14640EAD85548F9293C4005AEFA5C6DA14640660642B280293C40CD5A423EE8954640AAC48E8D40343C407F8E45D3D9954640179A9EB0C4333C40A6107008558A464076A2648FA92A3C40712763CE608A4640D93F355EBA293C400B89E59656734640758FEDDCD6253C4029575E805B734640F38C149161253C400CC37762D66746406D88B1D911163C402E048C7FE9674640CD8311C2A3153C407EF62345645C464099DDF4673F023C40EE832A357B5C4640FFB6E86963023C40FEB95B6683604640A406462575EA3B40D28151499D604640D8B01EBE4CEA3B40E026F801A35B4640DEAEFDF8A6FA3B409C50AFA5915B46409986EE377FFA3B406F0EE3DAF55646406D0685E6DF0D3C4014557BC7DF56464031C6D22C750D3C40CFA98D565A4B46406479E51F22123C4019F22AC6544B4640961D2A9EC4113C40AE19DC7B5D414640F05BAAD216253C402852EA81454146407DC113B35E243C404306465ED62E464071E313A1C7143C4088FA2F7CE92E4640DB272B1AC6143C40E382AD6DE52746405AE99C33FD353C40CDFC6FDBAD274640BD0818B897353C40CA685A07AC234640B17848AE51553C40FBA91F402B23464002276C787A553C40E28B37328F244640CF309886E17B3C400C67C22FF52346400837BF9A037C3C40D9708FA50F2546403043AD69DE993C40E0745E63972446402673D8B6289B3C401D7EE882FA2E4640B2D46531B1A93C40AE68C18BBE2E4640ED9747FE60A83C407B351AC05B24464009F44B0EE99D3C40B33E58C6862446400D8C16670C9D3C406EAD4C9DEC1E46403868B7E0567B3C4079E8A969721F464013EEDF617F7A3C40A7F0E9567418464056E3BC38F1793C405D67EB85A7114640950B9964E4A43C400652EDD3F1104640864E546F0DA43C406DDB114E0B0A4640A56FE6DA61853C40A2BE8E49900A4640AAC13E3A75653C4011AF122C0E0B464030EE2A4943663C40F64671E9F311464042D22C09505B3C40EE3459A31E124640452069CB145C3C4045CD9E5FEF184640DD8FC2F528543C401B6B3EAE0D19464083EE659E89543C406ABD8038591C4640C6B10D15E3343C40A1E4A59BC41C464062171F8522353C407F2D9BA1021F46400FA270B354093C4089E5D54D291F4640B2F174BF54093C40B3DCFAFA6B1C4640679FD43CECEE3B4057C83E236C1C464004D2B5D4E6EE3B4053C28256BB1B4640961075690DCF3B404E040F67D91B4640DD06D5720CCF3B40CB3668AF3E174640142DD96784BB3B403E7936AB3E1746405DCF142983BB3B406AA3B44824154640E3D9E209739B3B4055FC7CA53D154640D2FE78AF5A9B3B40F9F85DD89A10464048944AE427883B40535D0718A71046409FEBB53412883B40A66F1E98ED0B464027063763E2743B408558AD4CF80B46406E26E620E8543B40A0FE690F200C46405FC4CCE3D54A3B40B8E87CC2230C4640DB95486936473B407AECD45C6E0C46401F46111956453B40202C2AE2740C4640C96BCD1DFD3B3B4018D889CBF10A4640074212F6ED343B40FA789E78CE0A46402652F014722D3B40D0EBC4E5780B46403D66300DC3273B4093D77C5C1B0C4640AFA997DF691E3B40F462342BDB0D46402615CFA0A1033B40C55DF92CCF0D4640ADF24E88CAE03A407F9A6B98A10A464073616AF063C73A404D8B50B692054640516C0D00B0A53A40E2F13680C80446401464BC9CC86A3A40C43BCC03FD004640E3128E7B4E4F3A40B41033FB3CFD4540FFC3F7205F293A4076B4AED172F64540F7C5A145B61B3A401ACA738E4BF04540B0B2ED4850073A404275931804ED4540FD4560E5D0FA3940B224004922E9454084D26A0F7BEF394031066CBD95E2454094571AF851EB394022D28D0B62E14540DA8D62145FCC3940CBEE21E17BD645401E171A4F049F3940CC802E1A32D04540092A7E8CB98B3940A1272D12C9CC454064D4F6651F7A39400EC7E5D3BECA4540DB6DFF363070394012AF4F94DFCB4540869BB07A76633940869DD5B8EDCA45408E4AC33A9F4B3940A4D1F4238FCD454033233658382F39404C49F08634CE454041C01DB97F18394081EC3378A9D1454021FB3779DBFC38403B4B040539D74540D13493DB9BEE3840BEB8324D7DD745403307E1D1C6BB3840ECF008B831D4454014D6A93CCBBB384022231521D0D6454076EFAE7AC0BC38402878C02B38D84540144D54B99ABC3840312C921BEADE4540C0EAFA6074EE38405F702AAD1AE14540A23B47E4BBFE3840E8C5DA8420E14540445401309E193940C196FAC3E0DD4540101FFDD41D303940497B69E5B9DD45402B3E2619394D3940058B91369FD945402319434AFD62394004F3BA3434D54540A91CAA622A6F3940E64C9F7829D54540092A7E8CB98B39404AC59EE2DDD745400FAEE7A4F79D3940A7F98A6EBDDA4540A1B437BF61CA3940A6160F4AF3E2454004D48BA19CE83940DC1F7AF76CEF454085335E4E64FF394036E16F7B82F745400AD97E32C6193A4063AB2281ABFE454076868EE4F2273A40BA315981C600464051A3F06D554D3A40C53386EFB3064640D1531CCEFC6A3A40D4FB6662BA09464015DEF5775BA63A4015F50071B20D4640F2A718AE0EC63A40D543227E0F1046406A47205ED7DF3A40AC7E34417915464059A215623F033B40BE9C96C4FE154640AFB0A9BA471E3B40AD643909A51546406D79A38FF9343B4051373FFED2124640DF0F0C207C443B4084D98CD3101346404D85D4377A443B40898E96B9AF144640F5871A9650453B40F093302EB01446407470C9CC60453B401ECBA0359A1B4640D737C43F6C653B40C1C4C03A8E1B46401851C52176653B404C3FCCB96F1E4640E39EB98784853B40B931444E5F1E4640428107CDAE853B40C2D86DABB42746405AEADE9BF0983B40875F6397A827464058E28B5132AC3B400BB645E39A274640F9453E9E4CAC3B40A05E5C4F192C4640CADFED7A69CC3B4032D786D4FE2B4640A75FE795A1CC3B4059B4029E0F34464077E03B31EBDF3B404CFDA886FD334640A8B02017E6E03B40ED669082A754464005000000B2E16F20C9DD3B4002B60E5883694640EC5D37A5BCEA3B4005EAB7657669464019BC2F4FDFEA3B40129D1C77BF6D46406FF3EB04EADD3B401CADE28DCC6D4640B2E16F20C9DD3B4002B60E5883694640 |
1fe3b378544a
Added handcrafted responsibility areas and matching stretches.
Sascha Wilde <wilde@intevation.de>
parents:
3394
diff
changeset
|
34 RS 0106000020E61000000100000001030000000100000005010000FD0AC913523E3340F7330FAA1E6C46409D201D1EC2203340507896C5696A4640F09801C2E2053340F7033C69E1674640FDD18CFB45033340DB562BC9F0784640DD530E1C861933403F2A4B74967C4640213FA9F6E93C3340FFCE7D39B37F4640B02FD05A76553340B624039BCE814640C96A88CF427F3340E03C3DA539864640477A083E61A63340B2C0B3983383464034CBFB5AF2D33340FE42B11534754640DBEF748CD0D63340FF997631CD69464073384A97FEE733406469B290CA624640AB8DCD55F30434400C1E296C50634640E2CFD20440253440D22C4E6B89614640829AA07543413440413342E49962464083E9418BB65234402CB06E6182664640CEC75098415C3440408D4BB093684640E4D63F4F03603440EF3311363C6C46402E89659F6C5D3440505F36A6CC6C46407DB8195D945934405DDA9601676D464002A17433ED4834407108037404764640A9E44746184434409DD46542DD7B4640B2BA627FD943344094A393A5D67D4640F23DA1AF6A4434405B78D2C265804640ACA927E2634A34401F1C3F9EA78146400030396BA64F34401EC8444AB3814640715279E008553440EDB5FBB0398346408C8DF62E94503440314284C99E884640757851F4C04934400B5E46B1DC8946400C0E2769FE443440AC0E11ED198D4640F86A5B00BF433440B6F598A3228F4640E134AD14022F34405EF3CCDC8D9446404C19DB5A15133440C49B994F0C9446405168A1BF2B0334405CDC088B8A934640EC445F7AFBF33340BFC900F50B9646406DB5CE5378F13340C93F9468C996464064B26E17F5EC3340E8A9459FEA97464014D146BFC7E23340331F662FDB9D4640EA5CDEC1F4DC334072BACB8F099C4640E80445F300D23340982F7F85CC9A464017AA531EDDB833409DF14C68929A4640C9D17AE7069D3340BB2AE395DA99464015BA642D4F8F3340FCEEDC7BB89946401E085669E68A33402852C7BEBF9B4640CF2CC48FD687334002F7C841649D464094A0F9E648703340235C0BC4FC9B46404D6EE45F70523340069A53138E9B464032D53E671C403340CB219EDB3A9D46409F8C4061F5343340F3A69828E79E4640C3646E9CB91C33407719BB44F5A24640FF46814FBD1933408CE84482A9A3464032C519B270143340EE08EAEF00A64640CB41F2182F113340B277DCF0BBA846403D2D503008FF32400676BB5E9AAA4640DE56DEFA55F53240F85AA038DBAD4640494542B687F032403853ECC3D5B14640BF0CAC996BF53240CE14C49B90B44640BF3D9FB767F83240A06BFBB20FB84640788FBE38A7F6324022E1DEA1CDC04640CFA51EB3FD0B3340E21ACDDB22C1464057C84D68ED133340BAEE37DA71C1464005980D7C56033340145B6622B6C34640360F9DF930FC324011910A630BC346400AA53193A8F33240D4C6116BF1C14640B66A1679A3E8324005FFA5FBEFC34640E8664BFB8BDB32407132BE2F2EC74640A1D082F524E132400F40BE2951CD464099F62098FEE232409D3C95D39ED0464069FEE9060AEC3240FF2468DD50D44640AA55B6FE4CEB324017C469D2B7D54640491A7C9A93E53240674DD7135DD746405AA3C28EB5E13240054496163FDA46409481EE5FB4E03240C369F7AB00DB4640CF5D64027EDF3240A654BCDB06DF4640936D664F5DDE32403C7DCE3868E146409B0AE9F010D832408F4FF454E2E24640B40C9EF820D43240D60A372A81E546408CD932CF00D3324021F145C549EC46406C0664F904D032409406F41D57ED4640D9EE083B20CA324017F4328AE5F146400094DD38CECE32403AC5A0B888F34640EB998B1AA7CE3240D63B9AD99DF34640596F9B4E57D23240BC09ADF314F54640FBD833DF1CD33240DCBAF55091F44640041B42959AD33240F7E9A9C42BF44640E743C362D4D33240486001A7D2F34640437ADC1214D432407E12E2CAD9F34640A906259353D73240EE3D624F96F54640CB128CEF30DC3240C4B7489000F1464070A4DD5449DF32402A394206F2ED46402A99A0979BDF32409D9A155113EC464061392CC36EE432404B358012FAE5464082272E8ECAE9324004F50192FAE1464057822B346BEE324003A8902BF5DB4640591C37A1B5FF324059DBF9D923D746401A8C190346FE3240E4864E2A75D3464060AB2E85ACF532407B3274A213D1464073A62CC02DEC32408757169689C94640F73CE60302F932408E85BB0E30C7464084D7193AD1FB3240CFB79388F0C846409F806973F70233401F1A434AFDC846401AE064F95F0B3340F0B997A02BC84640BE56A5F44C173340B1E8BC7CA1C54640802F575062193340810C93043CC4464079CF6A26841D33405E1293814DC346403387E7C7BA1D3340DEAD923424BF4640D26C4D98D5163340560A51CFCCBC46405C832760E0043340D31ABC653DBD4640B20DDEFC2B0633409BE85C514ABA46403E882DA97F0B3340DC023054B4B44640B86830B209093340B2F830C566B24640FDBF7AEDE30033401E59C345EEB04640CF8352D6CA09334092A433D538AF46402B7C0239721A3340DBF875960FAD464040D79E0F85233340687AFF1F27A74640C2316EED8E3A33406A7DAF7CF1A246400B0EE7F2304833406ADC3D40F7A046403B09AB56CB5433403BB06CD564A04640913D80FBF0623340958A99D8D79F4640325D634D1B6E334077BEFE7FF79F4640C2C3E86FF883334017ED331DF0A14640B05C5095A58C3340BC1785B8CDA14640A1B8B6A62F923340BCB181CF6AA04640C9CE1F1D6899334059794265B29D46407DE297665FA633409BA3F77C839E464005906BE80BB23340FBE1804C219F4640082A9EFD92BA3340669F96D52A9F4640CB6A156987D43340BCC7E1DDDB9F4640FA6560E465CF3340911299034EA44640BA00A9E1B6DD3340A545937A05A44640A28C4358E8EA33409551D037B3A24640922CEBC550EE3340B6E91A2D07A14640694602EBDDFC3340FD74D602D69A46401E5B5D98960634407C1AE3C3EC9746408B8B0354DD123440768E9AC0BE974640A97391312D3234408550B17B3C9A4640824B7F07502F34407F1ECBCC169F464063044697371F344068F7B3588AB44640C3C63B8732FC3340DE06E92972C646405810047E43FF3340AB0DEDF71FD34640E1EA1C03B20F34405DB69C4B71E146408DD3807A330A34401B17A58460F3464054B03E1EFA023440A038D73043054740D6779BA333FF3340A525A314BE1647401EC208E1D1283440A525A314BE16474048A65945242934405EDB1A22B8FF464045735078BF2A3440FE553F259DF446401393313ECC3234400E20B58993E14640D6E49C11A5313440A6723271ABD2464093F72BF8C8233440F0E5B3F281C64640437A84D382473440D4768F6CAEB44640568EFFC9DF513440FC3C2B69C5A3464007821A74F8583440F9892A57D38B464008A2D755375F3440EEACA12F188846408053A8DA13633440DED154AA9F83464021C07BFDFF5E3440654DD477238046408ACF3F9F6D503440F194C217817C4640DFED84B938533440EAD339F537794640B84DB3ACA056344026AAAE32097946403C2F1785B86734406AD9B7A4B47046405994D7118782344091EEB787CE6E4640769F5D52109F344058E3897B877046407A0F8F30B1AC3440D2F9287EE76D46402599B0694AA73440023D343D72664640639FB525BCA83440766A914836634640A928C8CF46B6344075658412C15C46406CAD0E14D3BC344006A5D6FB8D59464056853D2652C63440E8BCF0EFD85646403C0E36F22FD0344074DD61C90B56464014220791B1DD34406861B197B7564640857686E28EE934401AEFE824005946406163D8CD31FB34408D379435455D46406045EC134009354035AB9564785E464011B85807F6163540F1A0B140055F464082275B24ED22354053D9D7BAD46046402C0EE93A9E2A354015C41A78FF63464094151BC9A43E35408737408422694640F4C5A1C8A43E35406C942E47D96B4640F5123DACFF5C3540714D1652D96B4640189E0A4C025D354019347D76C06D4640080F12C4D4893540EF661591BC6D46400C3F092241A53540D9E570523D674640A2E6C9FCA3AB35405F79D1B249624640232DF84553B73540A6E7C4C3205F4640D35118004FD335408A368584DE5D46408C3CA23149073640E90282397A584640FF1DCC81790B364091B26E17F5554640DFE8260FB01136408CCC51DBE15446405AF4081AB0113640D6B6E780054F4640EAF427CF61273640746BE0FDA74E4640A7AA85FEAE3A364001DEF98F96564640B40F1A0B54443640C3A424DA44604640EC0B11154F7A3640EA38341B1A60464072AF49A6F98F3640EA38341B1A604640F6BCEF294AB136402BB11B5B745A4640FB0927FD18AA3640C3F7C500E4504640406495C107B53640DB84D8AA6E4F4640D52D642B1ECD3640DB84D8AA6E4F46407FAD112D1ECD3640CCE8FEFB9D3D4640CDAFE7B523A63640E45861E93238464012013C1F549236408C784265B234464017C3BE9D449236404CE6F9D3462E464052EC9F85A9B83640AE3E98254B2E46405127500EB0B836408700A5FCFF1E4640E6AC4B8DD0AF3640D06C663E311C4640AA6E1F5E7CA436401B11487831194640125A38B5D8883640E807556AF6194640947FB4B5747B3640FD3DE834662846408EB0F7657A6B3640BA4E041665344640850A3DAC816B364043C90AD9D43E464023C73E33FB8336407BAEE0D10E414640D5DCA63FFB833640407314C5504B4640276BADE5847D3640A62160BE06524640E2E3E98486743640726EDEDD6F524640F8FD96B66E553640DDE3A5400B524640DC7B163A65543640B72AB7FEA74E464033DE21591B4E3640D53C201A273E464009E2EFCD253B3640809D41E8453D46403323C429CE3436403CC513419C3746406997D4F83B0636409A083D409C3746400E5B9C7B59003640D2CEB4B39E424640D66959BE2EFB3540CA79AC74D2444640D18B9E4ABCEC35409A2720819A4C4640C242C02154D5354052060D47A14E46407A8F3AA693A13540EB12DA28A14E4640EB9A7C5814913540B17DDB1324574640B60DA672248B3540B97DD0B3595A4640EED28F86538635406344FC68DD5B464074D7CE8B6E5A3540A16C7AAB095E4640CD5BFF756E5A35401091E67E3D6246409E454FCAA43E354093CF0F7E3D624640165609AAA12C35404A9A8697965C4640AA70D65D8F263540C9854C8D2B5A4640C24B95EF19213540FFEA2B595F59464066B448B8351E3540A184DF97445946409DB092342407354090D73FF4495946401B352CFCCFFC3440B7F9B1930B594640C92D31CF4AF2344054F2F2CF67554640D7AB401CDAEE3440EFD382177D54464095F53F1B14E23440CDB84379D55246400D6A183E22D0344052166987645246407A751563AAC23440E8BF85860F534640A60D4757E9B8344014C9F5A56D544640349B72F15CB434405ADBACFA5C564640AF2BCF17D6A034404B53910A635E46406290CE2CAE9A3440105A40683D624640110A24AB6C9934403246EF0A33674640709A7CD525883440A082680822684640AE5ECFB5D47E34409C2B5E76996646401202AB121B6C34401306A8041F5A4640905191AFA94E34406D60ED83875046403D2E17B83C243440C7EC66463F504640CC10BF0754063440C270B32E244C4640C44728113CDD3340BCE7316F7A4E4640D5908BD6F6C1334071A02EADE1554640EB03D53F88A63340AABE65040A5846407F15110F729E3340DFF08AE07F69464077743E3C4B8E334065281197D26B46401629115E717B3340A9BD1AFBED6E4640224BB7369E633340F07931EFCC6C4640FD0AC913523E3340F7330FAA1E6C4640 |
137 | 35 \. |
1129
04598cc4f695
Make responsibility areas a bit larger than countries
Tom Gottfried <tom@intevation.de>
parents:
211
diff
changeset
|
36 |
04598cc4f695
Make responsibility areas a bit larger than countries
Tom Gottfried <tom@intevation.de>
parents:
211
diff
changeset
|
37 UPDATE users.responsibility_areas |
3661
1fe3b378544a
Added handcrafted responsibility areas and matching stretches.
Sascha Wilde <wilde@intevation.de>
parents:
3394
diff
changeset
|
38 SET area = ST_Multi(CAST(ST_Buffer(area, 10) AS geometry)); |