Home

OEP Data Review

Process and Workflow

1. Write data to the database schema sandbox using the OEP-API (template here)
2. Make sure the table name follows the OEP Naming Conventions
3. Write the metadata string (examples and templates here)
4. Create an issue in this repository with tag review
5. Get in contact with OEP reviewers and find responsible person
6. If necessary, revise the data and metadata
7. Get familiar with the OEP community and become a OEP data reviewer!

Naming Conventions

Dos & Don'ts

• only use lower case
• use underscores
• use ASCII characters only
• no points, no commas
• no spaces
• avoid dates

Table Name

• name starts with the copyright owner, source, project or model name (e.g. zensus, eGo, oemof)
• 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 Remember to add new energy-related abbreviations to the Glossary

Collection of Criteria

General

• Data, metadata and additional material (e.g., documentation, article) has been provided
• User rights are set

Metadata

• Include metadata string to repo
• Metadata file has header
  • Metadata licensed with Public Domain (CC0)
  • Authors included
• Metadata follows additional information
• All columns are described in resources/fields
• All languages are listed
• Open Data
  • Suitable open license
  • All sources included (all attributions correct)
  • All links to sources included
• Add appropriate OEP tags

Data

• Primary Key is set

Geographic Data

• (PostGIS)-Geometry is in column named geom (vector) or rast (raster)
• Data type is geometry (or raster)
  • One of the Geometric Types is defined
• The CRS (SRID) defined is defined as EPSG
  • Original data stays with the original CRS
  • Prefered CRS of the oedb are
  1. WGS84 - EPSG: 4326
  2. ETRS89 / ETRS-LAEA - EPSG: 3035
  • Spacial Index (GIST) on column geom
  • All geometries are valid (ST_IsValid)

To get a basic understanding of CRS, see e.g. QGIS docs.

Data quality

The database set-up of the OEP is designed to support users in achieving good data quality:

• Plausibility and integration tests are applied to identify mistakes in the data.
• When the number of users and reviewers becomes large enough, user evaluations and ratings on data quality will be implemented.

Further information and guidelines regarding data management and data publication can be found here: Open Knowledge Foundation, Open Data Foundation and Software Carpentry (e.g. here).

Badge system

The quality of data is indicated by a badge, e.g.

• Bronze
• Silver
• Gold
• Platin

A certain badge implies that defined criteria are fulfilled, including subordinate ones (e.g. datasets holding a gold badge also fulfill criteria of bronze and silver).

Badge criteria

1. Bronze (must-have)

• Primary key
• Follows naming conventions
• Meta data exist
• ...

2. Silver (should-have)

• Meta data exhaustive
• Spatial index defined
• ...

3. Gold (good-to-have)

• Plausibility and integrity -> a testing script is provided for verification
• ...

4. Platin (best-practice)

• Approved/rated positively by XX users
• ...