Template:ScotlandLAMetric: Difference between revisions
Creation of Table |
No edit summary |
||
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
{{#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:}} | |||
{{#clear_external_data:}} | {{#clear_external_data:}} | ||
{{#get_db_data: db=ID |from=scotland_joined |where=gsscode='{{{gss}}}' |data=ghhg=ghhg,ghhgkgpp=ghhgkgpp,mrroprt=mrroprt,mrroprtpc=mrroprtpc,mrrect=mrrect,mrrecpc=mrrecpc,morgt=morgt,morgpc=morgpc,manpru=manpru,manprupc=manprupc,modothrlf=modothrlf,modothrlfpc=modothrlfpc,modrcoi=modrcoi,modrcoipc=modrcoipc,modrinc=modrinc,modrincpc=modrincpc,moddinc=moddinc,moddincpc=moddincpc,modothr=modothr,modothrpc=modothrpc,lfill=lfill,lfillpc=lfillpc,tco2e=tco2e,tco2epp=tco2epp,rnkkgpp=rnkkgpp,rnkrec=rnkrec,rnkcarb=rnkcarb | {{#get_db_data: db=ID |from=scotland_joined |where=gsscode='{{{gss}}}' |data=ghhg=ghhg,ghhgkgpp=ghhgkgpp,mrroprt=mrroprt,mrroprtpc=mrroprtpc,mrrect=mrrect,mrrecpc=mrrecpc,morgt=morgt,morgpc=morgpc,manpru=manpru,manprupc=manprupc,modothrlf=modothrlf,modothrlfpc=modothrlfpc,modrcoi=modrcoi,modrcoipc=modrcoipc,modrinc=modrinc,modrincpc=modrincpc,moddinc=moddinc,moddincpc=moddincpc,modothr=modothr,modothrpc=modothrpc,lfill=lfill,lfillpc=lfillpc,tco2e=tco2e,tco2epp=tco2epp,rnkkgpp=rnkkgpp,rnkrec=rnkrec,rnkcarb=rnkcarb | ||
Line 5: | Line 8: | ||
====Ranked Metrics==== | ====Ranked Metrics==== | ||
{| class=wikitable | {| class=wikitable | ||
! Metric !!Indicator !! Ranking | ! Metric !!Indicator !! [[Key Metric Rankings|Ranking]] | ||
|- | |- | ||
|Percentage of waste Recycled, Organics or Prepared for Reuse||style="text-align:right";|{{formatnum: {{#external_value:mrroprtpc}}}} ||{{#external_value:rnkrec}} | |Percentage of waste Recycled, Organics or Prepared for Reuse (%)||style="text-align:right";|{{formatnum: {{#external_value:mrroprtpc}}}} ||{{#external_value:rnkrec}} | ||
|- | |- | ||
|Household Generated Waste||style="text-align:right";|{{formatnum: {{#external_value:ghhgkgpp}}}} ||{{#external_value:rnkkgpp}} | |Household Generated Waste (kg/pp)||style="text-align:right";|{{formatnum: {{#external_value:ghhgkgpp}}}} ||{{#external_value:rnkkgpp}} | ||
|- | |- | ||
|Household Waste Carbon Impact (TCO2e/pp)||style="text-align:right";|{{formatnum: {{#external_value:tco2epp}}}}||{{#external_value:rnkcarb}} | |Household Waste Carbon Impact (TCO2e/pp)||style="text-align:right";|{{formatnum: {{#external_value:tco2epp}}}}||{{#external_value:rnkcarb}} | ||
Line 24: | Line 27: | ||
|colspan = 3 | '''Management - Recycling''' | |colspan = 3 | '''Management - Recycling''' | ||
|- | |- | ||
|Recycled, Organics, Prepared for Reuse (tonnes)||style="text-align:right";|{{formatnum: {{#external_value: mrroprt}}}}||{{formatnum: {{#external_value:mrroprtpc}}}} | |Recycled, Organics, Prepared for Reuse (tonnes)||style="text-align:right";|{{formatnum: {{#external_value: mrroprt}}}}||style="text-align:right";|{{formatnum: {{#external_value:mrroprtpc}}}} | ||
|- | |- | ||
|Recycled (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:mrrect}}}} || {{formatnum: {{#external_value:mrrecpc}}}} | |• Recycled (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:mrrect}}}} || style="text-align:right";|{{formatnum: {{#external_value:mrrecpc}}}} | ||
|- | |- | ||
|Organics Recycled (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:morgt}}}}||{{formatnum: {{#external_value:morgpc}}}} | |• Organics Recycled (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:morgt}}}}||style="text-align:right";|{{formatnum: {{#external_value:morgpc}}}} | ||
|- | |- | ||
|Prepared for Reuse (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:manpru}}}}||{{formatnum: {{#external_value:manprupc}}}} | |• Prepared for Reuse (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:manpru}}}}||style="text-align:right";|{{formatnum: {{#external_value:manprupc}}}} | ||
|- | |- | ||
|colspan=3 | '''Management - Other Diversion''' | |colspan=3 | '''Management - Other Diversion''' | ||
|- | |- | ||
|Other diversion from Landfill (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:modothrlf}}}}||{{formatnum: {{#external_value:modothrlfpc}}}} | |Other diversion from Landfill (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:modothrlf}}}}||style="text-align:right";|{{formatnum: {{#external_value:modothrlfpc}}}} | ||
|- | |- | ||
|Recovered by Co-Incineration||style="text-align:right";|{{formatnum: {{#external_value:modrcoi}}}}||{{formatnum: {{#external_value:modrcoipc}}}} | |• Recovered by Co-Incineration (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:modrcoi}}}}||style="text-align:right";|{{formatnum: {{#external_value:modrcoipc}}}} | ||
|- | |- | ||
|Recovered by Incineration||style="text-align:right";|{{formatnum: {{#external_value:modrinc}}}}||{{formatnum: {{#external_value:modrincpc}}}} | |• Recovered by Incineration (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:modrinc}}}}||style="text-align:right";|{{formatnum: {{#external_value:modrincpc}}}} | ||
|- | |- | ||
|Disposed by Incineration||style="text-align:right";|{{formatnum: {{#external_value:moddinc}}}}||{{formatnum: {{#external_value:moddincpc}}}} | |• Disposed by Incineration (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:moddinc}}}}||style="text-align:right";|{{formatnum: {{#external_value:moddincpc}}}} | ||
|- | |- | ||
|Managed by Other Methods||style="text-align:right";|{{formatnum: {{#external_value:modothr}}}}||{{formatnum: {{#external_value:modothrpc}}}} | |• Managed by Other Methods (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:modothr}}}}||style="text-align:right";|{{formatnum: {{#external_value:modothrpc}}}} | ||
|- | |- | ||
|Waste to Landfill ||style="text-align:right";|{{formatnum: {{#external_value:lfill}}}}||{{formatnum: {{#external_value:lfillpc | |colspan=3| '''Management - Landfill''' | ||
}}}} | |- | ||
|Waste to Landfill (tonnes)||style="text-align:right";|{{formatnum: {{#external_value:lfill}}}}||style="text-align:right";|{{formatnum: {{#external_value:lfillpc}}}} | |||
|- | |- | ||
|colspan=2 | '''Carbon Impact''' | |colspan=2 | '''Carbon Impact''' | ||
|- | |- | ||
| | |Household Waste Carbon Impact (TCO2e)||style="text-align:right";|{{formatnum: {{#external_value:tco2e}}}}|| - | ||
|- | |- | ||
|} | |} |
Latest revision as of 08:54, 13 July 2022
For reporting period: Jan22 - Dec22
Ranked Metrics
Metric | Indicator | Ranking |
---|---|---|
Percentage of waste Recycled, Organics or Prepared for Reuse (%) | Error: no local variable "mrroprtpc" has been set. | Error: no local variable "rnkrec" has been set. |
Household Generated Waste (kg/pp) | Error: no local variable "ghhgkgpp" has been set. | Error: no local variable "rnkkgpp" has been set. |
Household Waste Carbon Impact (TCO2e/pp) | Error: no local variable "tco2epp" has been set. | Error: no local variable "rnkcarb" has been set. |
Unranked Metrics
Metric | Indicator | Percentage |
---|---|---|
Generation | ||
Household Generated Waste (tonnes) | Error: no local variable "ghhg" has been set. | - |
Management - Recycling | ||
Recycled, Organics, Prepared for Reuse (tonnes) | Error: no local variable "mrroprt" has been set. | Error: no local variable "mrroprtpc" has been set. |
• Recycled (tonnes) | Error: no local variable "mrrect" has been set. | Error: no local variable "mrrecpc" has been set. |
• Organics Recycled (tonnes) | Error: no local variable "morgt" has been set. | Error: no local variable "morgpc" has been set. |
• Prepared for Reuse (tonnes) | Error: no local variable "manpru" has been set. | Error: no local variable "manprupc" has been set. |
Management - Other Diversion | ||
Other diversion from Landfill (tonnes) | Error: no local variable "modothrlf" has been set. | Error: no local variable "modothrlfpc" has been set. |
• Recovered by Co-Incineration (tonnes) | Error: no local variable "modrcoi" has been set. | Error: no local variable "modrcoipc" has been set. |
• Recovered by Incineration (tonnes) | Error: no local variable "modrinc" has been set. | Error: no local variable "modrincpc" has been set. |
• Disposed by Incineration (tonnes) | Error: no local variable "moddinc" has been set. | Error: no local variable "moddincpc" has been set. |
• Managed by Other Methods (tonnes) | Error: no local variable "modothr" has been set. | Error: no local variable "modothrpc" has been set. |
Management - Landfill | ||
Waste to Landfill (tonnes) | Error: no local variable "lfill" has been set. | Error: no local variable "lfillpc" has been set. |
Carbon Impact | ||
Household Waste Carbon Impact (TCO2e) | Error: no local variable "tco2e" has been set. | - |