Archives of Photographic PLates for Astronomical USE

Logbook pages and plate envelopes (applause_dr4.logpage)

The table has 113960 rows, 15 columns.


The logpage table contains data on individual digitized logbook pages and also images of plate covers/envelopes. The plate-logpage associations are stored in the plate_logpage table. Unique Identifier logpage_id


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

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


Name Type UCD Unit Description
logpage_id int
Log-page identification number
logbook_id int Logbook identification number
archive_id int Archive identification number
logpage_type short meta.code Log-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 metadata
page_num short meta.number Page number in the logbook
logpage_order short meta.record Log-page order associated with the specific plate
filename char meta.ref
Name of the logpage file
file_format char meta.code.class
File format
image_width short meta.number
Width in pixels of the digitized log-page image
image_height short meta.number
Height in pixels of the digitized log-page image
image_datetime char time.creation
Time[yyyy-mm-dd hh:mm:ss] Time of creation of the digital image (from Exif metadata)
file_datetime char time.creation
Time[yyyy-mm-dd hh:mm:ss] Timestamp of the last change of file
file_size int meta.number
byte File size
timestamp_insert char time.creation Time[yyyy-mm-dd hh:mm:ss] Timestamp of insert
timestamp_update char time.creation Time[yyyy-mm-dd hh:mm:ss] Timestamp of last update