I have a vector file containing points with an attributed value (no. of employes at that location). I need to create a hectare raster with the sum of employes for each grid cell. I'm using QGIS and have so far played around with gdal_rasterize gdal_grid but with no success. I'm not even sure if I'm looking at the right tool. Can anyone give me a hint?
Assuming you know how to create the hectare sized grid (using the
Using spatialite, import the two shapefiles:
Add new columns in the grid layer for the totals. You can also get averages, etc while you're at it...
Now do the UPDATE to populate those columns with a SELECT query that uses the SQL aggregate "SUM" and the ST_Contains() function. The second part of the WHERE clause matches each select to the correct row in the outer UPDATE statement:
It depends on your initial projection, but lets assume its distance units are meters.