Mapping of IATI to DAC CRS

JohnAdams · June 29, 2016, 3:07pm

Hi all

Has anyone successfully mapped from IATI to CRS? If so, have you shared your story?
Has anyone got a mapping between DAC country codes (http://www.oecd.org/dac/stats/documentupload/Codelist_May_2016.xls) and IATI country codes (http://iatistandard.org/202/codelists/Country/). I’m too lazy to write my own!

Thanks

John

markbrough · June 14, 2016, 5:39pm

Hey John! I think I can help with your point 2 – I guess it would also be good if there was somewhere to share these sorts of generally useful datasets:

github.com

markbrough/fr-crs-iati/blob/master/lib/countries-regions.csv

country_name,country_name_FR,dac_country_code,iso2,iso3,dac_region_code,dac_region_name,type
Afghanistan,Afghanistan,625,AF,AFG,689,"South & Central Asia, regional",Country
"Africa, regional","Afrique, régional",298,,,298,"Africa, regional",Region
Albania,Albanie,71,AL,ALB,89,"Europe, regional",Country
Algeria,Algérie,130,DZ,DZA,189,"North of Sahara, regional",Country
"America, regional/multi-country","Amérique, régional",498,,QNA,498,"America, regional",Region
Angola,Angola,225,AO,AGO,289,"South of Sahara, regional",Country
Anguilla,,376,AI,AIA,389,"North & Central America, regional",Country
Antigua & Barbuda,Antigua-et-Barbuda,377,AG,ATG,389,"North & Central America, regional",Country
Argentina,Argentine,425,AR,ARG,489,"South America, regional",Country
Armenia,Arménie,610,AM,ARM,689,"South & Central Asia, regional",Country
"Asia, regional/multi-country","Asie, régional",798,,QRA,798,"Asia, regional",Region
Azerbaijan,Azerbaïdjan,611,AZ,AZE,689,"South & Central Asia, regional",Country
Bangladesh,Bangladesh,666,BD,BGD,689,"South & Central Asia, regional",Country
Barbados,,329,BB,BRB,389,"North & Central America, regional",Country
Belarus,Bélarus,86,BY,BLR,89,"Europe, regional",Country
Belize,Belize,352,BZ,BLZ,389,"North & Central America, regional",Country
Benin,Bénin,236,BJ,BEN,289,"South of Sahara, regional",Country
Bhutan,Bhoutan,630,BT,BTN,689,"South & Central Asia, regional",Country
Bolivia,Bolivie,428,BO,BOL,489,"South America, regional",Country

This file has been truncated. show original

bill_anderson · June 14, 2016, 6:00pm

Speak to Herman @minbuza
A linked data option with lots of other country relationships is at http://joinedupdata.org/geo-pol/countries.html