DYNASONDE DATABASE STRUCTURE N. Zabotin, L. Zabotina 6 November 2014, Kiruna, Sweden YYYY_MM_DD : Table contains echo lists for all sounding sessions of the day DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS Seconds Time of the echo detection since the start of the sounding session, s FMHz Radio frequency of the echo, MHz fpMHz Plasma frequency at the reflection point, MHz SPGRkm Stationary Phase Group Range TRkm True range, km clz_SL Trace slope at the echo's location, km/MHz EPdeg Phase uncertainty within the echo XLkm Apparent W-E coordinate of the reflection point, km YLkm Apparent S-N coordinate of the reflection point, km ZLkm Apparent vertical coordinate of the reflection point, km V Line-of-sight Doppler speed, m/s dB Echo amplitude, dB PP Polarization chirality, deg NcB Background noise at the echo frequency, cB j Trace number Xkm True W-E coordinate of the reflection point, km Ykm True S-N coordinate of the reflection point, km Zkm True vertical coordinate of the reflection point, km ------------------------------------------------------- YYYY_MM_DD_ : Table contains trace lists for all sounding sessions of the day DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS P Trace selection flag ("+" if yes) j Trace number jj Trace number in natural order MAN Selection procedure index 1 NIX Selection procedure index 2 ITR Number of echoes in the trace FTR Average radio frequency of the trace, MHz RTR Average apparent range of the trace, km XTR Average apparent W-E coordinate of the trace, km YTR Average apparent S-N coordinate of the trace, km ZTR Average apparent vertical coordinate of the trace, km ATR Average amplitude of the trace, dB VTR Average line-of-sight Doppler speed of the trace, m/s VXX Average W-E velocity component of the trace, m/s VYY Average S-N velocity component of the trace, m/s VZZ Average vertical velocity component of the trace, m/s VMM Average trace velocity orthogonal to magnetic field (+ North), m/sec VBB Average trace velocity along the magnetic field (+ North), m/sec -------------------------------------------------------- vfitoaYYYY_MM_DD : Table contains experimental vector velocity analysis results where each ToA at every base frequency is considered an echo (unofficial product) DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS TOA Time of arrival expressed in km RPR Average stationary phase group range, km AFF Average plasma frequency, dB VXms Average W-E velocity component, m/s VYms Average S-N velocity component, m/s VZms Average vertical velocity component, m/s -------------------------------------------------------- resulYYYY_MM_DD : Table contains analysis products unique for each sounding session of the day DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS dDay Decimal Yearday fzE Z-mode E layer critical frequency from asimptotic analysis, MHz foE O-mode E layer critical frequency from asimptotic analysis, MHz fxE X-mode E layer critical frequency from asimptotic analysis, MHz fzF2 Z-mode F layer critical frequency from asimptotic analysis, MHz foF2 O-mode F layer critical frequency from asimptotic analysis, MHz fxF2 X-mode F layer critical frequency from asimptotic analysis, MHz COSCHI cosine of solar zenith angle, FMXE E layer maximum plasma frequency from NeXtYZ analysis, MHz HMXE E layer height of maximum from NeXtYZ analysis, km SHE E layer scale height from NeXtYZ analysis, km FMXF F layer maximum plasma frequency from NeXtYZ analysis, MHz HMXF F layer height of maximum from NeXtYZ analysis, km SHF F layer scale height from NeXtYZ analysis, km bTEC Bottomside part of TEC, TECU tTEC Topside part of TEC, TECU aTEC Total electron content (TEC), TECU rTEC Topside/bottomside ratio for TEC, VXF F layer horizontal velocity (+ East), m/s dVXF Uncertainty for F layer horizontal velocity, m/s VYF F layer horizontal velocity (+ North), m/s dVYF Uncertainty for F layer horizontal velocity, m/s VZF F layer vertical velocity (+ up), m/s dVZF Uncertainty for F layer vertical velocity (+ up), m/s PQF F layer Doppler variance expressed by the vector velocity results, percent VMF F layer velocity orthogonal to magnetic field (+ North), m/s dVMF Uncertainty for F layer velocity orthogonal to magnetic field, m/s VBF F layer velocity along magnetic field (+ up), m/s dVBF Uncertainty for F layer velocity along magnetic field, m/s VXe E layer horizontal velocity (+ East), m/s dVXe Uncertainty for E layer horizontal velocity, m/s VYe E layer horizontal velocity (+ North), m/s dVYe Uncertainty for E layer horizontal velocity, m/s VZe E layer vertical velocity (+ up), m/s dVZe Uncertainty for E layer vertical velocity, m/s PQe E layer Doppler variance expressed by the vector velocity results, percent VMe E layer velocity orthogonal to magn. field (+ North), m/s dVMe Uncertainty for E layer velocity orthogonal to magnetic field, m/s VBe E layer velocity along magnetic field (+ up), m/s dVBe Uncertainty for E layer velocity along magnetic field, m/s mFZE Z-mode spread E mean frequency, MHz sFZE Z-mode spread E ΔN/N mFOE O-mode spread E mean frequency, MHz sFOE O-mode spread E ΔN/N mFXE X-mode spread E mean frequency, MHz sFXE X-mode spread E ΔN/N mFZ2 Z-mode spread F mean frequency, MHz sFZ2 Z-mode spread F ΔN/N mFO2 O-mode spread F mean frequency, MHz sFO2 O-mode spread F ΔN/N mFX2 X-mode spread F mean frequency, MHz sFX2 X-mode spread F ΔN/N FkHZf F layer mean plasma frequency, kHz kmRTRf F layer mean virtual range, km kmZTRf F layer mean real height, km kmXTRf F layer mean echolocation (+ West), km kmYTRf F layer mean echolocation (+ South), km dgTAZf F layer echoes mean azimuth angle, deg dgTPOf F layer echoes mean polar angle, 0.1 deg msVHOf F layer mean horizontal velocity, m/s dgVAZf F layer mean horizontal velocity azimuth, deg dbATRf F layer mean echo amplitude, dB JLLf F layer number of phase structure function lags fitted HTRf F layer mean scale height, km SIAf F layer phase structure function index SIA SIBf F layer phase structure function index SIB CHFf F layer r.m.s. residual of phase structure function fit BAVf F layer weighted mean noise/signal ratio NSF2f F layer number of structure values in lag 1 SPINf F layer irregularity spectrum index SPAMf F layer ΔN/N for 1 km FkHZe E layer mean plasma frequency, kHz kmRTRe E layer mean virtual range, km kmZTRe E layer mean real height, km kmXTRe E layer mean echolocation (+ West), km kmYTRe E layer mean echolocation (+ South), km dgTAZe E layer echoes mean azimuth angle, deg dgTPOe E layer echoes mean polar angle, 0.1 deg msVHOe E layer mean horizontal velocity, m/s dgVAZe E layer mean horizontal velocity azimuth, deg dbATRe E layer mean echo amplitude, dB JLLe E layer number of phase SF lags fitted, HTRe E layer mean scale height, km SIAe E layer phase SF index SIA SIBe E layer phase SF index SIB CHFe E layer r.m.s. residual of phase SF fit BAVe E layer weighted mean noise/sygnal ratio NSF2e E layer number of structure values in lag 1 SPINe E layer irregularity spectrum index SPAMe E layer ΔN/N for 1 km, INFIL Raw data filename ------------------------------------------------------------- tsfeYYYY_MM_DD : Table contains results of alternative version of phase structure function analysis (modified V*) (unofficial product) DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS dDay Decimal UT yearday FkHZf kmRTRf kmZTRf kmXTRf kmYTRf dgTAZf dgTPOf msVHOf dgVAZf dbATRf JLLf HTRf SIAf SIBf CHFf BAVf NSF2f SPINf SPAMf FkHZe kmRTRe kmZTRe kmXTRe kmYTRe dgTAZe dgTPOe msVHOe dgVAZe dbATRe JLLe HTRe SIAe SIBe CHFe BAVe NSF2e SPINe SPAMe INFIL ------------------------------------------------------------------------- housekeepYYYY_MM_DD : Table contains housekeeping information in text form for all sounding sessions of the day DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS Name Reserved (ancillary) field Tx Houskeeping information in text form (contains metadata and intermediate output from analysis software). Format is different for new Dynasondes. ------------------------------------------------------------------------ amplYYYY_MM_DD : Table contains data for plotting raw amplitudes in ionogram image DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS mtoa Number of altitudes (length of tofa vector) tofa Vector of altitudes in binary form (real(4), km) numfr Number of frequencies (length of frrq vector) frrq Vector of frequencies in binary form (real(4), MHz) ampl 2-D matrix of amplitudes in binary form (mtoa and numfr are dimensions, integer(2), .01 dB) ------------------------------------------------------------------------ tsqYYYY_MM_DD : Table contains data for 3-D plots of NeXtYZ N(h) Profile Sequences DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS dDay Decimal UT yearday H1 ... H32 Plasma frequency values for 32 pre-determined real altitudes (70 74 79 84 90 95 101 108 114 122 129 138 146 156 165 176 187 199 212 225 239 254 270 288 306 325 346 368 391 416 442 470 km), .01 MHz ---------------------------------------------------------------- commentYYYY_MM_DD : Table contains auxiliary information for creation of 48-hour ionogram catalog and ionogram titles DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS Tx Abridged metadata info (Example: TROMSO NORWAY DYNASONDE 14-11-06 1336UT 15?E 8pBP6It0 DoY=310.56668 File=TR790462.BPG) ----------------------------------------------------------------- NeXtYZ_parsYYYY_MM_DD : Table contains parameters either produced or used by NeXtYZ inversion for all sounding sessions of the day DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS CorrH Correction coefficient for the height in Titheridge model of underlying ionization CorrFr Correction coefficient for the frequency in Titheridge model of underlying ionization (when E layer is not expected) or correction coefficient for the maximum frequency of the E layer in Titheridge model of underlying ionization (when E layer is expected) CorrVW Correction coefficient for the slope of F layer base in Titheridge model of underlying ionization (when E layer is not expected) or correction coefficient for the E-F valley width in Titheridge model (when E layer is expected) NoEu Number of echoes used in inversion AvPolE Average polar angle of arrival for E layer echoes, deg AvAzE Average azimuth angle of arrival for E layer echoes, deg AvPolF Average polar angle of arrival for F layer echoes, deg AvAzF Average azimuth angle of arrival for F layer echoes, deg ChapFmF Maximum plasma frequency in Chapman layer approximation for F peak, MHz ChapZmF Height of the maximum plasma frequency in Chapman layer approximation for F peak, km ChapHF Half thickness of Chapman layer approximation for F peak, km ChapFmE Maximum plasma frequency in Chapman layer approximation for E peak, MHz ChapZmE Height of the maximum plasma frequency in Chapman layer approximation for E peak, km ChapHE Half thickness of Chapman layer approximation for E peak, km ------------------------------------------------------------------ NeXtYZ_profileYYYY_MM_DD : Table contains vertical profiles produced by NeXtYZ inversion for all sounding sessions of the day DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS Z Real altitude, km PF Plasma frequency, MHz NY S-N projection of unit tilt vector NX W-E projection of unit tilt vector rmsR Standard deviation of the group range values for all echoes in the current wedge, km dPFdZ Vertical gradient of plasma frequency, MHz/km AvCalcR Average calculated group range for all echoes in the current wedge, km uncZ Profile uncertainty, km ------------------------------------------------------------------ NoiseYYYY_MM_DD : Table contains background noise power spectra for all sounding sessions of the day DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS FMHz Radio frequency, MHz dBN Background noise level, dB ------------------------------------------------------------------ man_echYYYY_MM_DD : Table contains auxiliary data necessary to support expert reprocessing of ionograms DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS j IST IET FST FET FSE FEE PSE RST RET RDT XDT YDT ADT VDT DST DET EPT EDT JSP ------------------------------------------------------------------ man_parYYYY_MM_DD : Table contains metadata describing station and organization of sounding session DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS STARTT Unix time for the start of a sounding session LatD Latitude, 0-90 deg Lat Latitude direction ("S" or "N") LonD Longitude, 0-180 deg Lon Longitude direction ("E" or "W") IDENT Station and mode of operation identification line CSITE Station code (Examples: TR, LR) CTYPE Recording type (B, K, P, BP, I, Z) for legacy Dynasonde stations NEDLY Analog delay in legacy Dynasonde systems FGYROF Electron gyrofrequency at the altitude 200 km, MHz DIPD Magnetic dip angle, deg AZM Rx antenna array orientation angle re North direction, deg DXX Base dimension of W-E leg of the Rx antenna array, km DYY Base dimension of S-N leg of the Rx antenna array, km WKMxKC Auxiliary variable RxNUM Number of Rx channels PPSet Number of pulses in the pulse set ITIKS Number of empty tiks within a pulse set (deprecated) SPRamp Number of base frequences within a B-block CYCLES Number of repetitions within a B-block MTAUU Time lag within a B-block (deprecated) TAU Inter-pulse interval, s MINR Minimum range, km MAXR Maximum range, km NTOA Number of ToAs FMIN Minimum base frequency, MHz FMAX Maximum base frequency, MHz NFRQ Number of base frequencies KSW Antenna-channel assignment -------------------------------------------------------- SRI : Table contains sunrise index, F10.7 and solar zenith angle DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS dDay Decimal UT yearday sDay Decimal local yearday CosCHI Cosine of solar zenith angle SRIMHz Sunrise index [Wright, J.W. and R.O. Conkright, A prospective ionospheric index of neutral thermospheric composition. Adv. Space Res. 22, 899-902, 1998] SIGSR Auxiliary variable INFIL Raw data filename F107 F10.7 value (from NOAA/SWPC online dataset) -------------------------------------------------------- kpindex : Table contains Kp index series data UT date, YYYY-MM-DD tim UT time, HH:MM:SS Kp Kp value (from NOAA/SWPC online dataset) -------------------------------------------------------- t50 : Table contains experimental estimates for month-long averages of echo amplitudes not affected by focusing/defocusing and any attenuation mechanisms (neither collisional nor caused by scattering). The "Top 50" algorithm. DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS f Radio frequency, MHz db Undisturbed echo amplitude, dB disp Standard deviation of the undisturbed echo amplitude, dB -------------------------------------------------------- maxdb50 : Table collects input data for Top 50 calculation DT db1 ... db50 -------------------------------------------------------- rawdata : Index of analized raw data files CrTime Creation date and time of raw data file, YYYY-MM-DD HH:MM:SS PrTime Start of processing date and time of raw data file, YYYY-MM-DD HH:MM:SS Path Directory of raw data file Name Raw data filename Numb Sequential number of raw data file (for legacy Dynasonde systems) Flag Processing stage flag ("new", "old", "incomplete", "done", "redo") DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS Web_flag Web display stage flag ("null", "web", "arch") ftp1_flag Reserved field ftp2_flag Reserved field ftp3_flag Reserved field xml_flag Reserved field flag1 Reserved field flag2 Reserved field flag3 Reserved field NeXtYZ_flag Reserved field -------------------------------------------------------- manual_index : Table contains parameters for ionogram reprocessing set by an expert Usname Login name of the Dynasonde Navigator's user who requested reprocessing CrTime Creation date and time of raw data file, YYYY-MM-DD HH:MM:SS EdTime Reprocessing request UT date and time, YYYY-MM-DD HH:MM:SS Name Raw data filename Numb Sequential number of raw data file (for legacy Dynasonde systems) Flag Reprocessing stage flag ("redo", "done", "new") DT UT date and time of the start of the sounding session, YYYY-MM-DD HH:MM:SS j Text mask reflecting trace selection choices (Example: 1001000110000) foF2c Manually corrected value of foF2 (if requested), MHz foEc Manually corrected value of foE (if requested), MHz