1.5.2

Descriptions of the files

File	Description
qgep_v1.5.2_structure.sql	Contains the structure of tables and system schema content
qgep_v1.5.2_structure_with_value_lists.sql	Contains the structure of tables, system schema data and value lists data
qgep_v1.5.2_demo_data.backup	Data-only backup of the qgep_od schema (i.e. ordinary data) from demonstration set of data
qgep_v1.5.2_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.5.2_structure_with_value_lists.sql.
• If you want to give a try at QGEP, you will likely restore the qgep_v1.5.2_structure_and_demo_data.backup backup file.

1.5.1

Descriptions of the files

File	Description
qgep_v1.5.1_structure.sql	Contains the structure of tables and system schema content
qgep_v1.5.1_structure_with_value_lists.sql	Contains the structure of tables, system schema data and value lists data
qgep_v1.5.1_demo_data.backup	Data-only backup of the qgep_od schema (i.e. ordinary data) from demonstration set of data
qgep_v1.5.1_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.5.1_structure_with_value_lists.sql.
• If you want to give a try at QGEP, you will likely restore the qgep_v1.5.1_structure_and_demo_data.backup backup file.

1.5.0

Descriptions of the files

File	Description
qgep_v1.5.0_structure.sql	Contains the structure of tables and system schema content
qgep_v1.5.0_structure_with_value_lists.sql	Contains the structure of tables, system schema data and value lists data
qgep_v1.5.0_demo_data.backup	Data-only backup of the qgep_od schema (i.e. ordinary data) from demonstration set of data
qgep_v1.5.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.5.0_structure_with_value_lists.sql.
• If you want to give a try at QGEP, you will likely restore the qgep_v1.5.0_structure_and_demo_data.backup backup file.

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.

1.3.1

• Remove channels when no reaches are left
• Add qgep_export schemas

Descriptions of the files

File	Description
qgep_v1.3.1_structure.sql	Contains the structure of tables and system schema content
qgep_v1.3.1_structure_with_value_lists.sql	Contains the structure of tables, system schema data and value lists data
qgep_v1.3.1_demo_data.backup	Data-only backup of the qgep_od schema (i.e. ordinary data) from demonstration set of data
qgep_v1.3.1_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.3.1_structure_with_value_lists.sql.
• If you want to give a try at QGEP, you will likely restore the qgep_v1.3.1_structure_and_demo_data.backup backup file.

1.3.0

• views are now created automatically via Python with Pirogue (https://opengisch.github.io/pirogue/)
• the datamodel now allows some customizations which will be reflected in automatically generated views and will go through model upgrades
• Import only verified element in import schema

Descriptions of the files

File	Description
qgep_v1.3.0_structure.sql	Contains the structure of tables and system schema content
qgep_v1.3.0_structure_with_value_lists.sql	Contains the structure of tables, system schema data and value lists data
qgep_v1.3.0_demo_data.backup	Data-only backup of the qgep_od schema (i.e. ordinary data) from demonstration set of data
qgep_v1.3.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.3.0_structure_with_value_lists.sql.
• If you want to give a try at QGEP, you will likely restore the qgep_v1.3.0_structure_and_demo_data.backup backup file.

1.2.0

• Delete reach points when reach is deleted (QGEP/QGEP#436)
• 3D geometry for reach_point, wastewater_node and cover (#90
  For more information see the synchronization chapter in the docs

Descriptions of the files

File	Description
qgep_v1.2.0_structure.sql	Contains the structure of tables and system schema content
qgep_v1.2.0_structure_with_value_lists.sql	Contains the structure of tables, system schema data and value lists data
qgep_v1.2.0_demo_data.backup	Data-only backup of the qgep_od schema (i.e. ordinary data) from demonstration set of data
qgep_v1.2.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.2.0_structure_with_value_lists.sql.
• If you want to give a try at QGEP, you will likely restore the qgep_v1.2.0_structure_and_demo_data.backup backup file.

1.1.1

New Features

• New function qgep_od.change_reach_direction to change the direction of one or more reaches

Fixes

• Performance improvements. When changing a reach, there was a severe performance impact (QGEP/QGEP#437)
• Various smaller fixes

Descriptions of the files

File	Description
qgep_v1.1.1_structure.sql	Contains the structure of tables and system schema content
qgep_v1.1.1_structure_with_value_lists.sql	Contains the structure of tables, system schema data and value lists data
qgep_v1.1.1_demo_data.backup	Data-only backup of the qgep_od schema (i.e. ordinary data) from demonstration set of data
qgep_v1.1.1_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.1.1_structure_with_value_lists.sql.
• If you want to give a try at QGEP, you will likely restore the qgep_v1.1.1_structure_and_demo_data.backup backup file.

1.1.0

New features

• QGEP import: a new schema to import data from the field

Fixes

• Remove Channels from vw_qgep_wastewater_structure (QGEP/QGEP#405)
• cast geometry types in network tracking views and organisation view
• fix table names for KEK tables in dictionary (see QGEP/QGEP#431)

Descriptions of the files

File	Description
qgep_v1.1.0_structure.sql	Contains the structure of tables and system schema content
qgep_v1.1.0_structure_with_value_lists.sql	Contains the structure of tables, system schema data and value lists data
qgep_v1.1.0_demo_data.backup	Data-only backup of the qgep_od schema (i.e. ordinary data) from demonstration set of data
qgep_v1.1.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.1.0_structure_with_value_lists.sql.
• If you want to give a try at QGEP, you will likely restore the qgep_v1.1.0_structure_and_demo_data.backup backup file.

1.0.1-5

Descriptions of the files

File	Description
qgep_v1.0.1-5_structure.sql	Contains the structure of tables and system schema content
qgep_v1.0.1-5_structure_with_value_lists.sql	Contains the structure of tables, system schema data and value lists data
qgep_v1.0.1-5_demo_data.backup	Data-only backup of the qgep_od schema (i.e. ordinary data) from demonstration set of data
qgep_v1.0.1-5_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.0.1-5_structure_with_value_lists.sql.
• If you want to give a try at QGEP, you will likely restore the qgep_v1.0.1-5_structure_and_demo_data.backup backup file.