Project:MyData/Finland/Mapping/Results
From Wikibase Personal data
Jump to navigation
Jump to search
Expand
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/>
#defaultView:Graph
SELECT ?item1 ?item1Label ?rgb ?item2 ?item2Label
WITH {
SELECT ?predicateFilterValue ?predicateFilterValueRGB WHERE {
VALUES (?predicateFilterValue ?predicateFilterValueRGB) {
(pdio:Q401 "EEEEEE")(pdio:Q646 "222288")
}
}
}
AS %predicateFilterValues
WITH {
SELECT ?predicate ?subjectValue ?objectValue ?predicateRGB WHERE {
VALUES (?predicate ?subjectValue ?objectValue ?predicateRGB) {
(pdiot:P111 pdio:Q401 pdio:Q646 "EEEEEE")(pdiot:P111 pdio:Q646 pdio:Q401 "222288")
}
}
}
AS %predicates
WITH {SELECT ?node ?nodeRGB WHERE {
?node pdiot:P55 pdio:Q564.
?node pdiot:P3 ?predicateFilterValue.
INCLUDE %predicateFilterValues.
BIND(?predicateFilterValueRGB AS ?nodeRGB)
}
}
AS %nodes
WITH {SELECT ?subject ?object ?edgeRGB WHERE {
INCLUDE %predicates.
?subject pdiot:P3 ?subjectValue.
?object pdiot:P3 ?objectValue.
?subject ?predicate ?object.
# This is filtering for each edge twice, potentially a huge waste: |E|*|V| instead of |V|
?subject pdiot:P55 pdio:Q564.
?object pdiot:P55 pdio:Q564.
BIND(?predicateRGB as ?edgeRGB)
}
} AS %edges
WHERE {
{
INCLUDE %nodes.
BIND(?node AS ?item1).
BIND(?nodeRGB AS ?rgb).
}
UNION
{
INCLUDE %edges.
BIND(?subject AS ?item1).
BIND(?object AS ?item2).
BIND(?edgeRGB AS ?rgb).
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
LIMIT 10000
MyData/Finland ecosystem mapping (embedded)
Expand
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 ?str_item ?itemLabel WHERE {
BIND(REPLACE(STR(?item),"http://wiki.personaldata.io/entity/","") AS ?str_item)
?item pdiot:P3 pdio:Q401.
?item pdiot:P55 pdio:Q564.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
LIMIT 100
organizations in Finland (embedded)
Expand
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 ?str_item ?itemLabel ?country ?countryLabel ?class ?classLabel WHERE {
BIND(REPLACE(STR(?item),"http://wiki.personaldata.io/entity/","") AS ?str_item)
BIND(pdio:Q564 AS ?country)
BIND(pdio:Q646 AS ?class)
?item pdiot:P3 ?class.
?item pdiot:P55 ?country.
# Label service, produces ?xxxLabel and ?xxxDescription above
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
LIMIT 100
data operators project in Finland (embedded)
Expand
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 ?operator ?operatorLabel ?rgb ?project ?projectLabel ?projectColor
WITH {SELECT ?operator ?operatorClass ?operatorColor WHERE {
BIND(?class AS ?operatorClass)
BIND("FFA500" AS ?operatorColor)
BIND(?item AS ?operator)
BIND(pdio:Q564 AS ?country)
BIND(pdio:Q401 AS ?class)
?item pdiot:P3 ?class.
?item pdiot:P55 ?country.
}
}
AS %operator
WITH {SELECT ?project ?projectClass ?projectColor WHERE {
BIND(?class AS ?projectClass)
BIND("500" AS ?projectColor)
BIND(?item AS ?project)
BIND(pdio:Q564 AS ?country)
BIND(pdio:Q646 AS ?class)
?item pdiot:P3 ?class.
?item pdiot:P55 ?country.
}
}
AS %project
WHERE {
BIND(?operatorColor AS ?rgb)
{
INCLUDE %operator.
INCLUDE %project.
?project pdiot:P111 ?operator
}
UNION
{
INCLUDE %operator.
}
UNION
{
INCLUDE %project.
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
LIMIT 10000
first attempt, kept for historic reasons (embedded)
Expand
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 DISTINCT ?operator ?operatorLabel ?project ?projectLabel
WHERE {
{
?operator pdiot:P3 pdio:Q401.
OPTIONAL {?project pdiot:P111 ?operator}
OPTIONAL {?project pdiot:P111 ?operator}
?operator pdiot:P55 pdio:Q564.
}
UNION
{
?project pdiot:P3 pdio:Q646.
OPTIONAL {?project pdiot:P111 ?operator}
OPTIONAL {?project pdiot:P111 ?operator}
?project pdiot:P55 pdio:Q564.
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
LIMIT 10000