![[Operator logo]](/static/img/logo_medium.png){kind=logo}
Metadata
Identifier
Cite this
Description
Keywords
astronomical-software
![[Logo]](https://tap.alerce.online/favicon.png)
| Tablename | Tableinfo | Table desc. | Res desc. |
|---|---|---|---|
| alerce_tap.allwise | Table Info | 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. | 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.band | Table Info | Lookup table defining photometric bands (filters) for each survey, including band names and display ordering. | 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.catalog_id_lut | Table Info | Lookup table mapping catalog identifiers to the names of external astronomical catalogs used for cross-matching. | 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.classifier | Table Info | Metadata for machine learning classifiers used to classify astronomical objects, including classifier name, version, and associated telescope/survey. | 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.detection | Table Info | 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. | 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.feature | Table Info | 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. | 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.feature_name_lut | Table Info | Lookup table mapping feature identifiers to descriptive feature names for light curve features used in object classification. | 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.feature_version_lut | Table Info | Lookup table mapping version identifiers to version names for light curve feature extraction algorithms. | 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.forced_photometry | Table Info | 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. | 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.gaiadr3_source | Table Info | Astrometric, photometric, and astrophysical data from the Gaia DR3 catalog for cross-matched objects, including positions, proper motions, parallaxes, G/BP/RP-band photometry, radial velocities, and GSP-Phot stellar parameters. | 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.lsst_detection | Table Info | 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. | 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.lsst_dia_object | Table Info | 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. | 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.lsst_forced_photometry | Table Info | 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. | 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.lsst_mpc_orbits | Table Info | 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. | 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.lsst_ss_detection | Table Info | 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. | 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.lsst_ss_object | Table Info | 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. | 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.magstat | Table Info | 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. | 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 | Table Info | 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). | 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.probability | Table Info | Classification probabilities for each object assigned by machine learning classifiers, including probability values, rankings among all classes, and the timestamp of the classification. | 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.sid_lut | Table Info | Lookup table mapping survey identifiers to survey names and associated telescope identifiers. | 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.taxonomy | Table Info | Taxonomy of astronomical object classes used by classifiers, including class names, display ordering, and the associated classifier producing these classifications. | 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.xmatch | Table Info | Cross-match results linking objects to external astronomical catalogs, including angular separation and the matched object's identifier in the external catalog. | 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_dataquality | Table Info | 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. | 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 | Table Info | 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. | 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_forced_photometry | Table Info | 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. | 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. |
| Tablename | Tableinfo | Table desc. | Res desc. |
| alerce_tap.ztf_gaia | Table Info | 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). | 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_non_detection | Table Info | 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. | 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_object | Table Info | ZTF-specific properties for astronomical objects including color indices, stellar classification, photometric correction flags, and historical detection statistics from the Zwicky Transient Facility survey. | 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_ps1 | Table Info | 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. | 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_reference | Table Info | 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. | 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_ss | Table Info | Cross-match information linking ZTF detections to known solar system objects from the Minor Planet Center archive, including angular separation, magnitude, and object name. | 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. |
| tap_schema.columns | Table Info | Columns in tables available for ADQL querying. | Unnamed data center's Table Access Protocol (TAP) service with table metadata. |
| tap_schema.groups | Table Info | Columns that are part of groups within tables available for ADQL querying. | Unnamed data center's Table Access Protocol (TAP) service with table metadata. |
| tap_schema.key_columns | Table Info | Columns participating in foreign key relationships between tables available for ADQL querying. | Unnamed data center's Table Access Protocol (TAP) service with table metadata. |
| tap_schema.keys | Table Info | Foreign key relationships between tables available for ADQL querying. | Unnamed data center's Table Access Protocol (TAP) service with table metadata. |
| tap_schema.schemas | Table Info | Schemas containing tables available for ADQL querying. | Unnamed data center's Table Access Protocol (TAP) service with table metadata. |
| tap_schema.tables | Table Info | Tables available for ADQL querying. | Unnamed data center's Table Access Protocol (TAP) service with table metadata. |
| ztf.allwise | Table Info | AllWISE catalog entries for ZTF cross-matched sources, including WISE mid-infrared photometry (W1-W4 bands) and 2MASS near-infrared photometry (J, H, K). | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.dataquality | Table Info | Image and PSF quality metrics for ZTF detections, including pixel statistics, PSF fit parameters, photometric calibration coefficients, and astrometric performance. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.detection | Table Info | Individual detections for each ZTF object including photometric measurements, RealBogus quality scores, corrected magnitudes, and image quality flags. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.feature | Table Info | Computed light-curve and variability features for ZTF objects used as input to ALeRCE classifiers. Features are stored per object, per filter, and per pipeline version. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.feature_version | Table Info | Version metadata for feature computation runs, linking feature values in the feature table to the pipeline steps used for extraction and preprocessing. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.forced_photometry | Table Info | Forced photometry measurements obtained at object positions for all ZTF epochs, including flux measurements, photometric calibration parameters, and image quality metrics. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.gaia_ztf | Table Info | Gaia catalog cross-match properties for ZTF objects including distances and magnitudes of the nearest Gaia source and the nearest bright Gaia source. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.magstat | Table Info | Per-filter magnitude statistics for each ZTF object including mean, median, min, max magnitudes both raw and corrected, along with temporal extent and variability metrics. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.non_detection | Table Info | Upper limit measurements at object positions where no source was detected in ZTF images. Useful for constraining rise times and pre-discovery activity of transients. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.object | Table Info | Main catalog of astronomical objects observed by ZTF. Each record corresponds to a unique transient or variable source with aggregated position, detection counts, photometric color statistics, and temporal coverage. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.probability | Table Info | Classification probabilities assigned to ZTF objects by various ALeRCE classifiers. Each row gives the probability of an object belonging to a given class according to a specific classifier and version. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.ps1_ztf | Table Info | Pan-STARRS1 catalog cross-match properties for ZTF detections including griz photometry and star-galaxy scores for the three nearest PS1 sources. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.reference | Table Info | Metadata for the ZTF reference images used in difference imaging, including the photometric properties of the nearest source in the reference image and the temporal extent of the reference image stack. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| Tablename | Tableinfo | Table desc. | Res desc. |
| ztf.score | Table Info | Detector-based scores assigned to ZTF objects by pipeline modules such as real-bogus detectors or other quality-scoring components. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.score_distribution | Table Info | Statistical reference distributions for detector scores, used to contextualize individual object scores against the overall population. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.ss_ztf | Table Info | Cross-matches between ZTF objects and known solar system objects from the Minor Planet Center catalog. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.taxonomy | Table Info | Taxonomy of ALeRCE classifiers and the set of class names they produce, used as a lookup to interpret probability and score tables. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |
| ztf.xmatch | Table Info | Cross-matches between ZTF objects and external astronomical catalogs, including angular separation, catalog identifiers, and classification information. | Legacy ZTF astronomical catalog containing objects, detections, photometric measurements, classifications, and cross-matches from the Zwicky Transient Facility (ZTF) survey, as processed by the ALeRCE broker pipeline. |