GCP TAPivo://pvol/tapPlanetary Virtual Observatory and Laboratory (PVOL)Planetary Sciences Group, UPV/EHUhttp://www.ajax.ehu.es/logoGCP.sml.gif2017-06-22T14:14:41Ricardo Hueso

Plaza Ingeniero Torres Quevedo 1, 48003 Bilbao (Spain)

ricardo.hueso@ehu.eusDelete this line if you don't want to give itVirtual observatoryCatalogsADQLThe PVOL EPN-TAP'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, emptyobscore, obscore from the ivoa schema, epn_core from the pvol schema.http://pvol2.ehu.eus:8083/__system__/tap/run/infoservice-forPVOLhttp://pvol2.ehu.eus:8083/tapObscore-1.0Obscore-1.1EpnCore#schema-2.0EpnCore/schema-2.0ADQL2.0ADQL 2.0

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.

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

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.

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.

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.

BOX

POINT

CIRCLE

POLYGON

REGION

CENTROID

COORD1

COORD2

DISTANCE

CONTAINS

INTERSECTS

AREA

text/xmltext/htmlhtmlapplication/x-votable+xml;serialization=binary2votable/b2application/fitsfitstext/csvtext/csv;header=presentcsvapplication/x-votable+xml;serialization=tabledatavotable/tdapplication/jsonjsonapplication/x-votable+xmlvotabletext/plaintext/tab-separated-valuestsv172800360020002000000020000000http://pvol2.ehu.eus:8083/__system__/tap/run/availabilityhttp://pvol2.ehu.eus:8083/__system__/tap/run/capabilitieshttp://pvol2.ehu.eus:8083/__system__/tap/run/tableMetadatahttp://pvol2.ehu.eus:8083/__system__/tap/run/examplesivoaDefinition and support code for the ObsCore data model and table.ivoa.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:obs.dataproducttypecharnullabledataproduct_subtypeData product specific typemeta.idobscore:obs.dataproductsubtypecharnullablecalib_levelAmount of data processing that has been applied to the datameta.code;obs.calibobscore:obs.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.angArea;obsobscore:char.spatialaxis.coverage.support.areacharnullables_resolutionBest spatial resolution within the data setarcsecpos.angResolutionobscore:Char.SpatialAxis.Resolution.refvaldoublenullablet_minLower bound of times represented in the data set, as MJDdtime.start;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.interval.starttimedoublenullablet_maxUpper bound of times represented in the data set, as MJDdtime.end;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.interval.stoptimedoublenullablet_exptimeTotal exporure timestime.duration;obs.exposureobscore:char.timeaxis.coverage.support.extentfloatnullablet_resolutionMinimal significant time interval along the time axisstime.resolutionobscore:char.timeaxis.resolution.refvalfloatnullableem_minMinimal wavelength represented within the data setmem.wl;stat.minobscore:char.spectralaxis.coverage.bounds.limits.interval.lolimdoublenullableem_maxMaximal wavelength represented within the data setmem.wl;stat.maxobscore:char.spectralaxis.coverage.bounds.limits.interval.hilimdoublenullableem_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.numBins1longnullablet_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.SpectralAxis.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.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:obs.dataproducttypecharnullabledataproduct_subtypeData product specific typemeta.idobscore:obs.dataproductsubtypecharnullablecalib_levelAmount of data processing that has been applied to the datameta.code;obs.calibobscore:obs.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.angArea;obsobscore:char.spatialaxis.coverage.support.areacharnullables_resolutionBest spatial resolution within the data setarcsecpos.angResolutionobscore:Char.SpatialAxis.Resolution.refvaldoublenullablet_minLower bound of times represented in the data set, as MJDdtime.start;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.interval.starttimedoublenullablet_maxUpper bound of times represented in the data set, as MJDdtime.end;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.interval.stoptimedoublenullablet_exptimeTotal exporure timestime.duration;obs.exposureobscore:char.timeaxis.coverage.support.extentfloatnullablet_resolutionMinimal significant time interval along the time axisstime.resolutionobscore:char.timeaxis.resolution.refvalfloatnullableem_minMinimal wavelength represented within the data setmem.wl;stat.minobscore:char.spectralaxis.coverage.bounds.limits.interval.lolimdoublenullableem_maxMaximal wavelength represented within the data setmem.wl;stat.maxobscore:char.spectralaxis.coverage.bounds.limits.interval.hilimdoublenullableem_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.numBins1longnullablet_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.SpectralAxis.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.ucdcharnullablepvolImages, maps, photometries and other kind of planetary graphic platforms made by amateur astronomers. Data is received by the astronomers themselves and can be subject of changeivo://vopdc.obspm/std/EpnCore/schema-2.0pvol.epn_coreEPN-TAP access to the PVOL dataivo://vopdc.obspm/std/EpnCore/schema-2.0granule_uidGranule unique identifier, provides direct accessmeta.idchargranule_gidGroup identifier, identical for similar data productsmeta.idcharobs_idIdentical for data products related to the same original datameta.idchardataproduct_typeOrganization of the data product (from enumerated list)meta.code.classcharnullabletarget_nameName of target (IAU standard)meta.id;srccharnullablealt_target_nameExtra: Alternative name of targetmeta.id;srccharnullabletarget_classType of target, from enumerated listmeta.code.class;srccharnullabletime_minAcquisition start time (in JD)dtime.startdoublenullabletime_maxAcquisition stop time (in JD)dtime.enddoublenullabletime_sampling_step_minMin time sampling stepstime.interval;stat.mindoublenullabletime_sampling_step_maxMax time sampling stepstime.interval;stat.maxdoublenullabletime_exp_minMin integration timestime.duration;obs.exposure;stat.mindoublenullabletime_exp_maxMax integration timestime.duration;obs.exposure;stat.maxdoublenullablespectral_range_minMin spectral range (as frequency)Hzem.freq;stat.mindoublenullablespectral_range_maxMax spectral range (as frequency)Hzem.freq;stat.maxdoublenullablespectral_sampling_step_minMin spectral sampling step (as frequency)Hzem.freq.step;stat.mindoublenullablespectral_sampling_step_maxMax spectral sampling step (as frequency)Hzem.freq.step;stat.maxdoublenullablespectral_resolution_minMin spectral resolution (as frequency)Hzspect.resolution;stat.mindoublenullablespectral_resolution_maxMax spectral resolution (as frequency)Hzspect.resolution;stat.maxdoublenullablec1minMin (westernmost) longitude on surfacedegpos;stat.mindoublenullablec1maxMax (easternmost) longitude on surfacedegpos;stat.maxdoublenullablec2minMin latitude on planetary surfacedegpos;stat.mindoublenullablec2maxMax latitude on planetary surfacedegpos;stat.maxdoublenullablec3minCoordinate not used (altitude or depth)pos;stat.mindoublenullablec3maxCoordinate not used (altitude or depth)pos;stat.maxdoublenullablec1_resol_minMin resolution in longitudedegpos.resolution;stat.mindoublenullablec1_resol_maxMax resolution in longitudedegpos.resolution;stat.maxdoublenullablec2_resol_minMin resolution in latitudedegpos.resolution;stat.mindoublenullablec2_resol_maxMax resolution in latitudedegpos.resolution;stat.maxdoublenullablec3_resol_minnot usedpos.resolution;stat.mindoublenullablec3_resol_maxnot usedpos.resolution;stat.maxdoublenullablespatial_frame_typeDefines the nature of coordinates (from enumerated list)meta.code.class;pos.framecharnullables_regionProvides footprintphys.outline;obs.fieldcharnullableincidence_minMin incidence angle (solar zenith angle)degpos.posAng;stat.mindoublenullableincidence_maxMax incidence angle (solar zenith angle)degpos.posAng;stat.maxdoublenullableemergence_minMin emergence angledegpos.posAng;stat.mindoublenullableemergence_maxMax emergence angledegpos.posAng;stat.maxdoublenullablephase_minMin illumination angledegpos.phaseAng;stat.mindoublenullablephase_maxMax illumination angledegpos.phaseAng;stat.maxdoublenullableinstrument_host_nameStandard name of the observatory or spacecraftmeta.id;instr.obstycharnullableinstrument_nameStandard name of the instrumentmeta.id;instrcharnullablemeasurement_typeUCD(s) defining the nature of measurementsmeta.ucdcharnullableaccess_urlURL of the data filemeta.ref.urlcharnullableaccess_formatFile format typemeta.code;mimecharnullableaccess_estsizeEstimate file size in kBkbytephys.size;meta.fileintthumbnail_urlURL of a small thumbnailmeta.ref.url;meta.filecharnullablefile_nameName root of the data filemeta.id;meta.filecharnullablecreation_dateCreation date of entrytime.creationcharnullablemodification_dateDate of last modification of entrytime.updatecharnullablerelease_dateStart of public periodtime.releasecharnullableservice_titleAcronym of this data servicemeta.titlecharnullableprocessing_levelLevel of calibration (CODMAC level)meta.code;obs.calibintfeature_nameFeature(s) visible in the imagemeta.featurecharobserver_nameImage observer's full namemeta.pubnamecharobserver_idImage observer's PVOL numeric identifiermeta.pubidintobserver_codeImage observer's PVOL usernamemeta.pubcodecharobserver_countryImage observer's country of residencemeta.pubcountrycharobserver_lonObserver's approximate longitudemeta.publonfloatobserver_latObserver's approximate latitudemeta.publatfloattap_schema PVOL EPN-TAP'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 modelcharnullablesourcerdId 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 datatypecharnullable"size"Length of variable length datatypesintnullableprincipalIs 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.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_nametap_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)charnullable