substation

The central module containing code to create substation tables

class EgonEhvTransferBuses(**kwargs)[source]

Bases: sqlalchemy.orm.decl_api.Base

bus_id
dbahn
frequency
lat
lon
operator
osm_id
osm_www
point
polygon
power_type
ref
status
subst_name
substation
voltage
class EgonHvmvTransferBuses(**kwargs)[source]

Bases: sqlalchemy.orm.decl_api.Base

bus_id
dbahn
frequency
lat
lon
operator
osm_id
osm_www
point
polygon
power_type
ref
status
subst_name
substation
voltage
class SubstationExtraction(dependencies)[source]

Bases: egon.data.datasets.Dataset

name: str

The name of the Dataset

version: str

The Dataset’s version. Can be anything from a simple semantic versioning string like “2.1.3”, to a more complex string, like for example “2021-01-01.schleswig-holstein.0” for OpenStreetMap data. Note that the latter encodes the Dataset’s date, region and a sequential number in case the data changes without the date or region changing, for example due to implementation changes.

create_sql_functions()[source]

Defines Postgresql functions needed to extract substation from osm

Returns

None.

create_tables()[source]

Create tables for substation data :returns: None.

extract_ehv()[source]
extract_hvmv()[source]
transfer_busses()[source]