Pollutant 1: Difference between revisions
(first draft based on Alex's model) |
mNo edit summary |
||
| Line 10: | Line 10: | ||
|---- | |---- | ||
| NOx | | NOx | ||
| {{indexlink| | | {{indexlink|NOx}} | ||
|---- | |---- | ||
| SOx | | SOx | ||
Revision as of 19:39, 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 | Other indices using this location | |
|---|---|---|
| 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= "NOx" |
NOx
}} |
| 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= "SOx" |
SOx
}} |
| 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= "VOC" |
VOC
}} |
| 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= "NH3" |
NH3
}} |
| 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= "CO2" |
CO2
}} |
| 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= "PM2.5" |
PM2.5
}} |
| 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= "PM10" |
PM10
}} |
| 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= "CH4" |
CH4
}} |
| 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= "CO" |
CO
}} |
| 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= "N2O" |
N2O
}} |
| 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= "SF6" |
SF6
}} |
| 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= "HFC" |
HFC
}} |
| 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= "As" |
As
}} |
| 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= "Cd" |
Cd
}} |
| 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= "Cr" |
Cr
}} |
| 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= "Cu" |
Cu
}} |
| 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= "Hg" |
Hg
}} |
| 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= "Ni" |
Ni
}} |
| 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= "Pb" |
Pb
}} |
| POPs | {{#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
}} |