prototype connection

[hirmore]

Server

• Triply
• Virtuoso
• Cellar
• Throttle limit
• CORS

Data

• Key vs code problem with notation
• Comments have extra info? ("Source code (2804 70 00) deleted in CN2021.")
• How to define last year

Data Query

• Prefixes
• Filter (RegEx)

[hirmore]

Key vs Code Problem

Query

`PREFIX : http:https://data.europa.eu/xsp/cn2022/
PREFIX skos: http:https://www.w3.org/2004/02/skos/core#
PREFIX xkos: http:https://rdf-vocabulary.ddialliance.org/xkos#

SELECT (?S_KEY as ?CN2022_KEY) (?S_CODE as ?CN2022_CODE) (?NAME_Source as ?CN2022_NAME) (?T_KEY as ?CN2021_KEY) (?T_CODE as ?CN2021_CODE) (?NAME_Target as ?CN2021_NAME) 
WHERE { 
  :CN2022_CN2021 xkos:madeOf ?Associations .
  ?Associations xkos:sourceConcept ?Source .

  ?Source skos:notation ?S_Notation;
    skos:altLabel ?S_Name;
    dc:identifier ?S_KEY . 
  BIND (STR(?S_Notation) as ?S_CODE) 
  BIND (STR(?S_Name) AS ?NAME_Source)
  FILTER (LANG(?S_Name) = "en")
      FILTER (regex(?S_KEY, "8479200000*"))

  OPTIONAL { ?Associations rdfs:comment ?Comment . }

  OPTIONAL { ?Associations xkos:targetConcept ?Target . 
       ?Target skos:notation ?T_Notation ;
         skos:altLabel ?T_Name;
         dc:identifier ?T_KEY .}
  FILTER (LANG(?T_Name) = "en")
  BIND (STR(?T_Name) AS ?NAME_Target)
  BIND (STR(?T_Notation) as ?T_CODE )
} LIMIT 10`

Response

Query (1).csv

[hirmore]

How to react to comments? E.g.: "Source code (2804 70 00) deleted in CN2021."