---
title: Wikidata Property Query
tags: wikidata, Query, SPARQL
---
* 職業
* [Query](https://w.wiki/aDX)
```sql=
SELECT DISTINCT ?item ?itemLabel ?職業 ?職業Label
WHERE
{
VALUES ?職業 {wd:Q12737077 wd:Q28640 wd:Q192581}
?item wdt:P31 ?職業.
SERVICE wikibase:label { bd:serviceParam wikibase:language "zh-tw, zh, zh-hant, en". }
}
```
* 台灣行政區
* [Query](https://w.wiki/aMb)
```sql=
SELECT DISTINCT ?city ?cityLabel ?locality ?localityLabel
WHERE
{
?city wdt:P31/(wdt:P279*) wd:Q50218;
OPTIONAL {?city wdt:P131 ?locality.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "zh-tw, zh, zh-hant, en". }
}
```
* 中國行政區
* 不完整，好像沒有抓到縣級以上
* [Query](https://w.wiki/aMc)
```sql=
SELECT DISTINCT ?city ?cityLabel
WHERE
{
# VALUES ?country {wd:515 wd:Q50231}
?city wdt:P31/wdt:P279* wd:Q50231;
OPTIONAL {?city wdt:P131 wd:Q148}
# OPTIONAL {?city wdt:P131 ?locality}
SERVICE wikibase:label { bd:serviceParam wikibase:language "zh-tw, zh, zh-hant, en". }
}
LIMIT 100000
```
* 澎湖廟宇
* [Query](https://w.wiki/aMf)
```sql=
SELECT DISTINCT ?item ?itemLabel ?localtity ?localtityLabel (GROUP_CONCAT(DISTINCT(?geo); separator = ", ") AS ?geo_list)
WHERE{
VALUES ?type {wd:Q29043583 wd:Q44539}
?item wdt:P31/(wdt:P279*) ?type;
wdt:P131/(wdt:P131*) wd:Q198525.
OPTIONAL {?item wdt:P131 ?localtity}
OPTIONAL {?item wdt:P625 ?geo}
SERVICE wikibase:label { bd:serviceParam wikibase:language "zh-tw, zh, zh-hant, en". }
}
GROUP BY ?item ?itemLabel ?localtity ?localtityLabel
```
* 中華民國所有宗教建築&宗教場所
* [Query](https://w.wiki/aDU)
```sql=
SELECT DISTINCT ?temple ?templeLabel ?countryLabel ?cityLabel ?typeLabel
WHERE
{
VALUES ?type {wd:Q24398318 wd:Q1370598}
?temple wdt:P31/(wdt:P279*) ?type;
wdt:P17 wd:Q865.
OPTIONAL{?temple wdt:P17 ?country.}
OPTIONAL{?temple wdt:P131 ?city.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "zh-tw, zh, zh-hant, en". }
}
```
* [Query](https://w.wiki/aSg)，資料詳細＆單一化
```sql=
SELECT ?item ?itemLabel ?itemDescription (GROUP_CONCAT(DISTINCT ?countryLabel; SEPARATOR = ", ") AS ?countryLabel_list) (GROUP_CONCAT(DISTINCT ?cityLabel; SEPARATOR = ", ") AS ?cityLabel_list) (GROUP_CONCAT(DISTINCT ?altLabel; SEPARATOR = ", ") AS ?altLabel_list) (GROUP_CONCAT(DISTINCT ?typeLabel; SEPARATOR = ", ") AS ?typeLabel_list)
WHERE {
VALUES ?type {wd:Q24398318 wd:Q1370598}
?item wdt:P31/(wdt:P279*) ?type;
wdt:P17 wd:Q865.
OPTIONAL { ?item wdt:P17 ?country. }
OPTIONAL { ?item wdt:P131 ?city. }
OPTIONAL { ?item skos:altLabel ?altLabel. FILTER(LANG(?altLabel) IN ("zh-tw", "zh", "zh-hant", "en")) }
SERVICE wikibase:label {
bd:serviceParam wikibase:language "zh-tw, zh, zh-hant, en".
?country rdfs:label ?countryLabel.
?city rdfs:label ?cityLabel.
?type rdfs:label ?typeLabel.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "zh-tw, zh, zh-hant, en". }
}
GROUP BY ?item ?itemLabel ?itemDescription ?altLabel_list
```
* [Query](https://w.wiki/aSs)，資料詳例＆單一化＆**列出維基百科連結**
```sql=
SELECT ?item ?itemLabel ?itemDescription ?sitelink (GROUP_CONCAT(DISTINCT ?countryLabel; SEPARATOR = ", ") AS ?countryLabel_list) (GROUP_CONCAT(DISTINCT ?cityLabel; SEPARATOR = ", ") AS ?cityLabel_list) (GROUP_CONCAT(DISTINCT ?altLabel; SEPARATOR = ", ") AS ?altLabel_list) (GROUP_CONCAT(DISTINCT ?typeLabel; SEPARATOR = ", ") AS ?typeLabel_list)
WHERE {
VALUES ?type {wd:Q24398318 wd:Q1370598}
?item wdt:P31/(wdt:P279*) ?type;
wdt:P17 wd:Q865.
OPTIONAL { ?item wdt:P17 ?country. }
OPTIONAL { ?item wdt:P131 ?city. }
OPTIONAL { ?item skos:altLabel ?altLabel. FILTER(LANG(?altLabel) IN ("zh-tw", "zh", "zh-hant", "en")) }
OPTIONAL {
?sitelink schema:about ?item;
schema:isPartOf <https://zh.wikipedia.org/>.
}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "zh-tw, zh, zh-hant, en".
?country rdfs:label ?countryLabel.
?city rdfs:label ?cityLabel.
?type rdfs:label ?typeLabel.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "zh-tw, zh, zh-hant, en". }
}
GROUP BY ?item ?itemLabel ?itemDescription ?altLabel_list ?wikipedia ?sitelink
```
* 墳場的限定詞有寫墳場的 item
* [Query](https://w.wiki/aMg)
```sql=
SELECT ?item ?itemLabel ?墓地 ?墓地Label ?墳場 ?墳場Label WHERE {
?item wdt:P31 wd:Q5;
p:P119 [ ps:P119 ?墓地; pq:P119 ?墳場].
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
LIMIT 100
```
* 台灣的所有 GLAM
* [Query](https://w.wiki/aMj)
```sql=
SELECT DISTINCT ?item ?itemLabel (GROUP_CONCAT(DISTINCT(?address); separator = "；") AS ?address_list) (GROUP_CONCAT(DISTINCT(?geo); separator = ", ") AS ?geo_list)
WHERE {
?item (wdt:P31/(wdt:P279*)) wd:Q1030034;
wdt:P17 wd:Q865.
OPTIONAL { ?item wdt:P6375 ?address. }
OPTIONAL { ?item wdt:P625 ?geo. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],zh-tw". }
}
GROUP BY ?item ?itemLabel
```
* 所有 property 的 ID、Label、描述、亦稱為
* [Query](https://w.wiki/aMk)
```sql=
SELECT ?property ?propertyLabel ?propertyDescription (GROUP_CONCAT(DISTINCT(?altLabel); separator = ", ") AS ?altLabel_list) WHERE {
?property a wikibase:Property.
OPTIONAL { ?property skos:altLabel ?altLabel. FILTER (lang(?altLabel) in ("zh-tw", "zh", "zh-hant", "en")) }
SERVICE wikibase:label { bd:serviceParam wikibase:language "zh-tw,zh" .}
}
GROUP BY ?property ?propertyLabel ?propertyDescription
LIMIT 10000
```
* 中華民國學校
* [Query](https://w.wiki/aUA)
```sql=
SELECT DISTINCT ?school ?schoolLabel ?locatity ?locatityLabel
WHERE {
?school wdt:P31/(wdt:P279*) wd:Q3914;
wdt:P17 wd:Q865.
OPTIONAL { ?school wdt:P131 ?locatity }
SERVICE wikibase:label { bd:serviceParam wikibase:language "zh-tw, zh, zh-hant, en". }
}
```
---
* 徐瑛 [`Q98456728`](https://www.wikidata.org/wiki/Q98456728)
* 徐瑛補償金申請案 [`Q98456656`](https://www.wikidata.org/wiki/Q98456656)
Sign in with Wallet
Connect another wallet