TOPCAT – Tool for OPerations on Catalogues And Tables

Tool for OPerations on Catalogues And Tables (TOPCAT) is an interactive graphical tool for analysis and manipulation of 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 has facilities for plotting, cross matching, row selection, sorting and manipulation of data and metadata. Synthetic columns can be created and row selections made using a powerful and extensible algebraic expression language. 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.

TOPCAT 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.

Features include:

  • Fast access to large datasets (millions of rows/hundreds of columns).
  • View/edit table data in a scrollable browser.
  • View/edit table and column metadata.
  • Re-order and hide/reveal columns.
  • Insert ‘synthetic’ columns defined by algebraic expression.
  • Sort rows on the values in a given column.
  • Define row subsets in various ways.
  • View interactive and configurable plots of column-based quantities against each other distinguishing different data sets:
    • Plot types are histogram, plane, sky, cube, sphere, time.
  • Features include variable transparency, error bars, point labelling, colour axes, all-sky plots, configurable density shading, vectors, ellipses, polygons, contours, density maps, KDEs, analytic functions, plain text/LaTeX axis annotation, …
  • Plots can be exported in bitmapped or vector formats, and a command to script the same plot is displayed.
  • Calculate statistics on each column for some or all rows.
  • Perform flexible and fast matching of rows in the same or different tables.
  • Concatenate the rows of existing tables to create new ones.
  • Cause various things to happen when a row or plotted point is selected.
  • Communicate with other applications using SAMP.
  • Acquire tables from a file, URL, or SQL query.
  • Communicate with external VO and non-VO data services, including TAP, VizieR, CDS X-Match, cone search, SIA, SSA or DataLink.
  • Perform multiple (per-row) cone search, SIA or SSA queries, to join a local to a remote catalogue or image/spectrum archive.
  • Write modified tables out in original or different format to file or an SQL database.
  • Comprehensive documentation supplied within the application or off-line.
  • Cross-platform support – runs under Linux, Mac OS X, Windows, and any other operating system that supports the Java Runtime Environment.

Supported table input formats include:

  • FITS TABLE (ASCII table) or BINTABLE (binary table) extensions.
  • VOTables in any of the format variants (TABLEDATA, FITS, BINARY, BINARY2) or versions.
  • ASCII tables in a number of variations.
  • CDF files.
  • Comma-Separated Values.
  • Results of SQL queries on relational databases.
  • IPAC format.
  • GBIN files.

and supported output formats include:

  • FITS BINTABLE (binary table).
  • VOTables in any of the format variants (TABLEDATA, FITS, BINARY, BINARY2) or versions.
  • Plain ASCII text.
  • Comma-Separated Values.
  • New table exported to an SQL-compatible relational database.
  • IPAC format.
  • HTML TABLE element.
  • LaTeX tabular environment.

Website: www.star.bris.ac.uk/~mbt/topcat
Support: FAQ, Mailing Lists
Developer: Mark Taylor
License: GNU General Public Licence. Some parts of the library code are released under the GNU Lesser General Public License

TOPCAT

The software is written in the Java programming language. Learn Java with our recommended free books and free tutorials.

Return to Astronomical Data Analysis Home Page


Popular series
Guide to LinuxNew to Linux? Read our Linux for Starters series. We start right at the basics and teach you everything you need to know to get started with Linux.
Free and Open Source SoftwareThe largest compilation of the best free and open source software in the universe. Each article is supplied with a legendary ratings chart helping you to make informed decisions.
ReviewsHundreds of in-depth reviews offering our unbiased and expert opinion on software. We offer helpful and impartial information.
Alternatives to Proprietary SoftwareReplace proprietary software with open source alternatives: Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle, Atlassian, Corel, Cisco, Intuit, and SAS.
Linux Around The WorldLinux Around The World showcases events and usergroups that are relevant to Linux enthusiasts.
AudioSurveys popular streaming services from a Linux perspective: Amazon Music Unlimited, Myuzi, Spotify, Deezer, Tidal.
Saving Money with LinuxSaving Money with Linux looks at how you can reduce your energy bills running Linux.
System ToolsEssential Linux system tools focuses on small, indispensable utilities, useful for system administrators as well as regular users.
ProductivityLinux utilities to maximise your productivity. Small, indispensable tools, useful for anyone running a Linux machine.
Home ComputersHome computers became commonplace in the 1980s. Emulate home computers including the Commodore 64, Amiga, Atari ST, ZX81, Amstrad CPC, and ZX Spectrum.
Now and ThenNow and Then examines how promising open source software fared over the years. It can be a bumpy ride.
Linux at HomeLinux at Home looks at a range of home activities where Linux can play its part, making the most of our time at home, keeping active and engaged.
Linux CandyLinux Candy reveals the lighter side of Linux. Have some fun and escape from the daily drudgery.
DockerGetting Started with Docker helps you master Docker, a set of platform as a service products that delivers software in packages called containers.
Android AppsBest Free Android Apps. We showcase free Android apps that are definitely worth downloading. There's a strict eligibility criteria for inclusion in this series.
Programming BooksThese best free books accelerate your learning of every programming language. Learn a new language today!
Programming TutorialsThese free tutorials offer the perfect tonic to our free programming books series.
Stars and StripesStars and Stripes is an occasional series looking at the impact of Linux in the USA.
Share this article

Share your Thoughts

This site uses Akismet to reduce spam. Learn how your comment data is processed.