CiaranOtter
commented
1 year ago Hey Gemma. I found the issue. The headers that datadesk found in the greenhouse data were too long to be saved in the database based on the specification i gave it. I have resolved this problem and successfully updated the dataset.
Hiya Ciaran!
I received this message (below) when I tried to change the category for 'Greenhouse gas emissions for 55 African countries'.
I am also struggling to change the categories of 'Covid-19 vaccinations in South Africa', 'Flood exposure and poverty estimates in 188 countries' and 'SA Mayors Ages'.
UPDATE tables SET last_updated=CURRENT_TIMESTAMP, str_name='Greenhouse gas emissions for 55 African countries', data_source='https://docs.google.com/spreadsheets/d/1jgpYXwZ-FwKPWx8TK1A7XK8v4ZslIk6qEKEf9Y_xVYM/edit#gid=493247727', description='Carbon dioxide and greenhouse gas emissions for 55 African countries going back as far as the 1950s and beyond up to 2020. It contains more than 50 variables including CO2 emissions, CO2 emissions per capita, emissions per sector, cumulative CO2 as well as global share of CO2. This is a subset of Our World in Charts full CO2 and greenhouse gas emissions data which is available on github https://github.com/owid/co2-data along with the sources and explanation of the variables.', row_count=4235, col_count=60, headings='iso_code,country,year,co2,co2_per_capita,trade_co2,cement_co2,cement_co2_per_capita,coal_co2,coal_co2_per_capita,flaring_co2,flaring_co2_per_capita,gas_co2,gas_co2_per_capita,oil_co2,oil_co2_per_capita,other_industry_co2,other_co2_per_capita,co2_growth_prct,co2_growth_abs,co2_per_gdp,co2_per_unit_energy,consumption_co2,consumption_co2_per_capita,consumption_co2_per_gdp,cumulative_co2,cumulative_cement_co2,cumulative_coal_co2,cumulative_flaring_co2,cumulative_gas_co2,cumulative_oil_co2,cumulative_other_co2,trade_co2_share,share_global_co2,share_global_cement_co2,share_global_coal_co2,share_global_flaring_co2,share_global_gas_co2,share_global_oil_co2,share_global_other_co2,share_global_cumulative_co2,share_global_cumulative_cement_co2,share_global_cumulative_coal_co2,share_global_cumulative_flaring_co2,share_global_cumulative_gas_co2,share_global_cumulative_oil_co2,share_global_cumulative_other_co2,total_ghg,ghg_per_capita,total_ghg_excluding_lucf,ghg_excluding_lucf_per_capita,methane,methane_per_capita,nitrous_oxide,nitrous_oxide_per_capita,population,gdp,primary_energy_consumption,energy_per_capita,energy_per_gdp', source_name='', source_link='', status='active', category='Climate' WHERE id=211;