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 #####

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

Links:

[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

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

_______________________________________________
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata

Reply via email to