TABLE Segment

Contains the basic parameters associated with a Segment

A Segment corresponds to a single camera column within a chunk. See chunk table description for more details.

name type length unit ucd description

segmentID bigint 8 ID_AREA Unique segment identifier

skyVersion tinyint 1 CODE_MISC 0 = OPDB target, 1 = OPDB best

run smallint 2 OBS_RUN Run number

camCol tinyint 1 INST_ID Camera column (1-6)

rerun smallint 2 CODE_MISC Rerun number

field0 int 4 ID_FIELD Starting field number

nFields int 4 NUMBER Number of fields in this segment

dscale int 4 INST_SCALE Scaling for bias

chunkID bigint 8 ID_IDENTIFIER Long-ID of the export chunk

startMu int 4 arcsec POS_LIMIT Starting mu value

endMu int 4 arcsec POS_LIMIT Ending mu value

stripe int 4 ID_FIELD Stripe number

strip smallint 2 ID_FIELD Strip (N or S) (? which is which)

status smallint 2 CODE_QUALITY Status (primary,secondary,bad)

resolved smallint 2 CODE_MISC Resolved flag (yes/no)

exported smallint 2 CODE_MISC Exported flag (yes/no)

families smallint 2 CODE_MISC Families identified flag (yes/no)

equinox float 8 y TIME_EQUINOX Great Circle Equinox

node float 8 deg POS_EQ_RA Great Circle Ascending Node

incl float 8 deg POS_INCLIN Great Circle Inclination

cObs float 8 us/line INST_SAMP-TIME CCD Clock rate

tracking float 8 deg/h INST_PARAM Tracking Rate

raMin float 8 deg POS_LIMIT Lowest J2000 RA

raMax float 8 deg POS_LIMIT Highest J2000 RA

decMin float 8 deg POS_LIMIT Lowest J2000 DEC

decMax float 8 deg POS_LIMIT Highest J2000 DEC

lMin float 8 deg POS_LIMIT Lowest Galactic Lambda

lMax float 8 deg POS_LIMIT Highest Galactic Lambda

bMin float 8 deg POS_LIMIT Lowest Galactic Beta

bMax float 8 deg POS_LIMIT Highest Galactic Beta

lambdaMin float 8 deg POS_LIMIT Lowest Survey Lambda

lambdaMax float 8 deg POS_LIMIT Highest Survey Lambda

etaMin float 8 deg POS_LIMIT Lowest Survey Eta

etaMax float 8 deg POS_LIMIT Highest Survey Eta

photoId varchar 32 ID_TRACER Photo ID tag

photoVersion varchar 32 ID_VERSION Photo Version

targetAstroId varchar 32 ID_TRACER Astrometric Pipeline used for Target

targetAstroVersion varchar 32 ID_VERSION Astrometric Pipeline version used for target selection

exportAstroId varchar 32 ID_VERSION Astrometric Pipeline used for Target

exportAstroVersion varchar 32 ID_VERSION Astrometric pipeline version used for export to Science Archive

targetFCalibId varchar 32 ID_VERSION Photometric calibration used for target selection

targetFCalibVersion varchar 32 ID_VERSION FCALIB pipeline version used for target selection

exportFCalibID varchar 32 ID_VERSION Photometric calibration used for export to Science Archive

exportFCalibVersion varchar 32 ID_VERSION FCALIB pipeline version used for export to Science Archive

loaderVersion varchar 32 ID_VERSION Version of Science Archive Loader used to load this segment

objectSource varchar 32 ID_VERSION Object Source

targetSource varchar 32 ID_VERSION Target Source

targetVersion varchar 32 ID_VERSION Target version

loadVersion int 4 ID_VERSION Load Version

name	type	length	unit	ucd	description
segmentID	bigint	8		ID_AREA	Unique segment identifier
skyVersion	tinyint	1		CODE_MISC	0 = OPDB target, 1 = OPDB best
run	smallint	2		OBS_RUN	Run number
camCol	tinyint	1		INST_ID	Camera column (1-6)
rerun	smallint	2		CODE_MISC	Rerun number
field0	int	4		ID_FIELD	Starting field number
nFields	int	4		NUMBER	Number of fields in this segment
dscale	int	4		INST_SCALE	Scaling for bias
chunkID	bigint	8		ID_IDENTIFIER	Long-ID of the export chunk
startMu	int	4	arcsec	POS_LIMIT	Starting mu value
endMu	int	4	arcsec	POS_LIMIT	Ending mu value
stripe	int	4		ID_FIELD	Stripe number
strip	smallint	2		ID_FIELD	Strip (N or S) (? which is which)
status	smallint	2		CODE_QUALITY	Status (primary,secondary,bad)
resolved	smallint	2		CODE_MISC	Resolved flag (yes/no)
exported	smallint	2		CODE_MISC	Exported flag (yes/no)
families	smallint	2		CODE_MISC	Families identified flag (yes/no)
equinox	float	8	y	TIME_EQUINOX	Great Circle Equinox
node	float	8	deg	POS_EQ_RA	Great Circle Ascending Node
incl	float	8	deg	POS_INCLIN	Great Circle Inclination
cObs	float	8	us/line	INST_SAMP-TIME	CCD Clock rate
tracking	float	8	deg/h	INST_PARAM	Tracking Rate
raMin	float	8	deg	POS_LIMIT	Lowest J2000 RA
raMax	float	8	deg	POS_LIMIT	Highest J2000 RA
decMin	float	8	deg	POS_LIMIT	Lowest J2000 DEC
decMax	float	8	deg	POS_LIMIT	Highest J2000 DEC
lMin	float	8	deg	POS_LIMIT	Lowest Galactic Lambda
lMax	float	8	deg	POS_LIMIT	Highest Galactic Lambda
bMin	float	8	deg	POS_LIMIT	Lowest Galactic Beta
bMax	float	8	deg	POS_LIMIT	Highest Galactic Beta
lambdaMin	float	8	deg	POS_LIMIT	Lowest Survey Lambda
lambdaMax	float	8	deg	POS_LIMIT	Highest Survey Lambda
etaMin	float	8	deg	POS_LIMIT	Lowest Survey Eta
etaMax	float	8	deg	POS_LIMIT	Highest Survey Eta
photoId	varchar	32		ID_TRACER	Photo ID tag
photoVersion	varchar	32		ID_VERSION	Photo Version
targetAstroId	varchar	32		ID_TRACER	Astrometric Pipeline used for Target
targetAstroVersion	varchar	32		ID_VERSION	Astrometric Pipeline version used for target selection
exportAstroId	varchar	32		ID_VERSION	Astrometric Pipeline used for Target
exportAstroVersion	varchar	32		ID_VERSION	Astrometric pipeline version used for export to Science Archive
targetFCalibId	varchar	32		ID_VERSION	Photometric calibration used for target selection
targetFCalibVersion	varchar	32		ID_VERSION	FCALIB pipeline version used for target selection
exportFCalibID	varchar	32		ID_VERSION	Photometric calibration used for export to Science Archive
exportFCalibVersion	varchar	32		ID_VERSION	FCALIB pipeline version used for export to Science Archive
loaderVersion	varchar	32		ID_VERSION	Version of Science Archive Loader used to load this segment
objectSource	varchar	32		ID_VERSION	Object Source
targetSource	varchar	32		ID_VERSION	Target Source
targetVersion	varchar	32		ID_VERSION	Target version
loadVersion	int	4		ID_VERSION	Load Version