User talk:Rahmatdenas

From Wikidata
Jump to navigation Jump to search

Masjid di Indonesia

[edit]
#added 2017-08
#defaultView:Map
SELECT ?item ?itemLabel ?koordinat_tempat ?sejak ?gambar WHERE {
  ?item wdt:P31 wd:Q32815.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?item wdt:P17 wd:Q252.
  OPTIONAL { ?item wdt:P625 ?koordinat_tempat. }
  OPTIONAL{?item wdt:P571 ?sejak .}
  OPTIONAL{?item wdt:P18 ?gambar.}
  FILTER((?sejak >= "1900-01-01T00:00:00Z"^^xsd:dateTime) && (?sejak <= "1990-12-31T00:00:00Z"^^xsd:dateTime))
}

Jangan tampilkan

[edit]
#added before 2016-10
SELECT DISTINCT ?country ?countryLabel ?capital ?capitalLabel
WHERE
{
  ?country wdt:P31 wd:Q3624078 .
  #not a former country
  FILTER NOT EXISTS {?country wdt:P31 wd:Q3024240}
  #and no an ancient civilisation (needed to exclude ancient Egypt)
  FILTER NOT EXISTS {?country wdt:P31 wd:Q28171280}
  OPTIONAL { ?country wdt:P36 ?capital } .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?countryLabel

Tampilkan bangunan di sekitar kecuali masjid

[edit]
#added before 2016-10
 SELECT ?place ?placeLabel ?location ?instanceLabel
WHERE
{
  wd:Q7253 wdt:P625 ?loc .
  SERVICE wikibase:around {
      ?place wdt:P625 ?location .
      bd:serviceParam wikibase:center ?loc .
      bd:serviceParam wikibase:radius "1" .
  }
  OPTIONAL {  	?place wdt:P31 ?instance  }
    FILTER NOT EXISTS {?place wdt:P31 wd:Q32815}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
  BIND(geof:distance(?loc, ?location) as ?dist)
} ORDER BY ?dist

Tampilkan bangunan di sekitar hanya masjid dan museum

[edit]
#added before 2016-10
 SELECT ?place ?placeLabel ?location ?instanceLabel
WHERE
{
  wd:Q7253 wdt:P625 ?loc .
  SERVICE wikibase:around {
      ?place wdt:P625 ?location .
      bd:serviceParam wikibase:center ?loc .
      bd:serviceParam wikibase:radius "1" .
  }
  OPTIONAL {  	?place wdt:P31 ?instance  }
    FILTER (?instance = wd:Q32815 || ?instance = wd:Q33506)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
  BIND(geof:distance(?loc, ?location) as ?dist)
} ORDER BY ?dist

Peta

[edit]
{{Maplink|frame=yes
|type=shape|id=Q2772|title=Shape|description=Description of shape
}}

Masjid di Sumatra Barat

[edit]
#added before 2016-10
#defaultView:Map

 SELECT ?place ?placeLabel ?location ?instanceLabel
WHERE
{
  wd:Q7253 wdt:P625 ?loc .
  SERVICE wikibase:around {
      ?place wdt:P625 ?location .
      bd:serviceParam wikibase:center ?loc .
      bd:serviceParam wikibase:radius "150" .
  }
  OPTIONAL {  	?place wdt:P31 ?instance  }
    FILTER (?instance = wd:Q32815)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
  BIND(geof:distance(?loc, ?location) as ?dist)
} ORDER BY ?dist
Dengan informasi
#added before 2016-10
#defaultView:Map
SELECT ?place ?placeLabel ?location ?instanceLabel ?article ?gambar WHERE {
  wd:Q7253 wdt:P625 ?loc.
  SERVICE wikibase:around {
    ?place wdt:P625 ?location.
    bd:serviceParam wikibase:center ?loc;
      wikibase:radius "150".
  }
  OPTIONAL { ?place wdt:P18 ?gambar. }
  OPTIONAL {
    ?article schema:about ?place;
      schema:isPartOf <https://id.wikipedia.org/>.
  }
  OPTIONAL { ?place wdt:P31 ?instance. }
  FILTER(?instance = wd:Q32815)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id". }
  BIND(geof:distance(?loc, ?location) AS ?dist)
}
ORDER BY (?dist)
Hanya yang punya pernyataan tahun
SELECT DISTINCT  ?place ?placeLabel ?location ?image ?year ?letak ?article WHERE {
  BIND(wd:Q32815 AS ?masjid)
      	?place wdt:P31 ?masjid.
      ?place p:P571 ?pernyataan .   
       OPTIONAL { ?place wdt:P18 ?image. }
       OPTIONAL { ?place wdt:P571 ?sejak. }
       OPTIONAL { ?place wdt:P131 ?letak. }
   OPTIONAL {  ?article schema:about ?place . 
    ?article schema:isPartOf <https://id.wikipedia.org/>.  }
  	BIND(YEAR(?sejak) as ?year)
SERVICE wikibase:box {
?place wdt:P625 ?location.
bd:serviceParam wikibase:cornerWest "Point(98.36 0.52)"^^geo:wktLiteral .
bd:serviceParam wikibase:cornerEast "Point(101.53 -2)"^^geo:wktLiteral .
}

SERVICE wikibase:label { bd:serviceParam wikibase:language "id". }
}
ORDER BY DESC(?sejak)

Hanya masjid di Sumbar tanpa wikibase:box

[edit]
SELECT DISTINCT ?place ?placeLabel ?location ?image ?year ?letakLabel ?article WHERE {
    BIND(wd:Q32815 AS ?masjid)
      BIND(wd:Q2772 AS ?sumbar)
       ?place wdt:P31 ?masjid.
  ?place wdt:P131/wdt:P131+ ?sumbar.
       OPTIONAL { ?place wdt:P18 ?image. }
       OPTIONAL { ?place wdt:P571 ?sejak. }
       OPTIONAL { ?place wdt:P131 ?letak. } 
       OPTIONAL { ?place wdt:P625 ?location. } 
   OPTIONAL {  ?article schema:about ?place . 
    ?article schema:isPartOf <https://id.wikipedia.org/>.  }
  	BIND(YEAR(?sejak) as ?year)

SERVICE wikibase:label { bd:serviceParam wikibase:language "id". }
}
ORDER BY DESC(?sejak)

Menggunakan filter

[edit]
SELECT DISTINCT ?place ?placeLabel ?location ?image ?year ?letakLabel ?article WHERE {
  ?place wdt:P131/wdt:P131+ ?sumbar.
      BIND(wd:Q2772 AS ?sumbar)  
       OPTIONAL { ?place wdt:P18 ?image. }
       OPTIONAL { ?place wdt:P571 ?sejak. }
       OPTIONAL { ?place wdt:P131 ?letak. } 
       OPTIONAL { ?place wdt:P625 ?location. }
      OPTIONAL {  	?place wdt:P31 ?adalah  }
      FILTER (?adalah = wd:Q32815 || ?adalah = wd:Q15051389)
   OPTIONAL {  ?article schema:about ?place . 
    ?article schema:isPartOf <https://id.wikipedia.org/>.  }
  	BIND(YEAR(?sejak) as ?year)

SERVICE wikibase:label { bd:serviceParam wikibase:language "id". }
}
ORDER BY DESC(?sejak)

Galeri tempat di sekitar

[edit]
#added before 2016-10
#defaultView:ImageGrid
SELECT ?place ?placeLabel ?location ?instanceLabel ?gambar WHERE {
  wd:Q7253 wdt:P625 ?loc.
  SERVICE wikibase:around {
    ?place wdt:P625 ?location.
    bd:serviceParam wikibase:center ?loc;
      wikibase:radius "4".
  }
  OPTIONAL { ?place wdt:P31 ?instance. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  BIND(geof:distance(?loc, ?location) AS ?dist)
  OPTIONAL { ?place wdt:P18 ?gambar. }
}
ORDER BY (?dist)

Film Indonesia

[edit]
#defaultView:BarChart
SELECT ?year (COUNT(?year) AS ?count) WHERE {
  ?painting wdt:P31 wd:Q11424;
    wdt:P495 wd:Q252;
    wdt:P577 ?inception.
  BIND(STR(YEAR(?inception)) AS ?year)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id". }
}
GROUP BY ?year ?count
ORDER BY (?year)

Genre film 5 tahun terakhir

[edit]
#defaultView:BarChart
SELECT (SAMPLE(?year) AS ?year) (COUNT(?_country) AS ?count) (SAMPLE(?_countryLabel) AS ?_countryLabel) WHERE {
  ?object wdt:P31 wd:Q11424.
  BIND(STR(YEAR(?_inception)) AS ?year)
  ?object wdt:P577 ?_inception;
    wdt:P136 ?_country.
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
    ?_country rdfs:label ?_countryLabel.
  }
    FILTER((?_inception >= "2015-01-01T00:00:00Z"^^xsd:dateTime) && (?_inception <= "2020-12-31T00:00:00Z"^^xsd:dateTime))

}
GROUP BY ?year ?_country
ORDER BY (?_countryLabel)

Film Indonesia 10 tahun terakhir dan genre

[edit]
#defaultView:BarChart
SELECT (SAMPLE(?year) AS ?year) (COUNT(?_country) AS ?count) (SAMPLE(?_countryLabel) AS ?_countryLabel) WHERE {
  ?object wdt:P31 wd:Q11424.
    ?object wdt:P364 wd:Q9240.
  BIND(STR(YEAR(?_inception)) AS ?year)
  ?object wdt:P577 ?_inception;
    wdt:P136 ?_country.
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id".
    ?_country rdfs:label ?_countryLabel.
  }
    FILTER((?_inception >= "2010-01-01T00:00:00Z"^^xsd:dateTime) && (?_inception <= "2020-12-31T00:00:00Z"^^xsd:dateTime))

}
GROUP BY ?year ?_country
ORDER BY (?_countryLabel)

Sutradara paling produktif

[edit]
#defaultView:BarChart
SELECT (SAMPLE(?year) AS ?year) (COUNT(?_country) AS ?count) (SAMPLE(?_countryLabel) AS ?_countryLabel) WHERE {
  ?object wdt:P31 wd:Q11424.
    ?object wdt:P364 wd:Q9240.
  BIND(STR(YEAR(?_inception)) AS ?year)
  ?object wdt:P577 ?_inception;
    wdt:P57 ?_country.
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id".
    ?_country rdfs:label ?_countryLabel.
  }
    FILTER((?_inception >= "2010-01-01T00:00:00Z"^^xsd:dateTime) && (?_inception <= "2020-12-31T00:00:00Z"^^xsd:dateTime))

}
GROUP BY ?year ?_country
ORDER BY (?_countryLabel)

Daftar gubernur Indonesia

[edit]
#added before 2016-10
SELECT DISTINCT ?country ?countryLabel ?capital ?capitalLabel WHERE {
  ?country wdt:P31 wd:Q5098;
    wdt:P17 wd:Q252.
  FILTER(NOT EXISTS { ?country wdt:P31 wd:Q3024240. })
  FILTER(NOT EXISTS { ?country wdt:P31 wd:Q28171280. })
  OPTIONAL { ?country wdt:P6 ?capital. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id". }
}
ORDER BY (?countryLabel)

Timeline masjid

[edit]
#defaultView:Timeline
SELECT ?item ?itemLabel ?launchdate (SAMPLE(?image) AS ?image)
WHERE
{
	?item wdt:P31 wd:Q32815 .
	?item wdt:P17 wd:Q252 .
    ?item wdt:P571 ?launchdate .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "id" }
    OPTIONAL { ?item wdt:P18 ?image }
}
GROUP BY ?item ?itemLabel ?launchdate

Wikidata Box

[edit]
#defaultView:Map
SELECT ?place ?placeLabel ?location WHERE {
      SERVICE wikibase:box {
      ?place wdt:P625 ?location.
    bd:serviceParam wikibase:cornerWest "Point(99.078898 0.828219)"^^geo:wktLiteral .
    bd:serviceParam wikibase:cornerEast "Point(101.811369 -2.368067)"^^geo:wktLiteral .
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Masjid menurut abad

[edit]
# Metro stations in Athens by date
#defaultView:Map{"layer":"?dateBin"}
SELECT ?item ?itemLabel ?coord ?image ?minDate ?negara ?dateBin WHERE {
  BIND(
    IF((YEAR(?minDate)) < 1701, "Abad ke-17 dan sebelum",
       IF((YEAR(?minDate)) < 1801, "Abad ke-18",
          IF((YEAR(?minDate)) < 1901, "Abad ke-19",
             IF((YEAR(?minDate)) < 1971, "Abad ke-20 (>50 tahun)", "Abad ke-20 (<50 tahun)")))) 
   AS ?dateBin)
  {
    SELECT ?item (MIN(?date) AS ?minDate) ?coord ?image WHERE {
      	?item wdt:P31 wd:Q32815 .
      	?item wdt:P17 wd:Q252 .
      ?item wdt:P625 ?coord.
      OPTIONAL { ?item wdt:P18 ?image. }
      OPTIONAL { ?item wdt:P1619 ?d1. }
      OPTIONAL { ?item wdt:P571 ?d2. }
      BIND(IF(BOUND(?d1), ?d1, ?d2) AS ?date)
    }
    
    GROUP BY ?item ?coord ?image
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?minDate

Atau samain OPTIONAL { ?item wdt:P571 ?d2. } jadi d1

Kota menurut abad

[edit]
# Metro stations in Athens by date
#defaultView:Map{"layer":"?dateBin"}
SELECT ?item ?itemLabel ?coord ?image ?minDate ?negara ?dateBin WHERE {
  BIND(
    IF((YEAR(?minDate)) < 1700, "Abad ke-17 dan sebelum",
       IF((YEAR(?minDate)) < 1800, "Abad ke-18",
          IF((YEAR(?minDate)) < 1900, "Abad ke-19",
             IF((YEAR(?minDate)) < 1998, "Abad ke-20 (>50 tahun)", "Sejak reformasi")))) 
   AS ?dateBin)
  {
    SELECT ?item (MIN(?date) AS ?minDate) ?coord ?image WHERE {
      	?item wdt:P31 wd:Q3199141 .
      	?item wdt:P17 wd:Q252 .
      ?item wdt:P625 ?coord.
      OPTIONAL { ?item wdt:P18 ?image. }
      OPTIONAL { ?item wdt:P1619 ?d1. }
      OPTIONAL { ?item wdt:P571 ?d2. }
      BIND(IF(BOUND(?d1), ?d1, ?d2) AS ?date)
    }
    
    GROUP BY ?item ?coord ?image
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?minDate

Masjid berdasarkan range

[edit]
#defaultView:Map
SELECT ?place ?location ?image ?commons WHERE {
       ?place wdt:P31 wd:Q32815 .
       OPTIONAL { ?place wdt:P18 ?image. } 
       OPTIONAL { ?place wdt:P373 ?commons. } 
SERVICE wikibase:box {
?place wdt:P625 ?location.
bd:serviceParam wikibase:cornerWest "Point(99.459008 0.254724)"^^geo:wktLiteral .
bd:serviceParam wikibase:cornerEast "Point(101.633972 -1.691588)"^^geo:wktLiteral .
}

SERVICE wikibase:label { bd:serviceParam wikibase:language "id". }
}

Atau samain OPTIONAL { ?item wdt:P571 ?d2. } jadi d1

Anggota DPR RI perempuan

[edit]
SELECT DISTINCT ?item ?itemLabel ?positionLabel ?start ?end ?partaiLabel ?dapilLabel WHERE
{
  ?item wdt:P31 wd:Q5 ;
          wdt:P21 wd:Q6581072;  #  Who was born in New York City.
        p:P39 ?position_statement .
  ?position_statement ps:P39 ?position ;
                      pq:P580 ?start FILTER (?start >= "2019-10-01T00:00:00Z"^^xsd:dateTime) .
  ?position wdt:P279* wd:Q21328632 .
  OPTIONAL { ?position_statement pq:P582 ?x }
  OPTIONAL { ?position_statement pq:P768 ?dapil }
  OPTIONAL { ?item wdt:P102 ?partai }
  bind(if(bound(?x), ?x, NOW()) as ?end )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id" . }
  
}
ORDER BY DESC(?days) ?itemLabel

Semua anggota DPR RI

[edit]
SELECT DISTINCT ?item ?itemLabel ?genderLabel ?positionLabel ?start ?end ?partaiLabel ?dapilLabel WHERE
{
  ?item wdt:P31 wd:Q5 ;
        p:P39 ?position_statement .
  ?position_statement ps:P39 ?position ;
                      pq:P580 ?start FILTER (?start >= "2019-10-01T00:00:00Z"^^xsd:dateTime) .
  ?position wdt:P279* wd:Q21328632 .
  OPTIONAL { ?position_statement pq:P582 ?x }
  OPTIONAL { ?position_statement pq:P768 ?dapil }
  OPTIONAL { ?item wdt:P102 ?partai }
  OPTIONAL { ?item wdt:P21 ?gender }
  bind(if(bound(?x), ?x, NOW()) as ?end )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id" . }
  
}
ORDER BY DESC(?days) ?itemLabel

Bulan lahir

[edit]
SELECT distinct ?pemeran ?pemeranLabel ?bulanlahir WHERE {
SERVICE wikibase:label { bd:serviceParam wikibase:language "id" .}
?pemeran wdt:P31 wd:Q5.
?pemeran wdt:P106 wd:Q33999.
?pemeran wdt:P27 wd:Q252.
?pemeran wdt:P569 ?tanggallahir
BIND(MONTH(?tanggallahir) AS ?bulanlahir).
}

Nagari di Sijunjung

[edit]
#kucing
SELECT ?item ?itemLabel ?id ?min WHERE {
  ?item wdt:P31 wd:Q882149.
  ?item wdt:P131/wdt:P131+ wd:Q6055.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id". }
     OPTIONAL {  ?id schema:about ?item . 
    ?id schema:isPartOf <https://id.wikipedia.org/>.  }  
     OPTIONAL {  ?min schema:about ?item . 
    ?min schema:isPartOf <https://min.wikipedia.org/>.  }  
}

Nagari lengkap

[edit]
SELECT 
  ?item 
(SAMPLE(?itemLabel) AS ?itemLabel) 
(SAMPLE(?koordinatLabel) AS ?koordinatLabel) 
(SAMPLE(?article) AS ?article) 
(GROUP_CONCAT(DISTINCT ?occupationLabel; SEPARATOR=", ") AS ?occupationLabels)

WHERE {
   ?item wdt:P31 wd:Q882149.
 
  OPTIONAL { ?item wdt:P131+ ?occupation. }
  OPTIONAL { ?item wdt:P625 ?koordinat. }
   OPTIONAL {  ?article schema:about ?item . 
    ?article schema:isPartOf <https://id.wikipedia.org/>.  }
  SERVICE wikibase:label { 
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id". 
    ?item rdfs:label ?itemLabel.
    ?occupation rdfs:label ?occupationLabel.
    ?koordinat rdfs:label ?koordinatLabel.
  }
}
GROUP BY ?item

Nagari lengkap 2

[edit]
SELECT distinct ?nagari ?nagariLabel ?kabupatenkotaLabel ?kecamatanLabel ?article ?koordinat WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id". }
  ?nagari wdt:P31 wd:Q882149.
  ?nagari wdt:P131 ?kecamatan.
  ?kecamatan wdt:P131 ?kabupatenkota.
  ?kabupatenkota wdt:P131 wd:Q2772.
   OPTIONAL {  ?article schema:about ?nagari . 
    ?article schema:isPartOf <https://id.wikipedia.org/>.  }
    OPTIONAL { ?nagari wdt:P625 ?koordinat. }
}

Tokoh

[edit]
SELECT 
  ?item 
(SAMPLE(?itemLabel) AS ?itemLabel) 
(SAMPLE(?lahir) AS ?lahir) 
(SAMPLE(?wafat) AS ?wafat) 
(SAMPLE(?article) AS ?article) 
(GROUP_CONCAT(DISTINCT ?occupationLabel; SEPARATOR=", ") AS ?occupationLabels)

WHERE {
   ?item wdt:P31 wd:Q5;
    wdt:P172 wd:Q1130350.
 
  OPTIONAL { ?item wdt:P106 ?occupation. }
  OPTIONAL { ?item wdt:P569 ?lahir. }
  OPTIONAL { ?item wdt:P570 ?wafat. }
   OPTIONAL {  ?article schema:about ?item . 
    ?article schema:isPartOf <https://id.wikipedia.org/>.  }
  SERVICE wikibase:label { 
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id". 
    ?item rdfs:label ?itemLabel.
    ?occupation rdfs:label ?occupationLabel.
  }
}
GROUP BY ?item
ORDER BY ASC (?itemLabel)

Kab dan kota

[edit]
SELECT ?item ?itemLabel ?instanceLabel
WHERE 
{
    ?item wdt:P131 wd:Q2772.
    OPTIONAL {  	?item wdt:P31 ?instance  }
    FILTER (?instance = wd:Q3191695 || ?instance = wd:Q3199141)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # <span lang="en" dir="ltr" class="mw-content-ltr">Helps get the label in your language, if not, then en language</span>
}

Kantor Camat di Sumbar

[edit]
#kantorcamat
SELECT 
  ?item 
(SAMPLE(?itemLabel) AS ?itemLabel) 
(SAMPLE(?article) AS ?article) 
(SAMPLE(?kantor) AS ?kantor) 
(GROUP_CONCAT(DISTINCT ?occupationLabel; SEPARATOR=", ") AS ?occupationLabels)

WHERE {
  ?item wdt:P31 wd:Q26262476.
  ?item wdt:P131/wdt:P131+ wd:Q2772.
   OPTIONAL { ?item wdt:P625 ?kantor. }
  OPTIONAL { ?item wdt:P131+ ?occupation. }
   OPTIONAL {  ?article schema:about ?item . 
    ?article schema:isPartOf <https://id.wikipedia.org/>.  }
  SERVICE wikibase:label { 
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id". 
    ?item rdfs:label ?itemLabel.
    ?occupation rdfs:label ?occupationLabel.
  }
}
GROUP BY ?item

Pohon

[edit]
Administrasi
SELECT ?negara ?negaraLabel ?provinsi ?provinsiLabel ?daerah ?daerahLabel ?lambang WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  
  ?daerah wdt:P31/wdt:P279 wd:Q12479774.
  ?daerah wdt:P131 ?provinsi.
  ?provinsi wdt:P31 wd:Q5098.
  ?daerah wdt:P17 ?negara.
  ?daerah wdt:P158 ?lambang.
}
LIMIT 100
ADM Sumbar
#defaultView:Tree
SELECT ?kabkota ?kabkotaLabel ?kec ?kecLabel ?nagari ?nagariLabel ?masjid ?masjidLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id". }
  
  ?masjid wdt:P31 wd:Q2225692.
  ?masjid wdt:P131 ?kec.
  ?kec wdt:P131 ?kabkota.
  ?kabkota wdt:P131 wd:Q2772.
}
Masjid Sumbar
SELECT ?kabkota ?kabkotaLabel ?kec ?kecLabel ?nagari ?nagariLabel ?masjid ?masjidLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id". }
  
  ?masjid wdt:P31 wd:Q32815.
  ?masjid wdt:P131 ?nagari.
  ?nagari wdt:P131 ?kec.
  ?kec wdt:P131 ?kabkota.
  ?kabkota wdt:P131 wd:Q2772.
}

Ada berapa masjid di nagari/kecamatan

[edit]
Kecamatan
#Dibuat oleh Adhmi
#defaultView:BubbleChart
SELECT ?sutradara ?film (count(*) as ?count)
WHERE
{
  ?item wdt:P31 wd:Q32815.  
  ?item wdt:P17 wd:Q252.
  ?item wdt:P131 ?kecamatan.
  ?kecamatan wdt:P131 ?sutradara.
  OPTIONAL {
    ?sutradara rdfs:label ?film filter (lang(?film) = "id") .
  }
  ?item wdt:P131/wdt:P131+ wd:Q2772.
         
}
GROUP BY ?sutradara ?film
ORDER BY DESC(?count) ASC(?film)
TABEL LENGKAP
SELECT distinct ?nagari ?nagariLabel ?kabupatenkotaLabel ?kecamatanLabel ?kelurahanLabel ?article ?koordinat WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id". }
  ?nagari wdt:P31 wd:Q32815.
  ?nagari wdt:P17 wd:Q252.
  ?nagari wdt:P131 ?kelurahan.
  ?kelurahan wdt:P131 ?kecamatan.
  ?kecamatan wdt:P131 ?kabupatenkota.
  ?kabupatenkota wdt:P131 wd:Q2772.
   OPTIONAL {  ?article schema:about ?nagari . 
    ?article schema:isPartOf <https://id.wikipedia.org/>.  }
    OPTIONAL { ?nagari wdt:P625 ?koordinat. }
}

Spotify

[edit]

Spotify

Apapun objek di Sumbar

[edit]
#defaultView:BubbleChart
SELECT DISTINCT ?place ?placeLabel ?location ?image ?year ?letakLabel ?article WHERE {
  ?place wdt:P131/wdt:P131+ ?sumbar.
      BIND(wd:Q2772 AS ?sumbar)  
       OPTIONAL { ?place wdt:P18 ?image. }
       OPTIONAL { ?place wdt:P571 ?sejak. }
       OPTIONAL { ?place wdt:P131 ?letak. } 
       OPTIONAL { ?place wdt:P625 ?location. } 
   OPTIONAL {  ?article schema:about ?place . 
    ?article schema:isPartOf <https://id.wikipedia.org/>.  }
  	BIND(YEAR(?sejak) as ?year)

SERVICE wikibase:label { bd:serviceParam wikibase:language "id". }
}
ORDER BY DESC(?sejak)
Try it!
  • atau ini (lebih lengkap, kok bisa): akademi, aliran air, arsip, balairung, asrama, bandar udara, bangunan, bank, benteng, bukit, Bunker, cagar budaya, daerah adm, Wismar, villa, vihara, universitas, Tugu, toko, tempat pemakaman, tambang, sungai, surau, stasiun radio, stasiun kereta, stasiun aja, stadion, situs arkeologi, seklah, organisasi, nama jalan, Pangkalan TNI Angkatan Udara, pantai, Pasar, penerbit akses terbuka, pengadilan, perbankan syariah, permukiman manusia, perguruan tinggi, perpustakaan, PEsantren, prasasti, pulau, Pusat kebudayaan, Q123705, Q149566, Q15642541, Q19979289, Q3146899, Q3850808, Q906512, Q94993988, ruko, rumah, rumah sakit, sekolah, Sekolah asrama, kediaman resmi, masjid raya, Menara, menhir, Monumen, Meriam, museumm, kawasan perlindungan di Indonesia, kawasan lindung laut kawasan ekologi , kantor, institusi akademik Istana, jembatan, institusi pendidikan , Hotel, gunung gereja Gudang, gua,galeri seni , fasilitas, ekoregion WWF, dolin, dapur
  • ganda gak papa gak dibereskan isinya belum, sebaiknya bentang alam?

inisial

[edit]

Masjid Sumbar

[edit]
Corner
#defaultView:Map
SELECT ?place ?placeLabel ?location ?image ?sejak ?letakLabel ?article WHERE {
       ?place wdt:P31 wd:Q32815 .
       OPTIONAL { ?place wdt:P18 ?image. }
       OPTIONAL { ?place wdt:P571 ?sejak. }
       OPTIONAL { ?place wdt:P131 ?letak. } 
   OPTIONAL {  ?article schema:about ?place . 
    ?article schema:isPartOf <https://id.wikipedia.org/>.  }
  	BIND(YEAR(?sejak) as ?year)
SERVICE wikibase:box {
?place wdt:P625 ?location.
bd:serviceParam wikibase:cornerWest "Point(98.36 0.62)"^^geo:wktLiteral .
bd:serviceParam wikibase:cornerEast "Point(101.8 -2)"^^geo:wktLiteral .
}

SERVICE wikibase:label { bd:serviceParam wikibase:language "id". }
}
ORDER BY DESC(?sejak)
Try it!
Tabel
SELECT ?kabkota ?kabkotaLabel ?kec ?kecLabel ?nagari ?nagariLabel ?masjid ?masjidLabel ?koordinat ?year WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id". }
  
  ?masjid wdt:P31 wd:Q32815.
  ?masjid wdt:P131 ?nagari.
  ?nagari wdt:P131 ?kec.
  ?kec wdt:P131 ?kabkota.  
  ?kabkota wdt:P131 wd:Q2772.
  OPTIONAL { ?masjid wdt:P571 ?sejak. }
  	BIND(YEAR(?sejak) as ?year)
  OPTIONAL {
    ?article schema:about ?masjid . 
    ?article schema:isPartOf <https://id.wikipedia.org/>.  
  }
  OPTIONAL { ?masjid wdt:P625 ?koordinat. }
  OPTIONAL { ?masjid wdt:P18 ?image. }
}
ORDER BY ?kabkotaLabel ?kecLabel ?nagariLabel ?masjidLabel
Try it!

Beres-beres

[edit]
P131 Sumatra Barat
#Dibuat oleh Denas
#Objek P131 Sumatra Barat
#defaultView:BarChart
SELECT ?adalah ?label (count(*) as ?count)
WHERE
{
  ?item wdt:P131 wd:Q2772.
  ?item wdt:P31 ?adalah.
  OPTIONAL {
  ?adalah rdfs:label ?label filter (lang(?label) = "id") .
  }    
}
GROUP BY ?adalah ?label
ORDER BY DESC(?count) ASC(?label)
Try it!
P131 Kabkota Sumatra Barat
#Dibuat oleh Denas
#Objek P131 Sumatra Barat
#defaultView:BarChart
SELECT ?adalah ?label (count(*) as ?count)
WHERE
{
  ?item wdt:P131 ?kabkota.
  ?kabkota wdt:P131 wd:Q2772.
  ?item wdt:P31 ?adalah.
  OPTIONAL {
  ?adalah rdfs:label ?label filter (lang(?label) = "id") .
  }    
}
GROUP BY ?adalah ?label
ORDER BY DESC(?count) ASC(?label)
Try it!
P131 Kec Sumatra Barat
#Dibuat oleh Denas
#Objek P131 Sumatra Barat
#defaultView:BarChart
SELECT ?adalah ?label (count(*) as ?count)
WHERE
{
  ?item wdt:P131 ?kec.
  ?kec wdt:P131 ?kabkota.
  ?kabkota wdt:P131 wd:Q2772.
  ?item wdt:P31 ?adalah.
  OPTIONAL {
  ?adalah rdfs:label ?label filter (lang(?label) = "id") .
  }    
}
GROUP BY ?adalah ?label
ORDER BY DESC(?count) ASC(?label)
Try it!
P131 Dati IV Sumatra Barat
#Dibuat oleh Denas
#Objek P131 Sumatra Barat
#defaultView:BarChart
SELECT ?adalah ?label (count(*) as ?count)
WHERE
{
  ?item wdt:P131 ?datiiv.
  ?datiiv wdt:P131 ?kec.
  ?kec wdt:P131 ?kabkota.
  ?kabkota wdt:P131 wd:Q2772.
  ?item wdt:P31 ?adalah.
  OPTIONAL {
  ?adalah rdfs:label ?label filter (lang(?label) = "id") .
  }    
}
GROUP BY ?adalah ?label
ORDER BY DESC(?count) ASC(?label)
Try it!
Hasil yang didapat
Dati I

gunung, sungai, bukit, pulau, tanjung, aliran air, gelung, aliran, kabupaten, kota, terumbu, museum, gunung api strato, laguna, daerah pemilihan Dewan Perwakilan Rakyat Republik Indonesia, gempa bumi, kota besar, taman, taman nasional di Indonesia, Pusat kebudayaan, bahasa, bahasa modern, daerah pemilihan Dewan Perwakilan Daerah Republik Indonesia, daerah tingkat II, danau, danau kawah, gunung berapi, gunung berapi kompleks, kawasan perlindungan di Indonesia, kepulauan, kereta api bandara, pelabuhan, permukiman manusia, perpustakaan, rumah, takson

Dati II

kecamatan, kantor, daerah tingkat III di Indonesia, sekolah menengah atas, perguruan tinggi, rumah sakit, bangunan, universitas swasta, rumah, cagar budaya, sekolah dasar, stasiun kereta api, sekolah menengah kejuruan, museum, tempat pemakaman, pulau, situs arkeologi, menhir, sungai, Bank Syariah Indonesia, Lembaga Pemasyarakatan, kawasan lindung laut, kawasan perlindungan, kawasan perlindungan di Indonesia, prasasti, tugu makam, universitas, bank, benteng, gereja, gunung, institusi akademik, penerbit akses terbuka, stasiun, Balairung, Rumah Tahanan Negara, istana, Hotel, Villa, Wismar, akademi, aliran air, bandar udara, benteng, bunker, institusi pendidikan, klinik, lokawisata, ngarai, organisasi, perpustakaan, politeknik, stadion, tambang, Asrama, Bandar udara internasional, Gudang, Menara, Meriam, Pangkalan TNI Angkatan Udara, Pasar, Perbankan syariah, Pesantren, Pusat kebudayaan, Stasiun Geofisika, Stasiun Klimatologi, Stasiun Pemantau Atmosfer Global, bukit, candi, ekoregion WWF, fasilitas, jembatan, kawasan ekologi, lembah, monumen, museum kereta api, museum zoologi, pantai, permukiman manusia, sekolah, sekolah tinggi, stasiun kereta api bandara, stasiun radio

Dati III

daerah tingkat IV di Indonesia, nagari, kelurahan, rumah, pulau, cagar budaya, tempat pemakaman, sekolah dasar, perguruan tinggi, bangunan, sekolah menengah atas, situs arkeologi, universitas swasta, kantor, stasiun, toko, menhir, museum, prasasti, benteng, tugu makam, gereja, perpustakaan, Balairung, Hotel, arsip, candi, universitas, Asrama, Bioskop, Bungker Jepang, Pesantren, bank, benteng, desa, dolin, gua, istana, jembatan, sungai, Gudang, Lembaga Pembinaan Khusus Anak, Pasar, Ruko, Rumah Tahanan Negara, Vihara, bandar udara, bunker, dapur, institusi pendidikan, kediaman resmi, kuil, monumen, organisasi, pantai, penerbit akses terbuka, pengadilan, politeknik, rawa, rumah sakit, sekolah menengah kejuruan, sekolah tinggi

Dati IV

masjid, sekolah dasar, sekolah menengah atas, perpustakaan, arsip, pulau, cagar budaya, Lembaga Pemasyarakatan, Rumah Tahanan Negara, bangunan, Balairung, museum, rumah, universitas swasta, Pusat kebudayaan, Sekolah asrama, galeri seni, gua, masjid raya, monumen, nama jalan, permukiman manusia, tempat pemakaman

Duplikat

kantor, sekolah menengah atas, perguruan tinggi, rumah sakit, bangunan, universitas swasta, rumah, cagar budaya, sekolah dasar, sekolah menengah kejuruan, museum, tempat pemakaman, pulau, situs arkeologi, menhir, sungai, Lembaga Pemasyarakatan, prasasti, tugu makam, universitas, bank, benteng, gereja, penerbit akses terbuka, stasiun, Balairung, Rumah Tahanan Negara, istana, Hotel, bandar udara, benteng, bunker, institusi pendidikan, organisasi, perpustakaan, politeknik, Asrama, Gudang, Pasar, Pesantren, Pusat kebudayaan, candi, jembatan, monumen, pantai, permukiman manusia, sekolah tinggi, gunung, sungai, bukit, pulau, aliran air, museum, Pusat kebudayaan, kawasan perlindungan di Indonesia, permukiman manusia, perpustakaan, rumah, rumah, pulau, cagar budaya, tempat pemakaman, sekolah dasar, bangunan, sekolah menengah atas, universitas swasta, museum, benteng, perpustakaan, Balairung, arsip, benteng, gua, Rumah Tahanan Negara, monumen

Kurang ADM

[edit]
Pdgpariaman kurang banyak
Nagari Ulu Aie
Nagari Koto Tinggi Maek
8 nagari di Solsel
https://sumbarsatu.com/berita/17519-pemkab-agam-mekarkan-sembilan-nagari-dua-sudah-diresmikan

Mencari

[edit]
#defaultView:BarChart
SELECT ?painting (COUNT(?painting) AS ?count) WHERE {
  ?painting wdt:P31 wd:Q965568;
OPTIONAL { ?painting wdt:P625 ?koordinat. }
  OPTIONAL {  	?painting wdt:P131/wdt:P131+ ?instance  }
    FILTER (?instance = wd:Q2772)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id". }
}
GROUP BY ?painting ?count

Pulau di Indonesia

[edit]
Peta
#Oleh Rahmatdenas
SELECT ?instance ?instanceLabel ?letak ?letakLabel ?pulau ?pulauLabel ?article ?koordinat_tempat WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id,en". }
  ?pulau wdt:P31 wd:Q23442.
   OPTIONAL {  	?pulau wdt:P131/wdt:P131+ ?instance  }
  ?instance wdt:P31 wd:Q5098.
  OPTIONAL { ?pulau wdt:P625 ?koordinat_tempat. }
  OPTIONAL { ?pulau wdt:P18 ?foto. }
  OPTIONAL {
    ?article schema:about ?pulau;
      schema:isPartOf <https://id.wikipedia.org/>.
  }
  OPTIONAL { ?pulau wdt:P131 ?letak. }
}
ORDER BY ASC(?instance)
Barchat
#Oleh Rahmatdenas
#defaultView:BarChart
SELECT ?instance ?instanceLabel (COUNT(*) AS ?count)  WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id,en". }
  ?pulau wdt:P31 wd:Q23442.
  ?pulau wdt:P131/wdt:P131+ ?instance.
  ?instance wdt:P31 wd:Q5098.
}
GROUP BY ?instance ?instanceLabel

Tempor

[edit]
qid,Lid,Len,P31,P21,P569,P570,P140,P172,P40
,Abdoel Latif Chatib Dinagari,Abdoel Latif Chatib Dinagari,Q5,Q6581097,+1792-00-00T00:00:00Z/9,+1852-00-00T00:00:00Z/9,Q432,Q1130350,Q4260016
,Limbak Oerai,Limbak Oerai,Q5,Q6581072,+1795-00-00T00:00:00Z/9,+1855-00-00T00:00:00Z/9,Q432,Q1130350,Q4260016

Contoh

[edit]
SELECT DISTINCT ?item ?itemLabel ?genderLabel ?positionLabel ?start ?end ?partaiLabel ?dapilLabel WHERE
{
  ?item wdt:P31 wd:Q5 ;
        p:P39 ?position_statement .
  ?position_statement ps:P39 ?position ;
                      pq:P580 ?start FILTER (?start >= "2019-10-01T00:00:00Z"^^xsd:dateTime) .
  ?position wdt:P279* wd:Q21328632 .
  
  ?item rdfs:label ?name.
  OPTIONAL { ?position_statement pq:P582 ?x }
  OPTIONAL { ?position_statement pq:P768 ?dapil }
  OPTIONAL { ?item wdt:P102 ?partai }
  OPTIONAL { ?item wdt:P21 ?gender }
  bind(if(bound(?x), ?x, NOW()) as ?end )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id" . }
  filter (lang(?name) = "id").
  filter(regex(?name, "^D(.+)K(.+)")).
  
}
ORDER BY DESC(?days) ?itemLabel

Contoh

[edit]
SELECT 
  ?Tour_de_Singkarak 
(SAMPLE(?Tour_de_SingkarakLabel) AS ?Tour_de_SingkarakLabel) 
(SAMPLE(?bermula_sejak) AS ?bermula_sejak) 
(SAMPLE(?berakhir_pada) AS ?berakhir_pada) 
(GROUP_CONCAT(DISTINCT ?pemenangLabel; SEPARATOR=", ") AS ?pemenangLabels)

WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],id". 
                          ?Tour_de_Singkarak rdfs:label ?Tour_de_SingkarakLabel.
  ?pemenang rdfs:label ?pemenangLabel.                       
                         
                         }
  ?Tour_de_Singkarak wdt:P31 wd:Q1973056.
  OPTIONAL { ?Tour_de_Singkarak wdt:P580 ?bermula_sejak. }
  OPTIONAL { ?Tour_de_Singkarak wdt:P582 ?berakhir_pada. }
  OPTIONAL { ?Tour_de_Singkarak wdt:P1346 ?pemenang. }
}
GROUP BY ?Tour_de_Singkarak
ORDER BY ASC (?Tour_de_SingkarakLabel)

Asal kampung

[edit]
SELECT ?eyeColor ?eyeColorLabel (COUNT(?human) AS ?count)
WHERE
{
  ?human wdt:P1343 wd:Q122894359.
  ?human wdt:P19 ?eyeColor.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?eyeColor ?eyeColorLabel 
ORDER BY DESC(?count)

Tertua

[edit]
SELECT DISTINCT ?person ?personLabel ?lahiryear ?umur
WHERE
{
       ?person wdt:P1343 wd:Q122894359 . # human
       FILTER NOT EXISTS { ?person  wdt:P570  [] } # alive
       FILTER EXISTS { ?person  wdt:P569  [] } # lahir
    OPTIONAL { ?person wdt:P569 ?lahir. }
  BIND(YEAR(?lahir) as ?lahiryear)  
  BIND(2023 - ?lahiryear AS ?umur)
       SERVICE wikibase:label {bd:serviceParam wikibase:language "id" }
}

Ringkas orang

[edit]
qid,Lid,P31,P21
,Landjadin Dt. Kajo,Q5,Q6581097 atau Q6581072 (pr)

Ringkas masjid

[edit]
qid,Lid,P31,P17
,Masjid,Q32815,Q252

Perolehan suara caleg perempuan

[edit]
#Dibuat oleh Rahmat Irfan Denas
SELECT DISTINCT ?item ?itemLabel ?genderLabel ?dapilLabel ?partaiLabel ?suara ?article WHERE
{
  ?item wdt:P21 wd:Q6581072 ;
        p:P3602 ?position_statement .
  ?position_statement ps:P3602 wd:Q108816797 ;
  OPTIONAL { ?position_statement pq:P582 ?x }
  OPTIONAL { ?position_statement pq:P768 ?dapil }
  OPTIONAL { ?position_statement pq:P1111 ?suara }
  OPTIONAL { ?position_statement pq:P102 ?partai }
  OPTIONAL {  ?article schema:about ?item . 
  ?article schema:isPartOf <https://id.wikipedia.org/>.  }
  OPTIONAL { ?item wdt:P21 ?gender }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id" . }
  
}
ORDER BY ASC(?dapilLabel)
Retrieved from "https://www.wikidata.org/w/index.php?title=User_talk:Rahmatdenas&oldid=2086479845"