Task #4317 (new)
Opened 13 years ago
Last modified 12 years ago
ROI model-database alignment — at Version 9
Reported by: | wmoore | Owned by: | ajpatterson |
---|---|---|---|
Priority: | major | Milestone: | OMERO-Beta4.3 |
Component: | Model | Keywords: | n.a. |
Cc: | jburel, ajpatterson, jamoore | Story Points: | n.a. |
Sprint: | n.a. | Importance: | n.a. |
Total Remaining Time: | 0.0d | Estimated Remaining Time: | n.a. |
Description (last modified by wmoore)
Some differences between what the model supports and what the database contains or clients write to DB.
ROI model: http://www.ome-xml.org/browser/Documentation/Graphics/ROI/2010-04/Ome-ROI-overview-standard.png
Looking at the Shape table:
- Does not have 'marker' column ('arrow' etc in the model)
- 'path' is not supported
- Line is not supported by measurement tool. Uses polyline.
- 'transform' model says this should be a String with 6 numbers. Database contains strings such as "rotate(0, 100,50)"
- font weight (not used?)
- 'Verdana' in DB, not in model.
Attribute Write Read ------------------------------------------- FontStyle no no FontSize no yes FontFamily no only Courier recognised LineI polyline line or polyline
Database shape table:
Column | Type | Modifiers --------------------------+------------------------+----------- discriminator | character varying(31) | not null id | bigint | not null permissions | bigint | not null fillcolor | integer | - no e.g. fillrule | character varying(255) | - no e.g. fontfamily | character varying(255) | fontsize | integer | fontstretch | character varying(255) | fontstyle | character varying(255) | fontvariant | character varying(255) | fontweight | character varying(255) | g | character varying(255) | locked | boolean | strokecolor | integer | strokedasharray | character varying(255) | strokedashoffset | integer | strokelinecap | character varying(255) | strokelinejoin | character varying(255) | strokemiterlimit | integer | strokewidth | integer | thec | integer | thet | integer | thez | integer | transform | character varying(255) | vectoreffect | character varying(255) | version | integer | visibility | boolean | points | text | textvalue | text | cx | double precision | cy | double precision | anchor | character varying(255) | baselineshift | character varying(255) | decoration | character varying(255) | direction | character varying(255) | glyphorientationvertical | integer | writingmode | character varying(255) | x | double precision | y | double precision | d | text | height | double precision | rx | double precision | width | double precision | bytes | bytea | ry | double precision | x1 | double precision | x2 | double precision | y1 | double precision | y2 | double precision | creation_id | bigint | not null external_id | bigint | group_id | bigint | not null owner_id | bigint | not null update_id | bigint | not null roi | bigint | not null pixels | bigint | roi_index | integer | not null pg_geom | polygon |
Change History (9)
comment:1 Changed 13 years ago by wmoore
comment:2 Changed 13 years ago by wmoore
omero=# select g, locked, fillcolor, fillrule, strokecolor, strokedasharray, strokedashoffset, strokelinecap, strokelinejoin, strokemiterlimit, strokewidth from shape order by id desc; g | locked | fillcolor | fillrule | strokecolor | strokedasharray | strokedashoffset | strokelinecap | strokelinejoin | strokemiterlimit | strokewidth ---+--------+------------+----------+-------------+-----------------+------------------+---------------+----------------+------------------+------------- | f | 1073741824 | | -993737532 | | | | | | 1 | f | 1090453504 | | -989856000 | | | | | | 1 | f | 1073741824 | | -993737532 | | | | | | 1
comment:3 Changed 13 years ago by jburel
- Cc jmoore added
comment:4 Changed 13 years ago by wmoore
omero=# select discriminator, transform, vectoreffect, version, visibility, anchor, baselineshift, decoration, direction, glyphorientationvertical, writingmode from shape order by id desc; discriminator | transform | vectoreffect | version | visibility | anchor | baselineshift | decoration | direction | glyphorientationvertical | writingmode ---------------+--------------------------------------------------+--------------+---------+------------+--------+---------------+------------+-----------+--------------------------+------------- text | none | | | | | | | | | text | none | | | | | | | | | polyline | none | | | | | | | | | polygon | none | | | | | | | | | rect | none | | | | | | | | | rect | none | | | | | | | | | rect | none | | | | | | | | | ellipse | translate(245.74999251304587 209.50000561479504) | | | | | | | | |
comment:5 Changed 13 years ago by wmoore
'Line' vv 'Polygon'
discriminator | points ---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------- text | polyline | points[137,433, 183,260] points1[137,433, 183,260] points2[137,433, 183,260] mask[0,0] polygon | points[472,112, 473,162, 378,91, 437,51, 509,68] points1[472,112, 473,162, 378,91, 437,51, 509,68] points2[472,112, 473,162, 378,91, 437,51, 509,68] mask[0,0,0,0,0] rect |
comment:6 Changed 13 years ago by wmoore
omero=# select discriminator, d, bytes, roi, pixels, roi_index, pg_geom from shape order by id desc; shell-init: error retrieving current directory: getcwd: cannot access parent directories: Permission denied discriminator | d | bytes | roi | pixels | roi_index | pg_geom ---------------+---+-------+-----+--------+-----------+--------- polyline | | | 905 | | 2 | polyline | | | 905 | | 1 | text | | | 907 | | 0 | text | | | 906 | | 0 | polyline | | | 905 | | 0 | ... older ellipse | | | 646 | | 1 | ((0,0)) ellipse | | | 646 | | 0 | ((0,0)) ellipse | | | 645 | | 1 | ((0,0)) ellipse | | | 645 | | 0 | ((0,0))
comment:7 Changed 13 years ago by wmoore
- Description modified (diff)
comment:8 Changed 13 years ago by wmoore
- Description modified (diff)
comment:9 Changed 13 years ago by wmoore
- Description modified (diff)
Note: See
TracTickets for help on using
tickets.
You may also have a look at Agilo extensions to the ticket.