Skip to main content
Solved

Geopackage Table Handling

  • April 26, 2021
  • 2 replies
  • 172 views

Forum|alt.badge.img

Dear community,

 

I want to read a geopackage, transform it, and write into the same database. After the process the geopackage f_id need to be the same as in the beginning.

 

When I choose "update", "drop and create" and geopackage_fid as the ID Attribute in the writer settings, I get the warning "OGCGEOPACKAGE writer: Cannot perform Update on feature type 'grundnutzung' because feature with ID '21024' does not exist. Skipping feature".

 

When I choose "update" with "use existing" it works but features that have been deleted during the transformation still exist in the database.

 

When I choose "insert" and "drop and create" it works but then the features geopackage f_ids change.

 

What are the correct settings to write into the database keeping the same geopackage f_ids?

 

Thanks!

 

 

 

Best answer by takashi

Hi @vincenthischier​ ,I think you can control writer mode - i.e. UPDATE or DELETE - through fme_db_operation attribute. See here to learn more.

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/DatabaseWriterMode/feature_operations.htm

geopackage-writer-feature-operation-parameter

This post is closed to further activity.
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.

2 replies

takashi
Celebrity
  • 7843 replies
  • Best Answer
  • April 26, 2021

Hi @vincenthischier​ ,I think you can control writer mode - i.e. UPDATE or DELETE - through fme_db_operation attribute. See here to learn more.

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/DatabaseWriterMode/feature_operations.htm

geopackage-writer-feature-operation-parameter


Forum|alt.badge.img

Hi @vincenthischier​ ,I think you can control writer mode - i.e. UPDATE or DELETE - through fme_db_operation attribute. See here to learn more.

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/DatabaseWriterMode/feature_operations.htm

geopackage-writer-feature-operation-parameter

It worked, thank you!