Output: JSON file summarising the schematisation, + HTML file that displays the JSON
Properties to be included in the summary:
Schema version
Nr of features of each layer. Layers should be grouped in the same way as in the Layers panel
Settings (model settings, physical settings, time step settings)
Total area of surface.area, group by surface.surface_parameters_id
Mapped area of surfaces. In SQL this would be:
SELECT sp.id,
sp.description,
round(sum(area*(sm.percentage/100)), 2)
FROM surface AS su
LEFT JOIN surface_map AS sm
ON su.id = sm.surface_id
LEFT JOIN surface_parameters AS sp
ON su.surface_parameters_id = sp.id
GROUP BY su.surface_parameters_id
;
Input: schematisation geopackage
Output: JSON file summarising the schematisation, + HTML file that displays the JSON
Properties to be included in the summary:
surface.area
, group bysurface.surface_parameters_id