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 9 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 a survey rather than site assessment - need clarification. There are 3 sheets with the main one "uploaded_form_izr7j1" containing the header:

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

This appears to be a survey rather than a site assessment - need clarification. There is one sheet with a two line header:


A. Survey DetailsB. Site/Settlement Area DetailsC. Population Demographics (Best Estimate Number of)D. Persons with Special Vulnerabilities (Best estimate number of)E. MobilityF. Shelter and Non Food Items (NFI)G. Water, Sanitation and HygieneH. Food and NutritionI. HealthJ. EducationK. LivelihoodL. Protection of Child, Women, and other Vulnerable PersonsM. Communication









Verified byDate of verificationDatabase input by?Date of inputSurvey date dd mm yyyyEnumerator name person filling out the form?Survey roundSex of enumeratorSite nameSite RegionSite DistrictVillage/TownSite_SSIDSite GPS longitudeSite GPS latitudeIs there a site management committee (SMC) in the site?If No AnswerIs the site management committee (SMC) made up from the community at the site?If No AnswerSMC member name or focal pointSMC member phone numberIs there a site management agency at the siteIf No AnswerSite classificationType of organization managing the siteIf No AnswerType of SiteIf Other SpeciyName of SMASMA member name or focal pointSMA member phone numberSite start open date dd_mm_yyyySite expected closing dateClosing date dd_mm_yyyyIs there any registration activity?If No AnswerIs there a service provider contact list?If No AnswerAccessibility to site?Estimated area of camp per meter?Ownership of land of site?What is the most common type of Shelter?If Other SpeciyIs WASH support being provided at the site?If No AnswerIs HEALTH support being provided at the site?If No AnswerIs SHELTER/NFI support provided at the site?If No AnswerIs FOOD support provided at the site?If No AnswerIs PROTECTION support provided at the site?If No AnswerIs EDUCATION support provided at the site?If No AnswerIs LIVELIHOOD support being provided at the site?If No AnswerPlace of origin of the largest IDP group in camp (Region)Place of origin of the largest IDP group in camp (District)Place of origin of the largest IDP group in camp (Village/Town)Place of origin of the second largest IDP group in camp (Settlement)Place of origin of the second largest IDP group in camp (Region)Place of origin of the second largest IDP group in camp (District)Place of origin of the second largest IDP group in camp (Village/Town)Place of origin of the second largest IDP group in camp (Settlement)Total number of IDP families/HHNumber of males by age less than one year?Number of males by age 1-5 years?Number of males by age 6-17 years?Number of males by age 18 -59 years?Number of males by age over 60 years?Total number of IDP Male individuals?Number of females by age less than one year?Number of females by age 1-5 years?Number of females by age 6-17 years?Number of females by age 18 -59 years?Number of females by age over 60 years?Total number of IDP Female individuals?Number of individuals by age, less than one year?Number of individuals by age 1-5 years?Number of individuals by age 6-17 years?Number of individuals by age 18-59 years?Number of individuals by age over 60 years?Total number of IDP individuaLS?Number of pregnant women?Number of unaccompanied child?Number of breastfeeding mothers?Number of orphaned children?Number of persons with physical Disabilities?Number of single Female headed-households?Number of persons with Mental Disabilities?Number of single Male-headed households?Number of unaccompanied elderly persons?Number of child-headed households?Number of persons with Chronic Diseases or Serious Medical conditions?Date of arrival of first IDP groupHave IDPs previously been displaced?If No AnswerDate of arrival of last IDP groupArea of intended return for largest IDP group?If No AnswerRegion of intended area of return for largest group of IDPs?District of intended area of return for largest group of IDPs?Village/Town of intended area of return for largest group of IDPs?Settlement of intended area of return for largest group of IDPs?Area of intended relocation plan for largest group of IDPs?If No AnswerName the relocation site (new camp)Estimated percentage of IDPs sleeping in the siteWhat is preventing the largest IDP group from returning home?If No AnswerPercentage of HH living outside (no shelter)Percentage of HH living in tents?Percentage of HH living in makeshift/self-made shelter?Percentage of HH living indoorS (Solid walls)Percentage of HH with access to electricity (solar generator)Percentage of HH with access to safe cooking facilities?Percentage of HH with private houses (living area)Percentage of HH with mosquito nets?Most needed type of NFIIf Other, SpecifySecond most needed type of NFIIf Other, SpecifyThird most needed type of NFIIf Other, SpecifyIs there a need for shelter repair materials?If No AnswerLocation of site's main water source (walking, one-way)If No AnswerHave water points (hand-pump, piped,...)been improvedIf No AnswerHow operational are they?If No AnswerMain non drinking water source provided or availableIf Other specifyWhat is the main drinking water source provided or availableIf Other specifyAverage amount of water available per day and per personIf No AnswerIs the drinking water potable?If No AnswerWhat is the problem with the water?If Other, SpecifyComplaints about drinking water quality?If No AnswerCondition of most of the latrinesIf No AnswerNumber of functioning toilets available on-siteAvailability of separate male and female toilets?If No AnswerGarbage disposal type?If No AnswerAvailability of separate male and female bathing areas?If No AnswerDo toilets and bathrooms have locks from the inside?If No AnswerNumber of garbage disposals pointsSolid waste/garbage problem at the site?If No AnswerAvailability of hand washing station filed in with water and soap close to toilets?If No AnswerEvidence of hand washing practicesIf No AnswerHygiene promotion campaign?If No AnswerEvidence of open defecation?If No AnswerIs there access to food (distribution, vouchers, trade, fishing..)If No AnswerIs there access to a market near from the site?If No AnswerFrequency of food (or cash/vouchers) distributionIf No AnswerMost common source for obtaining foodIf Other, SpecifyScreening for malnutrition conducted in the area? (i.e weight, height, mid-upper arm circumference screening)If No AnswerAvailability of supplementary feeding for pregnant and lactating mothersIf No AnswerAvailability of supplementary feeding for childrenIf No AnswerWhat is the most prevalent health problem at the siteIf Other, SpecifyWhat is the second most prevalent health problem at the siteIf Other, SpecifyWhat is the third most prevalent health problem at the siteIf Other, SpecifyIs std (sexually transmitted diseases) a concern on this site?Regular access to medicine?If No AnswerAccess to health facilities?If No AnswerLocation of health facilities/servicesIf No AnswerWho provides health facilities/servicesIf Other, SpecifyAccess to formal/informal education facilities/services for children from displaced HHs.If No AnswerLocation of formal/informal education facilities/services for children from displaced HHs.If No AnswerDistance to nearest education facilityIf No AnswerPercentage of the children at the site attending schoolOccupation/trade of majority of displaced HH (Copying mechanism)If Other, SpecifyNumber of HH in the site with a source of incomeAccess to income generating activities If No AnswerIs there livestock on site?If No AnswerDo IDPs have access to land for cultivation?If No AnswerIs there security on site/settlement areas?Security incidents are reported on site?Who provides main security in the site?Most common type of security incidents reported/known occuring in the settlement area?Most common type of GBV incidents reported/known occuring in the settlement area?Most common type of harmful traditional practices reported/known occuring in the settlement area?Most common type of child protection incidents reported/known occuring in the settlement area?Most reported problem in receiving support?Number of children friendly spacesNumber of women friendly spacesDo the majority of people have identification card or other documentation?Reporting/referral mechanism for GBV survivorsDo women feel safe at the settlement area?Do men feel safe at the settlement area?Do children feel safe at the settlement area?How is relationship amongst IDPs?How is relationship between IDPs and host communityIs there adequate lighting in the majority of communal point (WASH facilities, public spaces…)Where do residents mostly get their information from?If No AnswerWhat is the main topic on which the community is requesting information on?If Other, SpecifyIs travel abroad opportunities are being discussed/advertised within the community?If No AnswerIf Yes, Specify Countrymeta/instanceID_id_uuid_submission_time_index_parent_table_name_parent_index_tags_notesComments



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