Template:EfWTemplate: Difference between revisions
No edit summary |
No edit summary |
||
Line 41: | Line 41: | ||
<small> | <small> | ||
{|class="wikitable" | {|class="wikitable" | ||
|-{{# | |-{{#if: {{#expr: {{#external_value:line}} > 0}} | | style="display:none;" }} | ||
|Number of Lines | |Number of Lines | ||
|style="text-align:right;"|{{formatnum:{{#external_value:line}}}} | |style="text-align:right;"|{{formatnum:{{#external_value:line}}}} |
Revision as of 10:41, 28 September 2020
The query SELECT site,epr,operator,cap,tin17,tin18,cappct17,cappc18,r1,r1_date,r1_value,mwe,chp,techtype,funding,status,line,turbines,mwth,mwel,lacw19,cni19,haz19,clin19,rdf19,other,tin19,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,line,turbines,mwth,mwel,lacw19,cni19,haz19,clin19,rdf19,other,tin19,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.]] |
Operators Annual Report
Number of Lines | Error: no local variable "line" has been set. |
Number of Turbines | Error: no local variable "turbines" has been set. |
MW Thermal Rating | Error: no local variable "mwth" has been set. |
MW Electric Rating | Error: no local variable "mwel" has been set. |
Waste Received | |
Waste Type | 2019 |
Local Authority | Error: no local variable "lacw19" has been set. |
Commercial & Industrial | Error: no local variable "cni19" has been set. |
Hazardous | Error: no local variable "haz19" has been set. |
Clinical | Error: no local variable "clin19" has been set. |
Refuse Derived Fuel | Error: no local variable "rdf19" has been set. |
Other | Error: no local variable "other" has been set. |
Total Received | Error: no local variable "tin19" 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