ego_dp_powerflow_assignment_otgid.sql

This scripts updates tables containing renewable power plants and conventional power plants with information on the otg_id of substations which the generator is assigned to. The otg_id and subst_id of the substations are matched in tables containing information on HV/MV substations and EHV substations.

Additionally the otg_id of offshore wind turbines is updated manually. The geometry of offshore wind power plants is matched with polygons representing a catchment area per relevant offshore grid connection point.

copyright
Flensburg University of Applied Sciences, Centre for Sustainable Energy Systems
license
GNU Affero General Public License Version 3 (AGPL-3.0)
url
https://github.com/openego/data_processing/blob/master/LICENSE
author
IlkaCu