Integral Science Archive TAP ISLA ivo://esavo/isla/obsloctap European Space Agency Bruno Merin esdc_leads@cosmos.esa.int +34918131456 Integral obsloctap ObsLocTAP and Integral observation resources https://www.cosmos.esa.int/web/integral/integral-data-archives https://isla.esac.esa.int/tap/tap ADQL 2.0 2.1 ADQL 2.1
esdc_array_dims(n VARCHAR) -> VARCHAR
Returns a text representation of array dimensions Parameters: n: Input array.
esdc_array_element(position INTEGER, n VARCHAR) -> VARCHAR
Returns the requested element (second argument) of the provided array as first argument in the input Parameters: position: array position of the element to be retrieved where position = 1 refers to the first array element n: Input array.
esdc_array_length(n VARCHAR, dim INTEGER) -> INTEGER
Returns the length of the requested array dimension Parameters: n: Input array. dim: Input dimension.
esdc_array_ndims(n VARCHAR) -> INTEGER
Returns the number of dimensions of the array. Parameters: n: Input array.
esdc_astrometric_parameter_error(pm_ra_ra DOUBLE, pm_de_ra DOUBLE, plx_de DOUBLE, pm_ra_de DOUBLE, pm_de_de DOUBLE, pm_ra_plx DOUBLE, plx_ra DOUBLE, pm_de_plx DOUBLE, pm_de_pm_ra DOUBLE, e_ra_deg DOUBLE, radial_velocity DOUBLE, e_rv DOUBLE, parallax DOUBLE, e_de_deg DOUBLE, e_plx DOUBLE, e_pm_ra DOUBLE, e_pm_de DOUBLE, de_ra DOUBLE) -> DOUBLE[21]
Returns the astrometric parameter errors double array to be used as input for epoch_prop() function Parameters: pm_ra_ra: Correlation Coefficient Proper Motion in RA/RA pm_de_ra: Correlation Coefficient Proper Motion in Dec/RA plx_de: Correlation Coefficient Parallax/Dec pm_ra_de: Correlation Coefficient Proper Motion in RA/Dec pm_de_de: Correlation Coefficient, Proper Motion in Dec/Dec pm_ra_plx: Correlation Coefficient Proper Motion in RA/Parallax plx_ra: Correlation Coefficient Parallax/RA pm_de_plx: Correlation Coefficient, Proper Motion in Dec/Parallax pm_de_pm_ra: Correlation Coefficient, Proper Motion in RA/Proper Motion in Dec e_ra_deg: Standard Error in Right Ascension (mas) radial_velocity: Radial Velocity (km/s) e_rv: Standard Error in Radial Velocity (km/s) parallax: Parallax (mas) e_de_deg: Standard Error in Declination (mas) e_plx: Standard Error in Parallax (mas) e_pm_ra: Standard Error in Proper Motion in RA (mas/yr) e_pm_de: Standard Error in Proper Motion in Dec (mas/yr) de_ra: Correlation Coefficient RA/Dec
esdc_astrometric_parameters(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE) -> DOUBLE[6]
Returns the astrometric parameters double array to be used as input for epoch_prop() function Parameters: ra: Right Ascension (deg) de: Declination (deg) parallax: Parallax (mas) pm_ra: Proper Motion in Right Ascension (mas/yr) pm_de: Proper Motion in Declination (mas/yr) radial_velocity: Radial Velocity (km/s)
esdc_cardinality(n VARCHAR) -> INTEGER
Returns the total number of elements in the array, or 0 if the array is empty. Parameters: n: Input array.
esdc_case_condition(default_value VARCHAR, conditions VARCHAR, results VARCHAR) -> VARCHAR
For an array of input conditions and results, return the first one found true. Parameters: default_value: Value to return if all conditions are false. conditions: Input conditions array. results: Input results array.
esdc_case_expression(input_value VARCHAR, default_value VARCHAR, condition_values VARCHAR, results VARCHAR) -> VARCHAR
For an array of input conditions and results, return the first one found equal to input value. Parameters: input_value: Value to compare condition values with. default_value: Value to return if none of condition_values equal input_value. condition_values: Input results array. results: Input results array.
esdc_crossmatch_positional(table_schema_a VARCHAR, table_name_a VARCHAR, table_schema_b VARCHAR, table_name_b VARCHAR, radius DOUBLE, output_table_name VARCHAR) -> BIGINT
For input tables, create a positional crossmatch for input radius and store it in a separate table. Parameters: table_schema_a: First table schema. table_name_a: First table name. table_schema_b: Second table schema. table_name_b: Second table name. radius: Crossmatch radius. output_table_name: Output table name.
esdc_current_date() -> TIMESTAMP
Returns a DATE value that represents the current date Parameters:
esdc_epoch_prop(radial_velocity DOUBLE, ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[6]
Returns all six input parameters (ra,dec,parallax,pm_ra,pm_dec,radial_velocity) propagated at the new arbitrary input epoch. Please note that the input argument radial_velocity denotes radial velocity in km/s while the corresponding output quantity is the radial proper motion in mas/yr computed as radial_velocity * parallax / 4.740,470,464 Parameters: radial_velocity: Radial Velocity (km/s) ra: Right Ascension (deg) de: Declination (deg) parallax: Parallax (mas) pm_ra: Proper Motion in Right Ascension (mas/yr) pm_de: Proper Motion in Declination (mas/yr) ref_epoch: Reference Julian Epoch out_epoch: Final Julian Epoch
esdc_epoch_prop(astrometric_parameters DOUBLE[6], ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[6]
Returns all six input parameters (ra,dec,parallax,pm_ra,pm_dec,radial_velocity) propagated at the new arbitrary input epoch. Please note that the input argument radial_velocity denotes radial velocity in km/s while the corresponding output quantity is the radial proper motion in mas/yr computed as radial_velocity * parallax / 4.740,470,464 Parameters: astrometric_parameters: Array with the full six input parameters needed (ra[deg],dec[deg],plx[mas],pm_ra[mas/yr],pm_dec[mas/yr],pm_rv[mas/yr]) ref_epoch: Reference Julian Epoch out_epoch: Final Julian Epoch
esdc_epoch_prop_covariance(ra DOUBLE, dec DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, e_ra_deg DOUBLE, e_de_deg DOUBLE, e_plx DOUBLE, e_pm_ra DOUBLE, e_pm_de DOUBLE, e_rv DOUBLE, de_ra DOUBLE, plx_ra DOUBLE, plx_de DOUBLE, pm_ra_ra DOUBLE, pm_ra_de DOUBLE, pm_ra_plx DOUBLE, pm_de_ra DOUBLE, pm_de_de DOUBLE, pm_de_plx DOUBLE, pm_de_pm_ra DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[6][6]
Returns the propagated covariance matrix from the epoch_prop function Parameters: ra: Right Ascension (deg) dec: Declination (deg) parallax: Parallax (mas) pm_ra: Proper Motion in Right Ascension (mas/yr) pm_de: Proper Motion in Declination (mas/yr) radial_velocity: Radial Velocity (km/s) e_ra_deg: Standard Error in Right Ascension (mas) e_de_deg: Standard Error in Declination (mas) e_plx: Standard Error in Parallax (mas) e_pm_ra: Standard Error in Proper Motion in RA (mas/yr) e_pm_de: Standard Error in Proper Motion in Dec (mas/yr) e_rv: Standard Error in Radial Velocity (km/s) de_ra: Correlation Coefficient RA/Dec plx_ra: Correlation Coefficient Parallax/RA plx_de: Correlation Coefficient Parallax/Dec pm_ra_ra: Correlation Coefficient Proper Motion in RA/RA pm_ra_de: Correlation Coefficient Proper Motion in RA/Dec pm_ra_plx: Correlation Coefficient Proper Motion in RA/Parallax pm_de_ra: Correlation Coefficient Proper Motion in Dec/RA pm_de_de: Correlation Coefficient, Proper Motion in Dec/Dec pm_de_plx: Correlation Coefficient, Proper Motion in Dec/Parallax pm_de_pm_ra: Correlation Coefficient, Proper Motion in RA/Proper Motion in Dec ref_epoch: Reference Julian Epoch (yr) out_epoch: Final Julian Epoch (yr)
esdc_epoch_prop_error(astrometric_parameters DOUBLE[6], astrometric_parameter_error DOUBLE[21], ref_epoch DOUBLE, out_epoch DOUBLE) -> DOUBLE[21]
Returns the error vector with the uncertainties associated to the propagated astrometric parameters plus the set of propagated correlation parameters Parameters: astrometric_parameters: Array with the full six input parameters needed (ra[deg],dec[deg],plx[mas],pm_ra[mas/yr],pm_dec[mas/yr],pm_rv[mas/yr]) astrometric_parameter_error: Array with the 21 covariance matrix elements (output from astrometric_parameter_error ADQL function) ref_epoch: Reference Julian Epoch out_epoch: Final Julian Epoch
esdc_epoch_prop_error(pm_ra_ra DOUBLE, pm_de_ra DOUBLE, plx_de DOUBLE, pm_ra_de DOUBLE, pm_de_de DOUBLE, pm_ra_plx DOUBLE, e_ra_deg DOUBLE, e_de_deg DOUBLE, e_plx DOUBLE, e_pm_ra DOUBLE, e_pm_de DOUBLE, e_rv DOUBLE, ra DOUBLE, plx_ra DOUBLE, pm_de_plx DOUBLE, pm_de_pm_ra DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE, de_ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE) -> DOUBLE[21]
Returns the error vector with the uncertainties associated to the propagated astrometric parameters plus the set of propagated correlation parameters Parameters: pm_ra_ra: Correlation Coefficient Proper Motion in RA/RA pm_de_ra: Correlation Coefficient Proper Motion in Dec/RA plx_de: Correlation Coefficient Parallax/Dec pm_ra_de: Correlation Coefficient Proper Motion in RA/Dec pm_de_de: Correlation Coefficient, Proper Motion in Dec/Dec pm_ra_plx: Correlation Coefficient Proper Motion in RA/Parallax e_ra_deg: Standard Error in Right Ascension (mas) e_de_deg: Standard Error in Declination (mas) e_plx: Standard Error in Parallax (mas) e_pm_ra: Standard Error in Proper Motion in RA (mas/yr) e_pm_de: Standard Error in Proper Motion in Dec (mas/yr) e_rv: Standard Error in Radial Velocity (km/s) ra: Right Ascension (deg) plx_ra: Correlation Coefficient Parallax/RA pm_de_plx: Correlation Coefficient, Proper Motion in Dec/Parallax pm_de_pm_ra: Correlation Coefficient, Proper Motion in RA/Proper Motion in Dec ref_epoch: Reference Julian Epoch (yr) out_epoch: Final Julian Epoch (yr) de_ra: Correlation Coefficient RA/Dec de: Declination (deg) parallax: Parallax (mas) pm_ra: Proper Motion in Right Ascension (mas/yr) pm_de: Proper Motion in Declination (mas/yr) radial_velocity: Radial Velocity (km/s)
esdc_epoch_prop_pos(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> VARCHAR
Returns the new position (ra,dec) of the source at the new arbitrary input epoch Parameters: ra: Right Ascension (deg) de: Declination (deg) parallax: Parallax (mas) pm_ra: Proper Motion in Right Ascension (mas/yr) pm_de: Proper Motion in Declination (mas/yr) radial_velocity: Radial Velocity (km/s) ref_epoch: Reference Julian Epoch out_epoch: Final Julian Epoch
esdc_greatest(v1 DOUBLE, v2 DOUBLE) -> DOUBLE
Select the largest value among given arguments. Parameters: v1: First argument. v2: Second argument.
esdc_if_then_else(condition VARCHAR, ouput_value VARCHAR, default_value VARCHAR) -> VARCHAR
If input condition is true, return output value. Otherwise return default value. Parameters: condition: Value to compare to true. ouput_value: Value to return if condition is true. default_value: Value to return if condition is false.
esdc_least(v1 DOUBLE, v2 DOUBLE) -> DOUBLE
Select the smallest value among given arguments. Parameters: v1: First argument. v2: Second argument.
esdc_left(string VARCHAR, n INTEGER) -> VARCHAR
The function returns the first n characters in the string. Parameters: string: a string from which a number of the leftmost characters is returned. n: an integer that specifies the number of left-most characters in the string should be returned. If n is negative, the function returns the leftmost characters in the string but last |n| (absolute) characters.
esdc_length(string VARCHAR) -> INTEGER
The function returns the number of characters in the string. Parameters: string: the string that you want to calculate its length.
esdc_nullif(value1 VARCHAR, value2 VARCHAR) -> VARCHAR
Returns a null value if value1 equals value2; otherwise it returns value1. Parameters: value1: Input value 1. value2: Input value 2.
esdc_position(substring VARCHAR, string VARCHAR) -> INTEGER
The function returns the location of a substring in a string. Parameters: substring: the string that you want to locate. string: the string for which the substring is searched.
esdc_radial_velocity(pm_rv DOUBLE, parallax DOUBLE) -> DOUBLE
Returns the radial velocity in units of mas/yr Parameters: pm_rv: Radial proper motion (mas/yr) parallax: Parallax (mas)
esdc_right(string VARCHAR, n INTEGER) -> VARCHAR
The function returns the last n characters in a string. Parameters: string: a string from which a number of the rightmost characters is returned. n: an integer that specifies the number of right-most characters in the string should be returned. If n is negative, the function returns all characters in the string but first |n| (absolute) characters.
esdc_stddev(n DOUBLE) -> DOUBLE
Standard deviation. Parameters: n: Input value.
esdc_substring(string VARCHAR, start_position INTEGER, length INTEGER) -> VARCHAR
The function returns a part of string. Parameters: string: the string that you want to get a part extracted. start_position: an integer that specifies where you want to extract the substring. If start_position equals zero, the substring starts at the first character of the string. The start_position can be only positive length: a positive integer that determines the number of characters that you want to extract from the string beginning at start_position. If the sum of start_position and length is greater than the number of characters in the string, the substring function returns the whole string beginning at start_position. The length parameter is optional. If you omit the length parameter, the substring function returns the whole string started at start_position.
esdc_to_bigint(n DOUBLE) -> BIGINT
Converts input value to BIGINT type. Parameters: n: Input value.
esdc_to_boolean(n INTEGER) -> BOOLEAN
Converts input value to BOOLEAN type. Parameters: n: Input value.
esdc_to_char(n DOUBLE) -> VARCHAR
Converts input value to VARCHAR type. Parameters: n: Input value.
esdc_to_double(n DOUBLE) -> DOUBLE
Converts input value to DOUBLE type. Parameters: n: Input value.
esdc_to_integer(n DOUBLE) -> INTEGER
Converts input value to INTEGER type. Parameters: n: Input value.
esdc_to_real(n DOUBLE) -> REAL
Converts input value to REAL type. Parameters: n: Input value.
esdc_to_smallint(n DOUBLE) -> SMALLINT
Converts input value to SMALLINT type. Parameters: n: Input value.
esdc_translate(string VARCHAR, from VARCHAR, to VARCHAR) -> VARCHAR
The function performs several single-character, one-to-one translation in one operation. Parameters: string: the string subjected to translation. from: a set of characters in the first argument (_string_) that should be replaced. to: a set of characters that replaces the _from_ in the _string_.
esdc_trim(characters VARCHAR, string VARCHAR) -> VARCHAR
removes the longest string that contains a specific character from a string. By default, the function removes spaces if you don’t specify explicitly which character you want to remove. Parameters: characters: optional parameter that defines a literal specifying explicitly which characters you want to remove in the string. Accepted literals are: LEADING, TRAILING and BOTH. Example of use: TRIM(BOTH, string) string: the string for which the removal is requested. Mandatory parameter: example of use: TRIM(string)
gavo_ipix(long REAL, lat REAL) -> BIGINT
Returns the q3c ipix (Koposov and Bartunov, 2006) for a long/lat pair (it simply wraps the q3c_angpix function). Parameters: long: The longitude to compute the ipix for. lat: The latitude to compute the ipix for.
ivo_epoch_prop_pos(ra DOUBLE, de DOUBLE, parallax DOUBLE, pm_ra DOUBLE, pm_de DOUBLE, radial_velocity DOUBLE, ref_epoch DOUBLE, out_epoch DOUBLE) -> POINT
Returns the new position (ra,dec) of the source at the new arbitrary input epoch Parameters: ra: Right Ascension (deg) de: Declination (deg) parallax: Parallax (mas) pm_ra: Proper Motion in Right Ascension (mas/yr) pm_de: Proper Motion in Declination (mas/yr) radial_velocity: Radial Velocity (km/s) ref_epoch: Reference Julian Epoch out_epoch: Final Julian Epoch
ivo_geom_transform(from_sys VARCHAR, to_sys VARCHAR, geo VARCHAR) -> VARCHAR
The function transforms ADQL geometries between various reference systems. Parameters: from_sys: name of the source reference system. to_sys: name of the target reference system. geo: an ADQL geometry (POINT, CIRCLE, POLYGON).
ivo_hashlist_has(hashlist VARCHAR, item VARCHAR) -> INTEGER
The function returns 1 if, compared case-insensitively, the second argument is in the list of words encoded in the first argument, 0 otherwise. Parameters: hashlist: A string containing hash-separated terms. item: A string containing a single term not containing a hash.
ivo_hasword(needle VARCHAR, haystack VARCHAR) -> INTEGER
Returns 1 if all tokens from the string needle are contained (in some sense) in the string haystack, 0 otherwise. Parameters: needle: A string to locate in haystack. haystack: A text to match needle in.
ivo_histogram(val REAL, lower REAL, upper REAL, nbins INTEGER) -> INTEGER[*]
This aggregate function returns a histogram of val with nbins+2 elements. Assuming 0-based arrays, results[0] contains the number of underflows (i.e., val < lower), result[nbins+1] the number of overflows. Elements 1…nbins are the counts in nbins bins of width (upper−lower)/nbins. Clients will have to convert back to physical units using some external communication, as there currently is no (meta-) data as lower and upper in the TAP response. Parameters: val: the value to bin. lower: the lower limit of the histogram upper: the upper limit of the histogram nbins: the number of "natural" bins in the histogram.
ivo_interval_overlaps(a1 DOUBLE, b1 DOUBLE, a2 DOUBLE, b2 DOUBLE) -> INTEGER
Function returns 1 if the interval [a1…b1] overlaps with the interval [a2…b2]. Parameters: a1: The lower bound of the first interval. b1: The upper bound of the first interval. a2: The lower bound of the second interval. b2: The upper bound of the second interval.
ivo_nocasematch(value VARCHAR, pattern VARCHAR) -> INTEGER
Evaluates value ILIKE pattern, i.e., pattern is defined as for the SQL LIKE operator, but the match is performed case-insensitively. Parameters: value: A string-valued SQL expression. pattern: A SQL pattern for LIKE evaluation.
ivo_normal_random(mu REAL, sigma REAL) -> REAL
Returns a random number drawn from a normal distribution. Parameters: mu: The mean of the normal distribution. sigma: The width of the normal distribution..
ivo_simbadpoint(identifier VARCHAR) -> POINT
Queries Simbad for an identifier and returns the corresponding point. Parameters: identifier: A string containing an identifier Simbad can resolve.
ivo_string_agg(expression VARCHAR, delimiter VARCHAR) -> VARCHAR
An aggregate function returning all values of expression concatenated with delimiter. Parameters: expression: A SQL expression giving the strings to concatenate. delimiter: A string used to concatenate the values of expression in each group.
ivo_to_jd(d TIMESTAMP) -> REAL
Converts a timestamp to a Julian date. Parameters: d: The SQL timestamp to convert.
ivo_to_mjd(d TIMESTAMP) -> REAL
Converts a timestamp to modified Julian date. Parameters: d: The SQL timestamp to convert.
AREA
BOX
CENTROID
CIRCLE
CONTAINS
COORD1
COORD2
COORDSYS
DISTANCE
INTERSECTS
POINT
POLYGON
REGION
WITH
LOWER
UPPER
ILIKE
UNION
EXCEPT
INTERSECT
OFFSET
COALESCE
CAST
 application/x-votable+xml votable_gzip application/x-votable+xml votable application/x-votable+xml votable_plain text/csv csv text/ecsv ecsv text/tab-separated-values tsv application/json json application/fits fits text/xml votable_plain_conesearch 259200 259200 3600 3600 3000000 3000000 https://isla.esac.esa.int/tap/tap/availability https://isla.esac.esa.int/tap/tap/tables https://isla.esac.esa.int/tap/tap/examples/ https://isla.esac.esa.int/tap/tap/capabilities esasky esasky.isla_mosaics product_link Download link meta.dataset;meta.ref.url char primary obsid Observation ID meta.id char primary ra Right Ascension of the Pointing Position degree pos.eq.ra;meta.main double primary dec Declination of the Pointing Position degree pos.eq.dec;meta.main double primary srcname char instrument char detector char band char epoch char rev_range char start_revno char end_revno char starttime char endtime char exposure long prop_id char title char surname char scw_number long scw_size long fov Internal ESASky column for searching and indexing the footprint with pgsphere pos.outline;meta.pgsphere double npix long
esasky.isla_mosaics_q3c_maxmin dec_maxval char dec_minval char exposure_maxval char exposure_minval char moc_ipix int moc_order int npix_maxval char npix_minval char ra_maxval char ra_minval char scw_number_maxval char scw_number_minval char scw_size_maxval char scw_size_minval char
esasky.isla_mosaics_q3c_moc moc_count int moc_coverage_count int moc_ipix int moc_order int
esasky.isla_observations product_link Download link meta.dataset;meta.ref.url1 char obsid Observation ID meta.id char ra Right Ascension of the Pointing Position degree pos.eq.ra;meta.main double dec Declination of the Pointing Position degree pos.eq.dec;meta.main double srcname char rev_range char start_revno char end_revno char starttime char endtime char exposure long prop_id char title char surname char scw_number long scw_size long fov Internal ESASky column for searching and indexing the footprint with pgsphere pos.outline;meta.pgsphere double npix long
esasky.isla_observations_q3c_maxmin dec_maxval char dec_minval char exposure_maxval char exposure_minval char moc_ipix int moc_order int npix_maxval char npix_minval char ra_maxval char ra_minval char scw_number_maxval char scw_number_minval char scw_size_maxval char scw_size_minval char
esasky.isla_observations_q3c_moc moc_count int moc_coverage_count int moc_ipix int moc_order int
esasky.isla_short_timeseries product_link Download link meta.dataset;meta.ref.url1 char obsid Observation ID meta.id char ra Right Ascension of the Pointing Position degree pos.eq.ra;meta.main double dec Declination of the Pointing Position degree pos.eq.dec;meta.main double srcname char instrument char detector char band char epoch char rev_range char start_revno char end_revno char starttime char endtime char exposure long prop_id char title char surname char scw_number long scw_size long fov Internal ESASky column for searching and indexing the footprint with pgsphere pos.outline;meta.pgsphere double npix long
esasky.isla_short_timeseries_q3c_maxmin dec_maxval char dec_minval char exposure_maxval char exposure_minval char moc_ipix int moc_order int npix_maxval char npix_minval char ra_maxval char ra_minval char scw_number_maxval char scw_number_minval char scw_size_maxval char scw_size_minval char
esasky.isla_short_timeseries_q3c_moc moc_count int moc_coverage_count int moc_ipix int moc_order int
esasky.isla_spectra product_link Download link meta.dataset;meta.ref.url1 char obsid Observation ID meta.id char ra Right Ascension of the Pointing Position degree pos.eq.ra;meta.main double dec Declination of the Pointing Position degree pos.eq.dec;meta.main double srcname char instrument char detector char epoch char rev_range char start_revno char end_revno char starttime char endtime char exposure long prop_id char title char surname char scw_number long scw_size long fov Internal ESASky column for searching and indexing the footprint with pgsphere pos.outline;meta.pgsphere double npix long
esasky.isla_spectra_q3c_maxmin dec_maxval char dec_minval char exposure_maxval char exposure_minval char moc_ipix int moc_order int npix_maxval char npix_minval char ra_maxval char ra_minval char scw_number_maxval char scw_number_minval char scw_size_maxval char scw_size_minval char
esasky.isla_spectra_q3c_moc moc_count int moc_coverage_count int moc_ipix int moc_order int
ila ila.band band_oid long instrument_oid long name char
ila.cat_expomap cat_expomap_oid long expomap_id char format char name char type char url char
ila.cat_grb b double cat_grb_oid long counterparts char dec char dec_deg double flux double gcn char grb_id char l double mjd double notes char products char ra char ra_deg double "references" char t90 double type char uncertainty double
ila.cat_omcOMC Catalog cat_omc_oid OMC catalog order id long comments char dec Dec char dec_deg Dec in degress deg double epoch days double err_epoch days double err_period days double err_v_mean mag double gaia_dr3_id long igrc_id char igrc_name char name Name char omc_id OMC ID char period days double ra RA char ra_deg RA in degrees deg double sp_type char tag_cont char time_first days double time_last days double var_group char var_type_omc char var_type_vsx char v_max mag double v_mean mag double v_min mag double
ila.cat_sourceHigh Energy Source Catalog full table cat_source_oid long cat_source_type_oid long class Source class according to HEASARC Classification char comments Other source names and comments on classification char day_id double dec Source Declination deg double e_max Maximum energy of the spectrum keV double e_min Minimum energy of the spectrum keV double err_rad Source Error Radius deg double flag Source flag short flux Flux in photons per unit area per second ph cm-2 s-1 double flux_err Uncertainty in flux measurement ph cm-2 s-1 double isgr_flux_1 counts s-1 double isgr_flux_2 counts s-1 double isgri_flag ISGRI Source detection flag short isgri_flag2 Extended ISGRI Source detection flag short jemx_flag JEMX Source detection flag short jemx_flux_1 counts s-1 double jemx_flux_2 counts s-1 double name Common name of the source char omc_id char pics_flux_1 counts s-1 double pics_flux_2 counts s-1 double picsit_flag PICSIT Source detection flag short ra Source Right Ascension deg double sel_flag Selection flag for source identification short source_id Source catalog id char spa_modl Model and parameters for flux determination char spa_npar Model and parameters for flux determination long spa_pars Model and parameters for flux determination double spe_modl Model and parameters for flux determination char spe_npar Model and parameters for flux determination long spe_pars Model and parameters for flux determination double spi_flag SPI Source detection flag short spi_flux_1 ph cm-2 s-1 double spi_flux_2 ph cm-2 s-1 double var_modl Model and parameters for flux determination char var_npar Model and parameters for flux determination long var_pars Model and parameters for flux determination double
ila.cat_source_name cat_source_name_oid long cat_source_oid long main boolean name char
ila.cat_source_type cat_source_type_oid long parent_cat_source_type_oid long type char
ila.community_product community_product_oid long create_date char create_user char create_user_full_name char description char instruments char publication_url char repository_url char scientific_subjects char target char update_date char
ila.cons_pub_obs dec double end_revno char endtime char exposure long obsid char prop_id char ra double rev_range char scw_number long scw_size long srcname char start_revno char starttime char surname char title char
ila.epoch band_oid long epoch char instrument_oid long source_id char
ila.instrument instrument_oid long name char
ila.long_tseries cat_source_oid long detector char instrument_oid long long_tseries_oid long path char
ila.mosaic band_oid long detector char epoch char mosaic_oid long obs_id char path char plot_path char revolution char
ila.publications bib_code char match_name char publications_oid long source_id char source_name char title char
ila.science_window dec double endtime char expid int good_isgri int good_jemx1 int good_jemx2 int good_omc int good_picsit int good_spi int ibismode int jmx1mode int jmx2mode int mjd_endtime double mjd_starttime double obsid char obstype char omcmode int path char pointingid int ra double rev_fraction double revno char science_window_oid long scwid char scw_type char scw_ver int "size" int spimode int starttime char swg_date char telapse double
ila.short_tseries band_oid long cat_source_oid long detector char epoch char obs_id char path char revolution char short_tseries_oid long
ila.spectra cat_source_oid long detector char epoch char instrument_oid long obs_id char path char plot_path char revolution char spectra_oid long
ila.v_cat_omc_explorerOMC Catalog cat_omc_oid OMC catalog order id long comments char dec Dec char dec_deg Dec in degress deg double epoch days double err_epoch days double err_period days double err_v_mean mag double gaia_dr3_id long igrc_id char igrc_name char name Name char omc_id OMC ID char period days double ra RA char ra_deg RA in degrees deg double sp_type char tag_cont char time_first days double time_last days double var_group char var_type_omc char var_type_vsx char v_max mag double v_mean mag double v_min mag double
ila.v_cat_source cat_source_oid long cat_source_type_oid long class char dec double isgri_flag short isgri_flag2 short jemx_flag short name char omc_id char picsit_flag short ra double source_id char spi_flag short
ila.v_cat_source_explorerHigh Energy Source Catalog Explorer table alt_names Other common name of the source char class Source class according to HEASARC Classification char dec Source Declination deg double err_rad Source Error Radius deg double isgr_flux_1 counts s-1 double isgr_flux_2 counts s-1 double isgri_flag ISGRI Source detection flag short isgri_flag2 Extended ISGRI Source detection flag short jemx_flag JEMX Source detection flag short jemx_flux_1 counts s-1 double jemx_flux_2 counts s-1 double name Common name of the source char pics_flux_1 counts s-1 double pics_flux_2 counts s-1 double picsit_flag PICSIT Source detection flag short ra Source Right Ascension deg double source_id Source catalog id char spi_flag SPI Source detection flag short spi_flux_1 ph cm-2 s-1 double spi_flux_2 ph cm-2 s-1 double
ila.v_doi_generation abstract char download_url char endtime char obsids char prop_id char publications char starttime char surname char title char
ivoa ivoa.obscore access_estsize long access_format char access_url char calib_level int dataproduct_type char em_max double em_min double em_res_power double em_xel long facility_name char instrument_name char obs_collection char obs_id char obs_publisher_did char obs_release_date char o_ucd char pol_states char pol_xel short s_dec double s_fov double s_ra double s_region double s_resolution double s_xel1 long s_xel2 long target_name char t_exptime double t_max double t_min double t_resolution double t_xel long
ivoa.obsplan category char em_max m em.wl;stat.max Char.SpectralAxis.Coverage.Bounds.Limits.HiLimit double em_min m em.wl;stat.min Char.SpectralAxis.Coverage.Bounds.Limits.LoLimit double em_res_power spect.resolution Char.SpectralAxis.Resolution.ResolPower.refVal double execution_status char exposure_id char facility_name meta.id;instr.tel Provenance.ObsConfig.Facility.name char instrument_name meta.id;instr Provenance.ObsConfig.Instrument.name char obs_collection meta.id DataID.collection char obs_id meta.id DataID.observationID char o_ucd meta.ucd Char.ObservableAxis.ucd char "pi" char pol_states meta.code;phys.polarization Char.PolarizationAxis.stateList char pol_xel meta.number Char.PolarizationAxis.numBins short priority short prop_id char revolution short s_dec deg pos.eq.dec Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C2 double s_fov deg phys.angSize;instr.fov Char.SpatialAxis.Coverage.Bounds.Extent.diameter double s_ra deg pos.eq.ra Char.SpatialAxis.Coverage.Location.Coord.Position2D.Value2.C1 double s_region pos.outline;obs.field Char.SpatialAxis.Coverage.Support.Area double s_resolution arcsec pos.angResolution Char.SpatialAxis.Resolution.Refval.value double target_name meta.id;src Target.name char t_exptime s time.duration;obs.exposure Char.TimeAxis.Coverage.Support.Extent double t_max d time.end;obs.exposure Char.TimeAxis.Coverage.Bounds.Limits.StopTime double t_min d time.start;obs.exposure Char.TimeAxis.Coverage.Bounds.Limits.StartTime double t_plan_exptime s time.duration;obs.exposure Char.TimeAxis.Coverage.Support.Extent double t_planning d double tracking_type char t_resolution s time.resolution Char.TimeAxis.Resolution.Refval.value double
job_upload public public.dualauxiliary table to be used as dummy "from" dummy int
tap_config tap_config.coord_sys epoch char equinox char id char system char xml_output char
tap_config.properties "key" char "value" char
tap_schema tap_schema.columnsTAP SCHEMA columns arraysize char column_index int column_name char datatype char db_column_name char description char indexed int principal int schema_name char "size" int std int table_name char ucd char unit char utype char xtype char tap_schema.tables table_name table_name TAP schema table name
tap_schema.key_columnsTAP SCHEMA key columns from_column char key_id char target_column char tap_schema.keys key_id key_id TAP schema key columns key id
tap_schema.keysTAP SCHEMA keys description char from_table char key_id char target_table char utype char tap_schema.tables from_table table_name TAP schema keys from table tap_schema.tables target_table table_name TAP schema keys target table
tap_schema.schemasTAP SCHEMA schemas db_schema_name char description char schema_index int schema_name char utype char
tap_schema.tablesTAP SCHEMA tables db_table_name char description char schema_name char "size" long size_bytes long table_index int table_name char table_type char utype char tap_schema.schemas schema_name schema_name TAP schema schema name
tap_upload