Converting KOPRA data into Opasnet Base: Difference between revisions
Juha Villman (talk | contribs) (added chemical composition) |
|||
(6 intermediate revisions by 2 users not shown) | |||
Line 77: | Line 77: | ||
|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 | |||
}} | |||
==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 | |||
|roww=? | |||
|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?{{disclink|Should we use WHO country codes?}}) | |||
{{loc | |||
|id=running number | |||
|std_id=? | |||
|obj_id_i=Country id (always same) | |||
|location=WHO code? | |||
|roww=? | |||
|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 | |||
|roww=? | |||
|description=AGR (agriculture) | |||
}} | |||
[[Category:Opasnet Base]] | |||
== See also == | |||
{{Opasnet Base}} |
Latest revision as of 20:29, 10 April 2015
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↷)
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
id | ? |
Ident | ? |
Name | Emission source |
Unit | ? |
Objtype_id | object type: 6 (index) |
Page | ? |
Wiki_id | 1 |
Newest | ? |
We need 11 Locations for this index:
id | running number |
Std_id | ? |
Obj_id_i | Emission source id (always same) |
Location | AGR |
Rowww | ? |
Description | AGR (agriculture) |
See also
Pages related to Opasnet Base |
Opasnet Base · Uploading to Opasnet Base · Data structures in Opasnet · Opasnet Base UI · Modelling in Opasnet · Special:Opasnet Base Import · Opasnet Base Connection for R (needs updating) · Converting KOPRA data into Opasnet Base · Poll · Working with sensitive data · Saved R objects |
Pages related to the 2008-2011 version of Opasnet Base |
Opasnet base connection for Analytica · Opasnet base structure · Related Analytica file (old version File:Transferring to result database.ANA) · Analytica Web Player · Removed pages and other links · Standard run · OpasnetBaseUtils |