2

I used FME to convert some geodatabases into GeoPackages. However, I updated some layers inside some geodatabases and need to do the same for the GeoPackages in FME. I opened the FME Data Inspector and could not find a way to delete features in GeoPackages.

Is there a proper way to delete features in GeoPackages? So I can add the updated version.

1

1 Answer 1

3

There are a couple of ways to do this.

  1. You just run the original workspace again, and create a new GeoPackage. Make sure it's set to overwrite, not append, the original file.
  2. You send only the updated features to a GeoPackage writer, with the mode set to something different. You can use the existing workspace or create a new one to do this.

enter image description here

Here I am using the Update mode. You might want to use the Delete mode instead.

  1. Do change detection. The advantage here is that it handles updates, deletes, and inserts all in one go. Best to start with a new workspace. Add a reader for the Geodatabase and one for the Geopackage. Connect them both into a ChangeDetector transformer. Send the output to the GeoPackage writer and set the mode (as above) to fme_db_operation

You'll find more detailed instructions for change detection on the FME knowledge base at community.safe.com

Regardless, the Data Inspector tool won't let you edit or delete records. It's purely for viewing data, not editing.

2
  • The first option seems to be the easiest. I am new in FME. I haven't saved the workspace though. How can I find the overwrite option?
    – GIS Noh
    May 12, 2023 at 8:34
  • Overwrite would be in the Navigator window, usually on the left hand side of Workbench May 26, 2023 at 15:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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