Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How are geometries stored into Oracle?

April 26, 2017geometries Oracle stored

0

Posted

How are geometries stored into Oracle?

1 Answer

0

Posted

The Realworld SyncManager has comprehensive geometry support. Points, oriented or not, lines, areas and texts are all supported. The SDO_GEOMETRY column type is used to store geometries into Oracle. Since there is no text geometry type in Oracle, each smallworld text geometry requires 2 Oracle columns, 1 to keep the geometry itself, as a point, and a second column to store the string of the text geometry. The V2 release has support the dimension geometries as well. Each Smallworld dimension_holder geometry is stored into 5 Oracle columns. – 1 sdo_geometry of type MULTILINE that holds the lines making up the dimension geometry – 2 sdo_geometry of type MULTIPOINT columns that hold the location of the symbols and labels making up the dimension geometry – 2 sync_dim_info, which is a string vector type, columns to store the symbol names and text strings.