PostGIS count, sum, average value per aggreazioni GROUP

GIS-Tips

learning avg dissolve dissolve postgis gis group by mapping osgeo osgeo live postgis postgis italiano postgres postgres italiano sum tutorial tutorial italiano

description

SELECT "PROVINCIA", count(*), sum(st_area(st_transform(st_setsrid("SP_GEOMETRY",4326),32632))), avg(st_area(st_transform(st_setsrid("SP_GEOMETRY",4326),32632))) FROM public."Comuni_MapInfo" GROUP BY "PROVINCIA" ... https://www.youtube.com/watch?v=uKblramqHIM

created

2021-09-21

staked

0.0 LBC

license

Copyrighted (contact publisher)

File size

16063350 Bytes