<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Very many thanks to Claudia Capitani and Mike Shand for their quick and helpful replies; question resolved, and I expect this’ll be useful for others too.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>All the best –<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Nick.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><b><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Claudia Capitani [mailto:claudia.capitani@gmail.com] <br><b>Sent:</b> 04 November 2015 17:18<br><b>To:</b> Nick McWilliam (MapAction) <nmcwilliam@mapaction.org>; Tanzania GIS Users Group Discussion <tzgisug@lists.habari.co.tz><br><b>Subject:</b> Re: [TZGISUG] 2012 ward-level census data joined to ward shapefiles?<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Dear Nick,<o:p></o:p></p><div><p class=MsoNormal>you are right, there's no unique code and names are repeated and spelt differently in vectors and published result table.<o:p></o:p></p></div><div><p class=MsoNormal>It took me a lot of effort, and manual checking to do it.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I even adjusted the raster layer from World pop so that it represents the total population 2012 following the data distribution of the wards. Since the Worldpop and the Wards shape have different borders (some part of Rufiji delta are not mapped in the vectors for example), I kept the Worldpop pixel as they were and I redistributed the population according to the nearest ward when pixel were not covered by the ward. This also took a while and manual checking, probably I missed something but it is quite good.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>You can find everything at my dropbox folder. My only request is if you find any mistake, please let me know, any help in refining this is very welcome.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><a href="https://www.dropbox.com/sh/2yvhsl6mojq3byg/AABOo9h1kgB19VJ1F0ZWdc2fa?dl=0&s=so">https://www.dropbox.com/sh/2yvhsl6mojq3byg/AABOo9h1kgB19VJ1F0ZWdc2fa?dl=0&s=so</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Best wishes,<o:p></o:p></p></div><div><p class=MsoNormal>Claudia<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>2015-11-04 15:35 GMT+00:00 Nick McWilliam (MapAction) via TZGISUG <<a href="mailto:tzgisug@lists.habari.co.tz" target="_blank">tzgisug@lists.habari.co.tz</a>>:<o:p></o:p></p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Dear All – <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> I’m doing s<span style='color:#1F497D'>o</span>me mapping for Red Cross, who are helping in the response to the ongoing cholera outbreak.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> I wondered if anyone might already have joined the 2012 census results to the <a href="http://www.nbs.go.tz/nbstz/index.php/english/statistics-by-subject/population-and-housing-census" target="_blank">NBS ward shapefile</a> please? Is this available? It’s not a simple join, as the census data aren’t geocoded, and some ward names are repeated in different regions, so I didn’t want to re-do the work if it’s already done.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> Also, I wondered if anyone knows of geocoded school locations please?<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> For health facilities, I’m looking at: <a href="http://opendata.go.tz/dataset/list-of-health-facilities-with-geographical-location" target="_blank">http://opendata.go.tz/dataset/list-of-health-facilities-with-geographical-location</a><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> Many thanks,<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Nick.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <span style='font-size:9.0pt;color:#7F7F7F'><a href="mailto:nmcwilliam@mapaction.org" target="_blank">nmcwilliam@mapaction.org</a> | <a href="tel:%2B44%20%280%2977%207379%207471" target="_blank">+44 (0)77 7379 7471</a> | skype nickmcw</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div></div><p class=MsoNormal><br>_______________________________________<br>TZGISUG mailing list <a href="mailto:TZGISUG@lists.habari.co.tz">TZGISUG@lists.habari.co.tz</a><br>List Info: <a href="http://mail.habari.co.tz/mailman/listinfo/tzgisug" target="_blank">http://mail.habari.co.tz/mailman/listinfo/tzgisug</a><br>Web Site: <a href="http://www.tzgisug.org" target="_blank">http://www.tzgisug.org</a><br>Facebook: <a href="https://www.facebook.com/tzgisug" target="_blank">https://www.facebook.com/tzgisug</a><o:p></o:p></p></blockquote></div><p class=MsoNormal><o:p> </o:p></p></div></div></body></html>