Template:EfWTemplate: Difference between revisions

Revision as of 13:21, 9 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

	2019
Number of Lines:	[[Error: no local variable "line" has been set.]]
turbines
mwth
mwel
lacw19
cni19
haz19
clin19
rdf19
other
tin19

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

@@ Line 1: / Line 1: @@
 {{#clear_external_data:}}
-{{#get_db_data: db=engy |from=efwdb |where=epr='{{{EPR}}}' |data=site=site,epr=epr,operator=operator,cap=cap,tin17=tin17,tin18=tin18,cappct17=cappct17,cappc18=cappc18,r1=r1,r1_date=r1_date,r1_value=r1_value,mwe=mwe,chp=chp,techtype=techtype,funding=funding,status=status,lain18=lain18,ash11=ash11,ash12=ash12,ash13=ash13,ash14=ash14}}
+{{#get_db_data: db=engy |from=efwdb |where=epr='{{{EPR}}}' | data=site=site,epr=epr,operator=operator,cap=cap,tin17=tin17,tin18=tin18,cappct17=cappct17,cappc18=cappc18,r1=r1,r1_date=r1_date,r1_value=r1_value,mwe=mwe,chp=chp,techtype=techtype,funding=funding,status=status,line=line,turbines=turbines,mwth=mwth,mwel=mwel,lacw19=lacw19,cni19=cni19,haz19=haz19,clin19=clin19,rdf19=rdf19,other=other,tin19=tin19,lain18=lain18,ash11=ash11,ash12=ash12,ash13=ash13,ash14=ash14}}
 <div style="float:right;">
 {|class="wikitable"
@@ Line 40: / Line 40: @@
 <big>'''Operators Annual Report'''</big>
 {|class="wikitable"
-|line
+! !! 2019
+|-
+|Number of Lines:
+|[[{{#external_value:line}}]]
 |-
 |turbines