1

This question already has an answer here:

I am preparing some data using FME, which I end up writing to an Esri file geodatabase. Unfortunately, FME doesn't appear to update the written feature classes' spatial indices. This results in display problems when I later inspect the written data with ArcMap (or other ArcGIS desktop tools).

It appears that there are two seemingly easy solutions for this problem:

  • Recreate any spatial indices after writing data.
  • Compact the file geodatabase after writing data.

Compacting seems like the easier choice, because it can be done per geodatabase (vs. recreating indices per feature class).

I don't want to compact the geodatabase manually; ideally I'd want to compact the geodatabase inside my FME workbench, using a shutdown Python script. However, there appears to be no ArcGIS geoprocessing tool for compacting a geodatabase (only one for compressing, which is not the same thing).

Does anyone have a solution here?

  • Updating the spatial indices directly in FME; or
  • compacting a file geodatabase using ArcPy (in an FME shutdown script).

marked as duplicate by ianbroad, Community Aug 17 '15 at 16:35

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

5

There is a GeoProcessing tool called Compact that will compact file or personal geodatabases and can be used within a model or called by an arcpy script.

  • I must have gone blind. Or I can blame Esri for translating tool names in localized versions of ArcGIS. Thank you for pointing me in the right direction! – stakx Aug 17 '15 at 16:35
  • The Help file is huge and ESRI seem to reconfigure it with each major release, it some times feels like the situation of you cannot see the wood for the trees! – Hornbydd Aug 17 '15 at 16:40
  • Turns out there is also an option in the FME Geodatabase writer, the "advanced" area, which does Compact. Sadly, it is labeled "compress" and we know we need to fix that. But in an FME world, that is how you can get Compaction to happen. – Dale Lutz Aug 20 '15 at 20:58

Not the answer you're looking for? Browse other questions tagged or ask your own question.