TAP server for Konkoly TAP servicekonkoly TAPivo://konkoly.hu/tapKonkoly ObservatorySzakats Roberthttps://konkoly.hu/images/logoY_s.jpgSzakats RobertKonkoly-Thege Miklos ut 15-17, 1121 Hungaryszakats.robert@csfk.mta.huvirtual-observatoriescatalogsThe TAP server for Konkoly's TAP end point. The Table Access
Protocol (TAP) lets you execute queries against our database tables,
inspect various metadata, and upload your own data. It is thus the
VO's premier way to access public data holdings.
Tables exposed through this endpoint include: epn_core from the sbnaf schema, columns, groups, key_columns, keys, schemas, tables from the tap_schema schema.http://nadir.konkoly.hu:80/__system__/tap/run/infoIsServiceForSmall Bodies Near and FarSmall Bodies Near and FarSmall Bodies Near and Farhttp://nadir.konkoly.hu:80/tapADQL2.02.1The Astronomical Data Query Language is the standard IVOA dialect of SQL; it contains a very general SELECT statement as well as some extensions for spherical geometry and higher mathematics.returns the authority part of an ivoid (or, more generally a URI).
So, ivo://org.gavo.dc/foo/bar#baz becomes org.gavo.dc.
The behaviour for anything that's not a full URI is undefined.gavo_ipix returns the q3c ipix for a long/lat pair (it simply wraps
the 13c_ang2ipix function).
This is probably only relevant when you play tricks with indices or
PPMXL ids.gavo_match returns 1 if the POSIX regular expression pattern
matches anything in string, 0 otherwise.returns the spectral value expr converted to dest_unit.
expr has to be in either energy, wavelength, or frequency, and dest_unit
must be a VOUnit giving another spectral unit (e.g., MHz, keV, nm, or
Angstrom). This is intended to let users express spectral constraints
in their preferred unit independently of the choice of unit in the
database. Examples::
gavo_specconv(obscore.em_min, "keV") > 300
gavo_specconv(obscore.em_max, "MHz") > 30
gavo_specconv(spectral_start, "Angstrom") > 4000
There is a variant of gavo_specconv accepting expr's unit in a third
argument.returns expr assumed to be in expr_unit expressed in dest_unit.
This is a variant of the two-argument gavo_specconv for when
the unit of expr is not known to the ADQL translator, either because
it because it is a literal or because it does not look like
a spectral unit. Examples::
gavo_specconv(656, 'nm', 'J') BETWEEN spectral_start AND spectral_end
gavo_specconv(arccos(phi)*incidence, 'Hz', 'eV')
Clearly, overriding known units is likely to yield bad results;
the translator therefore warns if an existing unit is overridden
with a different unit.returns 1 if matchagainst is term or narrower in the IVOA vocabulary
vocname, 0 otherwise.
This is intended for semantic querying. For instance,
gavo_vocmatch('datalink/core', 'calibration', semantics) would be 1
if semantics is any of calibration, bias, dark, or flat.
For RDF-flavoured vocabularies (strict trees), term will expand to the
entire branch rooted in term. For SKOS-flavoured vocabularies (where
narrower is not transitive), only directly narrower terms will be included.
Both the term and the vocabulary name must be string literals (i.e.,
constants). matchagainst can be any string-valued expression.The function transforms ADQL geometries between various reference systems.
geo can be a POINT, a CIRCLE, or a POLYGON, and the function will return a
geometry of the same type. In the current implementation, from_sys and
to_sys must be literal strings (i.e., they cannot be computed through
expressions or be taken from database columns).
All transforms are just simple rotations, which is only a rough
approximation to the actual relationships between reference systems
(in particular between FK4 and ICRS-based ones). Note that, in particular,
the epoch is not changed (i.e., no proper motions are applied).
We currently support the following reference frames: ICRS, FK5 (which
is treated as ICRS), FK4 (for B1950. without epoch-dependent corrections),
GALACTIC. Reference frame names are case-sensitive.The function takes two strings; the first is a list of words not
containing the hash sign (#), concatenated by hash signs, the second is
a word not containing the hash sign. It returns 1 if, compared
case-insensitively, the second argument is in the list of words coded in
the first argument. The behaviour in case the the second
argument contains a hash sign is unspecified.gavo_hasword returns 1 if needle shows up in haystack, 0 otherwise. This
is for "google-like"-searches in text-like fields. In word, you can
actually employ a fairly complex query language; see
https://www.postgresql.org/docs/current/textsearch.html
for details.returns a POINT corresponding to the center of the healpix with
the given index at the given order.Returns the index of the (nest) healpix with order containing the
spherical point (ra, dec).
An alternative, 2-argument form
ivo_healpix_index(order INTEGER, p POINT) -> BIGINT
is also available.The aggregate function returns a histogram of val with nbins+2 elements.
Assuming 0-based arrays, result[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, there currently is no (meta-) data as lower and upper in
the TAP response.The function returns 1 if the interval iv contains val, 0 otherwise.
The lower limit is always included in iv, behaviour on the upper
limit is column-specific.The function returns 1 if the interval [l1...h1] overlaps with
the interval [l2...h2]. For the purposes of this function,
the case l1=h2 or l2=h1 is treated as overlap. The function
returns 0 for non-overlapping intervals.ivo_nocasematch returns 1 if pattern matches value, 0 otherwise.
pattern is defined as for the SQL LIKE operator, but the
match is performed case-insensitively. This function in effect
provides a surrogate for the ILIKE SQL operator that is missing from
ADQL.
On this site, this is actually implemented using python's and SQL's
LOWER, so for everything except ASCII, your mileage will vary.The function returns a random number drawn from a normal distribution
with mean mu and width sigma.
Implementation note: Right now, the Gaussian is approximated by
summing up and scaling ten calls to random. This, hence, is not
very precise or fast. It might work for some use cases, and we
will provide a better implementation if this proves inadequate.gavo_simbadpoint queries simbad for an identifier and returns the
corresponding point. Note that identifier can only be a literal,
i.e., as simple string rather than a column name. This is because
our database cannot query simbad, and we probably wouldn't want
to fire off millions of simbad queries anyway; use simbad's own
TAP service for this kind of application.An aggregate function returning all values of
expression within a GROUP contcatenated with delimiterThe function converts a postgres timestamp to julian date.
This is naive; no corrections for timezones, let alone time
scales or the like are done; you can thus not expect this to be
good to second-precision unless you are careful in the construction
of the timestamp.The function converts a postgres timestamp to modified julian date.
This is naive; no corrections for timezones, let alone time
scales or the like are done; you can thus not expect this to be
good to second-precision unless you are careful in the construction
of the timestamp.Written after a table reference, TABLESAMPLE(10) will make the database only use 10% of the rows; these are `somewhat random' in that the system will use random blocks. This should be good enough when just testing queries (and much better than using TOP n).A geometry function creating MOCs. It either takes a string argument with an ASCII MOC ('4/13 17-18 8/3002'), or an order and another geometry.You can compute with vectors here. See https://wiki.ivoa.net/twiki/bin/view/IVOA/ADQLVectorMath for an overview of the functions and operators available.The SQL92 CASE expressiontext/tab-separated-valuestsvtext/plaintxttext/csvcsv_baretext/csv;header=presentcsvapplication/jsonjsonapplication/geo+jsongeojsonapplication/x-votable+xmlvotableapplication/x-votable+xml;serialization=BINARY2votable/b2votableb2application/x-votable+xml;serialization=TABLEDATAtext/xmlvotable/tdvotabletdapplication/x-votable+xml;serialization=TABLEDATA;version=1.1text/xmlvotabletd1.1application/x-votable+xml;version=1.1text/xmlvotable1.1application/x-votable+xml;serialization=TABLEDATA;version=1.2text/xmlvotabletd1.2application/x-votable+xml;serialization=TABLEDATA;version=1.6vodmlapplication/x-votable+xml;version=1.6vodmlbtext/htmlhtmlapplication/fitsfits1728003600200002000000020000000http://nadir.konkoly.hu:80/__system__/tap/run/availabilityhttp://nadir.konkoly.hu:80/__system__/tap/run/capabilitieshttp://nadir.konkoly.hu:80/__system__/tap/run/tableMetadatatap_schema TAP server for Konkoly's Table Access Protocol (TAP) service with
table metadata.tap_schema.tablesTables available for ADQL querying.schema_nameFully qualified schema namecharnullabletable_nameFully qualified table namecharindexedprimarytable_typeOne of: table, viewcharnullabledescriptionBrief description of the tableunicodeCharnullableutypeutype if the table corresponds to a data modelcharnullabletable_indexSuggested position this table should take in a sorted list of tables from this data centerintnullablesourcerdId of the originating rd (local information)charnullablenrowsThe approximate size of the table in rowslongnullabletap_schema.schemasschema_nameschema_name
tap_schema.columnsColumns in tables available for ADQL querying.table_nameFully qualified table namecharindexedprimarycolumn_nameColumn namecharindexedprimarydescriptionBrief description of columnunicodeCharnullableunitUnit in VO standard formatcharnullableucdUCD of column if anycharnullableutypeUtype of column if anycharnullabledatatypeADQL datatypecharnullablearraysizeArraysize in VOTable notationcharnullablextypeVOTable extended type information (for special interpretation of data content, e.g., timestamps or points)charnullable"size"Legacy length (ignore if you can).intnullableprincipalIs column principal?intindexedIs there an index on this column?intstdIs this a standard column?intsourcerdId of the originating rd (local information)charnullablecolumn_index1-based index of the column in database order.shortnullabletap_schema.tablestable_nametable_name
tap_schema.schemasSchemas containing tables available for ADQL querying.schema_nameFully qualified schema namecharindexedprimarydescriptionBrief description of the schemaunicodeCharnullableutypeutype if schema corresponds to a data modelcharnullableschema_indexSuggested position this schema should take in a sorted list of schemas from this data center.intnullable
tap_schema.keysForeign key relationships between tables available for ADQL querying.key_idUnique key identifiercharindexedprimaryfrom_tableFully qualified table namecharnullabletarget_tableFully qualified table namecharnullabledescriptionDescription of this keyunicodeCharnullableutypeUtype of this keycharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.tablesfrom_tabletable_nametap_schema.tablestarget_tabletable_name
tap_schema.key_columnsColumns participating in foreign key relationships between tables
available for ADQL querying.key_idKey identifier from TAP_SCHEMA.keyscharnullablefrom_columnKey column name in the from tablecharnullabletarget_columnKey column in the target tablecharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.keyskey_idkey_id
tap_schema.groupsColumns that are part of groups within tables available for ADQL
querying.table_nameFully qualified table namecharnullablecolumn_nameName of a column belonging to the groupcharnullablecolumn_utypeutype the column within the groupcharnullablegroup_nameName of the groupcharnullablegroup_utypeutype of the groupcharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.tablestable_nametable_name
sbnafSmall Bodies Near and Far SBNAF public database of thermal infrared observations of small
bodies in the solar system. Our database collects thermal emission
measurements of small Solar Systems targets that are otherwise
available in scattered sources and gives a complete description of the
data, with all information necessary to perform direct scientific
calculations and without the need to access additional, external
resources. See the details here: https://ird.konkoly.hu/sbnaf.epn_coreOur database collects thermal emission measurements of small Solar
Systems targets that are otherwise available in scattered sources and
gives a complete description of the data.ivo://ivoa.net/std/epntap#table-2.0granule_uidInternal table row index, which must be unique within the table. Can be alphanumeric.meta.idcharindexedprimarygranule_gidCommon to granules of same type (e.g. same map projection, or geometry data products). Can be alphanumeric.meta.idcharobs_idAssociates granules derived from the same data (e.g. various representations/processing levels). Can be alphanumeric, may be the ID of original observation.meta.id;obschardataproduct_typeThe high-level organization of the data product, from a controlled vocabulary (e.g., 'im' for image, sp for spectrum). Multiple terms may be used, separated by # characters.meta.code.classcharnullabletarget_nameStandard IAU name of target (from a list related to target class), case sensitivemeta.id;srccharnullabletarget_classType of target, from a controlled vocabulary.src.classcharnullabletime_minAcquisition start time (in JD), as UTC at time_refpositiondtime.start;obsdoublenullabletime_maxAcquisition stop time (in JD), as UTC at time_refpositiondtime.end;obsdoublenullabletime_sampling_step_minSampling time for measurements of dynamical phenomena, lower limit.stime.resolution;stat.mindoublenullabletime_sampling_step_maxSampling time for measurements of dynamical phenomena, upper limitstime.resolution;stat.maxdoublenullabletime_exp_minIntegration time of the measurement, lower limit.stime.duration;obs.exposure;stat.mindoublenullabletime_exp_maxIntegration time of the measurement, upper limitstime.duration;obs.exposure;stat.maxdoublenullablespectral_range_minSpectral range (frequency), lower limit.Hzem.freq;stat.mindoublenullablespectral_range_maxSpectral range (frequency), upper limitHzem.freq;stat.maxdoublenullablespectral_sampling_step_minSpectral sampling step, lower limit.Hzem.freq;spect.binSize;stat.mindoublenullablespectral_sampling_step_maxSpectral sampling step, upper limitHzem.freq;spect.binSize;stat.maxdoublenullablespectral_resolution_minSpectral resolution, lower limit.spect.resolution;stat.mindoublenullablespectral_resolution_maxSpectral resolution, upper limitspect.resolution;stat.maxdoublenullablec1minRight Ascension (ICRS), lower limit.degpos.eq.ra;stat.mindoublenullablec1maxRight Ascension (ICRS), upper limitdegpos.eq.ra;stat.maxdoublenullablec2minDeclination (ICRS), lower limit.degpos.eq.dec;stat.mindoublenullablec2maxDeclination (ICRS), upper limitdegpos.eq.dec;stat.maxdoublenullablec3minDistance from coordinate origin, lower limit.AUpos.distance;stat.mindoublenullablec3maxDistance from coordinate origin, upper limitAUpos.distance;stat.maxdoublenullables_regionObsCore-like footprint, valid for celestial, spherical, or body-fixed framespos.outline;obs.fieldcharnullablec1_resol_minResolution in the first coordinate, lower limit.degpos.angResolution;stat.mindoublenullablec1_resol_maxResolution in the first coordinate, upper limitdegpos.angResolution;stat.maxdoublenullablec2_resol_minResolution in the second coordinate, lower limit.degpos.angResolution;stat.mindoublenullablec2_resol_maxResolution in the second coordinate, upper limitdegpos.angResolution;stat.maxdoublenullablec3_resol_minResolution in the third coordinate, lower limit.AUpos.resolution;stat.mindoublenullablec3_resol_maxResolution in the third coordinate, upper limitAUpos.resolution;stat.maxdoublenullablespatial_frame_typeFlavor of coordinate system, defines the nature of coordinates. From a controlled vocabulary, where 'none' means undefined.meta.code.class;pos.framecharnullableincidence_minIncidence angle (solar zenithal angle) during data acquisition, lower limit.degpos.incidenceAng;stat.mindoublenullableincidence_maxIncidence angle (solar zenithal angle) during data acquisition, upper limitdegpos.incidenceAng;stat.maxdoublenullableemergence_minEmergence angle during data acquisition, lower limit.degpos.emergenceAng;stat.mindoublenullableemergence_maxEmergence angle during data acquisition, upper limitdegpos.emergenceAng;stat.maxdoublenullablephase_minPhase angle during data acquisition, lower limit.degpos.phaseAng;stat.mindoublenullablephase_maxPhase angle during data acquisition, upper limitdegpos.phaseAng;stat.maxdoublenullableinstrument_host_nameStandard name of the observatory or spacecraftmeta.id;instr.obstycharnullableinstrument_nameStandard name of instrumentmeta.id;instrcharnullablemeasurement_typeUCD(s) defining the data, with multiple entries separated by hash (#) characters.meta.ucdcharnullableprocessing_levelDataset-related encoding, or simplified CODMAC calibration levelmeta.calibLevelintcreation_dateDate of first entry of this granuletime.creationcharnullablemodification_dateDate of last modification (used to handle mirroring)time.processingcharnullablerelease_dateStart of public access periodtime.releasecharnullableservice_titleTitle of resource (an acronym really, will be used to handle multiservice results)meta.titlecharnullabletime_scaleDefaults to UTC in data services; takes values from http://www.ivoa.net/rdf/time_scale otherwisetime.scalecharnullablepublisherA short string identifying the entity running the data service usedmeta.curationcharnullablebib_referenceBibcode or DOI preferred if available, or other bibliographic identifier or URLmeta.bibcharnullablefilterIdentifies filter in use, typically for imagesmeta.id;instr.filtercharnullablealt_target_nameProvides alternative target name if more common (e.g. comets); multiple identifiers can be separated by hashesmeta.id;srccharnullableobsmodeObserving modemeta.code;instr.setupcharnullableraRight ascensiondegpos.eq.ra;meta.maindoublenullabledecDeclinationdegpos.eq.dec;meta.maindoublenullablefluxIn-band photometric flux density, photometric corrections applied, no colour correctionmJyphot.flux.densitydoublenullableflux_errUncertainty of the in-band photometric flux densitymJystat.error;phot.flux.densitydoublenullablecolour_correction_factorCorrection applied to obtain monochromatic flux density from in-band flux densityarith.factordoublenullablecorrected_fluxMonochromatic flux density (colour corrected in-band flux density)mJyphot.flux.densitydoublenullablecorrected_flux_errUncertainty on the monochromatic flux densitymJystat.error;phot.flux.densitydoublenullableabs_magnitudeAbsolute visual magnitude in HG system, from JPL/Horizonphys.magAbsdoublenullableslope_parameterSlope parameter in HG system, from JPL/Horizonphot.flux;arith.ratiodoublenullablemagnitudeApparent visual magnitude, from JPL/Horizonphot.magdoublenullablesemi_major_axisSemimajor axis of the target orbitauphys.size.smajAxisdoublenullableinclinationInclination of the target orbitdegsrc.orbital.inclinationdoublenullableeccentricityEccentricity of the target orbitsrc.orbital.eccentricitydoublenullablemean_anomalyMean anomaly at the epochdegsrc.orbital.meanAnomalydoublenullablearg_perihelArgument of periheliondegsrc.orbital.periastrondoublenullablelong_ascLongitude of ascending nodedegsrc.orbital.nodedoublenullablesun_distance_minSun-target min distanceuapos.distance;stat.mindoublenullablesun_distance_maxSun-target max distanceuapos.distance;stat.maxdoublenullabletarget_distance_minMin observer-target distancekmpos.distance;stat.mindoublenullabletarget_distance_maxMax observer-target distancekmpos.distance;stat.maxdoublenullabletarget_time_minMin observing time in target frametime.start;srccharnullabletarget_time_maxMax observing time in target frametime.end;srccharnullableobsqualContamination and confusion flags and photometric quality flagsmeta.code.qualcharnullablenative_idMission-specific identifier of the observation, e.g. OBSID for Herschel measurements and AORKEY for Spitzer observationsmeta.idcharnullableradiusEstimated radius of the target as obtained from JPL Horizonskmphys.size.radiusdoublenullablealbedoEstimated V-band geometric albedo of the target as obtained from JPL Horizons.physdoublenullablera_rateThe rate of change in right ascension.arcsec/sarith.ratedoublenullabledec_rateThe rate of change in declination.arcsec/sarith.ratedoublenullablelighttimeThe elapsed time since light (observed at print-time) would have left or reflected off a point at the center of the target.stimedoublenullablesolar_elongationTarget’s apparent solar elongation seen from the observer location at print-time.degpos.angDistancedoublenullableobsecllonObserver-centered Earth ecliptic-of-date longitude of the target center’s apparent position, adjusted for light-time, the gravitational deflection of light and stellar aberration as obtained by JPL/Horizons.degpos.ecliptic.londoublenullableobsecllatObserver-centered Earth ecliptic-of-date latitude of the target center’s apparent position, adjusted for light-time, the gravitational deflection of light and stellar aberration as obtained by JPL/Horizons.degpos.ecliptic.latdoublenullabletarget_x_sunSun-centered X Cartesian coordinate of the target body at observation mid-time, in the referenceframe defined in Archinal et al. (2011).aupos.cartesian.xdoublenullabletarget_y_sunSun-centered Y Cartesian coordinate of the target body at observation mid-time, in the referenceframe defined in Archinal et al. (2011).aupos.cartesian.ydoublenullabletarget_z_sunSun-centered Y Cartesian coordinate of the target body at observation mid-time, in the referenceframe defined in Archinal et al. (2011).aupos.cartesian.zdoublenullabletarget_x_observerObserver-centered X Cartesian coordinate of the target body at observation mid-time, in the reference frame defined in Archinal et al. (2011).aupos.cartesian.xdoublenullabletarget_y_observerObserver-centered Y Cartesian coordinate of the target body at observation mid-time, in the reference frame defined in Archinal et al. (2011).aupos.cartesian.ydoublenullabletarget_z_observerObserver-centered Z Cartesian coordinate of the target body at observation mid-time, in the reference frame defined in Archinal et al. (2011).aupos.cartesian.zdoublenullableobserver_x_sunSun-centered X Cartesian coordinate of the target body at observation mid-time, in the reference frame defined in Archinal et al. (2011).aupos.cartesian.xdoublenullableobserver_y_sunSun-centered Y Cartesian coordinate of the target body at observation mid-time, in the reference frame defined in Archinal et al. (2011).aupos.cartesian.ydoublenullableobserver_z_sunSun-centered Z Cartesian coordinate of the target body at observation mid-time, in the reference frame defined in Archinal et al. (2011).aupos.cartesian.zdoublenullabledata_calibration_descComments regarding the quality of the measurement / information when an assumed value was applied in the calculations; e.g. indicating whether the target is (also) regarded as a comet in JPL/Horizons; non standard value of geometric albedo is also marked here when it is not taken from JPL/Horizonsmeta.notecharnullableds_idIdentifier for this granule to use when calling datalink servicesmeta.idcharnullabledatalink_urlDatalinks and services for this granulemeta.ref.url;meta.datalinkcharnullable