[QGIS-ZA-user] aggregate crime attribute data from SAPS Station boundaries to Wards

[Gavin Fleming]

Hi Brian

Please share a few overlapping station and ward features with the list.

thanks

Gavin

> On 02 Oct 2018, at 10:57, Brian O'Leary via qgis-za-user <qgis-za-user at lists.osgeo.org> wrote:
> 
> Dear QGis SA,
> 
> 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.
> 
> 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.
> 
> <image.png>
> Any advise most welcome.
> 
> Regards
> Brian O'Leary
> 
> 
> 
> _______________________________________________
> qgis-za-user mailing list
> qgis-za-user at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/qgis-za-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-za-user/attachments/20181003/76bd58c1/attachment.html>