[08:43:56] [mattermost] Hey folx - what is the good way to add a link to a web media appearance (online published TV report) into Wikidata profile of a person? [12:42:42] I have a quick question about COALESCE in SPARQL [12:43:08] in this example query, why do I get all three sets of coordinates despite the COALESCE? [12:43:09] https://w.wiki/pRb [13:16:10] Hello. I created a Wikidata page for my company and it got deleted. Why? [13:17:49] !admin [13:17:49] Please visit https://www.wikidata.org/wiki/WD:AN [13:20:59] Become: what is your username? [13:21:15] Become.co [13:22:43] Sorry - it got marked for deletion by an admin. My question stands. [13:22:57] Become: firstly you need a username change, because username same as company names are not allowed. [13:23:53] you can file username change request at https://www.wikidata.org/wiki/Special:GlobalRenameRequest [13:24:32] item was deleted because it do not met our notability policy, https://www.wikidata.org/wiki/Wikidata:Notability [13:26:13] In what sense? [13:27:28] you tell which of the criteria in above link it satisfy? [13:28:23] It refers to an instance of a clearly identifiable conceptual or material entity. The entity must be notable, in the sense that it can be described using serious and publicly available references. [13:29:01] we absolutely meet this criteria. we're in countless publications on notable media outlets including Medium and Forbes to name just a couple... [13:29:55] there were zero references used in that item which got deleted [13:31:11] I am not entirely familiar with how this all works - but I can clearly see I provided way more information about my company when I created that page than you can find about OnDeck here: https://www.wikidata.org/wiki/Q24204582 [13:31:39] So why is that page up and live, and mine got deleted? What is the criterion they met which I did not? [13:32:26] because it has an wikipedia article [13:34:34] so, in essence, if i create a wikipedia article for my company and use enough articles from outside sources as references in that article, i can then 'import from Wikimedia project'? [13:34:49] to create the associated Wikidata page? [13:35:15] yes. [13:35:29] ok. thank you for your help, i appreciate it [13:35:36] have a great day [13:35:56] and for you information, that another item will be also deleted.. [13:36:09] "become" one [13:36:23] because it also doesn't have any sources [13:36:52] not sure what you're referring to [13:37:12] https://www.wikidata.org/wiki/Q103899536 this one [13:37:30] Yes, that is the one I was originally referring to [13:38:20] I thought you were asking about https://www.wikidata.org/wiki/Q102352719 [13:38:35] but both of them have/had same issues [13:39:32] yeah, that one was deleted about a week ago to my understanding [13:39:40] and also don't forget to submit username change request, your current username is violation of policy [13:40:35] yes, i changed that first thing [13:40:36] thanks [13:42:07] Become: do you really want to user real name as username? [13:42:25] see https://en.wikipedia.org/wiki/Wikipedia:Username_policy#Real_names [13:47:15] What do you suggest? [13:48:08] BecomeAdmin better? BenBecome? i don't really mind, i just want to obey the rules and of course not cause myself any problems... not sure if using my name will be an issue for me personally, but if you think so then yeah, let's do something differnet [13:49:05] how about BenAtBecome? [13:49:18] sounds good to me [13:49:27] How about Ben2Become? [13:49:40] C1K98V: no [13:50:05] Lozenge: why so [13:50:19] BenAtBecome is just fine, thanks [13:50:51] Become: I have rejected the earlier request, please submit another one. https://www.wikidata.org/wiki/Special:GlobalRenameRequest [13:51:23] Lozenge: why you changed your irc Nick name [13:51:28] because other one is more clear [13:52:02] Both suggestions seems good... [13:52:28] I have both nicks [13:52:38] Ohh [13:52:42] Never knew about it [13:52:49] Lozenge I've submitted the request [13:53:02] cheers [14:22:10] [mattermost] Finnusertop_at_w: I think you want OPTIONAL, not UNION https://w.wiki/pS5 [14:24:21] I did it with OPTIONAL before, but it resulted in a slow query in the actual circumstances I used it in [14:28:50] this is closer to what I'm actually doing (on a much bigger set of items): https://w.wiki/pS7 [14:29:35] the problem is it also gives me ?objects that don't have anything the coordinates could come from [14:29:49] and takes a lot of time fetching labels for those useless results [15:15:54] [mattermost] hm, so you only want items that have *some* coordinates? https://w.wiki/pSL [15:17:18] [mattermost] https://w.wiki/pSN [15:28:54] that might work [15:44:21] I got it to work and it might be a little bit faster than my own implementation [15:56:29] [mattermost] nice! [17:36:58] Anyone here who could handle a quick block/revdel request? [17:39:12] (eh, just noticed there's a revdel channel, nvm) [23:15:03] What should I do if someone creates what appears to be a duplicate item, and are seemingly aware of the original item? [23:15:10] https://www.wikidata.org/wiki/Q532067 https://www.wikidata.org/wiki/Q103958847 [23:19:25] I guess it's possible there's Tonatico as a city, and Tonatico as a municipalities [23:19:44] but the articles look to be all for municipalities [23:20:16] Guess keep an eye on what they do, and then just merge the items back together [23:21:02] That's what I was thinking too, but I can't see anything like that on enwiki's: https://en.wikipedia.org/wiki/Tonatico [23:21:28] They did also remove some sitelinks from one so they could put it on the other which was weird. [23:21:31] the enwiki infobox does say Largest city Tonatico [23:21:51] Oh fart, you right [23:22:07] but like I say, the articles seem to be about the municipalities not the city [23:22:23] hmm. https://es.wikipedia.org/wiki/Tonatico does seem to be the city [23:22:35] maybe [23:22:38] * Reedy translates it [23:23:07] "town and municipal capital" [23:23:08] ffs [23:23:25] Ah [23:23:26] https://es.wikipedia.org/wiki/Municipio_de_Tonatico [23:23:48] So they shouldn't have removed the en one, I think [23:24:09] "and whose municipal capital is Tonatico" from that last link [23:25:04] I've moved the en entry back, and added an en description to the city... [23:25:16] and put "location" Tonatico Municipality [23:25:35] looks like it should've been P131 though [23:26:05] :) Thank you [23:27:22] ok, I think that makes https://www.wikidata.org/wiki/Q103958847 more sane now