Views

namedescription
Columns Aliias the DBColumns table also as Columns, for legacy SkyQuery
CoordType Contains the CoordType enumerated values from DataConstants as int
FieldMask Contains the FieldMask flag values from DataConstants as binary(4)
FieldQuality Contains the FieldQuality enumerated values from DataConstants as int
FramesStatus Contains the FramesStatus enumerated values from DataConstants as int
Galaxy The objects classified as galaxies from PhotoPrimary.
GalaxyTag The objects classified as galaxies from primary PhotoTag objects.
HoleType Contains the HoleType enumerated values from DataConstants as int
ImageMask Contains the ImageMask flag values from DataConstants as binary(4)
InsideMask Contains the InsideMask flag values from DataConstants as binary(1)
MaskType Contains the MaskType enumerated values from DataConstants as int
ObjType Contains the ObjType enumerated values from DataConstants as int
PhotoAux The PhotoAuxAll parameters for the PhotoObj view.
PhotoAuxAll View for PhotoAuxAll for backward compatibility with DR5.
PhotoFamily These are in PhotoObj, but neither PhotoPrimary or Photosecondary.
PhotoFlags Contains the PhotoFlags flag values from DataConstants as binary(8)
PhotoMode Contains the PhotoMode enumerated values from DataConstants as int
PhotoObj All primary and secondary objects in the PhotoObjAll table, which contains all the attributes of each photometric (image) object.
PhotoPrimary These objects are the primary survey objects.
PhotoSecondary Secondary objects are reobservations of the same primary object.
PhotoStatus Contains the PhotoStatus flag values from DataConstants as binary(4)
PhotoType Contains the PhotoType enumerated values from DataConstants as int
PrimTarget Contains the PrimTarget flag values from DataConstants as binary(4)
ProgramType Contains the ProgramType enumerated values from DataConstants as int
PspStatus Contains the PspStatus enumerated values from DataConstants as int
QsoCatalog The primary objects in the QsoCatalogAll table.
QsoConcordance The primary objects in the QsoConcordanceAll table.
RegionConvex Emulates the old RegionConvex table for compatibility
Run Distinct Run from Segment table, mainly for RUNS DB.
SecTarget Contains the SecTarget flag values from DataConstants as binary(4)
Sky The objects selected as sky samples in PhotoPrimary
spbsParams This view contains the galaxy-centric parameters for objects with spectra in the database.
SpecClass Contains the SpecClass enumerated values from DataConstants as int
SpecLine A view of SpecLines objects that have been measured
SpecLineNames Contains the SpecLineNames enumerated values from DataConstants as int
SpecObj A view of Spectro objects that just has the clean spectra.
SpecPhoto A view of joined Spectro and Photo objects that have the clean spectra.
SpecZStatus Contains the SpecZStatus enumerated values from DataConstants as int
SpecZWarning Contains the SpecZWarning flag values from DataConstants as binary(4)
Star The objects classified as stars from PhotoPrimary
StarTag The objects classified as stars from primary PhotoTag objects.
TargPhotoObj All primary and secondary objects in the TargPhotoObjAll table.
TargPhotoPrimary These objects are the primary survey objects from the TargPhotoObjAll table.
TargPhotoSecondary Secondary objects are reobservations of the same primary object.
Tile A view of TileAll that have untiled=0
TiledTarget A view of TiledTargetAll objects that have untiled = 0
TilingBoundary A view of TilingGeometry objects that have isMask = 0
TilingMask A view of TilingGeometry objects that have isMask = 1
TiMask Contains the TiMask flag values from DataConstants as binary(4)
UberCalibStatus Contains the UberCalibStatus flag values from DataConstants as binary(2)
Unknown Everything in PhotoPrimary, which is not a galaxy, star or sky