PostGIS count, sum, average value per aggreazioni GROUP

Blog

PostGIS count, sum, average value per aggreazioni GROUP

PostGIS count, sum, average value per aggreazioni GROUP >> 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