|
|
| 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 | | |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/> | | *[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/> "'''title'''": "Good example title",<br/> "'''description'''": "example metadata for example data",<br/> "'''language'''": [ "eng", "ger", "fre" ],<br/> "'''spatial'''": <br/> {"location": "52.433405, 13.535666",<br/> "extent": "europe",<br/> "resolution": "100 m"},<br/> "'''temporal'''": <br/> {"reference_date": "2016-01-01",<br/> "start": "2017-01-01",<br/> "end": "2017-12-31",<br/> "resolution": "hour"},<br/> "'''sources'''": [<br/> {"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/> {"name": "", "description": "", "url": "", "license": "", "copyright": ""} ],<br/> "'''license'''": <br/> {"id": "ODbL-1.0",<br/> "name": "Open Data Commons Open Database License 1.0",<br/> "version": "1.0",<br/> "url": "[https://opendatacommons.org/licenses/odbl/1.0/ https://opendatacommons.org/licenses/odbl/1.0/]",<br/> "instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",<br/> "copyright": "© Reiner Lemoine Institut"},<br/> "'''contributors'''": [<br/> {"name": "Ludee", "email": "", "date": "2016-06-16", "comment": "Create metadata"},<br/> {"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update metadata"},<br/> {"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update header and license"},<br/> {"name": "Ludee", "email": "", "date": "2017-03-16", "comment": "Add license to source"},<br/> {"name": "Ludee", "email": "", "date": "2017-03-28", "comment": "Add copyright to source and license"},<br/> {"name": "Ludee", "email": "", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],<br/> "resources": [<br/> {"'''name'''": "model_draft.test_table", <br/> "'''format'''": "sql",<br/> "'''fields'''": [<br/> {"name": "id", "description": "Unique identifier", "unit": "" },<br/> {"name": "year", "description": "Reference year", "unit": "" },<br/> {"name": "value", "description": "Example value", "unit": "MW" },<br/> {"name": "geom", "description": "Geometry", "unit": "" }] }],<br/> "metadata_version": "1.3"}'; |
| | | | |
| − | -- metadata description<br/>COMMENT ON TABLE model_draft.test_table IS '{<br/> "'''title'''": "Good example title",<br/> "'''description'''": "example metadata for example data",<br/> "language": [ "eng", "ger", "fre" ],<br/> "reference_date": "2016-01-01",<br/> "'''sources'''": [<br/> {"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/> {"name": "", "description": "", "url": "", "license": "", "copyright": ""} ],<br/> "'''spatial'''": [<br/> {"extent": "europe",<br/> "resolution": "100 m"} ],<br/> "'''temporal'''": [<br/> {"start": "2017-01-01",<br/> "end": "2017-12-31",<br/> "resolution": "hour"} ],<br/> "'''license'''": [<br/> {"id": "ODbL-1.0",<br/> "name": "Open Data Commons Open Database License 1.0",<br/> "version": "1.0",<br/> "url": "https://opendatacommons.org/licenses/odbl/1.0/",<br/> "instruction": "You are free: To Share, To Create, To Adapt; As long as you: Attribute, Share-Alike, Keep open!",<br/> "copyright": "© Reiner Lemoine Institut"} ],<br/> "'''contributors'''": [<br/> {"name": "Ludee", "email": "", "date": "2016-06-16", "comment": "Create metadata"},<br/> {"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update metadata"},<br/> {"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update header and license"},<br/> {"name": "Ludee", "email": "", "date": "2017-03-16", "comment": "Add license to source"},<br/> {"name": "Ludee", "email": "", "date": "2017-03-28", "comment": "Add copyright to source and license"},<br/> {"name": "Ludee", "email": "", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],<br/> "resources": [<br/> {"'''name'''": "model_draft.test_table", <br/> "'''format'''": "sql",<br/> "'''fields'''": [<br/> {"name": "id", "description": "Unique identifier", "unit": "" },<br/> {"name": "year", "description": "Reference year", "unit": "" },<br/> {"name": "value", "description": "Example value", "unit": "MW" },<br/> {"name": "geom", "description": "Geometry", "unit": "" }] }],<br/> "metadata_version": "1.3"}'; | + | -- select description<br/>SELECT obj_description('model_draft.test_table' ::regclass) ::json; |
| − | | + | |
| − | -- select description<br/>SELECT obj_description('model_draft.test_table' ::regclass) ::json;
| + | |
Revision as of 09:21, 5 October 2017
Definition
1. Metadata is data (information) that provides information about other data.
2. Three distinct types of metadata exist: structural metadata, descriptive metadata, and administrative metadata.
3. 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
Abbreviation
Synonyms
Superterms
Subterms
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
In the oedb, the metadata is stored in a comment as a JSON string.
The SQL example is on GitHub.
Different concepts for metadata were compared, harmonized and simplyfied:
-- metadata description
COMMENT ON TABLE model_draft.test_table IS '{
"title": "Good example title",
"description": "example metadata for example data",
"language": [ "eng", "ger", "fre" ],
"spatial":
{"location": "52.433405, 13.535666",
"extent": "europe",
"resolution": "100 m"},
"temporal":
{"reference_date": "2016-01-01",
"start": "2017-01-01",
"end": "2017-12-31",
"resolution": "hour"},
"sources": [
{"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"},
{"name": "", "description": "", "url": "", "license": "", "copyright": ""} ],
"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": "© Reiner Lemoine Institut"},
"contributors": [
{"name": "Ludee", "email": "", "date": "2016-06-16", "comment": "Create metadata"},
{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update metadata"},
{"name": "Ludee", "email": "", "date": "2016-11-22", "comment": "Update header and license"},
{"name": "Ludee", "email": "", "date": "2017-03-16", "comment": "Add license to source"},
{"name": "Ludee", "email": "", "date": "2017-03-28", "comment": "Add copyright to source and license"},
{"name": "Ludee", "email": "", "date": "2017-05-30", "comment": "Update metadata to version 1.3"} ],
"resources": [
{"name": "model_draft.test_table",
"format": "sql",
"fields": [
{"name": "id", "description": "Unique identifier", "unit": "" },
{"name": "year", "description": "Reference year", "unit": "" },
{"name": "value", "description": "Example value", "unit": "MW" },
{"name": "geom", "description": "Geometry", "unit": "" }] }],
"metadata_version": "1.3"}';
-- select description
SELECT obj_description('model_draft.test_table' ::regclass) ::json;
