head 1.1; access; symbols; locks http:1.1; strict; comment @# @; 1.1 date 2002.09.04.09.06.41; author MarcoLeoni; state Exp; branches; next ; desc @none @ 1.1 log @none @ text @ UCD mapping for HST Science Archive Catalog

UCD mapping for HST Science Archive Catalog

 Column name          Sybase Type  UCD                    Example              Unit       Description (from ICD 19, StarView on-line help, etc.)
 -------------------- ------------ ---------------------- -------------------  ---------- -------------------------------------------------------
 pep_id               INT          OBS_CODE               3813                 -          proposal identifier
 dataset_name         VARCHAR(32)  ID_DATASET		  Y1410505T            -          rootname of the observation set
 dec_targ_int         INT          POS_EQ_DEC_MAIN	  195266989            mas        declination (J2000)
 start_time           DATETIME     OBS_START_DATE(4+)	  26/09/1993 12:00:00  dd/mm/yyyy hh:mm:ss  UT date of start of exposure 
 actual_duration      FLOAT        TIME_EXPTIME	          120.0                s          calculated exposure duration
 instrume             VARCHAR(6)   INST_ID		  FOS                  -          instrument name
 v3_pos_angle         FLOAT        POS_POS-ANG(5,6)	  212.100500           deg        position angle of V3 axis of HST
 ra_targ_int          INT          POS_EQ_RA_MAIN	  758717399            mas        right ascension (J2000)
 targname             VARCHAR(30)  ID_TARGET           	  NGC5455              -          proposer's target name
 release_date         DATETIME     OBS_REL_DATE(4)	  26/09/1993 03:43:00  dd/mm/yyyy hh:mm:ss  date when this data set is expected to be released from proprietary status 
 pr_inv_l             VARCHAR(20)  ID_HUMAN(5)		  ROSA                 -          last name of principal investigator
 sci_category         VARCHAR(50)  CLASS_MISC(6)          GO                   -          category of program (calibration, director's diescretionary, general observer, ...)
 proposal_title       VARCHAR(150) REMARKS(6)		  FORMATION AND EVOLUTION OF MASSIVE STARS, AND THE CHEMICAL EVOLUTION OF GALAXIES  
 tardescr             VARCHAR(136) REMARKS(6)		  EXT-CLUSTER;OB ASSOCIATION;     target description
 targcat              VARCHAR(48)  CLASS_OBJECT		  EXT-CLUSTER          -          target category
 minwave              FLOAT        INST_SETUP(6)          2221.095             Angstroem  minimum wavelength
 maxwave              FLOAT        INST_SETUP(6)          3300.691             Angstroem  maximum wavelength
 grating              CHAR(9)      INST_SETUP(6)	  H27                  -          grating in use
 filter               CHAR(23)     OBS_BAND               G270H                -          filter in use
 spectral_res         FLOAT        SPECT_RESOLUTION	  1300.0               -          approx. resolving power at central wavelength
 instrument_config    VARCHAR(15)  INST_SETUP(6)	  FOS/BL               -          proposed instrument configuration
 obsnum               CHAR(3)      OBS_ID(6)	          05                   -          observation number (base 36 [0-9,A-Z])
 stop_time            DATETIME     OBS_STOP_DATE(4+) 	  26/09/1992 12:02:00  dd/mm/yyyy hh:mm:ss  UT date of end of exposure
 bandwidth            FLOAT        INST_BANDWIDTH     	  1079.000             -          Bandwidth of the Filter and Detector
 costar_deploy        VARCHAR(1)   INST_SETUP(6)          F                    -          has observation been taken before or after costar deployment
 pa_aper              FLOAT        POS_POS-ANG(5,6)	  203.920200           deg        position angle of aperture used with target
 central_wavelength   FLOAT        INST_SETUP(6)       	  2650.000             Angstroem  central wavelength of the data
 dispersion           FLOAT        INST_DISPERSION	  2.090		       Angstroem/diode  the dispersion of an HST spectrograph observation
 program_id           CHAR(3)      OBS_ID(6)	          141                  -          program identifier (base 36 [0-9,A-Z])
 aec                  VARCHAR(1)   OBS_CAT(4)		  S                    -          science flag; S science, C calibration
 pixel_res            FLOAT        INST_PIXSIZE           0.1                  arcsec/pixel  plate scale
 fov_config           VARCHAR(7)   INST_SETUP(6)          LAUNCH               -          Spacecraft configuration
 -------------------- ------------ ---------------------- -------------------- ---------- -------------------------------------------------------

(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 @