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

455
6
11-26-2017 09:19 PM
vikaswardiya
New Contributor II

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

 

Polygon is a substation whereas LIne layers are different electrical lines

0 Kudos
6 Replies
DanPatterson_Retired
MVP Esteemed Contributor

is this related to your other question?

Do you have the Network Analyst Extension?

0 Kudos
vikaswardiya
New Contributor II

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

0 Kudos
XanderBakker
Esri Esteemed Contributor

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

0 Kudos
vikaswardiya
New Contributor II

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

0 Kudos
XanderBakker
Esri Esteemed Contributor

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?

0 Kudos
shan_sarkar
Regular Contributor

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


~Shan