Skip to content
This repository was archived by the owner on Jul 8, 2024. It is now read-only.

SDG data cube properties and codes schemes

Jump to bottom
sklarman edited this page Oct 31, 2019 · 18 revisions

Following a W3C recommended practice, all properties and their possible codes that are used for representing SDG series as RDF Data Cubes are defined as SKOS concepts and concept schemes. This representation is included in the file: sdg-codes.ttl.

We assume the following prefix declarations:

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> 
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX sdgc: <http://metadata.un.org/sdg/codes/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX sdmx-dimension:  <http://purl.org/linked-data/sdmx/2009/dimension#>

The main "UN SDG Data Series Property Scheme" describes all properties/attributes used as dimensions in data cubes. If further includes a designated property sdgc:units for associating units with observed values. Every such property is an instance of three classes:

  1. skos:Concept
  2. rdf:Property
  3. rdfs:Class (except for sdgc:year).

This extensive use of punning reflects multiple perspectives on data cube properties: a common semantic concept, a property of an observation with a specific code value, a class of all code values that belong to it. As values of sdgc:year range over xsd:gYear datatype, this property is not considered an rdfs:Class.

The code values for each property (again, except for sdgc:year) are further represented in dedicated concept schemes - one per each dimension property.

The following RDF snippet contains a fragment of the property and code schemes relevant for modelling the example from section SDG data cube properties and codes schemes:

<http://metadata.un.org/sdg/codes> a skos:ConceptScheme .
<http://metadata.un.org/sdg/codes> skos:prefLabel "UN SDG Data Series Property Scheme"@en .

sdgc:age a skos:Concept, rdf:Property, rdfs:Class .
sdgc:age skos:inScheme <http://metadata.un.org/sdg/codes> .
sdgc:age skos:prefLabel "age"@en .
sdgc:age rdfs:range sdgc:age .
sdgc:age <http://metadata.un.org/sdg/codes#sdmxDSDcode> "AGE" .
sdgc:age rdfs:subPropertyOf sdmx-dimension:age .

sdgc:ageCodes a skos:ConceptScheme .
sdgc:ageCodes skos:prefLabel "Coding scheme for attribute: age"@en .
<http://metadata.un.org/sdg/codes/age/Y15T19> skos:inScheme sdgc:ageCodes .
<http://metadata.un.org/sdg/codes/age/Y15T19> a skos:Concept, sdgc:age .
<http://metadata.un.org/sdg/codes/age/Y15T19> skos:prefLabel "15 to 19 years old"@en .
<http://metadata.un.org/sdg/codes/age/Y15T19> skos:notation "Y15T19" .
<http://metadata.un.org/sdg/codes/age/Y15T19> <http://metadata.un.org/sdg/codes#sdmxDSDcode> "Y15T19" .

sdgc:sex a skos:Concept, rdf:Property, rdfs:Class .
sdgc:sex skos:inScheme <http://metadata.un.org/sdg/codes> .
sdgc:sex skos:prefLabel "sex"@en .
sdgc:sex rdfs:range sdgc:sex .
sdgc:sex <http://metadata.un.org/sdg/codes#sdmxDSDcode> "SEX" .
sdgc:sex rdfs:subPropertyOf sdmx-dimension:sex .

sdgc:sexCodes a skos:ConceptScheme .
sdgc:sexCodes skos:prefLabel "Coding scheme for attribute: sex"@en .
<http://metadata.un.org/sdg/codes/sex/F> skos:inScheme sdgc:sexCodes .
<http://metadata.un.org/sdg/codes/sex/F> a skos:Concept, sdgc:sex .
<http://metadata.un.org/sdg/codes/sex/F> skos:prefLabel "Female"@en .
<http://metadata.un.org/sdg/codes/sex/F> skos:notation "F" .
<http://metadata.un.org/sdg/codes/sex/F> <http://metadata.un.org/sdg/codes#sdmxDSDcode> "F" .

sdgc:geoArea a skos:Concept, rdfs:Class, rdf:Property  .
sdgc:geoArea skos:inScheme <http://metadata.un.org/sdg/codes> .
sdgc:geoArea skos:prefLabel "geographic area"@en .
sdgc:geoArea rdfs:range sdgc:geoArea .
sdgc:geoArea <http://metadata.un.org/sdg/codes#sdmxDSDcode> "REF_AREA" .
sdgc:geoArea rdfs:subPropertyOf sdmx-dimension:refArea .

