Metadata - Revision history

Ludwig Schneider: /* Metadata in oedb */

2018-09-11T11:34:20Z

‎Metadata in oedb

Lilly Schoen at 08:53, 3 November 2017

2017-11-03T08:53:11Z

Ludwig Schneider: /* Metadata in oedb */

2017-10-05T09:21:41Z

‎Metadata in oedb

Ludwig Schneider: /* Example Metadata (Template) */

2017-06-19T12:05:10Z

‎Example Metadata (Template)

Ludwig Schneider: /* Metadata in oedb */

2017-06-06T12:48:22Z

‎Metadata in oedb

Ludwig Schneider: /* Metadata in oedb */

2017-04-04T07:42:13Z

‎Metadata in oedb

Ludwig Schneider: /* Metadata in oedb */

2017-04-04T07:41:24Z

‎Metadata in oedb

Ludwig Schneider: /* Metadata in oedb */

2016-11-23T12:48:46Z

‎Metadata in oedb

Ludwig Schneider: /* Metadata in oedb */

2016-11-23T12:44:00Z

‎Metadata in oedb

Ludwig Schneider: /* Metadata in oedb */

2016-11-22T15:47:47Z

‎Metadata in oedb

@@ Line 8: / Line 8: @@
 |Sources=http://www.merriam-webster.com/dictionary/metadata(1.); http://marciazeng.slis.kent.edu/metadatabasics/types.htm (2.); https://en.wikipedia.org/wiki/Metadata#Definition (3.); https://en.wikipedia.org/wiki/Metadata (4.); http://whatis.techtarget.com/definition/metadata (5.)
 }}
 == Metadata in oedb<br/> ==
