Top-header1
Schema NOAO DB » Manage your user account  |  Log in

Schema for table: voi.siap

Column Description
md5sum unknown
bandpass_id NOAO Bandpass Id
dtacqnam <File name supplied at the telescope by the observer during observations.>-{[UCD]=<meta.ref;meta.file>}
noao_id The NOAO username for this person. Needed to log in using the NOAO security system.
corn1ra Right Ascension of image corner 1.
dtpropid <DTPROPID keyword value. Assigned by iSTB system.>-{[UCD]=<meta.id;obs.proposal>}
pixflags Pix flags
corn3ra Right Ascension of image corner 3.
bunit <Brightness Units for the image pixel array, which is 'adu' for raw data; 'adu/s' for calibrated data.>-{[UCD]=<instr.scale>}
darkfil <Name of the dark reference file.>-{[UCD]=<obs.calib;meta.file>}
obsmode <OBSMODE keyword value. A newer FITS keyword indicating the type of observation mode. Older files may sometimes lack any value for this.>-{[UCD]=<meta;obs.image>}
mimetype Mime file type
corn4dec Declination of image corner 4.
obs_elev <Observatory elevation. Accurate to ~10 m.>-{[UCD]=<pos.earth.altitude;instr.obsty>}
corn2ra Right Ascension of image corner 2.
disper <DISPER keyword value. May contain shortname, description and serial number of any dispersing agent used to take the image.>-{[UCD]=<meta;instr.spect.dispersion>}
rawfile <Name of raw source file.>-{[UCD]=<obs.image;meta.file>}
survey <The survey name. As not all NOAO data are from surveys, this may be a blank value.>-{[UCD]=<meta.ref>}
dttitle <Title of observing program specified by DTPROPID.>-{[UCD]=<meta.title>}
corn1dec Declination of image corner 1.
proctype PROCTYPE keyword value. Assigned by NOAO pipeline system. Values include 'Raw', 'InstCal' (a single exposure which has been flux and astrometrically calibrated but not resampled), 'SkySub' (an InstCal frame which has been sky background subtracted), 'Resampled' (a single exposure which has been resampled to a standard orientation), and 'MasterCal' (a master calibration general created from a sequence of exposures).
depth_err <The error on the photometric depth.>-{[UCD]=<obs.param;stat.error>}
equinox <Epoch of mean equator and equinox.>-{[UCD]=<time.equinox>}
mjd_obs <Modified Julian Date of observation start. Includes fractional day, derived from DATE-OBS.>-{[UCD]=<time.start>}
dtutc <DTS time of datafile creation.>-{[UCD]=<time.creation;meta.file>}
pldname Exposures processed as a single 'filter' dataset.
corn3dec Declination of image corner 3.
rsptgrp An association denoting all exposures in the archive stackable without resampling share this 'tangent' point value.
seeing <The average FWHM of point sources in the image. In arcsec.>-{[UCD]=<instr.obsty.seeing>}
bandpass_hilimit NOAO Bandpass Hi limit value
nocslit Slit mask name.
filtid <Unique filter identification as a serial number.>-{[UCD]=<meta.id;instr.filter>}
observat <Observatory name>-{[UCD]=<meta;instr.obsty>}
naxis_length <The length of axes in the image.>-{[UCD]=<VOX:Image_Naxis>,[ARRAYSIZE]=<2>,[ARRAYDATATYPE]=<int>}
depth <The photometric depth of this image.>-{[UCD]=<obs.param>}
ha <Hour angle. Angle East or West of the meridian at observation start.>-{[UCD]=<pos.eq.ha>}
plqname Pipeline queue dataset name.
filesize File size
prodtype <Type of data product.>-{[UCD]=<meta>}
fk5coords PostGIS (FK5) coordinate for fast sky search.
magzero Magnitude zero-point for the focal plane array, defined as the brightness of a point-source that generates one detected count.
dqmask Name of corresponding Data Quality Mask
filter <FILTER keyword value. May contain shortname, description and serial number.>-{[UCD]=<meta;instr.filter>}
exposure <The duration of the exposure.>-{[UCD]=<time.duration>}
seqid Exposures processed as an (observing) sequence (NEWFIRM pipeline only, may include multiple PLDNAME).
flatfil <Name of the primary flat-field reference file.>-{[UCD]=<obs.calib.flat;meta.file>}
reject Indicates whether an image is rejected (not included) in the stack.
timesys Principle time system. Reference system for all time-related keywords. Should be 'UTC'.
naxes Number of Axes
dtnsanam <DTNSANAM keyword value. Assigned by iSTB system.>-{[UCD]=<meta.id;meta.main>}
zd <Zenith distance. Angle between zenith and the target at observation start.>-{[UCD]=<pos.az.zd>}
dtobserv DTS observatory designation. Institution responsible for scheduling this observation. One of:NOAO, WIYN, SOAR, or SMARTS.
object The object description
dtpiaffl PI institutional affiliation.
efftime <Effective exposure time. A scaled or normalized exposure time that applies to the image.>-{[UCD]=<time.duration;obs.exposure>}
ra Right ascention
dtsite <DTSITE keyword value. Assigned by iSTB system.>-{[UCD]=<meta.id;instr.obsty>}
plver <Version ID of the pipeline. Valid only when PROCTYPE is not 'Raw'.>-{[UCD]=<meta.version>}
obs_lat <Observatory latitude. Accurate to ~1 arcsec.>-{[UCD]=<pos.earth.lat;instr.obsty>}
dec Declination
obs_long <Observatory east longitude. Accurate to ~1 arcsec.>-{[UCD]=<pos.earth.lon;instr.obsty>}
dtpi <DTPI keyword value. Assigned by iSTB system.>-{[UCD]=<meta.id.PI>}
date_obs <DATEOBS keyword value.>-{[UCD]=<time.start>}
airmass <Airmass. The pathlength through the atmosphere of a target at observation start.>-{[UCD]=<obs.airMass>}
rspgrp An association denoting all exposures in a stack, including those rejected from a stack, share this value.
radesys <Principle coordinate reference frame. One of 'FK5' or 'ICRS'.>-{[UCD]=<pos.frame>}
frngfil <Name of the fringe template reference file. Valid only for some data from some CCD detectors.>-{[UCD]=<obs.calib;meta.file>}
sflatfil <Sky flat-field reference file.>-{[UCD]=<obs.calib.flat;meta.file>}
obstype <OBSTYPE keyword value. A newer FITS keyword indicating the type of observation the header holds. Older files may sometimes lack any value for this.>-{[UCD]=<meta;obs.image>}
fits_extension The FITS extension used to obtain some metadata of the file/image. Primary header value is 1.
instrument The observing instrument
telescope <Telescope used to collect the data.>-{[UCD]=<meta.id;instr.tel>}
surveyid <The survey id. As not all NOAO data are from surveys, this may be a blank value.>-{[UCD]=<meta.ref.uri>}
reference <The NOAO reference URI.>-{[UCD]=<meta.ref.uri>}
ds_ident <ADS dataset identifier. See STR 2007-02.>-{[UCD]=<meta.id;meta.ref.uri>}
magerr Magnitude zero-point error.
photclam <Bandpass central wavelength.>-{[UCD]=<instr.bandpass;em.wl.central>}
puplfil <Name of pupil ghost reference file. Used only for data from CCD cameras.>-{[UCD]=<obs.calib;meta.file>}
photfwhm <Bandpass full-width, half-max.>-{[UCD]=<instr.bandwidth>}
astrmcat <Astrometric catalog used for WCS solution.>-{[UCD]=<meta.ref;meta.table>}
corn4ra Right Ascension of image corner 4.
bandpass_unit NOAO Bandpass Units
sb_recno <DTS sequential record number. Replaces RECNO, but is not present in earlier images.>-{[UCD]=<meta.record>}
pipeline <Name of the calibration pipeline which produced the image. Valid only when PROCTYPE is not 'Raw'.>-{[UCD]=<meta.software>}
corn2dec Declination of image corner 2.
fits_data_product_id Fits Data Product Id. Interal object id.
biasfil <Bias structure reference file.>-{[UCD]=<obs.calib;meta.file>}
photbw <Photometric bandpass width.>-{[UCD]=<instr.bandpass>}
release_date <NOAO Public Release date>-{[UCD]=<time.release>}
filename <FILENAME keyword value. This is the pipeline suggested name for the file.>-{[UCD]=<meta.id;meta.main>}
bandpass_lolimit NOAO Bandpass Low limit value
prop_id The survey
instrume <Instrument used to collect the data. Appears only for select instruments, ex. 'NEWFIRM'.>-{[UCD]=<meta;instr.obsty>}
start_date Observation date
vo_id unknown
nocssn Slit mask ID/number.

