Key Metric Rankings: Difference between revisions

← Older edit

VisualWikitext

@@ Line 1: / Line 1: @@
-{{#get_db_data: db=ID |from=districts|data=dist=name,area=area,rarea=rarea,pop=pop,rpop=rpop,ppha=ppha,rppha=rppha,res=residual,rres=rres,rpp=rpp,rrpp=rrpp,rpha=rpha,rrpha=rrpha,recpc=recpc,rrecpc=rrecpc,dmr=dmr,rdmr=rdmr,food=food,rfood=rfood,mix=mixed,rmix=rmix,gard=garden,rgdn=rgdn,orgpp=orgpp,rorgpp=rorgpp,fpp=fpp,rfpp=rfpp}}
+[[Category:Arrangements]][[Category:Targets & Metrics]]
-Below are tables showing all the Collection Authorities and their rankings from each of the groupings.
+Below are tables showing all the ranked metrics from the [[Key Metrics]], grouped by region. Use the arrows in the header row to sort any of the columns into ascending or descending order.
-__FORCETOC__
-==Demographics==
+Recycling is ranked from high to low, whilst household waste per person has been ranked low to high. In the case of Scotland where they have a Carbon metric, that has also been ranked from low to high.
+__TOC__
+<br clear=all />
+==England==
+{{#clear_external_data:}}
+{{#get_db_data: db=ID| from=england_joined|limit=1|data=year=year}}
+For reporting period: {{#external_value:year}}
+{{#clear_external_data:}}
+{{#get_db_data: db=ID |from=england_joined|data=authority=authority,hhwrecypc=hhwrecypc,rnkrecypc=rnkrecypc,chhwpp=chhwpp,rnkhhpp=rnkhhpp}}
 {| class="wikitable sortable"
-! District
+! Authority
-! Population
+! Recycling (%)
 ! Rank
-! Area
+! Household Waste (kg/pp)
-! Rank
-! Pop/Ha
 ! Rank {{#for_external_table:<nowiki/>
 {{!}}-
-{{!}} [[{{{dist}}}]]
+{{!}} [[{{{authority}}}]]
-{{!}} {{{pop}}}
+{{!}} {{{hhwrecypc}}}
-{{!}} {{{rpop}}}
+{{!}} {{{rnkrecypc}}}
-{{!}} {{{area}}}
+{{!}} {{{chhwpp}}}
-{{!}} {{{rarea}}}
+{{!}} {{{rnkhhpp}}}
-{{!}} {{{ppha}}}
-{{!}} {{{rppha}}}
 }}
 |}
-==Collected Waste==
+==Northern Ireland==
+{{#clear_external_data:}}
+{{#get_db_data: db=ID| from=nireland_joined |limit=1|data=year=year}}
+For reporting period: {{#external_value:year}}{{#clear_external_data:}}
+{{#get_db_data: db=ID |from=nireland_joined |data=name=name,kpi_a2=kpi_a2,kpi_a2_rnk=kpi_a2_rnk,kpi_p=kpi_p,kpi_p_rnk=kpi_p_rnk}}
 {| class="wikitable sortable"
-! District
+! Authority
-! Residual
+! Recycling (%)
 ! Rank
-! DMR
+! Household Waste (kg/pp)
+! Rank  {{#for_external_table:<nowiki/>
+{{!}}-
+{{!}} [[{{{name}}}]]
+{{!}} {{{kpi_a2}}}
+{{!}} {{{kpi_a2_rnk}}}
+{{!}} {{{kpi_p}}}
+{{!}} {{{kpi_p_rnk}}}
+}}
+|}
+==Scotland==
+{{#clear_external_data:}}
+{{#get_db_data: db=ID| from=scotland_joined|limit=1|data=period=period}}
+For reporting period: {{#external_value:period}}{{#clear_external_data:}}
+{{#get_db_data: db=ID |from=scotland_joined |data=authority=authority,mrroprtpc=mrroprtpc,rnkrec=rnkrec,ghhgkgpp=ghhgkgpp,rnkkgpp=rnkkgpp,tco2epp=tco2epp,rnkcarb=rnkcarb}}
+{| class="wikitable sortable"
+! Authority
+! Recycling (%)
 ! Rank
-! Mixed
+! Household Waste (kg/pp)
 ! Rank
-! Food
+! Carbon Impact (TCO2e/pp)
+! Rank {{#for_external_table:<nowiki/>
+{{!}}-
+{{!}} [[{{{authority}}}]]
+{{!}} {{{mrroprtpc}}}
+{{!}} {{{rnkrec}}}
+{{!}} {{{ghhgkgpp}}}
+{{!}} {{{rnkkgpp}}}
+{{!}} {{{tco2epp}}}
+{{!}} {{{rnkcarb}}}
+}}
+|}
+==Wales==
+{{#clear_external_data:}}
+{{#get_db_data: db=ID| from=wales_joined |limit=1|data=period=period}}
+For reporting period: {{#external_value:period}}{{#clear_external_data:}}
+{{#get_db_data: db=ID |from=wales_joined |data=authority=authority,wrrccpc=wrrccpc,rnkkkwrec=rnkkkwrec,hhwpp=hhwpp,rnkhhwpp=rnkhhwpp}}
+{| class="wikitable sortable"
+! Authority
+! Recycling (%)
 ! Rank
-! Garden
+! Household Waste (kg/pp)
-! Rank {{#for_external_table:<nowiki/>
+! Rank  {{#for_external_table:<nowiki/>
 {{!}}-
-{{!}} [[{{{dist}}}]]
+{{!}} [[{{{authority}}}]]
-{{!}} {{{res}}}
+{{!}} {{{wrrccpc}}}
-{{!}} {{{rres}}}
+{{!}} {{{rnkkkwrec}}}
-{{!}} {{{dmr}}}
+{{!}} {{{hhwpp}}}
-{{!}} {{{rdmr}}}
+{{!}} {{{rnkhhwpp}}}
-{{!}} {{{mix}}}
-{{!}} {{{rmix}}}
-{{!}} {{{food}}}
-{{!}} {{{rfood}}}
-{{!}} {{{gard}}}
-{{!}} {{{rgdn}}}
 }}
 |}
-==Metrics==
+==References==
+<references />