TABLE  Plate

Contains information about each plate measurement used in the F287 survey.

The details of each plate (eg. emulsion, filter, epoch etc.) and the
measurement (eg. date, time, machine etc.) are stored in this
table, along with image map processing parameters (eg. detection
threshold, astrometric solution, etc.)

Required constraints:
  • Primary key is (plateNum)

NameTypeLengthUnitDescriptionDefault ValueUnified Content Descriptor
plateNumint4 Unique plate number assigned by UK Schmidt Telescope Unit (NB: 1,2,3 or 4 = deep stack in U,B,R or I)-99999999ID_PLATE
dateMeasdatetime8YYYY-MM-DDMeasurement date9999-12-31TIME_DATE
timeMeasvarchar8HH:MM:SSMeasurement time (local), eg. 15:33:47NoneTIME_MISC
instrumentvarchar16 Name of scanning machineNoneINST_ID
softVersionvarchar30 Software version, eg. /home/scosdev/v033NoneID_VERSION
operatorvarchar3 Machine operator's username---ID_HUMAN
scanMaterialvarchar16 Photographic medium, eg. Original glass, Copy film, Copy glassNoneREMARKS
filterIDtinyint1 Unique filter identification number0INST_FILTER_CODE
raPntreal4degreesMean plate centre RA-0.99999995e9POS_EQ_RA_MAIN
decPntreal4degreesMean plate centre Dec-0.99999995e9POS_EQ_DEC_MAIN
radecSysvarchar4 Co-ordinate system of raPnt/decPnt, eg. FK4NonePOS_REFERENCE-SYSTEM
equinoxreal4yearEquinox of raPnt and decPnt-0.99999995e9TIME_EQUINOX
eqTsysvarchar12 Time system of equinox, eg. BESSELIANNoneNOTE
utDateObsdatetime8YYYY-MM-DDUT date of observation9999-12-31TIME_DATE
lstObsvarchar424-hourLocal sidereal time at start of exposure, eg. 2336NoneTIME_MISC
expLengthreal4minutesExposure time-0.99999995e9TIME_EXPTIME
epochreal4yearsEpoch of observation-0.99999995e9TIME_EPOCH
domeTempreal4KelvinDome temp at observation-0.99999995e9OBS_CONDITIONS
domePressurereal4mBarDome pressure at observation-0.99999995e9OBS_CONDITIONS
domeHumidreal4 Dome relative humidity at obsevation time-0.99999995e9OBS_CONDITIONS
troplreal4K/mTropospheric lapse rate-0.99999995e9MODEL_PARAM
mjdfloat8Julian daysModified Julian Date at mid exposure-0.99999995e9TIME_DATE
focusNXtinyint1 No. of scan focus points in X0INST_PARAM
focusNYtinyint1 No. of scan focus points in Y0INST_PARAM
calTypevarchar16 Intensity calibration wedge fit type, eg. SPLINENoneINST_PARAM
stepWdgvarchar16 Intensity calibration step-wedge type, eg. kpnoNoneINST_PARAM
nStepstinyint1 No. of intensity calibration wedge steps0INST_PARAM
orientationvarchar4 SuperCOSMOS plate orientation, eg. newsNoneINST_PARAM
emulposvarchar4 SuperCOSMOS emulsion position, eg. upNoneINST_PARAM
sospsmallint2 SuperCOSMOS start of scan CCD pixel number-9999INST_PARAM
stepsizereal4micronsSuperCOSMOS nominal pixel size-0.99999995e9INST_PIXSIZE
scanlensmallint2pixelsSuperCOSMOS CCD lane scan length-9999INST_PARAM
aXminreal4micronsSuperCOSMOS XMIN of measured area-0.99999995e9POS_PLATE_X
aXmaxreal4micronsSuperCOSMOS XMAX of measured area-0.99999995e9POS_PLATE_X
aYminreal4micronsSuperCOSMOS YMIN of measured area-0.99999995e9POS_PLATE_Y
aYmaxreal4micronsSuperCOSMOS YMAX of measured area-0.99999995e9POS_PLATE_Y
xPntreal4micronsCentre of scan area in X-0.99999995e9POS_PLATE_Y
yPntreal4micronsCentre of scan area in Y-0.99999995e9POS_PLATE_Y
areaCuttinyint1pixelsMinimum area of detected object0NUMBER
apParamreal4 Areal profile parameter-0.99999995e9REDUCT_PARAM
dbParamreal4 Deblending parameter-0.99999995e9REDUCT_PARAM
dbAmintinyint1pixelsMinimum area of parent image that can be deblended0REDUCT_PARAM
dbAmaxint4pixelsMaximum area of parent image that can be deblended-99999999REDUCT_PARAM
dbAcuttinyint1pixelsMinimum area of deblended object detection0REDUCT_PARAM
dbLeveltinyint1 No. of rethresholding levels for deblending0REDUCT_PARAM
skySquaresmallint2pixelsBlocksize (one side) of sky background-9999REDUCT_PARAM
skyDefnvarchar16 Method of defining sky, eg. "median"NoneREDUCT_METHOD
skyFiltervarchar16 Box filter weights for sky determinationNoneREDUCT_PARAM
fThreshtinyint1 Sky filtering parameter0REDUCT_PARAM
fSclentinyint1 Scale size for iterative filter application0REDUCT_PARAM
pCutreal4percentThreshold "percentage cut" for pixel analysis-0.99999995e9STAT_%REJECT
starCatvarchar80 Name of reference star catalogue used for astrometric fitNoneID_CATALOG
brightLimreal4 Bright mag limit for selected astrometric refstars-0.99999995e9PHOT_MAG_LIMIT
faintLimreal4 Faint limit for selected refstars-0.99999995e9PHOT_MAG_LIMIT
equinRefreal4 Equinox of refstar positions-0.99999995e9TIME_EQUINOX
tSysRefvarchar12 Time system of equinox of refstar positions, eg. JULIANNoneNOTE
maxIterint4 Maximum no. of iterations for non-linear astrometric fit-99999999NUMBER
rCritInireal4micronsInitial matching tolerance for refstars-0.99999995e9REDUCT_PARAM
rCritAbsreal4micronsAbsolute object rejection criterion-0.99999995e9REDUCT_PARAM
rCritRelreal4 Relative object rejection criterion-0.99999995e9REDUCT_PARAM
rCritFinreal4sigmaFinal residual tolerance-0.99999995e9REDUCT_PARAM
distTypevarchar80 Radial distortion term in solution, eg. R/TAN(R)NoneMODEL_CORRECTION
scdGridvarchar80 Non-linear distortion mask filenameNoneID_FILE
raColvarchar16 Name of RA column in reference catalogueNoneREMARKS
decColvarchar16 Name of Dec column in reference catalogueNoneREMARKS
raPMColvarchar16 Name of RA proper motion column in reference catalogueNoneREMARKS
decPMColvarchar16 Name of Dec proper motion column in reference catalogueNoneREMARKS
plxColvarchar16 Name of parallax column in reference catalogueNoneREMARKS
rvColvarchar16 Name of radial velocity column in reference catalogueNoneREMARKS
magColvarchar16 Name of magnitude column in reference catalogueNoneREMARKS
cEquinoxreal4yearCatalogue equinox-0.99999995e9TIME_EQUINOX
cEqTSysvarchar16 Catalogue equinox time system, eg. JULIANNoneNOTE
cEpochreal4yearCatalogue epoch-0.99999995e9TIME_EPOCH
cEpTSysvarchar16 Catalogue epoch time system, eg. JULIANNoneNOTE
starsInitint4 No. of refstars in initial astrometric solution-99999999NUMBER
starsSelecint4 No. of refstars initially selected-99999999NUMBER
starsUsedint4 No. of refstars in final astrometric solution-99999999NUMBER
coeffs1float8 1st coefficient of astrometric fit for XY to obs. xi,eta FIT_PARAM_VALUE
coeffs2float8 2nd coefficient of astrometric fit for XY to obs. xi,eta FIT_PARAM_VALUE
coeffs3float8 3rd coefficient of astrometric fit for XY to obs. xi,eta FIT_PARAM_VALUE
coeffs4float8 4th coefficient of astrometric fit for XY to obs. xi,eta FIT_PARAM_VALUE
coeffs5float8 5th coefficient of astrometric fit for XY to obs. xi,eta FIT_PARAM_VALUE
coeffs6float8 6th coefficient of astrometric fit for XY to obs. xi,eta FIT_PARAM_VALUE
cubicDistfloat8 Cubic coefficient of radial distortion FIT_PARAM_VALUE
obsRaPntfloat8radiansObserved plate centre RA POS_EQ_RA_MAIN
obsDecPntfloat8radiansObserved plate centre Dec POS_EQ_DEC_MAIN
shiftPntfloat8radiansShift of from nominal to fitted plate centre POS_OFFSET
areaMinint4pixelsMinimum object area in IAM file-99999999EXTENSION_AREA
areaMaxint4pixelsMaximum object area in IAM file-99999999EXTENSION_AREA
magMinreal4 Minimum instrumental mag in IAM file-0.99999995e9PHOT_MAG_LIMIT
magMaxreal4 Maximum instrumental mag in IAM file-0.99999995e9PHOT_MAG_LIMIT
ellipMinreal4 Minimum object ellipticity in IAM file-0.99999995e9PHYS_ELLIPTICITY
ellipMaxreal4 Maximum object ellipticity in IAM file-0.99999995e9PHYS_ELLIPTICITY
ellipModereal4 Modal object ellipticity in IAM file-0.99999995e9PHYS_ELLIPTICITY
orientModereal4degreesModal orientation in IAM file-0.99999995e9POS_POS-ANG
ellipMedreal4 Median ellipticity in IAM file-0.99999995e9PHYS_ELLIPTICITY
orientMedreal4degreesMedian orientation in IAM file-0.99999995e9POS_POS-ANG
ellipMeanreal4 Mean object ellipticity in IAM file-0.99999995e9PHYS_ELLIPTICITY
orientMeanreal4degreesMean orientation in IAM file-0.99999995e9POS_POS-ANG
objNumint4 No. of objects detected on plate-99999999NUMBER
nParentsint4 No. of parent objects detected on plate-99999999NUMBER
lane1Countint4 No. of objects in lane 1 of plate scan-99999999NUMBER
lane2Countint4 No. of objects in lane 2 of plate scan-99999999NUMBER
lane3Countint4 No. of objects in lane 3 of plate scan-99999999NUMBER
lane4Countint4 No. of objects in lane 4 of plate scan-99999999NUMBER
lane5Countint4 No. of objects in lane 5 of plate scan-99999999NUMBER
lane6Countint4 No. of objects in lane 6 of plate scan-99999999NUMBER
lane7Countint4 No. of objects in lane 7 of plate scan-99999999NUMBER
lane8Countint4 No. of objects in lane 8 of plate scan-99999999NUMBER
lane9Countint4 No. of objects in lane 9 of plate scan-99999999NUMBER
lane10Countint4 No. of objects in lane 10 of plate scan-99999999NUMBER
lane11Countint4 No. of objects in lane 11 of plate scan-99999999NUMBER
lane12Countint4 No. of objects in lane 12 of plate scan-99999999NUMBER
lane13Countint4 No. of objects in lane 13 of plate scan-99999999NUMBER
lane14Countint4 No. of objects in lane 14 of plate scan-99999999NUMBER
lane15Countint4 No. of objects in lane 15 of plate scan-99999999NUMBER
lane16Countint4 No. of objects in lane 16 of plate scan-99999999NUMBER
lane17Countint4 No. of objects in lane 17 of plate scan-99999999NUMBER
lane18Countint4 No. of objects in lane 18 of plate scan-99999999NUMBER
lane19Countint4 No. of objects in lane 19 of plate scan-99999999NUMBER
lane20Countint4 No. of objects in lane 20 of plate scan-99999999NUMBER
lane21Countint4 No. of objects in lane 21 of plate scan-99999999NUMBER
lane22Countint4 No. of objects in lane 22 of plate scan-99999999NUMBER
lane23Countint4 No. of objects in lane 23 of plate scan-99999999NUMBER
lane24Countint4 No. of objects in lane 24 of plate scan-99999999NUMBER
lane25Countint4 No. of objects in lane 25 of plate scan-99999999NUMBER
lane26Countint4 No. of objects in lane 26 of plate scan-99999999NUMBER
lane27Countint4 No. of objects in lane 27 of plate scan-99999999NUMBER
lane28Countint4 No. of objects in lane 28 of plate scan-99999999NUMBER
lane29Countint4 No. of objects in lane 29 of plate scan-99999999NUMBER
lane30Countint4 No. of objects in lane 30 of plate scan-99999999NUMBER
astResidXreal4arcsecResidual of astrometric fit in X-0.99999995e9FIT_RESIDUAL
astResidYreal4arcsecResidual of astrometric fit in Y-0.99999995e9FIT_RESIDUAL
nCalCoeffstinyint1 No. of photometric calibration coefficients0FIT_PARAM_VALUE
CalXKreal4inst. profile magStationary point in profile cal. curve-0.99999995e9FIT_PARAM_VALUE
gradientreal4 Gradient of linear portion of profile cal. curve-0.99999995e9FIT_PARAM_VALUE
getCal1float8 1st profile calibration polynomial coefficient-0.99999995e9FIT_PARAM_VALUE
getCal2float8 2nd profile calibration polynomial coefficient-0.99999995e9FIT_PARAM_VALUE
getCal3float8 3rd profile calibration polynomial coefficient-0.99999995e9FIT_PARAM_VALUE
getCal4float8 4th profile calibration polynomial coefficient-0.99999995e9FIT_PARAM_VALUE
getCal5float8 5th profile calibration polynomial coefficient-0.99999995e9FIT_PARAM_VALUE
getCal6float8 6th profile calibration polynomial coefficient-0.99999995e9FIT_PARAM_VALUE
ffZpreal4magField-to-field zeropoint-0.99999995e9PHOT_ZPT
galZpfloat8magZeropoint of galaxy instrumental scale-0.99999995e9PHOT_ZPT
galGradfloat8mags per instrumental magGradient of galaxy instrumental mag scale-0.99999995e9FIT_PARAM_VALUE
directoryvarchar80 Name of directory in flat-file system of source data.NoneID_FILE
Total length1158