Kullanıcı:Chidgk1/deneme tahtası: Revizyonlar arasındaki fark

İçerik silindi İçerik eklendi
Chidgk1 (mesaj | katkılar)
Değişiklik özeti yok
Chidgk1 (mesaj | katkılar)
Değişiklik özeti yok
1. satır:
==Türkiye'deki kömür yakan termik santralleri listesi==
Not: Kapasite mekanizması ödemeleri için [[Türkiye'deki enerji santralleri listesi#Kömür yakan termik santraller|Türkiye'deki önemli enerji santralleri listesi]] bakınız.
 
{{Wikidata list
|sparql=SELECT DISTINCT ?item ?2019ghg2021 ?2020ghg2020 ?sub2021 ?sub2020
WHERE
{
Satır 9 ⟶ 6:
?item wdt:P17 wd:Q43 . # ?item is in Turkey
?item wdt:P5817 wd:Q55654238 . # ?item state of use is "in use"
?item wdt:P9274 ?CapacityPayment . # write properties as names so easier to follow code below
?item wdt:P2109 ?InstalledCapacity . # write property as name so easier to follow code below
FILTER (?InstalledCapacity >= 40) . # Only list plants of 40 MW or over installed capacity
optional {?CapacityPaymentitem p:P5991 ?stat20g21 . # CapacityGreenhouse paymentgas by year
optional {?itemg21 pps:P4131P5991 ?stat21ghg2021 . # To add another year duplicatecopy these 4 lines, paste them above and add one to all the year numbers. Also add the column below.
?stat20 ps:CapacityPayment ?2020 .
?stat21g21 pspq:P4131P585 ?2021 .year21 # And add the data to Wikidata of course - if you could automate adding the data please document how.
?stat20 pq:CapacityPayment ?year20
filter(year(?year21)=2021) }
optional {?item p:P5991 ?g20 .
?g20 ps:P5991 ?ghg2020 .
?stat20g20 pq:CapacityPaymentP585 ?year20
filter(year(?year20)=2020) }
optional {?item p:P4131 ?stat21 . # To add another year duplicate these 4 lines and add one to all the year numbers. Also add the column below.
optional {?item p:P9274 ?s21 . # Capacity payment by year
?stat21 ps:P4131 ?2021 . # And add the data to Wikidata of course - if you could automate adding the data please document how.
?s21 ps:P9274 ?sub2021 . # To add another year copy these 4 lines, paste them above and add one to all the year numbers. Also add the column below.
?stat21 pq:P585 ?year21
?s21 pq:P585 ?year21 # And add the data to Wikidata of course - if you could automate adding the data please document how.
filter(year(?year21)=2021) }
optional {?item p:P9274 ?s20 .
?s20 ps:P9274 ?sub2020 .
?stat21s20 pq:P585 ?year21year20
filter(year(?year20)=2020) }
}
|columns=label:Santral,P2109,?2021:Enerji üretimi 2021,?2020:2020,?2019:2019,P729,P127,P625,P18,P516,P618,P8506,P9274/P585?ghg2021:Karbon ayak 2021,?ghg2020:2020,?sub2021:Sübvansiyon P5991/P5852021,?sub2020:2020
|section=
|min_section=