The Tohoku University VO Server'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 iitatehf schema, columns, groups, key_columns, keys, schemas, tables from the tap_schema schema, epn_core from the iprt schema, epn_core from the irtf_cshell schema, epn_core from the hisaki schema, epn_core from the sw_model schema, emptyobscore, obscore from the ivoa schema.

ADQL 2.0

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 delimiter

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

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.

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