Template:EfWTemplate: Difference between revisions

From Wikiwaste
No edit summary
No edit summary
Line 41: Line 41:
<small>
<small>
{|class="wikitable"
{|class="wikitable"
|- {{#if {{#external_value:line}} | | style="display:none;"}}
|-  
|Number of Lines
|Number of Lines
|style="text-align:right;"|{{#external_value:line}}
|style="text-align:right;"|{{#external_value:line}}
|- {{#if {{#external_value:turbines}} || style="display:none;"}}
|-  
|Number of Turbines
|Number of Turbines
|style="text-align:right;"|{{#external_value:turbines}}
|style="text-align:right;"|{{#external_value:turbines}}
|- {{#if {{#external_value:mwth}} | | style="display:none;"}}
|-  
|MW Thermal Rating
|MW Thermal Rating
|style="text-align:right;"|{{#external_value:mwth}}
|style="text-align:right;"|{{#external_value:mwth}}
|- {{#if {{#external_value:mwel}} | | style="display:none;"}}
|-  
|MW Electric Rating
|MW Electric Rating
|{{#external_value:mwel}}
|{{#external_value:mwel}}
Line 57: Line 57:
|-
|-
|Waste Type || 2019
|Waste Type || 2019
|- {{#if {{#external_value:lacw19}} | | style="display:none;"}}
|-  
|Local Authority
|Local Authority
|{{#external_value:lacw19}}
|{{#external_value:lacw19}}
|- {{#if {{#external_value:cni19}} | | style="display:none;"}}
|-  
|Commercial & Industrial
|Commercial & Industrial
|{{#external_value:cni19}}
|{{#external_value:cni19}}
|- {{#if {{#external_value:haz19}} | | style="display:none;"}}
|-  
|Hazardous
|Hazardous
|{{#external_value:haz19}}
|{{#external_value:haz19}}
|- {{#if {{#external_value:clin19}} | | style="display:none;"}}
|-  
|Clinical
|Clinical
|{{#external_value:clin19}}
|{{#external_value:clin19}}
|- {{#if {{#external_value:rdf19}} | | style="display:none;"}}
|-  
|Refuse Derived Fuel
|Refuse Derived Fuel
|{{#external_value:rdf19}}
|{{#external_value:rdf19}}
|- {{#if {{#external_value:other}} | | style="display:none;"}}
|-  
|Other
|Other
|{{#external_value:other}}
|{{#external_value:other}}
|- {{#if {{#external_value:tin19}} | | style:"display:none;"}}
|-  
|Total Received
|Total Received
|{{#external_value:tin19}}
|{{#external_value:tin19}}

Revision as of 12:02, 12 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