Re: [Wikidata] Query Help - Stock Symbols and Wikipedia Pages

[Hampton Snowball]

Thank you Andrew. You are pointing out that simply trying to export p249
alone is not working properly or needs a different query, I see.

On Thu, Oct 13, 2016 at 3:02 PM, Hampton Snowball <hamptonsnowb...@gmail.com
> wrote:

> When I got to the 'what links here' for p249 seems like a lot more
> (hundreds) of entries:
>
> https://www.wikidata.org/wiki/Special:WhatLinksHere/Property:P249
>
>
> On Thu, Oct 13, 2016 at 2:20 PM, Andrew Gray <andrew.g...@dunelm.org.uk>
> wrote:
>
>> There are only 73 entries (including some duplicates) showing up for a
>> straight P249 search, which is a bit strange in any case -
>>
>> https://query.wikidata.org/#SELECT%20%3Fitem%20%20%3Fstock%
>> 20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP249%20%3Fstock%20.%0A%20%7D
>>
>> Sampling a few items suggests that most businesses don't use P249
>> directly, instead they use it as a qualifier on P414, eg
>> https://www.wikidata.org/wiki/Q156578 or
>> https://www.wikidata.org/wiki/Q156238
>>
>> These won't show up on a straight search. I'm not familiar with how
>> searching for qualifiers is best done, but at least it narrows down
>> the problem...
>>
>> A.
>>
>> On 13 October 2016 at 18:42, Hampton Snowball <hamptonsnowb...@gmail.com>
>> wrote:
>> > I took another query from this list and have been trying to modify it
>> to get
>> > stock symbols and there wikipedia pages.  But I am only getting 64
>> results.
>> > Am I  doing something wrong, filtering the results?
>> >
>> > http://tinyurl.com/go8zpvy
>> >
>> > Thanks in advance!
>> >
>> > Hampton
>> >
>> > ___
>> > Wikidata mailing list
>> > Wikidata@lists.wikimedia.org
>> > https://lists.wikimedia.org/mailman/listinfo/wikidata
>> >
>>
>>
>>
>> --
>> - Andrew Gray
>>   andrew.g...@dunelm.org.uk
>>
>> ___
>> 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

Re: [Wikidata] Query Help - Stock Symbols and Wikipedia Pages

[Hampton Snowball]

When I got to the 'what links here' for p249 seems like a lot more
(hundreds) of entries:

https://www.wikidata.org/wiki/Special:WhatLinksHere/Property:P249


On Thu, Oct 13, 2016 at 2:20 PM, Andrew Gray <andrew.g...@dunelm.org.uk>
wrote:

> There are only 73 entries (including some duplicates) showing up for a
> straight P249 search, which is a bit strange in any case -
>
> https://query.wikidata.org/#SELECT%20%3Fitem%20%20%
> 3Fstock%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP249%20%3Fstock%20.%0A%20%7D
>
> Sampling a few items suggests that most businesses don't use P249
> directly, instead they use it as a qualifier on P414, eg
> https://www.wikidata.org/wiki/Q156578 or
> https://www.wikidata.org/wiki/Q156238
>
> These won't show up on a straight search. I'm not familiar with how
> searching for qualifiers is best done, but at least it narrows down
> the problem...
>
> A.
>
> On 13 October 2016 at 18:42, Hampton Snowball <hamptonsnowb...@gmail.com>
> wrote:
> > I took another query from this list and have been trying to modify it to
> get
> > stock symbols and there wikipedia pages.  But I am only getting 64
> results.
> > Am I  doing something wrong, filtering the results?
> >
> > http://tinyurl.com/go8zpvy
> >
> > Thanks in advance!
> >
> > Hampton
> >
> > ___
> > Wikidata mailing list
> > Wikidata@lists.wikimedia.org
> > https://lists.wikimedia.org/mailman/listinfo/wikidata
> >
>
>
>
> --
> - Andrew Gray
>   andrew.g...@dunelm.org.uk
>
> ___
> 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

[Wikidata] Wikidata Query Help: IMDB id + wikipedia

[Hampton Snowball]

Hello,

