qwat / qwat-data-model

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

pressure reducing valve value missing #347

Open tudorbarascu opened 2 years ago

tudorbarascu commented 2 years ago

Hi, in the valve types we currently have:

1/4 de tour à déterminer autre clapet anti-retour Elgef inconnu limiteur de débit soupape automatique soupape manuelle sprinkler vanne vanne à opercule vanne annulaire vanne clayton vanne papillon

I see no mention of PRV (pressure reducing valves) althoug FRV (flow reducing valves) exist (limiteur de debit). I'm curious where do you currently save this attribute? Aren't you using it?

sjib commented 2 years ago

There is a value list of different pressurecontrol types: https://github.com/qwat/qwat-data-model/blob/master/value_lists/vl_pressurecontrol_type.sql

and https://rawgit.com/qwat/qwat-data-model/master/diagram/qwat_od/tables/pressurecontrol.html for the overview