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

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

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.