Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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.
Example Format:
????

FK6

Code Block
languagesql
titleCreate Syntax (old)
collapsetrue
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;

...