search

quintel / etsource

Data source for the Energy Transition Model
https://energytransitionmodel.com/
MIT License
12 stars 8 forks source link

Add EC guests to presets - Part II #631

Closed fvancamp closed 10 years ago

fvancamp commented 10 years ago

Deleted following scenarios from production database:

INSERT INTO `scenarios` (`id`, `author`, `title`, `description`, `created_at`, `updated_at`, `user_values`, `end_year`, `in_start_menu`, `user_id`, `preset_scenario_id`, `use_fce`, `present_updated_at`, `protected`, `area_code`, `source`, `balanced_values`)
VALUES
    (172526, NULL, 'Energy Convention 2013 - Joep van Leersum', '', '2013-10-31 19:35:26', '2013-10-31 19:35:26', '---\nhouseholds_number_of_inhabitants: 17.5\nhouseholds_useful_demand_hot_water_share: 1.0\nhouseholds_useful_demand_electric_appliances: 3.0\nhouseholds_useful_demand_lighting: 1.0\nhouseholds_useful_demand_cooking_per_person: 1.0\nhouseholds_useful_demand_heat_per_person: 1.0\nhouseholds_useful_demand_for_cooling: 1.0\nhouseholds_climate_influence: -1.0\nhouseholds_space_heater_combined_network_gas_share: 76.4654414\nhouseholds_space_heater_heatpump_ground_water_electricity_share: 1.0\nhouseholds_space_heater_district_heating_steam_hot_water_share: 3.9991214\nhouseholds_space_heater_wood_pellets_share: 4.1974359\nhouseholds_space_heater_electricity_share: 1.7324427\nhouseholds_space_heater_network_gas_share: 10.3839492\nhouseholds_space_heater_crude_oil_share: 1.0755671\nhouseholds_space_heater_coal_share: 0.1460423\nhouseholds_space_heater_heatpump_air_water_electricity_share: 1.0\nhouseholds_water_heater_combined_network_gas_share: 73.958357\nhouseholds_water_heater_micro_chp_network_gas_share: 1.0\nhouseholds_water_heater_district_heating_steam_hot_water_share: 2.7133477\nhouseholds_water_heater_resistive_electricity_share: 7.9552036\nhouseholds_water_heater_network_gas_share: 13.3730917\nhouseholds_water_heater_heatpump_air_water_electricity_share: 1.0\nhouseholds_solar_pv_solar_radiation_market_penetration: 5.0\nhouseholds_cooling_heatpump_ground_water_electricity_share: 2.0\nhouseholds_cooling_airconditioning_electricity_share: 97.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 1.0\nhouseholds_appliances_dishwasher_electricity_efficiency: 36.5\nhouseholds_appliances_fridge_freezer_electricity_efficiency: 46.4\nhouseholds_appliances_washing_machine_electricity_efficiency: 35.0\nhouseholds_appliances_clothes_dryer_electricity_efficiency: 50.0\nhouseholds_appliances_television_electricity_efficiency: 10.0\nhouseholds_appliances_computer_media_electricity_efficiency: 10.0\nhouseholds_appliances_vacuum_cleaner_electricity_efficiency: 10.0\nhouseholds_appliances_other_electricity_efficiency: 10.0\nhouseholds_lighting_incandescent_electricity_share: 70.0\nhouseholds_lighting_efficient_fluorescent_electricity_share: 25.0\nhouseholds_lighting_led_electricity_share: 5.0\ntransport_car_using_electricity_share: 10.0\ntransport_car_using_diesel_mix_share: 37.1317108\ntransport_car_using_gasoline_mix_share: 48.2403396\ntransport_car_using_lpg_share: 4.4592723\ntransport_car_using_compressed_natural_gas_share: 0.1686774\ntransport_truck_using_electricity_share: 10.0\ntransport_truck_using_diesel_mix_share: 90.0\ntransport_car_using_electricity_efficiency: 1.0\ntransport_truck_using_compressed_natural_gas_efficiency: 1.0\ntransport_car_using_diesel_mix_efficiency: 1.0\ninvestment_costs_wind_onshore: -5.0\ninvestment_costs_wind_offshore: -5.0\nom_costs_wind_onshore: -5.0\nom_costs_wind_offshore: -5.0\ninvestment_costs_solar_solar_panels: -20.0\nnumber_of_energy_power_supercritical_coal: 0.0\nnumber_of_energy_power_solar_pv_solar_radiation: 2.0\ntransport_road_mixer_diesel_diesel_share: 95.0\ntransport_road_mixer_diesel_biodiesel_share: 5.0\ntransport_road_mixer_gasoline_gasoline_share: 95.0\ntransport_road_mixer_gasoline_ethanol_share: 5.0\nnumber_of_energy_power_wind_turbine_offshore: 1830.0\n', 2030, NULL, NULL, 172525, 0, NULL, 1, 'nl', 'ETM', '---\nhouseholds_space_heater_micro_chp_network_gas_share: 0.0\nhouseholds_water_heater_coal_share: 0.0\nhouseholds_water_heater_fuel_cell_chp_network_gas_share: 0.0\nhouseholds_water_heater_wood_pellets_share: 0.0\nhouseholds_water_heater_heatpump_ground_water_electricity_share: 0.0\nhouseholds_water_heater_crude_oil_share: 0.0\ntransport_truck_using_gasoline_mix_share: 0.0\ntransport_truck_using_compressed_natural_gas_share: 0.0\n');

