Admin: Protected "Item:OSW7d3292e5104f45b1be4fc23901fae4fa": Protected as read-only import via Page Exchange extension ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]

2026-01-13T05:05:27Z

Protected "Tabular Data": Protected as read-only import via Page Exchange extension ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]

← Older revision

Revision as of 05:05, 13 January 2026

Admin: Update package: OSW Docs - Core

2026-01-13T05:05:26Z

Update package: OSW Docs - Core

jsondata
← Older revision		Revision as of 05:05, 13 January 2026
Line 423:		Line 423:
	</div>		</div>

	== Data Tables Schema ==		== Data Tables Schema and Tools ==
	http://dataprotocols.org/json-table-schema/
			* http://dataprotocols.org/json-table-schema/
			* [https://rml.io/yarrrml/https://www.w3.org/TR/csv2json/#examples Generating JSON from Tabular Data on the Web (w3.org)]
			* [https://rml.io/yarrrml/ YARRRML]
			* [https://github.com/Mat-O-Lab/CSVToCSVW Mat-O-Lab/CSVToCSVW: Generates JSON-LD for various types CSVs (github.com)]
Line 1:		Line 1:
	{		{
	"type": [		"type": [
	"Category:OSW494f660e6a714a1a9681c517bbb975da"		"Category:OSW494f660e6a714a1a9681c517bbb975da"
	],		],
	"uuid": "7d3292e5-104f-45b1-be4f-c23901fae4fa",		"uuid": "7d3292e5-104f-45b1-be4f-c23901fae4fa",
	"name": "TabularData",		"name": "TabularData",
	"label": [		"label": [
	{		{
	"text": "Tabular Data",		"text": "Tabular Data",
	"lang": "en"		"lang": "en"
	},		},
	{		{
	"text": "Tabellarische Daten",		"text": "Tabellarische Daten",
	"lang": "de"		"lang": "de"
	}		}
	],		],
	"required_predecessor": [		"required_predecessor": [
	"Item:OSW911488771ea449a6a34051f8213d7f2f"		"Item:OSW911488771ea449a6a34051f8213d7f2f"
	]		]
	}		}

Admin: Install package: OSW Docs - Core

2023-06-27T08:53:02Z

Install package: OSW Docs - Core

New page

==Tabular Data: JSON-Representation==
<div style=" column-count: 3;">
<div style="break-inside: avoid;">Table
{| class="wikitable"
|+
!id
!name
!number
|-
|row1
|test1
|1e12
|-
|row2
|test2
|2
|-
|row3
|test3
| 3
|}
</div>
<div style="break-inside: avoid;">JSON - id as key
<syntaxhighlight lang="json">
{
"content": {
"row1": {"id": "row1", "name": "test1", "number": "1e12"},
"row2": {"id": "row2", "name": "test2", "number": 2},
"row3": {"id": "row3", "name": "test3", "number": 3}
}
}
</syntaxhighlight>
</div>
<div style="break-inside: avoid;">JSON - index as key
<syntaxhighlight lang="json">
{
"content": [
{"id": "row1", "name": "test1", "number": "1e12"},
{"id": "row2", "name": "test2", "number": 2},
{"id": "row3", "name": "test3", "number": 3}
]
}
</syntaxhighlight>
</div>
</div>

==Tabular Data: JSON-LD Mapping==
*map each column to a term
*set a default language
*misuse language tag as unit tag - not recommended
<div style=" column-count: 2;">
<div style="break-inside: avoid;">JSON - id as key with context
<syntaxhighlight lang="json">
{
"@context": {
"test": "http://test.voc/",
"name": {"@id": "test:name", "@language": "en"},
"number": {"@id": "test:number", "@language": "Volt"},
"content": {"@container": "@index", "@id": "test:hasRow", "@index": "test:HasId"}
},
"content": {
"row1": {"id": "row1", "name": "test1", "number": "1e12"},
"row2": {"id": "row2", "name": "test2", "number": 2},
"row3": {"id": "row3", "name": "test3", "number": 3}
}
}
</syntaxhighlight>
</div>
<div style="break-inside: avoid;">Mapping
{| class="wikitable"
!Subject
!Predicate
!Object
!Language
|-
|_:b0
|<nowiki>http://test.voc/hasRow</nowiki>
|_:b1
|
|-
|_:b0
|<nowiki>http://test.voc/hasRow</nowiki>
|_:b2
|
|-
|_:b0
|<nowiki>http://test.voc/hasRow</nowiki>
|_:b3
|
|-
|_:b1
|<nowiki>http://test.voc/HasId</nowiki>
|row1
|
|-
|_:b1
|<nowiki>http://test.voc/name</nowiki>
|test1
|en
|-
|_:b1
|<nowiki>http://test.voc/number</nowiki>
|1e12
|volt
|-
|_:b2
|<nowiki>http://test.voc/HasId</nowiki>
|row2
|
|-
|_:b2
|<nowiki>http://test.voc/name</nowiki>
|test2
|en
|-
|_:b2
|<nowiki>http://test.voc/number</nowiki>
|2
|
|-
|_:b3
|<nowiki>http://test.voc/HasId</nowiki>
|row3
|
|-
|_:b3
|<nowiki>http://test.voc/name</nowiki>
|test3
|en
|-
|_:b3
|<nowiki>http://test.voc/number</nowiki>
|3
|
|}
</div>
</div>

==Tabular Data: JSON-LD Mapping==
*map each column to a term
*set a default language
*misuse language tag as unit tag - not recommended
<div style=" column-count: 2;">
<div style="break-inside: avoid;">JSON - index as key with context
<syntaxhighlight lang="json">
{
"@context": {
"test": "http://test.voc/",
"id": "test:hasId",
"name": {"@id": "test:name", "@language": "en"},
"number": {"@id": "test:number", "@language": "Volt"},
"content": {"@container": "@index", "@id": "test:hasRow", "@index": "test:HasId"}
},
"content": [
{"id": "row1", "name": "test1", "number": "1e12"},
{"id": "row2", "name": "test2", "number": 2},
{"id": "row3", "name": "test3", "number": 3}
]
}
</syntaxhighlight>
</div>
<div style="break-inside: avoid;">Mapping
{| class="wikitable"
!Subject
!Predicate
!Object
!Language
|-
|_:b0
|<nowiki>http://test.voc/hasRow</nowiki>
|_:b1
|
|-
|_:b0
|<nowiki>http://test.voc/hasRow</nowiki>
|_:b2
|
|-
|_:b0
|<nowiki>http://test.voc/hasRow</nowiki>
|_:b3
|
|-
|_:b1
|<nowiki>http://test.voc/hasId</nowiki>
|row1
|
|-
|_:b1
|<nowiki>http://test.voc/name</nowiki>
|test1
|en
|-
|_:b1
|<nowiki>http://test.voc/number</nowiki>
|1e12
|volt
|-
|_:b2
|<nowiki>http://test.voc/hasId</nowiki>
|row2
|
|-
|_:b2
|<nowiki>http://test.voc/name</nowiki>
|test2
|en
|-
|_:b2
|<nowiki>http://test.voc/number</nowiki>
|2
|
|-
|_:b3
|<nowiki>http://test.voc/hasId</nowiki>
|row3
|
|-
|_:b3
|<nowiki>http://test.voc/name</nowiki>
|test3
|en
|-
|_:b3
|<nowiki>http://test.voc/number</nowiki>
|3
|
|}
</div>
</div>

==Tabular Data: JSON-LD Mapping==
*alternative mapping with named nodes
<div style=" column-count: 2;">
<div style="break-inside: avoid;">JSON - index as key with context
<syntaxhighlight lang="json">
{
"@context": {
"test": "http://test.voc/",
"id": {"@id": "@id", "@context": {"@base": "http://test.voc/"}},
"name": {"@id": "test:name", "@language": "en"},
"number": {"@id": "test:number", "@language": "Volt"},
"content": {"@container": "@index", "@id": "test:hasRow", "@index": "test:HasId", "@context": {"@base": "http://test.voc/"}}
},
"@id": "test:myTable",
"content": [
{"id": "row1", "name": "test1", "number": "1e12"},
{"id": "row2", "name": "test2", "number": 2},
{"id": "row3", "name": "test3", "number": 3}
]
}
</syntaxhighlight>
</div>
<div style="break-inside: avoid;">Mapping

</div>
{| class="wikitable"
!Subject
!Predicate
!Object
!Language
|-
|<nowiki>http://test.voc/myTable</nowiki>
|<nowiki>http://test.voc/hasRow</nowiki>
|<nowiki>http://test.voc/row1</nowiki>
|
|-
|<nowiki>http://test.voc/myTable</nowiki>
|<nowiki>http://test.voc/hasRow</nowiki>
|<nowiki>http://test.voc/row2</nowiki>
|
|-
|<nowiki>http://test.voc/myTable</nowiki>
|<nowiki>http://test.voc/hasRow</nowiki>
|<nowiki>http://test.voc/row3</nowiki>
|
|-
|<nowiki>http://test.voc/row1</nowiki>
|<nowiki>http://test.voc/name</nowiki>
|test1
|en
|-
|<nowiki>http://test.voc/row1</nowiki>
|<nowiki>http://test.voc/number</nowiki>
|1e12
|volt
|-
|<nowiki>http://test.voc/row2</nowiki>
|<nowiki>http://test.voc/name</nowiki>
|test2
|en
|-
|<nowiki>http://test.voc/row2</nowiki>
|<nowiki>http://test.voc/number</nowiki>
|2
|
|-
|<nowiki>http://test.voc/row3</nowiki>
|<nowiki>http://test.voc/name</nowiki>
|test3
|en
|-
|<nowiki>http://test.voc/row3</nowiki>
|<nowiki>http://test.voc/number</nowiki>
|3
|
|}
</div>

==Tabular Data: JSON-LD Mapping==

<div style=" column-count: 2;">
<div style="break-inside: avoid;">JSON - index as key with context, header meta data
<syntaxhighlight lang="json">
{
"@context": {
"test": "http://test.voc/",
"id": {"@id": "@id", "@context": {"@base": "http://test.voc/"}},
"name": {"@id": "test:name", "@language": "en"},
"number": {"@id": "test:number"},
"property": {"@id": "test:hasProperty", "@type": "@id"},
"unit": {"@id": "test:hasUnit", "@type": "@id"},
"header": {"@container": "@index", "@id": "test:hasColumn", "@index": "test:HasId", "@context": {"@base": "http://test.voc/"}},
"content": {"@container": "@index", "@id": "test:hasRow", "@index": "test:HasId", "@context": {"@base": "http://test.voc/"}}
},
"@id": "test:myTable",
"header": [
{"id": "column1", "name": "id", "property": "test:hasId"},
{"id": "column2", "name": "name", "property": "test:hasName"},
{"id": "column3", "name": "number", "property": "test:hasNumber", "unit": "test:volt"}
],
"content": [
{"id": "row1", "name": "test1", "number": "1e12"},
{"id": "row2", "name": "test2", "number": 2},
{"id": "row3", "name": "test3", "number": 3}
]
}
</syntaxhighlight>
</div>
<div style="break-inside: avoid;">Mapping
{| class="wikitable"
!Subject
!Predicate
!Object
|-
|<nowiki>http://test.voc/column1</nowiki>
|<nowiki>http://test.voc/hasProperty</nowiki>
|<nowiki>http://test.voc/hasId</nowiki>
|-
|<nowiki>http://test.voc/column1</nowiki>
|<nowiki>http://test.voc/name</nowiki>
|id
|-
|<nowiki>http://test.voc/column2</nowiki>
|<nowiki>http://test.voc/hasProperty</nowiki>
|<nowiki>http://test.voc/hasName</nowiki>
|-
|<nowiki>http://test.voc/column2</nowiki>
|<nowiki>http://test.voc/name</nowiki>
|name
|-
|<nowiki>http://test.voc/column3</nowiki>
|<nowiki>http://test.voc/hasProperty</nowiki>
|<nowiki>http://test.voc/hasNumber</nowiki>
|-
|<nowiki>http://test.voc/column3</nowiki>
|<nowiki>http://test.voc/hasUnit</nowiki>
|<nowiki>http://test.voc/volt</nowiki>
|-
|<nowiki>http://test.voc/column3</nowiki>
|<nowiki>http://test.voc/name</nowiki>
|number
|-
|<nowiki>http://test.voc/myTable</nowiki>
|<nowiki>http://test.voc/hasColumn</nowiki>
|<nowiki>http://test.voc/column1</nowiki>
|-
|<nowiki>http://test.voc/myTable</nowiki>
|<nowiki>http://test.voc/hasColumn</nowiki>
|<nowiki>http://test.voc/column2</nowiki>
|-
|<nowiki>http://test.voc/myTable</nowiki>
|<nowiki>http://test.voc/hasColumn</nowiki>
|<nowiki>http://test.voc/column3</nowiki>
|-
|<nowiki>http://test.voc/myTable</nowiki>
|<nowiki>http://test.voc/hasRow</nowiki>
|<nowiki>http://test.voc/row1</nowiki>
|-
|<nowiki>http://test.voc/myTable</nowiki>
|<nowiki>http://test.voc/hasRow</nowiki>
|<nowiki>http://test.voc/row2</nowiki>
|-
|<nowiki>http://test.voc/myTable</nowiki>
|<nowiki>http://test.voc/hasRow</nowiki>
|<nowiki>http://test.voc/row3</nowiki>
|-
|<nowiki>http://test.voc/row1</nowiki>
|<nowiki>http://test.voc/name</nowiki>
|test1
|-
|<nowiki>http://test.voc/row1</nowiki>
|<nowiki>http://test.voc/number</nowiki>
|1e12
|-
|<nowiki>http://test.voc/row2</nowiki>
|<nowiki>http://test.voc/name</nowiki>
|test2
|-
|<nowiki>http://test.voc/row2</nowiki>
|<nowiki>http://test.voc/number</nowiki>
|2
|-
|<nowiki>http://test.voc/row3</nowiki>
|<nowiki>http://test.voc/name</nowiki>
|test3
|-
|<nowiki>http://test.voc/row3</nowiki>
|<nowiki>http://test.voc/number</nowiki>
|3
|}
</div>
</div>

== Data Tables Schema ==
http://dataprotocols.org/json-table-schema/

Item:OSW7d3292e5104f45b1be4fc23901fae4fa - Revision history

Admin: Protected "Item:OSW7d3292e5104f45b1be4fc23901fae4fa": Protected as read-only import via Page Exchange extension ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]

Admin: Update package: OSW Docs - Core

Admin: Install package: OSW Docs - Core