Sorgulama: Difference between revisions

no edit summary
(seeding with English text)
 
No edit summary
Line 1: Line 1:
Run SPARQL queries via the [https://ottgaz.org/query/ Ottgaz Query Service].
Ottgaz Query Service[https://ottgaz.org/query/ Ottgaz Query Service] aracılığıyla SPARQL sorgulamlarını çalıştırın.  


'''Remember:''' SPARQL is currently case sensitive, as elastic search is disabled in wikibase.cloud.
'''Hatırlatma:''' Esnek arama wikibase.cloud'da devre dışı bırakıldığı için SPARQL şu anda büyük/küçük harfe duyarlıdır.


== Namespace ==
== Ad alanları ==


Declare these namespaces at the start of every query:
Bu ad alanlarını her sorgunun başında belirtin:


  PREFIX og: <https://ottgaz.org/entity/>
  PREFIX og: <https://ottgaz.org/entity/>
Line 15: Line 15:
  PREFIX ogpq: <https://ottgaz.org/prop/qualifier/>
  PREFIX ogpq: <https://ottgaz.org/prop/qualifier/>


== Sample queries ==
== Örnek Sorgulamalar ==


=== Label ===
=== Etiket ===
All regions that had vilayet status, as well as their English language label. [https://tinyurl.com/2k4uq6u2 run]
Vilayet statüsüne sahip tüm bölgeler ve İngilizce dil etiketleri. [https://tinyurl.com/2k4uq6u2 run]


  SELECT ?vilayet ?vilayetLabel
  SELECT ?vilayet ?vilayetLabel
  WHERE  
  WHERE
  {
  {
   ?vilayet ogt:P15 og:Q5.
   ?vilayet ogt:P15 og:Q5.
Line 27: Line 27:
  }
  }


=== Duration, start and end dates ===
=== Süre, başlangıç ve bitiş tarihleri ===
Duration between start and end date of every region with a start date, as well as region type. [https://tinyurl.com/2k8h75bz run]
Başlangıç tarihi ve bölge türü ile her bölgenin başlangıç ve bitiş tarihi arasındaki süre. [https://tinyurl.com/2k8h75bz run]


  SELECT ?regionLabel ?statusLabel (YEAR(?starttime) as ?start) (YEAR(?endtime) as ?end) ?duration
  SELECT ?regionLabel ?statusLabel (YEAR(?starttime) as ?start) (YEAR(?endtime) as ?end) ?duration
Line 45: Line 45:
  ORDER BY desc(?duration)
  ORDER BY desc(?duration)


=== Number of kazas created each year ===
=== Her yıl kurulan kaza sayısı ===
In each year, how many kazas were inaugurated? [https://tinyurl.com/2z9gjrch run]
Her yıl kaç tane kaza kuruldu? [https://tinyurl.com/2z9gjrch run]


  SELECT ?year (COUNT (DISTINCT ?kaza) AS ?count)
  SELECT ?year (COUNT (DISTINCT ?kaza) AS ?count)
Line 60: Line 60:
  ORDER BY desc(?count)
  ORDER BY desc(?count)


===Count status types in a given year===
===Belirli bir yıldaki statü çeşitlerini sayın===
For a given year, how many regions of each status are found in the dataset? [https://tinyurl.com/2mqqhl8u run]
Belirli bir yıl için, veri setinde her statüden kaç bölge bulunmaktadır? [https://tinyurl.com/2mqqhl8u run]


  SELECT (COUNT (DISTINCT ?region) AS ?count) ?statusLabel
  SELECT (COUNT (DISTINCT ?region) AS ?count) ?statusLabel
Line 78: Line 78:
  ORDER BY desc(?count)
  ORDER BY desc(?count)


===Number of kazas between 1800 and 1900===
===1800 ve 1900 yılları arasındaki kaza sayıları===
*This query is not working yet.* The query below returns the number of vilayets between 1750 and 1760. Thanks to [https://stackoverflow.com/users/7879193/stanislav-kralin Stanislav Kralin] for [https://stackoverflow.com/questions/75137894/counting-items-over-time-using-sparql help]. [ run]
*Bu sorgulama henüz çalışmıyor. * Aşağıdaki sorgulama 1750 ile 1760 arasındaki vilayetlerin sayısını vermektedir. Kaynak: [https://stackoverflow.com/users/7879193/stanislav-kralin Stanislav Kralin] for [https://stackoverflow.com/questions/75137894/counting-items-over-time-using-sparql help]. [ run]


  PREFIX wd: <http://www.wikidata.org/entity/>
  PREFIX wd: <http://www.wikidata.org/entity/>
Line 101: Line 101:
  order by ?number
  order by ?number


===Sancak status ending between 1830 and 1840===
===1830 ile 1840 arasında sona eren Sancak statüleri===
This query will return the region more than once, if it undergoes status change more than once during this time period. [https://tinyurl.com/2ew6y2vw run]
Bu sorgulama, bu süre zarfında birden fazla durum değişikliğine uğrarsa, bölgeyi birden çok kez sunar. [https://tinyurl.com/2ew6y2vw run]


  SELECT ?sancak ?sancakLabel (YEAR(?starttime) as ?start) (YEAR(?endtime) as ?end)  
  SELECT ?sancak ?sancakLabel (YEAR(?starttime) as ?start) (YEAR(?endtime) as ?end)  
Line 118: Line 118:
  ORDER BY (?endtime)
  ORDER BY (?endtime)


=== Map of sanjak seats ===
=== Sancak mevkilerinin haritası ===


This shows only those sanjaks with seats designated and geolocated. [https://tinyurl.com/2hqpwoas run]
Bu, yalnızca mevkileri ve coğrafi konumu belirlenmiş sancakları gösterir. [https://tinyurl.com/2hqpwoas run]


  #defaultView:Map
  #defaultView:Map
Line 132: Line 132:
  }
  }


== Federated query with Wikidata ==
== Vikiveri ile birleştirilmiş sorgulama ==


For every sanjak in Ottgaz, this query fetches the vilayet or eyalet to which Wikidata says it belongs. Thanks to Lucas Werkmeister for help. [https://tinyurl.com/2eokop65 run]
Ottgaz'daki her sancak için bu sorgu, Vikiveri'nin ait olduğunu söylediği vilayet veya eyaleti getirir. Yardımı için Lucas Werkmeister'a teşekkürler. [https://tinyurl.com/2eokop65 run]


  PREFIX og: <https://ottgaz.org/entity/>
  PREFIX og: <https://ottgaz.org/entity/>
Bureaucrats, emailconfirmed
34

edits