Here are some examples of using
stilts arrayjoin in=dr3-sources.vot atable='"https://gea.esac.esa.int/data-server/data?RETRIEVAL_TYPE=XP_SAMPLED&RELEASE=Gaia+DR3&ID="+source_id' icmd=progress out=sources-with-xp.fits
The input file
dr3-sources.vot must contain the column
source_id giving the Gaia DR3 source ID
corresponding to that row.
atable expression is a URL built using that
source_id column and a base URL that can be obtained
by examining the DR3 catalogue
or by examining the DataLink service descriptor returned from a
source catalogue query.
The output file
is a FITS table with the same content as the input
but with three added array-valued columns,
as supplied by tables downloaded from the URL in the
For each row of the output table, the lengths of those three arrays
will be the same, namely the row count of the table that supplied them.
These matched arrays can be manipulated within STILTS,
for instance using the
or to produce plots using the
arrayquantile plot layer types.
icmd=progress filter is a useful convenience to see
how the command is progressing,
since the operation requires multiple downloads and so may be
stilts arrayjoin in=dr3-sources.vot atable='"https://gea.esac.esa.int/data-server/data?RETRIEVAL_TYPE=XP_SAMPLED&RELEASE=Gaia+DR3&ID="+source_id' icmd=progress keepall=false ocmd='constcol -acceptnull' out=sources-with-xp.fits
keepall=false parameter means that only those
rows for which array data exists will be retained in the output table,
rather than including blank entries in the array columns in cases
for which the remote table couldn't be loaded.
ocmd='constcol -acceptnull' filter looks for
columns in the output that have the same value (or null) in every row.
Since Gaia DR3 sampled spectra are all sampled onto the same grid,
in this case the
wavelength column will have the same
array value for every row, which is harmless but makes the output table
larger than required.
spots this and removes the
replacing it with a parameter having the same name,
which can therefore be referred to using the
stilts arrayjoin in=dl_dr3.fits icmd='select has_epoch_photometry' atable='"https://gea.esac.esa.int/data-server/data?RETRIEVAL_TYPE=EPOCH_PHOTOMETRY&ID="+urlEncode(designation)' afmt=votable acmd='select equals(BAND,\"G\")' acmd='keepcols "time mag flux"' out=with-epoch-photom.fits
designationfield is wrapped in the
urlEncodefunction when preparing the URL; this is necessary since that field may contain spaces which are not legal URL characters. Only those input rows are used for which the boolean
has_epoch_photometrycolumn is True; for the linked array tables the rows are limited to those with the
BANDcolumn having the value "
G"; and only the array columns
fluxare retained for inclusion into the output.
stilts arrayjoin in=rrlyrae.vot atable='"https://gaia.ari.uni-heidelberg.de/timeseries/gaiadr3?sourceid="+source_id' acmd='keepcols "time mag flux flux_error"' aparams='p1 pf' icmd=progress out=rrlyrae-timeseries.vot
aparams='p1 pf'parameter takes two of these and adds them as scalar-valued columns in the output table. Since the
pfparameter gives the variability period, a period-folded variability graph can then be plotted using an X coordinate like
stilts arrayjoin in=obscore-lotssdr2.vot atable=access_url icmd=progress icmd='select equals(dataproduct_type,\"spectrum\")' out=with-spectra.vot
access_urlfield. Only those rows with a
spectrum" are included. Note all the access_urls in the selected rows must point to spectrum files of a similar form (i.e. having the same columns), otherwise the command will fail.