đŸȘŽ JachĂ©re

Collected Notes 2024-09

Mar 01, 20242 min read

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.

mapping-robox

  • 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

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" }
}