-- Data for Name: spatial_ref_sys; Type: TABLE DATA; Schema: public; Owner: postgres
--



--
-- TOC entry 6303 (class 0 OID 19403)
-- Dependencies: 241
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO public.users VALUES (1, '4ca1db3f-9e82-483a-b5eb-5507c9147ccf', 'Christian NGANWA', 'cnganwa@wwfcam.org', NULL, '$2y$12$D.n1oteieQ3VTZvNaHdpMuRU5aGH.4dCt/.MVBKQ93bzH9ij/tRx2', '883112a8-fed4-4c25-8e8d-e4e77ed46e59', '335db174-a66a-4b46-aa86-ab79745d04c9', NULL, NULL, '2025-06-25 16:01:04', '2025-06-25 16:01:04');


--
-- TOC entry 6319 (class 0 OID 21033)
-- Dependencies: 262
-- Data for Name: agro_industrial_concession; Type: TABLE DATA; Schema: spatial; Owner: postgres
--

INSERT INTO spatial.agro_industrial_concession VALUES (1, 'Plantation agro-industrielle', 'Palmeraie', 'Palmier à huile', 'Sangha', 20094, 20094, 'Congo', '0106000020110F0000010000000103000000010000002400000075677DEDCCF83A41A0E1C9DEF1BB03415177C4CF1CF73A41003871F43CA703419003AF72F3F33A416A67FD53A863034102CC400422F33A41225A9A7B7053034147185D8EAAEA3A41E7DB2BD35B84034129DD29729FE43A4160916097F092034153786C0DECDE3A417ECEC3A78EB30341FF74BA739FD53A4176AF86AD2CB003418E568E6302D13A412127419E3F790341B2C505B1A1CC3A410E7527EBE461034190603D5896C53A4163F091710E8703414892CC01DEBF3A41D02131870C760341E89AE69FA0BC3A41AD74F74A648F0341769D702F29B83A41A1525AEA1AB803419FDCF980EAB33A41DB8AC1867FDA0341638D70DD89AD3A41CF60A68904F303412D4F606A19AB3A410FDEA289A93704411BB918A2ADAC3A41F9DC7E54B2520441B64B7B50A0B33A416521F6613B550441C2C5EBCF72B43A4186E4661693B70441527692167DC63A41D3A1FD18BABA0441D942A3FCC5CD3A4197B6D78FDBC00441AA2B9FD25DCF3A417918778213FF0441BCFB4B1A7ECF3A411444F75D43220541BC4C97423CD83A410355A9E1DC2C05410C4054244ADE3A4108F7CD096F3805411D60E748A2DF3A4149E96E0166380541D64F2A2B1CE73A41423505761FEF04412389408040ED3A414EA211DE25BF0441F19D7FC57EF23A4154642C3FE2880441B32F74F9C9FD3A41292254ADE15704415CF8C48524023B41972A1F39C9320441488C8922AAFF3A413ED3AE05C40E0441DEEA3675F9FD3A4176F31FDAA5F40341E4FCA5AFD2F93A41FDA3F0B0CEE1034175677DEDCCF83A41A0E1C9DEF1BB0341');
INSERT INTO spatial.agro_industrial_concession VALUES (2, 'Plantation agro-industrielle', 'Palmeraie', 'Palmier à huile', 'Sangha', 5726, 5726, 'Congo', '0106000020110F000001000000010300000001000000300000000B8658EF421F3B41CF752FDD11CD05416CC58031901D3B417B60482CD2A1054125604639761F3B417C3F8C3124950541592B9213F5243B41126D90B0EEA705414060C9AF17263B41DC0315B9FACB054155D47042CA2B3B416A5A3F3D5AAB0541B18228AB5B2E3B41637F755A3E9905415D23C257C42A3B41C11A66B14D870541E906DA56B5233B41CDC796E2607F05418E5C112BC81F3B41611B91ED3F6F05413E7CD46E31293B41F6A67C61EA780541AD6BB3BD63273B41C6BAD02B015D0541E2F44F4396263B41BAAD72F1ED2F05418AA8BED639243B4190163FBA7119054193DAED0DDE203B41893D77623D1C0541359F7468101F3B4144228DB95300054180D5C13CED1C3B4168AFC0BBEEE804415B6E9C293D1A3B41AE5488E500E90441BEECD81EE6193B412933DF3617DF04414AF2EBFEE2173B41986482DE29E80441FCBCD1476E163B41631226B133E80441EF3DB6E9F9153B416B17EA59FAD7044153BEE2529D123B41055FD25D8ED30441BA773C7B810D3B4182A0F6F3AAB30441C707C3C27D0B3B41AB461E0D54B704414C5872FB750C3B418DA4524B0DE30441D72934693A0A3B41A0A589C926F50441440CDF3B8F083B41691409C828110541F18D6BC701073B415FACA75D16370541039F850B8A033B41E5B5D52F014205415D0DEBD335033B4111CA0437275305414D32D407BFFF3A410358909217670541ABB782E94EFF3A41988F8300767F05418E0BBE1860073B41107E3CF18E85054138601A80DA0A3B411C26F2C5E59305411F324C466B0D3B4135C38708927A05418F05CE6BA9103B41985751B5DA6D05419E19CBF7AD113B413BC3C9A2478505416035AD58B5133B411AC14CD7E4A3054183EDA04E67173B41583B2F38FDA1054113DD138FA0153B416B9C294805C705411F7C0C7FA3153B41C88ADACA14E20541F4062F88C5173B41A1AE91AABFED0541807D9C9C72163B41C47BE3E4B01C06414B7045F5CC173B410A906A66663106411144566B661D3B41FAAA1357573006413E20830A781C3B41AB4EC0E148DE05410B8658EF421F3B41CF752FDD11CD0541');
INSERT INTO spatial.agro_industrial_concession VALUES (3, 'Plantation agro-industrielle', 'Palmeraie', 'Palmier à huile', 'Cuvette Ouest', 1460, 1460, 'Congo', '0106000020110F0000060000000103000000010000001100000092E8481E7A353941C0D70968020DA3C099999909B831394161B010C75AF1A6C0FEDD02B9E42F39417135DD2486EAA3C02F4A7B13752C39412F26B29DAF36A5C0D4E53FB4D82A3941306B2CD43A0DA3C052B1DF20C52A39419DF8A5686020A3C07BB844FAA12A39411AA6FA708C31A2C04AC06F43283339413ECE45D4FC938FC0EA5E2C71413539414326B0701F119340B82338FC234039418717C9EBF265A0409371497886463941823AFC13535F9B40DD361AB0B04539413B06B29D2F989840EE5A428E934239419B22E2C718A784403D0378BBDB4039417A775C226CE83EC0887CD083D13E3941F5C02FBBA7E88AC06F3BDFFFBC3A39410A554AEAC48F99C092E8481E7A353941C0D70968020DA3C0010300000001000000040000003060E5603371394167DF238BEDD9B8400CF5B0CF87713941404AD530DC67B8403060E560337139417A7D8EE4226DB8403060E5603371394167DF238BEDD9B8400103000000010000000400000042E2DF9585693941D6FCCFB7ACA3B94033BB273F7F69394154CB88D24E3EB940FAC79BDCF1683941FC2208FE8052B94042E2DF9585693941D6FCCFB7ACA3B94001030000000100000006000000E59AF9D6B56C39417A5277DF951EBA407B0ACE14DC6D3941D6469AC0FEF9B940615986882E6C39418A6C423E780FBA40A1DF9E37D9693941D5E0AF66D103BB40EECE83BB516B39416052B13C4AFEBA40E59AF9D6B56C39417A5277DF951EBA400103000000010000000400000055DB3B89E571394120C2C98418EEBA403060E56033713941FB110F5F6A8DB9403060E56033713941985135035C61BB4055DB3B89E571394120C2C98418EEBA4001030000000100000005000000CAD32B1580703941C2D0718ADEA4BA409DDABE386770394196478E49189CBA406DC6C12D8A703941ABE8D6DCD3CEBB40994DC4E80D713941F81C81E39979BB40CAD32B1580703941C2D0718ADEA4BA40');
INSERT INTO spatial.agro_industrial_concession VALUES (4, 'Plantation agro-industrielle', 'Projet Palm', 'Palmier à huile', 'Sangha', 134980, 134980, 'Congo', '[encoded data, 7060 characters]');
INSERT INTO spatial.agro_industrial_concession VALUES (5, 'Plantation agro-industrielle', 'Projet Palm', 'Palmier à huile', 'Cuvette Ouest', 72091, 72091, 'Congo', '[encoded data, 5780 characters]');
INSERT INTO spatial.agro_industrial_concession VALUES (6, 'Plantation agro-industrielle', 'Projet Palm ATAMA Plantation', 'Palmier à huile', 'Sangha', 191664, 191664, 'Congo', '[encoded data, 17460 characters]');
INSERT INTO spatial.agro_industrial_concession VALUES (7, 'Plantation agro-industrielle', 'Zone à défricher ATAMA', NULL, 'Sangha', 4422, 4422, 'Congo', '0106000020110F0000010000000103000000010000000800000030C08FA6DA2A3A41CC4A38CC3ECBE840EBAA05B0422C3A4125EFFFE658CAE840B68B8B5C972E3A415EDB5E4646CAE8407938EEECAA423A4137B555C8C3C7E8409B3C4F21E63A3A4114B3DFCF14E2E44005AF47ABD63A3A41B303D26E3A93E440368E3685E3193A418E6B0F61F3D9E84030C08FA6DA2A3A41CC4A38CC3ECBE840');
INSERT INTO spatial.agro_industrial_concession VALUES (8, 'Plantation agro-industrielle', 'Projet Palm ATAMA Plantation', 'Palmier à huile', 'Sangha', 0, 0, 'Congo', '0106000020110F00000100000001030000000100000004000000E1B46564AE4D3A419B0C822E4515E340FC6E2551B84D3A416461A53E9A13E34042354631A74D3A41C9E92C2BCA14E340E1B46564AE4D3A419B0C822E4515E340');
INSERT INTO spatial.agro_industrial_concession VALUES (9, 'Plantation agro-industrielle', 'Projet Palm ATAMA Plantation', 'Palmier à huile', 'Sangha', 0, 0, 'Congo', '0106000020110F0000010000000103000000010000000600000030C05D22C8073A418A0A8DB2E5F6E3403D175BE2C8073A417E4D4213B9F5E34089954CBE6E073A41B2F5D9A470F6E340C9016FAB6E073A417BB31EB874F6E340031F29BA76073A41DDF677E300FBE34030C05D22C8073A418A0A8DB2E5F6E340');
INSERT INTO spatial.agro_industrial_concession VALUES (10, 'Plantation agro-industrielle', 'Projet Palm ATAMA Plantation', 'Palmier à huile', 'Sangha', 2, 2, 'Congo', '0106000020110F000001000000010300000001000000060000006254462ED7CA3A4122F07F294EEFE44079CDE8C2CDC93A414BCFAF8433E4E440DE39F561D4C93A418C4A2F81CBECE440B31ECCA98CCA3A41266F22FB5DF8E440618F59DD8CCA3A418ED4183861F8E4406254462ED7CA3A4122F07F294EEFE440');
INSERT INTO spatial.agro_industrial_concession VALUES (11, 'Plantation à grand echelle', 'Hevea Sud Plantation', 'hevea', NULL, 37763, 37763, 'Cameroun', '0106000020110F0000010000000103000000010000002900000071B37FA738293541C4215B3867E61441D80191CA992E35410F67A1A7C9CE1441A2529851EC303541B7979F49DBCE14410953C82EEF31354173DABCEAAFCD1441281EEF3F2A3335413727C3EEE0CC1441ECDAAD18EA343541902138F7C8D0144159B4C16F69353541DF4B0F5FA8CE14415D538BC916353541ED36DBFFF1C8144133E218BDE1333541DEB59DD88DC014414FDC96DD50333541C815FE5CAEBD1441FF9BA706EE33354103A46AB38EBA1441CC0F12A91236354143BC0F20BEB714416809CCD641383541660EF4215EB614419BF963FFFB393541616BF76B46B41441A58E5E7C463B3541E12644A158B414413E0F10F3AD3D354169F778A78EB514415E6FE223913F3541DF5AE1B5DFB81441C25779EA92413541F87292D4BCBD1441B0675BE54C433541B1C433B53EBD1441B9927AC5AA453541568A102FDCBA1441EAABA56C674835417EF30CAD53BE1441321CD5A1DA493541BFB072E650BE1441D042DFA1454C354164E94F8C07BB1441D6A79407104E354146139C3691B71441EC968B02F34E354172359841A4B31441B5BFED82E04D35417A6C47247EAB144151BDD567D24C3541403E81439FA614410FCC8787D84B3541625A83CF59A1144153DA8000844B35416919B804D89D14413CE01F23844C3541BC9B5CCF44991441877BA253C34D3541B5DD39A82E931441AA417C19914E3541EB98EAB5DD8F14413A44D7A766503541AD21905C699214416D1CF8B9CD5135417B0AC6DB4F8F14419D252E97CA4335419567FA7EBC1113411789CFED643B35411B8651DA9B30134180AB07AEBB0835411C1381A4E0EA1341702D5BA0050D3541D0C7E59EB4E91441FEEED9B11D20354164F7C250E4E914410590B54C37293541ED09D21858EF144171B37FA738293541C4215B3867E61441');
INSERT INTO spatial.agro_industrial_concession VALUES (12, 'Plantation à grand echelle', 'Hevea Sud Plantation', 'hevea', NULL, 8274, 8274, 'Cameroun', '0106000020110F000001000000010300000001000000240000004E5DDC2098183541DF253A36FBEF154153392591D71A35419FD60134D1EC1541309E3A068B1C35418CC9DBA849F7154150640EE295213541560DAE0280F81541495321A5E3213541C2FD9961D9F41541CA26918C751F354136CCC49AA8F215410F30DB8E261D3541E4B5015931E81541F990D9255B1A35416B3443A5F1DE1541C1D9CDC15219354142256351CABF15417644B4EC4D1C35418B4787FB12BC154188B732F51E1D3541FDCFA3702DAE1541E39E3DA9A51B354125FD1F77F1A31541613002CE051D3541F5928822F49615411F7D869FC12035411F4AF8451A9A154148BB54B42A203541BAAC1054DE8F154160EFE3396D2235410EC05A34E980154175AAA3E6C8243541B1E77CA76E791541EBF6D24964243541E128CD588F711541B3F68411A81F35415A1FA5800E7515411D703F34721C3541D5C5A949676B1541D1246EE1091C3541E7C581DB97611541B5AFEE76071735413AD5E3853562154107EEBC8B7016354146F388631A50154175E2564E4D0D35411E0996203B48154142144254D7FF3441230924D284361541A9163D65E6F63441466244C2D0611541FBAF45085EFE3441B137DDFF7E751541EA7F2DB047033541F352A1DCA7901541D3E7F64CAC0335414D4F6625E1A71541106B05B5B9003541698EA5175CD41541EA7F2DB047033541CFBD9B8959E11541A28D7B70330C35417F20E7C032F115418CEAFAEF5D1135412E3B470D59041641DEB7F347EE19354107B369D62E041641556EC95D4A183541B92F1519EFFA15414E5DDC2098183541DF253A36FBEF1541');
INSERT INTO spatial.agro_industrial_concession VALUES (13, 'Plantation à grand echelle', 'Hevea Sud Plantation', 'hevea', NULL, 29932, 29932, 'Cameroun', '[encoded data, 24628 characters]');


