<html><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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1723862509;
mso-list-type:hybrid;
mso-list-template-ids:-1743475488 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1
{mso-list-id:2003507492;
mso-list-type:hybrid;
mso-list-template-ids:-1727513058 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style></head><body bgcolor="white" lang="EN-US" link="blue" vlink="purple"><div class="WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi All,</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I would just like to close this post and mark as complete / solved.</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Myself, Gavin and Zoltan discussed the sg diagram off-list and with the help of both Gavin and Zoltan we managed to find a solution.</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoListParagraph" style><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span style>1.<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">The SG diagram in question was not in feet but in meters, I misread a 3 for a 9 (stupid mistake but it comes with using scanned and printed documents)</span></p><p class="MsoListParagraph" style><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span style>2.<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">The contstants were added to the XY locations before importing the data into QGIS</span></p><p class="MsoListParagraph" style><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span style>3.<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">The correct projection to load the data into QGIS was EPSG 22279 Cape / Lo19 (<a href="http://epsg.io/22279">http://epsg.io/22279</a>)</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">The workflow that worked for me was as follows</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoListParagraph" style><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span style>1.<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Copy the coordinates into a spreadsheet remembering to add the specified constant to each coordinate (check the constant values carefully – this can cause major headaches if you don’t get it right)</span></p><p class="MsoListParagraph" style><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span style>2.<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Import into QGIS using the delimited text file import.</span></p><p class="MsoListParagraph" style><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span style>3.<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Keep X and Y the same (Don’t swop the axes)</span></p><p class="MsoListParagraph" style><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span style>4.<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Once the layer has been imported assign the correct projection to the layer (EPSG 22279)</span></p><p class="MsoListParagraph" style><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span style>5.<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Assign the project projection to the same EPSG code (22279) – Cape Lo19</span></p><p class="MsoListParagraph" style><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span style>6.<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">The points should now map to the correct locations</span></p><p class="MsoListParagraph" style><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><span style>7.<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I then re-projected to WGS84 </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Many thanks to all who offered advice and support, especially Zoltan Szecsei and Gavin Fleming.</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Just to note that there were extensive discussions regarding north and south orientation of the Lo system and how this is represented / handled by QGIS. I have avoided mentioning this here as a “ticket” has been opened on the qgis-dev mailing list. </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Regards,</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Wesley</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><div><div style="border:none;border-bottom:solid windowtext 1.5pt;padding:0in 0in 1.0pt 0in"><p class="MsoNormal" style="border:none;padding:0in"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><img border="0" width="334" height="103" id="Picture_x0020_1" src="cid:image001.jpg@01CFE222.C8E9E190" alt="Email_Signature"></span></p></div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Wesley Roberts, PhD</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Geospatial Manager</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Biocarbon Partners</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><a href="mailto:wesley@biocarbonpartners.com"><span style="color:#0563c1">wesley@biocarbonpartners.com</span></a></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Cell RSA: +27 83 5355 646</span></p></div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><div><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext"> <a href="mailto:africa-bounces@lists.osgeo.org">africa-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:africa-bounces@lists.osgeo.org">africa-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Gavin Fleming<br><b>Sent:</b> Tuesday, September 30, 2014 9:48 AM<br><b>To:</b> <a href="mailto:africa@lists.osgeo.org">africa@lists.osgeo.org</a><br><b>Subject:</b> Re: [OSGeo Africa] Surveyor General Diagram - Mapping property boundary points</span></p></div></div><p class="MsoNormal"> </p><div><p class="MsoNormal">Wesley, send your point text file (or SG 21 chr code) to the list with some context of where it should be drawing; the list will also accept images such as a scan of the SG diagram. <br><br>On 30/09/2014 09:36, Dr Wesley Roberts wrote:</p></div><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi All,</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I am so close now. I have taken both Gavin’s and Zoltan’s advice and used the custom CRS definition using the precision conversion factor suggested by Zoltan.</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I am able to view the coordinate points in QGIS and can see that they are almost in the correct location, however, there appears to be some sort of transformation error. The best way to describe the error is to imagine points as a rectangle lying at a 45 degree angle. With the current CRS setup the points which should be at the top are now at the bottom and the points at the bottom are at the top. Difficult to explain without a graphic and I doubt that the mailing list will accept graphics in images. The points need to be rotated 180 degrees through the vertical, if that makes any sense.</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I can mail a grphic off list should this not make sense.</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Many thanks,</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Wesley</span></p><p class="MsoNormal"> </p><p class="MsoNormal" align="center" style="text-align:center">Gavin Fleming</p><p class="MsoNormal" align="center" style="text-align:center">Visit <a href="http://kartoza.com/" target="_blank">http://kartoza.com</a> to find out about open source:<br>* Desktop GIS programming services<br>* Geospatial web development</p><p class="MsoNormal" align="center" style="text-align:center">* GIS Training</p><p class="MsoNormal" align="center" style="text-align:center">* Consulting Services</p><div><p class="MsoNormal" align="center" style="text-align:center">Skype: phlemingo</p></div><div><p class="MsoNormal" align="center" style="text-align:center">-------------------------------------------------------------------------------------------</p><p class="MsoNormal" align="center" style="text-align:center">Kartoza = Linfiniti <span style="font-family:"Cambria Math","serif"">∪</span> Afrispatial</p></div></div></blockquote></div></body></html>