Difference between revisions of "Project:MakingSense"
Jump to navigation
Jump to search
Line 64: | Line 64: | ||
== data models == | == 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}} | ||
* [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%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%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] | * [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] |
Revision as of 08:29, 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
- 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" . } }
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" . } }
- [
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]
- [
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]
- [
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]
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". } }