qwat / qwat-data-model

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

Project planned #310

Closed tudorbarascu closed 4 years ago

tudorbarascu commented 4 years ago

Up until now we had only one "project" status so there wasn't any way to distinguish a planned project from an project in execution

Important:

The "project" value has now the "planned project" meaning and there's a new value for status (1308) that represents the project in execution.

Please check for the wording in french..

In the qgep model there are also these values, which we don't have in the qwat model. Should we include them also?

  | operational.tentative | en_service.provisoire
  | operational.will_be_suspended | en_service.sera_supprime
  | abanndoned.suspended_not_filled | abandonne.supprime_non_demoli
  | abanndoned.suspended_unknown | abandonne.supprime_inconnu
  | abanndoned.filled | abandonne.demoli
tudorbarascu commented 4 years ago

gentle ping @kandre @ponceta @haubourg @lbartoletti

kandre commented 4 years ago

Nice idea to include that in the model. At SIGE, we use a custom value "waiting" instead for 1308, which is pretty much the same. French translation looks good to me.

lbartoletti commented 4 years ago

Thank you @tudorbarascu