Archives of Photographic PLates for Astronomical USE

Logpage table (applause_dr1.logpage)

The table has 26526 rows, 13 columns.

Description

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

Attribution

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

Funding for APPLAUSE has been provided by DFG (German Research Foundation, Grant), Leibniz Institute for Astrophysics Potsdam (AIP), Dr. Remeis Sternwarte Bamberg (University Nuernberg/Erlangen) and the Hamburger Sternwarte (University of Hamburg).

Columns

Name Type UCD Unit Description
logpage_id int meta.id
meta.main
Log-page identification number
logbook_id int meta.id Logbook identification number
archive_id int meta.id 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.cryptic Page order in the logbook
filename char meta.ref
meta.image
Name of the log-page image file
file_format char meta.code.class
meta.file
File format
image_width short phys.size Width in pixels of the digitized log-page image
image_height short meta.number
phys.size
Height in pixels of the digitized log-page image
image_datetime timestamp meta.number
phys.size
Time of creation of the digital image
timestamp_insert timestamp time.creation Time[yyyy-mm-dd hh:mm:ss] Timestamp of insert
timestamp_update timestamp time.creation Time[yyyy-mm-dd hh:mm:ss] Timestamp of last update