Template:EAIn: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
{{#clear_external_data:}}{{#get_db_data: db=mnk|from=db_ea.ea_ew_in|where=epr='{{{EPR}}}'|limit=1|data=updated=updated}}{{#vardefine: update|{{#external_value:updated}}}}{{#clear_external_data:}}{{#get_db_data: db=mnk|from=db_ea.ea_ton_in|where=epr='{{{EPR}}}'|data=opt=tin}}{{#vardefine: total| {{#external_value:opt}}}}{{#clear_external_data:}}{{#get_db_data: db=mnk|from=db_ea.ea_ew_in|where=epr='{{{EPR}}}'|data=ewc=ewc,originregion=origin,tin=tin}} | {{#clear_external_data:}}{{#get_db_data: db=mnk|from=db_ea.ea_ew_in|where=epr='{{{EPR}}}'|limit=1|data=updated=updated}}{{#vardefine: update|{{#external_value:updated}}}}{{#clear_external_data:}}{{#get_db_data: db=mnk|from=db_ea.ea_ton_in|where=epr='{{{EPR}}}'|data=opt=tin}}{{#vardefine: total| {{#external_value:opt}}}}{{#clear_external_data:}}{{#get_db_data: db=mnk|from=db_ea.ea_ew_in|where=epr='{{{EPR}}}'|data=ewc=ewc,originregion=origin,tin=tin}} | ||
==Waste Tonnage, By Origin== | ==Waste Tonnage, By Origin== | ||
The table shows a list of the [[Waste]] for the [[WML|Permit]] {{{EPR}}}, that has arrived into sites as reported to the [[Regulator]] and then publicised in their reported statistics. {{#iferror: {{#var:update}}| The Data used is from the most recent returns | The Data was last updated on {{#var:update}}}}. The total reported tonnage arriving at the site was: '''{{#if: {{#var:total}} | {{formatnum: {{#expr: {{#var:total}} round 2}} }}t | 0t }}'''. Where this tonnage exceeds that reported in year of the corresponding annual report, this may be due to the following reasons: | The table shows a list of the [[Waste]] for the [[WML|Permit]] {{{EPR}}}, that has arrived into sites as reported to the [[Regulator]] and then publicised in their reported statistics. {{#iferror: {{#var:update}}| The Data used is from the most recent returns | The Data was last updated on {{#var:update}}}}. The total reported tonnage arriving at the site was: '''{{#if: {{#var:total}} | {{formatnum: {{#expr: {{#var:total}} round 2}} }}t | 0t }}'''. | ||
Where this tonnage exceeds that reported in year of the corresponding annual report, this may be due to the following reasons: | |||
* Tonnage may have been received but not [[incineration|incinerated]], i.e. the material is held pending [[incineration]] (the operator return to the [[EA]] reports as received whereas the annual report focuses on when the waste is incinerated.) | * Tonnage may have been received but not [[incineration|incinerated]], i.e. the material is held pending [[incineration]] (the operator return to the [[EA]] reports as received whereas the annual report focuses on when the waste is incinerated.) | ||
* Material may have been received into the site but [[treatment|treated]] in some other way than [[incineration]]. | * Material may have been received into the site but [[treatment|treated]] in some other way than [[incineration]]. | ||
Latest revision as of 11:40, 16 July 2024
The query SELECT "updated" FROM "db_ea"."ea_ew_in" WHERE epr='{{{EPR}}}' LIMIT 1 is invalid (Error : SSL SYSCALL error: EOF detected
Function: EDConnectorRdbms::fetch Query: SELECT "updated" FROM "db_ea"."ea_ew_in" WHERE epr='{{{EPR}}}' LIMIT 1 ).Error: Could not connect to database (Cannot access the database: Unable to connect to PostgreSQL server: connection to server at "10.106.0.2", port 5432 failed: FATAL: the database system is in recovery mode).Error: Could not connect to database (Cannot access the database: Unable to connect to PostgreSQL server: connection to server at "10.106.0.2", port 5432 failed: FATAL: the database system is in recovery mode).
Waste Tonnage, By Origin
The table shows a list of the Waste for the Permit {{{EPR}}}, that has arrived into sites as reported to the Regulator and then publicised in their reported statistics. The Data used is from the most recent returns. The total reported tonnage arriving at the site was: Expression error: Unexpected < operator.t.
Where this tonnage exceeds that reported in year of the corresponding annual report, this may be due to the following reasons:
- Tonnage may have been received but not incinerated, i.e. the material is held pending incineration (the operator return to the EA reports as received whereas the annual report focuses on when the waste is incinerated.)
- Material may have been received into the site but treated in some other way than incineration.
- Material may have been received on the but transferred out of site for disposal/treatment at another site rather than incineration on the site.
| EWC Code | Origin of Waste | Tonnes In |
|---|
Table to display the waste received listed by by region of origin, Incineration Plants