sdgc:geoAreaCodes a skos:ConceptScheme .
sdgc:geoAreaCodes skos:prefLabel "Coding scheme for attribute: geographic area (UN M49 standard)"@en .
<http://metadata.un.org/sdg/codes/geoArea/004> skos:inScheme sdgc:geoAreaCodes .
<http://metadata.un.org/sdg/codes/geoArea/004> a skos:Concept, sdgc:geoArea .
<http://metadata.un.org/sdg/codes/geoArea/004> skos:prefLabel "Afghanistan"@en .
<http://metadata.un.org/sdg/codes/geoArea/004> skos:notation "004" .

sdgc:units a skos:Concept, rdf:Property, rdfs:Class  .
sdgc:units skos:inScheme <http://metadata.un.org/sdg/codes> .
sdgc:units skos:prefLabel "unit of measurement"@en .
sdgc:units rdfs:range sdgc:units .
sdgc:units <http://metadata.un.org/sdg/codes#sdmxDSDcode> "UNIT_MEASURE" .

sdgc:unitsCodes a skos:ConceptScheme .
sdgc:unitsCodes skos:prefLabel "Units of measurement coding scheme"@en .
<http://metadata.un.org/sdg/codes/units/PER_1000_POP> skos:inScheme sdgc:unitsCodes .
<http://metadata.un.org/sdg/codes/units/PER_1000_POP> a skos:Concept, sdgc:units .
<http://metadata.un.org/sdg/codes/units/PER_1000_POP> skos:prefLabel "Per 1,000 population"@en .
<http://metadata.un.org/sdg/codes/units/PER_1000_POP> skos:notation "PER_1000_POP" .
<http://metadata.un.org/sdg/codes/units/PER_1000_POP> <http://metadata.un.org/sdg/codes#sdmxDSDcode> "PER_1000_POP" .

sdgc:year a skos:Concept, rdf:Property .
sdgc:year skos:inScheme <http://metadata.un.org/sdg/codes> .
sdgc:year skos:prefLabel "year"@en .
sdgc:year rdfs:range xsd:gYear .
sdgc:year <http://metadata.un.org/sdg/codes#sdmxDSDcode> "TIME_PERIOD" .
sdgc:year rdfs:subPropertyOf sdmx-dimension:refPeriod .

Whenever possible, the cube properties are further mapped to their corresponding sdmx-dimension properties via the rdfs:subPropertyOf relation. Further, we included mappings of properties and codes to their corresponding identifiers from the SDG Data Structure Definition, being currently developed by the IAEG-SDG Working Group on SDMX. These identifiers, whenever available, are associated via the property http://metadata.un.org/sdg/codes#sdmxDSDcode.

In the special case of geographic concepts, we have further extended their descriptions including:

  1. corresponding codes and hierarchical structures of the M49 and ISO standards;
  2. matching URIs from GeoNames and Wikidata
  3. multilingual labels imported from Wikidata.

The following RDF snippet presents the geographic data about Afghanistan:

@prefix geo: <http://metadata.un.org/sdg/codes/geoArea#> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .

<http://metadata.un.org/sdg/codes/geoArea/004>
  geo:iso2code "AF" ;
  geo:iso3code "AFG" ;
  geo:m49code "4" ;
  a geoArea:co, geoArea:dc, geoArea:ldc, <http://metadata.un.org/sdg/codes/geoArea>, skos:Concept ;
  skos:altLabel "Afghanistan (l')"@fr, "Afghanistan"@en ;
  skos:broader geoArea:034, geoArea:dc, geoArea:ldc ;
  skos:exactMatch <http://www.wikidata.org/entity/Q889>, <https://www.geonames.org/1149361> ;
  skos:inScheme <http://metadata.un.org/sdg/codes/geoAreaCodes> ;
  skos:notation "004" ;
  skos:prefLabel "Afganistán"@es, "Afghanistan"@en, "Afghanistan"@fr, "Афганистан"@ru, "أفغانستان"@ar, "阿富汗"@zh .

Overview

Contents

Clone this wiki locally