loadarea

OSM landuse extraction and load areas creation.

class LoadArea(dependencies)[source]

Bases: Dataset

Creates load area data based on OSM and census data.

Dependencies
Resulting tables

  • demand.egon_loadarea is created and filled (no associated Python class)

Create and update the demand.egon_loadarea table with new data, based on OSM and census data. Among other things, area updates are carried out, smaller load areas are removed, center calculations are performed, and census data are added. Statistics for various OSM sectors are also calculated and inserted. See also documentation section Load areas for more information.

Note: industrial demand contains:

  • voltage levels 4-7

  • only demand from ind. sites+osm located in LA!

name: str = 'LoadArea'
sources: DatasetSources = DatasetSources(tables={'osm_landuse': 'openstreetmap.osm_landuse', 'zensus_population': 'society.destatis_zensus_population_per_ha_inside_germany', 'vg250': 'boundaries.vg250_sta_union'}, files={'osm_landuse_melt': 'osm_landuse_melt.sql', 'census_cells_melt': 'census_cells_melt.sql', 'osm_landuse_census_cells_melt': 'osm_landuse_census_cells_melt.sql', 'loadareas_create': 'loadareas_create.sql', 'loadareas_add_demand_hh': 'loadareas_add_demand_hh.sql', 'loadareas_add_demand_cts': 'loadareas_add_demand_cts.sql', 'loadareas_add_demand_ind': 'loadareas_add_demand_ind.sql', 'drop_temp_tables': 'drop_temp_tables.sql'}, urls={})

The sources used by the datasets. Could be tables, files and urls

targets: DatasetTargets = DatasetTargets(tables={'egon_loadarea': 'demand.egon_loadarea'}, files={})

The targets created by the datasets. Could be tables and files

version: str = '0.0.4'
class OsmLanduse(dependencies)[source]

Bases: Dataset

OSM landuse extraction.

  • Landuse data is extracted from OpenStreetMap: residential, retail, industrial, Agricultural

  • Data is cut with German borders (VG 250), data outside is dropped

  • Invalid geometries are fixed

  • Results are stored in table openstreetmap.osm_landuse

Note: industrial demand contains:

  • voltage levels 4-7

  • only demand from ind. sites+osm located in LA!

name: str = 'OsmLanduse'
sources: DatasetSources = DatasetSources(tables={'osm_polygons': 'openstreetmap.osm_polygon', 'vg250': 'boundaries.vg250_sta_union'}, files={'osm_landuse_extraction': 'osm_landuse_extraction.sql'}, urls={})

The sources used by the datasets. Could be tables, files and urls

targets: DatasetTargets = DatasetTargets(tables={'osm_landuse': 'openstreetmap.osm_landuse'}, files={})

The targets created by the datasets. Could be tables and files

version: str = '0.0.3'
class OsmPolygonUrban(**kwargs)[source]

Bases: Base

Class definition of table openstreetmap.osm_landuse.

area_ha
geom
id
name
osm_id
sector
sector_name
tags
vg250
census_cells_melt()[source]

Melt all census cells: buffer, union, unbuffer

create_landuse_table()[source]

Create tables for landuse data :returns: None.

drop_temp_tables()[source]
execute_sql_script(script)[source]

Execute SQL script

Parameters:

script (str) – Filename of script

extract_osm_landuse()[source]
loadareas_add_demand_cts()[source]

Adds consumption and peak load to load areas for CTS

loadareas_add_demand_hh()[source]

Adds consumption and peak load to load areas for households

loadareas_add_demand_ind()[source]

Adds consumption and peak load to load areas for industry

loadareas_create()[source]

Create load areas from merged OSM landuse and census cells:

  • Cut Loadarea with MV Griddistrict

  • Identify and exclude Loadarea smaller than 100m².

  • Generate Centre of Loadareas with Centroid and PointOnSurface.

  • Calculate population from Census 2011.

  • Cut all 4 OSM sectors with MV Griddistricts.

  • Calculate statistics like NUTS and AGS code.

  • Check for Loadareas without AGS code.

osm_landuse_census_cells_melt()[source]

Melt OSM landuse areas and census cells

osm_landuse_melt()[source]

Melt all OSM landuse areas by: buffer, union, unbuffer