Init Batch (IN)

Init batches have a lot of tables, consisting of metadata tables. These are the ones that ipptopsps is responsible for

• Filter
• FitModel
• Survey
• CameraConfig
• PhotoCal
• SkyCell
• ProjectionCell
• Region
• StackType
• ImageFlags
• StackDetectionFlags
• DetectionFlags
• ObjectInfoFlags
• ObjectFilterFlags
• ObjectQualityFlags

---

Filter VOTable description of PSPS table Filter

---

filterID		TINYINT 1		filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ...
filterType		VARCHAR(100)		filter name: g,r,i,z,y, etc.
filterSpec		VARCHAR(100)		No comment

---

FitModel VOTable description of PSPS table FitModel

---

fitModelID		SMALLINT 2		indentifier of alternate model fit
name		VARCHAR(100)		model name
description		VARCHAR(100)		string describing the model
param1		VARCHAR(100)		description of model parameter 1
param2		VARCHAR(100)		description of model parameter 2
param3		VARCHAR(100)		description of model parameter 3
param4		VARCHAR(100)		description of model parameter 4
param5		VARCHAR(100)		description of model parameter 5
param6		VARCHAR(100)		description of model parameter 6
param7		VARCHAR(100)		description of model parameter 7
param8		VARCHAR(100)		description of model parameter 8
param9		VARCHAR(100)		description of model parameter 9
param10		VARCHAR(100)		description of model parameter 10
param11		VARCHAR(100)		description of model parameter 11
param12		VARCHAR(100)		description of model parameter 12
param13		VARCHAR(100)		description of model parameter 13
param14		VARCHAR(100)		description of model parameter 14
param15		VARCHAR(100)		description of model parameter 15
param16		VARCHAR(100)		description of model parameter 16
param17		VARCHAR(100)		description of model parameter 17
param18		VARCHAR(100)		description of model parameter 18
param19		VARCHAR(100)		description of model parameter 19
param20		VARCHAR(100)		description of model parameter 20
param21		VARCHAR(100)		description of model parameter 21
param22		VARCHAR(100)		description of model parameter 22
param23		VARCHAR(100)		description of model parameter 23
param24		VARCHAR(100)		description of model parameter 24
param25		VARCHAR(100)		description of model parameter 25
param26		VARCHAR(100)		description of model parameter 26
param27		VARCHAR(100)		description of model parameter 27
param28		VARCHAR(100)		description of model parameter 28
param29		VARCHAR(100)		description of model parameter 29
param30		VARCHAR(100)		description of model parameter 30
param31		VARCHAR(100)		description of model parameter 31
param32		VARCHAR(100)		description of model parameter 32
param33		VARCHAR(100)		description of model parameter 33
param34		VARCHAR(100)		description of model parameter 34
param35		VARCHAR(100)		description of model parameter 35
param36		VARCHAR(100)		description of model parameter 36
param37		VARCHAR(100)		description of model parameter 37
param38		VARCHAR(100)		description of model parameter 38
param39		VARCHAR(100)		description of model parameter 39

---

Survey VOTable description of PSPS table Survey

---

surveyID		TINYINT 1		index of survey type
name		VARCHAR(100)		survey name
description		VARCHAR(100)		survey description

---

CameraConfig VOTable description of PSPS table CameraConfig

---

cameraID		SMALLINT 2		camera identification number
cameraConfigID		SMALLINT 2		configuration identification number
endDate		REAL 4		ending date of this configuration in MJD (unit = day)
configDetails		VARCHAR(100)		text/table giving the details of the camera configuration

---

PhotoCal VOTable description of PSPS table PhotoCal

---

photoCalID		INT 4		numerical code for this reduction
filterID		TINYINT 1		filter id
photoCodeDesc		VARCHAR(100)		Photometry reduction code name
AB		REAL 4		AB magnitude
zeropoint		REAL 4		photometric zero point (excluding long term variation)
extinction		REAL 4		photometric extinction term (excluding long term variation)
colorterm		REAL 4		photometric color term (excluding long term variation)
colorExtn		REAL 4		photometric color dependent extinction (excluding long term variation)
orphanCalColor		REAL 4		color adopted for magnitude calculation
orphanCalColorErr		REAL 4		error in calibrating color
startDate		REAL 4		starting date of this configuration in MJD (unit = day)

---

SkyCell VOTable description of PSPS table SkyCell

---

skyCellID		INT 4		indentifier of the sky cell
projectionCellID		INT 4		indentifier of the projection cell
partitionKey		BIGINT 8		fgetPANobjID(skyCell_center_ra, skyCell_center_dec, zHeight)
regionID		BIGINT 8		region identifier in the Region table

---

ProjectionCell VOTable description of PSPS table ProjectionCell

---

projectionCellID		INT 4		projection cell unique identifier
partitionKey		BIGINT 8		fGetPanObjID(crval1,crval2)
primaryCellRegionID		BIGINT 8		reference to the primary cell region definition in the Region table
projectionCellRegionID		BIGINT 8		reference to the projectio cell region definition in the Region table)
ctype1		VARCHAR(100)		name of astrometric projection in RA
ctype2		VARCHAR(100)		name of astrometric projection in DEC
crval1		FLOAT 8		RA corresponding to reference pixel (unit = deg)
crval2		FLOAT 8		DEC corresponding to reference pixel (unit = deg)
crpix1		FLOAT 8		reference pixel value for RA
crpix2		FLOAT 8		reference pixel value for DEC
pc001001		FLOAT 8		elements of rotation/scale matrix
pc001002		FLOAT 8		elements of rotation/scale matrix
pc002001		FLOAT 8		elements of rotation/scale matrix
pc002002		FLOAT 8		elements of rotation/scale matrix

---

Region VOTable description of PSPS table Region

---

regionID		BIGINT 8		Unique Region identifier
id		BIGINT 8		Custom Identifier
type		VARCHAR(100)		Region type
comment		VARCHAR(100)		Comment
area		FLOAT 8		Area covered by the region
regionBinary		VARCHAR(100)		Binary object managed by the spatial library

---

StackType VOTable description of PSPS table StackType

---

stackTypeID		TINYINT 1		stack type identifier
name		VARCHAR(100)		stack type name
description		VARCHAR(100)		stack type description

---

ImageFlags VOTable description of PSPS table ImageFlags

---

name		VARCHAR(100)		Name of flag
value		BIGINT 8		Flag value
description		VARCHAR(100)		Description of the flag

---

StackDetectionFlags VOTable description of PSPS table DetectionFlags

---

name		VARCHAR(100)		Name of flag
value		BIGINT 8		Flag value
description		VARCHAR(100)		Description of the flag

---

DetectionFlags VOTable description of PSPS table DetectionFlags

---

name		VARCHAR(100)		Name of flag
value		BIGINT 8		Flag value
description		VARCHAR(100)		Description of the flag

---

ObjectInfoFlags VOTable description of PSPS table ObjectInfoFlags

---

name		VARCHAR(100)		Name of flag
value		BIGINT 8		Flag value
description		VARCHAR(100)		Description of the flag

---

ObjectFilterFlags VOTable description of PSPS table ObjectInfoFlags

---

name		VARCHAR(100)		Name of flag
value		BIGINT 8		Flag value
description		VARCHAR(100)		Description of the flag

---

ObjectQualityFlags VOTable description of PSPS table ObjectInfoFlags

---

name		VARCHAR(100)		Name of flag
value		BIGINT 8		Flag value
description		VARCHAR(100)		Description of the flag