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

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

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 NameDescription
FK6 Numberthe internal ID from the catalog

The SQL code for creating the table is:

Create Syntax (old) 
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;
Create Syntax (new) 
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

The Tycho catalog provides the following additional parameters:

Column NameDescription
BT Magnitude 
VT Magnitude 

The SQL code for creating the table is:

Create Syntax (old) 
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;
Create Syntax (new) 
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;

UCAC4

 The UCAC4 catalog provides the following additional parameters:

Column Name

Description

J2Mass

2MASS J magnitude

H2Mass

2MASS H magnitude

Ks2Mass2MASS K_s magnitude

The SQL code for creating the table is:

Create Syntax (new) 
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;
  • No labels