nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

auto-increment x,y fields with alphanumeric ID

ErinRichmond

I have a shapfile that contains a grid of points and I want to assign each point a unique alphanumeric ID so that latitude is the "alpha" part of the ID and longitude is the "numeric" part of the ID. Can anyone remind me how to do this using the field ArcGIS field calculator? Thanks!

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

ErinRichmond

Hi All - thanks for all the tips. I was able to do what I needed to do by using Excel.

TedKowal

Could you by chance wanting to create a Grid/Gradicule? Sort of a map index?

LukeSturtevant

As Dan asked, we really need to know if you are trying to assign unique id's based on groups. Say if you have 2 polygons in a fishnet and each have a group of points inside each polygon. Would you want the IDs to be something like this:

fishnet polygon 1 point id increment: AA01, AA02... etc.

fishnet polygon 2 point id increment: AB01, AB02...etc

Or are you just looking to assign a unique id for every individual point?

LukeSturtevant

Could you maybe give us a quick screen grab of an excel sheet that has all the fields you have fully populated as you would like to see them? Maybe a completed example like that will give a better idea of what you are shooting for here.

ErinRichmond

That's what I'm trying to figure out, how to assign the alphanumeric values...

DanPatterson_Retired

So how do you assign AA,AB etc and 00, 01 etc? is it based upon a lexicographic sort of the coordinates? is it based on its location in a fishnet? Create Fishnet—Help | ArcGIS for Desktop

ErinRichmond

I all ready have lat/long coordinates calculated and want to keep them as they are in separate fields (no concatenating). I need to then calculate 2 new fields (YID, XID) that just contain the alpha and numeric values that I will then concatenate for the alphanumeric value.

DanPatterson_Retired

This is confusing, if you plan to concatenate, longitude and latitude together, you will have to put the results in a text (string) field

ErinRichmond

I have a 'YID' and 'XID' column in my attribute table. I want those columns to contain the values: AA, AB, AC, etc... and 01-99, respectively. I will then concatenate the YID and XID columns for the unique alpha-numeric ID (ex: AA01). Does that make sense? Thanks for the help!

FreddieGibson

Could you provide an example of what the resulting lat/long would look like?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.