topic joining junctions with information on the connecting edges in ArcGIS Network Analyst Questions https://community.esri.com/t5/arcgis-network-analyst-questions/joining-junctions-with-information-on-the/m-p/572882#M5507 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I need to find several things about my junctions and add that info as columns in the junctions table.</SPAN><BR /><BR /><SPAN>One of them is the number of edges a junction connects to. From reading around I figured that there is a way to query the network dataset about that information but only programatically. Is that correct? In this case, I can work around this by doing a spatial join between my junctions and my edges and I get a count column which is what I want.</SPAN><BR /><BR /><SPAN>The other thing is more problematic. I would like to have information about the class of edges a junction is connected to. Class is a column in my edges table. The only way to do this I can think would be to encode my classes as powers of 10 (residential = 1, secondary=10, major = 100, motorway = 1000, ...) and do a sum in the join so that if a junction connects to two secondary and a residential it would return 21 and I can also work the thing backwards (since there is a maximum of 8 edges connected to a junction).</SPAN><BR /><SPAN>Is there a simpler way of doing this?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>Guillaume</SPAN></BODY></HTML> Thu, 16 Feb 2012 17:38:50 GMT GuillaumeBarreau 2012-02-16T17:38:50Z joining junctions with information on the connecting edges https://community.esri.com/t5/arcgis-network-analyst-questions/joining-junctions-with-information-on-the/m-p/572882#M5507 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I need to find several things about my junctions and add that info as columns in the junctions table.</SPAN><BR /><BR /><SPAN>One of them is the number of edges a junction connects to. From reading around I figured that there is a way to query the network dataset about that information but only programatically. Is that correct? In this case, I can work around this by doing a spatial join between my junctions and my edges and I get a count column which is what I want.</SPAN><BR /><BR /><SPAN>The other thing is more problematic. I would like to have information about the class of edges a junction is connected to. Class is a column in my edges table. The only way to do this I can think would be to encode my classes as powers of 10 (residential = 1, secondary=10, major = 100, motorway = 1000, ...) and do a sum in the join so that if a junction connects to two secondary and a residential it would return 21 and I can also work the thing backwards (since there is a maximum of 8 edges connected to a junction).</SPAN><BR /><SPAN>Is there a simpler way of doing this?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>Guillaume</SPAN></BODY></HTML> Thu, 16 Feb 2012 17:38:50 GMT https://community.esri.com/t5/arcgis-network-analyst-questions/joining-junctions-with-information-on-the/m-p/572882#M5507 GuillaumeBarreau 2012-02-16T17:38:50Z