Skip to main content
Solved

Geopackage Table Handling


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

View original
Did this help you find an answer to your question?

2 replies

takashi
Influencer
  • 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
takashi wrote:

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!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings