Difference between revisions of "Project:MakingSense"
Jump to navigation
Jump to search
Line 10: | Line 10: | ||
# find the entries that don't fit into any class, fix | # 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) | # 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" . | ||
+ | } | ||
+ | }|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". } | ||
+ | }|classes and instances}} | ||
+ | |||
+ | |||
+ | == 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"] | ||
+ | * [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"] | ||
+ | * [{{PredicateValue|predicate=P110|value=Q1740}} concerns 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] | ||
+ | * [https://tinyurl.com/wlk4c6n shapley values] | ||
+ | * [https://tinyurl.com/uypl324 REACH regulation] | ||
+ | |||
+ | == data models == | ||
+ | * [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] |
Revision as of 08:24, 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
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
topics
- "?item concerns ?concern"
- "?item interested in ?interest"
- [
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]