Difference between revisions of "Project:MyData/Visualizations"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 23: | 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 68: | Line 69: | ||
|state={{{state}}} | |state={{{state}}} | ||
|label=Hub Initiators meeting map}} | |label=Hub Initiators meeting map}} | ||
| − | |||
{{SPARQL|query=SELECT ?item ?itemLabel ?edgeLabel ?object ?objectLabel WHERE { | {{SPARQL|query=SELECT ?item ?itemLabel ?edgeLabel ?object ?objectLabel WHERE { | ||
?item ?rel ?object. | ?item ?rel ?object. | ||
| Line 74: | Line 74: | ||
?item pdiot:P3 pdio:Q47. | ?item pdiot:P3 pdio:Q47. | ||
MINUS {pdio:P3 wikibase:directClaim ?rel} | MINUS {pdio:P3 wikibase:directClaim ?rel} | ||
| − | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
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)