Difference between revisions of "Project:MakingSense"

From Wikibase Personal data
Jump to navigation Jump to search
Line 103: Line 103:
  
 
{{SPARQL|query=
 
{{SPARQL|query=
SELECT ?class ?classLabel ?wikidataQid ?property ?propertyLabel WHERE {
+
SELECT ?class ?classLabel ?wikidataQid ?property ?propertyLabel ?wikidataPid WHERE {
 
   ?class pdiot:P291 ?property.
 
   ?class pdiot:P291 ?property.
 
   OPTIONAL {?class pdiot:P103 ?wikidataQid}
 
   OPTIONAL {?class pdiot:P103 ?wikidataQid}
 +
  OPTIONAL {?property pdiot:P104 ?wikidataPid}
 
   SERVICE wikibase:label {
 
   SERVICE wikibase:label {
 
     bd:serviceParam wikibase:language "en" .  
 
     bd:serviceParam wikibase:language "en" .  

Revision as of 00:48, 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

defining properties for a type

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 ?class ?classLabel ?wikidataQid ?property ?propertyLabel ?wikidataPid WHERE {
  ?class pdiot:P291 ?property.
  OPTIONAL {?class pdiot:P103 ?wikidataQid}
  OPTIONAL {?property pdiot:P104 ?wikidataPid}
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" . 
  }  
}
ORDER BY ASC(?classLabel)
LIMIT 100

expected properties (embedded)