Child pages
  • Adding WSIS data
Skip to end of metadata
Go to start of metadata

Data file

Use the pre-processed tsv files for transformation:

The description of the needed transformation below is based on the raw data. It will be much easier using the referenced pre-processed files.

Prefixes

@prefix dct: <http://purl.org/dc/terms/> .
@prefix foaf: <http://xmlns.com/foaf/0.1/> .
@prefix oo: <http://purl.org/openorg/> .
@prefix schema: <http://schema.org/> .

Example 1 - adding a new organisation & person (I)

Input

y,,673135,Free Knowledge Institute,"The Free Knowledge Institute believes that by promoting the use of free knowledge in the fields of Technology, Education, Culture and Science  more individuals and organisations will profit from the benefits of sharing knowledge.",http://freeknowledge.eu/,access@freeknowledge.eu,Institutional,C,,,,"[{""salutation"":""Mr"",""first_name"":""Wouter"",""last_name"":""Tebbens"",""job_title"":""CEO"",""email"":""wouter@freeknowledge.eu"",""organization"":""Consortium of Thinkers"",""website"":""http:\/\/freeknowledge.eu\/"",""street_address"":""Cruquiuskade 219"",""city"":""Amsterdam"",""country"":""NL""}]",CC BY,,

Output for initiative data

<http://lobid.org/oer/$UUID1>
# If field "Initiative Type" has value "C" type resource as schema:Organization.
    a schema:Organization ;
    dct:identifier "wsis673135" ;
    schema:name "Free Knowledge Institute" ;
    schema:description "The Free Knowledge Institute believes that by promoting the use of free knowledge in the fields of Technology, Education, Culture and Science  more individuals and organisations will profit from the benefits of sharing knowledge." ;
    schema:url <http://freeknowledge.eu/> ;
    schema:email "access@freeknowledge.eu" ;
    oo:contact <http://lobid.org/oer/$UUID2> ;
    schema:address <urn:uuid:$UUID3> 
    schema:geo <$UUID31>.

<urn:uuid:$UUID3>
# Attach the address data that resides in the person field to the organization.
    a schema:PostalAddress ;
    schema:streetAddress "Cruquiuskade 219" ;
# We have to match the strings and the country code to GeoName Features.
    schema:addressLocality <http://sws.geonames.org/2759794/> ;
    schema:addressCountry <http://sws.geonames.org/2750405/> .

<urn:uuid:$UUID31>
    a schema:GeoCoordinates ;
    schema:longitude "4.88969" ;
    schema:latitude "52.37403" .

Output for person data

General remarks:

  • We won't use the URL information from the person entries as mostly also the organization/service/project URL is indicated.
  • The address info won't be attached to the person but to the organization/service/project.
<http://lobid.org/oer/$UUID2>
    a schema:Person ;
# Concatenate fields "first_name" and "last_name" for the schema:name literal.
    schema:name "Wouter Tebbens" ;
# Concatenate fields "job_title" and "organization" seperated by ", " for field schema:description.
    schema:description "CEO, Consortium of Thinkers" ;
    schema:email "wouter@freeknowledge.eu" .

Example 2 - adding a new organization & person (II)

Input

y,,673106,AMAQUEN,An association in French teaching and Learning.,http://amaquen.org,amaquen@amaquen.org,National,C,,,,"[{""salutation"":""Professor"",""first_name"":""Abdennasser"",""last_name"":""Naji"",""job_title"":""President"",""email"":""amaquen@amaquen.org"",""organization"":""Morocco"",""website"":""http:\/\/amaquen.org"",""street_address"":"""",""city"":""Rabat"",""country"":""MA""}]",Copyright,,

Output for initiative data

<http://lobid.org/oer/$UUID4>
# If field "Initiative Type" has value "C" type resource as schema:Organization.
    a schema:Organization ;
    dct:identifier "wsis673106" ;
    schema:name "AMAQUEN" ;
    schema:description "An association in French teaching and Learning." ;
    schema:url <http://amaquen.org> ;
    schema:email "amaquen@amaquen.org" ;
    oo:contact <http://lobid.org/oer/$UUID5> ;
    schema:address <urn:uuid:$UUID6> .

<urn:uuid:$UUID6>
# Attach the address data that resides in the person field to the organization.
    a schema:PostalAddress ;
    schema:streetAddress "Cruquiuskade 219" ;
# We have to match the strings and the country code to GeoName Features.
    schema:addressLocality <http://sws.geonames.org/2538475/> ;
    schema:addressCountry <http://sws.geonames.org/2542007/> .

Output for person data

<http://lobid.org/oer/$UUID5>
    a schema:Person ;
# Concatenate fields "first_name" and "last_name" for the schema:name literal.
    schema:name "Abdennasser Naji" ;
# Concatenate fields "job_title" and "organization" seperated by ", " for field schema:description.
    schema:description "President, Morocco" ;
    schema:email "amaquen@amaquen.org" .

Example 3 - adding a new project & person

Input

y,,673118,BerLin project,"Funded by HEFCE/JISC/HEA this project enhances and expands Nottingham’s existing Open Educational Repository, u-Now, one of the first OERs in the UK and a member of the international Open Courseware Consortium. Through providing guidance and advice, BERLiN benefits the whole of the UK sector by disseminating our experiences, as well as the outcomes of the project itself which is aimed at exploring the issues raised in the wider take-up and development of an OER.",http://unow.nottingham.ac.uk/berlin.html,,Institutional,P,,,,"[{""salutation"":""Mr"",""first_name"":""Andy"",""last_name"":""Beggan"",""job_title"":""Associate Manager"",""email"":""andy.beggan@nottingham.ac.uk"",""organization"":""Nottingham University - UK"",""website"":""http:\/\/www.nottingham.ac.uk\/"",""street_address"":"""",""city"":""Nottingham"",""country"":""GB""}]",Copyright,,

