Skip to main content
Writing spatial index on File geodatabase with a specific grid size

Identifier

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


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:

http://docs.safe.com/fme/2016.1/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/Configuration_Parameters.htm


Thanks 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.


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.


Thanks 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.


Reply