...
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 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 arc seconds (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 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.
Example Format:
...
Please refer to Observer Target View for more details.
FK6
| 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; |
...