 		osm.area_ha,
 		pp.gid AS powerplant_id,
 		pp.voltage_level
-	FROM 	orig_geo_powerplants.proc_power_plant_germany AS pp, 
+	FROM 	supply.ego_conv_powerplant AS pp, 
 		openstreetmap.osm_deu_polygon_urban_sector_3_industrial_mview AS osm
 	WHERE	(pp.voltage_level='3' OR pp.voltage_level='2' OR pp.voltage_level='1')
 			AND ST_Intersects(pp.geom, ST_transform(osm.geom,4326))


__copyright__ = "tba"
__license__ = "tba"
__author__ = "IK"
*/

--------------

INSERT INTO	model_draft.ego_scenario_log (version,io,schema_name,table_name,script_name,entries,status,user_name,timestamp,metadata)
SELECT	'0.2.1' AS version,
	'input' AS io,
	'supply' AS schema_name,
	'ego_conv_powerplant' AS table_name,
	'process_eGo_osm_loads_industry.sql' AS script_name,
	COUNT(*)AS entries,
	'OK' AS status,
	session_user AS user_name,
	NOW() AT TIME ZONE 'Europe/Berlin' AS timestamp,
	obj_description('supply.ego_conv_powerplant' ::regclass) ::json AS metadata
FROM	supply.ego_conv_powerplant;

DROP TABLE IF EXISTS model_draft.ego_demand_hv_largescaleconsumer CASCADE;
CREATE TABLE model_draft.ego_demand_hv_largescaleconsumer AS
