 	ADD COLUMN otg_id integer,  
 	ADD COLUMN un_id integer,
 	ADD COLUMN consumption numeric, 
-	ADD COLUMN peak_load numeric,
+	ADD COLUMN numeric,
 	ADD COLUMN geom geometry(MultiPolygon,3035),
 	ADD COLUMN geom_centre geometry(Point,3035),
 	ADD PRIMARY KEY (id);

	SET otg_id = b.otg_id
	FROM calc_ego_substation.ego_deu_substations b
	WHERE a.subst_id = b.subst_id; 

			  
-- Scenario eGo data processing




COMMENT ON TABLE  orig_ego_consumption.lak_consumption_per_district IS
'{
"Name": "Electricity consumption per administrative district",
"Source": [{
                  "Name": "open_eGo data-processing",
                  "URL":  "https://github.com/openego/data_processing" }],
"Reference date": "2011",
"Date of collection": "...",
"Original file": "...",
"Spatial resolution": ["Germany"],
"Description": ["Electricity consumption calculated for every administrative district in Germany"],
"Column": [
                   {"Name": "eu_code",
                    "Description": "eu_code for nuts region",
                    "Unit": "" },
                   {"Name": "district",
                    "Description": "name of administrative district",
                    "Unit": "" },
                   {"Name": "elec_consumption_industry",
                    "Description": "electricity consumption of industrial sector",
                    "Unit": "GWh" },
                   {"Name": "elec_consumption_tertiary_sector",
                    "Description": "electricity consumption of tertiary sector",
                    "Unit": "GWh" },
                   {"Name": "area_industry",
                    "Description": "industrial osm-area within the administrative district",
                    "Unit": "ha" },
                   {"Name": "area_retail",
                    "Description": "retail osm-area within the administrative district",
                    "Unit": "ha" },
                   {"Name": "area_agricultural",
                    "Description": "agricultural osm-area within the administrative district",
                    "Unit": "ha" },
                   {"Name": "area_tertiary_sector",
                    "Description": "retail and agricultural osm-area within the administrative district",
                    "Unit": "ha" },
                   {"Name": "consumption_per_area_industry",
                    "Description": "specific consumption of industrial sector per ha within the administrative district",
                    "Unit": "GWh/ha" }],
"Changes":[
                   {"Name": "Mario Kropshofer",
                    "Mail": "mario.kropshofer2@stud.fh-flensburg.de",
                    "Date":  "05.10.2016",
                    "Comment": "..." }, 
                   {"Name": "Ilka Cussmann",
                    "Mail": "ilka.cussmann@hs-flensburg.de",
                    "Date":  "25.10.2016",
                    "Comment": "Completed meta-dokumentation" }
                  ],
"ToDo": ["add licence"],
"Licence": ["..."],
"Instructions for proper use": ["..."]
}';

------------------
-- "Export information on the industrial area into calc_ego_loads.landuse_industry"
------------------
