A Practical Workflow for Reusing Proprietary Stormwater Model Data in Open-Source GIS Using CSV and SWMM Formats with Giswater
2026-09-03 , Ran1

This presentation introduces a practical workflow for converting proprietary stormwater model data into open formats using CSV and SWMM inputs, enabling reuse and visualization in QGIS and Giswater environments.


Many municipalities and practitioners rely on proprietary stormwater management software to maintain and operate drainage network models. While these models represent valuable public assets, their reuse in open-source environments is often limited by vendor-specific data formats and licensing constraints. This study presents a proof-of-concept workflow that enables the reuse of such existing assets in open-source GIS platforms through a simple and transparent data conversion process, with application in Giswater.

The proposed workflow assumes that core network data—nodes, links, coordinates, and basic attributes—are exported from proprietary stormwater models as CSV files using standard export functions. These CSV datasets are then mapped to the EPA SWMM input format (SWMM .inp) using lightweight Python scripts based on straightforward table-to-table mappings. The resulting .inp files are subsequently visualized and inspected in QGIS, allowing users to verify network structure and attributes without requiring access to proprietary software.

This workflow is intended for municipalities, consultants, and researchers who manage stormwater networks in closed-source systems but wish to incrementally integrate open-source tools into their workflows. By treating CSV files as a clearly defined boundary format and SWMM .inp as a common open schema, the approach minimizes vendor dependency while preserving existing data investments. The converted datasets can also serve as inputs for downstream open-source platforms, specifically Giswater. This opens the possibility for more advanced data management and analysis within the Giswater environment.

The presentation shares the conversion concept, data assumptions, and implementation considerations, providing a practical reference for organizations seeking to unlock proprietary stormwater model data for open-source GIS use.


Level of technical complexity: 2 - intermediate Indicate what is (are) the open source project(s) essential in your talk:

Giswater, QGIS, and EPA SWMM.

I make my conference contribution available under the CC BY 4.0 license. The conference contribution comprises the abstract, the text contribution for the conference proceedings, the presentation materials as well as the video recording and live transmission of the presentation:

GIS Analyst with over eight years of experience at BGEO, currently serving as GIS Area Coordinator. He leads the implementation of GIS solutions for national and international clients, supporting all project phases, including deployment, training, customization, development, maintenance, and troubleshooting.

He actively contributes to the development of Giswater, focusing on its data model and PostgreSQL-integrated functionality. He works daily with tools such as QGIS, QField, GeoNode, GeoServer, and MapStore, and is strongly committed to promoting competitive, reliable open-source GIS solutions for companies and public administrations.

This speaker also appears in: