### VirtRDF-Label and Faceted Browser rules re. labels for URIs

-- The SPARUL statement for loading it into the Quad Store:
INSERT INTO <facets> 
WHERE 
  {
    <http://www.aktors.org/ontology/portal#full-name> rdfs:subPropertyOf  virtrdf:label  .
  }

--Making the rule from the graph:
rdfs_rule_set ('facets', 'facets');

-- extend to other rules e.g. virtrdf-label.

rdfs_rule_set ('facets', 'virtrdf-label');



## Google Spreadsheet function

http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=select+%3Fs+%3Fgenre+%3Fdied+%3Fborn+%28bif%3Adatediff%28%27year%27%2Cxsd%3AdateTime%28str%28%3Fborn%29%29%2Cxsd%3AdateTime%28str%28%3Fdied%29%29%29%29+as+%3Fage%0D%0Awhere+%7B+%7B%0D%0Aselect+distinct+%3Fs+%3Fgenre+%3Fdied+%3Fborn+from+%3Chttp%3A%2F%2Fdbpedia.org%3E+where+%0D%0A%7B+%0D%0A++%3Fs+a+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FMusicalArtist%3E+%3B%0D%0A+++++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2Fgenre%3E+%3Fgenre%3B%0D%0A+++++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FdeathDate%3E+%3Fdied%3B%0D%0A+++++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FbirthDate%3E+%3Fborn+.%0D%0A%0D%0A++%0D%0A%7D%0D%0A+order+by+desc+%28+%3CLONG%3A%3AIRI_RANK%3E+%28%3Fgenre%29+%29+limit+100+%7D%7D&format=text%2Fcsv&timeout=0&debug=on

=ImportHtml("";"table";1)


Google HTML Import placehoder:

=ImportHtml("http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=SELECT+DISTINCT+%3Fperson+as+%3Fperson_id+str%28%3Fplabel%29+as+%3Fperson_name+%3Fgenre+as+%3Fgenre_id+str%28%3Fglabel%29+as+%3Fgenre_name+%3Fdied+%3Fborn+%28+%3CLONG%3A%3AIRI_RANK%3E+%28%3Fperson%29+%29+as+%3Frank%0D%0A%28+IF+%28%0D%0A++%28datatype+%28%3Fborn%29+in+%28xsd%3AdateTime%2C+xsd%3Adate%29%29+and%0D%0A++%28datatype+%28%3Fdied%29+in+%28xsd%3AdateTime%2C+xsd%3Adate%29%29%2C%0D%0A++bif%3Adatediff%28%27year%27%2Cxsd%3AdateTime%28str%28%3Fborn%29%29%2Cxsd%3AdateTime%28str%28%3Fdied%29%29%29%2C%0D%0A++%22error%22+%29+%29+as+%3Fage%0D%0AWHERE+%7B+%7B%0D%0ASELECT+DISTINCT+%3Fperson+%3Fplabel+%3Fgenre+%3Fglabel+%3Fdied+%3Fborn+from+%3Chttp%3A%2F%2Fdbpedia.org%3E+WHERE%0D%0A%7B+%0D%0A%3Fperson+a+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FMusicalArtist%3E+%3B%0D%0A+++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2Fgenre%3E+%3Fgenre%3B%0D%0A+++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FdeathDate%3E+%3Fdied%3B%0D%0A+++rdfs%3Alabel+%3Fplabel%3B%0D%0A+++%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FbirthDate%3E+%3Fborn+.%0D%0A+++%3Fgenre+rdfs%3Alabel+%3Fglabel+.%0D%0A+++filter+%28lang%28%3Fplabel%29+%3D+%22en%22%29%0D%0A+++filter+%28lang%28%3Fglabel%29+%3D+%22en%22%29%0D%0A%0D%0A%7D%0D%0A%0D%0AORDER+BY+DESC+%28+%3CLONG%3A%3AIRI_RANK%3E+%28%3Fperson%29+%29+LIMIT+100++%7D%7D&format=application%2Fvnd.ms-excel&timeout=0&debug=on";"table";1)

=ImportHtml("";"table";1)

