search

qwat / qwat-data-model

TEKSI Water module (project QWAT) - PostgreSQL / postgis Datamodel
https://www.teksi.ch
23 stars 24 forks source link

Wrong matching GRP instead of PRV #338

Closed sjib closed 2 years ago

sjib commented 2 years ago

https://github.com/qwat/qwat-data-model/blob/0f56a817da4817d7f261e2f3456175fae983e218/update/delta/delta_1.3.6_add_vl_for_SIA_export.sql#L127

UPDATE qwat_vl.pipe_material SET sia405code = 'Kunststoff.Glasfaserverstaerkter_Epoxiharz' WHERE short_fr = 'GRP'; should be

UPDATE qwat_vl.pipe_material SET sia405code = 'Kunststoff.Glasfaserverstaerkter_Epoxiharz' WHERE short_fr = 'PRV';

Abreviation form short_en taken instead of short_fr

qwat pipe_material_polyester reinforcé de fibres de verre