NRAO E2E Archive (EVLA, VLA, VLBA) - Database MetaData Listing
(DB name : ARCHIVE, Host : chewbacca.aoc.nrao.edu, Oracle 11g)
(Document Version : 2009-Sep-7 JMB) -
Nearly all of the metadata items in the NRAO E2E Archive Database are listed below. In order to enable the
reader to make some sense of which metadata items are present and which metadata items we lack, the metadata items (db table columns)
are grouped
by catagory. The catagories do not particularly correspond to actual db tables. The goal of this document is to
relieve the reader of having to read and understand the db table relations and schema, and focus on the metadata content.
The db metadata population is intended to support
user and automated process queries, and allow query results to display additional information about the
obseravtions in the archive. The NRAO Data Archive Policy decrees that all observational metadata is in the public domain
immediately after the observations are completed.
NRAO E2E Archive DB MetaData Catagory : PROJECT
| Column Name |
Description |
Example |
Units |
Data Type |
VO UCD |
|---|
| ARCH_FILES | Number of raw data archive files | 2 | none | float | meta.number |
| COLLECTION | Survey name, or VLA Users, or VLBA Users | NVSS | none | varchar | none |
| DATE_EXPIRES | none | none | none | float | none |
| EMAIL_ADDR | User email for notifcation, data set going public | none | none | float | none |
| ENTRY_DATE | none | none | none | float | none |
| GRANT_ACCESS | Grant access to who | ALL | none | varchar | none |
| IDENTITY | none | NVSS | none | varchar | none |
| KEYWORD | Keyword to manually unlock an observing project | eqL4W2Bp | none | float | none |
| NUM_SEGMENTS | Number of observing sessions (segments) | 1 | none | float | meta.number |
| OBSERVER | Observer name present in data files | Benson, John | none | varchar | none |
| OBSERVER_ID | Observer NRAO ID number | 999 | none | float | none |
| OBS_BANDS | List of observing band codes | X | none | varchar | none |
| PROJECT_CODE | Observing Program Name | AB0973 | none | varchar | obs.proposal |
| PROJECT_LOCK | Proprietary lock status : locked , unlocked, public | UTIME | none | varchar | meta.code.status |
| PROPRIETARY | Proprietary period expires, data beomes public. | 52410.8362947 | none | float | none |
| PROPRIETARY_DURATION | Proprietary period : 365 days after last observation | 365.0 | d | float | none |
| RAW_PROJECT_CODE | Project code embedded in data file | AB973 | none | varchar | none |
| ROW_DATE | (MJD) | 52528.23832 | d | float | none |
| STARTTIME | First data time in this observation (MJD) | 51862.0065494 | d | double | time.start |
| STOPTIME | Last data time in this observation (MJD) | 51862.8362947 | d | double | time.end |
| TELESCOPE | Telescope name | VLA | none | varchar | inst.tel |
| TELESCOPE_CONFIG | Telescope Configuration; VLA : A, B, C, D, etc. | A | none | varchar | inst.telescope.setup |
| TOTAL_OBS_TIME | Total observing time | 5.877 | hour | float | none |
| UNLOCK_EXPIRE | (MJD) | 0.0 | d | float | none |
| WARNED | Count emails sent warning owner, data public | 0.0 | none | float | none |
NRAO E2E Archive DB MetaData Catagory : Observing Scans
| Column Name |
Description |
Example |
Units |
Data Type |
VO UCD |
|---|
| DISTANCE | Distance between the query search and observing positions | 0.0012 | deg | float | Query.AngularDistance |
| ELEV_MAX | not used | none | deg | float | none |
| ELEV_MIN | not used | none | deg | float | none |
| EXPOSURE | Scheduled time on source | 560 | s | float | obs.exposure |
| FOV | Field of view | 0.01 | arcmin | float | inst.fov |
| INTERVAL | Averaging interval | 10 | s | float | time.interval |
| N_ANTS | Number of antennas in this subarray | 26 | none | int | none |
| N_IMAGES | Number of images for this observation row | 1 | none | int | none |
| PROJECT_CODE | Observing Program Name | AB0973 | none | varchar | obs.proposal |
| RESOL | Best angular resolution from this data | 0.012 | arcsec | float | none |
| RMS | Estimated background noise (mJy/beam) | 0.01 | mJy | float | none |
| SOURCE_ID | Source or pointing position name | I16288+392 | none | varchar | src.name |
| SOURCE_TYPE | not used | STAR | none | float | src.class |
| STARTTIME | First data time in this observation (MJD) | 51862.0065494 | d | double | time.start |
| STOPTIME | Last data time in this observation (MJD) | 51862.8362947 | d | double | time.end |
| UV_MAX | not used | none | km | float | none |
| UV_MIN | not used | none | km | float | none |
< NRAO E2E Archive DB MetaData Catagory: Source
| Column Name |
Description |
Example |
Units |
Data Type |
VO UCD |
|---|
| CALIB_TYPE | Calibrator source quality : A, B, etc | A | none | varchar | none |
| DEC2000 | Observed sky position, DEC J2000 | 0.687384002 | rad | double | pos.eq.dec |
| DECDEG | Observed sky position, DEC J2000 | 21.432156 | deg | double | pos.eq.dec;meta.main |
| RA2000 | Observed sky position, RA J2000 | 4.32206798 | rad | double | pos.eq.ra |
| RADEG | Observed sky position, RA J2000 | 191.23456 | deg | double | pos.eq.ra;meta.main |
| SOURCE_ID | Source or pointing position name | I16288+392 | none | varchar | src.name |
| SOURCE_TYPE | not used | STAR | none | float | src.class |
NRAO E2E Archive DB MetaData Catagory : Spectral Window
| Column Name |
Description |
Example |
Units |
Data Type |
VO UCD |
|---|
| DATA_DESC_ID | Unique key for observing freqs in this program in this file | 181751519 | none | float | none |
| IF_BAND | Obs Band code (actually): 4, P, L, C, X, U, K, Q | C | none | varchar | inst.bandpass |
| IF_CHAN | IF Band Code (VLA) : AC, BD | AC | none | varchar | none |
| IF_CONV_CHAIN | VLA, VLBA not used | none | none | float | none |
| IF_REF_FREQ | Reference Frequency | 8435100000 | Hz | float | em.freq |
| OBS_BANDS | List of observing band codes | X | none | varchar | none |
| RECEIVER_ID | VLA, VLBA not used | none | none | float | none |
| SUB_BANDW | Sub band or spectral window bandwidth | 50000000 | Hz | float | inst.bandwidth |
| SUB_CHAN_ID | Sub-band or spectral window id | 1 | none | int | none |
| SUB_DESC_ID | Sub-band index; 1-n | 1 | none | float | none |
| SUB_NET_SIDEBAND | Subband net sideband, +1 or -1 | 1 | none | float | none |
| SUB_NUM_CHANS | N spectral channels for this subband | 1 | none | int | spect.resolution |
| SUB_REF_FREQ | Sub band reference Frequency | 8435100000 | Hz | double | em.freq |
NRAO E2E Archive DB MetaData Catagory: Polarization
| Column Name |
Description |
Example |
Units |
Data Type |
VO UCD |
|---|
| POL1 | Polarization code, index 1 - 4 : I, Q, U, V | 5 | none | float | none |
| POL2 | Polarization code, index 5 - 8 : RR, RL, LR, LL | 8 | none | float | none |
| POL3 | Polarization code, index 9 - 12: XX, XY, YX, YY | 6 | none | float | none |
| POL4 | Polarization code, index 13 - 20 : RX, RY, LX, LY, XR, XL, YR, YL | 7 | none | float | none |
| POLAR | Polarization description: RR,LL,RL,LR | RR,LL,RL,LR | none | varchar | none |
| SUB_POL_1 | Subband polarization code, index 1 - 4 : I, Q, U, V | 5 | none | int | none |
| SUB_POL_2 | Subband polarization code, index 5 - 8 : RR, RL, LR, LL | 6 | none | int | none |
| SUB_POL_3 | Subband polarization code, index 9 - 12: XX, XY, YX, YY | 7 | none | int | none |
| SUB_POL_4 | Subband polarization code, index 13 - 20 : RX, RY, LX, LY, XR, XL, YR, YL | 8 | none | int | none |
NRAO E2E Archive DB MetaData Catagory: Correlator
|
Column Name |
Description |
Example |
Units |
Data Type
|
|---|
| CORR_MODE | Correlator mode | none | none | varchar |
NRAO E2E Archive DB MetaData Catagory: Telescope
| Column Name |
Description |
Example |
Units |
Data Type |
VO UCD |
|---|
| ANTENNA_TYPE | Ground or space based | GROUND-BASED | none | varchar | none |
| AXIS_OFF | Axis intersection offset in meters | 0.001 | m | float | none |
| DISH_DIAMETER | Antenna Diameter in meters | 25 | m | float | none |
| FRAME | Terrestrial Coordinate Frame (ITRF) | ITRF | none | varchar | none |
| MOUNT | Alt-az, Equatorial | ALT-AZ | none | varchar | none |
| NAME | Antenna name, VLA antenna number | 16 | none | varchar | none |
| N_ANTS | Number of antennas in this subarray | 26 | none | int | none |
| STATION | VLA Antenna Location; VLBA Station ID | VLA:W48 | none | varchar | none |
| SUBARRAY_ID | VLA sub array id number | 1 | none | int | none |
| TELESCOPE | Telescope name | VLA | none | varchar | inst.tel |
| TELESCOPE_CONFIG | Telescope Configuration; VLA : A, B, C, D, etc. | A | none | varchar | inst.telescope.setup |
NRAO E2E Archive DB MetaData Catagory: Archive Data Files
| Column Name |
Description |
Example |
Units |
Data Type |
VO UCD |
|---|
| ARCH_FILE | Archive File Name | VLA/XH00149/file_7 | none | varchar | meta.file |
| ARCH_FILE_DATE | File Creation Date (MJD) | none | d | float | time.creation |
| ARCH_FILE_ID | Unique key for this obs. program in this file | 181751519 | none | int | none |
| ARCH_FORMAT | Data format : FITS-IDI, FITS-AIPS, VLA Exp | VLA Exp | none | varchar | none |
| BDF_FILE | EVLA/ALMA BDF file name | uid___evla_bdf_X1227136037120.bdf | none | varchar | meta.file |
| CATALOG_DATE | Date of DB entry (MJD) | 53647.89721065 | d | float | none |
| COMMON_FILE_ID | Used to connect images with uv data files | none | none | varchar | none |
| DATA_TYPE | raw or calibrated data | raw | none | varchar | none |
| ENTITY_ID | ASDM UID | uid://evla/bdf/X1227136037120 | none | varchar | none |
| ENTITY_TYPE_NAME | File Type Description | bdf | none | varchar | none |
| FILE_ID | SDM/BDF File Name in NGAS Archive | uid___evla_bdf_X1227136037120.bdf | none | varchar | none |
| FILE_SET_ID | EVLA/ALMA SDM file set identifier | Xtestobs_091.54782.123456 | none | varchar | none |
| FILE_SIZE | File size (kBytes) | 144589 | kByte | float | none |
| FILE_VERSION | NGAS archived file version number | 1 | none | float | none |
| IMAGEFILE | none | C0552M08.fits | none | float | meta.file |
| IMAGEFORAMT | none | image/fits | none | float | none |
| MIMETYPE | Data model for EVLA, VLA, VLBA, FITS | application/x-vla;datamodel=vla-exp | none | varchar | none |
| NGAS_HOST | NGAS node hosting this file | none | none | varchar | none |
| OBSSUMMARY_UID | EVLA/ALMA SDM format uid, uid://vla/1/123456789 | uid://vla/1/123456789 | none | varchar | meta.ref.uri |
| ROOTDIRECTORY | Directory path to image file location | /home/archive/surveys/NVSS | none | varchar | none |
| ROOT_DIRECTORY | Path to file in archive disk array | /home/archive_VLBA21/tapes | none | varchar | none |
| SITE_CODE | File Location Key : AOC, EVLA, CV, etc | AOC | none | varchar | none |
| STARTTIME | First data time in this observation (MJD) | 51862.0065494 | d | double | time.start |
| STOPTIME | Last data time in this observation (MJD) | 51862.8362947 | d | double | time.end |
NRAO E2E Archive DB MetaData Catagory: IMAGE
| Column Name |
Description |
Example |
Units |
Data Type |
VO UCD |
|---|
| BANDWD | Total observing bandwidth | 1000000000 | Hz | float | none |
| DECDELT | Dec increment per pixel | 0.00416667 | deg | float | none |
| DECERR | none | 0.0 | deg | float | none |
| DECMAX | Field Dec maximum | -5.829167 | deg | float | none |
| DECMIN | Field Dec minimum | -10.133333 | deg | float | none |
| DECPIXELS | Number of pixels, Dec axis | 1034 | none | float | none |
| DECREF | Dec coordinate at DECREFPIXEL | -8.00416667 | deg | float | none |
| DECREFPIX | Dec axis reference pixel | 513 | none | float | none |
| FIELDNAME | Observing field name supplied by the observer | C0552M08 | none | varchar | obs.field |
| FILESIZE | Image file size | 6459392 | byte | float | none |
| FREQINCRE | Frequency increment per pixel | 100000000 | Hz | float | none |
| FREQUENCY | Observing Frequency | 1400000000 | Hz | float | none |
| IMAGEDATE | Date of image creation (MJD) | 50918 | d | float | none |
| IMAGEMAX | Maximum intensity in image | 0.8937966 | Jy | float | none |
| IMAGEMIN | Minimum intensity in image | -0.01464416 | Jy | float | none |
| IMAGEQUAL | none | A | none | float | none |
| IMAGESCALE | none | 0.0001 | none | float | pos.wcs.scale |
| IMAGESENS | Image background rms | 0.00045 | Jy | float | none |
| IMAGEUNITS | Image units (Jy/beam) | JY/BEAM | none | varchar | none |
| IMAGEZERO | none | 0 | none | float | none |
| INSTRUMENT | none | L-BAND | none | varchar | none |
| MIDOBSTIME | Middle obs. time of image (MJD) | 49250 | d | float | none |
| NAXES | Number of axes in the image | 4 | none | float | pos.wcs.naxes |
| NPOLAR | Number of polarization pixels | 3 | none | float | none |
| NSPECT | Number of spectral pixels | 1 | none | float | none |
| OBSBAND | Observing Frequency band code | L | none | float | none |
| PHOTOERR | none | 0.0 | none | float | none |
| POLPIXELS | Polarization pixel polarization codes (I,Q,U,V) | i q u | none | varchar | none |
| PROJECTION | International Celestial Ref. Frame - SIN | SIN | none | varchar | pos.frame |
| RADELT | RA increment per pixel | -0.00416667 | deg | float | none |
| RAERR | none | 0.0 | deg | float | none |
| RAMAX | Field RA maximum | 88.0 | deg | float | none |
| RAMIN | Field RA minimum | 85.870833 | deg | float | none |
| RAPIXELS | none | 1024 | arcmin | float | none |
| RAREF | RA coordinate at RAREFPIXEL | 88.8 | deg | float | none |
| RAREFPIX | RA axis reference pixel | 512 | none | float | none |
| REFREQPIX | Sky frequency at first spectral pixel | 1400000000 | Hz | float | none |
| REFURL | Retrieve image using VO Simple Image Access Protocol | https://archive.nrao.edu/vo/SIA/getImage?archive=NVSS&fileID=C0552M08.fits | none | float | none |
| REGION | Image field shape | POLYGON | none | varchar | none |
| RESTOREMAJ | Restoring beam major axis | 0.0125 | arcmin | float | none |
| RESTOREMIN | Restoring beam minor axis | 0.0125 | arcmin | float | none |
| RESTOREPA | Restoring beam position angle | 0.0 | deg | float | none |
| ROTANGLE | Image field rotation angle | 0.0 | deg | float | none |
| SPECTERR | none | 0.0 | Hz | float | none |
NRAO E2E Archive DB MetaData Catagory: Scripts/LOgs
|
Column Name |
Description |
Example |
Units |
Data Type |
|
|---|
| OBSFILES | none | ak634.e.a.a.004.obs | none | float |
| DYNAMIC_TAG | none | none | none | float |
| SCHED_TYPE | none | SCHED | none | float |
|