owid / etl

A compute graph for loading and transforming OWID's data
https://docs.owid.io/projects/etl
MIT License
87 stars 23 forks source link

📊 energy: Update irena capacity data #3494

Closed pabloarosado closed 3 weeks ago

pabloarosado commented 3 weeks ago
owidbot commented 3 weeks ago
Quick links (staging server): Site Admin Wizard Docs

Login: ssh owid@staging-site-update-irena-capacity-data

chart-diff: ✅
  • 2/2 reviewed charts
  • Modified: 2/2
  • New: 0/0
  • Rejected: 0
data-diff: ❌ Found differences ```diff + Dataset garden/energy/2024-11-01/photovoltaic_cost_and_capacity + + Table photovoltaic_cost_and_capacity + + Column cost + + Column cost_source + + Column cumulative_capacity + + Column cumulative_capacity_source = Dataset garden/irena/2024-10-29/renewable_power_generation_costs = Table solar_photovoltaic_module_prices ~ Column cost (changed metadata) - - IRENA presents solar photovoltaic module prices for a number of different technologies. Here we use the figures for 'Thin film a-Si/u-Si or Global Price Index (from Q4 2013)'. ? ^^ ^^^^^^^^ + + IRENA presents solar photovoltaic module prices for a number of different technologies. Here we use the average yearly price for technologies 'Thin film a-Si/u-Si or Global Price Index (from Q4 2013)'. ? ^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ = Table renewable_power_generation_costs + Dataset garden/irena/2024-11-01/renewable_capacity_statistics + + Table renewable_capacity_statistics + + Column bioenergy__total + + Column biogas + + Column biogas__off_grid + + Column concentrated_solar_power + + Column geothermal + + Column geothermal__off_grid + + Column geothermal__total + + Column hydropower + + Column hydropower__off_grid + + Column hydropower__total + + Column hydropower__total__excl__pumped_storage + + Column liquid_biofuels + + Column liquid_biofuels__off_grid + + Column marine + + Column mixed_hydro_plants + + Column offshore_wind + + Column onshore_wind + + Column onshore_wind__off_grid + + Column pumped_storage + + Column renewable_municipal_waste + + Column renewables__total + + Column solar__total + + Column solar_photovoltaic + + Column solar_photovoltaic__off_grid + + Column solid_biofuels + + Column solid_biofuels__off_grid + + Column wind__total Legend: +New ~Modified -Removed =Identical Details Hint: Run this locally with etl diff REMOTE data/ --include yourdataset --verbose --snippet ``` Automatically updated datasets matching _weekly_wildfires|excess_mortality|covid|fluid|flunet|country_profile|garden/ihme_gbd/2019/gbd_risk_ are not included

Edited: 2024-11-06 08:00:24 UTC Execution time: 4.47 seconds

pabloarosado commented 3 weeks ago

LGTM! Is it expected that there's no chart diff? I see some charts have changed so I was a little surprised by that.

Thanks! Argh, it seems something went wrong on the staging server, I had already approved all charts. I'll check what's going on.