<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=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@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;}
@font-face
{font-family:"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0mm;
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.17
{mso-style-type:personal-reply;
font-family:"Arial",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Arial",sans-serif;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:99.25pt 30.0mm 30.0mm 30.0mm;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1947957891;
mso-list-template-ids:-2000629874;}
ol
{margin-bottom:0mm;}
ul
{margin-bottom:0mm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026">
<v:textbox inset="5.85pt,.7pt,5.85pt,.7pt" />
</o:shapedefaults></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=JA link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Dear Mr. Gitau,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Thank you very much.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>It works now.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Best regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Maruyama<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'><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'> John Gitau [mailto:John.Gitau@unhabitat.org] <br><b>Sent:</b> Thursday, October 6, 2016 4:11 PM<br><b>To:</b> maruyama <idi05@idi.or.jp><br><b>Cc:</b> stdm-user@lists.osgeo.org<br><b>Subject:</b> Re: [STDM-user] help: STDM stops when I try to set up "New Social Tenure relationship"<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><div><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>Dear Maruyama,<o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>The issue is common in lower versions of PostgreSQL, specifically with regard to how geometry data is transported from PostgreSQL to QGIS/STDM.<o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>You will need to change one PostgreSQL setting in order to resolve the issue, the steps are as follows:<o:p></o:p></span></p></div><div><ol start=1 type=1><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>Browse to your PostgreSQL installation in Windows i.e <i>C:\Program Files\PostgreSQL\9.x</i> where x is the minor version of PostgreSQL. <o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>Open the <i>data</i> folder and locate the file named <i>postgresql.conf</i>. Open this file using any text editor such as Notepad.<o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>Scroll down til you find the following entry <i>#bytea_output = 'hex'.</i><o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>Delete the pound sign (#) before <i>bytea_output</i> and replace <i>hex</i> with <i>escape</i> (ensure <i>escape</i> is enclosed by single quotes). Hence, the resulting line should read <b><i>bytea_output = 'escape'</i></b><o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>Save the file and close.<o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>Click on the Windows Start button and click on <i>Run...</i><o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>In the Run dialog, type <i>services.msc</i> in order to load the list of currently installed Windows services.<o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>Scroll down til you locate <i>postgresql-9.x</i> (where <i>x</i> is the PostgreSQL minor version). Right click on this item and select <i>Restart</i>.<o:p></o:p></span></li><li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1'><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>Once the PostgreSQL service has successfully restarted, restart QGIS and create the social tenure relationship. It should now work as expected.<o:p></o:p></span></li></ol><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>Regards,</span><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'><o:p> </o:p></span></p></div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>John Gitau<br>Land and GLTN Unit, Urban Legislation, Land and Governance Branch | UN-HABITAT</span><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'><o:p></o:p></span></p><div><div><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>NOF Block 3 Level 3 South Wing I </span><span lang=EN-US style='font-family:"Verdana",sans-serif'>P.O. Box 30030-00100 Nairobi, Kenya</span><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Verdana",sans-serif'>Tel: + 254 20 762 3032 | +254 (0)722 945 556<br>Website:<a href="http://www.unhabitat.org" target=blank>www</a><a href="http://www.unhabitat.org" target=blank>.unhabitat.org</a> | Partners' website:<a href="http://www.gltn.net" target=blank>www</a><a href="http://www.gltn.net" target=blank>.gltn.net</a></span><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'><o:p></o:p></span></p></div></div></div><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'><br><br><span style='color:#990099'>-----"STDM-user" <<a href="mailto:stdm-user-bounces@lists.osgeo.org">stdm-user-bounces@lists.osgeo.org</a>> wrote: -----</span><o:p></o:p></span></p><div><div style='border:none;border-left:solid black 1.5pt;padding:0mm 0mm 0mm 4.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'>To: <<a href="mailto:stdm-user@lists.osgeo.org">stdm-user@lists.osgeo.org</a>><br>From: "maruyama" <br>Sent by: "STDM-user" <br>Date: 10/06/2016 08:38AM<br>Subject: [STDM-user] help: STDM stops when I try to set up "New Social Tenure relationship"<o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'>Dear All,</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'> </span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'>I have just installed STDM 1.1 with QGIS 2.8.3. I encountered the following problem.</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'>OS I am using is Windows 10 pro</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'> </span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'>When I came to set up “NEW Social Tenure Relationship” in page 67 of the STDM user manual, inputting “WABALE” worked properly.</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'>But after that , when I put “1000” for “Select the land or building information”, the message in the attached file appeared.</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'> </span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'>Before I came to this part, I imported “sample data.shp”. Because if not, nothing happen when I put anything at step 7 in page 67.</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'> </span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'>I look forward to having any help from you.</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'> </span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'>With best regards,</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'> </span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'>Maruyama</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'> </span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'> </span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-size:10.0pt'> </span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-family:"Courier New"'>_______________________________________________<br>STDM-user mailing list<br><a href="mailto:STDM-user@lists.osgeo.org">STDM-user@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/stdm-user">http://lists.osgeo.org/mailman/listinfo/stdm-user</a></span><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'><o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Verdana",sans-serif'><br><br>[attachment "NEWsocial.png" removed by John Gitau/UNHABITAT/NBO/UNO]<o:p></o:p></span></p></div></div></body></html>