--
-- TOC entry 6336 (class 0 OID 47569)
-- Dependencies: 279
-- Data for Name: base_indicator; Type: TABLE DATA; Schema: spatial; Owner: postgres
--

INSERT INTO spatial.base_indicator VALUES ('9b715fae-e1a5-4b9c-b9cc-8ec0105fabec', 'Superficies plantées', 'Superficie des terres plantées dans le cadre de la mise en œuvre du Projet CIBEL', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL);
INSERT INTO spatial.base_indicator VALUES ('cdf040d0-ade0-4165-9c0d-850013283d8c', 'Nombre d''agriculteurs engagés', 'Nombre d''agriculteurs engagés dans le cadre de la mise en œuvre du Projet CIBEL', NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL);
INSERT INTO spatial.base_indicator VALUES ('2e37aee3-2dea-42fa-91e3-8e935194c555', 'Nombre de villages couverts par le projet CIBEL', 'Valeur du nombre de villages couverts par le projet CIBEL', 'spatial.village', 'is_supported_by_cibel LIKE ''Yes''', 'SELECT COUNT(*) AS value FROM spatial.village WHERE is_supported_by_cibel LIKE ''Yes''', 'Villages', 'SELECT TRUNC((COUNT(*) FILTER (WHERE is_supported_by_cibel LIKE ''Yes'')::numeric / COUNT(*)::numeric) * 100, 2) AS value FROM spatial.village;', '%', 1, 'par rapport au nombre total de villages');
INSERT INTO spatial.base_indicator VALUES ('b63dadd9-1efd-4c25-88ff-c9f80c17f8cb', 'Superficie des aires protégées avec un Plan d’aménagement', 'Valeur de la superficie des aires protégées avec un Plan d’aménagement', 'spatial.protected_area', 'planning_status IS NOT NULL', 'SELECT TRUNC( SUM((ST_Area(geom) / 10000)::numeric), 2 ) AS value FROM spatial.protected_area WHERE planning_status IS NOT NULL;', 'Hectare (Ha)', 'SELECT TRUNC((SUM(CASE WHEN planning_status IS NOT NULL THEN (ST_Area(geom) / 10000)::numeric END) / SUM((ST_Area(geom) / 10000)::numeric)) * 100,2) AS value FROM spatial.protected_area;', '%', 2, 'par rapport à la superficie totale des APs');


