Changes

Jump to navigation Jump to search

Project:MyData/Finland/Mapping/Results (view source)

Revision as of 00:40, 27 January 2020

1,990 bytes removed ,  4 years ago
no edit summary
Line 1: Line 1:  
{{SPARQL|query={{SPARQLcountry|country=Q564}}|label=MyData/Finland ecosystem mapping|state=collapsed}}
 
{{SPARQL|query={{SPARQLcountry|country=Q564}}|label=MyData/Finland ecosystem mapping|state=collapsed}}
−
 
+
{{SPARQL|query=
−
* [https://query.personaldata.io/embed.html#PREFIX%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%3Fitem%20%3Fstr_item%20%3FitemLabel%20WHERE%20%7B%0A%20%20BIND%28REPLACE%28STR%28%3Fitem%29%2C%22http%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%22%2C%22%22%29%20AS%20%3Fstr_item%29%0A%20%20%3Fitem%20pdiot%3AP3%20pdio%3AQ401.%0A%20%20%3Fitem%20pdiot%3AP55%20pdio%3AQ564.%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 organisations in Finland] on PersonalData.IO
+
SELECT ?item ?str_item ?itemLabel WHERE {
−
 
+
  BIND(REPLACE(STR(?item),"http://wiki.personaldata.io/entity/","") AS ?str_item)
−
* [https://query.personaldata.io/embed.html#PREFIX%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%3Fitem%20%3Fstr_item%20%3FitemLabel%20%3Fcountry%20%3FcountryLabel%20%3Fclass%20%3FclassLabel%20WHERE%20%7B%0A%20%20BIND%28REPLACE%28STR%28%3Fitem%29%2C%22http%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%22%2C%22%22%29%20AS%20%3Fstr_item%29%0A%20%20BIND%28pdio%3AQ564%20AS%20%3Fcountry%29%0A%20%20BIND%28pdio%3AQ646%20AS%20%3Fclass%29%0A%20%20%3Fitem%20pdiot%3AP3%20%3Fclass.%0A%20%20%3Fitem%20pdiot%3AP55%20%3Fcountry.%0A%20%20%23%20Label%20service%2C%20produces%20%3FxxxLabel%20and%20%3FxxxDescription%20above%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 data operator projects in Finland]
+
  ?item pdiot:P3 pdio:Q401.
−
 
+
  ?item pdiot:P55 pdio:Q564.
−
* [https://query.personaldata.io/embed.html#PREFIX%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%3Foperator%20%3FoperatorLabel%20%3Frgb%20%3Fproject%20%3FprojectLabel%20%3FprojectColor%20%0AWITH%20%7BSELECT%20%3Foperator%20%3FoperatorClass%20%3FoperatorColor%20WHERE%20%7B%0A%20%20%20%20BIND%28%3Fclass%20AS%20%3FoperatorClass%29%0A%20%20%20%20BIND%28%22FFA500%22%20AS%20%3FoperatorColor%29%0A%20%20%20%20BIND%28%3Fitem%20AS%20%3Foperator%29%0A%20%20%20%20BIND%28pdio%3AQ564%20AS%20%3Fcountry%29%0A%20%20%20%20BIND%28pdio%3AQ401%20AS%20%3Fclass%29%0A%20%20%20%20%3Fitem%20pdiot%3AP3%20%3Fclass.%0A%20%20%20%20%3Fitem%20pdiot%3AP55%20%3Fcountry.%0A%20%20%7D%7D%0AAS%20%25operator%0AWITH%20%7BSELECT%20%3Fproject%20%3FprojectClass%20%3FprojectColor%20WHERE%20%7B%0A%20%20%20%20BIND%28%3Fclass%20AS%20%3FprojectClass%29%0A%20%20%20%20BIND%28%22500%22%20AS%20%3FprojectColor%29%0A%20%20%20%20BIND%28%3Fitem%20AS%20%3Fproject%29%0A%20%20%20%20BIND%28pdio%3AQ564%20AS%20%3Fcountry%29%0A%20%20%20%20BIND%28pdio%3AQ646%20AS%20%3Fclass%29%0A%20%20%20%20%3Fitem%20pdiot%3AP3%20%3Fclass.%0A%20%20%20%20%3Fitem%20pdiot%3AP55%20%3Fcountry.%0A%20%20%7D%7D%0AAS%20%25project%0AWHERE%20%7B%0A%20%20BIND%28%3FoperatorColor%20AS%20%3Frgb%29%0A%20%20%7B%0A%20%20%20%20%20INCLUDE%20%25operator.%0A%20%20%20%20%20INCLUDE%20%25project.%0A%20%20%20%20%20%3Fproject%20pdiot%3AP111%20%3Foperator%0A%20%20%7D%0A%20%20UNION%0A%20%20%7B%0A%20%20%20%20%20INCLUDE%20%25operator.%0A%20%20%7D%0A%20%20UNION%0A%20%20%7B%0A%20%20%20%20%20INCLUDE%20%25project.%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%7D%0ALIMIT%2010000 first attempt] (kept for historic reasons)
+
  SERVICE wikibase:label {
−
* [https://query.personaldata.io/embed.html#PREFIX%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%20DISTINCT%20%3Foperator%20%3FoperatorLabel%20%3Fproject%20%3FprojectLabel%0AWHERE%20%7B%0A%20%20%7B%0A%20%20%20%20%3Foperator%20pdiot%3AP3%20pdio%3AQ401.%0A%20%20%20%20OPTIONAL%20%7B%3Fproject%20pdiot%3AP111%20%3Foperator%7D%0A%20%20%20%20OPTIONAL%20%7B%3Fproject%20pdiot%3AP111%20%3Foperator%7D%0A%20%20%20%20%3Foperator%20pdiot%3AP55%20pdio%3AQ564.%0A%20%20%7D%0A%20%20UNION%0A%20%20%7B%0A%20%20%20%20%3Fproject%20pdiot%3AP3%20pdio%3AQ646.%0A%20%20%20%20OPTIONAL%20%7B%3Fproject%20pdiot%3AP111%20%3Foperator%7D%0A%20%20%20%20OPTIONAL%20%7B%3Fproject%20pdiot%3AP111%20%3Foperator%7D%0A%20%20%20%20%3Fproject%20pdiot%3AP55%20pdio%3AQ564.%0A%20%20%7D%20%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%2010000 spreadsheet with both]
+
    bd:serviceParam wikibase:language "en" .  
 +
  }
 +
}
 +
LIMIT 100
 +
|label=organizations in Finland
 +
|state=collapsed}}
 +
{{SPARQL|query=
 +
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
 +
|label=data operators project in Finland
 +
|state=collapsed}}
 +
{{SPARQL|query=
 +
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
 +
|state=collapsed
 +
|label=first attempt, kept for historic reasons}}
 +
{{SPARQL|query=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
 +
|label=spreadsheet with both
 +
|state=collapsed}}
Retrieved from "https://wiki.personaldata.io/wiki/Special:MobileDiff/77277"

Navigation menu