Longitude
We need to define Longitude into Opasnet Base:
OBJ
id
|
?
|
Ident
|
Op_en3679
|
Name
|
Longitude
|
Unit
|
Decimal degree
|
Objtype_id
|
object type: 6 (index)
|
Page
|
3679
|
Wiki_id
|
1
|
Newest
|
?
|
- Several thousands of points
For each unique point we need a location
Loc
id
|
running number
|
Std_id
|
?
|
Obj_id_i
|
Longitude_id (always same)
|
Location
|
exact point
|
Rowww
|
?
|
Description
|
?
|
Latitude
We need to define Latitude into Opasnet Base:
OBJ
id
|
?
|
Ident
|
Op_en3680
|
Name
|
Latitude
|
Unit
|
Decimal degree
|
Objtype_id
|
object type: 6 (index)
|
Page
|
3680
|
Wiki_id
|
1
|
Newest
|
?
|
- Several thousands of points
For each unique point we need a location
Loc
id
|
running number
|
Std_id
|
?
|
Obj_id_i
|
Latitude_id (always same)
|
Location
|
exact point
|
Rowww
|
?
|
Description
|
?
|
Chemical composition
OBJ
id
|
?
|
Ident
|
|
Name
|
Chemical composition
|
Unit
|
?
|
Objtype_id
|
object type: 6 (index)
|
Page
|
?
|
Wiki_id
|
1
|
Newest
|
?
|
For this index we need 4 locations (PM, SO2,SO4 and NO):
Loc
id
|
running number
|
Std_id
|
?
|
Obj_id_i
|
Chemical composition id (always same)
|
Location
|
PM, SO2,SO4 or NO
|
Rowww
|
?
|
Description
|
?
|
Size fraction
OBJ
id
|
?
|
Ident
|
|
Name
|
Size fraction
|
Unit
|
?
|
Objtype_id
|
object type: 6 (index)
|
Page
|
?
|
Wiki_id
|
1
|
Newest
|
?
|
For this index we need 7 locations:
Loc
id
|
running number
|
Std_id
|
?
|
Obj_id_i
|
Size fraction id (always same)
|
Location
|
PM0.1, PM0.1-1.0, PM1.0-2.5, PM2.5-10, PM>10, PM2.5, PM10
|
Rowww
|
?
|
Description
|
particulate matter which size is less than 0,1 micrometer (etc.)
|
Year
Index year need to be created into Opasnet Base:
OBJ
id
|
?
|
Ident
|
Op_en3678
|
Name
|
Year
|
Unit
|
a
|
Objtype_id
|
object type: 6 (index)
|
Page
|
3678
|
Wiki_id
|
1
|
Newest
|
?
|
For this index we need 3 locations (years 2000, 2001 and 2002):
Loc
id
|
running number
|
Std_id
|
?
|
Obj_id_i
|
Year id (always same)
|
Location
|
2000, 2001 or 2002
|
Rowww
|
?
|
Description
|
Year to which concentrations are estimated
|
Month
Index Month need to be created into Opasnet base and Opasnet:
OBJ
id
|
?
|
Ident
|
?
|
Name
|
Month
|
Unit
|
?
|
Objtype_id
|
object type: 6 (index)
|
Page
|
?
|
Wiki_id
|
1
|
Newest
|
?
|
For this we need 13 locations (Jan, Feb..Dec,All):
Loc
id
|
running number
|
Std_id
|
?
|
Obj_id_i
|
Month id (always same)
|
Location
|
Jan, Feb..Dec,All
|
Rowww
|
?
|
Description
|
the average concentration in January
|
Resolution
Index Resolution need to be created into Opasnet and Base:
OBJ
id
|
?
|
Ident
|
?
|
Name
|
Resolution
|
Unit
|
km
|
Objtype_id
|
object type: 6 (index)
|
Page
|
?
|
Wiki_id
|
1
|
Newest
|
?
|
For this we need 3 locations (30 km, 5 km and 1 km)
Loc
id
|
running number
|
Std_id
|
?
|
Obj_id_i
|
Resolution id (always same)
|
Location
|
30, 5, 1
|
Rowww
|
?
|
Description
|
the resolution of data in km
|
Source of emission
Index Country need to be created into Opasnet Base.
OBJ
id
|
?
|
Ident
|
Op_en2868
|
Name
|
Country
|
Unit
|
?
|
Objtype_id
|
object type: 6 (index)
|
Page
|
?
|
Wiki_id
|
1
|
Newest
|
?
|
We need location for every country where data is provided (Should we use WHO country codes instead?D↷)
Loc
id
|
running number
|
Std_id
|
?
|
Obj_id_i
|
Country id (always same)
|
Location
|
WHO code?
|
Rowww
|
?
|
Description
|
WHO classification of countries?
|
Emission source
Index Emission source is needed in Opasnet and Base
OBJ
id
|
?
|
Ident
|
?
|
Name
|
Emission source
|
Unit
|
?
|
Objtype_id
|
object type: 6 (index)
|
Page
|
?
|
Wiki_id
|
1
|
Newest
|
?
|
We need 11 Locations for this index:
Loc
id
|
running number
|
Std_id
|
?
|
Obj_id_i
|
Emission source id (always same)
|
Location
|
AGR
|
Rowww
|
?
|
Description
|
AGR (agriculture)
|
See also