@@ Line 13: / Line 14: @@
 [https://github.com/openego/data_processing/blob/dev/documentation/metadata_on_table_example.sql The SQL example is on GitHub.]
 <br/>

@@ Line 1: / Line 1: @@
 {{GlossaryTermTemp
 |Definition=1. Metadata is data (information) that provides information about other data.
 . Three distinct types of metadata exist: structural metadata, descriptive metadata, and administrative metadata.
-. Metadata means "data about data". Although the "meta" prefix (from the Greek preposition and prefix μετά-) means "after" or "beyond", it is used to mean "about" in epistemology. Metadata is defined as the data providing information about one or more aspects of the data; it is used to summarize basic information about data which can make tracking and working with specific data easier. Some examples include: Means of creation of the data, Purpose of the data, Time and date of creation, Creator or author of the data, Location on a computer network where the data was created, Standards used, File size
+. Metadata means "data about data". Although the "meta" prefix (from the Greek preposition and prefix μετά-) means "after" or "beyond", it is used to mean "about" in epistemology. Metadata is defined as the data providing information about one or more aspects of the data; it is used to summarize basic information about data which can make tracking and working with specific data easier. Some examples include: Means of creation of the data, Purpose of the data, Time and date of creation, Creator or author of the data, Location on a computer network where the data was created, Standards used, File size.
-|Sources=http://www.merriam-webster.com/dictionary/metadata, http://marciazeng.slis.kent.edu/metadatabasics/types.htm, https://en.wikipedia.org/wiki/Metadata#Definition
+. "metadata describes a resource for purposes such as discovery and  identification. It can include elements such as title, abstract, author,  and keywords."
 }}
 == Metadata in oedb<br/> ==
@@ Line 27: / Line 23: @@
 *[http://inspire.ec.europa.eu/documents/Metadata/MD_IR_and_ISO_20131029.pdf INSPIRE]<br/>
-<br/>-- metadata description<br/>COMMENT ON TABLE model_draft.test_table IS '{<br/>&nbsp;&nbsp; "'''title'''": "Good example title",<br/>&nbsp;&nbsp; "'''description'''": "example metadata for example data",<br/>&nbsp;&nbsp; "'''language'''": [ "eng", "ger", "fre" ],<br/>&nbsp;&nbsp; "'''spatial'''": <br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"location": "52.433405, 13.535666",<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "extent": "europe",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "100 m"},<br/>&nbsp;&nbsp; "'''temporal'''": <br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"reference_date": "2016-01-01",<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "start": "2017-01-01",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"end": "2017-12-31",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "hour"},<br/>&nbsp;&nbsp; "'''sources'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "eGo dataprocessing", "description": "", "url": "[https://github.com/openego/data_processing https://github.com/openego/data_processing]", "license": "GNU Affero General Public License Version 3 (AGPL-3.0)", "copyright": "© Reiner Lemoine Institut"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "", "description": "", "url": "", "license": "", "copyright": ""} ],<br/>&nbsp;&nbsp; "'''license'''": <br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"id": "ODbL-1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"name": "Open Data Commons Open Database License 1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"version": "1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"url": "[https://opendatacommons.org/licenses/odbl/1.0/ https://opendatacommons.org/licenses/odbl/1.0/]",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"copyright": "© Reiner Lemoine Institut"},<br/>&nbsp;&nbsp; &nbsp;"'''contributors'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-06-16", "comment": "Create metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update header and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-16", "comment": "Add license to source"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-28", "comment": "Add copyright to source and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],<br/>&nbsp;&nbsp; &nbsp;"resources": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"'''name'''": "model_draft.test_table",&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''format'''": "sql",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''fields'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "id", "description": "Unique identifier", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "year", "description": "Reference year", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "value", "description": "Example value", "unit": "MW" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "geom", "description": "Geometry", "unit": "" }] }],<br/>&nbsp;&nbsp; &nbsp;"metadata_version": "1.3"}';
+<br/>-- metadata description<br/>COMMENT ON TABLE model_draft.test_table IS '{<br/>&nbsp;&nbsp; "'''title'''": "Good example title",<br/>&nbsp;&nbsp; "'''description'''": "example metadata for example data",<br/>&nbsp;&nbsp; "'''language'''": [ "eng", "ger", "fre" ],<br/>&nbsp;&nbsp; "'''spatial'''":<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"location": "52.433405, 13.535666",<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "extent": "europe",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "100 m"},<br/>&nbsp;&nbsp; "'''temporal'''":<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"reference_date": "2016-01-01",<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "start": "2017-01-01",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"end": "2017-12-31",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "hour"},<br/>&nbsp;&nbsp; "'''sources'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "eGo dataprocessing", "description": "", "url": "[https://github.com/openego/data_processing https://github.com/openego/data_processing]", "license": "GNU Affero General Public License Version 3 (AGPL-3.0)", "copyright": "© Reiner Lemoine Institut"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "", "description": "", "url": "", "license": "", "copyright": ""} ],<br/>&nbsp;&nbsp; "'''license'''":<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"id": "ODbL-1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"name": "Open Data Commons Open Database License 1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"version": "1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"url": "[https://opendatacommons.org/licenses/odbl/1.0/ https://opendatacommons.org/licenses/odbl/1.0/]",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"copyright": "© Reiner Lemoine Institut"},<br/>&nbsp;&nbsp; &nbsp;"'''contributors'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-06-16", "comment": "Create metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update header and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-16", "comment": "Add license to source"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-28", "comment": "Add copyright to source and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],<br/>&nbsp;&nbsp; &nbsp;"resources": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"'''name'''": "model_draft.test_table",&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''format'''": "sql",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''fields'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "id", "description": "Unique identifier", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "year", "description": "Reference year", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "value", "description": "Example value", "unit": "MW" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "geom", "description": "Geometry", "unit": "" }] }],<br/>&nbsp;&nbsp; &nbsp;"metadata_version": "1.3"}';
 -- select description<br/>SELECT obj_description('model_draft.test_table'&nbsp;::regclass)&nbsp;::json;

@@ Line 5: / Line 5: @@
 |Sources=http://www.merriam-webster.com/dictionary/metadata, http://marciazeng.slis.kent.edu/metadatabasics/types.htm, https://en.wikipedia.org/wiki/Metadata#Definition
 }}
