trees
163,064 rows where qCaretaker_id = 2 sorted by TreeID
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );