CINXE.COM
CORDIS : a SPARQL endpoint is born ! - Sparna Blog
<!DOCTYPE html> <html lang="fr-FR" prefix="og: http://ogp.me/ns#"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>CORDIS : a SPARQL endpoint is born ! - Sparna Blog</title> <link rel="pingback" href="https://blog.sparna.fr/xmlrpc.php"> <!--[if lt IE 9]> <script src="https://blog.sparna.fr/wp-content/themes/wpex-luxmag/js/plugins/html5.js"></script> <![endif]--> <!-- This site is optimized with the Yoast WordPress SEO plugin v2.2.1 - https://yoast.com/wordpress/plugins/seo/ --> <link rel="canonical" href="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/" /> <meta property="og:locale" content="fr_FR" /> <meta property="og:type" content="article" /> <meta property="og:title" content="CORDIS : a SPARQL endpoint is born ! - Sparna Blog" /> <meta property="og:description" content="Another star to light on EU’s linked open data maturity flag ! 🌟 Not talking about 2024 exceptional Northern Lights to come, but this one’s also good news for science ! ➡️ Late 2023, the Publications Office of the European Union announced on social media the public release of the new CORDIS SPARQL endpoint. CORDIS, aka « the Community…" /> <meta property="og:url" content="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/" /> <meta property="og:site_name" content="Sparna Blog" /> <meta property="article:tag" content="endpoint" /> <meta property="article:tag" content="Europe" /> <meta property="article:tag" content="Linked Data" /> <meta property="article:tag" content="Linked Open Data" /> <meta property="article:tag" content="ontologie" /> <meta property="article:tag" content="ontologies" /> <meta property="article:tag" content="Open Data" /> <meta property="article:tag" content="SPARQL" /> <meta property="article:tag" content="thesaurus" /> <meta property="article:section" content="Linked Data" /> <meta property="article:published_time" content="2024-01-15T09:55:41+00:00" /> <meta property="article:modified_time" content="2024-01-23T16:55:43+00:00" /> <meta property="og:updated_time" content="2024-01-23T16:55:43+00:00" /> <meta property="og:image" content="https://blog.sparna.fr/wp-content/uploads/2024/01/person-holding-bengal-light-hand_23-2147955677.jpg" /> <meta name="twitter:card" content="summary"/> <meta name="twitter:description" content="Another star to light on EU’s linked open data maturity flag ! 🌟 Not talking about 2024 exceptional Northern Lights to come, but this one’s also good news for science ! ➡️ Late 2023, the Publications Office of the European Union announced on social media the public release of the new CORDIS SPARQL endpoint. CORDIS, aka « the Community…"/> <meta name="twitter:title" content="CORDIS : a SPARQL endpoint is born ! - Sparna Blog"/> <meta name="twitter:domain" content="Sparna Blog"/> <meta name="twitter:image:src" content="https://blog.sparna.fr/wp-content/uploads/2024/01/person-holding-bengal-light-hand_23-2147955677.jpg"/> <!-- / Yoast WordPress SEO plugin. --> <link rel="alternate" type="application/rss+xml" title="Sparna Blog » Flux" href="https://blog.sparna.fr/feed/" /> <link rel="alternate" type="application/rss+xml" title="Sparna Blog » Flux des commentaires" href="https://blog.sparna.fr/comments/feed/" /> <link rel="alternate" type="application/rss+xml" title="Sparna Blog » CORDIS : a SPARQL endpoint is born ! Flux des commentaires" href="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/feed/" /> <script type="text/javascript"> window._wpemojiSettings = {"baseUrl":"https:\/\/s.w.org\/images\/core\/emoji\/72x72\/","ext":".png","source":{"concatemoji":"https:\/\/blog.sparna.fr\/wp-includes\/js\/wp-emoji-release.min.js?ver=4.2.38"}}; !function(e,n,t){var a;function o(e){var t=n.createElement("canvas"),a=t.getContext&&t.getContext("2d");return!(!a||!a.fillText)&&(a.textBaseline="top",a.font="600 32px Arial","flag"===e?(a.fillText(String.fromCharCode(55356,56812,55356,56807),0,0),3e3<t.toDataURL().length):(a.fillText(String.fromCharCode(55357,56835),0,0),0!==a.getImageData(16,16,1,1).data[0]))}function i(e){var t=n.createElement("script");t.src=e,t.type="text/javascript",n.getElementsByTagName("head")[0].appendChild(t)}t.supports={simple:o("simple"),flag:o("flag")},t.DOMReady=!1,t.readyCallback=function(){t.DOMReady=!0},t.supports.simple&&t.supports.flag||(a=function(){t.readyCallback()},n.addEventListener?(n.addEventListener("DOMContentLoaded",a,!1),e.addEventListener("load",a,!1)):(e.attachEvent("onload",a),n.attachEvent("onreadystatechange",function(){"complete"===n.readyState&&t.readyCallback()})),(a=t.source||{}).concatemoji?i(a.concatemoji):a.wpemoji&&a.twemoji&&(i(a.twemoji),i(a.wpemoji)))}(window,document,window._wpemojiSettings); </script> <style type="text/css"> img.wp-smiley, img.emoji { display: inline !important; border: none !important; box-shadow: none !important; height: 1em !important; width: 1em !important; margin: 0 .07em !important; vertical-align: -0.1em !important; background: none !important; padding: 0 !important; } </style> <link rel='stylesheet' id='symple_shortcode_styles-css' href='https://blog.sparna.fr/wp-content/plugins/symple-shortcodes/shortcodes/css/symple_shortcodes_styles.css?ver=4.2.38' type='text/css' media='all' /> <link rel='stylesheet' id='wpex-style-css' href='https://blog.sparna.fr/wp-content/themes/wpex-luxmag/style.css?ver=4.2.38' type='text/css' media='all' /> <link rel='stylesheet' id='wpex-google-font-source-sans-pro-css' href='http://fonts.googleapis.com/css?family=Source+Sans+Pro%3A300%2C400%2C600%2C700&subset=latin%2Cvietnamese%2Clatin-ext&ver=4.2.38' type='text/css' media='all' /> <link rel='stylesheet' id='jetpack_social_media_icons_widget-css' href='https://blog.sparna.fr/wp-content/plugins/jetpack/modules/widgets/social-media-icons/style.css?ver=20150602' type='text/css' media='all' /> <link rel='stylesheet' id='genericons-css' href='https://blog.sparna.fr/wp-content/plugins/jetpack/_inc/genericons/genericons/genericons.css?ver=3.1' type='text/css' media='all' /> <link rel='stylesheet' id='jetpack_css-css' href='https://blog.sparna.fr/wp-content/plugins/jetpack/css/jetpack.css?ver=3.6.4' type='text/css' media='all' /> <script type='text/javascript' src='https://blog.sparna.fr/wp-includes/js/jquery/jquery.js?ver=1.11.2'></script> <script type='text/javascript' src='https://blog.sparna.fr/wp-includes/js/jquery/jquery-migrate.min.js?ver=1.2.1'></script> <link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://blog.sparna.fr/xmlrpc.php?rsd" /> <link rel="wlwmanifest" type="application/wlwmanifest+xml" href="https://blog.sparna.fr/wp-includes/wlwmanifest.xml" /> <link rel='shortlink' href='https://wp.me/p55RD1-q3' /> <style type='text/css'>img#wpstats{display:none}</style><!-- Theme Customizer Styling Options --> <style type="text/css"> #header-wrap{ padding-top:0 !important; }#header-wrap{ padding-bottom:0 !important; }.author-badge{ color:#ffffff !important; } </style><style type="text/css" id="custom-background-css"> body.custom-background { background-color: #f9f9f9; } </style> <style id="custom-css-css">body{font-size:16px}</style> </head> <body class="single single-post postid-1615 single-format-standard custom-background symple-shortcodes symple-shortcodes-responsive wpex-theme responsive default-skin right-sidebar entry-columns-3 with-sidebar"> <div id="wrap" class="clr"> <div id="header-wrap" class="clr"> <header id="header" class="site-header clr container" role="banner"> <div class="site-branding clr"> <div id="logo" class="clr"> <a href="https://blog.sparna.fr" title="Sparna Blog" rel="home"><img src="http://blog.sparna.fr/wp-content/uploads/2015/04/header2.jpg" alt="Sparna Blog" /></a> </div><!-- #logo --> <div id="blog-description" class="clr"> Web de données | Architecture de l'information | Accès aux connaissances </div><!-- #blog-description --> </div><!-- .site-branding --> <div class="site-social clr"><a href="https://fr.linkedin.com/in/thomasfrancart" title="LinkedIn" target="_blank"><i class="fa fa-linkedin"></i></a><a href="http://blog.sparna.fr/feed" title="RSS" target="_blank"><i class="fa fa-rss"></i></a></div> </header><!-- #header --> </div><!-- #header-wrap --> <div id="site-navigation-wrap" class="clr "> <div id="site-navigation-inner" class="clr"> <nav id="site-navigation" class="navigation main-navigation clr container" role="navigation"> <a href="#mobile-nav" class="navigation-toggle"><span class="fa fa-bars navigation-toggle-icon"></span><span class="navigation-toggle-text">Click here to navigate</span></a> <div class="menu-menu-container"><ul id="menu-menu" class="main-nav dropdown-menu sf-menu"><li id="menu-item-1009" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1009"><a href="http://blog.sparna.fr">Accueil</a></li> <li id="menu-item-1008" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children dropdown menu-item-1008"><a href="#">Thèmes</a> <ul class="sub-menu"> <li id="menu-item-1002" class="menu-item menu-item-type-taxonomy menu-item-object-category current-post-ancestor current-menu-parent current-post-parent menu-item-1002"><a href="https://blog.sparna.fr/category/theme/linked-data/">Linked Data</a></li> <li id="menu-item-1004" class="menu-item menu-item-type-taxonomy menu-item-object-category current-post-ancestor current-menu-parent current-post-parent menu-item-1004"><a href="https://blog.sparna.fr/category/theme/opendata/">Open Data</a></li> <li id="menu-item-1003" class="menu-item menu-item-type-taxonomy menu-item-object-category current-post-ancestor current-menu-parent current-post-parent menu-item-1003"><a href="https://blog.sparna.fr/category/theme/ontologies-theme/">Ontologies</a></li> <li id="menu-item-1005" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1005"><a href="https://blog.sparna.fr/category/theme/recherche-informations/">Recherche d’informations</a></li> <li id="menu-item-1006" class="menu-item menu-item-type-taxonomy menu-item-object-category current-post-ancestor current-menu-parent current-post-parent menu-item-1006"><a href="https://blog.sparna.fr/category/theme/thesaurus-theme/">Thesaurus</a></li> <li id="menu-item-1007" class="menu-item menu-item-type-taxonomy menu-item-object-category current-post-ancestor current-menu-parent current-post-parent menu-item-1007"><a href="https://blog.sparna.fr/category/theme/visualisation-de-donnees/">Visualisation de données</a></li> </ul> </li> <li id="menu-item-1019" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children dropdown menu-item-1019"><a href="#">Outils</a> <ul class="sub-menu"> <li id="menu-item-1013" class="menu-item menu-item-type-taxonomy menu-item-object-category current-post-ancestor current-menu-parent current-post-parent menu-item-1013"><a href="https://blog.sparna.fr/category/outils/triplestores/">Triplestores</a></li> <li id="menu-item-1010" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1010"><a href="https://blog.sparna.fr/category/outils/editeurs/">Editeurs</a></li> <li id="menu-item-1011" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1011"><a href="https://blog.sparna.fr/category/outils/moteurs-de-recherche/">Moteurs de recherche</a></li> <li id="menu-item-1012" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1012"><a href="https://blog.sparna.fr/category/outils/skos-play-outils/">SKOS Play</a></li> </ul> </li> <li id="menu-item-1020" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children dropdown menu-item-1020"><a href="#">Technologies</a> <ul class="sub-menu"> <li id="menu-item-1015" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1015"><a href="https://blog.sparna.fr/category/technologie/rdf/">RDF</a></li> <li id="menu-item-1018" class="menu-item menu-item-type-taxonomy menu-item-object-category current-post-ancestor current-menu-parent current-post-parent menu-item-1018"><a href="https://blog.sparna.fr/category/technologie/sparql-technologies/">SPARQL</a></li> <li id="menu-item-1014" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1014"><a href="https://blog.sparna.fr/category/technologie/owl/">OWL</a></li> <li id="menu-item-1017" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1017"><a href="https://blog.sparna.fr/category/technologie/skos-technologies/">SKOS</a></li> <li id="menu-item-1016" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1016"><a href="https://blog.sparna.fr/category/technologie/schema-org-technologies/">Schema.org</a></li> </ul> </li> <li id="menu-item-1024" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children dropdown menu-item-1024"><a href="#">Autres</a> <ul class="sub-menu"> <li id="menu-item-1023" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1023"><a href="https://blog.sparna.fr/category/projets/">Projets</a></li> <li id="menu-item-1022" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1022"><a href="https://blog.sparna.fr/category/evenements/">Evénements</a></li> <li id="menu-item-1021" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1021"><a href="https://blog.sparna.fr/category/et/">Et…</a></li> </ul> </li> <li id="menu-item-1025" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1025"><a href="http://sparna.fr">sparna.fr</a></li> </ul></div> <a href="#" class="header-search-icon" title="Search"> <span class="fa fa-search"></span> </a><!-- .header-search-icon --> </nav><!-- #site-navigation --> </div><!-- #site-navigation-inner --> </div><!-- #site-navigation-wrap --> <div class="site-main-wrap clr"> <div id="main" class="site-main clr container"> <div class="search-overlay clr"> <form method="get" id="searchform" class="overlay-searchform" action="https://blog.sparna.fr/" role="search"> <input type="search" class="field" name="s" id="s" value="To search type and hit enter" onfocus="if(this.value==this.defaultValue)this.value='';" onblur="if(this.value=='')this.value=this.defaultValue;" autocomplete="off" /> </form> </div><!-- .search-overlay --> <div id="primary" class="content-area clr"> <div id="content" class="site-content left-content boxed-content clr" role="main"> <article class="single-post-article clr"> <div class="single-post-media clr"> <div class="post-thumbnail"> <img src="https://blog.sparna.fr/wp-content/uploads/2024/01/person-holding-bengal-light-hand_23-2147955677-650x450.jpg" alt="CORDIS : a SPARQL endpoint is born !" width="650" height="450" /> </div><!-- .post-thumbnail --> </div><!-- .single-post-media --> <header class="post-header clr"> <div class="post-meta clr"> <div class="post-meta-date"> <span class="fa fa-clock-o"></span>15 janvier 2024 </div> <div class="post-meta-author"> <span class="fa fa-user"></span><a href="https://blog.sparna.fr/author/marie/" title="Articles par Marie Muller" rel="author">Marie Muller</a> </div> <div class="post-meta-category"> <span class="fa fa-folder"></span><a href="https://blog.sparna.fr/category/theme/linked-data/">Linked Data</a>, <a href="https://blog.sparna.fr/category/theme/ontologies-theme/">Ontologies</a>, <a href="https://blog.sparna.fr/category/theme/opendata/">Open Data</a>, <a href="https://blog.sparna.fr/category/technologie/sparql-technologies/">SPARQL</a>, <a href="https://blog.sparna.fr/category/theme/thesaurus-theme/">Thesaurus</a>, <a href="https://blog.sparna.fr/category/outils/triplestores/">Triplestores</a>, <a href="https://blog.sparna.fr/category/theme/visualisation-de-donnees/">Visualisation de données</a> </div> <div class="post-meta-comments"> <span class="fa fa-comments"></span><a href="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/#comments">2 commentaires <span class="screen-reader-text"> sur CORDIS : a SPARQL endpoint is born !</span></a> </div> </div><!-- .post-meta --> <h1 class="post-header-title">CORDIS : a SPARQL endpoint is born !</h1> </header><!-- .page-header --> <div class="entry clr"> <p><span style="font-weight: 400;">Another star to light on EU’s linked open data maturity flag ! 🌟</span></p> <p><span style="font-weight: 400;">Not talking about 2024 exceptional <a href="https://www.nationalgeographic.com/science/article/auroras-solar-maximum-2024">Northern Lights to come,</a> </span><span style="font-weight: 400;">but this one’s also good news for science !</span></p> <p><span style="font-weight: 400;">➡️ Late 2023, </span><span style="font-weight: 400;">the Publications Office of the European Union</span><span style="font-weight: 400;"> <a href="https://twitter.com/CORDIS_EU/status/1726865540143276079">announced on social media</a> </span><span style="font-weight: 400;">the public release of </span><strong><a href="https://cordis.europa.eu/datalab/sparql-endpoint">the new CORDIS SPARQL endpoint</a></strong><span style="font-weight: 400;">.</span></p> <p><span style="font-weight: 400;">CORDIS, aka « </span><span style="font-weight: 400;">t</span><span style="font-weight: 400;">he Community Research and Development Information Service </span><span style="font-weight: 400;">of</span><span style="font-weight: 400;"> the European Commission</span><span style="font-weight: 400;"> », is « </span><em><a href="https://cordis.europa.eu/about"><span style="font-weight: 400;">the […] primary source of results from the projects funded by the EU’s framework programmes for research and innovation, from FP1 to Horizon Europe</span></a></em><span style="font-weight: 400;"> ». Described as a « <em>rich and structured public repository with all project information held by the European Commission such as project factsheets, participants, reports, deliverables and links to open-access publications</em> », the CORDIS catalog has also been made available in 6 European languages by Publications Office’s editorial team.</span></p> <p><span style="font-weight: 400;">Cherry on top 🍒 of a whole process, the CORDIS SPARQL endpoint release comes to crown a long-term linked open data project. The aim identifying, acquiring, preserving and providing access to knowledge in a common will to share with the widest public possible a trust-worthy, qualified and structured information (see </span><a href="https://op.europa.eu/webpub/op/annual-management-report-2021/en/"><span style="font-weight: 400;">Publications Office 2021 Annual Management Report</span></a><span style="font-weight: 400;">).</span></p> <p><span style="font-weight: 400;">In the context of the pandemic (and recent opening of <a href="https://data.europa.eu/en">data.europa.eu</a>, the official portal for European data, as defined in 2017–2025 European Open Data Space strategy), </span><a href="https://data.europa.eu/data/datasets/euroscivoc-the-european-science-vocabulary?locale=en"><span style="font-weight: 400;">the EuroSciVoc taxonomy of fields of science</span></a><span style="font-weight: 400;"> was released April 2020, followed December 2021 by the publishing of </span><a href="https://data.europa.eu/data/datasets/european-research-information-ontology?locale=en"><span style="font-weight: 400;">European research information ontology (EURIO)</span></a><span style="font-weight: 400;"> on the EU Vocabularies website 🌐.</span></p> <p><span style="font-weight: 400;">As presented at </span><a href="https://op.europa.eu/en/web/endorse-2021/conference"><span style="font-weight: 400;">ENDORSE conference March 2021</span></a><span style="font-weight: 400;">, the redesign of CORDIS data-model in accordance with Semantic Web standards contributed to bring the platform « <strong><em>from acting as a data repository to finally playing an active role as data provider</em></strong> », where EuroSciVoc taxonomy & EURIO ontology both played key roles in the creation of future CORDIS knowledge graph and SPARQL endpoint :</span></p> <p><span style="font-weight: 400;">🔸</span><em><span style="font-weight: 400;"> <a href="https://data.europa.eu/data/datasets/euroscivoc-the-european-science-vocabulary?locale=en">EuroSciVoc</a> […] is a multilingual, SKOS-XL based taxonomy that represents all the main fields of science that were discovered from the CORDIS content, e.g., project abstracts. It was built starting from the hierarchy of the OECD’s Fields of R&D classification (FoRD) as root and extended through a semi-automatic process based on NLP techniques. It contains almost 1 000 categories in 6 languages (English, French, German, Italian, Polish and Spanish) and each category is enriched with relevant keywords extracted from the textual description of CORDIS projects. It is constantly evolving and is available on EU Vocabularies website […].</span></em></p> <p><span style="font-weight: 400;">🔸</span><em><span style="font-weight: 400;"> In order to transform CORDIS data into Linked Open Data, thus aligning with Semantic Web standards, best practices and tools in industry and public organizations, the need for an ontology emerged. CORDIS created the <a href="https://data.europa.eu/data/datasets/european-research-information-ontology?locale=en">EURIO</a> (European Research Information Ontology) based on data about research projects funded by the EU’s framework programmes for research and innovation. EURIO is aligned with EU ontologies such as <a href="https://dcodings.github.io/DINGO/">DINGO</a> and <a href="https://github.com/SPAROntologies/frapo">FRAPO</a> and de facto standard ontologies such as schema.org and the Organization Ontology from W3C. It models projects, their results and actors such as people and organizations, and includes administrative information like funding schemes and grants.</span></em></p> <p><span style="font-weight: 400;">👉</span><em> EURIO, which is available on EU Vocabularies website, was <strong>the starting point to develop a Knowledge Graph of CORDIS data that will be publicly available via a dedicated SPARQL endpoint</strong>.</em> <em>»</em></p> <p>(Enrico Bignotti & Baya Remaoun, « <a href="https://op.europa.eu/en/web/endorse-2021/programme">EuroSciVoc taxonomy and EURIO ontology: CORDIS as (semantic) data provider</a> » , ENDORSE March 16, 2021. <a href="https://op.europa.eu/documents/10120270/10133951/BIGNOTTI_REMAOUN_presentation_EuroSciVoc+taxonomy+and+EURIO+ontology+CORDIS+as+%28semantic%29+data+provider.pdf/3303e7b9-967d-65f2-23a3-96b3e2bd2856?t=1616568751644"><span style="font-weight: 400;">PDF</span></a><span style="font-weight: 400;"> </span><a href="https://www.youtube.com/watch?v=vIBC_PO5aoM&t=3689s"><span style="font-weight: 400;">VIDEO</span></a>)</p> <p><span style="font-weight: 400;">… A Knowledge graph <a href="https://upcommons.upc.edu/bitstream/handle/2117/378291/2022-ISWC.pdf?sequence=1&isAllowed=y">that was soon released in 2022-2023</a></span><span style="font-weight: 400;"> (see INDUSTRY TRACK 1 on Tuesday, 25 October of <a href="http://iswc2022.semanticweb.org/index.php/conference/">ISWC 2022 Conference</a> for more detail), until final opening of a </span><a href="https://cordis.europa.eu/datalab"><span style="font-weight: 400;">CORDIS SPARQL endpoint</span></a><span style="font-weight: 400;"> late november 2023.</span></p> <p><span style="font-weight: 400;">Now fancy a few SPARQL queries in there ?</span></p> <p><strong>Follow the SPARQL 💫</strong></p> <p><span style="font-weight: 400;">CORDIS SPARQL endpoint is </span><a href="https://cordis.europa.eu/datalab"><span style="font-weight: 400;">actually made available on CORDIS Datalab</span></a><span style="font-weight: 400;"> (and already referenced in <a href="https://linkedopendata.eu/wiki/The_EU_Knowledge_Graph">EU Knowledge Graph</a> among other European SPARQL endpoints ! <a href="http://tinyurl.com/yn5fsylk">see the query</a> / <a href="http://tinyurl.com/2e8z6y5e">see the results</a>)</span></p> <p><span style="font-weight: 400;">Here you can access a quick documentation guide to CORDIS Linked Open Data : </span><a href="https://cordis.europa.eu/about/sparql"><span style="font-weight: 400;">https://cordis.europa.eu/about/sparql</span></a><span style="font-weight: 400;">.</span></p> <p><span style="font-weight: 400;">Let’s have a look at EURIO ontology first : we need to understand it to query CORDIS knowledge graph.</span></p> <p><span style="font-weight: 400;">As we are told in the guide, the latest version can be downloaded </span><a href="https://op.europa.eu/en/web/eu-vocabularies/dataset/-/resource?uri=http://publications.europa.eu/resource/dataset/eurio"><span style="font-weight: 400;">on EU Vocabularies website</span></a><span style="font-weight: 400;">. When we unzip</span><span style="font-weight: 400;"> the archive we access the whole documentation about EURIO Classes & properties that we need to write our SPARQL queries – and a diagram of </span><span style="font-weight: 400;">main classes and properties</span><span style="font-weight: 400;"> of CORDIS data model : </span></p> <p><a href="http://blog.sparna.fr/wp-content/uploads/2024/01/EURIO_v2.4.png"><img class="aligncenter size-large wp-image-1669" src="http://blog.sparna.fr/wp-content/uploads/2024/01/EURIO_v2.4-1024x812.png" alt="EURIO_v2.4" width="650" height="515" /></a></p> <p><span style="font-weight: 400;">At first sight we can observe on the schema 3 main groups of entities :</span></p> <ul> <li style="font-weight: 400;"><span style="font-weight: 400;">On the top right, the projects & publications associated, key ressources of CORDIS ;</span></li> <li style="font-weight: 400;"><span style="font-weight: 400;">On the top left, the fundings & grants materials, on « monetary » side of the project ;</span></li> <li style="font-weight: 400;"><span style="font-weight: 400;">On the bottom, the organisations & persons implied, with references & coordinates.</span></li> </ul> <p><span style="font-weight: 400;">Let’s open </span><a href="https://cordis.europa.eu/datalab/sparql-endpoint"><span style="font-weight: 400;">CORDIS SPARQL endpoint</span></a><span style="font-weight: 400;"> – some easy queries can be run to begin exploring CORDIS knowledge graph.</span></p> <p><span style="font-weight: 400;">Nb : the data on SPARQL endpoint is a snapshot, but freshest dumps can be found </span><a href="https://data.europa.eu/data/datasets/named-graphs-from-eurio-knowledge-graph?locale=en"><span style="font-weight: 400;">on European data portal</span></a><span style="font-weight: 400;"> !</span></p> <p><span style="font-weight: 400;">Here a simple one to </span><b>find a list of FundingSchemes with their titles and IDs corresponding to « Horizon 2020 » programme</b><span style="font-weight: 400;"> :</span></p> <table> <tbody> <tr> <td><strong>FundingSchemes with their titles and IDs corresponding to « Horizon 2020 » programme</strong></p> <p>PREFIX xsd: <http://www.w3.org/2001/XMLSchema#><br /> PREFIX eurio: <http://data.europa.eu/s66#><br /> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#><br /> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#><br /> SELECT ?fs ?title ?id<br /> WHERE {<br /> # select all funding schemes …<br /> ?fs a eurio:FundingScheme.<br /> # … with their title …<br /> ?fs eurio:title ?title.<br /> # … and identifier …<br /> ?fs eurio:identifier ?id.<br /> # where the identifier contains the regular expression “H2020”<br /> FILTER (REGEX (?id, ‘H2020′))<br /> } LIMIT 100</td> </tr> </tbody> </table> <p>▶️ <a href="https://cordis.europa.eu/datalab/sparql-endpoint#query=%23%20FundingSchemes%20with%20their%20titles%20and%20IDs%20corresponding%20to%20%C2%AB%20Horizon%202020%20%C2%BB%20programme%0A%0APREFIX%20xsd%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0APREFIX%20eurio%3A%20%3Chttp%3A%2F%2Fdata.europa.eu%2Fs66%23%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0ASELECT%20%3Ffs%20%3Ftitle%20%3Fid%0AWHERE%20%7B%0A%23%20select%20all%20funding%20schemes%20%E2%80%A6%0A%3Ffs%20a%20eurio%3AFundingScheme.%0A%23%20%E2%80%A6%20with%20their%20title%20%E2%80%A6%0A%3Ffs%20eurio%3Atitle%20%3Ftitle.%0A%23%20%E2%80%A6%20and%20identifier%20%E2%80%A6%0A%3Ffs%20eurio%3Aidentifier%20%3Fid.%0A%23%20where%20the%20identifier%20contains%20the%20regular%20expression%20%E2%80%9CH2020%E2%80%9D%0AFILTER%20(REGEX%20(%3Fid%2C%20'H2020'))%0A%7D%20LIMIT%20100&endpoint=https%3A%2F%2Fcordis.europa.eu%2Fdatalab%2Fsparql&requestMethod=POST&tabTitle=Query&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq&outputFormat=table">See the results</a></p> <p><span style="font-weight: 400;">The FILTER REGEX enables us to display the IDs corresponding to H2020 Funding Schemes.</span></p> <p><span style="font-weight: 400;">We can make another query to get the projects with the Funding Scheme Programme they are related to (note that, in EURIO a eurio:</span><span style="font-weight: 400;">hasFundingSchemeProgramme</span><span style="font-weight: 400;"> is a sub-property of eurio:fundingScheme) :</span></p> <table> <tbody> <tr> <td><strong>Projects with the Funding Scheme Programme they are related to</strong></p> <p><span style="font-weight: 400;">PREFIX eurio: <http://data.europa.eu/s66#></span><br /> <span style="font-weight: 400;">PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#></span><br /> <span style="font-weight: 400;">PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#></span><br /> <span style="font-weight: 400;">SELECT ?project ?acronym ?fundingscheme</span><br /> <span style="font-weight: 400;">WHERE {</span><br /> # select the projects …<br /> <span style="font-weight: 400;">?project a eurio:Project.</span><br /> # … with acronyms …<br /> <span style="font-weight: 400;">?project eurio:hasAcronym/eurio:shortForm ?acronym.</span><br /> # … and corresponding funding scheme programmes<br /> <span style="font-weight: 400;">?project eurio:isFundedBy/eurio:hasFundingSchemeProgramme/eurio:code ?fundingscheme.</span><br /> <span style="font-weight: 400;">} LIMIT 100</span></td> </tr> </tbody> </table> <p>▶️ <a href="https://cordis.europa.eu/datalab/sparql-endpoint#query=%23%20Projects%20with%20the%20Funding%20Scheme%20Programme%20they%20are%20related%20to%0A%0APREFIX%20eurio%3A%20%3Chttp%3A%2F%2Fdata.europa.eu%2Fs66%23%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0ASELECT%20%3Fproject%20%3Facronym%20%3Ffundingscheme%0AWHERE%20%7B%0A%23%20select%20the%20projects%20...%0A%3Fproject%20a%20eurio%3AProject.%0A%23%20%E2%80%A6%20with%20acronyms%20...%0A%3Fproject%20eurio%3AhasAcronym%2Feurio%3AshortForm%20%3Facronym.%0A%23%20%E2%80%A6%20and%20corresponding%20funding%20scheme%20programmes%0A%3Fproject%20eurio%3AisFundedBy%2Feurio%3AhasFundingSchemeProgramme%2Feurio%3Acode%20%3Ffundingscheme.%0A%7D%20LIMIT%20100&endpoint=https%3A%2F%2Fcordis.europa.eu%2Fdatalab%2Fsparql&requestMethod=POST&tabTitle=Query%201&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq&outputFormat=table">See the results</a></p> <p><span style="font-weight: 400;">(Here we used a property path with a « / » to shorten the query to get the acronyms of projects & Funding Scheme Programmes codes).</span></p> <p><span style="font-weight: 400;">… and combining with the first query we can find the projects depending on H2020 Funding Scheme Programme in particular :</span></p> <table> <tbody> <tr> <td><strong>Projects depending on H2020 Funding Scheme Programme in particular</strong></p> <p><span style="font-weight: 400;">PREFIX eurio: <http://data.europa.eu/s66#></span><br /> <span style="font-weight: 400;">PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#></span><br /> <span style="font-weight: 400;">PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#></span><br /> <span style="font-weight: 400;">SELECT ?project ?acronym ?fundingscheme</span><br /> <span style="font-weight: 400;">WHERE {</span><br /> # select the projects …<br /> <span style="font-weight: 400;">?project a eurio:Project.</span><br /> # … with acronyms …<br /> <span style="font-weight: 400;">?project eurio:hasAcronym/eurio:shortForm ?acronym.</span><br /> # … and corresponding funding scheme programmes codes …<br /> <span style="font-weight: 400;">?project eurio:isFundedBy/eurio:hasFundingSchemeProgramme/eurio:code ?fundingscheme.</span><br /> # … with a filter on funding scheme codes ‘H2020′<br /> <span style="font-weight: 400;">FILTER REGEX (?fundingscheme, ‘H2020′)</span><br /> <span style="font-weight: 400;">} LIMIT 100</span></td> </tr> </tbody> </table> <p>▶️ <a href="https://cordis.europa.eu/datalab/sparql-endpoint#query=%23%20Projects%20depending%20on%20H2020%20Funding%20Scheme%20Programme%20in%20particular%0A%0APREFIX%20eurio%3A%20%3Chttp%3A%2F%2Fdata.europa.eu%2Fs66%23%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0ASELECT%20%3Fproject%20%3Facronym%20%3Ffundingscheme%0AWHERE%20%7B%0A%23%20select%20the%20projects%20...%0A%3Fproject%20a%20eurio%3AProject.%0A%23%20%E2%80%A6%20with%20acronyms%20...%0A%3Fproject%20eurio%3AhasAcronym%2Feurio%3AshortForm%20%3Facronym.%0A%23%20%E2%80%A6%20and%20corresponding%20funding%20scheme%20programmes%20codes%20...%0A%3Fproject%20eurio%3AisFundedBy%2Feurio%3AhasFundingSchemeProgramme%2Feurio%3Acode%20%3Ffundingscheme.%0A%23%20%E2%80%A6%20with%20a%20filter%20on%20funding%20scheme%20codes%20'H2020'%0AFILTER%20REGEX%20(%3Ffundingscheme%2C%20'H2020')%0A%7D%20LIMIT%20100&endpoint=https%3A%2F%2Fcordis.europa.eu%2Fdatalab%2Fsparql&requestMethod=POST&tabTitle=Query&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq&outputFormat=table">See the results</a></p> <p><span style="font-weight: 400;">It is also possible to get the list of all existing Funding Scheme Programmes CORDIS projects have been funded by – we observe 27 of them here (from the SPARQL endpoint) – while adding a count function to know how many projects per FundingSchemeProgramme :</span></p> <table> <tbody> <tr> <td><strong>All existing Funding Scheme Programmes CORDIS projects have been funded by</strong></p> <p><span style="font-weight: 400;">PREFIX eurio: <http://data.europa.eu/s66#></span><br /> <span style="font-weight: 400;">PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#></span><br /> <span style="font-weight: 400;">PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#></span><br /> # count the number of projects by funding scheme programme …<br /> <span style="font-weight: 400;">SELECT (COUNT (?project) as ?count) ?fundingscheme</span><br /> <span style="font-weight: 400;">WHERE {</span><br /> # select the projects with corresponding funding scheme programmes codes …<br /> <span style="font-weight: 400;">?project eurio:isFundedBy/eurio:hasFundingSchemeProgramme/eurio:code ?fundingscheme.</span><br /> # … counting projects per funding scheme programme<br /> <span style="font-weight: 400;">} GROUP BY ?fundingscheme</span><br /> <span style="font-weight: 400;">LIMIT 100</span></td> </tr> </tbody> </table> <p>▶️ <a href="https://cordis.europa.eu/datalab/sparql-endpoint#query=%23%20All%20existing%20Funding%20Scheme%20Programmes%20CORDIS%20projects%20have%20been%20funded%20by%0A%0APREFIX%20eurio%3A%20%3Chttp%3A%2F%2Fdata.europa.eu%2Fs66%23%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0A%23%20count%20the%20number%20of%20projects%20by%20funding%20scheme%20programme%20...%0ASELECT%20(COUNT%20(%3Fproject)%20as%20%3Fcount)%20%3Ffundingscheme%0AWHERE%20%7B%0A%23%20select%20the%20projects%20with%20corresponding%20funding%20scheme%20programmes%20codes%20...%0A%3Fproject%20eurio%3AisFundedBy%2Feurio%3AhasFundingSchemeProgramme%2Feurio%3Acode%20%3Ffundingscheme.%0A%23%20...%20counting%20projects%20per%20funding%20scheme%20programme%0A%7D%20GROUP%20BY%20%3Ffundingscheme%0ALIMIT%20100&endpoint=https%3A%2F%2Fcordis.europa.eu%2Fdatalab%2Fsparql&requestMethod=POST&tabTitle=Query%201&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq&outputFormat=table">See the results</a></p> <p>Querying the organisations properties will return other kind of useful informations about geographical location of the projects stakeholders. Let’s figure out we want to find the projects whose coordinating organisations have sites located in France :</p> <table> <tbody> <tr> <td><strong>Projects whose coordinating organisations have sites located in France 🐓</strong></p> <p>PREFIX skos: <http://www.w3.org/2004/02/skos/core#><br /> PREFIX eurio: <http://data.europa.eu/s66#><br /> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#><br /> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#><br /> SELECT ?project ?acronym ?role ?organisation ?country<br /> WHERE {<br /> # select the projects with their acronyms …<br /> ?project a eurio:Project.<br /> ?project eurio:hasAcronym/eurio:shortForm ?acronym.<br /> # … and organisations with ‘coordinator’ role and name …<br /> ?project eurio:hasInvolvedParty ?organisationrole.<br /> ?organisationrole eurio:roleLabel ?role.<br /> ?organisationrole eurio:roleLabel « coordinator ».<br /> ?organisationrole eurio:isRoleOf/eurio:legalName ?organisation.<br /> # … with address country for the sites defined at ‘FR’<br /> ?organisationrole eurio:isRoleOf/eurio:hasSite/eurio:hasAddress/eurio:addressCountry ?country.<br /> VALUES ?country { ‘FR’ }<br /> } LIMIT 100</td> </tr> </tbody> </table> <p>▶️ <a href="https://cordis.europa.eu/datalab/sparql-endpoint#query=%23%20Projects%20whose%20coordinating%20organisations%20have%20sites%20located%20in%20France%20%F0%9F%90%93%0A%0APREFIX%20skos%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0APREFIX%20eurio%3A%20%3Chttp%3A%2F%2Fdata.europa.eu%2Fs66%23%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0ASELECT%20%3Fproject%20%3Facronym%20%3Frole%20%3Forganisation%20%3Fcountry%0AWHERE%20%7B%0A%23%20select%20the%20projects%20with%20their%20acronyms%20...%0A%3Fproject%20a%20eurio%3AProject.%0A%3Fproject%20eurio%3AhasAcronym%2Feurio%3AshortForm%20%3Facronym.%0A%23%20...%20and%20organisations%20with%20'coordinator'%20role%20and%20name%20...%0A%3Fproject%20eurio%3AhasInvolvedParty%20%3Forganisationrole.%0A%3Forganisationrole%20eurio%3AroleLabel%20%3Frole.%0A%3Forganisationrole%20eurio%3AroleLabel%20%22coordinator%22.%0A%3Forganisationrole%20eurio%3AisRoleOf%2Feurio%3AlegalName%20%3Forganisation.%0A%23%20...%20with%20address%20country%20for%20the%20sites%20defined%20at%20'FR'%0A%3Forganisationrole%20eurio%3AisRoleOf%2Feurio%3AhasSite%2Feurio%3AhasAddress%2Feurio%3AaddressCountry%20%3Fcountry.%0AVALUES%20%3Fcountry%20%7B%20'FR'%20%7D%0A%7D%20LIMIT%20100&endpoint=https%3A%2F%2Fcordis.europa.eu%2Fdatalab%2Fsparql&requestMethod=POST&tabTitle=Query&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq&outputFormat=table">See the results</a></p> <p>Depending on available data, you can either query via PostalAddress info (eurio:addressCountry ‘FR’) or AdministrativeArea (eurio:hasGeographicalLocation) … Here we’re lucky as both fields are mandatory ones.</p> <p>Last but not least, we can also play with CORDIS vocabularies : here you’ll have the choice to investigate via plain keywords of Projects or Publications items, querying titles, abstracts or other types of literals…</p> <p>An example of projects with abstracts containing string ❄ ‘winter’ ❄ – the URL giving the exact link to the project online :</p> <table> <tbody> <tr> <td><strong>Looking for ❄ ‘winter’ ❄ in CORDIS projects abstracts (with nice URL to go)</strong></p> <p>PREFIX eurio: <http://data.europa.eu/s66#><br /> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#><br /> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#><br /> SELECT?project ?acronym ?abstract ?url<br /> WHERE {<br /> # select the projects with their acronyms and abstracts …<br /> ?project rdf:type eurio:Project.<br /> ?project eurio:hasAcronym/eurio:shortForm ?acronym.<br /> ?project eurio:abstract ?abstract.<br /> # … with a filter on abstracts containing string ‘winter’ case insensitive …<br /> FILTER (regex(str(?abstract), ‘winter’, ‘i’))<br /> # … generating proper CORDIS website URLs based on RCN project code<br /> ?project eurio:rcn ?rcn.<br /> BIND(IRI(CONCAT(‘https://cordis.europa.eu/project/rcn/’, ?rcn)) AS ?url)<br /> } LIMIT 100</td> </tr> </tbody> </table> <p>▶️ <a href="https://cordis.europa.eu/datalab/sparql-endpoint#query=%23%20Looking%20for%20%E2%9D%84%20'winter'%20%E2%9D%84%20in%20CORDIS%20projects%20abstracts%20(with%20nice%20URL%20to%20go)%0A%0APREFIX%20eurio%3A%20%3Chttp%3A%2F%2Fdata.europa.eu%2Fs66%23%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0ASELECT%3Fproject%20%3Facronym%20%3Fabstract%20%3Furl%0AWHERE%20%7B%0A%23%20select%20the%20projects%20with%20their%20acronyms%20and%20abstracts%20...%0A%3Fproject%20rdf%3Atype%20eurio%3AProject.%0A%3Fproject%20eurio%3AhasAcronym%2Feurio%3AshortForm%20%3Facronym.%0A%3Fproject%20eurio%3Aabstract%20%3Fabstract.%0A%23%20...%20with%20a%20filter%20on%20abstracts%20containing%20string%20'winter'%20case%20insensitive%20...%0AFILTER%20(regex(str(%3Fabstract)%2C%20'winter'%2C%20'i'))%0A%23%20...%20generating%20proper%20CORDIS%20website%20URLs%20based%20on%20RCN%20project%20code%0A%3Fproject%20eurio%3Arcn%20%3Frcn.%0ABIND(IRI(CONCAT('https%3A%2F%2Fcordis.europa.eu%2Fproject%2Frcn%2F'%2C%20%3Frcn))%20AS%20%3Furl)%0A%7D%20LIMIT%20100&endpoint=https%3A%2F%2Fcordis.europa.eu%2Fdatalab%2Fsparql&requestMethod=POST&tabTitle=Query%201&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq&outputFormat=table">See the results</a></p> <p>But funniest way will be using EuroSciVoc taxonomy (and navigating through thesaurus hierarchy) : to do so we need to navigate through property « eurio:hasEuroSciVocClassification » to get the Concepts skosxl:prefLabel property … to finally obtain the thesaurus labels (don’t forget to choose a prefered language with a FILTER (lang parameter) :</p> <table> <tbody> <tr> <td><strong>Projects with their associated EuroSciVoc keywords (English prefLabels 💂)</strong></p> <p>PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#><br /> PREFIX skos: <http://www.w3.org/2004/02/skos/core#><br /> PREFIX eurio: <http://data.europa.eu/s66#><br /> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#><br /> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#><br /> SELECT ?project ?acronym ?ESV<br /> WHERE {<br /> # select the projects with their acronyms …<br /> ?project eurio:hasAcronym/eurio:shortForm ?acronym.<br /> # … with EuroSciVoc Classification prefLabels …<br /> ?project eurio:hasEuroSciVocClassification/skosxl:prefLabel/skosxl:literalForm ?ESV.<br /> # … only returning ‘English’ prefLabels<br /> FILTER (lang(?ESV) = ‘en’)<br /> } LIMIT 100</td> </tr> </tbody> </table> <p>▶️ <a href="https://cordis.europa.eu/datalab/sparql-endpoint#query=%23%20Projects%20with%20their%20associated%20EuroSciVoc%20keywords%20(English%20prefLabels%20%F0%9F%92%82)%0A%0APREFIX%20skosxl%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0APREFIX%20skos%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0APREFIX%20eurio%3A%20%3Chttp%3A%2F%2Fdata.europa.eu%2Fs66%23%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0ASELECT%20%3Fproject%20%3Facronym%20%3FESV%0AWHERE%20%7B%0A%23%20select%20the%20projects%20with%20their%20acronyms%20...%0A%3Fproject%20eurio%3AhasAcronym%2Feurio%3AshortForm%20%3Facronym.%0A%23%20...%20with%20EuroSciVoc%20Classification%20prefLabels%20...%0A%3Fproject%20eurio%3AhasEuroSciVocClassification%2Fskosxl%3AprefLabel%2Fskosxl%3AliteralForm%20%3FESV.%0A%23%20...%20only%20returning%20'English'%20prefLabels%0AFILTER%20(lang(%3FESV)%20%3D%20'en')%0A%7D%20LIMIT%20100%0A&endpoint=https%3A%2F%2Fcordis.europa.eu%2Fdatalab%2Fsparql&requestMethod=POST&tabTitle=Query%203&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq&outputFormat=table">See the results</a></p> <p><span style="font-weight: 400;">A bit more complex one using first level of hierarchy of the taxonomy : here we are searching for all skos:broader concepts « with no other broader concept » (the FILTER NOT EXISTS formula), aka the top concepts or root concepts of the vocabulary used to describe the projects. Then counting the projects by each category :</span></p> <table> <tbody> <tr> <td><strong>All root categories of EuroSciVoc used to describe the projects</strong></p> <p>PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#><br /> PREFIX skos: <http://www.w3.org/2004/02/skos/core#><br /> PREFIX eurio: <http://data.europa.eu/s66#><br /> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#><br /> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#><br /> # count the number of projects by EuroSciVoc top categories …<br /> SELECT (COUNT(?project) AS ?nbProject) ?ESV_root_label<br /> WHERE {<br /> # … the top categories are Concepts …<br /> ?ESV_root a skos:Concept .<br /> # … with no broader Concept …<br /> FILTER NOT EXISTS { ?ESV_root skos:broader ?anything }<br /> # … list with corresponding projects …<br /> ?ESV_root ^skos:broader*/^eurio:hasEuroSciVocClassification ?project .<br /> # … and EuroSciVoc corresponding skos-xl prefLabels …<br /> ?ESV_root skosxl:prefLabel/skosxl:literalForm ?ESV_root_label.<br /> # … sorting by EuroSciVoc category, with English prefLabels<br /> FILTER (lang(?ESV_root_label) = ‘en’)<br /> } GROUP BY ?ESV_root_label<br /> LIMIT 100</td> </tr> </tbody> </table> <p>▶️ <a href="https://cordis.europa.eu/datalab/sparql-endpoint#query=%23%20All%20root%20categories%20of%20EuroSciVoc%20used%20to%20describe%20the%20projects%0A%0APREFIX%20skosxl%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0APREFIX%20skos%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0APREFIX%20eurio%3A%20%3Chttp%3A%2F%2Fdata.europa.eu%2Fs66%23%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0A%23%20count%20the%20number%20of%20projects%20by%20EuroSciVoc%20top%20categories%20...%0ASELECT%20(COUNT(%3Fproject)%20AS%20%3FnbProject)%20%3FESV_root_label%0AWHERE%20%7B%0A%23%20...%20the%20top%20categories%20are%20Concepts%20...%0A%3FESV_root%20a%20skos%3AConcept%20.%0A%23%20...%20with%20no%20broader%20Concept%20...%0AFILTER%20NOT%20EXISTS%20%7B%20%3FESV_root%20skos%3Abroader%20%3Fanything%20%7D%0A%23%20...%20list%20with%20corresponding%20projects%20...%0A%3FESV_root%20%5Eskos%3Abroader*%2F%5Eeurio%3AhasEuroSciVocClassification%20%3Fproject%20.%0A%23%20...%20and%20EuroSciVoc%20corresponding%20skos-xl%20prefLabels%20...%0A%3FESV_root%20skosxl%3AprefLabel%2Fskosxl%3AliteralForm%20%3FESV_root_label.%0A%23%20...%20sorting%20by%20EuroSciVoc%20category%2C%20with%20English%20prefLabels%0AFILTER%20(lang(%3FESV_root_label)%20%3D%20'en')%0A%7D%20GROUP%20BY%20%3FESV_root_label%0ALIMIT%20100&endpoint=https%3A%2F%2Fcordis.europa.eu%2Fdatalab%2Fsparql&requestMethod=POST&tabTitle=Query%201&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq&outputFormat=table">See the results</a></p> <p>… and maybe again more explicit results if refined to level 2 of hierarchy 👀 :</p> <table> <tbody> <tr> <td><strong>All ‘level 2′ root categories of EuroSciVoc used to describe the projects</strong></p> <p>PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#><br /> PREFIX skos: <http://www.w3.org/2004/02/skos/core#><br /> PREFIX eurio: <http://data.europa.eu/s66#><br /> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#><br /> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#><br /> # count the number of projects by EuroSciVoc level 2 top categories …<br /> SELECT (COUNT(?project) AS ?nbProject) ?ESV_root_label ?ESV_level2_label<br /> WHERE {<br /> # … the top categories are Concepts …<br /> ?ESV_root a skos:Concept .<br /> # … with no broader Concept …<br /> FILTER NOT EXISTS { ?ESV_root skos:broader ?anything }<br /> # … list level 2 category below level 1 with corresponding projects …<br /> ?ESV_root ^skos:broader ?ESV_level2 .<br /> ?ESV_level2 ^skos:broader*/^eurio:hasEuroSciVocClassification ?project .<br /> # … and EuroSciVoc corresponding skos-xl prefLabels …<br /> ?ESV_root skosxl:prefLabel/skosxl:literalForm ?ESV_root_label.<br /> ?ESV_level2 skosxl:prefLabel/skosxl:literalForm ?ESV_level2_label.<br /> # … sorting by EuroSciVoc category, with English prefLabels<br /> FILTER (lang(?ESV_root_label) = ‘en’)<br /> FILTER (lang(?ESV_level2_label) = ‘en’)<br /> } GROUP BY ?ESV_root_label ?ESV_level2_label<br /> ORDER BY ?ESV_root_label<br /> LIMIT 100</td> </tr> </tbody> </table> <p>▶️ <a href="https://cordis.europa.eu/datalab/sparql-endpoint#query=%23%20All%20'level%202'%20root%20categories%20of%20EuroSciVoc%20used%20to%20describe%20the%20projects%0A%0APREFIX%20skosxl%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0APREFIX%20skos%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0APREFIX%20eurio%3A%20%3Chttp%3A%2F%2Fdata.europa.eu%2Fs66%23%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0A%23%20count%20the%20number%20of%20projects%20by%20EuroSciVoc%20level%202%20top%20categories%20...%0ASELECT%20(COUNT(%3Fproject)%20AS%20%3FnbProject)%20%3FESV_root_label%20%3FESV_level2_label%0AWHERE%20%7B%0A%23%20...%20the%20top%20categories%20are%20Concepts%20...%0A%3FESV_root%20a%20skos%3AConcept%20.%0A%23%20...%20with%20no%20broader%20Concept%20...%0AFILTER%20NOT%20EXISTS%20%7B%20%3FESV_root%20skos%3Abroader%20%3Fanything%20%7D%0A%23%20...%20list%20level%202%20category%20below%20level%201%20with%20corresponding%20projects%20...%0A%3FESV_root%20%5Eskos%3Abroader%20%3FESV_level2%20.%0A%3FESV_level2%20%5Eskos%3Abroader*%2F%5Eeurio%3AhasEuroSciVocClassification%20%3Fproject%20.%0A%23%20...%20and%20EuroSciVoc%20corresponding%20skos-xl%20prefLabels%20...%0A%3FESV_root%20skosxl%3AprefLabel%2Fskosxl%3AliteralForm%20%3FESV_root_label.%0A%3FESV_level2%20skosxl%3AprefLabel%2Fskosxl%3AliteralForm%20%3FESV_level2_label.%0A%23%20...%20sorting%20by%20EuroSciVoc%20category%2C%20with%20English%20prefLabels%0AFILTER%20(lang(%3FESV_root_label)%20%3D%20'en')%0AFILTER%20(lang(%3FESV_level2_label)%20%3D%20'en')%0A%7D%20GROUP%20BY%20%3FESV_root_label%20%3FESV_level2_label%0AORDER%20BY%20%3FESV_root_label%0ALIMIT%20100&endpoint=https%3A%2F%2Fcordis.europa.eu%2Fdatalab%2Fsparql&requestMethod=POST&tabTitle=Query&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq&outputFormat=table">See the results</a></p> <p>And a little last one with a count, to enumerate most used EuroSciVoc Concepts for indexing projects :</p> <table> <tbody> <tr> <td><strong>Most used EuroSciVoc Concepts for indexing projects</strong></p> <p>PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#><br /> PREFIX skos: <http://www.w3.org/2004/02/skos/core#><br /> PREFIX eurio: <http://data.europa.eu/s66#><br /> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#><br /> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#><br /> # count the number of projects by EuroSciVoc Concept …<br /> SELECT (COUNT (?project) as ?count) ?ESV<br /> WHERE {<br /> # … select the projects with their acronyms …<br /> ?project eurio:hasAcronym/eurio:shortForm ?acronym.<br /> # … with EuroSciVoc Classification prefLabels …<br /> ?project eurio:hasEuroSciVocClassification/skosxl:prefLabel/skosxl:literalForm ?ESV.<br /> # … sorting by EuroSciVoc Concept, with English prefLabels<br /> FILTER (lang(?ESV) = ‘en’)<br /> } GROUP BY ?ESV<br /> ORDER BY DESC(?count)<br /> LIMIT 3000</td> </tr> </tbody> </table> <p>▶️ <a href="https://cordis.europa.eu/datalab/sparql-endpoint#query=%23%20Most%20used%20EuroSciVoc%20Concepts%20for%20indexing%20projects%0A%0APREFIX%20skosxl%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0APREFIX%20skos%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0APREFIX%20eurio%3A%20%3Chttp%3A%2F%2Fdata.europa.eu%2Fs66%23%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0A%23%20count%20the%20number%20of%20projects%20by%20EuroSciVoc%20Concept%20...%0ASELECT%20(COUNT%20(%3Fproject)%20as%20%3Fcount)%20%3FESV%0AWHERE%20%7B%0A%23%20%20...%20select%20the%20projects%20with%20their%20acronyms%20...%0A%3Fproject%20eurio%3AhasAcronym%2Feurio%3AshortForm%20%3Facronym.%0A%23%20...%20with%20EuroSciVoc%20Classification%20prefLabels%20...%0A%3Fproject%20eurio%3AhasEuroSciVocClassification%2Fskosxl%3AprefLabel%2Fskosxl%3AliteralForm%20%3FESV.%0A%23%20...%20sorting%20by%20EuroSciVoc%20Concept%2C%20with%20English%20prefLabels%0AFILTER%20(lang(%3FESV)%20%3D%20'en')%0A%7D%20GROUP%20BY%20%3FESV%0AORDER%20BY%20DESC(%3Fcount)%0ALIMIT%203000&endpoint=https%3A%2F%2Fcordis.europa.eu%2Fdatalab%2Fsparql&requestMethod=POST&tabTitle=Query%201&headers=%7B%7D&contentTypeConstruct=application%2Fn-triples%2C*%2F*%3Bq&contentTypeSelect=application%2Fsparql-results%2Bjson%2C*%2F*%3Bq&outputFormat=table">See the results</a></p> <p>💡This one an ideal one to generate a word cloud maybe ?</p> <p>What if we send the CSV data to <a href="https://wordart.com/create">some nice online word cloud generator</a> then ?</p> <p><a href="https://wordart.com/r8zsokkk7ghu/untitled"><img class="aligncenter size-full wp-image-1710" src="http://blog.sparna.fr/wp-content/uploads/2024/01/Cordis-Taxo-Cloud.png" alt="Cordis Taxo Cloud" width="660" height="757" /></a></p> <p>(OMG <a href="https://wordart.com/create">they also have a shooting star shape</a> 🌠 in there 🤩)</p> <p><strong>As a conclusion…</strong></p> <p><span style="font-weight: 400;">According to Science (CORDIS saying !), <a href="https://europa.eu/!vYVHXD">New Year’s resolutions appear difficult to be held</a></span><span style="font-weight: 400;">… because most of time too ambitious, restrictive or unprecisely formulated : indeed, « </span><span style="font-weight: 400;">the </span><a href="https://cordis.europa.eu/article/id/428767-trending-science-do-this-one-thing-to-keep-your-new-year-s-resolutions-research-says"><span style="font-weight: 400;">effectiveness of resolutions depends on how they are </span><b>framed</b></a><span style="font-weight: 400;">.</span><span style="font-weight: 400;"> »</span></p> <p><span style="font-weight: 400;">Horizon 2024, let’s suggest a(n RDF ?) well-framed one : may CORDIS SPARQL endpoint initiative be an example for other structures who want to share Linked Open Data !</span></p> <p><span style="font-weight: 400;"><strong>Wishing you Best Interoperability and a Very Merry ✨ Sparqling New Year !</strong> ✨</span></p> <div class="sharedaddy sd-sharing-enabled"><div class="robots-nocontent sd-block sd-social sd-social-icon sd-sharing"><h3 class="sd-title">Partager :</h3><div class="sd-content"><ul><li class="share-linkedin"><a rel="nofollow" data-shared="sharing-linkedin-1615" class="share-linkedin sd-button share-icon no-text" href="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/?share=linkedin" target="_blank" title="Cliquez pour partager sur LinkedIn"><span></span><span class="sharing-screen-reader-text">Cliquez pour partager sur LinkedIn(ouvre dans une nouvelle fenêtre)</span></a></li><li class="share-twitter"><a rel="nofollow" data-shared="sharing-twitter-1615" class="share-twitter sd-button share-icon no-text" href="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/?share=twitter" target="_blank" title="Partager sur Twitter"><span></span><span class="sharing-screen-reader-text">Partager sur Twitter(ouvre dans une nouvelle fenêtre)</span></a></li><li class="share-facebook"><a rel="nofollow" data-shared="sharing-facebook-1615" class="share-facebook sd-button share-icon no-text" href="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/?share=facebook" target="_blank" title="Partager sur Facebook"><span></span><span class="sharing-screen-reader-text">Partager sur Facebook(ouvre dans une nouvelle fenêtre)</span></a></li><li class="share-google-plus-1"><a rel="nofollow" data-shared="sharing-google-1615" class="share-google-plus-1 sd-button share-icon no-text" href="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/?share=google-plus-1" target="_blank" title="Cliquez pour partager sur Google+"><span></span><span class="sharing-screen-reader-text">Cliquez pour partager sur Google+(ouvre dans une nouvelle fenêtre)</span></a></li><li class="share-end"></li></ul></div></div></div> <div class="post-tags"><span class="strong">Post Tagged:</span> <a href="https://blog.sparna.fr/tag/endpoint/" rel="tag">endpoint</a>, <a href="https://blog.sparna.fr/tag/europe/" rel="tag">Europe</a>, <a href="https://blog.sparna.fr/tag/linked-data/" rel="tag">Linked Data</a>, <a href="https://blog.sparna.fr/tag/linked-open-data/" rel="tag">Linked Open Data</a>, <a href="https://blog.sparna.fr/tag/ontologie/" rel="tag">ontologie</a>, <a href="https://blog.sparna.fr/tag/ontologies/" rel="tag">ontologies</a>, <a href="https://blog.sparna.fr/tag/open-data-2/" rel="tag">Open Data</a>, <a href="https://blog.sparna.fr/tag/sparql/" rel="tag">SPARQL</a>, <a href="https://blog.sparna.fr/tag/thesaurus/" rel="tag">thesaurus</a></div> <div class="single-post-pagination clr"> <div class="post-next"><strong>Next Post:</strong> <a href="https://blog.sparna.fr/2023/03/13/2013-2023-tis-skosplays-birthday/" rel="prev">2013-2023 : ‘Tis SKOSPlay!’s Birthday !</a></div> <div class="post-prev"><strong>Previous Post:</strong> <a href="https://blog.sparna.fr/2024/10/15/sparnatural-say-it-with-shacl/" rel="next">Sparnatural : say it with SHACL !</a></div> </div><!-- .post-post-pagination --> </div><!-- .entry --> </article> <section class="related-posts clr"> <div class="related-posts-title"><span class="fa fa-pencil"></span>Related Posts</div> <article class="related-entry"> <div class="related-entry-media clr"> <div class="related-entry-thumbnail"> <a href="https://blog.sparna.fr/2013/10/25/video-parodiquedbpedia-et-services-sparql/" title="Vidéo parodique sur la disponibilité de DBPedia – et les services SPARQL"> <img src="https://blog.sparna.fr/wp-content/uploads/2013/10/parody_martine_542571ff3925f-600x450.jpg" alt="Vidéo parodique sur la disponibilité de DBPedia – et les services SPARQL" width="600" height="450" /> <span class="overlay"></span> </a> </div><!-- .related-entry-thumbnail --> </div><!-- .related-entry-media --> <div class="related-entry-content clr"> <div class="related-entry-title"><a href="https://blog.sparna.fr/2013/10/25/video-parodiquedbpedia-et-services-sparql/" title="Vidéo parodique sur la disponibilité de DBPedia – et les services SPARQL">Vidéo parodique sur la disponibilité de DBPedia – et les services SPARQL</a></div> <div class="related-entry-excerpt entry clr"> Comment savoir si vous êtes un geek ? vous avez… </div><!-- .related-entry-excerpt --> </div><!-- .related-entry-content --> </article><!-- .related-entry --> <article class="related-entry"> <div class="related-entry-media clr"> <div class="related-entry-thumbnail"> <a href="https://blog.sparna.fr/2020/07/29/dessiner-ontologies-visualiser-graphes-outils/" title="Dessiner des ontologies, visualiser des graphes : quels outils ?"> <img src="https://blog.sparna.fr/wp-content/uploads/2020/07/reseau-semantique-sainte-trinite-650x450.png" alt="Dessiner des ontologies, visualiser des graphes : quels outils ?" width="650" height="450" /> <span class="overlay"></span> </a> </div><!-- .related-entry-thumbnail --> </div><!-- .related-entry-media --> <div class="related-entry-content clr"> <div class="related-entry-title"><a href="https://blog.sparna.fr/2020/07/29/dessiner-ontologies-visualiser-graphes-outils/" title="Dessiner des ontologies, visualiser des graphes : quels outils ?">Dessiner des ontologies, visualiser des graphes : quels outils ?</a></div> <div class="related-entry-excerpt entry clr"> Un récent fil de discussion sur la mailing-list public-lod demandait… </div><!-- .related-entry-excerpt --> </div><!-- .related-entry-content --> </article><!-- .related-entry --> <article class="related-entry"> <div class="related-entry-media clr"> <div class="related-entry-thumbnail"> <a href="https://blog.sparna.fr/2017/02/06/unesco-thesaurus-published-with-semantic-web-standards-and-open-source-software/" title="UNESCO Thesaurus published with Semantic Web standards and Open-Source software"> <img src="https://blog.sparna.fr/wp-content/uploads/2017/01/unesco_logo_en-650x450.jpg" alt="UNESCO Thesaurus published with Semantic Web standards and Open-Source software" width="650" height="450" /> <span class="overlay"></span> </a> </div><!-- .related-entry-thumbnail --> </div><!-- .related-entry-media --> <div class="related-entry-content clr"> <div class="related-entry-title"><a href="https://blog.sparna.fr/2017/02/06/unesco-thesaurus-published-with-semantic-web-standards-and-open-source-software/" title="UNESCO Thesaurus published with Semantic Web standards and Open-Source software">UNESCO Thesaurus published with Semantic Web standards and Open-Source software</a></div> <div class="related-entry-excerpt entry clr"> Sparna conducted in 2016 the replacement of the Thesaurus Management… </div><!-- .related-entry-excerpt --> </div><!-- .related-entry-content --> </article><!-- .related-entry --> </section> <div id="comments" class="comments-area clr"> <div class="comments-title"> <span class="fa fa-comments"></span> There are 2 comments for this article </div> <div class="comments-inner clr"> <ol class="commentlist"> <li id="li-comment-38752"> <article id="comment-38752" class="comment even thread-even depth-1 clr"> <div class="comment-author vcard"> <img alt='' src='https://0.gravatar.com/avatar/6afa55114fdbe78bfda430e3d3203e87?s=45&d=identicon&r=g' srcset='https://0.gravatar.com/avatar/6afa55114fdbe78bfda430e3d3203e87?s=90&d=identicon&r=g 2x' class='avatar avatar-45 photo' height='45' width='45' /> </div><!-- .comment-author --> <div class="comment-details clr"> <header class="comment-meta"> <cite class="fn"> Vladimir Alexiev </cite> <span class="comment-date"> <a href="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/#comment-38752"><time datetime="2024-01-15T17:25:24+00:00">15 janvier 2024</time></a> at 17 h 25 min </span><!-- .comment-date --> </header><!-- .comment-meta --> <div class="comment-content entry clr"> <p>These are some very nice queries!<br /> But I have some bugs to post to OPOCE regarding their RDF representation, do you know if they have a github project?</p> </div><!-- .comment-content --> <div class="reply comment-reply-link"> <a class='comment-reply-link' href='/2024/01/15/cordis-a-sparql-endpoint-is-born/?replytocom=38752#respond' onclick='return addComment.moveForm( "comment-38752", "38752", "respond", "1615" )' aria-label='Répondre à Vladimir Alexiev'>Reply to this message</a> </div><!-- .reply --> </div><!-- .comment-details --> </article><!-- #comment-## --> </li><!-- #comment-## --> <li id="li-comment-38753"> <article id="comment-38753" class="comment byuser comment-author-marie bypostauthor odd alt thread-odd thread-alt depth-1 clr"> <div class="comment-author vcard"> <img alt='' src='https://2.gravatar.com/avatar/8adc53424babfab9191c11759c20c30e?s=45&d=identicon&r=g' srcset='https://2.gravatar.com/avatar/8adc53424babfab9191c11759c20c30e?s=90&d=identicon&r=g 2x' class='avatar avatar-45 photo' height='45' width='45' /> </div><!-- .comment-author --> <div class="comment-details clr"> <header class="comment-meta"> <cite class="fn"> Marie Muller <span class="author-badge">Author</span> </cite> <span class="comment-date"> <a href="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/#comment-38753"><time datetime="2024-01-15T17:53:56+00:00">15 janvier 2024</time></a> at 17 h 53 min </span><!-- .comment-date --> </header><!-- .comment-meta --> <div class="comment-content entry clr"> <p>Thank you Vladimir for your comment !</p> <p>I’ve seen there is a contact address on CORDIS website, maybe you can start there ? It’s the same address as mentioned on EU Vocabularies website for CORDIS assets. Otherwise they seem pretty reactive via social media (try X : <a href="https://twitter.com/CORDIS_EU" rel="nofollow">https://twitter.com/CORDIS_EU</a> or Mastodon : <a href="https://mastodon.social/@CORDIS_EU@respublicae.eu" rel="nofollow">https://mastodon.social/@CORDIS_EU@respublicae.eu</a>).</p> <p>Anyway a good thing to suggest to the team <img src="https://blog.sparna.fr/wp-includes/images/smilies/simple-smile.png" alt=":)" class="wp-smiley" style="height: 1em; max-height: 1em;" /></p> </div><!-- .comment-content --> <div class="reply comment-reply-link"> <a class='comment-reply-link' href='/2024/01/15/cordis-a-sparql-endpoint-is-born/?replytocom=38753#respond' onclick='return addComment.moveForm( "comment-38753", "38753", "respond", "1615" )' aria-label='Répondre à Marie Muller'>Reply to this message</a> </div><!-- .reply --> </div><!-- .comment-details --> </article><!-- #comment-## --> </li><!-- #comment-## --> </ol><!-- .commentlist --> <div id="respond" class="comment-respond"> <h3 id="reply-title" class="comment-reply-title">Laisser un commentaire <small><a rel="nofollow" id="cancel-comment-reply-link" href="/2024/01/15/cordis-a-sparql-endpoint-is-born/#respond" style="display:none;"><i class="fa fa-times"></i>Cancel comment reply</a></small></h3> <form action="https://blog.sparna.fr/wp-comments-post.php" method="post" id="commentform" class="comment-form"> <p class="comment-notes"><span id="email-notes">Votre adresse de messagerie ne sera pas publiée.</span> Les champs obligatoires sont indiqués avec <span class="required">*</span></p> <div class="col span_1_of_3 col-1"><input id="author" name="author" type="text" placeholder="Name*" value="" size="30" aria-required='true' /></div> <div class="col span_1_of_3"><input id="email" name="email" type="text" placeholder="Email*" value="" size="30" aria-required='true' /></div> <div class="col span_1_of_3"><input id="url" name="url" type="text" placeholder="Website" value="" size="30" /></div> <p class="comment-form-comment"><label for="comment">Commentaire</label> <textarea id="comment" name="comment" cols="45" rows="8" aria-describedby="form-allowed-tags" aria-required="true" required="required"></textarea></p> <p class="form-allowed-tags" id="form-allowed-tags">Vous pouvez utiliser ces balises et attributs <abbr title="HyperText Markup Language">HTML</abbr> : <code><a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> </code></p> <p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="Laisser un commentaire" /> <input type='hidden' name='comment_post_ID' value='1615' id='comment_post_ID' /> <input type='hidden' name='comment_parent' id='comment_parent' value='0' /> </p><p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="04dce2f65c" /></p><p class="comment-subscription-form"><input type="checkbox" name="subscribe_comments" id="subscribe_comments" value="subscribe" style="width: auto; -moz-appearance: checkbox; -webkit-appearance: checkbox;" /> <label class="subscribe-label" id="subscribe-label" for="subscribe_comments">Prévenez-moi de tous les nouveaux commentaires par e-mail.</label></p><p class="comment-subscription-form"><input type="checkbox" name="subscribe_blog" id="subscribe_blog" value="subscribe" style="width: auto; -moz-appearance: checkbox; -webkit-appearance: checkbox;" /> <label class="subscribe-label" id="subscribe-blog-label" for="subscribe_blog">Prévenez-moi de tous les nouveaux articles par email.</label></p><p style="display: none;"><input type="hidden" id="ak_js" name="ak_js" value="128"/></p> </form> </div><!-- #respond --> </div><!-- .comments-inner --> </div><!-- #comments --> </div><!-- #content --> <aside id="secondary" class="sidebar-container" role="complementary"> <div class="sidebar-inner"> <div class="widget-area"> <div class="sidebar-widget widget_wpex_recent_posts_thumb clr"><span class="widget-title">Derniers articles</span> <ul class="wpex-widget-recent-posts clr"> <li class="clr wpex-widget-recent-posts-li left-thumbnail format- count-3" > <a href="https://blog.sparna.fr/2024/10/15/sparnatural-say-it-with-shacl/" title="Sparnatural : say it with SHACL !" class="wpex-widget-recent-posts-thumbnail clr"> <img src="https://blog.sparna.fr/wp-content/uploads/2024/10/navigate-55x55.png" alt="Sparnatural : say it with SHACL !" width="55" height="55" /> </a> <div class="clr"></div> <a href="https://blog.sparna.fr/2024/10/15/sparnatural-say-it-with-shacl/" title="Sparnatural : say it with SHACL !" class="wpex-widget-recent-posts-title">Sparnatural : say it with SHACL !</a> </li> <li class="clr wpex-widget-recent-posts-li left-thumbnail format- count-3" > <a href="https://blog.sparna.fr/2023/03/13/2013-2023-tis-skosplays-birthday/" title="2013-2023 : ‘Tis SKOSPlay!’s Birthday !" class="wpex-widget-recent-posts-thumbnail clr"> <img src="https://blog.sparna.fr/wp-content/uploads/2023/03/SKOSPlayBDay-55x55.jpg" alt="2013-2023 : ‘Tis SKOSPlay!’s Birthday !" width="55" height="55" /> </a> <div class="clr"></div> <a href="https://blog.sparna.fr/2023/03/13/2013-2023-tis-skosplays-birthday/" title="2013-2023 : ‘Tis SKOSPlay!’s Birthday !" class="wpex-widget-recent-posts-title">2013-2023 : ‘Tis SKOSPlay!’s Birthday !</a> </li> <li class="clr wpex-widget-recent-posts-li left-thumbnail format- count-3" > <a href="https://blog.sparna.fr/2022/10/31/sparnatural-a-semweb-pro-2022-le-8-novembre/" title="Sparnatural à SemWeb.pro 2022 le 8 novembre" class="wpex-widget-recent-posts-thumbnail clr"> <img src="https://blog.sparna.fr/wp-content/uploads/2022/10/anf-demo-B-55x55.png" alt="Sparnatural à SemWeb.pro 2022 le 8 novembre" width="55" height="55" /> </a> <div class="clr"></div> <a href="https://blog.sparna.fr/2022/10/31/sparnatural-a-semweb-pro-2022-le-8-novembre/" title="Sparnatural à SemWeb.pro 2022 le 8 novembre" class="wpex-widget-recent-posts-title">Sparnatural à SemWeb.pro 2022 le 8 novembre</a> </li> </ul> </div><div class="sidebar-widget widget_wpex_recent_comments_avatars_widget clr"><span class="widget-title">Derniers commentaires</span> <ul class="wpex-recent-comments-widget clr"> <li class="clr"> <a href="https://blog.sparna.fr/2013/12/07/ontologie-thesaurus-taxonomie-web-de-donnees/#comment-44170" title="CORDIS : a SPARQL endpoint is born !" class="clr"> <img alt='' src='https://1.gravatar.com/avatar/d34d02d390b703a3345c70b3d4d97910?s=55&d=identicon&r=g' srcset='https://1.gravatar.com/avatar/d34d02d390b703a3345c70b3d4d97910?s=110&d=identicon&r=g 2x' class='avatar avatar-55 photo' height='55' width='55' /> <span class="title strong">Nicolas:</span> bonjour Rachid, je vous invite à lire "La survie des…... </a> </li> <li class="clr"> <a href="https://blog.sparna.fr/2013/12/07/ontologie-thesaurus-taxonomie-web-de-donnees/#comment-44169" title="CORDIS : a SPARQL endpoint is born !" class="clr"> <img alt='' src='https://1.gravatar.com/avatar/d34d02d390b703a3345c70b3d4d97910?s=55&d=identicon&r=g' srcset='https://1.gravatar.com/avatar/d34d02d390b703a3345c70b3d4d97910?s=110&d=identicon&r=g 2x' class='avatar avatar-55 photo' height='55' width='55' /> <span class="title strong">Nicolas:</span> Votre article est éclairant. merci!! Mais encore... "La Taxonomie n'est…... </a> </li> <li class="clr"> <a href="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/#comment-38753" title="CORDIS : a SPARQL endpoint is born !" class="clr"> <img alt='' src='https://2.gravatar.com/avatar/8adc53424babfab9191c11759c20c30e?s=55&d=identicon&r=g' srcset='https://2.gravatar.com/avatar/8adc53424babfab9191c11759c20c30e?s=110&d=identicon&r=g 2x' class='avatar avatar-55 photo' height='55' width='55' /> <span class="title strong">Marie Muller:</span> Thank you Vladimir for your comment ! I've seen there…... </a> </li> </ul> </div><div class="sidebar-widget jetpack_subscription_widget clr"><span class="widget-title">Abonnez-vous à ce blog par e-mail.</span> <form action="#" method="post" accept-charset="utf-8" id="subscribe-blog-blog_subscription-2"> <div id="subscribe-text"><p>Saisissez votre adresse e-mail pour vous abonner à ce blog et recevoir une notification de chaque nouvel article par email.</p> </div> <p id="subscribe-email"> <label id="jetpack-subscribe-label" for="subscribe-field"> Adresse e-mail </label> <input type="email" name="email" required="required" class="required" value="" id="subscribe-field-blog_subscription-2" placeholder="Adresse e-mail" /> </p> <p id="subscribe-submit"> <input type="hidden" name="action" value="subscribe" /> <input type="hidden" name="source" value="https://blog.sparna.fr/2024/01/15/cordis-a-sparql-endpoint-is-born/" /> <input type="hidden" name="sub-type" value="widget" /> <input type="hidden" name="redirect_fragment" value="blog_subscription-2" /> <input type="submit" value="S'abonner" name="jetpack_subscriptions_widget" /> </p> </form> <script> /* Custom functionality for safari and IE */ (function( d ) { // Creates placeholders for IE if ( ( 'placeholder' in d.createElement( 'input' ) ) ) { var label = d.getElementById( 'jetpack-subscribe-label' ); label.style.clip = 'rect(1px, 1px, 1px, 1px)'; label.style.position = 'absolute'; label.style.height = '1px'; label.style.width = '1px'; label.style.overflow = 'hidden'; } // Make sure the email value is filled in before allowing submit var form = d.getElementById('subscribe-blog-blog_subscription-2'), input = d.getElementById('subscribe-field-blog_subscription-2'), handler = function( event ) { if ( '' === input.value ) { input.focus(); if ( event.preventDefault ){ event.preventDefault(); } return false; } }; if ( window.addEventListener ) { form.addEventListener( 'submit', handler, false ); } else { form.attachEvent( 'onsubmit', handler ); } })( document ); </script> </div><div class="sidebar-widget widget_wpcom_social_media_icons_widget clr"><ul><li><a title="Voir le profil de thomasfrancart sur LinkedIn" href="https://www.linkedin.com/in/thomasfrancart/" class="genericon genericon-linkedin-alt" target="_blank"><span class="screen-reader-text">Voir le profil de thomasfrancart sur LinkedIn</span></a></li><li><a title="Voir le profil de tfrancart sur GitHub" href="https://github.com/tfrancart/" class="genericon genericon-github" target="_blank"><span class="screen-reader-text">Voir le profil de tfrancart sur GitHub</span></a></li></ul></div> </div> </div> </aside><!-- #secondary --> </div><!-- #primary --> </div><!--.site-main --> </div><!-- .site-main-wrap --> </div><!-- #wrap --> <footer id="footer-wrap" class="site-footer clr"> <div id="footer-bottom" class="clr"> <div class="container clr"> <div id="copyright" class="clr" role="contentinfo"> Copyright 2014 Your Company LLC </div><!-- #copyright --> </div><!-- .container --> </div><!-- #footer-bottom --> </footer><!-- #footer-wrap --> <div style="display:none"> <div class="grofile-hash-map-6afa55114fdbe78bfda430e3d3203e87"> </div> <div class="grofile-hash-map-8adc53424babfab9191c11759c20c30e"> </div> <div class="grofile-hash-map-d34d02d390b703a3345c70b3d4d97910"> </div> <div class="grofile-hash-map-8adc53424babfab9191c11759c20c30e"> </div> </div> <div id="mobile-search"> <form method="get" action="https://blog.sparna.fr/" role="search" id="mobile-search-form"> <input type="search" class="field" name="s" value="" placeholder="To search type and hit enter" /> </form> </div> <a href="#" class="site-scroll-top"><span class="fa fa-arrow-up"></span></a> <script type="text/javascript"> window.WPCOM_sharing_counts = {"https:\/\/blog.sparna.fr\/2024\/01\/15\/cordis-a-sparql-endpoint-is-born\/":1615}; window.WPCOM_jetpack = true; window.WPCOM_site_ID = 75279471; </script> <script type="text/javascript"> var windowOpen; jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-linkedin' ).on( 'click', function() { if ( 'undefined' !== typeof windowOpen ){ // If there's another sharing window open, close it. windowOpen.close(); } windowOpen = window.open( jQuery(this).attr( 'href' ), 'wpcomlinkedin', 'menubar=1,resizable=1,width=580,height=450' ); return false; }); }); </script> <script type="text/javascript"> var windowOpen; jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-twitter' ).on( 'click', function() { if ( 'undefined' !== typeof windowOpen ){ // If there's another sharing window open, close it. windowOpen.close(); } windowOpen = window.open( jQuery(this).attr( 'href' ), 'wpcomtwitter', 'menubar=1,resizable=1,width=600,height=350' ); return false; }); }); </script> <script type="text/javascript"> var windowOpen; jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-facebook' ).on( 'click', function() { if ( 'undefined' !== typeof windowOpen ){ // If there's another sharing window open, close it. windowOpen.close(); } windowOpen = window.open( jQuery(this).attr( 'href' ), 'wpcomfacebook', 'menubar=1,resizable=1,width=600,height=400' ); return false; }); }); </script> <script type="text/javascript"> var windowOpen; jQuery(document).on( 'ready post-load', function(){ jQuery( 'a.share-google-plus-1' ).on( 'click', function() { if ( 'undefined' !== typeof windowOpen ){ // If there's another sharing window open, close it. windowOpen.close(); } windowOpen = window.open( jQuery(this).attr( 'href' ), 'wpcomgoogle-plus-1', 'menubar=1,resizable=1,width=480,height=550' ); return false; }); }); </script> <script type='text/javascript' src='https://blog.sparna.fr/wp-content/plugins/akismet/_inc/form.js?ver=3.1.5'></script> <script type='text/javascript' src='https://blog.sparna.fr/wp-content/plugins/contact-form-7/includes/js/jquery.form.min.js?ver=3.51.0-2014.06.20'></script> <script type='text/javascript'> /* <![CDATA[ */ var _wpcf7 = {"loaderUrl":"https:\/\/blog.sparna.fr\/wp-content\/plugins\/contact-form-7\/images\/ajax-loader.gif","sending":"Envoi en cours ..."}; /* ]]> */ </script> <script type='text/javascript' src='https://blog.sparna.fr/wp-content/plugins/contact-form-7/includes/js/scripts.js?ver=4.2.1'></script> <script type='text/javascript' src='https://s0.wp.com/wp-content/js/devicepx-jetpack.js?ver=202447'></script> <script type='text/javascript' src='https://secure.gravatar.com/js/gprofiles.js?ver=2024Novaa'></script> <script type='text/javascript'> /* <![CDATA[ */ var WPGroHo = {"my_hash":""}; /* ]]> */ </script> <script type='text/javascript' src='https://blog.sparna.fr/wp-content/plugins/jetpack/modules/wpgroho.js?ver=4.2.38'></script> <script type='text/javascript' src='https://blog.sparna.fr/wp-includes/js/comment-reply.min.js?ver=4.2.38'></script> <script type='text/javascript'> /* <![CDATA[ */ var wpexLocalize = {"mobileMenuOpen":"Click here to navigate","mobileMenuClosed":"Close navigation","flexSlideshow":"true","flexSlideshowSpeed":"7000"}; /* ]]> */ </script> <script type='text/javascript' src='https://blog.sparna.fr/wp-content/themes/wpex-luxmag/js/global-min.js?ver=1.0'></script> <script type='text/javascript'> /* <![CDATA[ */ var sharing_js_options = {"lang":"en","counts":"1"}; /* ]]> */ </script> <script type='text/javascript' src='https://blog.sparna.fr/wp-content/plugins/jetpack/modules/sharedaddy/sharing.js?ver=3.6.4'></script> <script type='text/javascript' src='https://stats.wp.com/e-202447.js' async defer></script> <script type='text/javascript'> _stq = window._stq || []; _stq.push([ 'view', {v:'ext',j:'1:3.6.4',blog:'75279471',post:'1615',tz:'1',srv:'blog.sparna.fr'} ]); _stq.push([ 'clickTrackerInit', '75279471', '1615' ]); </script> </body> </html>