CSVW for energy datasets - Revision history

Valerias: /* Worked example: Power plant information */

2022-11-07T19:24:28Z

Worked example: Power plant information

← Older revision		Revision as of 19:24, 7 November 2022
Line 401:		Line 401:
	<nowiki>		<nowiki>
	{		{
	"titles": "~~lat~~",		"titles": "latitude",
	"dc:description": "geo location of the position of a power plant, latitude, WGS84",		"dc:description": "geo location of the position of a power plant, latitude, WGS84",
	"datatype": {		"datatype": {

Valerias: /* Worked example: Power plant information */

2022-11-07T19:19:23Z

Worked example: Power plant information

@@ Line 396: / Line 396: @@
   </nowiki>
 There is no resource which actually allows to express that the entry is an identifier from the SIEC list. Instead, here a more general property is used. schema:identifier represents any kind of identifier for any kind of thing, so not specifying that it is an energy product.
 For the commissioning date, the entry looks like this

Valerias: /* Worked example: Power plant information */

2022-11-07T10:00:55Z

Worked example: Power plant information

← Older revision		Revision as of 10:00, 7 November 2022
Line 390:		Line 390:

	<nowiki>		<nowiki>
	{
	"titles": "using energy product",		"titles": "using energy product",
	"dc:description": "Standard international energy product classification for the energy product used as input for the power plant",		"dc:description": "Standard international energy product classification for the energy product used as input for the power plant",
	"valueURL": "https://dd.eionet.europa.eu/vocabularyconcept/eurostat/siec/{using energy product}"		"valueURL": "https://dd.eionet.europa.eu/vocabularyconcept/eurostat/siec/{using energy product}"
	}		"propertyURL": "schema:identifier"
	</nowiki>		</nowiki>
			There is no resource which actually allows to express that the entry is an identifier from the SIEC list. Instead, here a more general property is used. schema:identifier represents any kind of identifier for any kind of thing, so not specifying that it is an energy product.

	For the commissioning date, the entry looks like this		For the commissioning date, the entry looks like this

Valerias: /* Worked example: Power plant information */

2022-11-07T09:38:08Z

Worked example: Power plant information

← Older revision		Revision as of 09:38, 7 November 2022
Line 389:		Line 389:
	given [https://dd.eionet.europa.eu/vocabularies here]. Following Example 60 of the primer, the valueURL property can be used to automatically expand the entry from the 'using energy product' column into the corresponding resource, the		given [https://dd.eionet.europa.eu/vocabularies here]. Following Example 60 of the primer, the valueURL property can be used to automatically expand the entry from the 'using energy product' column into the corresponding resource, the

	<nowiki>		<nowiki>
	{		{
	"titles": "using energy product",		"titles": "using energy product",

Valerias: /* Worked example: Power plant information */

2022-11-07T09:37:15Z

Worked example: Power plant information

← Older revision		Revision as of 09:37, 7 November 2022
Line 383:		Line 383:
	"dc:description": Type of the power plant",		"dc:description": Type of the power plant",
	"datatype": "string",		"datatype": "string",
	"~~aboutURL~~": "oeo:OEO_00000311"		"@type": "oeo:OEO_00000311"
	</nowiki>		</nowiki>

	The third column specifies more in detail the energy input to the power plant in terms of the [https://unstats.un.org/unsd/classifications/Family/Detail/2007 standard international energy product classicification]. A machine-actionable version of this classification is provided by [https://dd.eionet.europa.eu/vocabulary/eurostat/siec/view Eionet Data Dictionary]. The identifier RA310, which describes the "wind onshore" energy product, is located at this [http://dd.eionet.europa.eu/vocabulary/eurostat/siec/RA310 link]. More resources for vocabularies in the context of EU directives are		The third column specifies more in detail the energy input to the power plant in terms of the [https://unstats.un.org/unsd/classifications/Family/Detail/2007 standard international energy product classicification]. A machine-actionable version of this classification is provided by [https://dd.eionet.europa.eu/vocabulary/eurostat/siec/view Eionet Data Dictionary]. The identifier RA310, which describes the "wind onshore" energy product, is located at this [http://dd.eionet.europa.eu/vocabulary/eurostat/siec/RA310 link]. More resources for vocabularies in the context of EU directives are
	given [https://dd.eionet.europa.eu/vocabularies here].		given [https://dd.eionet.europa.eu/vocabularies here]. Following Example 60 of the primer, the valueURL property can be used to automatically expand the entry from the 'using energy product' column into the corresponding resource, the

			<nowiki>
			{
			"titles": "using energy product",
			"dc:description": "Standard international energy product classification for the energy product used as input for the power plant",
			"valueURL": "https://dd.eionet.europa.eu/vocabularyconcept/eurostat/siec/{using energy product}"
			}
			</nowiki>

	For the commissioning date, the entry looks like this		For the commissioning date, the entry looks like this

Valerias: /* Worked example: Power plant information */

2022-11-07T08:57:38Z

Worked example: Power plant information

← Older revision		Revision as of 08:57, 7 November 2022
Line 386:		Line 386:
	</nowiki>		</nowiki>

	The third column specifies more in detail the energy input to the power plant in terms of the [https://unstats.un.org/unsd/classifications/Family/Detail/2007 standard international energy classicification]		The third column specifies more in detail the energy input to the power plant in terms of the [https://unstats.un.org/unsd/classifications/Family/Detail/2007 standard international energy product classicification]. A machine-actionable version of this classification is provided by [https://dd.eionet.europa.eu/vocabulary/eurostat/siec/view Eionet Data Dictionary]. The identifier RA310, which describes the "wind onshore" energy product, is located at this [http://dd.eionet.europa.eu/vocabulary/eurostat/siec/RA310 link]. More resources for vocabularies in the context of EU directives are
			given [https://dd.eionet.europa.eu/vocabularies here].

	For the commissioning date, the entry looks like this		For the commissioning date, the entry looks like this

Valerias: /* Specifying information about table headers */

2022-11-02T10:53:15Z

Specifying information about table headers

← Older revision		Revision as of 10:53, 2 November 2022
Line 255:		Line 255:
	"titles": "national industrial sector classification",		"titles": "national industrial sector classification",
	"datatype": {		"datatype": {
	"~~aboutURL~~": "https://www.wikidata.org/wiki/Q2976602",		"@type": "https://www.wikidata.org/wiki/Q2976602",
	"dc:title": "Swedish Standard Industrial Classification",		"dc:title": "Swedish Standard Industrial Classification",
	"dc:description": "Swedish Standard Industrial Classification for activities by the citizen-led initiative",		"dc:description": "Swedish Standard Industrial Classification for activities by the citizen-led initiative",
Line 263:		Line 263:
	</nowiki>		</nowiki>
	While wikidata offers resources for the [NACE classification codes] and the [https://www.wikidata.org/wiki/Q100269151 Belgium classification code], no resource is available for the Swedish case. As a minimum, wikidata allows a resource for economic classification schemes, in general, using the resource [https://www.wikidata.org/wiki/Q2976602 wikidata:Q2976602]		While wikidata offers resources for the [NACE classification codes] and the [https://www.wikidata.org/wiki/Q100269151 Belgium classification code], no resource is available for the Swedish case. As a minimum, wikidata allows a resource for economic classification schemes, in general, using the resource [https://www.wikidata.org/wiki/Q2976602 wikidata:Q2976602]
	or [https://www.wikidata.org/wiki/Q27048688 wikidata:Q27048688]. For describing that all values in a column are of a particular type, the csv on the web offers the statement ~~aboutURL~~. An alternative is offered here by DBpedia, which has a resource [https://dbpedia.org/page/Category:Industry_classifications dbr:International_Standard_Industrial_Classification] exactly providing what is given in the column of the csv file. Thus, the type can be specified as "~~aboutURL~~": "dbr:International_Standard_Industrial_Classification".		or [https://www.wikidata.org/wiki/Q27048688 wikidata:Q27048688]. For describing that all values in a column are of a particular type, the csv on the web offers the statement @type. An alternative is offered here by DBpedia, which has a resource [https://dbpedia.org/page/Category:Industry_classifications dbr:International_Standard_Industrial_Classification] exactly providing what is given in the column of the csv file. Thus, the type can be specified as "@type": "dbr:International_Standard_Industrial_Classification".

	The next two column describe the purpose statement of the initiative, both in the native language, i.e. Swedish, and in English. Following [https://www.w3.org/TR/tabular-data-primer/#column-language Example 96] from the Primer, this is specified with the lang property. According to [https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes ISO 639-1], the corresponding value for Swedish is sv. The fact that the entry itself is a corporate purpose statement can be expressed using the wikidata resource [https://www.wikidata.org/wiki/Q2498417 Q2498417].		The next two column describe the purpose statement of the initiative, both in the native language, i.e. Swedish, and in English. Following [https://www.w3.org/TR/tabular-data-primer/#column-language Example 96] from the Primer, this is specified with the lang property. According to [https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes ISO 639-1], the corresponding value for Swedish is sv. The fact that the entry itself is a corporate purpose statement can be expressed using the wikidata resource [https://www.wikidata.org/wiki/Q2498417 Q2498417].
Line 270:		Line 270:
	{		{
	"titles": "purpose (original language)",		"titles": "purpose (original language)",
	"~~aboutURL~~": "wikidata:Q2498417",		"@type": "wikidata:Q2498417",
	"dc:description": "Purpose statement of the initiative in Swedish",		"dc:description": "Purpose statement of the initiative in Swedish",
	"lang": "sv"		"lang": "sv"

Valerias: /* Worked example: Power plant information */

2022-10-31T09:59:29Z

Worked example: Power plant information

← Older revision		Revision as of 09:59, 31 October 2022
Line 386:		Line 386:
	</nowiki>		</nowiki>

	The third column specifies more in detail the energy input to the power plant in terms of the [standard		The third column specifies more in detail the energy input to the power plant in terms of the [https://unstats.un.org/unsd/classifications/Family/Detail/2007 standard international energy classicification]
	]

	For the commissioning date, the entry looks like this		For the commissioning date, the entry looks like this

Valerias: /* Worked example: Power plant information */

2022-10-31T09:44:00Z

Worked example: Power plant information

← Older revision		Revision as of 09:44, 31 October 2022
Line 385:		Line 385:
	"aboutURL": "oeo:OEO_00000311"		"aboutURL": "oeo:OEO_00000311"
	</nowiki>		</nowiki>

			The third column specifies more in detail the energy input to the power plant in terms of the [standard
			]

	For the commissioning date, the entry looks like this		For the commissioning date, the entry looks like this

Valerias: /* Worked example: Power plant information */

2022-10-31T09:29:02Z

Worked example: Power plant information

← Older revision		Revision as of 09:29, 31 October 2022
Line 377:		Line 377:
	</nowiki>		</nowiki>

	The second column contains information about the type of the power plant. There is a discussion comparing different resources for power plant types [https://eeradata-platform.eu/wiki/index.php?title=Example:_Standards_on_power_plants here]. Taking the results from this discussion, the wikidata resource [https://www.wikidata.org/wiki/Q50687555 wikidata:Q50687555] and/or the resource [http://openenergy-platform.org/ontology/oeo/OEO_00000311 oeo:OEO_00000311] offered the open energy ontology can be used to relate to.		The second column contains information about the type of the power plant. There is a discussion comparing different resources for power plant types [https://eeradata-platform.eu/wiki/index.php?title=Example:_Standards_on_power_plants here]. Taking the results from this discussion, the wikidata resource [https://www.wikidata.org/wiki/Q50687555 wikidata:Q50687555] and/or the resource [http://openenergy-platform.org/ontology/oeo/OEO_00000311 oeo:OEO_00000311] offered the open energy ontology can be used to relate to. The corresponding entry to the metadata file may look this

			<nowiki>
			"titles": "type",
			"dc:description": Type of the power plant",
			"datatype": "string",
			"aboutURL": "oeo:OEO_00000311"
			</nowiki>

	For the commissioning date, the entry looks like this		For the commissioning date, the entry looks like this