INSERT INTO `scenarios` (`id`, `author`, `title`, `description`, `created_at`, `updated_at`, `user_values`, `end_year`, `in_start_menu`, `user_id`, `preset_scenario_id`, `use_fce`, `present_updated_at`, `protected`, `area_code`, `source`, `balanced_values`)
VALUES
    (172133, NULL, 'Antonello Monti - Session EC', '', '2013-10-23 13:59:19', '2013-10-23 13:59:19', '---\npolicy_sustainability_co2_emissions: -25.0\npolicy_sustainability_renewable_percentage: 20.4\npolicy_cost_total_energy_cost: 20.0\ncosts_oil: 30.0\ncosts_coal: 15.0\ninvestment_costs_wind_onshore: -30.0\ninvestment_costs_wind_offshore: -30.0\nom_costs_wind_onshore: -50.0\nom_costs_wind_offshore: -50.0\ninvestment_costs_solar_solar_panels: -40.0\ncosts_co2: 20.0\ncosts_co2_free_allocation: 30.0\nhouseholds_useful_demand_electric_appliances: 2.0\nhouseholds_useful_demand_lighting: -2.0\nhouseholds_useful_demand_heat_per_person: -2.0\nhouseholds_useful_demand_for_cooling: 1.0\nhouseholds_number_of_inhabitants: 17.0\nhouseholds_number_of_new_houses: 1.8\nhouseholds_insulation_level_old_houses: 0.6\nhouseholds_space_heater_combined_network_gas_share: 70.7706432\nhouseholds_space_heater_heatpump_ground_water_electricity_share: 0.0787474\nhouseholds_space_heater_micro_chp_network_gas_share: 3.0\nhouseholds_space_heater_district_heating_steam_hot_water_share: 3.9991214\nhouseholds_space_heater_wood_pellets_share: 4.1974359\nhouseholds_space_heater_electricity_share: 1.7324427\nhouseholds_space_heater_network_gas_share: 5.0\nhouseholds_space_heater_crude_oil_share: 1.0755671\nhouseholds_space_heater_coal_share: 0.1460423\nhouseholds_space_heater_heatpump_air_water_electricity_share: 10.0\nhouseholds_water_heater_combined_network_gas_share: 69.3314487\nhouseholds_water_heater_district_heating_steam_hot_water_share: 2.7133477\nhouseholds_water_heater_heatpump_air_water_electricity_share: 10.0\nhouseholds_water_heater_resistive_electricity_share: 7.9552036\nhouseholds_water_heater_network_gas_share: 7.0\nhouseholds_water_heater_micro_chp_network_gas_share: 3.0\nhouseholds_solar_pv_solar_radiation_market_penetration: 10.0\nhouseholds_water_heater_solar_thermal_share: 3.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 10.0\nhouseholds_cooling_airconditioning_electricity_share: 90.0\nhouseholds_appliances_dishwasher_electricity_efficiency: 20.0\nhouseholds_appliances_fridge_freezer_electricity_efficiency: 20.0\nhouseholds_appliances_washing_machine_electricity_efficiency: 20.0\nhouseholds_appliances_clothes_dryer_electricity_efficiency: 20.0\nhouseholds_lighting_incandescent_electricity_share: 0.0\nhouseholds_lighting_efficient_fluorescent_electricity_share: 50.0\nhouseholds_lighting_led_electricity_share: 50.0\nbuildings_insulation_level: 1.0\nbuildings_space_heater_network_gas_share: 64.4603446\nbuildings_space_heater_collective_heatpump_water_water_ts_electricity_share: 14.8148148\nbuildings_space_heater_solar_thermal_share: 0.0632802\nbuildings_space_heater_wood_pellets_share: 0.1890397\nbuildings_space_heater_district_heating_steam_hot_water_share: 10.4725207\nbuildings_space_heater_electricity_share: 10.0\nbuildings_useful_demand_for_appliances: 1.8\nbuildings_lighting_standard_fluorescent_electricity_share: 0.0\nbuildings_lighting_efficient_fluorescent_electricity_share: 75.9259259\nbuildings_lighting_led_electricity_share: 24.0740741\nbuildings_lighting_savings_from_motion_detection_light: 52.0\nbuildings_lighting_savings_from_daylight_control_light: 40.0\ntransport_useful_demand_trains: 2.0\ntransport_useful_demand_truck_kms: -1.0\ntransport_car_using_electricity_share: 15.0\ntransport_car_using_diesel_mix_share: 39.8148148\ntransport_car_using_gasoline_mix_share: 35.7259129\ntransport_car_using_lpg_share: 4.4592723\ntransport_car_using_compressed_natural_gas_share: 5.0\ntransport_truck_using_diesel_mix_share: 90.0\ntransport_truck_using_compressed_natural_gas_share: 10.0\ntransport_useful_demand_planes_efficiency: 1.0\ntransport_car_using_electricity_efficiency: 1.0\ntransport_car_using_diesel_mix_efficiency: 0.5\nindustry_useful_demand_electricity_efficiency: 1.5\nindustry_useful_demand_useable_heat_efficiencty: 1.0\nindustry_burner_network_gas_share: 48.6078904\nindustry_burner_crude_oil_share: 25.0\nindustry_burner_coal_share: 0.3921096\nindustry_burner_wood_pellets_share: 1.0\nindustry_final_demand_steam_hot_water_share: 25.0\nnumber_of_industry_chp_combined_cycle_gas_power_fuelmix: 20.0\nnumber_of_industry_chp_engine_gas_power_fuelmix: 16.0\nnumber_of_energy_power_ultra_supercritical_coal: 1.2\nnumber_of_energy_power_supercritical_coal: 0.0\nnumber_of_energy_power_ultra_supercritical_cofiring_coal: 0.2\nnumber_of_energy_power_ultra_supercritical_network_gas: 0.0\nnumber_of_energy_power_wind_turbine_inland: 2000.0\nnumber_of_energy_power_wind_turbine_coastal: 200.0\nnumber_of_energy_power_wind_turbine_offshore: 2000.0\nsettings_enable_merit_order: 1.0\ntransport_road_mixer_diesel_diesel_share: 54.6296296\ntransport_road_mixer_diesel_biodiesel_share: 45.3703704\ntransport_road_mixer_gasoline_gasoline_share: 52.7777778\ntransport_road_mixer_gasoline_ethanol_share: 47.2222222\nnatural_gas_total_share: 98.0\ngreen_gas_total_share: 2.0\n', 2030, NULL, NULL, 172131, 0, NULL, 1, 'nl', 'ETM', '---\nhouseholds_water_heater_coal_share: 0.0\nhouseholds_water_heater_fuel_cell_chp_network_gas_share: 0.0\nhouseholds_water_heater_wood_pellets_share: 0.0\nhouseholds_water_heater_heatpump_ground_water_electricity_share: 0.0\nhouseholds_water_heater_crude_oil_share: 0.0\nhouseholds_cooling_heatpump_ground_water_electricity_share: 0.0\nbuildings_space_heater_crude_oil_share: 0.0\nbuildings_space_heater_coal_share: 0.0\nbuildings_space_heater_heatpump_air_water_network_gas_share: 0.0\ntransport_truck_using_electricity_share: 0.0\ntransport_truck_using_gasoline_mix_share: 0.0\n');

