search

SWS-Methodology / faoswsStandardization

Standardization logic for Food Balance Sheets
0 stars 6 forks source link

Incomplete extraction rates and shares #22

Open sebastian-c opened 8 years ago

sebastian-c commented 8 years ago

I'm fairly sure that these tables are incomplete. They come from the aupus_ratio table - I need to check their status.

sebastian-c commented 8 years ago

For the US in 2011, there are 908 missing extraction rates: USA_commodity_tree_2011.txt

sebastian-c commented 8 years ago

I'm sure there's a good reason why the rates are missing. All the shares are either 0 or 1.

sebastian-c commented 8 years ago

In addition, there are the following extraction rates of 0 from various countries:

   geographicAreaM49 geographicAreaM49_description timePointYearsSP measuredItemParentCPC measuredItemParentCPC_description measuredItemChildCPC
1:                12                       Algeria             2011                 01343                          Apricots             21419.01
2:                76                        Brazil             2011              01491.01                    Oil palm fruit                 2165
3:               250                        France             2011                 01801                        Sugar beet                23512
4:                50                    Bangladesh             2011              01921.01             Seed cotton, unginned                F0769
   measuredItemChildCPC_description extractionRate share target
1:                  Apricots, Dried              0     0      B
2:                         Palm oil              0     1      B
3:                       Beet sugar              0     1      B
4:                     cotton waste              0     0      F
sebastian-c commented 8 years ago

By default, we use an extraction rate of 1 when there is no extraction rate