Next Previous Up Contents
Next: Release Notes
Up: tpipe
Previous: Miscellaneous Flags

B.3.4 Examples

tpipe -head 5 -write cat.fits
Outputs the first 5 rows of cat.fits to standard output in human readable form.
tpipe -ifmt csv xxx.csv -keepcols "index ra dec" -write -ofmt fits xxx.fits
Copies a comma-separated value file to a FITS file discarding all columns except INDEX, RA and DEC.
cat tab1.vot | tpipe - -addcol IV_SUM "(IMAG+VMAG)" \
                       -addcol IV_DIFF "(IMAG-VMAG)" \
                       -delcols "IMAG VMAG" \
                       -write - >tab2.vot
Replaces two columns by their sum and difference in a VOTable.
tpipe 2dfgrs_ngp.fits -keepcols "SEQNUM AREA ECCENT" -sort -down AREA -head 20
Displays selected columns for the 20 rows with largest values in the AREA column of a FITS table.
tpipe t.fits -meta
Outputs column and table metadata about t.fits.
tpipe survey.fits -select "skyDistance(hmsToRadians(RA),dmsToRadians(DEC), \
                                       0.6457,-0.1190) < 5 * ARC_MINUTE" \
                  -count
Counts the number of rows within a given cone of sky in a FITS table.
tpipe -ifmt ascii survey.txt -select "OBJTYPE == 3 && Z > 0.15" \
                             -keepcols "IMAG JMAG KMAG" \
                             -stats
Calculate statistics on the I, J and K magnitudes of selected objects from a catalogue.
tpipe -explode x.fits -tosql jdbc:mysql://localhost/astro1#TABLEX
Writes a FITS table to an SQL table, converting any array columns to scalar ones.
tpipe USNOB.FITS -every 1000000 -stats
Calculates statistics on a selection of the rows in a catalogue. In this example, every millionth row is sampled.


Next Previous Up Contents
Next: Release Notes
Up: tpipe
Previous: Miscellaneous Flags

STIL - Starlink Tables Infrastructure Library
Starlink User Note 252
STIL web page: http://www.starlink.ac.uk/stil/
Author email: m.b.taylor@bristol.ac.uk
Starlink: http://www.starlink.ac.uk/