trees
194,517 rows 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
138186 | 1 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 10 10th Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.468982710496 | (37.7866097734767, -122.468982710496) | 11 | 6 | 1 | 54 | 11 | |||
34993 | 10 | DPW Maintained 1 | Palm (unknown Genus) :: Palm Spp 273 | 97 12th St | 4 | Median : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | 8 | 2 | 9 | 28853 | 19 | |||
60856 | 1000 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1726 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X5PL | 6001385.76767 | 2092068.06757 | 37.724498876108 | -122.437365919005 | (37.724498876108, -122.437365919005) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||||
181241 | 10001 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 145 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X2 | 6005474.27283 | 2108090.23028 | 37.7687236538132 | -122.424371552702 | (37.7687236538132, -122.424371552702) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |||||
81417 | 10002 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 145 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2014 12:50:00 PM | 3 | 3X2 | 6005473.70519 | 2108134.2356 | 37.7688444498294 | -122.424376646466 | (37.7688444498294, -122.424376646466) | 8 | 4 | 5 | 28853 | 19 | ||
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 | ||||
87213 | 100031 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | 3 | 1 | 10 | 28857 | 21 | |
30472 | 100032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 3x3 | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | ||
153256 | 100033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
71695 | 100034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
143356 | 100035 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
178352 | 100036 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
151278 | 100037 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
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 | ||||
119271 | 10004 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 150 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6005403.33839 | 2108127.1988 | 37.7688211546939 | -122.424619539876 | (37.7688211546939, -122.424619539876) | 8 | 4 | 5 | 28853 | 19 | |||
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 | ||
153196 | 10005 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 156 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005408.68432 | 2108096.72474 | 37.7687377821415 | -122.424598880629 | (37.7687377821415, -122.424598880629) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |||
72431 | 10007 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 170 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005407.88099 | 2108072.95104 | 37.7686724598889 | -122.424599967939 | (37.7686724598889, -122.424599967939) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |||
68163 | 10008 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 170 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6005410.95643 | 2108039.08035 | 37.7685796327732 | -122.424586920555 | (37.7685796327732, -122.424586920555) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |||
84704 | 10009 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 170 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6005412.73113 | 2108018.38384 | 37.7685229053392 | -122.4245793096 | (37.7685229053392, -122.4245793096) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |||
116514 | 100095 | Permitted Site 7 | Tree(s) :: 17 | 4372 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 07/03/2012 12:00:00 AM | 3x3 | Permit Number 769070 | 6001507 | 2100613.7 | 37.7479700909705 | -122.43755853273 | (37.7479700909705, -122.43755853273) | 2 | 4 | 5 | 28862 | 22 |
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) );