...
When you create your Standard Layers in Studio you may wish to extract the information for a specific Annotation Layer and this can be done by Modifying the SQL when you create the Layer. The scratch_id id field is actually the layerid i.e. the unique key for the Annotation Layer so your SQL would be something like...
...
When creating your Layer to display the Annotation Line information you may wish to exclude the Annotation Text entries which show up as lines. If this is the case then you just need to add the following to your select statement:
...