Wolrd Entity and the various Total trade estimations

[paulgirard]

The total trade of one reporting entity to the World can be defined in different ways:

• SUM : estimate trade tot he world as the sum of trade with the partners
• TOTAL_REPORTING : use the total trade stastistics one can find in entities archives
• TOTAL_PARTOF_REPORTING : same as TOTAL_REPORTING for politically dependent entities
• TOTAL_ESTIMATED : use the total trade stastistics one can find in recent works (Mitchell, SAFC_US)

In RICardo we propose to use a mix-method to define the Total Trade.
In Country view, we will use the TOTAL_REPORTING or if not present TOTAL_PARTOF_REPORTING
In World view, we will use the TOTAL_ESTIMATED or if not present TOTAL_REPORTING

The SUM method is not used.

Deprecated information :

nouvelle colonne : total_type
valeurs possibles : null, reporting_total, estimated_total
Dans country view, on affiche le montant vers le partner World de type reporting_total
Dans World view, on affiche le montant vers le partner World de type estimated_total si il existe sinon on prend le reporting_total

"- Pour la country view (tous les partners + total des partners), on retient par défaut le code 0 (vide) dans 'Total trade Estimation' ou 1 s'il n'y a pas de données pour le code 0 (ce qui peut être souvent le cas). "

In country view we want to compare the total amounts obtained by summing all the partners imp/exp with the total declared in the database.

This total is in the database as flows to World Partner.
We should take the flow where 'Total trade Estimation' is null if exists otherwise where 'Total trade Estimation'=1

[paulgirard]

New proposition from Toflit18 project meeting.
We distinguish 4 ways to consider world trade :
1- recent estimation
2- total flow as reported in source
3- sum of flows to partners

• best guess: one of the three depending on availability with priority 1,2,3

In CountryView we use sum of partners for the total curve on top.
For the detail bellow user can chose the different world flows 4 choices in a specific select.

In Wolrd view we use best guess.
Ideally we can visualize which of trade calculation has been use in a specific year bellow the curve the same way we indicate missing values.