194,517 rows sorted by TreeID 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)
52174 99998 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501X Mission St 1 Sidewalk: Curb side : Pot Tree Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013420 2115433 37.7893307029327 -122.397402707509 (37.7893307029327, -122.397402707509) 12 2 9 28855 6
178138 99997 Permitted Site 7 Corymbia maculata :: Spotted Gum 69 600@Clay Montgomery St 9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
60177 99996 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 10 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
169008 99995 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 8 Sidewalk: Curb side : Cutout Tree Private 2     11   Permit Number 44594 6011799.65117 2117580.00293 37.795135512042 -122.403160044009 (37.795135512042, -122.403160044009) 3 1 10 28860 4
175597 99994 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
84637 99993 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
179677 99992 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
5844 99991 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
148277 99990 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 4 Sidewalk: Curb side : Cutout Tree Private 2     13   Permit Number 44594 6011811.05033 2117521.86685 37.7949765208901 -122.403116509626 (37.7949765208901, -122.403116509626) 3 1 10 28860 4
127074 9999 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 126 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x12   6005395.58344 2108269.7872 37.7692122302826 -122.424656508299 (37.7692122302826, -122.424656508299) 8 4 5 28853 19
189935 99989 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2     13   Permit Number 44594 6011816.52839 2117490.26365 37.7948900519939 -122.403095330591 (37.7948900519939, -122.403095330591) 3 1 10 28860 4
167930 99988 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Clay Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
20003 99987 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 535@Clay Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
163853 99986 Undocumented 4 Corymbia maculata :: Spotted Gum 69 535 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
108297 99985 Undocumented 4 Corymbia maculata :: Spotted Gum 69 535 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
152273 99984 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 535 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
173075 99983 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 535@Clay Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
177588 99982 Undocumented 4 Corymbia maculata :: Spotted Gum 69 535@Clay Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
20802 99981 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 535@Clay Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     19     6012012.90465 2117729.4246 37.7955576951954 -122.402432661541 (37.7955576951954, -122.402432661541) 3 1 10 28860 4
24671 99980 Undocumented 4 Corymbia maculata :: Spotted Gum 69 441 Castenada Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5993079.9 2099895.8 37.7455161901456 -122.466646671257 (37.7455161901456, -122.466646671257) 1 8 4 29491 40
53821 9998 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 122 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 2X2   6005390.2576582 2108319.0051408 37.7693470701553 -122.424678431625 (37.7693470701553, -122.424678431625) 8 4 5 28853 19
169611 99979 Undocumented 4 Corymbia maculata :: Spotted Gum 69 441 Castenada Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5993079.9 2099895.8 37.7455161901456 -122.466646671257 (37.7455161901456, -122.466646671257) 1 8 4 29491 40
151198 99978 Undocumented 4 Corymbia maculata :: Spotted Gum 69 441 Castenada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5993079.9 2099895.8 37.7455161901456 -122.466646671257 (37.7455161901456, -122.466646671257) 1 8 4 29491 40
96928 99977 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2295 Folsom St 15 Sidewalk: Curb side : Cutout Tree DPW 1         Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
115415 99976 DPW Maintained 1 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2295 Folsom St 14 Sidewalk: Curb side : Cutout Tree DPW 1           6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
183646 99975 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 2295 Folsom St 13 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
111853 99974 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
3230 99973 Permitted Site 7 Corymbia maculata :: Spotted Gum 69 2295 Folsom St 11 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
80873 99972 Undocumented 4 Tree(s) :: 17 143 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x3 Permit Number 776811 5988622.1 2114374.2 37.7850116539768 -122.483121892919 (37.7850116539768, -122.483121892919) 11 6 2 55 26
128468 99971 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2270 Folsom St 13 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
9226 99970 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2270 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
39226 9997 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 120 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1997 12:00:00 AM 18 2X2   6005389.5589835 2108331.2308198 37.7693805994769 -122.424681718135 (37.7693805994769, -122.424681718135) 8 4 5 28853 19
33189 99969 Undocumented 4 Tree(s) :: 17 2270 Folsom St 11 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2013 12:00:00 AM     Permit Number 767924 6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
48096 99968 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2270 Folsom St 10 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
8269 99967 Undocumented 4 Ficus nitida :: Laurel Fig 53 2270 Folsom St 9 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
20880 99966 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 2270 Folsom St 8 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
152512 99965 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2270 Folsom St 7 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
107862 99964 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2439 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769385 6003671 2116729 37.7923415699538 -122.431225642925 (37.7923415699538, -122.431225642925) 13 9 1 29490 27
81970 99963 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2439 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     11   Permit Number 769118 6003656.75521 2116793.16502 37.7925169434648 -122.43127951245 (37.7925169434648, -122.43127951245) 13 9 1 29490 27
165987 99962 DPW Maintained 1 Quercus suber :: Cork Oak 78 1202X Van Ness Ave 4 Median : Cutout Tree DPW 1     8 9x5   6006588.9 2114703 37.7869435992692 -122.420985708971 (37.7869435992692, -122.420985708971) 13 9 10 28858 21
68497 99961 Property Tree 8 Callistemon citrinus :: Lemon Bottlebrush 67 537 Valley St 1 Front Yard : Yard Tree Private 2   07/25/2012 12:00:00 AM     Permit Number 768880 6002459 2099152 37.7440106863694 -122.434162082356 (37.7440106863694, -122.434162082356) 2 7 5 63 22
147160 99960 Undocumented 4 Ulmus americana :: American Elm 74 279 Filbert St 1 Unaccepted Street : Yard Tree Private 2         shared responsibility with 1400 Montgomery 6011546.2 2120046.5 37.8018937585678 -122.40421070766 (37.8018937585678, -122.40421070766) 3 1 10 308 23
121293 9996 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 115 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/22/2014 06:44:00 AM 3 3X2   6005461.13944 2108328.79796 37.769377961859 -122.424433951272 (37.769377961859, -122.424433951272) 8 4 5 28853 19
179834 99959 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 19 Rausch St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2014 12:00:00 AM 28 3x3 Permit Number 772856 6009640 2110980 37.776892640268 -122.410166607108 (37.776892640268, -122.410166607108) 8 2 9 28853 34
189821 99958 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4204 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6003489 2093971 37.7298432476922 -122.430231025456 (37.7298432476922, -122.430231025456) 9 7 6 28861 25
165282 99957 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 308 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2012 12:00:00 AM 3 7x7 Permit Number 768921 5998118.54102 2115379.99567 37.7883213434981 -122.450339905768 (37.7883213434981, -122.450339905768) 13 6 1 54 31
99885 99952 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 420 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3 3x3 Permit Number 778491 5993609 2105311 37.760415458577 -122.465210403501 (37.760415458577, -122.465210403501) 1 8 11 56 12
47218 99951 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1160 Battery St 1 Front Yard : Yard Tree Private 2   06/19/2012 12:00:00 AM     Permit Number 768993 6012314.3 2120017.7 37.8018575696458 -122.401550680127 (37.8018575696458, -122.401550680127) 3 1 10 28860 6
167818 99950 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1545 05th Ave 1 Front Yard : Yard Tree Private 2   08/14/2012 12:00:00 AM     Permit Number 768941 5994712.1 2105033.7 37.7597176147703 -122.461375215787 (37.7597176147703, -122.461375215787) 1 5 4 56 12
30291 9995 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 109 GUERRERO ST 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/06/2015 12:59:00 PM 3 2X2   6005457 2108414 37.7696116724665 -122.424454330606 (37.7696116724665, -122.424454330606) 8 4 5 28853 19
131318 99947 Permitted Site 7 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 522 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/2012 12:00:00 AM   4x4 Permit Number 54785 6007824 2104880.2 37.7600420622217 -122.416016646831 (37.7600420622217, -122.416016646831) 2 4 7 28859 19
36492 99946 DPW Maintained 1 Tree(s) :: 17 499X FOLSOM ST 2 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2015 12:00:00 AM 3 3x3 Permit Number 769035 6014477 2114572 37.787025389439 -122.393685294607 (37.787025389439, -122.393685294607) 6 2 9 28855 6
74500 99945 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 499X FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2015 12:00:00 AM 3 3x3 Permit Number 769035 6014477 2114572 37.787025389439 -122.393685294607 (37.787025389439, -122.393685294607) 6 2 9 28855 6
138820 99944 Undocumented 4 Melaleuca linariifolia :: Flaxleaf Paperbark 103 221 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6006240 2101855 37.7516463781161 -122.421280123778 (37.7516463781161, -122.421280123778) 2 4 5 28859 19
85255 99943 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2790 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2012 12:00:00 AM 6 4x4 Permit Number 768876 6000263.51246 2117158.55941 37.7933273378328 -122.443046457948 (37.7933273378328, -122.443046457948) 13 9 1 57 27
41751 99942 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2790 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2012 12:00:00 AM 5 4x4 Permit Number 768876 6000286.44523 2117159.95802 37.79333248556 -122.442967209691 (37.79333248556, -122.442967209691) 13 9 1 57 27
130683 99941 Permitted Site 7 Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 298 182 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2012 12:00:00 AM   3x3 Permit Number 769134 6003955.9 2092670 37.7262974264753 -122.42852420031 (37.7262974264753, -122.42852420031) 9 7 6 28861 5
77831 9994 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 102 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X2   6005389.27087 2108406.08421 37.7695861126487 -122.424688040346 (37.7695861126487, -122.424688040346) 8 4 5 28853 19
44771 99937 Undocumented 4 Tree(s) :: 17 315 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2012 12:00:00 AM   3c3 Permit Number 768708 6006226 2098169 37.7415246698481 -122.421066843418 (37.7415246698481, -122.421066843418) 2 7 7 28859 2
97025 99934 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 63 Manchester St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 768712 6008250 2099654 37.7457160396744 -122.41417355851 (37.7457160396744, -122.41417355851) 2 7 7 28859 2
132137 99933 Undocumented 4 Tree(s) :: 17 63 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2012 12:00:00 AM   3x3 Permit Number 768712 6008250 2099654 37.7457160396744 -122.41417355851 (37.7457160396744, -122.41417355851) 2 7 7 28859 2
152098 99932 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 277 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2012 12:00:00 AM   3x3 Permit Number 768952 6006756.8 2104530.9 37.7590229060886 -122.419682802567 (37.7590229060886, -122.419682802567) 2 4 7 28859 19
142116 99931 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 801X Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2012 12:00:00 AM   3x3 Permit Number 768924 6003100.6 2103580.4 37.7562064244422 -122.432259777723 (37.7562064244422, -122.432259777723) 2 4 5 28862 22
118680 9993 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 65 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/18/2001 12:00:00 AM 6 2X2   6005451.908597 2108608.747745 37.770146115502 -122.424485796032 (37.770146115502, -122.424485796032) 8 2 5 28853 19
179365 99928 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3331 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2013 12:00:00 AM 3 3x3 Permit Number 54787 6007298 2105556 37.7618680647923 -122.417883738243 (37.7618680647923, -122.417883738243) 2 4 7 28859 19
137800 99927 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 665 Bowdoin St 2 Sidewalk: Curb side : Cutout Tree Private 2     6     6008996.47999 2092997.06161 37.7274794299239 -122.411122192648 (37.7274794299239, -122.411122192648) 9 3 7 309 28
50016 99924 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 125 Cerritos Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2012 12:00:00 AM     Permit Number 769009 5992063.9 2092889.6 37.7262202448731 -122.469649855245 (37.7262202448731, -122.469649855245) 9 8 4 59 40
67 99921 Section 806 (d) 5 Olea europaea :: Olive Tree 9 1740 Jones St 1 Front Yard : Yard Tree Private 2   06/01/2015 12:00:00 AM 3   Permit Number 774389 6008331.64636 2118443.68708 37.7973126906849 -122.415221079511 (37.7973126906849, -122.415221079511) 5 1 10 308 21
102213 99920 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1740 Jones St 7 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
127988 9992 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 67 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/02/2014 12:00:00 AM 3 2x2   6005450.48952 2108526.98568 37.7699215363694 -122.424484887989 (37.7699215363694, -122.424484887989) 8 2 5 28853 19
140038 99919 Permitted Site 7 Juniperus chinensis :: Juniper 113 1740 Jones St 4 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
103648 99918 Permitted Site 7 Juniperus chinensis :: Juniper 113 1740 Jones St 5 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
114624 99917 Permitted Site 7 Juniperus chinensis :: Juniper 113 1740 Jones St 3 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
118511 99916 Permitted Site 7 Juniperus chinensis :: Juniper 113 1740 Jones St 1 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
83394 99914 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 85 Ramona Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2012 12:00:00 AM 4 3x3 Permit Number 768764 6005244.6 2107384.2 37.7667720917659 -122.425115731153 (37.7667720917659, -122.425115731153) 8 4 5 28853 19
31355 99913 Undocumented 4 Ulmus pumila :: Siberian Elm 99 3751X Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 768933 6005509.05056 2101091.11643 37.7495076933522 -122.42375353502 (37.7495076933522, -122.42375353502) 2 4 5 28859 19
18105 99912 Undocumented 4 Ulmus pumila :: Siberian Elm 99 3751X Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005509.05056 2101091.11643 37.7495076933522 -122.42375353502 (37.7495076933522, -122.42375353502) 2 4 5 28859 19
132451 99911 Undocumented 4 Ulmus pumila :: Siberian Elm 99 400 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005460.7 2101331.3 37.7501644526018 -122.423937810125 (37.7501644526018, -122.423937810125) 2 4 5 28859 19
127896 99910 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 710 El Camino Del Mar 3 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2012 12:00:00 AM     Permit Number 769055 5986442 2114842 37.7861689922045 -122.490698673964 (37.7861689922045, -122.490698673964) 11 6 1 55 33
38594 9991 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 43 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6005443.37728 2108628.68203 37.7702003684767 -122.424516723968 (37.7702003684767, -122.424516723968) 8 2 5 28853 19
183598 99909 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 210 Gaven St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2014 12:00:00 AM 3 3x3 Permit Number 774553 6009399.78383 2095020.31894 37.7330574731105 -122.409870724875 (37.7330574731105, -122.409870724875) 10 3 7 309 28
22295 99908 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 10 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
184283 99907 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
189714 99906 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 8 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
156825 99905 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
101150 99904 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
14158 99903 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
53086 99902 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
23492 99901 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
119395 99900 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
27680 9990 DPW Maintained 1 Ligustrum japonicum :: Japanese Privet 232 33 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6005438.43144 2108674.6093 37.7703261944175 -122.424537099004 (37.7703261944175, -122.424537099004) 8 2 5 28853 19
148575 999 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1725 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3X3   6001467.99656 2092045.35722 37.7244411930178 -122.437080040045 (37.7244411930178, -122.437080040045) 9 7 6 28861 25
189388 99899 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3 Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
163505 99898 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2101X Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2     2   Permit Number 768908 6004438.52556 2116689.23299 37.7922758451055 -122.428567149951 (37.7922758451055, -122.428567149951) 13 9 1 28858 27
80066 99897 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2101X Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2     21   Permit Number 768908 6004409.82631 2116680.57597 37.7922504509529 -122.428665832574 (37.7922504509529, -122.428665832574) 13 9 1 28858 27
72946 99896 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2101X Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 768908 6004371.30251 2116674.47154 37.7922315094359 -122.428798690309 (37.7922315094359, -122.428798690309) 13 9 1 28858 27
25519 99895 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2101X Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3 Permit Number 768908 6004333.92311 2116670.59896 37.7922187606381 -122.428927747522 (37.7922187606381, -122.428927747522) 13 9 1 28858 27
164727 99894 Significant Tree 6 Ulmus pumila :: Siberian Elm 99 1636 Bush St 1 Front Yard : Yard Tree Private 2   07/11/2012 12:00:00 AM     Permit Number 768849 6005665 2115204 37.7882670981083 -122.424217840789 (37.7882670981083, -122.424217840789) 13 9 1 28858 41
189259 99893 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 715 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2           5997893.2 2108079.1 37.7682620848422 -122.450592979377 (37.7682620848422, -122.450592979377) 15 5 11 29492 9
97482 99892 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5646@ Whipple Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.7109047702551 -122.447663697002 (37.7109047702551, -122.447663697002) 9 7 6 28861 25

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