Data investigation

Using ADQL queries to look at the existing metadata available from TAP services.

Data collected using TopCat to query TAP services.

Data collected on 4th August 2017.

    SELECT DISTINCT
        datatype,
        type_system,
        arraysize,
        delim,
        extended_schema,
        extended_type
    FROM
        rr.table_column
    ORDER BY
        datatype,
        type_system,
        arraysize,
        delim,
        extended_schema,
        extended_type

http://dc.zah.uni-heidelberg.de/
datatype type_system arraysize delim extended_schema extended_type notes
bigint vs:taptype - - - - -
boolean vs:votabletype 1 - - - -
boolean - - - - - -
char vs:taptype - - - - -
char vs:votabletype * - - - -
char vs:votabletype 1 - - - -
char vs:votabletype 2 - - - -
char vs:votabletype 3 - - - -
char vs:votabletype 5 - - - -
char N/A * - - - -
char N/A 1 - - - -
clob vs:taptype - - - - -
double vs:taptype - - - - -
double vs:votabletype * - - - -
double vs:votabletype 1 - - - -
double - - - - - -
float vs:taptype - - - - -
float vs:votabletype * - - - -
float vs:votabletype 1 - - - -
float vs:votabletype 2 - - - -
float vs:votabletype 4 - - - -
float - - - - - -
int vs:votabletype * - - - -
int vs:votabletype 1 - - - -
int - - - - - -
integer vs:taptype - - - - -
long vs:taptype - - - - -
long vs:votabletype 1 - - - -
long - - - - - -
real vs:taptype - - - - -
region vs:taptype - - - - -
short vs:taptype - - - - -
short vs:votabletype 1 - - - -
short - - - - - -
smallint vs:taptype - - - - -
timestamp vs:taptype - - - - -
unicodechar vs:votabletype * - - - -
varchar vs:taptype - - - - -
N/A - - - - - -
 
http://registry.euro-vo.org/
datatype type_system arraysize delim extended_schema extended_type notes
bigint vs:taptype - - - - -
boolean vs:votabletype 1 - - - -
boolean - - - - - -
char vs:taptype - - - - -
char vs:votabletype * - - - -
char vs:votabletype 1 - - - -
char vs:votabletype 2 - - - -
char vs:votabletype 3 - - - -
char vs:votabletype 5 - - - -
char - * - - - -
char - 1 - - - -
clob vs:taptype - - - - -
double vs:taptype - - - - -
double vs:votabletype * - - - -
double vs:votabletype 1 - - - -
double - - - - - -
float vs:votabletype * - - - -
float vs:votabletype 1 - - - -
float vs:votabletype 2 - - - -
float vs:votabletype 4 - - - -
float - - - - - -
int vs:votabletype * - - - -
int vs:votabletype 1 - - - -
int - - - - - -
integer vs:taptype - - - - -
long vs:votabletype 1 - - - -
long - - - - - -
real vs:taptype - - - - -
region vs:taptype - - - - -
short vs:votabletype 1 - - - -
short - - - - - -
smallint vs:taptype - - - - -
timestamp vs:taptype - - - - -
unicodechar vs:votabletype * - - - -
varchar vs:taptype - - - - -
- - - - - - -

    SELECT DISTINCT
        datatype,
        "size"
    FROM
        TAP_SCHEMA.columns
    ORDER BY
        datatype,
        "size"

 
http://dc.zah.uni-heidelberg.de/
datatype "size" notes
BIGINT 1 -
CHAR 1 -
DOUBLE 1 -
DOUBLE - -
INTEGER 1 -
INTEGER - -
POINT 1 -
REAL 1 -
REAL 4 -
REAL - -
REGION 1 -
SMALLINT 1 -
TIMESTAMP 1 -
VARCHAR - -
 
http://registry.euro-vo.org/
datatype "size" notes
BIGINT 0 -
INTEGER 0 -
REAL 0 -
SMALLINT 0 -
TIMESTAMP 0 -
VARCHAR 0 -
 
http://gea.esac.esa.int/
datatype "size" notes
BIGINT - -
BOOLEAN - -
CHAR - -
DOUBLE - -
INTEGER - -
REAL - -
SMALLINT - -
TIMESTAMP - -
VARCHAR - -
 
