User:Daanvr

Babel user information

nl-N	Deze gebruiker heeft het Nederlands als moedertaal.

en-4	This user has near native speaker knowledge of English.

fr-4	Cet utilisateur dispose de connaissances proches de la langue maternelle en français.

de-1	Dieser Benutzer beherrscht Deutsch auf grundlegendem Niveau.

This user uses QuickStatements.

This user has a page on English Wikipedia.

This is my Wikidata user page. I also have a Wikimedia Commons user page. Here is an incompleet map of images I uploaded

This user loves Wikidata.

User subpages

User:Daanvr/French accommodations import project

Tools I use for editing

Paws, Open Refine - Tool to add datasets to wikidata - got to know it throug: Wikipedia Weekly Network - LIVE Wikidata editing #55 OpenRefine
Depictor - Awesome tool to easily add "depicts" statments to images in Commons.
Wikidata Query Service - Advanced searches through the wolrd of Wikidata
Wikimedia Commons Query Service (Beta) - Advanced Search for images and what it depicts
WikiShootMe! (filter applied in link.) - Map helping to match Wikimedia, wikipedia and wikidata.
Quick Statements - Batch edit wikidata from an .csv file
- can be used with Qnumbers from Wikidata and with Mnumbers from Commons
Wikitree - Familiy tree visualisator
Structured Data Search - Easy search through Wikidata
Locator Tool - Geolocate photos from a Wikimedia Commons category
Link to find Instagram lcation IDs via google
Tabernacle - For vieuweing and editing in table mode
Commons query service
Minefield - a tool to convert file names form wikimedia commons to Mnumbers
Petscan

Queries links

Query exemples

API query examples

Useful queries for external services and bots

All properties and their values of a given item

# added 2022-08
# title: All Properties and Values of an Item
# Based on the "winwaed"'s answer on Stack Overflow: https://stackoverflow.com/questions/56486888/how-to-get-property-labels-from-wikidata-using-sparql

SELECT ?propLabel ?valueLabel
WHERE
{
  wd:Q243 ?a ?value.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } 
  ?prop wikibase:directClaim ?a .
}

Try it!

similar but with qualifiers based on this Stackoverflow answer

Other queries

UNESCO World Heritage Sites (including Tentative)

#defaultView:Map
SELECT ?item ?itemLabel ?itemDescription ?image (SAMPLE(?geo) AS ?geo) (SAMPLE(?pic) AS ?pic) (SAMPLE(?picAlbum) AS ?picAlbum) (SAMPLE(?article) AS ?article) WHERE {
         { ?item wdt:P4171 ?WorldHeritageTentative. }
  UNION  { ?item wdt:P757 ?WorldHeritage. }
  UNION  { ?item wdt:P31/wdt:P279* wd:Q9259.}
  
  OPTIONAL { ?item wdt:P625 ?geo. }
  OPTIONAL { ?item wdt:P18 ?pic. }
  OPTIONAL { ?item wdt:P373 ?picAlbum. }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en".
    ?item rdfs:label ?itemLabel;
      schema:description ?itemDescription.
  }
  OPTIONAL {
    ?article schema:about ?item;
      schema:isPartOf <https://en.wikipedia.org/>.
  }
}
GROUP BY ?item ?itemLabel ?itemDescription ?image

Try it!

Ancient history query

