STILTS Starlink Tables Infrastructure Library Tool Set

STILTS - Starlink Tables Infrastructure Library Tool Set

STILTS - Starlink Tables Infrastructure Library Tool Set
Version 2.4

---

Starlink User Note 256

Mark Taylor

27 October 2011

$Id: sun256.xml 10109 2011-10-27 15:55:57Z mbt $

---

Contents

• Abstract
• 1 Introduction
• 2 The stilts command
  • 2.1 Stilts flags
  • 2.2 Task Names
  • 2.3 Task Arguments
  • 2.4 Getting Help
• 3 Invocation
  • 3.1 Class Path
  • 3.2 Java Flags
  • 3.3 System Properties
  • 3.4 JDBC Configuration
• 4 JyStilts - STILTS from Python
  • 4.1 Running JyStilts
  • 4.2 Table I/O
  • 4.3 Table objects
  • 4.4 Table filter commands (cmd_*)
  • 4.5 Table output modes (mode_*)
  • 4.6 Tasks
  • 4.7 Calculation Functions
• 5 Table I/O
  • 5.1 Table Locations
  • 5.2 Table Formats
    • 5.2.1 Input Formats
    • 5.2.2 Output Formats
• 6 Table Pipelines
  • 6.1 Processing Filters
    • 6.1.1 addcol
    • 6.1.2 addresolve
    • 6.1.3 addskycoords
    • 6.1.4 assert
    • 6.1.5 badval
    • 6.1.6 cache
    • 6.1.7 check
    • 6.1.8 clearparams
    • 6.1.9 colmeta
    • 6.1.10 delcols
    • 6.1.11 every
    • 6.1.12 explodeall
    • 6.1.13 explodecols
    • 6.1.14 fixcolnames
    • 6.1.15 head
    • 6.1.16 keepcols
    • 6.1.17 meta
    • 6.1.18 progress
    • 6.1.19 random
    • 6.1.20 randomview
    • 6.1.21 repeat
    • 6.1.22 replacecol
    • 6.1.23 replaceval
    • 6.1.24 rowrange
    • 6.1.25 select
    • 6.1.26 seqview
    • 6.1.27 setparam
    • 6.1.28 sort
    • 6.1.29 sorthead
    • 6.1.30 stats
    • 6.1.31 tablename
    • 6.1.32 tail
    • 6.1.33 transpose
    • 6.1.34 uniq
  • 6.2 Specifying a Single Column
  • 6.3 Specifying a List of Columns
  • 6.4 Output Modes
    • 6.4.1 cgi
    • 6.4.2 count
    • 6.4.3 discard
    • 6.4.4 meta
    • 6.4.5 out
    • 6.4.6 plastic
    • 6.4.7 samp
    • 6.4.8 stats
    • 6.4.9 topcat
    • 6.4.10 tosql
• 7 Crossmatching
  • 7.1 Match Criteria
    • 7.1.1 sky: Sky Matching
    • 7.1.2 skyerr:
      Sky Matching with Per-Object Errors
    • 7.1.3 skyellipse:
      Sky Matching of Elliptical Regions
    • 7.1.4 sky3d: Spherical Polar Matching
    • 7.1.5 exact: Exact Matching
    • 7.1.6 1d, 2d, ...:
      Isotropic Cartesian Matching
    • 7.1.7 2d_anisotropic, ...:
      Anisotropic Cartesian Matching
    • 7.1.8 1d_err, 2d_err, ...:
      Cartesian Matching with Per-Object Errors
    • 7.1.9 2d_ellipse:
      Cartesian Matching of Elliptical Regions
    • 7.1.10 Custom Matchers
    • 7.1.11 Matcher Combinations
  • 7.2 Multi-Object Matches
• 8 Plotting
  • 8.1 Parameter Suffixes
  • 8.2 Output Modes
    • 8.2.1 swing
    • 8.2.2 out
    • 8.2.3 cgi
    • 8.2.4 discard
    • 8.2.5 auto
  • 8.3 Output Formats
  • 8.4 Comparison with TOPCAT plotting
• 9 Algebraic Expression Syntax
  • 9.1 Referencing Column Values
  • 9.2 Referencing Parameter Values
  • 9.3 Null Values
  • 9.4 Operators
  • 9.5 Functions
    • 9.5.1 TrigDegrees
    • 9.5.2 Times
    • 9.5.3 Maths
    • 9.5.4 Conversions
    • 9.5.5 Formats
    • 9.5.6 Arithmetic
    • 9.5.7 CoordsRadians
    • 9.5.8 Tilings
    • 9.5.9 Distances
    • 9.5.10 Arrays
    • 9.5.11 Strings
    • 9.5.12 Fluxes
    • 9.5.13 CoordsDegrees
  • 9.6 Examples
  • 9.7 Advanced Topics
    • 9.7.1 Expression evaluation
    • 9.7.2 Instance Methods
    • 9.7.3 Adding User-Defined Functions
• A Commands By Category
• B Command Reference
  • B.1 calc: Evaluates expressions
  • B.2 coneskymatch: Crossmatches table on sky position against remote cone service
  • B.3 funcs: Browses functions used by algebraic expression langauage
  • B.4 plot2d: 2D Scatter Plot
  • B.5 plot3d: 3D Scatter Plot
  • B.6 plothist: Histogram
  • B.7 regquery: Queries the VO registry
  • B.8 server: Runs an HTTP server to perform STILTS commands
  • B.9 sqlclient:
    Executes SQL statements
  • B.10 sqlskymatch:
    Crossmatches table on sky position against SQL table
  • B.11 sqlupdate: Updates values in an SQL table
  • B.12 taplint: Tests TAP services
  • B.13 tapquery: Queries a Table Access Protocol server
  • B.14 tapresume: Resumes a previous query to a Table Access Protocol server
  • B.15 tcat: Concatenates multiple similar tables
  • B.16 tcatn: Concatenates multiple tables
  • B.17 tcopy: Converts between table formats
  • B.18 tcube: Calculates N-dimensional histograms
  • B.19 tjoin: Joins multiple tables side-to-side
  • B.20 tmatch1: Performs a crossmatch internal to a single table
  • B.21 tmatch2: Crossmatches 2 tables using flexible criteria
  • B.22 tmatchn: Crossmatches multiple tables using flexible criteria
  • B.23 tmulti: Writes multiple tables to a single container file
  • B.24 tmultin: Writes multiple processed tables to single container file
  • B.25 tpipe: Performs pipeline processing on a table
  • B.26 tskymatch2: Crossmatches 2 tables on sky position
  • B.27 votcopy: Transforms between VOTable encodings
  • B.28 votlint: Validates VOTable documents
• C Release Notes
  • C.1 Acknowledgements
  • C.2 Version History