Difference between revisions of "Truly Tabular RDF"

From BITPlan Wiki
Jump to navigation Jump to search
Line 4: Line 4:
 
# select further properties such as
 
# select further properties such as
 
## [https://www.wikidata.org/wiki/Property:P1813 P1813 short name]
 
## [https://www.wikidata.org/wiki/Property:P1813 P1813 short name]
 +
## [https://www.wikidata.org/wiki/Property:P17 P17 country]
 +
## [https://www.wikidata.org/wiki/Property:P1476 P1476 title]
  
 
=== Result of Step #2 ===
 
=== Result of Step #2 ===
Line 32: Line 34:
 
|-
 
|-
 
| ...
 
| ...
−
|}        
+
|}
 +
=== Result of Step 3 ===
 +
<source lang='SPARQL'>
 +
# Academic conference wikidata query
 +
# WF 2021-01-30
 +
PREFIX wd: <http://www.wikidata.org/entity/>
 +
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
 +
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 +
SELECT
 +
  ?conference ?conferenceLabel
 +
  ?short_name
 +
  ?country
 +
  ?title
 +
WHERE
 +
{
 +
  #  academic conference series (Q2020153)
 +
  ?conference wdt:P31 wd:Q2020153.
 +
  # label
 +
  ?conference rdfs:label ?conferenceLabel filter (lang(?conferenceLabel) = "en").
 +
  # short name
 +
  OPTIONAL { ?conference wdt:P1813 ?short_name }
 +
  # country
 +
  OPTIONAL { ?conference wdt:P17 ?country }
 +
  # title
 +
  OPTIONAL { ?conference wdt:P1476 ?title }
 +
}
 +
</source>
 +
 
 
= How tabular are the  Academic Conference entries in wikidata? =
 
= How tabular are the  Academic Conference entries in wikidata? =
 
{| class="wikitable" style="text-align: left;"
 
{| class="wikitable" style="text-align: left;"

Revision as of 11:43, 27 July 2022

Naive SPARQL Query

  1. Start with a wikidata item your are intested in e.g. International Semantic Web Conference 2022
  2. use the instance of property to find similar items of the same class academic conference
  3. select further properties such as
    1. P1813 short name
    2. P17 country
    3. P1476 title

Result of Step #2

# Academic conference wikidata query
# WF 2021-01-30
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?conference ?conferenceLabel 
WHERE
{
  #  academic conference series (Q2020153)
  ?conference wdt:P31 wd:Q2020153.
  # label
  ?conference rdfs:label ?conferenceLabel filter (lang(?conferenceLabel) = "en").
}

try it!

conference conferenceLabel
http://www.wikidata.org/entity/Q75698988 The 2013 Conference of the North American Chapter of the Association for Computational Linguistics: Human Language Technologies
http://www.wikidata.org/entity/Q75707991 Digital Humanities 2020
http://www.wikidata.org/entity/Q75709854 Digital Humanities 2018
...

Result of Step 3

# Academic conference wikidata query
# WF 2021-01-30
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT 
  ?conference ?conferenceLabel
  ?short_name
  ?country
  ?title
WHERE
{
  #  academic conference series (Q2020153)
  ?conference wdt:P31 wd:Q2020153.
  # label
  ?conference rdfs:label ?conferenceLabel filter (lang(?conferenceLabel) = "en").
  # short name
  OPTIONAL { ?conference wdt:P1813 ?short_name }
  # country
  OPTIONAL { ?conference wdt:P17 ?country }
  # title
  OPTIONAL { ?conference wdt:P1476 ?title }
}

How tabular are the Academic Conference entries in wikidata?

property total f1 total% non tabular non tabular% f2 f3 f14 f4 f7 f5 f9
∑ 7518
country 7077 7077 94.1 0 0
part of the series 7139 7120 95 19 0.3 15 4
VIAF ID 2096 2092 27.9 4 0.2 3 1
GND ID 3049 3043 40.6 6 0.2 4 2
location 7209 7180 95.9 29 0.4 24 4 1
start time 6916 6914 92 2 0 2
end time 6912 6909 91.9 3 0 3
official website 596 586 7.9 10 1.7 9 1
main subject 1882 1722 25 160 8.5 131 23 2 2 1 1
described at URL 6512 6510 86.6 2 0 1 1
title 6718 6700 89.4 18 0.3 10 8
short name 6750 6741 89.8 9 0.1 9
language used 87 84 1.2 3 3.4 3
is proceedings from 921 901 12.3 20 2.2 16 3 1
WikiCFP event ID 98 98 1.3 0 0
Retrieved from "https://wiki.bitplan.com/index.php?title=Truly_Tabular_RDF&oldid=15983"