topic Re: Calculate Fields Using Python in Geoprocessing Questions

Calculate Fields Using Python

RobertBradley1 — Wed, 09 Sep 2015 14:43:24 GMT

Hello,

I have some tables in our Enterprise GeoDatabase that are used in a Map Service for another application, Cityworks 2013. To link the table asset to other data created in Cityworks (Work orders, etc.), a particular field must be designated for linking. This field must be unique and unchanging for each asset row in the table, and also the application is being used to add new assets to said tables. When a new asset record is added by Cityworks it does not automatically calculate the field designated for linking in the correct method. It simply places an OBJECT ID in that field, but we need it to also have a combination of other attributes. When performing a mass upload of this tabular asset data into our GeoDatabase I employed Field Calculator to update these fields using a concatenation Python Expression: "%s-%s-%s" % ('CP', !Field1!, !Field2!)

I would like to automated this expression to update this field on a regular basis, but cannot figure out a way to only update new records that have been added by the application and not overwrite existing data. Any help would be greatly appreciated!

Robert

Re: Calculate Fields Using Python

JakeSkinner — Wed, 09 Sep 2015 15:23:28 GMT

Hi Robert,

You could incorporate an IF statement to determine if the field is blank. If it is, then you can run the calculation. Ex:

Re: Calculate Fields Using Python

RobertBradley1 — Wed, 09 Sep 2015 15:51:54 GMT

Thanks Jake but in my statement 'CP' is not a field but just a text string I'm adding. Also I am only trying to update one field, called CityworksID not three. Basically I need it to look at that field, determine if it meets certain qualifications (i.e. maybe if it contains 'CP'), and if not update to a concatenated value using the string text 'CP' + !Field1! (an asset type)+ !Field2! (a number)

For example the final value would be CP-PUMP1-0001

Thanks for helping!!

Re: Calculate Fields Using Python

WesMiller — Wed, 09 Sep 2015 16:04:38 GMT

I would use select by attribute to isolate the new records then run your field calculator.

Re: Calculate Fields Using Python

DarrenWiens2 — Sun, 12 Dec 2021 00:08:38 GMT

Your expression would be:

CityworksID=
myFunction(!CityworksID!, !Field1!, !Field2!)

and the code block:

def myFunction(cw, f1, f2):
    if 'CP' not in cw:
        return cw # or some other default
    else:
        return 'CP-' + f1 + str(f2)

Re: Calculate Fields Using Python

RobertBradley1 — Wed, 09 Sep 2015 18:55:05 GMT

Thank you Darren!! I think this might just work. Didn't think about using myFunction

Going to test this on a test database right away.