INSERT INTO public.ref_chiefdom(code, val, province_code, household_name, chief_name, chief_gender_code, establishment_date, srs, geom, logo) 
  VALUES ('MNU', 'Mnukwa', 'ZM30', 'Chikenkhe Cha M''sang''ombe', 'Donald Mazsyopa (IV)', 'male', null, 32736, ST_GeomFromText('MULTIPOLYGON(((32.5290046737936 -13.2512618698206,32.5415954502237 -13.247232821363,32.5415954502237 -13.247232821363,32.5496535471389 -13.2507582387634,32.5536825955966 -13.2714071121088,32.5839004590287 -13.3076685482274,32.6080747497745 -13.3172375383143,32.6282199920626 -13.3202593246575,32.6438325548359 -13.3127048587994,32.6574305933804 -13.3263028973439,32.6498761275224 -13.3514844502041,32.6332563026347 -13.3716296924922,32.619154633033 -13.3947967211236,32.626709098891 -13.4169564876405,32.6458470790647 -13.4315617882994,32.6483652343508 -13.4557360790451,32.6382926132067 -13.4839394182485,32.6272127299482 -13.5005592431362,32.6075711187173 -13.5050919226511,32.5889367696008 -13.4869612045917,32.5803750416283 -13.4753776902761,32.5662733720266 -13.4648014380748,32.5531789645393 -13.4723559039329,32.5375664017661 -13.465305069132,32.527493780622 -13.4582542343312,32.5229611011072 -13.435590836757,32.5335373533084 -13.4270291087846,32.5788641484567 -13.4250145845557,32.5607334303974 -13.4003366627528,32.5466317607957 -13.3811986825791,32.5164138973635 -13.3867386242083,32.5108739557343 -13.3796877894075,32.5043267519906 -13.3610534402909,32.52245747005 -13.346448139632,32.5184284215923 -13.3368791495452,32.5083558004483 -13.3328501010876,32.5058376451622 -13.3152230140854,32.4902250823889 -13.3001140823693,32.5123848489059 -13.2829906264244,32.52245747005 -13.2678816947083,32.5290046737936 -13.2512618698206)))',4326), decode('[encoded data, 16320 characters]','hex'));
  
INSERT INTO public.ref_chiefdom(code, val, province_code, household_name, chief_name, chief_gender_code, establishment_date, srs, geom, logo) 
  VALUES ('NYA', 'Nyamphande', 'ZM30', 'Nyamphande Royal Establishment', 'Mr (V)', 'male', '2021-07-05', 32736, ST_GeomFromText('MULTIPOLYGON(((31.1683975922069 -13.9855651309337,31.1998696660541 -13.9930055800876,31.2118639741092 -14.0021777956081,31.2358525726422 -13.9930055571672,31.247141338092 -14.0099388854747,31.2534912756626 -14.0289888831891,31.2407914399483 -14.0494500040883,31.2422025485453 -14.0713222283377,31.2358526376216 -14.0910777905844,31.2199917523875 -14.102860319494,31.1972071556815 -14.1197862474648,31.1864643622355 -14.1277667162728,31.1695312583105 -14.1679834003419,31.1646101596504 -14.1734723923652,31.162266404303 -14.1959963038018,31.1423365105449 -14.2517929255009,31.131232379916 -14.2605236845202,31.1060057415952 -14.2721309178167,31.0937506648402 -14.2707049569518,31.0786304370383 -14.2671737515371,31.0826313220937 -14.2093262428533,31.0853426057261 -14.1007723587453,31.0842549444115 -14.1007528298221,31.0855710846089 -14.0783778885398,31.0947431570031 -14.0219334310728,31.1025041632306 -14.0050000910585,31.1306523283265 -13.980532394746,31.1549770517517 -13.9805323785172,31.1683975922069 -13.9855651309337)))',4326), decode('[encoded data, 85224 characters]','hex'));
  
