Non-Hazardous Landfill: Difference between revisions

← Older edit Newer edit →

VisualWikitext

@@ Line 77: / Line 77: @@
 |}
-==Operational Landfill==
+==Non-Hazardous Landfill Capacity==
+===England===
+All data 2020<ref>[https://data.gov.uk/dataset/237825cb-dc10-4c53-8446-1bcd35614c12/remaining-landfill-capacity EA Remaining Landfill Capacity]</ref>.
 {{#clear_external_data:}}
-{{#get_db_data: db=engy |from=nhlandfill |data=site=site,id=id,operator=operator}}
+{{#get_db_data:
+ db=engy
+ |from=lfvoidrgn
+ |where=year=2020 and class='Non-Hazardous Landfill' and cntry = 'England'
+ |data=rgn=rgn, num=num, void=void, avgvoid=avgvoid
+ |order by=rgn
+ |suppress error
+}}
+{| class="wikitable"
+   ! Region !! Number of Sites !! Total Void (m<sup>3</sup>) !! Average Void per site (m<sup>3</sup>){{#for_external_table:<nowiki/>
+   {{!}}-
+   {{!}} {{{rgn}}}
+   {{!}} {{{num}}}
+   {{!}} {{{void}}}
+   {{!}} {{{avgvoid}}}
+  }}
+|}
-[[File:Landlfill_map.png|600px|right]]
+===Scotland===
-{|Class="wikitable sortable"
+{{#clear_external_data:}}
-! ID !! Site Name !! Operator
+{{#get_db_data:
-{{#for_external_table:<nowiki/>
+ db=engy
-{{!}}-
+ |from=lfvoidrgn
-{{!}} {{{id}}}.
+ |where=year=2019 and class='Non-Hazardous Landfill' and cntry = 'Scotland'
-{{!}} [[{{{site}}}]]
+ |data=rgn=rgn, num=num, void=void, avgvoid=avgvoid
-{{!}} [[{{{operator}}}]]
+ |order by=rgn
+ |suppress error
 }}
+{| class="wikitable"
+   ! Region !! Number of Sites !! Total Void (t) !! Average Void per site (t){{#for_external_table:<nowiki/>
+   {{!}}-
+   {{!}} {{{rgn}}}
+   {{!}} {{{num}}}
+   {{!}} {{{void}}}
+   {{!}} {{{avgvoid}}}
+  }}
 |}
-<br clear="all" />
+===Wales===
+{{#clear_external_data:}}
+{{#get_db_data:
+ db=engy
+ |from=lfvoidrgn
+ |where=year=2018 and class='Non-Hazardous Landfill' and cntry = 'Wales'
+ |data=rgn=rgn, num=num, void=void, avgvoid=avgvoid
+ |order by=rgn
+ |suppress error
+}}
+{| class="wikitable"
+   ! Region !! Number of Sites !! Total Void (m<sup>3</sup>) !! Average Void per site (m<sup>3</sup>){{#for_external_table:<nowiki/>
+   {{!}}-
+   {{!}} {{{rgn}}}
+   {{!}} {{{num}}}
+   {{!}} {{{void}}}
+   {{!}} {{{avgvoid}}}
+  }}
+|}
+==Operational Landfill==
 ==References==
 <references />