Preston City Council: Difference between revisions

Preston City Council (view source)

Revision as of 03:20, 30 September 2019

104 bytes added , 30 September 2019

Imported from text file

VisualWikitext

Admin

Bureaucrats, Interface administrators, Administrators

4,355

edits

@@ Line 1: / Line 1: @@
 Preston District
-{{#get_db_data: db=ID |from=districts |where=gsscode='E07000123' |data=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 |where=gsscode='E07000123' |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}}
 == Demographic Information ==
@@ Line 20: / Line 19: @@
 {|class=wikitable
-|Population<ref>Source: ONS mid 2018 projection</ref>|| {{formatnum: {{#external_value:pers}}}}
+|Population<ref>Source: ONS mid 2018 projection</ref>|| {{formatnum: {{#external_value:pop}}}} || [[Ranking|{{#external_value:rpop}}]]
 |-
-|Land Area (ha)<ref>Source: Ordnance Survey boundry line data 2019</ref>|| {{formatnum: {{#external_value:ha}}}}
+|Land Area (ha)<ref>Source: Ordnance Survey boundry line data 2019</ref>|| {{formatnum: {{#external_value:area}}}}|| [[Ranking|{{#external_value:rarea}}]]
 |-
-|Population per ha|| {{#external_value:ppha}}
+|Population per ha|| {{#external_value:ppha}}|| [[Ranking|{{#external_value:rppha}}]]
 |}
@@ Line 34: / Line 33: @@
 == Key Metrics ==
 {|class=wikitable
-!Metric<ref>Collection data from WasteData Flow for calendar year 2017, and refers to only waste colleced at the kerbside.</ref>!!Indicator
+!Metric<ref>Collection data from WasteData Flow for calendar year 2017, and refers to only waste colleced at the kerbside.</ref>!!Indicator!!Ranking
 |-
-|Residual Waste per Person|| {{#expr: ({{#external_value:res}}*1000)/{{#external_value:pers}} round 2 }} kg/person
+|Residual Waste per Person|| {{#external_value:rpp}} kg/person || [[Ranking|{{#external_value:rrpp}}]]
 |-
-|Residual Waste per ha|| {{formatnum: {{#expr: {{#external_value:res}}/{{#external_value:ha}} round 2}}}} t/ha
+|Residual Waste per ha|| {{#external_value:rpha}} t/ha || [[Ranking|{{#external_value:rrpha}}]]
 |-
-|Recycling Rate|| {{#iferror: {{#expr: (({{#external_value:org}}+{{#external_value:food}}+{{#external_value:mix}}+{{#external_value:dmr}})/(({{#external_value:org}}+{{#external_value:food}}+{{#external_value:mix}}+{{#external_value:dmr}})+{{#external_value:res}}))*100 round 2}} | 0}}%
+|Recycling Rate|| {{#external_value:recpc}} || [[Ranking|{{#external_value:rrecpc}}]]
 |-
-|Organic<ref>Combined Garden, Food and Mixed Waste.</ref> Waste per Person || {{#expr: (({{#external_value:org}}+{{#external_value:mix}}+{{#external_value:food}})*1000)/{{#external_value:pers}} round 2}} kg/person
+|Organic<ref>Combined Garden, Food and Mixed Waste.</ref> Waste per Person || {{#external_value:orgpp}} kg/person || [[Ranking|{{#external_value:rorgpp}}]]
 |-
-|Food Waste per Person || {{#expr: ({{#external_value:food}}*1000)/{{#external_value:pers}} round 2}} kg/person
+|Food Waste per Person || {{#external_value:fpp}} kg/person || [[Ranking|{{#external_value:rfpp}}]]
 |-
-|Collected Recyclate|| {{formatnum: {{#expr: ({{#external_value:org}}+{{#external_value:food}}+{{#external_value:mix}}+{{#external_value:dmr}})}}}} t
+|Collected Recyclate|| ||
 |-
-| * Collected Garden || {{formatnum: {{#external_value:org}}}} t
+| * Collected Garden || {{formatnum: {{#external_value:gard}}}} t || [[Ranking|{{#external_value:rgdn}}]]
 |-
-| * Collected Food || {{formatnum: {{#external_value:food}}}} t
+| * Collected Food || {{formatnum: {{#external_value:food}}}} t || [[Ranking|{{#external_value:rfood}}]]
 |-
-| * Collected Mixed<ref>Collection of Food and Garden Waste together in the same bin.</ref> || {{formatnum: {{#external_value:mix}}}} t
+| * Collected Mixed<ref>Collection of Food and Garden Waste together in the same bin.</ref> || {{formatnum: {{#external_value:mix}}}} t || [[Ranking|{{#external_value:rmix}}]]
 |-
-| * Collected DMR || {{formatnum: {{#external_value:dmr}}}} t
+| * Collected DMR || {{formatnum: {{#external_value:dmr}}}} t || [[Ranking|{{#external_value:rdmr}}]]
 |-
-|Collected Residual Waste|| {{formatnum: {{#external_value:res}}}} t
+|Collected Residual Waste|| {{formatnum: {{#external_value:res}}}} t || [[Ranking|{{#external_value:rres}}]]
 |}
 ====Notes====