trees

163,064 rows where qCaretaker_id = 2 sorted by DBH descending

✎ View and edit SQL

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)
114469 141190 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1771 ELLIS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9999 Width 0ft   6002407.0405 2112959.471 37.7819196963173 -122.435329208056 (37.7819196963173, -122.435329208056) 15 5 11 29490 41
30720 186155 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1700 Sunset Blvd 40 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5984957.7478 2103324.5301 37.7544584761874 -122.494984162752 (37.7544584761874, -122.494984162752) 1 8 3 56 35
55229 185035 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2701 Sunset Blvd 61 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5985023.8956 2096287.7176 37.7351411700064 -122.494236773234 (37.7351411700064, -122.494236773234) 1 8 3 29491 35
57542 184735 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1301 Sunset Blvd 1 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5984680.1977 2106291.6891 37.7625892162308 -122.496162889393 (37.7625892162308, -122.496162889393) 1 8 3 56 35
62709 185074 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2801 Sunset Blvd 2 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5984997.7254 2096135.7209 37.7347222961152 -122.494316051543 (37.7347222961152, -122.494316051543) 1 8 3 29491 35
92340 186402 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1801 Sunset Blvd 69 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5984820.6527 2102319.266 37.7516902715465 -122.495384132242 (37.7516902715465, -122.495384132242) 1 8 3 56 35
123285 107037 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1060 Clayton St 1 Front Yard : Yard Tree Private 2     99     5998985 2106259 37.7633269800406 -122.446685590868 (37.7633269800406, -122.446685590868) 15 5 5 29492 9
136451 187008 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2501 Sunset Blvd 27 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5984967.4388 2098043.05 37.7399575385403 -122.494561323189 (37.7399575385403, -122.494561323189) 1 8 3 29491 35
168292 186361 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1801 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5984795.4735 2102590.7965 37.752434345234 -122.495491228463 (37.752434345234, -122.495491228463) 1 8 3 56 35
171755 184346 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1251 Sunset Blvd 16 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5984686.7384 2106407.7493 37.7629082680796 -122.496148830979 (37.7629082680796, -122.496148830979) 1 8 3 56 35
192427 185929 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2000 Sunset Blvd 72 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5985012.7201 2101493.4926 37.7494341681805 -122.494659074897 (37.7494341681805, -122.494659074897) 1 8 3 29491 35
193206 186256 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1701 Sunset Blvd 67 Sidewalk: Property side : Yard Tree Private 2     99 Width 0ft   5984812.6153 2103003.1364 37.7535675206606 -122.495462358835 (37.7535675206606, -122.495462358835) 1 8 3 56 35
140443 185710 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2101 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     95 Width 0ft   5984848.6658 2100421.3565 37.7464807716884 -122.495147319794 (37.7464807716884, -122.495147319794) 1 8 3 29491 35
122681 217519 DPW Maintained 1 Yucca gloriosa :: Spanish Dagger 126 125 Marston Ave 1 Sidewalk: Property side : Yard Tree Private 2     94 Width 10ft   5998618.10798 2093180.61105 37.7273959305753 -122.447013334218 (37.7273959305753, -122.447013334218) 9 7 4 28861 40
374 5332 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 125 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 6x7   6004849.91389 2107615.96816 37.7673861676625 -122.426497389946 (37.7673861676625, -122.426497389946) 8 4 5 28862 19
4388 12732 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1619 Lake St 3 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5990481.52989 2114717.45643 37.7860621686584 -122.476714011555 (37.7860621686584, -122.476714011555) 11 6 2 55 26
6635 8146 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1000 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2     90 4X4   6002926.0085 2111351.5233 37.7775341328911 -122.433418880148 (37.7775341328911, -122.433418880148) 15 5 11 29492 41
17759 8164 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1108 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2     90 3x3   6002345.91863 2111334.94694 37.7774556905463 -122.435424415956 (37.7774556905463, -122.435424415956) 15 5 11 29492 41
20255 185965 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2001 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     90 Width 0ft   5984859.6467 2101291.1753 37.7488696995369 -122.4951734814 (37.7488696995369, -122.4951734814) 1 8 3 29491 35
27711 3410 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 6528 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5987293.52978 2113992.83204 37.7838871248275 -122.487690236342 (37.7838871248275, -122.487690236342) 11 6 1 55 33
27899 1421 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 50 Arguello Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     90 3x12   5995527.21204 2115624.1968 37.7888432106719 -122.459323111848 (37.7888432106719, -122.459323111848) 11 6 1 54 31
29599 1559 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 552 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3x3   5995643.10859 2112475.92175 37.7802055542204 -122.458694119583 (37.7802055542204, -122.458694119583) 11 6 2 54 16
30361 175 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 5400X California St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5990796.10602 2114048.44446 37.7842434899767 -122.475576806045 (37.7842434899767, -122.475576806045) 11 6 2 54 26
32734 5631 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1234 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   6005123.01487 2101119.88751 37.7495648926104 -122.425090505838 (37.7495648926104, -122.425090505838) 2 4 5 28862 22
36800 1993 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 162 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   6007301.50891 2098085.20202 37.7413551489316 -122.417342154839 (37.7413551489316, -122.417342154839) 2 7 7 28859 2
38652 1382 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 601X Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5995593.50257 2112100.09905 37.7791707937226 -122.458838511201 (37.7791707937226, -122.458838511201) 11 6 2 54 11
39138 3336 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 5414 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5990748.98801 2114101.91513 37.7843875739705 -122.475743722006 (37.7843875739705, -122.475743722006) 11 6 2 54 26
40260 14571 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1101 Masonic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     90 5x5   5999361.6418 2109001.7234 37.7708793165263 -122.445580154944 (37.7708793165263, -122.445580154944) 15 5 11 29492 9
44589 1636 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 827 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3x3   5995647.41415 2110653.56158 37.7752020829683 -122.458547268394 (37.7752020829683, -122.458547268394) 11 6 2 54 11
52736 13161 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1895 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   6003359.5664 2119590.4223 37.8001806439695 -122.432507683341 (37.8001806439695, -122.432507683341) 13 9 1 57 17
53196 1582 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 633 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5995604.58017 2111830.53845 37.778431288562 -122.458780668658 (37.778431288562, -122.458780668658) 11 6 2 54 11
53956 12603 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 645 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5993471.58312 2114823.45454 37.7865261918162 -122.466377023021 (37.7865261918162, -122.466377023021) 11 6 2 54 11
60093 3327 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 5300 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3x3   5991115.03763 2114114.39354 37.7844430513541 -122.474478240984 (37.7844430513541, -122.474478240984) 11 6 2 54 26
69588 10276 DPW Maintained 1 Olea europaea :: Olive Tree 9 215X Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   6004948.05546 2109498.71961 37.7725612966014 -122.426291992897 (37.7725612966014, -122.426291992897) 7 9 5 28852 10
70175 13127 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1700 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   6004182.8465 2119787.4466 37.8007682730329 -122.42967287413 (37.8007682730329, -122.42967287413) 13 9 1 57 17
70736 3246 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3934 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3x3   5995332.13001 2114476.70361 37.7856812864958 -122.459914906703 (37.7856812864958, -122.459914906703) 11 6 1 54 11
74817 1574 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 595 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5995589.69887 2112254.70561 37.7795950836314 -122.45886286632 (37.7795950836314, -122.45886286632) 11 6 2 54 11
79809 4593 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   6011460.12974 2118136.30046 37.7966440043551 -122.404374021953 (37.7966440043551, -122.404374021953) 3 1 10 308 4
82293 12601 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 637 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5993509.18858 2114827.45466 37.7865393448418 -122.466247209305 (37.7865393448418, -122.466247209305) 11 6 2 54 11
82417 3315 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 5010 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5992011.64144 2114143.58423 37.7845751079649 -122.471378457169 (37.7845751079649, -122.471378457169) 11 6 2 54 11
82745 8148 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000 Fulton St 4 Sidewalk: Curb side : Cutout Tree Private 2     90 4X4   6002886.96217 2111360.68278 37.7775570672136 -122.433554609066 (37.7775570672136, -122.433554609066) 15 5 11 29492 41
87278 3408 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 6517 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 2X3   5987328.28355 2113919.47268 37.7836877279639 -122.48756461185 (37.7836877279639, -122.48756461185) 11 6 2 55 26
88572 3393 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 6241 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5988252.22536 2113941.19107 37.7838012036794 -122.484369756511 (37.7838012036794, -122.484369756511) 11 6 2 55 26
91946 13112 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1601 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3x3   6004666.807 2119779.6281 37.8007741971938 -122.42799761136 (37.8007741971938, -122.42799761136) 13 9 1 57 17
92306 8150 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1000 Fulton St 6 Sidewalk: Curb side : Cutout Tree Private 2     90 4X4   6002846.3106 2111341.485 37.7775020483312 -122.433693863913 (37.7775020483312, -122.433693863913) 15 5 11 29492 41
96201 186060 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1901 Sunset Blvd 6 Sidewalk: Property side : Yard Tree Private 2     90 Width 0ft   5984837.0831 2102159.5408 37.7512526720721 -122.495315536401 (37.7512526720721, -122.495315536401) 1 8 3 29491 35
100799 14523 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 625 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     90 4x4   5999129.3058 2110654.1301 37.7754031370148 -122.446502707181 (37.7754031370148, -122.446502707181) 15 5 11 29492 16
113946 24546 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 704 Cortland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     90 3X4   6007961.02706 2097162.19636 37.7388578629053 -122.414996450438 (37.7388578629053, -122.414996450438) 2 7 7 28859 2
115934 12526 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 45 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5995287.93021 2114888.84585 37.7868103758205 -122.460097693179 (37.7868103758205, -122.460097693179) 11 6 1 54 11
136913 12672 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1132 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2     90 3X4   5991897.52815 2114823.03375 37.786434086563 -122.47182278185 (37.786434086563, -122.47182278185) 11 6 1 54 11
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
147246 12815 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2139 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5988780.51636 2114651.15635 37.7857813149586 -122.482594130976 (37.7857813149586, -122.482594130976) 11 6 2 55 26
149967 11434 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3x3   6011450.63994 2118045.46213 37.7963940539012 -122.404400461805 (37.7963940539012, -122.404400461805) 3 1 10 308 4
150197 12586 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 446 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 4X4   5994034.10882 2114901.58036 37.7867731461033 -122.46443651291 (37.7867731461033, -122.46443651291) 11 6 1 54 11
159244 12589 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 501 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5993835.87193 2114839.30681 37.7865907308189 -122.465117835634 (37.7865907308189, -122.465117835634) 11 6 2 54 11
160088 5713 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1629 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   6005337.04528 2098854.62727 37.7433570946697 -122.424189297907 (37.7433570946697, -122.424189297907) 2 7 5 28859 22
161157 1584 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 653 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   5995606.55902 2111798.94869 37.7783446651954 -122.458771535508 (37.7783446651954, -122.458771535508) 11 6 2 54 11
161160 5458 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 589 Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2009 12:00:00 AM 90 3x3   6004996.57492 2104960.58209 37.7601033992601 -122.425801080858 (37.7601033992601, -122.425801080858) 2 4 5 28859 19
163868 24547 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 704 Cortland Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     90 3X4   6007976.32415 2097161.8833 37.7388578628999 -122.414943537915 (37.7388578628999, -122.414943537915) 2 7 7 28859 2
165872 5459 DPW Maintained 1 Schinus polygamus :: Chilean pepper tree 523 589 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 8X8   6004997.42906 2104935.20905 37.7600337791527 -122.425796320748 (37.7600337791527, -122.425796320748) 2 4 5 28859 19
167034 10495 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1701 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 3x3   5997835.7259 2108510.475 37.7694432404816 -122.450822883239 (37.7694432404816, -122.450822883239) 15 5 11 29492 9
173278 8147 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1000 Fulton St 3 Sidewalk: Curb side : Cutout Tree Private 2     90 4X4   6002886.96217 2111360.68278 37.7775570672136 -122.433554609066 (37.7775570672136, -122.433554609066) 15 5 11 29492 41
181464 11367 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52 1351X Ingalls St 6 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   6017270.42563 2093912.097264 37.730452470679 -122.38258247713 (37.730452470679, -122.38258247713) 10 3 8 58 1
186738 5699 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1569 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 6   6005313.38344 2099208.61144 37.7443277185515 -122.424296285742 (37.7443277185515, -122.424296285742) 2 7 5 28859 22
193814 23927 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1715 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 4X4   6003460.7841 2114695.1886 37.7867453258178 -122.431807713622 (37.7867453258178, -122.431807713622) 13 9 11 29490 27
23 50211 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 834 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/2003 12:00:00 AM 9   Permit Number 46919 5987605.33986 2110266.54313 37.7736739696217 -122.486337841964 (37.7736739696217, -122.486337841964) 11 6 2 55 26
118 236256 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 151 Valencia St 1 : Tree Private 2     9 Width 4ft   6006073.15075 2108915.83898 37.7710243776945 -122.422358744984 (37.7710243776945, -122.422358744984) 8 2 9 28853 19
145 193492 DPW Maintained 1 Maytenus boaria :: Mayten 58 1918 23rd St 1 Front Yard : Yard Tree Private 2     9     6012632.36685 2102863.5529 37.7547739610597 -122.399245141377 (37.7547739610597, -122.399245141377) 10 3 8 28856 29
189 178694 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 184 Mount Vernon Ave 7 Side Yard : Yard Tree Private 2     9     5998957.82756 2089383.479 37.7169892861082 -122.445565994978 (37.7169892861082, -122.445565994978) 9 7 6 28861 25
254 130309 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 95 Vallejo St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013009.60555 2119229.44522 37.7997319839043 -122.399089221411 (37.7997319839043, -122.399089221411) 3 1 10 28860 6
337 193188 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 401 Harrison St 6 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6014838.37703 2114321.79559 37.7863584598262 -122.392417493778 (37.7863584598262, -122.392417493778) 6 2 9 28855 6
369 138522 Undocumented 4 Tristania conferta :: 61 1602 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6001658.1955 2114019.9111 37.7847888393579 -122.437995843174 (37.7847888393579, -122.437995843174) 13 6 11 29490 13
497 133485 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 100 Spruce St 6 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5997070.63549 2115917.82612 37.7897380545196 -122.454004325646 (37.7897380545196, -122.454004325646) 11 6 1 54 31
500 230695 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 174 Hancock St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003158.12549 2105079.13528 37.7603248546353 -122.432167861868 (37.7603248546353, -122.432167861868) 2 4 5 28862 3
580 65382 DPW Maintained 1 Olea europaea :: Olive Tree 9 1709 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/29/1989 12:00:00 AM 9   Permit Number 28221 6000542.2902 2114603.4223 37.7863274878262 -122.441898393886 (37.7863274878262, -122.441898393886) 13 6 1 29490 27
619 177547 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1202 Sunnydale Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6008380.57452 2087049.08192 37.7111129665536 -122.412831047535 (37.7111129665536, -122.412831047535) 9 7 8 309 39
640 222906 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6004761.72453 2109824.22026 37.7734445081828 -122.42695971791 (37.7734445081828, -122.42695971791) 7 9 11 28852 10
729 203987 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1520 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992392.5651 2096889.45083 37.7372218288298 -122.46880462056 (37.7372218288298, -122.46880462056) 1 8 4 59 40
739 38480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2515 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1998 12:00:00 AM 9   Permit Number 40479 5999797.20513 2119471.52027 37.7996515161494 -122.444826245059 (37.7996515161494, -122.444826245059) 13 9 1 57 17
866 28332 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3247 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2004 12:00:00 AM 9 3x3   6006498.83651 2099346.51324 37.74477323292 -122.420207017141 (37.74477323292, -122.420207017141) 2 7 7 28859 2
924 168125 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2329 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999732.18095 2116962.81225 37.7927595589676 -122.444870818143 (37.7927595589676, -122.444870818143) 13 6 1 29490 27
950 72251 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 437 London St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6001865.6588 2091176.05062 37.7220768687262 -122.435643214558 (37.7220768687262, -122.435643214558) 9 7 6 28861 5
967 78568 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1192 Bowdoin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6009666.22083 2090670.9365 37.7211299140849 -122.408642858878 (37.7211299140849, -122.408642858878) 9 3 7 309 28
1065 180355 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1900 San Jose Ave 33 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999392.39561 2091826.25637 37.7237213933189 -122.444239347485 (37.7237213933189, -122.444239347485) 9 7 6 28861 25
1094 124411 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3906 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5996074.1747 2115241.80305 37.7878246921221 -122.457403032995 (37.7878246921221, -122.457403032995) 11 6 1 54 31
1098 31784 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 7 Alpine Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM 9   Permit Number 35255 6001631.05677 2108636.54376 37.7700059251571 -122.437704050605 (37.7700059251571, -122.437704050605) 15 5 5 29492 9
1099 138916 DPW Maintained 1 Tristania conferta :: 61 707 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6004396.0968 2110813.5411 37.7761402601039 -122.428295000541 (37.7761402601039, -122.428295000541) 7 9 11 28852 10
1115 238053 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 426 Lily St 2 : Tree Private 2     9 Width 3ft   6004459.53739 2109991.59452 37.7738869854343 -122.428016956418 (37.7738869854343, -122.428016956418) 7 9 11 28852 10
1123 72265 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 358 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6002353.80444 2091524.36294 37.7230609707806 -122.433980702666 (37.7230609707806, -122.433980702666) 9 7 6 28861 5
1196 41203 DPW Maintained 1 Olea europaea :: Olive Tree 9 18 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/24/1999 12:00:00 AM 9   Permit Number 41910 5993961.82877 2115413.43591 37.7881743948276 -122.464723766289 (37.7881743948276, -122.464723766289) 11 6 1 54 11
1225 70200 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 651 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6002623.55844 2089844.48662 37.7184637093015 -122.432928262055 (37.7184637093015, -122.432928262055) 9 7 6 28861 5
1240 860 DPW Maintained 1 Acer rubrum :: Red Maple 75 400X Alemany Blvd 6 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2003 12:00:00 AM 9 3x3   6008061.902 2095033.66744 37.7330190549875 -122.414497094675 (37.7330190549875, -122.414497094675) 2 7 7 28859 2
1280 191487 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 288 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010205.79697 2110974.44372 37.7769090816273 -122.408208942312 (37.7769090816273, -122.408208942312) 8 2 9 28853 34
1292 102259 DPW Maintained 1 Tree(s) :: 17 904 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2013 12:00:00 AM 9 3x3 Permit Number 769677 6003013.4 2111448.1 37.7778042661218 -122.433123466086 (37.7778042661218, -122.433123466086) 15 9 11 29492 41
1329 124750 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 566 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6004650.035 2110687.35997 37.7758081630602 -122.42740756863 (37.7758081630602, -122.42740756863) 7 9 11 28852 10
1362 244521 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 577 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003849.83 2109698.0755 37.7730465408764 -122.430105090767 (37.7730465408764, -122.430105090767) 7 9 11 29492 10
1462 225196 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007182.851 2103832.80652 37.7571300930895 -122.418159821127 (37.7571300930895, -122.418159821127) 2 4 7 28859 19
1485 70364 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4039 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     5982287.6338 2104871.478 37.7585492864556 -122.504332547004 (37.7585492864556, -122.504332547004) 1 8 3 56 35
1487 73682 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2232 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     5987047.2593 2102366.6287 37.7519504378009 -122.487687815073 (37.7519504378009, -122.487687815073) 1 8 3 56 35
1582 51483 DPW Maintained 1 Koelreuteria paniculata :: Golden Rain Tree 131 235 Berry St 1 Sidewalk: Curb side : Cutout Tree Private 2     9   Permit Number 47794 6014118.18221 2110089.57063 37.774697713467 -122.39461272721 (37.774697713467, -122.39461272721) 6 2 9 310 20

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