On FactGrid we have matched all our items with the respective Wikidata Q-numbers (wherever possible). Does anybody know what SPARQL query I should use to get these numbers?
This is a geographical entity on our wikibase with the Wikidata number at the appropriate place
https://database.factgrid.de/wiki/Item:Q89076
and this is the SPARQL-query to all geographical places which I would love to get with the respective Wikidata numbers
Best, Olaf
Dr. Olaf Simons Forschungszentrum Gotha der Universität Erfurt Schloss Friedenstein, Pagenhaus 99867 Gotha
Büro: +49-361-737-1722 Mobil: +49-179-5196880
Privat: Hauptmarkt 17b/ 99867 Gotha
Hi Olaf,
Is it what you are looking for: https://database.factgrid.de/query/#SELECT%20%2a%20WHERE%20%7B%0A%20%20%3Fli... ?
Cheers, ~nicolas
Le mer. 22 janv. 2020 à 10:31, Olaf Simons olaf.simons@pierre-marteau.com a écrit :
On FactGrid we have matched all our items with the respective Wikidata Q-numbers (wherever possible). Does anybody know what SPARQL query I should use to get these numbers?
This is a geographical entity on our wikibase with the Wikidata number at the appropriate place
https://database.factgrid.de/wiki/Item:Q89076
and this is the SPARQL-query to all geographical places which I would love to get with the respective Wikidata numbers
Best, Olaf
Dr. Olaf Simons Forschungszentrum Gotha der Universität Erfurt Schloss Friedenstein, Pagenhaus 99867 Gotha
Büro: +49-361-737-1722 Mobil: +49-179-5196880
Privat: Hauptmarkt 17b/ 99867 Gotha
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
no, not quite. My problem is that the wikidata number (that appears in the Wiki-link section) is not organised as a regular Property entry - so I wonder how to ask for it in this search:
https://database.factgrid.de/query/
thanks, Olaf
Nicolas VIGNERON vigneron.nicolas@gmail.com hat am 22. Januar 2020 um 10:58 geschrieben:
Hi Olaf,
Is it what you are looking for: https://database.factgrid.de/query/#SELECT%20%2a%20WHERE%20%7B%0A%20%20%3Fli... ?
Cheers, ~nicolas
Le mer. 22 janv. 2020 à 10:31, Olaf Simons olaf.simons@pierre-marteau.com a écrit :
On FactGrid we have matched all our items with the respective Wikidata Q-numbers (wherever possible). Does anybody know what SPARQL query I should use to get these numbers?
This is a geographical entity on our wikibase with the Wikidata number at the appropriate place
https://database.factgrid.de/wiki/Item:Q89076
and this is the SPARQL-query to all geographical places which I would love to get with the respective Wikidata numbers
Best, Olaf
Dr. Olaf Simons Forschungszentrum Gotha der Universität Erfurt Schloss Friedenstein, Pagenhaus 99867 Gotha
Büro: +49-361-737-1722 Mobil: +49-179-5196880
Privat: Hauptmarkt 17b/ 99867 Gotha
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Dr. Olaf Simons Forschungszentrum Gotha der Universität Erfurt Schloss Friedenstein, Pagenhaus 99867 Gotha
Büro: +49-361-737-1722 Mobil: +49-179-5196880
Privat: Hauptmarkt 17b/ 99867 Gotha
Le mer. 22 janv. 2020 à 11:06, Olaf Simons olaf.simons@pierre-marteau.com a écrit :
no, not quite.
Hmm, not sure to understand what you want then, could you explain?
My problem is that the wikidata number (that appears in the Wiki-link
section) is not organised as a regular Property entry - so I wonder how to ask for it in this search:
Yes, that's why I used schema:about to get the wikilink (store in a link variable).
Here the same instruction but applied to your query (that I see in your second mail after I answered the first mail, sorry, maybe it will be more explicit like that) : https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20%3Fl...
Cheers, ~nicolas
and I gave a mutilated link again... This is my search:
https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20WHER...
now most of these places have a Wikidata reference, which you find in the section of Wikimedia-related projects (at the end or to the right, where you can link to Wikipedias).
https://database.factgrid.de/wiki/Item:Q10279
the Wikidata link is under "wikidatawiki"
I am wondering how I can have these Wikidata Q-numbers in a column. (I am just preparing a new input from Wikidata and want to make sure I do not create double records - identical Wikidata-numbers are the indicator that we already have the item...)
best, Olaf
This is my search for all the places on FactGrid
Nicolas VIGNERON vigneron.nicolas@gmail.com hat am 22. Januar 2020 um 11:26 geschrieben:
Le mer. 22 janv. 2020 à 11:06, Olaf Simons olaf.simons@pierre-marteau.com a écrit :
no, not quite.
Hmm, not sure to understand what you want then, could you explain?
My problem is that the wikidata number (that appears in the Wiki-link
section) is not organised as a regular Property entry - so I wonder how to ask for it in this search:
Yes, that's why I used schema:about to get the wikilink (store in a link variable).
Here the same instruction but applied to your query (that I see in your second mail after I answered the first mail, sorry, maybe it will be more explicit like that) : https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20%3Fl...
Cheers, ~nicolas
Dr. Olaf Simons Forschungszentrum Gotha der Universität Erfurt Schloss Friedenstein, Pagenhaus 99867 Gotha
Büro: +49-361-737-1722 Mobil: +49-179-5196880
Privat: Hauptmarkt 17b/ 99867 Gotha
Le mer. 22 janv. 2020 à 11:36, Olaf Simons olaf.simons@pierre-marteau.com a écrit :
and I gave a mutilated link again... This is my search:
https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20WHER...
now most of these places have a Wikidata reference, which you find in the section of Wikimedia-related projects (at the end or to the right, where you can link to Wikipedias).
https://database.factgrid.de/wiki/Item:Q10279
the Wikidata link is under "wikidatawiki"
I am wondering how I can have these Wikidata Q-numbers in a column. (I am just preparing a new input from Wikidata and want to make sure I do not create double records - identical Wikidata-numbers are the indicator that we already have the item...)
best, Olaf
I'm confused: what is the difference between your wish and the query a gave you? (because my query do have the « Wikidata Q-numbers in a column. »)
I've added a filter to have only the Wikidata links (my previous query gave all the links, wikidata or otherwise) : https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20%3Fl...
Cheers, ~nicolas
ah, I did not understand how I would expand this search - nice! that does my job,
thank you, Olaf
Nicolas VIGNERON vigneron.nicolas@gmail.com hat am 22. Januar 2020 um 12:03 geschrieben:
Le mer. 22 janv. 2020 à 11:36, Olaf Simons olaf.simons@pierre-marteau.com a écrit :
and I gave a mutilated link again... This is my search:
https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20WHER...
now most of these places have a Wikidata reference, which you find in the section of Wikimedia-related projects (at the end or to the right, where you can link to Wikipedias).
https://database.factgrid.de/wiki/Item:Q10279
the Wikidata link is under "wikidatawiki"
I am wondering how I can have these Wikidata Q-numbers in a column. (I am just preparing a new input from Wikidata and want to make sure I do not create double records - identical Wikidata-numbers are the indicator that we already have the item...)
best, Olaf
I'm confused: what is the difference between your wish and the query a gave you? (because my query do have the « Wikidata Q-numbers in a column. »)
I've added a filter to have only the Wikidata links (my previous query gave all the links, wikidata or otherwise) : https://database.factgrid.de/query/#SELECT%20%3Fplace%20%3FplaceLabel%20%3Fl...
Cheers, ~nicolas
Dr. Olaf Simons Forschungszentrum Gotha der Universität Erfurt Schloss Friedenstein, Pagenhaus 99867 Gotha
Büro: +49-361-737-1722 Mobil: +49-179-5196880
Privat: Hauptmarkt 17b/ 99867 Gotha