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

[vikaswardiya]

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

[DanPatterson_Retired]

is this related to your other question?

Do you have the Network Analyst Extension?

[vikaswardiya]

yes sir, it is the same question, and yes i have network Analyst Extension

[XanderBakker]

Just wondering, why do you need to generate the ID this way? What are you going to do with it?

[vikaswardiya]

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.)".

[XanderBakker]

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?

[shan_sarkar]

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