TABLE  HoleObj

Information for holes on a Plate

This table stores information for non OBJECT holes, and for OBJECT holes that were not mapped.

nametypelengthunitucddescription
holeIDbigint8 ID_CATALOGhash assigned by csv creator
plateIDbigint8 ID_CATALOGhashed id of PlateX
holeTypeLink to HoleTypeint4 CODE_MISCtype of hole (plPlugMap style)
objTypeLink to ObjTypeint4 CODE_MISCtype of OBJECT hole (plPlugMap style)
targetIDbigint8 ID_CATALOGhash of run,rerun,camcol,field,id with skyversion=0
fiberIDsmallint2 ID_FIBERFiber ID
xFocalfloat8mmPOS_DETECTORx position on plate
yFocalfloat8mmPOS_DETECTORy position on plate
rafloat8degPOS_EQ_RAright ascension
decfloat8degPOS_EQ_DECdeclination
loadVersionint4 ID_VERSIONLoad Version