Difference between revisions of "Project:MyData/Visualizations"
Jump to navigation
Jump to search
Line 45: | Line 45: | ||
OPTIONAL { ?item pdiot:P55 ?country. } | OPTIONAL { ?item pdiot:P55 ?country. } | ||
OPTIONAL { ?item pdiot:P80 ?location. } } }} | OPTIONAL { ?item pdiot:P80 ?location. } } }} | ||
+ | |||
+ | |||
+ | == Hub initiators meeting work == | ||
+ | {{SPARQL|query=#defaultView:Graph | ||
+ | SELECT ?item ?itemLabel ?object ?objectLabel ?edgeLabel WHERE { | ||
+ | ?item ?rel ?object. | ||
+ | ?edge wikibase:directClaim ?rel. | ||
+ | ?item pdiot:P3 pdio:Q47. | ||
+ | MINUS {pdio:P3 wikibase:directClaim ?rel} | ||
+ | ?edge wikibase:propertyType wikibase:WikibaseItem #If we don't remove this, then those properties pointing to non-item labels mess everything up | ||
+ | |||
+ | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
+ | } | ||
+ | LIMIT 1000 | ||
+ | |state={{{state}}} | ||
+ | |label=Hub Initiators meeting map}} | ||
+ | |||
+ | {{SPARQL|query=SELECT ?item ?itemLabel ?edgeLabel ?object ?objectLabel WHERE { | ||
+ | ?item ?rel ?object. | ||
+ | ?edge wikibase:directClaim ?rel. | ||
+ | ?item pdiot:P3 pdio:Q47. | ||
+ | MINUS {pdio:P3 wikibase:directClaim ?rel} | ||
+ | |||
+ | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
+ | } | ||
+ | LIMIT 1000 | ||
+ | |label=full triple table of Hub initiators meeting | ||
+ | |state={{{state}}}}} |
Revision as of 23:28, 26 January 2020
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 ?node ?nodeLabel ?value ?valueLabel ?edgeLabel
(IF(BOUND(?edge), ?propertyrgb, "FFFFFF") AS ?rgb) #white
{
VALUES (?propertyRel ?propertyrgb)
{
(pdiot:P57 "880000") # red - activity
(pdiot:P55 "00AA00") # light green - country
(pdiot:P137 "0000AA") # blue - partner
(pdiot:P145 "AA00AA") # pink - seeks
}
pdio:Q49 pdiot:P63 ?node.
OPTIONAL
{
?node ?propertyRel ?value.
?edge wikibase:directClaim ?propertyRel.
}.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
- personal data ecosystem maps
- personal data tools ecosystem map
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 ?country ?countryLabel WHERE {
?item pdiot:P3 pdio:Q646.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
OPTIONAL { ?item pdiot:P55 ?country. }
}
data operators around the world (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 ?country ?countryLabel ?location ?locationLabel WHERE {
?item pdiot:P3 pdio:Q401.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
OPTIONAL { ?item pdiot:P55 ?country. }
OPTIONAL { ?item pdiot:P80 ?location. } }
associations, with country and location (embedded)
Hub initiators meeting work
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 ?item ?itemLabel ?object ?objectLabel ?edgeLabel WHERE {
?item ?rel ?object.
?edge wikibase:directClaim ?rel.
?item pdiot:P3 pdio:Q47.
MINUS {pdio:P3 wikibase:directClaim ?rel}
?edge wikibase:propertyType wikibase:WikibaseItem #If we don't remove this, then those properties pointing to non-item labels mess everything up
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 1000
Hub Initiators meeting map (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 ?edgeLabel ?object ?objectLabel WHERE {
?item ?rel ?object.
?edge wikibase:directClaim ?rel.
?item pdiot:P3 pdio:Q47.
MINUS {pdio:P3 wikibase:directClaim ?rel}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 1000