C04 12444726Q0064 Attach 6 TreeDiameterEst.xlsx

This is a tree diameter estimation spreadsheet (Attachment 6) containing field survey data for the Emerald Ash Borer (EAB) insecticide treatment contract on the Allegheny National Forest. The spreadsheet documents two distinct inventory datasets: a Rec Admin (Recreation Administration) 2027 study and an NRS (National Resource Survey) Study 2027, with tree measurements recorded across multiple forest survey plots and recreational sites throughout the ANF.

The Rec Admin dataset identifies 66 individual trees across 10 sites (Buckaloons, Clarion River, Irwin Run Canoe Launch, Kiasutha, Kinzua Beach, Marienville ATV Trailhead, Minister Creek, MRD Office, Red Bridge, and Willow Bay) with a combined diameter breast height (DBH) of 1,388 inches. Tree classifications are distributed by size category: 12 trees in the 6-14 inch range, 22 trees in the 15-20 inch range, and 32 trees exceeding 20 inches. The NRS Study dataset encompasses 517 trees across 27 plots (FAL002 through FAL192 and FAU001 through FAU147) with a combined DBH of 9,145 inches. The NRS inventory shows 97 trees in the 6-14 inch category, 199 trees in the 15-20 inch category, and 221 trees exceeding 20 inches in diameter. Both datasets include precise latitude/longitude coordinates for geographic reference and appear designed to support treatment prioritization and resource allocation decisions for the EAB control initiative on the ANF.