topic Re: sql api and arcsde compressed binary in Data Management Questions

sql api and arcsde compressed binary

deleted-user-0hg8sVY9GHfr — Thu, 12 Aug 2010 22:49:56 GMT

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.

Re: sql api and arcsde compressed binary

VinceAngelo — Fri, 13 Aug 2010 03:20:45 GMT

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

Re: sql api and arcsde compressed binary

BrentPierce — Fri, 13 Aug 2010 15:32:50 GMT

To convert storage types see the following thread.

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

Hope this helps.