User talk:Shyamal/Archive 1

Welcome to Wikidata, Shyamal!

Wikidata is a free knowledge base that you can edit! It can be read and edited by humans and machines alike and you can go to any item page now and add to this ever-growing database!

Need some help getting started? Here are some pages you can familiarize yourself with:

• Introduction – An introduction to the project.
• Wikidata tours – Interactive tutorials to show you how Wikidata works.
• Community portal – The portal for community members.
• User options – including the 'Babel' extension, to set your language preferences.
• Contents – The main help page for editing and using the site.
• Project chat – Discussions about the project.
• Tools – A collection of user-developed tools to allow for easier completion of some tasks.

Please remember to sign your messages on talk pages by typing four tildes (~~~~); this will automatically insert your username and the date.

If you have any questions, don't hesitate to ask on Project chat. If you want to try out editing, you can use the sandbox to try. Once again, welcome, and I hope you quickly feel comfortable here, and become an active editor for Wikidata.

Best regards! Jon Harald Søby (talk) 14:38, 25 January 2016 (UTC)

test

<iframe style="width:80vw; height:50vh;" frameborder="0" src="https://query.wikidata.org/embed.html#SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3Fpic%20%3Fdob%20%3Fdod%0AWHERE%20%7B%0A%09%3Fitem%20wdt%3AP106%20wd%3AQ901%20.%09%09%23%20scientist%20only%0A%09%7B%20%3Fitem%20wdt%3AP19%2F%20wdt%3AP131%2a%20wd%3AQ64%20%7D%09%23%20place%20of%20birth%20Berlin%20%0A%09%09UNION%20%7B%20%3Fitem%20wdt%3AP20%2F%20wdt%3AP131%2a%20wd%3AQ64%20%7D%09%23%20place%20of%20death%20Berlin%0A%20%20%20%20%20%20%20%20%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP569%20%3Fdob%20%20%7D%0A%20%20%20%20%20%20%20%20%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP570%20%3Fdod%20%20%7D%0A%20%20%20%20%20%20%20%20%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP18%20%3Fpic%20%7D%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D%0A%23Order%20by%20date%20of%20birth%2C%20avoid%20overriding%20this%20in%20the%20template%20with%20sort%3D%0AORDER%20BY%20%3Fdob">

Scientists who were born or died in Berlin

@Ijon: Why does this pick "Theologians"? I went up the occupation tree and removed a couple of what appeared to be problematic classifications - this and this but evidently that is not the solution.

SELECT DISTINCT ?item ?itemLabel ?itemDescription ?dob ?dod 
WHERE{
  ?item wdt:P106/wdt:P279*  wd:Q901 .		# scientist/subclass of scientist 
	{ ?item wdt:P19 wd:Q64 }			# place of birth = Berlin (Q64)
		UNION	{ ?item wdt:P20 wd:Q64 }	# place of death = Berlin (Q64)
	OPTIONAL { ?item wdt:P569 ?dob  }
  	OPTIONAL { ?item wdt:P570 ?dod  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?dob

Try it!

Indian scientists born in March

SELECT DISTINCT ?item ?itemLabel ?itemDescription ?dob ?dod 
WHERE{
  ?item wdt:P106/wdt:P279*  wd:Q901 .		# scientist/subclass of scientist 
	{ ?item wdt:P27 wd:Q668 }			# place of birth = India
	OPTIONAL { ?item wdt:P569 ?dob  }
  	OPTIONAL { ?item wdt:P570 ?dod  }
   FILTER (month(?dob) = 3) .  # born in March (=3)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?dob

Try it!

Protected areas in India

This was not showing Rollapadu Wildlife Sanctuary - hoping it is an indexing delay - let's try this query again soon.

#defaultView:Map
SELECT ?itemLabel ?itemDescription ?coord WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q473972.
  ?item wdt:P17 wd:Q668.
  ?item wdt:P625 ?coord.
  OPTIONAL { ?item wdt:P18 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Bangalore inscriptions

SELECT ?itemLabel ?itemDescription ?image ?coord WHERE {
  ?item (wdt:P31/wdt:P279*) wd:Q4989906.
  ?item wdt:P17 wd:Q668.
  OPTIONAL {?item wdt:P625 ?coord.}
  OPTIONAL { ?item wdt:P18 ?image. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
#List of all the memorials in India
##defaultView:Map

Try it!

Incorrect merge

Hi - You merged Q55454471 (D. Griffin) into Q327908 (Donald Griffin). Unfortunately they are different people. I don't know that much about D. Griffin, but what I do know is that he attended a meeting of the British Ornithologists Club in 2007, 4 years after Donald Griffin died (see page 253 of this document: https://www.archive.org/download/bulletinofbritis1274brit/bulletinofbritis1274brit.pdf . Also, D. Griffin was active in the UK and based on my reading of Donald Griffin, there is no evidence he was. Could you undo the merge? Thanks. JerryL2017 (talk) 07:05, 10 March 2021 (UTC)

I have no idea how to undo a merge but you could probably recreate D. Griffin perhaps with more data items that would distinguish them from others. Shyamal (talk) 07:26, 10 March 2021 (UTC)

Scientists born in July

SELECT DISTINCT ?item ?itemLabel ?itemDescription ?dob ?dod 
WHERE{
  ?item wdt:P106/wdt:P279*  wd:Q901 .		# scientist/subclass of scientist 
	OPTIONAL { ?item wdt:P569 ?dob  }
  	OPTIONAL { ?item wdt:P570 ?dod  }
   FILTER (month(?dob) = 7) .  # born in March (=3)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?dob

Try it!

Shyamal (talk) 13:48, 4 July 2023 (UTC)