Writing spatial index on File geodatabase with a specific grid size
+1Best answer by mark2atsafe
I don't have ArcGIS installed right now, so I can't give you a screenshot (because w/o ArcGIS I can't create a Geodatabase Writer in FME) but you should open up the table definition in FME by clicking the cog icon on the Writer table objects. Then click the tab labelled Format Parameters. In there you should find some settings to control the grid size.
See this page for more info:
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.
+1Identifier
MessageBase_value(Python)Test_value(FME)"25""GeometryDef""GeometryDef grid count does not match""2""1""GeometryDef""GeometryDef grid size 1 does not match""0.089000000000""0.089000000000""GeometryDef""GeometryDef grid size 2 does not match""0.534000000000""0.000000000000"I did a geometry comparison for two File Geodatabase created from FME and existing Python script. I got the above result as differences. I want to know if it is possible to specify the spatial index grid size and count for creating indexes. I know it can be done using Python scripting but I want to use that as a last resort.
Please suggest what to do.
Vivek
+59- Safer
- Best Answer
I don't have ArcGIS installed right now, so I can't give you a screenshot (because w/o ArcGIS I can't create a Geodatabase Writer in FME) but you should open up the table definition in FME by clicking the cog icon on the Writer table objects. Then click the tab labelled Format Parameters. In there you should find some settings to control the grid size.
See this page for more info:
+1Thanks Mark. Yes, there is an option of Grid size for Grid 1. However, the link provides option for multiple grid sizes. I am just curious if it is possible to specify multiple grid values.
+23- Contributor
Another option that can be used is to create an empty file geodatabase using ArcGis, set the right Grid index in ArcGis and use that empty file geodatabase to write to (do not overwrite) with FME.
The settings created in ArcGis should remain in the file geodatabase.
+1Thanks Erik! I created the same effect using Template Geodatabase created by ArcGIS. The benefit which I had was to avoid rows getting inserted on multiple run.