Questions tagged [wikidata]
Wikidata is a project of the Wikimedia foundation related to open data
117
questions
1
vote
1answer
46 views
Wikidata reconciliation with OpenRefine—get only those subjects with English as the language flag
Leptospermum scoparium (Q1520028) has 8 common name (P1843) entries.
I have data in OpenRefine reconciled to this object:
How can I get only those P1843 entries that are in English? The ...
0
votes
0answers
5 views
Sparql Qualifiers
i am trying to extract some information from wikidata. I want to show the current version and its corresponding operating system and publishing date for Applications (for example microsoft teams).
My ...
0
votes
1answer
16 views
How to get person name and other attributes from Wikidata Sparql (resolving entities)?
I have this Node.js sparql fetcher from Wikidata:
next()
async function next(offset = 0) {
const sparql = `
SELECT ?person ?pic ?givenName ?familyName ?placeOfBirth
WHERE {
?person wdt:P31 ...
0
votes
1answer
41 views
Wikimedia: Delta-Dumps or Timestamp of Last Change
I am looking for a list of all the entries of https://de.wiktionary.org (German Wiktionary, but I think this works for all Wikimedia the same way) that have had any changes since the last dump. Is ...
1
vote
1answer
28 views
What is the best way to create private wikidata items
I am looking for a way to create new private wikidata items to be integrated with the existing public wikidata.
Example:
Fluffy (Qxxxx) is a (P31) red (Q3142) rabbit (Q9394) stuffed toy (Q682582) .
...
1
vote
0answers
24 views
Explanation for behaviour of FILTER in WDQS
I try to write a simple SPARQL query using WDQS to show some information about a city. My first attempt was to filter using a check for equality, like:
SELECT ?city ?cityLabel
WHERE
{
?city wdt:P31/...
1
vote
1answer
44 views
SPARQL query to find invalid date in Wikidata
The following wikidata query lists the teams Cristiano Ronaldo played for including start and end dates.
SELECT ?playerLabel ?teamLabel ?start ?end WHERE {
VALUES ?player {
wd:Q11571
}
?...
1
vote
0answers
45 views
Is it possible to query Wikidata to get a list of things by item index?
Say, for example, that I wanted to know what the first 100 items are on WikiData (which I do,) without searching in WikiData Q1, Q2, Q3 and so on. Is there a way to write a SPARQL query to find all ...
1
vote
1answer
54 views
Dataset for plant identification
I'm looking for a plant identification dataset (to train a plant identification system) that is free or not too expensive to use and has plant images, specifically garden plants. Just wondering if ...
1
vote
0answers
32 views
DOID , SYMP Ontology Sparql Queries
I need to extract the list of diseases, categories, bodyparts and symptoms.
I've found several ontologies for that datasets.
Disease ontology, symptom ontology, Bioportal and Wikipedia. But I don't ...
0
votes
0answers
25 views
How to retrieve infos about creators with sparql in wikidata
I'm trying to retrieve infos about birth and death corresponding to paintors with this query, however I have an empty result if I uncomment birth and death infos.
# added before 2016-10
# Recherche de ...
1
vote
0answers
34 views
How can I override this «Query is malformed: Bad aggregate» error message?
I'm working with a Wikidata query:
SELECT DISTINCT ?protected_area ?protected_areaLabel ?coordinate_location ?territorialEntity ?territorialEntityLabel (SAMPLE(?instance_of) AS ?instance_of) ?...
1
vote
0answers
29 views
SPARQL to get Wikidata items that have no P18 image but have a Commons image depicting them?
Many Commons images depict Wikidata concepts.
How to find these concepts, in particular those that do not have an image (P18) property?
The request should output the URIs of both the Wikidata item ...
1
vote
0answers
28 views
Whole word entity search on Wikidata
Wikidata wbsearchentities service seems perform prefix-based matching, e.g. searching for novel matches as expected:
novel : narrative text, normally of a substantial length and in the form of prose ...
4
votes
0answers
170 views
Torrent for Wikidata dump
I'm looking for Wikipedia (enwiki-latest-pages-articles-multistream.xml.bz2) and a Wikidata (latest-all.json.bz2 ) dumps. The files are quite large (the latter has ~47GB) and my internet connection ...
1
vote
1answer
57 views
Filtering Wikidata Search
Wikidata today is not only an ontology but also a catalog of publications: scientific articles, formal documents (law), etc. are registered, millions of Wikidata-items. So, when using Wikidata's ...
2
votes
0answers
17 views
Airline Distribution system Data
Appreciate it if anyone can suggest an online data source to capture the below information.
Airline | Country | number of Fleet | Number of Destinations | Airline PSS (Passenger Service System)
1
vote
1answer
52 views
How do I extract certain articles from Arabic Wiki Dumps?
I need to collect all articles that are about countries and continents in Arabic from Wikipedia. I was wondering how do I find these articles if I downloaded the latest wiki dump?
New to the field. ...
2
votes
1answer
52 views
Does Wikidata offer inferencing/reasoning?
I would like to use RDFS level inferencing in some queries posed in the Wikidata Query Service which uses SPARQL. Does it support inferencing/reasoning? If so, in what kind? For example, is it Forward ...
1
vote
1answer
41 views
Looking for foot pressure database collected from pressure sensors
I am working on a project where I need foot pressure data that a person put on his foot while walking, running, or doing any other practice. I searched a lot in the search engines and I couldn't find ...
0
votes
1answer
62 views
Query wikipedia links
I'm using the following query to receive label and description of all Wikidata-entries with geo-location in a geo-bounding box:
SELECT DISTINCT ?place ?placeLabel ?placeDescription ?location WHERE
{
...
1
vote
2answers
46 views
Find all Wikidata items whose image (P18) URL contains a certain word
I am trying to find all Wikidata items whose P18 property is an URL that has the word "Montage" anywhere in its filename.
Example:
I managed to find items by their complete P18 filename:
SELECT ?...
1
vote
1answer
311 views
SPARQL get all the data before it reaches timeout
I am trying to get all the city names of all countries in the world using this below query. Whenever I execute this below query it returns this message "Query timeout limit reached".
Is there any ...
4
votes
0answers
41 views
Find most-depicted Wikidata items that have no image
Wikimedia Commons has a new feature where a picture can have metadata saying it depicts a given Wikidata item.
For instance, https://commons.wikimedia.org/wiki/File:Grandpark_Plaza.jpg depicts https:/...
1
vote
0answers
28 views
How come there are missing entities in this SPARQL query?
I was interested in listing all books,
so I wrote:
SELECT ?book ?url WHERE {
?book wdt:P31 wd:Q571 .
OPTIONAL {
?url schema:about ?book .
?url schema:inLanguage "en" .
?url schema:...
1
vote
1answer
157 views
How to find the wikidata ID of a DBpedia concept?
I have a set of DBpedia concepts and would like to get the corresponding wikidata IDs of them.
For example, consider word2vec. The wikidata ID of word2vec is wd:Q22673982.
Currently, I have the ...
2
votes
0answers
53 views
SPARQL - Filter wikidata identifiers
Query below gives me all programming languages entities, with their statements.
Problem is that I don't need identifiers now, but these IDs might become necessary. I was just gonna model database ...
2
votes
0answers
61 views
Wikidata SPARQL - get company entities and the location of their headquarters
I'm having trouble extracting location attributes of company HQ's.
My query: finds all companies or sub-classes, and returns some basic properties such as ISIN and URL, and the Headquarter location. ...
2
votes
0answers
32 views
SPARQL query to get capacity of event venues from Wikidata
I am trying to query Wikidata to find out the capacities of all event venues in specific geographic regions (US urban centers). They have this service for querying: Wikidata Query Service
The answer ...
1
vote
0answers
19 views
How to distinguish between human and animal bones in Wikidata?
The two topics
https://www.wikidata.org/wiki/Q16343 (Clavicle)
https://www.wikidata.org/wiki/Q835986 (Baculum, Penis bone)
are both instances of Q265868 (Bone). However, the clavicle is a human (...
2
votes
0answers
61 views
How to use wikidata property paths?
Given a term/concept, I want to decide if it belongs to computer science. For that, I am checking if the concept has a property path to computer science node. In other words, I am checking whether ...
1
vote
0answers
39 views
Wikidata SPARQL How to speed up this query?
I have come to this query, which retrieves wikipedia and wikidata info from a wikipedia title:
SELECT ?wikipediaId ?wikipediaTitle ?wikidataId ?desc ?imageUrl
(GROUP_CONCAT(?instanceOfS; SEPARATOR=";"...
1
vote
0answers
45 views
Wikidata Sparql Getting properties from a Wikipedia generator list
I am trying to get the properties that the linked pages from a wikipedia page have.
SELECT ?item ?wikipediaTitle ?target WHERE {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:endpoint "en....
1
vote
1answer
51 views
Wikidata Query: How to retrieve the normal (non-verbose) JSON?
We can download the results of a Wikidata Query as "JSON file" or "JSON file (verbose)"
Example link of random query: http://w.wiki/WQ.
I am developing a javascript software which retrieves some ...
1
vote
1answer
35 views
Wikidata SPARQL get current VALUES index
I have the current SPARQL code:
SELECT ?currentQid ?propQid ?targetQid WHERE
{
VALUES ?current {wd:Q5 wd:Q6 wd:Q7 wd:Q8 wd:Q9}
VALUES ?prop {wdt:P31 wdt:P279 wdt:P361}
BIND (STRAFTER(STR(?...
1
vote
0answers
20 views
Does Wikidata contain the data from the Wikipedia {{distinguish}} template?
Wikipedia uses the {{Distinguish}} template for pages whose subject is easily confused with another subject. For example, the two Congo countries are frequently confused with each other, so their ...
2
votes
1answer
132 views
Wikidata SPARQL with optional qualifiers
I am trying to adapt the Mona Lisa exercise in the Wikidata SPARQL tutorial so it will show all the materials used and where they apply.
If I simply do:
SELECT ?painting ?paintingLabel ?material ?...
1
vote
1answer
57 views
Expand Wikidata SPARQL query to self-join
I have this query to get the population of cities and the country they belong to:
SELECT ?city (?population as ?city_pop) ?country ?countryLabel ?continent ?continentLabel ?cityLabel
WHERE {
...
1
vote
1answer
544 views
How to output only English labels in SPARQL query?
I don't understand why this SPARQL queries produce duplicates:
SELECT DISTINCT ?WikidataItem ?itemLabel
WHERE {
?WikidataItem rdfs:label ?itemLabel.
?WikidataItem ?label "Mozilla Firefox"@en. ...
0
votes
1answer
48 views
Wikidata - Filter or Detect or Get incomplete date
I've the following query
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?item ?itemLabel ?dod ?dob WHERE {
?item wdt:P570 ?dod.
?item wdt:P31 wd:Q5.
SERVICE wikibase:label { bd:...
1
vote
1answer
63 views
What are Outlink categories of Wikipedia
I am wondering if it is possible to view outlink categories of a given article in Wikipedia? For example, consider the Wikipedia article about 'Data Mining'. What are the outlink categories of "Data ...
2
votes
1answer
107 views
Limiting a SPARQL Query to Lastest Point in Time
I'm trying to get information on Prefectures in Japan out of Wikidata. I succeeded to read the population statement, however there are occasionally several values with different point in time fields.
...
2
votes
2answers
115 views
How to get specific wikipedia data?
I only want to use the link structure and articles’ content of Wikipedia. Therefore, I want to downlaod the dump that contains only the following details.
articles content
link structure (i.e. re-...
1
vote
1answer
193 views
Get list of all wikidata properties used to link to an item
The first part of my question is, is there a SPARQL equivalent of the "What links here" link? E.g. as described at https://opendata.stackexchange.com/a/5271/20321
I tried:
WHERE { ?item wdt:?...
5
votes
1answer
84 views
Wikidata: How to represent British Hong Kong's under Japanese occupation?
Between 1941 and 1945, British Hong Kong (then a colony) was occupied by the Japanese, see this Wikipedia article.
However on British Hong Kong's Wikidata page, there's no mention of the Japaneses ...
1
vote
1answer
39 views
Wikidata on all Trump's executive orders
I'd like a wikidata query that returns all executive orders signed by President Trump.
This query gets all executive orders:
https://query.wikidata.org/#SELECT%20%3Forder%20%3ForderLabel%20WHERE%20%...
3
votes
1answer
227 views
Numerically order SPARQL results that are external identifiers but actually all numbers
I wrote this query to list Wikidata items that have an RFC identifier:
SELECT ?rfcId ?itemLabel ?classLabel ?item
WHERE
{
?item wdt:P31 ?class.
?item wdt:P892 ?rfcId.
SERVICE wikibase:label { ...
1
vote
0answers
28 views
Filter wikidata results with 'around' service
Is it possible to use the "around" service as a filter, for example to search for a place name in a country and limit results to those within a given distance of a known point.
For example, limit ...
2
votes
1answer
85 views
How can I query Wikidata for a label and optional image without further constraints?
I made a derivation of the cats with images example where I query for a specific cat, in particular its label and a possible image (in the web interface):
SELECT ?item ?itemLabel ?pic
WHERE {
...
3
votes
1answer
96 views
Why does Wikidata's query interface return no results for entities with an id of Q10000001 or higher?
I have this SPARQL query to return an item's label and the url of a Wikipedia article:
PREFIX schema: <http://schema.org/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?article ?...