[09:39:50] still having this issue regarding the API rate limit. I hit the rate limit 13 days ago, and can still not edit items via wikidataintegrator. Would be great, if someone can help me with this issue. For more, please look at the github issue: https://github.com/SuLab/WikidataIntegrator/issues/21https://github.com/SuLab/WikidataIntegrator/issues/21 [09:40:24] Or maybe you can point me to someone, who can help me. thanks! [09:48:22] stefankasberger: did you try searching in https://www.mediawiki.org/wiki/API:FAQ or https://www.mediawiki.org/wiki/API:Etiquette ? [09:50:41] is the mediawiki api the same as the wikidata? [09:52:47] basically yes, wikidata extends MW [09:56:34] sorry, posted the issue url twice: https://github.com/SuLab/WikidataIntegrator/issues/21 [10:10:28] will have a look on the documentation, but the people from wikidataintegrator already did it i think, and did not find a specific rate limit description. or how the api handles violations. [12:31:05] Hey everyone. How should I find the data to add to incomplete Wikidata entries? [12:31:41] Do I just like... scour the web for them? [12:35:44] bella: if you want to improve some specific items, yes you can do that [12:36:46] pintoch: thanks. I remember there being a tutorial that involved editing the page for Earth? [12:36:47] but I prefer to import datasets which will add statements on many items [12:37:10] wow... I don't know what that means. I'm very new to Wikidata (as you can possibly tell) [12:37:52] that's fine, it is fine to focus on your preferred items too ! :) [12:38:09] I do not remember this tutorial [12:38:10] the tutorials are at https://www.wikidata.org/wiki/Wikidata:Tours [12:38:32] thanks nikki :) [12:39:38] nikki: thanks [14:16:38] Aleksey_WMDE: Do you have time today to look at all my patches on the Lexeme extension? (At least start at the bottom of the chain.) [14:35:59] hi, i'm taking my first baby steps with wikidata and sparql and was wondering wether there's a predicate to query entities of a list? [14:38:07] in particular i'm trying to query the cities listed in https://de.wikipedia.org/wiki/Liste_der_St%C3%A4dte_in_Deutschland - i imagine starting from this list will give me cleaner results / avoid duplicates (which i encountered when querying via Q515) [14:46:48] ciss: I don't think there is any simple way to use wikipedia lists in SPARQL. But normally bare SPARQL should work fine in that case, maybe you can show us your query to understand what is wrong with it? [14:50:56] pintoch: thanks! what is the preferred way of sharing queries? pastebin? link to query.wikidata.org? shortened link to query.wikidata.org? [14:51:48] you can use the tinyurl generated by the interface on query.wikidata.org, that is a bit shorter :) [14:53:27] ah, missed that ^^ [14:55:48] pintoch: http://tinyurl.com/ybf26ffv [14:59:08] okay, so there various things that you can improve [15:00:08] first, when you write "SELECT DISTINCT ?place ?placeLabel ?location", it means that it will return all distincts *tuples* matching the query [15:00:46] so if for some reason one city has multiple P625 statements, it will show up twice in the list [15:02:21] one way to solve that is to add "GROUP BY ?place ?placeLabel" after your WHERE { ... }, and replace ?location in your SELECT statement by (SAMPLE(?location) AS ?location) [15:03:09] this means that the engine will pick one of the P625 for you, so that each city appears once [15:03:54] (is that clear enough? I find it quite hard to explain this "GROUP BY" instruction) [15:05:10] second, you are only considering items which are marked as instances of "city", but you probably want to accept subclasses as well [15:07:01] for instance https://www.wikidata.org/wiki/Q436724 is marked as a "municipality of Germany (https://www.wikidata.org/wiki/Q262166)" [15:08:17] alright, current status: http://tinyurl.com/y79dv8rw [15:09:41] great! :-) [15:11:01] next, i tried fetching latitude and longitude separately via wikibase:geoLatitude and wikibase:geoLongitude. unfortunately this gives me timeouts. are there any magic tricks to avoid those? [15:12:24] what are you using to fetch them separately? [15:14:31] nikki: that is an excellent question. i just noticed that i screwed up while adapting the example from https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries#Query_to_find_latitudes_and_longitudes_for_places_in_Paris [15:16:35] that's easily done :) [15:16:49] updated version with P625 statement, grouping temporarily removed: http://tinyurl.com/y7t8jyuy [15:17:26] (no longer timing out) [15:21:19] awesome, thanks a lot so far! [15:22:17] if i may, i have two remaining questions. 1. a last look at my query because i'm not certain if using SAMPLE() twice this way will yield correct results: http://tinyurl.com/ybs5ynwr [15:23:09] that looks dangerous indeed :) [15:24:58] pintoch: to be fair, its used in a similar way (i believe?) in this example: https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples#Battles_per_year_per_continent_and_country_last_80_years_.28animated.29 [15:26:29] (on the other hand, seeing "AS ?contient" in there isn't reassuring) [15:28:03] ciss: Nice, animated bar charts. Any idea what triggers the animation part? [15:29:46] multichill: i'm guessing it's a default behavior of the bar chart when having multidimensional data? you can see the years iterating in the upper left [15:31:26] line and scatter chart exhibit the same behavior [15:32:40] multichill: yep, confirmed. try reordering the selected values. [15:32:55] Interesting feature [15:33:31] You didn't happen to find a map itinerary module too, didn't you? :-) [15:33:50] nope :) [15:35:24] anyway, the use of multiple sample() directives *appears* to be fine. i've only found few additional examples, but they use it in a similar fashion. [15:42:42] btw, what does the Q### stand for? [15:42:45] Lydia_WMDE: Cleaning out the backlog? ;-) [15:43:26] i had assumed "qualifier", but qualifiers seem to be a different thing [15:46:31] "P" for property is fairly clear, but the closest i've seen for "Q" would be uniQue identifier [15:48:44] ciss: I thought for a moment you meant Q ### in a sparql query. That would be Q with weird comments ;-) [15:49:09] ciss: See https://www.wikidata.org/wiki/Help:Items [15:50:03] https://www.wikidata.org/wiki/Help:Contents got updated quite recently to give a good introduction [15:52:52] multichill: that doesn’t explain where the “Q” comes from, right? (I think that’s what ciss wants to know) [15:53:02] I’ve heard the story, but I don’t remember it well enough to retell it (sorry) [15:54:57] Lucas_WMDE: exactly :) [15:56:00] https://lists.wikimedia.org/pipermail/wikidata//2013-July/002518.html [15:56:12] (second to last paragraph) [15:56:39] nikki: awesome, thanks! :) [15:56:59] :) [15:57:26] :D [15:57:32] I had trouble finding it though [15:57:35] i was about to check the source commits ^^ [15:58:06] but now it's safely bookmarked so I can find it again next time I want it [16:00:08] i'd like to add one last question: if i wanted to query https://www.wikidata.org/wiki/Q10864048 for each city, how would i have to go about that? [16:05:57] i assume i'd have to drill down from the country level? [16:07:07] you want to get the first level subdivision for each city? [16:08:15] yup [16:09:13] I think adding "?place wdt:P131* ?p131 . ?p131 wdt:P31/wdt:P279* wd:Q10864048 ." should work [16:13:16] (the first part follows the P131 statements from the place, the second part restricts it to ones which are an instance of something which is a first level subdivision) [16:16:33] nikki: works beautifully. thank you so much :D [16:34:19] here's the final result: http://tinyurl.com/ycuzcql8 [16:34:28] thanks again for everyone's help :D [16:39:10] ciss: if you want to make the query extra easily configurable, you can add a query template: http://tinyurl.com/ya78rzxp [16:48:22] Lucas_WMDE: thanks, it seems to be somewhat fickle though. changing values immediately reformats the query and strips any comments [16:49:42] yeah, it parses the query to SPARQL and stringifies it again, throwing out comments in the process :/ [16:50:00] only toplevel comments are preserved, as a special case (because of #TEMPLATE and #defaultView) [16:50:22] i think i'll stick with a few bind statements at the top for now :) [16:50:28] sure :) [18:21:01] :( https://grafana.wikimedia.org/dashboard/db/wikidata-datamodel-statements?refresh=30m&panelId=4&fullscreen&orgId=1 [18:22:50] all those new sitelinked items? [18:30:07] yep [18:51:20] !admin https://www.wikidata.org/w/index.php?title=Special:Contributions&target=LadyOnTheRun [18:51:32] adding random stuff, irresponsive to talk page messages [18:51:44] done [18:51:49] :D [18:52:03] bedankt [19:15:19] sjoerddebruin : grab your popcorn, explanation's coming https://www.wikidata.org/w/index.php?title=User_talk:LadyOnTheRun&diff=513280434&oldid=513272553 [19:15:40] "My sister stole my phone!!!" [19:16:02] "and then, UFOs !" [19:16:26] "then, for some reason, jar jar binks…" *stops listening* [19:22:21] usual excuses [19:22:52] "I was trying to help the community by adding.... ah... Idk. I had no idea it was vandalism." [19:23:00] xD [19:23:16] "I promise I will never do so again." [19:23:21] So, what do you guys say. [19:29:17] keep blocked