View Source

Needs Major Updating

CAT contains several catalogs each stored in a separate table in the database. The database currently contains the following catalogs:

FK6
TYCHO
GWAVES (a composite catalog of UCAC2 & UCAC3 limited to declinations observable at DCT)
UCAC2
UCAC3

Each catalog display table contains the following minimum set of information:

Column Name	Description
ID	integer indicating the ID (primary key) in the database table
Name	if catalog does not contain name, it will be a unique construct depending on the catalog
Right Ascension
Declination
Epoch
Proper Motion in RA*cos(dec)	mas/yr
Proper Motion in Declincation	mas/yr
Magnitude
Distance	arcsec (from the center for the original query) - Computed at the time of query
Last Modified	Timestamp from the last modification date in the database

A text file containing the observer's target list can be loaded and displayed in a separate tab along catalog searches. The file should contain name (enclosed in double quotes), RA, DEC, epoch, proper motion in RA (mas/yr), proper motion in DEC (mas/yr), and magnitude.
Example Format:

"HR 173" 00 40 32.9 -23 48 16  2000.0  4.4 -34.2 11.5
"Gl 15 A" 00 18 22.9999  44 01 23  2000  2888.92 410.10 13.5
"DELTA SGE " 19 47 23.2  18 32 03  1950  -4.31 12.35 5.3

FK6

DROP TABLE IF EXISTS `fk6`;
CREATE TABLE `fk6` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `FK6` int(11) DEFAULT NULL,
  `HIP` int(11) DEFAULT NULL,
  `Flag` varchar(2) DEFAULT NULL,
  `Name` varchar(19) DEFAULT NULL,
  `Right_Ascension` double DEFAULT NULL,
  `Declination` double DEFAULT NULL,
  `pmRA` double DEFAULT NULL,
  `pmDE` double DEFAULT NULL,
  `TRA` double DEFAULT NULL,
  `e_RA` double DEFAULT NULL,
  `e_pmRA` double DEFAULT NULL,
  `TDE` double DEFAULT NULL,
  `e_DE` double DEFAULT NULL,
  `e_pmDE` double DEFAULT NULL,
  `plx` double DEFAULT NULL,
  `e_plx` double DEFAULT NULL,
  `f_plx` char(1) DEFAULT NULL,
  `RV` double DEFAULT NULL,
  `Vmag` float DEFAULT NULL,
  `f_Vmag` float DEFAULT NULL,
  `Kbin1` int(11) DEFAULT NULL,
  `Kbin2` int(11) DEFAULT NULL,
  `Kae` int(11) DEFAULT NULL,
  `lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4151 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `fk6`;
CREATE TABLE `fk6` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `right_ascension` double NOT NULL,
  `declination` double NOT NULL,
  `epoch` double NOT NULL,
  `pm_ra` double DEFAULT NULL,
  `pm_dec` double DEFAULT NULL,
  `magnitude` float NOT NULL,
  `fk6` int(11) DEFAULT NULL,
  `flag` varchar(2) DEFAULT NULL,
  `tra` double DEFAULT NULL,
  `e_ra` double DEFAULT NULL,
  `e_pmra` double DEFAULT NULL,
  `tde` double DEFAULT NULL,
  `e_de` double DEFAULT NULL,
  `e_pmde` double DEFAULT NULL,
  `plx` double DEFAULT NULL,
  `e_plx` double DEFAULT NULL,
  `f_plx` char(1) DEFAULT NULL,
  `rv` double DEFAULT NULL,
  `vmag` float DEFAULT NULL,
  `f_Vmag` float DEFAULT NULL,
  `kbin1` int(11) DEFAULT NULL,
  `kbin2` int(11) DEFAULT NULL,
  `kae` int(11) DEFAULT NULL,
  `lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

TYCHO

