Split Philippines

[frodrigo]

Split by admin_level=3

@id	@type	name	name:en	ISO3166-2
147488	relation	Metro Manila	Metro Manila	PH-00
1552120	relation	Calabarzon	Calabarzon	PH-40
1552186	relation	Ilocos Region	Ilocos Region	PH-01
1552190	relation	Cordillera Administrative Region	Cordillera Administrative Region	PH-15
1552192	relation	Cagayan Valley	Cagayan Valley	PH-02
1552195	relation	Central Luzon	Central Luzon	PH-03
1552261	relation	Mimaropa	Mimaropa	PH-41
3561455	relation	Bicol Region	Bicol Region	PH-05
3589982	relation	Western Visayas	Western Visayas	PH-06
3625910	relation	Central Visayas	Central Visayas	PH-07
3759193	relation	Eastern Visayas	Eastern Visayas	PH-08
3777290	relation	Zamboanga Peninsula	Zamboanga Peninsula	PH-09
3821409	relation	Bangsamoro	Bangsamoro	PH-14
3851570	relation	Soccsksargen	Soccsksargen	PH-12
3870502	relation	Caraga	Caraga	PH-13
3873457	relation	Northern Mindanao	Northern Mindanao	PH-10
3936842	relation	Davao Region	Davao Region	PH-11

[out:csv(::id,::type,name,"name:en","ISO3166-2")];
relation(2850940);
map_to_area -> .a;
relation(area.a)[admin_level=3];
out;

[frodrigo]

ph_state("metro_manila", 147488,"PH-00")
ph_state("calabarzon", 1552120,"PH-40")
ph_state("ilocos_region", 1552186,"PH-01")
ph_state("cordillera_administrative_region", 1552190,"PH-15")
ph_state("cagayan_valley", 1552192,"PH-02")
ph_state("central_luzon", 1552195,"PH-03")
ph_state("mimaropa",1552261 "PH-41")
ph_state("bicol_region", 3561455,"PH-05")
ph_state("western_visayas", 3589982,"PH-06")
ph_state("central_visayas", 3625910,"PH-07")
ph_state("eastern_visayas", 3759193,"PH-08")
ph_state("zamboanga_peninsula", 3777290,"PH-09")
ph_state("bangsamoro",3821409 "PH-14")
ph_state("soccsksargen",3851570 "PH-12")
ph_state("caraga",3870502 "PH-13")
ph_state("northern_mindanao", 3873457,"PH-10")
ph_state("davao_region", 3936842,"PH-11")