Hi,
You could also try the following query:
SELECT ?software ?softwareLabel
WHERE
{
[] wdt:P4290 ?software.
OPTIONAL{?software wdt:P31 wd:Q341.}
SERVICE wikibase:label { bd:serviceParam wikibase:language
"[AUTO_LANGUAGE]". }
}
This will give you all the mobile applications (currently 30). As Nicolas
says, you may need to use licence information or other properties like
software repository.
Best,
John Samuel
On Mon, Jun 4, 2018 at 2:00 PM, <wikidata-request(a)lists.wikimedia.org>
wrote:
> Send Wikidata mailing list submissions to
> wikidata(a)lists.wikimedia.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.wikimedia.org/mailman/listinfo/wikidata
> or, via email, send a message with subject or body 'help' to
> wikidata-request(a)lists.wikimedia.org
>
> You can reach the person managing the list at
> wikidata-owner(a)lists.wikimedia.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Wikidata digest..."
>
>
> Today's Topics:
>
> 1. SPARQL to retrieve a list of open source mobile apps
> (Sebastian Kürten)
> 2. Re: SPARQL to retrieve a list of open source mobile apps
> (Nicolas VIGNERON)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 4 Jun 2018 13:50:32 +0200
> From: Sebastian Kürten <sebastian.kuerten(a)fu-berlin.de>
> To: wikidata(a)lists.wikimedia.org
> Subject: [Wikidata] SPARQL to retrieve a list of open source mobile
> apps
> Message-ID: <20180604135032.0ddabce3@pluto>
> Content-Type: text/plain; charset=US-ASCII
>
> Hello,
>
> I'm trying to retrieve a list of open source mobile applications using
> the Wikidata Query Service. After identifying the item for K9-Mail
> (Q14565723), I can see that it has "instance of" (P31) set to both
> "free software" (Q341) and "mobile app" (Q620615). I hence derived the
> following SPARQL query, to retrieve similar items:
>
> SELECT ?software ?softwareLabel
> WHERE
> {
> ?software wdt:P31 wd:Q341, wd:Q620615.
> SERVICE wikibase:label { bd:serviceParam wikibase:language
> "[AUTO_LANGUAGE]". }
> }
>
> It returns three results, but to my suprise, it does not return the
> item for K9-Mail. Given that the query is such a simple one, I'm
> wondering what I am doing wrong here? Or is something else possibly not
> working correctly?
>
> Thanks for your help,
> Sebastian
>
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 4 Jun 2018 13:58:21 +0200
> From: Nicolas VIGNERON <vigneron.nicolas(a)gmail.com>
> To: Discussion list for the Wikidata project
> <wikidata(a)lists.wikimedia.org>
> Subject: Re: [Wikidata] SPARQL to retrieve a list of open source
> mobile apps
> Message-ID:
> <CANTrCmg7si9EwObJNX5momWzsxburkWbAPfxOFnHPh2dFWioVg@mail.
> gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi Sebastian,
>
> There was a rank on https://www.wikidata.org/wiki/Q14565723#P31 third
> value. By default, SPARQL query only give the best ranked values. It is
> useful for series of values, like for population to give only the more cent
> one by default.
> Here I see no reason why the rank was used, I removed it. Now there is 4
> results, including K9-Mail.
>
> That said, maybe a better way to request would be with P275 (license).
>
> Cheers, ~nicolas
>
> 2018-06-04 13:50 GMT+02:00 Sebastian Kürten <sebastian.kuerten@fu-berlin.
> de>
> :
>
> > Hello,
> >
> > I'm trying to retrieve a list of open source mobile applications using
> > the Wikidata Query Service. After identifying the item for K9-Mail
> > (Q14565723), I can see that it has "instance of" (P31) set to both
> > "free software" (Q341) and "mobile app" (Q620615). I hence derived the
> > following SPARQL query, to retrieve similar items:
> >
> > SELECT ?software ?softwareLabel
> > WHERE
> > {
> > ?software wdt:P31 wd:Q341, wd:Q620615.
> > SERVICE wikibase:label { bd:serviceParam wikibase:language
> > "[AUTO_LANGUAGE]". }
> > }
> >
> > It returns three results, but to my suprise, it does not return the
> > item for K9-Mail. Given that the query is such a simple one, I'm
> > wondering what I am doing wrong here? Or is something else possibly not
> > working correctly?
> >
> > Thanks for your help,
> > Sebastian
> >
> > _______________________________________________
> > Wikidata mailing list
> > Wikidata(a)lists.wikimedia.org
> > https://lists.wikimedia.org/mailman/listinfo/wikidata
> >
>
Hello,
I'm trying to retrieve a list of open source mobile applications using
the Wikidata Query Service. After identifying the item for K9-Mail
(Q14565723), I can see that it has "instance of" (P31) set to both
"free software" (Q341) and "mobile app" (Q620615). I hence derived the
following SPARQL query, to retrieve similar items:
SELECT ?software ?softwareLabel
WHERE
{
?software wdt:P31 wd:Q341, wd:Q620615.
SERVICE wikibase:label { bd:serviceParam wikibase:language
"[AUTO_LANGUAGE]". }
}
It returns three results, but to my suprise, it does not return the
item for K9-Mail. Given that the query is such a simple one, I'm
wondering what I am doing wrong here? Or is something else possibly not
working correctly?
Thanks for your help,
Sebastian
Hello everyone,
I am trying to count how often every constraint type
<https://www.wikidata.org/wiki/Help:Property_constraints_portal#Constraint_t…>
is used in wikidata. My first question:
What exactly does this query
<https://query.wikidata.org/#%23%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FH…>
count? If I understand it it counts for each constraint to how many
properties it is applicable. According to the help page it is supposed
to list the popular constraints. Do the authors of the query simply have
another definition of popular constraints than I?
Which leads to my second question: How would I count the use of
constraint types? What I mean by this is: How many statements exist that
are subject to a constraint of type X?
Thanks in advance,
Adrian