NRAO Archive DB Tables < Main

NRAO E2E Archive (EVLA, VLA, VLBA) - Database MetaData Listing
(DB name : ARCHIVE, Host : chewbacca.aoc.nrao.edu, Oracle 11g)
(Document Version : 2009-Aug-27 JMB) - IGNORE THE TEXT IN THIS VERSION

NRAO E2E Archive DB MetaData Catagory : PROJECT
The Project Table contains a one row description of observing programs (projects) for the VLA, VLBA and EVLA. The observer's name and observer's id are what is found in the archived data files. Aside from user browsing, the main use of the Project Table is that it carries the project proprietary staus and expiration data.

Column Name	Description	Example	Units	Data Type
ARCH_FILES	Number of raw data archive files	2	none	float
COLLECTION	Survey name, or VLA Users, or VLBA Users	NVSS	none	varchar
DATE_EXPIRES	none	none	none	float
EMAIL_ADDR	none	none	none	float
ENTRY_DATE	none	none	none	float
GRANT_ACCESS	Grant access to who	ALL	none	varchar
IDENTITY	none	NVSS	none	varchar
KEYWORD	none	eqL4W2Bp	none	float
NUM_SEGMENTS	Number of observing sessions (segments)	1	none	float
OBSERVER	Observer name present in data files	Benson, John	none	varchar
OBSERVER_ID	Observer NRAO ID number	999	none	float
PROJECT_CODE	Observing Program Name	AB0973	none	varchar
PROJECT_LOCK	Proprietary lock status : locked , unlocked, public	UTIME	none	varchar
PROJECT_LOCK	Proprietary lock status : locked, unlocked, public	UTIME	none	varchar
PROPRIETARY	Proprietary period expires, data beomes public.	52410.8362947	none	float
PROPRIETARY_DURATION	Proprietary period : 365 days after last observation	365.0	d	float
RAW_PROJECT_CODE	Project code embedded in data file	AB973	none	varchar
ROW_DATE	(MJD)	52528.23832	d	float
STARTTIME	First data time in this observation (MJD)	51862.0065494	d	double
STOPTIME	Last data time in this observation (MJD)	51862.8362947	d	double
TOTAL_OBS_TIME	Total observing time	5.877	hour	float
UNLOCK_EXPIRE	(MJD)	0.0	d	float
WARNED	Count emails sent warning owner, data public	0.0	none	float

NRAO E2E Archive DB MetaData Catagory : Observing Scans
The Archive Table summarizes observations by project code and archive file. That is, there is one row in the Archive Table for all data within a single archive file for an individual observing project. This table is the basis of what is displayed to users searching for their observations and guides the selection of data to retrieve from the archive.

Column Name	Description	Example	Units	Data Type
DEC_EPOCH	DEC 1950	0.0	rad	float
DISTANCE	Distance between the query search and observing positions	0.0012	deg	float
ELEV_MAX	not used	none	deg	float
ELEV_MIN	not used	none	deg	float
EXPOSURE	Scheduled time on source	560	s	float
FOV	Field of view	0.01	arcmin	float
INTERVAL	Averaging interval	10	s	float
N_IMAGES	Number of images for this observation row	1	none	int
OBS_TYPE	Obs type : TRACK, POINT, RASTER	TRACK	none	varchar
RA_EPOCH	RA 1950	0.0	rad	float
RESOL	Best angular resolution from this data	0.012	arcsec	float
RMS	Estimated background noise (mJy/beam)	0.01	mJy	float
STARTTIME	First data time in this observation (MJD)	51862.0065494	d	double
STOPTIME	Last data time in this observation (MJD)	51862.8362947	d	double
UV_MAX	not used	none	km	float
UV_MIN	not used	none	km	float

NRAO E2E Archive DB MetaData Catagory : Spectral Window
The Archive Table summarizes observations by project code and archive file. That is, there is one row in the Archive Table for all data within a single archive file for an individual observing project. This table is the basis of what is displayed to users searching for their observations and guides the selection of data to retrieve from the archive.

Column Name	Description	Example	Units	Data Type
DATA_DESC_ID	Unique key for observing freqs in this program in this file	181751519	none	float
IF_BAND	Obs Band code (actually): 4, P, L, C, X, U, K, Q	C	none	varchar
IF_CHAN	IF Band Code (VLA) : AC, BD	AC	none	varchar
IF_CONV_CHAIN	VLA, VLBA not used	none	none	float
IF_REF_FREQ	Reference Frequency	8435100000	Hz	float
OBS_BANDS	List of observing band codes	X	none	varchar
RECEIVER_ID	VLA, VLBA not used	none	none	float
SUB_BANDW	Sub band or spectral window bandwidth	50000000	Hz	float
SUB_CHAN_ID	Sub-band or spectral window id	1	none	int
SUB_DESC_ID	Sub-band index; 1-n	1	none	float
SUB_NET_SIDEBAND	Subband net sideband, +1 or -1	1	none	float
SUB_NUM_CHANS	N spectral channels for this subband	1	none	int
SUB_REF_FREQ	Sub band reference Frequency	8435100000	Hz	double

