The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Data » Geographic Data » A general approach to merge GPS and Individual Data
A general approach to merge GPS and Individual Data [message #9316] Wed, 09 March 2016 13:02 Go to next message
Doon is currently offline  Doon
Messages: 1
Registered: March 2016
Member
I am doing an analysis that requires geographic information. I downloaded the GPS, Individual Recode, and Men Recode for all sub-Saharan African countries when available. I have a file of all individual recodes for different countries and phases, all appended and a separate shapefile with all the available GPS files merged. I have a question regarding the approach I need to use to merge the geographic information to the individual files.

In the geographic files, the identifier is of the form:

I use the case of Liberia, phase 5 as an example (File LBGE5CFL.shp)

Survey = Two letter country code + Year , ex: LB2009
Cluster = Cluster number, ex: 1
=> I thought a unique identifier would be of the form LB2009_1

However, it is not easy to match such information with the individual recode file.
There are 2 Stata files that can be downloaded: (LBIR51FL and LBIR5AFL)They both have the country code LB5, although they run for years 2007 to 2009. My question is then: are they run in the same villages, meaning that I can merge all the clusters in these files with those in LBGE5CFL.shp, or can I just only merge the subsample of the individual recode that were collected in 2009?

In other words,
What is the best way for me to create a unique identifier in the appended file of *all* the individual recodes in sub-Saharan Africa that I'll manage to merge correctly with the GPS files, provided that phase of the DHS collected GPS information?

Re: A general approach to merge GPS and Individual Data [message #12393 is a reply to message #9316] Tue, 09 May 2017 08:03 Go to previous message
Yonemese is currently offline  Yonemese
Messages: 2
Registered: May 2017
Member
I have the same problem. You found a solution? I will very much appreciate help here.



Best,

Yonemese
Previous Topic: Uganda 1995_DHS identifying district and county
Next Topic: Global identifier between BR and GPS shapefiles
Goto Forum:
  


Current Time: Thu Jun 21 06:37:13 Eastern Daylight Time 2018