Child pages
  • RAF Database Tables

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

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:

Panel

"global_attributes_pkey" primary key, btree ("key")

Rules:

Panel

"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:

Panel

"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:

Panel

"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