alerce_tap.ztf_divo://x-unregistred/alerce_tap/multisurvey_lowercase/ztf_detectionALeRCE (Automatic Learning for the Rapid Classification of Events)ALeRCE Teamhttps://tap.alerce.online/favicon.png2026-04-11T22:13:50ZALeRCE Team

Beauchef 851, Edificio Norte, piso 6. Santiago, Chile.

alerce.broker@gmail.comastronomy, objectssurveystransientstime-series Individual detections from ZTF difference imaging, including PSF and aperture photometry, Real/Bogus quality scores, corrected magnitudes accounting for reference flux, and flags indicating image quality and photometric reliability.http://tap.alerce.online/tableinfo/alerce_tap.ztf_detectionalerce_tap Multi-survey astronomical object catalog containing astrometric and statistical information from multiple surveys. This table provides aggregated properties for astronomical objects including position, detection statistics, and temporal coverage.alerce_tap.ztf_detection Individual detections from ZTF difference imaging, including PSF and aperture photometry, Real/Bogus quality scores, corrected magnitudes accounting for reference flux, and flags indicating image quality and photometric reliability.oidUnique identifier for this objectmeta.id;srclongindexedprimarysidSurvey identifiermeta.idshortmeasurement_idUnique identifier for the subtraction candidate (candid from ZTF)meta.idlongindexedprimarypidProcessing ID for imagemeta.idlongnullablediffmaglim5-sigma magnitude limit in difference image based on PSF-fit photometrymagphot.mag;stat.minfloatnullableisdiffposDifference image sign: 1 => candidate is from positive (science minus reference) subtraction; -1 => candidate is from negative (reference minus science) subtractionmeta.codeintnullablenidNight IDmeta.idintnullablemagpsfMagnitude from PSF-fit photometrymagphot.magfloatnullablesigmapsf1-sigma uncertainty in magpsfmagstat.error;phot.magfloatnullablemagapAperture magnitude using 8 pixel diameter aperturemagphot.magfloatnullablesigmagap1-sigma uncertainty in magapmagstat.error;phot.magfloatnullabledistnrDistance to nearest source in reference image PSF-catalog within 30 arcsecarcsecpos.angDistancefloatnullablerbRealBogus quality score from machine learning classifier, range 0 to 1 where closer to 1 is more reliablestat.probabilityfloatnullablerbversionVersion of RealBogus model/classifier used to assign rb quality scoremeta.versioncharnullabledrbRealBogus quality score from Deep-Learning-based classifier, range 0 to 1 where closer to 1 is more reliablestat.probabilityfloatnullabledrbversionVersion of Deep-Learning-based classifier model used to assign drb quality scoremeta.versioncharnullablemagapbigAperture magnitude using 18 pixel diameter aperturemagphot.magfloatnullablesigmagapbig1-sigma uncertainty in magapbigmagstat.error;phot.magfloatnullablerfidProcessing ID for reference image to facilitate archive retrievalmeta.idlongnullablemagpsf_corrCorrected PSF magnitude accounting for flux in reference imagemagphot.mag;arith.correctedfloatnullablesigmapsf_corrError of the corrected PSF magnitude assuming no contribution from an extended componentmagstat.error;phot.mag;arith.correctedfloatnullablesigmapsf_corr_extError of the corrected PSF magnitude assuming a contribution from an extended componentmagstat.error;phot.magfloatnullablecorrectedWhether the corrected photometry was applied (True if source present in reference image within 1.4 arcsec)meta.code.qualbooleannullabledubiousWhether the corrected photometry should be flagged as dubious due to inconsistenciesmeta.code.qualbooleannullableparent_candidParent candidate ID if alert coming from previous candidate history (null if from main alert)meta.idlongnullablehas_stampWhether the detection has an associated image stamp triplet (when parent_candid is null)meta.codebooleannullablecreated_dateDate record was createdtime.creationcharnullable