Hi,
I asked this on the Cloud mailing list[1] and got some useful advice but am still looking for a better answer. Apologies for cross-posting.
Take [2] as an example. We see that in this page, the entity Q2113430 has a property called GeoNames ID (property P1566) and that property has a value of 18918. *Where can I find the link *between Q2113430 <--> P1566 <--> 18918 *in the database?* (Not through the API, but via a direct SQL query on the database)
The idea is to get a list of all these triads to use for some investigation needed for [3].
Thanks in advance,
Huji
[1] https://lists.wikimedia.org/pipermail/cloud/2018-March/000244.html [2] https://www.wikidata.org/wiki/Q2113430 [3] https://phabricator.wikimedia.org/T174553
You can't. The value of properties such as GeoNames are literally not in the database.
Very roughly speaking - Wikidata uses mediawiki to store json blobs describing data. The actual data being stored is not exposed to the MediaWiki database. The idea instead is that people would export this data and use a specialized graph database to query it, such as https://query.wikidata.org/
The closest you can get is: select pl_from 'page id', page_title 'Q id' from pagelinks inner join page on page_id = pl_from where pl_namespace =120 and pl_title = 'P1566' limit 20;
Which will give you a list of pages that have the P1566 property (or otherwise link to it).
-- Brian
On Wed, Mar 14, 2018 at 1:45 AM, Huji Lee huji.huji@gmail.com wrote:
Hi,
I asked this on the Cloud mailing list[1] and got some useful advice but am still looking for a better answer. Apologies for cross-posting.
Take [2] as an example. We see that in this page, the entity Q2113430 has a property called GeoNames ID (property P1566) and that property has a value of 18918. *Where can I find the link *between Q2113430 <--> P1566 <--> 18918 *in the database?* (Not through the API, but via a direct SQL query on the database)
The idea is to get a list of all these triads to use for some investigation needed for [3].
Thanks in advance,
Huji
[1] https://lists.wikimedia.org/pipermail/cloud/2018-March/000244.html [2] https://www.wikidata.org/wiki/Q2113430 [3] https://phabricator.wikimedia.org/T174553 _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Ah, I see.
Are the JSON blobs dumped somewhere so I can process them using my own python script or something?
On Tue, Mar 13, 2018 at 11:20 PM, Brian Wolff bawolff@gmail.com wrote:
You can't. The value of properties such as GeoNames are literally not in the database.
Very roughly speaking - Wikidata uses mediawiki to store json blobs describing data. The actual data being stored is not exposed to the MediaWiki database. The idea instead is that people would export this data and use a specialized graph database to query it, such as https://query.wikidata.org/
The closest you can get is: select pl_from 'page id', page_title 'Q id' from pagelinks inner join page on page_id = pl_from where pl_namespace =120 and pl_title = 'P1566' limit 20;
Which will give you a list of pages that have the P1566 property (or otherwise link to it).
-- Brian
On Wed, Mar 14, 2018 at 1:45 AM, Huji Lee huji.huji@gmail.com wrote:
Hi,
I asked this on the Cloud mailing list[1] and got some useful advice but
am
still looking for a better answer. Apologies for cross-posting.
Take [2] as an example. We see that in this page, the entity Q2113430
has a
property called GeoNames ID (property P1566) and that property has a
value
of 18918. *Where can I find the link *between Q2113430 <--> P1566 <--> 18918 *in the database?* (Not through the API, but via a direct SQL query on the database)
The idea is to get a list of all these triads to use for some
investigation
needed for [3].
Thanks in advance,
Huji
[1] https://lists.wikimedia.org/pipermail/cloud/2018-March/000244.html [2] https://www.wikidata.org/wiki/Q2113430 [3] https://phabricator.wikimedia.org/T174553 _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
The answer to my own question is https://www.wikidata.org/wiki/Wikidata:Database_download
Thanks for the response though!
Huji
On Wed, Mar 14, 2018 at 7:51 AM, Huji Lee huji.huji@gmail.com wrote:
Ah, I see.
Are the JSON blobs dumped somewhere so I can process them using my own python script or something?
On Tue, Mar 13, 2018 at 11:20 PM, Brian Wolff bawolff@gmail.com wrote:
You can't. The value of properties such as GeoNames are literally not in the database.
Very roughly speaking - Wikidata uses mediawiki to store json blobs describing data. The actual data being stored is not exposed to the MediaWiki database. The idea instead is that people would export this data and use a specialized graph database to query it, such as https://query.wikidata.org/
The closest you can get is: select pl_from 'page id', page_title 'Q id' from pagelinks inner join page on page_id = pl_from where pl_namespace =120 and pl_title = 'P1566' limit 20;
Which will give you a list of pages that have the P1566 property (or otherwise link to it).
-- Brian
On Wed, Mar 14, 2018 at 1:45 AM, Huji Lee huji.huji@gmail.com wrote:
Hi,
I asked this on the Cloud mailing list[1] and got some useful advice
but am
still looking for a better answer. Apologies for cross-posting.
Take [2] as an example. We see that in this page, the entity Q2113430
has a
property called GeoNames ID (property P1566) and that property has a
value
of 18918. *Where can I find the link *between Q2113430 <--> P1566 <--> 18918 *in the database?* (Not through the API, but via a direct SQL
query
on the database)
The idea is to get a list of all these triads to use for some
investigation
needed for [3].
Thanks in advance,
Huji
[1] https://lists.wikimedia.org/pipermail/cloud/2018-March/000244.html [2] https://www.wikidata.org/wiki/Q2113430 [3] https://phabricator.wikimedia.org/T174553 _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org