Output for initiative data

<http://lobid.org/oer/$UUID7>
# If field "Initiative Type" has value "P" type resource as foaf:Project.
    a foaf:Project ;
    dct:identifier "wsis673118" ;
    schema:name "BerLin project" ;
    schema:description "Funded by HEFCE/JISC/HEA this project enhances and expands Nottingham’s existing Open Educational Repository, u-Now, one of the first OERs in the UK and a member of the international Open Courseware Consortium. Through providing guidance and advice, BERLiN benefits the whole of the UK sector by disseminating our experiences, as well as the outcomes of the project itself which is aimed at exploring the issues raised in the wider take-up and development of an OER." ;
    schema:url <http://unow.nottingham.ac.uk/berlin.html> ;
    schema:email "amaquen@amaquen.org" ;
    oo:contact <http://lobid.org/oer/$UUID8> .
# schema:address NONE . Projects don't have a address according to AP. This makes it even more important to link them to the organisation(s) it is run within.

Output for person data

<http://lobid.org/oer/$UUID8>
    a schema:Person ;
# Concatenate fields "first_name" and "last_name" for the schema:name literal.
    schema:name "Andy Beggan" ;
# Concatenate fields "job_title" and "organization" seperated by ", " for field schema:description.
    schema:description "Associate Manager, Nottingham University - UK" ;
    schema:email "andy.beggan@nottingham.ac.uk" .

Example 4 - enriching an existing organization & adding a person

Input

y,http://lobid.org/oer/227ea4ad-faa6-4fe1-958a-e677f0f4cd57#!,673094,ABED,Association for Distance learning in Brazil,http://www2.abed.org.br,abed@abed.org.br,National,C,,,,"[{""salutation"":""Dr"",""first_name"":""Frederic M."",""last_name"":""Litto"",""job_title"":""President"",""email"":""frmlitto@terra.com.br"",""organization"":""Association of Distance learning"",""website"":""http:\/\/www2.abed.org.br"",""street_address"":"""",""city"":""S\u00e3o Paulo"",""country"":""BR""}]",Copyright,,

Output for initiative data

General remarks:
The URI in column two indicates that the resource already exists in the lobid data. If the resource in question is of type "C" (= schema:Organization) the person resource will be created and linked to the existing organization resource. Also some possible new data, like the email of the organization, is enriched:

<http://lobid.org/oer/227ea4ad-faa6-4fe1-958a-e677f0f4cd57#!>
# the existing lobid data won't be changed but the linkg to the person is added.
    ... ;
    schemaa:email "abed@abed.org.br" ;
    oo:contact <http://lobid.org/oer/$UUID10> .

Output for person data

<http://lobid.org/oer/$UUID10>
    a schema:Person ;
# Concatenate fields "first_name" and "last_name" for the schema:name literal.
    schema:name "Frederic M. Litto" ;
# Concatenate fields "job_title" and "organization" seperated by ", " for field schema:description.
    schema:description "President, Association of Distance learning" ;
    schema:email "frmlitto@terra.com.br" .

Example 5 - enriching an existing service and adding a person

Input

y,http://lobid.org/oer/65667483-8a3c-44ac-8e9a-c8f63b5ca71b#!,673214,Kyoto-U OpenCourseWare,"A member of the Japan OCW Alliance, Kyoto University OCW is a free and open publication of course materials in both Japanese and English. The goal of the OCW@KU Project is to transmit educational information from Kyoto University to the rest of the world.",http://ocw.kyoto-u.ac.jp/en/,secretariat@ceaie.edu.cn,Global,R,,,,"[{""salutation"":""Dr"",""first_name"":""Hiroshi"",""last_name"":""MATSUMOTO"",""job_title"":""President"",""email"":""matsumot@kurasc.kyoto-u.ac.jp"",""organization"":""Kyoto University"",""website"":""http:\/\/ocw.kyoto-u.ac.jp\/en\/"",""street_address"":"""",""city"":""Kyoto"",""country"":""JP""}]",Copyright,,

Output for initiative data

General remarks:
The URI in column two indicates that the resource already exists in the lobid data. If the resource in question is of type "R" (= schema:Service)

  • the existing resource information will be enriched with (if existing) the following fields: schema:name, schema:description, schema:email
  • the person resource will be created and linked to the existing organization resource.
<http://lobid.org/oer/65667483-8a3c-44ac-8e9a-c8f63b5ca71b#!>
# the existing lobid data won't be changed but some fields and the link to the person is added.
    ... ;
    schema:name "Kyoto-U OpenCourseWare" ;
    schema:description "A member of the Japan OCW Alliance, Kyoto University OCW is a free and open publication of course materials in both Japanese and English. The goal of the OCW@KU Project is to transmit educational information from Kyoto University to the rest of the world." ;
    schema:email "secretariat@ceaie.edu.cn" ;
    oo:contact <http://lobid.org/oer/$UUID11> .

Output for person data

<http://lobid.org/oer/$UUID11>
    a schema:Person ;
# Concatenate fields "first_name" and "last_name" for the schema:name literal.
    schema:name "Hiroshi MATSUMOTO" ;
# Concatenate fields "job_title" and "organization" seperated by ", " for field schema:description.
    schema:description "President, Kyoto University" ;
    schema:email "matsumot@kurasc.kyoto-u.ac.jp" .
  • No labels