alerce TAPivo://x-unregistred/tapALeRCE (Automatic Learning for the Rapid Classification of Events)ALeRCE Teamhttps://tap.alerce.online/favicon.png2026-03-16T19:34:29ZALeRCE Team

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

alerce.broker@gmail.comvirtual-observatoriescatalogsThe ALeRCE TAP service's TAP end point. The Table Access Protocol (TAP) lets you execute queries against our database tables, inspect various metadata, and upload your own data. It is thus the VO's premier way to access public data holdings. Tables exposed through this endpoint include: allwise, band, catalog_id_lut, classifier, detection, feature, feature_name_lut, feature_version_lut, forced_photometry, lsst_detection, lsst_dia_object, lsst_forced_photometry, lsst_mpc_orbits, lsst_ss_detection, lsst_ss_object, magstat, object, probability, sid_lut, taxonomy, xmatch, ztf_dataquality, ztf_detection, ztf_forced_photometry, ztf_gaia, ztf_non_detection, ztf_object, ztf_ps1, ztf_reference, ztf_ss from the alerce_tap schema, columns, groups, key_columns, keys, schemas, tables from the tap_schema schema.http://tap.alerce.online/__system__/tap/run/infoIsServiceForALeRCE Multi-Survey Object Cataloghttps://tap.alerce.online/tapADQL2.02.1The Astronomical Data Query Language is the standard IVOA dialect of SQL; it contains a very general SELECT statement as well as some extensions for spherical geometry and higher mathematics.

gavo_apply_pm(ra DOUBLE PRECISION, dec DOUBLE PRECISION, pmra DOUBLE PRECISION, pmde DOUBLE PRECISION, epdist DOUBLE PRECISION) -> POINT

Returns a POINT (in the UNDEFINED reference frame) for the position an object at ra/dec with proper motion pmra/pmde has after epdist years. positions must be in degrees, PMs in should be in julian years (i.e., proper motions are expected in degrees/year). pmra is assumed to contain cos(delta). This function goes through the tangential plane. Since it does not have information on distance and radial velocity, it cannot reconstruct the true space motion, and hence its results will degrade over time. This function should not be used in new queries; use ivo_epoch_prop instead.

gavo_getauthority(ivoid TEXT) -> TEXT

returns the authority part of an ivoid (or, more generally a URI). So, ivo://org.gavo.dc/foo/bar#baz becomes org.gavo.dc. The behaviour for anything that's not a full URI is undefined.

gavo_ipix(long REAL, lat REAL) -> BIGINT

gavo_ipix returns the q3c ipix for a long/lat pair (it simply wraps the 13c_ang2ipix function). This is probably only relevant when you play tricks with indices or PPMXL ids.

gavo_match(pattern TEXT, string TEXT) -> INTEGER

gavo_match returns 1 if the POSIX regular expression pattern matches anything in string, 0 otherwise.

gavo_mocintersect(moc1 MOC, moc2 MOC) -> MOC

returns the intersection of two MOCs.

gavo_mocunion(moc1 MOC, moc2 MOC) -> MOC

returns the union of two MOCs.

gavo_specconv(expr DOUBLE PRECISION, dest_unit TEXT) -> DOUBLE PRECISION

returns the spectral value expr converted to dest_unit. expr has to be in either energy, wavelength, or frequency, and dest_unit must be a VOUnit giving another spectral unit (e.g., MHz, keV, nm, or Angstrom). This is intended to let users express spectral constraints in their preferred unit independently of the choice of unit in the database. Examples:: gavo_specconv(obscore.em_min, "keV") > 300 gavo_specconv(obscore.em_max, "MHz") > 30 gavo_specconv(spectral_start, "Angstrom") > 4000 There is a variant of gavo_specconv accepting expr's unit in a third argument.

gavo_specconv(expr NUMERIC, expr_unit TEXT, dest_unit TEXT) -> NUMERIC

returns expr assumed to be in expr_unit expressed in dest_unit. This is a variant of the two-argument gavo_specconv for when the unit of expr is not known to the ADQL translator, either because it because it is a literal or because it does not look like a spectral unit. Examples:: gavo_specconv(656, 'nm', 'J') BETWEEN spectral_start AND spectral_end gavo_specconv(arccos(phi)*incidence, 'Hz', 'eV') Clearly, overriding known units is likely to yield bad results; the translator therefore warns if an existing unit is overridden with a different unit.

gavo_vocmatch(vocname TEXT, term TEXT, matchagainst TEXT) -> INTEGER

returns 1 if matchagainst is term or narrower in the IVOA vocabulary vocname, 0 otherwise. This is intended for semantic querying. For instance, gavo_vocmatch('datalink/core', 'calibration', semantics) would be 1 if semantics is any of calibration, bias, dark, or flat. For RDF-flavoured vocabularies (strict trees), term will expand to the entire branch rooted in term. For SKOS-flavoured vocabularies (where narrower is not transitive), only directly narrower terms will be included. Both the term and the vocabulary name must be string literals (i.e., constants). matchagainst can be any string-valued expression.

ivo_epoch_prop(ra DOUBLE PRECISION, dec DOUBLE PRECISION, parallax DOUBLE PRECISION, pmra DOUBLE PRECISION, pmdec DOUBLE PRECISION, radial_velocity DOUBLE PRECISION, ref_epoch DOUBLE PRECISION, out_epoch DOUBLE PRECISION) -> DOUBLE PRECISION[6]

Returns a 6-vector of (ra, dec, parallax, pmra, pmdec, rv) at out_epoch for these quantities at ref_epoch. Essentially, it will apply the proper motion under the assumption of linear motion. Despite the name of the positional parameters, this is not restricted to equatorial systems, as long as positions and proper motions are expressed in the same reference frames. Units on input and output are degrees for ra and dec, mas for parallax, mas/yr for pmra and pmdec, and km/s for the radial velocity. ref_epoch and out_epoch are given in Julian years. parallax, pmra, pmdec, and radial_velocity may be None and will enter the computations as 0 then, except in the case of parallax, which will be some small value. When abs(parallax) is smaller or equal to that small value, parallax and radial velocity will be NULL on output. In daily use, you probably want to use the ivo_epoch_prop_pos functions.

ivo_epoch_prop_pos(ra DOUBLE PRECISION, dec DOUBLE PRECISION, parallax DOUBLE PRECISION, pmra DOUBLE PRECISION, pmdec DOUBLE PRECISION, radial_velocity DOUBLE PRECISION, ref_epoch DOUBLE PRECISION, out_epoch DOUBLE PRECISION) -> POINT

Returns a POINT giving the position at out_epoch for an object with the six parameters at ref_epoch. Essentially, it will apply the proper motion under the assumption of linear motion. Despite the name of the positional parameters, this is not restricted to equatorial systems, as long as positions and proper motions are expressed in the same reference frames. Units on input are degrees for ra and dec, mas for parallax, mas/yr for pmra and pmdec, and km/s for the radial velocity. ref_epoch and out_epoch are given in Julian years. parallax, pmra, pmdec, and radial_velocity may be None and will enter the computations as 0 then, except in the case of parallax, which will be some small value.

ivo_epoch_prop_pos(ra DOUBLE PRECISION, dec DOUBLE PRECISION, pmra DOUBLE PRECISION, pmdec DOUBLE PRECISION, ref_epoch DOUBLE PRECISION, out_epoch DOUBLE PRECISION) -> POINT

A variant of ivo_epoch_prop_pos that behave as if parallax and radial_velocity were both passed as NULL.

ivo_geom_transform(from_sys TEXT, to_sys TEXT, geo GEOMETRY) -> GEOMETRY

The function transforms ADQL geometries between various reference systems. geo can be a POINT, a CIRCLE, or a POLYGON, and the function will return a geometry of the same type. In the current implementation, from_sys and to_sys must be literal strings (i.e., they cannot be computed through expressions or be taken from database columns). All transforms are just simple rotations, which is only a rough approximation to the actual relationships between reference systems (in particular between FK4 and ICRS-based ones). Note that, in particular, the epoch is not changed (i.e., no proper motions are applied). We currently support the following reference frames: ICRS, FK5 (which is treated as ICRS), FK4 (for B1950. without epoch-dependent corrections), GALACTIC. Reference frame names are case-sensitive.

ivo_hashlist_has(hashlist TEXT, item TEXT) -> INTEGER

