topic Re: calculate field in ArcGIS Pro Questions

calculate field

itayroei — Thu, 15 Feb 2024 12:17:21 GMT

Hi dear community.

I need to accumalate value of one field by order of other field.

I sucsses to accumlate value but the order detaramine by "OBJECTID"

who can i change that?

thanks

itay

Re: calculate field

PedroCoutinhoMendonça — Thu, 15 Feb 2024 12:52:34 GMT

Hello Itay! You can use update cursor in python do achieve what you want. In the sql_clause parameter there is one exemple of the epression used with ORDER BY

https://pro.arcgis.com/en/pro-app/3.1/arcpy/data-access/updatecursor-class.htm

with arcpy.da.UpdateCursor( in_features, ['OID@', "ELEVATION"], sql_clause=("TOP 5", "ORDER BY ELEVATION DESC") ) as cur:

Re: calculate field

Amir-Sarrafzadeh-Arasi — Thu, 15 Feb 2024 13:40:15 GMT

Dear itayroei,

I hope you are doing well,

If you are using ArcGIS Pro, you can do by this way, insert a New Notebook,

and write the python script like below image,

Here I read the Airports feature layer as a Pandas DataFrame, you should put your feature layer's name.

Then I have sorted by scale value, which you should put the name of the column which you want to sort the dataframe, and then create a new column which is accumaled values of size column which you should put yours.

If need more info please let me know.

Hope it works,

Best Wishes

Re: calculate field

itayroei — Fri, 16 Feb 2024 04:32:28 GMT

thank you Amir

i will try your solution in sundey and let you knew if it's work for me

good weekend

itay

Re: calculate field

itayroei — Fri, 16 Feb 2024 04:38:27 GMT

thank you pedro

i will try your solution

hopes that it's work for me

best regards

itay