For shapefiles, FME has the ability to create a spatial index for ESRI, but of course that requires an ArcGIS license to create (and another to use).
Might I suggest creating a QGIS compatible spatial index instead/as-well? That way folks who don't have ArcGIS can still enjoy fast shapefiles.
And as a bonus (probably a different PR), FME could probably integrate the spatial index handling with "search envelope" for shape reader and read the QIX file to speed up reading in those scenarios.
+19Hi Jonathan, until there's an option to write QIX files on the Shape writer, you could run ogrinfo in a SystemCaller after a FeatureWriter, e.g. C:\\OSGeo4W64\\bin\\ogrinfo.exe $(DestDataset_ESRISHAPE)/to_be_indexed.shp -sql "CREATE SPATIAL INDEX ON to_be_indexed"
+19
+20I'm pleased to let you know that the ability to create a spatial index for QGIS has been added as a parameter option to the new bulk mode enabled Shapefile writer in FME 2019.2 betas. You can find our latest installers at https://www.safe.com/support/downloads/#beta
Users will have the ability to select which application to create a shapefile index for ArcGIS, QGIS, or both applications within the Create Shapefile Index writer parameter.
If this does not address your concerns, please let me know in the comments.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