The function takes two strings; the first is a list of words not containing the hash sign (#), concatenated by hash signs, the second is a word not containing the hash sign. It returns 1 if, compared case-insensitively, the second argument is in the list of words coded in the first argument. The behaviour in case the the second argument contains a hash sign is unspecified.

ivo_hasword(haystack TEXT, needle TEXT) -> INTEGER

gavo_hasword returns 1 if needle shows up in haystack, 0 otherwise. This is for "google-like"-searches in text-like fields. In word, you can actually employ a fairly complex query language; see https://www.postgresql.org/docs/current/textsearch.html for details.

ivo_healpix_center(hpxOrder INTEGER, hpxIndex BIGINT) -> POINT

returns a POINT corresponding to the center of the healpix with the given index at the given order.

ivo_healpix_index(order INTEGER, ra DOUBLE PRECISION, dec DOUBLE PRECISION) -> BIGINT

Returns the index of the (nest) healpix with order containing the spherical point (ra, dec). An alternative, 2-argument form ivo_healpix_index(order INTEGER, p POINT) -> BIGINT is also available.

ivo_histogram(val REAL, lower REAL, upper REAL, nbins INTEGER) -> INTEGER[]

The aggregate function returns a histogram of val with nbins+2 elements. Assuming 0-based arrays, result[0] contains the number of underflows (i.e., val<lower), result[nbins+1] the number of overflows. Elements 1..nbins are the counts in nbins bins of width (upper-lower)/nbins. Clients will have to convert back to physical units using some external communication, there currently is no (meta-) data as lower and upper in the TAP response.

ivo_interval_has(val NUMERIC, iv INTERVAL) -> INTEGER

The function returns 1 if the interval iv contains val, 0 otherwise. The lower limit is always included in iv, behaviour on the upper limit is column-specific.

ivo_interval_overlaps(l1 NUMERIC, h1 NUMERIC, l2 NUMERIC, h2 NUMERIC) -> INTEGER

The function returns 1 if the interval [l1...h1] overlaps with the interval [l2...h2]. For the purposes of this function, the case l1=h2 or l2=h1 is treated as overlap. The function returns 0 for non-overlapping intervals.

ivo_nocasematch(value TEXT, pattern TEXT) -> INTEGER

ivo_nocasematch returns 1 if pattern matches value, 0 otherwise. pattern is defined as for the SQL LIKE operator, but the match is performed case-insensitively. This function in effect provides a surrogate for the ILIKE SQL operator that is missing from ADQL. On this site, this is actually implemented using python's and SQL's LOWER, so for everything except ASCII, your mileage will vary.

ivo_normal_random(mu REAL, sigma REAL) -> REAL

The function returns a random number drawn from a normal distribution with mean mu and width sigma. Implementation note: Right now, the Gaussian is approximated by summing up and scaling ten calls to random. This, hence, is not very precise or fast. It might work for some use cases, and we will provide a better implementation if this proves inadequate.

ivo_simbadpoint(identifier TEXT) -> POINT

gavo_simbadpoint queries simbad for an identifier and returns the corresponding point. Note that identifier can only be a literal, i.e., as simple string rather than a column name. This is because our database cannot query simbad, and we probably wouldn't want to fire off millions of simbad queries anyway; use simbad's own TAP service for this kind of application.

ivo_string_agg(expression TEXT, delimiter TEXT) -> TEXT

An aggregate function returning all values of expression within a GROUP contcatenated with delimiter

ivo_to_jd(d TIMESTAMP) -> DOUBLE PRECISION

The function converts a postgres timestamp to julian date. This is naive; no corrections for timezones, let alone time scales or the like are done; you can thus not expect this to be good to second-precision unless you are careful in the construction of the timestamp.

ivo_to_mjd(d TIMESTAMP) -> DOUBLE PRECISION

The function converts a postgres timestamp to modified julian date. This is naive; no corrections for timezones, let alone time scales or the like are done; you can thus not expect this to be good to second-precision unless you are careful in the construction of the timestamp.

BOX

POINT

CIRCLE

POLYGON

REGION

CENTROID

COORD1

COORD2

DISTANCE

CONTAINS

INTERSECTS

AREA

COALESCE

LOWER

ILIKE

UPPER

OFFSET

CAST

IN_UNIT

WITH

TABLESAMPLE

Written after a table reference, TABLESAMPLE(10) will make the database only use 10% of the rows; these are `somewhat random' in that the system will use random blocks. This should be good enough when just testing queries (and much better than using TOP n).

MOC

A geometry function creating MOCs. It either takes a string argument with an ASCII MOC ('4/13 17-18 8/3002'), or an order and another geometry.

VECTORMATH

You can compute with vectors here. See https://wiki.ivoa.net/twiki/bin/view/IVOA/ADQLVectorMath for an overview of the functions and operators available.

CASE

The SQL92 CASE expression

UNION

EXCEPT

INTERSECT

text/tab-separated-valuestsvtext/plaintxttext/csvcsv_baretext/csv;header=presentcsvapplication/jsonjsonapplication/geo+jsongeojsonapplication/x-votable+xmlvotableapplication/x-votable+xml;serialization=BINARY2votable/b2votableb2application/x-votable+xml;serialization=TABLEDATAtext/xmlvotable/tdvotabletdapplication/x-votable+xml;serialization=TABLEDATA;version=1.1text/xmlvotabletd1.1application/x-votable+xml;version=1.1text/xmlvotable1.1application/x-votable+xml;serialization=TABLEDATA;version=1.2text/xmlvotabletd1.2application/x-votable+xml;serialization=TABLEDATA;version=1.6vodmlapplication/x-votable+xml;version=1.6vodmlbtext/htmlhtmlapplication/fitsfits1728003600200002000000020000000https://tap.alerce.online/__system__/tap/run/availabilityhttps://tap.alerce.online/__system__/tap/run/capabilitieshttps://tap.alerce.online/__system__/tap/run/tableMetadatatap_schema ALeRCE TAP service's Table Access Protocol (TAP) service with table metadata.tap_schema.tablesTables available for ADQL querying.schema_nameFully qualified schema namecharnullabletable_nameFully qualified table namecharindexedprimarytable_typeOne of: table, viewcharnullabledescriptionBrief description of the tableunicodeCharnullableutypeutype if the table corresponds to a data modelcharnullabletable_indexSuggested position this table should take in a sorted list of tables from this data centerintnullablesourcerdId of the originating rd (local information)charnullablenrowsThe approximate size of the table in rowslongnullabletap_schema.schemasschema_nameschema_nametap_schema.columnsColumns in tables available for ADQL querying.table_nameFully qualified table namecharindexedprimarycolumn_nameColumn namecharindexedprimarydescriptionBrief description of columnunicodeCharnullableunitUnit in VO standard formatcharnullableucdUCD of column if anycharnullableutypeUtype of column if anycharnullabledatatypeADQL datatypecharnullablearraysizeArraysize in VOTable notationcharnullablextypeVOTable extended type information (for special interpretation of data content, e.g., timestamps or points)charnullable"size"Legacy length (ignore if you can).intnullableprincipalIs column principal?intindexedIs there an index on this column?intstdIs this a standard column?intsourcerdId of the originating rd (local information)charnullablecolumn_index1-based index of the column in database order.shortnullabletap_schema.tablestable_nametable_nametap_schema.schemasSchemas containing tables available for ADQL querying.schema_nameFully qualified schema namecharindexedprimarydescriptionBrief description of the schemaunicodeCharnullableutypeutype if schema corresponds to a data modelcharnullableschema_indexSuggested position this schema should take in a sorted list of schemas from this data center.intnullabletap_schema.keysForeign key relationships between tables available for ADQL querying.key_idUnique key identifiercharindexedprimaryfrom_tableFully qualified table namecharnullabletarget_tableFully qualified table namecharnullabledescriptionDescription of this keyunicodeCharnullableutypeUtype of this keycharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.tablesfrom_tabletable_nametap_schema.tablestarget_tabletable_nametap_schema.key_columnsColumns participating in foreign key relationships between tables available for ADQL querying.key_idKey identifier from TAP_SCHEMA.keyscharnullablefrom_columnKey column name in the from tablecharnullabletarget_columnKey column in the target tablecharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.keyskey_idkey_idtap_schema.groupsColumns that are part of groups within tables available for ADQL querying.table_nameFully qualified table namecharnullablecolumn_nameName of a column belonging to the groupcharnullablecolumn_utypeutype the column within the groupcharnullablegroup_nameName of the groupcharnullablegroup_utypeutype of the groupcharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.tablestable_nametable_namealerce_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.object This table contains aggregated information about astronomical objects observed in multiple surveys. Each record corresponds to a unique object identified by its position and survey. The table includes astrometric properties (mean RA/Dec), detection statistics (number of detections, forced photometry measurements, non-detections), and temporal coverage (first and last observation dates).oidInternal object identifiermeta.id;srclongindexedprimarytidTelescope identifiermeta.idshortsidSurvey identifiermeta.idshortindexedprimarymeanraMean right ascension (ICRS)degpos.eq.ra;meta.maindoubleindexedmeandecMean declination (ICRS)degpos.eq.dec;meta.maindoubleindexedsigmaraStandard deviation of right ascensiondegstat.error;pos.eq.radoublenullablesigmadecStandard deviation of declinationdegstat.error;pos.eq.decdoublenullablefirstmjdFirst observation MJDdtime.start;obsdoubleindexedlastmjdLast observation MJDdtime.end;obsdoubleindexeddeltamjdTime span between first and last observationdtime.intervaldoublen_detNumber of detectionsmeta.numberintindexedn_forcedNumber of forced photometry measurementsmeta.numberintn_non_detNumber of non-detectionsmeta.numberintcreated_dateDate when the record was createdtime.creationcharnullableupdated_dateDate when the record was last updatedtime.processingcharnullablealerce_tap.ztf_object ZTF-specific properties for astronomical objects including color indices, stellar classification, photometric correction flags, and historical detection statistics from the Zwicky Transient Facility survey.oidUnique identifier for this objectmeta.id;srclongindexedprimaryg_r_maxMaximum g-r color (difference between minimum g and r band magnitudes)phot.color;stat.maxfloatnullableg_r_max_corrMaximum g-r color using corrected magnitudesphot.color;stat.max;arith.correctedfloatnullableg_r_meanMean g-r color (difference between mean g and r band magnitudes)phot.color;stat.meanfloatnullableg_r_mean_corrMean g-r color using corrected magnitudesphot.color;stat.mean;arith.correctedfloatnullablecorrectedWhether the corrected light curve was computed and can be usedbooleanstellarWhether the object is likely a stellar-like (unresolved) source based on PS1 and ZTF reference image propertiesbooleannullablereference_changeReference image change flag indicating template updatebooleannullablediffposDifference image positivity flagbooleannullablendethistNumber of spatially-coincident detections within 1.5 arcsec going back to beginning of survey; only detections on the same field and readout-channel ID are counted, down to S/N ~ 3intnullablencovhistNumber of times the object position fell on any field and readout-channel going back to beginning of surveyintnullablemjdstarthistEarliest Modified Julian Date corresponding to ndethistdtime.startdoublenullablemjdendhistLatest Modified Julian Date corresponding to ndethistdtime.enddoublenullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.lsst_dia_object Summary catalog of transient and variable objects detected in LSST difference imaging. Contains aggregated photometric measurements across all bands (u, g, r, i, z, y), including PSF flux statistics, forced photometry fluxes, and temporal information for each detected DIA object.oidUnique identifier of this DiaObjectmeta.id;srclongindexedprimaryvaliditystartmjdtaiProcessing time when validity of this diaObject starts, expressed as Modified Julian Date, International Atomic Timedtime.startdoubleraRight ascension coordinate of the position of the objectdegpos.eq.ra;meta.maindoubleindexedraerrUncertainty of radegstat.error;pos.eq.rafloatnullabledecDeclination coordinate of the position of the objectdegpos.eq.dec;meta.maindoubleindexeddecerrUncertainty of decdegstat.error;pos.eq.decfloatnullablera_dec_covCovariance between ra and decdeg**2stat.covariance;pos.eqfloatnullableu_psffluxmeanWeighted mean point-source model magnitude for u filterphot.flux;em.opt.U;stat.meanfloatnullableu_psffluxmeanerrStandard error of u_psfFluxMeanstat.error;phot.flux;em.opt.Ufloatnullableu_psffluxsigmaStandard deviation of the distribution of u_psfFluxstat.stdev;phot.flux;em.opt.Ufloatnullableu_psffluxndataThe number of u-band data pointsmeta.numberintnullableu_fpfluxmeanWeighted mean forced photometry flux for u filterphot.flux;em.opt.U;stat.meanfloatnullableu_fpfluxmeanerrStandard error of u_fpFluxMeanstat.error;phot.flux;em.opt.Ufloatnullableg_psffluxmeanWeighted mean point-source model magnitude for g filterphot.flux;em.opt.B;stat.meanfloatnullableg_psffluxmeanerrStandard error of g_psfFluxMeanstat.error;phot.flux;em.opt.Bfloatnullableg_psffluxsigmaStandard deviation of the distribution of g_psfFluxstat.stdev;phot.flux;em.opt.Bfloatnullableg_psffluxndataThe number of g-band data pointsmeta.numberintnullableg_fpfluxmeanWeighted mean forced photometry flux for g filterphot.flux;em.opt.B;stat.meanfloatnullableg_fpfluxmeanerrStandard error of g_fpFluxMeanstat.error;phot.flux;em.opt.Bfloatnullabler_psffluxmeanWeighted mean point-source model magnitude for r filterphot.flux;em.opt.R;stat.meanfloatnullabler_psffluxmeanerrStandard error of r_psfFluxMeanstat.error;phot.flux;em.opt.Rfloatnullabler_psffluxsigmaStandard deviation of the distribution of r_psfFluxstat.stdev;phot.flux;em.opt.Rfloatnullabler_psffluxndataThe number of r-band data pointsmeta.numberintnullabler_fpfluxmeanWeighted mean forced photometry flux for r filterphot.flux;em.opt.R;stat.meanfloatnullabler_fpfluxmeanerrStandard error of r_fpFluxMeanstat.error;phot.flux;em.opt.Rfloatnullablei_psffluxmeanWeighted mean point-source model magnitude for i filterphot.flux;em.opt.I;stat.meanfloatnullablei_psffluxmeanerrStandard error of i_psfFluxMeanstat.error;phot.flux;em.opt.Ifloatnullablei_psffluxsigmaStandard deviation of the distribution of i_psfFluxstat.stdev;phot.flux;em.opt.Ifloatnullablei_psffluxndataThe number of i-band data pointsmeta.numberintnullablei_fpfluxmeanWeighted mean forced photometry flux for i filterphot.flux;em.opt.I;stat.meanfloatnullablei_fpfluxmeanerrStandard error of i_fpFluxMeanstat.error;phot.flux;em.opt.Ifloatnullablez_psffluxmeanWeighted mean point-source model magnitude for z filterphot.flux;em.opt.I;stat.meanfloatnullablez_psffluxmeanerrStandard error of z_psfFluxMeanstat.error;phot.flux;em.opt.Ifloatnullablez_psffluxsigmaStandard deviation of the distribution of z_psfFluxstat.stdev;phot.flux;em.opt.Ifloatnullablez_psffluxndataThe number of z-band data pointsmeta.numberintnullablez_fpfluxmeanWeighted mean forced photometry flux for z filterphot.flux;em.opt.I;stat.meanfloatnullablez_fpfluxmeanerrStandard error of z_fpFluxMeanstat.error;phot.flux;em.opt.Ifloatnullabley_psffluxmeanWeighted mean point-source model magnitude for y filterphot.flux;em.IR.NIR;stat.meanfloatnullabley_psffluxmeanerrStandard error of y_psfFluxMeanstat.error;phot.flux;em.IR.NIRfloatnullabley_psffluxsigmaStandard deviation of the distribution of y_psfFluxstat.stdev;phot.flux;em.IR.NIRfloatnullabley_psffluxndataThe number of y-band data pointsmeta.numberintnullabley_fpfluxmeanWeighted mean forced photometry flux for y filterphot.flux;em.IR.NIR;stat.meanfloatnullabley_fpfluxmeanerrStandard error of y_fpFluxMeanstat.error;phot.flux;em.IR.NIRfloatnullableu_sciencefluxmeanWeighted mean forced photometry flux for u filterphot.flux;em.opt.U;stat.meanfloatnullableu_sciencefluxmeanerrStandard error of u_scienceFluxMeanstat.error;phot.flux;em.opt.Ufloatnullableg_sciencefluxmeanWeighted mean forced photometry flux for g filterphot.flux;em.opt.B;stat.meanfloatnullableg_sciencefluxmeanerrStandard error of g_scienceFluxMeanstat.error;phot.flux;em.opt.Bfloatnullabler_sciencefluxmeanWeighted mean forced photometry flux for r filterphot.flux;em.opt.R;stat.meanfloatnullabler_sciencefluxmeanerrStandard error of r_scienceFluxMeanstat.error;phot.flux;em.opt.Rfloatnullablei_sciencefluxmeanWeighted mean forced photometry flux for i filterphot.flux;em.opt.I;stat.meanfloatnullablei_sciencefluxmeanerrStandard error of i_scienceFluxMeanstat.error;phot.flux;em.opt.Ifloatnullablez_sciencefluxmeanWeighted mean forced photometry flux for z filterphot.flux;em.opt.I;stat.meanfloatnullablez_sciencefluxmeanerrStandard error of z_scienceFluxMeanstat.error;phot.flux;em.opt.Ifloatnullabley_sciencefluxmeanWeighted mean forced photometry flux for y filterphot.flux;em.IR.NIR;stat.meanfloatnullabley_sciencefluxmeanerrStandard error of y_scienceFluxMeanstat.error;phot.flux;em.IR.NIRfloatnullableu_psffluxminMinimum observed u band fluxesphot.flux;em.opt.U;stat.minfloatnullableu_psffluxmaxMaximum observed u band fluxesphot.flux;em.opt.U;stat.maxfloatnullableu_psffluxmaxslopeMaximum slope between u band flux obsevations max(delta_flux/delta_time)nJy/darith.rate;phot.flux;em.opt.U;stat.maxfloatnullableu_psffluxerrmeanMean of the u band flux errorsstat.error;phot.flux;em.opt.U;stat.meanfloatnullableg_psffluxminMinimum observed g band fluxesphot.flux;em.opt.B;stat.minfloatnullableg_psffluxmaxMaximum observed g band fluxesphot.flux;em.opt.B;stat.maxfloatnullableg_psffluxmaxslopeMaximum slope between g band flux obsevations max(delta_flux/delta_time)nJy/darith.rate;phot.flux;em.opt.B;stat.maxfloatnullableg_psffluxerrmeanMean of the g band flux errorsstat.error;phot.flux;em.opt.B;stat.meanfloatnullabler_psffluxminMinimum observed r band fluxesphot.flux;em.opt.R;stat.minfloatnullabler_psffluxmaxMaximum observed r band fluxesphot.flux;em.opt.R;stat.maxfloatnullabler_psffluxmaxslopeMaximum slope between r band flux obsevations max(delta_flux/delta_time)nJy/darith.rate;phot.flux;em.opt.R;stat.maxfloatnullabler_psffluxerrmeanMean of the r band flux errorsstat.error;phot.flux;em.opt.R;stat.meanfloatnullablei_psffluxminMinimum observed i band fluxesphot.flux;em.opt.I;stat.minfloatnullablei_psffluxmaxMaximum observed i band fluxesphot.flux;em.opt.I;stat.maxfloatnullablei_psffluxmaxslopeMaximum slope between i band flux obsevations max(delta_flux/delta_time)nJy/darith.rate;phot.flux;em.opt.I;stat.maxfloatnullablei_psffluxerrmeanMean of the i band flux errorsstat.error;phot.flux;em.opt.I;stat.meanfloatnullablez_psffluxminMinimum observed z band fluxesphot.flux;em.opt.I;stat.minfloatnullablez_psffluxmaxMaximum observed z band fluxesphot.flux;em.opt.I;stat.maxfloatnullablez_psffluxmaxslopeMaximum slope between z band flux obsevations max(delta_flux/delta_time)nJy/darith.rate;phot.flux;em.opt.I;stat.maxfloatnullablez_psffluxerrmeanMean of the z band flux errorsstat.error;phot.flux;em.opt.I;stat.meanfloatnullabley_psffluxminMinimum observed y band fluxesphot.flux;em.IR.NIR;stat.minfloatnullabley_psffluxmaxMaximum observed y band fluxesphot.flux;em.IR.NIR;stat.maxfloatnullabley_psffluxmaxslopeMaximum slope between y band flux obsevations max(delta_flux/delta_time)nJy/darith.rate;phot.flux;em.IR.NIR;stat.maxfloatnullabley_psffluxerrmeanMean of the y band flux errorsstat.error;phot.flux;em.IR.NIR;stat.meanfloatnullablefirstdiasourcemjdtaiFirst DIA source MJD in TAIdtime.startdoublenullablelastdiasourcemjdtaiLast DIA source MJD in TAIdtime.enddoublenullablendiasourcesNumber of DIA sourcesmeta.numberintcreated_dateDate record was createdtime.creationcharnullablealerce_tap.lsst_ss_object Properties of solar system objects observed by LSST, including orbital parameters, photometric phase curves, minimum orbit intersection distances (MOID), and H-G12 magnitude models fitted in each photometric band.oidSolar system object identifiermeta.id;srclongindexedprimarydesignationThe unpacked primary provisional designation for this objectmeta.idcharnullablenobsTotal number of LSST observations of this objectmeta.number;obsintarcTimespan (arc) of all LSST observations, t_last - t_firstdtime.duration;obsfloatfirstobservationmjdtaiThe time of the first LSST observation of this object (could be precovered), TAIdtime.epoch;obsdoublenullablemoidearthMinimum orbit intersection distance to EarthAUpos.distance;src.orbitalfloatnullablemoidearthdeltavDeltaV at the MOID pointkm/sphys.veloc.orbitalfloatnullablemoideartheclipticlongitudeEcliptic longitude of the MOID point (Earth's orbit)degpos.ecliptic.lonfloatnullablemoidearthtrueanomalyTrue anomaly of the MOID point on Earth's orbitdegpos.phaseAngfloatnullablemoidearthtrueanomalyobjectTrue anomaly of the MOID point on the object's orbitdegpos.phaseAng;src.orbitalfloatnullabletisserand_jTisserand parameter with respect to Jupiter (T_J)src.orbital.TissJfloatnullableextendednessmaxMaximum extendedness value from the DiaSourcephys.size;stat.maxfloatnullableextendednessmedianMedian extendedness value from the DiaSourcephys.size;stat.medianfloatnullableextendednessminMinimum extendedness value from the DiaSourcephys.size;stat.minfloatnullableu_nobsTotal number of data points (u band)meta.number;obsintnullableu_hBest fit absolute magnitude (u band)magphot.magfloatnullableu_herrError in the estimate of H (u band)magstat.error;phot.magfloatnullableu_g12Best fit G12 slope parameter (u band)stat.fit.paramfloatnullableu_g12errError in the estimate of G12 (u band)stat.error;stat.fit.paramfloatnullableu_h_u_g12_covH–G12 covariance (u band)mag**2stat.covariance;phot.mag;stat.fit.paramfloatnullableu_nobsusedThe number of data points used to fit the phase curve (u band)meta.number;obsintnullableu_chi2Chi^2 statistic of the phase curve fit (u band)stat.fit.chi2floatnullableu_phaseangleminMinimum phase angle observed (u band)degpos.phaseAng;stat.minfloatnullableu_phaseanglemaxMaximum phase angle observed (u band)degpos.phaseAng;stat.maxfloatnullableu_slope_fit_failedG12 fit failed in u band. G12 contains a fiducial value used to fit Hmeta.code.qualbooleannullableg_nobsTotal number of data points (g band)meta.number;obsintnullableg_hBest fit absolute magnitude (g band)magphot.magfloatnullableg_herrError in the estimate of H (g band)magstat.error;phot.magfloatnullableg_g12Best fit G12 slope parameter (g band)stat.fit.paramfloatnullableg_g12errError in the estimate of G12 (g band)stat.error;stat.fit.paramfloatnullableg_h_g_g12_covH–G12 covariance (g band)mag**2stat.covariance;phot.mag;stat.fit.paramfloatnullableg_nobsusedThe number of data points used to fit the phase curve (g band)meta.number;obsintnullableg_chi2Chi^2 statistic of the phase curve fit (g band)stat.fit.chi2floatnullableg_phaseangleminMinimum phase angle observed (g band)degpos.phaseAng;stat.minfloatnullableg_phaseanglemaxMaximum phase angle observed (g band)degpos.phaseAng;stat.maxfloatnullableg_slope_fit_failedG12 fit failed in g band. G12 contains a fiducial value used to fit Hmeta.code.qualbooleannullabler_nobsTotal number of data points (r band)meta.number;obsintnullabler_hBest fit absolute magnitude (r band)magphot.magfloatnullabler_herrError in the estimate of H (r band)magstat.error;phot.magfloatnullabler_g12Best fit G12 slope parameter (r band)stat.fit.paramfloatnullabler_g12errError in the estimate of G12 (r band)stat.error;stat.fit.paramfloatnullabler_h_r_g12_covH–G12 covariance (r band)mag**2stat.covariance;phot.mag;stat.fit.paramfloatnullabler_nobsusedThe number of data points used to fit the phase curve (r band)meta.number;obsintnullabler_chi2Chi^2 statistic of the phase curve fit (r band)stat.fit.chi2floatnullabler_phaseangleminMinimum phase angle observed (r band)degpos.phaseAng;stat.minfloatnullabler_phaseanglemaxMaximum phase angle observed (r band)degpos.phaseAng;stat.maxfloatnullabler_slope_fit_failedG12 fit failed in r band. G12 contains a fiducial value used to fit Hmeta.code.qualbooleannullablei_nobsTotal number of data points (i band)meta.number;obsintnullablei_hBest fit absolute magnitude (i band)magphot.magfloatnullablei_herrError in the estimate of H (i band)magstat.error;phot.magfloatnullablei_g12Best fit G12 slope parameter (i band)stat.fit.paramfloatnullablei_g12errError in the estimate of G12 (i band)stat.error;stat.fit.paramfloatnullablei_h_i_g12_covH–G12 covariance (i band)mag**2stat.covariance;phot.mag;stat.fit.paramfloatnullablei_nobsusedThe number of data points used to fit the phase curve (i band)meta.number;obsintnullablei_chi2Chi^2 statistic of the phase curve fit (i band)stat.fit.chi2floatnullablei_phaseangleminMinimum phase angle observed (i band)degpos.phaseAng;stat.minfloatnullablei_phaseanglemaxMaximum phase angle observed (i band)degpos.phaseAng;stat.maxfloatnullablei_slope_fit_failedG12 fit failed in i band. G12 contains a fiducial value used to fit Hmeta.code.qualbooleannullablez_nobsTotal number of data points (z band)meta.number;obsintnullablez_hBest fit absolute magnitude (z band)magphot.magfloatnullablez_herrError in the estimate of H (z band)magstat.error;phot.magfloatnullablez_g12Best fit G12 slope parameter (z band)stat.fit.paramfloatnullablez_g12errError in the estimate of G12 (z band)stat.error;stat.fit.paramfloatnullablez_h_z_g12_covH–G12 covariance (z band)mag**2stat.covariance;phot.mag;stat.fit.paramfloatnullablez_nobsusedThe number of data points used to fit the phase curve (z band)meta.number;obsintnullablez_chi2Chi^2 statistic of the phase curve fit (z band)stat.fit.chi2floatnullablez_phaseangleminMinimum phase angle observed (z band)degpos.phaseAng;stat.minfloatnullablez_phaseanglemaxMaximum phase angle observed (z band)degpos.phaseAng;stat.maxfloatnullablez_slope_fit_failedG12 fit failed in z band. G12 contains a fiducial value used to fit Hmeta.code.qualbooleannullabley_nobsTotal number of data points (y band)meta.number;obsintnullabley_hBest fit absolute magnitude (y band)magphot.magfloatnullabley_herrError in the estimate of H (y band)magstat.error;phot.magfloatnullabley_g12Best fit G12 slope parameter (y band)stat.fit.paramfloatnullabley_g12errError in the estimate of G12 (y band)stat.error;stat.fit.paramfloatnullabley_h_y_g12_covH–G12 covariance (y band)mag**2stat.covariance;phot.mag;stat.fit.paramfloatnullabley_nobsusedThe number of data points used to fit the phase curve (y band)meta.number;obsintnullabley_chi2Chi^2 statistic of the phase curve fit (y band)stat.fit.chi2floatnullabley_phaseangleminMinimum phase angle observed (y band)degpos.phaseAng;stat.minfloatnullabley_phaseanglemaxMaximum phase angle observed (y band)degpos.phaseAng;stat.maxfloatnullabley_slope_fit_failedG12 fit failed in y band. G12 contains a fiducial value used to fit Hmeta.code.qualbooleannullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.lsst_mpc_orbits Complete orbital solutions from the Minor Planet Center for solar system objects, including Keplerian orbital elements, non-gravitational parameters (Yarkovsky, SRP, A1-A3), observational arc statistics, fit quality metrics, and Earth MOID calculations.ssobjectidSolar system object identifiermeta.id;srclongindexedprimarydesignationThe unpacked primary provisional designation for this objectmeta.id;srccharpacked_primary_provisional_designationThe primary provisional designation in packed form (e.g. K08A00B)meta.id;srccharunpacked_primary_provisional_designationThe primary provisional designation in unpacked form (e.g. 2008 AB)meta.id;srccharmpc_orb_jsonbDetails of the orbit solution in JSON formmetacharnullablecreated_atWhen this row was createdtime.creation;meta.datasetcharnullableupdated_atWhen this row was updatedtime.processing;meta.datasetcharnullableorbit_type_intOrbit type codemeta.codeintnullableu_paramU parametermeta.codeintnullablenoppNumber of oppositionsmeta.numberintnullablearc_length_totalArc length over total observations [days]dtime.intervaldoublenullablearc_length_selArc length over total observations *selected* [days]dtime.intervaldoublenullablenobs_totalTotal number of all observations (optical + radar) availablemeta.numberintnullablenobs_total_selTotal number of all observations (optical + radar) selected for use in orbit fittingmeta.numberintnullableaSemi Major Axis [au]AUpos.distance;src.orbitaldoublenullableqPericenter Distance [au]AUpos.distance;src.orbitaldoublenullableeEccentricitysrc.orbital.eccentricitydoublenullableiInclination [degrees]degsrc.orbital.inclinationdoublenullablenodeLongitude of Ascending Node [degrees]degsrc.orbital.nodedoublenullableargperiArgument of Pericenter [degrees]degsrc.orbital.periastrondoublenullableperi_timeTime from Pericenter Passage [days]dtime.epochdoublenullableyarkovskyYarkovsky Component [10^(-10)*au/day^2]1e-10.au.d-2phys.accelerationdoublenullablesrpSolar-Radiation Pressure Component [m^2/ton]m2.t-1phys.accelerationdoublenullablea1A1 non-grav components [m^2/ton]m2.t-1phys.accelerationdoublenullablea2A2 non-grav components [m^2/ton]m2.t-1phys.accelerationdoublenullablea3A3 non-grav components [m^2/ton]m2.t-1phys.accelerationdoublenullabledtDT non-grav componenttime.intervaldoublenullablemean_anomalyMean Anomaly [degrees]degsrc.orbital.meanAnomalydoublenullableperiodOrbital Period [days]dtime.period.revolution;src.orbitaldoublenullablemean_motionOrbital Mean Motion [degrees per day]deg.d-1src.orbital.meanMotiondoublenullablea_uncUncertainty on Semi Major Axis [au]AUstat.error;pos.distance;src.orbitaldoublenullableq_uncUncertainty on Pericenter Distance [au]AUstat.error;pos.distance;src.orbitaldoublenullablee_uncUncertainty on Eccentricitystat.error;src.orbital.eccentricitydoublenullablei_uncUncertainty on Inclination [degrees]degstat.error;src.orbital.inclinationdoublenullablenode_uncUncertainty on Longitude of Ascending Node [degrees]degstat.error;src.orbital.nodedoublenullableargperi_uncUncertainty on Argument of Pericenter [degrees]degstat.error;src.orbital.periastrondoublenullableperi_time_uncTime of perihelion passage uncertaintydstat.error;time.epochdoublenullableyarkovsky_uncYarkovsky effect parameter uncertaintystat.errordoublenullablesrp_uncSolar radiation pressure parameter uncertaintystat.errordoublenullablea1_uncA1 non-gravitational parameter uncertaintystat.errordoublenullablea2_uncA2 non-gravitational parameter uncertaintystat.errordoublenullablea3_uncA3 non-gravitational parameter uncertaintystat.errordoublenullabledt_uncTime offset uncertaintydstat.error;time.intervaldoublenullablemean_anomaly_uncMean anomaly uncertaintydegstat.errordoublenullableperiod_uncOrbital period uncertaintydstat.error;time.perioddoublenullablemean_motion_uncMean motion uncertaintydeg/dstat.errordoublenullableepoch_mjdEpoch in MJDdtime.epochdoublenullablehAbsolute magnitude Hmagphys.magAbsdoublenullablegSlope parameter Gphot.magdoublenullablenot_normalized_rmsNon-normalized RMS of fitstat.fit.residualdoublenullablenormalized_rmsNormalized RMS of fitstat.fit.residualdoublenullableearth_moidEarth minimum orbit intersection distanceAUphys.distance;pos.earthdoublenullablefitting_datetimeDateTime of orbital fittime.processingcharnullablecreated_dateDate record was createdtime.creationcharnullableupdated_dateDate record was last updatedtime.processingcharnullablealerce_tap.detection Generic detection table containing basic information for all detections across multiple surveys, including position, observation time, and photometric band. For detailed survey-specific detection properties, see the corresponding survey-specific detection tables.oidObject identifiermeta.id;srclongindexedprimarysidSurvey identifiermeta.idshortindexedprimarymeasurement_idMeasurement identifiermeta.idlongindexedprimarymjdModified Julian Datedtime.epochdoubleraRight ascensiondegpos.eq.ra;meta.maindoubleindexeddecDeclinationdegpos.eq.dec;meta.maindoubleindexedbandPhotometric bandinstr.bandpassshortnullablecreated_dateDate record was createdtime.creationcharnullablealerce_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.creationcharnullablealerce_tap.lsst_detection Individual LSST Difference Image Analysis sources, containing detailed measurements from difference imaging including PSF photometry, aperture photometry, trail and dipole fitting for moving objects, shape moments, forced photometry on science and template images, and extensive quality flags for pixels and measurements.oidObject identifiermeta.id;srclongindexedprimarysidSurvey identifiermeta.idshortmeasurement_idUnique identifier of this DiaSourcemeta.idlongindexedprimaryparentdiasourceidId of the parent diaSource this diaSource has been deblended from, if anymeta.idlongnullablevisitVisit numberobs.fieldlongdetectorDetector numberinstr.detintdiaobjectidId of the diaObject this source was associated with, if any. If not, it is set to NULL (each diaSource will be associated with either a diaObject or ssObject)meta.idlongnullablessobjectidId of the ssObject this source was associated with, if any. If not, it is set to NULL (each diaSource will be associated with either a diaObject or ssObject)meta.idlongnullableraerrUncertainty of radegstat.error;pos.eq.rafloatnullabledecerrUncertainty of decdegstat.error;pos.eq.decfloatnullablera_dec_covCovariance between ra and decdeg**2stat.covariance;pos.eqfloatnullablexx position computed by a centroiding algorithmpixpos.cartesian.xfloatxerrUncertainty of xpixstat.error;pos.cartesian.xfloatnullableyy position computed by a centroiding algorithmpixpos.cartesian.yfloatyerrUncertainty of ypixstat.error;pos.cartesian.yfloatnullablecentroid_flagGeneral centroid algorithm failure flag; set if anything went wrong when fitting the centroid. Another centroid flag field should also be set to provide more informationmeta.code.qualbooleannullableapfluxFlux in a 12 pixel radius aperture on the difference imagephot.fluxfloatnullableapfluxerrEstimated uncertainty of apFluxstat.error;phot.fluxfloatnullableapflux_flagGeneral aperture flux algorithm failure flag; set if anything went wrong when measuring aperture fluxes. Another apFlux flag field should also be set to provide more informationmeta.code.qualbooleannullableapflux_flag_aperturetruncatedAperture did not fit within measurement imagemeta.code.qualbooleannullableisnegativeSource was detected as significantly negativemeta.codebooleannullablesnrThe signal-to-noise ratio at which this source was detected in the difference imagestat.snrfloatnullablepsffluxFlux for Point Source model. Note this actually measures the flux difference between the template and the visit imagephot.fluxfloatnullablepsffluxerrUncertainty of psfFluxstat.error;phot.fluxfloatnullablepsflnlNatural log likelihood of the observed data given the point source modelstat.likelihoodfloatnullablepsfchi2Chi^2 statistic of the point source model fitstat.fit.chi2floatnullablepsfndataThe number of data points (pixels) used to fit the point source modelmeta.numberintnullablepsfflux_flagFailure to derive linear least-squares fit of psf model. Another psfFlux flag field should also be set to provide more informationmeta.code.qualbooleannullablepsfflux_flag_edgeObject was too close to the edge of the image to use the full PSF modelmeta.code.qualbooleannullablepsfflux_flag_nogoodpixelsNot enough non-rejected pixels in data to attempt the fitmeta.code.qualbooleannullabletrailfluxFlux for a trailed source model. Note this actually measures the flux difference between the template and the visit imagephot.fluxfloatnullabletrailfluxerrUncertainty of trailFluxstat.error;phot.fluxfloatnullabletrailraRight ascension coordinate of centroid for trailed source modeldegpos.eq.radoublenullabletrailraerrUncertainty of trailRadegstat.error;pos.eq.rafloatnullabletraildecDeclination coordinate of centroid for trailed source modeldegpos.eq.decdoublenullabletraildecerrUncertainty of trailDecdegstat.error;pos.eq.decfloatnullabletraillengthMaximum likelihood fit of trail lengtharcsecphys.angSizefloatnullabletraillengtherrUncertainty of trailLengtharcsecstat.errorfloatnullabletrailangleMaximum likelihood fit of the angle between the meridian through the centroid and the trail direction (bearing)degpos.posAngfloatnullabletrailangleerrUncertainty of trailAngledegstat.errorfloatnullabletrailchi2Chi^2 statistic of the trailed source model fitstat.fit.chi2floatnullabletrailndataThe number of data points (pixels) used to fit the trailed source modelmeta.numberintnullabletrail_flag_edgeThis flag is set if a trailed source extends onto or past edge pixelsmeta.code.qualbooleannullabledipolemeanfluxMaximum likelihood value for the mean absolute flux of the two lobes for a dipole modelphot.fluxfloatnullabledipolemeanfluxerrUncertainty of dipoleMeanFluxstat.error;phot.fluxfloatnullabledipolefluxdiffMaximum likelihood value for the difference of absolute fluxes of the two lobes for a dipole modelphot.fluxfloatnullabledipolefluxdifferrUncertainty of dipoleFluxDiffstat.error;phot.fluxfloatnullabledipolelengthMaximum likelihood value for the lobe separation in dipole modelarcsecphys.angSizefloatnullabledipoleangleMaximum likelihood fit of the angle between the meridian through the centroid and the dipole direction (bearing, from negative to positive lobe)degpos.posAngfloatnullabledipolechi2Chi^2 statistic of the model fitstat.fit.chi2floatnullabledipolendataThe number of data points (pixels) used to fit the modelmeta.numberintnullablesciencefluxForced photometry flux for a point source model measured on the visit image centered at DiaSource positionphot.fluxfloatnullablesciencefluxerrEstimated uncertainty of scienceFluxstat.error;phot.fluxfloatnullableforced_psfflux_flagForced PSF photometry on science image failed. Another forced_PsfFlux flag field should also be set to provide more informationmeta.code.qualbooleannullableforced_psfflux_flag_edgeForced PSF flux on science image was too close to the edge of the image to use the full PSF modelmeta.code.qualbooleannullableforced_psfflux_flag_nogoodpixelsForced PSF flux not enough non-rejected pixels in data to attempt the fitmeta.code.qualbooleannullabletemplatefluxForced photometry flux for a point source model measured on the template image centered at the DiaObject positionphot.fluxfloatnullabletemplatefluxerrUncertainty of templateFluxstat.error;phot.fluxfloatnullableixxAdaptive second moment of the source intensitynJy.arcsec**2phys.sizefloatnullableiyyAdaptive second moment of the source intensitynJy.arcsec**2phys.sizefloatnullableixyAdaptive second moment of the source intensitynJy.arcsec**2phys.sizefloatnullableixxpsfAdaptive second moment for the PSFnJy.arcsec**2phys.sizefloatnullableiyypsfAdaptive second moment for the PSFnJy.arcsec**2phys.sizefloatnullableixypsfAdaptive second moment for the PSFnJy.arcsec**2phys.sizefloatnullableshape_flagGeneral source shape algorithm failure flag; set if anything went wrong when measuring the shape. Another shape flag field should also be set to provide more informationmeta.code.qualbooleannullableshape_flag_no_pixelsNo pixels to measure shapemeta.code.qualbooleannullableshape_flag_not_containedCenter not contained in footprint bounding boxmeta.code.qualbooleannullableshape_flag_parent_sourceThis source is a parent source; we should only be measuring on deblended children in difference imagingmeta.code.qualbooleannullableextendednessA measure of extendedness, computed by comparing an object's moment-based traced radius to the PSF moments. extendedness = 1 implies a high degree of confidence that the source is extended. extendedness = 0 implies a high degree of confidence that the source is point-likesrc.class.starGalaxyfloatnullablereliabilityProbability (0-1) that the diaSource is astrophysical, derived from a machine learning modelstat.probabilityfloatnullableisdipoleSource well fit by a dipolemeta.codebooleannullabledipolefitattemptedAttempted to fit a dipole model to this sourcemeta.codebooleannullabletimeprocessedmjdtaiTime when the image was processed and this DiaSource record was generated, expressed as Modified Julian Date, International Atomic Timedtime.processingdoubletimewithdrawnmjdtaiTime when this record was marked invalid, expressed as Modified Julian Date, International Atomic Timedtime.processingdoublenullablebboxsizeSize of the square bounding box that fully contains the detection footprintpixphys.angSizeintnullablepixelflagsGeneral pixel flags failure; set if anything went wrong when setting pixels flags from this footprint's mask. This implies that some pixelFlags for this source may be incorrectly set to Falsemeta.code.qualbooleannullablepixelflags_badBad pixel in the DiaSource footprintmeta.code.qualbooleannullablepixelflags_crCosmic ray in the DiaSource footprintmeta.code.qualbooleannullablepixelflags_crcenterCosmic ray in the 3x3 region around the centroidmeta.code.qualbooleannullablepixelflags_edgeSome of the source footprint is outside usable exposure region (masked EDGE or centroid off image)meta.code.qualbooleannullablepixelflags_nodataNO_DATA pixel in the source footprintmeta.code.qualbooleannullablepixelflags_nodatacenterNO_DATA pixel in the 3x3 region around the centroidmeta.code.qualbooleannullablepixelflags_interpolatedInterpolated pixel in the DiaSource footprintmeta.code.qualbooleannullablepixelflags_interpolatedcenterInterpolated pixel in the 3x3 region around the centroidmeta.code.qualbooleannullablepixelflags_offimageDiaSource center is off imagemeta.code.qualbooleannullablepixelflags_saturatedSaturated pixel in the DiaSource footprintmeta.code.qualbooleannullablepixelflags_saturatedcenterSaturated pixel in the 3x3 region around the centroidmeta.code.qualbooleannullablepixelflags_suspectDiaSource's footprint includes suspect pixelsmeta.code.qualbooleannullablepixelflags_suspectcenterSuspect pixel in the 3x3 region around the centroidmeta.code.qualbooleannullablepixelflags_streakStreak in the DiaSource footprintmeta.code.qualbooleannullablepixelflags_streakcenterStreak in the 3x3 region around the centroidmeta.code.qualbooleannullablepixelflags_injectedInjection in the DiaSource footprintmeta.code.qualbooleannullablepixelflags_injectedcenterInjection in the 3x3 region around the centroidmeta.code.qualbooleannullablepixelflags_injected_templateTemplate injection in the DiaSource footprintmeta.code.qualbooleannullablepixelflags_injected_templatecenterTemplate injection in the 3x3 region around the centroidmeta.code.qualbooleannullableglint_trailThis flag is set if the source is part of a glint trailmeta.codebooleannullablehas_stampHas image stamp flagmeta.codebooleannullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.lsst_ss_detection Individual LSST detections associated with solar system objects, including observing geometry (phase angle, elongation, ranges), ephemeris predictions, ephemeris offsets (O-C residuals), and heliocentric/topocentric state vectors in ICRS coordinates.measurement_idUnique identifier of this DIA source observationmeta.idlongindexedprimaryssobjectidLSST solar system object identifiermeta.id;srclongindexedprimarydesignationUnpacked primary provisional designation for this solar system objectmeta.id;srccharnullableecllambdaEcliptic longitudedegpos.ecliptic.londoubleeclbetaEcliptic latitudedegpos.ecliptic.latdoublegallonGalactic longitudedegpos.galactic.londoublegallatGalactic latitudedegpos.galactic.latdoubleelongationSolar elongation, the angular separation of the object from the Sun on the celestial spheredegpos.angDistancefloatnullablephaseanglePhase angle, the angle between the Sun and observer as seen from the objectdegpos.phaseAngfloatnullabletoporangeTopocentric range, the distance from the observer to the objectAUphys.distancefloatnullabletoporangerateTopocentric range rate, the radial velocity of the object relative to the observerAU/dphys.velocfloatnullableheliorangeHeliocentric range, the distance from the Sun to the objectAUphys.distancefloatnullableheliorangerateHeliocentric range rate, the radial velocity of the object relative to the SunAU/dphys.velocfloatnullableephraPredicted ICRS right ascension computed from orbit propagation at observation timedegpos.eq.ra;meta.modelled;pos.ephemdoublenullableephdecPredicted ICRS declination computed from orbit propagation at observation timedegpos.eq.dec;meta.modelled;pos.ephemdoublenullableephvmagPredicted V-band magnitude computed from orbit propagation at observation timemagphot.mag;em.opt.V;meta.modelled;pos.ephemfloatnullableephratePredicted total angular rate of motion on the skyarcsec/hpos.pm;pos.ephemfloatnullableephrateraPredicted angular rate of motion along right ascensionarcsec/hpos.pm;pos.eq.ra;pos.ephemfloatnullableephratedecPredicted angular rate of motion along declinationarcsec/hpos.pm;pos.eq.dec;pos.ephemfloatnullableephoffsetTotal angular offset between observed and predicted position on the celestial spherearcsecpos.angDistance;stat.fit.omcfloatnullableephoffsetraAngular offset in right ascension between observed and predicted position (observed minus predicted)degpos.eq.ra;stat.fit.omcdoublenullableephoffsetdecAngular offset in declination between observed and predicted position (observed minus predicted)degpos.eq.dec;stat.fit.omcdoublenullableephoffsetalongtrackAngular offset along the direction of motion between observed and predicted positionarcsecpos.angDistance;stat.fit.omcfloatnullableephoffsetcrosstrackAngular offset perpendicular to the direction of motion between observed and predicted positionarcsecpos.angDistance;stat.fit.omcfloatnullablehelio_xHeliocentric X position component in ICRS reference frameAUpos.cartesian.x;pos.heliocentricfloatnullablehelio_yHeliocentric Y position component in ICRS reference frameAUpos.cartesian.y;pos.heliocentricfloatnullablehelio_zHeliocentric Z position component in ICRS reference frameAUpos.cartesian.z;pos.heliocentricfloatnullablehelio_vxHeliocentric velocity component along X axis in ICRS reference frameAU/dphys.veloc;pos.cartesian.x;pos.heliocentricfloatnullablehelio_vyHeliocentric velocity component along Y axis in ICRS reference frameAU/dphys.veloc;pos.cartesian.y;pos.heliocentricfloatnullablehelio_vzHeliocentric velocity component along Z axis in ICRS reference frameAU/dphys.veloc;pos.cartesian.z;pos.heliocentricfloatnullablehelio_vtotHeliocentric total velocity magnitudeAU/dphys.veloc;pos.heliocentricfloatnullabletopo_xTopocentric X position component in ICRS reference frame relative to the observerAUpos.cartesian.xfloatnullabletopo_yTopocentric Y position component in ICRS reference frame relative to the observerAUpos.cartesian.yfloatnullabletopo_zTopocentric Z position component in ICRS reference frame relative to the observerAUpos.cartesian.zfloatnullabletopo_vxTopocentric velocity component along X axis in ICRS reference frameAU/dphys.veloc;pos.cartesian.xfloatnullabletopo_vyTopocentric velocity component along Y axis in ICRS reference frameAU/dphys.veloc;pos.cartesian.yfloatnullabletopo_vzTopocentric velocity component along Z axis in ICRS reference frameAU/dphys.veloc;pos.cartesian.zfloatnullabletopo_vtotTopocentric total velocity magnitudeAU/dphys.velocfloatnullablediadistancerankRanking based on the distance between this DIA source and the predicted position of the solar system object, with 1 being the closest matchmeta.code.classintnullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.forced_photometry Generic forced photometry measurements across multiple surveys, containing basic position and timing information. For detailed survey-specific forced photometry measurements, see the corresponding survey-specific tables.oidObject identifiermeta.id;srclongindexedprimarysidSurvey identifiermeta.idshortindexedprimarymeasurement_idMeasurement identifiermeta.idlongindexedprimarymjdModified Julian Datedtime.epochdoubleraRight ascensiondegpos.eq.ra;meta.maindoubleindexeddecDeclinationdegpos.eq.dec;meta.maindoubleindexedbandPhotometric bandinstr.bandpassshortnullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.ztf_forced_photometry ZTF forced photometry measurements at known object positions, including magnitudes with and without host galaxy corrections, image quality metrics (seeing, background, zero point), reference source properties, and processing status flags.oidObject identifiermeta.id;srclongindexedprimarysidSurvey identifiermeta.idshortmeasurement_idMeasurement identifiermeta.idlongindexedprimarypidProcessing IDmeta.idlongnullablemagMagnitudemagphot.magfloate_magMagnitude errormagstat.error;phot.magfloatmag_corrCorrected magnitudemagphot.mag;arith.correctedfloatnullablee_mag_corrCorrected magnitude errormagstat.error;phot.mag;arith.correctedfloatnullablee_mag_corr_extExtended corrected magnitude errormagstat.error;phot.magfloatnullableisdiffposDifference image positive flagmeta.codeintcorrectedCorrection applied flagmeta.code.qualbooleandubiousDubious measurement flagmeta.code.qualbooleanparent_candidParent candidate IDmeta.idlongnullablefieldField numberobs.fieldintrcidReadout channel IDinstr.detintrfidReference image IDmeta.idlongsciinpseeingScience image seeingarcsecinstr.obsty.seeingfloatscibckgndScience image backgroundinstr.skyLevelfloatscisigpixScience image sigma per pixelstat.stdev;instr.pixelfloatmagzpsciMagnitude zero pointmagphot.calibfloatmagzpsciuncMagnitude zero point uncertaintymagstat.error;phot.calibfloatmagzpscirmsMagnitude zero point RMSmagstat.stdev;phot.calibfloatclrcoeffColor coefficientarith.factorfloatclrcouncColor coefficient uncertaintystat.error;arith.factorfloatexptimeExposure timestime.duration;obs.exposurefloatadpctdif1Adaptive percentile difference 1stat.valuefloatadpctdif2Adaptive percentile difference 2stat.valuefloatdiffmaglimDifference image magnitude limitmagphot.mag;stat.minfloatprogramidProgram IDobs.programintprocstatusProcessing statusmeta.code.statuschardistnrDistance to nearest sourcearcsecpos.angDistancefloatranrRA of nearest sourcedegpos.eq.radoubledecnrDec of nearest sourcedegpos.eq.decdoublemagnrMagnitude of nearest sourcemagphot.magfloatsigmagnrMagnitude error of nearest sourcemagstat.error;phot.magfloatchinrChi of nearest sourcestat.fit.chi2floatsharpnrSharpness of nearest sourcestat.valuefloatcreated_dateDate record was createdtime.creationcharnullablealerce_tap.lsst_forced_photometry LSST forced photometry measurements extracted at DIA object positions on individual visit images, including PSF flux and forced science flux with uncertainties, and temporal processing metadata.oidObject identifiermeta.id;srclongindexedprimarysidSurvey identifiermeta.idshortmeasurement_idUnique idmeta.idlongindexedprimaryvisitId of the visit where this forcedSource was measuredobs.fieldlongdetectorId of the detector where this forcedSource was measuredinstr.detintpsffluxPoint Source model fluxphot.fluxfloatnullablepsffluxerrUncertainty of psfFluxstat.error;phot.fluxfloatnullablesciencefluxForced photometry flux for a point source model measured on the visit image centered at the DiaObject positionphot.fluxfloatnullablesciencefluxerrUncertainty of scienceFluxstat.error;phot.fluxfloatnullabletimeprocessedmjdtaiTime when this record was generated, expressed as Modified Julian Date, International Atomic Timedtime.processingdoubletimewithdrawnmjdtaiTime when this record was marked invalid, expressed as Modified Julian Date, International Atomic Timedtime.processingdoublenullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.ztf_non_detection ZTF non-detection upper limits providing 5-sigma magnitude limits from difference images when an object was not detected, useful for constraining object brightness and variability.oidUnique identifier for this objectmeta.id;srclongindexedprimarysidSurvey identifiermeta.idshortbandFilter ID: 1=g, 2=r, 3=iinstr.bandpassshortmjdObservation Modified Julian Date at start of exposure when non-detection occurreddtime.epochdoubleindexedprimarydiffmaglim5-sigma magnitude limit in difference image based on PSF-fit photometry, providing upper limit for object brightnessmagphot.mag;stat.minfloatcreated_dateDate record was createdtime.creationcharnullablealerce_tap.ztf_ss Cross-match information linking ZTF detections to known solar system objects from the Minor Planet Center archive, including angular separation, magnitude, and object name.oidUnique identifier for this objectmeta.id;srclongindexedprimarymeasurement_idUnique identifier for the subtraction candidatemeta.idlongindexedprimaryssdistnrDistance to nearest known solar system object; set to -999.0 if nonearcsecpos.angDistancefloatnullablessmagnrMagnitude of nearest known solar system object (usually V-band from MPC archive); set to -999.0 if nonemagphot.magfloatnullablessnamenrName of nearest known solar system object (from MPC archive); 'null' if nonemeta.idcharnullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.ztf_ps1 Cross-match of ZTF detections to Pan-STARRS1 catalog sources within 30 arcsec, including up to three closest matches with multi-band PSF photometry (g, r, i, z), star/galaxy scores, and angular separations.oidUnique identifier for this objectmeta.id;srclongindexedprimarymeasurement_idUnique identifier for the subtraction candidatemeta.idlongindexedprimaryobjectidps1Object ID of closest source from PS1 catalog, if exists within 30 arcsecmeta.id.crosslongnullablesgmag1g-band PSF magnitude of closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Bfloatnullablesrmag1r-band PSF magnitude of closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Rfloatnullablesimag1i-band PSF magnitude of closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Ifloatnullableszmag1z-band PSF magnitude of closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Ifloatnullablesgscore1Star/Galaxy score of closest source from PS1 catalog, 0 <= sgscore <= 1 where closer to 1 implies higher likelihood of being a starsrc.class.starGalaxyfloatnullabledistpsnr1Distance of closest source from PS1 catalog, if exists within 30 arcsecarcsecpos.angDistancefloatnullableobjectidps2Object ID of second closest source from PS1 catalog, if exists within 30 arcsecmeta.id.crosslongnullablesgmag2g-band PSF magnitude of second closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Bfloatnullablesrmag2r-band PSF magnitude of second closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Rfloatnullablesimag2i-band PSF magnitude of second closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Ifloatnullableszmag2z-band PSF magnitude of second closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Ifloatnullablesgscore2Star/Galaxy score of second closest source from PS1 catalog, if exists within 30 arcsec: 0 <= sgscore <= 1 where closer to 1 implies higher likelihood of being a starsrc.class.starGalaxyfloatnullabledistpsnr2Distance to second closest source from PS1 catalog, if exists within 30 arcsecarcsecpos.angDistancefloatnullableobjectidps3Object ID of third closest source from PS1 catalog, if exists within 30 arcsecmeta.id.crosslongnullablesgmag3g-band PSF magnitude of third closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Bfloatnullablesrmag3r-band PSF magnitude of third closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Rfloatnullablesimag3i-band PSF magnitude of third closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Ifloatnullableszmag3z-band PSF magnitude of third closest source from PS1 catalog, if exists within 30 arcsecmagphot.mag;em.opt.Ifloatnullablesgscore3Star/Galaxy score of third closest source from PS1 catalog, if exists within 30 arcsec: 0 <= sgscore <= 1 where closer to 1 implies higher likelihood of being a starsrc.class.starGalaxyfloatnullabledistpsnr3Distance to third closest source from PS1 catalog, if exists within 30 arcsecarcsecpos.angDistancefloatnullablenmtchpsNumber of source matches from PS1 catalog falling within 30 arcsecmeta.numberintnullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.ztf_gaia Cross-match of ZTF objects to Gaia DR1 catalog sources within 90 arcsec, providing distances and G-band magnitudes for the nearest source and nearest bright source (G < 14 mag).oidUnique identifier for this objectmeta.id;srclongindexedprimarymeasurement_idUnique identifier for the subtraction candidatemeta.idlongneargaiaDistance to closest source from Gaia DR1 catalog irrespective of magnitude, if exists within 90 arcsecarcsecpos.angDistancefloatnullableneargaiabrightDistance to closest source from Gaia DR1 catalog brighter than magnitude 14, if exists within 90 arcsecarcsecpos.angDistancefloatnullablemaggaiaGaia (G-band) magnitude of closest source from Gaia DR1 catalog irrespective of magnitude, if exists within 90 arcsecmagphot.mag;em.optfloatnullablemaggaiabrightGaia (G-band) magnitude of closest source from Gaia DR1 catalog brighter than magnitude 14, if exists within 90 arcsecmagphot.mag;em.optfloatnullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.ztf_dataquality Detailed data quality metrics for ZTF detections including image position, PSF-fit quality (chi-square, FWHM), SExtractor properties, pixel statistics, photometric calibration parameters, and signal-to-noise measurements.oidUnique identifier for this objectmeta.id;srclongindexedprimarymeasurement_idUnique identifier for the subtraction candidatemeta.idlongindexedprimaryxposX-image position of candidate on CCDpixpos.cartesian.xfloatnullableyposY-image position of candidate on CCDpixpos.cartesian.yfloatnullablechipsfReduced chi-square for PSF-fitstat.fit.goodnessfloatnullableskyLocal sky background estimate [DN]instr.skyLevelfloatnullablefwhmFull Width Half Maximum assuming a Gaussian core, from SExtractorpixinstr.obsty.seeingfloatnullableclasstarStar/Galaxy classification score from SExtractorsrc.class.starGalaxyfloatnullablemindtoedgeDistance to nearest edge in imagepixphys.angSizefloatnullableseeratioRatio: difffwhm / fwhmstat.fit.goodnessfloatnullableaimageWindowed profile RMS along major axis from SExtractorpixphys.angSize.smajAxisfloatnullablebimageWindowed profile RMS along minor axis from SExtractorpixphys.angSize.sminAxisfloatnullableaimageratRatio: aimage / fwhmarith.ratiofloatnullablebimageratRatio: bimage / fwhmarith.ratiofloatnullablennegNumber of negative pixels in a 5 x 5 pixel stampmeta.numberintnullablenbadNumber of prior-tagged bad pixels in a 5 x 5 pixel stampmeta.numberintnullablesumratRatio: sum(pixels) / sum(abs(pixels)) in a 5 x 5 pixel stamp where stamp is first median-filtered to mitigate outliersarith.ratiofloatnullablescorrPeak-pixel signal-to-noise ratio in point source matched-filtered detection imagestat.correlationdoublenullabledsnrmsRatio: D/stddev(D) on event position where D = difference imagestat.stdevfloatnullablessnrmsRatio: S/stddev(S) on event position where S = image of convolution: D (x) PSF(D)stat.stdevfloatnullablemagzpsciMagnitude zero point for photometry estimatesmagphot.calibfloatnullablemagzpsciuncMagnitude zero point uncertainty (in magzpsci)magstat.error;phot.calibfloatnullablemagzpscirmsRMS (deviation from average) in all differences between instrumental photometry and matched photometric calibrators from science image processingmagstat.stdev;phot.calibfloatnullablenmatchesNumber of PS1 photometric calibrators used to calibrate science image from science image processingmeta.numberintnullableclrcoeffColor coefficient from linear fit from photometric calibration of science imagearith.factorfloatnullableclrcouncColor coefficient uncertainty from linear fit (corresponding to clrcoeff)stat.error;arith.factorfloatnullablezpclrcovCovariance in magzpsci and clrcoeff from science image processing [mag^2]stat.covariancefloatnullablezpmedMagnitude zero point from median of all differences between instrumental photometry and matched photometric calibrators from science image processingmagphot.calib;stat.medianfloatnullableclrmedMedian color of all PS1 photometric calibrators used from science image processing: for filter (fid) = 1, 2, 3, PS1 color used = g-r, g-r, r-i respectivelystat.medianfloatnullableclrrmsRMS color (deviation from average) of all PS1 photometric calibrators used from science image processingstat.stdevfloatnullableexptimeIntegration time of camera exposurestime.duration;obs.exposurefloatnullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.ztf_reference Information about ZTF reference (template) images used for difference imaging, including properties of the nearest catalog source, temporal coverage of the reference image stack, and field/CCD identifiers.oidUnique identifier for this objectmeta.id;srclongindexedprimaryrfidProcessing ID for reference image to facilitate archive retrievalmeta.idlongindexedprimarymeasurement_idUnique identifier for the first detection associated with this reference imagemeta.idlongbandFilter ID: 1=g, 2=r, 3=iinstr.bandpassintnullablercidReadout channel ID [00 .. 63]instr.detintnullablefieldZTF field IDobs.fieldintnullablemagnrMagnitude of nearest source in reference image PSF-catalog within 30 arcsecmagphot.magfloatnullablesigmagnr1-sigma uncertainty in magnr within 30 arcsecmagstat.error;phot.magfloatnullablechinrDAOPhot chi parameter of nearest source in reference image PSF-catalog within 30 arcsecstat.fit.chi2floatnullablesharpnrDAOPhot sharp parameter of nearest source in reference image PSF-catalog within 30 arcsec (values between -0.13 and 0.1 indicate unresolved sources)stat.valuefloatnullableranrRight ascension of nearest source in reference image PSF-catalog, J2000degpos.eq.ra;meta.maindoubleindexednullabledecnrDeclination of nearest source in reference image PSF-catalog, J2000degpos.eq.dec;meta.maindoubleindexednullablemjdstartrefObservation Modified Julian Date of earliest exposure used to generate reference imagedtime.startdoublenullablemjdendrefObservation Modified Julian Date of latest exposure used to generate reference imagedtime.enddoublenullablenframesrefNumber of frames (epochal images) used to generate reference imagemeta.numberintnullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.magstat Per-band photometric statistics for each object including mean, median, minimum, maximum magnitudes, standard deviation, first/last magnitudes, rate of change, and corrected values accounting for host galaxy flux.oidObject identifiermeta.id;srclongindexedprimarysidSurvey identifiermeta.idshortindexedprimarybandPhotometric bandinstr.bandpassshortindexedprimarystellarStellar classification flagsrc.class.starGalaxybooleannullablecorrectedCorrection applied flagmeta.code.qualbooleannullablendubiousNumber of dubious measurementsmeta.numberintnullabledmdt_firstFirst magnitude rate of changemag/darith.rate;phot.magfloatnullabledm_firstFirst magnitude differencemagphot.mag;arith.difffloatnullablesigmadm_firstFirst magnitude difference errormagstat.error;phot.magfloatnullabledt_firstFirst time intervaldtime.intervalfloatnullablemagmeanMean magnitudemagphot.mag;stat.meanfloatnullablemagmedianMedian magnitudemagphot.mag;stat.medianfloatnullablemagmaxMaximum magnitudemagphot.mag;stat.maxfloatnullablemagminMinimum magnitudemagphot.mag;stat.minfloatnullablemagsigmaMagnitude standard deviationmagstat.stdev;phot.magfloatnullablemaglastLast magnitudemagphot.magfloatnullablemagfirstFirst magnitudemagphot.magfloatnullablemagmean_corrCorrected mean magnitudemagphot.mag;stat.mean;arith.correctedfloatnullablemagmedian_corrCorrected median magnitudemagphot.mag;stat.median;arith.correctedfloatnullablemagmax_corrCorrected maximum magnitudemagphot.mag;stat.max;arith.correctedfloatnullablemagmin_corrCorrected minimum magnitudemagphot.mag;stat.min;arith.correctedfloatnullablemagsigma_corrCorrected magnitude standard deviationmagstat.stdev;phot.mag;arith.correctedfloatnullablemaglast_corrCorrected last magnitudemagphot.mag;arith.correctedfloatnullablemagfirst_corrCorrected first magnitudemagphot.mag;arith.correctedfloatnullablestep_id_corrCorrection step identifiermeta.idcharnullablen_detNumber of detectionsmeta.numberintnullablefirstmjdFirst observation MJDdtime.startdoublenullablelastmjdLast observation MJDdtime.enddoublenullablesaturation_rateSaturation ratearith.ratefloatnullableupdated_dateDate record was last updatedtime.processingcharnullablealerce_tap.classifier Metadata for machine learning classifiers used to classify astronomical objects, including classifier name, version, and associated telescope/survey.classifier_idClassifier identifiermeta.idintindexedprimaryclassifier_nameClassifier namemeta.idcharclassifier_versionClassifier versionmeta.versionchartidTelescope identifiermeta.idshortcreated_dateDate record was createdtime.creationcharnullablealerce_tap.taxonomy Taxonomy of astronomical object classes used by classifiers, including class names, display ordering, and the associated classifier producing these classifications.class_idClass identifiermeta.idintindexedprimaryclass_nameClass namesrc.classchartaxonomy_orderDisplay ordermeta.code.classintclassifier_idClassifier identifiermeta.idshortcreated_dateDate record was createdtime.creationcharnullablealerce_tap.probability Classification probabilities for each object assigned by machine learning classifiers, including probability values, rankings among all classes, and the timestamp of the classification.oidObject identifiermeta.id;srclongindexedprimarysidSurvey identifiermeta.idshortindexedprimaryclassifier_idClassifier identifiermeta.idshortindexedprimaryclassifier_versionClassifier versionmeta.versionshortindexedprimaryclass_idClass identifiermeta.idshortindexedprimaryprobabilityClassification probabilitystat.probabilityfloatindexedrankingClassification rankingmeta.code.classshortindexednullablelastmjdLast observation MJDdtime.enddoublealerce_tap.feature Computed features from light curves for each object and photometric band, including time-series statistics and variability metrics used as inputs to machine learning classifiers.oidObject identifiermeta.id;srclongindexedprimarysidSurvey identifiermeta.idshortindexedprimaryfeature_idFeature identifiermeta.idshortindexedprimarybandPhotometric bandinstr.bandpassshortindexedprimaryversionFeature versionmeta.versionshortfeature_valueFeature valuestat.valuedoublenullableupdated_dateDate record was last updatedtime.processingcharnullablealerce_tap.feature_name_lut Lookup table mapping feature identifiers to descriptive feature names for light curve features used in object classification.feature_idFeature identifiermeta.idshortindexedprimaryfeature_nameFeature namemeta.idcharcreated_dateDate record was createdtime.creationcharnullablesidSurvey identifiermeta.idshortnullabletidTelescope identifiermeta.idshortnullablealerce_tap.feature_version_lut Lookup table mapping version identifiers to version names for light curve feature extraction algorithms.version_idVersion identifiermeta.idshortindexedprimaryversion_nameVersion namemeta.versioncharsidSurvey identifiermeta.idshortnullabletidTelescope identifiermeta.idshortnullablealerce_tap.sid_lut Lookup table mapping survey identifiers to survey names and associated telescope identifiers.sidSurvey identifiermeta.idshortindexedprimarytidTelescope identifiermeta.idshortnullablesurvey_nameSurvey nameobs.paramcharcreated_dateDate record was createdtime.creationcharnullablealerce_tap.band Lookup table defining photometric bands (filters) for each survey, including band names and display ordering.sidSurvey identifiermeta.idshortindexedprimarytidTelescope identifiermeta.idshortindexedprimarybandBand identifierinstr.bandpassshortindexedprimaryband_nameBand nameinstr.bandpasscharband_orderDisplay ordermeta.code.classintnullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.xmatch Cross-match results linking objects to external astronomical catalogs, including angular separation and the matched object's identifier in the external catalog.oidObject identifiermeta.id;srclongindexedprimarysidSurvey identifiermeta.idshortindexedprimarycatidCatalog identifiermeta.idshortindexedprimarydistCross-match distancearcsecpos.angDistancefloatoid_catalogObject identifier in external catalogmeta.id.crosscharcreated_dateDate record was createdtime.creationcharnullableupdated_dateDate record was last updatedtime.processingcharnullablealerce_tap.catalog_id_lut Lookup table mapping catalog identifiers to the names of external astronomical catalogs used for cross-matching.catidCatalog identifiermeta.idshortindexedprimarycatalog_nameCatalog namemeta.idcharnullablecreated_dateDate record was createdtime.creationcharnullablealerce_tap.allwise Photometric data from the AllWISE catalog for cross-matched objects, including WISE mid-infrared magnitudes (W1-W4 at 3.4, 4.6, 12, 22 microns) and 2MASS near-infrared magnitudes (J, H, K) with uncertainties.oid_catalogObject identifier in AllWISE catalogmeta.id.crosscharnullableraRight ascension from AllWISE catalogdegpos.eq.radoublenullabledecDeclination from AllWISE catalogdegpos.eq.decdoublenullablew1mproW1 magnitude (3.4 micron) from AllWISE catalogmagphot.mag;em.IR.3-4umdoublenullablew2mproW2 magnitude (4.6 micron) from AllWISE catalogmagphot.mag;em.IR.4-8umdoublenullablew3mproW3 magnitude (12 micron) from AllWISE catalogmagphot.mag;em.IR.8-15umdoublenullablew4mproW4 magnitude (22 micron) from AllWISE catalogmagphot.mag;em.IR.15-30umdoublenullablew1sigmproW1 magnitude uncertainty from AllWISE catalogmagstat.error;phot.mag;em.IR.3-4umdoublenullablew2sigmproW2 magnitude uncertainty from AllWISE catalogmagstat.error;phot.mag;em.IR.4-8umdoublenullablew3sigmproW3 magnitude uncertainty from AllWISE catalogmagstat.error;phot.mag;em.IR.8-15umdoublenullablew4sigmproW4 magnitude uncertainty from AllWISE catalogmagstat.error;phot.mag;em.IR.15-30umdoublenullablej_m_2massJ-band magnitude from 2MASS catalogmagphot.mag;em.IR.Jdoublenullablej_msig_2massJ-band magnitude uncertainty from 2MASS catalogmagstat.error;phot.mag;em.IR.Jdoublenullableh_m_2massH-band magnitude from 2MASS catalogmagphot.mag;em.IR.Hdoublenullableh_msig_2massH-band magnitude uncertainty from 2MASS catalogmagstat.error;phot.mag;em.IR.Hdoublenullablek_m_2massK-band magnitude from 2MASS catalogmagphot.mag;em.IR.Kdoublenullablek_msig_2massK-band magnitude uncertainty from 2MASS catalogmagstat.error;phot.mag;em.IR.Kdoublenullable