Difference between revisions of "Converting KOPRA data into Opasnet Base"

From Testiwiki
Jump to: navigation, search
(→‎Emission source)
 
(11 intermediate revisions by 2 users not shown)
Line 7: Line 7:
 
{{Obj
 
{{Obj
 
|id=?
 
|id=?
−
|ident=?
+
|ident=Op_en3679
 
|name=Longitude
 
|name=Longitude
−
|objtype_id=object type: index (6) or dimension (2) ?
+
|unit=Decimal degree
−
|page=wikipage number? do we have one?
+
|objtype_id=object type: 6 (index)
−
|wiki_id=Heande (6) or Opasnet (1)
+
|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
 +
|roww=?
 +
|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=?}}
 
|newest=?}}
  
Line 17: Line 45:
  
 
For each '''unique''' point we need a location
 
For each '''unique''' point we need a location
 +
 +
{{loc
 +
|id=running number
 +
|std_id=?
 +
|obj_id_i=Latitude_id (always same)
 +
|location=exact point
 +
|roww=?
 +
|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
 +
|roww=?
 +
|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


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

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

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

Retrieved from "http://www.opasnet.org/testiwiki/index.php?title=Converting_KOPRA_data_into_Opasnet_Base&oldid=35365"