APPLAUSE

The table has 51793 rows, 48 columns.

Description

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

Columns

Name	Type	UCD	Unit	Description
plate_id	int	meta.id		Plate identification number
archive_id	int	meta.id		Archive identification number
plate_num	char	meta.record instr.plate		Plate number in archive
plate_num_orig	char	meta.record instr.plate		Original plate number in archive
wfpdb_id	char	meta.id		Plate identification in the Wide-Field Plate Database
plate_aid	char	meta.id		AID of the plate
preview_aid	char	meta.id		AID of the plate preview
series	char	meta.id		Plate series
plate_format	char	meta.code phys.size instr.plate		Plate format (cm x cm)
plate_size1	float	phys.size instr.plate	cm	Plate size along axis 1
plate_size2	float	phys.size instr.plate	cm	Plate size along axis 2
emulsion	char	instr.plate.emulsion		Name of the photographic emulsion
filter	char	instr.filter		Filter type used during the observation
spectral_band	char	instr.bandpass		Spectral bandpass
develop	char	meta.note		Plate development information (developer, time)
plate_quality	char	meta.code.qual		Quality of the plate
plate_notes	char	meta.note instr.plate		Notes about the plate
date_orig	char	time.epoch obs.exposure		Original recorded date
numexp	short	meta.number obs.sequence		Number of exposures
observatory	char	meta.id instr.obsty		Observatory name
site_name	char
longitude_deg	double	pos.earth.lon instr.obsty	deg	East longitude of the observing site, in decimal degrees
latitude_deg	double	pos.earth.lat instr.obsty	deg	Latitude of the observing site, in decimal degrees
elevation	float	pos.earth.altitude instr.obsty	m	Elevation of the observatory site
telescope	char	meta.id instr.tel		Telescope name
tel_aper	float	stat.value instr.tel	m	Clear aperture of the telescope
tel_foc	float	instr.tel.focalLength	m	Focal length of the telescope
tel_scale	float	instr.scale	arcsec\/mm	Plate scale of the telescope
instrument	char	meta.id instr		Instrument name
method	short	meta.code		Observation method. A list of possible values is given in the WFPDB.
prism	char	meta.note instr		Information about the objective prism used
prism_angle	char	stat.value		Angle of the objective prism (deg:mm)
dispersion	float	instr.dispersion	0.1nm/mm	Dispersion (Angstrom / mm)
grating	char	meta.note instr		Information about the grating used
air_temperature	float
calmness	char	obs.param obs.atmos		Calmness (seeing conditions), scale 1-5 (German: Ruhe)
sharpness	char	obs.param obs.atmos		Sharpness, scale 1-5 (German: Schärfe)
transparency	char	obs.param obs.atmos		Transparency, scale 1-5 (German: Durchsicht, Klarheit)
sky_conditions	char	meta.note obs.atmos		Notes on sky conditions (from logbook)
observer	char	obs.observer		Observer name
obs_notes	char	meta.note		Observer notes (from logbook)
notes	char	meta.note		Miscellaneous notes
bibcode	char	meta.bib.bibcode		Bibcode of related paper
filename_preview	char	meta.ref meta.image		Name of the preview image file
filename_thumbnail	char	meta.ref meta.file		Name of the thumbnail image file
filename_cover	char	meta.ref meta.image		Name of the plate cover (envelope) image file
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