NRAO E2E Archive DB MetaData Catagory: Polarization
The ArchFileLocation Table contains the physical location of archived data files in the current disk array system, or in the local NGAS data repository, or data being help at off-site locations.

Column Name	Description	Example	Units	Data Type
POL1	Polarization code, index 1 - 4 : I, Q, U, V	5	none	float
POL2	Polarization code, index 5 - 8 : RR, RL, LR, LL	8	none	float
POL3	Polarization code, index 9 - 12: XX, XY, YX, YY	6	none	float
POL4	Polarization code, index 13 - 20 : RX, RY, LX, LY, XR, XL, YR, YL	7	none	float
POLAR	Polarization description: RR,LL,RL,LR	RR,LL,RL,LR	none	varchar
SUB_POL_1	Subband polarization code, index 1 - 4 : I, Q, U, V	5	none	int
SUB_POL_2	Subband polarization code, index 5 - 8 : RR, RL, LR, LL	6	none	int
SUB_POL_3	Subband polarization code, index 9 - 12: XX, XY, YX, YY	7	none	int
SUB_POL_4	Subband polarization code, index 13 - 20 : RX, RY, LX, LY, XR, XL, YR, YL	8	none	int

NRAO E2E Archive DB MetaData Catagory: Correlator
The NGAS_File_Sets Table associates members of SDM file sets. The file_set_id will be based on the observing block name.

Column Name	Description	Example	Units	Data Type
CORR_MODE	Correlator mode	none	none	varchar

NRAO E2E Archive DB MetaData Catagory: Telescope
The Observation Table is a list of observing scans. A scan is defined as a continuous observation of a single object while the observing configuration remains unchanged. For the VLA and VLBA a new scan starts when an antenna joins or leaves the observing subarray.

Column Name	Description	Example	Units	Data Type
ANTENNA_TYPE	Ground or space based	GROUND-BASED	none	varchar
AXIS_OFF	Axis intersection offset in meters	0.001	m	float
DISH_DIAMETER	Antenna Diameter in meters	25	m	float
FRAME	Terrestrial Coordinate Frame (ITRF)	ITRF	none	varchar
MOUNT	Alt-az, Equatorial	ALT-AZ	none	varchar
NAME	Antenna name, VLA antenna number	16	none	varchar
N_ANTS	Number of antennas in this subarray	26	none	int
STATION	VLA Antenna Location; VLBA Station ID	VLA:W48	none	varchar
SUBARRAY_ID	VLA sub array id number	1	none	int
TELESCOPE	Telescope name	VLA	none	varchar
TELESCOPE_CONFIG	Telescope Configuration; VLA : A, B, C, D, etc.	A	none	varchar

NRAO E2E Archive DB MetaData Catagory: Archive Data Files
The DataDesc Table contains descriptions of observing frequency and spectral window configurations. An observing scan in the Obseration Table points to a set of DataDesc rows for that obseravation. There is one DataDesc Table row for each subband in the observation.

Column Name	Description	Example	Units	Data Type
ARCH_FILE	Archive File Name	VLA/XH00149/file_7	none	varchar
ARCH_FILE_DATE	File Creation Date (MJD)	none	d	float
ARCH_FILE_ID	Unique key for this obs. program in this file	181751519	none	int
ARCH_FORMAT	Data format : FITS-IDI, FITS-AIPS, VLA Exp	VLA Exp	none	varchar
BDF_FILE	EVLA/ALMA BDF file name	uid___evla_bdf_X1227136037120.bdf	none	varchar
CATALOG_DATE	Date of DB entry (MJD)	53647.89721065	d	float
COMMON_FILE_ID	Used to connect images with uv data files	none	none	varchar
DATA_TYPE	raw or calibrated data	raw	none	varchar
ENTITY_ID	ASDM UID	uid://evla/bdf/X1227136037120	none	varchar
ENTITY_TYPE_NAME	File Type Description	bdf	none	varchar
FILE_ID	SDM/BDF File Name in NGAS Archive	uid___evla_bdf_X1227136037120.bdf	none	varchar
FILE_SET_ID	EVLA/ALMA SDM file set identifier	Xtestobs_091.54782.123456	none	varchar
FILE_SIZE	File size (kBytes)	144589	kByte	float
FILE_VERSION	NGAS archived file version number	1	none	float
IMAGEFILE	none	C0552M08.fits	none	float
IMAGEFORAMT	none	image/fits	none	float
MIMETYPE	Data model for EVLA, VLA, VLBA, FITS	application/x-vla;datamodel=vla-exp	none	varchar
NGAS_HOST	NGAS node hosting this file	none	none	varchar
OBSSUMMARY_UID	EVLA/ALMA SDM format uid, uid://vla/1/123456789	uid://vla/1/123456789	none	varchar
ROOTDIRECTORY	Directory path to image file location	/home/archive/surveys/NVSS	none	varchar
ROOT_DIRECTORY	Path to file in archive disk array	/home/archive_VLBA21/tapes	none	varchar
SITE_CODE	File Location Key : AOC, EVLA, CV, etc	AOC	none	varchar
STARTTIME	First data time in this observation (MJD)	51862.0065494	d	double
STOPTIME	Last data time in this observation (MJD)	51862.8362947	d	double

