Arbor Preserve Tree Destruction List

	A	B	C	D
1	UPDATE:
2	This is the file with all the data from the Arbor Preserve proposed final site plan (2025-02-04) digitized into spreadsheet format, see different tabs for various cuts of it. The whole data set is in the last tab (the one marked "Data (cleaned up)")
3
4	Total trees (North and South) documented 5679
5	Proposed Destroy: 3285 (58% of them!)
6
7	Landmark total 657 * ( there are actually more, they missed documenting at least 33 as Landmark)
8	Proposed destroy 325 (half of them!)
9
10	Number with Bat homes 100 total
11	Proposed destroy 52 (over half of them!)
12
13
14	Notes about the pages submitted in the Arbor Preserve plan:
15	* North data has a column repeated
16	* North "Summary of Landmark Trees" is completely wrong (maybe old data?)
17	* South "Summary of Landmark Trees" is completely wrong (maybe old data?). This one is especially troubling since their summary makes it look like they are destroying only 10 landmark trees in the south, when actually their plan is to destroy 254 landmark trees in the south! (Their north summary looks like 28 landmark trees to be destroyed when it's actually 71)
18	* South data has a column repeated
19	* South data also has a number (8 or so?) of individual tree records with repeated tag numbers (sometimes complete duplicate records, sometimes completely different trees)
20	* South data pages are in the wrong order
21	* Their definition of Landmark is missing some required by Lodi Twp ordinance. Smaller Ironwoods, for example, should be classified as Landmark and aren't. Missing at least 27 landmark trees due to this. Also some slower growing species within genuses of Maple, Oak, Hickory should probably be reclassified in Lodi Twp ordiance: like Burr Oak and Chinquapin Oak, Red Maple and Pignut Hickory. For example they plan to destroy a Burr Oak over 70 years old and are not denoting it as Landmark, but since our ordinance currently allows that designation those are not included below.
22	Ironwood (8")	5
23	Crabapple/ Common Apple (malus sp) (12")	2
24	Pear (12")	1
25	Eastern Red Cedar (12") (missing the ones 12-14")	13
26	Quaking Aspen (12") (missing the ones 12-14")	6	27	TOTAL
27	* The numbers of trees is actually higher than these counted by row because they group some into one line item at times, which I believe the Zoning Ordinance allows. 334 rows actually contain up to 6 trees, often several landmark, in the same row :	row actually contains	already counted	Meaning MISSING numbers are:
28	263 rows have 2 trees	526	263	263
29	49 rows have 3 trees	147	49	98
30	16 rows have 4 trees	64	16	48
31	5 rows have 5 trees	25	5	20
32	1 row has 6 trees	6	1	5
33				434
34	72 rows have landmark trees with extra numbers embedded
35	33 of those are slated to be destoyed - meaning 2 - 6 times that number ADDITIONAL destroyed landmark trees (as an estimate 4x72 is 288 ADDITIONAL Landmark trees documented, with 4x33 is 132 ADDITIONAL Landmark trees being destroyed)
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100