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:

For each unique point we need a location

We need to define Latitude into Opasnet Base:

For each unique point we need a location

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	?

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.)

Index year need to be created into Opasnet Base:

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

Index Month need to be created into Opasnet base and Opasnet:

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