Difference between revisions of "Project:MakingSense"
Jump to navigation
Jump to search
(→topics) |
|||
(6 intermediate revisions by the same user not shown) | |||
Line 97: | Line 97: | ||
} | } | ||
|label=website tracking}} | |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
- 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 (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". }
}
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". }
}
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". }
}