STILTS
coneskymatch
coneskymatch
command can now make multiple
Simple Image Access or
Simple Spectral Access
queries against remote services as well as
Cone Search ones.
-disk flag
(unlimited size streaming processing is not affected).
The STIL Tool Set is a set of command-line tools based on STIL, the Starlink Tables Infrastructure Library. It deals with the processing of tabular data; the package has been designed for, but is not restricted to, astronomical tables such as object catalogues. Some of the tools are generic and can work with multiple formats (including FITS, VOTable, CSV, SQL and ASCII), and others are specific to the VOTable format. In some ways, STILTS forms the command-line counterpart of the GUI table analysis tool TOPCAT. The package is robust, fully documented, and designed for efficiency, especially with very large datasets.
Facilities offered include:
For tasks in which the data can be streamed, the size of table STILTS can process is effectively unlimited. For other tasks, million-row tables usually do not present a problem.
STILTS is written in pure Java (J2SE1.4 or later), and released under the GPL.
STILTS currently consists of ten generic table processing commands:
tcopy
- Table format convertertpipe
- Generic table pipeline processing utilitytmatch2,
tskymatch2
- Two-table crossmatcherstmatch1
- Intra-table crossmatchertmatchn
- Multi-table crossmatchertjoin
- Trivial side-by-side multiple-table joinertcube
- N-dimensional histogram calculatortcat,
tcatn
- Multiple-table concatenatersregquery
- Registry Queryconeskymatch
(formerly multicone)
- Match local table with one behind a Cone Search/SIA/SSA servicesqlskymatch
(formerly sqlcone)
- Match local table with one in an SQL databasesqlclient
- JDBC-based SQL command-line clientsqlupdate
- Updates data in existing cells of an RDBMS tableserver
- HTTP server which executes STILTS commandscalc
- Quick expression evaluatorfuncs
- Documentation browser for expression language functionsSee also the Commands by Category section of the manual.
More commands and facilities may be added in the future.
The STILTS documentatation is provided in the user document, SUN/256. This is available in the following formats:
The easiest way to download STILTS is from the following links:
svn checkout https://starjava.jach.hawaii.edu/svn/trunk
(see ttools package)stilts.jar file contains
all the classes required to run STILTS.
If you run "java -jar stilts.jar" you will see a help message;
on Unix you also have the choice of downloading the stilts
script into the same directory and using that for convenience.
For more details on invoking the tools, read
SUN/256.
It is also possible to run STILTS commands against an installation of the full Starjava set or of TOPCAT, since the relevant classes are present in each case.
The current release of STILTS is v2.1, released 6 November 2009. The full Version History is available in the user document.
Products related to STILTS are:
If you have any comments, questions, requests, bugs etc, please contact me:
And finally...
Q: What do you get if you combine all the Starlink Java table handling applications?
A: TOPCAT STILTS.
Thanks to Proporta and Malcolm Currie for that.