On 2/24/17 4:00 PM, Rick Labs wrote: > > Nav, > > YES!!! that's it! Your SPARQL works perfectly, exactly what I wanted. > > Thanks very much. Just had to learn how to get the CVS into Excel as > UTF-8, not hard. Can finally see what objects people want immediately > below "Organizations", worldwide. (yes, whats evolved is pretty darn > "chaotic") > > Very much appreciated. > > Rick
An FYI, and happy to receive feedback about how to achieve the same thing directly from Wikidata: [1] http://tinyurl.com/gohu2eg -- SPARQL-FED from a Service that can return a CSV doc URI [2] http://tinyurl.com/zblqqf2 -- SPARQL Query Results in CSV format. Getting the CSV into Google Spreadsheet boils down to the formula: =importData("http://tinyurl.com/zblqqf2") or the use the raw URI if the tinyURL trips up Google Spreadsheet. curl -iLO http://tinyurl.com/zblqqf2 to make a local copy that you can import into Excel using its CSV import. In the past, you used to be able to consume a URI directly in Excel, but things have gotten strange of late. Links: [1] https://www.linkedin.com/pulse/importing-data-google-spreadsheet-using-sparql-kingsley-uyi-idehen [2] http://kidehen.blogspot.com/2015/06/importing-data-into-microsoft-excel-via.html [3] http://kidehen.blogspot.com/2015/06/importing-data-into-google-spreadsheet.html Kingsley > > On 2/24/2017 7:25 AM, Navino Evans wrote: >> Hi Rick, >> >> Is this what you're after? http://tinyurl.com/z7ru9yr >> Once you run the query there is a download drop-down menu, just above >> the query results on the right hand side of the screen - it has a >> range of options including CSV. >> Hope that helps! >> Nav >> >> >> On 24 February 2017 at 02:25, Rick Labs <tmp2...@clbcm.com >> <mailto:tmp2...@clbcm.com>> wrote: >> >> Thanks Stas & especially Kingsley for the example: >> >> # All subclasses of a class example >> # here all subclasses of P279 Organization (Q43229) >> SELECT ?item ?label ?itemDescription ?itemAltLabel >> WHERE >> { >> ?item wdt:P279 wd:Q43229; >> rdfs:label ?label . >> # SERVICE wikibase:label { bd:serviceParam wikibase:language >> "en,de,fr,ja,cn,ru,es,sv,pl,nl,sl,ca,it" } >> FILTER (LANG(?label) = "en") >> } >> ORDER BY ASC(LCASE(?itemLabel)) >> >> When I pull the FILTER line out of above I have almost what I >> need - "the universe" of all sub classes of organization >> (regardless of language). I want all subclasses in the output, >> not just those available currently with an English label. >> >> In the table output, is it possible to get: a column for language >> code, and get the description to show up (if available for that >> row)? That would be very helpful prior to my manual operations. >> >> Can I easily export the results table to CSV or Excel? I can >> filter and sort easily from there provided I have the hooks. >> >> Thanks very much! >> >> Rick >> >> . >> >> >> >> >> >> On 2/23/2017 1:22 PM, Kingsley Idehen wrote: >>> On 2/23/17 12:59 PM, Stas Malyshev wrote: >>>> Hi! >>>> >>>> On 2/23/17 7:20 AM, Thad Guidry wrote: >>>>> In Freebase we had a parameter %lang=all >>>>> >>>>> Does the SPARQL label service have something similar ? >>>> Not as such, but you don't need it if you want all the labels, just do: >>>> >>>> ?item rdfs:label ?label >>>> >>>> and you'd get all labels. No need to invoke service for that, the >>>> service is for when you have specific set of languages you're >>>> interested >>>> in. >>> >>> Yep. >>> >>> Example at: http://tinyurl.com/h2sbvhd >>> >>> -- >>> Regards, >>> >>> Kingsley Idehen >>> Founder & CEO >>> OpenLink Software (Home Page: http://www.openlinksw.com) >>> >>> Weblogs (Blogs): >>> Legacy Blog: http://www.openlinksw.com/blog/~kidehen/ >>> <http://www.openlinksw.com/blog/%7Ekidehen/> >>> Blogspot Blog: http://kidehen.blogspot.com >>> Medium Blog: https://medium.com/@kidehen >>> >>> Profile Pages: >>> Pinterest: https://www.pinterest.com/kidehen/ >>> <https://www.pinterest.com/kidehen/> >>> Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen >>> <https://www.quora.com/profile/Kingsley-Uyi-Idehen> >>> Twitter: https://twitter.com/kidehen >>> Google+: https://plus.google.com/+KingsleyIdehen/about >>> <https://plus.google.com/+KingsleyIdehen/about> >>> LinkedIn: http://www.linkedin.com/in/kidehen >>> <http://www.linkedin.com/in/kidehen> >>> >>> Web Identities (WebID): >>> Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this >>> <http://kingsley.idehen.net/dataspace/person/kidehen#this> >>> : >>> http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this >>> >>> <http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this> >>> >>> _______________________________________________ >>> Wikidata mailing list >>> Wikidata@lists.wikimedia.org <mailto:Wikidata@lists.wikimedia.org> >>> https://lists.wikimedia.org/mailman/listinfo/wikidata >>> <https://lists.wikimedia.org/mailman/listinfo/wikidata> >> _______________________________________________ Wikidata mailing >> list Wikidata@lists.wikimedia.org >> <mailto:Wikidata@lists.wikimedia.org> >> https://lists.wikimedia.org/mailman/listinfo/wikidata >> <https://lists.wikimedia.org/mailman/listinfo/wikidata> >> >> -- >> /nav...@histropedia.com <mailto:nav...@histropedia.com>/ >> @NavinoEvans <https://twitter.com/NavinoEvans> >> ----------------------------------------- >> www.histropedia.com <http://www.histropedia.com/> >> Twitter <https://twitter.com/Histropedia> Facebo >> <https://www.facebook.com/Histropedia>ok >> <https://www.facebook.com/Histropedia> Google + >> <https://plus.google.com/+Histropedia> >> >> _______________________________________________ >> Wikidata mailing list >> Wikidata@lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/wikidata > > _______________________________________________ > Wikidata mailing list > Wikidata@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikidata -- Regards, Kingsley Idehen Founder & CEO OpenLink Software (Home Page: http://www.openlinksw.com) Weblogs (Blogs): Legacy Blog: http://www.openlinksw.com/blog/~kidehen/ Blogspot Blog: http://kidehen.blogspot.com Medium Blog: https://medium.com/@kidehen Profile Pages: Pinterest: https://www.pinterest.com/kidehen/ Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen Twitter: https://twitter.com/kidehen Google+: https://plus.google.com/+KingsleyIdehen/about LinkedIn: http://www.linkedin.com/in/kidehen Web Identities (WebID): Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata