 	SET otg_id = b.otg_id
 	FROM calc_ego_substation.ego_deu_substations b
 	WHERE a.subst_id = b.subst_id; 
+
+
+COMMENT ON TABLE  calc_ego_loads.large_scale_consumer IS
+'{
+"Name": "Large scale consumer in EHV-level",
+"Source": [{
+                  "Name": "open_eGo data-processing",
+                  "URL":  "https://github.com/openego/data_processing" }],
+"Reference date": "...",
+"Date of collection": "...",
+"Original file": "...",
+"Spatial resolution": ["Germany"],
+"Description": ["Identified industrial large scale consumer with a connection to the EHV-grid"],
+"Column": [
+                   {"Name": "polygon_id",
+                    "Description": "unique id for osm industry-polygon",
+                    "Unit": "" },
+                   {"Name": "area_ha",
+                    "Description": "area of polygon",
+                    "Unit": "ha" },
+                   {"Name": "powerplant_id",
+                    "Description": "id of powerplants on the considered polygons",
+                    "Unit": "" },
+                   {"Name": "voltage_level",
+                    "Description": "voltage level of the consumers grid connection",
+                    "Unit": "" },
+                   {"Name": "id",
+                    "Description": "unique id",
+                    "Unit": "" },
+                   {"Name": "consumption",
+                    "Description": "electricity consumption of associated industry polygon",
+                    "Unit": "GWh" },
+                   {"Name": "peak_load",
+                    "Description": "peak-load of associated industry polygon",
+                    "Unit": "MW" },
+                   {"Name": "geom",
+                    "Description": "geometry of industry-polygon",
+                    "Unit": "" },
+                   {"Name": "geom_centre",
+                    "Description": "centre of industry-polygon",
+                    "Unit": "" },
+                   {"Name": "subst_id",
+                    "Description": "id of associated substation",
+                    "Unit": "" },
+                   {"Name": "otg_id",
+                    "Description": "otg_id of associated substation",
+                    "Unit": "" },
+                   {"Name": "un_id",
+                    "Description": "unique id of loads",
+                    "Unit": "" }],
+"Changes":[
+                   {"Name": "Mario Kropshofer",
+                    "Mail": "mario.kropshofer2@stud.fh-flensburg.de",
+                    "Date":  "04.10.2016",
+                    "Comment": "..." }, 
+                   {"Name": "Ilka Cussmann",
+                    "Mail": "ilka.cussmann@hs-flensburg.de",
+                    "Date":  "25.10.2016",
+                    "Comment": "completed json-string" }
+                  ],
+"ToDo": ["Add licence"],
+"Licence": ["..."],
+"Instructions for proper use": ["..."]
+}';
 
 			  
 -- Scenario eGo data processing




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

OWNER TO oeuser;


-- "Add Meta-documentation"

COMMENT ON TABLE  orig_ego_consumption.lak_consumption_per_federalstates_per_gva IS
'{
"Name": "Specific electricity consumption per gross value added",
"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 of the industrial and tertiary sector divided by the respective gross value added"],
"Column": [
                   {"Name": "eu_code",
                    "Description": "eu_code for nuts region",
                    "Unit": "" },
                   {"Name": "federal_states",
                    "Description": "name of federal state",
                    "Unit": "" },
                   {"Name": "elec_consumption_industry",
                    "Description": "specific electricity consumption per Million Euro of gva of the industrial sector",
                    "Unit": "GWh/Million Euro" },
                   {"Name": "elec_consumption_tertiary_sector",
                    "Description": "specific electricity consumption per Million Euro of gva of the tertiary sector",
                    "Unit": "GWh/Million Euro" }],
"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 json-String" }
                  ],
"ToDo": ["Add Licence"],
"Licence": ["..."],
"Instructions for proper use": ["..."]
}';


--------------
-- Calculate electricity consumption per district based on gross value added
--------------
