     ON    	calc_ego_loads.landuse_industry
     USING     	GIST (geom);
 
+-- "Add metadata"
+
+COMMENT ON TABLE  calc_ego_loads.landuse_industry IS
+'{
+"Name": "Industrial landuse area",
+"Source": [{
+                  "Name": "open_eGo data_processing",
+                  "URL":  "https://github.com/openego/data_processing" }],
+"Reference date": "October 2016",
+"Date of collection": "...",
+"Original file": "...",
+"Spatial resolution": ["Germany"],
+"Description": ["Collection of osm polygons with a tag landuse=industrial"],
+"Column": [
+                   {"Name": "gid",
+                    "Description": "unique id",
+                    "Unit": "" },
+                   {"Name": "osm_id",
+                    "Description": "osm-id",
+                    "Unit": "" },
+                   {"Name": "name",
+                    "Description": "name",
+                    "Unit": "" },
+                   {"Name": "sector",
+                    "Description": "Integer to identify the landuse sector",
+                    "Unit": "" },
+                   {"Name": "area_ha",
+                    "Description": "landuse area",
+                    "Unit": "ha" },
+                   {"Name": "tags",
+                    "Description": "osm-tags",
+                    "Unit": "" },
+                   {"Name": "vg250",
+                    "Description": "check if landuse are is inside the german vg250-polygon",
+                    "Unit": "" },
+                   {"Name": "geom",
+                    "Description": "geometry polygon",
+                    "Unit": "" },
+                   {"Name": "geom_centroid",
+                    "Description": "centroid of polygon",
+                    "Unit": "" },
+                   {"Name": "geom_surfacepoint",
+                    "Description": "Surfacepoint of polygon",
+                    "Unit": "" },
+                   {"Name": "geom_centre",
+                    "Description": "centre of polygon",
+                    "Unit": "" },
+                   {"Name": "nuts",
+                    "Description": "nuts code for corresponding administrative district",
+                    "Unit": "" },
+                   {"Name": "consumption",
+                    "Description": "electricity consumption associated with polygon",
+                    "Unit": "GWh" },
+                   {"Name": "peak_load",
+                    "Description": "peak load associated with polygon",
+                    "Unit": "MW" }],
+"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
 INSERT INTO	scenario.eGo_data_processing_clean_run (version,schema_name,table_name,script_name,entries,status,timestamp)
 	SELECT	'0.1' AS version,

		'OK' AS status,
		NOW() AT TIME ZONE 'Europe/Berlin' AS timestamp
	FROM	calc_ego_loads.landuse_industry;
	
-----------------
-- "Identify large scale consumer"

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