Python: Comparing attributes in a SQL Server table with a ArcSDE feature class

KevinCressy

Morning all,

I have been asked to write a python script to update an ArcSDE feature class using information recorded in a separate SQL Server table.

I have a table of data that regularly gets updated by staff in my organisation.  This table has a unique identifier that corresponds with a unique identifier in a point feature class in ArcSDE.  I need to:

- look up the first unique ID in the table
   - find the corresponding value in the ArcSDE feature class.
   - check to see if the attributes values in the table are different to the attribute values for same feature in the ArcSDE feature class
   - if there are any changes update the ArcSDE feature with the attribute values from the table.
- go to next record in the table and start the process again.

Is there an easy way cycle through each feature in the ArcSDE feature class and make this comparison?

Any help would be appreciated.

Many thanks,

Kevin

VINCENTHERRERA

Of course, they would work. Just store a copy of the database connection in any drive,say G:drive or whatever. Example G:\Folder\DB.sde. Set this as your workspace and there you go!. Let me know if you have any other question.

I have a similar issue with compare however what I need to compare is globalID's in (2) tables due to replication this code seems to address what I would like to do, however I dont need it to update any records.What I would like to do after it compares is receive a message that tells me it matched or not even better it would be nice if I could get it to created a list of matched and unmatched globalID's based on the same features.
Do you think I can use this and modify it to read the (2) feature classes?

Vin