Converting KOPRA data into Opasnet Base

This page is a knowledge crystal of subtype method. The page identifier is Op_en3702
Moderator:Juha Villman (see all)
Upload data {{#opasnet_base_link:Op_en3702}}

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)