head 1.1;
access;
symbols;
locks
http:1.1; strict;
comment @# @;
1.1
date 2002.09.04.09.06.26; author MarcoLeoni; state Exp;
branches;
next ;
desc
@none
@
1.1
log
@none
@
text
@
UCD mapping for ESO Science Archive Catalog
UCD mapping for ESO Science Archive Catalog
Column name Sybase Type UCD Example Unit
-------------------- ------------ ---------------------- ------------------- ----------
dp_id VARCHAR(45) ID_DATASET FORS.1999-03-09T05:06:14.119
tel_id VARCHAR(30) TEL_ID ESO-VLT-U1
ins_id VARCHAR(30) INST_ID FORS1
prog_id VARCHAR(30) OBS_CODE 60.A-9203(A)
dp_type VARCHAR(30) OBS_TYPE OBJECT
dp_tech VARCHAR(30) OBS_TECH(4) IMAGE
light_path VARCHAR(255) INST_SETUP(6) COLL(COLL_SR);FILT1(H_Alpha)
exp_start DATETIME OBS_START_DATE(4+) 09/03/1999 05:06:00 dd/mm/yyyy hh:mm:ss
exptime FLOAT TIME_EXPTIME 899.966600 s
det_id VARCHAR(30) INST_DET_ID(4) CCD FIERA - Rev 2.42
qual_flag VARCHAR(10) CODE_QUALITY D
ra INT POS_EQ_RA_MAIN 735307498 mas(J2000)
dec INT POS_EQ_DEC_MAIN -107515008 mas(J2000)
object VARCHAR(64) OBS_ID M83
ins_mode VARCHAR(40) INST_SETUP IMG
obs_name VARCHAR(70) ID_EXPOSURE(5) observationBlock6
naxis1 SHORT INST_SETUP(6) 2080 pixel
naxis2 SHORT INST_SETUP(6) 2048 pixel
tel_airm_start FLOAT PHOT_ATM_AIRMASS 1.138000
det_chip1id VARCHAR(64) INST_DET_CODE(4) TK2048EB4-1 160
rel_date DATETIME OBS_REL_DATE(4) 29/11/1999 12:00:00 dd/mm/yyyy hh:mm:ss
public_f CHAR(1) CLASS_MISC R or W or T
filter_path VARCHAR(255) OBS_BAND H_Alpha
gris_path VARCHAR(255) INST_SETUP(6) GRIS_300V
grat_path VARCHAR(255) INST_SETUP(6) Grat#1
slit_path VARCHAR(255) INST_SETUP(6) slit#1.2
-------------------- ------------ ---------------------- -------------------- ----------
(1)(2)(3) N/A
(4) suggested new UCDs by Francesco
(4+)- " - by Markus
(5) inaccurate match with existing UCD
(6) same UCD used for several columns
Markus.Dolensky@@eso.org
@