search

qwat / qwat-data-model

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

[ENH] part types #379

Open nicolas-sitylb opened 9 months ago

nicolas-sitylb commented 9 months ago

Hello QWAT team,

some official survey offices use more part types than those provided in the official QWAT data model, for example (here in french) : image

whereas the actual QWAT data model only provides those values:

SELECT id, value_fr, value_en, value_ro FROM qwat_vl.part_type;

image

Therefore, the correspondence is complicated. This is especially true as there are no "unknown"-like values.

That's why I'm asking if it could be possible to integrate, at least the most common values in the official QWAT data model?

(It would also be convenient to use the default values 101, 102 and 103 (see: https://github.com/qwat/qwat-data-model/pull/378 ))

Thanks.

ponceta commented 9 months ago

Very good input, it would be nice to list elements not in this list and check whether they are not in some other class in QWAT.

I've added a delta to your PR.