1.4.0
This is a major upgrade of the datamodel.
Most notably, the qgep_wastewater_structure view is now a single point, 2D geometry of the main wastewater node (in most cases) or the main cover (where no main wastewater node is present).
Warning: This may require adjusting import scripts and will require adjusting the QGEP qgs project file.
Changes:
- Support for SWMM
- Audit triggers / history upgraded
- NOT NULL constraints on geometries
- Add a main wastewater node, the attributes of this will be exposed in qgep_wastewater_structure
- qgep_wastewater_structure is now a single point, 2D geometry
Smaller fixes:
- Increased length for qgep_od.maintenance_event.base_data
- Increase catchment_area surface precision
- Fix vw_individual_surface
- Many other small bugfixes
Descriptions of the files
File | Description |
---|---|
qgep_v1.4.0_structure.sql | Contains the structure of tables and system schema content |
qgep_v1.4.0_structure_with_value_lists.sql | Contains the structure of tables, system schema data and value lists data |
qgep_v1.4.0_demo_data.backup | Data-only backup of the qgep_od schema (i.e. ordinary data) from demonstration set of data |
qgep_v1.4.0_structure_and_demo_data.backup | Complete backup with structure and data of the demonstration set of data |
- If you plan to use QGEP for production, it is more likely you will be using the plain SQL
qgep_v1.4.0_structure_with_value_lists.sql
. - If you want to give a try at QGEP, you will likely restore the
qgep_v1.4.0_structure_and_demo_data.backup
backup file.