Login | Signup

Schemas for the tables

All attributes are floating point or double unless otherwise noted.

Schema for "objects" table

ncandnumber of candidates that cite this object (integer)
rameanmean RA in degrees
decmeanmean Dec in degrees
rastdstandard deviation of RA in arcseconds
decstdstandard deviation of Dec in arcseconds
glonmeanmean galactic longitude in degrees
glatmeanmean galactic latitude in degrees
maggminminimum g magnitude of candidates that cite this object
maggmaxmaximum g magnitude of candidates that cite this object
maggmedianmedian g magnitude of candidates that cite thisobject
maggmeanmean g magnitude of candidates that cite thisobject
magrminminimum r magnitude of candidates that cite thisobject
magrmaxmaximum r magnitude of candidates that cite thisobject
magrmedianmedian r magnitude of candidates that cite thisobject
magrmeanmean r magnitude of candidates that cite thisobject
latestgmaglatest g magnitude of candidates that cite this object
latestrmaglatest r magnitude of candidates that cite this object
jdminearliest Julian Day of candidates that cite this object
jdmaxlatest Julian Day of candidates that cite this object

Schema for "sherlock_classifications" table

(for more information see Sherlock documentation)
classification Can be NULL, AGN, BS, CV, NT, ORPHAN, SN, UNCLEAR, VS
summary Natural language about what Sherlock thinks this object is

Schema for "sherlock_crossmatches" table

(for more information see Sherlock documentation)
rank Rank of the match, 1 being best (integer)
catalogue_object_type Type of crossmatched catalogued astrophysical source (Can be: star, galaxy, cv, cb, agn, other, unknown) (string)
association_type Predicted transient classification if correctly associated with catalogued astrophysical source (VS, SN, CV, BS, NT, AGN, UNKNOWN) (string)
separationArcsec Separation from the candidate
northSeparationArcsec Separation north
eastSeparationArcsec Separation east
catalogue_table_name Name of the catalog with the matched object (string)
catalogue_object_id ID in the named catalog (integer)
z Redshift of the object
distance Distance of the object in Mpc
U U magnitude if known
UErr Error on U magnitude
B B magnitude if known
BErr Error on B magnitude
V V magnitude if known
VErr Error on V magnitude
G G magnitude if known
GErr Error on G magnitude
R R magnitude if known
RErr Error on R magnitude
I I magnitude if known
IErr Error on I magnitude
J J magnitude if known
JErr Error on J magnitude
H H magnitude if known
HErr Error on H magnitude
K K magnitude if known
KErr Error on K magnitude
_u u magnitude if known
_uErr Error on u magnitude
_g g magnitude if known
_gErr Error on g magnitude
_r r magnitude if known
_rErr Error on r magnitude
_i i magnitude if known
_iErr Error on i magnitude
_z z magnitude if known
_zErr Error on z magnitude
_y y magnitude if known
_yErr Error on y magnitude

Schema for "candidates" table

(The attributes below are not the full schema. For more documentation and full schema see ZTF schema document).
objectId Object ID for objects to which this candidate belongs (string)
candid unique identifier for the subtraction candidate (integer)
jd Observation Julian date at start of exposure
ra Right Ascension of candidate; J2000 [deg]
decl Declination of candidate; J2000 [deg]
magpsf magnitude from PSF-fit photometry [mag]
sigmapsf 1-sigma uncertainty in magpsf [mag]
chipsf Reduced chi-square for PSF-fit
magap Aperture mag using 8 pixel diameter aperture [mag]
sigmagap 1-sigma uncertainty in magap [mag]
isdiffpos t or 1 if candidate is from positive (sci minus ref) subtraction; f or 0 if candidate is from negative (ref minus sci) subtraction (string)
nid Night ID, starts 2017-01-01 (integer)
field ZTF field ID (integer)
xpos x-image position of candidate [pixels]
ypos y-image position of candidate [pixels]
distnr distance to nearest source in reference image PSF-catalog within 30 arcsec [pixels]
magnr magnitude of nearest source in reference image PSF-catalog within 30 arcsec [mag]
sigmagnr 1-sigma uncertainty in magnr within 30 arcsec [mag]
sky Local sky background estimate [DN]
magdiff Difference: magap - magpsf [mag]
fwhm Full Width Half Max assuming a Gaussian core, from SExtractor [pixels]
classtar Star/Galaxy classification score from SExtractor (string)
elong Ratio: aimage / bimage
nbad number of prior-tagged bad pixels in a 5 x 5 pixel stamp (integer)
rb RealBogus quality score; range is 0 to 1 where closer to 1 is more reliable
drb RealBogus quality score from Deep-Learning-based classifier; range is 0 to 1 where closer to 1 is more reliable
drbversion version of Deep-Learning-based classifier model used to assign RealBogus (drb) quality score
scorr Peak-pixel signal-to-noise ratio in point source matched-filtered detection image
Solar System
ssdistnr distance to nearest known solar system object; set to -999.0 if none [arcsec]
ssmagnr magnitude of nearest known solar system object (usually V-band from MPC archive); set to -999.0 if none [mag]
ssnamenr name of nearest known solar system object (from MPC archive); ‘null’ if none (string)
Pan-STARRS
objectidps1 Object ID of closest source from PS1 catalog; if exists within 30 arcsec
sgmag1 g-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec [mag]
srmag1 r-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec [mag]
simag1 i-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec [mag]
szmag1 z-band PSF magnitude of closest source from PS1 catalog; if exists within 30 arcsec [mag]
sgscore1 Star/Galaxy score of closest source from PS1 catalog 0 <= sgscore <= 1 where closer to 1 implies higher likelihood of being a star
distpsnr1 Distance of closest source from PS1 catalog; if exists within 30 arcsec [arcsec]
Gaia DR1
neargaia Distance to closest source from Gaia DR1 catalog irrespective of magnitude; if exists within 90 arcsec [arcsec]
neargaiabright Distance to closest source from Gaia DR1 catalog brighter than magnitude 14; if exists within 90 arcsec [arcsec]
maggaia Gaia (G-band) magnitude of closest source from Gaia DR1 catalog irrespective of magnitude; if exists within 90 arcsec [mag]
maggaiabright Gaia (G-band) magnitude of closest source from Gaia DR1 catalog brighter than magnitude 14; if exists within 90 arcsec [mag]
Attributes added by Lasair
dc_mag Computed apparent magnitude (see Note about Photometry in this page
dc_sigmag Error in computed apparent magnitude (see Note about Photometry in this page
dc_mag_g02Exponential Moving Average of apparent magnitude in g band, with 2-day timescale (see note)
dc_mag_g08Exponential Moving Average of apparent magnitude in g band, with 8-day timescale (see note)
dc_mag_g28Exponential Moving Average of apparent magnitude in g band, with 28-day timescale (see note)
dc_mag_r02Exponential Moving Average of apparent magnitude in r band, with 2-day timescale (see note)
dc_mag_r08Exponential Moving Average of apparent magnitude in r band, with 8-day timescale (see note)
dc_mag_r28Exponential Moving Average of apparent magnitude in r band, with 28-day timescale (see note)