Input parameter files, databases and input files ================================================ .. _inputparmfile: 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 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: * https://www.sqlite.org/ * https://docs.python.org/2/library/sqlite3.html * https://addons.mozilla.org/de/firefox/addon/sqlite-manager/ The database consists of **three tables**: 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) 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 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 Inputfiles ---------- Samples of a valid nobo data inputfiles. 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 :download:`can be seen here<./download/HAM02.txt>`. 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 :download:`can be seen here<./download/AIC01.txt>`.