A description of the current database tables as used by NCAR RAF for real-time data exchange. These tables exist on the aircraft and a subset exists on a ground computer.
Global Attributes
For real-time use, EndTime is updated after new data is entered in the raf_lrt table, this then causes a NOTIFY to be sent out to clients which are listening using PostGreS' notify/listen mechanism.
key | value |
|---|---|
Source | NCAR Research Aviation Facility |
ProjectName | TREX |
Platform | N677F |
coordinates | GGLON GGLAT GGALT datetime |
landmarks | 39.9083 -105.116 BJC,39.191 -106.817 Aspen,36.407 -105.573 Taos,40.7858 -111.979 Alta,38.573 -109.549 Moab |
FlightNumber | rf10 |
StartTime | 2006-04-16 18:41:18 |
EndTime | 2006-04-17 04:00:33 |
Indexes:
"global_attributes_pkey" primary key, btree ("key")
Rules:
"update" AS ON UPDATE TO global_attributes DO NOTIFY current
Variable List
This table is a list of all the variables and desired attributes. This list [rows] is incomplete and can vary from instance to instance.
name | units | uncalibrated_units | long_name | sampleratetable | ndims | dims | ncals | poly_cals | missing_value | data_quality |
|---|---|---|---|---|---|---|---|---|---|---|
DPL | deg_C | V | Dew/Frost Point Temperature, Fuselage Left | SampleRate500 | 1 | {1} | 2 | {-0.2,9.902} | -32767 | Preliminary |
GGALT | m | Garmin GPS Altitude | SampleRate1 | 1 | {1} | 0 | {} | -32767 | Preliminary | |
GGLAT | degree_N | Garmin GPS Latitude | SampleRate1 | 1 | {1} | 0 | {} | -32767 | Preliminary | |
GGLON | degree_E | Garmin GPS Longitude | SampleRate1 | 1 | {1} | 0 | {} | -32767 | Preliminary | |
WD | degree_T | Horizontal Wind Direction | 1 | {1} | 0 | {} | -32767 | Preliminary | ||
WI | m/s | Wind Vector, Vertical Gust Component | 1 | {1} | 0 | {} | -32767 | Preliminary | ||
WS | m/s | Horizontal Wind Speed | 1 | {1} | 0 | {} | -32767 | Preliminary |
Indexes:
"variable_list_pkey" primary key, btree (name)
Flight Data
There are as many columns in this table as there are rows in the variable_list table. They must be in the same order also. Onboard this table will be on the order 300-500 columns and there is one row for each second of data.
datetime | DPL | GGALT | GGLAT | GGLON | WD | WI | WS |
|---|---|---|---|---|---|---|---|
2006-04-14T13:45:32 | -11.234 | 15000 | 39.234 | -105.2134 | 262.12 | 1.274 | 16.432 |
2006-04-14T13:45:33 | -11.8724 | 15001 | 39.235 | -105.2132 | 262.62 | 1.384 | 16.722 |
Indexes:
"raf_lrt_pkey" primary key, btree (datetime)
Categories
This is not a mandatory table. It provides a list of categories which variables may belong too. Variables may show up multiple times with different categories.
variable | category |
|---|---|
ACINS | Aircraft State |
ACINS | Raw |
AT_A | Raw |
CONCN_WCN | Chemistry |
CONCN_WCN | Raw |
DPL | Analog |
DPR | Analog |
GGALT | Position |
GGALT | Raw |
DPXC | Atmos. State |
DPXC | Derived |