oeplatform icon indicating copy to clipboard operation
oeplatform copied to clipboard

Show column metadata for tables

Open adelmemariani opened this issue 3 years ago • 3 comments

The column names of the tables in OEP, have (abbreviated) names that are specific for each dataset. We then show the meta-data of these tables under the table which provides more information about the columns.

For example, here, the column 'geom' means 'Geometry' or the 'gf' means 'Geofaktor'. I think to have a more clear view, we should replace the column names with their associated names in the meta-data. I think ultimately, we need to somehow connect each column to a term in the OEO.

adelmemariani avatar Jan 28 '22 09:01 adelmemariani

This has been done in the latest version of the OEM. Please see the documentation:

15.6.1.4 is_about Ontology URI to describe the column header  
15.6.1.5 value_reference Ontology URI for an extended description of the values in the column

Ludee avatar Feb 09 '22 10:02 Ludee

This is also covered here: https://github.com/OpenEnergyPlatform/ontology/issues/1532

Ludee avatar Feb 09 '22 10:02 Ludee

@Ludee I think this is also about making the human readable field/column names from the metadata visible in the displayed table on the OEP "close" to the actual "technical" column names. I imagine that I'm looking at a table and when I look at a column heading, I can directly see the associated column description without scrolling down to the metadata part. This would improve the user experience. Looking at a table and then being forced to scroll down to get that information might annoy the user :) . We already have a widget that extracts the column name and description and then displays it under the metadata information widget at the very bottom of the page. We could try to insert this directly into the table.

jh-RLI avatar Jun 27 '22 14:06 jh-RLI