Hydraulic capabilities - Giswater/giswater_dbmodel GitHub Wiki

Giswater project is natively oriented to integrate GIS inventory data with US EPA hydraulic programs EPANET & SWMM. From version 1.0 launched on 2014, database was already designed to full-integration of inventory and hydraulic modelling capabilities. As a result, there are some special features that make Giswater a powerful tool to integrate hydraulic capabilities with asset inventory. The key points are:

1 - Dual-face database model wich integrates data from both inventory and hydraulic model, using two diferent sides for each asset element: the epa side (epa tables) and the inventory side (inventory tables), wich provides full flexibility to modeler to work with hydraulic capabilities without any impact on inventory data for each asset element. Besides there are some differences for EPANET dual-database model and SWMM dual-database model. In addition, any value from any feature table can be used in order to fill epa tables.

2 - Specific columns on datamodel to decide which element must be exported and which not. The 'enable go2epa columns' option allows hydraulic modeller to create inp file exporting only those network elements that fits with proposed hydraulic goals.

3 - Custom columns, which do not overwrite inventory values. Columns like [custom_top_elev, custom_elev, custom_ymax, custom_length, custom_roughness, custom_dint] and so one, allow hydraulic modeller to work with modified inventory values without overwriting the original data. Simply when these columns are filled, they have more priority than inventory values and are used to create the inp file.

4 - Rich inp file export module with ‘on the fly’ transformations in order to compatibilize the two diferent geometries (remember the dual-face) of inventory elements. In example: flow regulators need to be a link on epa side, some arcs need to be broken on epa side or some inventory pumps may be more complex than simple ‘link' on the epa side. More information: EPANET on-the-fly transformations and SWMM on-the-fly transformations.

5 - Full control of hydraulic models from Giswater UI, in terms of OPTIONS, REPORTS including FILES, TAGS, LABELS and non visual objects. All what hydraulic software needs can be managed by Giswater UI (epa tables). In addition Giswater works in a full workflow creating input files (inp), executing epa software and reading result files (rpt).

6 - Possibility to work with diferent scenarios to create different modelling conditions in order to check the worst scenario or to check how the network will response on future scenarios. For Water Supply networks it is possible to work with dscenarios and for Urban Drainage projects is possible to work with DWF scenarios and hydrology scenarios.

7 - Possibility to work with alternatives to planify new network elements without interferece with asset inventory elements. Creating new psectors you will modify the phisical reality of the network. More information: work with alternatives