Latest Contributions by OLANIYANOLAKUNLE

‎09-20-2017

Thank you RANDY!!!! You are the best.....

‎09-20-2017

I want to construct a replace statement in my python script through the following python code below; arcpy.CalculateField_management("Mainfb_Stage_P","AFileN","!ABFileN!","PYTHON_9.3","replace(ABFileN, "/","-")") But i keep getting the error below; Runtime error Traceback (most recent call last): File "<string>", line 1, in <module> TypeError: unsupported operand type(s) for /: 'str' and 'str' Anyone with a wonderful suggestion. Thanks

‎09-25-2016

You're the MAN! Thanks

‎09-20-2016

Thanks a MILLION!!!!

‎09-18-2016

Evening Dan, i know its a long time since i started this thread your code works but it leaves zeros instead of the actual total considering the concatenations from the previous row. Please kindly check my code out so as to see if you can enhance it further? Form1 = "Form1" Calculated_EA1=0 with arcpy.da.UpdateCursor(Form1, ["OBJECTID", "EstimatedPopulationinEA", "Calculated_EA"]) as cursor: for row in cursor: Calculated_EA2 = row[1] row[2] = (Calculated_EA1 + Calculated_EA2) Calculated_EA1 += Calculated_EA2 if row[2] >= 500: row[2] = Calculated_EA2 - 500 cursor.updateRow(row)

‎07-21-2016

I'm actually running it from a script. This is what it should look like really; When the totaling reaches the 500 threshold, it should then start again from zero (0).

‎07-21-2016

This was what i got when i tried the script And this is the script below; CensusBldForm = "SCensusBldForm" vsum = 0 flds = ["OBJECTID", "EstimatedPopulationinEA", "Calculated_EA"] with arcpy.da.UpdateCursor(CensusBldForm, flds) as cursor: for row in cursor: vsum += row[1] if vsum >= 500: vsum = vsum - 500 row[2] = vsum cursor.updateRow(row)

‎07-13-2016

I got the error below when i incorporated the lines of code you suggested; vsum = vsum + row[1] TypeError: unsupported operand type(s) for +: 'float' and 'NoneType' See my code; CensusBldForm = "SCensusBldForm" vsum = 0 flds = ["OBJECTID", "EstimatedPopulationinEA", "Calculated_EA"] with arcpy.da.UpdateCursor(CensusBldForm, flds) as cursor: for row in cursor: vsum = vsum + row[1] if vsum >= 500: vsum = vsum - 500 row[2] = vsum cursor.updateRow(row) What do you think i'm doing wrong?

‎07-13-2016

Thanks for saving my day!!!!

‎07-13-2016

I'm trying to create a distinct list of values in my Python addin combo box drop down list; i already have the script that actually shows all the values of the field appended to my combo box drop down. What i intend to achieve with this is to have a list of distinct values on my drop down - see my code below; def __init__(self): OBJECTID = [] for row in arcpy.SearchCursor("BldForm"): OBJECTID.append(row.Combo) self.items = sorted(OBJECTID) self.editable = True self.enabled = True self.dropdownWidth = 'WWWWWWWWWWWW' self.width = 'WWWWWWWWWWWW' def onSelChange(self, selection): mxd = arcpy.mapping.MapDocument("Current") for df in arcpy.mapping.ListDataFrames(mxd): if df.name == "Layers": dfmain = arcpy.mapping.ListDataFrames(mxd, "Layers")[0] OBJECTID = [] for row in arcpy.SearchCursor("BldForm"): OBJECTID.append(row.Combo) I'll kindly appreciate your help on this.

‎04-26-2016

Thanks

‎04-26-2016

Thanks i changed from the default version to another version and i didn't get any error and my edits where retained as well.

‎04-26-2016

Thanks, i'm actually running my script against an SDE Geodatabase

‎04-26-2016

This is the error message i get when i want to save edits; Kindly assist me please. Thanks in advance

‎04-26-2016

My edits don't get saved after running the script, because i have to start an edit session before running the script; CensusBldForm = "CensusBldForm" Calculated_EA1=0 with arcpy.da.UpdateCursor(CensusBldForm, ["OBJECTID", "EstimatedPopulationinEA", "Calculated_EA"]) as cursor: for row in cursor: Calculated_EA2 = row[1] row[2] = (Calculated_EA1 + Calculated_EA2) Calculated_EA1 += Calculated_EA2 cursor.updateRow(row) What do you think might be wrong or better still can i get it to run without starting an edit session i.e using a arcpy.UpdateCursor instead of arcpy.da.UpdateCursor? Thanks

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by OLANIYANOLAKUNLE

Re: I want to construct a replace statement in my python script

I want to construct a replace statement in my python script

Re: I need to automatically calculate a field based on values from previous rows

Re: I need to automatically calculate a field based on values from previous rows

Re: I need to automatically calculate a field based on values from previous rows

Re: I need to automatically calculate a field based on values from previous rows

Re: I need to automatically calculate a field based on values from previous rows

Re: I need to automatically calculate a field based on values from previous rows

Re: I'm trying to create a distinct list of values in my Python Addin combo box drop down list

I'm trying to create a distinct list of values in my Python Addin combo box drop down list

Re: My python script calculates only the value of the immediate previous record

Re: My python script calculates only the value of the immediate previous record

Re: My python script calculates only the value of the immediate previous record

Re: My python script calculates only the value of the immediate previous record

Re: My python script calculates only the value of the immediate previous record

Re: Export data from Map Service

Use Arcpy to Unselect the currently selected Featu...

Re: I need to automatically calculate a field base...

Re: I need to automatically calculate a field base...

How Can I Close an mxd using arcpy script