Field Definitions for table SAO_CAT


If the database maintainer has set up a data dictionary, then this form will show information defining and explaining each field in the table SAO_CAT. When an asterisk appears following the column data type (like int *) this indicates that this column is indexed in the database server for faster searches.
FieldTypeDescription
sybidint, no nulls *
SAOint SAO Catalog number
Del_Flagchar if star deleted (all other fields blank); If D, all other fields in the record are blank-filled due to the deletion of a duplicate star in the catalog.
RAHint *Hours RA, equinox B1950, epoch 1950.0; units: h
RAMint *Minutes RA, equinox B1950, epoch 1950.0; units: min
RASreal Seconds RA, equinox B1950, epoch 1950.0; units: s
PM_RAfloat Annual proper motion in RA; units: s/yr
PM_RA_Stdvint deviation in PM_RA; units: arcsec/yr; scale by 0.001
RAM2_Flagchar add 1, or ''-'', subtract 1, RA minute; + for addition or - for subtraction of one arcminute to the seconds portion of RA at original epoch (field RAS2).
RAS2real Seconds RA, original epoch, precessed to B1950; units: s
RA2_Stdvint deviation of RA2; units: arcsec/yr; scale by 0.01
RA2_Epochreal of RA2 (RA original epoch); units: yr
DecSignchar Sign Dec, equinox B1950, epoch 1950.0
DecDint *Degrees Dec, equinox B1950, epoch 1950.0; units: deg
DecMint *Minutes Dec, equinox B1950, epoch 1950.0; units: arcmin
DecSreal Seconds Dec, equinox B1950, epoch 1950.0; units: arcsec
PM_Decreal Annual proper motion in Dec; units: arcsec/yr
PM_Dec_Stdvint deviation of Dec proper motion; units: arcsec/yr; scale by 0.001
DecM2_Flagchar add 1, or ''-'', subtract 1, Dec minutes; + for addition or - for subtraction of one arcminute to the seconds portion of DEC at original epoch (field DecS2).
DecS2real Seconds Dec, original epoch, precessed to B1950; units: arcsec
Dec2_Stdvint deviation of Dec2; units: arcsec/yr; scale by 0.01
Dec2_Epochreal of Dec2 (Dec original epoch); units: yr
Pos_Stdvint deviation of position at epoch 1950.0; units: arcsec/yr; scale by 0.01
Ptgreal Photographic magnitude; units: mag; null val: 99.9
Vreal Visual magnitude; units: mag; null val: 99.9
SpTypechar Spectral type, ''+++'' for composite spectra
V_Codeint Coded source of visual magnitude
Num_Codeint source of star number and footnotes
Ptg_Codeint source of photographic magnitude
PM_Codeint Coded source of proper motions
SpType_Codeint source of spectral type
Rem_Codeint misc. remarks duplicity and variability
V_Accint Accuracy of V: 0=0.00 mag, 1=0.0 mag
Ptg_Accint Accuracy of Ptg: 0=0.00 mag, 1=0.0 mag
Cat_Codeint for source catalog
CatNumint Number in source catalog
DM_Catchar Durchmusterung catalog ID, ''BD'', ''CD'', ''CP''
DMchar Durchmusterung catalog number, SZZNNNNN
DM_Compchar DM component identification
DM_Supplchar supplement letter
HDchar Henry Draper Catalog (HD or HDE) number
HD_Codechar HD component and multiple code
GCchar Boss General Catalog (GC) number
RAfloat Right ascension, 1950.0, in radians; units: rad
Decfloat Declination, 1950.0, in radians; units: rad
RAH_2000int RA, equinox, epoch J2000.0; units: h
RAM_2000int RA, equinox, epoch J2000.0; units: min
RAS_2000real RA, equinox, epoch J2000.0; units: s
PM_RA_2000float proper motion in RA J2000.0; units: s/yr
DecSign_2000char Dec, equinox, epoch J2000.0
DecD_2000int Dec, equinox, epoch J2000.0; units: deg
DecM_2000int Dec, equinox, epoch J2000.0; units: arcmin
DecS_2000real Dec, equinox, epoch J2000.0; units: arcsec
PM_Dec_2000real proper motion in Dec J2000.0; units: arcsec/yr
RA_2000float Right ascension, J2000.0, in radians; units: rad
Dec_2000float J2000.0, in radians; units: rad

Go back to main index.

webmaster@ucolick.org
A Service of the Computing Support Group
UCO/Lick Observatory
University of California
Santa Cruz, CA 95064
Tel: +1 408 459 2630
Fax: +1 408 454 9863