Use the same case on all value lists

[rbovard]

There is a lack of case consistency for values lists.

Some examples:

• Mixed case qwat_vl.status:
  • autre
  • inconnu
  • à déterminer
  • En service
  • Hors service
  • Désaffecté
  • Abandonné
  • Détruit
  • Projet planifie
  • Fictif
  • Projet en execution
• Lower case qwat_vl.source_type:
  • autre
  • inconnu
  • à déterminer
  • captage eau lac
  • captage eau nappe
  • captage eau source
  • captage eau rivière
• Upper case qwat_vl.precision:
  • Autre
  • Inconnu
  • À déterminer
  • Imprécis
  • Précis
  • Localisé
  • Digitalisé

[ponceta]

Since all theses values have unique codes, we could easily provide a uniformed case french translation. This will require a delta since it is considered as a datamodel upgrade.

[rbovard]

It's not only for french, but yes.

Now you need to decide wich way go: uppercase or lowercase ;)

[ponceta]

It's mainly a community decision and some user comfort, as these rely on value codes.

Here is a sample of reaches in TEKSI wastewater :

Here is the equivalent for pipes in QWAT :

But what I find hard to decide is when translating, do we care more about the data and its conversion into other systems like geoportals -> approach of having lowercase with underscore is the best (with language like german that will still have some mandatory uppercases.)

Or do we care more about the user (geomatician, GIS operator) feeling and how he likes his fields to be displayed.

For materials in QWAT in pully we had to create a custom displayname to fit these user needs.

This can have a large impact for any user who uses the solution because they will have to adapt this everywhere theses attributes are used. (geoportals, FME, DWG, ...)

[ponceta]

I would fix it like this for now (as it will surely change when SSIGE releases its datamodel) :

• Mixed case qwat_vl.status:
  • Autre
  • Inconnu
  • À déterminer
  • En service
  • Hors service
  • Désaffecté
  • Abandonné
  • Détruit
  • Projet planifie
  • Fictif
  • Projet en execution
• Lower case qwat_vl.source_type:
  • Autre
  • Inconnu
  • À déterminer
  • Captage eau lac
  • Captage eau nappe
  • Captage eau source
  • Captage eau rivière
• Upper case qwat_vl.precision:
  • Autre
  • Inconnu
  • À déterminer
  • Imprécis
  • Précis
  • Localisé
  • Digitalisé

[sjib]

see also Value lists - add a new column to handle display values without underscore #389