Difference between revisions of "Project:MyData"

From Wikibase Personal data
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 8: Line 8:
 
{{Project:MyData/Visualizations|state=collapsed}}
 
{{Project:MyData/Visualizations|state=collapsed}}
  
−
== Hub initiators meeting work ==
+
= Mapping =
−
{{SPARQL|query=#defaultView:Graph
+
== Scotland ==
−
SELECT ?item ?itemLabel ?object ?objectLabel ?edgeLabel WHERE {
+
[[Project:MyData/Scotland/Mapping]]
−
  ?item ?rel ?object.
+
{{Project:MyData/Scotland/Mapping/Results}}
−
  ?edge wikibase:directClaim ?rel.
+
== Japan ==
−
  ?item pdiot:P3 pdio:Q47.
+
[[Project:MyData/Japan/Mapping]]
−
  MINUS {pdio:P3 wikibase:directClaim ?rel}
+
{{Project:MyData/Japan/Mapping/Results}}
−
  ?edge wikibase:propertyType wikibase:WikibaseItem  #If we don't remove this, then those properties pointing to non-item labels mess everything up
+
== Finland ==
−
 
+
[[Project:MyData/Finland/Mapping]]
−
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
+
{{Project:MyData/Finland/Mapping/Results}}
−
}
+
== Cameroon ==
−
LIMIT 1000
+
[[Project:MyData/Cameroon/Mapping]]
−
|state=collapsed
+
{{Project:MyData/Cameroon/Mapping/Results}}
−
|label=Hub Initiators meeting map}}
+
== Methodology ==
−
 
 
−
{{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=table
 
−
|state=collapsed}}
 
−
 
 
−
== MyData ==
 
−
{| class="wikitable"
 
−
|-
 
−
! Contributor !! Topic !! Visualization
 
−
|-
 
−
| 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 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]
 
−
* [{{SPARQLEmbed|query=
 
−
SELECT ?item ?itemLabel WHERE {
 
−
  ?item pdiot:P3 pdio:Q47.
 
−
  SERVICE wikibase:label {
 
−
    bd:serviceParam wikibase:language "en" .
 
−
  }
 
−
}
 
−
}} MyData hubs]
 
−
|-
 
−
| MyData Scotland || [[MyData Scotland ecosystem mapping]] workshop ||
 
−
[{{SPARQLEmbed|query={{SPARQLTableQuery|table=Q201}}}} health + education]
 
−
[{{SPARQLEmbed|query={{SPARQLTableQuery|table=Q227}}}} health + education + family activity]
 
−
[{{SPARQLEmbed|query={{SPARQLTableQuery|table=Q228}}}} work]
 
−
[{{SPARQLEmbed|query={{SPARQLWorkshopQuery|workshop=Q224}}}} all together]
 
−
|-
 
−
| MyData Finland  || [[Mapping/Finland|Finnish ecosystem]] ||
 
−
[{{SPARQLEmbed|query={{SPARQLcountry|country=Q564}}}} Finnish MyData ecosystem]
 
−
|-
 
−
| MyData Cameroon || [[Mapping/Cameroon|Cameroon ecosystem]] ||
 
−
[{{SPARQLEmbed|query={{SPARQLcountry|country=Q1918}}}} Cameroon MyData ecosystem]
 
−
|-
 
−
| MyData Japan  || [[Mapping/Japan|Japanese ecosystem]] ||
 
−
[{{SPARQLEmbed|query={{SPARQLcountry|country=Q681|legend=true}}}} Japanese ecosystem]
 
−
|}
 
−
 
 
−
 
 
  
 
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.
 
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:29, 27 January 2020

Documenting hubs

For instance:

Visualizations

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" . 
  }
}

MyData hubs (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/>
#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) 

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)


On Wikidata

Mapping

Scotland

Project:MyData/Scotland/Mapping 

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 ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
   BIND(pdio:Q201 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.
       }
   }.
}

MyData/Scotland ecosystem mapping health + education (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/>
#defaultView:Graph
SELECT ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
   BIND(pdio:Q227 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.
       }
   }.
}

MyData/Scotland ecosystem mapping health + education +family activity (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/>
#defaultView:Graph
SELECT ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
   BIND(pdio:Q228 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.
       }
   }.
}

MyData/Scotland ecosystem mapping work (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/>
#defaultView:Graph
SELECT ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel 
   WITH {
     SELECT ?table 
     WHERE {
       pdio:Q224 pdiot:P63 ?table.
     }
   } AS %workshop
   WHERE
   {
     
   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 {
          INCLUDE %workshop.
          ?table pdiop:P25 ?relationshipStatement.
          ?relationshipStatement pdiopq:P24 ?domain.
          ?relationshipStatement pdiopq:P23 ?range.
       }
     
   }
   UNION
   {  
     SELECT ?domain ?range WHERE {
          INCLUDE %workshop.
          ?table pdiop:P58 ?relationshipInStatement.
          ?relationshipInStatement pdiops:P58 ?range.
          ?relationshipInStatement pdiopq:P61 ?domain.
       }
   }
   UNION
   {  
     SELECT ?domain ?range WHERE {
          INCLUDE %workshop.
          ?table pdiop:P59 ?relationshipOutStatement.
          ?relationshipOutStatement pdiops:P59 ?domain.
          ?relationshipOutStatement pdiopq:P60 ?range.
       }
   }.
}

MyData/Scotland ecosystem mapping all together (embedded)

Japan

Project:MyData/Japan/Mapping 

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:Q681.
    ?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:Q681.
    ?object pdiot:P55 pdio:Q681.
    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

Japanese ecosystem (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 DISTINCT ?operator ?operatorLabel  ?project ?projectLabel  ?industry ?industryLabel
WHERE {
  {
    ?operator pdiot:P3 pdio:Q401.
    OPTIONAL {?operator pdiot:P44 ?industry.}
    OPTIONAL {?project pdiot:P111 ?operator}
    OPTIONAL {?project pdiot:P111 ?operator}
    ?operator pdiot:P55 pdio:Q681.
  }
  UNION
  {
    ?project pdiot:P3 pdio:Q646.
    OPTIONAL {?project pdiot:P111 ?operator}
    OPTIONAL {?project pdiot:P111 ?operator}
    ?project pdiot:P55 pdio:Q681.
  } 
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" . 
  }
}
LIMIT 10000

Japanese ecosystem with indsutry information (embedded)

Finland

Project:MyData/Finland/Mapping 

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) 

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) 

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) 

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) 

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

spreadsheet with both (embedded)

Cameroon

Project:MyData/Cameroon/Mapping 

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:Q1918.
    ?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:Q1918.
    ?object pdiot:P55 pdio:Q1918.
    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

Cameroon MyData ecosystem (embedded)

Methodology

Of course, it is necessary for these visualisations to engage in a mapping process. We explain here how to do so.

Retrieved from "https://wiki.personaldata.io/w/index.php?title=Project:MyData&oldid=77263"