search

polifonia-project / sonar2021_demo

This repository is created for the documentation of the Polifonia demo that is going to be presented to SONAR2021
https://polifonia-project.github.io/sonar2021_demo/
2 stars 0 forks source link

Data transformation: Raw JSON data —> Polifonia KG Manual Example #34

Closed FiorelaCiroku closed 2 years ago

FiorelaCiroku commented 2 years ago

Create ideal Places KG example manually. Examine the raw JSON data, and its fields, manually map the fields to both classes and properties of the Places (and Musical Performance + and Core) Ontology Module(s).

INPUT: https://github.com/polifonia-project/sonar2021_demo/blob/datasets/places/places.json

OUTPUT1a (RDF): manually created example RDF (can be Turtle or JSON-LD) with one/a few of the examples in the raw data mapped to the Places module.

OUTPUT1b: A list of binary relations/other requirements to edit the Ontology Modules.

FiorelaCiroku commented 2 years ago

OUTPUT 1a:

Example KG mapping output

Comment: The property coordinates from the JSON file has not been mapped yet.

OUTPUT 1b: In the Excel file you can find the corresponding properties of the module to the properties from the JSON file. There are properties like IDs (5 in total) that are not necessary to be mapped and are coloured orange. There are some properties whose mappings are missing because they have not been modelled in the module.

KG Mapping.xlsx

FiorelaCiroku commented 2 years ago 
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix xml: <http://www.w3.org/XML/1998/namespace> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix mp: <https://w3id.org/polifonia/ON/musical-performance/> .
@prefix core: <https://w3id.org/polifonia/ON/core/> .

<https://w3id.org/polifonia/resource/Recording/01> a mp:Recording ;
     mp:hasRecordingPerformer <https://w3id.org/polifonia/resource/Agent/the_beatles> ;
     core:hasTitle <https://w3id.org/polifonia/resource/Title/i_saw_her_standing_there> ;
     mp:hasSession <https://w3id.org/polifonia/resource/Session/session_01_1> , <https://w3id.org/polifonia/resource/Session/session_01_2> , <https://w3id.org/polifonia/resource/Session/session_01_3> .

<https://w3id.org/polifonia/resource/Agent/the_beatles> a core:Agent ;
     rdfs:label "The Beatles" ;
     core:hasBirthPlace <https://w3id.org/polifonia/resource/Place/great_britain> ;
     mp:hasMusicalActivityBeginPlace <https://w3id.org/polifonia/resource/Place/liverpool> .

<https://w3id.org/polifonia/resource/Title/i_saw_her_standing_there> a core:Title ;
     rdfs:label "I Saw Her Standing There" .

<https://w3id.org/polifonia/resource/Session/session_01_1> a mp:Session ;
     core:hasType <https://w3id.org/polifonia/resource/SessionType/edited_at> ;
     core:startTime "1963-02-25" ;
     core:endTime "1963-02-25" ;
     core:hasPlace <https://w3id.org/polifonia/resource/PhysicalPlace/physicalplace_1> .

<https://w3id.org/polifonia/resource/Session/session_01_2> a mp:Session ;
     core:hasType <https://w3id.org/polifonia/resource/SessionType/mixed_at> ;
     core:startTime "1963-02-25" ;
     core:endTime "1963-02-25" ;
     core:hasPlace <https://w3id.org/polifonia/resource/PhysicalPlace/physicalplace_1> .

<https://w3id.org/polifonia/resource/Session/session_01_3> a mp:Session ;
     core:hasType <https://w3id.org/polifonia/resource/SessionType/recorded_at> ;
     core:startTime "1963-02-11" ;
     core:endTime "1963-02-11" ;
     core:hasPlace <https://w3id.org/polifonia/resource/PhysicalPlace/physicalplace_1> .

<https://w3id.org/polifonia/resource/SessionType/edited_at> a mp:SessionType ;
     rdfs:label "edited at" .

<https://w3id.org/polifonia/resource/SessionType/mixed_at> a mp:SessionType ;
     rdfs:label "mixed at" .

<https://w3id.org/polifonia/resource/SessionType/recorded_at> a mp:SessionType ;
     rdfs:label "recorded at" .

<https://w3id.org/polifonia/resource/PhysicalPlace/physicalplace_1> a core:PhysicalPlace ;
     core:hasAddress "3 Abbey Road, St John\u2019s Wood, London"^^xsd:string ;
     core:hasCoordinates <https://w3id.org/polifonia/resource/Coordinates/coordinates_1> .

<https://w3id.org/polifonia/resource/Place/great_britain> a core:Place ;
     rdfs:label "GB" .

<https://w3id.org/polifonia/resource/Place/liverpool> a core:Place ;
     rdfs:label "Liverpool" .

<https://w3id.org/polifonia/resource/Coordinates/coordinates_1> ;
     core:lat "51.53192" ;
     core:long "-0.17835" .
FiorelaCiroku commented 2 years ago

Open issues:

  1. The mapping of the coordinate property. Should we create a new class in the module or create a property to connect it to GeographicalFeature or Geometry?
  2. The modelling of the property mp:hasRecordingPerformer should be completed.
  3. For the sake of the demo, can the range of mp:hasSessionType property be a literal?
  4. Can we create a binary relation e.g. mp:hasSession between mp:Recording to mp:Session?
  5. Can we add the youtube ID in the module?