## FAO Country Listing and CoRefs

 SELECT DISTINCT ?s1 (sql:GROUP_CONCAT(?coRef, " , ")) AS ?sameAs where 
  { { SELECT DISTINCT * WHERE {
    ?s1 a <http://aims.fao.org/aos/geopolitical.owl#self_governing>; owl:sameAs ?coRef .}
    
  } }
 ORDER BY DESC ( <LONG::IRI_RANK> ( ?s1 ) ) 
 
 ## SUMO Country Listing & CoRefs
 
 SELECT DISTINCT ?s1 AS ?CountryID (sql:GROUP_CONCAT(?coRef, " , ")) AS ?CoReferences where 
  { { SELECT DISTINCT * WHERE {
    ?s1 a  <http://www.ontologyportal.org/SUMO.owl#Nation> ; owl:sameAs ?coRef .}
    
  } }
 ORDER BY DESC ( <LONG::IRI_RANK> ( ?s1 ) ) 
 
 ## SUMO Country Listing and CoRefs
 ## Pretty Labels
 
 SELECT DISTINCT ?s1 AS ?CountryID, (sql:GROUP_CONCAT(?coRef, " , ")) AS ?CoReference, str(?label) AS ?Name, str(?o) AS ?Comment
 WHERE
  { { SELECT DISTINCT * 
      WHERE {
              ?s1 a <http://www.ontologyportal.org/SUMO.owl#Nation>; 
              owl:sameAs ?coRef.
              OPTIONAL {?s1 rdfs:label ?label}.
              OPTIONAL {?s1 owl:comment ?o}.
       }
    
  } }
 ORDER BY DESC ( <LONG::IRI_RANK> ( ?s1 ) )
 
 ## SUMO Country Listing and CoRefs
 ## Pretty Labels
 ## GeoSpatial Data from FAO
 
 SELECT DISTINCT ?s1 AS ?CountryID, 
                  ?s AS ?Capital, 
                  (sql:GROUP_CONCAT(?coRef, " , ")) AS ?CoReference, 
                  str(?label) AS ?Name, 
                  str(?o) AS ?Comment,
                  ?lat AS ?Latitude,
                  ?long AS ?Longitude,
                  ?geopoint AS ?Point 
  WHERE
   { { SELECT DISTINCT * 
       WHERE {
               ?s1 a <http://www.ontologyportal.org/SUMO.owl#Nation>; 
               owl:sameAs ?coRef.
               OPTIONAL {?s1 rdfs:label ?label}.
               OPTIONAL {?s1 owl:comment ?o}.
               ?s <http://www.ontologyportal.org/SUMO.owl#capitalCity> ?s1 .
               ?coRef <http://aims.fao.org/aos/geopolitical.owl#hasMinLatitude> ?lat.
               ?coRef <http://aims.fao.org/aos/geopolitical.owl#hasMinLongitude> ?long.
               ?coRef geo:geometry ?geopoint.    
        }
    
   } }
 ORDER BY DESC ( <LONG::IRI_RANK> ( ?s1 ) )
 

## DBpedia Country Listing & CoRefs
 
 SELECT DISTINCT ?s1 AS ?CountryID (sql:GROUP_CONCAT(?coRef, " , ")) AS ?CoReferences where 
  { { SELECT DISTINCT * WHERE {
    ?s1 a  <http://dbpedia.org/ontology/Country> ; owl:sameAs ?coRef .}
    
  } }
 ORDER BY DESC ( <LONG::IRI_RANK> ( ?s1 ) ) 

 
## Date Arithmetic, Entity Rank, Grouping but no labels

select distinct ?person (sql:GROUP_CONCAT(?genre, " , ")) as ?genres ?died ?born
( if (
  (datatype (?born) in (xsd:dateTime, xsd:date)) and
  (datatype (?died) in (xsd:dateTime, xsd:date)),
  bif:datediff('year',xsd:dateTime(str(?born)),xsd:dateTime(str(?died))),
  "error" ) ) as ?age
where { {
select distinct ?person ?genre ?died ?born from <http://dbpedia.org> where 
{ 
?person a <http://dbpedia.org/ontology/MusicalArtist> ;
   <http://dbpedia.org/ontology/genre> ?genre;
   <http://dbpedia.org/ontology/deathDate> ?died;
   <http://dbpedia.org/ontology/birthDate> ?born .


}
order by desc ( <LONG::IRI_RANK> (?person) ) limit 100  }}

## Data Arithmetic, Entity Rank, Grouping, with Pretty Labels

SELECT DISTINCT ?person as ?person_id str(?plabel) as ?person_name ?genre as ?genre_id str(?glabel) as ?genre_name ?died ?born ( <LONG::IRI_RANK> (?person) ) as ?rank
( IF (
  (datatype (?born) in (xsd:dateTime, xsd:date)) and
  (datatype (?died) in (xsd:dateTime, xsd:date)),
  bif:datediff('year',xsd:dateTime(str(?born)),xsd:dateTime(str(?died))),
  "error" ) ) as ?age
WHERE { {
SELECT DISTINCT ?person ?plabel ?genre ?glabel ?died ?born from <http://dbpedia.org> WHERE
{ 
?person a <http://dbpedia.org/ontology/MusicalArtist> ;
   <http://dbpedia.org/ontology/genre> ?genre;
   <http://dbpedia.org/ontology/deathDate> ?died;
   rdfs:label ?plabel;
   <http://dbpedia.org/ontology/birthDate> ?born .
   ?genre rdfs:label ?glabel .
   filter (lang(?plabel) = "en")
   filter (lang(?glabel) = "en")

}

ORDER BY DESC ( <LONG::IRI_RANK> (?person) ) LIMIT 100  }}

## Date Arithmetic, Entity Rank, and Grouping 

	

## Date Arithmetic and Entity Ranking

select distinct ?person ?plabel ?genre ?glabel ?died ?born ( <LONG::IRI_RANK> (?person) ) as ?rank
( if (
  (datatype (?born) in (xsd:dateTime, xsd:date)) and
  (datatype (?died) in (xsd:dateTime, xsd:date)),
  bif:datediff('year',xsd:dateTime(str(?born)),xsd:dateTime(str(?died))),
  "error" ) ) as ?age
where { {
select distinct ?person ?plabel ?genre ?glabel ?died ?born from <http://dbpedia.org> where 
{ 
?person a <http://dbpedia.org/ontology/MusicalArtist> ;
   <http://dbpedia.org/ontology/genre> ?genre;
   <http://dbpedia.org/ontology/deathDate> ?died;
   rdfs:label ?plabel;
   <http://dbpedia.org/ontology/birthDate> ?born .
   ?genre rdfs:label ?glabel .
   filter (lang(?plabel) = "en")
   filter (lang(?glabel) = "en")

}

order by desc ( <LONG::IRI_RANK> (?person) ) limit 100  }}
 
## Date Arithmetic
select ?s ?genre ?died ?born (bif:datediff('year',xsd:dateTime(str(?born)),xsd:dateTime(str(?died)))) as ?age
where { {
select distinct ?s ?genre ?died ?born from <http://dbpedia.org> where 
{ 
  ?s a <http://dbpedia.org/ontology/MusicalArtist> ;
     <http://dbpedia.org/ontology/genre> ?genre;
     <http://dbpedia.org/ontology/deathDate> ?died;
     <http://dbpedia.org/ontology/birthDate> ?born .

  
}
limit 20 }}

## Using SPARQL to add missing isDefinedBy relations to an Ontology.
## Benefit: isDefinedBy relations make Ontologies (TBox) more navigable using follow-your-nose pattern. This also ## makes ABox instance data more discoverable. 
## Ontology Document URL: http://www.w3.org/2006/vcard/ns
## Ontology URI: http://www.w3.org/2006/vcard/ns#
## Goal: use SPARQL to generate relations that associate Classes and Properties the Ontology that describes them.
## Steps: use a local Named Graph IRI to host SPARQL Update (SPARUL) the new relations.
## ** Important OWL Reasoning Note ** 
## http://open.vocab.org/terms/defines is owl:inverseOf rdfs:isDefinedBy, thus adding this relation to a Named Graph that's used for an inference rule negates the need for creating the actual relations, if you choose to put Virtuoso's reasoner to use. 

## Uncomment line below if using Virtuoso and executing SPARQL via iSQL or via an ODBC, JDBC, ADO.NET connection
## SPARQL

## Uncomment line (a SPARQL pragma) below if using Virtuoso and there isn't a local Named Graph holding triples retrieved from the ## Ontology URL

## DEFINE get:soft "add"

INSERT INTO <http://www.w3.org/2006/vcard/ns> {?s rdfs:isDefinedBy <http://www.w3.org/2006/vcard/ns#> . <http://www.w3.org/2006/vcard/ns#> <http://open.vocab.org/terms/defines> ?s}
FROM <http://www.w3.org/2006/vcard/ns>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

## Another example using the recorded media Ontology
## Ontology Document URL: http://www.w3.org/ns/ma-ont
## Ontology URI: http://www.w3.org/ns/ma-ont#

SPARQL
INSERT INTO <http://www.w3.org/ns/ma-ont> {?s rdfs:isDefinedBy <http://www.w3.org/ns/ma-ont#> . <http://www.w3.org/ns/ma-ont#> <http://open.vocab.org/terms/defines> ?s}
FROM <http://www.w3.org/ns/ma-ont>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

## PA Ontologies cleanup

INSERT INTO <http://data.press.net/ontology/classification.rdf> {?s rdfs:isDefinedBy <http://data.press.net/ontology/classification/>. <http://data.press.net/ontology/classification/> <http://open.vocab.org/terms/defines> ?s}
FROM <http://data.press.net/ontology/classification.rdf>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}


INSERT INTO <http://data.press.net/ontology/event.rdf> {?s rdfs:isDefinedBy <http://data.press.net/ontology/event/>. <http://data.press.net/ontology/event/> <http://open.vocab.org/terms/defines> ?s}
FROM <http://data.press.net/ontology/event.rdf>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

SPARQL
INSERT INTO <http://data.press.net/ontology/stuff.rdf> {?s rdfs:isDefinedBy <http://data.press.net/ontology/stuff/> . <http://data.press.net/ontology/stuff/>  <http://open.vocab.org/terms/defines> ?s}
FROM <http://data.press.net/ontology/stuff.rdf>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

INSERT INTO <http://data.press.net/ontology/asset.rdf> {?s rdfs:isDefinedBy <http://data.press.net/ontology/asset/> . <http://data.press.net/ontology/asset/> <http://open.vocab.org/terms/defines> ?s}
FROM <http://data.press.net/ontology/asset.rdf>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}


INSERT INTO <http://data.press.net/ontology/tag.rdf> {?s rdfs:isDefinedBy <http://data.press.net/ontology/tag/> . <http://data.press.net/ontology/tag/> <http://open.vocab.org/terms/defines> ?s}
FROM <http://data.press.net/ontology/tag.rdf>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

## Provenance Ontology Cleanup
INSERT INTO <http://www.w3.org/TR/2011/WD-prov-o-20111213/ProvenanceOntology.owl> {?s rdfs:isDefinedBy <http://www.w3.org/TR/2011/WD-prov-o-20111213/ProvenanceOntology.owl/> . <http://www.w3.org/TR/2011/WD-prov-o-20111213/ProvenanceOntology.owl/> <http://open.vocab.org/terms/defines> ?s}
FROM <http://www.w3.org/TR/2011/WD-prov-o-20111213/ProvenanceOntology.owl>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

## Web Semantics Ontology

INSERT INTO <http://www.w3.org/2000/10/swap/log.rdf> 
{?s rdfs:isDefinedBy <http://www.w3.org/2000/10/swap/log#> . 
<http://www.w3.org/2000/10/swap/log#> <http://open.vocab.org/terms/defines> ?s.
<http://www.w3.org/2000/10/swap/log#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://www.w3.org/2000/10/swap/log.rdf>}
FROM <http://www.w3.org/2000/10/swap/log.rdf>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

## Wordnet to Schema.org mapping

INSERT INTO <http://schema.rdfs.org/mappings/schemaorg_wn.owl> 
{?s rdfs:isDefinedBy <http://schema.rdfs.org/mappings/schemaorg_wn.owl/> . 
<http://schema.rdfs.org/mappings/schemaorg_wn.owl/> <http://open.vocab.org/terms/defines> ?s.
<http://schema.rdfs.org/mappings/schemaorg_wn.owl/> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://schema.rdfs.org/mappings/schemaorg_wn.owl>}
FROM <http://schema.rdfs.org/mappings/schemaorg_wn.owl>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}


##Bibo
INSERT INTO <http://schema.rdfs.org/mappings/bibo.ttl> 
{?s rdfs:isDefinedBy <http://schema.rdfs.org/mappings#bibo2schemaorg> . 
<http://schema.rdfs.org/mappings#bibo2schemaorg> <http://open.vocab.org/terms/defines> ?s.
<http://schema.rdfs.org/mappings#bibo2schemaorg> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://schema.rdfs.org/mappings/bibo.ttl>}
FROM <http://schema.rdfs.org/mappings/bibo.ttl>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

## VoiD Ontology

INSERT INTO <http://vocab.deri.ie/void> 
{
<http://vocab.deri.ie/void> <http://open.vocab.org/terms/defines> ?s.
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://vocab.deri.ie/void.rdf>}
FROM <http://vocab.deri.ie/void.rdf>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}


### Nepomuk

### Calendar
INSERT INTO <http://www.semanticdesktop.org/ontologies/2007/04/02/ncal/> 
{?s rdfs:isDefinedBy <http://www.semanticdesktop.org/ontologies/2007/04/02/ncal#> . 
<http://www.semanticdesktop.org/ontologies/2007/04/02/ncal#> <http://open.vocab.org/terms/defines> ?s.
<http://www.semanticdesktop.org/ontologies/2007/04/02/ncal#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://www.semanticdesktop.org/ontologies/2007/04/02/ncal/>}
FROM <http://www.semanticdesktop.org/ontologies/2007/04/02/ncal/>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

### Contacts
INSERT INTO <http://www.semanticdesktop.org/ontologies/2007/03/22/nco/> 
{?s rdfs:isDefinedBy <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#> . 
<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#> <http://open.vocab.org/terms/defines> ?s.
<http://www.semanticdesktop.org/ontologies/2007/03/22/nco#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://www.semanticdesktop.org/ontologies/2007/03/22/nco/>}
FROM <http://www.semanticdesktop.org/ontologies/2007/03/22/nco/>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

### Files

INSERT INTO <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo/> 
{?s rdfs:isDefinedBy <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo/#> . 
<http://www.semanticdesktop.org/ontologies/2007/03/22/nfo/#> <http://open.vocab.org/terms/defines> ?s.
<http://www.semanticdesktop.org/ontologies/2007/03/22/nfo/#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo/>}
FROM <http://www.semanticdesktop.org/ontologies/2007/03/22/nfo/>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}


### Nepomuk Representational Language Specification

INSERT INTO <http://www.semanticdesktop.org/ontologies/2007/08/15/nrl/> 
{?s rdfs:isDefinedBy <http://www.semanticdesktop.org/ontologies/2007/08/15/nrl#> . 
<http://www.semanticdesktop.org/ontologies/2007/08/15/nrl#> <http://open.vocab.org/terms/defines> ?s.
<http://www.semanticdesktop.org/ontologies/2007/08/15/nrl#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://www.semanticdesktop.org/ontologies/2007/08/15/nrl/>}
FROM <http://www.semanticdesktop.org/ontologies/2007/08/15/nrl/>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

### Personal Information Management

INSERT INTO <http://www.semanticdesktop.org/ontologies/2007/11/01/pimo/> 
{?s rdfs:isDefinedBy <http://www.semanticdesktop.org/ontologies/2007/11/01/pimo#> . 
<http://www.semanticdesktop.org/ontologies/2007/11/01/pimo#> <http://open.vocab.org/terms/defines> ?s.
<http://www.semanticdesktop.org/ontologies/2007/11/01/pimo#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://www.semanticdesktop.org/ontologies/2007/11/01/pimo/>}
FROM <http://www.semanticdesktop.org/ontologies/2007/11/01/pimo/>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

### NLP Analysis from Washington Post Article

SELECT 
DISTINCT * FROM <http://www.washingtonpost.com/business/modern-monetary-theory-is-an-unconventional-take-on-economic-strategy/2012/02/15/gIQAR8uPMR_story.html> 
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

### Network Information Element (NIE) 

INSERT INTO <http://www.semanticdesktop.org/ontologies/2007/01/19/nie> 
{?s rdfs:isDefinedBy <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#> . 
<http://www.semanticdesktop.org/ontologies/2007/01/19/nie#> <http://open.vocab.org/terms/defines> ?s.
<http://www.semanticdesktop.org/ontologies/2007/01/19/nie#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://www.semanticdesktop.org/ontologies/2007/01/19/nie>}
FROM <http://www.semanticdesktop.org/ontologies/2007/01/19/nie>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

### Annotation Ontology


INSERT INTO <http://www.semanticdesktop.org/ontologies/2007/08/15/nao> 
{?s rdfs:isDefinedBy <http://www.semanticdesktop.org/ontologies/2007/08/15/nao#> . 
<http://www.semanticdesktop.org/ontologies/2007/08/15/nao#> <http://open.vocab.org/terms/defines> ?s.
<http://www.semanticdesktop.org/ontologies/2007/08/15/nao#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://www.semanticdesktop.org/ontologies/2007/08/15/nao>}
FROM <http://www.semanticdesktop.org/ontologies/2007/08/15/nao>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

## HAO


INSERT INTO <http://purl.obolibrary.org/obo/hao.owl> 
{?s rdfs:isDefinedBy <http://purl.obolibrary.org/obo/hao.owl> . 
<http://purl.obolibrary.org/obo/hao.owl> <http://open.vocab.org/terms/defines> ?s.
<http://purl.obolibrary.org/obo/hao.owl> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://purl.obolibrary.org/obo/hao.owl>}
FROM <http://purl.obolibrary.org/obo/hao.owl>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

## RPIs dataset ontology

INSERT INTO <http://data-gov.tw.rpi.edu/2009/data-gov-twc.rdf> 
{?s rdfs:isDefinedBy <http://data-gov.tw.rpi.edu/2009/data-gov-twc.rdf#> . 
<http://data-gov.tw.rpi.edu/2009/data-gov-twc.rdf#> <http://open.vocab.org/terms/defines> ?s.
<http://data-gov.tw.rpi.edu/2009/data-gov-twc.rdf#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://data-gov.tw.rpi.edu/2009/data-gov-twc.rdf>}
FROM <http://data-gov.tw.rpi.edu/2009/data-gov-twc.rdf>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

## Nature.com Ontology

INSERT INTO <http://ns.nature.com/terms/> 
{?s rdfs:isDefinedBy <http://ns.nature.com/terms/> . 
<http://ns.nature.com/terms/> <http://open.vocab.org/terms/defines> ?s.
<http://ns.nature.com/terms/> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://ns.nature.com/terms/>}
FROM <http://ns.nature.com/terms/>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

## Vivo Ontology

INSERT INTO <http://vivoweb.org/ontology/core> 
{?s rdfs:isDefinedBy <http://vivoweb.org/ontology/core#> . 
<http://vivoweb.org/ontology/core#> <http://open.vocab.org/terms/defines> ?s.
<http://vivoweb.org/ontology/core#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://vivoweb.org/ontology/core>}
FROM <http://vivoweb.org/ontology/core>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}

## Polymer Informatics Ontology

INSERT INTO <http://www.polymerinformatics.com/ChemAxiom/ChemDomain.owl> 
{?s rdfs:isDefinedBy <http://www.polymerinformatics.com/ChemAxiom/ChemDomain.owl#> . 
<http://www.polymerinformatics.com/ChemAxiom/ChemDomain.owl#> <http://open.vocab.org/terms/defines> ?s.
<http://www.polymerinformatics.com/ChemAxiom/ChemDomain.owl#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://www.polymerinformatics.com/ChemAxiom/ChemDomain.owl>}
FROM <http://www.polymerinformatics.com/ChemAxiom/ChemDomain.owl>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}





## Stat Ontology from Data.FM
## Doesn't work as it doesn't really have an RDFs or OWL relations

INSERT INTO <http://www.w3.org/ns/posix/stat> 
{?s rdfs:isDefinedBy <http://www.w3.org/ns/posix/stat#> . 
<http://www.w3.org/ns/posix/stat#> <http://open.vocab.org/terms/defines> ?s.
<http://www.w3.org/ns/posix/stat#> a owl:Ontology .
?s <http://www.w3.org/2007/05/powder-s#describedby> <http://www.w3.org/ns/posix/stat>}
FROM <http://www.w3.org/ns/posix/stat>
WHERE {  {?s rdfs:subClassOf ?o} UNION {?s rdfs:subPropertyOf ?o} UNION {?s owl:equivalentClass ?o} UNION {?s owl:equivalentProperty ?o} UNION {?s a ?o}}












## More co-refs
sparql
insert into <urn:kingly:data:tweaks> {
<http://kingsley.idehen.net/dataspace/person/kidehen#this> owl:sameAs <http://linkeddata.uriburner.com/about/id/entity/http/twitter.com/kidehen>.
<http://uriburner.com/about/id/entity/http/twitter.com/kidehen> owl:sameAs <http://linkeddata.uriburner.com/about/id/entity/http/twitter.com/kidehen>.
<http://kingsley.idehen.name/dataspace/person/kidehen#this> owl:sameAs <http://uriburner.com/about/id/entity/http/twitter.com/kidehen>, <http://linkeddata.uriburner.com/about/id/entity/http/twitter.com/kidehen> }
##

##
insert into <urn:kingly:data:tweaks> {
<http://kingsley.idehen.net/dataspace/person/kidehen#this> owl:sameAs <http://myopenlink.net/dataspace/person/kidehen#this>, <http://id.myopenlink.net/dataspace/person/KingsleyUyiIdehen#this>,
<http://graph.facebook.com/kidehen#this>, <http://myopenlink.net/dataspace/person/kidehen#this>, <http://vizualize.me/kidehen#this>, <https://www.foldedsoft.at/+/allmy+/user/112399767740508618350#this>, <http://linkeddata.uriburner.com/about/id/entity/http/twitter.com/kidehen>}
##
PREFIX mu:   <http://www.jiscmu.ac.uk/schema/muweb/>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT *
WHERE
    { SERVICE <http://api.talis.com/stores/jisc-prod-dev1/services/sparql>
       
        { 
			SELECT ?muOrg ?name ?postcode ?lat ?long
			WHERE {  
			?muOrg a <http://www.jiscmu.ac.uk/schema/muweb/Organisation> .
			{ ?muOrg mu:Sector "Further Education" } 
			UNION 
			{ ?muOrg mu:Sector "Higher Education" } .
			?muOrg mu:OfficialName ?name .
			?muOrg mu:PostCode ?postcode .
			?muOrg geo:lat ?lat .
			?muOrg geo:lon ?long .
			}
        }
       
    }



	PREFIX space: <http://purl.org/net/schemas/space/>
	PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
	
	SELECT ?disc ?label
	WHERE
	    { SERVICE <http://api.talis.com/stores/space/services/sparql>
		 {
			SELECT ?disc ?label
                        WHERE 
			{
			  <http://nasa.dataincubator.org/spacecraft/1968-089A> space:discipline ?disc .
			  ?disc rdfs:label ?label
			}
			
          }

	    }


--- Data Space Tweak Exercise

sparql
insert into <urn:mylinkeddata:tweaks>
{
<http://www.productontology.org/id/Book> owl:equivalentClass <http://purl.org/ontology/bibo/Book> .
<http://www.productontology.org/id/Book> owl:equivalentClass <http://purl.org/NET/book/vocab#Book> .
}

-- Verification
http://uriburner.com/describe/?url=http%3A%2F%2Fpurl.org%2FNET%2Fbook%2Fvocab%23Book&p=3279&lp=3278&op=3277&prev=&gp=3279


-- Content Negotiation Driven Loading

DB.DBA.RDF_LOAD_RDFXML (http_get ('http://purl.org/ontology/mo/', null, 'GET', 'Accept: application/rdf+xml', null, null, 3), 'http://purl.org/ontology/mo/', 'http://purl.org/ontology/mo/');

--- Rules Management
-- Remove
rdfs_rule_set (rule_name, graph_name, 1)

-- Add
rdfs_rule_set   (rule_name, graph_name)

Example:
SPARQL 
load <http://motools.sourceforge.net/doc/musicontology.n3> ;
-- Remove
rdfs_rule_set ('music_ontology', 'http://motools.sourceforge.net/doc/musicontology.n3', 1)

-- Add
rdfs_rule_set ('music_ontology', 'http://motools.sourceforge.net/doc/musicontology.n3')