<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)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 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;}
/* 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.apple-converted-space
{mso-style-name:apple-converted-space;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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-ZA" 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">Hi,<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">I would do it in PostGIS as a first choice by finding the appropriate function.<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">In QGIS I guess one needs to use the intersection tool and then load the result into a spreadsheet and do a pivot table per ward<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"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Regards
<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>
<div>
<p class="MsoNormal"><b><span lang="EN-AU" style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#C75B12">Arthur Taute |
</span></b><span lang="EN-AU" style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#C75B12">Chief Technical Principal<br>
</span><b><span lang="EN-AU" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#595959">SMEC South Africa<br>
</span></b><span lang="EN-AU" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#7F7F7F">230 Albertus Street, La Montagne, Pretoria, South Africa, 0184<br>
</span><b><span lang="EN-AU" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#595959">T
</span></b><span lang="EN-AU" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#595959">+27 (12) 481 3821 |
<b>F </b>+27 (12) 803 7943 | <b>M </b>+27 (83) 274 8885 <br>
<a href="mailto:arthur.taute@smec.com">arthur.taute@smec.com</a> |</span><span lang="EN-AU" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#7F7F7F">
</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#7F7F7F"><a href="http://www.smec.com/">www.smec.com</a>
</span><span lang="EN-AU" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#595959">|
<a href="http://www.linkedin.com/company/smec">LinkedIn</a><br>
____________________________________________________<br>
<b>SMEC SNOWY MOUNTAINS ENGINEERING CORPORATION<br>
</b></span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#565A5C;mso-fareast-language:EN-AU"><br>
</span><b><i><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#C75B12;mso-fareast-language:EN-AU">Local People. Global Experience.</span></i></b><i><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#C75B12;mso-fareast-language:EN-AU">
</span></i><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#565A5C;mso-fareast-language:EN-AU"><br>
</span></b><span lang="EN-US" style="font-size:7.0pt;font-family:"Arial",sans-serif;color:#565A5C;mso-fareast-language:EN-AU"><br>
</span><span lang="EN-AU" style="font-size:7.0pt;font-family:"Arial",sans-serif;color:#565A5C">Disclaimer: The information contained in this e-mail and any attachment file is confidential. It is intended for the addressee, and may not be used, reproduced, disclosed
or distributed without SMEC's permission. SMEC accepts no liability for loss or damage (whether caused by negligence or not) resulting from the use of any attached files.<br>
</span><i><span lang="EN-AU" style="font-size:7.0pt;font-family:"Arial",sans-serif;color:#76923C"><br>
Please consider the environment before printing this email.</span></i><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</div>
<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>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<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"> qgis-za-user [mailto:qgis-za-user-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Tim Sutton via qgis-za-user<br>
<b>Sent:</b> 02 October 2018 01:38 PM<br>
<b>To:</b> South Africa QGIS user group <qgis-za-user@lists.osgeo.org><br>
<b>Cc:</b> Tim Sutton <tim@kartoza.com><br>
<b>Subject:</b> Re: [QGIS-ZA-user] aggregate crime attribute data from SAPS Station boundaries to Wards<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi Brian<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">This should be fairly easy to do in QGIS without using any special plugins if you don’t mind doing a few steps. Can you share the datasets you want to use with me and I will see if I can come up with an easy workflow for you?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Regards<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Tim<o:p></o:p></p>
<div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">On 02 Oct 2018, at 10:57, Brian O'Leary via qgis-za-user <<a href="mailto:qgis-za-user@lists.osgeo.org">qgis-za-user@lists.osgeo.org</a>> wrote:<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<p class="MsoNormal">Dear QGis SA,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I would like to know if there is a QGis tool that can assist with the following task. I want to transfer crime attribute data from SAPS Station boundaries to Ward boundaries, assuming that crime is evenly distributed within the SAPS Station
boundary.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Previously I have done this task in Arc View using a script called DataPart.avx which was written by Jianwei Dou in 2002. The below simplified sketch illustrates what I am trying to do in Qgis. The SAPS Station shape has the data attributes
and the Ward shape is the overlay or boundary shape. The output that I need is an attribute table that has calculated the % intersection of the SAPS Station by the ward boundaries and aggregated the crime attributes to a Ward table based on the % intersection.
In the below sketch the ward boundaries intersect the SAPS Station boundary by 50% in both cases. As there were 100 crimes in the SAPS Station boundary the output table lists Wards 1 and 2 with 50 crimes in each.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><image.png><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal">Any advise most welcome.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Regards<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Brian O'Leary<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
qgis-za-user mailing list<br>
<a href="mailto:qgis-za-user@lists.osgeo.org">qgis-za-user@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/qgis-za-user">https://lists.osgeo.org/mailman/listinfo/qgis-za-user</a><o:p></o:p></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">—<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"><br>
<img border="0" width="150" height="118" style="width:1.5625in;height:1.2291in" id="E43D71E9-FE04-470D-8E1B-DAC8A118FC55" src="cid:image001.jpg@01D45AF2.2DD2C440"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="margin-bottom:12.0pt;text-align:center">
<span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"><br>
<br>
<br>
<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">Tim Sutton</span></b><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">Co-founder:</span></b><span class="apple-converted-space"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"> </span></span><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">Kartoza<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">Ex Project chair:</span></b><span class="apple-converted-space"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"> </span></span><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__QGIS.org&d=DwMFaQ&c=smhuqwfPwWSMyaibamWBQA&r=i-HHAe_D_s6l3U9xyATSOWTmAMX2qe4okWKiQbXajo8&m=2eaVbGTy98mFaEHSesD54JT3UZqYeE7Zu65k0yByLBw&s=-HULmDragl1QT4SK-R1B71P44Til_nyTO90O5uUF644&e=">QGIS.org</a><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">Visit <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__kartoza.com_&d=DwMFaQ&c=smhuqwfPwWSMyaibamWBQA&r=i-HHAe_D_s6l3U9xyATSOWTmAMX2qe4okWKiQbXajo8&m=2eaVbGTy98mFaEHSesD54JT3UZqYeE7Zu65k0yByLBw&s=cfvyTS8GHZ0Rr9R_gUUiV-T4u9mz3C6rpNqrjJNEdDk&e=">http://kartoza.com</a> to
find out about open source:<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">Desktop GIS programming services<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">Geospatial web development<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">GIS Training<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">Consulting Services<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">Skype</span></b><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">: timlinux <o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">IRC:</span></b><span class="apple-converted-space"><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"> </span></span><span style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black">timlinux
on #qgis at <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__freenode.net&d=DwMFaQ&c=smhuqwfPwWSMyaibamWBQA&r=i-HHAe_D_s6l3U9xyATSOWTmAMX2qe4okWKiQbXajo8&m=2eaVbGTy98mFaEHSesD54JT3UZqYeE7Zu65k0yByLBw&s=v4qRYBIQwfs84wDncsW5hNC2ptwRNqUPc1befQ4oMrI&e=">freenode.net</a><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>