How can i give unique auto increment id to a line network based on its connectivity

Question

Hi all

How can i give unique auto increment id to a line network based on its connectivity, For example i have to give a unique auto increment id to each feature based on its connectivity which starts from substation. How can i achieve this objective, kindly help

shan_sarkar · Answer

Vikas,

I assume you have the TOWNCODE, ASSETCODE, FEEDERID available in your database?

If it is the case you can use the OBJECTID as the INTEGER field. OBJECTID field will always have auto increment by default.

So in a nutshell the final query can be GISID= [TOWNCODE] &""& [ASSETCODE] &""& [FEEDERID] &""& [OBJECTID]

I hope this helps!

~Shan

XanderBakker · Answer

I still don't understand why you would like to create an ID based on the connectivity when the connectivity is managed in a geometric network (ArcMap) or in a utility network (ArcGIS Pro and the rest of the platform) of the soon to be released ArcGIS Utility Network Management extension.

Is this a requirement of an external system? What kind of questions will you resolve based on this ID or what functional workflows do you have that require this ID?

vikaswardiya · Answer

Sir,

There is a requirement to give a unique ID to each features based on connectivity, and then later also assign a from-id and to-id to that feature, so that each feature could be uniquely identified. its format is- somewhat like this. GISID="towncode"+"assetcode"+"feederid"+"interger(unique autoincrement no.)".