sql api and arcsde compressed binary

[deleted-user-0hg8sVY9GHfr]

can i assume that if my spatial is stored in arcsde compressed binary that i cannot perform queries with the sql api on that data?

if not then is there a method to convert the data on the fly so that i can use the sql api?

thanks for any information.

[VinceAngelo]

You can only perform SQL operations with ST_GEOMETRY or native geometry storage
(PostGIS/SDO_GEOMETRY/GEOMETRY/GEOGRAPHY).

There are utilities to convert an entire table to a new storage format, but it is not possible
to convert SDEBINARY/SDELOB to ST_GEOMETRY/native on the fly in via SQL.

- V

[BrentPierce]

To convert storage types see the following thread.

http://forums.arcgis.com/threads/10008-Converting-between-Geodatabase-and-SQL-Server-Spatial

Hope this helps.