PADC TAP Server on voparis-tap-voevent.obspm.fr TAP servicePADC TAPivo://padc.obspm.voevent/tapParis Astronomical Data CentrePADChttp://voparis-srv-paris.obspm.fr/logos/PADC_small.png2019-07-12T10:29:33PADC support team77 av. Denfert Rochereau, 75014 Paris, FRANCEvo.paris@obspm.fr0033140512082Virtual observatoryCatalogsADQLThe PADC TAP Server on voparis-tap-voevent.obspm.fr'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: obscore from the ivoa schema.http://voparis-tap-voevent.obspm.fr/__system__/tap/run/infohttp://voparis-tap-voevent.obspm.fr/tapADQL2.12.0The 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.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 applications.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.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_match returns 1 if the POSIX regular expression pattern
matches anything in string, 0 otherwise.returns a POINT corresponding to the center of the healpix with
the given index at the given order.An aggregate function returning all values of
expression within a GROUP contcatenated with delimiterReturns a POINT (in the UNDEFINED reference frame) for the position
an object at ra/dec with proper motion pmra/pmde has after epdist years.
positions must be in degrees, PMs in should be in julian years (i.e., proper
motions are expected in degrees/year). pmra is assumed to contain
cos(delta).
NOTE: This currently is a crappy approximation that does *not* go
through the tangential plane. If you use it, let the operators know
so we replace it with something real.The 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 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.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). Not 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 trested as ICRS), FK4 (for B1950. without epoch-dependent corrections),
GALACTIC. Reference frame names are case-sensitive.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 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.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 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.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 milage will vary.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
http://www.postgresql.org/docs/8.3/static/textsearch.html
for details.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.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).text/xmlapplication/x-votable+xml;version=1.4vodmltext/htmlhtmlapplication/x-votable+xml;serialization=binary2votable/b2application/geo-jsongeojsonapplication/fitsfitstext/csvtext/csv;header=presentcsvapplication/x-votable+xml;serialization=tabledatavotable/tdapplication/jsonjsonapplication/x-votable+xmlvotabletext/plaintext/tab-separated-valuestsv1728003600200002000000020000000http://voparis-tap-voevent.obspm.fr/__system__/tap/run/availabilityhttp://voparis-tap-voevent.obspm.fr/__system__/tap/run/capabilitieshttp://voparis-tap-voevent.obspm.fr/__system__/tap/run/tableMetadataivoaDefinition and support code for the ObsCore data model and table.ivoa.obscoreThe IVOA-defined obscore table, containing generic metadata for
datasets within this datacenter.dataproduct_typeHigh level scientific classification of the data product, taken from an enumerationmeta.idobscore:obsdataset.dataproducttypecharnullabledataproduct_subtypeData product specific typemeta.idobscore:obsdataset.dataproductsubtypecharnullablecalib_levelAmount of data processing that has been applied to the datameta.code;obs.calibobscore:obsdataset.caliblevelshortobs_collectionName of a data collection (e.g., project name) this data belongs tometa.idobscore:dataid.collectioncharnullableobs_idUnique identifier for an observationmeta.idobscore:DataID.observationIDcharnullableobs_titleFree-from title of the data setmeta.title;obsobscore:dataid.titlecharnullableobs_publisher_didDataset identifier assigned by the publisher.meta.ref.uri;meta.curationobscore:curation.publisherdidcharnullableobs_creator_didDataset identifier assigned by the creator.meta.idobscore:dataid.creatordidcharnullableaccess_urlThe URL at which to obtain the data set.meta.ref.urlobscore:access.referencecharnullableaccess_formatMIME type of the resource at access_urlmeta.code.mimeobscore:access.formatcharnullableaccess_estsizeEstimated size of data productkbytephys.size;meta.fileobscore:access.sizelongnullabletarget_nameObject a targeted observation targetedmeta.id;srcobscore:Target.Namecharnullabletarget_classClass of the target object (star, QSO, ...)src.classobscore:target.classcharnullables_raRA of (center of) observation, ICRSdegpos.eq.raobscore:char.spatialaxis.coverage.location.coord.position2d.value2.c1doublenullables_decDec of (center of) observation, ICRSdegpos.eq.decobscore:char.spatialaxis.coverage.location.coord.position2d.value2.c2doublenullables_fovApproximate spatial extent for the region covered by the observationdegphys.angSize;instr.fovobscore:char.spatialaxis.coverage.bounds.extent.diameterdoublenullables_regionRegion covered by the observation, as a polygonpos.outline;obs.fieldobscore:char.spatialaxis.coverage.support.areacharnullables_resolutionBest spatial resolution within the data setarcsecpos.angResolutionobscore:Char.SpatialAxis.Resolution.refval.valuedoublenullablet_minLower bound of times represented in the data set, as MJDdtime.start;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.starttimedoublenullablet_maxUpper bound of times represented in the data set, as MJDdtime.end;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.stoptimedoublenullablet_exptimeTotal exposure timestime.duration;obs.exposureobscore:char.timeaxis.coverage.support.extentfloatnullablet_resolutionMinimal significant time interval along the time axisstime.resolutionobscore:char.timeaxis.resolution.refval.valuefloatnullableem_minMinimal wavelength represented within the data setmem.wl;stat.minobscore:char.spectralaxis.coverage.bounds.limits.lolimitdoublenullableem_maxMaximal wavelength represented within the data setmem.wl;stat.maxobscore:char.spectralaxis.coverage.bounds.limits.hilimitdoublenullableem_res_powerSpectral resolving power delta lambda/lamdaspect.resolutionobscore:char.spectralaxis.resolution.resolpower.refvaldoublenullableo_ucdUCD for the product's observablemeta.ucdobscore:char.observableaxis.ucdcharnullablepol_statesList of polarization states in the data setmeta.code;phys.polarizationobscore:Char.PolarizationAxis.stateListcharnullablefacility_nameName of the facility at which data was takenmeta.id;instr.telobscore:Provenance.ObsConfig.facility.namecharnullableinstrument_nameName of the instrument that produced the datameta.id;instrobscore:Provenance.ObsConfig.instrument.namecharnullables_xel1Number of elements (typically pixels) along the first spatial axis.meta.numberobscore:Char.SpatialAxis.numBins1longnullables_xel2Number of elements (typically pixels) along the second spatial axis.meta.numberobscore:Char.SpatialAxis.numBins2longnullablet_xelNumber of elements (typically pixels) along the time axis.meta.numberobscore:Char.TimeAxis.numBinslongnullableem_xelNumber of elements (typically pixels) along the spectral axis.meta.numberobscore:Char.SpectralAxis.numBinslongnullablepol_xelNumber of elements (typically pixels) along the polarization axis.meta.numberobscore:Char.PolarizationAxis.numBinslongnullables_pixel_scaleSampling period in world coordinate units along the spatial axisarcsecphys.angSize;instr.pixelobscore:Char.SpatialAxis.Sampling.RefVal.SamplingPerioddoublenullableem_ucdNature of the product's spectral axismeta.ucdobscore:Char.SpectralAxis.ucdcharnullablepreviewURL of a preview (low-resolution, quick-to-retrieve representation) of the data.meta.ref.url;datalink.previewcharnullablesource_tableName of a TAP-queriable table this data originates from. This source table usually provides more information on the the data than what is given in obscore. See the TAP_SCHEMA of the originating TAP server for details.meta.id;meta.tablecharnullable