topic Re: Sum Attribute from Stacked/Coincident Lines in ArcGIS in ArcMap Questions

Sum Attribute from Stacked/Coincident Lines in ArcGIS

DanSeidensticker — Fri, 24 Sep 2021 15:13:29 GMT

I have line features of Bus Routes where every route/feature has an attribute with the Number of Buses per Hour. Up to 16 different routes can run down the same street. I want to summarize all the coincident line features into a single line with a sum of the number of buses.

The attached screen capture is an example where there are 8 coincident routes/features in the selection. I want a single feature with the total of HW2_Bus, which would be 21.

I'm looking for a way to do this in ether ArcGIS Desktop or ArcGIS Pro.

Re: Sum Attribute from Stacked/Coincident Lines in ArcGIS

DavidPike — Fri, 24 Sep 2021 15:45:32 GMT

Possibly Dissolve (Data Management)—ArcGIS Pro | Documentation with the field statistics set as 'SUM'

Re: Sum Attribute from Stacked/Coincident Lines in ArcGIS

DanSeidensticker — Fri, 24 Sep 2021 16:43:41 GMT

Thanks for replying. Unfortunately Dissolve does not work because the Sum returns the Bus total of all the line segments, not just where the line segments overlap. It's looking like I need some sort of overlay analysis that will sum in the Z direction. Union or Intersect come to mind, but they don't have a Sum option.

Re: Sum Attribute from Stacked/Coincident Lines in ArcGIS

DavidPike — Fri, 24 Sep 2021 18:53:53 GMT

yes sorry, even the unsplit lines option wouldn't be ideal. How about... Spatial Join (Analysis)—ArcGIS Pro | Documentation Join it to itself, match option of 'identical' and set a 'sum' merge rule of the fields in the field mapping.

Re: Sum Attribute from Stacked/Coincident Lines in ArcGIS

DanSeidensticker — Tue, 28 Sep 2021 16:24:51 GMT

Thanks for pointing me in the right direction. I first did a Feature To Line to break all the routes into segments by intersection. After that, used Spatial Join on itself to calculate the attribute summary (total buses). Then used Delete Identical to delete all the duplicate line work so that there was no overlapping geography.