Schema for table: voi.skyimage

Column Description
scale Scale
dtacqnam <DTAQUNAM keyword value. This is the original name for the file which contains the image.>-{[UCD]=<meta.id>}
corn1ra Right Ascension of image corner 1.
naxes Number of Axes
crefpixel WCS Coordinate Image pixel coordinates of the reference pixel
corn3ra Right Ascension of image corner 3.
obsmode <OBSMODE keyword value. A newer FITS keyword indicating the type of observation mode. Older files may sometimes lack any value for this.>-{[UCD]=<meta;obs.image>}
ra Right ascention
plver unknown
title <Title of observing program specified by DTPROPID.>-{[UCD]=<meta.title>}
mimetype Mime file type
dec Declination
corn4dec Declination of image corner 4.
cdmatrix WCS CD Matrix: Scale and Rotation of the Image
corn2ra Right Ascension of image corner 2.
survey <The NOAO survey name; Only survey data have a survey id.>-{[UCD]=<meta.ref>}
corn1dec Declination of image corner 1.
proctype PROCTYPE keyword value. Assigned by NOAO pipeline system. Values include 'Raw', 'InstCal' (a single exposure which has been flux and astrometrically calibrated but not resampled), 'SkySub' (an InstCal frame which has been sky background subtracted), 'Resampled' (a single exposure which has been resampled to a standard orientation), and 'MasterCal' (a master calibration general created from a sequence of exposures).
equinox <Epoch of mean equator and equinox.>-{[UCD]=<time.equinox>}
cprojection WCS Coordinate Projection
radesys <Principle coordinate reference frame. One of 'FK5' or 'ICRS'.>-{[UCD]=<pos.frame>}
site <DTSITE keyword value. Assigned by iSTB system.>-{[UCD]=<meta.id;instr.obsty>}
corn3dec Declination of image corner 3.
seeing <The average FWHM of point sources in the image. In arcsec.>-{[UCD]=<instr.obsty.seeing>}
photdpth <The photometric depth of this image.>-{[UCD]=<obs.param>}
obstype <OBSTYPE keyword value. A newer FITS keyword indicating the type of observation the header holds. Older files may sometimes lack any value for this.>-{[UCD]=<meta;obs.image>}
instrument The observing instrument
fits_header_id fits header id (internal db).
crefvalue WCS coordinates of the reference pixel
telescope <Telescope used to collect the data.>-{[UCD]=<meta.id;instr.tel>}
surveyid <The NOAO survey id; Only survey data have a survey id.>-{[UCD]=<meta.ref.uri>}
naxis_length <The length of axes in the image.>-{[UCD]=<VOX:Image_Naxis>,[ARRAYSIZE]=<2>,[ARRAYDATATYPE]=<int>}
reference <The NOAO reference URI.>-{[UCD]=<meta.ref.uri>}
magerr Magnitude zero-point error.
extension The FITS header extension of the file/image. Primary header value is 1.
corn4ra Right Ascension of image corner 4.
prodtype <Type of data product.>-{[UCD]=<meta>}
fk5coords PostGIS (FK5) point for fast sky search on center of FOV of image.
pipeline unknown
corn2dec Declination of image corner 2.
proposal <DTPROPID keyword value. Assigned by iSTB system.>-{[UCD]=<meta.id;obs.proposal>}
fits_data_product_id fits dataproduct id (internal db).
release_date <NOAO Public Release date>-{[UCD]=<time.release>}
filename <File name supplied at the telescope by the observer during observations.>-{[UCD]=<meta.ref;meta.file>}
fk5region PostGIS (FK5) 4-point polygon region for fast sky search.
magzero Magnitude zero-point for the focal plane array, defined as the brightness of a point-source that generates one detected count.
start_date Observation date
pi <DTPI keyword value. Assigned by iSTB system.>-{[UCD]=<meta.id.PI>}

