3. Input parameter files, databases and input files

3.1. Inputparameter File

Example of an Input-Parameter-File:

#######################################################################
# Input parameters for NOBOTOULS
# V 0.3.1 2015-10-23
#
# - Comments start with #
# - empty lines, heading and trailing white space characters are ignored
#
# General pattern:
# parameter name ; (semicolon)  further data separated with ;
# NO TRAILING SEMICOLON ALLOWED

# valid key names are:
# dbname outputdir stat statlist startdattim enddattim timedelta
# parameter tl_lim ps_lim rh_lim dd_lim ff_lim
# maptitle maplimits mappickledir
#
#######################################################################

# For: noboplot_alldb.py, noboplot_manny21db.py, nobowindmap.py
# =============================================================

# sqlite-database pathname
dbname; /home/thl/nobotouls/data/nobodb/aichfeld_db.sqlite

# outputdirectory
# outputdir; /home/thl/nobotouls/test/outpics3
outputdir; /home/thl/nobotouls/test/outwindmov2

# start and end date and time as integer (yyyymoddhhmi)
#startdattim;   201505110000
#enddattim;     201506190000
startdattim;   201505181200
enddattim;     201505181800
# time-delta in minutes (needed for some routines)
timedelta; 10

# parameter to plot - valid entries (one!) : tl rh ps dd ff fx
# parameter; rh
# parameter; ps
# parameter; dd
parameter; tl
# parameter; ff
# parameter; fx

# plotlimit for parameters
# valid keys: tl_lim rh_lim ps_lim dd_lim ff_lim
tl_lim; -15; +40
rh_lim; 0; 100
ps_lim; 900; 960
dd_lim; 0; 360
ff_lim; 0; 50
rr_lim; 0; 20

# For noboplot_manny21db.py
# =========================

# stationlist
statlist; fal01; gro01; ham02; jud01; kob01; lor01

# parameter to plot - valid entries (one!) : tl rh ps dd ff fx
parameter; tl
# parameter; rh
# parameter; ps
# parameter; dd
# parameter; ff
# parameter; fx

# For nobowindmap.py
# ==================

# Title/headerline (first part, ASCII ONLY!!, no semicolons allowed)
maptitle; Aichfeld Wind Chart - Testplot

# Map limits:
# min. longitude; max. longitude; min. latitude; max. latitude (deci. degrees)
# maplimits; 14.41466; 15.07701; 47.06861; 47.33861
maplimits; 14.41466; 14.99999; 47.06861; 47.33861

# Map pickle directory (map details once calculated,  frequently used)
mappickledir; /home/thl/nobotouls/test

# For nobowindmap2.py
# ===================
# path to high res. DEM file
dempath; /home/thl/Dokumente/DEM_Data/SRTM3/srtm_39_03/srtm_39_03.asc

# Good for nothing yet
# ====================
# station
stat; POL02

3.2. Database

Data are kept in a sqlite database. Access is programmed with the python 2.7 sqlite3 module. For direct access via the Mozilla Firefox Webbrowser the sqlite plugin SQLite Manager is recommended.

Sqlite was chosen because it is fast and powerful enough for the problem, it is easily available for various platforms, and therefore first choice for decentralized use on single workstations.

For details/download see:

The database consists of three tables:

3.2.1. nobostations

SQLITE-command that created the table:

CREATE TABLE "nobostations" ("stat" PRIMARY KEY NOT NULL UNIQUE ,
"longname" , "lon" DEFAULT 0.0, "lat" DEFAULT 0.0, "elev" DEFAULT
-99., "active" BOOL DEFAULT true)
  • stat: station identifier (typically an uppercase short string, e.g. ‘POL01’)
  • longname: more descriptive station name
  • lon: longitude in decimal degrees (e.g. 12°30’: lon = 12.5)
  • lat: latitudetude in decimal degrees (e.g. 45°30’: lon = 45.5)
  • elev: mean sea level in m
  • active: boolean variable with a flag weathter the station is active or not (default: true)

3.2.2. nobraw

SQLITE-command that created the table:

CREATE TABLE noboraw ('stat' NOT NULL, 'dattim' NOT NULL,
'dattiml', 'timez', 'tl', 'rh', 'ps', 'dd', 'ff', 'fx', PRIMARY
KEY ('stat', 'dattim'))
  • stat: station identifier (typically an uppercase short string,
    e.g. ‘POL01’)
  • dattim: date and time in UTC (e.q. 201505231220)
  • dattiml: local date and time
  • timez: timezone (CEST: timezone = 200)
  • tl: station temperature in Celsius
  • rh: relative humidity in percent
  • ps: station pressure in hPa
  • dd: mean wind direction in degrees (90 .. east, 180 .. south,
    etc. ..)
  • ff: mean wind speed in m/s
  • fx: maximum wind spead in m/s