INSERT INTO public.ref_chiefdom(code, val, province_code, household_name, chief_name, chief_gender_code, establishment_date, srs, geom, logo) 
  VALUES ('CHI', 'Chikwa', 'ZM30', null, 'Mr Felix  Mbuzi ', 'male', null, 32736, ST_GeomFromText('MULTIPOLYGON(((32.5932669966631 -11.6656719993601,32.5932639974241 -11.6656849999596,32.5932609972857 -11.6656839999135,32.5932669966631 -11.6656719993601)),((32.4518569977398 -11.505144999889,32.4519079973936 -11.5051819997966,32.4517619978557 -11.5051329993356,32.4518569977398 -11.505144999889)),((32.5932669966631 -11.6656719993601,32.5906189968651 -11.6642759997354,32.5888039968078 -11.6629109997414,32.5841099970914 -11.6569809996738,32.583285996866 -11.6555539995181,32.5806609972295 -11.655279999474,32.5782019971533 -11.6532889993904,32.5800579973016 -11.6513340000659,32.5767869975539 -11.6501479993338,32.5772479972277 -11.64905799943,32.5753739971476 -11.6475219996442,32.5754839968236 -11.6462619999949,32.5720409972387 -11.6456489996065,32.5699999975522 -11.6455440001611,32.5692949974182 -11.6444599996351,32.5695819971624 -11.6436009995922,32.5637429968091 -11.6419109999006,32.5608209969667 -11.6406660000448,32.559180996885 -11.6392430000739,32.5583219968456 -11.6423379998087,32.5559359974383 -11.6431499994835,32.5563289975732 -11.6402299997253,32.5537609969676 -11.639669999982,32.551027996848 -11.6412849998153,32.5494609974354 -11.6427229995797,32.5485849975102 -11.6422699993742,32.5480469969827 -11.6396969994305,32.5464629967852 -11.6378159999225,32.5444169968677 -11.6367949996043,32.5428301350277 -11.6358623082143,32.5425967492661 -11.6352894517623,32.5437069974022 -11.6347380000737,32.5421809971812 -11.6327419997591,32.5422329968808 -11.6315970000172,32.542633997385 -11.6301079996999,32.5419279972048 -11.6288519993361,32.5409859969339 -11.6270249996201,32.5431409973806 -11.6266139995518,32.544766996816 -11.6254039995098,32.5451629970894 -11.6229990001185,32.5425349973142 -11.6222099997074,32.5391069975222 -11.6245729998609,32.538515997249 -11.6229729998211,32.5380989969053 -11.6211440000128,32.5387349974542 -11.6201110000396,32.5410689971621 -11.6204999999912,32.5414069974589 -11.6180949997006,32.539710997493 -11.6171870000967,32.5378379974589 -11.6156509994115,32.5377129970903 -11.6140490001787,32.5368339970268 -11.613251999398,32.5345529970646 -11.6118889994963,32.5355379975189 -11.6105679997316,32.5378149972964 -11.6111299995673,32.5388589968741 -11.6100939994556,32.5384449975682 -11.6088949999215,32.5370449968627 -11.6087289994615,32.5352869976349 -11.6070209998376,32.5348129973609 -11.605534999659,32.5331799976023 -11.6054280001212,32.5307209975259 -11.6034939999681,32.5308849969938 -11.6013189994922,32.529542997164 -11.6010960000008,32.5239479972705 -11.6016379998162,32.5221399975361 -11.6016460001857,32.5208469972674 -11.5995919998943,32.5196779973211 -11.5989679998971,32.5202519977088 -11.5971909997884,32.5190199975551 -11.5957089997946,32.5152359975343 -11.5969859993298,32.513482997638 -11.5961929996332,32.513124997317 -11.5945349996166,32.5127069969272 -11.5926489998777,32.5111879970293 -11.5920839999035,32.5088499971367 -11.5908359999091,32.5093029973404 -11.5882009998037,32.5071989974463 -11.5872949993929,32.5059049971314 -11.5850690001629,32.5040379973742 -11.5848489999107,32.5033479970333 -11.5866270000655,32.5019989968804 -11.5852020000022,32.5001799975374 -11.5829220000808,32.4997649972861 -11.5814359999022,32.5011579976686 -11.5802269999064,32.4995159974944 -11.5784029994297,32.4977019974829 -11.5771529993429,32.495748195162 -11.5767893935478,32.4880655477421 -11.5601436574387,32.4889779971892 -11.5585369997173,32.4864599970899 -11.5564309997263,32.4873869975677 -11.5551110000078,32.486379996997 -11.5520249997894,32.4848499974905 -11.5493990000998,32.4836169972906 -11.5476879994381,32.4852419975793 -11.5461929997431,32.4858749970905 -11.5445869994262,32.4854629969777 -11.5437309995219,32.4831909974308 -11.5440849996596,32.4807365829977 -11.5442642327456,32.4799603646516 -11.5425824258759,32.4802579970801 -11.5407220001578,32.4789079977802 -11.5388399997043,32.4776759976264 -11.5373579997104,32.4795929969909 -11.5359179998537,32.4799289971956 -11.5333409997252,32.4786879975256 -11.5299699998539,32.4745919975055 -11.5271850000274,32.473598997581 -11.5267319998219,32.4725379972184 -11.5245619995769,32.4697309972824 -11.5229730000452,32.4677979971792 -11.5211509996608,32.4661479975349 -11.5176680000206,32.4641019976172 -11.516703999633,32.4608289977764 -11.5151170001936,32.4574899975897 -11.51204299963,32.4548649970533 -11.5119409994237,32.4530469977563 -11.5097169993867,32.4540279971268 -11.5077099994633,32.45279399778 -11.505826999863,32.452484997021 -11.5056019993797,32.4524049978285 -11.5054259993574,32.4525579976891 -11.5054269994034,32.4451839975971 -11.5000249994035,32.448727997343 -11.497375999551,32.4448099974369 -11.4952199999525,32.4445499971375 -11.489956000019,32.4416909975017 -11.4895690001598,32.4398139972827 -11.4874030000995,32.4373749972297 -11.4891889997244,32.4352649970582 -11.4870239997103,32.432408997561 -11.4873809999865,32.4300769970456 -11.4874489995258,32.4285729978399 -11.4897450001861,32.426237997186 -11.4891269995667,32.4257029976963 -11.4871259999204,32.4235339975021 -11.4848480000913,32.4230169970446 -11.4864519994165,32.4217409975604 -11.4876599993662,32.4202809976849 -11.4872670001291,32.4184639975347 -11.4854439996985,32.4168379971995 -11.4866539997405,32.4142049971929 -11.4849489993558,32.4099599974972 -11.4872589997632,32.4088989971345 -11.4848599997497,32.4062629978886 -11.4824110001289,32.4050399972508 -11.4828180000124,32.4037659978589 -11.4845979993603,32.4016709974804 -11.4853519999576,32.3996869977235 -11.4849609999136,32.3993289974026 -11.4833029998969,32.3993789979092 -11.481814999626,32.3971649974391 -11.4819969999257,32.396174997653 -11.4822879998557,32.3941309978272 -11.4816110001126,32.3930319975117 -11.4833899994142,32.3913329974068 -11.4817959996515,32.3878339979363 -11.4816979996298,32.3864459977843 -11.4840510002207,32.3836459972715 -11.4837780002226,32.3823489977172 -11.4809799997956,32.3792589973216 -11.4810519995195,32.3796529975029 -11.4781879996457,32.3777249976302 -11.4774529999258,32.375110997601 -11.4792969995275,32.3732419977511 -11.4787909995761,32.3728249974073 -11.4770189996984,32.3714799974387 -11.4761100000481,32.3697319977726 -11.476519000024,32.3687869973629 -11.4740050001031,32.3670939975349 -11.4737269998741,32.365571997498 -11.4725319996255,32.3639809978762 -11.4691629998464,32.361934997958 -11.4680849995975,32.3607029978039 -11.4666029996036,32.357839997983 -11.4654149996782,32.3560299972563 -11.4649079996806,32.3549689977928 -11.462680999505,32.3531579979193 -11.4619459997851,32.3509299977021 -11.4596669999098,32.3483619979947 -11.4591070001663,32.345156997692 -11.4594659996355,32.3413679974389 -11.4595979994285,32.338626997848 -11.4594970001675,32.3372839979716 -11.4591029999849,32.3348279980327 -11.4576840001986,32.3295119975118 -11.4557629997463,32.3274709978242 -11.4557150002313,32.3257819972814 -11.4561810001377,32.3249569979087 -11.454410999453,32.3237879979619 -11.4537299995251,32.3186009979941 -11.4542120001703,32.3165619974995 -11.4545649993624,32.3151569974618 -11.4535989997816,32.3115959978295 -11.4526999996938,32.3089709981915 -11.4524269996955,32.3058809977955 -11.4524989994194,32.3036029979707 -11.4516509998844,32.3019029978194 -11.4499420002143,32.3000369981076 -11.4498939997999,32.2977049975915 -11.4499620002384,32.2928589980591 -11.4486689999679,32.2898859976623 -11.4487969995762,32.2874339979077 -11.4481789998559,32.2856899975266 -11.449218000106,32.2832429980028 -11.4495729993904,32.2814459978759 -11.4516989994058,32.2807559975345 -11.4534759995145,32.2801839981381 -11.4558259999667,32.278325997896 -11.4573229997539,32.2760019977491 -11.4588219996334,32.272682997585 -11.45981000023,32.2695439976276 -11.4616569999701,32.2688319980701 -11.4618930000615,32.2688209975629 -11.461887999831,32.2669373243742 -11.4625198212329,32.2597070296481 -11.4633810318111,32.2593469977588 -11.4630209999213,32.2549709983155 -11.4624129997633,32.2532239977958 -11.4628789996697,32.2502449980211 -11.4617479996748,32.2474459975538 -11.4618190002517,32.2433089983397 -11.4623539997434,32.2405119979646 -11.4626530000427,32.2386459982525 -11.4625479996977,32.2376569976129 -11.4630099994195,32.236379998082 -11.4642180002683,32.2346269981846 -11.4634819996028,32.2328759983795 -11.463032999582,32.2319379982928 -11.4621789997699,32.2288989975497 -11.4607050001453,32.225920997821 -11.4598609998956,32.2251479981479 -11.4568889995383,32.2257899980746 -11.4556120000043,32.225792998213 -11.4556120000043,32.2262249983485 -11.4547190001921,32.2284559978043 -11.4518259998798,32.2284419980576 -11.4499249994491,32.2235899982477 -11.4480249999648,32.2226109980695 -11.4504290002095,32.2191419981827 -11.4514800001141,32.2191689976292 -11.4515780001367,32.2190699975611 -11.4541700000576,32.218892651254 -11.4543163224525,32.2196673083737 -11.4372738549167,32.2281339757475 -11.3822405212936,32.2450673087064 -11.3272071885679,32.2521228642522 -11.2876960770179,32.2394669614302 -11.2753488547746,32.2436400810093 -11.2482235751659,32.2437022763232 -11.2478193083225,32.2980737861434 -11.2821472437941,32.3746265633522 -11.3056069658614,32.3882085079684 -11.3031375210485,32.4017904525856 -11.306841688258,32.432658508119 -11.2969639099121,32.4610571188527 -11.30684168824,32.4721696186695 -11.3265972431112,32.5166196188219 -11.3599347435216,32.5413140632513 -11.3858639104104,32.5697126739789 -11.3982111326468,32.5820598961915 -11.4080889100797,32.5993460080058 -11.4142625211966,32.6166321189264 -11.4414264104918,32.6413265633499 -11.4648861325706,32.6561432294721 -11.5043972432135,32.6549085070887 -11.5574902994127,32.6647862854065 -11.5945319661478,32.6870112850294 -11.6241652993502,32.7141751742358 -11.6031750211605,32.7067668407294 -11.5945319661308,32.7215835077326 -11.584654187788,32.7277571188287 -11.5661333544159,32.766562674334 -11.5820965491445,32.8078376737355 -11.5969132161812,32.8808626739718 -11.6053798826495,32.8909621684309 -11.6097082369145,32.8896255456522 -11.6169424050374,32.8996758651789 -11.6143942317728,32.9211653506522 -11.6287205560619,32.9196889966086 -11.6310709989813,32.9171369967457 -11.6357049995412,32.9154579966681 -11.63930299909,32.9142459965407 -11.6426669995388,32.9132649962726 -11.6452159992758,32.9115829960565 -11.6485169995176,32.90786699648 -11.6547859990341,32.9066119961693 -11.6605719987587,32.9044999968127 -11.6709379992501,32.9035259968682 -11.6752239990495,32.9030799969887 -11.679390998757,32.9018099968847 -11.682989999251,32.9002459967135 -11.6858839987103,32.897807996711 -11.6901199989027,32.8957749964975 -11.6936529990515,32.894336996741 -11.6980029991046,32.8939509969304 -11.7027449992479,32.8941539964005 -11.7076099987678,32.8941769965636 -11.7120099993273,32.8943819970256 -11.7175589989137,32.8958169966481 -11.7232259994446,32.896777996896 -11.7270939988526,32.8980329963121 -11.7322429988782,32.9001119968516 -11.7370329994352,32.9011799966373 -11.7402149986844,32.9021909964922 -11.7426419990896,32.9059589966725 -11.7465599990034,32.9074369964776 -11.7486349993635,32.9100919965969 -11.7520359988187,32.9127919960926 -11.75359099948,32.917140996083 -11.7557139993543,32.9216009966948 -11.7569709988628,32.926756996125 -11.7579349992484,32.9301599965601 -11.7586649987365,32.9357949964941 -11.7606709995098,32.9383849963137 -11.7631459994296,32.9390569967256 -11.7680089988571,32.9383809961339 -11.773566998859,32.9371259967229 -11.7798209994812,32.9372219966557 -11.7860639986961,32.9392349968498 -11.7908639988148,32.9417219964175 -11.7955989995331,32.9442639967222 -11.7992889988257,32.9465179963381 -11.804713998988,32.9480549961661 -11.8077229992523,32.9496079967329 -11.8132069994378,32.9493479964378 -11.8189359992313,32.9477309965216 -11.823513999007,32.9438239962308 -11.8270609989031,32.9376909967178 -11.8298089988266,32.9295579967124 -11.8319229991917,32.9236379962274 -11.8311929988056,32.9177739965256 -11.8299479989518,32.9126129968643 -11.8284089990296,32.9079209963466 -11.8277869991267,32.9029429970303 -11.8276929992911,32.898437997042 -11.8286959987822,32.8935809970104 -11.8299309990797,32.8896559967866 -11.8300669990581,32.8846169964556 -11.8296229992699,32.8805089967859 -11.8283039987005,32.8765789963309 -11.8269909993071,32.8719449966881 -11.8256829992453,32.8685419971516 -11.8249979991343,32.8638499966331 -11.8240959989095,32.859171996761 -11.8255609990215,32.8579639968177 -11.8293839990534,32.8586879969294 -11.8337799994281,32.8593589963958 -11.8381129986962,32.860667996503 -11.8421629993026,32.8616939970509 -11.8475329987279,32.8620879963363 -11.8552919995048,32.8619459969858 -11.8619459987874,32.8612179966941 -11.8683159993627,32.8601569963368 -11.8774549990281,32.8578499969796 -11.8844699987716,32.8540189965957 -11.8909039987025,32.8498429964915 -11.8983889994366,32.849779606878 -11.8984802428528,32.8406460067735 -11.8943048830523,32.8173626741964 -11.8953632160391,32.7771460077636 -11.882663215853,32.7453960077981 -11.8583215493329,32.6945960071372 -11.8435048822992,32.6543793406878 -11.8191632157811,32.6236876745904 -11.8117548831647,32.5908793407435 -11.7937632162954,32.5697126740949 -11.7905882164768,32.5431690167008 -11.7746092467328,32.5433945630714 -11.7721282366422,32.5442536701284 -11.7626780553612,32.5447369972706 -11.7617809996065,32.544376209951 -11.7613301200022,32.5456809661527 -11.7469777963012,32.5456859969603 -11.7469759994557,32.5471849968348 -11.7460479998277,32.5486129970325 -11.7448339996013,32.5497549975321 -11.7444769993256,32.5499689975072 -11.7431209997458,32.5492549969583 -11.7424789998177,32.5482559976565 -11.7415509992913,32.5473989968088 -11.7408369996402,32.5462784100661 -11.7404059123158,32.5463508000944 -11.7396096219992,32.5971508007554 -11.696747122077,32.5874484504967 -11.6838106559358,32.5879309970275 -11.6837009997999,32.589072997527 -11.6832010001242,32.5909999973521 -11.6817739999676,32.5922139966749 -11.6809170000166,32.5933559971744 -11.6807739997169,32.594854997049 -11.6809889997386,32.5960689972715 -11.6813449999674,32.5972109968717 -11.6812739993907,32.5979959970968 -11.6807739997152,32.5988529970445 -11.6795609995351,32.5990669970195 -11.6782759996322,32.5983529973699 -11.6768479994304,32.597281997446 -11.6759199998034,32.5959259969707 -11.6751349995763,32.5939989971452 -11.674849999924,32.592641997523 -11.6738499996747,32.5914999970232 -11.6728509994715,32.5910719970718 -11.671637000145,32.5909999973484 -11.6697099994146,32.5919999966955 -11.6679969995592,32.59392699742 -11.667068999931,32.5949429975051 -11.6664880001173,32.593304997516 -11.6657049999826,32.593307996755 -11.6656939994753,32.5932669966631 -11.6656719993601)))',4326), decode('[encoded data, 404853 characters]