Archives of Photographic PLates for Astronomical USE

Logbook pages and plate envelopes (applause_dr3.logpage)

The table has 96852 rows, 15 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 DR3, kindly include this acknowledgement

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

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.record

Log-page order associated with the specific plate

filename char meta.ref
meta.file

Name of the logpage file

file_format char meta.code.class
meta.file

File format

image_width short meta.number
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 char time.creation
meta.file
Time[yyyy-mm-dd hh:mm:ss]

Time of creation of the digital image (from Exif metadata)

file_datetime char time.creation
meta.file
Time[yyyy-mm-dd hh:mm:ss]

Timestamp of the last change of file

file_size int meta.number
meta.file
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