On 10/11/16 2:48 PM, Thad Guidry wrote:
Kingsley,
You might ask others on the list who could help more with providing the WD - Schema.org mappings or get them into a format that you want...or an RDF dump file.
I just don't have the knowledge to assist you with that via SPARQL. (i.e., I am not a SPARQL guru)
-Thad
_______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Thad,
Having figured out how the Wikidata SPARQL endpoint works, here are the mappings between Wikidata and Schema.org using owl:equivalentClass and owl:equivalentProperty relations. Basically, I am using SPARQL-FED to produce the desired result using a variety of RDF related document types (JSON-LD. RDF-Turtle, HTML5+Microdata, and XHTML+RDFa).
We will load this into the DBpedia DBMS which will make this data available via SPARQL and relevant Linked Data pages, now that the new 2016-04 release is live [1].
##### Equivalent Property Relations Generation #####
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
CONSTRUCT {?s owl:equivalentProperty ?o}
WHERE { SERVICE <http://query.wikidata.org/sparql>
{
SELECT ?s ?equivalentProperty ?o
WHERE {
?s wdt:P1628 ?o .
BIND (wdt:P1628 as ?equivalentProperty)
FILTER( REGEX(STR(?o), "schema.org"))
}
}
}
Live Links:
[1] http://linkeddata.uriburner.com/sparql?default-graph-uri=&query=PREFIX+wdt%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E+%0D%0A%0D%0ACONSTRUCT+%7B%3Fs+owl%3AequivalentProperty+%3Fo%7D++%0D%0AWHERE+%7B+SERVICE+%3Chttp%3A%2F%2Fquery.wikidata.org%2Fsparql%3E++++++++++%0D%0A++++++++++++++++%7B++%0D%0A+++++++++++++++++++++SELECT+%3Fs+%3FequivalentProperty+%3Fo%0D%0A+++++++++++++++++++++WHERE+%7B+%0D%0A%09%09%09%09%09+%09%09+%3Fs+wdt%3AP1628+%3Fo+.+%0D%0A%09%09%09%09%09+%09%09+BIND+%28wdt%3AP1628+as+%3FequivalentProperty%29%0D%0A+++++++++++++++++++++%09%09+FILTER%28+REGEX%28STR%28%3Fo%29%2C+%22schema.org%22%29%29+%0D%0A%09%09%09%09%09%09+++%7D%0D%0A++++++++++++++++%7D++++++++%0D%0A+++++++%7D&should-sponge=&format=application%2Fld%2Bjson&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000000 -- JSON-LD
[2] http://linkeddata.uriburner.com/sparql?default-graph-uri=&query=PREFIX+wdt%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E+%0D%0A%0D%0ACONSTRUCT+%7B%3Fs+owl%3AequivalentProperty+%3Fo%7D++%0D%0AWHERE+%7B+SERVICE+%3Chttp%3A%2F%2Fquery.wikidata.org%2Fsparql%3E++++++++++%0D%0A++++++++++++++++%7B++%0D%0A+++++++++++++++++++++SELECT+%3Fs+%3FequivalentProperty+%3Fo%0D%0A+++++++++++++++++++++WHERE+%7B+%0D%0A%09%09%09%09%09+%09%09+%3Fs+wdt%3AP1628+%3Fo+.+%0D%0A%09%09%09%09%09+%09%09+BIND+%28wdt%3AP1628+as+%3FequivalentProperty%29%0D%0A+++++++++++++++++++++%09%09+FILTER%28+REGEX%28STR%28%3Fo%29%2C+%22schema.org%22%29%29+%0D%0A%09%09%09%09%09%09+++%7D%0D%0A++++++++++++++++%7D++++++++%0D%0A+++++++%7D&should-sponge=&format=text%2Fturtle&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000000 -- RDF-Turtle
[3] http://linkeddata.uriburner.com/sparql?default-graph-uri=&query=PREFIX+wdt%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E+%0D%0A%0D%0ACONSTRUCT+%7B%3Fs+owl%3AequivalentProperty+%3Fo%7D++%0D%0AWHERE+%7B+SERVICE+%3Chttp%3A%2F%2Fquery.wikidata.org%2Fsparql%3E++++++++++%0D%0A++++++++++++++++%7B++%0D%0A+++++++++++++++++++++SELECT+%3Fs+%3FequivalentProperty+%3Fo%0D%0A+++++++++++++++++++++WHERE+%7B+%0D%0A%09%09%09%09%09+%09%09+%3Fs+wdt%3AP1628+%3Fo+.+%0D%0A%09%09%09%09%09+%09%09+BIND+%28wdt%3AP1628+as+%3FequivalentProperty%29%0D%0A+++++++++++++++++++++%09%09+FILTER%28+REGEX%28STR%28%3Fo%29%2C+%22schema.org%22%29%29+%0D%0A%09%09%09%09%09%09+++%7D%0D%0A++++++++++++++++%7D++++++++%0D%0A+++++++%7D&should-sponge=&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000000
[4] http://linkeddata.uriburner.com/sparql?default-graph-uri=&query=PREFIX+wdt%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E+%0D%0A%0D%0ACONSTRUCT+%7B%3Fs+owl%3AequivalentProperty+%3Fo%7D++%0D%0AWHERE+%7B+SERVICE+%3Chttp%3A%2F%2Fquery.wikidata.org%2Fsparql%3E++++++++++%0D%0A++++++++++++++++%7B++%0D%0A+++++++++++++++++++++SELECT+%3Fs+%3FequivalentProperty+%3Fo%0D%0A+++++++++++++++++++++WHERE+%7B+%0D%0A%09%09%09%09%09+%09%09+%3Fs+wdt%3AP1628+%3Fo+.+%0D%0A%09%09%09%09%09+%09%09+BIND+%28wdt%3AP1628+as+%3FequivalentProperty%29%0D%0A+++++++++++++++++++++%09%09+FILTER%28+REGEX%28STR%28%3Fo%29%2C+%22schema.org%22%29%29+%0D%0A%09%09%09%09%09%09+++%7D%0D%0A++++++++++++++++%7D++++++++%0D%0A+++++++%7D&should-sponge=&format=application%2Fxhtml%2Bxml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000000 -- XHTML+RDFa
##### Equivalent Class Relations Generation #####
Links:
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
CONSTRUCT {?s ?equivalentClass ?o}
WHERE { SERVICE <http://query.wikidata.org/sparql>
{
SELECT ?s ?equivalentClass ?o
WHERE { ?s wdt:P1709 ?o .
BIND ( wdt:P1709 as ?equivalentClass)
FILTER( REGEX(STR(?o), "schema.org"))
}
}
}
## Explicit Remapping to owl:equivalentClass relations
## which enables better reasoning and inference oriented data
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
CONSTRUCT {?s owl:equivalentClass ?o}
WHERE { SERVICE <http://query.wikidata.org/sparql>
{
SELECT ?s ?equivalentClass ?o
WHERE { ?s wdt:P1709 ?o .
BIND ( wdt:P1709 as ?equivalentClass)
FILTER( REGEX(STR(?o), "schema.org"))
}
}
}
Live Links:
[1] http://linkeddata.uriburner.com/sparql?default-graph-uri=&query=PREFIX+wdt%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E+%0D%0A%0D%0ACONSTRUCT+%7B%3Fs+owl%3AequivalentClass+%3Fo%7D++%0D%0AWHERE+%7B+SERVICE+%3Chttp%3A%2F%2Fquery.wikidata.org%2Fsparql%3E++++++++++%0D%0A+++++++++++++%7B++%0D%0A%09%09%09%09SELECT+%3Fs+%3FequivalentClass+%3Fo%0D%0A%09%09%09%09WHERE+%7B+%3Fs+wdt%3AP1709+%3Fo+.+%0D%0A%09%09%09%09%09%09BIND+%28+wdt%3AP1709+as+%3FequivalentClass%29%0D%0A%09%09%09%09++++++++FILTER%28+REGEX%28STR%28%3Fo%29%2C+%22schema.org%22%29%29+%0D%0A%09%09%09%09%09++%7D%0D%0A+++++++++++++%7D++++++++%0D%0A++++%7D&should-sponge=&format=application%2Fld%2Bjson&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000000 -- JSON-LD
[2] http://linkeddata.uriburner.com/sparql?default-graph-uri=&query=PREFIX+wdt%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E+%0D%0A%0D%0ACONSTRUCT+%7B%3Fs+owl%3AequivalentClass+%3Fo%7D++%0D%0AWHERE+%7B+SERVICE+%3Chttp%3A%2F%2Fquery.wikidata.org%2Fsparql%3E++++++++++%0D%0A+++++++++++++%7B++%0D%0A%09%09%09%09SELECT+%3Fs+%3FequivalentClass+%3Fo%0D%0A%09%09%09%09WHERE+%7B+%3Fs+wdt%3AP1709+%3Fo+.+%0D%0A%09%09%09%09%09%09BIND+%28+wdt%3AP1709+as+%3FequivalentClass%29%0D%0A%09%09%09%09++++++++FILTER%28+REGEX%28STR%28%3Fo%29%2C+%22schema.org%22%29%29+%0D%0A%09%09%09%09%09++%7D%0D%0A+++++++++++++%7D++++++++%0D%0A++++%7D&should-sponge=&format=text%2Fturtle&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000000 -- RDF-Turtle
[3] http://linkeddata.uriburner.com/sparql?default-graph-uri=&query=PREFIX+wdt%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E+%0D%0A%0D%0ACONSTRUCT+%7B%3Fs+owl%3AequivalentClass+%3Fo%7D++%0D%0AWHERE+%7B+SERVICE+%3Chttp%3A%2F%2Fquery.wikidata.org%2Fsparql%3E++++++++++%0D%0A+++++++++++++%7B++%0D%0A%09%09%09%09SELECT+%3Fs+%3FequivalentClass+%3Fo%0D%0A%09%09%09%09WHERE+%7B+%3Fs+wdt%3AP1709+%3Fo+.+%0D%0A%09%09%09%09%09%09BIND+%28+wdt%3AP1709+as+%3FequivalentClass%29%0D%0A%09%09%09%09++++++++FILTER%28+REGEX%28STR%28%3Fo%29%2C+%22schema.org%22%29%29+%0D%0A%09%09%09%09%09++%7D%0D%0A+++++++++++++%7D++++++++%0D%0A++++%7D&should-sponge=&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000000 -- HTML+Microdata
[4] http://linkeddata.uriburner.com/sparql?default-graph-uri=&query=PREFIX+wdt%3A+%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E+%0D%0A%0D%0ACONSTRUCT+%7B%3Fs+owl%3AequivalentClass+%3Fo%7D++%0D%0AWHERE+%7B+SERVICE+%3Chttp%3A%2F%2Fquery.wikidata.org%2Fsparql%3E++++++++++%0D%0A+++++++++++++%7B++%0D%0A%09%09%09%09SELECT+%3Fs+%3FequivalentClass+%3Fo%0D%0A%09%09%09%09WHERE+%7B+%3Fs+wdt%3AP1709+%3Fo+.+%0D%0A%09%09%09%09%09%09BIND+%28+wdt%3AP1709+as+%3FequivalentClass%29%0D%0A%09%09%09%09++++++++FILTER%28+REGEX%28STR%28%3Fo%29%2C+%22schema.org%22%29%29+%0D%0A%09%09%09%09%09++%7D%0D%0A+++++++++++++%7D++++++++%0D%0A++++%7D&should-sponge=&format=application%2Fxhtml%2Bxml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=30000000 -- XHTML+RDFa
[1] DBpedia 2016-04 Announcement_______________________________________________-- Regards, Kingsley Idehen Founder & CEO OpenLink Software (Home Page: http://www.openlinksw.com) Weblogs (Blogs): Legacy Blog: http://www.openlinksw.com/blog/~kidehen/ Blogspot Blog: http://kidehen.blogspot.com Medium Blog: https://medium.com/@kidehen Profile Pages: Pinterest: https://www.pinterest.com/kidehen/ Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen Twitter: https://twitter.com/kidehen Google+: https://plus.google.com/+KingsleyIdehen/about LinkedIn: http://www.linkedin.com/in/kidehen Web Identities (WebID): Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata