Template:EfWTemplate: Difference between revisions
Arctellion (talk | contribs) No edit summary |
Arctellion (talk | contribs) No edit summary |
||
| Line 38: | Line 38: | ||
|[[{{#external_value:funding}}]] | |[[{{#external_value:funding}}]] | ||
|} | |} | ||
<big>'''Historical Tonnage | <big>'''Historical Tonnage'''</big> | ||
'''Environment Agency Dataset''' | '''Environment Agency Dataset''' | ||
<small>'''Input Tonnage''' | |||
{|class="wikitable" | {|class="wikitable" | ||
! Calendar Year !! Tonnage In !! Percent of Capacity | ! Calendar Year !! Tonnage In !! Percent of Capacity | ||
| Line 48: | Line 50: | ||
|2018||{{formatnum:{{#external_value:tin18}}}}||{{#external_value:cappc18}}% | |2018||{{formatnum:{{#external_value:tin18}}}}||{{#external_value:cappc18}}% | ||
|} | |} | ||
'''Ash Output''' | '''Ash Output Tonnage''' | ||
{|class="wikitable" | {|class="wikitable" | ||
! Calendar Year !! Ash Code !! Tonnage | ! Calendar Year !! Ash Code !! Tonnage !! %ge of Tonnes In | ||
|- | |- | ||
| rowspan=4 |2018 || [[19 01 11*]] ||{{formatnum:{{#external_value:ash11}}}} | | rowspan=4 |2018 || [[19 01 11*]] ||{{formatnum:{{#external_value:ash11}}}}|| {{formatnum:{{#expr: floor(({{#external_value:ash11}}/{{#external_value:tin18}})*100)}}}}% | ||
|- | |- | ||
| [[19 01 12]]||{{formatnum:{{#external_value:ash12}}}} | | [[19 01 12]]||{{formatnum:{{#external_value:ash12}}}}|| {{formatnum:{{#expr: floor(({{#external_value:ash12}}/{{#external_value:tin18}})*100)}}}}% | ||
|- | |- | ||
| [[19 01 13*]]||{{formatnum:{{#external_value:ash13}}}} | | [[19 01 13*]]||{{formatnum:{{#external_value:ash13}}}}|| {{formatnum:{{#expr: floor(({{#external_value:ash13}}/{{#external_value:tin18}})*100)}}}}% | ||
|- | |- | ||
| [[19 01 14]]||{{formatnum:{{#external_value:ash14}}}} | | [[19 01 14]]||{{formatnum:{{#external_value:ash14}}}}|| {{formatnum:{{#expr: floor(({{#external_value:ash14}}/{{#external_value:tin18}})*100)}}}}% | ||
|} | |}</small> | ||
'''Local Authority Dataset''' | '''Local Authority Dataset''' | ||
<small>'''Input Tonnage''' | |||
{|class='wikitable' | {|class='wikitable' | ||
!Financial Year!! Tonnage In | !Financial Year!! Tonnage In | ||
|- | |- | ||
|2018/19||{{formatnum:{{#external_value:lain18}}}} | |2018/19||{{formatnum:{{#external_value:lain18}}}} | ||
|} | |}</small> | ||
<small>Summary site information collated from a variety of sources<br /> | <small>Summary site information collated from a variety of sources<br /> | ||
including: Monksleigh[http://www.monksleigh.com], Tolvik[https://www.tolvik.com], [[EA]], [[WasteDataFlow]], [[SEPA]], [[NRW]], [[DEFRA]], [[BEIS]] <br /> | including: Monksleigh[http://www.monksleigh.com], Tolvik[https://www.tolvik.com], [[EA]], [[WasteDataFlow]], [[SEPA]], [[NRW]], [[DEFRA]], [[BEIS]] <br /> | ||
and owner and developer websites</small> | and owner and developer websites</small> | ||
</div> | </div> | ||
Revision as of 15:02, 26 February 2020
The query SELECT site,epr,operator,cap,tin17,tin18,cappct17,cappc18,r1,r1_date,r1_value,mwe,chp,techtype,funding,status,lain18,ash11,ash12,ash13,ash14 FROM `efwdb` WHERE epr='{{{EPR}}}' is invalid (Error 1054: Unknown column 'tin17' in 'field list' Function: EDConnectorRdbms::fetch Query: SELECT site,epr,operator,cap,tin17,tin18,cappct17,cappc18,r1,r1_date,r1_value,mwe,chp,techtype,funding,status,lain18,ash11,ash12,ash13,ash14 FROM `efwdb` WHERE epr='{{{EPR}}}' ).
| Error: no local variable "site" has been set. Error: no local variable "status" has been set. | |
| [[File:output_{{{id}}}.png|400px|center|Site Location]]
See Residual EfW → page for a larger UK Wide map. | |
| Waste Licence | Error: no local variable "epr" has been set. |
| Operator | [[Error: no local variable "operator" has been set.]] |
| Operational Capacity | Error: no local variable "cap" has been set.ktpa |
| Is site R1? | Error: no local variable "r1" has been set. |
| When was R1 Granted? | Error: no local variable "r1_date" has been set. |
| What was the R1 value | Error: no local variable "r1_value" has been set. |
| Electrical Capacity | Error: no local variable "mwe" has been set.MWe |
| CHP | Error: no local variable "chp" has been set. |
| Technology Approach | Error: no local variable "techtype" has been set. |
| Funding Type | [[Error: no local variable "funding" has been set.]] |
Historical Tonnage
Environment Agency Dataset
Input Tonnage
| Calendar Year | Tonnage In | Percent of Capacity |
|---|---|---|
| 2017 | Error: no local variable "tin17" has been set. | Error: no local variable "cappct17" has been set.% |
| 2018 | Error: no local variable "tin18" has been set. | Error: no local variable "cappc18" has been set.% |
Ash Output Tonnage
| Calendar Year | Ash Code | Tonnage | %ge of Tonnes In |
|---|---|---|---|
| 2018 | 19 01 11* | Error: no local variable "ash11" has been set. | Expression error: Unexpected < operator.% |
| 19 01 12 | Error: no local variable "ash12" has been set. | Expression error: Unexpected < operator.% | |
| 19 01 13* | Error: no local variable "ash13" has been set. | Expression error: Unexpected < operator.% | |
| 19 01 14 | Error: no local variable "ash14" has been set. | Expression error: Unexpected < operator.% |
Local Authority Dataset
Input Tonnage
| Financial Year | Tonnage In |
|---|---|
| 2018/19 | Error: no local variable "lain18" has been set. |
Summary site information collated from a variety of sources
including: Monksleigh[1], Tolvik[2], EA, WasteDataFlow, SEPA, NRW, DEFRA, BEIS
and owner and developer websites