search

qwat / qwat-data-model

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

SIRE imprecise coded values for PE100 material #237

Closed kandre closed 6 years ago

kandre commented 6 years ago

In vl_pipe_material.sql, code_sire value is set to 10 for PE materials (meaning PE100), example :

INSERT INTO qwat_vl.pipe_material (id, vl_active, short_en, value_en, short_fr, value_fr, short_ro, value_ro, diameter, diameter_nominal, diameter_internal, diameter_external, code_sire, pressure_nominal, sdr, wall_thickness) VALUES (7048, true, '', '', 'PE', 'Polyéthylène 100', 'PE', 'Polietilenă 100', '40', NULL, 35.200, 40.000, 10, 10, 17, 2.4);

According to SIRE dictionnary : 7: PE100 8: PE80 9: PE50 10: PE_type_inconnu

Hence it yields PE_type_inconnu instead of PE100 when exporting data to SIRE. Could we change that to code_sire = 7 for all those values ?

kandre commented 6 years ago

Thanks !