1,098 rows where qCaretaker_id = 4 sorted by PermitNotes 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)
191362 97733 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3 Permit Number 50638 6005736.8865 2120695.23683 37.8033487055393 -122.424359846228 (37.8033487055393, -122.424359846228) 5 9 1 28858 32
163795 37830 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451 Athens St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/09/2007 12:00:00 AM 3 6x6 Permit Number 49480 6003635.85955 2090436.92041 37.7201477680848 -122.429471383195 (37.7201477680848, -122.429471383195) 9 7 6 28861 5
181911 37840 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451 Athens St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/09/2007 12:00:00 AM 3 4x6 Permit Number 49480 6003672.4294 2090496.54171 37.7203135455184 -122.429349222898 (37.7203135455184, -122.429349222898) 9 7 6 28861 5
36159 37832 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 19 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2006 12:00:00 AM 3 3x3 Permit Number 48867 6003860.1558 2090386.44981 37.7200218836872 -122.42869247048 (37.7200218836872, -122.42869247048) 9 7 6 28861 5
49903 37828 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2006 12:00:00 AM 8 3x3 Permit Number 48867 6003752 2090699 37.720873955994 -122.429088601305 (37.720873955994, -122.429088601305) 9 7 6 28861 5
77291 98936 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2641 25th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3 Permit Number 48158 6011034 2101686.1 37.7514517258235 -122.404689875871 (37.7514517258235, -122.404689875871) 10 4 8 28859 19
90271 98937 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2641 25th St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3 Permit Number 48158 6011051 2101800 37.7517654203601 -122.404639104893 (37.7517654203601, -122.404639104893) 10 4 8 28859 19
95964 51930 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2641 25th St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/21/2005 12:00:00 AM 10 3x3 Permit Number 48158 6011052.19017876 2101794.26112893 37.7517497291988 -122.404634585115 (37.7517497291988, -122.404634585115) 10 4 8 28859 19
12999 38424 DPW Maintained 1 Morus alba :: White Mulberry 246 1451 Jackson St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/24/2005 12:00:00 AM 12 3x3 Permit Number 48015 6007280.79709 2117415.82487 37.7944313239892 -122.418784361633 (37.7944313239892, -122.418784361633) 5 1 10 28858 32
7113 51366 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014162.99112 2094669.44393 37.7323598375173 -122.393378385216 (37.7323598375173, -122.393378385216) 10 3 8 58 1
8049 51364 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014150.64944 2094610.63008 37.7321976609735 -122.393416939157 (37.7321976609735, -122.393416939157) 10 3 8 58 1
11126 51368 DPW Maintained 1 Celtis sinensis :: Chinese Hackberry 153 50 Pomona St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014172.09212 2094713.43563 37.7324811353964 -122.393349998121 (37.7324811353964, -122.393349998121) 10 3 8 58 1
13398 51356 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014174.8382 2094728.02379 37.7325213440762 -122.393341524701 (37.7325213440762, -122.393341524701) 10 3 8 58 1
14886 51359 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 50 Pomona St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014112.78564 2094416.99761 37.7316638818713 -122.393534297068 (37.7316638818713, -122.393534297068) 10 3 8 58 1
16291 51365 DPW Maintained 1 Celtis sinensis :: Chinese Hackberry 153 50 Pomona St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014154.93455 2094628.60419 37.7322472522973 -122.393403381858 (37.7322472522973, -122.393403381858) 10 3 8 58 1
18431 51369 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014169.21344 2094698.3618 37.7324395857978 -122.39335889599 (37.7324395857978, -122.39335889599) 10 3 8 58 1
45066 51362 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 50 Pomona St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014137.60928 2094535.47761 37.7319905830836 -122.393456764727 (37.7319905830836, -122.393456764727) 10 3 8 58 1
70543 51357 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 50 Pomona St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014147.24137 2094593.61459 37.732150750552 -122.393427531355 (37.732150750552, -122.393427531355) 10 3 8 58 1
80368 51358 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 50 Pomona St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014110.4538 2094404.71931 37.7316300385939 -122.393541499766 (37.7316300385939, -122.393541499766) 10 3 8 58 1
153668 51360 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 50 Pomona St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014114.6767 2094431.72556 37.7317044268964 -122.39352878962 (37.7317044268964, -122.39352878962) 10 3 8 58 1
174301 51361 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 50 Pomona St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014122.20154 2094470.50183 37.7318113167403 -122.393505487305 (37.7318113167403, -122.393505487305) 10 3 8 58 1
176902 51363 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014143.51923 2094573.18836 37.7320944574823 -122.393438970749 (37.7320944574823, -122.393438970749) 10 3 8 58 1
70173 66890 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/07/2005 12:00:00 AM 6 3x3 Permit Number 45482 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
35455 47256 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
72589 47255 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
38966 47201 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801X Clement St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/2002 12:00:00 AM 8 3x3 Permit Number 45157 5986666.18051 2113215.92346 37.7817173456419 -122.489803447111 (37.7817173456419, -122.489803447111) 11 6 2 55 26
75748 47199 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 30th Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/2002 12:00:00 AM 8 4x4 Permit Number 45157 5986584.12235 2112732.41489 37.7803849777225 -122.490051751347 (37.7803849777225, -122.490051751347) 11 6 2 55 26
117506 47203 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801X Clement St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/2002 12:00:00 AM 10 3x3 Permit Number 45157 5986727.74959 2113216.77029 37.7817232655044 -122.489590512271 (37.7817232655044, -122.489590512271) 11 6 2 55 26
136473 47200 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801X Clement St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/2002 12:00:00 AM 6 3x3 Permit Number 45157 5986636.79042 2113215.6243 37.7817148081587 -122.489905099586 (37.7817148081587, -122.489905099586) 11 6 2 55 26
178939 47202 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801X Clement St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/2002 12:00:00 AM 12 3x3 Permit Number 45157 5986698.68199 2113217.08014 37.7817224192006 -122.489691093913 (37.7817224192006, -122.489691093913) 11 6 2 55 26
188665 47198 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 30th Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/2002 12:00:00 AM 8 4x4 Permit Number 45157 5986584.00139 2112756.95832 37.7804523599117 -122.490053975567 (37.7804523599117, -122.490053975567) 11 6 2 55 26
49136 42633 DPW Maintained 1 Tristania conferta :: 61 1651 Union St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2016 02:56:00 PM 3 5x5 Permit Number 45045 6005048.16251 2118816.23898 37.7981505449739 -122.426609321383 (37.7981505449739, -122.426609321383) 13 9 1 57 17
99986 42634 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2016 02:52:00 PM 3 5x5 Permit Number 45045 6005069.31611 2118819.49736 37.7981606875253 -122.426536355794 (37.7981606875253, -122.426536355794) 13 9 1 57 17
5610 46958 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 7 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
58717 46964 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
59100 46948 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 3 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
63621 46967 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 5 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
70695 46953 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 6 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
72358 46950 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
75380 46955 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 4 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
78188 46960 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
79799 46957 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
81039 46962 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 6 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
97962 46965 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
104330 46952 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
155449 46966 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
157174 46961 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 7 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
162635 46949 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 5 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
167652 46951 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
68939 43903 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1050 York St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4   04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.7552328939148 -122.408509176777 (37.7552328939148, -122.408509176777) 2 4 7 28859 19
109017 43904 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1050 York St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.7552328939148 -122.408509176777 (37.7552328939148, -122.408509176777) 2 4 7 28859 19
193697 43905 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1050 York St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.7552328939148 -122.408509176777 (37.7552328939148, -122.408509176777) 2 4 7 28859 19
61919 43305 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/12/2000 12:00:00 AM 6   Permit Number 43072 6011285.67007 2105193.27319 37.7610957103087 -122.4040663601 (37.7610957103087, -122.4040663601) 10 3 8 28856 29
114573 43306 DPW Maintained 1 Prunus caroliniana :: Carolina Cherry Laurel 315 693 Vermont St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/12/2000 12:00:00 AM 22   Permit Number 43072 6011289.47877 2105149.93268 37.7609769197604 -122.404050137204 (37.7609769197604, -122.404050137204) 10 3 8 28856 29
165196 43304 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 693 Vermont St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/12/2000 12:00:00 AM 19   Permit Number 43072 6011287.96925 2105166.37556 37.7610219838923 -122.404056515205 (37.7610219838923, -122.404056515205) 10 3 8 28856 29
136087 30737 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 60 490X Page St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/05/2000 12:00:00 AM 4 3x3 Permit Number 42884 6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
26495 42983 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2X Yale St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/16/2000 12:00:00 AM 4 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
54545 42985 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/16/2000 12:00:00 AM 12 9x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
103561 42990 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/05/2000 12:00:00 AM 10 5x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
110301 42989 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/05/2000 12:00:00 AM 10 5x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
120765 42988 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/16/2000 12:00:00 AM 10 4x5 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
132081 42984 DPW Maintained 1 Tree(s) :: 17 2X Yale St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/05/2000 12:00:00 AM 4 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
175839 42987 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 2X Yale St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/16/2000 12:00:00 AM 8 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
191330 42986 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 2X Yale St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/16/2000 12:00:00 AM 3 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
156959 42841 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2245 Jones St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/03/2000 12:00:00 AM     Permit Number 42773 6008051.69679947 2120116.37092576 37.8018897255523 -122.416308313185 (37.8018897255523, -122.416308313185) 5 1 10 308 32
1047 42641 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1651 Union St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 12:11:00 PM 3 5x5 Permit Number 42688 6005090.06351 2118821.98656 37.7981686950973 -122.426464740961 (37.7981686950973, -122.426464740961) 13 9 1 57 17
12918 42635 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 11:32:00 AM 3 4x5 Permit Number 42688 6005113.34773 2118824.42387 37.7981767035488 -122.426384344263 (37.7981767035488, -122.426384344263) 13 9 1 57 17
13407 42632 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 12:07:00 PM 3 4x4 Permit Number 42688 6005134.31421 2118828.07494 37.7981879136105 -122.426312054082 (37.7981879136105, -122.426312054082) 13 9 1 57 17
15563 42636 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 11:48:00 AM 3 4x5 Permit Number 42688 6005181.30457 2118838.80185 37.7982200229931 -122.426150217479 (37.7982200229931, -122.426150217479) 13 9 1 57 17
17940 42637 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 11:43:00 AM 3 4x4 Permit Number 42688 6005203.48268 2118840.06651 37.7982247489172 -122.42607356464 (37.7982247489172, -122.42607356464) 13 9 1 57 17
20458 42640 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1651 Union St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/25/2015 02:08:00 PM 3 3x3 Permit Number 42688 6005273.82097 2118847.7065 37.7982497015198 -122.425830717123 (37.7982497015198, -122.425830717123) 13 9 1 57 17
71113 42638 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2016 02:49:00 PM 3 5x5 Permit Number 42688 6005231.45083 2118842.40752 37.7982327574016 -122.425976953174 (37.7982327574016, -122.425976953174) 13 9 1 57 17
101654 42639 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 1651 Union St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/2014 12:00:00 AM 8 3x3 Permit Number 42688 6005258.41678 2118846.41372 37.7982452813572 -122.425883928195 (37.7982452813572, -122.425883928195) 13 9 1 57 17
15793 42348 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 7 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 3 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
23669 42343 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
55302 42355 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 380X Flood Ave 14 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 9 8x90 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
70737 42344 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 380X Flood Ave 3 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 8 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
72021 42345 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
72982 42350 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
81932 42360 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 19 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
82359 42366 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
82711 42354 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
108541 42349 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
130186 42352 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
144395 42361 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
147728 42365 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
154352 42367 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
160859 42357 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 16 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 3 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
161881 42369 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 250 Foerster St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
162866 42347 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
180710 42358 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 4x4 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
182513 42356 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
41872 41128 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2049 Grove St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268) 15 5 11 29492 16
106593 41127 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2049 Grove St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268) 15 5 11 29492 16
132145 41129 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2049 Grove St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268) 15 5 11 29492 16
40144 40254 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 10 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
48192 99026 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3 Permit Number 41415 6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
52900 40252 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 8 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
106047 40253 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 5 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
129647 40250 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 3351X 23rd St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 3 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19

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)
);