This repository contains input data for the open-source Python tool eTraGo (electricity Transmission Grid optimization) version 0.10.0.
This data will be uploaded to the OpenEnergy Platform which can be accessed by eTraGo. This dataset is an intermediate solution until the data is uploaded.

The published data includes the sector-coupled transmission grid data for the scenario status2019. It was created with the open-source tool powerd-data within the research project PoWerD. All input data sets as well as the code are available under open source licenses.

We thank the Federal Ministry for Economic Affairs and Climate Action for funding the research project PoWerD (grant number: 03EI1042C)

The data is stored as a PostgreSQL database in the attached backup file. First, the required schemas and extensions have to be created within the database by running the following SQL statements:

CREATE EXTENSION postgis;

Afterwards, the data can be restored by using e.g. pgAdmin or via PostgreSQL's pg_restore command (replace HOST, DATABASE_NAME, PORT and USER by your settings):

pg_restore --host HOST --port PORT --username USER --no-password --dbname DATABASE_NAME --no-owner --no-privileges --verbose "PoWerD_status2019.backup"

THIS VERSION IS OUTDATED, PLEASE CHECK OUT THE LAST VERSION HERE: https://zenodo.org/record/6771217

_

This repository contains result data for the paper "Open modeling of electricity and heat demand curves for all residential buildings in Germany".

The published data includes residential electricity and heat demand profiles for every building in Germany. It was created with the open source tool eGon-data within the research project eGon. All input data sets as well as the code are available under open source licenses.

Files

• The profile data is stored as PostgreSQL database in attached backup file. The data can be restored by using e.g. pgAdmin or via PostgreSQL's pg_restore command. See section Database structure below for details.
• Unpack the zip files.
• The directory scripts/ contains example scripts to obtain electricity and heat profiles.
• The directory additional_data/ contains TRY climate zones and weather data which can be used to extract heat profiles.
• See section Example scripts below for details.

Database structure

After restoring the backup file, the data is stored in different schemas: society, openstreetmap and demand. Different tables have to be combined to create the final demand time series for heat and electricity. In the following, the tables and the matching methods are described.

The schema society includes data from Census 2011 on population in 100m x 100m cells ('Census cells'). The cells are georeferenced and have a unique id.

Schema: society

• destatis_zensus_population_per_ha_inside_germany
  National census in Germany in 2011 with the bounds on Germanys borders.
  • id: Unique identifier
  • grid_id: Grid number of Census
  • population: Number of registred residents
  • geom_point: Geometry centroid (CRS: ERTS89)
  • geom: Geometry (CRS: ERTS89)

Schema: openstreetmap

The schema openstreetmap includes data on residential buildings. All buildings hold an internal building_id. All residential buildings extracted from openstreetmap are stored in openstreetmap.osm_buildings_residential including osm_id and internal building_id. Additional, synthetic buildings are stored in openstreetmap.osm_buildings_synthetic.

• osm_buildings_residential: Filtered list of residential buildings from OpenStreetMap - (c) OpenStreetMap contributors
  • id: Building id
  • osm_id: Openstreetmap id
  • amenity: Amenity in building
  • building: Type of building
  • name: Name of the building
  • geom: Polygon of building (CRS: ERTS89)
  • area: Surface area of building
  • geom_point: Centroid of building (CRS: ERTS89)
  • tags: Opensteetmap tags
• osm_buildings_synthetic: List of generated synthetic buildings
  • id: Building id
  • geom: Polygon of building (CRS: ERTS89)
  • geom_point: Centroid of building (CRS: ERTS89)
  • grid_id: Census grid id (reference to: society.destatis_zensus_population_per_ha_inside_germany.grid_id)
  • cell_id: Census cell id (reference to: society.destatis_zensus_population_per_ha_inside_germany.id)
  • building: Building type (residential)
  • area: Surface area

Schema: demand

With the profile_ids in egon_household_electricity_profile_of_buildings, specific profiles from iee_household_load_profiles are mapped to all residential buildings. The profiles need to be scaled therafter by their annual sum and the corresponding scaling factors, which can be found in egon_household_electricity_profile_in_census_cell and matched per census cell id.