http://www.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/
datatype "size" notes
adql:BIGINT - -
adql:BINARY 16 -
adql:BINARY - -
adql:BLOB - -
adql:CHAR 8 -
adql:CHAR - -
adql:CLOB - -
adql:DOUBLE - -
adql:INTEGER - -
adql:POINT - -
adql:proto:INTERVAL - -
adql:REAL - -
adql:REGION - -
adql:SMALLINT - -
adql:TIMESTAMP - -
adql:VARBINARY 16 -
adql:VARBINARY - -
adql:VARCHAR 8 -
adql:VARCHAR 16 -
adql:VARCHAR 32 -
adql:VARCHAR 64 -
adql:VARCHAR 128 -
adql:VARCHAR 256 -
adql:VARCHAR 512 -
adql:VARCHAR - -
uuid - uuid
votable:double 2 -
votable:long 2 -
 
http://tapvizier.u-strasbg.fr/
BIGINT -1 -
CHAR(1) 1 CHAR(n)
CHAR(1) 14 CHAR(n) != size
CHAR(2) 2 -
CHAR(3) 3 -
CHAR(4) 4 -
CHAR(5) 5 -
CHAR(6) 6 -
CHAR(7) 7 -
CHAR(8) 8 -
CHAR(9) 9 -
CHAR(10) 10 -
CHAR(11) 11 -
CHAR(12) 12 -
CHAR(13) 13 -
CHAR(14) 14 -
CHAR(15) 15 -
CHAR(16) 16 -
CHAR(17) 17 -
CHAR(18) 18 -
CHAR(19) 19 -
CHAR(20) 20 -
CHAR(21) 21 -
CHAR(22) 22 -
CHAR(23) 23 -
CHAR(24) 24 -
CHAR(25) 25 -
CHAR(26) 26 -
CHAR(27) 27 -
CHAR(28) 28 -
CHAR(29) 29 -
CHAR(30) 30 -
CHAR(31) 31 -
CHAR(32) 32 -
CHAR(33) 33 -
CHAR(34) 34 -
CHAR(35) 35 -
CHAR(36) 36 -
CHAR(37) 37 -
CHAR(38) 38 -
CHAR(39) 39 -
CHAR(40) 40 -
CHAR(41) 41 -
CHAR(42) 42 -
CHAR(43) 43 -
CHAR(44) 44 -
CHAR(45) 45 -
CHAR(46) 46 -
CHAR(47) 47 -
CHAR(48) 48 -
CHAR(49) 49 -
CHAR(50) 50 -
CHAR(51) 51 -
CHAR(52) 52 -
CHAR(53) 53 -
CHAR(54) 54 -
CHAR(58) 58 -
CHAR(59) 59 -
CHAR(60) 60 -
CHAR(61) 61 -
CHAR(63) 63 -
CHAR(64) 64 -
CHAR(65) 65 -
CHAR(66) 66 -
CHAR(67) 67 -
CHAR(69) 69 -
CHAR(71) 71 -
CHAR(72) 72 -
CHAR(73) 73 -
CHAR(76) 76 -
CHAR(77) 77 -
CHAR(78) 78 -
CHAR(79) 79 -
CHAR(80) 80 -
CHAR(83) 83 -
CHAR(84) 84 -
CHAR(89) 89 -
CHAR(91) 91 -
CHAR(120) 120 -
CHAR(128) 128 -
CHAR(130) 130 -
CHAR(255) 255 -
CHAR(400) 400 -
CHAR(637) 637 -
DOUBLE -1 -
INTEGER -1 -
REAL -1 -
SMALLINT -1 -
VARCHAR -1 -
VARCHAR 24 -
VARCHAR 36 -
VARCHAR 259 -
 
http://voparis-tap-planeto.obspm.fr/
datatype "size" notes
BIGINT 1 -
DOUBLE 1 -
INTEGER 1 -
REAL 1 -
REGION 1 -
SMALLINT 1 -
TIMESTAMP 1 -
VARCHAR - -

Notes:

uuid In the /tables XML, this is defined as

<dataType xsi:type="vod:VOTableType" arraysize="36" extendedType="uuid">char</dataType>

CHAR(n) Adding the size to the data type makes it impossible to recognise the dataype without custom parsing.

Edit | Attach | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r1 - 2017-08-04 - DaveMorris
 
This site is powered by the TWiki collaboration platformCopyright © 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback