The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hi, we have a GIS application here, intending to be migrated to SQLA 12/16. Its using Oracle SDO types pretty much, which are some special spatial types for geometry, under MDSYS schema. Dont know much about it, but as per: ..its not only single datatype as we all know with SQLA, but it also bundles lots of other stuff, like special geo indexing, separate engine, some converters etc..

I was trying with PowerDesigner, it converts oracles spatial datatypes into char(10) types, but I believe here its not so easy, though I have zero experiences with spatial data on both ORA and SQLA.

Is it possible to get those SDO data into SQLA, and/or how does it work with Mobilink ?

Many thanks in advance.

asked 02 May '13, 07:41

marchello's gravatar image

accept rate: 14%

The Oracle spatial data can be unloaded into a common format that can be loaded into SQL Anywhere spatial columns. The format is either "well known text" or "well known binary". I think the oracle function is called something like sdo_util.to_wktgeometry().
In SQL Anywhere, you would then use the ST_GeomFromText() method to load the data into a spatial column.

For example, if you set up a proxy connection to Oracle from SA, you could do something like this
(note that this is pseudocode):
create variable xfer long varchar;
select sdo_util.to_wktgeometry(geometry_column) into xfer from Oracle_geometry_table;
Insert into SA_geometry_table( geometry_column) values( ST_Geometry::ST_GeomFromText( xfer, srid ) );

The srid value is the spatial reference system being used for the data, which you can look up in the Oracle database definition.

permanent link

answered 02 May '13, 10:32

Jason%20Hinsperger's gravatar image

Jason Hinspe...
accept rate: 35%

Many thanks Jason, will discuss it our team, in case we would need some more info, will kindly let you know here. cheers

(03 May '13, 03:05) marchello
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 02 May '13, 07:41

question was seen: 913 times

last updated: 03 May '13, 03:30