Street_Tree_List

Data source: data.sfgov.org

99,669 rows where qLegalStatus = 2 sorted by PlantDate

View and edit SQL

These facets timed out: qLegalStatus

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate ▼ DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
4 207368 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 920 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5992009.48044 2105269.9271 37.760210314285004 -122.47073935813 (37.760210314285, -122.47073935813)
9 203507 Undocumented 2 Agonis flexuosa :: Peppermint Willow 7 920 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   5991972.62617 2105259.8491700003 37.76018051163321 -122.470866084321 (37.7601805116332, -122.470866084321)
19 182260 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1471 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   5987398.0 2105276.0 37.759959232607606 -122.486688530832 (37.7599592326076, -122.486688530832)
22 203506 Undocumented 2 Agonis flexuosa :: Peppermint Willow 7 910 Kirkham St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   5992059.0 2105289.0 37.760265546982495 -122.470569484113 (37.7602655469825, -122.470569484113)
34 240126 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 Lily St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6006399.28254 2110261.0751 37.7747364652596 -122.42132618837299 (37.7747364652596, -122.421326188373)
37 226924 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 1 Sidewalk: Property side : Pot 6 Tree 1 Private 1     11 Width 4ft   6002558.65829 2099967.6575700003 37.7462559468486 -122.433875776072 (37.7462559468486, -122.433875776072)
38 192589 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1390 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008004.0 2110521.0 37.775540499151 -122.415793536261 (37.775540499151, -122.415793536261)
40 222540 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1 Newburg St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002573.08856 2099992.67614 37.74632546084511 -122.433827665916 (37.7463254608451, -122.433827665916)
41 192590 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1390 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008004.0 2110521.0 37.775540499151 -122.415793536261 (37.775540499151, -122.415793536261)
43 222539 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1 Newburg St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002564.39948 2099984.1142599997 37.7463014588556 -122.433857099823 (37.7463014588556, -122.433857099823)
44 226925 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 2 Sidewalk: Property side : Pot 6 Tree 1 Private 1     19 Width 4ft   6002565.841680001 2099976.66752 37.746281093695 -122.433851580699 (37.746281093695, -122.433851580699)
49 251186 Undocumented 2 Juniperus chinensis :: Juniper 19 3042 Steiner St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6002010.0 2118654.0 37.7975328515761 -122.437110618013 (37.7975328515761, -122.437110618013)
52 233897 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1021 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6003182.0050800005 2102290.73647 37.75266992967379 -122.43188616810801 (37.7526699296738, -122.431886168108)
53 251187 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 1 Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
61 226596 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1 Newburg St 4 Sidewalk: Property side : Pot 6 Tree 1 Private 1     4 Width 4ft   6002583.45295 2099992.19698 37.746324733318 -122.433791792881 (37.746324733318, -122.433791792881)
62 239043 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 10 12th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6006946.59098 2109912.5632700003 37.773810376676295 -122.41940820332898 (37.7738103766763, -122.419408203329)
63 222541 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1 Newburg St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft Permit Number 779491 6002580.9472199995 2099999.66602 37.7463450993615 -122.433800991143 (37.7463450993615, -122.433800991143)
64 138748 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1614 Broderick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000643.1477 2114229.9232 37.7853077023438 -122.441522641665 (37.7853077023438, -122.441522641665)
65 226926 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Newburg St 3 Sidewalk: Property side : Pot 6 Tree 1 Private 1     15 Width 4ft   6002574.76935 2099983.89995 37.7463014588644 -122.433821226777 (37.7463014588644, -122.433821226777)
66 222538 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1 Newburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002556.19825 2099973.42317 37.746271638232 -122.43388469462201 (37.746271638232, -122.433884694622)
68 251188 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 1 Baker St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
71 251206 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 270 Trumbull St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005145.0 2094297.0 37.7308320294825 -122.424529217878 (37.7308320294825, -122.424529217878)
79 251205 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2000X Market St 5 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       4X4   6004899.0 2108432.0 37.769629569555896 -122.426385716137 (37.7696295695559, -122.426385716137)
83 130626 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 3660 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft Permit Number 779583 5996802.12344 2115996.768 37.789939408212206 -122.454939052208 (37.7899394082122, -122.454939052208)
88 251208 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 4115 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5982071.0 2104840.0 37.758450113202294 -122.505079418654 (37.7584501132023, -122.505079418654)
98 142074 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1384X GROVE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6001183.1648 2110763.0502 37.7758193019084 -122.439405751925 (37.7758193019084, -122.439405751925)
101 192592 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1399X Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6008031.0 2110483.0 37.775437677991796 -122.41569744526699 (37.7754376779918, -122.415697445267)
107 142075 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1384X GROVE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6001166.7226 2110758.8221 37.775806756879895 -122.439462326391 (37.7758067568799, -122.439462326391)
108 192593 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1399X Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6008031.0 2110483.0 37.775437677991796 -122.41569744526699 (37.7754376779918, -122.415697445267)
110 97646 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1824 Noriega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   5988290.0 2103126.0 37.7541078738982 -122.48344595561899 (37.7541078738982, -122.483445955619)
125 119758 Undocumented 2 Maytenus boaria :: Mayten 22 151X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
128 212622 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 115 Beverly St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5991392.0 2089980.0 37.718192344870296 -122.471760605115 (37.7181923448703, -122.471760605115)
133 218972 Undocumented 2 Fraxinus americana :: American Ash 23 742 Myra Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft Permit Number 779535 5997475.9556599995 2098006.28819 37.7405807633888 -122.451309623139 (37.7405807633888, -122.451309623139)
142 251241 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 2305 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5998495.0 2111363.0 37.777313260379 -122.44874797929701 (37.777313260379, -122.448747979297)
155 251225 Undocumented 2 Jacaranda mimosifolia :: Jacaranda 52 1 Yukon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       12x2.5   6000238.0 2104757.0 37.7592743544717 -122.442244057145 (37.7592743544717, -122.442244057145)
161 142720 Undocumented 2 :: 54 1170 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078)
162 251231 Undocumented 2 Pinus radiata :: Monterey Pine 3 164 Serrano Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989598.0 2090848.0 37.7204716934452 -122.478025052476 (37.7204716934452, -122.478025052476)
166 251230 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 99x Ogden Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
167 251232 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 99x Ogden Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
168 179480 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 100 Serrano Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5989599.0 2090767.0 37.7202493457345 -122.478015677124 (37.7202493457345, -122.478015677124)
171 251242 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 2449 Golden Gate Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           5997716.0 2111278.0 37.7770352956542 -122.451436646998 (37.7770352956542, -122.451436646998)
174 251226 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 1 Yukon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       13x2.5   6000262.0 2104839.0 37.7595008741196 -122.442166940047 (37.7595008741196, -122.442166940047)
185 251243 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 299x Chapman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6008953.0 2098186.0 37.7417246968109 -122.411638974942 (37.7417246968109, -122.411638974942)
191 210495 Undocumented 2 Myoporum laetum :: Myoporum 1 365 San Leandro Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft Permit Number 779799 5992304.44524 2094447.3559700001 37.7305113566072 -122.468931622808 (37.7305113566072, -122.468931622808)
208 100305 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 3701 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6003064.411830001 2121045.8637900003 37.804160163827206 -122.433633107497 (37.8041601638272, -122.433633107497)
241 251257 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1748x Eucalyptus Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
245 251255 Undocumented 2 Tree(s) :: 17 4089x Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991686.0 2086822.0 37.7095382490701 -122.47051450746099 (37.7095382490701, -122.470514507461)
249 251254 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 330 09th Ave 1 unknown : Cutout 12 Tree 1 MTA 6       3x3   5993109.0 2113253.0 37.782193225103605 -122.467517213871 (37.7821932251036, -122.467517213871)
251 251258 Undocumented 2 Phoenix dactylifera :: Date Palm 65 1748x Eucalyptus Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
253 251256 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 4091x Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991686.0 2086783.0 37.70943116445179 -122.470511668938 (37.7094311644518, -122.470511668938)
256 221894 Undocumented 2 Geijera parviflora :: Australian Willow 68 3164 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6008618.9330400005 2101573.97925 37.75100859049479 -122.41303356944799 (37.7510085904948, -122.413033569448)
257 251260 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 1163 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   6007684.87734 2102881.8281400003 37.754547168222295 -122.41635626045701 (37.7545471682223, -122.416356260457)
258 251259 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1050x Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6009753.0 2116795.0 37.7928655753561 -122.410186352148 (37.7928655753561, -122.410186352148)
259 141361 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1499X Hayes St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
260 221893 Undocumented 2 Geijera parviflora :: Australian Willow 68 3164 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6008601.79804 2101572.78068 37.751004337584796 -122.41309273944599 (37.7510043375848, -122.413092739446)
261 141359 Undocumented 2 Olea europaea :: Olive Tree 41 1499X Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
262 141360 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1499X Hayes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
263 141358 Undocumented 2 Myoporum laetum :: Myoporum 1 1499X Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
265 109354 Undocumented 2 Juniperus chinensis :: Juniper 19 900x Chestnut St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     6 5x45   6007474.1784 2120601.5824599997 37.803189502164294 -122.418341225173 (37.8031895021643, -122.418341225173)
280 194427 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 905 Minna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
285 98003 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1904 Filbert St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4x12   6003782.57859 2119037.12075 37.7986853996597 -122.431004385541 (37.7986853996597, -122.431004385541)
299 196427 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 McLea Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010117.0 2109248.0 37.772163696411795 -122.408394314545 (37.7721636964118, -122.408394314545)
303 196320 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 905 Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
305 191509 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 905 Minna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
328 251272 Undocumented 2 Acer negundo :: Box Elder 74 1301X 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993949.0 2106317.0 37.7631972735035 -122.46410754142299 (37.7631972735035, -122.464107541423)
334 246360 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1932 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6006755.8259 2107130.7038 37.76616130474321 -122.419870652653 (37.7661613047432, -122.419870652653)
339 251273 Undocumented 2 Acer negundo :: Box Elder 74 1301X 07th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993949.0 2106317.0 37.7631972735035 -122.46410754142299 (37.7631972735035, -122.464107541423)
354 93479 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 113X Leroy Pl 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 1.5x3 Tree 4 on Leroy 6008317.250990001 2116630.80353 37.792334150853 -122.415142500331 (37.792334150853, -122.415142500331)
355 182552 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2565 Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5986555.5107 2105693.4321 37.7610562355745 -122.489632951355 (37.7610562355745, -122.489632951355)
357 181338 Undocumented 2 Quercus ilex :: Holly Oak 78 1220 28th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5987427.0 2106942.0 37.7645353017913 -122.486710570648 (37.7645353017913, -122.486710570648)
364 182551 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2565 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5986541.5452 2105693.4321 37.7610554202125 -122.489681251316 (37.7610554202125, -122.489681251316)
379 122497 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 31X 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6008445.21835 2111601.2724900004 37.7785314648928 -122.414343702699 (37.7785314648928, -122.414343702699)
383 181340 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1360 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   5988678.0351 2106085.8063 37.7622572799997 -122.48232089502501 (37.7622572799997, -122.482320895025)
411 154366 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 411 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 3ft   6006164.37856 2107202.76015 37.7663258166161 -122.42192147568899 (37.7663258166161, -122.421921475689)
423 109554 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 300x Van Ness Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6006839.87541 2111919.81075 37.7793157843461 -122.41991981597201 (37.7793157843461, -122.419919815972)
427 251307 Undocumented 2 Tree(s) :: 17 200 Cashmere St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
429 142788 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 733 POLK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft Polk St Scape will replant 6007029.0497 2113497.6534 37.7836588132661 -122.419377346786 (37.7836588132661, -122.419377346786)
433 251301 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 100 Whitney Young Cir 2 Back Yard : Yard 13 Tree 1 Mayor Office of Housing 7       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
443 251293 Undocumented 2 :: 54 3789 Market St 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       3x3   6000208.0 2102740.0 37.753734455764 -122.44220302061701 (37.753734455764, -122.442203020617)
448 224849 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 4 Rotteck St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3 Permit Number 779889 6003244.1353400005 2095137.54828 37.733032453088704 -122.431160782146 (37.7330324530887, -122.431160782146)
450 142159 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 490X Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
452 221749 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 275 Grattan St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     24 Width 4ft   5997432.91763 2106413.5715 37.763662611962 -122.452064861225 (37.763662611962, -122.452064861225)
454 251309 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 2111 15th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991606.081259999 2101026.68041 37.7485361329461 -122.471825260742 (37.7485361329461, -122.471825260742)
457 142162 Undocumented 2 Prunus spp :: Cherry 84 490X Baker St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
458 221750 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 275 Grattan St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     11 Width 4ft   5997409.41415 2106414.31665 37.7636633116224 -122.45214620578699 (37.7636633116224, -122.452146205787)
460 142327 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1652 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5999940.0 2110256.0 37.774356244626205 -122.44366972691601 (37.7743562446262, -122.443669726916)
461 98533 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1805X Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 6x6 Permit Number 779899 5999986.39066 2115181.83206 37.787883958235504 -122.44386322941901 (37.7878839582355, -122.443863229419)
462 187628 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2 Rotteck St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 779889 6003236.0 2095183.0 37.7331567921798 -122.431192151262 (37.7331567921798, -122.431192151262)
470 98535 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1805X Baker St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 6x6 Permit Number 779899 5999990.232999999 2115142.7171 37.7877767779168 -122.44384712433799 (37.7877767779168, -122.443847124338)
472 236059 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 601X 14th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6004719.95486 2107769.51353 37.7678004187701 -122.42695783742799 (37.7678004187701, -122.426957837428)
473 142160 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 490X Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
474 251300 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 100 Whitney Young Cir 1 Back Yard : Yard 13 Tree 1 Health Dept 8       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
476 174954 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1400x Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4xt Permit Number 779898 6007316.0 2110809.0 37.776292577113104 -122.418193923043 (37.7762925771131, -122.418193923043)
478 142161 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 490X Baker St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
482 142326 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1652 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5999940.0 2110256.0 37.774356244626205 -122.44366972691601 (37.7743562446262, -122.443669726916)
483 236058 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 601X 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6004683.7857099995 2107762.8709299997 37.767780134560205 -122.427082469082 (37.7677801345602, -122.427082469082)
485 142163 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 490X Baker St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
486 98534 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1805X Baker St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3 Permit Number 779899 5999986.755609999 2115164.0145 37.787835056676705 -122.443860686142 (37.7878350566767, -122.443860686142)
491 236057 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 601X 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004642.9908 2107763.18347 37.767778685763 -122.427223596101 (37.767778685763, -122.427223596101)
495 248613 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 0ft   5997648.1233 2107524.615 37.766725579885 -122.451400674442 (37.766725579885, -122.451400674442)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 3138.198ms · Data source: data.sfgov.org