topic Re: Joining Zonal Statististics to feature in Geoprocessing Questions

Joining Zonal Statististics to feature

JontyKnox — Fri, 21 Oct 2011 14:59:55 GMT

Hi there,

So I have a DEM and a line .shp file. What I want to do is obtain the mean elevation for each line segment. Relatively simple, I just used the Zonal Statistics as table tool.

However I run into a problem when I try and join these average elevation values back to the original line data. There are no spatial coordinates in the table so I can't so a spatial join and when I conduct a normal Join, the Zonal Statistics Table has not maintained the original FID values from the line .shp file.

Any ideas on how I can solve this one?

Thanks,
- Jonty

Re: Joining Zonal Statististics to feature

DanLee — Fri, 21 Oct 2011 16:30:23 GMT

If you use your line features as the input features and the FID as the Zone Field, the output table should have the FID field. You should be able to use the FID field as the Join Field to link back to your lines.

If you use a different field as the Zone Field, then you still should use that field as the Join Field to link the two tables; remember that the Stats are not based on the FID in this case.

Does that make sense?

Re: Joining Zonal Statististics to feature

JontyKnox — Fri, 28 Oct 2011 20:10:52 GMT

Hey Dan,

That made sense, thanks for the help. It worked out well in the end.

Cheers,

Jonty

Re: Joining Zonal Statististics to feature

DanLee — Fri, 28 Oct 2011 20:17:29 GMT

Hi Jonty,

You are welcome. Thank you for letting me know. I am glad it worked for you.

cheers! 🙂