Schema for table: viewspace.siap_all_collection

Column Description
md5sum unknown
dtacqnam unknown
noao_id unknown
dtpropid unknown
bunit unknown
obsmode unknown
obs_elev unknown
dttitle unknown
rawfile unknown
disper unknown
corn2ra unknown
proctype unknown
equinox unknown
mjd_obs unknown
corn3dec unknown
bandpass_hilimit unknown
filtid unknown
naxis_length unknown
ha unknown
plqname unknown
filesize unknown
prodtype unknown
fk5coords unknown
dqmask unknown
flatfil unknown
seqid unknown
timesys unknown
dtpiaffl unknown
obs_lat unknown
dec unknown
dtpi unknown
date_obs unknown
rspgrp unknown
radesys unknown
sflatfil unknown
obstype unknown
fits_extension unknown
telescope unknown
surveyid unknown
ds_ident unknown
magerr unknown
puplfil unknown
astrmcat unknown
corn4ra unknown
sb_recno unknown
biasfil unknown
release_date unknown
photbw unknown
prop_id unknown
start_date unknown
bandpass_id unknown
corn1ra unknown
pixflags unknown
corn3ra unknown
darkfil unknown
mimetype unknown
collection_id unknown
corn4dec unknown
survey unknown
corn1dec unknown
depth_err unknown
dtutc unknown
pldname unknown
seeing unknown
rsptgrp unknown
nocslit unknown
observat unknown
depth unknown
magzero unknown
data_product_id unknown
filter unknown
exposure unknown
reject unknown
dtnsanam unknown
naxes unknown
zd unknown
dtobserv unknown
object unknown
efftime unknown
dtsite unknown
ra unknown
plver unknown
obs_long unknown
airmass unknown
frngfil unknown
instrument unknown
reference unknown
photclam unknown
photfwhm unknown
bandpass_unit unknown
pipeline unknown
fits_data_product_id unknown
corn2dec unknown
bandpass_lolimit unknown
filename unknown
instrume unknown
vo_id unknown
nocssn unknown

Schema for table: viewspace.skyimage_all_collection

Column Description
dtacqnam unknown
corn1ra unknown
crefpixel unknown
corn3ra unknown
obsmode unknown
mimetype unknown
collection_id unknown
corn4dec unknown
survey unknown
corn2ra unknown
proctype unknown
corn1dec unknown
equinox unknown
corn3dec unknown
seeing unknown
crefvalue unknown
fits_header_id unknown
naxis_length unknown
prodtype unknown
fk5coords unknown
magzero unknown
pi unknown
data_product_id unknown
scale unknown
naxes unknown
ra unknown
title unknown
plver unknown
dec unknown
cdmatrix unknown
cprojection unknown
site unknown
radesys unknown
photdpth unknown
obstype unknown
instrument unknown
telescope unknown
surveyid unknown
reference unknown
magerr unknown
extension unknown
corn4ra unknown
pipeline unknown
fits_data_product_id unknown
proposal unknown
corn2dec unknown
release_date unknown
filename unknown
fk5region unknown
start_date unknown