TOPCAT

Tool for OPerations on Catalogues And Tables

Does what you want with tables


Latest (see Version History for details)

Version 4.9-1 released 29 February 2024
New: TAP window improvements
New ADQL tab displays all service functions, UDFs and optional features;
Choose either service-defined or alphabetical order for schema/table tree listing;
Tables selected in service search show up immediately in metadata panel.
New: HAPI Load Dialogue
Query and download data from Heliophysics Data API time series services.
New: Cube Plot coordinate extensions
New Coordinates selector lets you plot 3-vectors or spherical polars as well as X, Y, Z components.


* What is TOPCAT?

TOPCAT is an interactive graphical viewer and editor for tabular data. Its aim is to provide most of the facilities that astronomers need for analysis and manipulation of source catalogues and other tables, though it can be used for non-astronomical data as well. It understands a number of different astronomically important formats (including FITS, VOTable and CDF) and more formats can be added. It is especially good at interactive exploration of large (multi-million row, lots of columns) tables.

It offers a variety of ways to view and analyse tables, including a browser for the cell data themselves, viewers for information about table and column metadata, and facilities for sophisticated interactive 1-, 2-, 3- and higher-dimensional visualisation, calculating statistics and joining tables using flexible matching algorithms. Using a powerful and extensible Java-based expression language new columns can be defined and row subsets selected for separate analysis. Table data and metadata can be edited and the resulting modified table can be written out in a wide range of output formats.

It is a stand-alone application which works quite happily with no network connection. However, because it uses Virtual Observatory (VO) standards, it can cooperate smoothly with other tools, services and datasets in the VO world and beyond.

The program is written in pure Java and available under the GNU General Public Licence, though some of the library code is LGPL. It has been developed mostly in the UK within various UK and Euro-VO projects (Starlink, AstroGrid, VOTech, AIDA, GAVO, GENIUS, DPAC) and under PPARC and STFC grants. Its underlying table processing facilities are provided by the related packages STIL and STILTS.


* Features

The following is a list of the program's main capabilities. The hyperlinks are to the relevant parts of the user document.

Supported table input formats include:

and supported output formats include:


* Documentation

Full tutorial and reference documentation for TOPCAT is provided by SUN/253, the user document. This is available within the program at runtime via the context-sensitive and searchable help system, or in the following forms within the distribution or on the web:


* Frequently Asked Questions

A list of frequently asked questions is available. If you want to suggest additional questions and/or answers, please get in touch.


* Mailing Lists

Two mailing lists are in use for TOPCAT and related software:

See the mailing list page for more information.

If you have queries or support enquiries you can send them to topcat-user (especially if the answer might be of interest to other users), or email me if you prefer that.


* Tutorials and Examples

Demos/tutorials of using TOPCAT with Gaia DR3 data:

Tutorial script exercising TOPCAT and STILTS with Gaia DR2/EDR3 data (built from repository - you can adapt it):

Introduction/Demo tutorial covering some similar material as presented to Shristi Astronomy/AstroSprint courses:

Español: Tutorial para crear el diagrama H-R (Hertzsprung-Russell) de las Pléyades (M45) utilizando TOPCAT

Some older tutorials are available too:

And some more general items may also be helpful:


* Screenshots

You can see screenshots of TOPCAT in action in the following places:


* Downloads

TOPCAT is written in the Java language using the Java 2 Standard Edition version 8, and should run on any Java SE 8 or more recent system. This means it can be run on a wide range of platforms, without requiring any recompilation - you just need to ensure that you have a suitable Java Runtime Environment (JRE) - though that's not necessary for the MacOS DMG download, see below. If you don't have Java installed, or have an unsuitable version, you can obtain the Java SE for Linux, Mac OS X, MS Windows and Solaris from Oracle's web site (you only need the "JRE" rather than the "JDK" download, unless you will be doing development work). Java SE Runtime Enviroments (sometimes called JVMs or Java Virtual Machines) for other platforms may be available from operating system vendors. OpenJDK is also suitable.

If starting TOPCAT fails with an error like java.lang.UnsupportedClassVersionError, you have a version of Java that is too old, and you should upgrade to Java 8 or later. If you're unable or unwilling to do that and you only have the rather ancient Java 6, you can still use TOPCAT version v4.6-3 or older.

Having got Java, There are several ways to download TOPCAT, described in rough order of advisability in the following subsections. More information on how to run the program having obtained it can be found in SUN/253's section on Invoking TOPCAT.

Standalone Jar File

The generally recommended form for downloading is to pick up a single Jar file containing the required classes:

On Unix-like operating systems, download one or other of these jar files and the startup script topcat into the same directory, then "chmod +x topcat", and you can just run the command:

   topcat
On non-Unix systems the script won't work, and you can use a command like:
   java -jar topcat-*.jar
or invoke it in some other system-dependent way such as by clicking on it.

For many users, topcat-lite will provide all the features they need. The optional extras provided by topcat-full include:

Even topcat-full lacks a few of the niche features (proper coordinate handling in SoG, NDF viewing in hierarchy view, parquet support), since these require native libraries; for these you will need the Full Starjava installation described below, or topcat-extra if you just want parquet.

MacOS

If you have an Apple Mac, you can pick up the following for easy installation (no pre-existing Java required):

topcat-all.dmg (106.2M)
A couple of FAQ entries are relevant: problem with "damaged" dmg file and how to set flags for memory usage etc.

This DMG file contains a bundled Java Runtime Environment, user manuals for TOPCAT and STILTS, and the topcat-extra.jar file (see above). It ought to work for both Intel and Apple Silicon hardware, and does not require an external Java installation. It is therefore quite large; if you want something more compact, you can use an existing java installation with one of the topcat-*.jar Standalone Jar Files listed in the previous section. The main disadvantage is that you don't get to click on a yellow cat to start it.

This DMG file was built using Install4j, a multi-platform installer builder, which has saved me a lot of Mac-specific wrangling.

Full Starjava Installation

If you want the most comprehensive installation then download and unpack the full starjava tree in one of the following forms:

These archives include related applications such as SPLAT, SoG and Treeview. You can run TOPCAT using the starjava/bin/topcat script (Unix) or by running java -jar starjava/lib/topcat/topcat.jar.

From other distributions

TOPCAT is also packaged as part of some other larger software distributions:

Note however these may not provide the most up to date version.

WebStart (deprecated)

Note: the WebStart version of TOPCAT is being provisionally deprecated from TOPCAT v4.8-8. The jar file is no longer signed, which means various things may not work, see the FAQ. WebStart is therefore no longer recommended. But if you really want, you can try it at topcat-full.jnlp or topcat-lite.jnlp.


* Version History

The most recent public release of TOPCAT is version 4.9-1, released 29 February 2024.

For a detailed history of the changes in this and previous releases, see the

Full Version History
section of SUN/253.


* Further Information

STILTS
TOPCAT's sister package is STILTS, the STIL Tool Set. STILTS offers many of the same facilities as TOPCAT (and some additional ones) in the form of command-line tools, which can be invoked from the Unix/Windows command-line prompt, or from Jython.
Other Resources relating to the code
Acknowledgements

TOPCAT is currently (2024) under active development, and I'm very open to user feedback. Any comments, questions, requests, bugs etc, please either post to the topcat-user list or contact me direct: