ANITA Database Layout

Last modified: Thu Jan 1 10:16:54 HST 2009

ANITA telemetry database stores all data in tables listed here. Please refer to any SQL tutorial on how to retreive data from these tables, use variables for filters, etc.

Tables available
Table Name Content
hd Event headers
run Run starts
wv Event waveforms
wv_pedWaveform pedestals
hk Housekeeping data
hk_cal Housekeeping calibrations
hk_surf SURF housekeeping data
turf TURF trigger rates
mon CPU monitor data
other CPU other monitor data
adu5_pat ADU5 GPS position data
adu5_vtg ADU5 GPS velocity data
adu5_sat ADU5 GPS satellite coverage data
g12_pos G12 GPS position data
g12_sat G12 GPS satellite coverage data
cmd Command echos
slow Slow link data
wakeup Telemetry wakeup packets
file Configuration and log file dumps

Variable type names
Type Comment
int4 byte integer
int44 byte integer
int22 byte integer
realSingle precision, 4 byte floating point number
xxx[]Array of type xxx
xxx[][]2D array of type xxx
textVariable length string

Checksum check values
Wrapper checksum is calculated by telemetry software (i.e. Marty), while packet and waveform checksums are calculated by flight software (i.e. Ryan). Red fields are paradoxical states, i.e. they would indicate some software failure, not true telemetry information loss. Italicized fields apply to wavefrom checksums (i.e. in wv table), while the rest to all other packet checksums.
Value Comment
0wrapper and packet failed
0wrapper, packet, and waveform failed
1wrapper failed, packet passed
1wrapper failed, packet passed, waveform failed
2wrapper failed, packet failed, waveform passed
3wrapper failed, packet passed, waveform passed
256wrapper passed, packet failed
256wrapper passed, packet and waveform failed
257wrapper and packet passed
257wrapper passed, packet passed, waveform failed
258wrapper passed, packet failed, wavefrom passed
259wrapper, packet, and waveform passed

TABLE hk_cal variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
usintUNIX microsecond timestamp of data packet
codeint2IP320 analogue code; 512=AVZ calibration, 768=CAL calibration
bd1int2[]Acromag board 1 ADC values (40 entries)
bd2int2[]Acromag board 2 ADC values (40 entries)
bd3int2[]Acromag board 3 ADC values (40 entries)

TABLE hk variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
usintUNIX microsecond timestamp of data packet
codeint2IP320 analogue code; 256=RAW data
calintnbuf of hk_cal table entry used for CAL calibration
avzintnbuf of hk_cal table entry used for AVZ calibration
bd1int2[]Acromag board 1 ADC values (40 entries)
bd2int2[]Acromag board 2 ADC values (40 entries)
bd3int2[]Acromag board 3 ADC values (40 entries)
calb1real[]Acromag board 1 calibrated voltages (40 entries)
calb2real[]Acromag board 2 calibrated voltages (40 entries)
calb3real[]Acromag board 3 calibrated voltages (40 entries)
accxreal[]Accelerometer X values (2 entries)
accyreal[]Accelerometer Y values (2 entries)
acczreal[]Accelerometer Z values (2 entries)
acctreal[]Accelerometer temperatures (2 entries)
ssxreal[]Sun sensor X values (4 entries)
ssyreal[]Sun sensor Y values (4 entries)
ssireal[]Sun sensor intensities (4 entries)
ssflagint2[]Sun sensor quality flag (4 entries)
sselreal[]Sun elevation (4 entries)
ssazreal[]Sun azimuth (4 entries)
sstreal[]Sun sensor temperatures (4 entries)
presshrealPressure sensor high in PSI
presslrealPressure sensor low in Torr
p1_5vreal+1.5V true voltage
p3_3vreal+3.3V true voltage
p5vreal+5V true voltage
p5sbvreal+5V short board true voltage
p12vreal+12V true voltage
p24vreal+24V true voltage
ppvvrealPV true voltage
n5vreal-5V true voltage
n12vreal-12V true voltage
iprf1vrealIPRF1 true voltage
iprf2vrealIPRF2 true voltage
p1_5ireal+1.5V supply current in amps
p3_3ireal+3.3V supply current in amps
p5ireal+5V supply current in amps
p5sbireal+5V short board supply current in amps
p12ireal+12V supply current in amps
p24ireal+24V supply current in amps
ppvirealPV current in amps
n5ireal-5V supply current in amps
n12ireal-12V supply current in amps
iprf1irealIPRF1 supply current in amps
iprf2irealIPRF2 supply current in amps
batirealBattery current in amps
itreal[]Internal temperature sensors in deg C (25 entries)
etreal[]External temperature sensors in deg C (25 entries)
sbst1int4CPU temperature 1
sbst2int4CPU temperature 2
magxrealMagnetometer X value
magyrealMagnetometer Y value
magzrealMagnetometer Z value

