Skip to main content
Question

Avoiding SDE spatial index creation

  • June 1, 2018
  • 3 replies
  • 102 views
_trent
Contributor
Forum|alt.badge.img+1

Is it possible to write annotation features to an ArcGIS SDE annotation feature class without a spatial index being created in FME?

I am writing annotation features to ArcGIS SDE on SQL Server using the GEODATABASE_SDE writer. I delete the spatial index on the target annotation feature class before running FME. I do not want a spatial index created on the feature class, but FME appears to always be creating one. Referencing this article I have tried the below FME and SDE settings, but the result is always the same.

Environment:

  • FME 2018.0.1.0 (20180518 - Build 18310 - WIN32)
  • ArcGIS Desktop 10.2.1
  • ArcSDE 10.2.1
  • SQL Server 2014

Feature Type Grid 1 Value

SDE LOAD_ONLY Mode

Spatial Index Created

unset/blankYes

Yes

0

Yes

Yes

-1

Yes

Yes

unset/blank

No

Yes

0

No

Yes

-1

No

Yes

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

lars_de_vries
Forum|alt.badge.img+10

Looking at this thread, that is referenced from the page you mention, it seams as if it is not possible to not create a Spatial Index unless you're writing to Oracle.

_trent
Contributor
Forum|alt.badge.img+1
  • _trentContributor
  • Author
  • Contributor
  • June 4, 2018

Looking at this thread, that is referenced from the page you mention, it seams as if it is not possible to not create a Spatial Index unless you're writing to Oracle.

Maybe. Since I'm using the GEODATABASE_SDE writer in FME I wasn't sure if that referenced page applied, as it deals with the SDE C API.

 

Using the ArcGIS geoprocessing modules, though, I can run an Append from a file geodatabase to SDE and the spatial index isn't created. So it seems like this should be possible in ArcObjects, which I assume is what FME is using under the hood.

 

 

lars_de_vries
Forum|alt.badge.img+10
Maybe. Since I'm using the GEODATABASE_SDE writer in FME I wasn't sure if that referenced page applied, as it deals with the SDE C API.

 

Using the ArcGIS geoprocessing modules, though, I can run an Append from a file geodatabase to SDE and the spatial index isn't created. So it seems like this should be possible in ArcObjects, which I assume is what FME is using under the hood.

 

 

The only thing I can find about the Grid 1 Value, is that it only needs to be set when creating new feature classes, since in all other situations the grid already is present. Bottom of this page, it is mentioned a second time on this page. The first is about Feature Type parameters and the second about Writer parameters.

 

Sorry I can't help you any further. I no one responses I would contact your reseller to file a question there.

 

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.