Page History

Note
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
UCAC4

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

Column Name	Description
ID	integer indicating the order ID (primary key) in the original query 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 arc minutes (from the center for the original query) - Computed at the time of query

A text file containing the observer's target list can be loaded and displayed in a separate tab along with the 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. Please refer to Target View for more details.

FK6

The FK6 catalog provides the following additional parameters:

Column Name	Description
FK6 Number	the internal ID from the catalog

The SQL code for creating the table is:

Code Block

language	sql
title	Create Syntax (old)
collapse	true


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;

Code Block

language	sql
title	Create Syntax (new)
collapse	true


DROP TABLE IF EXISTS `fk6`;
CREATE TABLE `fk6` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `ra``right_ascension` double NOT NULL,
  `dec``declination` double NOT NULL,
  `epoch` floatdouble 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

The Tycho catalog provides the following additional parameters:

Column Name	Description
BT Magnitude
VT Magnitude

The SQL code for creating the table is:

Code Block

language	sql
title	Create Syntax (old)
collapse	true


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;

Code Block

language	sql
title	Create Syntax (new)
collapse	true


DROP TABLE IF EXISTS `tycho`;
CREATE TABLE `tycho` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `ra``right_ascension` double NOT NULL,
  `dec``declination` double NOT NULL,
  `epoch` floatdouble 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` (`Declination`,`Right_Ascension``dec`,`ra`,`magnitude`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

GWAVES

...

language	sql
title	Create Syntax (old)
collapse	true

...

UCAC4

The UCAC4 catalog provides the following additional parameters:

Column Name	Description
J2Mass	2MASS J magnitude
H2Mass	2MASS H magnitude
Ks2Mass	2MASS K_s magnitude

The SQL code for creating the table is:

Code Block

language	sql
title	Create Syntax (new)
collapse	true


DROP TABLE IF EXISTS `gwaves``ucac3`;
CREATE TABLE `gwaves``ucac3` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `ra``right_ascension` double NOT NULL,
  `dec``declination` double NOT NULL,
  `epoch` floatdouble 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``2mass_j float NOT NULL,
  `M`2mass_H`h` float NOT NULL,
  `M`2mass_k_Ks`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``declination`,`Right`right_Ascension`ascension`,`Magnitude``magnitude`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

UCAC2

...

language	sql
title	Create Syntax (old)
collapse	true

...

language	sql
title	Create Syntax (new)
collapse	true

UCAC3

true

Code Block

language	sql
title	Create Syntax (old)
collapse	true

Code Block

language

sql

title

Create Syntax (new)

collapse

Child pages

Versions Compared

Old Version 4

New Version Current

Key

FK6

TYCHO

GWAVES

UCAC4

UCAC2

UCAC3