3.2.3. noborain

SQLITE-command that created the table:

CREATE TABLE 'noborain' ('stat' NOT NULL ,'dattim' NOT NULL ,
'dattiml' ,'timez' ,'rr' ,'obs' BOOL DEFAULT (0), PRIMARY KEY
('stat', 'dattim'))
  • stat: station identifier (typically an uppercase short
    string, e.g. ‘POL01’)
  • dattim: date and time in UTC (e.q. 201505231220)
  • dattiml: local date and time
  • timez: timezone (CEST: timezone = 200)
  • rr: 10 minutes rain sum in mm
  • obs: 1 .. observed, 0 .. not observed

3.3. Inputfiles

Samples of a valid nobo data inputfiles.

3.3.1. Nobo raw data

"Plot-Titel: HAM02"
"Anz.";"Datum";"Zeit, GMT+02:00";"Temp., °C (LGR S/N: 1163658, SEN S/N: 1128761, LBL: TT_HAM02)";"RH, % (LGR S/N: 1163658, SEN S/N: 1128761, LBL: RH_HAM02)";\
"Windgeschwindigkeit, m/s (LGR S/N: 1163658, SEN S/N: 1136473, LBL: FF_HAM02)";"Böengeschwindigkeit, m/s (LGR S/N: 1163658, SEN S/N: 1136473, LBL: FX_HAM02)";\
"Windrichtung, ø (LGR S/N: 1163658, SEN S/N: 1136473, LBL: DD_HAM02)";"Druck, mbar (LGR S/N: 1163658, SEN S/N: 1149476, LBL: PS_HAM02)"
1;2015.07.15;11:50:00;27.776;70.000;0.93;1.86;329.9;941.350
2;2015.07.15;12:00:00;27.235;45.200;1.11;2.04;1.4;940.250
3;2015.07.15;12:10:00;26.182;48.000;1.67;3.53;78.6;940.150
4;2015.07.15;12:20:00;26.549;49.300;1.48;2.78;23.9;940.050
5;2015.07.15;12:30:00;26.818;48.700;1.48;2.60;35.1;939.950
6;2015.07.15;12:40:00;26.426;48.900;2.04;3.15;44.9;939.950
7;2015.07.15;12:50:00;27.628;48.500;1.67;3.15;28.1;939.950
8;2015.07.15;13:00:00;26.818;47.600;2.41;3.53;42.1;939.750
9;2015.07.15;13:10:00;27.358;49.000;2.04;3.53;64.6;939.650
10;2015.07.15;13:20:00;27.308;47.900;2.41;4.82;60.4;939.650
11;2015.07.15;13:30:00;27.161;46.800;1.86;3.15;33.7;939.650
12;2015.07.15;13:40:00;28.394;44.800;1.11;2.60;352.4;939.550
13;2015.07.15;13:50:00;27.998;46.000;0.93;2.04;8.4;939.550
14;2015.07.15;14:00:00;28.023;45.900;1.86;3.53;44.9;939.450
15;2015.07.15;14:10:00;27.210;46.700;3.15;4.64;85.6;939.450
16;2015.07.15;14:20:00;28.097;47.100;2.23;4.08;68.8;939.450
17;2015.07.15;14:30:00;27.875;46.700;2.60;3.53;68.8;939.350
......

The full file can be seen here.

3.3.2. Nobo rain data

"Plot-Titel: AIC01"
"Anz.";"Datum";"Zeit, GMT+02:00";"Event, units (LGR S/N: 1141499, SEN S/N: 1141499, LBL: RR_AIC01)";"Koppler abgetrennt (LGR S/N: 1141499)";\
"Koppler verbunden (LGR S/N: 1141499)";"Host verbunden (LGR S/N: 1141499)";"Dateiende (LGR S/N: 1141499)"
1;2015.07.15;10:56:59;0.00;;;;
2;2015.07.15;10:57:21;;Protokolliert;;;
3;2015.07.15;10:57:26;1.00;;;;
4;2015.07.16;14:08:03;2.00;;;;
5;2015.07.16;14:15:22;3.00;;;;
6;2015.07.16;14:17:23;4.00;;;;
7;2015.07.16;14:19:53;5.00;;;;
8;2015.07.16;14:24:33;6.00;;;;
9;2015.07.16;14:29:26;7.00;;;;
10;2015.07.16;14:30:51;8.00;;;;
11;2015.07.16;14:36:12;9.00;;;;
12;2015.07.16;14:44:43;10.00;;;;
13;2015.07.17;07:50:26;;;Protokolliert;;
14;2015.07.17;07:50:31;;;;Protokolliert;
15;2015.07.17;07:50:35;10.00;;;;Protokolliert

The full file can be seen here.