TOPCAT - Tool for OPerations on Catalogues And Tables
Version 2.2
Starlink User Note 253
Mark Taylor
7 July 2006
$Id: sun253.xml,v 1.135 2006/07/07 11:20:13 mbt Exp $
Starlink Project
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 Formats
4.1 Supported Input Formats
4.1.1 FITS
4.1.2 Column-oriented FITS
4.1.3 VOTable
4.1.4 ASCII
4.1.5 IPAC
4.1.6 Comma-Separated Values
4.1.7 SQL Database Queries
4.1.8 World Data Center
4.2 Supported Output Formats
4.2.1 FITS
4.2.2 Column-oriented FITS
4.2.3 VOTable
4.2.4 ASCII
4.2.5 Text
4.2.6 Comma-Separated Values
4.2.7 SQL Tables
4.2.8 HTML
4.2.9 LaTeX
4.2.10 Mirage Format
4.3 Custom I/O Formats
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
6 Algebraic Expression Syntax
6.1 Referencing Cell Values
6.2 Referencing Row Subset Flags
6.3 Null Values
6.4 Operators
6.5 Functions
6.5.1 Technical Note
6.6 Instance Methods
6.7 Examples
6.8 Adding User-Defined Functions
7 Activation Actions
7.1 Activation Functions
8 Tool Interoperability
8.1 PLASTIC control
8.2 Messages Transmitted
8.3 Messages Received
9 Invoking TOPCAT
9.1 TOPCAT Command-line Arguments
9.2 Java Options
9.2.1 Class Path
9.2.2 Memory Size
9.2.3 System properties
9.3 JDBC Configuration
9.4 Tips for Large Tables
9.5 Examples
A TOPCAT Windows
A.1 Common Window Features
A.1.1 Toolbar
A.1.2 Menus
A.1.3 JTables
A.2 Control Window
A.2.1 Table List
A.2.2 Current Table Properties panel
A.2.3 Toolbar Buttons
A.2.4 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 Defining Subsets by Region
A.4.1.4 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 Hierarchy Browser
A.5.2.1 Navigation
A.5.2.2 Table Searches
A.5.3 SQL Query
A.5.4 Cone Search
A.5.5 Example Tables
A.6 Save Window
A.6.1 Enter Location
A.6.2 Filestore Browser
A.6.3 SQL Output Dialogue
A.7 Other Windows
A.7.1 Concatenation Window
A.7.2 Pair Match Window
A.7.2.1 Match Criteria
A.7.2.2 Column Selection Boxes
A.7.2.3 Output Rows Selector Box
A.7.3 Internal Match Window
A.7.3.1 Internal Match Action box
A.7.4 Activation Window
A.7.4.1 Image Viewer Applications
A.7.4.2 Spectrum Viewers
A.7.4.3 Web Browsers
A.7.5 Help Window
A.7.6 New Parameter Window
A.7.7 Synthetic Column Window
A.7.8 Sky Coordinates Window
A.7.9 Algebraic Subset Window
A.7.10 Available Functions Window
A.7.11 Log Window
B Algebraic Functions
B.1 General Functions
B.2 Activation Functions
C Release Notes
C.1 Acknowledgements
C.2 Version History