@@ Line 26: / Line 27: @@
 *[http://inspire.ec.europa.eu/documents/Metadata/MD_IR_and_ISO_20131029.pdf INSPIRE]<br/>
--- metadata description<br/>COMMENT ON TABLE model_draft.test_table IS '{<br/>&nbsp;&nbsp; &nbsp;"'''title'''": "Good example title",<br/>&nbsp;&nbsp; &nbsp;"'''description'''": "example metadata for example data",<br/>&nbsp;&nbsp; &nbsp;"language": [ "eng", "ger", "fre" ],<br/>&nbsp;&nbsp; &nbsp;"reference_date": "2016-01-01",<br/>&nbsp;&nbsp; &nbsp;"'''sources'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "eGo dataprocessing", "description": "", "url": "https://github.com/openego/data_processing", "license": "GNU Affero General Public License Version 3 (AGPL-3.0)", "copyright": "© Reiner Lemoine Institut"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "", "description": "", "url": "", "license": "", "copyright": ""} ],<br/>&nbsp;&nbsp; &nbsp;"'''spatial'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"extent": "europe",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "100 m"} ],<br/>&nbsp;&nbsp; &nbsp;"'''temporal'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"start": "2017-01-01",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"end": "2017-12-31",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "hour"} ],<br/>&nbsp;&nbsp; &nbsp;"'''license'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"id": "ODbL-1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"name": "Open Data Commons Open Database License 1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"version": "1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"url": "https://opendatacommons.org/licenses/odbl/1.0/",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"copyright": "© Reiner Lemoine Institut"} ],<br/>&nbsp;&nbsp; &nbsp;"'''contributors'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-06-16", "comment": "Create metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update header and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-16", "comment": "Add license to source"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-28", "comment": "Add copyright to source and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],<br/>&nbsp;&nbsp; &nbsp;"resources": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"'''name'''": "model_draft.test_table",&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''format'''": "sql",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''fields'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "id", "description": "Unique identifier", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "year", "description": "Reference year", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "value", "description": "Example value", "unit": "MW" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "geom", "description": "Geometry", "unit": "" }] }],<br/>&nbsp;&nbsp; &nbsp;"metadata_version": "1.3"}';
+-- select description<br/>SELECT obj_description('model_draft.test_table'&nbsp;::regclass)&nbsp;::json;
-−
--- select description<br/>SELECT obj_description('model_draft.test_table' ::regclass) ::json;

@@ Line 26: / Line 26: @@
 *[http://inspire.ec.europa.eu/documents/Metadata/MD_IR_and_ISO_20131029.pdf INSPIRE]<br/>
--- metadata<br/>COMMENT ON TABLE model_draft.test_table IS '{<br/>&nbsp;&nbsp; &nbsp;"'''title'''": "Good example title",<br/>&nbsp;&nbsp; &nbsp;"'''description'''": "example metadata for example data",<br/>&nbsp;&nbsp; &nbsp;"'''language'''": [ "eng", "ger", "fre" ],<br/>&nbsp;&nbsp; &nbsp;"'''reference_date'''": "2016-01-01",<br/>&nbsp;&nbsp; &nbsp;"sources": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"'''name'''": "eGo dataprocessing", "'''description'''": " ", "'''url'''": "https://github.com/openego/data_processing", "'''license'''": "GNU Affero General Public License Version 3 (AGPL-3.0)", "'''copyright'''": "© Reiner Lemoine Institut"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": " ", "description": " ", "url": " ", "license": " ", "copyright": " "} ],<br/>&nbsp;&nbsp; &nbsp;"spatial": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"'''extend'''": "europe",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''resolution'''": "100m"} ],<br/>&nbsp;&nbsp; &nbsp;"temporal": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"'''start'''": "2017-01-01",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''end'''": "2017-12-31",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''resolution'''": "hour"} ],<br/>&nbsp;&nbsp; &nbsp;"'''license'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"id": "ODbL-1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"name": "Open Data Commons Open Database License 1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"version": "1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"url": "https://opendatacommons.org/licenses/odbl/1.0/",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"copyright": "© Reiner Lemoine Institut"} ],<br/>&nbsp;&nbsp; &nbsp;"'''contributors'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": " ", "date": "2016-06-16", "comment": "Create metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": " ", "date": "2016-11-22", "comment": "Update metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": " ", "date": "2016-11-22", "comment": "Update header and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": " ", "date": "2017-03-16", "comment": "Add license to source"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": " ", "date": "2017-03-28", "comment": "Add copyright to source and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": " ", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],<br/>&nbsp;&nbsp; &nbsp;"resources": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"'''name'''": "model_draft.test_table",&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''format'''": "sql",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''fields'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "id", "description": "Unique identifier", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "year", "description": "Reference year", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "value", "description": "Example value", "unit": "MW" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "geom", "description": "Geometry", "unit": "" } ],<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''metadata_version'''": "1.3" } ] }';
+-- metadata description<br/>COMMENT ON TABLE model_draft.test_table IS '{<br/>&nbsp;&nbsp; &nbsp;"'''title'''": "Good example title",<br/>&nbsp;&nbsp; &nbsp;"'''description'''": "example metadata for example data",<br/>&nbsp;&nbsp; &nbsp;"language": [ "eng", "ger", "fre" ],<br/>&nbsp;&nbsp; &nbsp;"reference_date": "2016-01-01",<br/>&nbsp;&nbsp; &nbsp;"'''sources'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "eGo dataprocessing", "description": "", "url": "https://github.com/openego/data_processing", "license": "GNU Affero General Public License Version 3 (AGPL-3.0)", "copyright": "© Reiner Lemoine Institut"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "", "description": "", "url": "", "license": "", "copyright": ""} ],<br/>&nbsp;&nbsp; &nbsp;"'''spatial'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"extent": "europe",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "100 m"} ],<br/>&nbsp;&nbsp; &nbsp;"'''temporal'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"start": "2017-01-01",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"end": "2017-12-31",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"resolution": "hour"} ],<br/>&nbsp;&nbsp; &nbsp;"'''license'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"id": "ODbL-1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"name": "Open Data Commons Open Database License 1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"version": "1.0",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"url": "https://opendatacommons.org/licenses/odbl/1.0/",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"copyright": "© Reiner Lemoine Institut"} ],<br/>&nbsp;&nbsp; &nbsp;"'''contributors'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-06-16", "comment": "Create metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update metadata"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update header and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-16", "comment": "Add license to source"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-03-28", "comment": "Add copyright to source and license"},<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "Ludee", "email": "", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],<br/>&nbsp;&nbsp; &nbsp;"resources": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"'''name'''": "model_draft.test_table",&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''format'''": "sql",<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"'''fields'''": [<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "id", "description": "Unique identifier", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "year", "description": "Reference year", "unit": "" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "value", "description": "Example value", "unit": "MW" },<br/>&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{"name": "geom", "description": "Geometry", "unit": "" }] }],<br/>&nbsp;&nbsp; &nbsp;"metadata_version": "1.3"}';
 -- select description<br/>SELECT obj_description('model_draft.test_table' ::regclass) ::json;

