728 Matching Annotations
  1. Nov 2023
  2. Oct 2023
    1. Federated SPARQL Query, incorporating data from both DBpedia & Wikidata

      ```sparql PREFIX wd: http://www.wikidata.org/entity/ PREFIX wdt: http://www.wikidata.org/prop/direct/ PREFIX wikibase: http://wikiba.se/ontology# PREFIX p: http://www.wikidata.org/prop/ PREFIX ps: http://www.wikidata.org/prop/statement/ PREFIX pq: http://www.wikidata.org/prop/qualifier/ PREFIX bd: http://www.bigdata.com/rdf# PREFIX owl: http://www.w3.org/2002/07/owl# PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema# PREFIX foaf: http://xmlns.com/foaf/0.1/ PREFIX dct: http://purl.org/dc/terms/SELECT DISTINCT ?dbpediaID AS ?href xsd:string(?label) AS ?name ?description ?subjectText ?item AS ?wikidataID ?dbpediaID ?image ?picture WHERE { SERVICE http://query.wikidata.org/sparql { SELECT DISTINCT ?item ?itemLabel ?numero ( SAMPLE(?pic) AS ?picture ) WHERE { ?item p:P528 ?catalogStatement . ?catalogStatement ps:P528 ?numero . ?catalogStatement pq:P972 wd:Q14530 . OPTIONAL { ?item wdt:P18 ?pic } . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } GROUP BY ?item ?itemLabel ?numero ORDER BY ?numero }

      SERVICE <http://dbpedia.org/sparql>
        { 
          SELECT ?item
                 ?dbpediaID
                 ?label
                 ?image
                 ?description
                 ?subjectText
          FROM  <http://dbpedia.org> 
          WHERE
            {
              ?dbpediaID  owl:sameAs      ?item ; 
                          rdfs:label      ?label ; 
                          foaf:depiction  ?image ;
                          rdfs:comment    ?description ;
                          dct:subject
                            [ rdfs:label  ?subjectText ] .
              FILTER ( LANG(?label) = "en" ) 
              FILTER ( LANG(?description) = "en" ) 
            }
        }
      

      } ```

  3. Sep 2023
  4. Aug 2023
  5. Jul 2023
  6. Jun 2023
    1. There are many different types of controlled vocabularies, the most common among them are: Thesaurus - a type of controlled vocabulary used in information systems that organizes concepts in hierarchical and/or associative relationships and provides their semantic definitions Classification schema - a system that based primarily on classifying things or concepts into groups or classes with a detailed explanation of those classification methods Subject heading list - a list of terms describing subjects in information system Taxonomy - a system that organizes things and concepts in groups based on their common characteristics and/or differences Terminology - a list of terms used to describe concepts in a certain domain Glossary - an alphabetical list of terms with their explanation used in a specific context
  7. May 2023
    1. ```php

      $record) { if ($name<>"count" and $name<>"specials") { foreach ($record["site"] as $sitelink) { $site[$sitelink["dbname"]]=$sitelink["url"]; } } if ($name==="specials") { foreach ($record as $sitelink) { $site[$sitelink["dbname"]]=$sitelink["url"]; } } } /* Open files */ $fp = fopen('data/'.$entity_proc.'.ttl', 'w'); fwrite($fp, "@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .\n"); fwrite($fp, "@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .\n"); fwrite($fp, "@prefix skos: <http://www.w3.org/2004/02/skos/core#> .\n"); fwrite($fp, "@prefix wd: <http://www.wikidata.org/entity/> .\n"); fwrite($fp, "@prefix wdt: <http://www.wikidata.org/prop/direct/> .\n"); fwrite($fp,"\n"); fwrite($fp,"<http://www.wikidata.org/categories> rdf:type skos:ConceptScheme ;\n"); fwrite($fp," skos:prefLabel \"Wikidata categories\"@en .\n\n"); // echo $list_entities."\n"; $url = "https://www.wikidata.org/w/api.php?action=wbgetentities&ids=".$entity_proc."&props=labels|aliases|sitelinks&format=php&utf8="; $a = unserialize(file_get_contents($url)); foreach ($a["entities"] as $entity=>$data_entity) { fwrite($fp,"wd:".$entity." rdf:type skos:Concept ;\n"); fwrite($fp," skos:inScheme <http://www.wikidata.org/categories> "); if (isset($data_entity["labels"])) { foreach ($data_entity["labels"] as $label) { fwrite($fp,";\n skos:prefLabel \"".$label["value"]."\"@".$label["language"]." "); } } if (isset($data_entity["aliases"])) { foreach ($data_entity["aliases"] as $item) { foreach ($item as $label) { fwrite($fp,";\n skos:altLabel> \"".$label["value"]."\"@".$label["language"]." "); } } } foreach ($data_entity["sitelinks"] as $item) { if (in_array($item["site"],$array_sources)) { /* GET BROADER CATEGORIES */ $repeat_query=true; $cmcontinue=""; while ($repeat_query==true) { $repeat_query = false; $url_wiki = $site[$item["site"]]."/w/api.php?action=query&generator=categories&titles=".urlencode($item["title"])."&prop=pageprops|categoryinfo&format=php&utf8=".$cmcontinue; $b = unserialize(file_get_contents($url_wiki)); if (isset($b["continue"]["cmcontinue"])) { $repeat_query = true; $cmcontinue = $b["continue"]["cmcontinue"]; } if (isset($b["query"]["pages"])) { foreach ($b["query"]["pages"] as $broadcat) { if (isset($broadcat["pageprops"]["wikibase_item"])) { if (!isset($broader[$broadcat["pageprops"]["wikibase_item"]])) {$broader[$broadcat["pageprops"]["wikibase_item"]]=$broadcat["title"];} // fwrite($fp,"<http://www.wikidata.org/entity/".$entity_proc."> <http://www.w3.org/2004/02/skos/core#broader> <http://www.wikidata.org/entity/".$broadcat["pageprops"]["wikibase_item"]."> <http://www.wikidata.org/categories/".$item["site"]."> .\n"); } } } } /* GET NARROWER CATEGORIES */ $repeat_query=true; $cmcontinue=""; while ($repeat_query==true) { $repeat_query = false; $url_wiki = $site[$item["site"]]."/w/api.php?action=query&generator=categorymembers&gcmtitle=".urlencode($item["title"])."&gcmtype=subcat&prop=pageprops|categoryinfo&format=php&utf8=".$cmcontinue; $b = unserialize(file_get_contents($url_wiki)); if (isset($b["continue"]["cmcontinue"])) { $repeat_query = true; $cmcontinue = $b["continue"]["cmcontinue"]; } if (isset($b["query"]["pages"])) { foreach ($b["query"]["pages"] as $narrowcat) { if (isset($narrowcat["pageprops"]["wikibase_item"])) { if (!isset($narrower[$narrowcat["pageprops"]["wikibase_item"]]) or $item["site"]=="enwiki") {$narrower[$narrowcat["pageprops"]["wikibase_item"]]=$narrowcat["title"];} // fwrite($fp,"<http://www.wikidata.org/entity/".$entity_proc."> <http://www.w3.org/2004/02/skos/core#narrower> <http://www.wikidata.org/entity/".$narrowcat["pageprops"]["wikibase_item"]."> <http://www.wikidata.org/categories/".$item["site"]."> .\n"); } } } } } } } $prevalue=""; foreach ($broader as $target=>$value) { fwrite($fp,";".$prevalue."\n skos:broader wd:".$target); $prevalue=" # ".$value; } if ($prevalue!=="") {fwrite($fp,$prevalue);} $prevalue=""; foreach ($narrower as $target=>$value) { fwrite($fp,";".$prevalue."\n skos:narrower wd:".$target); $prevalue=" # ".$value; } if ($prevalue!=="") {fwrite($fp,$prevalue);} fwrite($fp,".\n\n"); fclose($fp); ?>

      ```