Difference between revisions of "Project:MyData/Scotland/Mapping"

From Wikibase Personal data
Jump to navigation Jump to search
Line 28: Line 28:
  
 
== Results ==  
 
== Results ==  
{{SPARQLEmbed|query=
+
{{SPARQL|query=
 
SELECT ?item ?itemLabel WHERE {
 
SELECT ?item ?itemLabel WHERE {
 
   ?item pdiot:P3 pdio:Q47.
 
   ?item pdiot:P3 pdio:Q47.

Revision as of 00:22, 27 January 2020

Event invitation

Checklist:

Contribute:

Final result:

Possible services:

  • Data ecosystem visualisations
  • Subject Access Requests (requests for your data)
  • Schema.org generation for actors through self-mapping

Videos:

Results

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 ?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)