NRAO E2E Archive (EVLA, VLA, VLBA) - Database Table Schema
(DB name : ARCHIVE, Host : chewbacca.aoc.nrao.edu, Oracle 11g)
(Document revised : 2011-May-19 JMB)
NRAO E2E Archive DB Table: 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 |
Data Type |
Example |
Comments |
|---|
| PROJECT_CODE | varchar2(16) | (VLA) AB0973
(EVLA) 10B-123
(VLBA) BC0432 | Observing Program Name (Project Code) |
| OBSERVER | varchar2(48) | Benson, John | Observer name present in data files |
| OBSERVER_ID | number | 266 | Observer NRAO ID number |
| STARTTIME | number | 51862.0065494 | First data time for this program in this file |
| STOPTIME | number |
51862.8362947 | Last data time for this program in this file |
| PROPRIETARY | number |
52410.8362947 | Proprietary period expires, data beomes public. |
| TELESCOPE | varchar2(12) | VLA | Telescope Name |
| TELESCOPE_CONFIG | varchar2(8) | A | Telescope Configuration; VLA : A, B, C, D, etc. |
| OBS_BANDS | varchar2(16) | X | List of observing frequency bands |
| TOTAL_OBS_TIME | number | 5.877 | Total observing time |
| NUM_SEGMENTS | number | 1 | Number of observing sessions (segments) |
| ARCH_FILES | number | 2 | Number of raw data archive files |
| ROW_DATE | number | 52528.23832 | |
| RAW_PROJECT_CODE | varchar2(16) | AB973 | Observing Program Name as is in the data files |
| PROJECT_LOCK | varchar2(16) | UTIME | Proprietary lock status : locked , unlocked, public |
| UNLOCK_EXPIRES | number | 0.0 | |
| GRANT_ACCESS | varchar2(16) | ALL | |
| PROPRIETARY_DURATION | number | 365.0 | Proprietary period : 365 days after last observation |
| WARNED | number | 0.0 | Count emails sent warning owner, data public |
| PROJECT_ID | number | 12345678 | Observing project tag in PDS db (EVLA only) |
NRAO E2E Archive DB Table: ARCHIVE
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 |
Data Type |
Example |
Comments |
|---|
| PROJECT_CODE | varchar2(16) | (VLA) AB0973
(EVLA) 10B-123
(VLBA) BC0432 | Observing Program Name (Project Code) |
| SEGMENT | varchar2(4) | A | Note 1. Observing session during observing program |
| STARTTIME | number | 51862.12928241 | First data time for this program in this file |
| STOPTIME | number |
51862.83645833 | Last data time for this program in this file |
| TELESCOPE | varchar2(12) | VLA | Telescope Name |
| TELESCOPE_CONFIG | varchar2(8) | A | Telescope Configuration; VLA, EVLA : A, B, C, D, etc. |
| ARCH_FORMAT | varchar2(8) | VLA Exp | Data format : SDMset, FITS-IDI, FITS-AIPS, VLA Exp |
| DATA_TYPE | varchar2(12) | raw | raw or cal (calibrated) |
| SUBARRAY_ID | number | 1 | Subarray id number |
| ARCH_FILE_ID | number | 181751519 | Unique key for this program (project) in this file |
| ARCH_FILE | varchar2(96) | (VLA) VLA_XH00149_file_7.dat
(EVLA) 10C-211_sb2561443_1.55642.0928 | Archived file (set) name |
| ARCH_FILE_DATE | number | - | not used |
| CATALOG_DATE | number | 53647.89721065 | Date of DB entry |
| FILE_SIZE | number | 144589 | File size in kBytes |
| RAW_PROJECT_CODE | varchar2(16) | AB973 | Project code embedded in data file |
| ANNEX1_ID | number | - | not used |
| OBS_BANDS | varchar2(16) | X | List of observing band codes |
| PROJECT_ID | number(19) | 12345678 | Observing project tag in PDS db (EVLA) |
| SB_ID | number(19) | 12345678 | Scheduling block tag in PDS db (EVLA) |
| EB_ID | number(19) | 12345678 | Execution block tag in PDS db (EVLA) |
NRAO E2E Archive DB Table: ARCHFILELOCATION
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 |
Data Type |
Example |
Comments |
|---|
| SITE_CODE | varchar2(8) |
AOC | File Location Key : AOC, EVLA, CV, etc. |
| ARCH_FILE_ID | number |
0 | not used |
| ROOT_DIRECTORY | varchar2(128) |
ngas_host | Path to file in archive disk array |
| ARCH_FILE | varchar2(128) |
(VLA) VLA_XH00149_file7.dat
(EVLA) 10C-211_sb2561443_1.55642.0928 | File or File Set Name |
| MIMETYPE | varchar2(80) |
application/x-vla;datamodel=vla-exp
application/x-sdm or /x-bdf | Data model for VLA, VLBA, FITS, SDM, BDF |
| COMMON_FILE_ID | varchar2(64) |
none | Used to connect images with uv data files |
| NGAS_HOST | varchar2(64) |
aocngas-master.aoc.nrao.edu:7777 | NGAS node hosting this file |
NRAO E2E Archive DB Table: NGAS_FILE_SETS
The NGAS_File_Sets Table associates individual files with a common membership in a file set. The file_set_id will be based on
the observing block name (for EVLA ASDM file sets). Besides ASDM/BDF files sets, this table may contain calibrated data
products from historical VLA and VLBA data.
This table has been modified to describe file set memberships for advanced data products that are returned to the archive from outside users or processes. JMB 2011-Jan-19.
|
Column Name |
Data Type |
Example |
Comments |
|---|
| FILE_SET_ID | varchar2(64) |
Xtestobs_091.54782.123456 | File Set Name |
| FILE_SUBSET_ID | varchar2(64) |
Xtestobs_091.54782.123456_3C84 | File Sub-Set Name |
| FILE_ID | varchar2(64) |
uid___evla_bdf_X1227136037120.bdf | Individual File Name (in NGAS) |
| FILE_VERSION | number |
1 | NGAS file version number |
| ENTITY_TYPE_NAME | varchar2(32) |
bdf | File Type Description:
sdm, bdf, image, plot, log, etc |
| ENTITY_ID | varchar2(48) |
uid://evla/bdf/X1227136037120 | ASDM UID (for EVLA) |
| FORMAT | varchar2(48) |
application/x-uvfits OR
package.task.file-format.data-type
aips.fittp.fits.vis
aips.fittp.fits.image
aips.task.jpg.uv | Mime-type for NGAS OR
package.task.format.type |
| NATIVE_EXT | varchar2(24) |
xml | ASDM std file ext |
| FILE_ID_ALIAS | varchar2(128) |
BP131B_FPOL4IF8MHZ16CH_43.2015GHZ00.uvfits_ | User/process supplied |
NRAO E2E Archive DB Table: FILE_SET_PROPERTIES
Contains the high level meta-data which describes advanced data product file sets.
Currently (2011-04-08), a set of metadata is being discussed by the VO project for file set description. When they have settled on a
standard set of metadata items,
this table will be modified accordingly.
|
Column Name |
Data Type |
Example |
Comments |
|---|
| FILE_SET_ID | varchar2(128) |
AB1234_2010JUN06_1 | File Set Name |
| FILE_SET_ALIAS | varchar2(128) |
| User/process supplied |
| FILE_SET_CATEGORY | varchar2(32) |
PROJECT or POSITION | xxxxx |
| N_FILE_SUBSETS | number |
0 or 1, or 2.. | NUmber of file subsets in this file set |
| CATEGORY_ID | varchar2(48) |
'10B-205' or 'J015950.2+002344' | xxxxx |
| COLLECTION | varchar2(48) |
'VLA_PIPE' | Collection membership |
| CALIB_LEVEL | number |
0 | Calibration level :
0 = raw data
1 = partially calibrated
2 = science ready
3 = enhanced product |
| STARTTIME | number |
55510.50 | Time of first data point |
| STOPTIME | number |
55510.85 | Time of last data point |
| TELESCOPE | varchar2(32) |
EVLA | Observing telescope |
| TELESCOPE_CONFIG | varchar2(48) |
A,B | Telescope array configurations |
| OBS_BANDS | varchar2(48) |
K,X | Observing bands |
| PROCESS_HISTORY | varchar2(128) |
xxxxx | User/process supplied |
NRAO E2E Archive DB Table: OBSSET
The ObsSet Table is a pretty close representation of the IVOA ObsCore data model. This table describes
observations of a single target that were conducted within a single observing project. Each table row
is keyed to rows in the NGAS_FILE_SETS and FILE_SET_PROPERTIES tables. The file set data described this
table are calibrated science products.
|
Column Name |
Data Type |
ObsCore Type |
UCD |
Example |
Comments |
|---|
| DATAPRODUCT_TYPE | varchar2(24) |
Obs.dataProductType | meta.id;class | image | |
| CALIB_LEVEL | number |
Obs.calibLevel | meta.id;class | 1 | |
| OBS_COLLECTION | varchar2(48) |
DataID.Collection | meta.id | VLBA_PIPE | |
| FILE_SET_ID | varchar2(128) |
DataID.Creatordid | meta.id | BL0149_080912_275608817 | |
| FILE_SUBSET_ID | varchar2(128) |
DataID.Creatordid | meta.id | 0355+508 | |
| FILE_ID | varchar2(128) |
DataID.Creatordid | meta.id | BL0149_BC_2cm_0355+508.ICalSC.fits | |
| OBS_PUBLISHER_DID | varchar2(48) |
Curation.PublisherDID | meta.ref.url | | |
| ACCESS_URL | varchar2(128) |
Access.Reference | meta.ref.url | http://archive.nrao.edu/archive/ArchiveDeliver | |
| TARGET_NAME | varchar2(48) |
Target.Name | meta.id;src | 0355+508 | |
| S_RA | number |
| pos.eq.ra | 59.8739469667 | |
| S_DEC | number |
| pos.eq.dec | 50.9639338333 | |
| S_FOV | number |
| phys.angSize;instr.fov | | |
| S_REGION | number |
| phys.area;obs | | |
| S_RESOLUTION | number |
| pos.angResolution | 3.24500000204e-08 | |
| T_MIN | number |
| time.start.obsExposure | | |
| T_MAX | number |
| time.stop.obsExposure | | |
| T_EXPTIME | number |
| time.duration.obsExposure | 0.0301170051098 | |
| T_RESOLUTION | number |
| time.resolution | | |
| EM_MIN | number |
| em.wl;stat.min | | |
| EM_MAX | number |
| em.wl;stat.max | | |
| EM_RES_POWER | number |
| spec.resolution | | |
| O_UCD | varchar2(128) |
| meta.ucd | | |
| PROJECT_CODE | varchar2(24) |
| meta.project | BL0149 | |
| ARCH_FILE_ID | number |
| meta.id | 275608817 | |
NRAO E2E Archive DB Table: OBSSET (optional fields)
Optional fields that may be added to the OBSSET Table (IVOA ObsCore Data Model).
|
Column Name |
Data Type |
ObsCore Type |
UCD |
Example |
Comments |
|---|
| DATAPRODUCT_SUBTYPE | varchar2(24) |
Obs.dataProductSubType | meta.id;class | image | |
| TARGET_CLASS | varchar2(24) |
Target.Class | src.class | | |
| OBS_CREATION_DATE | varchar2(24) |
DataID.Date | time;meta.dataset | 2008-09-12 | |
| OBS_CREATOR_NAME | varchar2(24) |
DataID.Creator | meta.id;creator | | |
| OBS_TITLE | varchar2(24) |
DataID.Title | meta.title;obs | | |
| PUBLISHER_ID | varchar2(24) |
Curation.PublisherID | meta.ref.url;meta.creation | | |
| BIB_REFERENCE | varchar2(24) |
Curation.Reference | meta.bib.bibcode | | |
| DATA_RIGHTS | varchar2(24) |
Curation.Rights | meta.code | | |
| OBS_RELEASE_DATE | varchar2(24) |
Curation.releaseDate | time.release | | |
| S_UCD | varchar2(24) |
Char.SpatialAxis.ucd | meta.ucd | | |
| S_RESOLUTION_MIN | number |
Char.SpatialAxis.Resolution.Bounds.
Limits.Interval.LoLim | pos.angleResolution;stat_min | 1.6342424658e-0 | |
| S_RESOLUTION_MAX | number |
Char.SpatialAxis.Resolution.Bounds.
Limits.Interval.HiLim | pos.angleResolution;stat_max | 1.98634879212e-07 | |
| S_CALIB_STATUS | varchar2(48) |
Char.SpatialAxis.calibStatus | meta.code.qual | | |
| S_STAT_ERROR | number |
Char.SpatialAxis.Accuracy.
statError.refval.value | stat.error;pos.eq | | |
| T_CALIB_STATUS | varchar2(48) |
Char.TimeAxis.calibStatus | meta.code.qual | | |
| T_STAT_ERROR | number |
Chae.TimeAxis.Accuracy.
StstError.refval.value | stat.error;time | | |
| EM_UCD | varchar2(48) |
Char.SpectralAxis.ucd | meta.ucd | | |
| EM_UNIT | varchar2(24) |
Char.SpectralAxis.unit | meta.unit | | |
| EM_RES_POWER_MIN | number |
Char.SpectralAxis.Resolution.
resolPower.LoLim | spect.resolution;stat.min | | |
| EM_RES_POWER_MAX | number |
Char.SpectralAxis.Resolution.
resolPower.LoLim | spect.resolution;stat.max | | |
| EM_RESOLUTION | number |
Char.SpectralAxis.Resolution.refval.value | spect.resolution;stat.mean | | |
| EM_STAT_ERROR | number |
Char.SpectralAxis.Accuracy.
StatError.refval.value.value | stat.error;em | | |
| O_UNIT | varchar2(24) |
Char.ObservableAxis.unit | meta.unit | | |
| O_CALIB_STATUS | varchar2(24) |
Char.ObservableAxis.calibStatus | meta.code.qual | | |
| FACILITY | varchar2(24) |
Provenance.ObsConfig.
Facility.name | meta.code | NRAO | |
| INSTRUMENT | varchar2(24) |
Provenance.ObsConfig.
Instrument.name | meta.id;instr | VLBA | |
| PROPOSAL | varchar2(24) |
Provenance.ProposalID | meta.id;obs.proposal | BL0149 | |
NRAO E2E Archive DB Table: OBSERVATION
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 |
Data Type |
Example |
Comments |
|---|
| PROJECT_CODE | varchar2(16) | AB0973 |
Observing Program Name (Project Code) |
| SEGMENT | varchar2(4) | A |
Observing session during observing program |
| OBS_TYPE | varchar2(4) | OBS |
Obs type : OBS, CAL, TRACK, POINT, RASTER
For ASDM file sets, these are based on scan_intent |
| STARTTIME | number | 51862.0066 | First data time in this onbserving scan |
| STOPTIME | number |
51862.013 | Last data time in this observing scan |
| SOURCE_ID | varchar2(16) | I16288+392 |
Source or pointing position name |
| SOURCE_TYPE | varchar2(8) | STAR |
currently not used |
| CALIB_TYPE | varchar2(8) | |
Calibrator source quality : A, B, etc |
| CORR_MODE | varchar2(6) | |
VLA correlator modes only |
| RA2000 | number | 4.32206798 | Observed sky position, RA J2000 (radians) |
| DEC2000 | number |
0.687384002 | Observed sky position, DEC J2000 (radians) |
| FRAME | varchar2(20) |
ICRF | Sky coordinates reference frame |
| SUBARRAY_ID | number | 1 | VLA sub array id number |
| ARCH_FILE_ID | number | 181751519 | Unique key for table row in ARCHIVE table |
| DATA_DESC_ID | number | 181751519 | Unique key for observing freq rows in table DATADESC |
| SUB_DESC_ID | iarray_type | 1,2 | Array of sub band indexs in table DATADESC that are linked to this observing scan. |
| EXPOSURE | number | 560 | Scheduled time on source (secs) |
| INTERVAL | number | 10 | Average interval (secs) |
| UV_MIN | number | 0.0 | Currently not used |
| UV_MAX | number | 0.0 | Currently not used |
| ELEV_MIN | number | 0.0 | Currently not used |
| ELEV_MAX | number | 0.0 | Currently not used |
| N_ANTS | number | 26 |
Number of antennas in this subarray |
| RA_EPOCH | number | 0.0 | RA 1950 |
| DEC_EPOCH | number | 0.0 | DEC 1950 |
| BDF_FILE | varchar2(64) | none | ASDM bdf file name for this subscan |
| CONFIG_DESC_ID | varchar2(48) | none | ASDM ConfigDescriptionId tag |
| SCAN | number | 0 | Scan number from ASDM |
| SUBSCAN | number | 0 | Subscan numbers from ASDM |
| SCAN_INTENT | varchar2(256) | intent list | ASDM Scan Intents |
NRAO E2E Archive DB Table: DATADESC
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 |
Data Type |
Example |
Comments |
|---|
| PROJECT_CODE | varchar2(16) | AB0973 | Observing Program Name (Project Code) |
| SEGMENT | varchar2(4) | A | Observing session during observing program |
| ARCH_FILE_ID | number | 181751519 | Unique key for this program in this file |
| DATA_DESC_ID | number | 181751519 | Unique key for observing freqs in this program in this file |
| SUB_DESC_ID | number | 1 | Sub-band index; 1-n |
| IF_BAND | varchar2(4) | X | Obs Band code (actually): 4, P, L, C, X, U, K, Q |
| RECEIVER_ID | number | -1 | VLA, VLBA not used |
| IF_REF_FREQ | number | 8435100000 | ... in Hz |
| POL1 | number | 5 | Polarization code, index 1 - 4 : I, Q, U, V |
| POL2 | number | 8 | Polarization code, index 5 - 8 : RR, RL, LR, LL |
| POL3 | number | 6 | Polarization code, index 9 - 12: XX, XY, YX, YY |
| POL4 | number | 7 | Polarization code, index 13 - 20 : RX, RY, LX, LY, XR, XL, YR, YL |
| IF_CONV_CHAIN | number | 0 | VLA, VLBA not used |
| SUB_CHAN_ID | number | 1 | Sub-band channel id |
| SUB_REF_FREQ | number | 8435100000 | Sub band reference Frequency (Hz) |
| SUB_BANDW | number | 50000000 | Sub band bandwidth (Hz) |
| SUB_POL1 | number | 5 | Subband polarization code |
| SUB_POL2 | number | 8 |
Subband polarization code |
| SUB_POL3 | number | 6 | Subband polarization code |
| SUB_POL4 | number | 7 | Subband polarization code |
| SUB_NET_SIDEBAND | number | 1 | Subband net sideband, +1 or -1 |
| SUB_NUM_CHANS | number | 1 | N spectral channels for this subband |
| CORR_MODE | varchar2(8) | | Subband correlator mode |
| IF_CHAN | varchar2(8) | X | IF Band Code (VLA) : AC, BD |
NRAO E2E Archive DB Table: OBSSUMMARY
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 table replaces complicated, slow queries based on the tables
above. The OBSSUMMARY Table is updated once per day by an automated process.
|
Column Name |
Data Type |
Example |
Comments |
Units |
VO UCD |
|---|
| PROJECT_CODE | varchar2(16) | AB0973
| Observing Program Name (Project Code) | | obs.proposal | >
| SOURCE_ID | varchar2(16) | I16288+39
| Source or pointing position name | | src.name |
| IF_BAND | varchar2(4) | X | Obs Band code (actually): 4, P, L, C, X, U, K, Q | | inst.bandpass |
| SUB_REF_FREQ | number | 8435100000 | Sub band reference Frequency | Hz | em.freq |
| STARTTIME | number | 51862.0066 | First data time in this onbserving scan | MJD days | time.start |
| STOPTIME | number |
51862.013 | Last data time in this observing scan | MJD days | time.end |
| EXPOSURE | number | 560 | Scheduled time on source | secs | obs.exposure |
| SUB_BANDW | number | 50000000 | Sub band bandwidth | Hz | inst.bandwidth |
| TELESCOPE | varchar2(12) | VLA | Telescope Name | | inst.tel |
| TELESCOPE_CONFIG | varchar2(8) | A | Telescope Configuration; VLA : A, B, C, D, etc. | | inst.tel.setup |
| SUB_NUM_CHANS | number | 1 | N spectral channels for this subband | | spect.resolution |
| RA2000 | number | 4.32206798 | Observed sky position, RA J2000 | radians | pos.eq.ra |
| DEC2000 | number |
0.687384002 | Observed sky position, DEC J2000 | radians | pos.eq.dec |
| PROJECT_LOCK | varchar2(16) | UTIME | Proprietary lock status : locked , unlocked, public | | meta.code.status |
| SUB_POL1 | number | 5 | Subband polarization code | | |
| SUB_POL2 | number | 8 |
Subband polarization code | | |
| SUB_POL3 | number | 6 | Subband polarization code | | |
| SUB_POL4 | number | 7 | Subband polarization code | | |
| SUBARRAY_ID | number | 1 | VLA sub array id number | | inst.tel.subArray |
| CORR_MODE | varchar2(8) | | Subband correlator mode | | |
| IF_CHAN | varchar2(8) | X | IF Band Code (VLA) : AC, BD | | |
| N_ANTS | number | 26 |
Number of antennas in this subarray | | |
| ARCH_FILE_ID | number | 181751519 | Unique key for this program in this file | | meta.file.id |
| N_IMAGES | number | 26 |
Number of images for this observation row | | |
| OBSSUMMARY_UID | varchar2(48) | uid://vla/1/123456789 |
EVLA/ALMA SDM format uid | | meta.ref.uri |
| FILE_SET_ID | varchar2(64) | 181751519 | EVLA/ALMA SDM file set identifier | | meta.file.sdmSet |
| RADEG | number | 191.23456 | Observed sky position, RA J2000 | deg | pos.eq.ra |
| DECDEG | number |
21.432156 | Observed sky position, DEC J2000 | deg | pos.eq.dec |
| DISTANCE | number |
0.012 | This column does not exist | arcmin | |
| RMS | number |
0.01 | This column does not exist | mJy/beam | |
| RESOL | number |
0.012 | This column does not exist | arcsec | |
| FOV | number |
0.01 | This column does not exist | arcmin | |
| POLAR | varchar2(16) |
RR,LL,RL,LR | This column does not exist | | |
NRAO E2E Archive DB Table: 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 |
Data Type |
Example |
Comments |
|---|
| IDENTITY | varchar2(16) | NVSS |
- |
| COLLECTION | varchar2(24) | NVSS | Survey name, or VLA Users, or VLBA Users |
| TELESCOPE | varchar2(12) | VLA | Telescope Name |
| TELESCOPE_CONFIG | varchar2(8) | CD | Telescope Configuration; VLA : A, B, C, D, etc. |
| INSTRUMENT | varchar2(24) | L-BAND | |
| OBSERVER | varchar2(48) | NVSS | Observer name present in data files |
| PROJECTCODE | varchar2(16) | NVSS | Observing Program Name (Project Code) |
| FIELDNAME | varchar2(24) | C0552M08 | Observing field name supplied by the observer |
| NAXES | number | 4 | Number of axes in the image | <
| IMAGEMAX | number | 0.8937966 | Maximum Intensity (Jy) |
| IMAGEMIN | number | -0.01464416 | Minimum Intensity (Jy) |
| IMAGESENS | number | 0.00045 | Image background rms (Jy) |
| IMAGESCALE | number | 0.0001 | .. |
| IMAGEZERO | number | 0 | .. |
| IMAGEUNITS | varchar2(16) | JY/BEAM | |
| RESTOREMAJ | number | 0.0125 | Restoring beam major axis (arcmin) |
| RESTOREMIN | number | 0.0125 | Restoring beam minor axis (arcmin) |
| RESTOREPA | number | 0.0 | Restoring beam position angle (deg) |
| FIRSTTIME | number | 49250 | .. |
| MIDOBSTIME | number | 49250 | .. |
| EXPOSURE | number | 0.0 | Total observing time on this field |
| IMAGEDATE | number | 50918 | Data Analysis - image creation |
| COORDFRAME | varchar2(16) | ICRF | .. |
| PROJECTION | varchar2(16) | SIN | International Celestial Ref. Frame |
| EQUINOX | number | 2000 | J2000 |
| REGION | varchar2(16) | POLYGON | Image field shape |
| RACENTER | number | 88.0 | Field center RA (degrees) |
| DECCENTER | number | -8.0 | Field center Dec (degrees).. |
| RAMIN | number | 85.870833 | Field RA minimum (degrees) |
| RAMAX | number | 88.0 | Field RA maximum (degrees) |
| DECMIN | number | -10.133333 | Field Dec minimum (degrees) |
| DECMAX | number | -5.829167 | Field Dec maximum (degrees) |
| RAREFPIXEL | number | 512 | RA axis reference pixel |
| RAREF | number | 88.0 | RA coordinate at RAREFPIXEL (degrees) |
| RADELT | number | -0.00416667 | RA increment per pixel (degrees) |
| RAPIXELS | number | 1024 | Number of pixels, RA axis |
| DECREFPIXEL | number | 513 | Dec axis reference pixel |
| DECREF | number | -8.00416667 | Dec coordinate at DECREFPIXEL |
| DECDELT | number | 0.0 | Dec increment per pixel (degrees) |
| DECPIXELS | number | 1034 | Number of pixels, Dec axis |
| ROTANGLE | number | 0.0 | Image field rotation angle (degrees) |
| OBSBAND | varchar2(8) | L | Observing Frequency band code |
| FREQUENCY | number | 1400000000 | Observing frequency (HZ) |
| BANDWD | number | 1000000000 | Total observing bandwidth (Hz) |
| NSPECT | number | 1 | Number of spectral pixels |
| REFFREQ | number | 1400000000 | Sky frequency at first spectral pixel (Hz) |
| FREQINCRE | number | 100000000 | Frequency increment per pixel (Hz) |
| NPOLAR | number | 3 | Number of polarization pixels |
| POLPIXELS | varchar2(12) | I Q U | Polarization pixel polarization codes |
| IMAGEQUAL | varchar2(6) | A | .. |
| PHOTOERR | number | 0.0 | .. |
| RAERR | number | 0.0 | .. |
| DECERR | number | 0.0 | .. |
| SPECTERR | number | 0.0 | .. |
| IMAGEFILE | varchar2(48) | C0552M08.fits | .. |
| IMAGEFORMAT | varchar2(32) | image/fits | .. |
| ROOTDIRECTORY | varchar2(64) | ../archive/results/surveys/NVSS | .. |
| REFURL | varchar2(128) | https://archive.nrao.edu/vo/SIA/getImage?
archive=NVSS&fileID=C0552M08.fits | Retrieve image using VO Simple Image Access Protocol - NRAO server |
| FILESIZE | number | 6459392 | .. |
| ARCH_FILE_ID | number | 226562914 | .. |
| COMMON_FILE_ID | varchar2(80) | C0552M08 | .. |
NRAO E2E Archive DB Table: ANTENNA
|
Column Name |
Data Type |
Example |
Comments |
|---|
| PROJECT_CODE | varchar2(16) | AB0973 | Observing Program Name (Project Code) |
| SEGMENT | varchar2(4) | A | Observing session during observing program |
| ARCH_FILE_ID | number | 181751519 | Unique key for this program in this file |
| NAME | varchar2(12) | 16 | Antenna name, VLA antenna number |
| STATION | varchar2(12) | VLA:W48 | VLA Antenna Location; VLBA Station ID |
| MOUNT | varchar2(8) | ALT-AZ | Alt-az, Equatorial |
| DISH_DIAMETER | number | 25 | Diameter in meters |
| ANTENNA_TYPE | varchar2(14) | GROUND-BASED | Ground or space based |
| AXIS_OFF | number | 0 | Axis intersection offset in meters |
| FRAME | varchar2(12) | ITRF | Coordinate frame |
NRAO E2E Archive DB Table: OBSSCRIPT
|
Column Name |
Data Type |
Example |
Comments |
|---|
| PROJECT_CODE | varchar2(16) | AB0973 | Observing Program Name (Project Code) |
| RAW_PROJECT_CODE | varchar2(16) | AB973 | Project code embedded in data file |
| OBSERVER | varchar2(48) | Benson, John | Observer name present in data files |
| STARTTIME | number | 51862.12928241 | First data time for this program in this file |
| STOPTIME | number |
51862.83645833 | Last data time for this program in this file |
| DYNAMIC_TAG | varchar2(16) | | nya |
| TELESCOPE | varchar2(12) | VLA | Telescope Name |
| SCHED_TYPE | varchar2(12) | | nya |
| SITE_CODE | varchar2(8) |
AOC | File Location Key : AOC, EVLA, CV, etc. |
| ROOT_DIRECTORY | varchar2(128) |
../archive/operations/VLA/observe/2006-09 | Path to script file in archive disk array |
| FILE_NAME | varchar2(128) |
732K634.OBS | Script File Name |
| MIMETYPE | varchar2(80) |
text/vla-observe | |
NRAO E2E Archive DB Table: LOGFILES
|
Column Name |
Data Type |
Example |
Comments |
|---|
| PROJECT_CODE | varchar2(16) | AB0973 | Observing Program Name (Project Code) |
| RAW_PROJECT_CODE | varchar2(16) | AB973 | Project code embedded in data file |
| OBSERVER | varchar2(48) | Benson, John | Observer name present in data files |
| STARTTIME | number | 51862.12928241 | First data time for this program in this file |
| STOPTIME | number |
51862.83645833 | Last data time for this program in this file |
| DYNAMIC_TAG | varchar2(16) | | nya |
| TELESCOPE | varchar2(12) | VLA | Telescope Name |
| SCHED_TYPE | varchar2(12) | SCHED | nya |
| SITE_CODE | varchar2(8) |
AOC | File Location Key : AOC, EVLA, CV, etc. |
| ROOT_DIRECTORY | varchar2(128) |
../archive/logs/VLA/observe/2006-09 | Path to log file in archive disk array |
| FILE_NAME | varchar2(128) |
2006-10-05_2314_AR603.txt | Logical File Name |
| MIMETYPE | varchar2(80) |
text/vla-oprlog | |
| OBSFILES | varchar2(128) |
| Observe control script for this log file |
Notes
|