Key Metric Rankings: Difference between revisions

@@ Line 1: / Line 1: @@
-{{#get_db_data: db=ID |from=districts|data=dist=name,pers=pop,ha=area,ppha=round(pop/area,2),res=residual,dmr=dmr,org=garden,food=food,mix=mixed }}
+{{#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}}
+Below are tables showing all the Collection Authorities and their rankings from each of the groupings.
+__FORCETOC__
+==Demographics==
 {| class="wikitable sortable"
 ! District
 ! Population
-! Area
+! Rank
-! Population/Ha {{#for_external_table:<nowiki/>
+! Area
+! Rank
+! Pop/Ha
+! Rank {{#for_external_table:<nowiki/>
 {{!}}-
-{{!}} {{{dist}}}
+{{!}} [[{{{dist}}}]]
-{{!}} {{{pers}}}
+{{!}} {{{pop}}}
-{{!}} {{{ha}}}
+{{!}} {{{rpop}}}
+{{!}} {{{area}}}
+{{!}} {{{rarea}}}
 {{!}} {{{ppha}}}
+{{!}} {{{rppha}}}
 }}
 |}
+==Collected Waste==
+{| class="wikitable sortable"
+! District
+! Residual
+! Rank
+! DMR
+! Rank
+! Mixed
+! Rank
+! Food
+! Rank
+! Garden
+! Rank {{#for_external_table:<nowiki/>
+{{!}}-
+{{!}} [[{{{dist}}}]]
+{{!}} {{{res}}}
+{{!}} {{{rres}}}
+{{!}} {{{dmr}}}
+{{!}} {{{rdmr}}}
+{{!}} {{{mix}}}
+{{!}} {{{rmix}}}
+{{!}} {{{food}}}
+{{!}} {{{rfood}}}
+{{!}} {{{gard}}}
+{{!}} {{{rgdn}}}
+}}
+|}
+==Metrics==