Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
so I have a shapefile with buildings and the shapefile has the height of the buildings in the attribute table. I have a second shapefile with the districts the buildings are located in. Now I would like to count the mean height of the buildings in each district and add it to the attribute table of the districts.
For raster data it would be easy using zonal statistics to get the mean for a specific area, but I cant figure out the solution for 'shapes within shapes'.
If the data is static, @Taras solution is the way to go.
Else, if the data changes frequently, you can create a virtual layer to compute the mean
Go to the menu Layer > Add Layer > Add/Edit Virtual Layer... and enter the following query. Replace the layer name for yours
SELECT poly.*, avg(pt.height) as mean_height
FROM my_polygon_layer poly
JOIN my_point_layer pt ON st_intersects(poly.geometry, pt.geometry)
GROUP BY poly.id
Join attributes by location(summary)?"Fix geometries","Remove null geometries"and"Delete duplicate geometries". Can you tell me what happens afterwards? Please, text me here discord.gg/h2rks6N, perhaps you can share your data with me