Le portail francophone de la géomatique

create table exportseg2 as
select  a.PK_UID as PK_UID,  Brightness, GLCM_Contr, GLCM_Dissi, 
GLCM_Entro, GLCM_Homog, Max_diff, Mean_Layer, Mean_Lay_1, Mean_Lay_2, Standard_d, Standard_1, Standard_2,  Class_name,
sum(b.area_m2) as sum_surfm2 , cast(area(a.geom) as double precision)as area_deg, cast(sum(b.area_m2)*100/area(a.geom) as double precision) as densbat , a.geom
    from exportseg a left join bati b
    on MbrIntersects(a.geom,b.centroid) and Intersects(a.geom,b.centroid)
    group by a.PK_UID,  Brightness, GLCM_Contr, GLCM_Dissi, 
GLCM_Entro, GLCM_Homog, Max_diff, Mean_Layer, Mean_Lay_1, Mean_Lay_2, Standard_d, Standard_1, Standard_2, Class_name, a.geom
;