|
|
| (22 intermediate revisions by the same user not shown) |
| Line 9: |
Line 9: |
| | | | |
| | For these reasons, we wish to split searches below into reusable components, but we are not there yet... | | For these reasons, we wish to split searches below into reusable components, but we are not there yet... |
| − | == Visualizations ==
| + | = Visualizations = |
| | These are some of the visualizations we are building together. | | These are some of the visualizations we are building together. |
| | | | |
| | + | == Facebook == |
| | + | {{Project:Ecosystem/Facebook/Visualizations|state=collapsed}} |
| | | | |
| − | {| class="wikitable"
| + | == Gig work == |
| − | |-
| + | {{Project:Gig/Visualizations|state=collapsed}} |
| − | ! Data ecosystem !! Topic !! Visualization
| + | |
| − | |-
| + | == Adtech == |
| − | | Facebook's tools || various Facebook tools, and how they exchange information || [{{SPARQLEmbed|query={{SPARQLTableQuery|table=Q383}}}}]
| + | {{Project:Adtech/Visualizations|state=collapsed}} |
| − | |-
| |
| − | | Facebook and disinformation || how disinformation blends into our information ecosystem through Facebook || [{{SPARQLEmbed|query={{SPARQLTableQuery|table=Q366}}}}]
| |
| − | |-
| |
| − | | Cambridge Analytica scandal || visual summary || [{{SPARQLEmbed|query={{SPARQLTableQuery|table=Q384}}}}]
| |
| − | |-
| |
| − | | Adtech ecosystem || [[adtech|routes your personal data takes when you browse the web]] ||
| |
| − | |-
| |
| − | | Platform economy and work || workers contribute a lot of data to the [[gig work ecosystem]] ||
| |
| − | |-
| |
| − | | Mobility data ecosystem || [[Mobility services|actors and activities in the mobility space]] ||
| |
| − | |-
| |
| − | | Open Science Hardware || [[Use case: GOSH | Mapping the Gathering for Open Science Hardware community]] ||
| |
| − | |}
| |
| | | | |
| | == MyData == | | == MyData == |
| − | {| class="wikitable" | + | {{Project:MyData/Visualizations|state=collapsed}} |
| − | |-
| + | |
| − | ! Contributor !! Topic !! Visualization
| + | === Others === |
| − | |-
| + | * [[Presentation_MyDataLab |Open Geneva workshop]] |
| − | | MyData Global || the whole network||
| |
| − | * [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]
| |
| − | * [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]
| |
| − | * [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]
| |
| − | |-
| |
| − | | MyData Scotland || [[MyData Scotland ecosystem mapping]] workshop || | |
| − | [{{SPARQLEmbed|query={{SPARQLTableQuery|table=Q201}}}}]
| |
| − | [{{SPARQLEmbed|query={{SPARQLTableQuery|table=Q227}}}}]
| |
| − | [{{SPARQLEmbed|query={{SPARQLTableQuery|table=Q228}}}}]
| |
| − | [{{SPARQLEmbed|query={{SPARQLWorkshopQuery|workshop=Q224}}}}]
| |
| − | |-
| |
| − | | MyData Geneva|| [[Presentation_MyDataLab |workshop]] run in the context of the OpenGeneva festival ||
| |
| | * [http://tinyurl.com/y49p76ff Paul's Wikidata footprint] | | * [http://tinyurl.com/y49p76ff Paul's Wikidata footprint] |
| − | * [https://query.personaldata.io/embed.html#%23defaultView%3AGraph%0APREFIX%20pdio%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%3E%0APREFIX%20pdiot%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fnode%20%3FnodeLabel%20%3FnodeImage%20%3FchildNode%20%3FchildNodeLabel%20%3FchildNodeImage%20%3Frgb%20WHERE%20%7B%0A%20%20%7B%0A%20%20%20%20BIND%28pdio%3AQ308%20AS%20%3Fnode%29%0A%20%20%20%20%3Fnode%20%3Fp%20%3Fi.%0A%20%20%20%20OPTIONAL%20%7B%20%3Fnode%20pdiot%3AP47%20%3FnodeImage.%20%7D%0A%20%20%20%20%3FchildNode%20%3Fx%20%3Fp.%0A%20%20%20%20%3FchildNode%20rdf%3Atype%20wikibase%3AProperty.%0A%20%20%20%20FILTER%28STRSTARTS%28STR%28%3Fi%29%2C%20%22http%3A%2F%2Fwiki.personaldata.io%2Fentity%2FQ%22%29%29%0A%20%20%20%20FILTER%28STRSTARTS%28STR%28%3FchildNode%29%2C%20%22http%3A%2F%2Fwiki.personaldata.io%2Fentity%2FP%22%29%29%0A%20%20%7D%0A%20%20UNION%0A%20%20%7B%0A%20%20%20%20BIND%28%22EFFBD8%22%20AS%20%3Frgb%29%0A%20%20%20%20pdio%3AQ308%20%3Fp%20%3FchildNode.%0A%20%20%20%20OPTIONAL%20%7B%20%3FchildNode%20pdiot%3AP47%20%3FchildNodeImage.%20%7D%0A%20%20%20%20%3Fnode%20%3Fx%20%3Fp.%0A%20%20%20%20%3Fnode%20rdf%3Atype%20wikibase%3AProperty.%0A%20%20%20%20FILTER%28STRSTARTS%28STR%28%3FchildNode%29%2C%20%22http%3A%2F%2Fwiki.personaldata.io%2Fentity%2FQ%22%29%29%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fnode%20pdiot%3AP47%20%3FnodeImage.%0A%20%20%20%20%3FchildNode%20pdiot%3AP47%20%3FchildNodeImage.%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D Mickey Mouse's social network]
| |
| | * [http://tinyurl.com/yyyk42d8 Sustainable development goals] | | * [http://tinyurl.com/yyyk42d8 Sustainable development goals] |
| | * [https://www.wikidata.org/wiki/Wikidata:WikiProject_Sustainable_Development WikiProject SDGs] | | * [https://www.wikidata.org/wiki/Wikidata:WikiProject_Sustainable_Development WikiProject SDGs] |
| | * [http://tinyurl.com/y6r6mm7n OpenGeneva] | | * [http://tinyurl.com/y6r6mm7n OpenGeneva] |
| | * [http://tinyurl.com/y253gnam OpenGeneva hackathons] | | * [http://tinyurl.com/y253gnam OpenGeneva hackathons] |
| − | |-
| |
| − | | MyData Finland || [[Mapping/Finland|Finnish ecosystem]] ||
| |
| − | [{{SPARQLEmbed|query={{SPARQLcountry|country=Q564}}}}]
| |
| − | |-
| |
| − | | MyData Japan || [[Mapping/Japan|Japanese ecosystem]] ||
| |
| − | [{{SPARQLEmbed|query={{SPARQLcountry|country=Q681|legend=true}}}}]
| |
| − | |}
| |
| − |
| |
| − |
| |
| − |
| |
| − | Of course, it is necessary for these visualisations to engage in a mapping process. We explain [https://www.youtube.com/watch?v=rcc9NoQGTsk here] how to do so.
| |
Latest revision as of 00:06, 27 January 2020
We think producing quickly and efficiently visualisations that are maximally relevant to specific segments of our stakeholders is key to our success in engaging progressively more participants.
We find ourselves in a particularly virtuous feedback loop if we manage to put contributors in front of a simple interface (to them) to enter data, knowing that their work will directly translate into an outcome valuable to them. The easiest way to achieve that is to give them a perspective on their own work that they didn't have before, because they can then address their peers with already new information.
For this reason, we need to be able to produce high quality visualisations in an extremely modular way. There are several reasons for the modularity:
- separation of concerns between querying the database for data and producing the visualisation itself;
- modularity of either side;
- access controls on components generating such requests.
For these reasons, we wish to split searches below into reusable components, but we are not there yet...
Visualizations
These are some of the visualizations we are building together.
Facebook
ExpandPREFIX 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 ?nodeImage ?childNode ?childNodeLabel ?childNodeImage ?rgb WHERE {
{
BIND(pdio:Q308 AS ?node)
?node ?p ?i.
OPTIONAL { ?node pdiot:P47 ?nodeImage. }
?childNode ?x ?p.
?childNode rdf:type wikibase:Property.
FILTER(STRSTARTS(STR(?i), "https://wiki.personaldata.io/entity/Q"))
FILTER(STRSTARTS(STR(?childNode), "https://wiki.personaldata.io/entity/P"))
}
UNION
{
BIND("EFFBD8" AS ?rgb)
pdio:Q308 ?p ?childNode.
OPTIONAL { ?childNode pdiot:P47 ?childNodeImage. }
?node ?x ?p.
?node rdf:type wikibase:Property.
FILTER(STRSTARTS(STR(?childNode), "https://wiki.personaldata.io/entity/Q"))
}
OPTIONAL {
?node pdiot:P47 ?nodeImage.
?childNode pdiot:P47 ?childNodeImage.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Mickey Mouse's social network (embedded)
ExpandPREFIX 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 ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
BIND(pdio:Q383 AS ?table).
OPTIONAL {
?table pdiop:P26 ?domain_prop.
?domain_prop pdiops:P26 ?domain.
?domain_prop pdiopq:P27 ?domainLabel
}.
OPTIONAL {
?table pdiop:P26 ?range_prop.
?range_prop pdiops:P26 ?range.
?range_prop pdiopq:P27 ?rangeLabel
}.
{
SELECT ?domain ?range WHERE {
?table pdiop:P25 ?relationshipStatement.
?relationshipStatement pdiopq:P24 ?domain.
?relationshipStatement pdiopq:P23 ?range.
}
}
UNION
{
SELECT ?domain ?range WHERE {
?table pdiop:P58 ?relationshipInStatement.
?relationshipInStatement pdiops:P58 ?range.
?relationshipInStatement pdiopq:P61 ?domain.
}
}
UNION
{
SELECT ?domain ?range WHERE {
?table pdiop:P59 ?relationshipOutStatement.
?relationshipOutStatement pdiops:P59 ?domain.
?relationshipOutStatement pdiopq:P60 ?range.
}
}.
}
simple view of FB (embedded)
ExpandPREFIX 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 ?origin ?originLabel ?destination ?destinationLabel ?rgb ?edgeLabel WHERE
{
pdio:Q1044 pdiot:P129 ?origin.
pdio:Q1044 pdiot:P129 ?destination.
pdio:Q1044 pdiop:P130 ?association_statement.
?association_statement pdiopq:P131 ?origin.
?association_statement pdiopq:P132 ?destination.
?association_statement pdiops:P130 ?edge.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
extended view of FB (embedded)
ExpandPREFIX 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 ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
BIND(pdio:Q383 AS ?table).
OPTIONAL {
?table pdiop:P26 ?domain_prop.
?domain_prop pdiops:P26 ?domain.
?domain_prop pdiopq:P27 ?domainLabel
}.
OPTIONAL {
?table pdiop:P26 ?range_prop.
?range_prop pdiops:P26 ?range.
?range_prop pdiopq:P27 ?rangeLabel
}.
{
SELECT ?domain ?range WHERE {
?table pdiop:P25 ?relationshipStatement.
?relationshipStatement pdiopq:P24 ?domain.
?relationshipStatement pdiopq:P23 ?range.
}
}
UNION
{
SELECT ?domain ?range WHERE {
?table pdiop:P58 ?relationshipInStatement.
?relationshipInStatement pdiops:P58 ?range.
?relationshipInStatement pdiopq:P61 ?domain.
}
}
UNION
{
SELECT ?domain ?range WHERE {
?table pdiop:P59 ?relationshipOutStatement.
?relationshipOutStatement pdiops:P59 ?domain.
?relationshipOutStatement pdiopq:P60 ?range.
}
}.
}
simple view of various Facebook tools, and how they exchange information (embedded)
ExpandPREFIX 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 ?origin ?originLabel ?destination ?destinationLabel ?rgb ?edgeLabel WHERE
{
pdio:Q1044 pdiot:P129 ?origin.
pdio:Q1044 pdiot:P129 ?destination.
pdio:Q1044 pdiop:P130 ?association_statement.
?association_statement pdiopq:P131 ?origin.
?association_statement pdiopq:P132 ?destination.
?association_statement pdiops:P130 ?edge.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
extended view of various Facebook tools, and how they exchange information (embedded)
ExpandPREFIX 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 ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
BIND(pdio:Q366 AS ?table).
OPTIONAL {
?table pdiop:P26 ?domain_prop.
?domain_prop pdiops:P26 ?domain.
?domain_prop pdiopq:P27 ?domainLabel
}.
OPTIONAL {
?table pdiop:P26 ?range_prop.
?range_prop pdiops:P26 ?range.
?range_prop pdiopq:P27 ?rangeLabel
}.
{
SELECT ?domain ?range WHERE {
?table pdiop:P25 ?relationshipStatement.
?relationshipStatement pdiopq:P24 ?domain.
?relationshipStatement pdiopq:P23 ?range.
}
}
UNION
{
SELECT ?domain ?range WHERE {
?table pdiop:P58 ?relationshipInStatement.
?relationshipInStatement pdiops:P58 ?range.
?relationshipInStatement pdiopq:P61 ?domain.
}
}
UNION
{
SELECT ?domain ?range WHERE {
?table pdiop:P59 ?relationshipOutStatement.
?relationshipOutStatement pdiops:P59 ?domain.
?relationshipOutStatement pdiopq:P60 ?range.
}
}.
}
how disinformation blends into our information ecosystem through Facebook (embedded)
ExpandPREFIX 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 ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
BIND(pdio:Q384 AS ?table).
OPTIONAL {
?table pdiop:P26 ?domain_prop.
?domain_prop pdiops:P26 ?domain.
?domain_prop pdiopq:P27 ?domainLabel
}.
OPTIONAL {
?table pdiop:P26 ?range_prop.
?range_prop pdiops:P26 ?range.
?range_prop pdiopq:P27 ?rangeLabel
}.
{
SELECT ?domain ?range WHERE {
?table pdiop:P25 ?relationshipStatement.
?relationshipStatement pdiopq:P24 ?domain.
?relationshipStatement pdiopq:P23 ?range.
}
}
UNION
{
SELECT ?domain ?range WHERE {
?table pdiop:P58 ?relationshipInStatement.
?relationshipInStatement pdiops:P58 ?range.
?relationshipInStatement pdiopq:P61 ?domain.
}
}
UNION
{
SELECT ?domain ?range WHERE {
?table pdiop:P59 ?relationshipOutStatement.
?relationshipOutStatement pdiops:P59 ?domain.
?relationshipOutStatement pdiopq:P60 ?range.
}
}.
}
summary of the Cambridge Analytica scandal (embedded)
Gig work
ExpandPREFIX 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 ?origin ?originLabel ?destination ?destinationLabel ?rgb ?edgeLabel WHERE
{
pdio:Q1070 pdiot:P129 ?origin.
pdio:Q1070 pdiot:P129 ?destination.
pdio:Q1070 pdiop:P130 ?association_statement.
?association_statement pdiopq:P131 ?origin.
?association_statement pdiopq:P132 ?destination.
?association_statement pdiops:P130 ?edge.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Uber systems (embedded)
Adtech
ExpandPREFIX 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 ?_image WHERE {
?item pdiot:P28 pdio:Q370.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
OPTIONAL { ?item pdiot:P47 ?_image. }
}
LIMIT 100
adtech mess... we need an ontology (embedded)
ExpandPREFIX 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 ?label ?_image WHERE {
?item pdiot:P3 pdio:Q1588.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
?item rdfs:label ?label
}
OPTIONAL { ?item pdiot:P47 ?_image. }
}
LIMIT 100
partners lists (embedded)
ExpandPREFIX 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 ?object ?objectLabel ?rgb ?subject ?subjectLabel
WHERE {
VALUES (?object ?rgb){
(pdio:Q110 "FF0000")
(pdio:Q495 "00FF00")
(pdio:Q559 "0000FF")
(pdio:Q153 "333333")
(pdio:Q491 "888800")
(pdio:Q807 "008888")
(pdio:Q492 "880088")
(pdio:Q498 "440000")
(pdio:Q810 "004400")
(pdio:Q556 "000044")
(pdio:Q504 "004444")
(pdio:Q874 "444400")
(pdio:Q834 "440044")
}
VALUES ?predicate {
pdiot:P3
pdiot:P28
}
?subject ?predicate ?object
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
LIMIT 1000
Lumascape-like map of the ecosystem (embedded)
ExpandPREFIX 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 ?label ?_image WHERE {
?item pdiot:P3 pdio:Q110.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
?item rdfs:label ?label
}
OPTIONAL { ?item pdiot:P47 ?_image. }
}
LIMIT 100
adtech companies (embedded)
ExpandPREFIX 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 ?label ?_image WHERE {
?item pdiot:P37 pdio:Q495.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
?item rdfs:label ?label
}
OPTIONAL { ?item pdiot:P47 ?_image. }
}
LIMIT 100
data management platforms (embedded)
ExpandPREFIX 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 ?label ?_image WHERE {
?item pdiot:P37 pdio:Q559.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
?item rdfs:label ?label
}
OPTIONAL { ?item pdiot:P47 ?_image. }
}
LIMIT 100
identity resolution services (embedded)
ExpandPREFIX 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:Q110 "EEEEEE")(pdio:Q495 "222288")(pdio:Q559 "8822222")
}
}
}
AS %predicateFilterValues
WITH {
SELECT ?predicate ?subjectValue ?objectValue ?predicateRGB WHERE {
VALUES (?predicate ?subjectValue ?objectValue ?predicateRGB) {
(pdiot:P111 pdio:Q495 pdio:Q559 "EEEEEE")(pdiot:P111 pdio:Q495 pdio:Q559 "222288")
}
}
}
AS %predicates
WITH {SELECT ?node ?nodeRGB WHERE {
?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|
BIND(?predicateRGB as ?edgeRGB)
}
} AS %edges
WHERE {
{ # The caption's nodes:
INCLUDE %predicateFilterValues.
BIND(?predicateFilterValue AS ?item1).
BIND(?predicateValueRGB AS ?rgb).
}
UNION
{ # The caption's edges:
INCLUDE %predicates.
BIND(?subjectValue AS ?item1).
BIND(?objectValue AS ?item2).
BIND(?predicateRGB AS ?rgb).
}
UNION
{
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
actors (embedded)
MyData
Network
ExpandPREFIX 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" .
}
}
MyData hubs (embedded)
ExpandPREFIX 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". }
}
MyData hub network (embedded)
ExpandPREFIX 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)
ExpandPREFIX 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
ExpandPREFIX 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)
ExpandPREFIX 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)
On Wikidata
Others