Difference between revisions of "Project:MakingSense"

From Wikibase Personal data
Jump to navigation Jump to search
 
(10 intermediate revisions by the same user not shown)
Line 32: Line 32:
 
}|label=classes and instances}}
 
}|label=classes and instances}}
  
−
== topics ==
+
== Topics ==
−
*{{SPARQL|query=
+
{{SPARQL|query=
 
SELECT ?item ?itemLabel ?interest ?interestLabel WHERE {
 
SELECT ?item ?itemLabel ?interest ?interestLabel WHERE {
 
   ?item pdiot:P110 ?interest.
 
   ?item pdiot:P110 ?interest.
 
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
 
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
 
}|label="?item concerns ?concern"}}
 
}|label="?item concerns ?concern"}}
−
*{{SPARQL|query=
+
{{SPARQL|query=
 
SELECT ?item ?itemLabel ?interest ?interestLabel WHERE {
 
SELECT ?item ?itemLabel ?interest ?interestLabel WHERE {
 
   ?item pdiot:P11 ?interest.
 
   ?item pdiot:P11 ?interest.
 
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
 
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
 
}|label="?item interested in ?interest"}}
 
}|label="?item interested in ?interest"}}
−
*{{SPARQL|query=
+
{{SPARQL|query=
 
SELECT ?item ?itemLabel ?web WHERE {
 
SELECT ?item ?itemLabel ?web WHERE {
 
   ?item pdiot:P3 pdio:Q210.
 
   ?item pdiot:P3 pdio:Q210.
Line 51: Line 51:
 
}
 
}
 
|label=shapley values}}
 
|label=shapley values}}
−
*{{SPARQL|query=
+
{{SPARQL|query=
 
SELECT ?item ?itemLabel ?web WHERE {
 
SELECT ?item ?itemLabel ?web WHERE {
 
   ?item pdiot:P3 pdio:Q210.
 
   ?item pdiot:P3 pdio:Q210.
Line 59: Line 59:
 
}
 
}
 
|label=REACH regulation}}
 
|label=REACH regulation}}
−
* [{{PredicateValue|predicate=P110|value=Q1740}} concerns e-commerce trade agreement]
+
{{PredicateValue|predicate=P110|value=Q1740|label=concerns e-commerce trade agreement}}
−
* [{{PredicateValue|predicate=P11|value=Q1740}} interested in e-commerce trade agreement]
+
{{PredicateValue|predicate=P11|value=Q1740|label=interested in e-commerce trade agreement}}
−
* [{{PredicateValue|predicate=P3|value=Q1740}} instance of e-commerce trade agreement]
+
{{PredicateValue|predicate=P3|value=Q1740|label=instance of e-commerce trade agreement}}
  
 
== data models ==
 
== data models ==
−
* [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]
+
{{SPARQL|query=
−
* [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]
+
SELECT ?domain ?domainLabel ?range ?rangeLabel ?edgeLabel WHERE
−
* [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]
+
{
 +
  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}}
 +
{{SPARQL|query=
 +
SELECT ?domain ?domainLabel ?range ?rangeLabel ?edgeLabel WHERE
 +
{
 +
  BIND(?value as ?edge)
 +
  pdio:Q88 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=whole ecosystem}}
 +
{{SPARQL|query=
 +
SELECT ?domain ?domainLabel ?range ?rangeLabel ?edgeLabel WHERE
 +
{
 +
  BIND(?value as ?edge)
 +
  pdio:Q440 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=website tracking}}
 +
 
 +
== linking to wikidata ==

Latest revision as of 01:38, 11 February 2020

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" . }  
}

concerns e-commerce trade agreement (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:P11 pdio:Q1740.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }  
}

interested in e-commerce trade agreement (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:P3 pdio:Q1740.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }  
}

instance of e-commerce trade agreement (embedded)


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) 

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:Q88 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". }
}

whole ecosystem (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 ?domain ?domainLabel ?range ?rangeLabel ?edgeLabel WHERE
{
  BIND(?value as ?edge)
  pdio:Q440 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". }
}

website tracking (embedded)


linking to wikidata

Retrieved from "https://wiki.personaldata.io/w/index.php?title=Project:MakingSense&oldid=79992"