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

From Wikibase Personal data
Jump to navigation Jump to search
(Replaced content with "[https://www.datafest.global/events-feed/2019/3/20/adapting-data-ecosystems-to-follow-mydata-principles Event invitation] Checklist: * create an account if you wish (all...")
Tag: Replaced
 
(28 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
[https://www.datafest.global/events-feed/2019/3/20/adapting-data-ecosystems-to-follow-mydata-principles Event invitation]
 +
 +
Checklist:
 
* create an account if you wish (all your edits can actually be anonymous)
 
* create an account if you wish (all your edits can actually be anonymous)
* look at Workshop page [[Item:Q224]]
+
* look at full Workshop page [[Item:Q224]], to get a list of tables
* look at example page [[Item:Q201]]
+
* look at page for [[Item:Q201|test run]]
 +
 
 +
Contribute:
 +
* [[Item:Q227|baby/education data]]
 +
* [[Item:Q228|labor]]
 +
* [[Item:Q233|events]]
 +
* [[Item:Q234|local gov]]
 +
 
 +
Possible services:
 +
* Data ecosystem visualisations
 +
* Subject Access Requests (requests for your data)
 +
* Schema.org generation for actors through self-mapping
  
 +
Videos:
 +
* [https://www.youtube.com/watch?v=rcc9NoQGTsk&feature=youtu.be| how to contribute]
 +
* [https://www.youtube.com/watch?v=miVWeLuXQuc&feature=youtu.be| how to do a SAR] (mockup)
  
Final result:
+
== Results ==
* [https://query.personaldata.io/#%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%0APREFIX%20pdiop%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2F%3E%0APREFIX%20pdiops%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fstatement%2F%3E%0APREFIX%20pdiopq%3A%20%3Chttp%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fqualifier%2F%3E%0A%0ASELECT%20%3Frel%20%3Fpred%20%3Fobj%20%3Fitem%20%3Fdomain%20%3FdomainLabel%20%3Frange%20%3FrangeLabel%20WHERE%0A%7B%0A%20%20%20BIND%28pdio%3AQ201%20AS%20%3Ftable%29.%0A%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%3Ftable%20pdiop%3AP26%20%3Fdomain_prop.%0A%20%20%20%20%20%3Fdomain_prop%20pdiops%3AP26%20%3Fdomain.%0A%20%20%20%20%20%3Fdomain_prop%20pdiopq%3AP27%20%3FdomainLabel%0A%20%20%20%7D.%0A%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%3Ftable%20pdiop%3AP26%20%3Frange_prop.%0A%20%20%20%20%20%3Frange_prop%20pdiops%3AP26%20%3Frange.%0A%20%20%20%20%20%3Frange_prop%20pdiopq%3AP27%20%3FrangeLabel%0A%20%20%20%7D.%0A%20%20%20%7B%0A%20%20%20%20%20SELECT%20%3Fdomain%20%3Frange%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Ftable%20pdiop%3AP25%20%3FrelationshipStatement.%0A%20%20%20%20%20%20%20%20%20%20%3FrelationshipStatement%20pdiopq%3AP24%20%3Fdomain.%0A%20%20%20%20%20%20%20%20%20%20%3FrelationshipStatement%20pdiopq%3AP23%20%3Frange.%0A%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%0A%20%20%20%7D%0A%20%20%20UNION%0A%20%20%20%7B%20%20%0A%20%20%20%20%20SELECT%20%3Fdomain%20%3Frange%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Ftable%20pdiop%3AP58%20%3FrelationshipInStatement.%0A%20%20%20%20%20%20%20%20%20%20%3FrelationshipInStatement%20pdiops%3AP58%20%3Frange.%0A%20%20%20%20%20%20%20%20%20%20%3FrelationshipInStatement%20pdiopq%3AP61%20%3Fdomain.%0A%20%20%20%20%20%20%20%7D%0A%20%20%20%7D%0A%20%20%20UNION%0A%20%20%20%7B%20%20%0A%20%20%20%20%20SELECT%20%3Fdomain%20%3Frange%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%20%20%3Ftable%20pdiop%3AP59%20%3FrelationshipOutStatement.%0A%20%20%20%20%20%20%20%20%20%20%3FrelationshipOutStatement%20pdiops%3AP59%20%3Fdomain.%0A%20%20%20%20%20%20%20%20%20%20%3FrelationshipOutStatement%20pdiopq%3AP60%20%3Frange.%0A%20%20%20%20%20%20%20%7D%0A%20%20%20%7D.%0A%7D Scotland MyData map]
+
{{Project:MyData/Scotland/Mapping/Results}}

Latest revision as of 00:25, 27 January 2020

Event invitation

Checklist:

  • create an account if you wish (all your edits can actually be anonymous)
  • look at full Workshop page Item:Q224, to get a list of tables
  • look at page for test run

Contribute:

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/>
#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)