| 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
- UCAC3UCAC4
Each catalog display table 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 | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
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 | ||||||
|---|---|---|---|---|---|---|
| ||||||
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 Name | Description |
|---|---|
| BT Magnitude | |
| VT Magnitude |
The SQL code for creating the table is:
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
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 | ||||
|---|---|---|---|---|
|
UCAC2
...
| language | sql |
|---|---|
| title | Table Creation Script |
| ||||
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 |
| Ks2Mass | 2MASS K_s magnitude |
The SQL code for creating the table is:
...
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
DROP TABLE IF EXISTS `gwaves``ucac3`; CREATE TABLE `gwaves``ucac3` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `Right_Ascension` double`name` varchar(32) NOT NULL, `Declination``right_ascension` double NOT NULL, `Magnitude``declination` floatdouble NOT NULL, `EpRAm``epoch` double NOT NULL, `EpDEm``pm_ra` double NOTDEFAULT NULL, `Proper`pm_Motion_RA`dec` double NOTDEFAULT NULL, `Proper_Motion_Dec` double`magnitude` float NOT NULL, `M`2mass_J`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 AUTO_INCREMENT=49054904 DEFAULT CHARSET=latin1; |