Hi,
I've a table [tbl_STEM INVENTORY] with three fields ([STEM ID], [DISTANCE], and [BEARING]) that I'd like to reduce into a single matrix. STEM ID is the primary key, DISTANCE is the linear distance from the center of a circular plot to the tree, and BEARING is the compass bearing from the center of the plot to the tree.
First off, the table is relatively large (i.e. 300 trees), and I'm not sure about the number of columns Access can handle. But what I'd like to do is export a diagonal matrix in which the intersection is the distance from each tree to every other. I'd like the intersection to be based on an expression of the cosine rule (a^2=b^2+c^2-2bcCosA), in which (a) is the distance between the two trees, (b) is the distance to tree #1, (c) is the distance to tree #2, and (A) is the difference in compass bearings.
Thanks for any and all help.
Greg
I've a table [tbl_STEM INVENTORY] with three fields ([STEM ID], [DISTANCE], and [BEARING]) that I'd like to reduce into a single matrix. STEM ID is the primary key, DISTANCE is the linear distance from the center of a circular plot to the tree, and BEARING is the compass bearing from the center of the plot to the tree.
First off, the table is relatively large (i.e. 300 trees), and I'm not sure about the number of columns Access can handle. But what I'd like to do is export a diagonal matrix in which the intersection is the distance from each tree to every other. I'd like the intersection to be based on an expression of the cosine rule (a^2=b^2+c^2-2bcCosA), in which (a) is the distance between the two trees, (b) is the distance to tree #1, (c) is the distance to tree #2, and (A) is the difference in compass bearings.
Thanks for any and all help.
Greg