topic Re: Calculating a field using Orderby in ArcGIS Pro Questions

Calculating a field using Orderby

Azita — Fri, 02 Aug 2024 00:03:37 GMT

Hello!

GIS newbie here looking for help with an Arcade expression.

I have a field named BeginTime with content such as "2024-06-20T11:36:31-07:00, 2024-06-20T11:36:16-07:00." I'm honestly not sure what the 07:00 is about but the orange timestamp is what I'm looking to use to number my field, "TPE." I want TPE to list the features/points as integers in order of time collected.

I'm not sure what it means by "wrong number of arguments."

Thanks!

Azita

Re: Calculating a field using Orderby

jcarlson — Fri, 02 Aug 2024 01:41:06 GMT

OrderBy takes two arguments, a FeatureSet and a SQL expression used to sort the features.

You can definitely still use Arcade for this, but it's probably not going to work very well. In a field calculation, the expression will have to evaluate for every feature separately, but since the value you want is dependent up on each feature's relation with every other feature, well, that expression could take a long time to run.

This wouldn't be terrible in Python, perhaps, but you're almost better off exporting to a spreadsheet, sorting the sheet and adding an auto-increment value there, then joining the sheet back into your layer based on the objectid. Then you could just refer to the joined field in your field calculation.

Re: Calculating a field using Orderby

vsogekr9 — Fri, 02 Aug 2024 07:16:28 GMT

Ah legend, it works! I'm not too sure why though, still very new to SQL. Could you explain what left outer and join does?

And ya the 'Likes has no default value' is weird. I think it could be because the column heading isn't the name of the column or something like that but not too sure.

Re: Calculating a field using Orderby

vsogekr9 — Sun, 04 Aug 2024 23:02:34 GMT

@vsogekr9 wrote:
Ah legend, it works! I'm not too sure why though, still very new to SQL. Could you explain what left outer and join does?
And ya the 'Likes has no default value' is weird. I think it could be because the column heading isn't the name of the column or something like that but not too sure https://omegle.onl/ .

I got this,...