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¶
-