Page History

Versions Compared

Old Version 1

changes.mady.by.user Rick White

Saved on Dec 13, 2018

compared with

New Version Current

changes.mady.by.user Rick White

Saved on Dec 13, 2018

Key

This line was added.
This line was removed.
Formatting was changed.

...

This page describes a "View", which is a database table created by joining other tables.

Excerpt

Description: -- View based on a combination of the tables MeanObject and ObjectThin joined by objID colummn.
Name	Unit	Data Type	Size	Default Value	Description
objName	dimensionless	VARCHAR(32)	32	NA	IAU name for this object.
objAltName1	dimensionless	VARCHAR(32)	32	NA	Alternate name for this object.
objAltName2	dimensionless	VARCHAR(32)	32		Altername name for this object.
objAltName3	dimensionless	VARCHAR(32)	32		Altername name for this object.
objID	dimensionless	BIGINT	8	NA	Unique object identifier.
uniquePspsOBid	dimensionless	BIGINT	8	NA	Unique internal PSPS object identifier.
ippObjID	dimensionless	BIGINT	8	NA	IPP internal object identifier.
surveyID	dimensionless	TINYINT	1	NA	Survey identifier. Details in the Survey table.
htmID	dimensionless	BIGINT	8	NA	Hierarchical triangular mesh (Szalay 2007) index.
zoneID	dimensionless	INT	4	NA	Local zone index, found by dividing the sky into bands of declination 1/2 arcminute in height: zoneID = floor((90 + declination)/0.0083333).
tessID	dimensionless	TINYINT	1	0	Tessellation identifier. Details in the TessellationType table.
projectionID	dimensionless	SMALLINT	2	-1	Projection cell identifier.
skyCellID	dimensionless	TINYINT	1	255	Skycell region identifier.
randomID	dimensionless	FLOAT	8	NA	Random value drawn from the interval between zero and one.
batchID	dimensionless	BIGINT	8	NA	Internal database batch identifier.
dvoRegionID	dimensionless	INT	4	-1	Internal DVO region identifier.
processingVersion	dimensionless	TINYINT	1	NA	Data release version.
objInfoFlag	dimensionless	INT	4	0	Information flag bitmask indicating details of the photometry. Values listed in ObjectInfoFlags.
qualityFlag	dimensionless	TINYINT	1	0	Subset of objInfoFlag denoting whether this object is real or a likely false positive. Values listed in ObjectQualityFlags.
raStack	degrees	FLOAT	8	-999	Right ascension from stack detections, weighted mean value across filters, in equinox J2000. See StackObjectThin for stack epoch information.
decStack	degrees	FLOAT	8	-999	Declination from stack detections, weighted mean value across filters, in equinox J2000. See StackObjectThin for stack epoch information.
raStackErr	arcsec	REAL	4	-999	Right ascension standard deviation from stack detections.
decStackErr	arcsec	REAL	4	-999	Declination standard deviation from stack detections.
raMean	degrees	FLOAT	8	-999	Right ascension from single epoch detections (weighted mean) in equinox J2000 at the mean epoch given by epochMean.
decMean	degrees	FLOAT	8	-999	Declination from single epoch detections (weighted mean) in equinox J2000 at the mean epoch given by epochMean.
raMeanErr	arcsec	REAL	4	-999	Right ascension standard deviation from single epoch detections.
decMeanErr	arcsec	REAL	4	-999	Declination standard deviation from single epoch detections.
epochMean	days	FLOAT	8	-999	Modified Julian Date of the mean epoch corresponding to raMean, decMean (equinox J2000).
posMeanChisq	dimensionless	REAL	4	-999	Reduced chi squared value of mean position.
cx	dimensionless	FLOAT	8	NA	Cartesian x on a unit sphere.
cy	dimensionless	FLOAT	8	NA	Cartesian y on a unit sphere.
cz	dimensionless	FLOAT	8	NA	Cartesian z on a unit sphere.
lambda	degrees	FLOAT	8	-999	Ecliptic longitude.
beta	degrees	FLOAT	8	-999	Ecliptic latitude.
l	degrees	FLOAT	8	-999	Galactic longitude.
b	degrees	FLOAT	8	-999	Galactic latitude.
nStackObjectRows	dimensionless	SMALLINT	2	-999	Number of independent StackObjectThin rows associated with this object.
nStackDetections	dimensionless	SMALLINT	2	-999	Number of stack detections.
nDetections	dimensionless	SMALLINT	2	-999	Number of single epoch detections in all filters.
ng	dimensionless	SMALLINT	2	-999	Number of single epoch detections in g filter.
nr	dimensionless	SMALLINT	2	-999	Number of single epoch detections in r filter.
ni	dimensionless	SMALLINT	2	-999	Number of single epoch detections in i filter.
nz	dimensionless	SMALLINT	2	-999	Number of single epoch detections in z filter.
ny	dimensionless	SMALLINT	2	-999	Number of single epoch detections in y filter.
gQfPerfect	dimensionless	REAL	4	-999	Maximum PSF weighted fraction of pixels totally unmasked from g filter detections.
gMeanPSFMag	AB magnitudes	REAL	4	-999	Mean PSF magnitude from g filter detections.
gMeanPSFMagErr	AB magnitudes	REAL	4	-999	Error in mean PSF magnitude from g filter detections.
gMeanPSFMagStd	AB magnitudes	REAL	4	-999	Standard deviation of PSF magnitudes from g filter detections.
gMeanPSFMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean PSF magnitude from g filter detections.
gMeanPSFMagMin	AB magnitudes	REAL	4	-999	Minimum PSF magnitude from g filter detections.
gMeanPSFMagMax	AB magnitudes	REAL	4	-999	Maximum PSF magnitude from g filter detections.
gMeanKronMag	AB magnitudes	REAL	4	-999	Mean Kron (1980) magnitude from g filter detections.
gMeanKronMagErr	AB magnitudes	REAL	4	-999	Error in mean Kron (1980) magnitude from g filter detections.
gMeanKronMagStd	AB magnitudes	REAL	4	-999	Standard deviation of Kron (1980) magnitudes from g filter detections.
gMeanKronMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean Kron (1980) magnitude from g filter detections.
gMeanApMag	AB magnitudes	REAL	4	-999	Mean aperture magnitude from g filter detections.
gMeanApMagErr	AB magnitudes	REAL	4	-999	Error in mean aperture magnitude from g filter detections.
gMeanApMagStd	AB magnitudes	REAL	4	-999	Standard deviation of aperture magnitudes from g filter detections.
gMeanApMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean aperture magnitude from g filter detections.
gFlags	dimensionless	INT	4	0	Information flag bitmask for mean object from g filter detections. Values listed in ObjectFilterFlags.
rQfPerfect	dimensionless	REAL	4	-999	Maximum PSF weighted fraction of pixels totally unmasked from r filter detections.
rMeanPSFMag	AB magnitudes	REAL	4	-999	Mean PSF magnitude from r filter detections.
rMeanPSFMagErr	AB magnitudes	REAL	4	-999	Error in mean PSF magnitude from r filter detections.
rMeanPSFMagStd	AB magnitudes	REAL	4	-999	Standard deviation of PSF magnitudes from r filter detections.
rMeanPSFMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean PSF magnitude from r filter detections.
rMeanPSFMagMin	AB magnitudes	REAL	4	-999	Minimum PSF magnitude from r filter detections.
rMeanPSFMagMax	AB magnitudes	REAL	4	-999	Maximum PSF magnitude from r filter detections.
rMeanKronMag	AB magnitudes	REAL	4	-999	Mean Kron (1980) magnitude from r filter detections.
rMeanKronMagErr	AB magnitudes	REAL	4	-999	Error in mean Kron (1980) magnitude from r filter detections.
rMeanKronMagStd	AB magnitudes	REAL	4	-999	Standard deviation of Kron (1980) magnitudes from r filter detections.
rMeanKronMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean Kron (1980) magnitude from r filter detections.
rMeanApMag	AB magnitudes	REAL	4	-999	Mean aperture magnitude from r filter detections.
rMeanApMagErr	AB magnitudes	REAL	4	-999	Error in mean aperture magnitude from r filter detections.
rMeanApMagStd	AB magnitudes	REAL	4	-999	Standard deviation of aperture magnitudes from r filter detections.
rMeanApMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean aperture magnitude from r filter detections.
rFlags	dimensionless	INT	4	0	Information flag bitmask for mean object from r filter detections. Values listed in ObjectFilterFlags.
iQfPerfect	dimensionless	REAL	4	-999	Maximum PSF weighted fraction of pixels totally unmasked from i filter detections.
iMeanPSFMag	AB magnitudes	REAL	4	-999	Mean PSF magnitude from i filter detections.
iMeanPSFMagErr	AB magnitudes	REAL	4	-999	Error in mean PSF magnitude from i filter detections.
iMeanPSFMagStd	AB magnitudes	REAL	4	-999	Standard deviation of PSF magnitudes from i filter detections.
iMeanPSFMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean PSF magnitude from i filter detections.
iMeanPSFMagMin	AB magnitudes	REAL	4	-999	Minimum PSF magnitude from i filter detections.
iMeanPSFMagMax	AB magnitudes	REAL	4	-999	Maximum PSF magnitude from i filter detections.
iMeanKronMag	AB magnitudes	REAL	4	-999	Mean Kron (1980) magnitude from i filter detections.
iMeanKronMagErr	AB magnitudes	REAL	4	-999	Error in mean Kron (1980) magnitude from i filter detections.
iMeanKronMagStd	AB magnitudes	REAL	4	-999	Standard deviation of Kron (1980) magnitudes from i filter detections.
iMeanKronMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean Kron (1980) magnitude from i filter detections.
iMeanApMag	AB magnitudes	REAL	4	-999	Mean aperture magnitude from i filter detections.
iMeanApMagErr	AB magnitudes	REAL	4	-999	Error in mean aperture magnitude from i filter detections.
iMeanApMagStd	AB magnitudes	REAL	4	-999	Standard deviation of aperture magnitudes from i filter detections.
iMeanApMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean aperture magnitude from i filter detections.
iFlags	dimensionless	INT	4	0	Information flag bitmask for mean object from i filter detections. Values listed in ObjectFilterFlags.
zQfPerfect	dimensionless	REAL	4	-999	Maximum PSF weighted fraction of pixels totally unmasked from z filter detections.
zMeanPSFMag	AB magnitudes	REAL	4	-999	Mean PSF magnitude from z filter detections.
zMeanPSFMagErr	AB magnitudes	REAL	4	-999	Error in mean PSF magnitude from z filter detections.
zMeanPSFMagStd	AB magnitudes	REAL	4	-999	Standard deviation of PSF magnitudes from z filter detections.
zMeanPSFMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean PSF magnitude from z filter detections.
zMeanPSFMagMin	AB magnitudes	REAL	4	-999	Minimum PSF magnitude from z filter detections.
zMeanPSFMagMax	AB magnitudes	REAL	4	-999	Maximum PSF magnitude from z filter detections.
zMeanKronMag	AB magnitudes	REAL	4	-999	Mean Kron (1980) magnitude from z filter detections.
zMeanKronMagErr	AB magnitudes	REAL	4	-999	Error in mean Kron (1980) magnitude from z filter detections.
zMeanKronMagStd	AB magnitudes	REAL	4	-999	Standard deviation of Kron (1980) magnitudes from z filter detections.
zMeanKronMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean Kron (1980) magnitude from z filter detections.
zMeanApMag	AB magnitudes	REAL	4	-999	Mean aperture magnitude from z filter detections.
zMeanApMagErr	AB magnitudes	REAL	4	-999	Error in mean aperture magnitude from z filter detections.
zMeanApMagStd	AB magnitudes	REAL	4	-999	Standard deviation of aperture magnitudes from z filter detections.
zMeanApMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean aperture magnitude from z filter detections.
zFlags	dimensionless	INT	4	0	Information flag bitmask for mean object from z filter detections. Values listed in ObjectFilterFlags.
yQfPerfect	dimensionless	REAL	4	-999	Maximum PSF weighted fraction of pixels totally unmasked from y filter detections.
yMeanPSFMag	AB magnitudes	REAL	4	-999	Mean PSF magnitude from y filter detections.
yMeanPSFMagErr	AB magnitudes	REAL	4	-999	Error in mean PSF magnitude from y filter detections.
yMeanPSFMagStd	AB magnitudes	REAL	4	-999	Standard deviation of PSF magnitudes from y filter detections.
yMeanPSFMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean PSF magnitude from y filter detections.
yMeanPSFMagMin	AB magnitudes	REAL	4	-999	Minimum PSF magnitude from y filter detections.
yMeanPSFMagMax	AB magnitudes	REAL	4	-999	Maximum PSF magnitude from y filter detections.
yMeanKronMag	AB magnitudes	REAL	4	-999	Mean Kron (1980) magnitude from y filter detections.
yMeanKronMagErr	AB magnitudes	REAL	4	-999	Error in mean Kron (1980) magnitude from y filter detections.
yMeanKronMagStd	AB magnitudes	REAL	4	-999	Standard deviation of Kron (1980) magnitudes from y filter detections.
yMeanKronMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean Kron (1980) magnitude from y filter detections.
yMeanApMag	AB magnitudes	REAL	4	-999	Mean aperture magnitude from y filter detections.
yMeanApMagErr	AB magnitudes	REAL	4	-999	Error in mean aperture magnitude from y filter detections.
yMeanApMagStd	AB magnitudes	REAL	4	-999	Standard deviation of aperture magnitudes from y filter detections.
yMeanApMagNpt	dimensionless	SMALLINT	2	-999	Number of measurements included in mean aperture magnitude from y filter detections.
yFlags	dimensionless	INT	4	0	Information flag bitmask for mean object from y filter detections. Values listed in ObjectFilterFlags.

Content

Space Tools

Versions Compared

Old Version 1

New Version Current

Key