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@lists.wikimedia.org wrote:

Send Wikidata mailing list submissions to wikidata@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@lists.wikimedia.org

You can reach the person managing the list at wikidata-owner@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@fu-berlin.de To: wikidata@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@gmail.com To: Discussion list for the Wikidata project wikidata@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata