User:Daanvr
Babel user information | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
Users by language |
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
[edit]Tools I use for editing
[edit]- 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
Further reading for me
[edit]- https://wikitech.wikimedia.org/wiki/Portal:Toolforge
- WikiProject Ancient Greece
- WikiProject Ancient Rome
- Query for museums twitter handels
Queries links
[edit]- Anything related to the Russian invasion of Ukraine in 2022
- In France but no country(P17)
- Layerd map of Dutch fortifications
- Metro stations on a world map
- All coats of arms from an entity located in France.
- Windmils in the Netherlands
- Instagram location IDs, with optional pictures and location
- Items with a Hotel ID
- List of Hotel Ids
- Has statment connecting it to Olst/Deventer but no coordinates location
- locations that have no Instragem location ID in the Ardeche
- items in the Netherlands that have a Commons categorie but no image - potentialy easy to add an image from the comons category of images.
- Chateau's in France with no image
- Chateau's in France with an image but with no Commons category
- All properties and values from a given item
Query exemples
[edit]API query examples
[edit]Useful queries for external services and bots
All properties and their values of a given item
[edit]# 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 .
}
similar but with qualifiers based on this Stackoverflow answer
Other queries
[edit]UNESCO World Heritage Sites (including Tentative)
[edit]#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
Ancient history query
[edit]#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
Windmils in commons pictues query
[edit]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)
}
get almoost all items in map vieuw (coordinat box)
[edit]#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
Nazi death camps query
[edit]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
[edit]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
[edit]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.
![](http://178.128.105.246/cars-http-upload.wikimedia.org/wikipedia/commons/thumb/8/80/Wikidata_heart_logo.svg/375px-Wikidata_heart_logo.svg.png)