The Attribute Rules in ArcGIS Pro is a tool to set user-defined rules to improve and automate the data editing experience when using geodatabase datasets. In this example we will be working on adding sequential values to your geodatabase. What this process will do is add an ever increasing number in whichever field you choose as you edit and create new features. Using it will increase your data’s integrity and save you time in the process.

First off, assure that the feature you wish to add sequential values to has a Global-ID field in it. If not use the ‘Add Global IDs’ Geoprocessing tool.

 

 

Then you need to create a database sequence. Use the ‘Create Database Sequence’ Geoprocessing tool. Give it a Sequence Name that you will remember. In this case I just went with ‘Test’.

 

 

Finally, right click on the feature in the Contents panel. Go to Design and Attribute Rules.

 

 

Make sure the top option is set to Calculation and hit Add Rule (Add Immediate Calculation Rule).  Give the rule a name, select which field you wish to use, check ‘Insert’ under Triggers, and enter this Python expression below.

 

if(isempty($feature.FID))

return concatenate(“P” + nextsequencevalue(“Test“));

 

Note that in this expression line: if(isempty($feature.FID)) you will want to change ‘FID’ to whatever the field name is you wish to add this to. Likewise, with this line: return concatenate(“P” + nextsequencevalue(“Test”)); the ‘Test’ must be named after the Database Sequence you made earlier. Mine was “Test”. You will also notice that in this line I have “P”  called out first in the Python Concatenate Module. What this will do is add a ‘P’ in front of each new sequence like so;

P1

P2

P3

P4

Feel free to add your own text or digits to go either in front or after your sequence or leave it out all together to have a standard number sequence. It all depends on what your project parameters require.

 

 

Hit Save.

 

Newly created features will now auto edit the next number sequence in your desired field. Please reach out to us if you have additional questions!

Solutions

Frontier Precision has a 30-year plus track record of helping you provide a measure of excellence. It all ladders back to our core philosophy of How You Measure Matters. It’s why each day, we seamlessly connect the physical and digital worlds through technology to improve how we all better interact with the earth in meaningful ways. Our tools and solutions make you more efficient, productive, and most importantly, profitable.

Products

Frontier Precision knows that every measurement its customers take is important. It’s why Frontier Precision not only offers the latest, cutting-edge measurement tools, but also understand the continuing need for service and support — because How You Measure Matters encompasses the total customer experience.

Professional Services

From Geospatial Services to GIS Professional Services to Water Resources Data Acquisition Services, Frontier Precision delivers leading-edge measurement technology. We’ve been there, every centimeter of the way, as geospatial technology has evolved. No matter what your need for accurate measurement, we have the experience and expertise to create a customized solution for you.

 

Training & Events

We give you the proper training on the solutions we sell. Sign up for Professional Certified Training to get up and running quickly — all backed by the most experience in the industry. Whether onsite, online or in the classroom, we are helping make our customers efficient, productive, and profitable with today’ s and tomorrow’s technology.

Support

Frontier Precision provides world-class support from centers across a wide section of the western United States. Need support for any geospacial products, software or services?

Contact Frontier Precision at 800-359-3703.

About Frontier Precision

Frontier Precision’s measure of excellence can be traced back to 1988. Four years later, in 1991, Frontier Precision partnered with Trimble — a United States-based GPS equipment manufacturer at the time, and the rest is history. Since then, Frontier Precision has grown with Trimble to be one their largest and best geospatial distributors in the world.

We’ve been at the frontier of technology for three decades, continually offering customers new tools and solutions, all with our end goal in mind to help make our customers efficient, productive, and profitable with today’s and tomorrow’s technology. Frontier Precision is an employee-owned company — each of our team members is committed to your success.

Contact Frontier Precision

WHEREVER YOU ARE, WE ARE.

From our original office in Bismarck, North Dakota, we’ve grown our footprint thousands of miles in every direction.Today, you’ll also find us in South Dakota, Minnesota, Colorado, Alaska, Montana, Idaho, Hawaii, Wyoming, Oregon and Washington — delivering the Frontier Precision difference to more people each day.