PRSFUB TAPivo://fu-berlin.planet.hrsc/tapFREIE UNIVERSITAET BERLIN, PLANETOLOGY AND REMOTE SENSINGSebastian Walterhttp://dachs.planet.fu-berlin.de/logo_big.png2018-07-17T11:01:55Sebastian Walter

Malteserstr. 74-100

s.walter@fu-berlin.deVirtual observatoryCatalogsADQLThe Planetary web services @ FUB'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: columns, groups, key_columns, keys, schemas, tables from the tap_schema schema, epn_core from the hrsc3nd schema, emptyobscore, obscore from the ivoa schema.http://dachs.planet.fu-berlin.de/__system__/tap/run/infoservice-forHRSC Level 3 nadir imagesFUB_WMShttp://dachs.planet.fu-berlin.de/tapObscore-1.1ADQL2.0ADQL 2.0

gavo_simbadpoint(identifier TEXT) -> POINT

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.

ivo_interval_has(val NUMERIC, iv INTERVAL) -> INTEGER

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.

gavo_match(pattern TEXT, string TEXT) -> INTEGER

gavo_match returns 1 if the POSIX regular expression pattern matches anything in string, 0 otherwise.

ivo_healpix_center(hpxOrder INTEGER, hpxIndex BIGINT) -> POINT

returns a POINT corresponding to the center of the healpix with the given index at the given order.

ivo_string_agg(expression TEXT, delimiter TEXT) -> TEXT

An aggregate function returning all values of expression within a GROUP contcatenated with delimiter

gavo_to_jd(d TIMESTAMP) -> DOUBLE PRECISION

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.

ivo_interval_overlaps(l1 NUMERIC, h1 NUMERIC, l2 NUMERIC, h2 NUMERIC) -> INTEGER

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.

gavo_transform(from_sys TEXT, to_sys TEXT, geo GEOMETRY) -> GEOMETRY

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.

ivo_healpix_index(order INTEGER, ra DOUBLE PRECISION, dec DOUBLE PRECISION) -> BIGINT

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.

ivo_hashlist_has(hashlist TEXT, item TEXT) -> INTEGER

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_histogram(val REAL, lower REAL, upper REAL, nbins INTEGER) -> INTEGER[]

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.

gavo_to_mjd(d TIMESTAMP) -> DOUBLE PRECISION

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(value TEXT, pattern TEXT) -> INTEGER

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.

ivo_hasword(haystack TEXT, needle TEXT) -> INTEGER

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.

ivo_apply_pm(ra DOUBLE PRECISION, dec DOUBLE PRECISION, pmra DOUBLE PRECISION, pmde DOUBLE PRECISON, epdist DOUBLE PRECISION) -> POINT

Returns 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.

BOX

POINT

CIRCLE

POLYGON

REGION

CENTROID

COORD1

COORD2

DISTANCE

CONTAINS

INTERSECTS

AREA

LOWER

ILIKE

OFFSET

CAST

IN_UNIT

WITH

UNION

EXCEPT

