30. June 2019 -- Files with faulty aspects table

[nheeren]

The following aspect tables need to be verified:

• The file 1_F_ElectricityGeneration_IEA_HeadlineEnergyData_2016.xlsx aspect_1 is given as "energy". This aspect does not exits.
• The file 1_F_FinalEnergyConsumption_TFC_ByCountryAndSector_IEA_2018.xlsx appears to have a similar issue as the above and others.
• 6_MIP_SI.POV.GINI_WorldBank_2019 aspects 1 and 2 should probably be a custom classifications?
• 6_IMI_EU_Regional_Carbon_Footprint_Ivanova_2017.xlsx
  • Unit "cap" is not defined.
  • Resolved / FYI: Renamed sheets "Unit_denom" to "Unit_denominator" and "Unit_nominator" to "Unit_nominator"

@stefanpauliuk Could you please investigate / fix?

P.S.: More details and successful uploads are documented here: https://github.com/IndEcol/IE_data_commons/blob/master/doc/File_changes_Niko.md#30-june-2019

[stefanpauliuk]

File "1_F_ElectricityGeneration_IEA_HeadlineEnergyData_2016.xlsx" aspect_1 is given as "energy", changed to "energy_carrier" File "1_F_FinalEnergyConsumption_TFC_ByCountryAndSector_IEA_2018.xlsx", aspect_2 is given as "energy", changed to "energy_carrier" 3_MC_Buildings_Heeren_Fishman_ScientificData_2019_V1: Please add the feature described in issue 21 to the upload script. 6_MIP_SI.POV.GINI_WorldBank_2019: aspects 1 is coded in classification 28 (just checked) and aspect 2 needs to matched to attribute3_oto of the general regions classsification 2, here, the template had a mistake, which is now fixed. 6_IMI_EU_Regional_Carbon_Footprint_Ivanova_2017.xlsx: Changed unit from "cap" to "person"

[stefanpauliuk]

6_MIP_SI.POV.GINI_WorldBank_2019, contains many empty cells, Please first add the feature described in issue #21 to the upload script. Updated files now in dropbox.

[nheeren]

Can you please double check if the files have been uploaded correctly? I cannot find them in e.g. Dropbox (Yale_FES)/G7 RECC/Other/IE_Data_Commons_Prototype/NEW_LIST/4_PE_EnergyIntensity_MaterialProduction_Hertwich_2015.xlsx

[stefanpauliuk]

They are in my dropbox and appear as synched. The four files that I changed before the conference are in \Dropbox\G7 RECC\Other\IE_Data_Commons_Prototype\NEW_TABLE and carry July 2nd as last change date. If you can't see them I will email them to you.

[nheeren]

Oh, nevermind! I actually looked in the wrong place. Sorry.

[nheeren]

Today, I tried uploading the files not affected by #21. Here is the result:

• 1_F_ElectricityGeneration_IEA_HeadlineEnergyData_2016 could not be uploaded because it caused the following error:

  aspect_2 electricity generation from nuclear reactors 6 not in classification_items aspect_2 electricity generation from renewable sources 6 not in classification_items aspect_2 electricity generation, total 6 not in classification_items

• 6_MIP_SI.POV.GINI_WorldBank_2019

  • uploaded successfully
  • Needs further attention: https://github.com/IndEcol/IE_data_commons/issues/23#issuecomment-507737192

• 1_F_FinalEnergyConsumption_TFC_ByCountryAndSector_IEA_2018 not uploaded and caused the following error:

  aspect_5 industry 6 not in classification_items aspect_5 transport 6 not in classification_items aspect_5 residential 6 not in classification_items aspect_5 other (commercial and public services, agriculture/forestry, fishing and non-specified) 6 not in classification_items aspect_5 non-energy use 6 not in classification_items

• 6_IMI_EU_Regional_Carbon_Footprint_Ivanova_2017 uploaded successfully

@stefanpauliuk Could you please look into 1_F_FinalEnergyConsumption_TFC_ByCountryAndSector_IEA_2018 and 1_F_ElectricityGeneration_IEA_HeadlineEnergyData_2016. I could have changed the electricity source, etc. but I was not 100% sure if I am thinking of the correct ones.

[stefanpauliuk]

Thanks for checking! The missing classification items were added. Please upload again!

[nheeren]

Thank you! Today, I uploaded the following datasets:

• 1_F_ElectricityGeneration_IEA_HeadlineEnergyData_2016
• 1_F_FinalEnergyConsumption_TFC_ByCountryAndSector_IEA_2018

Therefore all datasets that are not subject to #21 are uploaded now. Closing this issue -- let's discuss the remaining two datasets over there.