Model iteration, river length and creating output table

Question

Hi,

I am trying to calculate river network length for a catchment (which is easy!). However, I need to measure the river length for each shape file within the catchment (more than 5000 shape file!) and put it into one dbf. By iterating the model (based on shape file FID) I have managed to measure the river length for each shape file but all of them are creating individual dbf. Is there any option that I can direct all these individual dbf into one dbf.?

Cheers,
Rajib

MohammedHaq · Answer

Hi Rajib,

Can you merge the shapefiles into one large file and then use Summary Stats? You would need to make sure you have a field that identifies the original shapefile in your merged file. Then use that field as the Case field in SumStats.

/Nooski

Thanks Nooski. I have tried to merge but in the model it was not giving me a satisfactory result. However, I have found a slightly better way to do that, by creating empty shape file in file geodatabase and append all into it. It worked as I expected.

Cheers,
Rajib

StefanHaglund1 · Answer

Hi Rajib,

Can you merge the shapefiles into one large file and then use Summary Stats? You would need to make sure you have a field that identifies the original shapefile in your merged file. Then use that field as the Case field in SumStats.

/Nooski