Skip to main content
Geographic Information Systems

Return to Question

Removed chitchat as per help center instruction
Source Link
PolyGeo ♦
PolyGeo ♦
  • 65.4k
  • 29
  • 114
  • 345

I am trying to recreate something I successfully did using geodatabases, but I want to edit in a Feature Service on Portal instead.

Essentially, I am performing bulk edits in a feature service by deleting and replacing features that have been updated and identified using a matching ID field.

I used this blog post to get the initial FME workbench working: https://www.globema.com/how-to-do-a-bulk-database-update-with-fme/

I have a reader for the update data in a geodatabase. This fed into an AttributeCreator transformer that used the fme_db_operation as an attribute and would Insert the updated data and delete the old data based on a matching ID field. The writer is the geodatabase with data to be updated, and selected by using the Row Selection option in the writer parameters.

If I change the writer to the feature service on Portal, Row Selection is not an option. 

Is there a way I could select the features I want to delete, based on a matching ID field, and delete those? 

I've played around with FeatureJoiner and Testers with no luck so far.

Thank you for any assistance in advance. For context, I am a beginner/intermediate FME Form user and an advanced Esri ArcGIS Pro and Portal user. Please let me know if there is anything I can clear up too!

I am trying to recreate something I successfully did using geodatabases, but I want to edit in a Feature Service on Portal instead.

Essentially, I am performing bulk edits in a feature service by deleting and replacing features that have been updated and identified using a matching ID field.

I used this blog post to get the initial FME workbench working: https://www.globema.com/how-to-do-a-bulk-database-update-with-fme/

I have a reader for the update data in a geodatabase. This fed into an AttributeCreator transformer that used the fme_db_operation as an attribute and would Insert the updated data and delete the old data based on a matching ID field. The writer is the geodatabase with data to be updated, and selected by using the Row Selection option in the writer parameters.

If I change the writer to the feature service on Portal, Row Selection is not an option. Is there a way I could select the features I want to delete, based on a matching ID field, and delete those? I've played around with FeatureJoiner and Testers with no luck so far.

Thank you for any assistance in advance. For context, I am a beginner/intermediate FME Form user and an advanced Esri ArcGIS Pro and Portal user. Please let me know if there is anything I can clear up too!

I am trying to recreate something I successfully did using geodatabases, but I want to edit in a Feature Service on Portal instead.

Essentially, I am performing bulk edits in a feature service by deleting and replacing features that have been updated and identified using a matching ID field.

I used this blog post to get the initial FME workbench working: https://www.globema.com/how-to-do-a-bulk-database-update-with-fme/

I have a reader for the update data in a geodatabase. This fed into an AttributeCreator transformer that used the fme_db_operation as an attribute and would Insert the updated data and delete the old data based on a matching ID field. The writer is the geodatabase with data to be updated, and selected by using the Row Selection option in the writer parameters.

If I change the writer to the feature service on Portal, Row Selection is not an option. 

Is there a way I could select the features I want to delete, based on a matching ID field, and delete those? 

I've played around with FeatureJoiner and Testers with no luck so far.

I am a beginner/intermediate FME Form user and an advanced Esri ArcGIS Pro and Portal user.

Source Link
Mar
Mar
  • 11
  • 1

Deleting features based on matching attributes in Feature Service using FME (similar to row selection)

I am trying to recreate something I successfully did using geodatabases, but I want to edit in a Feature Service on Portal instead.

Essentially, I am performing bulk edits in a feature service by deleting and replacing features that have been updated and identified using a matching ID field.

I used this blog post to get the initial FME workbench working: https://www.globema.com/how-to-do-a-bulk-database-update-with-fme/

I have a reader for the update data in a geodatabase. This fed into an AttributeCreator transformer that used the fme_db_operation as an attribute and would Insert the updated data and delete the old data based on a matching ID field. The writer is the geodatabase with data to be updated, and selected by using the Row Selection option in the writer parameters.

If I change the writer to the feature service on Portal, Row Selection is not an option. Is there a way I could select the features I want to delete, based on a matching ID field, and delete those? I've played around with FeatureJoiner and Testers with no luck so far.

Thank you for any assistance in advance. For context, I am a beginner/intermediate FME Form user and an advanced Esri ArcGIS Pro and Portal user. Please let me know if there is anything I can clear up too!