@@ Line 10: / Line 10: @@
 == Metadata in oedb ==
 In the [[OpenEnergy Database|oedb]], the metadata is stored in a comment as a JSON string.
@@ Line 23: / Line 24: @@
 *[https://github.com/fraunhoferfokus/ogd-metadata/blob/master/OGPD_JSON_Schema.html CKAN (Frauenhofer)]
 *[http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/datapackage.json OPSD]
-*[http://inspire.ec.europa.eu/documents/Metadata/MD_IR_and_ISO_20131029.pdf INSPIRE]
+*[http://inspire.ec.europa.eu/documents/Metadata/MD_IR_and_ISO_20131029.pdf INSPIRE]<br/>

@@ Line 5: / Line 5: @@
 |Sources=http://www.merriam-webster.com/dictionary/metadata, http://marciazeng.slis.kent.edu/metadatabasics/types.htm, https://en.wikipedia.org/wiki/Metadata#Definition
 }}
 == Metadata in oedb ==
@@ Line 16: / Line 17: @@
 Different concepts for metadata were compared, harmonized and simplyfied:
-*[[:File:http://frictionlessdata.io/guides/data-package/#getting-started|OKFN (Frictionless / Data Package)]]
+*[http://frictionlessdata.io/guides/data-package/#getting-started OKFN (Frictionless / Data Package)]
-*[[:File:https://github.com/fraunhoferfokus/ogd-metadata/blob/master/OGPD JSON Schema.html|CKAN (Frauenhofer)]]
+*[https://github.com/fraunhoferfokus/ogd-metadata/blob/master/OGPD_JSON_Schema.html CKAN (Frauenhofer)]
-*[[:File:http://data.open-power-system-data.org/renewable power plants/2016-10-21/datapackage.json|OPSD]]
+*[http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/datapackage.json OPSD]
-*[[:File:http://www.geodaten.niedersachsen.de/download/26294/|INSPIRE]]
+*[http://inspire.ec.europa.eu/documents/Metadata/INSPIRE_MD_IR_and_ISO_v1_2_20100616.pdf INSPIRE]