Archives of Photographic PLates for Astronomical USE

APPLAUSE DR3 (applause_dr3)


The APPLAUSE Data Release 3 contains metadata about photographic plates and data extracted from digitized plates.

The source catalogue contains 3.508 billion extracted sources. The majority of sources have their positions (right ascension and declination) calibrated with the help of the Tycho-2 and a crossmatch of (updated) UCAC4 and APASS catalogues. The database contains 2.065 billion sources with matched UCAC4 designations, 1.179 billion apass matches and 367 million sources with Tycho-2 designations.

The APPLAUSE DR3 database is organised in 18 tables.

Along with the data we publish the version of the pyplate software which was used to process the scanned material.


If you have made substantial use of the data provided by APPLAUSE DR3, kindly include this acknowledgement

Funding for APPLAUSE has been provided by DFG (German Research Foundation, Grant), Leibniz Institute for Astrophysics Potsdam (AIP), Dr. Remeis Sternwarte Bamberg (University Nuernberg/Erlangen), the Hamburger Sternwarte (University of Hamburg) and Tartu Observatory. Plate material also has been made available from Thüringer Landessternwarte Tautenburg.


  • Archives of photographic plates (applause_dr3.archive)

    An archive in APPLAUSE is a collection of plates, logbooks, and extracted data that originate from a specific instrument. The archive table contains one row for each plate archive. Unique identifier: archive_id.

  • Photographic plates as physical objects (applause_dr3.plate)

    The table contains data on photographic plates or films as physical objects. An entry in this table does not guarantee that a scan of the plate is available. Unique identifier: plate_id.

  • Exposure data (applause_dr3.exposure)

    The table contains data on individual exposures for each plate, including start and end times, mid-exposure times, coordinates of telescope pointings. One row in the table corresponds to one exposure on the plate/film. Thus, multiple-exposure plates have multiple entries. Exposures are related with plates by the plate_id. Unique identifier: exposure_id.

  • Sub-exposures (applause_dr3.exposure_sub)

    The table contains data on interrupted exposures, e.g. due to passing clouds, or due to continuation of a long exposure during another night. Each row in the sub-exposure table corresponds to a continuous fragment of a full exposure. Unique identifier: subexposure_id.

  • Previews of photographic plates (applause_dr3.preview)

    Catalogue of preview images of photographic plates. Previews were often captured before cleaning plates from handwritten annotations, so preview images may contain additional information that are not present in scans. For some archives, previews were created from high-resolution scans. Previews are related with plates by plate_id. Unique identifier: preview_id.

  • Scans of photographic plates (applause_dr3.scan)

    Catalogue of high-resolution images of photographic plates. A row in the table corresponds to a scan of a plate. If a plate was scanned multiple times, usually to overcome scanner limitations, then there are multiple entries in the scan table belonging to the same plate, identified by plate_id. Unique identifier: scan_id.

  • Extracted sources (applause_dr3.source)

    Table of extracted sources. A row in the source table corresponds to an extracted source from a plate scan. The table contains raw data, obtained with the SExtractor software in the processing pipeline. Calibrated data can be found in the source_calib table, which shares the same source identifiers. Unique identifier: source_id.

  • Extracted sources with calibrated positions and magnitudes (applause_dr3.source_calib)

    Extracted sources with calibrated sky coordinates, magnitudes, and cross-matches with external catalogues. Astrometric calibration has been carried out using the Tycho-2 and UCAC4 catalogues. For photometric calibration, magnitudes from the APASS DR9 catalogue were used. Unique identifier: source_id. The identifier is the same as in the source table.

  • Calibrated sources with no UCAC4 id (applause_dr3.source_calib_nu)

    Convenience table with object where no matching UCAC4 id could be assigned

  • Light curves (applause_dr3.lightcurve)

    This table contains a subset of extracted sources with calibrated sky coordinates, magnitudes and designations, accompanied with essential exposure data. Sources only from single-exposure plates were included in the lightcurve table. For plates with multiple scans, sources from the scan with smaller scan_id were taken. For a complete data set, it is advised to use the source_calib and exposure tables. Unique identifier: source_id.

  • Logbooks (applause_dr3.logbook)

    Information about logbooks that contain data on photographic plates or notes about observations. Digitized logbook pages are catalogued in the logpage table. There is no direct relation between a plate and a logbook. Instead, plates are related with logpages and logpages are related with logbooks. Unique identifier: logbook_id.

  • Logbook pages and plate envelopes (applause_dr3.logpage)

    The logpage table contains data on individual digitized logbook pages and also images of plate covers/envelopes. Logbook pages are related with logbooks by the logbook_id. The relation between logpages and plates is given in the plate_logpage table. Unique identifier: logpage_id.

  • Relation between plates and logpages (applause_dr3.plate_logpage)

    The plate_logpage table contains links between plates and logbook pages / plate envelopes. Each row in the table corresponds to one plate-logpage pair. A single plate may have multiple related logpages and a single logpage may be related to multiple plates.

  • Plate image processes (applause_dr3.process)

    The process table contains data on pyplate"s processing of source extraction and astrometric calibration of plate scans. Unique Identifier process_id

  • Astrometric solutions of plate scans (applause_dr3.solution)

    The table contains astrometric solutions of plate scans. Unique identifier: solution_id.

  • Photometric calibration on whole scans (applause_dr3.phot_calib)

    This table contains data on photometric calibration that was carried out on whole scans and in annular bins. Unique Identifier calib_id

  • Photometric calibration: color term results (applause_dr3.phot_color)

    This table contains data on the determined color terms. Each row in the table corresponds to a scan of a photographic plate. Unique Identifier color_id

  • Photometric calibration: color term estimation (applause_dr3.phot_cterm)

    Fitting parameters for photometric calibration. This table contains standard deviations of residuals for each fit. Unique Identifier cterm_id

  • Photometric calibration in sub-fields (applause_dr3.phot_subfield)

    This table contains photometric error estimates for individual magnitude ranges in annular bins. Unique Identifier sub_id

  • Astrometric calibration in sub-fields (applause_dr3.astrom_subfield)

    This table contains astrometric error estimates for individual magnitude ranges in annular bins. Unique Identifier sub_id