Skip to content

Can't access coordinates in TAP schema #20

@ebrassfieldbourke

Description

@ebrassfieldbourke

This could be my own ignorance here regarding the manifestation of the model via the vo-dml, however, I cannot find a way to actually get back the coordinates on an observation. If this is via POINT or another shape, I'm also not yet able to access those.
SELECT column_name, description FROM TAP_SCHEMA.columns WHERE table_name = 'targetposition'

Results in:
TAP result from UKSRC Archive Service on 2025-04-22T15:36:22Z SELECT column_name, description FROM TAP_SCHEMA.columns WHERE table_name = 'targetposition' column_name description equinox colDesc id colDes coordinates_id colDesc "coordsys" colDesc

Which shows a key id for coordinates, called coordinates_id. However, I cannot get a description to result for a coordinates table that will tell me how it is organised so that I can query it.
TAP result from UKSRC Archive Service on 2025-04-22T15:34:19Z SELECT column_name, description FROM TAP_SCHEMA.columns WHERE table_name = 'coordinates' column_name description

Following the schema diagram, it shows the datatype for coordinates to be caom2:caom2.types.Point, but I've not been able to find a way to use that yet, and I believe we were told there are no 'Shape' items available yet.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions