trees

Custom SQL query returning 85 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
11205 17641 7 145 600X Phelps St 2 Sidewalk: Curb side : Cutout Tree 18     10 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
19804 29809 7 19 1695X Evans Ave 6 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
19975 29822 7 19 1695X Evans Ave 20 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
24613 6699 7 11 1795X Evans Ave 15 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
24791 29820 7 19 1695X Evans Ave 18 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
25279 6695 7 11 1795X Evans Ave 11 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
26979 29831 7 19 1695X Evans Ave 29 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
29038 86623 1 128 950 Bryant St 1 Sidewalk: Curb side : Cutout Tree 18   04/13/2007 12:00:00 AM 3 3x3   6010870.62173 2109748.7492 37.7735808121462 -122.405822739627 (37.7735808121462, -122.405822739627) 14 2 9 28853 34
31612 29821 7 19 1695X Evans Ave 19 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
35348 17631 7 145 420X Phelps St 1 Sidewalk: Curb side : Cutout Tree 18   11/15/1992 12:00:00 AM 6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
35988 17646 7 11 650X Phelps St 1 Sidewalk: Curb side : Cutout Tree 18     9 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
38193 6703 7 11 1795X Evans Ave 18 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
38581 29817 7 49 1695X Evans Ave 14 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
41584 29827 7 19 1695X Evans Ave 25 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
41932 29823 7 19 1695X Evans Ave 21 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
43501 17638 7 145 420X Phelps St 8 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
48269 29808 7 19 1695X Evans Ave 5 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
54027 86813 7 11 700X Phelps St 8 Sidewalk: Curb side : Cutout Tree 18     3 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
54518 200335 7 145 750 Phelps St 7 : Tree 18     4 Width 2ft   6015505.4551 2098329.2709 37.7424834725483 -122.388992567847 (37.7424834725483, -122.388992567847) 10 3 8 58 1
55826 86803 7 11 650X Phelps St 12 Sidewalk: Curb side : Cutout Tree 18   10/01/2007 12:00:00 AM 3 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
55872 86805 7 11 650X Phelps St 14 Sidewalk: Curb side : Cutout Tree 18   10/01/2007 12:00:00 AM 3 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
56423 29810 7 19 1695X Evans Ave 7 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
57188 28729 7 11 1795X Evans Ave 20 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
60255 29807 7 19 1695X Evans Ave 4 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
68696 86625 1 128 950 Bryant St 3 Sidewalk: Curb side : Cutout Tree 18   04/13/2007 12:00:00 AM 3 3x3   6010895.2675 2109773.10415 37.7736490634866 -122.405739201611 (37.7736490634866, -122.405739201611) 14 2 9 28853 34
71834 17642 7 145 600X Phelps St 3 Sidewalk: Curb side : Cutout Tree 18     6 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
72377 17649 7 11 650X Phelps St 4 Sidewalk: Curb side : Cutout Tree 18     12 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
72416 29816 7 11 1695X Evans Ave 13 Sidewalk: Curb side : Cutout Tree 18     12 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
74365 17636 7 145 420X Phelps St 6 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
75159 86806 7 145 700X Phelps St 1 Sidewalk: Curb side : Cutout Tree 18     9 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
75374 29812 7 11 1695X Evans Ave 9 Sidewalk: Curb side : Cutout Tree 18     12 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
78700 86807 7 145 700X Phelps St 2 Sidewalk: Curb side : Cutout Tree 18     6 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
78949 29814 7 19 1695X Evans Ave 11 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
79754 86812 7 11 700X Phelps St 7 Sidewalk: Curb side : Cutout Tree 18   10/26/2012 02:00:00 PM 9 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
81099 6689 7 11 1795X Evans Ave 5 Sidewalk: Curb side : Cutout Tree 18     6 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
81581 17650 7 11 650X Phelps St 5 Sidewalk: Curb side : Cutout Tree 18     10 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
84528 17645 7 145 600X Phelps St 6 Sidewalk: Curb side : Cutout Tree 18     10 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
89345 17639 7 145 420X Phelps St 9 Sidewalk: Curb side : Cutout Tree 18     6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
94190 6693 7 19 1795X Evans Ave 9 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
103418 17640 7 11 600X Phelps St 1 Sidewalk: Curb side : Cutout Tree 18     12 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
105906 29804 7 19 1695X Evans Ave 1 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
108380 17634 7 145 420X Phelps St 4 Sidewalk: Curb side : Cutout Tree 18     6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
110210 86626 1 128 950 Bryant St 4 Sidewalk: Curb side : Cutout Tree 18   04/13/2007 12:00:00 AM 3 3x3   6010925.67942 2109801.58517 37.7737289664413 -122.405636007996 (37.7737289664413, -122.405636007996) 14 2 9 28853 34
110822 17654 7 11 650X Phelps St 9 Sidewalk: Curb side : Cutout Tree 18     12 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
111628 29815 7 11 1695X Evans Ave 12 Sidewalk: Curb side : Cutout Tree 18     12 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
113550 29819 7 19 1695X Evans Ave 17 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
116439 17643 7 145 600X Phelps St 4 Sidewalk: Curb side : Cutout Tree 18     8 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
122158 17651 7 11 650X Phelps St 6 Sidewalk: Curb side : Cutout Tree 18     12 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
123510 29813 7 11 1695X Evans Ave 10 Sidewalk: Curb side : Cutout Tree 18     12 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
124098 29825 7 19 1695X Evans Ave 23 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
126907 6688 7 11 1795X Evans Ave 4 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
128702 29830 7 19 1695X Evans Ave 28 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
132652 17653 7 11 650X Phelps St 8 Sidewalk: Curb side : Cutout Tree 18     3 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
132986 200334 7 145 750 Phelps St 4 : Tree 18   11/15/1992 12:00:00 AM 8 Width 3ft   6015528.91481 2098358.82009 37.7425659089002 -122.388913512973 (37.7425659089002, -122.388913512973) 10 3 8 58 1
135378 29826 7 19 1695X Evans Ave 24 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
137825 28730 7 11 1795X Evans Ave 21 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
142707 6696 7 19 1795X Evans Ave 12 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
143601 29833 7 19 1695X Evans Ave 31 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
145278 6687 7 19 1795X Evans Ave 3 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
148712 29832 7 19 1695X Evans Ave 30 Sidewalk: Curb side : Cutout Tree 18   10/28/2011 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
149229 6690 7 11 1795X Evans Ave 6 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
150774 29818 7 19 1695X Evans Ave 16 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
151268 17647 7 145 650X Phelps St 2 Sidewalk: Curb side : Cutout Tree 18     6 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
152792 6700 7 11 1795X Evans Ave 16 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
157248 6697 7 11 1795X Evans Ave 13 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
160133 29811 7 11 1695X Evans Ave 8 Sidewalk: Curb side : Cutout Tree 18     12 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
161509 86815 7 11 710X Phelps St 2 Sidewalk: Curb side : Cutout Tree 18     3 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
162032 6694 7 11 1795X Evans Ave 10 Sidewalk: Curb side : Cutout Tree 18   11/01/1989 12:00:00 AM 12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
164193 86808 7 11 700X Phelps St 3 Sidewalk: Curb side : Cutout Tree 18     9 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
169099 29805 7 19 1695X Evans Ave 2 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
171929 17637 7 11 420X Phelps St 7 Sidewalk: Curb side : Cutout Tree 18     3 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
173791 17655 7 11 650X Phelps St 10 Sidewalk: Curb side : Cutout Tree 18     12 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
174113 29824 7 19 1695X Evans Ave 22 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
176808 86624 1 128 950 Bryant St 2 Sidewalk: Curb side : Cutout Tree 18   04/13/2007 12:00:00 AM 3 3x3   6010883.02334 2109759.81343 37.7736118855124 -122.405780619884 (37.7736118855124, -122.405780619884) 14 2 9 28853 34
179312 86811 7 11 700X Phelps St 6 Sidewalk: Curb side : Cutout Tree 18   10/26/2012 02:00:00 PM 9 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
179513 86814 7 11 710X Phelps St 1 Sidewalk: Curb side : Cutout Tree 18     3 2x2   6015125.852778 2097818.007348 37.7410585994074 -122.390269419031 (37.7410585994074, -122.390269419031) 10 3 8 58 1
180373 86804 7 11 650X Phelps St 13 Sidewalk: Curb side : Cutout Tree 18   10/01/2007 12:00:00 AM 3 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
186185 29829 7 19 1695X Evans Ave 27 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
187024 6698 7 19 1795X Evans Ave 14 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
187221 6691 7 19 1795X Evans Ave 7 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
187488 29806 7 19 1695X Evans Ave 3 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
190140 17652 7 11 650X Phelps St 7 Sidewalk: Curb side : Cutout Tree 18     12 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
191015 17644 7 145 600X Phelps St 5 Sidewalk: Curb side : Cutout Tree 18     8 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
191457 29828 7 19 1695X Evans Ave 26 Sidewalk: Curb side : Cutout Tree 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
194098 17635 7 145 420X Phelps St 5 Sidewalk: Curb side : Cutout Tree 18     12 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1