Western Riverside Waste Disposal Authority: Difference between revisions

← Older edit Newer edit →

VisualWikitext

@@ Line 1: / Line 1: @@
 WRWDA
-{{#clear_external_dispmetrics |where=gsscode={{#var: gss}}:}}[[Category:Disposal]]
+{{#clear_external_data:}}[[Category:Disposal]]
-{{#get_db_dispmetrics |where=gsscode={{#var: gss}}: db=dmet |from=dispmetrics |where=gsscode='wrwda' |dispmetrics |where=gsscode={{#var: gss}}=area=area,arearnk=arearnk, pop=pop, poprnk=poprnk, ppha=ppha, ppharnk, res=res, resrnk=resrnk,  grn=grn, grnrnk=grnrnk,food=food, fdrnk=fdrnk, dry=dry, dryrnk=dryrnk, recypc=recypc, recypcrnk=recypcrnk, respp=respp, respprnk=respprnk, respha=respha, respharnk=respharnk, orgpp=orgpp, orgpprnk=orgpprnk, foodpp=foodpp, fdpprnk=fdpprnk, hwrc=hwrc, hwrcrnk=hwrcrnk, pophwrc=pophwrc, pophwrcrnk=pophwrcrnk, hwrcpha=hwrcpha, hpharnk=hpharnk, res2lfpc=res2lfpc, r2lfrnk=r2lfrnk, w2epc=w2epc, w2ernk=w2ernk}}
+{{#get_db_data: db=dmet |from=dispmetrics |where=gsscode='wrwda' |data=area=area,arearnk=arearnk, pop=pop, poprnk=poprnk, ppha=ppha, ppharnk, res=res, resrnk=resrnk,  grn=grn, grnrnk=grnrnk,food=food, fdrnk=fdrnk, dry=dry, dryrnk=dryrnk, recypc=recypc, recypcrnk=recypcrnk, respp=respp, respprnk=respprnk, respha=respha, respharnk=respharnk, orgpp=orgpp, orgpprnk=orgpprnk, foodpp=foodpp, fdpprnk=fdpprnk, hwrc=hwrc, hwrcrnk=hwrcrnk, pophwrc=pophwrc, pophwrcrnk=pophwrcrnk, hwrcpha=hwrcpha, hpharnk=hpharnk, res2lfpc=res2lfpc, r2lfrnk=r2lfrnk, w2epc=w2epc, w2ernk=w2ernk}}
 == Demographic Information ==
@@ Line 22: / Line 22: @@
 |Population<ref>Source: ONS mid 2018 projection</ref>|| style='text-align:right;' | {{formatnum: {{#external_value:pop}}}}
 |-
-|Land Area (ha)<ref>Source: Ordnance Survey boundry line dispmetrics |where=gsscode={{#var: gss}} 2019</ref>|| style='text-align:right;' | {{formatnum: {{#external_value:area}}}}
+|Land Area (ha)<ref>Source: Ordnance Survey boundry line data 2019</ref>|| style='text-align:right;' | {{formatnum: {{#external_value:area}}}}
 |-
 |Population per ha|| style='text-align:right;' | {{#external_value:ppha}}
@@ Line 28: / Line 28: @@
 ==[[Key Metrics]]==
-{{#clear_external_dispmetrics |where=gsscode={{#var: gss}}:}}
+{{#clear_external_data:}}
-{{#get_db_dispmetrics |where=gsscode={{#var: gss}}: db=dmet |from=dispmetrics |where=gsscode={{#var: gss}}|dispmetrics |where=gsscode={{#var: gss}}=hwrc=hwrc, pophwrc=pophwrc, hwrcpha=hwrcpha}}
+{{#get_db_data: db=dmet |from=dispmetrics |where=gsscode='S12000033' |data=hwrc=hwrc, pophwrc=pophwrc, hwrcpha=hwrcpha}}
 ===[[Household Waste Recycling Centres]] ([[HWRC]])===
 {| class=wikitable
@@ Line 50: / Line 50: @@
 ==Destination Information==
 === Significant Tonnage Summary<ref>Tonnages under 2000 tonnes have been screened out.</ref> ===
-{{#clear_external_dispmetrics |where=gsscode={{#var: gss}}:}}
+{{#clear_external_data:}}
-{{#get_db_dispmetrics |where=gsscode={{#var: gss}}: db=disp |from=disposal |where=gsscode='wrwda' and tonnage >= 2000|order by=stream, tonnage desc|dispmetrics |where=gsscode={{#var: gss}}=stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage}}
+{{#get_db_data: db=disp |from=disposal |where=gsscode='wrwda' and tonnage >= 2000|order by=stream, tonnage desc|data=stream=stream,type=type,operator=operator,address=address,material=material,tonnage=tonnage}}
 {| class=wikitable
 ! Stream