Log 2024-09

I will attempt to finish the second Wikidata sprint this or next week with adding releases and genre (and maybe some gameplay infos). After that I will continue to expand to the already written SPARQL queries. If time allows, I’ll have a go at some visualisations of the dataset.
Had a good talk with Julien again. He gave me a overview of Linked Art and we discussed a bit to what end somebody would want to model something, which is an important topic, considering the effort that can go in such an endeavour. Most of the initial problems I had with Wikidata and modelling were resolved by the application of property qualifiers.
Drafted a first mapping of Robox. I do have a lot of pieces in this case and I would be able to actually map pieces of code to what is visible on screen, thanks to the way the game files are organized. I will be able to advance here, once I was able to conduct the second interview and get a hold of the source code.

Played with pixplot and the current state of the Assembling a Video Game Screenshots Corpus. I need more image… It’s showing slight hints of something meaningful, but nowhere near close to something interesting.

pixplot-umap-cluster-closeup pixplot-umap-grid

I found a gist on how to query wikidata directly from Gephi, which makes it a great choice to explore the data through graph visualisation. I adapted my query according to the Gephi plugin’s need.

PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX gephi: <http://gephi.org/#>

CONSTRUCT {
    ?item gephi:category "video game" .
    ?item gephi:label ?itemLabel .

    ?programmer gephi:category "programmer" .
    ?programmer gephi:label ?programmerLabel .
    ?item wdt:P943 ?programmer .

    ?gameartist gephi:category "gameartist" .
    ?gameartist gephi:label ?gameartistLabel .
    ?item wdt:P3080 ?gameartist .

    ?composer gephi:category "composer" .
    ?composer gephi:label ?composerLabel .
    ?item wdt:P86 ?composer .

    ?publisher gephi:category "publisher" .
    ?publisher gephi:label ?publisherLabel .
    ?item wdt:P123 ?publisher .

    ?developer gephi:category "developer" .
    ?developer gephi:label ?developerLabel .
    ?item wdt:P178 ?developer .
} WHERE {
    ?item wdt:P31 wd:Q7889 ;
     wdt:P495 wd:Q39 ;
     wdt:P577 ?publicationDate .

    OPTIONAL { ?item wdt:P943 ?programmer . }
    OPTIONAL { ?item wdt:P3080 ?gameartist . }
    OPTIONAL { ?item wdt:P86 ?composer . }
    OPTIONAL { ?item wdt:P123 ?developer . }
    OPTIONAL { ?item wdt:P178 ?publisher . }
   
    FILTER ( ?publicationDate <= "2000-01-01T00:00:00Z"^^xsd:dateTime )
  
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,fr" }
}