Difference between revisions of "Project:MakingSense"

From Wikibase Personal data
Jump to navigation Jump to search
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
This project is aimed at Making more Sense of the data we already have in the database. It is a curation project.
 +
 
== How? ==
 
== How? ==
 
* visualizations
 
* visualizations
Line 5: Line 7:
  
 
== Low-level ==
 
== Low-level ==
−
1. find the highest level concepts in the db
+
# find the highest level concepts in the db
−
2. find the entries that don't fit into any class, fix
+
# 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)
+
# add "interested in", "topic", etc to all the instances of a class (after visualization of top such entries for each class)
 +
 
 +
== Oversight ==
 +
 
 +
 
 +
== Useful queries ==
 +
*
 +
{{SPARQL|query=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" .
 +
  }
 +
}|label=interesting datasets and their licenses}}
 +
*
 +
{{SPARQL|query=
 +
SELECT ?item ?itemLabel ?class ?classLabel WHERE
 +
{
 +
  ?item pdiot:P4 ?class
 +
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 +
}|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}}
 +
 
 +
== 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}}
 +
{{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"