TABLE hk_surf variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
usintUNIX microsecond timestamp of data packet
globalint4Global threshold setting
errorint4Error flag (AFAIK values undefined)
scalergoalsint4Scaler target rate in kHz
nadirgoalsint4Scaler target rate in kHz
upperint4[]Upper words, one per SURF
scalerint4[][]Scaler rates in kHz, 32 entries per SURF (8 by 32 array)
thresholdint4[][]Threshold ADC values, 32 entries per SURF (8 by 32 array)
rfpowint4[][]RF power values in ADC values, 8 per SURF (10 by 8 array)
surfmaskint4[]Surf RF trigger band mask (32-bit fields), one per SURF

TABLE turf variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
usintUNIX microsecond timestamp of data packet
l1int4[][]Level 1 trigger rates (Hz) divided by 16, (16 by 3 (top,bottom,nadir) array)
l2int2[][]Level 2 trigger rates (Hz) divided by 64, 3 layers of 16 sectors (2 by 16 array)
l3int2[]Level 3 trigger rates (Hz) (16 entries)

TABLE mon variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
diskint4[]Free disk space in MB (8 entries)
1 - RAM disk
2 - Root partition
3 - Home partition
4 - PMC disk
5 - SATA Blade
6 - SATA mini
7 - Home
8 - Neo Brick
bladetextLabel of mounted blade disk
usbinttextLabel of mounted USB internal disk
usbexttextLabel of mounted USB external disk
linkevint4[]Events waiting in priority queues (10 entries)
linkcmdlosint4Command echos waiting in LOS queue
linkcmdsipint4Command echos waiting in SIP queue
linkgpsint4GPS packets waiting in a queue
linkhkint4Housekeeping packets waiting in a queue
linkmonint4Monitor packets waiting in a queue
linkhdint4Header packets waiting in a queue
linksurfint4SURF housekeeping packets waiting in a queue
linkturfint4TURF rate packets waiting in a queue
linkpedint4Pedestal packets waiting in a queue

TABLE other variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
raminodesintRAM disk inodes
runtimeintRun start time
runevnumintRun start event number
runnumintRun number
filesacqdintFiles in /tmp/anita/acqd
fileseventdintFiles in /tmp/anita/eventd
filespriorintFiles in /tmp/anita/prioritizerd
lnacqdintLinks in /tmp/anita/acqd
lneventdintLinks in /tmp/anita/eventd
lnpriorintLinks in /tmp/anita/prioritizerd
otherintOther flag

TABLE adu5_pat variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
codeintpacket code contains adu5 unit #
timeintUNIX timestamp of data packet
usintUNIX microsecond timestamp of data packet
todintTime of Day in milliseconds since midnight
headingrealPayload heading in degrees
pitchrealPayload pitch in degrees
rollrealPayload roll in degrees
mrmsrealAttitude phase measurement RMS error in meters
brmsrealAttitude baseline length RMS error in meters
flagint2Quality flag; either 0 or 1
latituderealPayload latitude in degrees
longituderealPayload longitude in degrees
altitudereal Payload altitude in meters

TABLE adu5_vtg variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
codeintpacket code contains adu5 unit #
timeintUNIX timestamp of data packet
usintUNIX microsecond timestamp of data packet
courserealTrue course in degrees(?) relative to true north
mcourserealMagnetic course in degrees(?) relative to magtenic north
vktrealSpeed in knots
vkphrealSpeed in kph

TABLE adu5_sat variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
codeintpacket code contains adu5 unit #
timeintUNIX timestamp of data packet
numsatsint2[]Number of satellites per antenna (4 entries)
prnint2[][]PRN value, numsats (up to 20) per antenna (4 by corresponding numsats entries)
elevationint2[][]Satellite elevation, numsats (up to 20) per antenna (4 by corresponding numsats entries)
snrint2[][]Satellite signal SNR, numsats (up to 20) per antenna (4 by corresponding numsats entries)
flagint2[][]Quality flag, numsats (up to 20) per antenna (4 by corresponding numsats entries)
azimuthint4[][]Satellite azimuth, numsats (up to 20) per antenna (4 by corresponding numsats entries)

TABLE g12_pos variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
usintUNIX microsecond timestamp of data packet
numsatsint4Number of satellites
latituderealPayload latitude in degrees
longituderealPayload longitude in degrees
altitudereal Payload altitude in meters
courserealTrue course in degrees(?) relative to true north
upvrealVertical velocity (units?)
vktrealSpeed in knots
pdoprealPDOP value
hdoprealHDOP value
vdoprealVDOP value
tdoprealTDOP value
unitint2G12 unit # (always 0)

