Nice Kingsley! Great work. So now....the bad news and where we need further help still :)I do want to let everyone know however that within Classes and Properties...there are a slight few mappings that were taken as an opinionated viewI.E. they may slightly conflict with other views of the mappings in Languages that are not English. Or might not seem correctly mapped or aligned.But I think most folks know that around here and deal with that everyday in Wikipedia and Wikidata.Still, we encourage all communities to review the Schema.org-WD mappings and voice any issues, errors, mistakes, or alternative viewpoints in this Wikidata mailing list or the Schema.org mailing list or our Schema.org Github issues.On Mon, Oct 17, 2016 at 1:26 PM Kingsley Idehen <kidehen@openlinksw.com> wrote: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