Difference between revisions of "Project:MyData/Scotland/Mapping"
Line 26: | Line 26: | ||
* [https://www.youtube.com/watch?v=rcc9NoQGTsk&feature=youtu.be| how to contribute] | * [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) | * [https://www.youtube.com/watch?v=miVWeLuXQuc&feature=youtu.be| how to do a SAR] (mockup) | ||
+ | |||
+ | {{SPARQLEmbed|query= | ||
+ | SELECT ?item ?itemLabel WHERE { | ||
+ | ?item pdiot:P3 pdio:Q47. | ||
+ | SERVICE wikibase:label { | ||
+ | bd:serviceParam wikibase:language "en" . | ||
+ | } | ||
+ | } | ||
+ | |label=MyData hubs | ||
+ | |state=collapsed | ||
+ | }} | ||
+ | |- | ||
+ | | MyData Scotland || [[MyData Scotland ecosystem mapping]] workshop || | ||
+ | {{SPARQL|query={{SPARQLTableQuery|table=Q201}}|label=[[MyData Scotland ecosystem mapping]] health + education|state=collapsed}} | ||
+ | {{SPARQL|query={{SPARQLTableQuery|table=Q227}}|label=[[MyData Scotland ecosystem mapping]] health + education +family activity|state=collapsed}} | ||
+ | {{SPARQL|query={{SPARQLTableQuery|table=Q228}}|label=work|state=collapsed}} | ||
+ | {{SPARQL|query={{SPARQLWorkshopQuery|workshop=Q224}}|label=all together|state=collapsed}} | ||
+ | |- | ||
+ | | 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] | ||
+ | |} |
Revision as of 00:20, 27 January 2020
Checklist:
- create an account if you wish (all your edits can actually be anonymous)
- look at full Workshop page MyData Scotland ecosystem mapping workshop (Q224), to get a list of tables
- look at page for test run
Contribute:
Final result:
Possible services:
- Data ecosystem visualisations
- Subject Access Requests (requests for your data)
- Schema.org generation for actors through self-mapping
Videos:
- how to contribute
- how to do a SAR (mockup)
//query.personaldata.io/embed.html#PREFIX%20pdio%3A%20%3Chttps%3A%2F%2Fwiki.personaldata.io%2Fentity%2F%3E%0APREFIX%20pdiot%3A%20%3Chttps%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fdirect%2F%3E%0APREFIX%20pdiop%3A%20%3Chttps%3A%2F%2Fwiki.personaldata.io%2Fprop%2F%3E%0APREFIX%20pdiops%3A%20%3Chttps%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fstatement%2F%3E%0APREFIX%20pdiopq%3A%20%3Chttps%3A%2F%2Fwiki.personaldata.io%2Fprop%2Fqualifier%2F%3E%0ASELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20%3Fitem%20pdiot%3AP3%20pdio%3AQ47.%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 |- | MyData Scotland || MyData Scotland ecosystem mapping workshop ||
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.
}
}.
}
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 Finland || Finnish ecosystem || Finnish MyData ecosystem |- | MyData Cameroon || Cameroon ecosystem || Cameroon MyData ecosystem |- | MyData Japan || Japanese ecosystem || Japanese ecosystem |}