TOPCAT - Tool for OPerations on Catalogues And Tables
Version 3.8
Starlink User Note 253
Mark Taylor
9 May 2011
$Id: sun253.xml 9900 2011-05-09 17:39:51Z mbt $
Contents
Abstract
1 Introduction
2 Quick Start Guide
3 Apparent Table
3.1 Row Subsets
3.1.1 Defining Subsets
3.2 Row Order
3.3 Column Set
4 Table I/O
4.1 Table Formats
4.1.1 Supported Input Formats
4.1.1.1 FITS
4.1.1.2 Column-oriented FITS
4.1.1.3 VOTable
4.1.1.4 ASCII
4.1.1.5 IPAC
4.1.1.6 Comma-Separated Values
4.1.1.7 Tab-Separated Table
4.1.1.8 SQL Database Queries
4.1.1.9 World Data Center
4.1.2 Supported Output Formats
4.1.2.1 FITS
4.1.2.2 Column-oriented FITS
4.1.2.3 VOTable
4.1.2.4 ASCII
4.1.2.5 Text
4.1.2.6 Comma-Separated Values
4.1.2.7 Tab-Separated Table
4.1.2.8 SQL Tables
4.1.2.9 HTML
4.1.2.10 LaTeX
4.1.2.11 Mirage Format
4.1.3 Custom I/O Formats
4.2 Table Locations
5 Joins and Matches
5.1 Concatenating Tables
5.2 Matching Rows Between Tables
5.3 Matching Rows Within a Table
5.4 Notes on Matching
5.5 Matching against a Remote Table
6 Virtual Observatory Access
6.1 The Registry
6.2 Data Access Services
7 Algebraic Expression Syntax
7.1 Referencing Cell Values
7.2 Referencing Row Subset Flags
7.3 Referencing Table Parameters
7.4 Null Values
7.5 Operators
7.6 Functions
7.6.1 Technical Note
7.7 Instance Methods
7.8 Examples
7.9 Adding User-Defined Functions
8 Activation Actions
8.1 Activation Functions
9 Tool Interoperability
9.1 SAMP control
9.2 PLASTIC control
9.3 Messages Transmitted
9.4 Messages Received
10 Invoking TOPCAT
10.1 TOPCAT Command-line Arguments
10.2 Java Options
10.2.1 Class Path
10.2.2 Memory Size
10.2.3 System properties
10.3 JDBC Configuration
10.4 Tips for Large Tables
10.5 Examples
A TOPCAT Windows
A.1 Common Window Features
A.1.1 Toolbar
A.1.2 Menus
A.1.3 JTables
A.1.4 Column Selector
A.2 Control Window
A.2.1 Table List
A.2.2 Current Table Properties panel
A.2.3 Memory Monitor
A.2.4 SAMP Panel
A.2.5 Toolbar Buttons
A.2.6 Menu Items
A.3 Table View Windows
A.3.1 Data Window
A.3.2 Parameters Window
A.3.3 Columns Window
A.3.4 Subsets Window
A.3.5 Statistics Window
A.4 Graphics Windows
A.4.1 Common Features
A.4.1.1 Dataset Selectors
A.4.1.2 Axis Configuration and Zooming
A.4.1.3 Error Bars
A.4.1.4 Point Labels
A.4.1.5 Auxiliary Axes
A.4.1.6 Defining Subsets by Region
A.4.1.7 Exporting Graphics
A.4.2 Histogram
A.4.2.1 Histogram Style Editor
A.4.3 2D Plot
A.4.3.1 Plot Style Editor
A.4.4 Stacked Line Plot
A.4.4.1 Lines Style Editor
A.4.5 3D Plot
A.4.5.1 3D Plot Style Editor
A.4.6 Spherical Plot
A.4.7 Density Map
A.4.7.1 Density Style Editor
A.5 Load Window
A.5.1 Filestore Browser
A.5.2 System Browser
A.5.3 Hierarchy Browser
A.5.3.1 Navigation
A.5.3.2 Table Searches
A.5.4 SQL Query
A.5.5 Cone Search
A.5.6 SIA Query
A.5.7 SSA Query
A.5.8 TAP Query
A.5.9 VizieR Catalogue Service Query
A.5.10 GAVO Millennium Database Query
A.5.11 BaSTI Theory Database Query
A.5.12 Example Tables
A.6 Save Window
A.6.1 Content Panel
A.6.1.1 Current Table
A.6.1.2 Multiple Tables
A.6.1.3 Session
A.6.2 Destination Panel
A.6.2.1 Enter Location
A.6.2.2 Filestore Browser
A.6.2.3 System Browser
A.6.2.4 SQL Output Dialogue
A.7 Match Windows
A.7.1 Common Features
A.7.1.1 Match Criteria
A.7.1.2 Column Selection Boxes
A.7.1.3 Tuning
A.7.2 Pair Match Window
A.7.2.1 Output Rows Selector Box
A.7.3 Internal Match Window
A.7.3.1 Internal Match Action Box
A.7.4 Multiple Match Window
A.7.4.1 Multiple Match Action Box
A.8 VO Data Access Windows
A.8.1 Common Features
A.8.1.1 Registry Query Panel
A.8.1.2 Single Positional Search Panel
A.8.1.3 Multiple Positional Search Panel
A.8.2 Cone Search
A.8.3 Simple Image Access (SIA) Query
A.8.4 Simple Spectral Access (SSA) Query
A.8.5 Multiple Cone Search
A.8.6 Multiple SIA Query
A.8.7 Multiple SSA Query
A.8.8 Table Access Protocol (TAP) Query
A.8.8.1 Select Service tab
A.8.8.2 Enter Query tab
A.8.8.3 Running Jobs tab
A.8.8.4 Resume Job tab
A.9 Other Windows
A.9.1 Concatenation Window
A.9.2 Activation Window
A.9.2.1 Image Viewer Applications
A.9.2.2 Spectrum Viewers
A.9.2.3 Web Browsers
A.9.3 SAMP Window
A.9.4 Help Window
A.9.5 New Parameter Window
A.9.6 Synthetic Column Window
A.9.7 Sky Coordinates Window
A.9.8 Algebraic Subset Window
A.9.9 Available Functions Window
A.9.10 Log Window
B Algebraic Functions
B.1 General Functions
B.1.1 Times
B.1.2 Maths
B.1.3 Conversions
B.1.4 Formats
B.1.5 Arithmetic
B.1.6 Tilings
B.1.7 Distances
B.1.8 Arrays
B.1.9 Strings
B.1.10 Fluxes
B.1.11 Coords
B.2 Activation Functions
B.2.1 Sdss
B.2.2 Browsers
B.2.3 SuperCosmos
B.2.4 Mgc
B.2.5 Sog
B.2.6 BasicImageDisplay
B.2.7 TwoQZ
B.2.8 Image
B.2.9 Output
B.2.10 System
C Release Notes
C.1 Acknowledgements
C.2 Version History