|
|
| Line 1: |
Line 1: |
| | | | |
| − | == Data documentation<br/> ==
| + | = Data documentation<br/> = |
| | | | |
| | All data included in the databases has be documented! | | All data included in the databases has be documented! |
| Line 6: |
Line 6: |
| | All abreviations have to be documentated in the Glossary! | | All abreviations have to be documentated in the Glossary! |
| | | | |
| − | == Naming of data ==
| + | = Naming of data = |
| | | | |
| − | '''Database Name''' | + | == '''Database Name''' == |
| | | | |
| | The name of the database is '''oedb''' | | The name of the database is '''oedb''' |
| | | | |
| − | '''Database Schema''' | + | == '''Database Schema''' == |
| | | | |
| | The structure of the database is realised via the naming of the schema! | | The structure of the database is realised via the naming of the schema! |
| Line 32: |
Line 32: |
| | Example: ''orig_vg250'' | | Example: ''orig_vg250'' |
| | | | |
| − | <br/>'''Database Table''' | + | == <br/>'''Database Table''' == |
| | | | |
| | *always lower case<br/> | | *always lower case<br/> |
| Line 49: |
Line 49: |
| | Example: ''zensus_population_by_gender_per_mun'' | | Example: ''zensus_population_by_gender_per_mun'' |
| | | | |
| − | <br/><pre>{"Name": "Wirtschaftsdaten pro Region", | + | === Original Data (orig) === |
| | + | |
| | + | <pre>{"Name": "Wirtschaftsdaten pro Region", |
| | "Source": ["Regionaldatenbank Deutschland", "www.regionalstatistik.de / registation required"], | | "Source": ["Regionaldatenbank Deutschland", "www.regionalstatistik.de / registation required"], |
| | "Reference date": ["2013"], | | "Reference date": ["2013"], |
| Line 88: |
Line 90: |
| | "Licence": ["Datenlizenz Deutschland – Namensnennung – Version 2.0 (dl-de/by-2-0; [http://www.govdata.de/dl-de/by-2-0 http://www.govdata.de/dl-de/by-2-0])"], | | "Licence": ["Datenlizenz Deutschland – Namensnennung – Version 2.0 (dl-de/by-2-0; [http://www.govdata.de/dl-de/by-2-0 http://www.govdata.de/dl-de/by-2-0])"], |
| | "Instructions for proper use": ["Always state licence"]}</pre> | | "Instructions for proper use": ["Always state licence"]}</pre> |
| | + | |
| | + | === Processed Data (calc) === |
| | + | |
| | + | <pre>{"Name": "Wirtschaftsdaten pro Region", |
| | + | "Source": ["Regionaldatenbank Deutschland", "www.regionalstatistik.de / registation required"], |
| | + | "Reference date": ["2013"], |
| | + | "Retrieved": ["04.06.2014"], |
| | + | "Date of collection": ["01.08.2013"], |
| | + | "Original file": ["346-22-5.xls"], |
| | + | "Spatial resolution": ["Germany"], |
| | + | "Description": ["Financial key figures of German municipalities (annual totals)", "Regional level: municipalities, association of municipalities"], |
| | + | |
| | + | "Table fields": [ |
| | + | {"name":"id", |
| | + | "description"Unique identifier"", |
| | + | "description_german":"", |
| | + | "unit":"" }, |
| | + | |
| | + | {"name":"year", |
| | + | "description"Reference Year"", |
| | + | "description_german":"", |
| | + | "unit":"" }, |
| | + | |
| | + | {"name":"example_value", |
| | + | "description"Some important value"", |
| | + | "description_german":"", |
| | + | "unit":"EUR" }], |
| | + | |
| | + | "Changes":[ |
| | + | { "name":"Wolf-Dieter Bunke", |
| | + | "mail":"wd.bunke@gmail.com", |
| | + | "date":"16.06.2014", |
| | + | "comment":"Created table" }, |
| | + | |
| | + | { "name":"Cord Kaldemeyer", |
| | + | "mail":"cord.kaldemeyer@fh-flensburg.de", |
| | + | "date":"17.07.2014", |
| | + | "comment":"Translated field names"}], |
| | + | |
| | + | "ToDo": ["Some datasets are odd -> Check numbers against another data"], |
| | + | "Licence": ["Datenlizenz Deutschland – Namensnennung – Version 2.0 (dl-de/by-2-0; [http://www.govdata.de/dl-de/by-2-0 http://www.govdata.de/dl-de/by-2-0])"], |
| | + | "Instructions for proper use": ["Always state licence"]}</pre><br/> |
Revision as of 08:37, 26 May 2016
Data documentation
All data included in the databases has be documented!
All abreviations have to be documentated in the Glossary!
Naming of data
Database Name
The name of the database is oedb
Database Schema
The structure of the database is realised via the naming of the schema!
- always lower case
- no points, no commas
- no spaces
- no dates
- use underscores
- name starts with type of schema
- orig for original data
- calc for processed data
- name includes distinct subject area or source
Example: orig_vg250
Database Table
- always lower case
- no points, no commas
- no spaces
- no dates
- use underscores
- name starts with the source (e.g. zensus)
- main value (e.g. population)
- if separated by [attribute] (e.g. by_gender)
- with resolution [tupel] (e.g. per_mun)
Example: zensus_population_by_gender_per_mun
Original Data (orig)
{"Name": "Wirtschaftsdaten pro Region",
"Source": ["Regionaldatenbank Deutschland", "www.regionalstatistik.de / registation required"],
"Reference date": ["2013"],
"Retrieved": ["04.06.2014"],
"Date of collection": ["01.08.2013"],
"Original file": ["346-22-5.xls"],
"Spatial resolution": ["Germany"],
"Description": ["Financial key figures of German municipalities (annual totals)", "Regional level: municipalities, association of municipalities"],
"Table fields": [
{"name":"id",
"description"Unique identifier"",
"description_german":"",
"unit":"" },
{"name":"year",
"description"Reference Year"",
"description_german":"",
"unit":"" },
{"name":"example_value",
"description"Some important value"",
"description_german":"",
"unit":"EUR" }],
"Changes":[
{ "name":"Wolf-Dieter Bunke",
"mail":"wd.bunke@gmail.com",
"date":"16.06.2014",
"comment":"Created table" },
{ "name":"Cord Kaldemeyer",
"mail":"cord.kaldemeyer@fh-flensburg.de",
"date":"17.07.2014",
"comment":"Translated field names"}],
"ToDo": ["Some datasets are odd -> Check numbers against another data"],
"Licence": ["Datenlizenz Deutschland – Namensnennung – Version 2.0 (dl-de/by-2-0; [http://www.govdata.de/dl-de/by-2-0 http://www.govdata.de/dl-de/by-2-0])"],
"Instructions for proper use": ["Always state licence"]}
Processed Data (calc)
{"Name": "Wirtschaftsdaten pro Region",
"Source": ["Regionaldatenbank Deutschland", "www.regionalstatistik.de / registation required"],
"Reference date": ["2013"],
"Retrieved": ["04.06.2014"],
"Date of collection": ["01.08.2013"],
"Original file": ["346-22-5.xls"],
"Spatial resolution": ["Germany"],
"Description": ["Financial key figures of German municipalities (annual totals)", "Regional level: municipalities, association of municipalities"],
"Table fields": [
{"name":"id",
"description"Unique identifier"",
"description_german":"",
"unit":"" },
{"name":"year",
"description"Reference Year"",
"description_german":"",
"unit":"" },
{"name":"example_value",
"description"Some important value"",
"description_german":"",
"unit":"EUR" }],
"Changes":[
{ "name":"Wolf-Dieter Bunke",
"mail":"wd.bunke@gmail.com",
"date":"16.06.2014",
"comment":"Created table" },
{ "name":"Cord Kaldemeyer",
"mail":"cord.kaldemeyer@fh-flensburg.de",
"date":"17.07.2014",
"comment":"Translated field names"}],
"ToDo": ["Some datasets are odd -> Check numbers against another data"],
"Licence": ["Datenlizenz Deutschland – Namensnennung – Version 2.0 (dl-de/by-2-0; [http://www.govdata.de/dl-de/by-2-0 http://www.govdata.de/dl-de/by-2-0])"],
"Instructions for proper use": ["Always state licence"]}
