Skip to content

This is the PostGIS data model for QWAT, the water management software based on QGIS

Notifications You must be signed in to change notification settings

obrix/qwat-data-model

 
 

Repository files navigation

qwat-data-model

Build Status

This repository contains the definition of the data model used by QWAT project, a module aimed at managing a water network in QGIS.

A full web data model documentation with diagrams and relations is available here.

Model changelog (Detailed)

  • v1.3.4 : Remove SIRE from core, add value list for valve nominal diameter
  • v1.3.3 : Support for customizations
  • v1.3.2 : SIRE extension and infrastructure enhancements
  • v1.3.1 : fix z computation logic for valves
  • v1.3.0 : Switch from custom version control to generic Postgres Update Manager
  • v1.2.8 : add hardcoded schema_visible field to pipes and valves for enhanced performance on QGIS
  • v1.2.7 : AutoPrint Mapview
  • v1.2.6 : Fixes issue 177. Pipes where not audited by audit log system.
  • V1.2.5 : Adds a scale field to print maps
  • v1.2.4 : Fixes bugs when deleting objects qwat/QWAT#174
  • v1.2.2 : Integrates the new audit history system. Fixes an issue with multiple primary keys in conformity check procedure
  • v1.2.1 : Allow installation type change (done in trigger function generated by submodule meta-project generator).
  • v1.2.0 : Simplification of the trigger on views, ie there are no more triggers in cascade generated by the inheritance model. That modification does not affect the data-model code, but the change deserves a change in QWAT version number.
  • v1.1.1 : Adds the ability to use post delta files to check auto generated triggers in model
  • v1.1.0 : Remove valve inheritance from nodes.
  • v1.0.1 : Add functionnal to vl status (meaning the object is ready to be used). This is useful to allow finer printing (print inactive but functional objects)
  • v1.0.0 : First version (3 june 2016)
  • v0.1 : Proof of concept model

About

This is the PostGIS data model for QWAT, the water management software based on QGIS

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • HTML 94.6%
  • PLpgSQL 3.1%
  • TSQL 0.8%
  • Python 0.8%
  • Shell 0.3%
  • CSS 0.2%
  • Other 0.2%