Difference between revisions of "Project:Ecosystem"
Jump to navigation
Jump to search
Facebook
Line 3: | Line 3: | ||
= Facebook = | = Facebook = | ||
− | {{Project:Ecosystem/Visualizations | + | {{Project:Ecosystem/Facebook/Visualizations|state=collapsed}} |
= Adtech = | = Adtech = |
Latest revision as of 00:02, 27 January 2020
A project to make sense of the data ecosystem as a whole.
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 ?nodeImage ?childNode ?childNodeLabel ?childNodeImage ?rgb WHERE {
{
BIND(pdio:Q308 AS ?node)
?node ?p ?i.
OPTIONAL { ?node pdiot:P47 ?nodeImage. }
?childNode ?x ?p.
?childNode rdf:type wikibase:Property.
FILTER(STRSTARTS(STR(?i), "https://wiki.personaldata.io/entity/Q"))
FILTER(STRSTARTS(STR(?childNode), "https://wiki.personaldata.io/entity/P"))
}
UNION
{
BIND("EFFBD8" AS ?rgb)
pdio:Q308 ?p ?childNode.
OPTIONAL { ?childNode pdiot:P47 ?childNodeImage. }
?node ?x ?p.
?node rdf:type wikibase:Property.
FILTER(STRSTARTS(STR(?childNode), "https://wiki.personaldata.io/entity/Q"))
}
OPTIONAL {
?node pdiot:P47 ?nodeImage.
?childNode pdiot:P47 ?childNodeImage.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Mickey Mouse's social 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/>
#defaultView:Graph
SELECT ?rel ?pred ?obj ?item ?domain ?domainLabel ?range ?rangeLabel WHERE
{
BIND(pdio:Q383 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 ?origin ?originLabel ?destination ?destinationLabel ?rgb ?edgeLabel WHERE
{
pdio:Q1044 pdiot:P129 ?origin.
pdio:Q1044 pdiot:P129 ?destination.
pdio:Q1044 pdiop:P130 ?association_statement.
?association_statement pdiopq:P131 ?origin.
?association_statement pdiopq:P132 ?destination.
?association_statement pdiops:P130 ?edge.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
extended view of FB (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:Q383 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.
}
}.
}
simple view of various Facebook tools, and how they exchange information (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 ?origin ?originLabel ?destination ?destinationLabel ?rgb ?edgeLabel WHERE
{
pdio:Q1044 pdiot:P129 ?origin.
pdio:Q1044 pdiot:P129 ?destination.
pdio:Q1044 pdiop:P130 ?association_statement.
?association_statement pdiopq:P131 ?origin.
?association_statement pdiopq:P132 ?destination.
?association_statement pdiops:P130 ?edge.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
extended view of various Facebook tools, and how they exchange information (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:Q366 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.
}
}.
}
how disinformation blends into our information ecosystem through Facebook (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:Q384 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.
}
}.
}
summary of the Cambridge Analytica scandal (embedded)
Adtech
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 ?_image WHERE {
?item pdiot:P28 pdio:Q370.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
OPTIONAL { ?item pdiot:P47 ?_image. }
}
LIMIT 100
adtech mess... we need an ontology (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 ?label ?_image WHERE {
?item pdiot:P3 pdio:Q1588.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
?item rdfs:label ?label
}
OPTIONAL { ?item pdiot:P47 ?_image. }
}
LIMIT 100
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 ?object ?objectLabel ?rgb ?subject ?subjectLabel
WHERE {
VALUES (?object ?rgb){
(pdio:Q110 "FF0000")
(pdio:Q495 "00FF00")
(pdio:Q559 "0000FF")
(pdio:Q153 "333333")
(pdio:Q491 "888800")
(pdio:Q807 "008888")
(pdio:Q492 "880088")
(pdio:Q498 "440000")
(pdio:Q810 "004400")
(pdio:Q556 "000044")
(pdio:Q504 "004444")
(pdio:Q874 "444400")
(pdio:Q834 "440044")
}
VALUES ?predicate {
pdiot:P3
pdiot:P28
}
?subject ?predicate ?object
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
LIMIT 1000
Lumascape-like map of the ecosystem (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 ?label ?_image WHERE {
?item pdiot:P3 pdio:Q110.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
?item rdfs:label ?label
}
OPTIONAL { ?item pdiot:P47 ?_image. }
}
LIMIT 100
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 ?label ?_image WHERE {
?item pdiot:P37 pdio:Q495.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
?item rdfs:label ?label
}
OPTIONAL { ?item pdiot:P47 ?_image. }
}
LIMIT 100
data management platforms (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 ?label ?_image WHERE {
?item pdiot:P37 pdio:Q559.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
?item rdfs:label ?label
}
OPTIONAL { ?item pdiot:P47 ?_image. }
}
LIMIT 100
identity resolution services (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 ?item1 ?item1Label ?rgb ?item2 ?item2Label
WITH {
SELECT ?predicateFilterValue ?predicateFilterValueRGB WHERE {
VALUES (?predicateFilterValue ?predicateFilterValueRGB) {
(pdio:Q110 "EEEEEE")(pdio:Q495 "222288")(pdio:Q559 "8822222")
}
}
}
AS %predicateFilterValues
WITH {
SELECT ?predicate ?subjectValue ?objectValue ?predicateRGB WHERE {
VALUES (?predicate ?subjectValue ?objectValue ?predicateRGB) {
(pdiot:P111 pdio:Q495 pdio:Q559 "EEEEEE")(pdiot:P111 pdio:Q495 pdio:Q559 "222288")
}
}
}
AS %predicates
WITH {SELECT ?node ?nodeRGB WHERE {
?node pdiot:P3 ?predicateFilterValue.
INCLUDE %predicateFilterValues.
BIND(?predicateFilterValueRGB AS ?nodeRGB)
}
}
AS %nodes
WITH {SELECT ?subject ?object ?edgeRGB WHERE {
INCLUDE %predicates.
?subject pdiot:P3 ?subjectValue.
?object pdiot:P3 ?objectValue.
?subject ?predicate ?object.
# This is filtering for each edge twice, potentially a huge waste: |E|*|V| instead of |V|
BIND(?predicateRGB as ?edgeRGB)
}
} AS %edges
WHERE {
{ # The caption's nodes:
INCLUDE %predicateFilterValues.
BIND(?predicateFilterValue AS ?item1).
BIND(?predicateValueRGB AS ?rgb).
}
UNION
{ # The caption's edges:
INCLUDE %predicates.
BIND(?subjectValue AS ?item1).
BIND(?objectValue AS ?item2).
BIND(?predicateRGB AS ?rgb).
}
UNION
{
INCLUDE %nodes.
BIND(?node AS ?item1).
BIND(?nodeRGB AS ?rgb).
}
UNION
{
INCLUDE %edges.
BIND(?subject AS ?item1).
BIND(?object AS ?item2).
BIND(?edgeRGB AS ?rgb).
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
}
}
LIMIT 10000
Gig 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/>
SELECT ?origin ?originLabel ?destination ?destinationLabel ?rgb ?edgeLabel WHERE
{
pdio:Q1070 pdiot:P129 ?origin.
pdio:Q1070 pdiot:P129 ?destination.
pdio:Q1070 pdiop:P130 ?association_statement.
?association_statement pdiopq:P131 ?origin.
?association_statement pdiopq:P132 ?destination.
?association_statement pdiops:P130 ?edge.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}