DROP TABLE IF EXISTS `tycho`;
CREATE TABLE `tycho` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `Name` char(16) DEFAULT NULL,
  `Right_Ascension` double DEFAULT NULL,
  `Declination` double DEFAULT NULL,
  `pmRA` double DEFAULT NULL,
  `pmDE` double DEFAULT NULL,
  `BTmag` float DEFAULT NULL,
  `VTmag` float DEFAULT NULL,
  `epoch` double DEFAULT NULL,
  `lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `starIndex` (`Declination`,`Right_Ascension`)
) ENGINE=MyISAM AUTO_INCREMENT=2448057 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `tycho`;
CREATE TABLE `tycho` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `right_ascension` double NOT NULL,
  `declination` double NOT NULL,
  `epoch` double NOT NULL,
  `pm_ra` double DEFAULT NULL,
  `pm_dec` double DEFAULT NULL,
  `magnitude` float NOT NULL,
  `bt_mag` float DEFAULT NULL,
  `vt_mag` float DEFAULT NULL,
  `lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `starIndex` (`dec`,`ra`,`magnitude`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

GWAVES

DROP TABLE IF EXISTS `gwaves`;
CREATE TABLE `gwaves` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `Right_Ascension` double NOT NULL,
  `Declination` double NOT NULL,
  `Magnitude` float NOT NULL,
  `EpRAm` double NOT NULL,
  `EpDEm` double NOT NULL,
  `Proper_Motion_RA` double NOT NULL,
  `Proper_Motion_Dec` double NOT NULL,
  `M_J` float NOT NULL,
  `M_H` float NOT NULL,
  `M_Ks` float NOT NULL,
  `lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `starIndex` (`Declination`,`Right_Ascension`,`Magnitude`)
) ENGINE=MyISAM AUTO_INCREMENT=49054904 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `gwaves`;
CREATE TABLE `gwaves` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `ra` double NOT NULL,
  `dec` double NOT NULL,
  `epoch` double NOT NULL,
  `pm_ra` double DEFAULT NULL,
  `pm_dec` double DEFAULT NULL,
  `magnitude` float NOT NULL,
  `EpRAm` double NOT NULL,
  `EpDEm` double NOT NULL,
  `M_J` float NOT NULL,
  `M_H` float NOT NULL,
  `M_Ks` float NOT NULL,
  `lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `starIndex` (`dec`,`ra`,`magnitude`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

UCAC2

DROP TABLE IF EXISTS `ucac2`;
CREATE TABLE `ucac2` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `Right_Ascension` double NOT NULL,
  `Declination` double NOT NULL,
  `Magnitude` float NOT NULL,
  `SE_RAm` double NOT NULL,
  `SE_DEm` double NOT NULL,
  `Nobs` int(11) NOT NULL,
  `Error_Position` double NOT NULL,
  `Num_Catalogs` int(11) NOT NULL,
  `CFlag` int(11) NOT NULL,
  `EpRAm` double NOT NULL,
  `EpDEm` double NOT NULL,
  `Proper_Motion_RA` double NOT NULL,
  `Proper_Motion_Dec` double NOT NULL,
  `E_pmRA` double NOT NULL,
  `E_pmDE` double NOT NULL,
  `Goodness_of_fit_pmRA` float NOT NULL,
  `Goodness_of_fit_pmDec` float NOT NULL,
  `M_ID` double NOT NULL,
  `M_J` float NOT NULL,
  `M_H` float NOT NULL,
  `M_Ks` float NOT NULL,
  `M_Ph` int(11) NOT NULL,
  `M_CC` int(11) NOT NULL,
  `lastModified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `ra` (`Right_Ascension`),
  KEY `declination` (`Declination`),
  KEY `mag` (`Magnitude`)
) ENGINE=MyISAM AUTO_INCREMENT=48330572 DEFAULT CHARSET=latin1;

UCAC3

DROP TABLE IF EXISTS `ucac3`;
CREATE TABLE `ucac3` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `Right_Ascension` double NOT NULL,
  `Declination` double NOT NULL,
  `Fit_Model_Magnitude` float NOT NULL,
  `Aperture_Magnitude` float NOT NULL,
  `E_Mag` float NOT NULL,
  `Object_Type` tinyint(3) NOT NULL,
  `Dbl_Flg` tinyint(3) NOT NULL,
  `SE_RAm` double NOT NULL,
  `SE_DEm` double NOT NULL,
  `CCD_Images` tinyint(3) NOT NULL,
  `Images_Used` tinyint(3) NOT NULL,
  `Num_Catalogs` tinyint(3) NOT NULL,
  `Total_Catalogs` tinyint(3) NOT NULL,
  `EpRAm` double NOT NULL,
  `EpDEm` double NOT NULL,
  `Proper_Motion_RA` double NOT NULL,
  `Proper_Motion_Dec` double NOT NULL,
  `E_pmRA` double NOT NULL,
  `E_pmDE` double NOT NULL,
  `M_ID` int(11) NOT NULL,
  `M_J` float NOT NULL,
  `M_H` float NOT NULL,
  `M_Ks` float NOT NULL,
  `M_Ph` char(10) NOT NULL,
  `M_Je` float NOT NULL,
  `M_He` float NOT NULL,
  `M_Kse` float NOT NULL,
  `SC_BMag` float NOT NULL,
  `SC_R2Mag` float NOT NULL,
  `SC_IMag` float NOT NULL,
  `SC_QFlag` tinyint(3) NOT NULL,
  `SCB_QFlag` tinyint(3) NOT NULL,
  `SCR2_QFlag` tinyint(3) NOT NULL,
  `SCI_QFlag` tinyint(3) NOT NULL,
  `Cat_Flag` char(10) NOT NULL,
  `Cat_Flag_Bit` tinyint(3) NOT NULL,
  `YaleG_Flag` tinyint(3) NOT NULL,
  `YaleC_Flag` tinyint(3) NOT NULL,
  `Leda_Flag` tinyint(3) NOT NULL,
  `Source_Flag` tinyint(3) NOT NULL,
  `MPOS_Num` int(11) NOT NULL,
  `lastModified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `starIndex` (`Right_Ascension`,`Declination`,`Aperture_Magnitude`)
) ENGINE=MyISAM AUTO_INCREMENT=50922153 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `ucac3`;
CREATE TABLE `ucac3` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `right_ascension` double NOT NULL,
  `declination` double NOT NULL,
  `epoch` double NOT NULL,
  `pm_ra` double DEFAULT NULL,
  `pm_dec` double DEFAULT NULL,
  `magnitude` float NOT NULL,
  `2mass_j float NOT NULL,
  `2mass_h` float NOT NULL,
  `2mass_k_s` float NOT NULL,
  `lastModified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `starIndex` (`declination`,`right_ascension`,`magnitude`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;