Question
I need to update both spatial and attribute data
I need to update both spatial and attribute data in an existing ESRI feature class. I have XYZ data that is in WGS84 so it needs to be reprojected and with it there is tabular data as well. The data contains a primary key field to join with the point feature class that I need to update. I am just not sure where to start. I figured that I could create a point layer in memory and use it to reproject with and then do a join with the feature class and update all of the attributes including the geometry. Any suggestion would be greatly appreciated.
Hi
If you're new to FME, I recommend you start by watching this recorded webinar:
https://www.youtube.com/watch?v=rgnpPzTwe1g
There are also a lot of helpful articles here on FMEpedia, e.g. https://knowledge.safe.com/articles/Samples_and_Demos/Updating-Inserting-and-Deleting-features-in-an-unversioned-Geodatabase
David
David,
Thanks for the information. I have been looking through the articles and community for help but I have not been able to find what I need. I need to update both geometry and tabular in a versioned feature class with data from a spreadsheet. The tabular data I think I can do by mapping the fields. It is the geometry that I don't know how to do with FME.
Thanks
?Don
Hi
As long as the updated geometry reaches the Geodatabase writer, you should be set. You can e.g. use an Inspector (or an inspection point/breakpoint) in your workspace to verify the presense of the new geometry.
David
The article that David refers to in his comment is a little out of date, if you're brave enough to be using the FME 2016 betas (the feature type Format Parameters GUI has been changed), but the principals are the same. In the end you need to understand the workings of fme_db_operation. As for joining your points to the table, you can use Joiner, SQLExecutor or FeatureMerger. The Joiner documentation does give some clues on the differences between these transformers. Also, you might find it useful to work through the FME for Esri training materials
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.