TOPCAT

1
Primer Curso Práctico de la red Temática
SVO Granada, 27-28 de octubre de 2009
TOPCAT STILTS
Francisco Jiménez Esteban Spanish Virtual
Observatory LAEX-CAB (INTA-CSIC)
2
TOPCAT

• Interactive graphical viewer and editor for
  tabular data.
• It can examine, analyse, combine, edit and write
  out tables.
• It understands a number of different
  astronomically important formats.
• A million rows by a hundred columns.

Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
3
TOPCAT Control Window
- The right hand panel describes the
characteristics of the current table.- The
buttons along the top allow launching of various
other windows.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
4
TOPCAT Load Windows
Load Data- You can load your local tables.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
5
TOPCAT Load Windows
Cone Search- Service available on the web.-
The list is obtained from a VO registry.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
6
TOPCAT Table Windows
Data- Scroll around.- Sort rows.- Define
subsets.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
7
TOPCAT Table Windows
Columns- Information about each column.-
Columns can be hidden/revealed, and new ones
added.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
8
TOPCAT Table Windows
Subsets- See all the row subsets defined, and
to define more.- Can be defined using algebraic
expression, or graphically.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
9
TOPCAT Table Windows
Statistics- Calculate statistics for all or a
selection of rows.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
10
TOPCAT Plot Windows

• Set axis labels and ranges- Different colors
  or symbols for different sets of data. - Error
  bars- Configurable plot markers- Zoom in or
  out.- Select a Subset.

1D histograms- Set bin width and offset
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
11
TOPCAT Plot Windows
2D- Plot pairs of columns.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
12
TOPCAT Plot Windows
3D- Plots on Cartesian axes.- Rotate the
axes by dragging the mouse.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
13
TOPCAT Plot Windows
Spherical Polar- Plots 3D plots on spherical
polar axes. - Plot points only on the surface
of the sphere or on the interior. - Rotate the
axes by dragging the mouse.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
14
TOPCAT Plot Windows
Stacked Line- Plots one or more X-Y line plots
using the same X axis but different Y axes. -
This can be particularly useful for visualizing
time-series data.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
15
TOPCAT Plot Windows
Density Maps- The intensity of color at each
pixel reflects the number of points that fall
within its bounds. - Pixel size can be changed,
cut levels can be altered.- This is very useful
for analysis and visualization of extremely
crowded plots.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
16
TOPCAT Match Windows
Concatenate- Concatenate the rows of existing
tables to create new ones.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
17
TOPCAT Match Windows
1 Table- Mark groups of rows.- Eliminate All
grouped.- Eliminate All but First.- New
tables with groups.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
18
TOPCAT Match Windows
2 Tables- Specify a match operation which will
join two tables. - A wide range of multivariate
matches is possible.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
19
TOPCAT Functions Windows
Available Functions- Displays the details of
the functions which can be used to define new
columns and subsets.
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
20
STILTS
STILTS is a set of command-line tools for
processing tabular data. Its facilities-
Cross-matching- Format conversion and
validation- Column calculation and
rearrangement- Row selection- Sorting-
Plotting- Statistical calculations- Metadata
display
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009
21
STILTS
- Accept streamed data so the size of tables
which can be processed is not limited by
available memory.- In general, the form of a
command isjava jar /path/stilts.jar
ltstilts-flagsgt lttask-namegt lttask-argsgt
Francisco Jiménez Esteban SVO
fran_at_laeff.inta.es Granada 27-28 de octubre
de 2009