Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

The International Organization for Migration (IOM) is the leading inter-governmental organization in the field of migration and works closely with governmental, intergovernmental and non-governmental partners. It is dedicated to promoting humane and orderly migration for the benefit of all and works to help ensure the orderly and humane management of migration, to promote international cooperation on migration issues, to assist in the search for practical solutions to migration problems and to provide humanitarian assistance to migrants in need, including refugees and internally displaced people.

The Displacement Tracking Matrix (DTM) continually tracks and monitors displacement across countries allowing IOM to identify the locations to which IDPs have chosen to settle. The location and population of these IDPs are recorded and further in-depth assessments are conducted to identify the multi-sectorial needs of the displaced.

IOM is currently working on a global DTM out of their office in Geneva. The goal is to produce a monthly combined DTM for all countries, starting with camp status (the type of DTM usually shared on HDX), and about 25 columns (which they refer to as "indicators").  The global DTM will be HXL tagged. We've also begun discussions between UNHCR (Laurent Pitoiset) and IOM (Muhammad Rizki) to ensure that the HXL tags they use for refugee and migrant data are well-aligned, and each is interested in becoming a consumer of the other's data.

The initial overview and first analysis of the data structure of datasets have been moved into separate pages, so that this page contains the latest analysis (below).

Jump to Initial Overview

Jump to Data Structure - First Analysis

Data Structure - Second Analysis

IOM provided new information - that their datasets are classified into 4 categories:
  1. Site assessment
  2. Baseline assessment
  3. Flow monitoring
  4. Survey

A second analysis was performed on a selection of datasets labelled as site assessment:

IOM DTM Ecuador - Site Assessment Data - Spontaneous Sites


File: Site_Assessments_Refugios_R4.xlsx

This appears to be at a survey level. There are 3 sheets with the sheet "uploaded_form_izr7j1" containing the data:

