Solved

Geopackage Table Handling

  • 26 April 2021
  • 2 replies
  • 16 views

Badge

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!

 

 

 

icon

Best answer by takashi 26 April 2021, 12:55

View original

2 replies

Userlevel 2
Badge +17

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

Badge

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!

Reply