8,659 rows where qSpecies_id = 11 sorted by qCaretaker_id descending

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id ▲ qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
49983 110536 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100X ASHBURY ST 4 Sidewalk: Curb side : Cutout Tree City College 20 Private 05/29/2015 02:12:00 PM 3 3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
24613 6699 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1795X Evans Ave 15 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
25279 6695 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1795X Evans Ave 11 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
35988 17646 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 650X Phelps St 1 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     9 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
38193 6703 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1795X Evans Ave 18 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
54027 86813 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 700X Phelps St 8 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     3 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
55826 86803 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 650X Phelps St 12 Sidewalk: Curb side : Cutout Tree Purchasing Dept 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 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 650X Phelps St 14 Sidewalk: Curb side : Cutout Tree Purchasing Dept 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
57188 28729 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1795X Evans Ave 20 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
72377 17649 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 650X Phelps St 4 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
72416 29816 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1695X Evans Ave 13 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
75374 29812 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1695X Evans Ave 9 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
79754 86812 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 700X Phelps St 7 Sidewalk: Curb side : Cutout Tree Purchasing Dept 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 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1795X Evans Ave 5 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     6 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
81581 17650 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 650X Phelps St 5 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     10 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
103418 17640 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 600X Phelps St 1 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 2x2   6015304.738625 2098066.4602575 37.7417507208067 -122.38966824015 (37.7417507208067, -122.38966824015) 10 3 8 58 1
110822 17654 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 650X Phelps St 9 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
111628 29815 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1695X Evans Ave 12 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
122158 17651 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 650X Phelps St 6 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
123510 29813 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1695X Evans Ave 10 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
126907 6688 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1795X Evans Ave 4 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
132652 17653 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 650X Phelps St 8 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     3 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
137825 28730 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1795X Evans Ave 21 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
149229 6690 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1795X Evans Ave 6 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
152792 6700 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1795X Evans Ave 16 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
157248 6697 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1795X Evans Ave 13 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 3X3   6014623.8379379 2099253.7018787 37.7449728593106 -122.392105596748 (37.7449728593106, -122.392105596748) 10 3 8 58 1
160133 29811 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1695X Evans Ave 8 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
161509 86815 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 710X Phelps St 2 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     3 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
162032 6694 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1795X Evans Ave 10 Sidewalk: Curb side : Cutout Tree Purchasing Dept 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 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 700X Phelps St 3 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     9 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992) 10 3 8 58 1
171929 17637 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 420X Phelps St 7 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     3 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.388649846738 (37.7428823403387, -122.388649846738) 10 3 8 58 1
173791 17655 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 650X Phelps St 10 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
179312 86811 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 700X Phelps St 6 Sidewalk: Curb side : Cutout Tree Purchasing Dept 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 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 710X Phelps St 1 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     3 2x2   6015125.852778 2097818.007348 37.7410585994074 -122.390269419031 (37.7410585994074, -122.390269419031) 10 3 8 58 1
180373 86804 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 650X Phelps St 13 Sidewalk: Curb side : Cutout Tree Purchasing Dept 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
190140 17652 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 650X Phelps St 7 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18     12 2x2   6015137.8127243 2097842.4274144 37.7411263152677 -122.390229771214 (37.7411263152677, -122.390229771214) 10 3 8 58 1
10223 7769 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 490X Franklin St 1 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006335.7213615 2111871.61132 37.7791550246023 -122.421660473625 (37.7791550246023, -122.421660473625) 7 9 11 28852 10
52534 7773 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 490X Franklin St 5 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006335.7213615 2111871.61132 37.7791550246023 -122.421660473625 (37.7791550246023, -122.421660473625) 7 9 11 28852 10
63035 7774 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 490X Franklin St 6 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006335.7213615 2111871.61132 37.7791550246023 -122.421660473625 (37.7791550246023, -122.421660473625) 7 9 11 28852 10
93928 7776 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 490X Franklin St 8 Sidewalk: Curb side : Cutout Tree War Memorial 17   04/16/1990 12:00:00 AM 6 3X3   6006335.7213615 2111871.61132 37.7791550246023 -122.421660473625 (37.7791550246023, -122.421660473625) 7 9 11 28852 10
141249 7777 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 490X Franklin St 9 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006335.7213615 2111871.61132 37.7791550246023 -122.421660473625 (37.7791550246023, -122.421660473625) 7 9 11 28852 10
145620 7771 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 490X Franklin St 3 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006335.7213615 2111871.61132 37.7791550246023 -122.421660473625 (37.7791550246023, -122.421660473625) 7 9 11 28852 10
177792 7775 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 490X Franklin St 7 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006335.7213615 2111871.61132 37.7791550246023 -122.421660473625 (37.7791550246023, -122.421660473625) 7 9 11 28852 10
178470 7770 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 490X Franklin St 2 Sidewalk: Curb side : Cutout Tree War Memorial 17     12 3X3   6006335.7213615 2111871.61132 37.7791550246023 -122.421660473625 (37.7791550246023, -122.421660473625) 7 9 11 28852 10
28370 29458 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1809X Ingalls St 4 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3X3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
42315 29508 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1850X Ingalls St 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 3 3x3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
64162 29457 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1809X Ingalls St 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3x3   6016492.91829 2092912.51025 37.7276648199576 -122.38520083393 (37.7276648199576, -122.38520083393) 10 3 8 58 1
64865 29451 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1829X Ingalls St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3X3   6016488.0524002 2092900.9411781 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755) 10 3 8 58 1
67214 29455 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1809X Ingalls St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3X3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
86267 29509 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1850X Ingalls St 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3x3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
94432 29453 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1829X Ingalls St 3 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3X3   6016488.0524002 2092900.9411781 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755) 10 3 8 58 1
120363 29456 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1809X Ingalls St 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/27/2008 12:00:00 AM 3 3X3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
124059 29454 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1829X Ingalls St 4 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 8 3X3   6016488.0524002 2092900.9411781 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755) 10 3 8 58 1
150090 29507 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1850X Ingalls St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 16 3x3   6016520.1701445 2092944.0657869 37.7277529727716 -122.385108820711 (37.7277529727716, -122.385108820711) 10 3 8 58 1
170395 29452 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1829X Ingalls St 2 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/28/2006 12:00:00 AM 12 3X3   6016488.0524002 2092900.9411781 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755) 10 3 8 58 1
59327 112509 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 699x WILLOW ST 1 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW     2x2   6004423 2113018 37.7821946822097 -122.42835909049 (37.7821946822097, -122.42835909049) 7 9 11 29490 41
79151 112511 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 699x WILLOW ST 3 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW 08/08/2015 03:37:00 PM 3 2x2   6004423 2113018 37.7821946822097 -122.42835909049 (37.7821946822097, -122.42835909049) 7 9 11 29490 41
85966 112510 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 699x WILLOW ST 2 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW     2x2   6004423 2113018 37.7821946822097 -122.42835909049 (37.7821946822097, -122.42835909049) 7 9 11 29490 41
10068 49666 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000245.17413 2120665.11682 37.8029543681198 -122.443361894237 (37.8029543681198, -122.443361894237) 13 9 1 57 17
15243 98997 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
16686 99005 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
31418 110533 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 100X ASHBURY ST 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
36748 246841 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 3 : Tree DPW for City Agency 14     14 Width 3ft   6001195.01805 2109899.62825 37.7734492368388 -122.439302846449 (37.7734492368388, -122.439302846449) 15 5 11 29492 10
38877 101808 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3149 26th St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   02/03/2015 12:00:00 AM 3 3x3   6008718.2 2100791.7 37.7488661984732 -122.412634998086 (37.7488661984732, -122.412634998086) 2 4 7 28859 19
41067 113874 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 11 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
42721 49663 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 7   Permit Number 46510 6000228.83335 2120782.17575 37.8032748487093 -122.443426854966 (37.8032748487093, -122.443426854966) 13 9 1 57 17
45985 99003 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
51749 49665 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000243.34961 2120687.49551 37.8030157099616 -122.443369816371 (37.8030157099616, -122.443369816371) 13 9 1 57 17
54557 246846 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 8 : Tree DPW for City Agency 14     14 Width 3ft   6001207.38463 2109809.38993 37.7732021687661 -122.439253599591 (37.7732021687661, -122.439253599591) 15 5 11 29492 10
55624 246843 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 5 : Tree DPW for City Agency 14     9 Width 3ft   6001198.91277 2109877.26909 37.7733880658265 -122.439287771129 (37.7733880658265, -122.439287771129) 15 5 11 29492 10
65235 113871 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
68320 137118 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2150 North Point St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   01/20/2015 12:00:00 AM 0 Width 4ft Permit Number 771149 6000490.48443 2120659.70119 37.8029534840902 -122.442512606897 (37.8029534840902, -122.442512606897) 13 9 1 57 17
75069 47415 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   05/14/2002 12:00:00 AM 9   Permit Number 45326 6000240.55787 2120707.38669 37.8030701666099 -122.443380906816 (37.8030701666099, -122.443380906816) 13 9 1 57 17
75284 113868 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
76830 99000 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
76955 99004 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
78158 113866 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
78526 254583 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1439 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 Private 08/02/2016 06:38:00 AM   3x3   6005488 2119883 37.8011044543754 -122.425163298445 (37.8011044543754, -122.425163298445) 13 9 1 57 17
87127 99008 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
94774 99002 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
111013 113867 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
112996 49662 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000225.92137 2120807.31261 37.803343701723 -122.44343873861 (37.803343701723, -122.44343873861) 13 9 1 57 17
117347 49668 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 Private 04/18/2011 12:00:00 AM     Permit Number 46510 6000239.54014865 2120711.44405841 37.8030812490195 -122.443384720262 (37.8030812490195, -122.443384720262) 13 9 1 57 17
117870 113873 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 10 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
127023 251811 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 4 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
127072 246842 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 4 : Tree DPW for City Agency 14     15 Width 4ft   6001208.43411 2109888.06605 37.7734182533891 -122.439255609578 (37.7734182533891, -122.439255609578) 15 5 11 29492 10
137242 49667 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 8   Permit Number 46510 6000232.67943 2120757.93136 37.8032084994456 -122.443411803017 (37.8032084994456, -122.443411803017) 13 9 1 57 17
139078 246847 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 9 : Tree DPW for City Agency 14     9 Width 3ft   6001212.96216 2109784.10249 37.7731330531814 -122.439232493392 (37.7731330531814, -122.439232493392) 15 5 11 29492 10
140109 246844 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 6 : Tree DPW for City Agency 14     17 Width 3ft   6001203.63374 2109838.69012 37.7732824062979 -122.439268674924 (37.7732824062979, -122.439268674924) 15 5 11 29492 10
141911 98998 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
144228 251810 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 3 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
147322 113872 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
149567 13091 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1439X Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   08/02/2016 06:38:00 AM 3 4x5   6005488.54173 2119878.23932 37.8010914133698 -122.425161084884 (37.8010914133698, -122.425161084884) 13 9 1 57 17
152225 129875 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2051 Beach St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   01/20/2015 12:00:00 AM 3 Width 4ft Permit Number 771149 6000472.54237 2120960.44245 37.8037782163629 -122.442596301384 (37.8037782163629, -122.442596301384) 13 9 1 57 17
152727 99006 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
153582 246840 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 2 : Tree DPW for City Agency 14     19 Width 3ft   6001188.51269 2109936.21842 37.7735493340682 -122.43932797262 (37.7735493340682, -122.43932797262) 15 5 11 29492 10
158133 246849 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 11 : Tree DPW for City Agency 14     9 Width 3ft   6001216.86576 2109748.14467 37.7730345441487 -122.439216412614 (37.7730345441487, -122.439216412614) 15 5 11 29492 10
158369 113869 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
161524 99001 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
168582 251809 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 2 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);