Värriö database
Instructions for database access
Database location: db5.csc.fi
Database engine: MySQL
Database: smear
Username and password: Ask from Pasi Aalto
Tables:
- VAR_META, meteorological, gas and soil data at original time resolution
- VAR_DMPS, DMPS data
- VAR_EDDY, flux data
- VAR_TREE, tree gas exchange data
Fields:
- VAR_META:
Field_name | Description |
|---|---|
CPC1 | Particle concentration 9 m level (1/cm^3) |
CPC2 | Particle concentration 6.6 m level (1/cm^3) |
CPC3 | Particle concentration 4.4 m level (1/cm^3) |
CPC4 | Particle concentration 2.2 m level (1/cm^3) |
GLOB | Global radiation (W/m^2) |
haildiammax | Hail maximum diameter (mm) |
HUM_RH | Humidity at 2m height (%) |
HUM_T | Temperature at 2 m height (C) |
WS00 | Wind speed 16m level, ultrasonic, heated sensor (m/s) |
NO_0 | Nitrogen monoxide concentration 15 m level (ug/m^3) |
NO_1 | Nitrogen monoxide concentration 9 m level (ug/m^3) |
NO_2 | Nitrogen monoxide concentration 6.6 m level (ug/m^3) |
NO_4 | Nitrogen monoxide concentration 2.2 m level (ug/m^3) |
NOX_0 | Nitrogen oxide concentration 15 m level (ug/m^3) |
NOX_1 | Nitrogen oxide concentration 9 m level (ug/m^3) |
NOX_2 | Nitrogen oxide concentration 6.6 m level (ug/m^3) |
NOX_4 | Nitrogen oxide concentration 2.2 m level (ug/m^3) |
O3_0 | Ozone concentration 15 m level (ug/m^3) |
O3_1 | Ozone concentration 9 m level (ug/m^3) |
O3_2 | Ozone concentration 6.6 m level (ug/m^3) |
O3_3 | Ozone concentration 4.4 m level (ug/m^3) |
O3_4 | Ozone concentration 2.2 m level (ug/m^3) |
P | Pressure (hPa) |
PAR | PAR (umol/m^2/s) |
Precipacc | Accumulated preciptation (mm) |
RAIN | Moisture detector (on/off) |
rainint | Rain intensity (mm/h) |
REFL | Reflected radiation (kW/m^2) |
RMM | Rain fall (mm/h) |
samptime | Sample time |
snowint | Intensity solid (mm/h) |
SO2_0 | Sulphur dioxide concentration 15 m level (ug/m^3) |
SO2_1 | Sulphur dioxide concentration 9 m level (ug/m^3) |
SO2_2 | Sulphur dioxide concentration 6.6 m level (ug/m^3) |
SO2_3 | Sulphur dioxide concentration 4.4 m level (ug/m^3) |
SO2_4 | Sulphur dioxide concentration 2.2 m level (ug/m^3) |
ST | Soil temperature 10-20 cm below ground level (C) |
TDRY0 | Temperature 15 m level (C) |
TDRY1 | Temperature 9 m level (C) |
TDRY2 | Temperature 6.6 m level (C) |
TDRY3 | Temperature 4.4 m level (C) |
TDRY4 | Temperature 2.2 m level (C) |
TLOG | Weather logger temperature (C) |
TWET0 | Wet bulb temperature 15 m level (C) |
TWET1 | Wet bulb temperature 9 m level (C) |
TWET2 | Wet bulb temperature 6.6 m level (C) |
TWET3 | Wet bulb temperature 4.4 m level (C) |
TWET4 | Wet bulb temperature 2.2 m level (C) |
H2O_0 | Absolute humidity 15 m level (g/m^3) |
H2O_1 | Absolute humidity 9 m level (g/m^3) |
H2O_2 | Absolute humidity 6.6 m level (g/m^3) |
H2O_3 | Absolute humidity 4.4 m level (g/m^3) |
H2O_4 | Absolute humidity 2.2 m level (g/m^3) |
UVA | UVA radiation (W/m^2) |
UVAT | UVA radiation sensor temperature (C) |
UVB | UVB radiation (W/m^2) |
UVBT | UVB radiation sensor temperature (C) |
visibility | Visibility (km) |
visibilitylpm | Visibility, decrease caused by rain (km) |
WDIR | Wind direction (deg) |
WS0 | Wind speed 15 m level (m/s) |
WS1 | Wind speed 9 m level (m/s) |
WS2 | Wind speed 6.6 m level (m/s) |
WS3 | Wind speed 4.4 m level (m/s) |
WS4 | Wind speed 2.2 m level (m/s) |
wthcode | Synop code |
NET | Net radiation (W/m^2) |
CO206 | CO2 concentration at 0.6 m height |
CO2soil | CO2 concentration in soil air in the uppermost 5 cm |
Tsoil | Temperature at 2 cm depth in soil organic layer (C) |
wsoil | Volumetric water content in the uppermost 5 cm soil |
- VAR_DMPS
Field name | Description |
|---|---|
p1 | DMPS1 pressure (hPa) |
p2 | DMPS2 pressure (hPa) |
rh1 | DMPS1 RH (%) |
rh2 | DMPS2 RH (%) |
samptime | Time |
t1 | DMPS1 temperature (K) |
t2 | DMPS2 temperature (K) |
tconc | Total concentration over the measurement range (1/cm^3) |
dNNN | dN/dlogDp (1/cm^3), NNN is particle diameter in 1e-10 meters |