opencorporates_mapping.ttl

###############################################################################################
# RML mapping rules for OpenCorporates company data (https://opencorporates.com/info/our-data/)
# 
# Copyright: SINTEF 2018-2021
# Author   : Brian Elvesæter (brian.elvesater@sintef.no)
# License  : Apache License 2.0 (http://www.apache.org/licenses/LICENSE-2.0)
# Project  : Developed as part of the TheyBuyForYou project (https://theybuyforyou.eu/)
# Funding  : TheyBuyForYou has received funding from the European Union's Horizon 2020
#            research and innovation programme under grant agreement No 780247
###############################################################################################


# RML prefixes
@prefix rr:       <http://www.w3.org/ns/r2rml#> .
@prefix rml:      <http://semweb.mmlab.be/ns/rml#> .
@prefix ql:       <http://semweb.mmlab.be/ns/ql#> .

# Own prefixes
@base             <http://data.tbfy.eu/> .
@prefix ebg:      <http://data.businessgraph.io/ontology#> .
@prefix nace:     <http://data.businessgraph.io/nace/> .
@prefix lau:      <http://data.businessgraph.io/lau/> .
@prefix ebg-id:   <http://data.businessgraph.io/identifier/> .
@prefix ebg-comp: <http://data.businessgraph.io/company/> .

# External prefixes
@prefix adms:     <http://www.w3.org/ns/adms#> .
@prefix dbo:      <http://dbpedia.org/ontology/> .
@prefix dc:       <http://purl.org/dc/elements/1.1/> .
@prefix dct:      <http://purl.org/dc/terms/> .
@prefix foaf:     <http://xmlns.com/foaf/0.1/> .
@prefix locn:     <http://www.w3.org/ns/locn#> .
@prefix ngeo:     <http://geovocab.org/geometry#> .
@prefix nuts:     <http://nuts.geovocab.org/id/> .
@prefix ocds:     <https://theybuyforyou.eu/ontology/ocds/> .
@prefix org:      <http://www.w3.org/ns/org#> .
@prefix owl:      <http://www.w3.org/2002/07/owl#> .
@prefix puml:     <http://plantuml.com/ontology#> .
@prefix ramon:    <http://rdfdata.eionet.europa.eu/ramon/ontology/> .
@prefix rdf:      <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs:     <http://www.w3.org/2000/01/rdf-schema#> .
@prefix rov:      <http://www.w3.org/ns/regorg#> .
@prefix schema:   <http://schema.org/> .
@prefix sioc:     <http://rdfs.org/sioc/ns#> .
@prefix skos:     <http://www.w3.org/2004/02/skos/core#> .
@prefix spatial:  <http://geovocab.org/spatial#> .
@prefix time:     <http://www.w3.org/2006/time#> .
@prefix vann:     <http://purl.org/vocab/vann/> .
@prefix void:     <http://rdfs.org/ns/void#> .
@prefix xsd:      <http://www.w3.org/2001/XMLSchema#> .
@prefix person:   <http://www.w3.org/ns/person#> .
@prefix sem:      <http://semanticweb.cs.vu.nl/2009/11/sem/> .


# *************************************
# Registered organization mapping rules
# *************************************

