topic Re: Adding sequential numbers for the selected features in ArcGIS Pro Questions

Adding sequential numbers for the selected features

YuvarajuDhananjay — Wed, 17 Jan 2024 19:41:39 GMT

I need sequential numbers(1,2,3...) for the selected features in the particular feild in attribute table, how to do it?

Re: Adding sequential numbers for the selected features

SLouq — Wed, 17 Jan 2024 19:46:12 GMT

Check out this page

https://support.esri.com/en-us/knowledge-base/how-to-sort-and-create-a-sequentially-ordered-id-field-000018847

Re: Adding sequential numbers for the selected features

Raul — Wed, 17 Jan 2024 19:46:21 GMT

Check out this arcticle by ESRI Support, It's for ArcMap but it still works in pro! You can modify the python code to fit your needs :).

https://support.esri.com/en-us/knowledge-base/how-to-create-sequential-numbers-in-a-field-in-arcmap-u-000011137

If you want something more simple, calculate your field equal to the ObjectID

Re: Adding sequential numbers for the selected features

CodyPatterson — Wed, 17 Jan 2024 19:47:20 GMT

Hey @YuvarajuDhananjay

You may have luck using this here:
https://support.esri.com/en-us/knowledge-base/how-to-sort-and-create-a-sequentially-ordered-id-field-000018847

Cody

Re: Adding sequential numbers for the selected features

YuvarajuDhananjay — Thu, 18 Jan 2024 07:00:15 GMT

this sequential number() is working based on OBJECTID, but I need the numbers without using OBJECTID in just sequential manner how my order is on the attribute table?

Re: Adding sequential numbers for the selected features

Bud — Thu, 18 Jan 2024 17:17:43 GMT

What kind of geodatabase?

If it's a mobile or enterprise geodatabase, it could be done in a SQL database view. And then you could join from the FC to the view and use the field calculator to populate the ID field in the FC.

Mobile geodatabase (SQLite):

select
    c.*,
    row_number() over (order by population_2021 desc) as sorted_id
from
    cities c

(File geodatabases don't have a row_number() function.)

If it's a file geodatabase (or any kind of geodatabase), you could use the Sort geoprocessing tool in conjunction with a join.

Like this:

(view in My Videos)

In hindsight, I could have joined on Objectid=OrigFID, instead of using my temp_unique_id field.

ArcGIS Pro 3.2.1

Re: Adding sequential numbers for the selected features

BWetherill — Fri, 16 Jan 2026 18:44:00 GMT

You can create sequentially numbered attribute values in Excel and then copy/paste the whole column of values to the attribute table in Arc Pro.