Stefan comments

Results 281 comments of


                                            Stefan

QGEP SWMM: fill wastewater_node.backflow_level and reach.hydraulic_load

@tproduit Results for nodes in Mike+: ![mikeplus_nodes_water_levels](https://user-images.githubusercontent.com/1265865/114072459-982ad580-98a2-11eb-9f93-d9a0027305cc.png) ![mikeplus_ergebnisse_knoten_becken](https://user-images.githubusercontent.com/1265865/114072468-99f49900-98a2-11eb-8256-a10f2ebe691b.png) For backflow_level

QGEP SWMM: fill wastewater_node.backflow_level and reach.hydraulic_load

@tproduit Results for weirs etc. in Mike+: ![mikeplus_weirs_orifices_gates_discharge](https://user-images.githubusercontent.com/1265865/114072856-f788e580-98a2-11eb-9f2b-e7595419db13.png) ![mikeplus_ergebnisse_pumpen](https://user-images.githubusercontent.com/1265865/114072870-f9eb3f80-98a2-11eb-86b2-ef5a7ea0a8ac.png) ![mikeplus_ergebnisse_wehre_schieber](https://user-images.githubusercontent.com/1265865/114072872-f9eb3f80-98a2-11eb-9667-87dd1456dd11.png)

QGEP SWMM: fill wastewater_node.backflow_level and reach.hydraulic_load

SWMM results (chapter 9.2 Viewing Summary Results ) [User Manual](https://www.epa.gov/water-research/storm-water-management-model-swmm-version-51-users-manual) ![swmm_results_nodes](https://user-images.githubusercontent.com/1265865/114074201-69adfa00-98a4-11eb-9d0e-c7e8eb3bac43.jpg) ![swmm_results_links](https://user-images.githubusercontent.com/1265865/114074211-6ca8ea80-98a4-11eb-8702-1cbeb0a1a7ce.jpg)

3D merging and cutting reaches

@ponceta @urskaufmann Did you write a short documentation already on how to split a reach with the current QGIS tools already? Here I did not find any details: https://qgep.github.io/docs/user-guide/editing/editing.html#split-a-reach-channel-into-different-reaches

3D merging and cutting reaches

@bogdanvaduva Thanks. Does it also add a wastewater_node inbetween the two new reaches?

3D merging and cutting reaches

@bogdanvaduva Thanks for clarification and the example.

3D merging and cutting reaches

@bogdanvaduva Any hint why I get this Error: ERROR: FEHLER: Syntaxfehler bei »(« LINE 68: ...th(ST_EndPoint(v_geom3d),ST_StartPoint(v_geom3d)))(ST_Distan... ^

3D merging and cutting reaches

@bogdanvaduva same Error in LINE 70

3D merging and cutting reaches

Great - the function works now: ![split_reach_1](https://user-images.githubusercontent.com/1265865/114004460-f930ba00-985e-11eb-919e-42d1d8cd2069.jpg) What I do not know is where it splits the reach exactly - in the middle? ![split_reach_2_missing_relations_fk_wastewater_networkelement_in_new_reach](https://user-images.githubusercontent.com/1265865/114004479-fc2baa80-985e-11eb-87e9-d65a6d98aa07.jpg) And it looks like the foreignkeys...

3D merging and cutting reaches

@bogdanvaduva So if I understand you right` v_point character varying DEFAULT ''::character varying` would need to be the identifier of an existing wastewater_node to be the locations, where the reach...