• egon_household_electricity_profile_in_census_cell: Mapping table for household electricity profiles to census cell including scaling factors for two scenarios (eGon2035, eGon100RE) .
  • cell_id: Census cell id (reference to: society.destatis_zensus_population_per_ha_inside_germany.id)
  • grid_id: Census grid id
  • cell_profile_ids: Household profile ids
  • nuts3: NUTS 3 code
  • nuts1: NUTS 1 code
  • factor_2035: Scaling factor for scenario eGon2035
  • factor_2050: Scaling factor for scenario eGon100RE
• iee_household_load_profiles: 100.000 annual profiles in hourly resolution of electricity demand of private households for different household types (singles, couples, other) with varying number of elderly and children. The profiles were created using a bottom-up load profile generator by Fraunhofer IEE developed in the Bachelor's thesis "Auswirkungen verschiedener Haushaltslastprofile auf PV-Batterie-Systeme" by Jonas Haack, Fachhochschule Flensburg, December 2012. The columns are named as follows: "
• egon_household_electricity_profile_of_building: Mapping table for household electricity profiles to buildings via internal building_id and corresponding census cell_id.
  • id: Unique identifier
  • building_id: Building id (reference to: osm_buildings_residential.id, osm_buildings_synthetic.id)
  • cell_id: Census cell id (reference to: society.destatis_zensus_population_per_ha_inside_germany.id)
  • profile_id: Household profile id (reference to: iee_household_load_profiles.type)

Heat demand profiles per building can be created by combining the tables egon_peta_heat, heat_idp_pool and heat_timeseries_selected_profiles. In addition, weather data (e.g. from ERA5, located in additional_data/) is needed to distribute the annual heat demands to single days. This is included in the example script, the usage is described below.

• egon_peta_heat: Table for annual heat demands of residential and service sector per Census cell
  • demand: Annual heat demand in MWh
  • id: Unique identifier
  • scenario: Scenario name (either eGon2035 or eGon100RE)
  • sector: Demand sector (either 'residential' or 'service')
  • zensus_population_id: id of the Census cell (reference to: society.destatis_zensus_population_per_ha_inside_germany.id)
• heat_idp_pool: About 460,000 inidvidual daily heat demand profiles per building including the temeprature class and building type.
  • house: Single- or multi-family house
  • idp: Normalized demand timeseries for one day (24 hours)
  • index: Unique identifier
  • temperature_class: Number of corresponding temperature class
• heat_timeseries_selected_profiles: Mapping table for household heat profiles to buildings per day via internal building_id and corresponding census cell_id.
  • ID: Unique identifier
  • building_id: Id of the corresponding building (reference to: osm_buildings_residential.id, osm_buildings_synthetic.id)
  • selected_ipd_profiles: Array of selected profiles per day (values in array refer to: heat_idp_pool.index)
  • zensus_population_id: id of corresponding Census cell (reference to: society.destatis_zensus_population_per_ha_inside_germany.id)

Weather data and the used climate zones are not included in the database. They are stored in files which are part of the additional_data/ folder. In this folder, you find the following data sets:

• TRY_Climate_Zone: Climate zones in Germany
  • source: Own representation based on DWD TRY climate zones
  • License: Attribution 4.0 International (CC BY 4.0)
• germany-2011-era5.nc: ERA 5 Weather data for the year 2011
  • Source: https://cds.climate.copernicus.eu/cdsapp#!/dataset/reanalysis-era5-single-levels?tab=overview
  • Terms of Use: https://cds.climate.copernicus.eu/api/v2/terms/static/20180314_Copernicus_License_V1.1.pdf

Example queries

Electricity profiles: The demand profiles for residential buildings can be obtained using the tables stored in the demand schema. To extract electricity demand profiles, the following tables have to be combined:

• egon_household_electricity_profile_in_census_cell
• iee_household_load_profiles
• egon_household_electricity_profile_of_building

Example script to obtain the electrical demand timeseries for 1 specific building for the eGon2035 scenario:

DEPRECATED. DO NOT USE. See current version at https://dx.doi.org/10.7799/1812548. See active link below in the resources section. Open sourced data needed to run the basic alpha release version of the dGen model. Includes a pre-generated agent file of 100,000 agents in pickle file format along with the base schema and table data in parquet format that are needed to create a postgreSQL database for the model to interact with.