![[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.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. |
| 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. |
| Tablename | Tableinfo | Table desc. | Res desc. |
| 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. |