<NRAO E2E Archive DB MetaData Catagory: Source
The NGAS_File_Sets Table associates members of SDM file sets. The file_set_id will be based on the observing block name.

Column Name	Description	Example	Units	Data Type
CALIB_TYPE	Calibrator source quality : A, B, etc	A	none	varchar
DEC2000	Observed sky position, DEC J2000	0.687384002	rad	double
DECDEG	Observed sky position, DEC J2000	21.432156	deg	double
RA2000	Observed sky position, RA J2000	4.32206798	rad	double
RADEG	Observed sky position, RA J2000	191.23456	deg	double
SOURCE_ID	Source or pointing position name	I16288+392	none	varchar
SOURCE_TYPE	not used	STAR	none	float

strong>NRAO E2E Archive DB MetaData Catagory: Scripts/LOgs
The Observation Summary Table presents information from scan averages. That is, one OBSSUMMARY Table row describes all observing scans from one observing project on one day, for one source at one observing frequency. This Document is under construction - 2009-Mar-15..

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

NRAO E2E Archive DB MetaData Catagory: IMAGE
The Image Table provides a pretty complete description of image files in the archive. There are currently 125000 image/fits files archived. The metadata in this table are retrieved almost entirely from the image/fits files (created in AIPS).

Column Name	Description	Example	Units	Data Type
BANDWD	Total observing bandwidth	1000000000	Hz	float
DECDELT	Dec increment per pixel	0.00416667	deg	float
DECERR	none	0.0	deg	float
DECMAX	Field Dec maximum	-5.829167	deg	float
DECMIN	Field Dec minimum	-10.133333	deg	float
DECPIXELS	Number of pixels, Dec axis	1034	none	float
DECREF	Dec coordinate at DECREFPIXEL	-8.00416667	deg	float
DECREFPIX	Dec axis reference pixel	513	none	float
FIELDNAME	Observing field name supplied by the observer	C0552M08	none	varchar
FILESIZE	Image file size	6459392	byte	float
FREQINCRE	Frequency increment per pixel	100000000	Hz	float
FREQUENCY	Observing Frequency	1400000000	Hz	float
IMAGEDATE	Date of image creation (MJD)	50918	d	float
IMAGEMAX	Maximum intensity in image	0.8937966	Jy	float
IMAGEMIN	Minimum intensity in image	-0.01464416	Jy	float
IMAGEQUAL	none	A	none	float
IMAGESCALE	none	0.0001	none	float
IMAGESENS	Image background rms	0.00045	Jy	float
IMAGEUNITS	Image units (Jy/beam)	JY/BEAM	none	varchar
IMAGEZERO	none	0	none	float
INSTRUMENT	none	L-BAND	none	varchar
MIDOBSTIME	Middle obs. time of image (MJD)	49250	d	float
NAXES	Number of axes in the image	4	none	float
NPOLAR	Number of polarization pixels	3	none	float
NSPECT	Number of spectral pixels	1	none	float
OBSBAND	Observing Frequency band code	L	none	float
PHOTOERR	none	0.0	none	float
POLPIXELS	Polarization pixel polarization codes (I,Q,U,V)	i q u	none	varchar
PROJECTION	International Celestial Ref. Frame - SIN	SIN	none	varchar
RADELT	RA increment per pixel	-0.00416667	deg	float
RAERR	none	0.0	deg	float
RAMAX	Field RA maximum	88.0	deg	float
RAMIN	Field RA minimum	85.870833	deg	float
RAPIXELS	none	1024	arcmin	float
RAREF	RA coordinate at RAREFPIXEL	88.8	deg	float
RAREFPIX	RA axis reference pixel	512	none	float
REFREQPIX	Sky frequency at first spectral pixel	1400000000	Hz	float
REFURL	Retrieve image using VO Simple Image Access Protocol	https://archive.nrao.edu/vo/SIA/getImage?archive=NVSS&fileID=C0552M08.fits	none	float
REGION	Image field shape	POLYGON	none	varchar
RESTOREMAJ	Restoring beam major axis	0.0125	arcmin	float
RESTOREMIN	Restoring beam minor axis	0.0125	arcmin	float
RESTOREPA	Restoring beam position angle	0.0	deg	float
ROTANGLE	Image field rotation angle	0.0	deg	float
SPECTERR	none	0.0	Hz	float

Notes

Reference	Note
Note 1
Note 2