Good day everyone!

I have lurked around here for info preiously, but this is my first post, so please be gentle if I commit any faux pas. Okay, let me try to break this down so we can all understand. (myself included)

I am attempting to edit a file GDB that contains over 1.5 million forest stand polygon records and change those that have a specific duplicated value. I will most likely be obtaining the information on how to do that from Generating sequential numbering for duplicate values in a field sorted by ObjectID, and since the data is stored on a file GDB, I will also be sourcing some code from Python script for identifying duplicate records (follow up), however that is the part that I have mostly figured out already.

My problem right now is that I am not familiar enough with python terminology to even properly explain the next step so I am going show you my thought process on this as best as I can. Warning: this explanation is not going to be in proper syntax simply because I am not very good at writing it quickly yet.

This is the part I think I understand what to do

IF Field A(called'NP')>0 AND Field B(called 'PREFID')contains a duplicate value THEN generate unique 'PREFID' value counting from +9999

and this is where it gets hinky for me:

Where a new value is created based on this criteria, I need another existing field (called 'MAPFID') to have a new value generated that will be a composite of the values in that row for the fields 'MAP' and the newly created 'PREFID' number. This field is called 'MAPFID'. Eg: if MAP=1343590 and PREFID=10000 then the value in MAPFID=134359010000

Because the 'MAP' value is based on UTM coordinates, the values for 'MAP' will not necessarily be sequential.

I realize that this may be a green thing to ask about, but this has been stumping me for too long and I can't seem to find anything online about this. I'm probably just not using the right vocabulary for my searches, but that just goes to show ya how green I am :P Any help would be greatly appreciated! Thanks guys and gals.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.