INTERLIS import/export interface for SIA 405

[kandre]

General information

• Applicant: Alexandre Bosshard and Stefan Burckhardt, coordinators and project leaders of the QWAT/QGEP group
• Developer: OPENGIS.ch GmbH
• User group referent: Kevin André, SIGE
• Developments referent: Olivier Dalang, Opengis

Users and administrators needs

Graphical identity / Logo

Illustrations if applicable.

Description of users and administrators feature requirements

This feature should allow any GIS administrator or trained QGIS user to use the import and export interface bewteen QWAT and QGEP data models and swiss norms VSA-KEK and SIA 405 by using the swiss standard format INTERLIS.

General requirements

See general requirements of QGEP #600 .

Specific requirements (QWAT and SIA 405)

• German speaking users will use this interface only if qwat data model is german compliant. => add a german column with translated values for each value lists in qwat data model.

Illustrations of the features and the requirements

Schemes, screen captures, or any other illustrations.

Graphical User Interface (GUI)

Illustrations if applicable.

Technical analysis and specifications

• The qwat data model lacks a "siacode" column with SIA values for each value lists. This data is needed in order to communicate (import/export) with the ili2pg SIA405water postgis schema (see import and export docs) It should then be added to the qwat data model.
• import: a sql translation from ili2pg SIA405water schema to qwat schema is needed
• export: a sql translation from qwat schema to ili2pg SIA405water schema is needed

Feasibility study

Feasibility, options, alternatives and technical specificities

Risks and constraints

Mutualisation

Mutualisation and possible impacts with other projects (QGIS, QWAT, QGEP)

Cahier des charges et offres ( Developer)

Specifications

Tenders

Not shared on Github.

Timeline / deadlines

• [x] 01.09.2020 : Contract signature

• [x] 11.09.2020: Preliminary meeting for user needs

• [x] ~~30.09.2020~~: Draft for user needs and specifications

• [x] 30.10.2020: User needs and specifications delivered to the developer

• [x] 31.12.2020: 1st intermediate report to NGDI (Stefan)

• [x] 28.02.2021: VSA-KEK INTERLIS import/export interface release (and demo ?)

• [x] ~~30.01.2021~~ 31.03.2021: SIA 405 INTERLIS import/export interface release (and demo ?)

• [x] 31.03.2020 - 30.04.2021: Quality control and bug fixing

• [x] 31.04.2021: 2nd intermediate report to NGDI (Stefan)

• [x] 31.05.2020: Users tests in customers' spatial data infrastructures

• [x] 30.06.2021: Corrections and bug fixing

• [x] 30.07.2021: Documentation release: 30.07.2021

• [ ] 31.08.2021: Interfaces SIA 405 for QWAT and VSA-KEK for QGEP are operationnal and documented. Final report to NGDI (Stefan).

• [ ] Warranty period : to be adressed

Versions of related softwares

• QGIS version: to be defined
• Database model version: to be defined

Public issues links :

• …

Helpdesk issues links :

• …

Dates de réalisation

• Tender reception date :
• Tender validation date :

Documentation

Documentation links

• User manual :
• Administrator manual :

Development and intégration

Link and comments from the developer about the product

• Deliverable :
• Recommendations and comments :
• Future prospects :

Conclusion

Conclusions from applicant, users or admins group

• Conclusion:

• Future prospects:

• Invoice date:

• Payment date:

[kandre]

This issue is our shared document to define user needs, specifications, timeline and to follow up the execution. As this feature should be thinked and developed in a participative way, feel free to react by using the comments below. Issue #600 in QGEP is not a duplicate, but very similar as we aim at mutualising as much as possible this development between those projects.

@sjib @ponceta feel free to complete of make corrections.

[sjib]

@kandre I would add the following necessary working steps:

1. extension of qwat datamodel with matching of SIA405 water values with existing values in qwat (SIACodes)
2. INTERLIS Export SIA405 water - translation of qwat schema to ili2pg schema SIA405water, code to language value translation
3. INTERLIS Import SIA405 water - translation of ili2pg schema SIA405water to qwat schema, language value to code translation
4. Integration in qwat plugin and processing tools

See also https://qgep.github.io/docs/admin-guide/data-export/index.html and https://qgep.github.io/docs/admin-guide/data-import/index.html

[kandre]

Thanks for you feedback,

@sjib indeed we lack SIA 405 values (a "siacode" column) in the qwat data model, and sql matching translations between ili2pg and qwat models, in both ways (export + import) I would add those requirements in the technical analysis and specifications section, as it is not a user need (the "user" does not care about the internal mechanisms).

@ponceta totally agree, we lack german translations in value lists (and not only values but even the german column is missing). I think this is a user need to use this interface.

I have edited the main description in this ticket accordingly.

[kandre]

4. Integration in qwat plugin and processing tools

@sjib this point is unclear to me, actually there is no qwat plugin and what should be integrated? Could you rephrase?