[Qgis-user] Using aggregates functions to count intersected features from another layer

[Nicolas Cadieux]

Try this.

http://www.qgistutorials.com/fr/docs/points_in_polygon.html

Nicolas

> Le 19 oct. 2016 à 06:37, DelazJ [via OSGeo.org] <ml-node+s1560n5291420h81 at n6.nabble.com> a écrit :
> 
> Hi,
> 
> I have a polygon layer and a point one.
> I'd like to calculate for each polygon feature, the number of points that it covers. I thought the aggregates functions could help me find an easier and straight expression to perform this (without creating intermediate layers) but I fail to find any correct syntax. 
> 
> I tried aggregate ('mypoint', 'count', "id", intersects ($geometry, geometry($currentfeature)))
> 
>  And many variants of the fourth option but It always return the total of points or an error. Actually this option is a filter and I wonder if i'm not missing a "group by" option in the aggregate function (which seems to be the appropriate one in my case). Is it possible?
> 
> The work around I found is to populate an ad'hoc field in the point layer with overlapping polygon id, thanks to the SpatialJoin plugin, then I create a one-to-many relation in the project between the two layers in other to use relation_aggregate function.
> But I expected something more direct.
> 
> Any hint, please?
> 
> Thanks,
> Harrissou
> 
> _______________________________________________ 
> Qgis-user mailing list 
> [hidden email] 
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user 
> 
> If you reply to this email, your message will be added to the discussion below:
> http://osgeo-org.1560.x6.nabble.com/Using-aggregates-functions-to-count-intersected-features-from-another-layer-tp5291420.html
> To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38 at n6.nabble.com 
> To unsubscribe from Quantum GIS - User, click here.
> NAML




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Using-aggregates-functions-to-count-intersected-features-from-another-layer-tp5291420p5291443.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20161019/9a3ab9a4/attachment.html>