I am trying to query the wikidata service for IMDB + the wikipedia of the
person. English only wikipedia is okay too.

I previously was able to use the following to include the
english wikipedia in the query, which is included below. I've tried the
query below, but believe I am doing something wrong. Your help is
appreciated. Thanks!

query:

PREFIX wd: 
PREFIX wdt: 
PREFIX rdfs: 
PREFIX schema: 

SELECT ?item  ?IMDB ?article WHERE {
  ?item wdt:P345 ?IMDB
  OPTIONAL {?item rdfs:label ?item_label filter (lang(?item_label) = "en")
.}

  ?article schema:about ?item .
  ?article schema:inLanguage "en" .
  FILTER (SUBSTR(str(?article), 1, 25) = "https://en.wikipedia.org/;)

 }
ORDER BY ASC (?article)
___
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata

Re: [Wikidata] Wikidata - short biographies

[Hampton Snowball]

I was able to semi-successfully use RDFSlice with the dump using Windows
command prompt.  Only, maybe because it's a 5gb dump file I am getting java
errors line after line as it goes through the file
(java.lang.StringIndexOutOfBoundsException: String index out of range - 1.
Sometimes the last number changes).

I thought it might might be a memory issue.  Increasing memory with the
-Xmx2G command (or 3G, 4G) I haven't had luck with.  Any tips would be
appreciated.

Thanks

On Mon, Feb 1, 2016 at 7:28 PM, Hampton Snowball <hamptonsnowb...@gmail.com>
wrote:

> Of course I meant sorry if this is a dumb question :)
>
>
>
> On Mon, Feb 1, 2016 at 7:13 PM, Hampton Snowball <
> hamptonsnowb...@gmail.com> wrote:
>
>> Sorry if this is a dump question (I'm not a developer).  To run the
>> command on the rdfslice program in mentions (" java -jar rdfslice.jar
>> -source | -patterns  -out  -order
>>  -debug ), can this be done with windows command
>> prompt? or do I need some special developer version of java/console?
>>
>> Thanks for the tool.
>>
>> On Sun, Jan 31, 2016 at 3:53 PM, Edgard Marx <
>> m...@informatik.uni-leipzig.de> wrote:
>>
>>> Hey,
>>> you can simple use RDFSlice (
>>> https://bitbucket.org/emarx/rdfslice/overview) directly on the dump
>>> file (https://dumps.wikimedia.org/wikidatawiki/entities/20160125/)
>>>
>>> best,
>>> Edgard
>>>
>>> On Sun, Jan 31, 2016 at 7:43 PM, Hampton Snowball <
>>> hamptonsnowb...@gmail.com> wrote:
>>>
>>>> Hello,
>>>>
>>>> I am interested in a subset of wikidata and I am trying to find the
>>>> best way to get it without getting a larger dataset then necessary.
>>>>
>>>> Is there a way to just get the "bios" that appear on the wikidata pages
>>>> below the name of the person/organization, as well as the link to the
>>>> english wikipedia page / or all wikipedia pages?
>>>>
>>>> For example from: https://www.wikidata.org/wiki/Q1652291;
>>>>
>>>> "Turkish female given name"
>>>> https://en.wikipedia.org/wiki/H%C3%BClya
>>>> and optionally https://de.wikipedia.org/wiki/H%C3%BClya
>>>>
>>>> I know there is SPARQL which previously this list helped me construct a
>>>> query, but I know some requests seem to timeout when looking at a large
>>>> amount of data so I am not sure this would work.
>>>>
>>>> The dumps I know are the full dataset, but I am not sure if there's any
>>>> other subset dumps available or better way of grabbing this data
>>>>
>>>> Thanks in advance,
>>>> HS
>>>>
>>>>
>>>> ___
>>>> 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
>>>
>>>
>>
>
___
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata

Re: [Wikidata] Wikidata - short biographies

[Hampton Snowball]

Okay, thanks!

On Tue, Feb 2, 2016 at 8:55 AM, Edgard Marx <m...@informatik.uni-leipzig.de>
wrote:

> Hey,
>
> I recommend you to not post doubts related with third part systems or
> softwares that are not related with Wikidata or Wikimida here.
> In case of RDFSlice there is a page called issues (
> https://bitbucket.org/emarx/rdfslice/issues),
> where you can open an issue and someone will answer you.
>
> I also advise you to post your command line or a error, so the developers
> can better understand it and quickly fix it (if there is a problem).
>
> best regards,
> Edgard
>
> On Tue, Feb 2, 2016 at 7:18 AM, Hampton Snowball <
> hamptonsnowb...@gmail.com> wrote:
>
>> I was able to semi-successfully use RDFSlice with the dump using Windows
>> command prompt.  Only, maybe because it's a 5gb dump file I am getting java
>> errors line after line as it goes through the file
>> (java.lang.StringIndexOutOfBoundsException: String index out of range - 1.
>> Sometimes the last number changes).
>>
>> I thought it might might be a memory issue.  Increasing memory with the
>> -Xmx2G command (or 3G, 4G) I haven't had luck with.  Any tips would be
>> appreciated.
>>
>> Thanks
>>
>> On Mon, Feb 1, 2016 at 7:28 PM, Hampton Snowball <
>> hamptonsnowb...@gmail.com> wrote:
>>
>>> Of course I meant sorry if this is a dumb question :)
>>>
>>>
>>>
>>> On Mon, Feb 1, 2016 at 7:13 PM, Hampton Snowball <
>>> hamptonsnowb...@gmail.com> wrote:
>>>
>>>> Sorry if this is a dump question (I'm not a developer).  To run the
>>>> command on the rdfslice program in mentions (" java -jar rdfslice.jar
>>>> -source | -patterns  -out  -order
>>>>  -debug ), can this be done with windows
>>>> command prompt? or do I need some special developer version of 
>>>> java/console?
>>>>
>>>> Thanks for the tool.
>>>>
>>>> On Sun, Jan 31, 2016 at 3:53 PM, Edgard Marx <
>>>> m...@informatik.uni-leipzig.de> wrote:
>>>>
>>>>> Hey,
>>>>> you can simple use RDFSlice (
>>>>> https://bitbucket.org/emarx/rdfslice/overview) directly on the dump
>>>>> file (https://dumps.wikimedia.org/wikidatawiki/entities/20160125/)
>>>>>
>>>>> best,
>>>>> Edgard
>>>>>
>>>>> On Sun, Jan 31, 2016 at 7:43 PM, Hampton Snowball <
>>>>> hamptonsnowb...@gmail.com> wrote:
>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> I am interested in a subset of wikidata and I am trying to find the
>>>>>> best way to get it without getting a larger dataset then necessary.
>>>>>>
>>>>>> Is there a way to just get the "bios" that appear on the wikidata
>>>>>> pages below the name of the person/organization, as well as the link to 
>>>>>> the
>>>>>> english wikipedia page / or all wikipedia pages?
>>>>>>
>>>>>> For example from: https://www.wikidata.org/wiki/Q1652291;
>>>>>>
>>>>>> "Turkish female given name"
>>>>>> https://en.wikipedia.org/wiki/H%C3%BClya
>>>>>> and optionally https://de.wikipedia.org/wiki/H%C3%BClya
>>>>>>
>>>>>> I know there is SPARQL which previously this list helped me construct
>>>>>> a query, but I know some requests seem to timeout when looking at a large
>>>>>> amount of data so I am not sure this would work.
>>>>>>
>>>>>> The dumps I know are the full dataset, but I am not sure if there's
>>>>>> any other subset dumps available or better way of grabbing this data
>>>>>>
>>>>>> Thanks in advance,
>>>>>> HS
>>>>>>
>>>>>>
>>>>>> ___
>>>>>> 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
>>>>>
>>>>>
>>>>
>>>
>>
>> ___
>> 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
>
>
___
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata

Re: [Wikidata] Wikidata - short biographies

[Hampton Snowball]

Thanks.

I only plan on using a query to extract from all
english wikidata "articles" or all articles though anyway, hopefully the
other queries will work.

On Mon, Feb 1, 2016 at 4:33 PM, Stas Malyshev 
wrote:

> Hi!
>
> > *The first one, which seems to be only for 1 record, just as a test
> > seemed to give me an ERROR though:*
> >
> >
> > PREFIX wd: 
> > PREFIX wdt: 
> > PREFIX rdfs: 
> > PREFIX schema: 
> >
> > SELECT *
> > WHERE
> > {
> >
> >   ?o .
> > filter(lang(?o)='en').
> >
> > ?article schema:about ?item .
> > ?article schema:inLanguage "en" .
> > FILTER (SUBSTR(str(?article), 1, 25) = "https://en.wikipedia.org/;)
> > }
>
> This one is not correct - ?item should be replaced by
> . Or you can use BIND or VALUES
> syntax in SPARQL to bind all instanced of ?item to one or more specific
> items. But if you just leave it as ?item it matches any value - which
> means you just made it scan through all 15M items :) That will time out.
>
> --
> Stas Malyshev
> smalys...@wikimedia.org
>
> ___
> 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

Re: [Wikidata] Wikidata - short biographies

[Hampton Snowball]

Sorry if this is a dump question (I'm not a developer).  To run the command
on the rdfslice program in mentions (" java -jar rdfslice.jar -source
| -patterns  -out  -order 
-debug ), can this be done with windows command prompt? or
do I need some special developer version of java/console?

Thanks for the tool.

On Sun, Jan 31, 2016 at 3:53 PM, Edgard Marx <m...@informatik.uni-leipzig.de
> wrote:

> Hey,
> you can simple use RDFSlice (https://bitbucket.org/emarx/rdfslice/overview)
> directly on the dump file (
> https://dumps.wikimedia.org/wikidatawiki/entities/20160125/)
>
> best,
> Edgard
>
> On Sun, Jan 31, 2016 at 7:43 PM, Hampton Snowball <
> hamptonsnowb...@gmail.com> wrote:
>
>> Hello,
>>
>> I am interested in a subset of wikidata and I am trying to find the best
>> way to get it without getting a larger dataset then necessary.
>>
>> Is there a way to just get the "bios" that appear on the wikidata pages
>> below the name of the person/organization, as well as the link to the
>> english wikipedia page / or all wikipedia pages?
>>
>> For example from: https://www.wikidata.org/wiki/Q1652291;
>>
>> "Turkish female given name"
>> https://en.wikipedia.org/wiki/H%C3%BClya
>> and optionally https://de.wikipedia.org/wiki/H%C3%BClya
>>
>> I know there is SPARQL which previously this list helped me construct a
>> query, but I know some requests seem to timeout when looking at a large
>> amount of data so I am not sure this would work.
>>
>> The dumps I know are the full dataset, but I am not sure if there's any
>> other subset dumps available or better way of grabbing this data
>>
>> Thanks in advance,
>> HS
>>
>>
>> ___
>> 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
>
>
___
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata

Re: [Wikidata] Wikidata - short biographies

[Hampton Snowball]

Of course I meant sorry if this is a dumb question :)



On Mon, Feb 1, 2016 at 7:13 PM, Hampton Snowball <hamptonsnowb...@gmail.com>
wrote:

> Sorry if this is a dump question (I'm not a developer).  To run the
> command on the rdfslice program in mentions (" java -jar rdfslice.jar
> -source | -patterns  -out  -order
>  -debug ), can this be done with windows command
> prompt? or do I need some special developer version of java/console?
>
> Thanks for the tool.
>
> On Sun, Jan 31, 2016 at 3:53 PM, Edgard Marx <
> m...@informatik.uni-leipzig.de> wrote:
>
>> Hey,
>> you can simple use RDFSlice (
>> https://bitbucket.org/emarx/rdfslice/overview) directly on the dump file
>> (https://dumps.wikimedia.org/wikidatawiki/entities/20160125/)
>>
>> best,
>> Edgard
>>
>> On Sun, Jan 31, 2016 at 7:43 PM, Hampton Snowball <
>> hamptonsnowb...@gmail.com> wrote:
>>
>>> Hello,
>>>
>>> I am interested in a subset of wikidata and I am trying to find the best
>>> way to get it without getting a larger dataset then necessary.
>>>
>>> Is there a way to just get the "bios" that appear on the wikidata pages
>>> below the name of the person/organization, as well as the link to the
>>> english wikipedia page / or all wikipedia pages?
>>>
>>> For example from: https://www.wikidata.org/wiki/Q1652291;
>>>
>>> "Turkish female given name"
>>> https://en.wikipedia.org/wiki/H%C3%BClya
>>> and optionally https://de.wikipedia.org/wiki/H%C3%BClya
>>>
>>> I know there is SPARQL which previously this list helped me construct a
>>> query, but I know some requests seem to timeout when looking at a large
>>> amount of data so I am not sure this would work.
>>>
>>> The dumps I know are the full dataset, but I am not sure if there's any
>>> other subset dumps available or better way of grabbing this data
>>>
>>> Thanks in advance,
>>> HS
>>>
>>>
>>> ___
>>> 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
>>
>>
>
___
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata

Re: [Wikidata] Wikidata - short biographies

[Hampton Snowball]

Thank you. This will give me the bios, however, I still want the associated
wikipedia links.  Previously someone had given me a query that included the
english wikipedia along with another property. You can see it below:


PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX schema: <http://schema.org/>

SELECT ?item  ?twitter ?article WHERE {
  ?item wdt:P2002 ?twitter
  OPTIONAL {?item rdfs:label ?item_label filter (lang(?item_label) = "en")
.}

  ?article schema:about ?item .
  ?article schema:inLanguage "en" .
  FILTER (SUBSTR(str(?article), 1, 25) = "https://en.wikipedia.org/;)

 }
ORDER BY ASC (?article)


*I tried to take the PREFIX header and this portion to append to some of
your queries.  *

  ?article schema:about ?item .
  ?article schema:inLanguage "en" .
  FILTER (SUBSTR(str(?article), 1, 25) = "https://en.wikipedia.org/;)


*The first one, which seems to be only for 1 record, just as a test seemed
to give me an ERROR though:*


PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX schema: <http://schema.org/>

SELECT *
WHERE
{
   <http://www.wikidata.org/entity/Q1652291>  <http://schema.org/description>
?o .
filter(lang(?o)='en').

?article schema:about ?item .
?article schema:inLanguage "en" .
FILTER (SUBSTR(str(?article), 1, 25) = "https://en.wikipedia.org/;)
}

*So I assume the other queries like this would not work (would timeout on
query.wikidata.org <http://query.wikidata.org> so can't test):*


PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX schema: <http://schema.org/>

SELECT *
WHERE
{
   ?s <http://schema.org/description> ?o .
   filter(lang(?o)='en').

?article schema:about ?item .
?article schema:inLanguage "en" .
FILTER (SUBSTR(str(?article), 1, 25) = "https://en.wikipedia.org/;)
}


So am I doing something wrong with these combined queries in the syntax?

Thanks in advance again, and the help thus far!


On Mon, Feb 1, 2016 at 1:19 AM, Edgard Marx <m...@informatik.uni-leipzig.de>
wrote:

> Yep,
>
> Please notes that RDFSlice will take the subset.
> That is, the triples that contain the property that you are looking for.
> Here go three examples of SPARQL queries:
>
> ps: you can try them here https://query.wikidata.org.
>
> ** For your example,*
>
> SELECT *
> WHERE
> {
><http://www.wikidata.org/entity/Q1652291>  <
> http://schema.org/description> ?o .
> filter(lang(?o)='en').
> }
>
>
> ** For all English bios:*
>
> SELECT *
> WHERE
> {
>?s <http://schema.org/description> ?o .
>filter(lang(?o)='en').
> }
>
> ** For all language bios:*
>
> SELECT *
> WHERE
> {
><http://www.wikidata.org/entity/Q1652291>  <
> http://schema.org/description> ?o .
> }
>
>
> best,
> Edgard
>
>
>
> On Mon, Feb 1, 2016 at 4:34 AM, Hampton Snowball <
> hamptonsnowb...@gmail.com> wrote:
>
>> Thanks. I see it requires constructing a query to only extract the data
>> you want. E.g. the graph pattern:
>>
>>  - desired query, e.g. "SELECT * WHERE {?s ?p ?o}" or
>> graph pattern e.g. "{?s ?p ?o}"
>>
>> Since I don't know about constructing queries, would you be able to tell
>> me what would be the proper query to extract from all the pages the short
>> bio, english wikipedia, maybe other wikipedias?
>>
>> For example from: https://www.wikidata.org/wiki/Q1652291;
>>
>> "Turkish female given name"
>> https://en.wikipedia.org/wiki/H%C3%BClya
>> and optionally https://de.wikipedia.org/wiki/H%C3%BClya
>>
>> Thanks in advance!
>>
>>
>> On Sun, Jan 31, 2016 at 3:53 PM, Edgard Marx <
>> m...@informatik.uni-leipzig.de> wrote:
>>
>>> Hey,
>>> you can simple use RDFSlice (
>>> https://bitbucket.org/emarx/rdfslice/overview) directly on the dump
>>> file (https://dumps.wikimedia.org/wikidatawiki/entities/20160125/)
>>>
>>> best,
>>> Edgard
>>>
>>> On Sun, Jan 31, 2016 at 7:43 PM, Hampton Snowball <
>>> hamptonsnowb...@gmail.com> wrote:
>>>
>>>> Hello,
>>>>
>>>> I am interested in a subset of wikidata and I am trying to find the
>>>> best way to get it without getting a larger dataset then necessary.
>>&

Re: [Wikidata] Wikidata - short biographies

[Hampton Snowball]

Thanks. I see it requires constructing a query to only extract the data you
want. E.g. the graph pattern:

 - desired query, e.g. "SELECT * WHERE {?s ?p ?o}" or graph
pattern e.g. "{?s ?p ?o}"

Since I don't know about constructing queries, would you be able to tell me
what would be the proper query to extract from all the pages the short bio,
english wikipedia, maybe other wikipedias?

For example from: https://www.wikidata.org/wiki/Q1652291;

"Turkish female given name"
https://en.wikipedia.org/wiki/H%C3%BClya
and optionally https://de.wikipedia.org/wiki/H%C3%BClya

Thanks in advance!


On Sun, Jan 31, 2016 at 3:53 PM, Edgard Marx <m...@informatik.uni-leipzig.de
> wrote:

> Hey,
> you can simple use RDFSlice (https://bitbucket.org/emarx/rdfslice/overview)
> directly on the dump file (
> https://dumps.wikimedia.org/wikidatawiki/entities/20160125/)
>
> best,
> Edgard
>
> On Sun, Jan 31, 2016 at 7:43 PM, Hampton Snowball <
> hamptonsnowb...@gmail.com> wrote:
>
>> Hello,
>>
>> I am interested in a subset of wikidata and I am trying to find the best
>> way to get it without getting a larger dataset then necessary.
>>
>> Is there a way to just get the "bios" that appear on the wikidata pages
>> below the name of the person/organization, as well as the link to the
>> english wikipedia page / or all wikipedia pages?
>>
>> For example from: https://www.wikidata.org/wiki/Q1652291;
>>
>> "Turkish female given name"
>> https://en.wikipedia.org/wiki/H%C3%BClya
>> and optionally https://de.wikipedia.org/wiki/H%C3%BClya
>>
>> I know there is SPARQL which previously this list helped me construct a
>> query, but I know some requests seem to timeout when looking at a large
>> amount of data so I am not sure this would work.
>>
>> The dumps I know are the full dataset, but I am not sure if there's any
>> other subset dumps available or better way of grabbing this data
>>
>> Thanks in advance,
>> HS
>>
>>
>> ___
>> 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
>
>
___
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata

[Wikidata] Query Help

[Hampton Snowball]

I'm looking to use the https://query.wikidata.org/ interface to export to
csv all wikidatas with this property P2002.

https://www.wikidata.org/w/index.php?title=Special:WhatLinksHere/Property:P2002=500=21542767=20967485

I am looking for the Wikipedia Article_Name + the value associated with
that property.

Thanks in advance!
___
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata

Re: [Wikidata] Query Help

[Hampton Snowball]

Thank you. Is there a way to export it though with the Wikipedia Article
name with underscores or wikipedia url?  So like Barack_Obama or
en.wikipedia.org/wiki/Barack_Obama.

On Mon, Nov 9, 2015 at 11:34 AM, Remko de Keijzer <re...@remkodekeijzer.nl>
wrote:

> I think this: http://tinyurl.com/o5lahko is what you wanted. It's got the
> item ID, the label and the value of P2002.
>
> --
> Mbch331
>
> When you have eliminated the impossible, whatever remains, however 
> improbable, must be the truth.
> (Sir Arthur Conan Doyle)
>
> Op 9-11-2015 om 17:09 schreef Hampton Snowball:
>
> I'm looking to use the  <https://query.wikidata.org/>
> https://query.wikidata.org/ interface to export to csv all wikidatas with
> this property P2002.
>
>
> https://www.wikidata.org/w/index.php?title=Special:WhatLinksHere/Property:P2002=500=21542767=20967485
>
> I am looking for the Wikipedia Article_Name + the value associated with
> that property.
>
> Thanks in advance!
>
>
>
> ___
> Wikidata mailing 
> listWikidata@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/wikidata
>
>
>
> ___
> 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

Re: [Wikidata] Query Help

[Hampton Snowball]

Maybe I misunderstood.  I think the item label is actually what's used in
the wikipedia article url, just convert spaces to underscores?

Thanks!

On Mon, Nov 9, 2015 at 11:47 AM, Hampton Snowball <hamptonsnowb...@gmail.com
> wrote:

> Thank you. Is there a way to export it though with the Wikipedia Article
> name with underscores or wikipedia url?  So like Barack_Obama or
> en.wikipedia.org/wiki/Barack_Obama.
>
> On Mon, Nov 9, 2015 at 11:34 AM, Remko de Keijzer <re...@remkodekeijzer.nl
> > wrote:
>
>> I think this: http://tinyurl.com/o5lahko is what you wanted. It's got
>> the item ID, the label and the value of P2002.
>>
>> --
>> Mbch331
>>
>> When you have eliminated the impossible, whatever remains, however 
>> improbable, must be the truth.
>> (Sir Arthur Conan Doyle)
>>
>> Op 9-11-2015 om 17:09 schreef Hampton Snowball:
>>
>> I'm looking to use the  <https://query.wikidata.org/>
>> https://query.wikidata.org/ interface to export to csv all wikidatas
>> with this property P2002.
>>
>>
>> https://www.wikidata.org/w/index.php?title=Special:WhatLinksHere/Property:P2002=500=21542767=20967485
>>
>> I am looking for the Wikipedia Article_Name + the value associated with
>> that property.
>>
>> Thanks in advance!
>>
>>
>>
>> ___
>> Wikidata mailing 
>> listWikidata@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/wikidata
>>
>>
>>
>> ___
>> 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

Re: [Wikidata] Query Help

[Hampton Snowball]

I think a lot of the freebase handles can be out of date and incorrect in
what I previously saw.

On Mon, Nov 9, 2015 at 2:56 PM, Tom Morris  wrote:

> Freebase has another 18,000 Twitter handles which are linked to IMDB, G+,
> etc which don't have English Wikipedia links (as well as 13K which are
> linked to English Wikipedia, although those should be in Wikidata too).
> http://tinyurl.com/omb6bxf
>
> I know some Wikipedias actively discourage links to social networking
> sites like Twitter [1].  What is Wikidata's position on Twitter handles?
> Is the existence of the property P2002 sufficient justification to fill it
> in? (Unlike enwiki's "Yes, we have Twitter template, but you shouldn't be
> using it" stance [2]).
>
> Tom
>
> [1]
> https://en.wikipedia.org/wiki/Wikipedia:External_links#Links_normally_to_be_avoided
> [2] https://en.wikipedia.org/wiki/Template:Twitter
>
> ___
> 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