INSERT INTO `scenarios` (`id`, `author`, `title`, `description`, `created_at`, `updated_at`, `user_values`, `end_year`, `in_start_menu`, `user_id`, `preset_scenario_id`, `use_fce`, `present_updated_at`, `protected`, `area_code`, `source`, `balanced_values`)
VALUES
    (171781, NULL, 'EC final Stijn Santen', 'This model is national, whereas measures should be based in a European context. The international dimension is crucial for the success of energy policy.', '2013-10-22 12:13:31', '2013-10-22 12:13:31', '---\nhouseholds_number_of_inhabitants: 20.0\npolicy_sustainability_co2_emissions: -30.0\npolicy_cost_electricity_cost: 0.0\npolicy_cost_total_energy_cost: 0.0\npolicy_area_offshore: 39.0\npolicy_area_onshore_land: 200.0\npolicy_area_onshore_coast: 30.0\nhouseholds_useful_demand_electric_appliances: 3.0\nhouseholds_useful_demand_heat_per_person: 2.0\nhouseholds_number_of_new_houses: 1.8\nhouseholds_insulation_level_old_houses: 0.7\nhouseholds_insulation_level_new_houses: 3.0\nhouseholds_space_heater_combined_network_gas_share: 65.4700085\nhouseholds_space_heater_heatpump_ground_water_electricity_share: 1.0\nhouseholds_space_heater_district_heating_steam_hot_water_share: 12.0\nhouseholds_space_heater_wood_pellets_share: 6.0\nhouseholds_space_heater_electricity_share: 5.0\nhouseholds_space_heater_network_gas_share: 10.3839492\nhouseholds_space_heater_crude_oil_share: 0.0\nhouseholds_space_heater_coal_share: 0.1460423\nhouseholds_water_heater_combined_network_gas_share: 73.0447964\nhouseholds_water_heater_heatpump_ground_water_electricity_share: 1.0\nhouseholds_water_heater_district_heating_steam_hot_water_share: 12.0\nhouseholds_water_heater_resistive_electricity_share: 7.9552036\nhouseholds_water_heater_network_gas_share: 0.0\nhouseholds_water_heater_wood_pellets_share: 6.0\nhouseholds_solar_pv_solar_radiation_market_penetration: 0.6\nhouseholds_water_heater_solar_thermal_share: 4.0\nhouseholds_cooling_heatpump_ground_water_electricity_share: 1.0\nhouseholds_cooling_airconditioning_electricity_share: 99.0\nhouseholds_cooker_network_gas_share: 46.224088\nhouseholds_cooker_resistive_electricity_share: 15.8473126\nhouseholds_cooker_halogen_electricity_share: 7.9285993\nhouseholds_cooker_induction_electricity_share: 30.0\nhouseholds_appliances_dishwasher_electricity_efficiency: 35.3\nhouseholds_appliances_fridge_freezer_electricity_efficiency: 45.0\nhouseholds_appliances_washing_machine_electricity_efficiency: 32.2\nhouseholds_appliances_clothes_dryer_electricity_efficiency: 50.8\nhouseholds_appliances_television_electricity_efficiency: 16.1\nhouseholds_appliances_computer_media_electricity_efficiency: 46.7\nhouseholds_appliances_vacuum_cleaner_electricity_efficiency: 0.0\nhouseholds_appliances_other_electricity_efficiency: 43.9\nhouseholds_lighting_incandescent_electricity_share: 30.0\nhouseholds_lighting_efficient_fluorescent_electricity_share: 35.0\nhouseholds_lighting_led_electricity_share: 35.0\nhouseholds_behavior_turn_off_the_light: 80.0\nhouseholds_behavior_standby_killer_turn_off_appliances: 80.0\nhouseholds_behavior_close_windows_turn_off_heating: 30.0\nhouseholds_behavior_low_temperature_washing: 30.0\nnumber_of_buildings: -1.0\nbuildings_insulation_level: 1.0\nbuildings_space_heater_network_gas_share: 66.7476801\nbuildings_space_heater_collective_heatpump_water_water_ts_electricity_share: 8.0\nbuildings_space_heater_solar_thermal_share: 0.0632802\nbuildings_space_heater_wood_pellets_share: 0.1890397\nbuildings_space_heater_district_heating_steam_hot_water_share: 20.0\nbuildings_space_heater_electricity_share: 5.0\nbuildings_collective_chp_wood_pellets_share: 5.2137727\nbuildings_chp_engine_biogas_share: 4.0353886\nbuildings_collective_chp_network_gas_share: 0.0\nbuildings_heat_network_connection_steam_hot_water_share: 90.7508387\nbuildings_cooling_collective_heatpump_water_water_ts_electricity_share: 8.0\nbuildings_cooling_heatpump_air_water_network_gas_share: 0.0\nbuildings_cooling_airconditioning_share: 92.0\nbuildings_useful_demand_for_appliances: 1.0\nbuildings_lighting_standard_fluorescent_electricity_share: 55.0\nbuildings_lighting_efficient_fluorescent_electricity_share: 20.0\nbuildings_lighting_led_electricity_share: 25.0\nbuildings_lighting_savings_from_motion_detection_light: 80.0\nbuildings_lighting_savings_from_daylight_control_light: 80.0\nbuildings_solar_pv_solar_radiation_market_penetration: 1.0\ntransport_useful_demand_car_kms: 1.0\ntransport_useful_demand_truck_kms: -1.0\ntransport_useful_demand_trains: 1.0\ntransport_useful_demand_ships: 3.0\ntransport_car_using_electricity_share: 15.0\ntransport_car_using_diesel_mix_share: 50.0\ntransport_car_using_gasoline_mix_share: 25.5407277\ntransport_car_using_lpg_share: 4.4592723\ntransport_car_using_compressed_natural_gas_share: 5.0\ntransport_truck_using_diesel_mix_share: 90.0\ntransport_truck_using_compressed_natural_gas_share: 5.0\ntransport_truck_using_electricity_share: 5.0\ntransport_useful_demand_trains_efficiency: 1.0\ntransport_car_using_electricity_efficiency: 2.0\ntransport_useful_demand_ships_efficiency: 1.5\ntransport_useful_demand_planes_efficiency: 1.5\nindustry_useful_demand_crude_oil_non_energetic: 1.0\nindustry_useful_demand_network_gas_non_energetic: 1.0\nindustry_useful_demand_electricity: 0.5\nindustry_useful_demand_useable_heat: 0.5\nindustry_useful_demand_electricity_efficiency: 2.5\nindustry_useful_demand_useable_heat_efficiencty: 2.5\nindustry_burner_network_gas_share: 49.1447014\nindustry_burner_crude_oil_share: 20.0\nindustry_burner_coal_share: 0.3921096\nindustry_burner_wood_pellets_share: 0.463189\nindustry_final_demand_steam_hot_water_share: 30.0\nnumber_of_industry_chp_engine_gas_power_fuelmix: 0.0\nindustry_steel_production: 0.6\nindustry_steel_blastfurnace_current_consumption_useable_heat_share: 0.0\nindustry_steel_electricfurnace_electricity_share: 8.0\nindustry_steel_hisarna_consumption_useable_heat_share: 50.0\nindustry_steel_blastfurnace_bat_consumption_useable_heat_share: 42.0\nindustry_aluminium_electrolysis_current_electricity_share: 0.0\nindustry_aluminium_smeltoven_electricity_share: 40.0\nindustry_aluminium_electrolysis_bat_electricity_share: 60.0\nagriculture_useful_demand_electricity: 0.5\nagriculture_useful_demand_useable_heat: 0.5\nagriculture_burner_network_gas_share: 67.0\nagriculture_burner_crude_oil_share: 0.0\nagriculture_burner_wood_pellets_share: 3.0\nagriculture_heatpump_water_water_ts_electricity_share: 10.0\nagriculture_geothermal_share: 10.0\nagriculture_final_demand_steam_hot_water_share: 10.0\nnumber_of_agriculture_chp_engine_network_gas: 320.0\ncosts_co2_free_allocation: 50.0\ncosts_co2: 400.0\ninvestment_costs_earth_geothermal_electricity: -20.0\nom_costs_earth_geothermal_electricity: -40.0\ninvestment_costs_fuel_cell: -30.0\ninvestment_costs_electric_heat_pumps: -20.0\nom_costs_co2_ccs: -30.0\ninvestment_costs_co2_ccs: -25.0\nnumber_of_energy_chp_combined_cycle_network_gas: 12.0\nnumber_of_energy_chp_ultra_supercritical_cofiring_coal: 3.0\nnumber_of_energy_power_combined_cycle_ccs_coal: 2.2\nnumber_of_energy_power_ultra_supercritical_ccs_coal: 2.2\nnumber_of_energy_power_supercritical_coal: 0.0\nnumber_of_energy_power_ultra_supercritical_coal: 0.0\nnumber_of_energy_power_combined_cycle_coal: 0.0\nnumber_of_energy_power_wind_turbine_coastal: 400.0\nnumber_of_energy_heater_for_heat_network_waste_mix: 400.0\nnatural_gas_total_share: 99.5\ngreen_gas_total_share: 0.5\n', 2030, NULL, NULL, 171778, 0, NULL, 1, 'nl', 'ETM', '---\nhouseholds_space_heater_micro_chp_network_gas_share: 0.0\nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.0\nhouseholds_water_heater_coal_share: 0.0\nhouseholds_water_heater_fuel_cell_chp_network_gas_share: 0.0\nhouseholds_water_heater_micro_chp_network_gas_share: 0.0\nhouseholds_water_heater_heatpump_air_water_electricity_share: 0.0\nhouseholds_water_heater_crude_oil_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooker_wood_pellets_share: 1.0e-07\nbuildings_space_heater_crude_oil_share: 0.0\nbuildings_space_heater_coal_share: 0.0\nbuildings_space_heater_heatpump_air_water_network_gas_share: 0.0\nbuildings_collective_geothermal_share: 0.0\nbuildings_cooling_collective_cooling_network_electricity_share: 0.0\ntransport_truck_using_gasoline_mix_share: 0.0\nindustry_aluminium_carbothermalreduction_electricity_share: 0.0\n');

