topic Generating unique feature IDs using a grid in Data Management Questions https://community.esri.com/t5/data-management-questions/generating-unique-feature-ids-using-a-grid/m-p/311678#M17803 <HTML><HEAD></HEAD><BODY><P>Hello, I'm trying to generate unique IDs for building footprints.&nbsp;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).</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Any ideas on how I can achieve that?</P></BODY></HTML> Mon, 18 Mar 2019 10:37:41 GMT AdminKigoma 2019-03-18T10:37:41Z Generating unique feature IDs using a grid https://community.esri.com/t5/data-management-questions/generating-unique-feature-ids-using-a-grid/m-p/311678#M17803 <HTML><HEAD></HEAD><BODY><P>Hello, I'm trying to generate unique IDs for building footprints.&nbsp;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).</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Any ideas on how I can achieve that?</P></BODY></HTML> Mon, 18 Mar 2019 10:37:41 GMT https://community.esri.com/t5/data-management-questions/generating-unique-feature-ids-using-a-grid/m-p/311678#M17803 AdminKigoma 2019-03-18T10:37:41Z Re: Generating unique feature IDs using a grid https://community.esri.com/t5/data-management-questions/generating-unique-feature-ids-using-a-grid/m-p/311679#M17804 <HTML><HEAD></HEAD><BODY><P>An update: I think the Generate ID by Intersect tool in the Attribute Assistant add on is what I need, but I'm having a hard time understanding how I need to fill the configuration tables (DynamicValue and GenerateId). Any direction that anyone can offer is much appreciated.</P></BODY></HTML> Wed, 20 Mar 2019 14:05:37 GMT https://community.esri.com/t5/data-management-questions/generating-unique-feature-ids-using-a-grid/m-p/311679#M17804 AdminKigoma 2019-03-20T14:05:37Z