User:Marius851000

From Wikidata
Jump to navigation Jump to search

Hello! This page is mostly note but please take a look at my Dragon Map based on WikiData (unfinished) at https://dragons.mariusdavid.fr!

Otherwise, I like doing stuff with automatic presentation. Feel free to take a look at my notes

Babel user information
fr-N Cet utilisateur a pour langue maternelle le français.
en-4 This user has near native speaker knowledge of English.
es-1 Esta persona tiene un conocimiento básico del español.
eo-1 Ĉi tiu uzanto povas komuniki per baza nivelo de Esperanto.
nl-0 Deze gebruiker heeft geen kennis van het Nederlands (of begrijpt het met grote moeite).
it-0 Questo utente non è in grado di comunicare in italiano (o lo capisce solo con notevole difficoltà).
de-0 Dieser Benutzer beherrscht Deutsch nicht (oder versteht es nur mit beträchtlichen Schwierigkeiten).
Users by language

Complete https://www.wikidata.org/wiki/Q117598956 (this is the lead animator of Ga’Hoole and also made a bunch of fascinating blog post about bird animation)

User:marius851000/Sandbox

Module:Sandbox/marius851000/dub

Module:Sandbox/marius851000/mkey

Module:Sandbox/marius851000/wikitable3d

Localized voice actor of the legend of spyro : A New Beggining

French English
Terrador Marc Alfos Kevin Michael Richardson
Flash Marc Alfos Jeff Bennett
Ignitus Gabriel Le Doze Gary Oldman
Spyro Alexandre Gillet Elijah Wood
The conductor anonymous Kevin Michael Richardson
Cyril Laurent Morteau Jeff Bennett
Nina Vanina Pradier Vanessa Marshall
Cynder Nathalie Homs Cree Summer
Kane Damien Boisseau Phil LaMarr
Sparx Guillaume Lebon David Spade
Exhumor anonymous Corey Burton
Volteer Gilbert Levy Corey Burton
Mole-yair Gilbert Levy Jeff Bennett


same, but with My Little Pony: A New Generation (Q105747750)

English French Russian
Rainbow Dash Ashleigh Ball anonymous anonymous
Pinkie Pie Andrea Libman Nathalie Hugo anonymous
Alphabittle Phil LaMarr Jean-Michel Vovk anonymous
Pipp Petals Sofia Carson Marghe anonymous
Sprout Alan Schmuckler anonymous anonymous
Fluttershy Andrea Libman Élisabeth Guinand anonymous
Rarity Tabitha St. Germain anonymous anonymous
Sunny Starscout Vanessa Hudgens Cerise Calixte Maria Ivashchenko
Queen Haven Jane Krakowski anonymous anonymous
Zipp Storm Liza Koshy anonymous Tatyana Shitova
Twilight Sparkle Tara Strong Claire Tefnin anonymous
Argyle Michael McKean anonymous anonymous
Phyllis Elizabeth Perkins anonymous anonymous
Izzy Moonbow Kimiko Glenn anonymous anonymous
Applejack Ashleigh Ball anonymous anonymous
Hitch Trailblazer James Marsden Matthieu Meunier anonymous


My Little Pony: Make Your Mark (Q111749122)

English French
Opaline Athena Karkanis anonymous
Misty Bahia Watson Béatrice Wegnez
Sprout anonymous Pierre Le Bec
Queen Haven anonymous Olivia Auclair
Sugar Moonlight anonymous Nathalie Hugo
Jazz Hooves anonymous Élisabeth Guinand
Windy anonymous Élisabeth Guinand
Toots anonymous Grégory Praet
Pipp Petals A. J. Bridel Stéphanie Vondenhoff
Sweets anonymous Nathalie Hugo
Seashell anonymous Élisabeth Guinand
Sunny Starscout anonymous Sofia Abouatmane
Twilight Sparkle anonymous Claire Tefnin
Hitch Trailblazer anonymous Matthieu Menier
Dahlia anonymous Ambre Grouwels
Peach Fizz anonymous Ambre Grouwels
Izzy Moonbow anonymous Aaricia Dubois
Sparky Sparkeroni Robert Tinkler anonymous
Zipp Storm Maitreyi Ramakrishnan Christa Jérôme


Moana (Q18647981)

Arabic
Villager #3 anonymous
Sina anonymous
Villager #1 anonymous
Tamatoa anonymous
Fisherman anonymous
additional voices anonymous
Villager #2 anonymous
Chief Tui Ziad Charif
Gramma Tala anonymous
Maui anonymous
Heihei anonymous
Moana anonymous


TODO:

Super plan for PS1 game matching : scrape redump.org add the playstation game id on wikidata link id with https://mix-n-match.toolforge.org/#/list/3144/manual

Show map of place depicting dragons

#defaultView:Map
SELECT DISTINCT ?item ?itemLabel ?coords ?image ?rgb WHERE {
  BIND(IF(BOUND(?image), "00FF00", "FF0000") as ?rgb).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,de". }
  {
    SELECT DISTINCT ?item ?coords ?image WHERE {
      ?item p:P180 ?depict.
      { ?depict (ps:P180/wdt:P31*/wdt:P279*) wd:Q7559. }
      UNION
      { ?depict (ps:P180/wdt:P31*/wdt:P279*) wd:Q30170627. }
      ?item p:P625 ?statement1.
      ?statement1 (ps:P625) ?coords.
      OPTIONAL { ?item wdt:P18 ?image. }
      
    }
    LIMIT 500
  }
}

Scrapped code to display work of art (Q838948) near La Roche-sur-Yon (Q190118). <syntaxghighlight lang="sparql">

  1. defaultView:Map

SELECT ?place ?placeLabel ?location WHERE {

 # Berlin coordinates
 wd:Q190118 wdt:P625 ?lrsyLoc . 
 SERVICE wikibase:around { 
     ?place wdt:P625 ?location . 
     bd:serviceParam wikibase:center ?lrsyLoc . 
     bd:serviceParam wikibase:radius "20" .
 } 
 FILTER EXISTS {
   ?place wdt:P31/wdt:P279* wd:Q838948 .
 }
 SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en". } 

} </syntaxhighlight>

Note about potential mashup of online video-game source[edit]

There is a number of public databases about video game, that I notice when doing data matching on mix-n-match. Most commonly, they are:

  • How long to beat
  • IGDB
  • mobygames
  • Steam
  • pc gaming wiki

(it seems IGDB, How Long to beat and pcgamingwiki are mostly automatic import from Steam, or some other source)

As such, too important unique source of info are steam and mobygames.

User:Poslovitch, User:Facenapalm and User:KrBot seems to already be doing this kind of work -- need to do some learning about them...