Sum of polylines within each Fishnet grid

[CeriMiddleton]

Hi,

I need to calculate the total length of paths within each 1km square grid (created with the Fishnet tool). The total length will then be used to rank each grid, depending on the total length distance inside.

I have already used the Intersect tool to ensure the paths do not go through any of the grid borders.

How do I now combine the separate lengths within each grid? See example dataset below. I would like it to show:

Fishnet ID :1

Shape_Length: 378

Thanks,

Ceri

(I am using ArcMap 10.4.1)

[MervynLotter]

Hi Ceri

You need to do a spatial join,joining up your trails to your fishnet layer. Right-click on fishnet layer, Joins and Relates > Joins ... Ensure you select the "Join data from another layer based on spatial location" option, and "Each polygon will be given the numeric attributes of the lines ..." Ensure Sum is checked on. 

If you are in a geodatabase, then just use the Shape_Length field. Otherwise you may need to first calculate feature length of the shapefile segments following your intersect.

[DanPatterson_Retired · Accepted solution]

If you already have the table, aren't you just looking for a way to summarize it?

Summarizing data in a table—Help | ArcGIS Desktop 

[CeriMiddleton]

Thanks Dan, yes this was the best option in the end. Cheers