stilts program -h
The STIL Tool Set (stilts) 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 source catalogues. Some of the tools are generic and can work with multiple formats (including FITS, VOTable, CDF, ECSV, CSV, PDS4, Parquet, MRT, Feather, GBIN, SQL and ASCII), and others are specific to the VOTable format. STILTS is 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.
The command stilts without argument will remind users what programs exist.
Below the current programs are listed, and a
related/equivalent program in NEMO that is functionally similar to what
the stilts program does.
program NEMO related calc nemoinp cdsskymatch cone coneskymatch datalinklint funcs tabmath pixfoot pixsample plot2d tabplot, snapplot plot3d snapplot3d, glnemo2 plothist tabhist, tabstat regquery sqlclient sqlskymatch sqlupdate taplint tapquery tapresume tapskymatch tcat tcatn tcopy tcube tgridmap snapgrid tjoin join(1)q tloop tabcols, tabrows tmatch1 tmatch2 tmatchn tmulti tmultin tpipe table pipeline processing tskymap snapgrid, ccdsky tskymatch2 votcopy votlint plot2plane tabplot, snapplot plot2sky plot2cube plot2sphere plot2time
Converting tables via a Unix pipe may be the most useful function to get tables into a more manageable version for NEMO’s limited table(5) format. Here’s an example grabing a huge table with over 500,000 rows and
99 columns
stilts tpipe \ ifmt=’ecsv(header=http://cdn.gea.esac.esa.int/Gaia/gedr3/ECSV_headers/gaia_source.header)’
\
in=http://cdn.gea.esac.esa.int/Gaia/gedr3/gaia_source/GaiaSource_000000-003111.csv.gz
\
cmd=’keepcols "ra dec l b"’ \
ofmt=csv
http://www.star.bris.ac.uk/~mbt/stilts/ https://www.star.bristol.ac.uk/mbt/topcat/