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(a)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(a)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(a)lists.wikimedia.org
<mailto:Wikidata@lists.wikimedia.org>
https://lists.wikimedia.org/mailman/listinfo/wikidata
<https://lists.wikimedia.org/mailman/listinfo/wikidata>
--
/navino(a)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/Histropedia>ok
<https://www.facebook.com/Histropedia> Google +
<https://plus.google.com/+Histropedia>
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org