TABLE g12_sat variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
numsatsint2Number of satellites
prnint2[]PRN value, (numsats entries, up to 20)
elevationint2[]Satellite elevation, (numsats entries, up to 20)
snrint2[]Satellite signal SNR, (numsats entries, up to 20)
flagint2[]Quality flag, (numsats entries, up to 20)
azimuthint4[]Satellite azimuth, (numsats entries, up to 20)

TABLE cmd variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
flagint2Goodness flag; either 0 or 1
bytesint2Number of command bytes
cmdint2Command bytes (up to 10 entries)

TABLE wakeup variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
typeint2Telemetry channel type
0 = LOS
1 = High rate TDRSS
2 = Low rate COM1
3 = Low rate COM2

TABLE file variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
filenametextName of the file transmitted
lengthintLength of file in bytes
contenttextFile content

TABLE slow variables (UPDATE!)
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
evnumintLast event number
latituderealLast payload latitude in degrees
longituderealLast payload longitude in degrees
altituderealLast payload altitude in meters
temprawint2[]Housekeeping temperatures, 8 entries, ADC counts (except tempraw[1] which is in degrees)
powerrawint2[]Housekeeping voltages and currents, 4 entries, ADC counts
tempvreal[]Housekeeping temperatures, 8 entries, voltages (except tempv[1] which is 0)
powervreal[]Housekeeping voltages and currents, 4 entries, voltages
tempreal[]Housekeeping temperatures, 8 entries, degrees C
ppvvrealPV voltage
p24vreal+24V voltage
batirealBattery current
p24ireal+24V current
rate1realEvent rate integrated over 1 minute in Hz
rate10realEvent rate integrated over 10 minutes in Hz
avgl1int2[]Average L1 trigger rates per trigger surf in Hz, 10 entries (divided by 512)
avgl2int2[]Average level 2 rate in Hz (16 sectors (upper+lower), divided by 64)
avgl3int2[]Average level 3 rate in Hz (16 sectors, multiplied by 32)
avgscalerint2[][]Average scaler rates (10 surfs by 4 antennas) in kHz(?)
rmsscalerint2[][]RMS of scaler rates (10 surfs by 4 antennas) in kHz(?)
avgrfpowint2[][]Average RF power ADC values, (10 surfs by 8 RF channels)

TABLE run variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
evnumintStart event number
runintRun number

TABLE hd variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet
usintUNIX microsecond timestamp of data packet
nsintNanosecond part of second from GPS
evidintturf event ID ; 12bit(run#) + 20bit(ev# in run)
evnumintEvent number
surfmaskint2SURF mask (12-bit value)
calibintCalibration status (see flight software documentation for interpretation)
priorityint2Event priority
turfwordint2TURF upper word
antmaskintAntenna trigger mask (32-bit value)
phimaskintPhi trigger mask (32-bit value)
trigtypeint2TURFIO trigger type
trignumintTURFIO trigger number
l3cntint2TURFIO L3 type1 count
ppsintTURFIO pps number
trigtimeintTURFIO trigger time
c3pointTURFIO C3PO number
deadtimeintTURFIO deadtime (expressed as value in [0,64400])
l1trigpatintL1 trigger patern (32-bit value, 1 bit per antenna)
l2trigpatintL2 trigger patern (32-bit value, 1 bit per phi sectors, upper word upper seector, lower word lower sectors)
l3trigpatintL3 trigger patern (16-bit value, 1 bit per phi sector)

TABLE wv variables
Name Type Comment
nbufintPacket number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
evnumintEvent number
idint2Channel id number (chan+9*surf) (0-80)
chipint2Chip read out (0-3)
rcobitint2RCObit, 0 or 1
hbwrapint2Hit bus wrap flag, 0 or 1
hbstartint2Position of first hitbus bin before rotation (0-259)
hbendint2Position of last hitbus bin before rotation (0-259)
pedsint4Timestamp of pedestals used (as recorded by flight computer or GSE)
rawint2[]Raw ADC data, full 16 bits (post decoding if necessary), 260 entries
calreal[]Calibrated and rotated data (mV), 260 entries

TABLE wv_ped variables
Name Type Comment
nbufintUnique packet number. Highest bit; high=TDRSS, low=LOS
crcint2Checksum check
nowintUNIX timestamp at GSE processing time
timeintUNIX timestamp of data packet, also end of pedestal measuring period
startintUNIX timestamp of start of pedestal taking period
idint2Channel id number (chan+9*surf) (0-80)
chipint2Chip read out (0-3)
entriesint2Number of samples taken to calculate pedestals
pedreal[]Pedestal ADC values (divided by 2), 260 entries
rmsreal[]Pedestal ADC RMS values (divided by 2?), 260 entries


-- Ped ; he still answers
-- Shige