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; } } }

Arcpy - ID generator using a Grid format

SeanPhayakapong2

Would it be possible to create an ID generator with a grid system overlayed. For example, I have a point and I want the ID to be concatenated from the grid's row/column and a unique ID. For example if the point lands on grid the grid 30(column) and 23 (row) with it being the second point created in that box then the ID should look like this: 302302 being CCRRID. I am using 10.2.2 ArcMap.

Najděte více příspěvků označených jako

Accepted answers

All comments

DanPatterson_Retired

line 27, indent by 4 spaces

Code = FC + Col + Row + Fno

If the above aren't all text or numbers you would be advised to

Code <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}{}{}{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>FC<SPAN class="punctuation token">,</SPAN> Col<SPAN class="punctuation token">,</SPAN> Row<SPAN class="punctuation token">,</SPAN> Fno<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

and Code will obviously going into a text field.

SeanPhayakapong2

Great, thank you, I will look more into the fishnet. I think at that point it wont matter if its in order or not as long as its all within each cell.

DanPatterson_Retired

assigning row and columns to the 'fishnet' shouldn't be a problem and the number of the points if done in sequential order, isn't a problem either, if they are added out of order then that will require a manual entry of that value. Concatenation isn't a problem either.

SeanPhayakapong2

This is primarily used for manholes, but here is the basic schematic that my employers want.

Example:

Example

The highlighted point is the tenth manhole (fc = 60) that was added in the 8th column (08) and the 22nd row (22) giving an ID by our standard of 600822010.

There will be about a 35x35 grid. For how many times would be as many times new data is added. So far I just coded an ID generator without any new relationship to the grid.

XanderBakker

In addition to the questions that Dan asked, if you have 30 * 23 grid cells, you will have 690 possibilities. If the ID must be unique I guess you would have to use 3 positions for the ID. If the points already have information about the grid cells (row and column) you can concatenate and create the CCRRID. If you have polygons to represent the grid cells with info on row and column, you can create the CCRRID there and convert the centre points to a point featureclass. To clear up all the doubts, it would be best to attach the data too.

DanPatterson_Retired

how many rows and columns?

how many times do you have to do this?

wouldn't joining the grid to the points suffice for the first part, then you could modify/calculate a supplemental key after?

What have you tried so far? This would take some coding and/or geoprocessing steps but what you have tried would go a long way

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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