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!
Hi All - thanks for all the tips. I was able to do what I needed to do by using Excel.
Could you by chance wanting to create a Grid/Gradicule? Sort of a map index?
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?
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.
That's what I'm trying to figure out, how to assign the alphanumeric values...
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
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.
This is confusing, if you plan to concatenate, longitude and latitude together, you will have to put the results in a text (string) field
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!
Could you provide an example of what the resulting lat/long would look like?
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
