Re: [Wikidata] Label gaps on Wikidata - (SPARQL help needed. SERVICE wikibase:label)

2017-02-23 Thread Lucas Werkmeister
You can specify multiple languages for the label service: # All subclasses of a class example # here all subclasses of P279 Organization (Q43229) SELECT ?item ?itemLabel ?itemDescription ?itemAltLabel WHERE { ?item wdt:P279 wd:Q43229. SERVICE wikibase:label { bd:serviceParam wikibase:language

Re: [Wikidata] Linked data fragment enabled on the Query Service

2016-12-22 Thread Lucas Werkmeister
Yup, I believe the ticket for that is https://phabricator.wikimedia.org/T153897 On 22.12.2016 21:53, Ruben Verborgh wrote: > Hi Stas, > > I found an important problem with the current configuration, > that is likely a major factor in the performance loss we see. > > I noticed that

Re: [Wikidata] WDQS: Lost Cities

2017-03-25 Thread Lucas Werkmeister
Neuruppin has two “instance of” statements: “city” and “municipality of Germany”. The second statement has preferred rank, and the first one has normal rank. The wdt: only includes “truthy” statements, that is, statements with the highest rank, and never statements of deprecated rank. The

Re: [Wikidata] coding of special character

2017-04-02 Thread Lucas Werkmeister
Hi, labels in Wikidata are multilingual and are mapped to RDF literals with a language tag. This query finds three results (though only one of them has a date of birth): SELECT ?_Geburtsdatum WHERE { ?s ?label "Brian O'Nolan"@en. OPTIONAL { ?s wdt:P569 ?_Geburtsdatum. } } This one, on the

Re: [Wikidata] Subst for Template:Wikidata on a Wikipedia

