https://battery.knowledge-graph.eu/w/index.php?action=history&feed=atom&title=Item%3AOSW7d3292e5104f45b1be4fc23901fae4fa
Item:OSW7d3292e5104f45b1be4fc23901fae4fa - Revision history
2026-04-28T14:14:09Z
Revision history for this page on the wiki
MediaWiki 1.39.5
https://battery.knowledge-graph.eu/w/index.php?title=Item:OSW7d3292e5104f45b1be4fc23901fae4fa&diff=116&oldid=prev
Maintenance script: Install package: OSW Docs - Core
2023-12-15T05:15:48Z
<p>Install package: OSW Docs - Core</p>
<p><b>New page</b></p><div>==Tabular Data: JSON-Representation==<br />
<div style=" column-count: 3;"><br />
<div style="break-inside: avoid;">Table<br />
{| class="wikitable"<br />
|+<br />
!id<br />
!name<br />
!number<br />
|-<br />
|row1<br />
|test1<br />
|1e12<br />
|-<br />
|row2<br />
|test2<br />
|2<br />
|-<br />
|row3<br />
|test3<br />
| 3<br />
|}<br />
</div><br />
<div style="break-inside: avoid;">JSON - id as key<br />
<syntaxhighlight lang="json"><br />
{<br />
"content": {<br />
"row1": {"id": "row1", "name": "test1", "number": "1e12"},<br />
"row2": {"id": "row2", "name": "test2", "number": 2},<br />
"row3": {"id": "row3", "name": "test3", "number": 3}<br />
}<br />
}<br />
</syntaxhighlight><br />
</div><br />
<div style="break-inside: avoid;">JSON - index as key<br />
<syntaxhighlight lang="json"><br />
{<br />
"content": [<br />
{"id": "row1", "name": "test1", "number": "1e12"},<br />
{"id": "row2", "name": "test2", "number": 2},<br />
{"id": "row3", "name": "test3", "number": 3}<br />
]<br />
}<br />
</syntaxhighlight><br />
</div><br />
</div><br />
<br />
==Tabular Data: JSON-LD Mapping==<br />
*map each column to a term<br />
*set a default language<br />
*misuse language tag as unit tag - not recommended<br />
<div style=" column-count: 2;"><br />
<div style="break-inside: avoid;">JSON - id as key with context<br />
<syntaxhighlight lang="json"><br />
{<br />
"@context": {<br />
"test": "http://test.voc/",<br />
"name": {"@id": "test:name", "@language": "en"},<br />
"number": {"@id": "test:number", "@language": "Volt"},<br />
"content": {"@container": "@index", "@id": "test:hasRow", "@index": "test:HasId"}<br />
},<br />
"content": {<br />
"row1": {"id": "row1", "name": "test1", "number": "1e12"},<br />
"row2": {"id": "row2", "name": "test2", "number": 2},<br />
"row3": {"id": "row3", "name": "test3", "number": 3}<br />
}<br />
}<br />
</syntaxhighlight><br />
</div><br />
<div style="break-inside: avoid;">Mapping<br />
{| class="wikitable"<br />
!Subject<br />
!Predicate<br />
!Object<br />
!Language<br />
|-<br />
|_:b0<br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|_:b1<br />
|<br />
|-<br />
|_:b0<br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|_:b2<br />
|<br />
|-<br />
|_:b0<br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|_:b3<br />
|<br />
|-<br />
|_:b1<br />
|<nowiki>http://test.voc/HasId</nowiki><br />
|row1<br />
|<br />
|-<br />
|_:b1<br />
|<nowiki>http://test.voc/name</nowiki><br />
|test1<br />
|en<br />
|-<br />
|_:b1<br />
|<nowiki>http://test.voc/number</nowiki><br />
|1e12<br />
|volt<br />
|-<br />
|_:b2<br />
|<nowiki>http://test.voc/HasId</nowiki><br />
|row2<br />
|<br />
|-<br />
|_:b2<br />
|<nowiki>http://test.voc/name</nowiki><br />
|test2<br />
|en<br />
|-<br />
|_:b2<br />
|<nowiki>http://test.voc/number</nowiki><br />
|2<br />
|<br />
|-<br />
|_:b3<br />
|<nowiki>http://test.voc/HasId</nowiki><br />
|row3<br />
|<br />
|-<br />
|_:b3<br />
|<nowiki>http://test.voc/name</nowiki><br />
|test3<br />
|en<br />
|-<br />
|_:b3<br />
|<nowiki>http://test.voc/number</nowiki><br />
|3<br />
|<br />
|}<br />
</div><br />
</div><br />
<br />
==Tabular Data: JSON-LD Mapping==<br />
*map each column to a term<br />
*set a default language<br />
*misuse language tag as unit tag - not recommended<br />
<div style=" column-count: 2;"><br />
<div style="break-inside: avoid;">JSON - index as key with context<br />
<syntaxhighlight lang="json"><br />
{<br />
"@context": {<br />
"test": "http://test.voc/",<br />
"id": "test:hasId",<br />
"name": {"@id": "test:name", "@language": "en"},<br />
"number": {"@id": "test:number", "@language": "Volt"},<br />
"content": {"@container": "@index", "@id": "test:hasRow", "@index": "test:HasId"}<br />
},<br />
"content": [<br />
{"id": "row1", "name": "test1", "number": "1e12"},<br />
{"id": "row2", "name": "test2", "number": 2},<br />
{"id": "row3", "name": "test3", "number": 3}<br />
]<br />
}<br />
</syntaxhighlight><br />
</div><br />
<div style="break-inside: avoid;">Mapping<br />
{| class="wikitable"<br />
!Subject<br />
!Predicate<br />
!Object<br />
!Language<br />
|-<br />
|_:b0<br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|_:b1<br />
|<br />
|-<br />
|_:b0<br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|_:b2<br />
|<br />
|-<br />
|_:b0<br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|_:b3<br />
|<br />
|-<br />
|_:b1<br />
|<nowiki>http://test.voc/hasId</nowiki><br />
|row1<br />
|<br />
|-<br />
|_:b1<br />
|<nowiki>http://test.voc/name</nowiki><br />
|test1<br />
|en<br />
|-<br />
|_:b1<br />
|<nowiki>http://test.voc/number</nowiki><br />
|1e12<br />
|volt<br />
|-<br />
|_:b2<br />
|<nowiki>http://test.voc/hasId</nowiki><br />
|row2<br />
|<br />
|-<br />
|_:b2<br />
|<nowiki>http://test.voc/name</nowiki><br />
|test2<br />
|en<br />
|-<br />
|_:b2<br />
|<nowiki>http://test.voc/number</nowiki><br />
|2<br />
|<br />
|-<br />
|_:b3<br />
|<nowiki>http://test.voc/hasId</nowiki><br />
|row3<br />
|<br />
|-<br />
|_:b3<br />
|<nowiki>http://test.voc/name</nowiki><br />
|test3<br />
|en<br />
|-<br />
|_:b3<br />
|<nowiki>http://test.voc/number</nowiki><br />
|3<br />
|<br />
|}<br />
</div><br />
</div><br />
<br />
==Tabular Data: JSON-LD Mapping==<br />
*alternative mapping with named nodes<br />
<div style=" column-count: 2;"><br />
<div style="break-inside: avoid;">JSON - index as key with context<br />
<syntaxhighlight lang="json"><br />
{<br />
"@context": {<br />
"test": "http://test.voc/",<br />
"id": {"@id": "@id", "@context": {"@base": "http://test.voc/"}},<br />
"name": {"@id": "test:name", "@language": "en"},<br />
"number": {"@id": "test:number", "@language": "Volt"},<br />
"content": {"@container": "@index", "@id": "test:hasRow", "@index": "test:HasId", "@context": {"@base": "http://test.voc/"}}<br />
},<br />
"@id": "test:myTable",<br />
"content": [<br />
{"id": "row1", "name": "test1", "number": "1e12"},<br />
{"id": "row2", "name": "test2", "number": 2},<br />
{"id": "row3", "name": "test3", "number": 3}<br />
]<br />
}<br />
</syntaxhighlight><br />
</div><br />
<div style="break-inside: avoid;">Mapping<br />
<br />
</div><br />
{| class="wikitable"<br />
!Subject<br />
!Predicate<br />
!Object<br />
!Language<br />
|-<br />
|<nowiki>http://test.voc/myTable</nowiki><br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|<nowiki>http://test.voc/row1</nowiki><br />
|<br />
|-<br />
|<nowiki>http://test.voc/myTable</nowiki><br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|<nowiki>http://test.voc/row2</nowiki><br />
|<br />
|-<br />
|<nowiki>http://test.voc/myTable</nowiki><br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|<nowiki>http://test.voc/row3</nowiki><br />
|<br />
|-<br />
|<nowiki>http://test.voc/row1</nowiki><br />
|<nowiki>http://test.voc/name</nowiki><br />
|test1<br />
|en<br />
|-<br />
|<nowiki>http://test.voc/row1</nowiki><br />
|<nowiki>http://test.voc/number</nowiki><br />
|1e12<br />
|volt<br />
|-<br />
|<nowiki>http://test.voc/row2</nowiki><br />
|<nowiki>http://test.voc/name</nowiki><br />
|test2<br />
|en<br />
|-<br />
|<nowiki>http://test.voc/row2</nowiki><br />
|<nowiki>http://test.voc/number</nowiki><br />
|2<br />
|<br />
|-<br />
|<nowiki>http://test.voc/row3</nowiki><br />
|<nowiki>http://test.voc/name</nowiki><br />
|test3<br />
|en<br />
|-<br />
|<nowiki>http://test.voc/row3</nowiki><br />
|<nowiki>http://test.voc/number</nowiki><br />
|3<br />
|<br />
|}<br />
</div><br />
<br />
==Tabular Data: JSON-LD Mapping==<br />
<br />
<div style=" column-count: 2;"><br />
<div style="break-inside: avoid;">JSON - index as key with context, header meta data<br />
<syntaxhighlight lang="json"><br />
{<br />
"@context": {<br />
"test": "http://test.voc/",<br />
"id": {"@id": "@id", "@context": {"@base": "http://test.voc/"}},<br />
"name": {"@id": "test:name", "@language": "en"},<br />
"number": {"@id": "test:number"},<br />
"property": {"@id": "test:hasProperty", "@type": "@id"},<br />
"unit": {"@id": "test:hasUnit", "@type": "@id"},<br />
"header": {"@container": "@index", "@id": "test:hasColumn", "@index": "test:HasId", "@context": {"@base": "http://test.voc/"}},<br />
"content": {"@container": "@index", "@id": "test:hasRow", "@index": "test:HasId", "@context": {"@base": "http://test.voc/"}}<br />
},<br />
"@id": "test:myTable",<br />
"header": [<br />
{"id": "column1", "name": "id", "property": "test:hasId"},<br />
{"id": "column2", "name": "name", "property": "test:hasName"},<br />
{"id": "column3", "name": "number", "property": "test:hasNumber", "unit": "test:volt"}<br />
],<br />
"content": [<br />
{"id": "row1", "name": "test1", "number": "1e12"},<br />
{"id": "row2", "name": "test2", "number": 2},<br />
{"id": "row3", "name": "test3", "number": 3}<br />
]<br />
}<br />
</syntaxhighlight><br />
</div><br />
<div style="break-inside: avoid;">Mapping<br />
{| class="wikitable"<br />
!Subject<br />
!Predicate<br />
!Object<br />
|-<br />
|<nowiki>http://test.voc/column1</nowiki><br />
|<nowiki>http://test.voc/hasProperty</nowiki><br />
|<nowiki>http://test.voc/hasId</nowiki><br />
|-<br />
|<nowiki>http://test.voc/column1</nowiki><br />
|<nowiki>http://test.voc/name</nowiki><br />
|id<br />
|-<br />
|<nowiki>http://test.voc/column2</nowiki><br />
|<nowiki>http://test.voc/hasProperty</nowiki><br />
|<nowiki>http://test.voc/hasName</nowiki><br />
|-<br />
|<nowiki>http://test.voc/column2</nowiki><br />
|<nowiki>http://test.voc/name</nowiki><br />
|name<br />
|-<br />
|<nowiki>http://test.voc/column3</nowiki><br />
|<nowiki>http://test.voc/hasProperty</nowiki><br />
|<nowiki>http://test.voc/hasNumber</nowiki><br />
|-<br />
|<nowiki>http://test.voc/column3</nowiki><br />
|<nowiki>http://test.voc/hasUnit</nowiki><br />
|<nowiki>http://test.voc/volt</nowiki><br />
|-<br />
|<nowiki>http://test.voc/column3</nowiki><br />
|<nowiki>http://test.voc/name</nowiki><br />
|number<br />
|-<br />
|<nowiki>http://test.voc/myTable</nowiki><br />
|<nowiki>http://test.voc/hasColumn</nowiki><br />
|<nowiki>http://test.voc/column1</nowiki><br />
|-<br />
|<nowiki>http://test.voc/myTable</nowiki><br />
|<nowiki>http://test.voc/hasColumn</nowiki><br />
|<nowiki>http://test.voc/column2</nowiki><br />
|-<br />
|<nowiki>http://test.voc/myTable</nowiki><br />
|<nowiki>http://test.voc/hasColumn</nowiki><br />
|<nowiki>http://test.voc/column3</nowiki><br />
|-<br />
|<nowiki>http://test.voc/myTable</nowiki><br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|<nowiki>http://test.voc/row1</nowiki><br />
|-<br />
|<nowiki>http://test.voc/myTable</nowiki><br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|<nowiki>http://test.voc/row2</nowiki><br />
|-<br />
|<nowiki>http://test.voc/myTable</nowiki><br />
|<nowiki>http://test.voc/hasRow</nowiki><br />
|<nowiki>http://test.voc/row3</nowiki><br />
|-<br />
|<nowiki>http://test.voc/row1</nowiki><br />
|<nowiki>http://test.voc/name</nowiki><br />
|test1<br />
|-<br />
|<nowiki>http://test.voc/row1</nowiki><br />
|<nowiki>http://test.voc/number</nowiki><br />
|1e12<br />
|-<br />
|<nowiki>http://test.voc/row2</nowiki><br />
|<nowiki>http://test.voc/name</nowiki><br />
|test2<br />
|-<br />
|<nowiki>http://test.voc/row2</nowiki><br />
|<nowiki>http://test.voc/number</nowiki><br />
|2<br />
|-<br />
|<nowiki>http://test.voc/row3</nowiki><br />
|<nowiki>http://test.voc/name</nowiki><br />
|test3<br />
|-<br />
|<nowiki>http://test.voc/row3</nowiki><br />
|<nowiki>http://test.voc/number</nowiki><br />
|3<br />
|}<br />
</div><br />
</div><br />
<br />
== Data Tables Schema ==<br />
http://dataprotocols.org/json-table-schema/</div>
Maintenance script