Difference between revisions of "Project:MyData/Visualizations"
Jump to navigation
Jump to search
(7 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | == Network == | ||
+ | {{SPARQL|query= | ||
+ | SELECT ?item ?itemLabel WHERE { | ||
+ | ?item pdiot:P3 pdio:Q47. | ||
+ | SERVICE wikibase:label { | ||
+ | bd:serviceParam wikibase:language "en" . | ||
+ | } | ||
+ | } | ||
+ | |label=MyData hubs | ||
+ | |state=collapsed | ||
+ | }} | ||
{{SPARQL|label=MyData hub network | {{SPARQL|label=MyData hub network | ||
|state={{{state}}} | |state={{{state}}} | ||
Line 12: | Line 23: | ||
(pdiot:P137 "0000AA") # blue - partner | (pdiot:P137 "0000AA") # blue - partner | ||
(pdiot:P145 "AA00AA") # pink - seeks | (pdiot:P145 "AA00AA") # pink - seeks | ||
+ | (pdiot:P11 "00AAAA") # interested in | ||
} | } | ||
pdio:Q49 pdiot:P63 ?node. | pdio:Q49 pdiot:P63 ?node. | ||
Line 22: | Line 34: | ||
} | } | ||
}} | }} | ||
− | |||
− | |||
− | |||
{{SPARQL|label=data operators around the world | {{SPARQL|label=data operators around the world | ||
|state={{{state}}} | |state={{{state}}} | ||
Line 45: | Line 54: | ||
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}}}}} | ||
+ | |||
+ | == On Wikidata == | ||
+ | * [https://query.wikidata.org/embed.html#SELECT%20%3Fitem%20%3FitemLabel%20%3FcountryLabel%20%3F_image%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP463%20wd%3AQ59696014.%0A%20%20OPTIONAL%0A%20%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP17%20%3Fcountry%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%0A%20%20%7D%0A%20%20%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP18%20%3F_image.%20%7D%0A%7D%0ALIMIT%20100 MyData org members on Wikidata] | ||
+ | * [https://query.wikidata.org/embed.html#SELECT%20%3Fitem%20%3FitemLabel%20%3Flocation%20%3FlocationLabel%20%3Fimage%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ60674536.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP276%20%3Flocation.%0A%20%20%20%20%20%20OPTIONAL%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Flocation%20wdt%3AP41%20%3Fimage%0A%20%20%20%20%20%20%7D%0A%20%20%7D%0A%20%20OPTIONAL%20%0A%20%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP856%20%3Fwebsite.%0A%20%20%7D%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%0A%20%20%7D%0A%7D%0ALIMIT%20100 hub list and their flags on Wikidata] | ||
+ | * [https://query.wikidata.org/embed.html#%23defaultView%3AGraph%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Fimage%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ60674536.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP276%20%3Flocation.%0A%20%20%20%20%20%20OPTIONAL%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Flocation%20wdt%3AP41%20%3Fimage%0A%20%20%20%20%20%20%7D%0A%20%20%7D%0A%20%20OPTIONAL%20%0A%20%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP856%20%3Fwebsite.%0A%20%20%7D%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%0A%20%20%7D%0A%7D%0ALIMIT%20100 MyData network visuals on Wikidata] |
Latest revision as of 01:29, 27 January 2020
Network
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:Q47.
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/>
#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
(pdiot:P11 "00AAAA") # interested in
}
pdio:Q49 pdiot:P63 ?node.
OPTIONAL
{
?node ?propertyRel ?value.
?edge wikibase:directClaim ?propertyRel.
}.
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 ?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
full triple table of Hub initiators meeting (embedded)