quintel / etmodel

Professional interface of the Energy Transition model.
https://energytransitionmodel.com/
MIT License
25 stars 12 forks source link

Remove unused input_elements from the database #364

Closed robbertdol closed 12 years ago

robbertdol commented 12 years ago

These are unused:

id key 570 coal_from_western_europe_share 448 industry_demand 134 investment_costs_solar_concentrated_solar_power 517 mw_of_co_firing_coal 518 mw_of_co_firing_gas 506 mw_of_coal_conventional 505 mw_of_coal_igcc_ccs 504 mw_of_coal_iggc 508 mw_of_coal_lignite 507 mw_of_coal_oxyfuel_ccs 502 mw_of_concentrated_solar_power 519 mw_of_electricity_biomass_chp 509 mw_of_electricity_central_coal_chp 553 mw_of_electricity_decentral_coal_chp_fixed 516 mw_of_electricity_large_gas_chp 557 mw_of_electricity_lignite_chp 513 mw_of_electricity_micro_chp 512 mw_of_electricity_small_chp 510 mw_of_gas_ccgt 511 mw_of_gas_ccgt_ccs 492 mw_of_gas_conventional 498 mw_of_geothermal_electric 547 mw_of_heat_agriculture_small_gas_chp 556 mw_of_heat_backup_burner_fixed 536 mw_of_heat_bio_oil_chp_fixed 535 mw_of_heat_biomass_chp_fixed 538 mw_of_heat_biomass_fired_heater_district 537 mw_of_heat_biomass_fired_heater_fixed 521 mw_of_heat_central_coal_chp_fixed 530 mw_of_heat_coal_fired_heater 532 mw_of_heat_coal_fired_heater_district 554 mw_of_heat_decentral_coal_chp_fixed 539 mw_of_heat_electric_heat_pump_fixed 531 mw_of_heat_gas_fired_heat_pump 528 mw_of_heat_gas_fired_heater 533 mw_of_heat_gas_fired_heater_district 540 mw_of_heat_geothermal_fixed 546 mw_of_heat_industry_biomass_chp 545 mw_of_heat_industry_gas_chp 523 mw_of_heat_large_gas_chp_fixed 527 mw_of_heat_lignite_chp_fixed 522 mw_of_heat_micro_chp_fixed 529 mw_of_heat_oil_fired_heater 544 mw_of_heat_other_small_gas_chp 525 mw_of_heat_small_gas_chp_fixed 541 mw_of_heat_solar_water_heater_fixed 534 mw_of_heat_waste_fired_heater_district 520 mw_of_hydro_blue_energy 552 mw_of_hydro_mountain 497 mw_of_hydro_river 490 mw_of_nuclear_3rd_gen 515 mw_of_nuclear_conventional 496 mw_of_offshore 514 mw_of_oil_fired_plant 495 mw_of_onshore_coast 494 mw_of_onshore_land 491 mw_of_pulverized_coal 503 mw_of_pulverized_coal_ccs 501 mw_of_solar_pv_plants 500 mw_of_solar_pv_roofs 499 mw_of_waste_incinerator 262 number_of_co_firing_gas 277 number_of_decentral_coal_chp_fixed 573 oil_from_north_america_share 574 oil_from_south_america_share 196 policy_area_biomass 197 policy_area_green_gas 447 policy_cost_energy_use 210 policy_grid_baseload_maximum 211 policy_grid_intermittent_maximum 558 share_biomass_co_firing_coal 297 transport_bio_gas_share 296 transport_natural_gas_share

robbertdol commented 12 years ago

Do we wanna keep this?

query to select them: SELECT id,key FROM input_elements WHERE id NOT IN (1,6,11,12,14,16,17,18,19,43,44,47,48,51,52,57,58,59,114,115,116,121,126,127,129,130,131,132,133,136,137,138,139,140,141,142,143,144,145,146,147,148,157,158,159,169,170,171,178,179,180,181,182,183,185,186,187,188,193,194,195,198,202,203,204,205,206,207,208,212,213,214,216,217,218,219,220,221,223,225,227,228,229,230,231,232,233,234,238,239,240,241,242,245,246,247,248,250,251,253,254,255,256,257,258,259,260,261,263,264,265,266,267,268,270,271,272,274,275,276,279,280,281,282,283,286,289,290,291,292,293,294,295,298,299,313,315,316,317,321,322,324,325,326,327,328,333,335,336,337,338,339,340,341,343,344,346,347,348,351,352,353,354,355,356,357,359,360,361,362,363,364,366,368,370,371,372,373,374,375,376,377,378,381,382,383,385,386,387,388,389,390,391,392,393,394,395,396,397,398,400,401,402,403,404,405,406,408,409,411,412,413,414,415,416,420,421,422,423,424,425,426,427,428,429,430,431,432,433,435,436,437,439,441,443,444,445,446,488,489,548,549,550,551,559,560,561,562,563,564,565,566,567,568,569,571,572,575,576,577,578,579,580,581) LIMIT 0,1000;

dennisquintel commented 12 years ago

I would like them to be deleted from beta.

@AlexanderWirtz: do you agree? This has a small risk, but we need to clean up.

robbertdol commented 12 years ago

this also includes all the ( never used ;-( ) mw sliders

AlexanderWirtz commented 12 years ago

I am fine with cleaning up. Do we have a ticket somewhere that one day we DO want to be able to show MW sliders? Will it be a lot of extra work to re-create them for when we do? If so, please leave them. I wouldn't want this to delay the glorious day that we get rid of the # of windmills slider, for example.

dennisquintel commented 12 years ago

We still have the ambition to make up for 'flexible units'. In fact, @hasclass already created that (untested) on ETEngine. When ETFlex flies, we can have @antw work on this.

robbertdol commented 12 years ago

i will remove the and send a backup to dennis!

robbertdol commented 12 years ago

on the engine the related input will also be backupped and removed

robbertdol commented 12 years ago

removed 73 input_elements and inputs