The DHS Program User Forum: Geographic Data » Import GPS Data

Home » Data » Geographic Data » Import GPS Data - Manuals

Show: Today's Messages :: Show Polls :: Message Navigator

Import GPS Data - Manuals [message #1528]

Mon, 10 March 2014 10:06

amira.elshal.1@city.ac.uk is currently offline

amira.elshal.1@city.ac.uk
Messages: 52
Registered: April 2013

Senior Member

Dear Sirs,

I have got the GPS data for Egypt and the QGIS program, but I do not know how to import the GPS data points into the QGIS to spatially join the displaced cluster locations to GIS polygon data of the district boundaries. Are there any manuals for that?

N.B. I am using data from Egypt DHS 2000 and 2008.

Thank you.

Amira

Report message to a moderator

Re: Import GPS Data - Manuals [message #1532 is a reply to message #1528]

Mon, 10 March 2014 14:32

Josh-DHS
Messages: 19
Registered: November 2013

Member

Dear Amira,

Thanks for your post. The DHS GPS datasets are in shapefile format so you can import them into QGIS by clicking on the Add Vector Layer tool and browsing to the location of the file on your computer. You can do a spatial join in QGIS by going to the Vector menu and, under Data Management Tools, selecting Join Attributes by Location.

The DHS Program has a QGIS Training Curriculum manual that can be downloaded for free from our Spatial Data Repository website. Follow this link and click on the document name in the GIS Tools window in order to download it http://spatialdata.dhsprogram.com/resources.html. QGIS Exercise 3 includes instructions on how to do a spatial join. Note that the curriculum is in a large zipped folder and so may take some time to download. Also, note that the curriculum was designed for QGIS version 1.8.0. A 2.0.1 version of QGIS has recently been released so we are currently updating the curriculum for the new version and will make it available in the next few months.

If this has not answered your question adequately, please reply.

Josh

Report message to a moderator

Re: Import GPS Data - Manuals [message #1541 is a reply to message #1532]

Tue, 11 March 2014 05:35

amira.elshal.1@city.ac.uk
Messages: 52
Registered: April 2013

Senior Member

Hello Josh,

I cannot thank you enough for your kind assistance. I will let you know should I require further help.

Sincerely,
Amira

Report message to a moderator

Re: Import GPS Data - Manuals [message #1596 is a reply to message #1541]

Sun, 16 March 2014 09:22

amira.elshal.1@city.ac.uk
Messages: 52
Registered: April 2013

Senior Member

Dear Josh,

As I understand, I have to (1) join the woman to the GPS data via the cluster variable (v001 in the individual recode file and DHSCLUST in the GPS data) before (2) importing it into your QGIS to carry out the spatial join.

I now know how to import data to and use QGIS, but I do not know how to first join the woman to the GPS data. I identified v001 in my .dta individual recode file and the DHSCLUST in the GPS file but I fail to join them.

Please advise.

Thank you.

Amira

Report message to a moderator

Re: Import GPS Data - Manuals [message #1625 is a reply to message #1596]

Wed, 19 March 2014 10:24

Josh-DHS
Messages: 19
Registered: November 2013

Member

Dear Amira,

You could try doing it in the reverse order by doing the spatial join first. This will create a second point shapefile. In the attribute table of the layer, there will be a column giving the district name for each cluster. You can then export the attribute table to an Excel file or whatever program you are using to do your analysis. Then you can merge the district classification to the individual women in the individual recode file based on the v001 and DHSCLUST variables. For tips on how to set up the merge, please refer to http://www.dhsprogram.com/data/Merging-Datasets.cfm#CP_JUMP_ 8052.

If this has not answered your question adequately, please reply.

Josh

Report message to a moderator

Re: Import GPS Data - Manuals [message #2215 is a reply to message #1625]

Wed, 28 May 2014 05:02

amira.elshal.1@city.ac.uk
Messages: 52
Registered: April 2013

Senior Member

Dear Josh,

When I spatially join Egypt's DHS 2000 points data layer to Egypt's districts polygon data layer in QGIS 2.2, which encoding shall I use? Big5 or UTF-8?

Thank you.

Sincerely yours,
Amira

Report message to a moderator

Re: Import GPS Data - Manuals [message #2217 is a reply to message #2215]

Wed, 28 May 2014 05:33

amira.elshal.1@city.ac.uk
Messages: 52
Registered: April 2013

Senior Member

Dear Josh,

I have added the vector layers of both Egypt's DHS GPS points and Egypt's polygons (district boundaries). I used the UTF-8 encoding. Whenever I attempt to join attributes by location, the following message appears "Input layers have non-matching CRS". However, when I check the CRS of both layers, I found it the same (EPSG:4326 - WGS 84).

Please advise.

Thank you.

Sincerely yours,
Amira

Report message to a moderator

Re: Import GPS Data - Manuals [message #2220 is a reply to message #2217]

Thu, 29 May 2014 08:04

amira.elshal.1@city.ac.uk
Messages: 52
Registered: April 2013

Senior Member

I have also tried to reproject one of the layers to a new shapefile, and specify to save in the CRS of the other.

I could not save the DHS GPS women's locations to a new layer, using the CRS of Egypt's administrative districts boundaries, because I do not know the CRS of the boundaries. No *.prj file is there and I do not have access to the supplier in the meantime. I just know the CRS of the DHS women's locations. Therefore, I tried to save the boundaries to the CRS of the interview locations then do the spatial join, but it did not work either.

Looking forward to your reply.

Sincerely yours,
Amira

Report message to a moderator

Re: Import GPS Data - Manuals [message #2224 is a reply to message #2220]

Thu, 29 May 2014 16:39

Josh-DHS
Messages: 19
Registered: November 2013

Member

Dear Amira,

I suggest that you try to doing the spatial join using a different districts shapefile that comes with a .prj file. The resources page of The DHS Program's Spatial Data Repository has links to possible sources of shapefiles http://spatialdata.dhsprogram.com/resources.html (for example, this webpage has shapefiles of Egypt's district boundaries https://www.humanitarianresponse.info/operations/egypt/datas et/egypt-admin-level-1-boundaries-admin-level-2-boundaries-a dmin-level-3).

If this has not answered your question adequately, please reply.

Josh

Report message to a moderator

Re: Import GPS Data - Manuals [message #2341 is a reply to message #2224]

Thu, 05 June 2014 05:32

amira.elshal.1@city.ac.uk
Messages: 52
Registered: April 2013

Senior Member

Dear Josh,

I did it :-) I have finally been able to merge both shapefiles. I cannot thank you enough for your assistance.

One more question if you please: what is the minimum number of observations required to calculate a child (or maternal) health indicator such as Measles (MCV) immunization coverage among 1-year-olds (MIC)(%), children aged <5 years with ARI symptoms taken to facility (%), etc at the district level?

I need to collapse Egypt DHS individual recode data at the district level, then calculate some child (or maternal) health indicators. The problem is that some districts have got 15 observations only.

Thank you.

Sincerely,
Amira

Report message to a moderator