Difference between revisions of "Converting KOPRA data into Opasnet Base"
From Testiwiki
Juha Villman (talk | contribs) (added chemical composition) |
Juha Villman (talk | contribs) (→Chemical composition) |
||
Line 76: | Line 76: | ||
|roww=? | |roww=? | ||
|description=? | |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 | ||
+ | |roww=? | ||
+ | |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 | ||
+ | |roww=? | ||
+ | |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 | ||
+ | |roww=? | ||
+ | |description=the average concentration in January | ||
}} | }} |
Revision as of 10:56, 22 September 2009
This page is a method.
The page identifier is Op_en3702 |
---|
Moderator:Juha Villman (see all) |
Give your opinion to the peer rating of the content of this page. |
Upload data
|
Longitude
We need to define Longitude into Opasnet Base:
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
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:
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
id | running number |
Std_id | ? |
Obj_id_i | Latitude_id (always same) |
Location | exact point |
Rowww | ? |
Description | ? |
Chemical composition
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):
id | running number |
Std_id | ? |
Obj_id_i | Chemical composition id (always same) |
Location | PM, SO2,SO4 or NO |
Rowww | ? |
Description | ? |
Size fraction
id | ? |
Ident | |
Name | Size fraction |
Unit | ? |
Objtype_id | object type: 6 (index) |
Page | ? |
Wiki_id | 1 |
Newest | ? |
For this index we need 7 locations:
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:
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):
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:
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):
id | running number |
Std_id | ? |
Obj_id_i | Month id (always same) |
Location | Jan, Feb..Dec,All |
Rowww | ? |
Description | the average concentration in January |