INDICES FOR TABLE  PhotoObjAll

Contains a record describing the attributes of each photometric object

The table has views:
  • PhotoObj: all primary and secondary objects; essentially this is the view you should use unless you want a specific type of object.
  • PhotoPrimary: all photo objects that are primary (the best version of the object).
    • Star: Primary objects that are classified as stars.
    • Galaxy: Primary objects that are classified as galaxies.
    • Sky:Primary objects which are sky samples.
    • Unknown:Primary objects which are no0ne of the above
  • PhotoSecondary: all photo objects that are secondary (secondary detections)
  • PhotoFamily: all photo objects which are neither primary nor secondary (blended)

The table has indices that cover the popular columns.

Index TypeKey or Field List
primary keyobjID
foreign keyField(fieldID)
covering indexmode, cy, cx, cz, htmID, type, flags, status, ra, dec, u, g, r, i, z, rho
covering indexhtmID, cx, cy, cz, type, mode, flags, status, ra, dec, u, g, r, i, z, rho
covering indexfield, run, rerun, camcol, type, mode, flags, rowc, colc, ra, dec, u, g, r, i, z
covering indexfieldID, objID, ra, dec, r, type, status, flags
covering indexSpecObjID, cx, cy, cz, mode, type, flags, status, ra, dec, u, g, r, i, z, rho
covering indexcx, cy, cz, htmID, mode, type, flags, status, ra, dec, u, g, r, i, z, rho
covering indexrun, mode, type, status, flags, u, g, r, i, z, Err_u, Err_g, Err_r, Err_i, Err_z
covering indexrun, camcol, rerun, type, mode, status, flags, ra, dec, fieldID, field, u, g, r, i, z
covering indexrun, camcol, field, mode, parentID, q_r, q_g, u_r, u_g, isoA_r, isoB_r, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z