[Qgis-user] QGIS Analytical combinations

[ferran fabregas]

Thanks! That make sense, I'll try and I will let you know.

El mar., 4 de noviembre de 2014 15:26, enricofer <enricofer at gmail.com>
escribió:

> I suggest you to put everything in spatialite database and, assuming that
> 1) GRID is the polygon layer with grid definition
> 2) POINTS is the point layer with population data
> 3) POINTS has a field "pop" with population data
> 4) both layers have a keyfield named "id"
> 5) both layer have "geom" as geometries field
>
> Run the following query with dbmanager:
>
> SELECT DISTINCT GRID.id, SUM(POINTS.pop) AS POPxGRID
> FROM POINTS
> INNER JOIN GRID ON ST_Within(POINTS.Geometry,GRID.geom)
> GROUP BY GRID.ID
>
> you will get a table with a reference to a grid feature ID and the sum of
> the population of the points that are within the grid feature
>
> I hope this help you.
>
> Enrico Ferreguti
>
>
>
> --
> View this message in context: http://osgeo-org.1560.x6.
> nabble.com/QGIS-Analytical-combinations-tp5171127p5171139.html
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141104/ee080e01/attachment.html>