Difference between revisions of "Project:MakingSense"

From Wikibase Personal data
Jump to navigation Jump to search
Line 34: Line 34:
  
 
== topics ==
 
== topics ==
−
* [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 ?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}} concerns e-commerce trade agreement]
 
* [{{PredicateValue|predicate=P110|value=Q1740}} concerns e-commerce trade agreement]
 
* [{{PredicateValue|predicate=P11|value=Q1740}} interested in e-commerce trade agreement]
 
* [{{PredicateValue|predicate=P11|value=Q1740}} interested in e-commerce trade agreement]
 
* [{{PredicateValue|predicate=P3|value=Q1740}} instance of e-commerce trade agreement]
 
* [{{PredicateValue|predicate=P3|value=Q1740}} instance of e-commerce trade agreement]
−
* [https://tinyurl.com/wlk4c6n shapley values]
 
−
* [https://tinyurl.com/uypl324 REACH regulation]
 
  
 
== data models ==
 
== data models ==

Revision as of 08:28, 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

Try it (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

Try it (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

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