Pollutant 1: Difference between revisions
mNo edit summary |
mNo edit summary |
||
Line 6: | Line 6: | ||
{| {{prettytable}} | {| {{prettytable}} | ||
|'''Pollutant 1'''<br> (link shows other indices using the same location) | |||
|---- | |---- | ||
| {{indexlink|NOx}} | | {{indexlink|NOx}} | ||
|---- | |---- | ||
| {{indexlink|SOx}} | | {{indexlink|SOx}} | ||
|---- | |---- | ||
| {{indexlink|VOC}} | | {{indexlink|VOC}} | ||
|---- | |---- | ||
| {{indexlink|NH3}} | | {{indexlink|NH3}} | ||
|---- | |---- | ||
| {{indexlink|CO2}} | | {{indexlink|CO2}} | ||
|---- | |---- | ||
| {{indexlink|PM2.5}} | | {{indexlink|PM2.5}} | ||
|---- | |---- | ||
| {{indexlink|PM10}} | | {{indexlink|PM10}} | ||
|---- | |---- | ||
| {{indexlink|CH4}} | | {{indexlink|CH4}} | ||
|---- | |---- | ||
| {{indexlink|CO}} | | {{indexlink|CO}} | ||
|---- | |---- | ||
| {{indexlink|N2O}} | | {{indexlink|N2O}} | ||
|---- | |---- | ||
| {{indexlink|SF6}} | | {{indexlink|SF6}} | ||
|---- | |---- | ||
| {{indexlink|HFC}} | | {{indexlink|HFC}} | ||
|---- | |---- | ||
| {{indexlink|As}} | | {{indexlink|As}} | ||
|---- | |---- | ||
| {{indexlink|Cd}} | | {{indexlink|Cd}} | ||
|---- | |---- | ||
| {{indexlink|Cr}} | | {{indexlink|Cr}} | ||
|---- | |---- | ||
| {{indexlink|Cu}} | | {{indexlink|Cu}} | ||
|---- | |---- | ||
| {{indexlink|Hg}} | | {{indexlink|Hg}} | ||
|---- | |---- | ||
| {{indexlink|Ni}} | | {{indexlink|Ni}} | ||
|---- | |---- | ||
| {{indexlink|Pb}} | | {{indexlink|Pb}} | ||
|---- | |---- | ||
| {{indexlink|POPs}} | | {{indexlink|POPs}} | ||
|---- | |---- | ||
|} | |} |
Revision as of 20:07, 10 December 2008
Metadata for this index (please use these attributes in Analytica and Result database) | |
Ind_name (identifier in Analytica) | Wik_id |
Op_en2692 | 1 |
Category:Index]]
Dimension: Pollutants
Pollutant 1 (link shows other indices using the same location) | |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "NOx" |
NOx
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "SOx" |
SOx
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "VOC" |
VOC
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "NH3" |
NH3
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "CO2" |
CO2
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "PM2.5" |
PM2.5
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "PM10" |
PM10
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "CH4" |
CH4
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "CO" |
CO
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "N2O" |
N2O
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "SF6" |
SF6
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "HFC" |
HFC
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "As" |
As
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "Cd" |
Cd
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "Cr" |
Cr
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "Cu" |
Cu
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "Hg" |
Hg
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "Ni" |
Ni
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "Pb" |
Pb
}} |
{{#sql-query:
SELECT Ind.Ident, Ind.Name, Dim.Name as Dimension_name, Loct as Location FROM Obj as Ind, Obj as Dim, Loc, Roww WHERE Ind.id = Roww.Obj_id_i AND Loc.id = Roww.Loc_id AND Dim.id = Loc.Obj_id_d AND Loct= "POPs" |
POPs
}} |