Difference between revisions of "Project:MakingSense"

From Wikibase Personal data
Jump to navigation Jump to search
Line 64: Line 64:
  
 
== data models ==
 
== data models ==
 +
* {{SPARQL|query=
 +
SELECT ?domain ?domainLabel ?range ?rangeLabel ?edgeLabel WHERE
 +
{
 +
  BIND(?value as ?edge)
 +
  pdio:Q435 pdiop:P6 ?prop.
 +
  ?prop pdiops:P6 ?value.
 +
  ?prop pdiopq:P24 ?domain.
 +
  ?prop pdiopq:P23 ?range.
 +
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 +
}
 +
|label=mobile apps}}
 
* [https://query.personaldata.io/#%23defaultView%3AGraph%0APREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20p%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2F%3E%0APREFIX%20pq%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fqualifier%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX%20bd%3A%20%3Chttp%3A%2F%2Fwww.bigdata.com%2Frdf%23%3E%0A%0APREFIX%20pdio%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%3E%0APREFIX%20pdiot%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fdirect%2F%3E%0APREFIX%20pdiop%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2F%3E%0APREFIX%20pdiops%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fstatement%2F%3E%0APREFIX%20pdiopq%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fqualifier%2F%3E%0A%0ASELECT%20%3Fdomain%20%3FdomainLabel%20%3Frange%20%3FrangeLabel%20%3FedgeLabel%20WHERE%0A%7B%0A%20%20BIND%28%3Fvalue%20as%20%3Fedge%29%0A%20%20pdio%3AQ435%20pdiop%3AP6%20%3Fprop.%0A%20%20%3Fprop%20pdiops%3AP6%20%3Fvalue.%0A%20%20%3Fprop%20pdiopq%3AP24%20%3Fdomain.%0A%20%20%3Fprop%20pdiopq%3AP23%20%3Frange.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D mobile apps]
 
* [https://query.personaldata.io/#%23defaultView%3AGraph%0APREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20p%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2F%3E%0APREFIX%20pq%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fqualifier%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX%20bd%3A%20%3Chttp%3A%2F%2Fwww.bigdata.com%2Frdf%23%3E%0A%0APREFIX%20pdio%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%3E%0APREFIX%20pdiot%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fdirect%2F%3E%0APREFIX%20pdiop%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2F%3E%0APREFIX%20pdiops%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fstatement%2F%3E%0APREFIX%20pdiopq%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fqualifier%2F%3E%0A%0ASELECT%20%3Fdomain%20%3FdomainLabel%20%3Frange%20%3FrangeLabel%20%3FedgeLabel%20WHERE%0A%7B%0A%20%20BIND%28%3Fvalue%20as%20%3Fedge%29%0A%20%20pdio%3AQ435%20pdiop%3AP6%20%3Fprop.%0A%20%20%3Fprop%20pdiops%3AP6%20%3Fvalue.%0A%20%20%3Fprop%20pdiopq%3AP24%20%3Fdomain.%0A%20%20%3Fprop%20pdiopq%3AP23%20%3Frange.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D mobile apps]
 
* [https://query.personaldata.io/#%23defaultView%3AGraph%0APREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20p%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2F%3E%0APREFIX%20pq%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fqualifier%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX%20bd%3A%20%3Chttp%3A%2F%2Fwww.bigdata.com%2Frdf%23%3E%0A%0APREFIX%20pdio%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%3E%0APREFIX%20pdiot%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fdirect%2F%3E%0APREFIX%20pdiop%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2F%3E%0APREFIX%20pdiops%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fstatement%2F%3E%0APREFIX%20pdiopq%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fqualifier%2F%3E%0A%0ASELECT%20%3Fdomain%20%3FdomainLabel%20%3Frange%20%3FrangeLabel%20%3FedgeLabel%20WHERE%0A%7B%0A%20%20BIND%28%3Fvalue%20as%20%3Fedge%29%0A%20%20pdio%3AQ88%20pdiop%3AP6%20%3Fprop.%0A%20%20%3Fprop%20pdiops%3AP6%20%3Fvalue.%0A%20%20%3Fprop%20pdiopq%3AP24%20%3Fdomain.%0A%20%20%3Fprop%20pdiopq%3AP23%20%3Frange.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D whole ecosytem]
 
* [https://query.personaldata.io/#%23defaultView%3AGraph%0APREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20p%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2F%3E%0APREFIX%20pq%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fqualifier%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX%20bd%3A%20%3Chttp%3A%2F%2Fwww.bigdata.com%2Frdf%23%3E%0A%0APREFIX%20pdio%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%3E%0APREFIX%20pdiot%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fdirect%2F%3E%0APREFIX%20pdiop%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2F%3E%0APREFIX%20pdiops%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fstatement%2F%3E%0APREFIX%20pdiopq%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fqualifier%2F%3E%0A%0ASELECT%20%3Fdomain%20%3FdomainLabel%20%3Frange%20%3FrangeLabel%20%3FedgeLabel%20WHERE%0A%7B%0A%20%20BIND%28%3Fvalue%20as%20%3Fedge%29%0A%20%20pdio%3AQ88%20pdiop%3AP6%20%3Fprop.%0A%20%20%3Fprop%20pdiops%3AP6%20%3Fvalue.%0A%20%20%3Fprop%20pdiopq%3AP24%20%3Fdomain.%0A%20%20%3Fprop%20pdiopq%3AP23%20%3Frange.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D whole ecosytem]
 
* [https://query.personaldata.io/#%23defaultView%3AGraph%0APREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20p%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2F%3E%0APREFIX%20pq%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fqualifier%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX%20bd%3A%20%3Chttp%3A%2F%2Fwww.bigdata.com%2Frdf%23%3E%0A%0APREFIX%20pdio%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%3E%0APREFIX%20pdiot%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fdirect%2F%3E%0APREFIX%20pdiop%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2F%3E%0APREFIX%20pdiops%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fstatement%2F%3E%0APREFIX%20pdiopq%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fqualifier%2F%3E%0A%0ASELECT%20%3Fdomain%20%3FdomainLabel%20%3Frange%20%3FrangeLabel%20%3FedgeLabel%20WHERE%0A%7B%0A%20%20BIND%28%3Fvalue%20as%20%3Fedge%29%0A%20%20pdio%3AQ440%20pdiop%3AP6%20%3Fprop.%0A%20%20%3Fprop%20pdiops%3AP6%20%3Fvalue.%0A%20%20%3Fprop%20pdiopq%3AP24%20%3Fdomain.%0A%20%20%3Fprop%20pdiopq%3AP23%20%3Frange.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D website tracking]
 
* [https://query.personaldata.io/#%23defaultView%3AGraph%0APREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20p%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2F%3E%0APREFIX%20pq%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fqualifier%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX%20bd%3A%20%3Chttp%3A%2F%2Fwww.bigdata.com%2Frdf%23%3E%0A%0APREFIX%20pdio%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%3E%0APREFIX%20pdiot%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fdirect%2F%3E%0APREFIX%20pdiop%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2F%3E%0APREFIX%20pdiops%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fstatement%2F%3E%0APREFIX%20pdiopq%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fqualifier%2F%3E%0A%0ASELECT%20%3Fdomain%20%3FdomainLabel%20%3Frange%20%3FrangeLabel%20%3FedgeLabel%20WHERE%0A%7B%0A%20%20BIND%28%3Fvalue%20as%20%3Fedge%29%0A%20%20pdio%3AQ440%20pdiop%3AP6%20%3Fprop.%0A%20%20%3Fprop%20pdiops%3AP6%20%3Fvalue.%0A%20%20%3Fprop%20pdiopq%3AP24%20%3Fdomain.%0A%20%20%3Fprop%20pdiopq%3AP23%20%3Frange.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D website tracking]

Revision as of 08:29, 19 December 2019

This project is aimed at Making more Sense of the data we already have in the database. It is a curation project.

How?

  • visualizations
  • prioritization of coverage
  • define contribution pipelines (how will my work be picked up by someone else?)

Low-level

  1. find the highest level concepts in the db
  2. find the entries that don't fit into any class, fix
  3. add "interested in", "topic", etc to all the instances of a class (after visualization of top such entries for each class)

Oversight

Useful queries

PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel ?website ?licenseLabel WHERE {
  ?item pdiot:P3 pdio:Q33.
  OPTIONAL {?item pdiot:P15 ?website}.
  OPTIONAL {?item pdiot:P13 ?license}.
  SERVICE wikibase:label {
   bd:serviceParam wikibase:language "en" . 
  }
}

interesting datasets and their licenses (embedded)

PREFIX pdio: <https://wiki.personaldata.io/entity/>
PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
PREFIX pdiop: <https://wiki.personaldata.io/prop/>
PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
SELECT ?item ?itemLabel ?class ?classLabel WHERE
{
   ?item pdiot:P4 ?class
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

classes and instances (embedded)


topics

  • PREFIX pdio: <https://wiki.personaldata.io/entity/>
    PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
    PREFIX pdiop: <https://wiki.personaldata.io/prop/>
    PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
    PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
    SELECT ?item ?itemLabel ?interest ?interestLabel WHERE {
      ?item pdiot:P110 ?interest.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
    }
    

"?item concerns ?concern" (embedded)

  • PREFIX pdio: <https://wiki.personaldata.io/entity/>
    PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
    PREFIX pdiop: <https://wiki.personaldata.io/prop/>
    PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
    PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
    SELECT ?item ?itemLabel ?interest ?interestLabel WHERE {
      ?item pdiot:P11 ?interest.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
    }
    

"?item interested in ?interest" (embedded)

  • PREFIX pdio: <https://wiki.personaldata.io/entity/>
    PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
    PREFIX pdiop: <https://wiki.personaldata.io/prop/>
    PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
    PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
    SELECT ?item ?itemLabel ?web WHERE {
      ?item pdiot:P3 pdio:Q210.
      ?item pdiot:P110 pdio:Q2117.
      ?item pdiot:P15 ?web
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }  
    }
    

shapley values (embedded)

  • PREFIX pdio: <https://wiki.personaldata.io/entity/>
    PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
    PREFIX pdiop: <https://wiki.personaldata.io/prop/>
    PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
    PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
    SELECT ?item ?itemLabel ?web WHERE {
      ?item pdiot:P3 pdio:Q210.
      ?item pdiot:P110 pdio:Q2119.
      ?item pdiot:P15 ?web
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }  
    }
    

REACH regulation (embedded)

  • [
    PREFIX pdio: <https://wiki.personaldata.io/entity/>
    PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
    PREFIX pdiop: <https://wiki.personaldata.io/prop/>
    PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
    PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
    SELECT ?item ?itemLabel WHERE {
      ?item pdiot:P110 pdio:Q1740.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }  
    }
    

{{{label}}} (embedded)

concerns e-commerce trade agreement]
  • [
    PREFIX pdio: <https://wiki.personaldata.io/entity/>
    PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
    PREFIX pdiop: <https://wiki.personaldata.io/prop/>
    PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
    PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
    SELECT ?item ?itemLabel WHERE {
      ?item pdiot:P11 pdio:Q1740.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }  
    }
    

{{{label}}} (embedded)

interested in e-commerce trade agreement]
  • [
    PREFIX pdio: <https://wiki.personaldata.io/entity/>
    PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
    PREFIX pdiop: <https://wiki.personaldata.io/prop/>
    PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
    PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
    SELECT ?item ?itemLabel WHERE {
      ?item pdiot:P3 pdio:Q1740.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }  
    }
    

{{{label}}} (embedded)

instance of e-commerce trade agreement]

data models

  • PREFIX pdio: <https://wiki.personaldata.io/entity/>
    PREFIX pdiot: <https://wiki.personaldata.io/prop/direct/>
    PREFIX pdiop: <https://wiki.personaldata.io/prop/>
    PREFIX pdiops: <https://wiki.personaldata.io/prop/statement/>
    PREFIX pdiopq: <https://wiki.personaldata.io/prop/qualifier/>
    SELECT ?domain ?domainLabel ?range ?rangeLabel ?edgeLabel WHERE
    {
      BIND(?value as ?edge)
      pdio:Q435 pdiop:P6 ?prop.
      ?prop pdiops:P6 ?value.
      ?prop pdiopq:P24 ?domain.
      ?prop pdiopq:P23 ?range.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    }
    

mobile apps (embedded)