group_details/__1_1_a_1__survey_date__dd_mm_yyyy_group_details/__1_1_b_1__enumerator_name__person_filligroup_details/__1_1_b_2__sex_of_enumeratorgroup_details/__1_1_a_2__survey_roundgroup_hc4co39/__1.1.c.1__site_idgroup_hc4co39/Site_Statusgroup_hc4co39/establecimientogroup_hc4co39/__1.1.d.1__site_namegroup_hc4co39/Site_Alternate_Namegroup_hc4co39/Site_Start_Dategroup_hc4co39/Site_Close_Date_if_applicablegroup_hc4co39/__1_1_e_1__site_location__admin_1_group_hc4co39/__1_1_e_2__site_location__admin_2_group_hc4co39/__1_1_e_3__site_location__admin_3_group_hc4co39/__1.1.f.3__gps_coordinatesgroup_hc4co39/___1.1.f.3__gps_coordinates_latitudegroup_hc4co39/___1.1.f.3__gps_coordinates_longitudegroup_hc4co39/___1.1.f.3__gps_coordinates_altitudegroup_hc4co39/___1.1.f.3__gps_coordinates_precisiongroup_hc4co39/__1.1.f.2__gps_coordinates_manual_latgroup_hc4co39/__1.1.f.1__gps_coordinates_manual_longroup_hc4co39/tipo_de_areagroup_hc4co39/Comunidadgroup_hc4co39/Name_of_nearest_city_towngroup_hc4co39/uso_sitiogroup_hc4co39/uso_sitio_othergroup_hc4co39/Propiedadgroup_hc4co39/Propiedad_othergroup_hc4co39/areagroup_hc4co39/carpas_instaladasgroup_hc4co39/carpas_ocupadasShare_roofss_Share_roof_ssgroup_site_details/tiene_fecha_limitegroup_site_details/fecha_limitegroup_site_details/previstogroup_site_details/ir_a_alberguegroup_site_details/ir_a_albergue_othergroup_site_details/ir_a_albergue_especifiquegroup_site_details/conoce_condicionesgroup_site_details/plan_preferidogroup_site_details/porque_razongroup_site_details/plan_menos_preferidogroup_site_details/plan_menos_preferido_razongroup_site_details/aplico_bonogroup_site_details/bono_aplicadogroup_site_details/problemas_bonogroup_site_details/descripcion_problemagroup_site_details/tienen_titulosCommentsgroup_sy6yd58/__2.1.a.1__no_of_householdsgroup_sy6yd58/__2.1.b.1__total_individualsgroup_sy6yd58/__2.1.b.2__male_totalgroup_sy6yd58/__2.1.b.3__female_totalgroup_sy6yd58/Comments_002grupo_etareo/lactantes_mgrupo_etareo/lactantes_fgrupo_etareo/total_bebes_lactantesgrupo_etareo/ninosgrupo_etareo/ninasgrupo_etareo/total_ninosgrupo_etareo/adolescentes_mgrupo_etareo/adolescentes_fgrupo_etareo/total_adolescentesgrupo_etareo/adultos_menor_mgrupo_etareo/adultos_menor_fgrupo_etareo/total_adultos_menorgrupo_etareo/adultos_mgrupo_etareo/adultos_fgrupo_etareo/total_adultosgrupo_etareo/adulto_mayor_mgrupo_etareo/adulto_mayor_fgrupo_etareo/total_adulto_mayorgroup_vulnerabilities/embarazadas_menoresgroup_vulnerabilities/embarazadas_mayoresgroup_vulnerabilities/total_embarazadasgroup_vulnerabilities/lactantes_menoresgroup_vulnerabilities/lactantes_mayoresgroup_vulnerabilities/total_mujeres_lactantesgroup_vulnerabilities/__2.2.g.2__no_of_men_w_physical_disabilitiesgroup_vulnerabilities/__2.2.g.3__no_of_women_w_physical_disabilitiesgroup_vulnerabilities/__2.2.g.2__no_of_ninos_w_physical_disabilitiesgroup_vulnerabilities/__2.2.g.3__no_of_ninas_w_physical_disabilitiesgroup_vulnerabilities/total_discapacidades_fisicasgroup_vulnerabilities/__2.2.h.2__no_of_hombres_w_mental_disabilitiesgroup_vulnerabilities/__2.2.h.3__no_of_mujeres_w_mental_disabilitiesgroup_vulnerabilities/__2.2.h.2__no_of_ninos_w_mental_disabilitiesgroup_vulnerabilities/__2.2.h.3__no_of_ninas_w_mental_disabilitiesgroup_vulnerabilities/total_discapacidades_mentalesgroup_vulnerabilities/__2.2.f.1__no_of_hombres_with_chronic_diseases_or_serious_medical_conditionsgroup_vulnerabilities/__2.2.f.1__no_of_mujeres_with_chronic_diseases_or_serious_medical_conditionsgroup_vulnerabilities/__2.2.f.1__no_of_ninos_with_chronic_diseases_or_serious_medical_conditionsgroup_vulnerabilities/__2.2.f.1__no_of_ninas_with_chronic_diseases_or_serious_medical_conditionsgroup_vulnerabilities/total_personas_enfermedades_cronicasgroup_vulnerabilities/__2.2.u.7__no_of_hombres_ethnic_minoritiesgroup_vulnerabilities/__2.2.u.8__no_of_mujeres_ethnic_minoritiesgroup_vulnerabilities/__2.2.u.7__no_of_ninos_ethnic_minoritiesgroup_vulnerabilities/__2.2.u.8__no_of_ninas_ethnic_minoritiesgroup_vulnerabilities/total_minorias_etnicasgroup_vulnerabilities/__2.2.x.5__no_of_elderly_persons_mengroup_vulnerabilities/__2.2.x.6__no_of_elderly_persons_womengroup_vulnerabilities/total_ancianosgroup_vulnerabilities/__2_2_x_3__number_of_unaccompanied_elderly_mengroup_vulnerabilities/__2_2_x_4__number_of_unaccompanied_elderly_womengroup_vulnerabilities/total_ancianos_sin_companiagroup_vulnerabilities/__2.2.i.5__no_of_unaccompanied_minors_boysgroup_vulnerabilities/__2.2.i.6__no_of_unaccompanied_minors_girlsgroup_vulnerabilities/total_menores_sin_companiagroup_vulnerabilities/__2.2.i.7__no_of_separated_minors_boysgroup_vulnerabilities/__2.2.i.8__no_of_separated_minors_girlsgroup_vulnerabilities/total_menores_separadosgroup_vulnerabilities/__2.2.i.9__no_of_orphan_minors_boysgroup_vulnerabilities/__2.2.i.10__no_of_orphan_minors_girlsgroup_vulnerabilities/total_menores_huerfanosgroup_vulnerabilities/__2.2.n.1__no_of_single_mothers_menoresgroup_vulnerabilities/__2.2.n.1__no_of_single_mothers_mayoresgroup_vulnerabilities/total_madres_solterasgroup_vulnerabilities/__2.2.o.1__no_of_single_fathers_menoresgroup_vulnerabilities/__2.2.o.1__no_of_single_fathers_mayoresgroup_vulnerabilities/total_padres_solterosgroup_vulnerabilities/__2.2.p.2__no_of_boys_headsofHHgroup_vulnerabilities/__2.2.p.3__no_of_girls_headsofHHgroup_vulnerabilities/total_menores_cabeza_hogargroup_vulnerabilities/Refugees_and_asylum_seekers_malegroup_vulnerabilities/Refugees_and_asylum_seekers_femalegroup_vulnerabilities/Refugees_and_asylum_seekers_ninogroup_vulnerabilities/Refugees_and_asylum_seekers_ninagroup_vulnerabilities/total_refugiadosgroup_mobility/__2.3_j_3__idps_living_in_place_of_displacementgroup_mobility/ss_2.3_j_3_ss_idps_living_in_place_of_displacement_specifygroup_mobility/identificacion_zonas_asentamientogroup_mobility/zonas_identificadasgroup_mobility/familias_asentamientogroup_mobility/ubicacion_familias/__2.3.e.2__admin_1group_mobility/ubicacion_familias/__2.3.e.3__admin_2group_mobility/ubicacion_familias/__2.3.e.4__admin_3group_NFI_Shelter/most_common_sheltergroup_NFI_Shelter/most_common_shelter_specifygroup_NFI_Shelter/material_techogroup_NFI_Shelter/material_techo_othergroup_NFI_Shelter/material_paredesgroup_NFI_Shelter/material_paredes_othergroup_NFI_Shelter/material_pisogroup_NFI_Shelter/material_piso_othergroup_NFI_Shelter/repair_materials_neededgroup_NFI_Shelter/repair_materials_needed_specifygroup_NFI_Shelter/temporary_housing_assistancegroup_NFI_Shelter/temporary_housing_assistance_specifygroup_NFI_Shelter/NFI_being_distributedgroup_NFI_Shelter/NFI_being_distributed_specifygroup_NFI_Shelter/most_distributed_NFIgroup_NFI_Shelter/most_distributed_NFI_specifygroup_NFI_Shelter/most_needed_NFIgroup_NFI_Shelter/most_needed_NFI/kits_cocinagroup_NFI_Shelter/most_needed_NFI/mosquiterosgroup_NFI_Shelter/most_needed_NFI/kits_higienegroup_NFI_Shelter/most_needed_NFI/kits_dignidadgroup_NFI_Shelter/most_needed_NFI/ropagroup_NFI_Shelter/most_needed_NFI/kits_herramientasgroup_NFI_Shelter/most_needed_NFI/otrogroup_NFI_Shelter/most_needed_NFI/ningunogroup_NFI_Shelter/most_needed_NFI_specifygroup_WASH/servicio_aguagroup_WASH/servicio_saneamientogroup_WASH/servicio_higienegroup_WASH/__4.1.a.1__water_source_locationgroup_WASH/ss_4.1.a.1_ss_water_source_location_specifygroup_WASH/water_storagegroup_WASH/water_storage_specifygroup_WASH/litros_tanquegroup_WASH/cantidad_tanquesgroup_WASH/drinking_water_quantitygroup_WASH/drinking_water_quantity_specifygroup_WASH/drinking_water_sourcegroup_WASH/drinking_water_source_specifiygroup_WASH/domestic_water_quantitygroup_WASH/domestic_water_quantity_specifygroup_WASH/domestic_water_sourcegroup_WASH/domestic_water_source_specifygroup_WASH/Inodoros_letrinasgroup_WASH/__4.4.a.1__functioning_toiletgroup_WASH/duchasgroup_WASH/duchas_funcionandogroup_WASH/__4.4.b.1__separate_toiletsgroup_WASH/ss_4.4.b.1_ss_separate_toilets_specifygroup_WASH/duchas_separadasgroup_WASH/ss_4.5.b.1_ss_separate_bathing_areas_specifygroup_WASH/letrinas_hombresgroup_WASH/letrinas_mujeresgroup_WASH/duchas_hombresgroup_WASH/duchas_mujeresgroup_WASH/__4_8_b_1__do_toilets_and_bathrooms_have_lgroup_WASH/ss_4_8_b_1_ss_do_toilets_and_bathrooms_have_lgroup_WASH/__4_5_j_1__do_bathing_areas_have_functionigroup_WASH/ss_4_5_j_1_ss_do_bathing_areas_have_functionigroup_WASH/lavamanosgroup_WASH/higiene_personalgroup_WASH/higiene_personal_especifiquegroup_WASH/__4_7_c_2___hygiene_materials_for_women_avgroup_WASH/ss_4_7_c_2_ss_hygiene_materials_for_women_avgroup_WASH/botes_basuragroup_WASH/botes_basura_expliquegroup_WASH/cuantos_botesgroup_WASH/frecuenciagroup_Food_nutrition/servicios_alimentaciongroup_Food_nutrition/Grupo_si_nutricion/__6.1.b.1__supplementary_feeding_mothergroup_Food_nutrition/Grupo_si_nutricion/ss_6.1.b.1_ss_supplementary_feeding_mother_specifygroup_Food_nutrition/Grupo_si_nutricion/supplementary_feeding_childrengroup_Food_nutrition/Grupo_si_nutricion/supplementary_feeding_children_specifygroup_Food_nutrition/Grupo_si_nutricion/frecuencia_suplemento_ninosgroup_Food_nutrition/Grupo_si_nutricion/alimentacion_especial_dietasgroup_Food_nutrition/Grupo_si_nutricion/alimentacion_especial_dietas_especifiquegroup_Food_nutrition/alimentacion_infantilgroup_Food_nutrition/alimentacion_infantil_specifygroup_Food_nutrition/comentarios_alimentaciongroup_Health/servicios_saludgroup_Health/__7.1.b.1__most_prevalent_health_problemgroup_Health/ss_7.1.b.1_ss_most_prevalent_health_problemgroup_Health/__7.1.b.2__second_most_prevalent_health_problemgroup_Health/ss_7.1.b.2_ss_second_most_prevalent_health_problemgroup_Health/ss_7.1.p.2_ss_number_of_people_treated_for_se_last_surv_malegroup_Health/ss_number_of_people_treated_for_se_last_surv_femalegroup_Health/ss_number_of_people_treated_for_se_last_surv_totalgroup_Health/__7.2.a.3__access_to_medicinegroup_Health/ss_7.2.a.3_ss_access_to_medicine_specifygroup_Health/hombres_mental_tratadogroup_Health/mujers_mental_tratadogroup_Health/total_mental_tratadogroup_Health/acceso_apoyo_psicosocialgroup_Health/acceso_apoyo_psicosocial_expliquegroup_Health/requiere_apoyo_psicosocialgroup_Health/requiere_apoyo_psicosocial_expliquegroup_Health/ninos_psicosocialgroup_Health/adolescentes_psicosocialgroup_Health/adultos_psicosocialgroup_Health/adultos_mayores_psicosocialgroup_Health/__7.2.b.1__location_health_facilitygroup_Health/ss_7.2.b.1_ss_location_health_facility_specifygroup_Health/disponibilidad_servicios_saludgroup_Health/__7.2.c.2__health_facilities_providergroup_Health/ss_7.2.c.2_ss_health_facilities_provider_othergroup_Health/ss_7.2.c.2_ss_health_facilities_provider_specifygroup_Health/vacunacioneducacion/__8.1.b.1__access_to_educationeducacion/ss_8.1.b.1_ss_access_to_education_specifyeducacion/group_education/__8.2.b.1__education_distanceeducacion/group_education/ss_8.2.b.1_ss_education_distance_specifyeducacion/group_education/porcentaje_escolareducacion/group_education/porcentaje_escolar_especifiqueeducacion/group_education/kit_escolareducacion/group_education/seguro_ir_escuelagroup_Livelihood/__9.1.a.5__majority_men_occupationgroup_Livelihood/ss_9.1.a.5_ss_majority_occupation_men_othergroup_Livelihood/ss_9.1.a.5_ss_majority_occupation_men_specifygroup_Livelihood/__9.1.a.6__majority_women_occupationgroup_Livelihood/ss_9.1.a.6_ss_majority_occupation_women_othergroup_Livelihood/ss_9.1.a.6_ss_majority_occupation_women_specifygroup_Livelihood/acceso_ingresosgroup_Livelihood/acceso_ingresos_expliquegroup_Livelihood/__9.2.h.2__with_source_of_incomegroup_Livelihood/__9.3.a.2__livestockgroup_Livelihood/ss_9.3.a.2_ss_livestock_specifygroup_Livelihood/__9.1.c.1__cultivationgroup_Livelihood/__9.1.c.1__cultivation_specifygroup_security/__10.1.a.2__security_availablegroup_security/ss_10.1.a.2_ss_security_available_specifygroup_security/__10.1.e.1__reported_incidentgroup_security/ss_10.1.e.1_ss_reported_incident_specify_typegroup_security/ss_10.1.e.1_ss_reported_incident_specifygroup_security/__10.1.b.1__security_providergroup_security/ss_10.1.b.1_ss_security_provider_specifygroup_security/presencia_organo_controlgroup_security/organos_controlgroup_security/organos_control/defensoriagroup_security/organos_control/fiscaliagroup_security/organos_control/consejogroup_security/organos_control/dinapengroup_security/organos_control/junta_cantonalgroup_security/organos_control/othergroup_security/organos_control_othergroup_security/sirvengroup_security/van_alberguesgroup_security/tenido_contactogroup_security/resuelven_casosgroup_security/__10_1_t_1__are_there_areas_women_and_girlgroup_security/ss_10_1_t_1_ss_are_there_areas_women_and_girl_whichgroup_security/ss_10_1_t_1_ss_are_there_areas_women_and_girl_othergroup_security/ss_10_1_t_1_ss_are_there_areas_women_and_girl_specifygroup_security/hay_proteccion_menoresgroup_security/__10_1_u_1__which_child_protection_servicegroup_security/ss_10_1_u_1_ss_which_child_protection_servicegroup_security/__10.1.c.1__child_friendly_spacegroup_security/__10.1.d.1__woman_friendly_spacegroup_security/__10.2.j.2__gbv_mechanismgroup_security/ss_10.2.j.2_ss_gbv_mechanism_specifygroup_security/mecanismos_violencia_menoresgroup_security/mecanismos_violencia_menores_especifiquegroup_security/ninos_sin_cuidado_dia_nochegroup_security/tiempo_libre_ninosgroup_security/tiempo_libre_ninos/trabajargroup_security/tiempo_libre_ninos/tareas_domesticasgroup_security/tiempo_libre_ninos/estudiargroup_security/tiempo_libre_ninos/ludicasgroup_security/tiempo_libre_ninos/tv_redesgroup_security/tiempo_libre_ninos/ningunagroup_security/tiempo_libre_adolescentesgroup_security/tiempo_libre_adolescentes/trabajargroup_security/tiempo_libre_adolescentes/tareas_domesticasgroup_security/tiempo_libre_adolescentes/estudiargroup_security/tiempo_libre_adolescentes/ludicasgroup_security/tiempo_libre_adolescentes/tv_redesgroup_security/tiempo_libre_adolescentes/actividades_no_positivasgroup_security/tiempo_libre_adolescentes/ningunagroup_security/ninos_escombreras_basurerosgroup_security/ninos_escombreras_basureros_especifiquegroup_security/__10.3.a.3__women_feel_unsafegroup_security/ss_10.3.a.3_ss_women_feel_unsafe_specifygroup_security/__10.3.a.1__men_feel_unsafegroup_security/ss_10.3.a.1_ss_men_feel_unsafe_specifygroup_security/__10.3.a.2__children_feel_unsafegroup_security/ss_10.3.a.2_ss_children_feel_unsafe_specifygroup_security/__10.2.n.1__relationship_idpgroup_security/ss_10.2.n.1_ss_relationship_idp_specifygroup_security/__10.2.o.1__relationship_idp_hostgroup_security/ss_10.2.o.1_ss_relationship_idp_host_specifygroup_security/alcohol_drogasgroup_security/alcohol_drogas_especifiquegroup_security/hay_gente_sin_IDgroup_security/__10_1_f_1__do_the_majority_of_people_have_numbergroup_security/ss_10_1_f_1_ss_do_the_majority_of_people_have_specifygroup_security/__10.1.s.1__adequate_lightinggroup_security/ss_10.1.s.1_ss_adequate_lighting_specifygroup_security/__10_2_d_1__what_are_the_types_of_problemsgroup_security/__10_2_d_1__what_are_the_types_of_problems/vivienda_temporalgroup_security/__10_2_d_1__what_are_the_types_of_problems/bienes_no_alimentariosgroup_security/__10_2_d_1__what_are_the_types_of_problems/agua_saneamiento_higienegroup_security/__10_2_d_1__what_are_the_types_of_problems/saludgroup_security/__10_2_d_1__what_are_the_types_of_problems/comidagroup_security/__10_2_d_1__what_are_the_types_of_problems/educaciongroup_security/__10_2_d_1__what_are_the_types_of_problems/medios_de_vidagroup_security/__10_2_d_1__what_are_the_types_of_problems/ningunogroup_security/__10_2_d_1__what_are_the_types_of_problems/no_sabegroup_security/__10_2_s_2__what_are_the_risk_factors_in_agroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/distanciagroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/diseñogroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/escombros_dañosgroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/falta_iluminaciongroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/falta_accesso_segregadogroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/seguridadgroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/discapacidadgroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/menor_edadgroup_security/__10_2_s_2__what_are_the_risk_factors_in_a/otrogroup_security/ss_10_2_s_2_ss_what_are_the_risk_factors_in_a_specifygroup_security/__10_2_s_3__are_there_constraints_barriersgroup_security/__10_2_s_3__are_there_constraints_barriers_nogroup_security/__10_2_s_3__are_there_constraints_barriers_no/distanciagroup_security/__10_2_s_3__are_there_constraints_barriers_no/diseñogroup_security/__10_2_s_3__are_there_constraints_barriers_no/escombros_dañosgroup_security/__10_2_s_3__are_there_constraints_barriers_no/falta_iluminaciongroup_security/__10_2_s_3__are_there_constraints_barriers_no/falta_accesso_segregadogroup_security/__10_2_s_3__are_there_constraints_barriers_no/seguridadgroup_security/__10_2_s_3__are_there_constraints_barriers_no/discapacidadgroup_security/__10_2_s_3__are_there_constraints_barriers_no/menor_edadgroup_security/__10_2_s_3__are_there_constraints_barriers_no/otrogroup_security/comments_003group_information/informacion_necesariagroup_information/__11.1.c.1__main_topicgroup_information/ss_11.1.c.1_ss_main_topic_othergroup_information/__11.1.c.1__main_topic_specifygroup_information/punto_informacion_alberguegroup_information/tipo_de_informacion_provistagroup_information/tipo_de_informacion_provista_othergroup_information/mecanismo_transmision_quejasgroup_information/a_quien_se_dirigen_quejasgroup_information/mecansimo_solucion_quejasgroup_information/casos_tratagroup_information/__11.3.a.1__travel_abroad_informationgroup_information/ss_11.3.a.1_ss_travel_abroad_information_specifygroup_information/__11.3.a.2__travel_abroad_information_yesgroup_information/que_se_prometio_en_el_viajegroup_information/ss_que_se_prometio_en_el_viajegroup_information/__11_3_a_5__how_are_travel_abroad_opportun__version__meta/instanceID_id_uuid_submission_time_index_parent_table_name_parent_index_tags_notesProvinciaCantonParroquia