INTERSECT

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://dachs.planet.fu-berlin.de/__system__/tap/run/availabilityhttp://dachs.planet.fu-berlin.de/__system__/tap/run/capabilitieshttp://dachs.planet.fu-berlin.de/__system__/tap/run/tableMetadatahttp://dachs.planet.fu-berlin.de/__system__/tap/run/exampleshrsc3ndMars-Express/High Resolution Stereo Camera nadir (panchromatic) images projected to Equidistant Cylindrical projection ortho-rectified using the MOLA DTM (HRSC level 3). The images are accessible via an OGC Map Web Service (WMS) directly from our WMS Server. For an interactive web-GIS of the data, visit: http://maps.planet.fu-berlin.dehrsc3nd.epn_coreEPN-TAP access to HRSC level 3 panchromatic image dataivo://vopdc.obspm/std/epncore#schema-2.0granule_uidInternal table row index Unique ID in data service, also in v2. Can be alphanumeric.meta.idchargranule_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.idchardataproduct_typeThe high-level organization of the data product, from enumerated list (e.g., 'im' for image, sp for spectrum)meta.code.classEpn.dataProductTypecharnullabletarget_nameStandard IAU name of target (from a list related to target class), case sensitivemeta.id;srcEpn.TargetNamecharnullabletarget_classType of target, from enumerated listmeta.code.class;srcEpn.TargetClasscharnullabletime_minAcquisition start time (in JD)dtime.startdoublenullabletime_maxAcquisition stop time (in JD)dtime.enddoublenullabletime_sampling_step_minSampling time for measurements of dynamical phenomena, lower limit.stime.interval;stat.minEpn.Time.Time_sampling_step_mindoublenullabletime_sampling_step_maxSampling time for measurements of dynamical phenomena, upper limitstime.interval;stat.maxEpn.Time.Time_sampling_step_maxdoublenullabletime_exp_minIntegration time of the measurement, lower limit.stime.duration;obs.exposure;stat.minEpn.Time.Time_exp_mindoublenullabletime_exp_maxIntegration time of the measurement, upper limitstime.duration;obs.exposure;stat.maxEpn.Time.Time_exp_maxdoublenullablespectral_range_minSpectral range (frequency), lower limit.Hzem.freq;stat.minEpn.Spectral.Spectral_range_mindoublenullablespectral_range_maxSpectral range (frequency), upper limitHzem.freq;stat.maxEpn.Spectral.Spectral_range_maxdoublenullablespectral_sampling_step_minspectral sampling step, lower limit.Hzem.freq.step;stat.minEpn.Spectral.Spectral_sampling_step_mindoublenullablespectral_sampling_step_maxspectral sampling step, upper limitHzem.freq.step;stat.maxEpn.Spectral.Spectral_sampling_step_maxdoublenullablespectral_resolution_minSectral resolution, lower limit.Hzspect.resolution;stat.minEpn.Spectral.Spectral_resolution_mindoublenullablespectral_resolution_maxSectral resolution, upper limitHzspect.resolution;stat.maxEpn.Spectral.Spectral_resolution_maxdoublenullablec1minLongitude on body, lower limit.degpos.bodyrc.long;stat.minEpn.Spatial.Spatial_range.c1mindoublenullablec1maxLongitude on body, upper limitdegpos.bodyrc.long;stat.maxEpn.Spatial.Spatial_range.c1maxdoublenullablec2minLatitude on body, lower limit.degpos.bodyrc.lat;stat.minEpn.Spatial.Spatial_range.c2mindoublenullablec2maxLatitude on body, upper limitdegpos.bodyrc.lat;stat.maxEpn.Spatial.Spatial_range.c2maxdoublenullablec3minHeight over defined null, lower limit.mpos.bodyrc.alt;stat.minEpn.Spatial.Spatial_range.c3mindoublenullablec3maxHeight over defined null, upper limitmpos.bodyrc.alt;stat.maxEpn.Spatial.Spatial_range.c3maxdoublenullables_regionObsCore-like footprint, valid for celestial, spherical, or body-fixed frames.phys.outline;obs.fieldcharnullablec1_resol_minResolution in the first coordinate, lower limit.degpos.resolution;stat.minEpn.Spatial.Spatial_resolution.c1_resol_mindoublenullablec1_resol_maxResolution in the first coordinate, upper limitdegpos.resolution;stat.maxEpn.Spatial.Spatial_resolution.c1_resol_maxdoublenullablec2_resol_minResolution in the second coordinate, lower limit.degpos.resolution;stat.minEpn.Spatial.Spatial_resolution.c2_resol_mindoublenullablec2_resol_maxResolution in the second coordinate, upper limitdegpos.resolution;stat.maxEpn.Spatial.Spatial_resolution.c2_resol_maxdoublenullablec3_resol_minResolution in the third coordinate, lower limit.mpos.resolution;stat.minEpn.Spatial.Spatial_resolution.c3_resol_mindoublenullablec3_resol_maxResolution in the third coordinate, upper limitmpos.resolution;stat.maxEpn.Spatial.Spatial_resolution.c3_resol_maxdoublenullablespatial_frame_typeFlavor of coordinate system, defines the nature of coordinates. From enumerated listmeta.code.class;pos.framecharnullableincidence_minIncidence angle (solar zenithal angle) during data acquisition, lower limit.degpos.posAng;stat.minEpn.View_angle.Incidence_angle_mindoublenullableincidence_maxIncidence angle (solar zenithal angle) during data acquisition, upper limitdegpos.posAng;stat.maxEpn.View_angle.Incidence_angle_maxdoublenullableemergence_minEmergence angle during data acquisition, lower limit.degpos.posAng;stat.minEpn.View_angle.Emergence_angle_mindoublenullableemergence_maxEmergence angle during data acquisition, upper limitdegpos.posAng;stat.maxEpn.View_angle.Emergence_angle_maxdoublenullablephase_minPhase angle during data acquisition, lower limit.degpos.phaseAng;stat.minEpn.View_angle.Phase_angle_mindoublenullablephase_maxPhase angle during data acquisition, upper limitdegpos.phaseAng;stat.maxEpn.View_angle.Phase_angle_maxdoublenullableinstrument_host_nameStandard name of the observatory or spacecraft.meta.id;instr.obstyProvenance.ObsConfig.Facility.namecharnullableinstrument_nameStandard name of instrumentmeta.id;instrProvenance.ObsConfig.Instrument.namecharnullablemeasurement_typeUCD(s) defining the data, with multiple entries separated by hash (#) characters.meta.ucdEpn.Measurement_typecharnullableprocessing_levelCODMAC calibration level; see the et_cal note http://dc.g-vo.org/tableinfo/titan.epn_core#note-et_cal for what values are defined here.meta.code;obs.calibintcreation_dateDate of first entry of this granuletime.creationcharnullablemodification_dateDate of last modification (used to handle mirroring)time.updatecharnullablerelease_dateStart of public access periodtime.releasecharnullableservice_titleTitle of resource (an acronym really, will be used to handle multiservice results)meta.titlecharnullableaccess_urlURL of the data file, case sensitive. If present, next 2 paramenters must be present.meta.ref.url;meta.filecharnullableaccess_formatFile format typemeta.code.mimecharnullableaccess_estsizeEstimate file size in kbyte (with this spelling)phys.size;meta.fileintnullablebib_referenceBibcode preferred if available (does that include link?), doi, or other biblio id, URLmeta.bibcharnullablethumbnail_urlURL of a thumbnail image with predefined size (png ~200 pix, for use in a client only)meta.ref.url;meta.previewcharnullableexternal_linkURL of the preview linkmeta.ref.urlcharnullablesolar_longitude_minSolar longitude (minimum)pos.ecliptic.lon;pos.heliocentric;stat.minfloatnullablesolar_longitude_maxSolar longitude (maximum)pos.ecliptic.lon;pos.heliocentric;stat.maxfloatnullablefilterFilter namemeta.id;instr.filtercharnullablereflectance_scaling_factorReflectance scaling factorarith.factorfloatnullablereflectance_offsetReflectance offsetarith.zpfloatnullableradiance_scaling_factorRadiance scaling factorarith.factorfloatnullableradiance_offsetRadiance offset (unit: W*m**-2*sr**-1)arith.zpfloatnullablemap_projectionMap projection parameters in libproj notationpos.projectioncharnullablegrid_sizeMeters per pixelpos.wcs.scalefloatnullablebest_ground_samplingMeters per pixelpos.wcs.scalefloatnullableivoaDefinition 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.url;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 polygonphys.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 exporure 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.ucdcharnullableivoa.emptyobscoreAn empty table having all columns of the obscore table. Useful internally, and sometimes for tricky queries.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.url;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 polygonphys.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 exporure 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.ucdcharnullabletap_schema Planetary web services @ FUB's Table Access Protocol (TAP) service with table metadata.tap_schema.schemasSchemas containing tables available for ADQL querying.schema_nameFully qualified schema namecharindexedprimarydescriptionBrief description of the schemacharnullableutypeutype if schema corresponds to a data modelcharnullabletap_schema.tablesTables available for ADQL querying.schema_nameFully qualified schema namecharnullabletable_nameFully qualified table namecharindexedprimarytable_typeOne of: table, viewcharnullabledescriptionBrief description of the tablecharnullableutypeutype 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)charnullabletap_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_nametap_schema.keysForeign key relationships between tables available for ADQL querying.key_idUnique key identifiercharindexedprimaryfrom_tableFully qualified table namecharnullabletarget_tableFully qualified table namecharnullabledescriptionDescription of this keycharnullableutypeUtype of this keycharnullablesourcerdId of the originating rd (local information)charnullabletap_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.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 withing the groupcharnullablegroup_nameName of the groupcharnullablegroup_utypeutype of the groupcharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.tablestable_nametable_name