163,064 rows where qCaretaker_id = 2 sorted by TreeID

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)
139521 10000 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 136 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 2X2   6005403.54778 2108183.22689 37.7689750062251 -122.424622801709 (37.7689750062251, -122.424622801709) 8 4 5 28853 19
95012 100000 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
10998 100001 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501X 01st St 2 Sidewalk: Curb side : Pot Tree Private 2         Address is 100 1st Street                    
35004 100003 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501X Mission St 2 Sidewalk: Curb side : Pot Tree Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.7897060631976 -122.397547983339 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
50134 100004 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 8 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
135793 100005 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 7 Sidewalk: Curb side : Cutout Tree Private 2     14     6011805.43211 2117563.29295 37.7950899532827 -122.403138864979 (37.7950899532827, -122.403138864979) 3 1 10 28860 4
123886 100006 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 6 Sidewalk: Curb side : Cutout Tree Private 2     15     6011806.48185 2117548.03354 37.7950481132234 -122.403134158813 (37.7950481132234, -122.403134158813) 3 1 10 28860 4
32707 100007 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501X Mission St 3 Sidewalk: Curb side : Pot Tree Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.7897060631976 -122.397547983339 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
88404 100008 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501X Mission St 4 Sidewalk: Curb side : Pot Tree Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.7897060631976 -122.397547983339 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
60809 100009 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 4 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
100855 100010 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501X Mission St 5 Sidewalk: Curb side : Pot Tree Private 2         Permit Number 768978 6013380.8 2115570.5 37.7897060631976 -122.397547983339 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
85685 100011 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 5 Sidewalk: Curb side : Cutout Tree Private 2     15     6011807.60069 2117536.15907 37.7950155712566 -122.40312945177 (37.7950155712566, -122.40312945177) 3 1 10 28860 4
148244 100012 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 3 Sidewalk: Curb side : Cutout Tree Private 2     15     6011815.13883 2117505.52997 37.7949318920521 -122.403101213045 (37.7949318920521, -122.403101213045) 3 1 10 28860 4
109088 100014 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600@Washington St Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2     16     6011819.70044 2117479.02475 37.7948593698064 -122.403083563865 (37.7948593698064, -122.403083563865) 3 1 10 28860 4
75648 100015 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 14 Sidewalk: Curb side : Cutout Tree Private 2     19     6011789.64079 2117672.98825 37.795390268386 -122.403201225768 (37.795390268386, -122.403201225768) 3 1 10 28860 4
136656 100016 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 13 Sidewalk: Curb side : Cutout Tree Private 2     14     6011790.6974 2117658.0677 37.7953493591435 -122.403196519624 (37.7953493591435, -122.403196519624) 3 1 10 28860 4
25628 100017 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 12 Sidewalk: Curb side : Cutout Tree Private 2     15     6011791.69231 2117640.10072 37.7953000816886 -122.403191812578 (37.7953000816886, -122.403191812578) 3 1 10 28860 4
76653 100018 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 11 Sidewalk: Curb side : Cutout Tree Private 2     14     6011793.71356 2117622.45121 37.7952517332473 -122.403183576561 (37.7952517332473, -122.403183576561) 3 1 10 28860 4
175170 100019 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 10 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
72619 100020 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 9 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
129974 100021 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 8 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
124561 100022 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 7 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
33339 100023 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 6 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
160909 100025 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 5 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
29882 100026 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 4 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
44949 100027 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 3 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
143924 100028 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
57271 100029 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 600 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
128526 10003 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 145 Guerrero St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3X2   6005473.24802 2108147.80938 37.7688816943622 -122.424379193367 (37.7688816943622, -122.424379193367) 8 4 5 28853 19
174330 100030 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 535@Clay Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     19     6012036.24942 2117732.62521 37.7955677864875 -122.402352109262 (37.7955677864875, -122.402352109262) 3 1 10 28860 4
85631 100038 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1925 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     6     6005164.06417 2116434.37592 37.7916171042824 -122.426038618789 (37.7916171042824, -122.426038618789) 13 9 1 28858 27
58737 100039 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1925 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     6     6005166.77799 2116408.45121 37.7915460749308 -122.426027382675 (37.7915460749308, -122.426027382675) 13 9 1 28858 27
57848 100040 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1925 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     6     6005169.80466 2116390.62846 37.7914973092018 -122.426015641131 (37.7914973092018, -122.426015641131) 13 9 1 28858 27
113537 100041 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1925 Gough St 4 Sidewalk: Curb side : Cutout Tree Private 2     8     6005173.38835 2116375.34408 37.7914555446772 -122.426002153097 (37.7914555446772, -122.426002153097) 13 9 1 28858 27
5697 100042 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1925 Gough St 5 Sidewalk: Curb side : Cutout Tree Private 2     8     6005174.91003 2116356.5458 37.7914040153291 -122.425995549348 (37.7914040153291, -122.425995549348) 13 9 1 28858 27
190141 100043 Significant Tree 6 Tree(s) :: 17 50 Bronte St 1 Front Yard : Yard Tree Private 2   07/12/2012 12:00:00 AM     Permit Number 769001 6009337 2097155 37.7389153282678 -122.410238449764 (37.7389153282678, -122.410238449764) 10 7 7 28859 2
77303 100044 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1250 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2012 12:00:00 AM   3x3 Permit Number 768984 6012201 2102568.4 37.7539394855375 -122.400716201774 (37.7539394855375, -122.400716201774) 10 3 8 28856 29
120627 100045 Property Tree 8 Acacia decurrens :: Acacia: Silver Wattle 111 556 28th St   Front Yard : Yard Tree Private 2         Not sure which property tree is located on. 6002301 2099461 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
58309 100046 Property Tree 8 Tree(s) :: 17 562 28th St   Front Yard : Yard Tree Private 2   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262 2099459 37.7448424535299 -122.434865213189 (37.7448424535299, -122.434865213189) 2 7 5 63 22
84856 100047 DPW Maintained 1 Ceanothus Sps :: California lilac 192 191@ 23rd Ave 23rd Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1     5988664 2114068 37.7841733536199 -122.482954484434 (37.7841733536199, -122.482954484434) 11 6 2 55 26
43487 100048 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 1445 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2012 12:00:00 AM   3x3 Permit Number 769137 5991161 2110614 37.7748345969519 -122.47406374416 (37.7748345969519, -122.47406374416) 11 6 2 54 26
20994 100049 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 768990 6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
85651 100050 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
187091 100051 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
179011 100052 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
2653 100053 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
188934 100054 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
153818 100055 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
37577 100056 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 401X Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.7809848079497 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
26755 100057 Undocumented 4 Tree(s) :: 17 240 05th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2012 12:00:00 AM 12 3x3 Permit Number 769058 6011351 2112431 37.7809725048626 -122.404349860228 (37.7809725048626, -122.404349860228) 14 2 9 28853 34
133766 100058 Undocumented 4 Tree(s) :: 17 240 05th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2012 12:00:00 AM 12 3x3 Permit Number 769058 6011351 2112431 37.7809725048626 -122.404349860228 (37.7809725048626, -122.404349860228) 14 2 9 28853 34
102447 100059 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435 2112345 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
189744 10006 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 165 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1991 12:00:00 AM 6 3X2   6005478.90232 2108028.91066 37.7685555462362 -122.42435117769 (37.7685555462362, -122.42435117769) 8 4 5 28853 19
26043 100060 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435 2112345 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
120243 100061 Undocumented 4 Tree(s) :: 17 430X Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459 2112320 37.7806737592872 -122.403968419194 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
193832 100062 Undocumented 4 Tree(s) :: 17 430X Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459 2112320 37.7806737592872 -122.403968419194 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
81685 100063 Undocumented 4 Tree(s) :: 17 430X Clementina St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459 2112320 37.7806737592872 -122.403968419194 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
159612 100064 Undocumented 4 Tree(s) :: 17 430X Clementina St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459 2112320 37.7806737592872 -122.403968419194 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
173940 100065 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 322 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2012 12:00:00 AM   3x3 Permit Number 58746 6004276.4 2099889 37.7461372993162 -122.427930429145 (37.7461372993162, -122.427930429145) 2 7 5 63 22
133534 100066 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 93 Buena Vista Ter 2 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2012 12:00:00 AM   2x2 Permit Number 768610 6001505.1 2107681.4 37.7673761743712 -122.438071302911 (37.7673761743712, -122.438071302911) 15 5 5 29492 3
72037 100067 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 93 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2       2x2 On property line with 99 Buena Vista Ter 6001505.1 2107681.4 37.7673761743712 -122.438071302911 (37.7673761743712, -122.438071302911) 15 5 5 29492 3
116936 100068 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 303 Serrano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2012 12:00:00 AM     Permit Number 769006 5990392 2090762 37.720281613079 -122.47527420247 (37.720281613079, -122.47527420247) 1 8 4 64 40
188916 100069 Permitted Site 7 Pinus radiata :: Monterey Pine 15 619 Gonzalez Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2012 12:00:00 AM     Permit Number 769006 5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
30075 100070 Property Tree 8 Tree(s) :: 17 331 Serrano Dr 1 Front Yard : Yard Tree Private 2         Permit Number 777990 5990400 2090718 37.7201612636948 -122.475243338807 (37.7201612636948, -122.475243338807) 1 8 4 64 40
149109 100071 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 96X Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Address is 4200-4204 17th St 6001034.7 2105837.1 37.7622854187027 -122.439566119284 (37.7622854187027, -122.439566119284) 15 5 5 28862 3
142242 100072 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 96X Douglass St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Address is 1200-1204 17th St 6001034.7 2105837.1 37.7622854187027 -122.439566119284 (37.7622854187027, -122.439566119284) 15 5 5 28862 3
187521 100073 Permitted Site 7 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 930@ Lorraine Ct Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2012 12:00:00 AM   3x3 Permit Number 769060 5996162 2112255 37.7796287713947 -122.456883064061 (37.7796287713947, -122.456883064061) 11 6 2 54 16
52216 100074 Undocumented 4 Tree(s) :: 17 701 Noe St   Sidewalk: Curb side : Cutout Tree Private 2           6003070 2104166 37.7578126071811 -122.432407426584 (37.7578126071811, -122.432407426584) 2 4 5 28862 3
184029 100075 Undocumented 4 Tree(s) :: 17 707-709 Noe St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003067 2104139 37.7577383015231 -122.432415873427 (37.7577383015231, -122.432415873427) 2 4 5 28862 3
142036 100076 DPW Maintained 1 Quercus tomentella :: Island oak 178 262 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2016 12:00:00 AM 3 4x4 Permit Number 776532 5990584.51145 2113652.92092 37.783145223942 -122.476279940242 (37.783145223942, -122.476279940242) 11 6 2 54 26
120641 100077 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 260 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005310 2109942 37.7737988894613 -122.425071534475 (37.7737988894613, -122.425071534475) 7 9 11 28852 10
61328 100078 DPW Maintained 1 Quercus tomentella :: Island oak 178 266 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2016 12:00:00 AM 3 4x4 Permit Number 776410 5990586.53381 2113609.7978 37.7830269371305 -122.476269792865 (37.7830269371305, -122.476269792865) 11 6 2 54 26
175764 100079 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1451 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x6   5982451.9345 2105243.3429 37.7595799838686 -122.503791871245 (37.7595799838686, -122.503791871245) 1 8 3 56 35
170162 100080 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 701X POLK ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774752 6007001 2113322 37.7831749319814 -122.419461922492 (37.7831749319814, -122.419461922492) 7 9 9 28858 36
85361 100087 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 2028 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003216.8 2118972.8 37.7984767167189 -122.432957560795 (37.7984767167189, -122.432957560795) 13 9 1 57 17
179824 100088 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2034 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6003201.40964 2118956.65929 37.7984315255609 -122.433009662373 (37.7984315255609, -122.433009662373) 13 9 1 57 17
159081 100089 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2034 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6003188.20593 2118955.0281 37.7984262977915 -122.433055234626 (37.7984262977915, -122.433055234626) 13 9 1 57 17
102360 100090 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 11X Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6007856.7 2107724 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
97064 100091 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 11X Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6007856.7 2107724 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
120574 100092 Undocumented 4 Tree(s) :: 17 11X Shotwell St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6007856.7 2107724 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
77223 100093 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 11X Shotwell St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6007856.7 2107724 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
16242 100094 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 11X Shotwell St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007856.7 2107724 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
64071 100096 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 495 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           6006848.2 2122207.6 37.8075639592102 -122.42062152066 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
57950 100097 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 495 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           6006848.2 2122207.6 37.8075639592102 -122.42062152066 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
81454 100098 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 495 Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           6006848.2 2122207.6 37.8075639592102 -122.42062152066 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
23589 100099 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 495 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2           6006848.2 2122207.6 37.8075639592102 -122.42062152066 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
162681 10010 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 174 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2002 12:00:00 AM 6 3x3   6005413.24282 2107997.40019 37.7684653181587 -122.424576046874 (37.7684653181587, -122.424576046874) 8 4 5 28853 19
171998 100100 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 495 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6006848.2 2122207.6 37.8075639592102 -122.42062152066 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
122906 100101 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 495 Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2           6006848.2 2122207.6 37.8075639592102 -122.42062152066 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
94746 100102 Undocumented 4 Ficus carica :: Edible Fig 341 495@ Beach Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           6006848.2 2122207.6 37.8075639592102 -122.42062152066 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
26574 100103 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 461 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
181687 100104 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 461 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
145774 100105 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 461 Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
122731 100106 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
48222 100107 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
114077 100108 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
61684 100109 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
67964 100110 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
81579 100111 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
97575 100112 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23

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