ivo://www.plate-archive.org/tapLeibniz Institute for Astrophysics Potsdam (AIP)APPLAUSEhttps://www.plate-archive.org/static/core/img/favicon.png2026-01-23T00:00:00ZHarry Enke

An der Sternwarte 16, 14482 Potsdam, Germany

henke@aip.de+49 (0) 331 7499 433tapThe TAP Service registry for www.plate-archive.org.https://www.plate-archive.org/tapCataloghttps://www.plate-archive.org/tapadql2.0postgresql16.2application/xmlvotabletext/csvcsvapplication/fitsfitsapplication/parquetparquet5000000500000010000000https://www.plate-archive.org/tap/asynchttps://www.plate-archive.org/tap/synchttps://www.plate-archive.org/tap/capabilitieshttps://www.plate-archive.org/tap/tableshttps://www.plate-archive.org/tap/examplesapplause_dr4The APPLAUSE Data Release 4 contains metadata about photographic plates and data extracted from digitized plates.applause_dr4.archiveAn 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.archive_idArchive identification numbermeta.idintarchive_nameArchive namemeta.id;meta.datasetcharinstituteInstitute responsible for the archivemeta.id;instr.obstycharnum_platesNumber of digitised plates in the archivemeta.numberintnum_scansNumber of scans in the archivemeta.numberintnum_direntriesNumber of metadata entries in a directorymeta.numberintnum_logbookpagesNumber of digitised logbook pages in the archivemeta.numberintnum_envelopesNumber of digitised envelopes in the archivemeta.numberintnum_notesNumber of digitised notes in the archivemeta.numberintnum_logbooksNumber of digitised logbooks in the archivemeta.numberinttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.plateThe 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.plate_idPlate identification numbermeta.id;meta.mainintarchive_idArchive identification numbermeta.idintplate_numPlate number in archivemeta.record;instr.platecharplate_num_origOriginal plate number in archivemeta.record;instr.platecharwfpdb_idPlate identification in the Wide-Field Plate Databasemeta.idcharseriesPlate seriesmeta.idcharplate_formatPlate format (cm x cm)meta.code;phys.size;instr.platecharplate_size1Plate size along axis 1cmphys.size;instr.platefloatplate_size2Plate size along axis 2cmphys.size;instr.platefloatemulsionName of the photographic emulsioninstr.plate.emulsioncharfilterFilter type used during the observationinstr.param;instr.filterchardevelopmentPlate development information (developer, time)meta.notecharplate_qualityQuality of the platemeta.code.qualcharplate_notesNotes about the platemeta.note;instr.platechardate_origOriginal recorded datetime.epoch;obs.exposurecharnumexpNumber of exposuresmeta.number;obs.sequenceshortobservatoryObservatory namemeta.id;instr.obstycharsite_nameObservatory site namemeta.id;instr.obstycharsite_longitudeEast longitude of the observing site, in decimal degreesdegpos.earth.lon;instr.obstydoublesite_latitudeLatitude of the observing site, in decimal degreesdegpos.earth.lat;instr.obstydoublesite_elevationElevation of the observatory sitempos.earth.altitude;instr.obstyfloattelescopeTelescope namemeta.id;instr.telcharota_nameName of the telescope optical tube assembly (OTA) that was used to expose the platemeta.id;instr.telcharota_diameterDiameter of the telescope optical tube assembly (OTA)mstat.value;instr.telfloatota_apertureClear aperture of the telescope optical tube assembly (OTA)mstat.value;instr.telfloatota_foclenFocal length of the telescope optical tube assembly (OTA)minstr.tel.focalLengthfloatota_scalePlate scale of the telescope optical tube assembly (OTA)arcsec/mminstr.scalefloatinstrumentInstrument namemeta.id;instrcharmethod_codemethod_code follows the WFPDB coding: see Vizier (`http://cdsarc.cds.unistra.fr/viz-bin/VizieR-n?-source=METAnot&catid=6090&notid=7&-out=text`)meta.code.qualshortprismInformation about the objective prism usedmeta.note;instrcharprism_angleAngle of the objective prism (degstat.valuechardispersionDispersion (Angstrom / mm)0.1nm/mminstr.dispersionfloatgratingInformation about the grating usedmeta.note;instrcharair_temperatureAir temperature (from logbook)Celsiusphys.temperature;obs.atmosfloatsky_calmnessSky calmness (seeing conditions), scale 1-5 (German: Ruhe)obs.param;obs.atmoscharsky_sharpnessSharpness (seeing conditions), scale 1-5 (German: Schärfe)obs.param;obs.atmoscharsky_transparencySky transparency (seeing conditions), scale 1-5 (German: Durchsicht, Klarheit)obs.param;obs.atmoscharsky_conditionsNotes on sky conditions (from logbook)meta.note;obs.atmoscharobserverObserver nameobs.observercharobserver_notesObserver notes (from logbook)meta.notecharnotesMiscellaneous notesmeta.notecharbibcodeBibcode of related papermeta.bib.bibcodechartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.exposureThe 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.exposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintexposure_numExposure sequence numbermeta.recordshortobject_nameName of the observed object or fieldmeta.idcharobject_type_codecharra_origOriginal recorded right ascension of the telescope pointing (plate center)degpos.eq.rachardec_origOriginal recorded declination of the telescope pointing (plate center)degpos.eq.deccharflag_coordQuality flag of the recorded coordinates (right ascension and declination)meta.code.qualcharra_icrsRight ascension of the source (International Celestial Reference System)degpos.eq.radoubledec_icrsDeclination of the source (International Celestial Reference System)degpos.eq.decdoubledate_orig_startOriginal recorded date of the sub-exposure (evening date)time.start;obs.exposurechardate_orig_endOriginal recorded date of the exposure end (evening date)time.end;obs.exposurechartime_orig_startOriginal recorded start time of the sub-exposuretime.start;obs.exposurechartime_orig_endOriginal recorded end time of the sub-exposuretime.end;obs.exposurecharflag_timeQuality flag of the recorded observation timemeta.code.qualcharut_startUT date and time of the start of exposureTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharut_midUT date and time at the mid-point of sub-exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_weightedUT date and time of the weighted mid-point of exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_endUT date and time of the sub-exposure endTime[yyyy-mm-dd hh:mm:ss]time.end;obs.exposurecharyear_startDecimal Julian year of the start of exposuretime.start;obs.exposuredoubleyear_midDecimal year of the mid-point of exposuretime.epoch;obs.exposuredoubleyear_weightedDecimal Julian year of the weighted mid-point of exposuretime.epoch;obs.exposuredoubleyear_endDecimal Julian year of the end of exposuretime.end;obs.exposuredoublejd_startJulian date at the start of exposuretime.start;obs.exposuredoublejd_midJulian date at the mid-point of exposuretime.epoch;obs.exposuredoublejd_weightedJulian date at the weighted mid-point of exposuretime.epoch;obs.exposuredoublejd_endJulian date at the end of sub-exposuretime.end;obs.exposuredoublehjd_midHeliocentric Julian date at the mid-point of exposuretime.epoch;obs.exposuredoublehjd_weightedHeliocentric Julian date at the weighted mid-point of exposuretime.epoch;obs.exposuredoubleexptimeExposure timestime.interval;obs.exposurefloatmethod_codemeta.code.qualshortnum_subNumber of sub-exposuresmeta.numbershortfocusFocus value (from logbook)stat.valuefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.exposure_subThe 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.subexposure_idSub-exposure identification numbermeta.id;meta.mainintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintexposure_numExposure sequence numbermeta.recordshortsubexposure_numSub-exposure sequence numbermeta.recordshortdate_orig_startOriginal recorded date of the sub-exposure (evening date)time.start;obs.exposurechartime_orig_startOriginal recorded start time of the sub-exposuretime.start;obs.exposurechartime_orig_endOriginal recorded end time of the sub-exposuretime.end;obs.exposurecharut_startUT date and time of the start of exposureTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharut_midUT date and time at the mid-point of sub-exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_endUT date and time of the sub-exposure endTime[yyyy-mm-dd hh:mm:ss]time.end;obs.exposurecharjd_startJulian date at the start of exposuretime.start;obs.exposuredoublejd_midJulian date at the mid-point of exposuretime.epoch;obs.exposuredoublejd_endJulian date at the end of sub-exposuretime.end;obs.exposuredoubleexptimeExposure timestime.interval;obs.exposurefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.previewCatalogue 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.preview_idPreview identification numbermeta.id;meta.mainintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintpreview_typePreview type: 1 - photograph of the plate (before cleaning), 2 - scan of the plate (before cleaning), 3 - downscaled version of the full-resolution plate scanmeta.codeshortfilenameName of the processed filemeta.ref;meta.imagecharfile_formatFile formatmeta.code.class;meta.filecharimage_widthWidth in pixels of the digitized log-page imagephys.sizeshortimage_heightHeight in pixels of the digitized log-page imagemeta.number;phys.sizeshortimage_datetimeTime of creation of the digital imagemeta.number;phys.sizecharfile_datetimeTimestamp of the last change of fileTime[yyyy-mm-dd hh:mm:ss]time.creation;meta.filecharfile_sizeFile sizebytemeta.number;meta.fileinttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.scanCatalogue 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.scan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintfilename_scanName of the scan filemeta.ref;meta.file;meta.fitscharfilename_wedgeName of the wedge scan filemeta.ref;meta.file;meta.fitscharnaxis1Length of data axis 1 (number of pixels in a row)meta.numbershortnaxis2Length of data axis 2 (number of rows)meta.numbershortminvalMinimum pixel value in the imagephot.count;stat.minintmaxvalMaximum pixel value in the imagephot.count;stat.maxintscannerName of the device used for digitizing the platemeta.idcharscan_res1Scan resolution along axis 1dpimeta.unitshortscan_res2Scan resolution along axis 2dpimeta.unitshortpixel_size1Pixel size along axis 1umphys.sizefloatpixel_size2Pixel size along axis 2umphys.sizefloatscan_softwareName of the scanning softwaremeta.id;meta.softwarecharscan_gammaScan gamma valuemeta.unitfloatscan_focusScan focus settingmeta.unitcharwedgeType of photometric step-wedgemeta.code;meta.crypticcharscan_dateScan date and timetime.epoch;time.creationcharscan_authorAuthor of the scanmeta.idcharscan_notesNotes about the scanmeta.notecharoriginInstitute responsible for the scanmeta.curation;instr.obstycharfile_datetimeTimestamp of the last change of fileTime[yyyy-mm-dd hh:mm:ss]time.creation;meta.filecharfile_sizeFile sizebytemeta.number;meta.filelongfits_checksumChecksum of the FITS file (from the CHECKSUM header keyword)meta.note;meta.file;meta.fitscharfits_datasumChecksum of the image part of the FITS file (from the DATASUM header keyword)meta.note;meta.file;meta.fitschartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.sourceTable 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.source_idSource identification number. The number is constructed as follows: process_id x 10000000 + source number in the image.meta.id;meta.mainlongprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintsource_numSource number within the imagemeta.numberintx_sourceSource coordinate along x-axispos.cartesian.xdoubley_sourceSource coordinate along y-axispos.cartesian.ydoublea_sourceSemi-major axis length of the sourcepixphys.size.smajAxisfloatb_sourceSemi-minor axis length of the sourcepixphys.size.sminAxisfloattheta_sourcePosition angledegpos.posAngfloaterra_sourceUncertainty on the semi-major axis lengthpixstat.error;phys.size.smajAxisfloaterrb_sourceUncertainty on the semi-minor axis lengthpixstat.error;phys.size.sminAxisfloaterrtheta_sourceUncertainty on the position angledegstat.error;pos.posAngfloatelongationSource elongation (a_source / b_source)phys.size.axisRatiofloatx_peakSource peak (brightest pixel) coordinate along x-axispos.cartesian.xinty_peakSource peak (brightest pixel) coordinate along y-axispos.cartesian.yintflag_usepsf1 if source position has been determined by PSF fitting, 0 if barycenter has been usedmeta.codeshortx_imageSource barycenter coordinate along x-axispos.cartesian.xdoubley_imageSource barycenter coordinate along y-axispos.cartesian.ydoubleerra_imageUncertainty on the semi-major axis length (barycenter method)pixstat.error;phys.size.smajAxisfloaterrb_imageUncertainty on the semi-minor axis length (barycenter method)pixstat.error;phys.size.sminAxisfloaterrtheta_imageUncertainty on the position angle (barycenter method)degstat.error;pos.posAngfloatx_psfSource coordinate along x-axis, determined by PSF fittingpos.cartesian.xdoubley_psfSource coordinate along y-axis, determined by PSF fittingpos.cartesian.ydoubleerra_psfUncertainty on the semi-major axis length (PSF fitting)pixstat.error;phys.size.smajAxisfloaterrb_psfUncertainty on the semi-minor axis length (PSF fitting)pixstat.error;phys.size.sminAxisfloaterrtheta_psfUncertainty on the position angle (PSF fitting)degstat.error;pos.posAngfloatmag_autoKron-like elliptical aperture magnitudemagphot.magfloatmagerr_autoError for mag_automagstat.error;phot.magfloatflux_autoFlux within a Kron-like elliptical aperturephot.countfloatfluxerr_autoError for flux_autostat.error;phot.countfloatmag_isoIsophotal magnitudemagphot.magfloatmagerr_isoError for isophotal magnitudemagstat.error;phot.magfloatflux_isoIsophotal fluxphot.countfloatfluxerr_isoError for isophotal fluxstat.error;phot.countfloatflux_maxPeak flux above backgroundphot.countfloatflux_radiusFraction-of-light radiuspixstat.valuefloatisoareaIsophotal area above thresholdpix2stat.valueintsqrt_isoareaSquare root of the isophotal area above thresholdpixstat.valuefloatbackgroundBackground valuestat.valuefloatsextractor_flagsFlags given by SExtractormeta.codeshortdist_centerDistance of the source from plate centerpixpos.distancedoubledist_edgeDistance of the source from plate edgepixpos.distancedoubleannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshortflag_rim1 if source is found to be at plate rim, 0 otherwisemeta.codeshortflag_negradius1 if flux_radius is negative, 0 otherwisemeta.codeshortflag_clean1 if source is not at the rim, flux_radius is not negative, and elongation < 5, 0 otherwisemeta.codeshortmodel_predictionlikelihood of being an artifact (0) or a detection (1)stat.likelihoodfloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.source_calibExtracted sources with calibrated sky coordinates, magnitudes, and cross-matches with the Gaia EDR3 catalogue. Astrometric and photometric calibration has been carried out using Gaia EDR3. Unique identifier: source_id. The identifier is the same as in the source table.source_idSource identification number. The number is constructed as follows: 4 x 10^13 + process_id x 10^7 + source number in the image.meta.id;meta.mainlongprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintsolution_numSolution number within the processmeta.numbershortannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshortdist_centerDistance of the source from plate centerpxpos.distancedoubledist_edgeDistance of the source from plate edgepxpos.distancedoublesextractor_flagsFlags given by SExtractormeta.codeshortmodel_predictionClassification of the source as celestial (value close to 1) or artifact (value close to 0). The value is a prediction by a machine-learning algorithm.stat.likelihoodfloatra_icrsRight ascension of the source (International Celestial Reference System)pos.eq.radoubledec_icrsDeclination of the source (International Celestial Reference System)pos.eq.decdoublera_errorError of the right ascensionarcsecstat.error;pos.eq.rafloatdec_errorError of the declinationarcsecstat.error;pos.eq.decfloatgal_lonGalactic longitude of the sourcepos.galactic.londoublegal_latGalactic latitude of the sourcepos.galactic.latdoubleecl_lonEcliptic longitude of the sourcedoubleecl_latEcliptic latitude of the sourcedoublex_sphereSource x-coordinate on the unit spherepos.cartesian.xdoubley_sphereSource y-coordinate on the unit spherepos.cartesian.ydoublez_sphereSource z-coordinate on the unit spherepos.cartesian.zdoublehealpix256Source HEALPix number (nside=256, nested ordering)pos.healpixinthealpix1024Source HEALPix number (nside=1024, nested ordering)pos.healpixintnn_distDistance to the nearest neighbor among extracted sourcesarcsecpos.angDistancefloatzenith_angleZenith angle of the sourcedegpos.az.zdfloatairmassAir mass (path length for light rays from a celestial source to pass through the atmosphere)obs.airMassfloatnatmagCalibrated magnitude of the source in the plate natural photometric systemmagphot.mag;em.optfloatnatmag_errorError estimate of the magnitude in the plate natural photometric systemstat.error;phot.mag;em.optfloatbpmagCalibrated magnitude of the source in the Gaia EDR3 BP (blue) passbandfloatbpmag_errorError estimate of the calibrated BP magnitudefloatrpmagCalibrated magnitude of the source in the Gaia EDR3 RP (red) passbandfloatrpmag_errorError estimate of the calibrated RP magnitudefloatnatmag_plateMagnitude of the source in the plate natural photometric system, obtained through photometric calibration for the whole plate, without correctionsmagphot.mag;em.optfloatnatmag_correctionCorrection applied to the source magnitude in the plate natural photometric systemmagphot.mag;em.opt;arith.difffloatnatmag_residualResidual of the source magnitude in the plate natural photometric system after corrections, compared to the synthetic magnitude constructed from Gaia EDR3 photometrymagphot.mag;em.opt;arith.difffloatphot_range_flagsPhotometric range flags: 0 - source natmag is in the range of calibration stars; 1 - source natmag is brighter than the brightest calibration star; 2 - source natmag is fainter than the estimated faint limit of the plateshortphot_calib_flagsFlag for photometric calibration stars: 0 - source is not a calibration star; 1 - source is a valid calibration star; 2 - source was found to be an outlier of the photometric calibration curvemeta.codeshortcolor_termColor term of the plate, characterizing color response of the emulsion and filter used. Color term 0 corresponds to the Gaia EDR3 RP passband, color term 1 corresponds to the BP passband. Values outside the 0...1 range are extrapolations.stat.fit.paramfloatcat_natmagMagnitude of the source in the plate natural photometric system, RP+color_term * (BP-RP), based on the Gaia EDR3 cataloguemagphot.mag;em.optfloatgaiaedr3_gmagGaia EDR3 G-magnitude of the matched sourcefloatgaiaedr3_idGaia EDR3 source_id of the matched sourcelonggaiaedr3_bp_rpGaia EDR3 BP-RP color index of the matched sourcefloatgaiaedr3_distAngular distance in the sky plane between the source and the matched Gaia EDR3 sourcearcsecfloatgaiaedr3_neighborsNumber of Gaia EDR3 sources that are in the neighborhood of the source. The neighboring sources can be found in the source_xmatch table.intmatch_radiusRadius in the sky plane that was used to cross-match extracted sources with the Gaia EDR3 cataloguearcsecpos.angDistancefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharposGIS index for (ra,dec)(radians,radians)meta.numbercharapplause_dr4.logbookInformation 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_idLogbook identification numbermeta.idintarchive_idArchive identification numbermeta.idintlogbook_numLogbook number within the archivemeta.numbercharlogbook_titleLogbook titlemeta.titlecharlogbook_typeLogbook typemeta.codeshortlogbook_notesNotes about logbookmeta.notechartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.logpageThe 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.logpage_idLog-page identification numbermeta.id;meta.mainintlogbook_idLogbook identification numbermeta.idintarchive_idArchive identification numbermeta.idintlogpage_typeLog-page type: 1 - plate directory (usually one row per plate), 2 - observation logbook (free text and notes), 3 - plate cover or envelope with handwritten or printed metadata, 4 - loose pages with notes or metadatameta.codeshortpage_numPage number in the logbookmeta.numbershortlogpage_orderLog-page order associated with the specific platemeta.recordshortfilenameName of the logpage filemeta.ref;meta.filecharfile_formatFile formatmeta.code.class;meta.filecharimage_widthWidth in pixels of the digitized log-page imagemeta.number;phys.sizeshortimage_heightHeight in pixels of the digitized log-page imagemeta.number;phys.sizeshortimage_datetimeTime of creation of the digital image (from Exif metadata)Time[yyyy-mm-dd hh:mm:ss]time.creation;meta.filecharfile_datetimeTimestamp of the last change of fileTime[yyyy-mm-dd hh:mm:ss]time.creation;meta.filecharfile_sizeFile sizebytemeta.number;meta.fileinttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.plate_logpageThe 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_idPlate identification numbermeta.idintlogpage_idLog-page identification number, associated with the platemeta.idintlogpage_orderSequence number of the log-page, associated with the platemeta.numbershorttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.processThe process table contains summary data on the processing of the plate scan with the astrometric and photometric pipeline, using the PyPlate software. Unique identifier process_id.process_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintfilenameName of the processed filemeta.ref;meta.fitscharhostnameName of the computer that carried out the plate processmeta.idcharnum_exposuresNumber of exposures of the plateshortplate_epochDecimal year of the plate exposurefloattimestamp_startTimestamp of the start of processTime[yyyy-mm-dd hh:mm:ss]time.start;time.processingchartimestamp_endTimestamp of the end of processTime[yyyy-mm-dd hh:mm:ss]time.start;time.processingchardurationDuration of the processstime.durationintskySky background valuephot.count;em.optfloatsky_sigmaStandard deviation of the sky background valuestat.stdev;phot.count;em.optfloatuse_psf1 if PSF fitting was used in the process, 0 otherwisemeta.codeshortthresholdThreshold above which sources were detectedphot.count;em.optfloatnum_sourcesNumber of sources extracted from the imagemeta.numberintnum_psf_sourcesNumber of sources for which image coordinates were determined using PSF photometrymeta.numberintsolved1 if astrometric solution was found for the image, 0 otherwisemeta.code.statusshortnum_true_sourcesNumber of sources classified as true sources (model_prediction > 0.9)intnum_artifactsNumber of sources classified as artifacts (model_prediction < 0.1)intnum_solutionsNumber of astrometric solutions found for the imageshortcolor_termColor term of the plate, characterizing color response of the emulsion and filter used, based on the Gaia EDR3 photometrystat.fit.paramfloatpattern_ratioRatio of the scanner pattern amplitude in the y direction to the amplitude in the x directionfloatbright_limitBrightest source magnitude in the plate natural photometric system in the image among calibration starsmagphot.mag;em.opt;stat.minfloatnum_gaia_edr3Number of matched Gaia EDR3 sourcesintfaint_limitEstimated faint limit of the plate in the plate natural photometric system. In case of multiple solutions, the faintest of the individual faint limits.magphot.mag;em.opt;stat.maxfloatmag_rangeMagnitude range between the brightest and faintest source magnitudes in the plate natural photometric system in the imagemagphot.mag;em.opt;arith.difffloatnum_calibNumber of calibration stars in the imagemeta.numberintcalibrated1 if photometric calibration was completed, 0 otherwisemeta.code.statusshortnum_iterationsNumber of iterations in the photometric calibrationshortcompleted1 if process was completed, 0 otherwisemeta.code.statusshortpyplate_versionVersion number of the PyPlate software used for the processmeta.version;meta.softwarecharapplause_dr4.solutionThe table contains astrometric solutions of plate scans. Unique identifier is solution_id.solution_idSolution identifiermeta.id;meta.versionintprocess_idProcess identification numbermeta.idintsolutionset_idIdentifier of the solution set where the solution belongsintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintsolution_numNumber of the solution within the solution setmeta.numbershortra_icrsRight ascension of the image center, corresponding to the current astrometric solutiondoubledec_icrsDeclination of the image center, corresponding to the current astrometric solutiondoublefov1Field of view of the image along axis 1degpos.angDistance;instr.fovfloatfov2Field of view of the image along axis 2degpos.angDistance;instr.fovfloatpixel_scaleMean pixel scale for the imagearcsec / pxpos.wcs.scalefloatsource_densityNumber of sources per square degree in the central 2/3 of the imagemeta.numberfloatcd1_1Transformation matrix elementpos.wcs.cdmatrixdoublecd1_2Transformation matrix elementpos.wcs.cdmatrixdoublecd2_1Transformation matrix elementpos.wcs.cdmatrixdoublecd2_2Transformation matrix elementpos.wcs.cdmatrixdoublerotation_angleImage rotation angledegpos.posAngfloatplate_mirrored1 if image is mirrored, 0 otherwisemeta.codeshortncp_on_plate1 if North Celestial Pole is in the image, 0 otherwisemeta.codeshortscp_on_plate1 if South Celestial Pole is in the image, 0 otherwisemeta.codeshortstc_boxSpace-Time Coordinate (STC) representation of the image footprint in the sky. Numbers denote plate center coordinates (RA, Dec) and box width\/height in degrees.meta.notecharheader_wcsFITS header containing the World Coordinate System (WCS), adopted for the current solution (SCAMP or Astrometry.net)charstc_polygonSpace-Time Coordinate (STC) representation of the image footprint in the sky. Numbers denote RA\/Dec pairs (in degrees) of four plate corners.meta.notecharheader_anetFITS header containing the World Coordinate System (WCS), provided by the Astrometry.net software as an initial astrometric solutioncharheader_scampFITS header containing the World Coordinate System (WCS), provided by the SCAMP software as the refined astrometric solutionchartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationcharscamp_dscalefloattimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharscamp_danglefloatscamp_dxfloatscamp_dyfloatscamp_sigma_1floatscamp_sigma_2floatscamp_sigma_meanfloatscamp_chi2floatscamp_ndegintscamp_distortintscamp_iterationintx_centroidfloaty_centroidfloatrel_x_centroidfloatrel_y_centroidfloatnum_xmatchintnum_gaia_edr3intapplause_dr4.phot_calibThis table contains data on photometric calibration. Unique identifier calib_id.calib_idCalibration identification numbermeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintsolution_numSolution number in the solution setmeta.numbershortiterationIteration numbermeta.recordshortcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatcolor_term_errorfloatcterm_stdev_fitfloatcterm_stdev_minfloatnum_calib_starsNumber of stars that were actually used for photometric calibration in the annular binmeta.numberintcterm_range_minfloatnum_bright_starsNumber of bright stars that were actually used for photometric calibration in the annular bin. Bright-star calibration was handled separately and then merged with the calibration curve.meta.numberintcterm_range_maxfloatnum_outliersNumber of stars that were found to be outliers of the photometric calibration curve in the annular binmeta.numberintbright_limitBrightest source magnitude among calibration stars, belonging to the current astrometric solution, in the plate natural photometric systemmagphot.mag;em.opt;stat.minfloatcterm_iterationsshortcterm_num_starsintfaint_limitEstimated faint limit of the current astrometric solution in the plate natural photometric systemmagphot.mag;em.opt;stat.maxfloatmag_rangeMagnitude range between the bright and faint limitmagphot.mag;em.opt;arith.difffloatnum_gaia_edr3intnum_candidate_starsintrmse_minMinimum root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric systemmagstat.error;phot.mag;em.opt;stat.minfloatrmse_medianMedian root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric systemmagstat.error;phot.mag;em.opt;stat.medianfloatrmse_maxMaximum root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric systemmagstat.error;phot.mag;em.opt;stat.maxfloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharplate_mag_brightestfloatplate_mag_density02floatplate_mag_brightcutfloatplate_mag_maxdenfloatplate_mag_limfloatapplause_dr4.phot_calib_curveDerived photometric calibration curves that were used for transforming extracted source magnitudes to the plate natural photometric system. Unique identifier calibcurve_id.calibcurve_idUnique identifier in the tableintcalib_idCalibration identification numbermeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintsolution_numSolution number in the solution setmeta.numbershortiterationIteration numbermeta.recordshortplate_magPlate magnitude provided by the Source Extractor softwarefloatnatmagCorresponding magnitude in the plate natural photometric systemmagphot.mag;em.optfloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.scanner_patternpattern_idintsolutionset_idintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintaxisshortcoordfloatshiftfloatextrapolatedshorttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.solution_healpixAncillary table using HEALPIX 1 (nside=1024, nested ordering) to provide information on the location of objects (plate_id,scan_id,archive_id,num_sources) within or interesecting the HEALPIX area.solution_idSolution Identifiermeta.id;meta.versionintsolutionset_idintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintsolution_numNumber of the solution within the solution setmeta.numbershorthealpix1024Source HEALPix number (nside=1024, nested ordering)pos.healpixintnum_sourcesNumber of sources extracted from the imagemeta.numbershorttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.solution_setThis table provides summary data on all astrometric solutions found during processing of the plate image. Unique identifier solutionset_id.solutionset_idSolution set identification numberintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintnum_solutionsNumber of unique astrometric solutions foundshortnum_duplicate_solutionsNumber of duplicate astrometric solutions foundshortpattern_ratiofloatmean_pixel_scaleMean pixel scale of all astrometric solutions in the setarcsec / pxfloatmin_pixel_scaleMinimum pixel scale of all astrometric solutions in the setarcsec / pxfloatmax_pixel_scaleMaximum pixel scale of all astrometric solutions in the setarcsec / pxfloatmean_fov1Mean field of view (FOV) along image axis 1 among all astrometric solutions in the setfloatmean_fov2Mean field of view (FOV) along image axis 2 among all astrometric solutions in the setfloatsource_densityNumber of sources per square degree in the central 2/3 of the imagemeta.numberfloatmax_separationMaximum separation between individual astrometric solutions, measured as angular distance between image centers in the skydegfloatheader_wcsFITS header containing World Coordinate Systems (WCS) for all astrometric solutions in the solution setchartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.source_xmatchCrossmatch helper table, assembles plate_id, source_id, scan_id, process_id, gaiaedr3_id and crossmatch values like dist, coordinatessource_idSource identification number. The number is constructed as follows: process_id x 10000000 + source number in the image.meta.id;meta.mainlongprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintdistfloatsolution_numNumber of the solution within the solution setmeta.numbershortgaiaedr3_idlongx_gaiadoubley_gaiadoubleflag_xmatchshorttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr4.solution_healpix256Ancillary table using HEALPIX 1 (nside=256, nested ordering) to provide information on the location of objects (plate_id,scan_id,archive_id,num_sources) within or interesecting the HEALPIX area.solution_idintsolutionset_idintprocess_idintscan_idintplate_idintarchive_idintsolution_numshorthealpix256intnum_sourcesshorttimestamp_insertchartimestamp_updatecharapplause_dr3sThe APPLAUSE DR3s contains metadata about the Solar photographic plates of the Einsteinturm and data extracted from the digitzed plates.applause_dr3s.archiveAn 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_idarchive_idArchive identification numbermeta.idintarchive_nameArchive namemeta.id;meta.datasetcharinstituteInstitute responsible for the archivemeta.id;instr.obstychartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharnum_platesNumber of digitised plates in the archivemeta.numberintnum_logpagesNumber of digitised log pages in the archivemeta.numberintnum_notesNumber of digitised notes in the archivemeta.numberintnum_envelopesNumber of digitised envelopes in the archivemeta.numberintnum_previewsNumber of previews of scans and other digitised objects in the archivemeta.numberintnum_logbooksNumber of digitised logbooks in the archivemeta.numberintapplause_dr3s.solarplateThe table contains data on photographic plates of the Einsteinturm as physical objects. For the release, we enhanced the table with observation data pertaining to the plate, since there is a 1:1 relation; one plate corresponds to an observation with a short exposure time. See also the scan table. Unique Identifier: plate_idplate_idPlate identification numbermeta.id;meta.mainintarchive_idArchive identification numbermeta.idintplate_numPlate number in archivemeta.record;instr.platecharplate_formatPlate format (cm x cm)meta.code;phys.size;instr.platecharplate_size1Plate size along axis 1cmphys.size;instr.platefloatplate_size2Plate size along axis 2cmphys.size;instr.platefloatobservatoryObservatory namemeta.id;instr.obstycharsite_nameObservatory site namemeta.id;instr.obstychartelescopeTelescope namemeta.id;instr.telcharsite_longitudeEast longitude of the observing site, in decimal degreesdegpos.earth.lon;instr.obstydoublesite_latitudeLatitude of the observing site, in decimal degreesdegpos.earth.lat;instr.obstydoublesite_elevationElevation of the observatory sitempos.earth.altitude;instr.obstyfloatlogbookLogbook entry available (Logbook pages are not scanned)meta.codecharota_nameName of the telescope optical tube assembly (OTA) that was used to expose the platemeta.id;instr.telcharota_diameterDiameter of the telescope optical tube assembly (OTA)mstat.value;instr.telfloatota_apertureClear aperture of the telescope optical tube assembly (OTA)mstat.value;instr.telfloatota_foclenFocal length of the telescope optical tube assembly (OTA)minstr.tel.focalLengthfloatota_scalePlate scale of the telescope optical tube assembly (OTA)arcsec/mminstr.scalefloatinstrumentInstrument namemeta.id;instrcharfilterFilter type used during the observationinstr.param;instr.filtercharmethodObservation method.meta.codecharnumexpNumber of exposuresmeta.number;obs.sequenceshortobject_nameName of the observed objectmeta.idcharobject_typeObject typemeta.codecharra_degRight Ascension of the telescope pointingdegposdoubledec_degDeclination of the telescope pointingdegposdoublera_origOriginal recorded right ascension of the telescope pointing (plate center)pos.eq.rachardec_origOriginal recorded declination of the telescope pointing (plate center)pos.eq.deccharelevationElevation of the Sun (disk center)degmeta.number;pos.posAngdoublesolar_azimuthTelescope coelostat azimuthdegobs.paramdoublesolar_pzeroSolar axis position angledegobs.paramdoublesolar_bzeroSolar axis tilt angledegobs.paramdoublesolar_lzeroCarrington longitudedegobs.paramdoublesolar_rSolar radiusarcsecobs.paramdoublecar_rotCarrington rotation numbermeta.number;obs.paramdoublesid_timesiderial time (GST)degtimefloatair_massAirmassobs.param;obs.airMassfloatexptimeExposure time of the observationsobs;time.durationfloatobs_typeSchott Glass GG13 und BG12charwavelengthcentral wavelengthAngstroemem.wldoublewavelength_minminimum wavelengthAngstromem.wldoublewavelength_maxmaximum wavelengthAngstromem.wldoubleut_startUT date and time of the start of exposureTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharyear_startDecimal Julian year of the start of exposuretime.start;obs.exposuredoublejd_startJulian date at the start of exposuretime.start;obs.exposuredoubletimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3s.scanThe scan table provides scans all information available of sanning process of the photographic plates, giving sizes, etc. A scan is a high-resolution image of a photographic plate or film. In the case of the Solar plates, we provide the already preprocessed images, details see level 1 description. Unique Identifier: scan_id.scan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintfilename_scanName of the level 0 file (no raw scan)meta.ref;meta.file;meta.fitscharfilename_wedgeName of the wedge scan filemeta.ref;meta.file;meta.fitscharnaxis1Length of data axis 1 (number of pixels in a row)meta.numbershortnaxis2Length of data axis 2 (number of pixels in a row)meta.numbershortminvalMinimum pixel value in the imagephot.count;stat.minintmaxvalMaximum pixel value in the imagephot.count;stat.maxintscannerName of the device used for digitizing the platemeta.idcharscan_res1Scan resolution along axis 1dpimeta.unitshortscan_res2Scan resolution along axis 2dpimeta.unitshortpixel_size1Pixel size along axis 1umphys.sizefloatpixel_size2Pixel size along axis 2umphys.sizefloatscan_softwareName of the scanning softwaremeta.id;meta.softwarecharscan_gammaScan gamma valuemeta.unitfloatscan_focusScan focus settingmeta.unitcharwedgeType of photometric step-wedgemeta.code;meta.crypticcharscan_dateScan date and timetime.epoch;time.creationcharscan_authorAuthor of the scanmeta.idcharscan_notesNotes about the scanmeta.notecharoriginInstitute responsible for the scanmeta.curation;instr.obstycharfile_datetimeTimestamp of the last change of fileTime[yyyy-mm-dd hh:mm:ss]time.creation;meta.filecharfile_sizeFile sizebytemeta.number;meta.filelongfits_checksumChecksum of the FITS file (from the CHECKSUM header keyword)meta.note;meta.file;meta.fitscharfits_datasumChecksum of the image part of the FITS file (from the DATASUM header keyword)meta.note;meta.file;meta.fitschartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3s.level0level 0 is the result of converting the scan (tiff format, 8bit ) into a photographic positive imageplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintscan_idScan identification numbermeta.idintbitpixNumber of bits per data pixelmeta.unitshortnaxis1Length of data axis 1 (number of pixels in a row)meta.numbershortnaxis2Length of data axis 2 (number of pixels in a row)meta.numbershortpixel_size1Pixel size along axis 1umphys.sizefloatpixel_size2Pixel size along axis 2umphys.sizefloatflag[1] image + [2] time + [4] azimuth existsmeta.codeshortxscaleimage scale (X)mm/pixelmeta.unitfloatyscaleimage scale (Y)mm/pixelmeta.unitfloatctype1X directionmeta.id;meta.fitscharcunit1X directionmeta.unit;meta.fitscharcrpix1reference point xpixelmeta.unit;meta.fitsintcdelt1increment xmmmeta.unit;meta.fitsfloatctype2charcunit2increment ymmmeta.unit;meta.fitscharcrpix2reference point ypixelmeta.unit;meta.fitsintcdelt2increment ymmmeta.unit;meta.fitsfloatdata_valsintdata_minintdata_maxintdata_medianmedian valuemeta.number;stat.medianfloatdata_meanmean valuemeta.number;stat.meanfloatdata_rmsrms deviationmeta.number;stat.errorfloatdata_skewskewness from the mean valuemeta.number;stat.valuefloatdata_kurtosiskurtosismeta.number;stat.valuefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3s.level1level 1 processing results in a resampled 16bit image, calibrated and with standard solar orientationplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintscan_idScan identification numbermeta.idintbitpixNumber of bits per data pixelmeta.unitshortnaxis1Length of data axis 1 (number of pixels in a row)meta.numbershortnaxis2Length of data axis 2 (number of pixels in a row)meta.numbershortbscalescaling factormeta.numberdoublebzerozero pointmeta.numberdoublepixel_size1Pixel size along axis 1umphys.sizefloatpixel_size2Pixel size along axis 2umphys.sizefloatflag[1] image + [2] time + [4] azimuth existsmeta.codeshortflipflip [2] 180 deg, [5] horizontal, [7] verticalmeta.codecharthetarotation angledegpos.posAngcharxscaleimage scale (X)mm/pixelmeta.unitfloatyscaleimage scale (Y)mm/pixelmeta.unitfloatxcenterdisk center (X)pixelmeta.unitshortycenterdisk center (Y)pixelmeta.unitshortctype1North (top) / South (bottom)meta.id;meta.fitscharcunit1increment ymeta.unit;meta.fitscharcrpix1reference point xpixelmeta.unit;meta.fitsintcdelt1coordinate increment xarcsecmeta.unit;meta.fitsfloatctype2East (left) / West(right)meta.id;meta.fitscharcunit2increment ymeta.unit;meta.fitscharcrpix2reference point ypixelmeta.unit;meta.fitsintcdelt2coordinate increment yarcsecmeta.unit;meta.fitsfloatdata_valsintdata_mindoubledata_maxdoubledata_medianmedian valuemeta.number;stat.medianfloatdata_meanmean valuemeta.number;stat.meanfloatdata_rmsrms deviationmeta.number;stat.errorfloatdata_skewskewness from the mean valuemeta.number;stat.valuefloatdata_kurtosiskurtosismeta.number;stat.valuefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3s.level2level 2 contains the limb-darkening corrected full-disk with enhanced contrastplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintscan_idScan identification numbermeta.idintbitpixNumber of bits per data pixelmeta.unitshortnaxis1number of pixels in E-W directionmeta.numbershortnaxis2number of pixels in N-S directionmeta.numbershortbscalescaling factormeta.numberdoublebzerozero pointmeta.numberdoublepixel_size1Pixel size along axis 1umphys.sizefloatpixel_size2Pixel size along axis 2umphys.sizefloatflag[1] image + [2] time + [4] azimuth existsmeta.codeshortflipflip [2] 180 deg, [5] horizontal, [7] verticalmeta.codecharthetarotation angledegpos.posAngcharxscaleimage scale (X)mm/pixelmeta.unitfloatyscaleimage scale (Y)mm/pixelmeta.unitfloatxcenterdisk center (X)pixelmeta.unitshortycenterdisk center (Y)pixelmeta.unitshortctype1North (top) / South (bottom)meta.id;meta.fitscharcunit1X directionarcsecmeta.unit;meta.fitscharcrpix1reference point xpixelmeta.unit;meta.fitsintcdelt1coordinate increment xarcsecmeta.unit;meta.fitsfloatctype2East (left) / West(right)meta.id;meta.fitscharcunit2increment yarcsecmeta.unit;meta.fitscharcrpix2reference point ypixelmeta.unit;meta.fitsintcdelt2coordinate increment yarcsecmeta.unit;meta.fitsfloatdata_valsintdata_mindoubledata_maxdoubledata_medianmedian valuemeta.number;stat.medianfloatdata_meanmean valuemeta.number;stat.meanfloatdata_rmsrms deviationmeta.number;stat.errorfloatdata_skewskewness from the mean valuemeta.number;stat.valuefloatdata_kurtosiskurtosismeta.number;stat.valuefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3s.filesAccess to all files (fits level 0 to level 2, previews for level 1 and level 2)plate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintscan_idScan identification numbermeta.idintlevel0_fitslevel 0 fits contain the result of converting the scan (tiff format, 8bit ) into a photographic positive imagemeta.ref;meta.file;meta.fitscharl0_fits_checksumHDU checksummeta.fits;meta.numbercharl0_data_checksumData checksum FITSmeta.fits;meta.numbercharlevel1_fitslevel 1 fits contain the processing results of a level 0 image into a resampled 16bit image, calibrated and with standard solar orientationmeta.ref;meta.file;meta.fitscharl1_fits_checksumHDU checksummeta.fits;meta.numbercharl1_data_checksumData checksum FITSmeta.fits;meta.numbercharlevel2_fitslevel 2 fits contain the result of level 1 images with the limb-darkening corrected full-disk with enhanced contrastmeta.ref;meta.file;meta.fitscharl2_fits_checksumHDU checksummeta.fits;meta.numbercharl2_data_checksumData checksum FITSmeta.fits;meta.numbercharlevel1_previewpreview (png) of the level 1 fits, containing the processing results of a level 0 image into a resampled 16bit image, calibrated and with standard solar orientationmeta.ref;meta.imagecharlevel2_previewpreview (png) of the level 2 fits containing the result of level 1 images with the limb-darkening corrected full-disk with enhanced contrastmeta.ref;meta.imagechardoiDigital Object Identifier (DOI) for the plate, referencing the landig page for the results of the digital processingmeta.codecharapplause_dr3The APPLAUSE Data Release 3 contains metadata about photographic plates and data extracted from digitized plates.applause_dr3.archiveAn 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.archive_idArchive identification numbermeta.idintarchive_nameArchive namemeta.id;meta.datasetcharinstituteInstitute responsible for the archivemeta.id;instr.obstychartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharnum_platesNumber of digitised plates in the archivemeta.numberintnum_logpagesNumber of digitised log pages in the archivemeta.numberintnum_notesNumber of digitised notes in the archivemeta.numberintnum_envelopesNumber of digitised envelopes in the archivemeta.numberintnum_previewsNumber of previews of scans and other digitised objects in the archivemeta.numberintnum_logbooksNumber of digitised logbooks in the archiveintapplause_dr3.plateThe 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.plate_idPlate identification numbermeta.id;meta.mainintarchive_idArchive identification numbermeta.idintplate_numPlate number in archivemeta.record;instr.platecharplate_num_origOriginal plate number in archivemeta.record;instr.platecharwfpdb_idPlate identification in the Wide-Field Plate Databasemeta.idcharseriesPlate seriesmeta.idcharplate_formatPlate format (cm x cm)meta.code;phys.size;instr.platecharplate_size1Plate size along axis 1cmphys.size;instr.platefloatplate_size2Plate size along axis 2cmphys.size;instr.platefloatemulsionName of the photographic emulsioninstr.plate.emulsioncharfilterFilter type used during the observationinstr.param;instr.filterchardevelopmentPlate development information (developer, time)meta.notecharplate_qualityQuality of the platemeta.code.qualcharplate_notesNotes about the platemeta.note;instr.platechardate_origOriginal recorded datetime.epoch;obs.exposurecharnumexpNumber of exposuresmeta.number;obs.sequenceshortobservatoryObservatory namemeta.id;instr.obstycharsite_nameObservatory site namemeta.id;instr.obstycharsite_longitudeEast longitude of the observing site, in decimal degreesdegpos.earth.lon;instr.obstydoublesite_latitudeLatitude of the observing site, in decimal degreesdegpos.earth.lat;instr.obstydoublesite_elevationElevation of the observatory sitempos.earth.altitude;instr.obstyfloattelescopeTelescope namemeta.id;instr.telcharota_nameName of the telescope optical tube assembly (OTA) that was used to expose the platemeta.id;instr.telcharota_diameterDiameter of the telescope optical tube assembly (OTA)mstat.value;instr.telfloatota_apertureClear aperture of the telescope optical tube assembly (OTA)mstat.value;instr.telfloatota_foclenFocal length of the telescope optical tube assembly (OTA)minstr.tel.focalLengthfloatota_scalePlate scale of the telescope optical tube assembly (OTA)arcsec/mminstr.scalefloatinstrumentInstrument namemeta.id;instrcharmethodObservation method. A list of possible values is given in the WFPDB.meta.codeshortprismInformation about the objective prism usedmeta.note;instrcharprism_angleAngle of the objective prism (degstat.valuechardispersionDispersion (Angstrom / mm)0.1nm/mminstr.dispersionfloatgratingInformation about the grating usedmeta.note;instrcharair_temperatureAir temperature (from logbook)Celsiusphys.temperature;obs.atmosfloatsky_calmnessSky calmness (seeing conditions), scale 1-5 (German: Ruhe)obs.param;obs.atmoscharsky_sharpnessSharpness (seeing conditions), scale 1-5 (German: Schärfe)obs.param;obs.atmoscharsky_transparencySky transparency (seeing conditions), scale 1-5 (German: Durchsicht, Klarheit)obs.param;obs.atmoscharsky_conditionsNotes on sky conditions (from logbook)meta.note;obs.atmoscharobserverObserver nameobs.observercharobserver_notesObserver notes (from logbook)meta.notecharnotesMiscellaneous notesmeta.notecharbibcodeBibcode of related papermeta.bib.bibcodechartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.exposureThe 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.exposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintexposure_numExposure sequence numbermeta.recordshortobject_nameName of the observed object or fieldmeta.idcharobject_typeObject type, as listed in the WFPDBmeta.codecharra_origOriginal recorded right ascension of the telescope pointing (plate center)pos.eq.rachardec_origOriginal recorded declination of the telescope pointing (plate center)pos.eq.deccharflag_coordQuality flag of the recorded coordinates (right ascension and declination)meta.code.qualcharraj2000Right ascension of the source (equinox J2000)degpos.eq.radoubledej2000Declination of the source (equinox J2000)degpos.eq.decdoubleraj2000_hmsRight ascension of the plate center (equinox J2000) in sexagesimal formatpos.eq.rachardej2000_dmsDeclination of the image center (equinox J2000) in sexagesimal formatpos.eq.decchardate_orig_startOriginal recorded date of the sub-exposure (evening date)time.start;obs.exposurechardate_orig_endOriginal recorded date of the exposure end (evening date)time.end;obs.exposurechartime_orig_startOriginal recorded start time of the sub-exposuretime.start;obs.exposurechartime_orig_endOriginal recorded end time of the sub-exposuretime.end;obs.exposurecharflag_timeQuality flag of the recorded observation timemeta.code.qualcharut_startUT date and time of the start of exposureTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharut_midUT date and time at the mid-point of sub-exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_weightedUT date and time of the weighted mid-point of exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_endUT date and time of the sub-exposure endTime[yyyy-mm-dd hh:mm:ss]time.end;obs.exposurecharyear_startDecimal Julian year of the start of exposuretime.start;obs.exposuredoubleyear_midDecimal year of the mid-point of exposuretime.epoch;obs.exposuredoubleyear_weightedDecimal Julian year of the weighted mid-point of exposuretime.epoch;obs.exposuredoubleyear_endDecimal Julian year of the end of exposuretime.end;obs.exposuredoublejd_startJulian date at the start of exposuretime.start;obs.exposuredoublejd_midJulian date at the mid-point of exposuretime.epoch;obs.exposuredoublejd_weightedJulian date at the weighted mid-point of exposuretime.epoch;obs.exposuredoublejd_endJulian date at the end of sub-exposuretime.end;obs.exposuredoublehjd_midHeliocentric Julian date at the mid-point of exposuretime.epoch;obs.exposuredoublehjd_weightedHeliocentric Julian date at the weighted mid-point of exposuretime.epoch;obs.exposuredoubleexptimeExposure timestime.interval;obs.exposurefloatnum_subNumber of sub-exposuresmeta.numbershortmethodObservation method. A list of possible values is given in the WFPDB.meta.codeshortfocusFocus value (from logbook)stat.valuefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.exposure_subThe 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.subexposure_idSub-exposure identification numbermeta.id;meta.mainintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintexposure_numExposure sequence numbermeta.recordshortsubexposure_numSub-exposure sequence numbermeta.recordshortdate_orig_startOriginal recorded date of the sub-exposure (evening date)time.start;obs.exposurechartime_orig_startOriginal recorded start time of the sub-exposuretime.start;obs.exposurechartime_orig_endOriginal recorded end time of the sub-exposuretime.end;obs.exposurecharut_startUT date and time of the start of exposureTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharut_midUT date and time at the mid-point of sub-exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_endUT date and time of the sub-exposure endTime[yyyy-mm-dd hh:mm:ss]time.end;obs.exposurecharjd_startJulian date at the start of exposuretime.start;obs.exposuredoublejd_midJulian date at the mid-point of exposuretime.epoch;obs.exposuredoublejd_endJulian date at the end of sub-exposuretime.end;obs.exposuredoubleexptimeExposure timestime.interval;obs.exposurefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.previewCatalogue 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.preview_idPreview identification numbermeta.id;meta.mainintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintpreview_typePreview type: 1 - photograph of the plate (before cleaning), 2 - scan of the plate (before cleaning), 3 - downscaled version of the full-resolution plate scanmeta.codeshortfilenameName of the processed filemeta.ref;meta.imagecharfile_formatFile formatmeta.code.class;meta.filecharimage_widthWidth in pixels of the digitized log-page imagephys.sizeshortimage_heightHeight in pixels of the digitized log-page imagemeta.number;phys.sizeshortimage_datetimeTime of creation of the digital imagemeta.number;phys.sizecharfile_datetimeTimestamp of the last change of fileTime[yyyy-mm-dd hh:mm:ss]time.creation;meta.filecharfile_sizeFile sizebytemeta.number;meta.fileinttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.scanCatalogue 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.scan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintfilename_scanName of the scan filemeta.ref;meta.file;meta.notecharfilename_wedgeName of the wedge scan filemeta.ref;meta.file;meta.notecharnaxis1Length of data axis 1 (number of pixels in a row)meta.numbershortnaxis2Length of data axis 2 (number of rows)meta.numbershortminvalMinimum pixel value in the imagephot.count;stat.minintmaxvalMaximum pixel value in the imagephot.count;stat.maxintscannerName of the device used for digitizing the platemeta.idcharscan_res1Scan resolution along axis 1dpimeta.unitshortscan_res2Scan resolution along axis 2dpimeta.unitshortpixel_size1Pixel size along axis 1umphys.sizefloatpixel_size2Pixel size along axis 2umphys.sizefloatscan_softwareName of the scanning softwaremeta.id;meta.softwarecharscan_gammaScan gamma valuemeta.unitfloatscan_focusScan focus settingmeta.unitcharwedgeType of photometric step-wedgemeta.code;meta.crypticcharscan_dateScan date and timetime.epoch;time.creationcharscan_authorAuthor of the scanmeta.idcharscan_notesNotes about the scanmeta.notecharoriginInstitute responsible for the scanmeta.curation;instr.obstycharfile_datetimeTimestamp of the last change of fileTime[yyyy-mm-dd hh:mm:ss]time.creation;meta.filecharfile_sizeFile sizebytemeta.number;meta.filelongfits_checksumChecksum of the FITS file (from the CHECKSUM header keyword)meta.note;meta.file;meta.fitscharfits_datasumChecksum of the image part of the FITS file (from the DATASUM header keyword)meta.note;meta.file;meta.fitschartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.sourceTable 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.source_idSource identification number. The number is constructed as follows: process_id x 10000000 + source number in the image.meta.id;meta.mainlongprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintsource_numSource number within the imagemeta.numberintx_sourceSource coordinate along x-axispos.cartesian.xdoubley_sourceSource coordinate along y-axispos.cartesian.ydoublea_sourceSemi-major axis length of the sourcepixphys.size.smajAxisfloatb_sourceSemi-minor axis length of the sourcepixphys.size.sminAxisfloattheta_sourcePosition angledegpos.posAngfloaterra_sourceUncertainty on the semi-major axis lengthpixstat.error;phys.size.smajAxisfloaterrb_sourceUncertainty on the semi-minor axis lengthpixstat.error;phys.size.sminAxisfloaterrtheta_sourceUncertainty on the position angledegstat.error;pos.posAngfloatelongationSource elongation (a_source / b_source)phys.size.axisRatiofloatx_peakSource peak (brightest pixel) coordinate along x-axispos.cartesian.xinty_peakSource peak (brightest pixel) coordinate along y-axispos.cartesian.yintflag_usepsf1 if source position has been determined by PSF fitting, 0 if barycenter has been usedmeta.codeshortx_imageSource barycenter coordinate along x-axispos.cartesian.xdoubley_imageSource barycenter coordinate along y-axispos.cartesian.ydoubleerra_imageUncertainty on the semi-major axis length (barycenter method)pixstat.error;phys.size.smajAxisfloaterrb_imageUncertainty on the semi-minor axis length (barycenter method)pixstat.error;phys.size.sminAxisfloaterrtheta_imageUncertainty on the position angle (barycenter method)degstat.error;pos.posAngfloatx_psfSource coordinate along x-axis, determined by PSF fittingpos.cartesian.xdoubley_psfSource coordinate along y-axis, determined by PSF fittingpos.cartesian.ydoubleerra_psfUncertainty on the semi-major axis length (PSF fitting)pixstat.error;phys.size.smajAxisfloaterrb_psfUncertainty on the semi-minor axis length (PSF fitting)pixstat.error;phys.size.sminAxisfloaterrtheta_psfUncertainty on the position angle (PSF fitting)degstat.error;pos.posAngfloatmag_autoKron-like elliptical aperture magnitudemagphot.magfloatmagerr_autoError for mag_automagstat.error;phot.magfloatflux_autoFlux within a Kron-like elliptical aperturephot.countfloatfluxerr_autoError for flux_autostat.error;phot.countfloatmag_isoIsophotal magnitudemagphot.magfloatmagerr_isoError for isophotal magnitudemagstat.error;phot.magfloatflux_isoIsophotal fluxphot.countfloatfluxerr_isoError for isophotal fluxstat.error;phot.countfloatflux_maxPeak flux above backgroundphot.countfloatflux_radiusFraction-of-light radiuspixstat.valuefloatisoareaIsophotal area above thresholdpix2stat.valueintsqrt_isoareaSquare root of the isophotal area above thresholdpixstat.valuefloatbackgroundBackground valuestat.valuefloatsextractor_flagsFlags given by SExtractormeta.codeshortdist_centerDistance of the source from plate centerpixpos.distancedoubledist_edgeDistance of the source from plate edgepixpos.distancedoubleannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshortflag_rim1 if source is found to be at plate rim, 0 otherwisemeta.codeshortflag_negradius1 if flux_radius is negative, 0 otherwisemeta.codeshortflag_clean1 if source is not at the rim, flux_radius is not negative, and elongation < 5, 0 otherwisemeta.codeshorttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.source_calibExtracted 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.source_idSource identification number. The number is constructed as follows: process_id x 10000000 + source number in the image.meta.id;meta.mainlongprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshortdist_centerDistance of the source from plate centerpixpos.distancedoubledist_edgeDistance of the source from plate edgepixpos.distancedoublesextractor_flagsFlags given by SExtractormeta.codeshortraj2000Right ascension of the source (equinox J2000)degpos.eq.radoubledej2000Declination of the source (equinox J2000)degpos.eq.decdoublex_sphereSource x-coordinate on the unit spherepos.cartesian.xdoubley_sphereSource y-coordinate on the unit spherepos.cartesian.ydoublez_sphereSource z-coordinate on the unit spherepos.cartesian.zdoublehealpix256Source HEALPix number (nside=256, nested ordering)pos.healpixintraj2000_wcsRight ascension of the source based on WCS solution of the platedegpos.eq.radoubledej2000_wcsDeclination of the source based on WCS solution of the platedegpos.eq.decdoubleraj2000_subRight ascension of the source based on improved astrometric solution in a sub-fielddegpos.eq.radoubledej2000_subDeclination of the source based on improved astrometric solution in a sub-fielddegpos.eq.decdoubleraerr_subError for raj2000_subarcsecstat.error;pos.eq.rafloatdecerr_subError for dej2000_subarcsecstat.error;pos.eq.decfloatastrom_sub_gridGrid level for the finest sub-field where improved astrometric solution was applied to the source coordinates. Grid level is expressed as the number of divisions of an image in one axis. Possible values: 2, 4, 8, 16, 32.meta.numbershortastrom_sub_idHierarchical sub-field number, corresponding to the sub-field where improved astrometric solution was applied to the source coordinates. See the astrom_sub table for details.meta.idintnn_distDistance to the nearest neighbor among extracted sourcesarcsecpos.angDistancefloatzenith_angleZenith angle of the sourcepos.az.zdfloatairmassPath length for light rays from a celestial source to pass through the atmosphereobs.airMassfloatnatmagCalibrated magnitude of the source in the plate natural photometric systemmagphot.mag;em.optfloatnatmagerrEstimated error on the calibrated magnitude of the source in the plate natural photometric systemmagstat.error;phot.mag;em.optfloatbmagCalibrated B magnitude of the sourcemagphot.mag;em.opt.BfloatbmagerrEstimated error on the calibrated B magnitude of the sourcemagstat.error;phot.mag;em.opt.BfloatvmagCalibrated V magnitude of the sourcemagphot.mag;em.opt.VfloatvmagerrEstimated error on the calibrated V magnitude of the sourcemagstat.error;phot.mag;em.opt.Vfloatnatmag_plateMagnitude of the source in the plate natural photometric system, obtained through photometric calibration for the whole platemagphot.mag;em.optfloatnatmagerr_plateError of the magnitude of the source in the plate natural photometric system, obtained through photometric calibration for the whole platemagstat.error;phot.mag;em.optfloatphot_plate_flagsFlag of photometric calibration: 0 - source is within the magnitude range of calibration stars; 1 - source is brighter than the brightest calibration star in the image; 2 - source is fainter than the plate faint limitmeta.codeshortnatmag_correctionCorrection applied to the source magnitude in the plate natural photometric system, obtained through improved photometric calibration in sub-fieldsmagphot.mag;em.opt;arith.difffloatnatmag_subMagnitude of the source in the plate natural photometric system, obtained through improved photometric calibration in sub-fieldsmagphot.mag;em.optfloatnatmagerr_subError of the magnitude of the source in the plate natural photometric system, obtained through improved photometric calibration in sub-fieldsmagstat.error;phot.mag;em.optfloatnatmag_residualResidual of the source magnitude in the plate natural photometric system, after improved photometric calibration in sub-fieldsmagphot.mag;em.opt;arith.difffloatphot_sub_gridGrid level for the finest sub-field where improved photometric calibration was applied to the source. Grid level is expressed as the number of divisions of an image in one axis. Possible values: 2, 4, 8, 16, 32.meta.numbershortphot_sub_idHierarchical sub-field number, corresponding to the finest sub-field where improved photometric calibration was applied to the source. See the phot_sub table for details.meta.idintphot_sub_flagsFlag of improved photometric calibration in the sub-field: 0 - source is within the magnitude range of calibration stars; 1 - source is brighter than the brightest calibration star in the sub-field; 2 - source is fainter than the faintest calibration star in the sub-fieldmeta.codeshortphot_calib_flagsFlag for photometric calibration stars: 0 - source is not a calibration star; 1 - source is a valid calibration star; 2 - source was found to be an outlier of the photometric calibration curvemeta.codeshortcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatcolor_bvB-V color index of the source, based on the UCAC4 or Tycho-2 cataloguemagphot.color;em.opt.B;em.opt.Vfloatcat_natmagMagnitude of the source in the plate natural photometric system, B+color_term*(B-V), based on the UCAC4 or Tycho-2 cataloguemagphot.mag;em.optfloatmatch_radiusRadius in the sky plane that was used to cross-match extracted sources with external cataloguesarcsecpos.angDistancefloattycho2_idTycho 2 identifiermeta.id.crosschartycho2_id_padTycho 2 identifier paddedmeta.id.crosschartycho2_raRight ascension from the Tycho-2 cataloguedegpos.eq.radoubletycho2_decDeclination from the Tycho-2 cataloguedegpos.eq.decdoubletycho2_btmagBT magnitude from the Tycho-2 cataloguemagphot.mag;em.opt.Bfloattycho2_vtmagVT magnitude from the Tycho-2 cataloguemagphot.mag;em.opt.Vfloattycho2_btmagerrEstimated error on the calibrated magnitude vs BT mag Tycho-2 cataloguemagstat.error;phot.mag;em.opt.BTfloattycho2_vtmagerrEstimated error on the calibrated magnitude vs VT magTycho-2 cataloguemagstat.error;phot.mag;em.opt.VTfloattycho2_hipIdentification of the matched HIPPARCOS catalogue objectmeta.id.crossinttycho2_distDistance between the source and the Tycho-2 catalogue objectarcsecpos.angDistancefloattycho2_dist2Distance between the source and second nearest object of the Tycho-2 cataloguearcsecpos.angDistancefloattycho2_nn_distAngular distance between the matched object and its nearest neighbor in the Tycho-2 cataloguearcsecpos.angDistancefloatucac4_idIdentification of the matched UCAC4 catalogue objectmeta.id.crosscharucac4_raRight ascension from the UCAC4 cataloguedegpos.eq.radoubleucac4_decDeclination from the UCAC4 cataloguedegpos.eq.decdoubleucac4_bmagB magnitude from the UCAC4 cataloguemagphot.mag;em.opt.Bfloatucac4_vmagV magnitude from the UCAC4 cataloguemagphot.mag;em.opt.Vfloatucac4_bmagerrEstimated error on the calibrated magnitude vs B mag UCAC4 cataloguemagstat.error;phot.mag;em.opt.Bfloatucac4_vmagerrEstimated error on the calibrated V magnitude vs UCAC4 cataloguemagstat.error;phot.mag;em.opt.Vfloatucac4_distDistance between the source and the UCAC4 catalogue objectarcsecpos.angDistancefloatucac4_dist2Distance between the source and the second nearest neighbour object in the UCAC4 cataloguearcsecpos.angDistancefloatucac4_nn_distAngular distance between the matched object and its nearest neighbor in the UCAC4 cataloguearcsecpos.angDistancefloatapass_raRight ascension from the APASS cataloguedegpos.eq.radoubleapass_decDeclination from the APASS cataloguedegpos.eq.decdoubleapass_bmagB magnitude from the APASS cataloguemagphot.mag;em.opt.Bfloatapass_vmagV magnitude from the APASS cataloguemagphot.mag;em.opt.Vfloatapass_bmagerrEstimated error on the calibrated magnitude vs B mag APASS cataloguemagstat.error;phot.mag;em.opt.Bfloatapass_vmagerrEstimated error on the calibrated magnitude vs V mag APASS cataloguemagstat.error;phot.mag;em.opt.Vfloatapass_distDistance between the source and the APASS catalogue objectarcsecpos.angDistancefloatapass_dist2Distance between the source and the second nearest neighbour object in the APASS cataloguearcsecpos.angDistancefloatapass_nn_distAngular distance between the matched object and its nearest neighbor in the APASS DR9 cataloguearcsecpos.angDistancefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharposGIS index for (ra,dec)(radians,radians)meta.numbercharapplause_dr3.source_calib_nuConvenience table with object where no matching UCAC4 id could be assignedsource_idSource identification number. The number is constructed as follows: process_id x 10000000 + source number in the image.meta.id;meta.mainlongprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshortdist_centerDistance of the source from plate centerpixpos.distancedoubledist_edgeDistance of the source from plate edgepixpos.distancedoublesextractor_flagsFlags given by SExtractormeta.codeshortraj2000Right ascension of the source (equinox J2000)degpos.eq.radoubledej2000Declination of the source (equinox J2000)degpos.eq.decdoublex_sphereSource x-coordinate on the unit spherepos.cartesian.xdoubley_sphereSource y-coordinate on the unit spherepos.cartesian.ydoublez_sphereSource z-coordinate on the unit spherepos.cartesian.zdoublehealpix256Source HEALPix number (nside=256, nested ordering)pos.healpixintraj2000_wcsRight ascension of the source based on WCS solution of the platedegpos.eq.radoubledej2000_wcsDeclination of the source based on WCS solution of the platedegpos.eq.decdoubleraj2000_subRight ascension of the source based on improved astrometric solution in a sub-fielddegpos.eq.radoubledej2000_subDeclination of the source based on improved astrometric solution in a sub-fielddegpos.eq.decdoubleraerr_subError for raj2000_subarcsecstat.error;pos.eq.rafloatdecerr_subError for dej2000_subarcsecstat.error;pos.eq.decfloatastrom_sub_gridGrid level for the finest sub-field where improved astrometric solution was applied to the source coordinates. Grid level is expressed as the number of divisions of an image in one axis. Possible values: 2, 4, 8, 16, 32.meta.numbershortastrom_sub_idHierarchical sub-field number, corresponding to the sub-field where improved astrometric solution was applied to the source coordinates. See the astrom_sub table for details.meta.idintnn_distDistance to the nearest neighbor among extracted sourcesarcsecpos.angDistancefloatzenith_angleZenith angle of the sourcepos.az.zdfloatairmassPath length for light rays from a celestial source to pass through the atmosphereobs.airMassfloatnatmagCalibrated magnitude of the source in the plate natural photometric systemmagphot.mag;em.optfloatnatmagerrEstimated error on the calibrated magnitude of the source in the plate natural photometric systemmagstat.error;phot.mag;em.optfloatbmagCalibrated B magnitude of the sourcemagphot.mag;em.opt.BfloatbmagerrEstimated error on the calibrated B magnitude of the sourcemagstat.error;phot.mag;em.opt.BfloatvmagCalibrated V magnitude of the sourcemagphot.mag;em.opt.VfloatvmagerrEstimated error on the calibrated V magnitude of the sourcemagstat.error;phot.mag;em.opt.Vfloatnatmag_plateMagnitude of the source in the plate natural photometric system, obtained through photometric calibration for the whole platemagphot.mag;em.optfloatnatmagerr_plateError of the magnitude of the source in the plate natural photometric system, obtained through photometric calibration for the whole platemagstat.error;phot.mag;em.optfloatphot_plate_flagsFlag of photometric calibration: 0 - source is within the magnitude range of calibration stars; 1 - source is brighter than the brightest calibration star in the image; 2 - source is fainter than the plate faint limitmeta.codeshortnatmag_correctionCorrection applied to the source magnitude in the plate natural photometric system, obtained through improved photometric calibration in sub-fieldsmagphot.mag;em.opt;arith.difffloatnatmag_subMagnitude of the source in the plate natural photometric system, obtained through improved photometric calibration in sub-fieldsmagphot.mag;em.optfloatnatmagerr_subError of the magnitude of the source in the plate natural photometric system, obtained through improved photometric calibration in sub-fieldsmagstat.error;phot.mag;em.optfloatnatmag_residualResidual of the source magnitude in the plate natural photometric system, after improved photometric calibration in sub-fieldsmagphot.mag;em.opt;arith.difffloatphot_sub_gridGrid level for the finest sub-field where improved photometric calibration was applied to the source. Grid level is expressed as the number of divisions of an image in one axis. Possible values: 2, 4, 8, 16, 32.meta.numbershortphot_sub_idHierarchical sub-field number, corresponding to the finest sub-field where improved photometric calibration was applied to the source. See the phot_sub table for details.meta.idintphot_sub_flagsFlag of improved photometric calibration in the sub-field: 0 - source is within the magnitude range of calibration stars; 1 - source is brighter than the brightest calibration star in the sub-field; 2 - source is fainter than the faintest calibration star in the sub-fieldmeta.codeshortphot_calib_flagsFlag for photometric calibration stars: 0 - source is not a calibration star; 1 - source is a valid calibration star; 2 - source was found to be an outlier of the photometric calibration curvemeta.codeshortcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatcolor_bvB-V color index of the source, based on the UCAC4 or Tycho-2 cataloguemagphot.color;em.opt.B;em.opt.Vfloatcat_natmagMagnitude of the source in the plate natural photometric system, B+color_term&times;(B-V), based on the UCAC4 or Tycho-2 cataloguemagphot.mag;em.optfloatmatch_radiusRadius in the sky plane that was used to cross-match extracted sources with external cataloguesarcsecpos.angDistancefloattycho2_idTycho 2 identifiermeta.id.crosschartycho2_id_padTycho 2 identifier paddedmeta.id.crosschartycho2_raRight ascension from the Tycho-2 cataloguedegpos.eq.radoubletycho2_decDeclination from the Tycho-2 cataloguedegpos.eq.decdoubletycho2_btmagBT magnitude from the Tycho-2 cataloguemagphot.mag;em.opt.Bfloattycho2_vtmagVT magnitude from the Tycho-2 cataloguemagphot.mag;em.opt.Vfloattycho2_btmagerrEstimated error on the calibrated magnitude vs BT mag Tycho-2 cataloguemagstat.error;phot.mag;em.opt.BTfloattycho2_vtmagerrEstimated error on the calibrated magnitude vs VT magTycho-2 cataloguemagstat.error;phot.mag;em.opt.VTfloattycho2_hipIdentification of the matched HIPPARCOS catalogue objectmeta.id.crossinttycho2_distDistance between the source and the Tycho-2 catalogue objectarcsecpos.angDistancefloattycho2_dist2Distance between the source and second nearest object of the Tycho-2 cataloguearcsecpos.angDistancefloattycho2_nn_distAngular distance between the matched object and its nearest neighbor in the Tycho-2 cataloguearcsecpos.angDistancefloatucac4_idIdentification of the matched UCAC4 catalogue objectmeta.id.crosscharucac4_raRight ascension from the UCAC4 cataloguedegpos.eq.radoubleucac4_decDeclination from the UCAC4 cataloguedegpos.eq.decdoubleucac4_bmagB magnitude from the UCAC4 cataloguemagphot.mag;em.opt.Bfloatucac4_vmagV magnitude from the UCAC4 cataloguemagphot.mag;em.opt.Vfloatucac4_bmagerrEstimated error on the calibrated magnitude vs B mag UCAC4 cataloguemagstat.error;phot.mag;em.opt.Bfloatucac4_vmagerrEstimated error on the calibrated V magnitude vs UCAC4 cataloguemagstat.error;phot.mag;em.opt.Vfloatucac4_distDistance between the source and the UCAC4 catalogue objectarcsecpos.angDistancefloatucac4_dist2Distance between the source and the second nearest neighbour object in the UCAC4 cataloguearcsecpos.angDistancefloatucac4_nn_distAngular distance between the matched object and its nearest neighbor in the UCAC4 cataloguearcsecpos.angDistancefloatapass_raRight ascension from the APASS cataloguedegpos.eq.radoubleapass_decDeclination from the APASS cataloguedegpos.eq.decdoubleapass_bmagB magnitude from the APASS cataloguemagphot.mag;em.opt.Bfloatapass_vmagV magnitude from the APASS cataloguemagphot.mag;em.opt.Vfloatapass_bmagerrEstimated error on the calibrated magnitude vs B mag APASS cataloguemagstat.error;phot.mag;em.opt.Bfloatapass_vmagerrEstimated error on the calibrated magnitude vs V mag APASS cataloguemagstat.error;phot.mag;em.opt.Vfloatapass_distDistance between the source and the APASS catalogue objectarcsecpos.angDistancefloatapass_dist2Distance between the source and the second nearest neighbour object in the APASS cataloguearcsecpos.angDistancefloatapass_nn_distAngular distance between the matched object and its nearest neighbor in the APASS DR9 cataloguearcsecpos.angDistancefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharposGIS index for (ra,dec)(radians,radians)meta.numbercharapplause_dr3.lightcurveThis 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.source_idSource identification numbermeta.id;meta.mainlongprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure Identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintut_startUT date and time of the start of exposureTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharut_midUT date and time of the midpoint of exposureTime[yyyy-mm-dd hh:mm:ss]time.interval;obs.exposurecharjd_startJulian date at the start of exposuretime.start;obs.exposuredoublejd_midJulian date at the mid-point of exposuretime.epoch;obs.exposuredoublehjd_midHeliocentric Julian Day of mid-point of exposuretime.interval;obs.exposuredoubleyear_startDecimal year of the start point of exposuretime.start;obs.exposuredoubleyear_midDecimal year of the mid-point of exposuretime.epoch;obs.exposuredoubleexptimeExposure timestime.interval;obs.exposurefloatraj2000Right ascension of the source (equinox J2000)degpos.eq.radoubledej2000Declination of the source (equinox J2000)degpos.eq.decdoubletycho2_hipIdentification of the matched HIPPARCOS catalogue objectmeta.id.crossinttycho2_idIdentification of the matched Tycho-2 catalogue objectmeta.id.crosscharucac4_idIdentification of the matched UCAC4 catalogue objectmeta.id.crosscharhealpix256Source HEALPix number (nside=256, nested ordering)pos.healpixintnatmagCalibrated magnitude of the source in the plate natural photometric systemmagphot.mag;em.optfloatnatmagerrEstimated error on the calibrated magnitude of the source in the plate natural photometric systemmagstat.error;phot.mag;em.optfloatbmagCalibrated B magnitude of the sourcemagphot.mag;em.opt.BfloatbmagerrEstimated error on the calibrated B magnitude of the sourcemagstat.error;phot.mag;em.opt.BfloatvmagCalibrated V magnitude of the sourcemagphot.mag;em.opt.VfloatvmagerrEstimated error on the calibrated V magnitude of the sourcemagstat.error;phot.mag;em.opt.Vfloatcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatcolor_bvB-V color index of the source, based on the UCAC4 or Tycho-2 cataloguemagphot.color;em.opt.B;em.opt.Vfloatannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshortnn_distDistance to the nearest neighbor among extracted sourcesarcsecpos.distancefloatsextractor_flagsFlags given by SExtractormeta.codeshortzenith_angleZenith angle of the sourcepos.az.zdfloatairmassPath length for light rays from a celestial source to pass through the atmosphereobs.airMassfloatobstime_flagFlag indicatuiing, that the observation time is only known up to a day precisionmeta.codecharposGIS index for (ra,dec)(radians,radians)meta.numbercharapplause_dr3.logbookInformation 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_idLogbook identification numbermeta.idintarchive_idArchive identification numbermeta.idintlogbook_numLogbook number within the archivemeta.numbercharlogbook_titleLogbook titlemeta.titlecharlogbook_typeLogbook typemeta.codeshortlogbook_notesNotes about logbookmeta.notechartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.logpageThe 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.logpage_idLog-page identification numbermeta.id;meta.mainintlogbook_idLogbook identification numbermeta.idintarchive_idArchive identification numbermeta.idintlogpage_typeLog-page type: 1 - plate directory (usually one row per plate), 2 - observation logbook (free text and notes), 3 - plate cover or envelope with handwritten or printed metadata, 4 - loose pages with notes or metadatameta.codeshortpage_numPage number in the logbookmeta.numbershortlogpage_orderLog-page order associated with the specific platemeta.recordshortfilenameName of the logpage filemeta.ref;meta.filecharfile_formatFile formatmeta.code.class;meta.filecharimage_widthWidth in pixels of the digitized log-page imagemeta.number;phys.sizeshortimage_heightHeight in pixels of the digitized log-page imagemeta.number;phys.sizeshortimage_datetimeTime of creation of the digital image (from Exif metadata)Time[yyyy-mm-dd hh:mm:ss]time.creation;meta.filecharfile_datetimeTimestamp of the last change of fileTime[yyyy-mm-dd hh:mm:ss]time.creation;meta.filecharfile_sizeFile sizebytemeta.number;meta.fileinttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.plate_logpageThe 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_idPlate identification numbermeta.idintlogpage_idLog-page identification number, associated with the platemeta.idintlogpage_orderSequence number of the log-page, associated with the platemeta.numbershorttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.processThe process table contains data on pyplate"s processing of source extraction and astrometric calibration of plate scans. Unique Identifier process_idprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintfilenameName of the processed filemeta.ref;meta.fitscharhostnameName of the computer that carried out the plate processmeta.idchartimestamp_startTimestamp of the start of processTime[yyyy-mm-dd hh:mm:ss]time.start;time.processingchartimestamp_endTimestamp of the end of processTime[yyyy-mm-dd hh:mm:ss]time.start;time.processingchardurationDuration of the processstime.durationintskySky background valuephot.count;em.optfloatsky_sigmaStandard deviation of the sky background valuestat.stdev;phot.count;em.optfloatuse_psf1 if PSF fitting was used in the process, 0 otherwisemeta.codeshortthresholdThreshold above which sources were detectedphot.count;em.optfloatnum_sourcesNumber of sources extracted from the imagemeta.numberintnum_psf_sourcesNumber of sources for which image coordinates were determined using PSF photometrymeta.numberintsolved1 if astrometric solution was found for the image, 0 otherwisemeta.code.statusshortastrom_sub_totalNumber of sub-fields that were visited for improved astrometric solutionmeta.numberintastrom_sub_effNumber of sub-fields in which improved astrometric solution was applied to source coordinatesmeta.numberintnum_ucac4Number of matched UCAC4 catalogue objectsmeta.numberintnum_tycho2Number of matched Tycho-2 catalogue objectsmeta.numberintnum_apassNumber of matched APASS DR9 catalogue objectsmeta.numberintcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatbright_limitBrightest source magnitude in the plate natural photometric system in the image (annular bin < 9)magphot.mag;em.opt;stat.minfloatfaint_limitFaintest source magnitude in the plate natural photometric system in the image (annular bin < 9)magphot.mag;em.opt;stat.maxfloatmag_rangeMagnitude range between the brightest and faintest source magnitudes in the plate natural photometric system in the image (annular bin < 9)magphot.mag;em.opt;arith.difffloatnum_calibNumber of calibration stars in the imagemeta.numberintcalibrated1 if photometric calibration was completed, 0 otherwisemeta.code.statusshortphot_sub_totalNumber of sub-fields that were visited for improved photometric calibrationmeta.numberintphot_sub_effNumber of sub-fields in which improved photometric calibration was applied to sourcesmeta.numberintcompleted1 if process was completed, 0 otherwisemeta.code.statusshortpyplate_versionVersion number of the PyPlate software used for the processmeta.version;meta.softwarecharapplause_dr3.solutionThe table contains astrometric solutions of plate scans. Unique identifier: solution_id.solution_idSolution Identifiermeta.id;meta.versionintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintraj2000Right ascension of the plate center (equinox J2000)degpos.eq.radoubledej2000Declination of the plate center (equinox J2000)degpos.eq.decdoubleraj2000_hmsRight ascension of the plate center (equinox J2000) in sexagesimal formatpos.eq.rachardej2000_dmsDeclination of the image center (equinox J2000) in sexagesimal formatpos.eq.deccharfov1Field of view along axis 1degpos.angDistance;instr.fovfloatfov2Field of view along axis 2degpos.angDistance;instr.fovfloatpixel_scaleMean pixel scale for the imagearcsec / pixpos.wcs.scalefloatsource_densityNumber of sources per square degree in the central 2/3 of the imagemeta.numberfloatcd1_1Transformation matrix elementpos.wcs.cdmatrixdoublecd1_2Transformation matrix elementpos.wcs.cdmatrixdoublecd2_1Transformation matrix elementpos.wcs.cdmatrixdoublecd2_2Transformation matrix elementpos.wcs.cdmatrixdoublerotation_angleImage rotation anglepos.posAngfloatplate_mirrored1 if image is mirrored, 0 otherwisemeta.codeshortncp_on_plate1 if North Celestial Pole is in the image, 0 otherwisemeta.codeshortscp_on_plate1 if South Celestial Pole is in the image, 0 otherwisemeta.codeshortstc_boxSpace-Time Coordinate (STC) representation of the image footprint in the sky. Numbers denote plate center coordinates (RA, Dec) and box width\/height in degrees.meta.notecharstc_polygonSpace-Time Coordinate (STC) representation of the image footprint in the sky. Numbers denote RA\/Dec pairs (in degrees) of four plate corners.meta.notecharwcsPart of FITS header that provides the World Coordinate System (WCS) of the astrometric solutionpos.wcschartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.phot_calibThis table contains data on photometric calibration that was carried out on whole scans and in annular bins. Unique Identifier calib_idcalib_idCalibration identification numbermeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshortcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatcolor_term_errError on color term of the platestat.error;stat.fit.paramfloatnum_bin_starsNumber of stars in the annular bin in which photometric calibration was carried outmeta.numberintnum_calib_starsNumber of stars that were actually used for photometric calibration in the annular binmeta.numberintnum_bright_starsNumber of bright stars that were actually used for photometric calibration in the annular bin. Bright-star calibration was handled separately and then merged with the calibration curve.meta.numberintnum_outliersNumber of stars that were found to be outliers of the photometric calibration curve in the annular binmeta.numberintbright_limitBrightest source magnitude in the plate natural photometric system in the image (annular bin < 9)magphot.mag;em.opt;stat.minfloatfaint_limitFaintest source magnitude in the plate natural photometric system in the image (annular bin < 9)magphot.mag;em.opt;stat.maxfloatmag_rangeMagnitude range between the brightest and faintest source magnitudes in the plate natural photometric system in the image (annular bin < 9)magphot.mag;em.opt;arith.difffloatrmse_minMinimum root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric system in the annular binmagstat.error;phot.mag;em.opt;stat.minfloatrmse_medianMedian root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric system in the annular binmagstat.error;phot.mag;em.opt;stat.medianfloatrmse_maxMaximum root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric system in the annular binmagstat.error;phot.mag;em.opt;stat.maxfloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.phot_colorThis table contains data on the determined color terms. Each row in the table corresponds to a scan of a photographic plate. Unique Identifier color_idcolor_idUnique identification number of the color termmeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatcolor_term_errError on color term of the platestat.error;stat.fit.paramfloatstdev_fitFitted minimum standard deviation of magnitude residuals for a range of trial color termsmagstat.stdev;phot.mag;em.optfloatstdev_minMinimum standard deviation of magnitude residuals for a range of trial color termsmagstat.stdev;phot.mag;em.optfloatcterm_minMinimum trial color term that was used for the final color term estimationstat.paramfloatcterm_maxMaximum trial color term that was used for the final color term estimationstat.paramfloatiterationIteration numbermeta.recordshortnum_starsNumber of stars that were used for the RMS error estimationmeta.numberinttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.phot_ctermFitting parameters for photometric calibration. This table contains standard deviations of residuals for each fit. Unique Identifier cterm_idcterm_idUnique identification number of the trial color termmeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintiterationIteration numbermeta.recordintctermTrial color term for fitting the photometric calibration curvestat.fit.paramfloatstdevStandard deviation of magnitude residuals after photometric calibration with a trial color term valuestat.fit.residualfloatnum_starsNumber of stars that were used for the RMS error estimationmeta.numberinttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.phot_subfieldThis table contains photometric error estimates for individual magnitude ranges in annular bins. Unique Identifier sub_idsub_idUnique sub-field identification numbermeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintphot_sub_gridGrid level for the current sub-field, expressed as the number of divisions of an image in one axis. Possible values: 2, 4, 8, 16, 32.meta.numbershortphot_sub_idHierarchical sub-field number, characterising the size and location of the sub-field in the image. 1 - lower left, 2 - lower right, 3 - top left, 4 - top right. First level (grid 2): 1, 2, 3, 4; second level (grid 4): 11, 12, 13, 14, 21, 22, ..., 44; third level (grid 8): 111, 112, 113, 114, 121, 122, ..., 444; fourth level (grid 16): 1111, 1112, ..., 4444; fifth level (grid 32): 11111, 11112, ..., 44444.meta.idintparent_sub_idHierarchical sub-field number for the parent sub-field (0 for grid level 2). Example: for sub-field 2134, the parent sub-field is 213.meta.idintx_minX-coordinate of the left edge of the sub-fieldpos.cartesian.x;stat.minfloatx_maxX-coordinate of the right edge of the sub-fieldpos.cartesian.x;stat.maxfloaty_minY-coordinate of the bottom edge of the sub-fieldpos.cartesian.y;stat.minfloaty_maxY-coordinate of the top edge of the sub-fieldpos.cartesian.y;stat.maxfloatnum_selected_starsNumber of selected stars for improving photometric calibration in the sub-fieldmeta.numberintabove_threshold1 if the number of selected stars is above threshold (50) for improving photometric calibration in the subfield, 0 otherwisemeta.codeshortnum_fit_starsNumber of stars actually used for improving photometric calibration in the sub-field (remaining after sigma clipping)meta.numberintcorrection_minMinimum magnitude correction that was applied in the current sub-fieldmagphot.mag;phot.calib;stat.minfloatcorrection_maxMaximum magnitude correction that was applied in the current sub-fieldmagphot.mag;phot.calib;stat.maxfloatnum_applied_starsNumber of stars in the sub-field to which the improved photometric calibration was appliedNonemeta.numberintrmse_minMinimum root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric system in the sub-fieldmagstat.error;phot.mag;em.opt;stat.minfloatrmse_medianMedian root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric system in the sub-fieldmagstat.error;phot.mag;em.opt;stat.medianfloatrmse_maxMaximum root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric system in the sub-fieldmagstat.error;phot.mag;em.opt;stat.maxfloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr3.astrom_subfieldThis table contains astrometric error estimates for individual magnitude ranges in annular bins. Unique Identifier sub_idsub_idUnique sub-field identification numbermeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintastrom_sub_gridmeta.numbershortastrom_sub_idmeta.numberintparent_sub_idHierarchical sub-field number for the parent sub-field (0 for grid level 2). Example: for sub-field 2134, the parent sub-field is 213.meta.idintx_minX-coordinate of the left edge of the sub-fieldpos.cartesian.x;stat.minfloatx_maxX-coordinate of the right edge of the sub-fieldpos.cartesian.x;stat.maxfloaty_minY-coordinate of the bottom edge of the sub-fieldpos.cartesian.y;stat.minfloaty_maxY-coordinate of the top edge of the sub-fieldpos.cartesian.y;stat.maxfloatx_min_extmeta.numberfloatx_max_extmeta.numberfloaty_min_extmeta.numberfloaty_max_extmeta.numberfloatnum_sub_starsmeta.numberintnum_ref_starsmeta.numberintabove_threshold1 if the number of stars and the number of reference stars in the extended sub-field are both above threshold (50) for improving astrometric calibration, 0 otherwiseNonemeta.codeshortnum_selected_ref_starsmeta.numberintscamp_crossid_radiusmeta.numberfloatnum_scamp_starsmeta.numberintscamp_sigma_axis1meta.numberfloatscamp_sigma_axis2meta.numberfloatscamp_sigma_meanmeta.numberfloatscamp_sigma_prev_axis1meta.numberfloatscamp_sigma_prev_axis2meta.numberfloatscamp_sigma_prev_meanmeta.numberfloatscamp_sigma_diffmeta.numberfloatapply_astrometrymeta.numbershortnum_applied_starsNumber of stars in the sub-field to which the improved astrometric calibration was appliedNonemeta.numberinttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2The APPLAUSE Data Release 2 contains metadata about photographic plates and data extracted from digitized plates.applause_dr2.archiveAn 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_idarchive_idArchive identification numbermeta.idintarchive_nameArchive namemeta.id;meta.datasetcharinstituteInstitute responsible for the archivemeta.id;instr.obstychartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharnum_platesintnum_previewsintnum_logpagesintnum_notesintnum_envelopesintnum_logbooksintapplause_dr2.plateThe 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.plate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintplate_numPlate number in archivemeta.record;instr.platecharplate_num_origOriginal plate number in archivemeta.record;instr.platecharwfpdb_idPlate identification in the Wide-Field Plate Databasemeta.idcharplate_aidAID of the platemeta.idcharpreview_aidAID of the plate previewmeta.idcharseriesPlate seriesmeta.idcharplate_formatPlate format (cm x cm)meta.code;phys.size;instr.platecharplate_size1Plate size along axis 1cmphys.size;instr.platefloatplate_size2Plate size along axis 2cmphys.size;instr.platefloatemulsionName of the photographic emulsioninstr.plate.emulsioncharfilterFilter type used during the observationinstr.filtercharspectral_bandSpectral bandpassinstr.bandpasschardevelopPlate development information (developer, time)meta.notecharplate_qualityQuality of the platemeta.code.qualcharplate_notesNotes about the platemeta.note;instr.platechardate_origOriginal recorded datetime.epoch;obs.exposurecharnumexpNumber of exposuresmeta.number;obs.sequenceshortobservatoryObservatory namemeta.id;instr.obstycharsite_namecharlongitude_degEast longitude of the observing site, in decimal degreesdegpos.earth.lon;instr.obstydoublelatitude_degLatitude of the observing site, in decimal degreesdegpos.earth.lat;instr.obstydoubleelevationElevation of the observatory sitempos.earth.altitude;instr.obstyfloattelescopeTelescope namemeta.id;instr.telchartel_aperClear aperture of the telescopemstat.value;instr.telfloattel_focFocal length of the telescopeminstr.tel.focalLengthfloattel_scalePlate scale of the telescopearcsec\/mminstr.scalefloatinstrumentInstrument namemeta.id;instrcharmethodObservation method. A list of possible values is given in the WFPDB.meta.codeshortprismInformation about the objective prism usedmeta.note;instrcharprism_angleAngle of the objective prism (deg:mm)stat.valuechardispersionDispersion (Angstrom / mm)0.1nm/mminstr.dispersionfloatgratingInformation about the grating usedmeta.note;instrcharair_temperaturefloatcalmnessCalmness (seeing conditions), scale 1-5 (German: Ruhe)obs.param;obs.atmoscharsharpnessSharpness, scale 1-5 (German: Schärfe)obs.param;obs.atmoschartransparencyTransparency, scale 1-5 (German: Durchsicht, Klarheit)obs.param;obs.atmoscharsky_conditionsNotes on sky conditions (from logbook)meta.note;obs.atmoscharobserverObserver nameobs.observercharobs_notesObserver notes (from logbook)meta.notecharnotesMiscellaneous notesmeta.notecharbibcodeBibcode of related papermeta.bib.bibcodecharfilename_previewName of the preview image filemeta.ref;meta.imagecharfilename_thumbnailName of the thumbnail image filemeta.ref;meta.filecharfilename_coverName of the plate cover (envelope) image filemeta.ref;meta.imagechartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.exposureExposure time and observation time for plates. Unique Identifier exposure_idexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintexposure_numExposure sequence number. For single exposures, the number is always 1.meta.recordshortobject_nameName of the observed object or fieldmeta.idcharobject_typeObject type, as listed in the WFPDBmeta.codecharra_origOriginal recorded right ascension of the telescope pointing (plate center)pos.eq.rachardec_origOriginal recorded declination of the telescope pointing (plate center)pos.eq.deccharflag_coordQuality flag of the recorded coordinates (right ascension and declination)meta.code.qualcharraj2000Right ascension of the source (equinox J2000)degpos.eq.radoubledej2000Declination of the source (equinox J2000)degpos.eq.decdoubleraj2000_hmsRight ascension of the plate center (equinox J2000) in sexagesimal formatpos.eq.rachardej2000_dmsDeclination of the image center (equinox J2000) in sexagesimal formatpos.eq.decchardate_orig_startOriginal recorded date of the exposure start (evening date)time.start;obs.exposurechardate_orig_endOriginal recorded date of the exposure end (evening date)time.end;obs.exposurechartime_orig_startOriginal recorded time of the exposure starttime.start;obs.exposurechartime_orig_endOriginal recorded time of the exposure endtime.end;obs.exposurecharflag_timeQuality flag of the recorded observation timemeta.code.qualcharut_startUT date and time of the exposure startTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharut_midUT date and time of the mid-point of exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_weightedUT date and time of the weighted mid-point of exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_endUT date and time of the exposure endTime[yyyy-mm-dd hh:mm:ss]time.end;obs.exposurecharyear_startDecimal Julian year of the start of exposuretime.start;obs.exposuredoubleyear_midDecimal Julian year of the mid-point of exposuretime.epoch;obs.exposuredoubleyear_weightedDecimal Julian year of the weighted mid-point of exposuretime.epoch;obs.exposuredoubleyear_endDecimal Julian year of the end of exposuretime.end;obs.exposuredoublejd_startJulian date at the start of exposuretime.start;obs.exposuredoublejd_midJulian date at the mid-point of exposuretime.epoch;obs.exposuredoublejd_weightedJulian date at the weighted mid-point of exposuretime.epoch;obs.exposuredoublejd_endJulian date at the end of exposuretime.end;obs.exposuredoublehjd_midHeliocentric Julian date at the mid-point of exposuretime.epoch;obs.exposuredoublehjd_weightedHeliocentric Julian date at the weighted mid-point of exposuretime.epoch;obs.exposuredoubleexptimeExposure timestime.interval;obs.exposurefloatnum_subNumber of sub-exposuresmeta.numbershortmethodObservation method. A list of possible values is given in the WFPDB.meta.codeshortfocusFocus value (from logbook)stat.valuefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.source_calibSources with calibrated magnitudes by pyplate. Calibration against UCAC4 and APASS. Unique Identifier source_idsource_idSource identification numbermeta.id;meta.mainlongprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshortdist_centerDistance of the source from plate centerpixpos.distancedoubledist_edgeDistance of the source from plate edgepixpos.distancedoublesextractor_flagsFlags given by SExtractormeta.codeshortraj2000Right ascension of the source (equinox J2000)degpos.eq.radoubledej2000Declination of the source (equinox J2000)degpos.eq.decdoublex_sphereSource x-coordinate on the unit spherepos.cartesian.xdoubley_sphereSource y-coordinate on the unit spherepos.cartesian.ydoublez_sphereSource z-coordinate on the unit spherepos.cartesian.zdoublehealpix256Source HEALPix number (nside=256, nested ordering)pos.healpixintraj2000_wcsRight ascension of the source based on WCS solution of the platedegpos.eq.radoubledej2000_wcsDeclination of the source based on WCS solution of the platedegpos.eq.decdoubleraj2000_subRight ascension of the source based on improved astrometric solution in a sub-fielddegpos.eq.radoubledej2000_subDeclination of the source based on improved astrometric solution in a sub-fielddegpos.eq.decdoubleraerr_subError for raj2000_subarcsecstat.error;pos.eq.rafloatdecerr_subError for dej2000_subarcsecstat.error;pos.eq.decfloatgridsize_subNumber of sub-fields along one axismeta.numbershortnn_distDistance to the nearest neighbor among extracted sourcesarcsecpos.angDistancefloatnatmagCalibrated magnitude of the source in the plate natural photometric systemmagphot.mag;em.optfloatnatmagerrEstimated error on the calibrated magnitude of the source in the plate natural photometric systemmagstat.error;phot.mag;em.optfloatbmagCalibrated B magnitude of the sourcemagphot.mag;em.opt.BfloatbmagerrEstimated error on the calibrated B magnitude of the sourcemagstat.error;phot.mag;em.opt.BfloatvmagCalibrated V magnitude of the sourcemagphot.mag;em.opt.VfloatvmagerrEstimated error on the calibrated V magnitude of the sourcemagstat.error;phot.mag;em.opt.Vfloatflag_calib_star1 if the source was used for photometric calibration, 0 otherwisemeta.codeshortflag_calib_outlier1 if the source was found to be an outlier of the photometric calibration curve, 0 otherwisemeta.codeshortcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatcolor_bvB-V color index of the source, based on the UCAC4 or Tycho-2 cataloguemagphot.color;em.opt.B;em.opt.Vfloatcat_natmagMagnitude of the source in the plate natural photometric system, B+color_term&times;(B-V), based on the UCAC4 or Tycho-2 cataloguemagphot.mag;em.optfloattycho2_idIdentification of the matched Tycho-2 catalogue objectmeta.id.crosschartycho2_raRight ascension from the Tycho-2 cataloguedegpos.eq.radoubletycho2_decDeclination from the Tycho-2 cataloguedegpos.eq.decdoubletycho2_btmagBT magnitude from the Tycho-2 cataloguemagphot.mag;em.opt.Bfloattycho2_vtmagVT magnitude from the Tycho-2 cataloguemagphot.mag;em.opt.Vfloattycho2_btmagerrError on BT magnitude from the Tycho-2 cataloguemagstat.error;phot.mag;em.opt.Bfloattycho2_vtmagerrError on VT magnitude from the Tycho-2 cataloguemagstat.error;phot.mag;em.opt.Vfloattycho2_hipIdentification of the matched HIPPARCOS catalogue objectmeta.id.crossinttycho2_distAngular distance between the source and the matched Tycho-2 catalogue objectarcsecpos.angDistancefloattycho2_dist2Distance between the source and the second-to-nearest Tycho-2 catalogue objectarcsecpos.angDistancefloattycho2_nn_distDistance between the source and its nearest neighbour in the Tycho-2 cataloguearcsecpos.angDistancefloatucac4_idIdentification of the matched UCAC4 catalogue objectmeta.id.crosscharucac4_raRight ascension from the UCAC4 cataloguedegpos.eq.radoubleucac4_decDeclination from the UCAC4 cataloguedegpos.eq.decdoubleucac4_bmagB magnitude from the UCAC4 cataloguemagphot.mag;em.opt.Bfloatucac4_vmagV magnitude from the UCAC4 cataloguemagphot.mag;em.opt.Vfloatucac4_bmagerrError on B magnitude from the UCAC4 cataloguemagstat.error;phot.mag;em.opt.Bfloatucac4_vmagerrError on V magnitude from the UCAC4 cataloguemagstat.error;phot.mag;em.opt.Vfloatucac4_distDistance between the source and the UCAC4 catalogue objectarcsecpos.angDistancefloatucac4_dist2Distance between the source and the second-to-nearest UCAC4 catalogue objectarcsecpos.angDistancefloatucac4_nn_distDistance between the source and its nearest neighbour in the UCAC4 cataloguearcsecpos.angDistancefloatapass_raRight ascension from the APASS DR9 cataloguedegpos.eq.radoubleapass_decRight ascension from the APASS DR9 cataloguedegpos.eq.radoubleapass_bmagB magnitude from the APASS DR9 cataloguemagphot.mag;em.opt.Bfloatapass_vmagV magnitude from the APASS DR9 cataloguemagphot.mag;em.opt.Vfloatapass_bmagerrError on B magnitude from the APASS DR9 cataloguemagstat.error;phot.mag;em.opt.Bfloatapass_vmagerrError on V magnitude from the APASS DR9 cataloguemagstat.error;phot.mag;em.opt.Vfloatapass_distDistance between the source and the APASS DR9 catalogue objectarcsecpos.angDistancefloatapass_dist2Distance between the source and the second-to-nearest APASS DR9 catalogue objectarcsecpos.angDistancefloatapass_nn_distDistance between the source and its nearest neighbour in the APASS DR9 cataloguearcsecpos.angDistancefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharposGIS index for (ra,dec)(radians,radians)pos;meta.numbercharapplause_dr2.exposure_subSub exposures provide exposures, which were split into n fragments. Unique Identifier exposure_idsubexposure_idSub-exposure identification numbermeta.id;meta.mainintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintexposure_numExposure sequence numbermeta.recordshortsubexposure_numSub-exposure sequence numbermeta.recordshortdate_orig_startOriginal recorded date of the sub-exposure (evening date)time.start;obs.exposurechartime_orig_startOriginal recorded start time of the sub-exposuretime.start;obs.exposurechartime_orig_endOriginal recorded end time of the sub-exposuretime.end;obs.exposurecharut_startUT date and time of the sub-exposure startTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharut_midUT date and time at the mid-point of sub-exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_endUT date and time of the sub-exposure endTime[yyyy-mm-dd hh:mm:ss]time.end;obs.exposurecharjd_startJulian date at the start of sub-exposuretime.start;obs.exposuredoublejd_midJulian date at the mid-point of sub-exposuretime.epoch;obs.exposuredoublejd_endJulian date at the end of sub-exposuretime.end;obs.exposuredoubleexptimeSub-exposure durationstime.interval;obs.exposurefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.lightcurveThis table contains calibrated magnitudes, sky coordinates and source designations, exposure and observation time. Unique Identifier source_id.source_idSource identification numbermeta.id;meta.mainlongprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintut_startUT date and time of the start of exposureTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharjd_startJulian date at the start of exposuretime.start;obs.exposuredoublejd_midJulian date at the mid-point of exposuretime.epoch;obs.exposuredoubleyear_midDecimal year of the mid-point of exposuretime.epoch;obs.exposuredoubleexptimeExposure timestime.interval;obs.exposurefloatraj2000Right ascension of the source (equinox J2000)degpos.eq.radoubledej2000Declination of the source (equinox J2000)degpos.eq.decdoubletycho2_idIdentification of the matched Tycho-2 catalogue objectmeta.id.crosscharucac4_idIdentification of the matched UCAC4 catalogue objectmeta.id.crosscharhealpix256Source HEALPix number (nside=256, nested ordering)pos.healpixintnatmagCalibrated magnitude of the source in the plate natural photometric systemmagphot.mag;em.optfloatnatmagerrEstimated error on the calibrated magnitude of the source in the plate natural photometric systemmagstat.error;phot.mag;em.optfloatbmagCalibrated B magnitude of the sourcemagphot.mag;em.opt.BfloatbmagerrEstimated error on the calibrated B magnitude of the sourcemagstat.error;phot.mag;em.opt.BfloatvmagCalibrated V magnitude of the sourcemagphot.mag;em.opt.VfloatvmagerrEstimated error on the calibrated V magnitude of the sourcemagstat.error;phot.mag;em.opt.Vfloatcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatcolor_bvB-V color index of the source, based on the UCAC4 or Tycho-2 cataloguemagphot.color;em.opt.B;em.opt.Vfloatannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshortnn_distDistance to the nearest neighbor among extracted sourcesarcsecpos.distancefloatsextractor_flagsFlags given by SExtractormeta.codeshortposGIS index for (ra,dec)(radians,radians)meta.numbercharapplause_dr2.scanThe scan table registers all ingested scans of the photographic plates, giving sizes, etc. Unique Identifier scan_idscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintscan_aidIdentification number for OAI/PMHmeta.idcharfilename_scanName of the scan filemeta.ref;meta.file;meta.notecharfilename_wedgeName of the wedge scan filemeta.ref;meta.file;meta.notecharnaxis1Length of data axis 1 (number of pixels in a row)meta.numbershortnaxis2Length of data axis 2 (number of rows)meta.numbershortminvalMinimum pixel value in the imagephot.count;stat.minintmaxvalMaximum pixel value in the imagephot.count;stat.maxintscannerName of the device used for digitizing the platemeta.idcharscan_res1Scan resolution along axis 1dpimeta.unitshortscan_res2Scan resolution along axis 2dpimeta.unitshortpixel_size1Pixel size along axis 1umphys.sizefloatpixel_size2Pixel size along axis 2umphys.sizefloatscan_softwareName of the scanning softwaremeta.id;meta.softwarecharscan_gammaScan gamma valuemeta.unitfloatscan_focusScan focus settingmeta.unitcharwedgeType of photometric step-wedgemeta.code;meta.crypticcharscan_dateScan date and timetime.epoch;time.creationcharscan_authorAuthor of the scanmeta.idcharscan_notesNotes about the scanmeta.notecharoriginInstitute responsible for the scanmeta.curation;instr.obstychartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.logbookInformation about logbooks from various archives or observation sites. There is no direct relation betweeen a plate and a logbook. Unique Identifier logpage_idlogbook_idLogbook identification numbermeta.idintarchive_idArchive identification numbermeta.idintlogbook_aidAID of the logbook or notesmeta.idcharlogbook_numLogbook number within the archivemeta.numbercharlogbook_titleLogbook titlemeta.titlecharlogbook_typeLogbook typemeta.codeshortlogbook_notesNotes about logbookmeta.notechartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.logpageThe logpage table contains data on individual digitized logbook pages and also images of plate covers/envelopes. Unique Identifier logpage_idlogpage_idLog-page identification numbermeta.idintlogbook_idLogbook identification numbermeta.idintarchive_idArchive identification numbermeta.idintlogpage_aidAID of the logpagemeta.idcharlogpage_typeLog-page type : 1 - plate directory (usually one row per plate), 2 - observation logbook (free text and notes), 3 - plate cover or envelope with handwritten or printed metadata, 4 - loose pages with notes or metadatameta.codeshortpage_numPage number in the logbookmeta.numbershortlogpage_orderLog-page order associated with the specific platemeta.crypticshortfilenameName of the processed filemeta.ref;meta.imagecharfile_formatFile formatmeta.code.class;meta.filecharimage_widthWidth in pixels of the digitized log-page imagephys.sizeshortimage_heightHeight in pixels of the digitized log-page imagemeta.number;phys.sizeshortimage_datetimeTime of creation of the digital imagemeta.number;phys.sizechartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.plate_logpageThe plate_logpage table stores links between plates and logbook pages / plate envelopes.plate_idPlate identification numbermeta.idintlogpage_idLog-page identification numbermeta.idintlogpage_orderLog-page order associated with the specific platemeta.crypticshorttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.processThe process table contains data on pyplate"s processing of source extraction and astrometric calibration of plate scans. Unique Identifier process_idprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintfilenameName of the processed filemeta.ref;meta.fitscharhostnameName of the computer that carried out the plate processmeta.idchartimestamp_startTimestamp of the start of processTime[yyyy-mm-dd hh:mm:ss]time.start;time.processingchartimestamp_endTimestamp of the end of processTime[yyyy-mm-dd hh:mm:ss]time.start;time.processingchardurationDuration of the processstime.durationintskySky background valuephot.count;em.optfloatsky_sigmaStandard deviation of the sky background valuestat.stdev;phot.count;em.optfloatuse_psf1 if PSF fitting was used in the process, 0 otherwisemeta.codeshortthresholdThreshold above which sources were detectedphot.count;em.optfloatnum_sourcesNumber of sources extracted from the imagemeta.numberintsolved1 if astrometric solution was found for the image, 0 otherwisemeta.code.statusshortnum_ucac4Number of matched UCAC4 catalogue objectsmeta.numberintnum_tycho2Number of matched Tycho-2 catalogue objectsmeta.numberintnum_apassNumber of matched APASS DR9 catalogue objectsmeta.numberintcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatbright_limitBrightest source magnitude in the plate natural photometric system in the image (annular bin < 9)magphot.mag;em.opt;stat.minfloatfaint_limitFaintest source magnitude in the plate natural photometric system in the image (annular bin < 9)magphot.mag;em.opt;stat.maxfloatmag_rangeMagnitude range between the brightest and faintest source magnitudes in the plate natural photometric system in the image (annular bin < 9)magphot.mag;em.opt;arith.difffloatcalibrated1 if photometric calibration was completed, 0 otherwisemeta.code.statusshortcompleted1 if process was completed, 0 otherwisemeta.code.statusshortpyplate_versionVersion number of the PyPlate software used for the processmeta.version;meta.softwarecharapplause_dr2.sourceTable of extracted sources. A row in the source table corresponds to an extracted source from a plate scan. Unique Identifier source_idsource_idSource identification numbermeta.id;meta.mainlongprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintsource_numSource number within the imagemeta.numberintx_sourceSource coordinate along x-axispos.cartesian.xdoubley_sourceSource coordinate along y-axispos.cartesian.ydoublea_sourceSemi-major axis length of the sourcepixphys.size.smajAxisfloatb_sourceSemi-minor axis length of the sourcepixphys.size.sminAxisfloattheta_sourcePosition angledegpos.posAngfloaterra_sourceUncertainty on the semi-major axis lengthpixstat.error;phys.size.smajAxisfloaterrb_sourceUncertainty on the semi-minor axis lengthpixstat.error;phys.size.sminAxisfloaterrtheta_sourceUncertainty on the position angledegstat.error;pos.posAngfloatelongationSource elongation (a_source / b_source)phys.size.axisRatiofloatx_peakSource peak (brightest pixel) coordinate along x-axispos.cartesian.xinty_peakSource peak (brightest pixel) coordinate along y-axispos.cartesian.yintflag_usepsf1 if source position has been determined by PSF fitting, 0 if barycenter has been usedmeta.codeshortx_imageSource barycenter coordinate along x-axispos.cartesian.xdoubley_imageSource barycenter coordinate along y-axispos.cartesian.ydoubleerra_imageUncertainty on the semi-major axis length (barycenter method)pixstat.error;phys.size.smajAxisfloaterrb_imageUncertainty on the semi-minor axis length (barycenter method)pixstat.error;phys.size.sminAxisfloaterrtheta_imageUncertainty on the position angle (barycenter method)degstat.error;pos.posAngfloatx_psfSource coordinate along x-axis, determined by PSF fittingpos.cartesian.xdoubley_psfSource coordinate along y-axis, determined by PSF fittingpos.cartesian.ydoubleerra_psfUncertainty on the semi-major axis length (PSF fitting)pixstat.error;phys.size.smajAxisfloaterrb_psfUncertainty on the semi-minor axis length (PSF fitting)pixstat.error;phys.size.sminAxisfloaterrtheta_psfUncertainty on the position angle (PSF fitting)degstat.error;pos.posAngfloatmag_autoKron-like elliptical aperture magnitudemagphot.magfloatmagerr_autoError for mag_automagstat.error;phot.magfloatflux_autoFlux within a Kron-like elliptical aperturephot.countfloatfluxerr_autoError for flux_autostat.error;phot.countfloatmag_isoIsophotal magnitudemagphot.magfloatmagerr_isoError for isophotal magnitudemagstat.error;phot.magfloatflux_isoIsophotal fluxphot.countfloatfluxerr_isoError for isophotal fluxstat.error;phot.countfloatflux_maxPeak flux above backgroundphot.countfloatflux_radiusFraction-of-light radiuspixstat.valuefloatisoareaIsophotal area above thresholdpix2stat.valueintsqrt_isoareaSquare root of the isophotal area above thresholdpixstat.valuefloatbackgroundBackground valuestat.valuefloatsextractor_flagsFlags given by SExtractormeta.codeshortdist_centerDistance of the source from plate centerpixpos.distancedoubledist_edgeDistance of the source from plate edgepixpos.distancedoubleannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshortflag_rim1 if source is found to be at plate rim, 0 otherwisemeta.codeshortflag_negradius1 if flux_radius is negative, 0 otherwisemeta.codeshortflag_clean1 if source is not at the rim, flux_radius is not negative, and elongation < 5, 0 otherwisemeta.codeshorttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.solutionThe table contains astrometric solutions of plate scans. Unique Identifier solution_idsolution_idAstrometric solution identification numbermeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintraj2000Right ascension of the source (equinox J2000)degpos.eq.radoubledej2000Declination of the source (equinox J2000)degpos.eq.decdoubleraj2000_hmsRight ascension of the plate center (equinox J2000) in sexagesimal formatpos.eq.rachardej2000_dmsDeclination of the image center (equinox J2000) in sexagesimal formatpos.eq.deccharfov1Field of view along axis 1degpos.angDistance;instr.fovfloatfov2Field of view along axis 1degpos.angDistance;instr.fovfloatpixel_scaleMean pixel scale for the imagearcsec / pixpos.wcs.scalefloatsource_densityNumber of sources per square degree in the central 2/3 of the imagemeta.numberfloatcd1_1Transformation matrix elementpos.wcs.cdmatrixdoublecd1_2Transformation matrix elementpos.wcs.cdmatrixdoublecd2_1Transformation matrix elementpos.wcs.cdmatrixdoublecd2_2Transformation matrix elementpos.wcs.cdmatrixdoublerotation_angleImage rotation anglepos.posAngfloatplate_mirrored1 if image is mirrored, 0 otherwisemeta.codeshortncp_on_plate1 if North Celestial Pole is in the image, 0 otherwisemeta.codeshortscp_on_plate1 if South Celestial Pole is in the image, 0 otherwisemeta.codeshortstc_boxSpace-Time Coordinate (STC) representation of the image footprint in the sky. Numbers denote plate center coordinates (RA, Dec) and box (width/height) in degrees.meta.codecharstc_polygonSpace-Time Coordinate (STC) representation of the image footprint in the sky. Numbers denote (RA,Dec) pairs (in degrees) of four plate corners.meta.codecharwcsPart of FITS header that provides the World Coordinate System (WCS) of the astrometric solutionpos.wcschartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.phot_calibThis table contains data on photometric calibration that was carried out on whole scans and in annular bins. Unique Identifier calib_idcalib_idCalibration identification numbermeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintannular_binAnnular bin (1-9) on the scanned photographic plate (bin 1 is in the center, bin 9 is at the edge). Bin 0 refers to the whole image.meta.codeshortcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatcolor_term_errError on color term of the platestat.error;stat.fit.paramfloatnum_bin_starsNumber of stars in the annular bin in which photometric calibration was carried outmeta.numberintnum_calib_starsNumber of stars that were actually used for photometric calibration in the annular binmeta.numberintnum_bright_starsNumber of bright stars that were actually used for photometric calibration in the annular bin. Bright-star calibration was handled separately and then merged with the calibration curve.meta.numberintnum_outliersNumber of stars that were found to be outliers of the photometric calibration curve in the annular binmeta.numberintbright_limitBrightest source magnitude in the plate natural photometric system in the annular binmagphot.mag;em.opt;stat.minfloatfaint_limitFaintest source magnitude in the plate natural photometric system in the annular binmagphot.mag;em.opt;stat.maxfloatmag_rangeMagnitude range between the brightest and faintest source magnitudes in the plate natural photometric system in the annular binmagphot.mag;em.opt;arith.difffloatrmse_minMinimum root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric system in the annular binmagstat.error;phot.mag;em.opt;stat.minfloatrmse_medianMedian root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric system in the annular binmagstat.error;phot.mag;em.opt;stat.medianfloatrmse_maxMaximum root-mean-square (RMS) error estimate for magnitudes in the plate natural photometric system in the annular binmagstat.error;phot.mag;em.opt;stat.maxfloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.phot_colorThis table contains data on the determined color terms. Each row in the table corresponds to a scan of a photographic plate. Unique Identifier color_idcolor_idUnique identification number of the color termmeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintcolor_termColor term of the plate, characterizing color response of the emulsion and filter usedstat.fit.paramfloatcolor_term_errError on color term of the platestat.error;stat.fit.paramfloatstdev_fitFitted minimum standard deviation of magnitude residuals for a range of trial color termsmagstat.stdev;phot.mag;em.optfloatstdev_minMinimum standard deviation of magnitude residuals for a range of trial color termsmagstat.stdev;phot.mag;em.optfloatcterm_minMinimum trial color term that was used for the final color term estimationstat.paramfloatcterm_maxMaximum trial color term that was used for the final color term estimationstat.paramfloatiterationIteration number at which the final color term was determinedstat.paramshortnum_starsNumber of stars that were used for the final color term estimationmeta.numberinttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.phot_ctermFitting parameters for photometric calibration. This table contains standard deviations of residuals for each fit. Unique Identifier cterm_idcterm_idUnique identification number of the trial color termmeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintiterationIteration numbermeta.recordintctermTrial color term for fitting the photometric calibration curvestat.fit.paramfloatstdevStandard deviation of magnitude residuals after photometric calibration with a trial color term valuestat.fit.residualfloatnum_starsNumber of stars used for fitting photometric calibration curve with the trial color termmeta.numberinttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.phot_rmseThis table contains photometric error estimates for individual magnitude ranges in annular bins. Unique Identifier sub_idrmse_idUnique identification number of photometric error estimatemeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintannular_binAnnular bin (1-9) on the scanned photographic plate (bin 1 is in the center, bin 9 is at the edge). Bin 0 refers to the whole image.meta.codeshortplate_magUncalibrated magnitude (like mag_auto in the source table)magphot.mag;em.optfloatrmseRoot-mean-square (RMS) error of the calibrated magnitude in the plate natural photometric systemmagstat.error;phot.mag;em.optfloatmag_windowRange of uncalibrated magnitudes in which the RMS error was estimatedmagstat.value;phot.mag;em.optfloatnum_starsNumber of stars that were used for the RMS error estimationmeta.numberinttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr2.healpixHEALPix center coordinates (nside=256, nested scheme)healpix256HEALPix center coordinates (nside=256, nested scheme)pos.healpixintraj2000Right ascension of HEALPix centerdegpos.eq.radoubledej2000Declination of HEALPix centerdegdoubleapplause_dr1The APPLAUSE Data Release 1 contains metadata about photographic plates and data extracted from digitized plates.applause_dr1.archiveAn 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_idarchive_idArchive identification numbermeta.id;meta.mainintarchive_nameArchive namemeta.id;meta.datasetcharinstituteInstitute responsible for the archivemeta.id;instr.obstychartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharnum_platesintnum_previewsintnum_logpagesintnum_notesintnum_envelopesintnum_logbooksintapplause_dr1.plateThe 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_idplate_idPlate identification numbermeta.id;meta.mainintarchive_idArchive identification numbermeta.idintplate_numPlate number in archivemeta.record;instr.platecharplate_num_origOriginal plate number in archivemeta.record;instr.platecharwfpdb_idPlate identification in the Wide-Field Plate Databasemeta.idcharseriesPlate seriesmeta.idcharplate_formatPlate format (cm x cm)meta.code;phys.size;instr.platecharplate_size1Plate size along axis 1cmphys.size;instr.platefloatplate_size2Plate size along axis 2cmphys.size;instr.platefloatemulsionName of the photographic emulsioninstr.plate.emulsioncharfilterFilter type used during the observationinstr.filtercharspectral_bandSpectral bandpassinstr.bandpasschardevelopPlate development information (developer, time)meta.notecharplate_qualityQuality of the platemeta.code.qualcharplate_notesNotes about the platemeta.note;instr.platechardate_origOriginal recorded datetime.epoch;obs.exposurecharnumexpNumber of exposuresmeta.number;obs.sequenceshortobservatoryObservatory namemeta.id;instr.obstycharsite_namecharlongitude_degEast longitude of the observing site, in decimal degreesdegpos.earth.lon;instr.obstydoublelatitude_degLatitude of the observing site, in decimal degreesdegpos.earth.lat;instr.obstydoubleelevationElevation of the observatory sitempos.earth.altitude;instr.obstyfloattelescopeTelescope namemeta.id;instr.telchartel_aperClear aperture of the telescopemstat.value;instr.telfloattel_focFocal length of the telescopeminstr.tel.focalLengthfloattel_scalePlate scale of the telescopearcsec / mminstr.scalefloatplate_fov1Field of view along axis 1degpos.angDistance;instr.fovfloatplate_fov2Field of view along axis 2degpos.angDistance;instr.fovfloatinstrumentInstrument namemeta.id;instrcharmethodObservation method. A list of possible values is given in the WFPDB.meta.codeshortprismInformation about the objective prism usedmeta.note;instrcharprism_angleAngle of the objective prism (degstat.valuechardispersionDispersion (Angstrom / mm)0.1nm/mminstr.dispersionfloatgratingInformation about the grating usedmeta.note;instrcharair_temperaturefloatcalmnessCalmness (seeing conditions), scale 1-5 (German: Ruhe)obs.param;obs.atmoscharsharpnessSharpness, scale 1-5 (German: Schärfe)obs.param;obs.atmoschartransparencyTransparency, scale 1-5 (German: Durchsicht, Klarheit)obs.param;obs.atmoscharsky_conditionsNotes on sky conditions (from logbook)meta.note;obs.atmoscharobserverObserver nameobs.observercharobs_notesObserver notes (from logbook)meta.notecharnotesMiscellaneous notesmeta.notecharbibcodeBibcode of related papermeta.bib.bibcodecharfilename_previewName of the preview image filemeta.ref;meta.imagecharfilename_thumbnailName of the thumbnail image filemeta.ref;meta.filecharfilename_coverName of the plate cover (envelope) image filemeta.ref;meta.imagechartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr1.exposureExposure time and observation time for plates. Unique Identifier exposure_idexposure_idExposure identification numbermeta.id;meta.mainintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintexposure_numExposure number within the platemeta.recordshortobject_nameName of the observed object or fieldmeta.idcharobject_typeObject type, as listed in the WFPDBmeta.codecharra_origOriginal recorded right ascension of the telescope pointing (plate center)pos.eq.rachardec_origOriginal recorded declination of the telescope pointing (plate center)pos.eq.deccharflag_coordQuality flag of the recorded coordinates (right ascension and declination)meta.code.qualcharraj2000Right ascension of the telescope pointing in decimal degrees (equinox J2000)degpos.eq.radoubledej2000Declination of the telescope pointing in decimal degrees (equinox J2000)degpos.eq.decdoubleraj2000_hmsRight ascension of the telescope pointing (equinox J2000, sexagesimal format "h:m:s")pos.eq.rachardej2000_dmsDeclination of the telescope pointing (equinox J2000, sexagesimal format "d:m:s")pos.eq.deccharflag_wcs1 if coordinates are taken from WCS solution, 0 otherwisemeta.codeshortdate_orig_startOriginal recorded date of the start of observation (evening date)time.start;obs.exposurechardate_orig_endOriginal recorded date of the end of observation (evening date)time.end;obs.exposurechartime_orig_startOriginal recorded time of the start of the observation (format "TZ hh:mm:ss", where TZ is time zone). Time zone can be "ST" (sidereal time), "UT" (universal time), or any time zone. Multiple time notations are separated with commas.time.start;obs.exposurechartime_orig_endOriginal recorded time of the end of the observationtime.end;obs.exposurecharflag_timeQuality flag of the recorded observation time: "error","missing", "uncertain"meta.code.qualcharut_startUT date and time of the start of exposureTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharut_midUT date and time of the mid-point of exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_weightedUT date and time of the weighted mid-point of exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_endUT date and time of the end of exposureTime[yyyy-mm-dd hh:mm:ss]time.end;obs.exposurecharyear_startDecimal year of the start of exposuretime.start;obs.exposuredoubleyear_midDecimal year of the mid-point of exposuretime.epoch;obs.exposuredoubleyear_weightedDecimal year of the weighted mid-point of exposuretime.epoch;obs.exposuredoubleyear_endDecimal year of the end of exposuretime.end;obs.exposuredoublejd_startJulian date at the start of exposuretime.start;obs.exposuredoublejd_midJulian date at the mid-point of exposuretime.epoch;obs.exposuredoublejd_weightedJulian date at the weighted mid-point of exposuretime.epoch;obs.exposuredoublejd_endJulian date at the end of exposuretime.end;obs.exposuredoublehjd_midHeliocentric Julian date at the mid-point of exposuretime.epoch;obs.exposuredoublehjd_weightedHeliocentric Julian date at the weighted mid-point of exposuretime.epoch;obs.exposuredoubleexptimeExposure timestime.interval;obs.exposurefloatnum_subNumber of sub-exposuresmeta.numbershortmethodObservation method. A list of possible values is given in the WFPDB.meta.codeshortfocusFocus value (from logbook)stat.valuefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr1.exposure_subSub exposures provide exposures, which were split into n fragments. Unique Identifier exposure_idexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintexposure_numExposure sequence numbermeta.recordshortsubexposure_numSub-exposure sequence numbermeta.recordshortdate_orig_startOriginal recorded date of the sub-exposure (evening date)time.start;obs.exposurechartime_orig_startOriginal recorded start time of the sub-exposuretime.start;obs.exposurechartime_orig_endOriginal recorded end time of the sub-exposuretime.end;obs.exposurecharut_startUT date and time of the start of exposureTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharut_midUT date and time at the mid-point of sub-exposureTime[yyyy-mm-dd hh:mm:ss]time.epoch;obs.exposurecharut_endUT date and time of the sub-exposure endTime[yyyy-mm-dd hh:mm:ss]time.end;obs.exposurecharjd_startJulian date at the start of exposuretime.start;obs.exposuredoublejd_midJulian date at the mid-point of exposuretime.epoch;obs.exposuredoublejd_endJulian date at the end of sub-exposuretime.end;obs.exposuredoubleexptimeExposure timestime.interval;obs.exposurefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr1.scanThe scan table registers all ingested scans of the photographic plates, giving sizes, etc. Unique Identifier scan_idscan_idScan identification numbermeta.id;meta.mainintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintfilename_scanName of the scan filemeta.ref;meta.file;meta.notecharfilename_wedgeName of the wedge scan filemeta.ref;meta.file;meta.notecharnaxis1Length of data axis 1 (number of pixels in a row)meta.numbershortnaxis2Length of data axis 2 (number of rows)meta.numbershortminvalMinimum pixel value in the imagephot.count;stat.minintmaxvalMaximum pixel value in the imagephot.count;stat.maxintscannerName of the device used for digitizing the platemeta.idcharscan_res1Scan resolution along axis 1dpimeta.unitshortscan_res2Scan resolution along axis 2dpimeta.unitshortpixel_size1Pixel size along axis 1umphys.sizefloatpixel_size2Pixel size along axis 2umphys.sizefloatscan_softwareName of the scanning softwaremeta.id;meta.softwarecharscan_gammaScan gamma valuemeta.unitfloatscan_focusScan focus settingmeta.unitcharwedgeType of photometric step-wedgemeta.code;meta.crypticcharscan_dateScan date and timetime.epoch;time.creationcharscan_authorAuthor of the scanmeta.idcharscan_notesNotes about the scanmeta.notecharoriginInstitute responsible for the scanmeta.curation;instr.obstychartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr1.sourceTable of extracted sources. A row in the source table corresponds to an extracted source from a plate scan. Unique Identifier source_idsource_idSource identification numbermeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintsource_numSource number within the imagemeta.numberintx_sourceSource coordinate along x-axispos.cartesian.xdoubley_sourceSource coordinate along y-axispos.cartesian.ydoubleerra_sourceUncertainty on the semi-major axis lengthpixstat.error;phys.size.smajAxisfloaterrb_sourceUncertainty on the semi-minor axis lengthpixstat.error;phys.size.sminAxisfloaterrtheta_sourceUncertainty on the position angledegstat.error;pos.posAngfloata_sourceSemi-major axis length of the sourcepixphys.size.smajAxisfloatb_sourceSemi-minor axis length of the sourcepixphys.size.sminAxisfloattheta_sourcePosition angledegpos.posAngfloatelongationSource elongation (a_source / b_source)phys.size.axisRatiofloatx_peakSource peak (brightest pixel) coordinate along x-axispos.cartesian.xinty_peakSource peak (brightest pixel) coordinate along y-axispos.cartesian.yintflag_usepsf1 if source position has been determined by PSF fitting, 0 if barycenter has been usedmeta.codeshortx_imageSource barycenter coordinate along x-axispos.cartesian.xdoubley_imageSource barycenter coordinate along y-axispos.cartesian.ydoubleerra_imageUncertainty on the semi-major axis length (barycenter method)pixstat.error;phys.size.smajAxisfloaterrb_imageUncertainty on the semi-minor axis length (barycenter method)pixstat.error;phys.size.sminAxisfloaterrtheta_imageUncertainty on the position angle (barycenter method)degstat.error;pos.posAngfloatx_psfSource coordinate along x-axis, determined by PSF fittingpos.cartesian.xdoubley_psfSource coordinate along y-axis, determined by PSF fittingpos.cartesian.ydoubleerra_psfUncertainty on the semi-major axis length (PSF fitting)pixstat.error;phys.size.smajAxisfloaterrb_psfUncertainty on the semi-minor axis length (PSF fitting)pixstat.error;phys.size.sminAxisfloaterrtheta_psfUncertainty on the position angle (PSF fitting)degstat.error;pos.posAngfloatmag_autoKron-like elliptical aperture magnitudemagphot.magfloatmagerr_autoError for mag_automagstat.error;phot.magfloatflux_autoFlux within a Kron-like elliptical aperturephot.countfloatfluxerr_autoError for flux_autostat.error;phot.countfloatmag_isoIsophotal magnitudemagphot.magfloatmagerr_isoError for isophotal magnitudemagstat.error;phot.magfloatflux_isoIsophotal fluxphot.countfloatfluxerr_isoError for isophotal fluxstat.error;phot.countfloatflux_maxPeak flux above backgroundphot.countfloatflux_radiusFraction-of-light radiuspixstat.valuefloatisoareaIsophotal area above thresholdpix2stat.valueintsqrt_isoareaSquare root of the isophotal area above thresholdpixstat.valuefloatbackgroundBackground valuestat.valuefloatsextractor_flagsFlags given by SExtractormeta.codeshortdist_centerDistance of the source from plate centerpixpos.distancedoubledist_edgeDistance of the source from plate edgepixpos.distancedoubleannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshortflag_rim1 if source is found to be at plate rim, 0 otherwisemeta.codeshortflag_negradius1 if flux_radius is negative, 0 otherwisemeta.codeshortflag_clean1 if source is not at the rim, flux_radius is not negative, and elongation < 5, 0 otherwisemeta.codeshorttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr1.source_calibSources without magnitudes by pyplate. Unique Identifier source_idsource_idSource identification numbermeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintraj2000Right ascension of the source (equinox J2000)degpos.eq.radoubledej2000Declination of the source (equinox J2000)degpos.eq.decdoublex_sphereSource x-coordinate on the unit spherepos.cartesian.xdoubley_sphereSource y-coordinate on the unit spherepos.cartesian.ydoublez_sphereSource z-coordinate on the unit spherepos.cartesian.zdoublehealpix256Source HEALPix number (nside=256, nested ordering)pos.healpixintraj2000_wcsRight ascension of the source based on WCS solution of the platedegpos.eq.radoubledej2000_wcsDeclination of the source based on WCS solution of the platedegpos.eq.decdoubleraj2000_subRight ascension of the source based on improved astrometric solution in a sub-fielddegpos.eq.radoubledej2000_subDeclination of the source based on improved astrometric solution in a sub-fielddegpos.eq.decdoubleraerr_subError for raj2000_subdegstat.error;pos.eq.rafloatdecerr_subError for dej2000_subdegstat.error;pos.eq.decfloatgridsize_subNumber of sub-fields along one axismeta.numbershortbmagCalibrated B magnitude of the source (not available in DR1)magphot.mag;em.opt.Bfloaterr_bmagError for B magnitude (not available in DR1)magstat.error;phot.mag;em.opt.BfloatvmagCalibrated V magnitude of the source (not available in DR1)magphot.mag;em.opt.Vfloaterr_vmagError for V magnitude (not available in DR1)magstat.error;phot.mag;em.opt.Vfloattycho2_idIdentification of the matched Tycho-2 catalogue objectmeta.id.crosschartycho2_btmagBT magnitude from the Tycho-2 cataloguemagphot.mag;em.opt.Bfloattycho2_vtmagVT magnitude from the Tycho-2 cataloguemagphot.mag;em.opt.Vfloattycho2_hipIdentification of the matched HIPPARCOS catalogue objectmeta.id.crossinttycho2_distDistance between the source and the Tycho-2 catalogue objectarcsecpos.angDistancefloatucac4_idIdentification of the matched UCAC4 catalogue objectmeta.id.crosscharucac4_bmagB magnitude from the UCAC4 cataloguemagphot.mag;em.opt.Bfloatucac4_vmagV magnitude from the UCAC4 cataloguemagphot.mag;em.opt.Vfloatucac4_distDistance between the source and the UCAC4 catalogue objectarcsecpos.angDistancefloattimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharposGIS index for (ra,dec)(radians,radians)meta.numbercharapplause_dr1.raw_lightcurveThis table contains raw magnitudes (from source table), sky coordinates and source designations, exposure and observation time. Unique Identifier source_id.rlc_idUnique ID for tablemeta.id;meta.mainintsource_idSource identification numbermeta.idintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintut_startUT date and time of the start of exposureTime[yyyy-mm-dd hh:mm:ss]time.start;obs.exposurecharjd_startJulian date at the start of exposuretime.start;obs.exposuredoublejd_midJulian date at the mid-point of exposuretime.epoch;obs.exposuredoubleexptimeExposure timestime.interval;obs.exposurefloatraj2000Right ascension of the source (equinox J2000)degpos.eq.radoubledej2000Declination of the source (equinox J2000)degpos.eq.decdoubletycho2_idIdentification of the matched Tycho-2 catalogue objectmeta.id.crosscharucac4_idIdentification of the matched UCAC4 catalogue objectmeta.id.crosscharhealpix256Source HEALPix number (nside=256, nested ordering)pos.healpixintmag_autoKron-like elliptical aperture magnitudemagphot.magfloatmagerr_autoError for mag_automagstat.error;phot.magfloatannular_binAnnular bin (1-9) where the source belongs (bin 1 is in the center, bin 9 is at the edge)meta.codeshorttimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharposGIS index for (ra,dec)(radians,radians)meta.numbercharapplause_dr1.logbookInformation about logbooks from various archives or observation sites. There is no direct relation betweeen a plate and a logbook. Unique Identifier logpage_idlogbook_idLogbook identification numbermeta.id;meta.mainintarchive_idArchive identification numbermeta.idintlogbook_numLogbook number within the archivemeta.numbercharlogbook_titleLogbook titlemeta.titlecharlogbook_typeLogbook typemeta.codeshortlogbook_notesNotes about logbookmeta.notechartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr1.logpageThe logpage table contains data on individual digitized logbook pages and also images of plate covers/envelopes. Unique Identifier logpage_idlogpage_idLog-page identification numbermeta.id;meta.mainintlogbook_idLogbook identification numbermeta.idintarchive_idArchive identification numbermeta.idintlogpage_typeLog-page type : 1 - plate directory (usually one row per plate), 2 - observation logbook (free text and notes), 3 - plate cover or envelope with handwritten or printed metadata, 4 - loose pages with notes or metadatameta.codeshortpage_numPage number in the logbookmeta.numbershortlogpage_orderPage order in the logbookmeta.crypticshortfilenameName of the log-page image filemeta.ref;meta.imagecharfile_formatFile formatmeta.code.class;meta.filecharimage_widthWidth in pixels of the digitized log-page imagephys.sizeshortimage_heightHeight in pixels of the digitized log-page imagemeta.number;phys.sizeshortimage_datetimeTime of creation of the digital imagemeta.number;phys.sizechartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr1.plate_logpageThe plate_logpage table stores links between plates and logbook pages / plate envelopes.plate_idPlate identification numbermeta.idintlogpage_idLog-page identification numbermeta.idintlogpage_orderLog-page order associated with the specific platemeta.crypticshorttimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr1.processThe process table contains data on pyplate"s processing of source extraction and astrometric calibration of plate scans. Unique Identifier process_idprocess_idProcess identification numbermeta.id;meta.mainintscan_idScan identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintfilenameName of the processed filemeta.ref;meta.fitscharhostnameName of the computer that carried out the plate processmeta.idchartimestamp_startTimestamp of the start of processTime[yyyy-mm-dd hh:mm:ss]time.start;time.processingchartimestamp_endTimestamp of the end of processTime[yyyy-mm-dd hh:mm:ss]time.start;time.processingchardurationDuration of the processstime.durationintskySky background valuephot.count;em.optfloatsky_sigmaStandard deviation of the sky background valuestat.stdev;phot.count;em.optfloatuse_psf1 if PSF fitting was used in the process, 0 otherwisemeta.codeshortthresholdThreshold above which sources were detectedphot.count;em.optfloatnum_sourcesNumber of sources extracted from the imagemeta.numberintsolved1 if astrometric solution was found for the image, 0 otherwisemeta.code.statusshortnum_ucac4Number of matched UCAC4 catalogue objectsmeta.numberintnum_tycho2Number of matched Tycho-2 catalogue objectsmeta.numberintcompleted1 if process was completed, 0 otherwisemeta.code.statusshortpyplate_versionVersion number of the PyPlate software used for the processmeta.version;meta.softwarecharapplause_dr1.solutionThe table contains astrometric solutions of plate scans. Unique Identifier solution_idsolution_idAstrometric solution identification numbermeta.id;meta.mainintprocess_idProcess identification numbermeta.idintscan_idScan identification numbermeta.idintexposure_idExposure identification numbermeta.idintplate_idPlate identification numbermeta.idintarchive_idArchive identification numbermeta.idintraj2000Right ascension of the plate center (equinox J2000)degpos.eq.radoubledej2000Declination of the image center (equinox J2000)degpos.eq.decdoubleraj2000_hmsRight ascension of the plate center (equinox J2000) in sexagesimal formatpos.eq.rachardej2000_dmsDeclination of the image center (equinox J2000) in sexagesimal formatpos.eq.deccharfov1Field of view along axis 1degpos.angDistance;instr.fovfloatfov2Field of view along axis 1degpos.angDistance;instr.fovfloatpixel_scaleMean pixel scale for the imagearcsec / pixpos.wcs.scalefloatsource_densityNumber of sources per square degree in the central 2/3 of the imagemeta.numberfloatcd1_1Transformation matrix elementpos.wcs.cdmatrixdoublecd1_2Transformation matrix elementpos.wcs.cdmatrixdoublecd2_1Transformation matrix elementpos.wcs.cdmatrixdoublecd2_2Transformation matrix elementpos.wcs.cdmatrixdoublerotation_angleImage rotation anglepos.posAngfloatplate_mirrored1 if image is mirrored, 0 otherwisemeta.codeshortncp_on_plate1 if North Celestial Pole is in the image, 0 otherwisemeta.codeshortscp_on_plate1 if South Celestial Pole is in the image, 0 otherwisemeta.codeshortstc_boxSpace-Time Coordinate (STC) representation of the image footprint in the sky. Numbers denote plate center coordinates (RA, Dec) and box (width|height) in degrees.meta.codecharstc_polygonSpace-Time Coordinate (STC) representation of the image footprint in the sky. Numbers denote (RA,Dec) pairs (in degrees) of four plate corners.meta.codecharwcsPart of FITS header that provides the World Coordinate System (WCS) of the astrometric solutionpos.wcschartimestamp_insertTimestamp of insertTime[yyyy-mm-dd hh:mm:ss]time.creationchartimestamp_updateTimestamp of last updateTime[yyyy-mm-dd hh:mm:ss]time.creationcharapplause_dr1.healpixHEALPix center coordinates (nside=256, nested scheme)healpix256HEALPix number (nside=256, nested scheme)pos.healpixintraj2000Right ascension of HEALPix centerdegpos.eq.radoubledej2000Declination of HEALPix centerdegpos.eq.dedouble