#defaultView:Map
            SELECT DISTINCT ?item ?itemLabel ?itemDescription ?geo ?img ?commons ?instanceOf ?instanceOfLabel ?sitelink WHERE {
              # \"instance of\" \"Roman amphitheatre\" or(UNION) \"Greek theatre\" or one of it's subclasses(/wdt:P279*)
              {?item wdt:P31/wdt:P279* wd:Q7362268.} #Roman amphitheatre
              UNION {?item wdt:P31/wdt:P279* wd:Q2860319} #Greek Theater
              UNION {?item wdt:P31/wdt:P279* wd:Q69391739} #Greek colony
              UNION {?item wdt:P31/wdt:P279* wd:Q24933318} #Galo-roman amphiteaters
              UNION {?item wdt:P31/wdt:P279* wd:Q6581615} #Thermae
              UNION {?item wdt:P31/wdt:P279* wd:Q19757} #Roman theatre
              UNION {?item wdt:P31/wdt:P279* wd:Q867143} #Roman temple
              UNION {?item wdt:P31/wdt:P279* wd:Q918230} #Roman villa
              UNION {?item wdt:P31/wdt:P279* wd:Q2202509} #Roman city
              UNION {?item wdt:P31/wdt:P279* wd:Q782970} #domus 
              UNION {?item wdt:P31/wdt:P279* wd:Q252021} #villa rustica
              UNION {?item wdt:P31/wdt:P279* wd:Q180927} #mastaba 
              UNION {?item wdt:P31/wdt:P279* wd:Q2270185} #Mesoamerican pyramids 
              UNION {?item wdt:P31/wdt:P279* wd:Q1456099} #step pyramid
              UNION {?item wdt:P31/wdt:P279* wd:Q731966} #nymphaeum 
              UNION {?item wdt:P361/wdt:P279* wd:Q38888} #Olympia 
              UNION {?item wdt:P361/wdt:P279* wd:Q43332} #Pompeii 
              UNION {?item wdt:P31/wdt:P279* wd:Q6581615} #thermae  
              UNION {?item wdt:P31/wdt:P279* wd:Q1473950} #stepwell 
              UNION {?item wdt:P31/wdt:P279* wd:Q3411290} #smooth-sided pyramid
              UNION {?item wdt:P31/wdt:P279* wd:Q200141} #necropolis v
              UNION {?item wdt:P31/wdt:P279* wd:Q877152} #White elephant
              UNION {?item wdt:P31/wdt:P279* wd:Q12223988} #sphinx 
              UNION {?item wdt:P31/wdt:P279* wd:Q66108498} #Wonder of the Ancient World
              UNION {?item wdt:P31/wdt:P279* wd:Q13466456} #house of millions of years
              UNION {?item wdt:P31/wdt:P279* wd:Q665247} #hypogeum 
              UNION {?item wdt:P179/wdt:P279* wd:Q458082} #list of burials in the Valley of the Kings
              UNION {?item wdt:P179/wdt:P279* wd:Q690551} #list of Theban Tombs
              UNION {?item wdt:P136/wdt:P279* wd:Q6611811} #list of colossal sculpture in situ
              UNION {?item wdt:P31/wdt:P279* wd:Q855747} #Egyptian temple 
              UNION {?item wdt:P31/wdt:P279* wd:Q15661340} #ancient city 
              UNION {?item wdt:P361/wdt:P279* wd:Q5788} #Petra  
              UNION {?item wdt:P5008/wdt:P279* wd:Q68074438} #WikiProject Livius 
              UNION {?item wdt:P2596/wdt:P279* wd:Q220594} #Nabataeans  
              UNION {?item wdt:P361/wdt:P279* wd:Q163607} #Angkor 
              UNION {?item wdt:P361/wdt:P279* wd:Q1493784} #Chemtou, archaeological site in Tunisia 
              UNION {?item wdt:P361/wdt:P279* wd:Q3378708} #Pheradi Majius
              UNION {
                ?romanArchio wdt:P2596 wd:Q1747689. #everything Ancient Rome
                ?romanArchio wdt:P625 ?notRelavant. #Only keep thing with a location
                ?item wd:* ?romanArchio. #add them to item
              } # Anicent Roman Locations
                UNION {
                ?romanCity wdt:P31/wdt:P279* wd:Q2202509. #everything Ancient Rome
                ?romanCity wdt:P625 ?notRelavant. #Only keep archiological site
                ?item wd:* ?romanCity. #add them to item
              }  
              ?item wdt:P625 ?geo . #Filter on \"has a location\"
              OPTIONAL {?item wdt:P18 ?img}. # if result has a location, get it
              OPTIONAL {?item wdt:P373 ?commons}. # wiki commons img categorie
              OPTIONAL {?item wdt:P31 ?instanceOf}. #Hat is it part of?
              OPTIONAL { ?sitelink schema:about ?item.
                ?sitelink schema:isPartOf <https://en.wikipedia.org/>. }
            
              SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
            
            }
            LIMIT 10000

Try it!

Windmils in commons pictues query

A http://wcqs-beta.wmflabs.org query. Quering images dipicting windmils, and bringing along coordinates when they exist. For more Wikimedia Commons Query Service Exemples

#defaultView:ImageGrid
SELECT ?file ?image ?geo WHERE {
  ?file wdt:P180 wd:Q38720;
    schema:contentUrl ?url.
   OPTIONAL{ ?file wdt:P1259 ?geo.} #location on the point ov vieuw
   OPTIONAL{ ?file wdt:P625 ?geo2.} #location
  BIND(IRI(CONCAT("http://commons.wikimedia.org/wiki/Special:FilePath/", wikibase:decodeUri(SUBSTR(STR(?url), 53 )))) AS ?image)
}

Try it!

get almoost all items in map vieuw (coordinat box)

#defaultView:ImageGride
SELECT
  ?itemNew ?itemNewLabel ?itemNewDescription
  ?geo ?img ?categorie
  (GROUP_CONCAT(?instanceLabel; SEPARATOR = ", ") AS ?instancesof) # a nices String with the labels of the different instances of related to the item
WITH
{
  SELECT 
    ?itemNew 
    (SAMPLE(?geo_) AS ?geo) # The SAMPLE code is needed to inform the GROUP BY code what to do when there are more than one.
    (SAMPLE(?img_) AS ?img)
  WHERE
  {
    #### Selection based on location ####   
    SERVICE wikibase:box
    {
      ?itemNew wdt:P625 ?geo_.
      bd:serviceParam wikibase:cornerWest "Point(2.30 48.87)"^^geo:wktLiteral. 
      bd:serviceParam wikibase:cornerEast "Point(2.32 48.86)"^^geo:wktLiteral.
    }

    MINUS { ?itemNew (wdt:P31/(wdt:P279*)) wd:Q376799. } # Remove everything related to roads
    ?itemNew wdt:P18 ?img_. # Only keep items with pictures
  }
  GROUP BY ?itemNew
} AS %get_items
WHERE
{
  INCLUDE %get_items

  #### Categorise items ####
  BIND(
    IF(EXISTS {?itemNew (wdt:P31/(wdt:P279*)) wd:Q811979},
       "Architectural",
       IF(EXISTS {?itemNew (wdt:P31/(wdt:P279*)) wd:Q1656682},
          "Event",
          "Other"
         )
      )
  AS ?categorie)
  
  OPTIONAL { ?itemNew wdt:P31 ?instance. } # Get instances
   
  #### Wikipedia link ####
  OPTIONAL {
    ?article schema:about ?itemNew . # Get wikipedia link
    ?article schema:isPartOf <https://en.wikipedia.org/>. # Only keep EN language
  }
  
  #### Labels & discription #### 
  SERVICE wikibase:label { # Get labels
    bd:serviceParam wikibase:language "en". 
    ?instance rdfs:label ?instanceLabel.      # The specification of the variables to be labeld is needed for grouping the instances of correctly
    ?itemNew rdfs:label ?itemNewLabel.
    ?itemNew schema:description ?itemNewDescription.
  }
}
GROUP BY ?itemNew ?itemNewLabel ?itemNewDescription ?geo ?img ?categorie ?article

Try it!

Nazi death camps query

A map of Nazi death camp locations in a SPARQL query It is impressive to see the quantity of camps.

Digital Atlas of the Roman Empire query

Here follows an evolution of a query I have written to find the historical location of the Roman era that can be visited today.

Wikidata SPARQL query - added a filter that filters down to include only locations that are archaeological sites and have a Commons album link and/or property.

Wikidata SPARQL query - first attempt at combining sources

Wikidata SPARQL query - original query: all items that have a "Digital Atlas of the Roman Empire ID" property.

Next up: making a tool to loop through all locations and determine by hand how interesting each location is to visit.

I am using the data from this query to add to the hand-picked data set behind my pet project showing interesting places from Roman history to visit.

Adding Google Maps CID to a Wikidata item

It is not straight forward. The Google Maps CID used as a Reference code from the Wikidata item is hidden.

Step 1: Find and select the correct Google Maps item.
Step 2: Find the Hexadecimal CID by look for the second string of characters just after the "0x" ending before the "!" in the URL.
- exemple: google.com/maps/place/Le+Collectif+du+Château+de+Verchaüs/@44.5102554,4.6807098,3a,75y,90t/data=!3m8!1e2!3m6!1sAF1QipOlaaaRfNV0HAa9B1ZdCJpi6vueTCZtxSYngN6W!2e10!3e12!6shttps:%2F%2Flh5.googleusercontent.com%2Fp%2FAF1QipOlaaaRfNV0HAa9B1ZdCJpi6vueTCZtxSYngN6W%3Dw203-h360-k-no!7i1836!8i3264!4m5!3m4!1s0x0:0x24627753b48d58a4!8m2!3d44.510282!4d4.680589
- When lost, try this guid: and look for the section called: "From Google Maps for an SAB Listing (with hidden address)"
Step 3: convert the Hexadecimal to a number. This tool does the job among others.
Step 4: Add the CID as a Google Maps Customer ID (P3749) to the correct Wikidata item.

User subpages

Tools I use for editing

Further reading for me

Queries links

Query exemples

API query examples

All properties and their values of a given item

Other queries

UNESCO World Heritage Sites (including Tentative)

Ancient history query

Windmils in commons pictues query

get almoost all items in map vieuw (coordinat box)

Nazi death camps query

Digital Atlas of the Roman Empire query

Adding Google Maps CID to a Wikidata item