[01:06:26] <sec^nd>	 I'm not sure where to ask this but how would I find all classes which are a subclass of a specific class in sparql?
[03:14:50] <yurik>	 sec^nd, still need it?
[03:15:14] <yurik>	 SMalyshev, around?  I think i found a weird bug in geo:distance
[03:36:56] <sec^nd>	 I am
[03:37:05] <sec^nd>	 I forget the question I asked :(
[03:37:30] <sec^nd>	 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
[03:37:30] <sec^nd>	 PREFIX schema: <http://schema.org/>
[03:37:30] <sec^nd>	 SELECT ?subject ?label ?comment
[03:37:31] <sec^nd>	 WHERE {
[03:37:31] <sec^nd>	   ?subject rdfs:subClassOf* schema:Thing .
[03:37:32] <sec^nd>	   ?subject rdfs:label ?label .
[03:37:33] <sec^nd>	   ?subject rdfs:comment ?comment
[03:37:34] <sec^nd>	 }
[03:37:38] <sec^nd>	 I've been doing this :D 
[03:37:50] <sec^nd>	 I'm learning (barely) SPARQL
[03:38:09] <sec^nd>	 I barely understand all of the RDF or SPARQL
[03:39:12] <yurik>	 sec^nd, its not too hard :) worry not.  also, when you want to share your query, there is a "link" button on the left side 
[03:39:31] <yurik>	 sec^nd, the subclassof is not relevant for wikidata
[03:40:11] <yurik>	 you need p279
[03:42:42] <yurik>	 sec^nd, http://tinyurl.com/ycmv4rey
[03:43:07] <yurik>	 the whole "service" thing is needed to extract Wikidata's label & description variables
[03:43:54] <yurik>	 mouse over the wdt and wd constants - it should explain what they are
[03:44:17] <sec^nd>	 I'm working on something unrelated and wasn't sure where to ask about RDF or SPARQL stuff
[03:44:22] <sec^nd>	 I am very sorry about that
[03:44:30] <sec^nd>	 Thank you for your help yurik :) 
[03:44:32] <yurik>	 well, it all depends on the data structure :)
[03:44:54] <yurik>	 wikidata stores subclasse using the P279.  But your data might be different
[03:45:10] <sec^nd>	 schema.org / RDF / RDFS
[03:45:20] <yurik>	 good luck :)
[03:45:23] <sec^nd>	 rdf:type and rdfs:subClassOf
[03:45:50] <yurik>	 yeah, in theory, rdfs:subClassOf is the same as wdt:P279 in wikidata
[03:46:44] <yurik>	 in any case, i highly recommend one of the 10 minute sparql videos - you will get a much better understanding 
[03:48:40] <sec^nd>	 yurik do you have a link?
[03:52:43] <yurik>	 sec^nd, https://www.youtube.com/watch?v=FvGndkpa4K0 ?
[03:52:53] <yurik>	 main portal https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/Wikidata_Query_Help
[03:52:57] <sec^nd>	 Thank you :)
[16:47:01] <AdityaAS>	 hey, any admins around?
[17:05:20] <yurik>	 SMalyshev, can you think of how its possible for my .jnl file to be exactly the same size as before I added optimizations?
[17:06:14] <SMalyshev>	 block allocations?
[17:06:40] <yurik>	 is there an easy way to test if blazegraph actually applies the "osmway:NNN" -> NNN storage?
[17:07:08] <yurik>	 i'm sure it is a block allocation, but I would have expected all subjects to take considerably less space
[18:58:19] <infovarius>	 hello everyone!
[18:58:54] <pintoch>	 hi :)
[18:58:57] <infovarius>	 can anyone help? Why https://petscan.wmflabs.org/?psid=1249972 gives only 3 results
[18:59:23] <infovarius>	 but if I change "Use wiki" to "Automatic", list of results become full
[18:59:44] <yurik>	 SMalyshev, ^^^^ - in case you have some storage ideas )
[18:59:54] <infovarius>	 (I am getting all Appendices from ru-wikt)
[19:01:33] <matej_suchanek>	 infovarius: given that there are only three appendices with an item in ru.wikt, you cannot get more I'm afraid
[19:02:06] <SMalyshev>	 yurik: I'm not sure... you can check how the items are represented with something like WikibaseInlineUriFactoryUnitTest is doing
[19:02:38] <yurik>	 SMalyshev, i'm already doing that in my unit tests, but i'm worried that in production they don't get used
[19:03:43] <SMalyshev>	 yurik: you could look at performance counters in /bigdata/counters maybe there's some useful info there...
[19:03:45] <infovarius>	 @matej_suchanek, what do you mean "only three". At https://ru.wiktionary.org/wiki/Категория:Викисловарь:Приложения I see at least 25
[19:03:54] <yurik>	 thx!
[19:04:18] <matej_suchanek>	 infovarius: *with an item*
[19:05:29] <infovarius>	 ok, but when I change to "Only pages without item", no changes
[19:06:17] <matej_suchanek>	 depends really on what you choose as source
[19:06:34] <matej_suchanek>	 I mean "use wiki"
[19:07:32] <infovarius>	 I am trying to use wiki=Wikidata and to create new items
[19:08:47] <matej_suchanek>	 then "use wiki": Wikidata makes no sense to me
[19:09:14] <infovarius>	 but this is the only variant to make edits to Wikidata...
[19:09:27] <matej_suchanek>	 apparently no :D
[19:10:07] <infovarius>	 please propose how to create new items for appendices in PetScan then
[19:10:22] <matej_suchanek>	 https://petscan.wmflabs.org/?psid=1249983 and log in
[19:11:30] <infovarius>	 hmm, I am looking for the difference...
[19:13:00] <infovarius>	 hmm, really "use wiki=automatic" and "only pages without item"? 
[19:13:17] <infovarius>	 I thought I've tried this...
[19:13:22] <infovarius>	 Thanks!
[19:14:15] <matej_suchanek>	 :)
[19:34:13] <infovarius>	 @matej_suchanek, btw "Add items where available" is not working for this
[19:35:03] <matej_suchanek>	 hm, the last option is actually the only one which works...
[19:35:52] <infovarius>	 yea, this is not expected behavior
[19:36:50] <matej_suchanek>	 good catch!
[20:02:40] <Leonard>	 Hello, any one listening here?
[20:05:49] <matej_suchanek>	 Leonard: now me
[21:29:38] <yurik>	 SMalyshev, did you implement distance by hand, or did you use JTS?
[21:29:48] <SMalyshev>	 what is JTS?
[21:30:48] <yurik>	 SMalyshev, https://github.com/locationtech/jts  -- basically PostGIS and many other C++ and other languages were originally ported from it
[21:31:03] <yurik>	 its a set of functions for working with geometries
[21:31:47] <SMalyshev>	 no, not using that one
[21:32:35] <yurik>	 maybe it would be better to use it - that's the most well known and respected geo library 
[21:35:12] <SMalyshev>	 I don't think it's be easy to rewrite blazegraph internals to use this library
[21:36:46] <yurik>	 SMalyshev, i thought you added that function yourself?
[21:37:06] <yurik>	 does it need to rewrite internals?
[21:37:14] <yurik>	 https://gis.stackexchange.com/questions/156465/calculate-distance-with-jts
[21:40:35] <SMalyshev>	 yurik: function yes, but it uses internal functions to do calculations
[21:41:15] <SMalyshev>	 and jts uses different types, etc.
[21:55:41] <SMalyshev>	 also it looks like JTS itself is 2d, and needs some plugins to do spherical stuff
[21:55:52] <SMalyshev>	 according to https://gis.stackexchange.com/a/156477/61458
[22:42:01] <sjoerddebruin>	 Where is my Wikidata onesie with buttflap? https://twitter.com/Andy_Lunique/status/902611171810869248
[23:07:00] <quiddity>	 sjoerddebruin, and goat horns/ears
[23:08:05] <sjoerddebruin>	 I'm still waiting for orders of goat merch (addshore)