2017-04-18 Thread Lucas Werkmeister
Hi Pharos, I tried this on my own sandbox [1], and the subst seems to work without a problem. I’m not sure what’s in your own sandbox – the big red error in the revision you linked to seems to be caused by something different (the {{#invoke}} at the bottom), not the substituted Wikidata template.

Re: [Wikidata] New step towards structured data for Commons is now available: federation

2017-07-06 Thread Lucas Werkmeister
I just tried opening this link in Firefox and it complained that the XML file is not well-formed, at the first element. As far as I can tell, that’s correct according to Namespaces in XML 1.1 [1]: [8] PrefixedName::= Prefix : LocalPart [10] Prefix ::= NCName [11] LocalPart

Re: [Wikidata] New step towards structured data for Commons is now available: federation

2017-07-07 Thread Lucas Werkmeister
Yes, emitting the real, canonical URI sounds like the best solution. It looks like https://phabricator.wikimedia.org/T161592 is the Phabricator task for that (thanks Leszek for the link!). On 07.07.2017 00:21, Stas Malyshev wrote: > Hi! > >> I just tried opening this link in Firefox and it

Re: [Wikidata] Fwd: Which templates should be global?

2017-06-28 Thread Lucas Werkmeister
Sure, that’s a great idea! Here ’s a query for the 100 most common templates by number of sitelinks (across all projects): SELECT ?template ?templateLabel ?sitelinks WITH { SELECT ?template ?sitelinks WHERE { ?template wdt:P31/wdt:P279* wd:Q11266439;

Re: [Wikidata] Wikidata Query Service + Mediawiki API = Love

2017-04-27 Thread Lucas Werkmeister
Wow, this looks awesome! Thanks a lot for working on this! I think the configuration model could use some more documentation, but in principle I’d say it looks pretty reasonable. It’s also probably powerful enough for most reasonable needs (I read “XPath” and my eyes lit up :D ). As for

Re: [Wikidata] [Wikidata-tech] Script and API module for constraint checks

2017-04-27 Thread Lucas Werkmeister
That’s a bug in the constraints on Wikidata – “date of birth” has a constraint stating that its value must be at least 30 years away from the “date of birth” value. We’ll work on resolving this (I contacted Ivan Krestinin, who added this “experimental constraint”, to ask if he still needs it –

Re: [Wikidata] How to split a label by whitespace in WDQS ?

2017-09-18 Thread Lucas Werkmeister
I don’t think there’s any SPARQL function that can transform a single result into multiple results (one for each string fragment, in that case). But for your request, a regex works: SELECT ?human ?label WHERE {   ?human wdt:P31 wd:Q15632617; rdfs:label ?label.   FILTER(LANG(?label) =

[Wikidata] Announcement: Fallback indicators hidden on variant fallbacks

2017-08-28 Thread Lucas Werkmeister
gt;. Best regards, Lucas Werkmeister -- Lucas Werkmeister Software Developer (Intern) Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Phone: +49 (0)30 219 158 26-0 https://wikimedia.de Imagine a world, in which every single human being can freely share in the sum of all knowledg

[Wikidata] BREAKING CHANGE: wbcheckconstraints detail output

2017-11-20 Thread Lucas Werkmeister
rrit.wikimedia.org/r/391864> -- Lucas Werkmeister Software Developer (Intern) Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Phone: +49 (0)30 219 158 26-0 https://wikimedia.de Imagine a world, in which every single human being can freely share in the sum of all knowledge. Tha

[Wikidata] Next IRC office hour on November 14th (today!)

2017-11-14 Thread Lucas Werkmeister
urrent and future projects, and ask any question you want. (Sorry for the short notice! It looks like we forgot to send this email earlier.) See you there in 40 minutes! -- Lucas Werkmeister Software Developer (Intern) Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Phone:

Re: [Wikidata] Next IRC office hour on November 14th (today!)

2017-11-15 Thread Lucas Werkmeister
.pintsc...@wikimedia.de> wrote: > >> On Tue, Nov 14, 2017 at 6:18 PM, Lucas Werkmeister >> <lucas.werkmeis...@wikimedia.de> wrote: >> > Hello, >> > >> > our next Wikidata IRC office hour will take place on November 11th, >> 18:00 >> >

Re: [Wikidata] Wikidata HDT dump

2017-11-03 Thread Lucas Werkmeister
y email. I guess I could re-upload the file somewhere else myself, > but my uplink is really slow (1Mbps). > > ___ > Wikidata mailing list > Wikidata@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikidata >

Re: [Wikidata] Wikidata HDT dump

2017-11-07 Thread Lucas Werkmeister
The Wikidata Query Service currently holds some 3.8 billion triples – you can see the numbers on Grafana [1]. But WDQS “munges” the dump before importing it – for instance, it merges wdata:… into wd:… and drops `a wikibase:Item` and `a wikibase:Statement` types; see [2] for details – so the triple

Re: [Wikidata] How to get direct link to image

2017-10-30 Thread Lucas Werkmeister
The actual value of the statement is just the image name itself (in this case “0 A.D. logo.png”), the c.w.o/wiki/ link is only generated for the HTML view. You can get the path to the actual file using Special:FilePath on Commons; for instance, the RDF export of the entity

Re: [Wikidata] stats on WD edits and WDQS uptime

2017-12-20 Thread Lucas Werkmeister
There are edit count charts on Wikistats 2.0 (Wikidata [1], English Wikipedia [2]), but I don’t know if there’s a way to see a chart of all wikis simultaneously. As to the Query Service, there are some statistics available on Grafana [3], though I’m not sure how downtime would show up there

Re: [Wikidata] Wikiata and the LOD cloud

2018-05-07 Thread Lucas Werkmeister
; >>> > BTW, I'm not sure the implementation of content negotiation in >>> Wikidata is >>> > correct because the server does not tell me the format of the resource >>> to >>> > which it redirects (as opposed to what DBpedia does, for insta

Re: [Wikidata] [Wikitech-l] GSoC 2018 Introduction: Prssanna Desai

2018-05-06 Thread Lucas Werkmeister
The project consists of making usability improvements to the Explorer > Dialog and the Graph Explorer of WDQS. > You can read my full proposal here: > https://phabricator.wikimedia.org/T189669 > > I’d like to thank my mentors Jonas Kress, Stas Malyshev and Lucas &

Re: [Wikidata] Wikiata and the LOD cloud

2018-04-30 Thread Lucas Werkmeister
The real URI (without scare quotes :) ) is not https://www.wikidata.org/wiki/Q5200 but http://www.wikidata.org/entity/Q5200 – and depending on your Accept header, that will redirect you to the wiki page, JSON dump, or RDF data (in XML or Turtle formats). Since the LOD Cloud criteria

Re: [Wikidata] Wikiata and the LOD cloud

2018-05-01 Thread Lucas Werkmeister
g: D=75094 t=1525107829593021 >> x-varnish: 754403290 624210434, 160015159 924438274 >> via: 1.1 varnish (Varnish/5.1), 1.1 varnish (Varnish/5.1) >> age: 29522 >> x-cache: cp1067 hit/8, cp1068 hit/10 >> x-cache-status: hit-front >> set-cookie: CP=H2; Path=/; sec

[Wikidata] BREAKING CHANGE: wbcheckconstraints status parameter

2018-01-29 Thread Lucas Werkmeister
if you have any questions. -- Lucas Relevant tickets: - phabricator:T183927 <https://phabricator.wikimedia.org/T183927> - phabricator:T184812 <https://phabricator.wikimedia.org/T184812> - phabricator:T184937 <https://phabricator.wikimedia.org/T184937> -- Lucas Werkme

Re: [Wikidata] Wikidata in the LOD Cloud

2018-08-13 Thread Lucas Werkmeister
/y8taazzm>?  > > Cheers, > > Ettore > > On Mon, 9 Jul 2018 at 14:07, Lucas Werkmeister > mailto:m...@lucaswerkmeister.de>> wrote: > > On 27.06.2018 22:40, Federico Leva (Nemo) wrote: > > Maarten Dammers, 27/06/2018 23:26: > >> Excellent

Re: [Wikidata] Wikidata SPARQL query logs available

2018-08-23 Thread Lucas Werkmeister
The top result freaks me out, to be honest. Are /that many/ people running the first query from the SPARQL tutorial , or is there some other reason why Bach might be so overwhelmingly popular? On 8/23/18 9:57 PM, Daniel Mietchen wrote: > I

Re: [Wikidata] Wikidata SPARQL query logs available

2018-08-23 Thread Lucas Werkmeister
Ah, and I think I found a bug in your command: by grepping for |Q[1-9][0-9]*+*|, you’re excluding single-digit item IDs. I’m going to speculate that if you fix that, Q5 will comfortably beat all other items :) On 8/23/18 11:31 PM, Lucas Werkmeister wrote: > > The top result freaks

Re: [Wikidata] image re-use information available via a SPARQL query?

2018-08-29 Thread Lucas Werkmeister
There is a solution, but it’s a bit hacky. You can get the categories of the file via the MWAPI service [1] and then try to match those categories that denote a license (for example, a category starting with “CC-” *probably* indicates a Creative Commons license). Here’s a query using the example

Re: [Wikidata] Wikidata in the LOD Cloud

2018-07-09 Thread Lucas Werkmeister
On 27.06.2018 22:40, Federico Leva (Nemo) wrote: > Maarten Dammers, 27/06/2018 23:26: >> Excellent news! https://lod-cloud.net/dataset/wikidata seems to >> contain the info in a more human readable (and machine readable) way. >> If we add some URI link, does it automagically appear or does Lucas

Re: [Wikidata] Weekly Summary #338

2018-11-12 Thread Lucas Werkmeister
Isn’t “dramatist” the term for the person /writing/ the drama, and “dramaturge” is someone else (involved in the production)? Cheers, Lucas On 12.11.18 16:42, Thad Guidry wrote: > Dramaturge ?  Really ?   I had no idea, until now that a PRO dramatist > is actually called a... > > dramaturge

Re: [Wikidata] SPARQL Query - get property from entity

2018-09-04 Thread Lucas Werkmeister
Yes, the property is linked to all its predicates, e. g. wikibase:directClaim for the wdt: version or wikibase:claim for the p: version. In this query I’m using wikibase:claim instead of wikibase:directClaim to ensure that all statements are counted, not just best-rank ones: SELECT ?property

Re: [Wikidata] order of results: API vs. Website

2018-11-30 Thread Lucas Werkmeister
wbsearchentities is a Wikibase-specific API; the normal MediaWiki search function uses a different search configuration, which you can query in the API via: action=query=search=SEARCHTERM=0|120 For example: https://www.wikidata.org/w/api.php?action=query=search=maruti=0|120=2 Note that you

Re: [Wikidata] Article Size Filter on Wikidata

2019-01-12 Thread Lucas Werkmeister
You can’t directly query for the size as far as I know, but you can use the longpages query page generator to get a list of the longest enwiki pages, then filter the associated items for male authors. But this will only get you about a hundred results until the longpages list is exhausted (most of

Re: [Wikidata] Article Size Filter on Wikidata

2019-01-12 Thread Lucas Werkmeister
u so much, Nicolas & Lucas!  > > @Lucas this helps a lot! At least I will get an idea about what I need > until PetScan is sorted out. Would you elaborate a bit more what do > you mean by "most of its results are linked to items we don’t care about"? > > Best, >

Re: [Wikidata] Article Size Filter on Wikidata

2019-01-12 Thread Lucas Werkmeister
nformation > with a generator? (it's a real question, I'm not at all comfortable > with this API).  > > Ettore Rizza > > > Le sam. 12 janv. 2019 à 14:41, Reem Al-Kashif <mailto:reemalkas...@gmail.com>> a écrit : > > Right, I see what you mean. Thanks a lot!

Re: [Wikidata] [Wikimedia-l] Developing instructional material for Wikidata Query Service

2019-02-25 Thread Lucas Werkmeister
On 21.02.19 10:43, Darren Cook wrote: > The explorer graph, that you see from clicking the magnifying glass in > search results, is great. But is there a way to go straight to it? > > This is for a demo, and I want to go from the "wikidata" link on a > wikimedia page, to showing how they can

Re: [Wikidata] Help on references back to a Wikipedia page

2019-03-05 Thread Lucas Werkmeister
I’ve added a second reference with, as far as I know, the preferred way to model this: “imported from Wikimedia project” + “Wikimedia import URL” (via the “permanent link” in the sidebar on the Wikipedia article). I’m not sure if a “retrieved” date should also be added. Cheers, Lucas On 06.03.19

Re: [Wikidata] Graph view of WQS

2019-03-12 Thread Lucas Werkmeister
Yes – the wikidata-query-gui is open source, and the GraphResultBrowser specifically uses the Network

Re: [Wikidata] Language for non-logged in users

2019-01-25 Thread Lucas Werkmeister
(But note that this does change the whole UI language, not just the data.) (And for context, I’m pretty sure the reason we don’t respect Accept-Language for anonymous users is that it would hurt caching.) On 25.01.19 11:55, Leszek Manicki wrote: > Hello Darren, > > Using uselang parameter in the

Re: [Wikidata] qwikidata: a python package to process Wikidata entities and dumps

2019-04-11 Thread Lucas Werkmeister
That looks very interesting! But the Python 3.6 requirement is quite unfortunate for Wikimedia Toolforge users – the default Python version there is still 3.4, and even the latest image available (not yet available for the 'webservice' comand) has only Python 3.5 (T219091). Would it be difficult

Re: [Wikidata] Where did label filtering break recently and how?

2019-06-01 Thread Lucas Werkmeister
For this query, you can also use the regular Wikibase search, either skipping the query service completely – https://www.wikidata.org/wiki/Special:Search/haswbstatement:P31=Q2085381 inlabel:simon@en

Re: [Wikidata] Language codes for Chinese

2019-06-19 Thread Lucas Werkmeister
On 19.06.19 07:17, Federico Leva (Nemo) wrote: > Vladimir Ryabtsev, 19/06/19 03:04: >> How can I get the COMPLETE list of language codes (desirably with >> description) for Chinese that is supported by Wikidata? > > Languages supported by a MediaWiki instance are expected to be all > listed at

Re: [Wikidata] Python tools should use user-agent to access WDQS

2019-07-04 Thread Lucas Werkmeister
Yes, that would be T226709 . Cheers, Lucas On 04.07.19 19:10, Imre Samu wrote: > > If you're a tool builder and encountering issues with WDQS at the > moment,  > > please check that your tool is compliant with those guidelines. > > I like and I am using

Re: [Wikidata] Python tools should use user-agent to access WDQS

2019-07-04 Thread Lucas Werkmeister
dia Deutschland - Gesellschaft zur Förderung Freien Wissens e. V. > > Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg > unter der Nummer 23855 Nz. Als gemeinnützig anerkannt durch das Finanzamt > für Körperschaften I Berlin, Steuernummer 27/029/42207. >

Re: [Wikidata] qwikidata: a python package to process Wikidata entities and dumps

2019-04-11 Thread Lucas Werkmeister
  I would not want it to be unavailable in Toolforge!  > > On Thu, Apr 11, 2019 at 10:44 AM Lucas Werkmeister > mailto:m...@lucaswerkmeister.de>> wrote: > > That looks very interesting! But the Python 3.6 requirement is > quite unfortunate for Wikimedia Toolforge

Re: [Wikidata] Tinyurls no longer operable

2019-09-11 Thread Lucas Werkmeister
I didn’t do anything – but yeah, while I could reproduce the issue earlier today, it seems to be working again right now. My guess would be that the TinyURL folks fixed it. Cheers, Lucas On 11.09.19 18:26, Olaf Simons wrote: > seems someone very nice (Lucas?) has fixed it. > > thank you all, >

Re: [Wikidata] Generating EntitySchema from Wikidata Lexeme Forms data

2019-07-24 Thread Lucas Werkmeister
Just a side note – if anyone wants to use the templates, it’s probably better to use the tool’s templates API rather than the wiki page itself: transcribing the templates into structured form takes some time, there’s no

Re: [Wikidata] Wikidata Query Service User-Agent requirements for script users

2019-07-24 Thread Lucas Werkmeister
On 23.07.19 20:23, Stas Malyshev wrote: > Also, with live updates, long queries create other technical challenges > (if query is running for 2 hours, the database has basically to keep the > snapshot it runs on for 2 hours, which may make it much less efficient). Wait, does that mean that the

Re: [Wikidata] Generating EntitySchema from Wikidata Lexeme Forms data

2019-07-24 Thread Lucas Werkmeister
9 at 5:34 AM Lucas Werkmeister > mailto:m...@lucaswerkmeister.de>> wrote: > > Just a side note – if anyone wants to use the templates, it’s > probably better to use the tool’s templates API > > <https://www.wikidata.org/wiki/Wikidata:Wikidata_Lexeme_Forms#Templat

Re: [Wikidata] Query Service break down on FactGrId

2019-11-14 Thread Lucas Werkmeister
I’ve restarted Blazegraph, it looks like it ran out of memory. Not sure why. Cheers, Lucas On 14.11.19 18:19, Olaf Simons wrote: > Dear list, > > I am experiencing unexpected problems with running Queries on FactGrid. (You > find some sample queries here: >

Re: [Wikidata] Wikidata Query Service update lag

2019-11-14 Thread Lucas Werkmeister
As the Wikitech WDQS Hardware section [1] explains, “due to how we route traffic with GeoDNS, the primary cluster (usually eqiad) sees most of the traffic.” So the clusters may all have the same hardware, but one cluster sees most of the query load, so it has a harder time keeping up with updates

Re: [Wikidata] References to newspaper articles behind paywalls like newspapers.com

2019-11-12 Thread Lucas Werkmeister
I believe that’s what InternetArchiveBot is for, but apparently at the moment it only updates references when they break; at least, that’s how Ymblanter summarized the request for permissions

Re: [Wikidata] Full-text / autocomplete search on labels

2019-10-04 Thread Lucas Werkmeister
If you use regular search rather than entity search, you can use WikibaseCirrusSearch search keywords like "haswbstatement:P31=Q5". Note that this uses a different kind of search, though – I think it only

Re: [Wikidata] Full-text / autocomplete search on labels

2019-10-04 Thread Lucas Werkmeister
ucas's example query for WikibaseCirrusSearch. How > is the string "einst" being matched here? > > Thanks, > Tim > > -- > Tim A. Thompson > Discovery Metadata Librarian > Yale University Library > > On Fri, Oct 4, 2019 at 8:54 AM Lucas Werkmeister > mai

Re: [Wikidata] triple showing category membership?

2020-01-28 Thread Lucas Werkmeister
No, that information isn’t available as triples. We have a category graph in a separate endpoint, but that contains only category-subcategory relations, not individual pages. (Also, I just noticed it seems to be incomplete, see

Re: [Wikidata] WDQS and SPARQL Endpoint Compatibility

2020-03-30 Thread Lucas Werkmeister
The current whitelist is documented at https://www.mediawiki.org/wiki/Wikidata_Query_Service/User_Manual/SPARQL_Federation_endpoints and new additions can be proposed at https://www.wikidata.org/wiki/Wikidata:SPARQL_federation_input. Cheers, Lucas On 30.03.20 20:31, Kingsley Idehen wrote: > All,

Re: [Wikidata] How to get population in JSON

2020-03-18 Thread Lucas Werkmeister
If you have the item IDs already, the query is relatively simple: SELECT ?item ?population WHERE { VALUES ?item { wd:Q38 wd:Q148 wd:Q884 } ?item wdt:P1082 ?population. } https://w.wiki/KjA You can add more values for the ?item (and spread them across several lines as well), the three above

Re: [Wikidata] a question of data modeling about family ties

2020-10-05 Thread Lucas Werkmeister
I don’t understand the problem, the query shouldn’t need to get much more complicated… what kind of query did you have in mind? Here’s a simple one for all ancestors of Frodo Baggins

[Wikidata] [Significant change] New datatype fields in Lexeme JSON output

2020-08-17 Thread Lucas Werkmeister
uch by including it here ). Starting on 26 August 2020 (barring unexpected deployment issues; 25 August 2020 on Test Wikidata), these datatype fields will be present there as well. If you have any issue or question, feel free to leave a comment at T249206 <https://phabricator.wikimedia.org/T249206

Re: [Wikidata] Extension to add new property type

2020-05-30 Thread Lucas Werkmeister
WikibaseLexeme and WikibaseMediaInfo are two extensions that add new entity types, including datatypes for those entities. I suspect that WikibaseMediaInfo

[Wikidata] BREAKING CHANGE: removing special pageterms behavior on repo wikis, use entityterms instead

2020-07-15 Thread Lucas Werkmeister
<https://phabricator.wikimedia.org/T115117>, T255882 <https://phabricator.wikimedia.org/T255882> and T256255 <https://phabricator.wikimedia.org/T256255>. Cheers, Lucas -- Lucas Werkmeister (he/er) Full Stack Developer Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10

Re: [Wikidata] Does the Wikidata Query Service provide a REST API?

2021-01-27 Thread Lucas Werkmeister
If you look through the code examples the query service UI generates for you, you can see that several of them (including the PHP one and the two JavaScript ones) don’t use any special SPARQL libraries. You can also see the “URL” option, which is just the URL you’re looking for. The returned

Re: [Wikidata] Most popular month/day for inception P571

2021-05-07 Thread Lucas Werkmeister
If you don’t limit this to dates with a precision greater than “year”, then it actually works without timeout on the query service, but unsurprisingly the most common month and day , by far, are 1 (or January). If you do limit it to such dates, the

[Wikidata] BREAKING / SIGNIFICANT CHANGE: wbeditentity response to use standard JSON serialization

2021-02-08 Thread Lucas Werkmeister
fter your edit, make a separate request to Special:EntityData or wbgetentities. (This is nothing new, and unaffected by the change being announced here, but we thought it was still worth mentioning.) If you have any issue or question, feel free to leave a comment at T271105 <https://phabricator.w

Re: [Wikidata] Identifiers for WDQS queries

2021-02-18 Thread Lucas Werkmeister
There is also {{query page}} , which is useful if you want to reuse the query elsewhere on Wikidata. Cheers, Lucas On 18.02.21 18:52, Crystal E. Clements wrote: > > Thank you, Jeff! I was unaware of this template. > >   > > *From:* Wikidata *On

[Wikidata] [BREAKING CHANGE] Pagename/filename normalization on saving an edit

2021-08-23 Thread Lucas Werkmeister
a on or shortly after September 6th. If you have any questions or feedback, please feel free to let us know in this ticket <https://phabricator.wikimedia.org/T251480>. Cheers, Lucas Werkmeister -- Lucas Werkmeister (he/er) Full Stack Developer Wikimedia Deutschland e. V. | Tempelhofer Ufer

[Wikidata] Re: age distribution

2021-11-10 Thread Lucas Werkmeister
I think it works if you tag the date you mean: https://tinyurl.com/yzcqvrf9 or https://tinyurl.com/yk4cla52 But if the date is hard-coded, you could also skip the YEAR()/MONTH() functions: https://tinyurl.com/ygv8wb26 Cheers, Lucas On 10.11.21 12:50, Olaf Simons wrote: Dear all, the

[Wikidata-tech] BREAKING CHANGE: wbcheckconstraints API output format

2017-09-14 Thread Lucas Werkmeister
https://gerrit.wikimedia.org/r/#/c/369420 - https://gerrit.wikimedia.org/r/#/c/373323/ -- Lucas Werkmeister Software Developer (Intern) Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Phone: +49 (0)30 219 158 26-0 https://wikimedia.de Imagine a world, in which every single human being

[Wikidata-tech] Significant change: Snak hashes in API and HTML output formats

2017-09-11 Thread Lucas Werkmeister
ers. They are not stable, and may change at any time with the internal format. Please let us know if you have any comments or objections. -- Lucas Relevant tickets: - T171607 <https://phabricator.wikimedia.org/T171607> - T171725 <https://phabricator.wikimedia.org/T171725> Relevan

[Wikidata-tech] BREAKING CHANGE: wbcheckconstraints detail output

2017-11-20 Thread Lucas Werkmeister
rrit.wikimedia.org/r/391864> -- Lucas Werkmeister Software Developer (Intern) Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Phone: +49 (0)30 219 158 26-0 https://wikimedia.de Imagine a world, in which every single human being can freely share in the sum of all knowledge. Tha

[Wikidata-tech] Gadget / userscript editor feedback wanted

2017-11-03 Thread Lucas Werkmeister
#Gadget_.2F_userscript_editor_feedback_wanted>, or comment on phab:T95403 <https://phabricator.wikimedia.org/T95403>.) Cheers, Lucas -- Lucas Werkmeister Software Developer (Intern) Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Phone: +49 (0)30 219 158 26-0 https://wiki

Re: [Wikidata-tech] Fastest way (API or whatever) to verify a QID

2018-05-15 Thread Lucas Werkmeister
If you have the luxury of access to the replica servers (which is the case for the reconciliation service, right?), then I doubt any API is going to beat a raw SQL query: $ sql wikidata 'SELECT page_title FROM page WHERE page_namespace = 0 AND page_title IN ("Q12345", "Q123456", "Q1234567")'

Re: [Wikidata-tech] Query data type using WDQS

2018-06-07 Thread Lucas Werkmeister
The property type is available under the wikibase:propertyType predicate:

Re: [Wikidata-tech] Query data type using WDQS

2018-06-07 Thread Lucas Werkmeister
ertyLabel > > > On Thu, Jun 7, 2018 at 4:28 PM Lucas Werkmeister > mailto:m...@lucaswerkmeister.de>> wrote: > > The property type is available under the wikibase:propertyType > predicate: > > https://query.wikidata.org/#%23Subproperties%20of%20URL%20%

[Wikidata-tech] New API module to format multiple entity IDs

2018-12-04 Thread Lucas Werkmeister
be controlled via the global uselang parameter. Normal users can format up to 50 entities at once, bots up to 500. Please let us know if you have any comments, either by responding here or over on Phabricator at T207484 <https://phabricator.wikimedia.org/T207484>. -- Lucas -- Lucas Werkm

[Wikidata-tech] Fwd: [Wikitech-l] Possible change in schedule of generation of wikidata entity dumps

2019-03-14 Thread Lucas Werkmeister
imedia Foundation ar...@wikimedia.org ___ Wikitech-l mailing list wikitec...@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l -- Lucas Werkmeister Full Stack Developer Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963

Re: [Wikidata-tech] Question on Wikidata/Wikibase reconciliation service for OpenRefine

2019-09-18 Thread Lucas Werkmeister
It looks like the openrefine-wikibase reconciliation service uses the wbsearchentities API to find items. As far as I’m aware, the default SQL-based Wikibase search also searches other languages, but still, I think the most likely reason you’re getting different results is that Wikidata uses

Re: [Wikidata-tech] Question on Wikidata/Wikibase reconciliation service for OpenRefine

2019-09-19 Thread Lucas Werkmeister
nguages search, both within Wikibase > and for the reconciliation service, would be to use CirrusSearch as > well. What do you think? > > Cheers, > Régis > > Le jeu. 19 sept. 2019 à 00:08, Lucas Werkmeister > mailto:m...@lucaswerkmeister.de>> a écrit : > > It

Re: [Wikidata-tech] Question on Wikidata/Wikibase reconciliation service for OpenRefine

2019-09-19 Thread Lucas Werkmeister
his problem should not be related to CirrusSearch, > but I may be wrong... Any idea? > > Cheers, > Régis > > > > > Le jeu. 19 sept. 2019 à 12:15, Lucas Werkmeister > mailto:m...@lucaswerkmeister.de>> a écrit : > > Special:Search is the general MediaWiki search,

Re: [Wikidata-tech] Changed JS API?

2019-11-18 Thread Lucas Werkmeister
On 18.11.19 01:05, Michael Schönitzer wrote: > Hi, > > Am Sa., 16. Nov. 2019 um 15:30 Uhr schrieb Lucas Werkmeister > mailto:m...@lucaswerkmeister.de>>: > > – but that’s not the error I get anyways (I get “Error loading citoid > config”, because it’s

Re: [Wikidata-tech] Changed JS API?

2019-11-16 Thread Lucas Werkmeister
The Wikibase JavaScript code has never been a stable interface, as the Stable Interface Policy [1] explicitly points out. As for PropertyValueSnak, it should now be loaded via ResourceLoader – mw.loader.using( 'wikibase.datamodel' ) .then( function ( require ) { var datamodel =

[Wikidata-tech] Fwd: [Wikitech-l] BREAKING CHANGE: schema update, xml dumps

2019-11-27 Thread Lucas Werkmeister
___ Wikitech-l mailing list wikitec...@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l -- Lucas Werkmeister (he/er) Full Stack Developer Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Phone: +49 (0)30 219 158 26-0 https://wikimedia.de

Re: [Wikidata-tech] [Wikitech-l] BREAKING CHANGE: schema update, xml dumps

2019-11-28 Thread Lucas Werkmeister
um 17:14 Uhr schrieb Lucas Werkmeister < lucas.werkmeis...@wikimedia.de>: > Forwarding as this will also be relevant for people who consume Wikidata > XML dumps (but not entity dumps), and especially for people who are > interested in working with Structured Data on Commons from dump

[Wikidata-tech] [Significant change] New datatype fields in Lexeme JSON output

2020-08-17 Thread Lucas Werkmeister
uch by including it here ). Starting on 26 August 2020 (barring unexpected deployment issues; 25 August 2020 on Test Wikidata), these datatype fields will be present there as well. If you have any issue or question, feel free to leave a comment at T249206 <https://phabricator.wikimedia.org/T249206

[Wikidata-tech] BREAKING CHANGE: removing special pageterms behavior on repo wikis, use entityterms instead

2020-07-15 Thread Lucas Werkmeister
<https://phabricator.wikimedia.org/T115117>, T255882 <https://phabricator.wikimedia.org/T255882> and T256255 <https://phabricator.wikimedia.org/T256255>. Cheers, Lucas -- Lucas Werkmeister (he/er) Full Stack Developer Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10

Re: [Wikidata-tech] Problem with SPARQL query: items which use a specific image (P18)

2020-07-24 Thread Lucas Werkmeister
| > | > Urbanism: Radlobby Wien > Platz für Wien | > | Contact: | > | > Mail: sk...@xover.mud.at > Blog: plepe.at > Code: github.com/plepe | > | > Twitter: twitter.com/plepe > Jabber: sk...@jabber.at | > | > Mastodon: @pl...@en.osm.town

[Wikidata-tech] [Config change] WikibaseClient example config will no longer define an example repo

2020-07-20 Thread Lucas Werkmeister
57449 <https://phabricator.wikimedia.org/T257449>. For more information, see also T256238 <https://phabricator.wikimedia.org/T256238>. Cheers, Lucas -- Lucas Werkmeister (he/er) Full Stack Developer Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Phone: +49 (0)30 219 1

[Wikidata-tech] BREAKING / SIGNIFICANT CHANGE: wbeditentity response to use standard JSON serialization

2021-02-08 Thread Lucas Werkmeister
fter your edit, make a separate request to Special:EntityData or wbgetentities. (This is nothing new, and unaffected by the change being announced here, but we thought it was still worth mentioning.) If you have any issue or question, feel free to leave a comment at T271105 <https://phabricator.w

[Wikidata-tech] [BREAKING CHANGE] Pagename/filename normalization on saving an edit

2021-08-23 Thread Lucas Werkmeister
a on or shortly after September 6th. If you have any questions or feedback, please feel free to let us know in this ticket <https://phabricator.wikimedia.org/T251480>. Cheers, Lucas Werkmeister -- Lucas Werkmeister (he/er) Full Stack Developer Wikimedia Deutschland e. V. | Tempelhofer Ufer

[Wikidata-tech] Re: [BREAKING CHANGE] Pagename/filename normalization on saving an edit

2021-09-13 Thread Lucas Werkmeister
to new edits, and existing data in Wikidata could still be in non-normalized form. Cheers, Lucas Werkmeister Am Mo., 23. Aug. 2021 um 13:48 Uhr schrieb Lucas Werkmeister < lucas.werkmeis...@wikimedia.de>: > Hello, > > As you may know, Wikibase currently does not normalize page