SWMM Import Results

Measurement tables

If you want to store the results in QGEP and use the dedicated view for the mapping then use SWMM Import Results. It parses the report file of SWMM. The results are imported in the measurements tables in the qgep_od schema:

  • measuring_point: there is one measuring point for each wastewater structure and simulation,


Measuring point: the name of the simulation appears in the remark

  • measuring_device : there is one measuring device for each measuring point,


Measuring device

  • measurement_series: there is several measurement series for each measuring point, one for each measured parameter (i.e average depth, maximum depth, maximum hgl …),


Measurement series

  • measurement_result: there is one or several measurement result for each measurement series. There is one value if the summary only is imported and many values if the full time series are imported.


Measurement result

and they populate a view dedicated for the mapping (see Results are imported in QGEP).

Launch import

Launch SWMM Import results:

  • SWMM report file: the .rpt file generated during the previous step

  • Database: The name of the PostgreSQL service hosting the QGEP database.

  • Simulation name: The name that you want to give to this simulation (it will appear in qgep_od.measuring_point.remark).

  • Import summary: Only the summary is imported.

  • Import full results: The full time series will be imported. Attention, if the report step is small, the import can take a long time.

  • Import Max HGL in qgep_od.wastewater_node.backflow_level

  • Import Max/Full Flow in qgep_od.reach.dss2020_hydraulic_load_current


Attention, a report file created from the SWMM GUI don’t contain the full time series but only the summary.