{"id":180,"date":"2025-04-05T11:38:54","date_gmt":"2025-04-05T08:38:54","guid":{"rendered":"https:\/\/sedera.otantikas.me\/?page_id=180"},"modified":"2025-04-05T12:12:08","modified_gmt":"2025-04-05T09:12:08","slug":"les-23-regions-de-madagascar","status":"publish","type":"page","link":"https:\/\/sedera.otantikas.me\/?page_id=180","title":{"rendered":"Les 23 r\u00e9gions de Madagascar"},"content":{"rendered":"\n<p>Les 23 r\u00e9gions de Madagascar<\/p>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:1px\"><code>create table region_mada (\n\tid_region integer not null auto_increment primary key,\n\tcode_region integer not null,\n\tnom_region varchar (55)\n);\ninsert into region_mada values(null,11,\"ANALAMANGA\");\ninsert into region_mada values(null,12,\"BONGOLAVA\");\ninsert into region_mada values(null,13,\"ITASY\");\ninsert into region_mada values(null,14,\"VAKINANKARATRA\");\ninsert into region_mada values(null,21,\"DIANA\");\ninsert into region_mada values(null,22,\"SAVA\");\ninsert into region_mada values(null,31,\"AMORON'I MANIA\");\ninsert into region_mada values(null,32,\"ATSIMO-ATSINANANA\");\ninsert into region_mada values(null,33,\"HAUTE MATSIATRA\");\ninsert into region_mada values(null,34,\"IHOROMBE\");\ninsert into region_mada values(null,35,\"VATOVAVY\");\ninsert into region_mada values(null,35,\"FITOVINANY\");\ninsert into region_mada values(null,41,\"BETSIBOKA\");\ninsert into region_mada values(null,42,\"BOENY\");\ninsert into region_mada values(null,43,\"MELAKY\");\ninsert into region_mada values(null,44,\"SOFIA\");\ninsert into region_mada values(null,51,\"ALAOTRA-MANGORO\");\ninsert into region_mada values(null,52,\"ANALANJIROFO\");\ninsert into region_mada values(null,53,\"ATSINANANA\");\ninsert into region_mada values(null,61,\"ANDROY\");\ninsert into region_mada values(null,62,\"ANOSY\");\ninsert into region_mada values(null,63,\"ATSIMO-ANDREFANA\");\ninsert into region_mada values(null,64,\"MENABE\");<\/code><\/pre>\n\n\n\n<p>Les 119 districts<\/p>\n\n\n\n<pre class=\"wp-block-code\" style=\"font-size:1px\"><code>create table district_mada (\n\tid_distr integer not null auto_increment primary key,\n\tcode_region integer not null,\n\tnom_region varchar(55),\n\tcode_distr integer not null,\n\tnom_distr varchar(255)\n);\ninsert into district_mada values(null,11,\"ANALAMANGA\",1101,\"AMBOHIDRATRIMO\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1102,\"ANDRAMASINA\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1103,\"ANJOZOROBE\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1104,\"ANKAZOBE\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1105,\"ANTANANARIVO-ATSIMONDRANO\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1106,\"ANTANANARIVO AVARADRANO\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1107,\"ANTANANARIVO_I\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1108,\"ANTANANARIVO_II\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1109,\"ANTANANARIVO_III\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1110,\"ANTANANARIVO_IV\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1111,\"ANTANANARIVO_V\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1112,\"ANTANANRIVO VI\");\ninsert into district_mada values(null,11,\"ANALAMANGA\",1113,\"MANJAKANDRIANA\");\ninsert into district_mada values(null,12,\"BONGOLAVA\",1201,\"FENOARIVOBE\");\ninsert into district_mada values(null,12,\"BONGOLAVA\",1202,\"TSIROANOMANDIDY\");\ninsert into district_mada values(null,13,\"ITASY\",1301,\"ARIVONIMAMO\");\ninsert into district_mada values(null,13,\"ITASY\",1302,\"MIARINARIVO\");\ninsert into district_mada values(null,13,\"ITASY\",1303,\"SOAVINANDRIANA\");\ninsert into district_mada values(null,14,\"VAKINANKARATRA\",1401,\"AMBATOLAMPY\");\ninsert into district_mada values(null,14,\"VAKINANKARATRA\",1402,\"ANTANIFOTSY\");\ninsert into district_mada values(null,14,\"VAKINANKARATRA\",1403,\"ANTSIRABE I\");\ninsert into district_mada values(null,14,\"VAKINANKARATRA\",1404,\"ANTSIRABE II\");\ninsert into district_mada values(null,14,\"VAKINANKARATRA\",1405,\"BETAFO\");\ninsert into district_mada values(null,14,\"VAKINANKARATRA\",1406,\"FARATSIHO\");\ninsert into district_mada values(null,14,\"VAKINANKARATRA\",1407,\"MANDOTO\");\ninsert into district_mada values(null,21,\"DIANA\",2101,\"AMBANJA\");\ninsert into district_mada values(null,21,\"DIANA\",2102,\"AMBILOBE\");\ninsert into district_mada values(null,21,\"DIANA\",2103,\"ANTSIRANANA I\");\ninsert into district_mada values(null,21,\"DIANA\",2104,\"ANTSIRANANA II\");\ninsert into district_mada values(null,21,\"DIANA\",2105,\"NOSY-BE\");\ninsert into district_mada values(null,22,\"SAVA\",2201,\"ANDAPA\");\ninsert into district_mada values(null,22,\"SAVA\",2202,\"ANTALAHA\");\ninsert into district_mada values(null,22,\"SAVA\",2203,\"SAMBAVA\");\ninsert into district_mada values(null,22,\"SAVA\",2204,\"VOHEMAR\");\ninsert into district_mada values(null,31,\"AMORON'I MANIA\",3101,\"AMBATOFINANDRAHANA\");\ninsert into district_mada values(null,31,\"AMORON'I MANIA\",3102,\"AMBOSITRA\");\ninsert into district_mada values(null,31,\"AMORON'I MANIA\",3103,\"FANDRIANA\");\ninsert into district_mada values(null,31,\"AMORON'I MANIA\",3104,\"MANANDRIANA\");\ninsert into district_mada values(null,32,\"ATSIMO-ATSINANANA\",3201,\"BEFOTAKA ATSIMO\");\ninsert into district_mada values(null,32,\"ATSIMO-ATSINANANA\",3202,\"FARAFANGANA\");\ninsert into district_mada values(null,32,\"ATSIMO-ATSINANANA\",3203,\"MIDONGY SUD\");\ninsert into district_mada values(null,32,\"ATSIMO-ATSINANANA\",3204,\"VANGAINDRANO\");\ninsert into district_mada values(null,32,\"ATSIMO-ATSINANANA\",3205,\"VONDROZO\");\ninsert into district_mada values(null,33,\"HAUTE MATSIATRA\",3301,\"AMBALAVAO\");\ninsert into district_mada values(null,33,\"HAUTE MATSIATRA\",3302,\"AMBOHIMAHASOA\");\ninsert into district_mada values(null,33,\"HAUTE MATSIATRA\",3303,\"FIANARANTSOA\");\ninsert into district_mada values(null,33,\"HAUTE MATSIATRA\",3304,\"ISANDRA\");\ninsert into district_mada values(null,33,\"HAUTE MATSIATRA\",3305,\"IKALAMAVONY\");\ninsert into district_mada values(null,33,\"HAUTE MATSIATRA\",3306,\"VOHIBATO\");\ninsert into district_mada values(null,33,\"HAUTE MATSIATRA\",3307,\"LALANGINA\");\ninsert into district_mada values(null,34,\"IHOROMBE\",3401,\"IAKORA\");\ninsert into district_mada values(null,34,\"IHOROMBE\",3402,\"IHOSY\");\ninsert into district_mada values(null,34,\"IHOROMBE\",3403,\"IVOHIBE\");\ninsert into district_mada values(null,35,\"VATOVAVY\",3501,\"IFANADIANA\");\ninsert into district_mada values(null,35,\"FITOVINANY\",3502,\"IKONGO\");\ninsert into district_mada values(null,35,\"FITOVINANY\",3503,\"MANAKARA\");\ninsert into district_mada values(null,35,\"VATOVAVY\",3504,\"MANANJARY\");\ninsert into district_mada values(null,35,\"VATOVAVY\",3505,\"NOSY VARIKA\");\ninsert into district_mada values(null,35,\"FITOVINANY\",3506,\"VOHIPENO\");\ninsert into district_mada values(null,41,\"BETSIBOKA\",4101,\"KANDREHO\");\ninsert into district_mada values(null,41,\"BETSIBOKA\",4102,\"MAEVATANANA\");\ninsert into district_mada values(null,41,\"BETSIBOKA\",4103,\"TSARATANANA\");\ninsert into district_mada values(null,42,\"BOENY\",4201,\"AMBATO BOENI\");\ninsert into district_mada values(null,42,\"BOENY\",4202,\"MAHAJANGA I\");\ninsert into district_mada values(null,42,\"BOENY\",4203,\"MAHAJANGA II\");\ninsert into district_mada values(null,42,\"BOENY\",4204,\"MAROVOAY\");\ninsert into district_mada values(null,42,\"BOENY\",4205,\"MITSINJO\");\ninsert into district_mada values(null,42,\"BOENY\",4206,\"SOALALA\");\ninsert into district_mada values(null,43,\"MELAKY\",4301,\"AMBATOMAINTY\");\ninsert into district_mada values(null,43,\"MELAKY\",4302,\"ANTSALOVA\");\ninsert into district_mada values(null,43,\"MELAKY\",4303,\"BESALAMPY\");\ninsert into district_mada values(null,43,\"MELAKY\",4304,\"MAINTIRANO\");\ninsert into district_mada values(null,43,\"MELAKY\",4305,\"MORAFENOBE\");\ninsert into district_mada values(null,44,\"SOFIA\",4401,\"ANALALAVA\");\ninsert into district_mada values(null,44,\"SOFIA\",4402,\"ANTSOHIHY\");\ninsert into district_mada values(null,44,\"SOFIA\",4403,\"BEALANANA\");\ninsert into district_mada values(null,44,\"SOFIA\",4404,\"BEFANDRIANA NORD\");\ninsert into district_mada values(null,44,\"SOFIA\",4405,\"MAMPIKONY\");\ninsert into district_mada values(null,44,\"SOFIA\",4406,\"MANDRITSARA\");\ninsert into district_mada values(null,44,\"SOFIA\",4407,\"PORT-BERGE\");\ninsert into district_mada values(null,51,\"ALAOTRA-MANGORO\",5101,\"AMBATONDRAZAKA\");\ninsert into district_mada values(null,51,\"ALAOTRA-MANGORO\",5102,\"AMPARAFARAVOLA\");\ninsert into district_mada values(null,51,\"ALAOTRA-MANGORO\",5103,\"ANDILAMENA\");\ninsert into district_mada values(null,51,\"ALAOTRA-MANGORO\",5104,\"ANOSIBE AN'ALA\");\ninsert into district_mada values(null,51,\"ALAOTRA-MANGORO\",5105,\"MORAMANGA\");\ninsert into district_mada values(null,52,\"ANALANJIROFO\",5201,\"FENERIVE EST\");\ninsert into district_mada values(null,52,\"ANALANJIROFO\",5202,\"MANANARA-NORD\");\ninsert into district_mada values(null,52,\"ANALANJIROFO\",5203,\"MAROANTSETRA\");\ninsert into district_mada values(null,52,\"ANALANJIROFO\",5204,\"SAINTE MARIE\");\ninsert into district_mada values(null,52,\"ANALANJIROFO\",5205,\"SOANIERANA IVONGO\");\ninsert into district_mada values(null,52,\"ANALANJIROFO\",5206,\"VAVATENINA\");\ninsert into district_mada values(null,53,\"ATSINANANA\",5301,\"ANTANAMBAO MANAMPONTSY\");\ninsert into district_mada values(null,53,\"ATSINANANA\",5302,\"BRICKAVILLE\");\ninsert into district_mada values(null,53,\"ATSINANANA\",5303,\"MAHANORO\");\ninsert into district_mada values(null,53,\"ATSINANANA\",5304,\"MAROLAMBO\");\ninsert into district_mada values(null,53,\"ATSINANANA\",5305,\"TOAMASINA I\");\ninsert into district_mada values(null,53,\"ATSINANANA\",5306,\"TOAMASINA II\");\ninsert into district_mada values(null,53,\"ATSINANANA\",5307,\"VATOMANDRY\");\ninsert into district_mada values(null,61,\"ANDROY\",6101,\"AMBOVOMBE ANDROY\");\ninsert into district_mada values(null,61,\"ANDROY\",6102,\"BEKILY\");\ninsert into district_mada values(null,61,\"ANDROY\",6103,\"BELOHA ANDROY\");\ninsert into district_mada values(null,61,\"ANDROY\",6104,\"TSIHOMBE\");\ninsert into district_mada values(null,62,\"ANOSY\",6201,\"AMBOASARY SUD\");\ninsert into district_mada values(null,62,\"ANOSY\",6202,\"BETROKA\");\ninsert into district_mada values(null,62,\"ANOSY\",6203,\"TAOLANARO\");\ninsert into district_mada values(null,63,\"ATSIMO-ANDREFANA\",6301,\"AMPANIHY OUEST\");\ninsert into district_mada values(null,63,\"ATSIMO-ANDREFANA\",6302,\"ANKAZOABO SUD\");\ninsert into district_mada values(null,63,\"ATSIMO-ANDREFANA\",6303,\"BENENITRA\");\ninsert into district_mada values(null,63,\"ATSIMO-ANDREFANA\",6304,\"BEROROHA\");\ninsert into district_mada values(null,63,\"ATSIMO-ANDREFANA\",6305,\"BETIOKY SUD\");\ninsert into district_mada values(null,63,\"ATSIMO-ANDREFANA\",6306,\"MOROMBE\");\ninsert into district_mada values(null,63,\"ATSIMO-ANDREFANA\",6307,\"SAKARAHA\");\ninsert into district_mada values(null,63,\"ATSIMO-ANDREFANA\",6308,\"TOLIARY I\");\ninsert into district_mada values(null,63,\"ATSIMO-ANDREFANA\",6309,\"TOLIARY II\");\ninsert into district_mada values(null,64,\"MENABE\",6401,\"BELO SUR TSIRIBIHINA\");\ninsert into district_mada values(null,64,\"MENABE\",6402,\"MAHABO\");\ninsert into district_mada values(null,64,\"MENABE\",6403,\"MANJA\");\ninsert into district_mada values(null,64,\"MENABE\",6404,\"MIANDRIVAZO\");\ninsert into district_mada values(null,64,\"MENABE\",6405,\"MORONDAVA\");<\/code><\/pre>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Les 23 r\u00e9gions de Madagascar Les 119 districts<\/p>\n","protected":false},"author":1,"featured_media":181,"parent":183,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-180","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/sedera.otantikas.me\/index.php?rest_route=\/wp\/v2\/pages\/180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sedera.otantikas.me\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sedera.otantikas.me\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sedera.otantikas.me\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sedera.otantikas.me\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=180"}],"version-history":[{"count":3,"href":"https:\/\/sedera.otantikas.me\/index.php?rest_route=\/wp\/v2\/pages\/180\/revisions"}],"predecessor-version":[{"id":186,"href":"https:\/\/sedera.otantikas.me\/index.php?rest_route=\/wp\/v2\/pages\/180\/revisions\/186"}],"up":[{"embeddable":true,"href":"https:\/\/sedera.otantikas.me\/index.php?rest_route=\/wp\/v2\/pages\/183"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sedera.otantikas.me\/index.php?rest_route=\/wp\/v2\/media\/181"}],"wp:attachment":[{"href":"https:\/\/sedera.otantikas.me\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}