Mutualise value lists for better interoperability

[haubourg]

Issues #172 #170 #171 are issues dealing with value lists that are not common because of customization. Having them being merged is necessary for a better interoperability between QWAT instances and with standards. I propose to keep track of all value list modification proposals here.

[haubourg]

From #171, here is a SIA value list for part_types

INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (327,'', 'Robinet à vidange automatique', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (326,'', 'Robinet', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (329,'', 'Croix', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (332,'', 'Changement de pente', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (333,'', 'Pièce isolante', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (334,'', 'Coude', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (336,'', 'Manchon de réparation', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (337,'', 'Manchon bridé', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (338,'', 'Manchon emboîté', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (339,'', 'Obturation filetée', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (340,'', 'Bride de mise à terre', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (342,'', 'Collier de prise', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (343,'', 'Pièce de raccordement standard', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (345,'', 'Armature isolante dans bâtimen', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (346,'', 'Clapet anti-retour', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (347,'', 'Manchon à coupler', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (348,'', 'Manchon avec grippes', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (349,'', 'Dérivation', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (350,'', 'Divers réducteur de pression', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (351,'', 'Chambre normalisée', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (352,'', 'Vidange (bonde)', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (353,'', 'Ventouse sur tube', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (354,'', 'Elément d''obturation', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (335,'', 'Obturateur tampon de fermeture', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (344,'', 'Obturation standard sur condui', '', true);
INSERT INTO qwat_vl.part_type (id, value_en, value_fr, value_ro, vl_active) VALUES (10001,'', 'Point d''introduction', '', true);

[varrieta]

@haubourg Here a list of the different part_types we have in the ESRI model: bride de raccordement (pièce de raccordement), collier de prise (pièce de raccordement), réduction normale (pièce moulée), coude horizontal (pièce moulée), coude vertical (pièce moulée), pièce en T (pièce moulée), capuchon (élément d'obturation), manchon raccord acier-PE (manchon), raccord multi-joint (manchon), raccord primo fit (manchon), manchon soudé (manchon)

[haubourg]

I created a label to identify all issues concerning value lists

[varrieta]

Here are other interesting value lists from the Geonis Database missing in QWAT:

• valve_type: Robinet / Vanne avec dérivation
• hydrant_material: Fonte diamètre inconnu
• pipe_material: Plusieurs petits diamètres pour l'acier / Eternit
• pipe_install_method: Tube poussé