I'm sure this is documented somewhere, but...
In the Labs DB replicas, I see the wbc_entity_usage table. I assume that logs the Wikidata entities used for a particlar page.
* What is eu_aspect? What do "L.de"/O/S/T/X mean? * Is one of these the item ID of the page (as opposed to "arbitary use")? If so, which one? If not, how could I find this information on the replicas?
To venture a guess, "eu_aspect='S'" seems to be the page-to-item identity, with the exception of redirected items, which still appear to be associated with the page (e.g. page_id 8983308 on dewiki).
On Tue, Mar 29, 2016 at 12:10 AM Magnus Manske magnusmanske@googlemail.com wrote:
I'm sure this is documented somewhere, but...
In the Labs DB replicas, I see the wbc_entity_usage table. I assume that logs the Wikidata entities used for a particlar page.
- What is eu_aspect? What do "L.de"/O/S/T/X mean?
- Is one of these the item ID of the page (as opposed to "arbitary use")?
If so, which one? If not, how could I find this information on the replicas?
Hi Magnus,
These "entity usage aspects" are described here: https://github.com/wikimedia/mediawiki-extensions-Wikibase/blob/master/clien...
I'm not sure what you mean with "item id of the page". Which page? eu_page_id is the page id where information from a Wikidata entity is used. eu_entity_id is that Wikidata entity id.
Best Thiemo
Hi Thiemo,
what I am looking for is, in a Wikipedia database replica on Labs, for a given page, the Wikidata item.
Yes, I know I can get that via API, or via the Wikidata DB replica.
Cheers, Magnus
On Tue, Mar 29, 2016 at 11:10 PM Thiemo Mättig thiemo.maettig@wikimedia.de wrote:
Hi Magnus,
These "entity usage aspects" are described here:
https://github.com/wikimedia/mediawiki-extensions-Wikibase/blob/master/clien...
I'm not sure what you mean with "item id of the page". Which page? eu_page_id is the page id where information from a Wikidata entity is used. eu_entity_id is that Wikidata entity id.
Best Thiemo _______________________________________________ Wikidata-tech mailing list Wikidata-tech@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-tech
Hi Magnus,
This lookup is currently done via …
SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_id = 'enwiki' AND ips_site_page = 'Berlin'
This table is on the wikidata.org repo database.
This lookup may change any time, so better depend on the API whenever you can.
Best Thiemo
As I said in my last mail, I know how to do it in the Wikidata DB replica. I was just wondering how to do it in the Wikipedia one, if that's possible. (and no, I don't want the federated join either)
On Wed, Mar 30, 2016 at 5:56 PM Thiemo Mättig thiemo.maettig@wikimedia.de wrote:
Hi Magnus,
This lookup is currently done via …
SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_id = 'enwiki' AND ips_site_page = 'Berlin'
This table is on the wikidata.org repo database.
This lookup may change any time, so better depend on the API whenever you can.
Best Thiemo _______________________________________________ Wikidata-tech mailing list Wikidata-tech@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-tech
We actually have nice documentation for this :)
https://github.com/wikimedia/mediawiki-extensions-Wikibase/blob/master/docs/...
Am 29.03.2016 um 01:10 schrieb Magnus Manske:
I'm sure this is documented somewhere, but...
In the Labs DB replicas, I see the wbc_entity_usage table. I assume that logs the Wikidata entities used for a particlar page.
- What is eu_aspect? What do "L.de"/O/S/T/X mean?
- Is one of these the item ID of the page (as opposed to "arbitary use")? If so,
which one? If not, how could I find this information on the replicas?
Wikidata-tech mailing list Wikidata-tech@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-tech
Thank you!
On Thu, Mar 31, 2016 at 2:22 PM Daniel Kinzler daniel.kinzler@wikimedia.de wrote:
We actually have nice documentation for this :)
https://github.com/wikimedia/mediawiki-extensions-Wikibase/blob/master/docs/...
Am 29.03.2016 um 01:10 schrieb Magnus Manske:
I'm sure this is documented somewhere, but...
In the Labs DB replicas, I see the wbc_entity_usage table. I assume that
logs
the Wikidata entities used for a particlar page.
- What is eu_aspect? What do "L.de"/O/S/T/X mean?
- Is one of these the item ID of the page (as opposed to "arbitary
use")? If so,
which one? If not, how could I find this information on the replicas?
Wikidata-tech mailing list Wikidata-tech@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-tech
-- Daniel Kinzler Senior Software Developer
Wikimedia Deutschland Gesellschaft zur Förderung Freien Wissens e.V.
Wikidata-tech mailing list Wikidata-tech@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-tech
wikidata-tech@lists.wikimedia.org