mastr¶
Import MaStR dataset and write to DB tables
Data dump from Marktstammdatenregister (2022-11-17) is imported into the database. Only some technologies are taken into account and written to the following tables:
- PV: table supply.egon_power_plants_pv
- wind turbines: table supply.egon_power_plants_wind
- biomass/biogas plants: table supply.egon_power_plants_biomass
- hydro plants: table supply.egon_power_plants_hydro
Handling of empty source data in MaStr dump: * voltage_level: inferred based on nominal power (capacity) using the
ranges from https://redmine.iks.cs.ovgu.de/oe/projects/ego-n/wiki/Definition_of_thresholds_for_voltage_level_assignment which results in True in column voltage_level_inferred. Remaining datasets are set to -1 (which only occurs if capacity is empty).
- supply.egon_power_plants_*.bus_id: set to -1 (only if not within grid districts or no geom available, e.g. for units with nom. power <30 kW)
- supply.egon_power_plants_hydro.plant_type: NaN
The data is used especially for the generation of status quo grids by ding0.
-
class
EgonPowerPlantsBiomass
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
-
bus_id
¶
-
capacity
¶
-
city
¶
-
commissioning_date
¶
-
federal_state
¶
-
feedin_type
¶
-
fuel_name
¶
-
fuel_type
¶
-
gens_id
¶
-
geom
¶
-
id
¶
-
postcode
¶
-
status
¶
-
technology
¶
-
th_capacity
¶
-
voltage_level
¶
-
voltage_level_inferred
¶
-
-
class
EgonPowerPlantsHydro
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
-
bus_id
¶
-
capacity
¶
-
city
¶
-
commissioning_date
¶
-
federal_state
¶
-
feedin_type
¶
-
gens_id
¶
-
geom
¶
-
id
¶
-
plant_type
¶
-
postcode
¶
-
status
¶
-
voltage_level
¶
-
voltage_level_inferred
¶
-
water_origin
¶
-
-
class
EgonPowerPlantsPv
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
-
bus_id
¶
-
capacity
¶
-
capacity_inverter
¶
-
city
¶
-
commissioning_date
¶
-
federal_state
¶
-
feedin_type
¶
-
gens_id
¶
-
geom
¶
-
id
¶
-
module_count
¶
-
orientation_primary
¶
-
orientation_primary_angle
¶
-
orientation_secondary
¶
-
orientation_secondary_angle
¶
-
orientation_uniform
¶
-
postcode
¶
-
site_type
¶
-
status
¶
-
usage_sector
¶
-
voltage_level
¶
-
voltage_level_inferred
¶
-
-
class
EgonPowerPlantsWind
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
-
bus_id
¶
-
capacity
¶
-
city
¶
-
commissioning_date
¶
-
federal_state
¶
-
feedin_type
¶
-
gens_id
¶
-
geom
¶
-
hub_height
¶
-
id
¶
-
manufacturer_name
¶
-
postcode
¶
-
rotor_diameter
¶
-
site_type
¶
-
status
¶
-
type_name
¶
-
voltage_level
¶
-
voltage_level_inferred
¶
-