swiss-seismological-service / REIA-ws

API for the data from the near real time event specific loss calculations.
GNU Affero General Public License v3.0
0 stars 0 forks source link

More Verbose Names of Columns for CSV Files #10

Closed schmidni closed 9 months ago

schmidni commented 11 months ago

User Story

As a non technical consumer of the *.csv files I would like to be able to easily understand what each column represents.

Acceptance Criteria

Change column headers to something that all stakeholders are happy with and which is possibly more verbose and descriptive to what the numbers represent.

schmidni commented 10 months ago

Decided to have them only in German.

schmidni commented 10 months ago

Loss: BFS Gemeindenummer / Kanton / Land , Durchschnitt [CHF], 10er Perzentil [CHF], 90er Perzentil [CHF] Damage: BFS Gemeindenummer / Kanton / Land, SG1 Durchschnitt [Anzahl], SG1 10er Perzentil [Anzahl], SG1 90er Perzentil [Anzahl], SG2 Durchschnitt [Anzahl], SG2 10er Perzentil [Anzahl], ….., Gesamtzahl Gebäude [Anzahl]

or

Loss: Anzahl Todesopfer pro BFS Gemeindenummer / Kanton / Land, Durchschnitt , 10er Perzentil , 90er Perzentil Damage: Gebäudeschäden [CHF] pro BFS Gemeindenummer / Kanton / Land, SG1 Durchschnitt, SG1 10er Perzentil, SG1 90er Perzentil, SG2 Durchschnitt, SG2 10er Perzentil, ….., Gesamtzahl Gebäude

schmidni commented 9 months ago

Chose the first version, since that way the name of the tag column only depends on the aggregation types and not also on the risk category.