Logbook pages and plate envelopes (applause_dr4.logpage)
The table has 113960 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 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.
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 |