Difference between revisions of "Project:MyData/Visualizations"

From Wikibase Personal data
Jump to navigation Jump to search
(Created page with "{{SPARQL|label=MyData hub network |query= #defaultView:Graph SELECT ?node ?nodeLabel ?value ?valueLabel ?edgeLabel (IF(BOUND(?edge), ?propertyrgb, "FFFFFF") AS ?rgb) #white...")
 
 
(8 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}}}
 
|query=
 
|query=
 
#defaultView:Graph
 
#defaultView:Graph
Line 11: 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 21: Line 34:
 
}
 
}
 
}}
 
}}
−
* personal data ecosystem maps
 
−
* personal data tools ecosystem map
 
−
 
 
{{SPARQL|label=data operators around the world
 
{{SPARQL|label=data operators around the world
 +
|state={{{state}}}
 
|query=
 
|query=
 
SELECT ?item ?itemLabel ?country ?countryLabel WHERE {
 
SELECT ?item ?itemLabel ?country ?countryLabel WHERE {
Line 34: Line 45:
 
} }}
 
} }}
 
{{SPARQL|label=associations, with country and location
 
{{SPARQL|label=associations, with country and location
 +
|state={{{state}}}
 
|query=
 
|query=
 
SELECT ?item ?itemLabel ?country ?countryLabel ?location ?locationLabel WHERE {
 
SELECT ?item ?itemLabel ?country ?countryLabel ?location ?locationLabel WHERE {
Line 42: 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" . 
  }
}

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

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