--
-- TOC entry 6333 (class 0 OID 22970)
-- Dependencies: 276
-- Data for Name: country; Type: TABLE DATA; Schema: spatial; Owner: postgres
--

INSERT INTO spatial.country VALUES (2, 'Cameroun', '[encoded data, 34254 characters]');
INSERT INTO spatial.country VALUES (1, 'République du Congo', '[encoded data, 33844 characters]');
INSERT INTO spatial.country VALUES (3, 'Gabon', '[encoded data, 28200 characters]');


--
-- TOC entry 6346 (class 0 OID 48227)
-- Dependencies: 289
-- Data for Name: hunting_zone; Type: TABLE DATA; Schema: spatial; Owner: postgres
--

INSERT INTO spatial.hunting_zone VALUES (1, 'Zone d''intérêt cynégétique', 'Boumba', 'zic', 'Societe Bongo Safari', 'cree', '2000-09-20', '2000-09-20', 132197, 132270, '[encoded data, 47764 characters]');
INSERT INTO spatial.hunting_zone VALUES (2, 'Zone d''intérêt cynégétique', 'Ndama', 'zic', 'Societe des Guides Chasse du Sud Cameroun', 'cree', '2002-01-31', '2002-01-31', 109955, 109963, '[encoded data, 25556 characters]');
INSERT INTO spatial.hunting_zone VALUES (3, 'Zone d''intérêt cynégétique', 'Lebe', 'zic', 'Bekir Cem Cantürk', 'cree', '2002-01-31', '2002-01-31', 82020, 82026, '[encoded data, 17556 characters]');
INSERT INTO spatial.hunting_zone VALUES (5, 'Zone d''intérêt cynégétique', 'Sitatunga', 'zic', 'Mayo Oldiri Gie', 'cree', '2007-05-29', '2007-05-29', 63465, 63057, '[encoded data, 16468 characters]');
INSERT INTO spatial.hunting_zone VALUES (6, 'Zone d''intérêt cynégétique', 'Ayina', 'zic', 'Ndilla Safari', 'cree', '2007-05-29', '2007-05-29', 63465, 109828, '[encoded data, 40084 characters]');
INSERT INTO spatial.hunting_zone VALUES (18, 'Zone de chasse à gestion communautaire', 'Boumba Beuk', 'zicgc', NULL, 'cree', '2000-09-20', '2002-01-31', 86822, 86829, '[encoded data, 31700 characters]');
INSERT INTO spatial.hunting_zone VALUES (19, 'Zone de chasse à gestion communautaire', 'Akoafim', 'zicgc', NULL, 'cree', '2007-05-29', '2007-05-29', 63466, 65679, '[encoded data, 32724 characters]');
INSERT INTO spatial.hunting_zone VALUES (11, 'Zone de chasse à gestion communautaire', 'Bouloboi', 'zicgc', NULL, 'cree', '2000-09-20', '2000-09-20', 45300, 45320, '[encoded data, 25620 characters]');
