Wikidata

ValterVB

Joined 2 November 2012

it:Utente:ValterVB

Babel user information
it-N Questo utente può contribuire con un livello madrelingua in italiano.
en-2 This user has intermediate knowledge of English.
fr-0 Cet utilisateur n’a aucune connaissance en français (ou le comprend avec de grandes difficultés).
es-0 Este usuario no tiene ningún conocimiento del español (o lo entiende con mucha dificultad).
de-0 Dieser Benutzer beherrscht Deutsch nicht (oder versteht es nur mit beträchtlichen Schwierigkeiten).
vec-0 Sta utensa cuà no ła ga nisun conosimento de ła łéngua vèneta (o ła capise co granda fadiga).
This user is a member of
WikiProject Italy.
Users by language


Requests for deletions

high

~120 open requests for deletions.

Agenda edit

Pasqua 2018 Update of Wikidata:WikiProject Disambiguation pages/Wikisomething disambiguation page conflict

SPARQL edit


  • ?item schema:description ?descriptionEn FILTER (LANG (?descriptionEn) = "en") . useful to have a description in a specific language
  • Subquery to try to avoid time out fot service label (Optimization for labels Link)
select distinct ?prop ?propLabel {
  { SELECT DISTINCT ?prop {
   ?item (p:P1766|p:P41|p:P4004) [?qual []] .
   ?prop wikibase:qualifier ?qual .
  } LIMIT 1 }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Try it! 
  • SELECT ?item ?itemDescription {
  ?item wdt:P31 wd:Q4167410; schema:description ?itemDescription .
  FILTER(LANG(?itemDescription) = 'en') .
  FILTER(REGEX(STR(?itemDescription), '^Wiki[pm]edia disambiguation page$') = false) .
} LIMIT 100
    Try it! 
  • SELECT ?item ?itemLabel ?istLabel ?admin ?adminLabel ?adminDescription ?start ?end WHERE {
  VALUES ?admin { wd:Q16287 wd:Q18288162 wd:Q426025 wd:Q28769238 wd:Q2567535}
  ?item wdt:P31 ?ist .
  ?stat ps:P131 ?admin.
  ?item p:P131 ?stat; #The trick is the semicolon
  OPTIONAL { ?stat pq:P580 ?start. }
  OPTIONAL { ?stat pq:P582 ?end. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "it". }
} ORDER BY ?item ?start
    Try it! 
  • SELECT ?item ?itDescrizione WITH {
  SELECT ?item {
    BIND( 1000000 * 30 AS ?base ) . # change this 0-30
    ?item wdt:P31 wd:Q4167836 .
    BIND( xsd:integer( STRAFTER( STR( ?item ), STR( wd:Q ) ) ) AS ?num ) .
    FILTER( ?num > ?base + 0 && ?num < ?base + 1000001 ) .
  }
} AS %sub WHERE {
  INCLUDE %sub .
  ?item schema:description ?itDescrizione FILTER( LANG( ?itDescrizione ) = 'it' ) .
  FILTER( STR( ?itDescrizione ) != 'categoria di un progetto Wikimedia' ) .
}
    Try it! 
  • SELECT ?item ?description {
  ?item wdt:P31 wd:Q4167410.
  ?item schema:description ?description .
  FILTER( LANG( ?description ) = 'en' && REGEX( STR( ?description ), 'Wikipedia disambiguation page' ) ) .
} LIMIT 50000
    Try it!

BOT edit

Dirty Job edit

Label and description edit

Candidates to delete edit

Others edit

Useful link edit

Visual control of coordinates edit

SPARQL + Map

List of occupation for Bio infobox edit

User:ValterVB/Sandbox

Other edit

Stats edit

Admin statistics
Action Count
Edits 889,661
Edits+Deleted 896,969
Pages deleted 205,002
Pages restored 1,548
Pages protected 12
Protections modified 2
Users blocked 44
Users reblocked 2
User rights modified 31
Wikidata statistics
 
  Number of pages 114,441,848  
  User total 6,445,914  
  Active users list 25,065  
  Administrators 71  
  Users/administrator 353  
Retrieved from "https://www.wikidata.org/w/index.php?title=User:ValterVB&oldid=1441987025"