Difference between revisions of "Project:MakingSense"

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

find the highest level concepts in the db
find the entries that don't fit into any class, fix
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)

@@ Line 23: / Line 23: @@
     bd:serviceParam wikibase:language "en" .
    }
-}|interesting datasets and their licenses}}
+}|label=interesting datasets and their licenses}}
 *
 {{SPARQL|query=
@@ Line 30: / Line 30: @@
     ?item pdiot:P4 ?class
     SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
-}|classes and instances}}
+}|label=classes and instances}}
+== Topics ==
+{{SPARQL|query=
+SELECT ?item ?itemLabel ?interest ?interestLabel WHERE {
+  ?item pdiot:P110 ?interest.
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
+}|label="?item concerns ?concern"}}
+{{SPARQL|query=
+SELECT ?item ?itemLabel ?interest ?interestLabel WHERE {
+  ?item pdiot:P11 ?interest.
+  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
+}|label="?item interested in ?interest"}}
+{{SPARQL|query=
+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" . }
+}
+|label=shapley values}}
+{{SPARQL|query=
+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" . }
+}
+|label=REACH regulation}}
+{{PredicateValue|predicate=P110|value=Q1740|label=concerns e-commerce trade agreement}}
+{{PredicateValue|predicate=P11|value=Q1740|label=interested in e-commerce trade agreement}}
+{{PredicateValue|predicate=P3|value=Q1740|label=instance of e-commerce trade agreement}}
-== topics ==
+== data models ==
-* [https://query.personaldata.io/index.html#PREFIX%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%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Finterest%20%3FinterestLabel%20WHERE%20%7B%0A%20%20%3Fitem%20pdiot%3AP110%20%3Finterest.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%0A%20%20%7D%20%20%0AOPTIONAL%20%7B%20%3Fitem%20pdiot%3AP47%20%3F_image.%20%7D%0A%7D%0A "?item concerns ?concern"]
+{{SPARQL|query=
-* [https://query.personaldata.io/index.html#PREFIX%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%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Finterest%20%3FinterestLabel%20WHERE%20%7B%0A%20%20%3Fitem%20pdiot%3AP11%20%3Finterest.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%0A%20%20%7D%20%20%0AOPTIONAL%20%7B%20%3Fitem%20pdiot%3AP47%20%3F_image.%20%7D%0A%7D%0A "?item interested in ?interest"]
+SELECT ?domain ?domainLabel ?range ?rangeLabel ?edgeLabel WHERE
-* [{{PredicateValue|predicate=P110|value=Q1740}} concerns e-commerce trade agreement]
+{
-* [{{PredicateValue|predicate=P11|value=Q1740}} interested in e-commerce trade agreement]
+  BIND(?value as ?edge)
-* [{{PredicateValue|predicate=P3|value=Q1740}} instance of e-commerce trade agreement]
+  pdio:Q435 pdiop:P6 ?prop.
-* [https://tinyurl.com/wlk4c6n shapley values]
+  ?prop pdiops:P6 ?value.
-* [https://tinyurl.com/uypl324 REACH regulation]
+  ?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}}
-== data models ==
+== linking to wikidata ==
-* [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%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]

Difference between revisions of "Project:MakingSense"

Latest revision as of 01:38, 11 February 2020

Contents

How?

Low-level

Oversight

Useful queries

Topics

data models

linking to wikidata

Navigation menu

Search