Converting KOPRA data into Opasnet Base
| Moderator:Juha Villman (see all) |
|
|
| 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 |
Resolution
Index Resolution need to be created into Opasnet and Base:
| 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)
| 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.
| 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↷)