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-sparq...
[2] http://kidehen.blogspot.com/2015/06/importing-data-into-microsoft-excel-via....
[3] http://kidehen.blogspot.com/2015/06/importing-data-into-google-spreadsheet.h...
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 <tmp2004@clbcm.com mailto:tmp2004@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>-- /navino@histropedia.com mailto:navino@histropedia.com/ @NavinoEvans https://twitter.com/NavinoEvans
www.histropedia.com http://www.histropedia.com/ Twitter https://twitter.com/Histropedia Facebo https://www.facebook.com/Histropediaok 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