IOM DTM Somalia - Site Assessment Data


File: IOM_SOM_DTM_Master_Data_Site_Assessments_Final_Rou...XLS
 


Nigeria - IOM DTM Dataset (June 2016) - Site assessment data

File: rd10_DTM_Master_List_Jun2016.xlsx

This is at an aggregated level and has just one sheet "Sheet1" with a single line header:


LGAWARDSTATUSLATITUDELONGITUDESITE MANAGEMENT AGENCY (SMA)SMA TYPEREGISTRATION ACTIVITYSUPPORT WASHSUPPORT HEALTHSUPPORT SHELTER/NFISUPPORT FOODSUPPORT PROTECTIONSUPPORT EDUCATIONSUPPORT LIVELIHOODSITE CLASSIFICATIONSITE TYPELAND OWNERSHIPCOMMON SHELTER TYPENO OF HOUSEHOLDSINFANTS MALEINFANTS FEMALECHILDREN MALECHILDREN FEMALEYOUTH MALEYOUTH FEMALEADULT MALEADULT FEMALEELDERLY MALEELDERLY FEMALETOTAL NUMBER OF IDPSPREVIOUSLY BEEN DISPLACEDINTENDED RETURN AREAWHY NOT RETURNNO SHELTERTENTSMAKESHIFTINDOORSACCESS ELECTRICITYACCESS SAFE COOKINGHAVE PRIVATE AREASHAVE MOSQUITO NETSMOST NEEDED NFIWATER SOURCE LOCATIONDRINKING WATER SOURCEWATER CONSUMPTIONDRINKING WATER POTABLEDRINKING WATER QUALITY COMPLAINTSLATRINE CONDITIONFUNCTIONING TOILETGARBAGE DISPOSALSOLID WASTE PROBLEMHAND WASHING STATIONSHYGIENE PROMOTION CAMPAIGNOPEN DEFECATIONACCESS TO FOODACCESS TO MARKETDISTRIBUTION FREQUENCYOBTAINING FOODMALNUTRITION SCREENINGMOST PREVALENT HEALTH PROBLEMACCESS TO MEDICINEACCESS TO HEALTH FACILITYLOCATION HEALTH FACILITYHEALTH FACILITIES PROVIDERACCESS TO EDUCATIONEDUCATION LOCATIONATTENDING SCHOOLMAJORITY OCCUPATIONACCESS TO INCOMELIVESTOCKCULTIVATION



Haiti - IOM DTM Dataset (June 2016) - Site assessment data

File: rd25_DTM_Master_List_Mar2016.xlsx


Conclusion

Given the lack of any consistency between the DTM Master List spreadsheets, writing a one size fits all automated data checker and cleaner for all of them is challenging. It would involve placing a great deal of "intelligence" into the cleaning program with the possibility that errors are introduced during cleaning for example, by accidentally matching the wrong column heading when making an algorithm to match a very diverse range of names. It may be possible to write cleaners per country but the effort involved would be large.

A better approach is to try to encourage the different offices to use a similar template for their spreadsheets, as from this starting point, writing a cleaner would not be too onerous. If such a template were introduced, it could be HXLated from day one. How easy it would be to invent a template that covers the range of needs is debatable but it is likely to be much easier than trying to process greatly varying spreadsheet formats.

Appendix: IOM Global DTM information

The following files contain a data dictionary and partial sample for the in-progress global DTM, as supplied by IOM in Geneva.

This Google Sheet contains proposed HXL hashtags for the global DTM: https://docs.google.com/spreadsheets/d/1gifTnrz9A2fZ8Tuwg-EClsFvu4QEbC4OUtdgb61dXGs/edit?usp=sharing 

  • No labels