Soil, Rubble, Hardcore: Difference between revisions

 
(6 intermediate revisions by the same user not shown)
Line 26: Line 26:


== Rubble ==
== Rubble ==
Below is a list of local authorities that sends more than 20,000 tonnes of this material to a single waste operator.
Below is a list of local authorities that sends more than 7,000 tonnes of this material to a single waste operator.
{{#clear_external_data:}}
{{#clear_external_data:}}
{{#get_db_data: db=disp |from=disposal |where=material='Rubble' and tonnage >= 20000|order by=tonnage desc|data=authority=authority,stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage}}
{{#get_db_data: db=disp |from=disposal |where=material='Rubble' and tonnage >= 7000|order by=tonnage desc|data=authority=authority,stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage,date=date}}
{| class=wikitable
{| class=wikitable
! Authority
! Authority
Line 37: Line 37:
! Material
! Material
! Tonnes
! Tonnes
{{#display_external_table:template=Diposaltable‎|data=authority=authority,stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage}}
! Reporting Period
{{#display_external_table:template=Diposaltable‎|data=authority=authority,stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage,date=date}}
|}
|}


Line 57: Line 58:


== Soil ==
== Soil ==
Below is a list of local authorities that sends more than 10000 tonnes of this material to a single waste operator.
Below is a list of local authorities that sends more than 2000 tonnes of this material to a single waste operator.
{{#clear_external_data:}}
{{#clear_external_data:}}
{{#get_db_data: db=disp |from=disposal |where=material='Soil' and tonnage >= 10000|order by=tonnage desc|data=authority=authority,stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage}}
{{#get_db_data: db=disp |from=disposal |where=material='Soil' and tonnage >= 2000|order by=tonnage desc|data=authority=authority,stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage, date=date}}
{| class=wikitable
{| class=wikitable
! Authority
! Authority
Line 68: Line 69:
! Material
! Material
! Tonnes
! Tonnes
{{#display_external_table:template=Diposaltable‎|data=authority=authority,stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage}}
! Reporting Period
{{#display_external_table:template=Diposaltable‎|data=authority=authority,stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage,date=date}}
|}
|}


== References ==
== References ==
<references />
<references />