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

Szymon Klarman edited this page Sep 20, 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://data.un.org/codes/sdg/>
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 used as dimensions in data cubes and one designated property sdgc:units for associating units with observed values. Every such property is both an instance of skos:Concept and rdf:Property. Moreover, every property except for sdgc:year, is also an instance of rdfs:Class. Each property except for sdgc:year is accompanied with a dedicated concept scheme containing all codes for

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

sdgc:age a skos:Concept, rdf:Property, rdfs:Class .
sdgc:age skos:inScheme <http://data.un.org/codes/sdg> .
sdgc:age skos:prefLabel "age"@en .
sdgc:age rdfs:range skos:Concept .
sdgc:age <http://data.un.org/codes/sdg#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://data.un.org/codes/sdg/age/Y15T19> skos:inScheme sdgc:ageCodes .
<http://data.un.org/codes/sdg/age/Y15T19> a skos:Concept, sdgc:age .
<http://data.un.org/codes/sdg/age/Y15T19> skos:prefLabel "15 to 19 years old"@en .
<http://data.un.org/codes/sdg/age/Y15T19> skos:notation "Y15T19" .

sdgc:sex a skos:Concept, rdf:Property, rdfs:Class .
sdgc:sex skos:inScheme <http://data.un.org/codes/sdg> .
sdgc:sex skos:prefLabel "sex"@en .
sdgc:sex rdfs:range skos:Concept .
sdgc:sex <http://data.un.org/codes/sdg#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://data.un.org/codes/sdg/sex/F> skos:inScheme sdgc:sexCodes .
<http://data.un.org/codes/sdg/sex/F> a skos:Concept, sdgc:sex .
<http://data.un.org/codes/sdg/sex/F> skos:prefLabel "Female"@en .
<http://data.un.org/codes/sdg/sex/F> skos:notation "F" .

sdgc:geoArea a skos:Concept, rdfs:Class, rdf:Property  .
sdgc:geoArea skos:inScheme <http://data.un.org/codes/sdg> .
sdgc:geoArea skos:prefLabel "geographic area"@en .
sdgc:geoArea rdfs:range skos:Concept .
sdgc:geoArea <http://data.un.org/codes/sdg#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://data.un.org/codes/sdg/geoArea/004> skos:inScheme sdgc:geoAreaCodes .
<http://data.un.org/codes/sdg/geoArea/004> a skos:Concept, sdgc:geoArea .
<http://data.un.org/codes/sdg/geoArea/004> skos:prefLabel "Afghanistan"@en .
<http://data.un.org/codes/sdg/geoArea/004> skos:notation "004" .

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

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

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

In order to represent geographical references used in the SDG data series, we developed a bespoke RDF vocabulary derived from the M49 standard. Further we mapped all countries to the corresponding ids in GeoNames and Wikidata, and imported some of the relevant information.

The following RDF snippet presents the geographical data about Canada:

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

<http://data.un.org/codes/sdg/geoArea/004>
  <http://data.un.org/codes/sdg/geoArea#iso2code> "AF" ;
  <http://data.un.org/codes/sdg/geoArea#iso3code> "AFG" ;
  <http://data.un.org/codes/sdg/geoArea#m49code> "4" ;
  a geoArea:co, geoArea:dc, geoArea:ldc, <http://data.un.org/codes/sdg/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://data.un.org/codes/sdg/geoAreaCodes> ;
  skos:notation "004" ;
  skos:prefLabel "Afganistán"@es, "Afghanistan"@en, "Afghanistan"@fr, "Афганистан"@ru, "أفغانستان"@ar, "阿富汗"@zh .

Clone this wiki locally