-
Notifications
You must be signed in to change notification settings - Fork 5
Expand file tree
/
Copy pathopsd_powerdata.sql
More file actions
147 lines (131 loc) · 7.49 KB
/
opsd_powerdata.sql
File metadata and controls
147 lines (131 loc) · 7.49 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
/*
Create ego_conventional_powerplant based on OPSD beta Version of 2015/16
__copyright__ = "Europa-Universität Flensburg, 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__ = "wolfbunke"
*/
--------------------------------------------------------------------------------
-- Table: supply.ego_conventional_powerplant
-- DROP supply.ego_conventional_powerplant;
CREATE TABLE supply.ego_conventional_powerplant
(
gid integer NOT NULL,
bnetza_id text,
company text,
name text,
postcode text,
city text,
street text,
state text,
block text,
commissioned_original text,
commissioned double precision,
retrofit double precision,
shutdown double precision,
status text,
fuel text,
technology text,
type text,
eeg text,
chp text,
capacity double precision,
capacity_uba double precision,
chp_capacity_uba double precision,
efficiency_data double precision,
efficiency_estimate double precision,
network_node text,
voltage text,
network_operator text,
name_uba text,
lat double precision,
lon double precision,
comment text,
geom geometry(Point,4326),
CONSTRAINT ego_conventional_powerplant_pkey PRIMARY KEY (gid)
);
-- set meta documentation
COMMENT ON TABLE supply.ego_conventional_powerplant IS
'{
"title": "eGo Conventional power plants in Germany",
"description": "This dataset contains an augmented and corrected power plant list based on the power plant list provided by the BNetzA and UBA.",
"language": [ "eng", "ger" ],
"spatial":
{"location": "Germany",
"extent": "europe",
"resolution": "100 m"},
"temporal":
{"reference_date": "2016-01-01",
"start": "1900-01-01",
"end": "2049-12-31",
"resolution": ""},
"sources": [
{"name": "eGo data processing",
"description": "Scripts with allocate Geometry by OpenStreetMap Objects or create future scenarios by high resolution geo-allocation",
"url": "https://github.com/openego/data_processing",
"license": "GNU Affero General Public License Version 3 (AGPL-3.0)",
"copyright": "© ZNES Europa-Universität Flensburg"},
{"name": "Conventional power plants DE",
"description": "Open Power System Data. 2018. Data Package Conventional power plants. Version 2018-02-27. Data provider how collects and clean TSO, DSO data and other energy data of Germany and Europe",
"url": "https://data.open-power-system-data.org/conventional_power_plants/2018-02-27/",
"license": "MIT",
"copyright": "© Open-Power-System-Data, TU Berlin"},
{"name": "Kraftwerke in Deutschland 100MW",
"description": "Open Power System Data. 2018. Data Package Renewable power plants. Version 2018-03-08. Data provider how collects and clean TSO, DSO data and other energy data of Germany and Europe",
"url": "https://www.umweltbundesamt.de/dokument/datenbank-kraftwerke-in-deutschland",
"license": "in clarification processes",
"copyright": "© Umweltbundesamt (UBA)"},
{"name": "Kraftwerksliste der Bundesnetzagentur (BNetzA)",
"description": "The Federal Network Agency for Electricity, Gas, Telecommunications, Posts and Railway Data is in Germany data provider of power plant",
"url": "https://www.bundesnetzagentur.de/DE/Sachgebiete/ElektrizitaetundGas/Unternehmen_Institutionen/Versorgungssicherheit/Erzeugungskapazitaeten/Kraftwerksliste/kraftwerksliste-node.html",
"license": "Deutschland – Namensnennung – Version 2.0",
"copyright": "© Bundesnetzagentur für Elektrizität, Gas, Telekommunikation, Post und Eisenbahnen; Pressestelle"}
],
"license":
{"id": "ODbL-1.0",
"name": "Open Data Commons Open Database License 1.0",
"version": "1.0",
"url": "https://opendatacommons.org/licenses/odbl/1.0/",
"instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",
"copyright": "© ZNES Europa-Universität Flensburg"},
"contributors": [
{"name": "wolfbunke", "email": " ", "date": "01.06.2017", "comment": "Create and restructure scripts and table"}],
"resources": [
{"name": "model_draft.ego_dp_supply_conv_powerplant",
"format": "PostgreSQL",
"fields": [
{"name": "gid", "description": "Geo ID", "unit": "" },
{"name": "bnetza_id", "description": "Bundesnetzagentur unit ID", "unit": "" },
{"name": "company", "description": "name of company","unit": "" },
{"name": "name", "description": "name of unit","unit": "" },
{"name": "postcode", "description": "postcode", "unit": "" },
{"name": "city", "description": "name of City","unit": "" },
{"name": "street", "description": "Street name, address","unit": "" },
{"name": "state", "description": "name of federate state of location","unit": "" },
{"name": "block", "description": "Power plant block","unit": "" },
{"name": "commissioned_original", "description": "Year of commissioning (raw data)", "unit": "" },
{"name": "commissioned","description": "Year of commissioning", "unit": "" },
{"name": "retrofit", "description": "Year of modernization according to UBA data", "unit": "" },
{"name": "shutdown", "description": "Year of decommissioning", "unit": "" },
{"name": "status","description": "Power plant status", "unit": "" },
{"name": "fuel", "description": "Used fuel or energy source","unit": "" },
{"name": "technology", "description": "Power plant technology or sort","unit": "" },
{"name": "type","description": "Purpose of the produced power","unit": "" },
{"name": "eeg", "description": "Status of being entitled to a renumeration", "unit": "" },
{"name": "chp", "description": "Status of being able to supply heat","unit": "" },
{"name": "capacity", "description": "Power capacity","unit": "MW" },
{"name": "capacity_uba", "description": "Power capacity according to UBA data","unit": "" },
{"name": "chp_capacity_uba", "description": "Heat capacity according to UBA data","unit": "MW" },
{"name": "efficiency_data", "description": "Proportion between power output and input","unit": "" },
{"name": "efficiency_estimate", "description": "Estimated proportion between power output and input", "unit": "" },
{"name": "network_node", "description": "Connection point to the electricity grid","unit": "" },
{"name": "voltage", "description": "Grid or transformation level of the network node","unit": "" },
{"name": "network_operator", "description": "Network operator of the grid or transformation level","unit": "" },
{"name": "name_uba","description": "Power plant name according to UBA data","unit": "" },
{"name": "lat", "description": "Precise geographic coordinates - latitude","unit": "" },
{"name": "lon", "description": "Precise geographic coordinates - longitude","unit": "" },
{"name": "comment", "description": "Further comments", "unit": "" },
{"name": "geom", "description": "Geometry Point", "unit": "" } ] } ],
"meta_version": "1.3" }';
-- Json String test
SELECT obj_description('supply.ego_conventional_powerplant'::regclass)::json;