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: http://en.wikipedia.org/wiki/Oracle_Spatial_and_Graph ..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
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().
For example, if you set up a proxy connection to Oracle from SA, you could do something like this
The srid value is the spatial reference system being used for the data, which you can look up in the Oracle database definition.
answered 02 May '13, 10:32