GPS/MET Metadata database -- tables and their fields. Chris Bogart 7/28/97 ------------------------------------------------------- *** Table: attitude *** Record of attitude mode changes See addidx.pm, table-edit Attributes: idx integer Same as occ.att_idx time_in time(0) Enter attitude mode time_out time(0) Leave attitude mode (1 sec before next entry) eventid integer reason integer Same as explanation.code att_mode smallint 0=optimum 1=inverse 2=fixed 3=other/anomalous att_mode_angle integer Usually 0, 90, 180, or 270 Indices: UNIQUE ON (time_in) UNIQUE ON (idx) UNIQUE ON (time_out) ============================================================================== *** Table: code_version *** Record of instrument software version changes See addidx.pm, table-edit Attributes: idx integer Same as occ.code_idx time_in time(0) New code version installed to LEO satellite time_out time(0) 1-sec before next code version installed eventid integer reason integer Same as explanation.code (unused) datestamp character(32,1) Version string printed in s/w boot flag description character(320,1) Explanation of salient features of update Indices: UNIQUE ON (time_in) UNIQUE ON (idx) ============================================================================== *** Table: explan *** Common explanations for events See boot2db.pm, gap2db.pm, disp-outages, explan-page and gap-page (the latter 3 are cgi scripts) Attributes: code integer Unique index time_in time(0) Time of event being explained (optional) category character(10,1) Broad category that problem/explan falls into cause integer Pointer to event that caused this (mostly unused) explanation text(60,80,20,1) Explanation in English Indices: UNIQUE ON (code) ============================================================================== *** Table: fid_gaps *** Record of gaps in fiducial data See fid2db.pm Attributes: time_in time(0) Start hour of gap in fid data time_out time(0) End hour of gap in fid data exact_time smallint site_num smallint Same as fid_sites.idx out_of_svc smallint 1 = fiducial data gap (always set) noisy smallint 1 = noisy fiducial data (not used) Indices: UNIQUE ON (time_in, time_out, site_num) ============================================================================== *** Table: fid_sites *** Derived from stations.hr Attributes: idx integer Index (not used) name character(4,1) Four-letter site designation site_num character(4,1) Second column of stations.hr x_coord float(6) y_coord float(6) Location of fid_site from stations.hr z_coord float(6) ============================================================================== *** Table: gps_anomaly *** Record of delete cards. See pop_gps_anom.pm Attributes: time_in time(0) Start time of anomaly time_out time(0) End time of anomaly prn smallint GPS sat PRN number as_off smallint unused out_of_svc smallint (always set to 1) noisy smallint unused ============================================================================== *** Table: gps_status *** When anti-spoofing is on or off See addidx.pm, table-edit Attributes: time_in time(0) Time of A/S status change time_out time(0) 1 sec before next A/S status change global_as_off smallint 1=A/S OFF, 0=A/S ON idx integer Same as occ.gps_idx Indices: UNIQUE ON (idx) ============================================================================== *** Table: leo_orbit *** Obsolete Attributes: yr integer doy integer arc integer 0-3, for four arcs per day. wtobs integer wtrms float(6) radial_diff float(6) Difference between this arc and next cross_diff float(6) Difference between this arc and next along_diff float(6) Difference between this arc and next threed_diff float(6) Difference between this arc and next Indices: UNIQUE ON (yr, doy, arc) NORMAL (2, 15) ON (yr, doy) ============================================================================== *** Table: lev0_avail *** Info about each level 0 file See summ2db.pm Attributes: time_in time(0) Start time of readable data time_out time(0) End time of readable data span longinteger Minutes between time_in & time_out type smallint 0=sci, 1=att, 2=imm filename character(50,1) Filename scan_success smallint 1 if scansci created a summary record file_empty smallint 1 if lev 0 file was empty lost smallint 1 if lev 0 file was lost pct_error smallint percent of file lost to bad CRCs Indices: UNIQUE ON (filename) ============================================================================== *** Table: lev0_gaps *** Record of gaps in level 0 data See scansci, condense.pm, gap2db.pm Attributes: idx integer Unique index time_in time(0) Start of gap time_out time(0) End of gap eventid integer data_type character(8,1) hr, lr, mr, eng, or att reason integer Pointer to explan.code any_comment character(80,1) unused Indices: UNIQUE ON (idx) UNIQUE ON (time_in, time_out, data_type) ============================================================================== *** Table: lev0_ranges *** Record of ranges of good data in lev0 data See gap2range.pm Exactly the same information as lev0_gaps, but in a more useful form. Attributes: time_in time(0) End of one data gap time_out time(0) Beginning of the next data_type character(8,1) hr, lr, mr, eng, or att ============================================================================== *** Table: new_leo_orbit *** LEO orbit information; replaces leo_orbit See orbqual2db.pm Attributes: yr integer four digit year doy integer day of year -- one entry per day wtobs integer wtrms float(6) pos_radial_diff float(6) Position overlap pos_cross_diff float(6) pos_along_diff float(6) pos_threed_diff float(6) vel_radial_diff float(6) Velocity overlap vel_cross_diff float(6) vel_along_diff float(6) vel_threed_diff float(6) Indices: UNIQUE ON (yr, doy) ============================================================================== *** Table: occ *** Information for each occultation, using the "best" choice of fiducial site and reference satellite. See: stage2.pm, syncMeta.pm Attributes: id integer Unique ID number per day; see univOcc yr integer Four digit year doy integer Day of year, Jan 1 = 001 occsat smallint PRN of occulted satellite occchan smallint LEO Receiver channel oveserving occsat (1-8) time_in time(0) Start time of occ data in UTC time_out time(0) End time of occ data in UTC qc_lat_in float(6) QCMET predicted latitude qc_lon_in float(6) QCMET predicted longitude qc_top_alt float(6) QCMET predicted ceiling qc_bot_alt float(6) QCMET predicted floor (if no atm bending) deg_from_term float(6) Degrees of occ away from day/night terminator qc_az_occ float(6) Azimuth of occ sat from LEO wrt velocity or anti-vel (0-90) qc_smear float(6) km across earth's surface that occ perigee point traces qc_direction character(1,1) R=Rising, S=setting yaw float(6) Microlab-1 yaw at start of occ roll float(6) Microlab-1 roll at start of occ pitch float(6) Microlab-1 pitch at start of occ refsat smallint Reference satellite used refchan smallint Receiver channel used to track refsat (1-8) fid smallint Fiducial site used; Same as fid_sites.site_num alt_in float(6) Top altitude of GMR inversion alt_out float(6) Bottom altitude of GMR inversion lat_in float(6) Start latitude, according to GMR lat_out float(6) End latitude, according to GMR lon_in float(6) Start longitude, according to GMR lon_out float(6) End longitude, according to GMR qc_fid2oc float(6) QCMET altitude angle from fid site to occsat qc_fid2ref float(6) QCMET altitude angle from fid site to refsat qc_az_ref float(6) QCMET azimuth to refsat wrt. velocity or anti-vel (0-90) qc_ele_ref float(6) QCMET elevation angle to refsat qc_alt_ref float(6) QCMET zoning line altitude to refsat qc_az_occ_360 float(6) qc_az_occ, wrt anti-velocity (0-360) qc_az_ref_360 float(6) qc_az_ref, wrt anti-velocity (0-360) casnr_40 float(6) CA Signal/Noise when GMR says signal perigee at 40km p1snr_40 float(6) P1 Signal/Noise when GMR says signal perigee at 40km p2snr_40 float(6) P2 Signal/Noise when GMR says signal perigee at 40km lev3_online smallint 1 if tem file is in /gpsmet/data/pub lev3_performed smallint 1 if GMR ran successfullly subtype integer Subtype of level 3 output version integer Version of level 3 output sample_cutoff integer same as noffset qual_ion smallint 1 = high quality inversion in ionosophere (unused) qual_strat smallint 1 = high quality inversion in stratosphere qual_trop smallint 1 = high quality inversion in troposphere att_idx integer Index into attitude table -- see addidx.pm gps_idx integer Index into gps_status table -- see addidx.pm occp_idx integer Index into occparams table -- see addidx.pm code_idx integer Index into code_version table -- see addidx.pm GMR output parameters: rfict float(6) Radius of Earth's curvature at occ perigee (km) teralt float(6) Alt of earth surface above MSL (km) znion float(6) Altitude below which only L1 is used (km) z1 float(6) Max alt for occultation (km) eimax float(6) Max L1/L2 bending angle difference (rad) zimax float(6) Altitude of eimax smean float(6) DC component of bending angle noise (rad) stdev float(6) AC component of bending angle noise (rad) scale float(6) Mean half period of delta alpha oscillations, 60-80 km difref float(6) Max devation of refractivity from model, 20-60 km zdifref float(6) Altitude of difref (km) dpmax float(6) Max continuous increase of impact param (rad) demax float(6) Max continuous decrease of bending angle (rad) noffset integer Number of data points cut off ifadb integer 1 = adiabatic gradient exceeded below 60km idiffout integer 1 = diffraction correction used zndiff float(6) Altitude below which diffraction correction used ngap integer Number of 50Hz data lost in gaps igap1 integer Whether gaps existed below zndiff igap2 integer Whether gaps existed between 20 and 40km igap3 integer Whether gaps existed between 60 and 80km gps_anom integer Whether a GPS anomaly happened during the occ Indices: NORMAL (2, 15) ON (doy) NORMAL (2, 15) ON (time_in) NORMAL (2, 15) ON (fid) NORMAL (2, 15) ON (refsat) NORMAL (2, 15) ON (occsat) NORMAL (2, 15) ON (yr, doy) UNIQUE ON (id, yr, doy) ============================================================================== *** Table: occ_view *** Same as occ, but lists every combo of fiducial site and reference satellite. See: stage2.pm, syncMeta.pm Attributes: id integer Same as occ yr integer doy integer refsat smallint refchan smallint fid smallint alt_in float(6) alt_out float(6) lat_in float(6) lat_out float(6) lon_in float(6) lon_out float(6) qc_fid2oc float(6) qc_fid2ref float(6) qc_az_ref float(6) qc_ele_ref float(6) qc_alt_ref float(6) qc_az_ref_360 float(6) casnr_40 float(6) p1snr_40 float(6) p2snr_40 float(6) rank smallint Rating of this view compared with other views of the same occ ID; the one ranked #1 is copied to the occ table lev3_online smallint subtype integer version integer sample_cutoff integer qual_ion smallint qual_strat smallint qual_trop smallint rfict float(6) teralt float(6) znion float(6) z1 float(6) eimax float(6) zimax float(6) smean float(6) stdev float(6) scale float(6) difref float(6) zdifref float(6) dpmax float(6) demax float(6) noffset integer ifadb integer idiffout integer zndiff float(6) ngap integer igap1 integer igap2 integer igap3 integer fid_avail smallint 1 = fiducial data was available for this occ (unused) Indices: NORMAL (2, 15) ON (doy) NORMAL (2, 15) ON (id, yr, doy) UNIQUE ON (id, yr, doy, fid, refsat) ============================================================================== *** Table: occ_view_runs *** Obsolete -- used to show multiple sub/ver for each occ_view This table remains in /gpsmet/meta/metaold, but not in the newer databases. ============================================================================== *** Table: occparams *** Changes in GPS/MET LEO software parameters over time See occparam2db.pm Attributes: idx integer Index, pointed to by occ.occp_idx -- see attidx.pm time_in time(0) Time these new settings were confirmed time_out time(0) 1 second before next settings were confirmed eventid integer reason integer Pointer to explan.code exact_time smallint 0 = mere confirmation of previous change at unknown time op_azimuth float(6) Azimuth op_azwidth float(6) Occlazs op_enable smallint Enable op_elevation float(6) Elevation op_occmed float(6) Occlmed op_occtop float(6) Occltop op_occbot float(6) Occlbott op_occded float(6) Occlded op_highrate smallint 1 if Occltop > Occlbott op_medrate smallint 1 if Occlmed > Occlbott op_lowrate smallint Always set to 1 op_extrap smallint 1 if extrapolation mode turned on Indices: UNIQUE ON (time_in) UNIQUE ON (idx) NORMAL (2, 15) ON (op_occtop) ============================================================================== *** Table: pccg_type *** Software settings of GMR Attributes: pccg_index integer Unique index subtype integer Output file subtype version integer Output file version inv_num_of_rec integer Polynomial regression window width inv_poly_power integer Num of coefficients for polynomial regression inv_switch real Threshhold for ionospheric correction inv_Abel_init real Initial bending angle dev. before Abel inversion max_acc_dec_angle real Bending angle decrease cutoff max_acc_inc_impact real Impact parameter increase cutoff Indices: UNIQUE ON (subtype, version)