AnsweredAssumed Answered

Generating unique feature IDs using a grid

Question asked by MariaLugaKigoma on Mar 18, 2019
Latest reply on Mar 20, 2019 by MariaLugaKigoma

Hello, I'm trying to generate unique IDs for building footprints. I want them to be begin with the Unique ID of the grid cell in which they are located. But I don't want the number to be very long (the building shapefile has over 1 million features).

 

For example, I want the 3 buildings in Grid Cell F1A2 to be labeled F1A2001, F1A2002, F1A2003...and the 4 buildings in Grid Cell F1A3 to be labeled F1A3001, F1A3002, F1A3003, F1A3004.

 

So far, I've created the grid with a unique ID for each cell, and I've spatially joined this to the building footprint, so each building has an associated grid cell name. I'm stuck on how how to autocalculate a field with numbers that reset each time the Grid Cell ID changes.

 

Any ideas on how I can achieve that?

Outcomes