<RegisteredOrganizationMap>
  a rr:TriplesMap ;

  rml:logicalSource [
    rml:source "input.xml" ; 
    rml:referenceFormulation ql:XPath ;
    rml:iterator "/root/results/company"
  ];

  rr:subjectMap [
    rr:template "http://data.tbfy.eu/organisation/{jurisdiction_code}-{company_number}" ;
    rr:class rov:RegisteredOrganization
  ];

  rr:predicateObjectMap [
    rr:predicate rov:legalName ;
    rr:objectMap [ 
      rml:reference "name" ;
      rr:datatype xsd:string
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate skos:prefLabel ;
    rr:objectMap [ 
      rml:reference "name" ;
      rr:datatype xsd:string
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate dbo:jurisdiction ;
    rr:objectMap [ 
      rml:reference "jurisdiction_code" ;
      rr:datatype xsd:string
    ];
  ];

  rr:predicateObjectMap [
    rr:predicate schema:foundingDate ;
    rr:objectMap [ 
      rml:reference "incorporation_date" ;
      rr:datatype xsd:date
    ];
  ];

  rr:predicateObjectMap [
    rr:predicate schema:dissolutionDate ;
    rr:objectMap [ 
      rml:reference "dissolution_date" ;
      rr:datatype xsd:date
    ];
  ];

  rr:predicateObjectMap [
    rr:predicate ebg:numberOfEmployees ;
    rr:objectMap [ 
      rml:reference "number_of_employees" ;
      rr:datatype xsd:integer
    ];
  ];

  rr:predicateObjectMap [
    rr:predicate ebg:orgActivity ;
    rr:objectMap [ 
      rr:template "http://data.tbfy.eu/nace/{industry_codes/industry_code/tbfy_nace/code}"
    ];
  ];

  rr:predicateObjectMap [
    rr:predicate ebg:orgActivityText ;
    rr:objectMap [ 
      rml:reference "industry_codes/industry_code/description" ;
      rr:datatype xsd:string
    ];
  ];

  rr:predicateObjectMap [
    rr:predicate ebg:orgTypeText ;
    rr:objectMap [ 
      rml:reference "company_type" ;
      rr:datatype xsd:string
    ];
  ];

  rr:predicateObjectMap [
    rr:predicate ebg:orgStatusText ;
    rr:objectMap [ 
      rml:reference "current_status" ;
      rr:datatype xsd:string
    ];
  ];

  rr:predicateObjectMap [
    rr:predicate rov:hasSite ;
    rr:objectMap [ 
      rr:template "http://data.tbfy.eu/organisation/{jurisdiction_code}-{company_number}/registeredSite/address" 
    ];
  ];

  rr:predicateObjectMap [
    rr:predicate rov:hasRegisteredSite ;
    rr:objectMap [ 
      rr:template "http://data.tbfy.eu/organisation/{jurisdiction_code}-{company_number}/registeredSite/address" 
    ];
  ];

#  rr:predicateObjectMap [
#    rr:predicate rov:registration ;
#    rr:objectMap [ 
#      rr:template "http://data.tbfy.eu/organisation/{jurisdiction_code}-{company_number}/id"
#    ];
#  ];

  rr:predicateObjectMap [
    rr:predicate adms:identifier ;
    rr:objectMap [ 
      rr:template "http://data.tbfy.eu/organisation/{jurisdiction_code}-{company_number}/id/OpenCorporates" 
    ];
  ].

<CompanyRegisteredAddressMap>
  a rr:TriplesMap ;

  rml:logicalSource [
    rml:source "input.xml" ; 
    rml:referenceFormulation ql:XPath ;
    rml:iterator "/root/results/company/registered_address"
  ];

  rr:subjectMap [
    rr:template "http://data.tbfy.eu/organisation/{../jurisdiction_code}-{../company_number}/registeredSite/address" ;
    rr:class org:Site ;
    rr:class locn:Address
  ];

  rr:predicateObjectMap [
    rr:predicate org:siteAddress ;
    rr:objectMap [ 
      rr:template "http://data.tbfy.eu/organisation/{../jurisdiction_code}-{../company_number}/registeredSite/address" 
    ];
  ];

  rr:predicateObjectMap [
    rr:predicate locn:fullAddress ;
    rr:objectMap [
      rml:reference "../registered_address_in_full" ;
      rr:datatype xsd:string
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate locn:postCode ;
    rr:objectMap [
      rml:reference "postal_code" ;
      rr:datatype xsd:string
    ]
  ];
 
  rr:predicateObjectMap [
    rr:predicate locn:postName ;
    rr:objectMap [
      rml:reference "locality" ;
      rr:datatype xsd:string
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate locn:thoroughfare ;
    rr:objectMap [
      rml:reference "street_address" ;
      rr:datatype xsd:string
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate locn:adminUnitL1 ;
    rr:objectMap [ 
      rr:template "http://nuts.geovocab.org/id/{../tbfy_ramon_code}" 
    ];
  ].

#<CompanyRegistrationMap>
#  a rr:TriplesMap ;
#
#  rml:logicalSource [
#    rml:source "input.xml" ; 
#    rml:referenceFormulation ql:XPath ;
#    rml:iterator "/root/results/company/source"
#  ];
#
#  rr:subjectMap [
#    rr:template "http://data.tbfy.eu/organisation/{../jurisdiction_code}-{../company_number}/id" ;
#    rr:class adms:Identifier
#  ];
#
#  rr:predicateObjectMap [
#    rr:predicate skos:notation;
#    rr:objectMap [
#      rml:reference "../company_number" ;
#      rr:datatype xsd:string
#    ]
#  ];
#
#  rr:predicateObjectMap [
#    rr:predicate dct:isPartOf ;
#    rr:objectMap [ 
#      rr:template "http://data.tbfy.eu/identifierSystem/{tbfy_url}"
#    ]
#  ];
#
#  rr:predicateObjectMap [
#    rr:predicate dct:creator ;
#    rr:objectMap [ 
#      rr:template "http://{tbfy_url}"
#    ]
#  ].
#
#<CompanyRegistrationIdentifierSystemMap>
#  a rr:TriplesMap ;
#
#  rml:logicalSource [
#    rml:source "input.xml" ; 
#    rml:referenceFormulation ql:XPath ;
#    rml:iterator "/root/results/company/source"
#  ];
#
#  rr:subjectMap [
#    rr:template "http://data.tbfy.eu/identifierSystem/{tbfy_url}" ;
#    rr:class ebg:IdentifierSystem
#  ];
#
#  rr:predicateObjectMap [
#    rr:predicate skos:notation;
#    rr:objectMap [
#      rml:reference "../jurisdiction_code" ;
#      rr:datatype xsd:string
#    ]
#  ];
#
#  rr:predicateObjectMap [
#    rr:predicate dct:creator ;
#    rr:objectMap [ 
#      rr:template "http://{tbfy_url}"
#    ]
#  ].
#
#<CompanyRegistrationIdentifierSystemOrganizationMap>
#  a rr:TriplesMap ;
#
#  rml:logicalSource [
#    rml:source "input.xml" ; 
#    rml:referenceFormulation ql:XPath ;
#    rml:iterator "/root/results/company/source"
#  ];
#
#  rr:subjectMap [
#    rr:template "http://{tbfy_url}" ;
#    rr:class schema:Organization
#  ].

<CompanyIdentifierMap>
  a rr:TriplesMap ;

  rml:logicalSource [
    rml:source "input.xml" ; 
    rml:referenceFormulation ql:XPath ;
    rml:iterator "/root/results/company"
  ];

  rr:subjectMap [
    rr:template "http://data.tbfy.eu/organisation/{jurisdiction_code}-{company_number}/id/OpenCorporates" ;
    rr:class adms:Identifier
  ];

  rr:predicateObjectMap [
    rr:predicate skos:notation;
    rr:objectMap [
      rml:reference "tbfy_company_identifier_notation"
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate dct:creator ;
    rr:objectMap [ 
      rr:template "https://opencorporates.com" 
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate dct:isPartOf ;
    rr:objectMap [ 
      rr:template "http://data.tbfy.eu/identifierSystem/OpenCorporates" 
    ];
  ].

<CompanyOfficerMap>
  a rr:TriplesMap ;

  rml:logicalSource [
    rml:source "input.xml" ; 
    rml:referenceFormulation ql:XPath ;
    rml:iterator "/root/results/company/officers/officer" ;
  ];

  rr:subjectMap [
    rr:template "http://data.tbfy.eu/organisation/{../../jurisdiction_code}-{../../company_number}/officer/{id}" ;
    rr:class org:Membership ;
  ];

  rr:predicateObjectMap [
    rr:predicate ebg:rolePositionText ;
    rr:objectMap [
      rml:reference "position" ;
      rr:datatype xsd:string
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate org:memberDuring ;
    rr:objectMap [
      rr:template "http://data.tbfy.eu/organisation/{../../jurisdiction_code}-{../../company_number}/officer/{id}/interval" 
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate org:organization ;
    rr:objectMap [
      rr:template "http://data.tbfy.eu/organisation/{../../jurisdiction_code}-{../../company_number}" 
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate org:member ;
    rr:objectMap [
      rr:template "http://data.tbfy.eu/officer/OpenCorporates/{id}" 
    ]
  ].

<CompanyOfficerIntervalMap>
  a rr:TriplesMap ;

  rml:logicalSource [
    rml:source "input.xml" ; 
    rml:referenceFormulation ql:XPath ;
    rml:iterator "/root/results/company/officers/officer"
  ];

  rr:subjectMap [
    rr:template "http://data.tbfy.eu/organisation/{../../jurisdiction_code}-{../../company_number}/officer/{id}/interval" ;
    rr:class time:Interval
  ];

  rr:predicateObjectMap [
    rr:predicate time:hasBeginning ;
    rr:objectMap [
      rr:template "http://data.tbfy.eu/organisation/{../../jurisdiction_code}-{../../company_number}/officer/{id}/interval/beginning" 
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate time:hasEnd ;
    rr:objectMap [
      rr:template "http://data.tbfy.eu/organisation/{../../jurisdiction_code}-{../../company_number}/officer/{id}/end" 
    ]
  ].

<CompanyOfficerIntervalBeginningMap>
  a rr:TriplesMap ;

  rml:logicalSource [
    rml:source "input.xml" ; 
    rml:referenceFormulation ql:XPath ;
    rml:iterator "/root/results/company/officers/officer"
  ];

  rr:subjectMap [
    rr:template "http://data.tbfy.eu/organisation/{../../jurisdiction_code}-{../../company_number}/officer/{id}/interval/beginning" ;
    rr:class time:Instant
  ];

  rr:predicateObjectMap [
    rr:predicate time:inXSDDate ;
    rr:objectMap [
      rml:reference "start_date" ;
      rr:datatype xsd:date
    ]
  ].

<CompanyOfficerIntervalEndMap>
  a rr:TriplesMap ;

  rml:logicalSource [
    rml:source "input.xml" ; 
    rml:referenceFormulation ql:XPath ;
    rml:iterator "/root/results/company/officers/officer"
  ];

  rr:subjectMap [
    rr:template "http://data.tbfy.eu/organisation/{../../jurisdiction_code}-{../../company_number}/officer/{id}/interval/end" ;
    rr:class time:Instant
  ];

  rr:predicateObjectMap [
    rr:predicate time:inXSDDate ;
    rr:objectMap [
      rml:reference "end_date" ;
      rr:datatype xsd:date
    ]
  ].


# *********************
# Officer mapping rules
# *********************

<OfficerMap>
  a rr:TriplesMap ;

  rml:logicalSource [
    rml:source "input.xml" ; 
    rml:referenceFormulation ql:XPath ;
    rml:iterator "/root/results/company/officers/officer"
  ];

  rr:subjectMap [
    rr:template "http://data.tbfy.eu/officer/OpenCorporates/{id}" ;
    rr:class person:Person
  ];

  rr:predicateObjectMap [
    rr:predicate schema:identifier ;
    rr:objectMap [
      rml:reference "id" ;
      rr:datatype xsd:string
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate person:birthName ;
    rr:objectMap [
      rml:reference "name" ;
      rr:datatype xsd:string
    ]
  ];

  rr:predicateObjectMap [
    rr:predicate schema:nationality ;
    rr:objectMap [
      rml:reference "nationality" ;
      rr:datatype xsd:string
    ]
  ].