INSERT INTO `scenarios` (`id`, `author`, `title`, `description`, `created_at`, `updated_at`, `user_values`, `end_year`, `in_start_menu`, `user_id`, `preset_scenario_id`, `use_fce`, `present_updated_at`, `protected`, `area_code`, `source`, `balanced_values`)
VALUES
    (171775, NULL, 'Frank Vanclay - Session EC', '', '2013-10-22 09:50:47', '2013-10-22 09:50:47', '---\ncosts_oil: 100.0\ncosts_co2: 400.0\ncosts_gas: 50.0\ncosts_biomass: -50.0\ncosts_co2_free_allocation: 0.0\ninvestment_costs_solar_solar_panels: -50.0\nhouseholds_number_of_inhabitants: 17.2\nhouseholds_climate_influence: 0.5\nhouseholds_number_of_new_houses: 6.0\nhouseholds_number_of_old_houses: 2.0\nhouseholds_insulation_level_new_houses: 2.5\nhouseholds_insulation_level_old_houses: 1.0\nhouseholds_space_heater_combined_network_gas_share: 82.5675573\nhouseholds_space_heater_heatpump_ground_water_electricity_share: 0.5\nhouseholds_space_heater_district_heating_steam_hot_water_share: 10.0\nhouseholds_space_heater_wood_pellets_share: 0.0\nhouseholds_space_heater_electricity_share: 1.7324427\nhouseholds_space_heater_network_gas_share: 5.0\nhouseholds_space_heater_crude_oil_share: 0.0\nhouseholds_space_heater_coal_share: 0.0\nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.1\nhouseholds_space_heater_micro_chp_network_gas_share: 0.1\nhouseholds_water_heater_combined_network_gas_share: 74.6447964\nhouseholds_water_heater_district_heating_steam_hot_water_share: 10.0\nhouseholds_water_heater_resistive_electricity_share: 7.955203587915573\nhouseholds_water_heater_network_gas_share: 6.7\nhouseholds_water_heater_heatpump_ground_water_electricity_share: 0.5\nhouseholds_water_heater_micro_chp_network_gas_share: 0.1\nhouseholds_water_heater_heatpump_air_water_electricity_share: 0.1\nhouseholds_water_heater_wood_pellets_share: 0.0\nhouseholds_water_heater_crude_oil_share: 0.0\nhouseholds_water_heater_coal_share: 0.0\nhouseholds_water_heater_fuel_cell_chp_network_gas_share: 0.0\nhouseholds_collective_geothermal_share: 5.0\nhouseholds_heat_network_connection_steam_hot_water_share: 95.0\nhouseholds_solar_pv_solar_radiation_market_penetration: 10.0\nhouseholds_water_heater_solar_thermal_share: 5.0\nhouseholds_cooling_heatpump_ground_water_electricity_share: 0.5\nhouseholds_cooling_airconditioning_electricity_share: 99.4\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.1\nhouseholds_cooker_network_gas_share: 49.6296296\nhouseholds_cooker_resistive_electricity_share: 7.4074074\nhouseholds_cooker_halogen_electricity_share: 12.962963\nhouseholds_cooker_induction_electricity_share: 30.0\nhouseholds_lighting_incandescent_electricity_share: 10.0\nhouseholds_lighting_efficient_fluorescent_electricity_share: 30.0\nhouseholds_lighting_led_electricity_share: 60.0\nhouseholds_behavior_standby_killer_turn_off_appliances: 20.0\nhouseholds_behavior_turn_off_the_light: 20.0\nhouseholds_behavior_close_windows_turn_off_heating: 20.0\nhouseholds_behavior_low_temperature_washing: 20.0\nbuildings_insulation_level: 1.8\nbuildings_space_heater_network_gas_share: 45.7476801\nbuildings_space_heater_collective_heatpump_water_water_ts_electricity_share: 4.0\nbuildings_space_heater_solar_thermal_share: 0.0632802\nbuildings_space_heater_wood_pellets_share: 0.1890397\nbuildings_space_heater_district_heating_steam_hot_water_share: 50.0\nbuildings_chp_engine_biogas_share: 4.0\nbuildings_collective_chp_network_gas_share: 5.0\nbuildings_collective_geothermal_share: 10.0\nbuildings_heat_network_connection_steam_hot_water_share: 81.0\nbuildings_collective_chp_wood_pellets_share: 0.0\nbuildings_useful_demand_for_appliances: 2.0\nbuildings_lighting_standard_fluorescent_electricity_share: 10.0\nbuildings_lighting_efficient_fluorescent_electricity_share: 30.0\nbuildings_lighting_led_electricity_share: 60.0\nbuildings_lighting_savings_from_motion_detection_light: 75.0\nbuildings_lighting_savings_from_daylight_control_light: 75.0\nbuildings_solar_pv_solar_radiation_market_penetration: 50.0\ntransport_useful_demand_car_kms: -2.0\ntransport_useful_demand_truck_kms: 2.0\ntransport_useful_demand_trains: 5.0\ntransport_car_using_electricity_share: 20.0\ntransport_car_using_diesel_mix_share: 50.0\ntransport_car_using_gasoline_mix_share: 20.0\ntransport_car_using_lpg_share: 5.0\ntransport_car_using_compressed_natural_gas_share: 5.0\ntransport_truck_using_diesel_mix_share: 90.0\ntransport_truck_using_compressed_natural_gas_share: 10.0\ntransport_car_using_electricity_efficiency: 2.0\ntransport_truck_using_compressed_natural_gas_efficiency: 0.5\ntransport_car_using_diesel_mix_efficiency: 0.5\ntransport_useful_demand_trains_efficiency: 0.1\ntransport_useful_demand_ships_efficiency: 0.1\nindustry_useful_demand_electricity_efficiency: 1.0\nindustry_useful_demand_useable_heat_efficiencty: 1.0\nindustry_burner_network_gas_share: 40.0148148\nindustry_burner_crude_oil_share: 9.9851852\nindustry_burner_coal_share: 0.0\nindustry_burner_wood_pellets_share: 20.0\nindustry_final_demand_steam_hot_water_share: 30.0\nnumber_of_industry_chp_combined_cycle_gas_power_fuelmix: 15.0\nagriculture_useful_demand_electricity: -0.1\nagriculture_useful_demand_useable_heat: -0.1\nagriculture_burner_network_gas_share: 18.5541108\nagriculture_burner_crude_oil_share: 5.5555556\nagriculture_burner_wood_pellets_share: 20.0\nagriculture_heatpump_water_water_ts_electricity_share: 0.4024861\nagriculture_geothermal_share: 5.0\nagriculture_final_demand_steam_hot_water_share: 50.4878475\nnumber_of_agriculture_chp_engine_biogas: 120.0\nnumber_of_agriculture_chp_supercritical_wood_pellets: 10.0\nnumber_of_energy_power_ultra_supercritical_coal: 0.0\nnumber_of_energy_power_ultra_supercritical_cofiring_coal: 2.0\nnumber_of_energy_power_combined_cycle_coal: 0.0\nnumber_of_energy_power_supercritical_coal: 0.0\nnumber_of_energy_chp_ultra_supercritical_coal: 0.0\nnumber_of_energy_chp_ultra_supercritical_cofiring_coal: 1.0\nnumber_of_energy_power_turbine_network_gas: 4.0\nnumber_of_energy_power_ultra_supercritical_network_gas: 3.0\nnumber_of_energy_chp_combined_cycle_network_gas: 46.0\nnumber_of_energy_power_nuclear_gen3_uranium_oxide: 0.0\nnumber_of_energy_power_wind_turbine_inland: 1000.0\nnumber_of_energy_power_wind_turbine_coastal: 300.0\nnumber_of_energy_power_wind_turbine_offshore: 500.0\nnumber_of_energy_power_supercritical_waste_mix: 10.0\nnumber_of_energy_chp_supercritical_waste_mix: 10.0\ntransport_road_mixer_diesel_diesel_share: 0.0\ntransport_road_mixer_diesel_biodiesel_share: 100.0\ntransport_road_mixer_gasoline_gasoline_share: 0.0\ntransport_road_mixer_gasoline_ethanol_share: 100.0\ntransport_rail_mixer_diesel_diesel_share: 0.0\ntransport_rail_mixer_diesel_biodiesel_share: 100.0\ntransport_ship_using_diesel_share: 0.0\ntransport_ship_using_biodiesel_share: 100.0\nnatural_gas_total_share: 90.0\ngreen_gas_total_share: 10.0\nco_firing_coal_share: 50.0\nco_firing_biocoal_share: 50.0\nenergy_mixer_for_gas_power_fuel_natural_gas_share: 71.8238595\nenergy_mixer_for_gas_power_fuel_bio_oil_share: 10.0\n', 2030, NULL, NULL, 171767, 0, NULL, 1, 'nl', 'ETM', '---\nhouseholds_collective_chp_network_gas_share: 0.0\nhouseholds_collective_chp_biogas_share: 0.0\nhouseholds_collective_chp_wood_pellets_share: 0.0\nhouseholds_cooker_wood_pellets_share: 0.0\nbuildings_space_heater_crude_oil_share: 0.0\nbuildings_space_heater_coal_share: 0.0\nbuildings_space_heater_electricity_share: 0.0\nbuildings_space_heater_heatpump_air_water_network_gas_share: 0.0\ntransport_truck_using_electricity_share: 0.0\ntransport_truck_using_gasoline_mix_share: 0.0\ntransport_ship_using_heavy_fuel_oil_share: 0.0\nenergy_mixer_for_gas_power_fuel_crude_oil_share: 18.1761405\n');
dennisquintel commented 10 years ago

Hmmm, it might be a problem that etmodel (production) still stores a reference on its table saved_scenarios:

I am deleting one now to test it.

INSERT INTO `saved_scenarios` (`id`, `user_id`, `scenario_id`, `settings`, `created_at`, `updated_at`)
VALUES
    (2395, 1884, 173612, NULL, '2013-11-12 13:26:04', '2013-11-12 13:26:04');
dennisquintel commented 10 years ago

Hmmm, it might be a problem that etmodel (production) still stores a reference on its table saved_scenarios:

No, that's not it.... some reloading issue on etengine...

ChaelKruip commented 10 years ago

assigning @dennisschoenmakers

Is this still relevant @dennisschoenmakers ?