27,746 rows where qCaretaker_id = 1 sorted by qAddress

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)
56242 12380 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11   1 Sidewalk: Curb side : Cutout Tree DPW 1   09/17/2013 12:00:00 AM 3 3x3   6004345.46385 2113763.00934 37.7842359045501 -122.428680455521 (37.7842359045501, -122.428680455521) 13 9 11 29490 41
130779 14676 DPW Maintained 1 Acer rubrum 'Red Sunset' :: Red Swamp Maple 193   1 Sidewalk: Curb side : Cutout Tree DPW 1   05/12/2011 12:00:00 AM 3 4x4   6005306.03378 2112177.46067 37.7799366952092 -122.425244357372 (37.7799366952092, -122.425244357372) 7 9 11 28852 41
2382 255210 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1 Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
166760 2744 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 3X3   5995591.7347 2110770.58853 37.7755202080066 -122.458748349075 (37.7755202080066, -122.458748349075) 11 6 2 54 11
185346 3876 DPW Maintained 1 Maytenus boaria :: Mayten 58 1 Castro St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001972.79866 2108696.56564 37.7701901557853 -122.436526269672 (37.7701901557853, -122.436526269672) 15 5 5 29492 9
65097 110683 Undocumented 4 Robinia pseudoacacia :: Black Locust 286 1 EDDY ST 1 Median : Cutout Tree DPW 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
101109 110690 Undocumented 4 Robinia pseudoacacia :: Black Locust 286 1 EDDY ST 8 Median : Cutout Tree DPW 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
101272 110684 Undocumented 4 Robinia pseudoacacia :: Black Locust 286 1 EDDY ST 2 Median : Cutout Tree DPW 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
140351 110689 Undocumented 4 Robinia pseudoacacia :: Black Locust 286 1 EDDY ST 7 Median : Cutout Tree DPW 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
143278 110685 Undocumented 4 Robinia pseudoacacia :: Black Locust 286 1 EDDY ST 3 Median : Cutout Tree DPW 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
160617 110687 Undocumented 4 Robinia pseudoacacia :: Black Locust 286 1 EDDY ST 5 Median : Cutout Tree DPW 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
187514 110688 Undocumented 4 Robinia pseudoacacia :: Black Locust 286 1 EDDY ST 6 Median : Cutout Tree DPW 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
171910 91184 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Fell St 4 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM 5   Permit Number 51891 6007394.40571 2110929.76906 37.776628592972 -122.417931258428 (37.776628592972, -122.417931258428) 7 9 9 28852 36
26353 12949 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Lindsay Cir 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016403.18992 2095651.77267 37.7351813255446 -122.385701866655 (37.7351813255446, -122.385701866655) 10 3 8 58 1
860 9301 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1 Mansell St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6011832.70408 2090706.21234 37.7213478755834 -122.401156387751 (37.7213478755834, -122.401156387751) 10 7 8 309 28
46006 9300 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Mansell St 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/10/1992 12:00:00 AM 12 3X3   6011786.56982 2090691.56369 37.7213050795375 -122.401314833019 (37.7213050795375, -122.401314833019) 10 7 8 309 28
92947 9299 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Mansell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6011744.95061 2090679.05023 37.7212683980005 -122.401457820749 (37.7212683980005, -122.401457820749) 10 7 8 309 28
2955 13425 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 9 Sidewalk: Curb side : Cutout Tree DPW 1   02/10/2007 12:00:00 AM 25 4x4   6014152.78687 2117194.52143 37.7942082021958 -122.394990759026 (37.7942082021958, -122.394990759026) 12 2 9 28855 6
13225 13427 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 11 Sidewalk: Curb side : Cutout Tree DPW 1     30 4x4   6014172.84776 2117212.91542 37.7942598232708 -122.394922634488 (37.7942598232708, -122.394922634488) 12 2 9 28855 6
29193 13426 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 10 Sidewalk: Curb side : Cutout Tree DPW 1   10/29/2003 12:00:00 AM 8 4x4   6014161.01916 2117188.17749 37.7941912409866 -122.394961829643 (37.7941912409866, -122.394961829643) 12 2 9 28855 6
60823 13430 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 14 Sidewalk: Curb side : Cutout Tree DPW 1     20 4x4   6014204.72202 2117228.65304 37.7943048073789 -122.394813447799 (37.7943048073789, -122.394813447799) 12 2 9 28855 6
68686 13428 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 12 Sidewalk: Curb side : Cutout Tree DPW 1   10/29/2003 12:00:00 AM 6 4x4   6014180.24954 2117205.51401 37.7942399123011 -122.394896504683 (37.7942399123011, -122.394896504683) 12 2 9 28855 6
91640 13420 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/18/1991 12:00:00 AM 30 4x4   6014066.39965 2117110.59561 37.7939729575322 -122.395283788713 (37.7939729575322, -122.395283788713) 12 2 9 28855 6
101042 13424 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 8 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/2003 12:00:00 AM 20 4x4   6014140.16579 2117170.60528 37.7941418322359 -122.395032753763 (37.7941418322359, -122.395032753763) 12 2 9 28855 6
110833 13423 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 7 Sidewalk: Curb side : Cutout Tree DPW 1   12/12/2002 12:00:00 AM 20 4x4   6014116.98151 2117144.48589 37.7940688252683 -122.395111144077 (37.7940688252683, -122.395111144077) 12 2 9 28855 6
118223 13429 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 13 Sidewalk: Curb side : Cutout Tree DPW 1     25 4x4   6014197.04513 2117235.79144 37.7943239809064 -122.394840511095 (37.7943239809064, -122.394840511095) 12 2 9 28855 6
121357 13419 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 3 Sidewalk: Curb side : Cutout Tree DPW 1   09/10/1991 12:00:00 AM 20 4x4   6014048.53109 2117080.60856 37.7938896263516 -122.395343514492 (37.7938896263516, -122.395343514492) 12 2 9 28855 6
139303 13422 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 6 Sidewalk: Curb side : Cutout Tree DPW 1   02/10/2007 12:00:00 AM 3 4x4   6014092.01898 2117123.77404 37.7940105671925 -122.39519606617 (37.7940105671925, -122.39519606617) 12 2 9 28855 6
157457 27316 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1     35 4x4   6014028.45913 2117061.6774 37.7938365294714 -122.395411639052 (37.7938365294714, -122.395411639052) 12 2 9 28855 6
163365 13418 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1     40 4x4   6014042.20206 2117087.71971 37.7939087999011 -122.395365912104 (37.7939087999011, -122.395365912104) 12 2 9 28855 6
184834 13421 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1 Market St 5 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/1991 12:00:00 AM 30 4x4   6014072.44813 2117102.953 37.7939523091002 -122.395262324595 (37.7939523091002, -122.395262324595) 12 2 9 28855 6
20190 90411 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1 McCoppin St 4 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2008 12:00:00 AM 3 3x3   6006552.3 2109010.7 37.771311860318 -122.420708085152 (37.771311860318, -122.420708085152) 8 2 9 28853 19
21325 90408 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1 McCoppin St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2008 12:00:00 AM 3 3x3   6006661.144462 2109154.301371 37.7717122894321 -122.420341780693 (37.7717122894321, -122.420341780693) 8 2 9 28853 19
129046 90410 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1 McCoppin St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2008 12:00:00 AM 3 3x3   6006661.144462 2109154.301371 37.7717122894321 -122.420341780693 (37.7717122894321, -122.420341780693) 8 2 9 28853 19
131860 90409 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1 McCoppin St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2008 12:00:00 AM 3 3x3   6006661.144462 2109154.301371 37.7717122894321 -122.420341780693 (37.7717122894321, -122.420341780693) 8 2 9 28853 19
103003 15076 DPW Maintained 1 Washingtonia robusta :: Mexican Fan Palm 72 1 Minerva St 2 Median : Cutout Tree DPW 1     6 11   5995952.59829 2089005.63171 37.7157797770894 -122.455926258705 (37.7157797770894, -122.455926258705) 9 8 6 28861 24
165898 15067 DPW Maintained 1 Washingtonia robusta :: Mexican Fan Palm 72 1 Minerva St 9 Median : Cutout Tree DPW 1     3 11   5996019.74584 2089003.9616 37.7157790450506 -122.455694046564 (37.7157790450506, -122.455694046564) 9 8 6 28861 24
9426 107555 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
14319 107554 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
32524 107556 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
36574 107552 Significant Tree 6 Tree(s) :: 17 1 Newhall St 2 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
38316 107558 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
40220 107562 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 2 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
46702 107564 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 8 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
56372 107551 Significant Tree 6 Tree(s) :: 17 1 Newhall St 1 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
60676 107559 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 10 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
96373 107561 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 12 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
98721 107560 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 11 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
119862 107553 Significant Tree 6 Tree(s) :: 17 1 Newhall St 3 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
168696 107563 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 5 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
180086 107557 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
100787 253125 DPW Maintained 1 Acer japonicum :: Japanese Maple 124 1 Oak Park Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   5996419 2103319 37.7551075738744 -122.455348004876 (37.7551075738744, -122.455348004876) 1 5 4 63 12
19694 91181 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 8 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
36901 91180 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 7 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
65819 91179 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 6 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
141293 91178 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 Polk St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Private 10/16/2008 12:00:00 AM     Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
192979 89262 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1 Polk St   Sidewalk: Curb side : Cutout Tree DPW 1       3x3 Permit Number 51891 6007302.316366 2111625.640546 37.7785341058364 -122.418299173193 (37.7785341058364, -122.418299173193) 7 9 9 28852 36
96809 189798 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     17 Width 3ft   6010293.93626 2108038.50565 37.7688526102954 -122.407696978027 (37.7688526102954, -122.407696978027) 8 4 8 28853 19
189326 139587 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1 Saint Joseph's Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     11 Width 0ft   6000732.3602 2112121.031 37.7795223070318 -122.441062642932 (37.7795223070318, -122.441062642932) 15 5 1 29490 16
45014 22801 DPW Maintained 1 Tree(s) :: 17 1 Turquoise Way 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/12/1997 12:00:00 AM 3 2x2   5998832.3639753 2099992.0164602 37.7461106679667 -122.446762549602 (37.7461106679667, -122.446762549602) 2 7 5 63 22
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
121742 1389 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 10 Ardath Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X4   6017228.6912616 2095462.3520099 37.7347068580177 -122.382834602513 (37.7347068580177, -122.382834602513) 10 3 8 58 1
14982 26911 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 10 Caine Ave 7 Median : Cutout Tree DPW 1     18 10   5997609.86555 2089654.44991 37.7176562610968 -122.450244747607 (37.7176562610968, -122.450244747607) 9 8 6 28861 24
21304 26912 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 Caine Ave 8 Median : Cutout Tree DPW 1     50 10   5997598.31865 2089637.50605 37.7176090763688 -122.450283439137 (37.7176090763688, -122.450283439137) 9 8 6 28861 24
36869 26909 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 Caine Ave 5 Median : Cutout Tree DPW 1     18 10   5997629.54091 2089680.97756 37.7177302258428 -122.450178650143 (37.7177302258428, -122.450178650143) 9 8 6 28861 24
78290 26905 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 Caine Ave 1 Median : Cutout Tree DPW 1     12 10   5997683.40035 2089758.81084 37.7179470200262 -122.449998089654 (37.7179470200262, -122.449998089654) 9 8 6 28861 24
82134 26913 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 Caine Ave 9 Median : Cutout Tree DPW 1     24 10   5997584.35365 2089616.43233 37.7175504135998 -122.45033019131 (37.7175504135998, -122.45033019131) 9 8 6 28861 24
82713 26914 DPW Maintained 1 Yucca gloriosa :: Spanish Dagger 126 10 Caine Ave 10 Median : Cutout Tree DPW 1     12 10   5997577.15723 2089606.82913 37.7175236335794 -122.450354374056 (37.7175236335794, -122.450354374056) 9 8 6 28861 24
84206 26910 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 Caine Ave 6 Median : Cutout Tree DPW 1     12 10   5997620.43146 2089669.09204 37.7176970696553 -122.450209281034 (37.7176970696553, -122.450209281034) 9 8 6 28861 24
103542 26915 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 10 Caine Ave 11 Median : Cutout Tree DPW 1   01/26/1999 12:00:00 AM 3 10   5997570.4467 2089598.14436 37.7174994031582 -122.450376943463 (37.7174994031582, -122.450376943463) 9 8 6 28861 24
121848 26906 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 Caine Ave 2 Median : Cutout Tree DPW 1     24 10   5997668.87346 2089736.17467 37.7178840350953 -122.450046671911 (37.7178840350953, -122.450046671911) 9 8 6 28861 24
154978 26908 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 Caine Ave 4 Median : Cutout Tree DPW 1     18 10   5997639.65043 2089696.09364 37.7177723096208 -122.45014479517 (37.7177723096208, -122.45014479517) 9 8 6 28861 24
189000 26907 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 Caine Ave 3 Median : Cutout Tree DPW 1     18 10   5997653.71656 2089718.57825 37.7178348520782 -122.450097794787 (37.7178348520782, -122.450097794787) 9 8 6 28861 24
64315 14623 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 10 Matthew Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/1998 12:00:00 AM 6 3X4   6018016.8978124 2094239.2837712 37.7313920698281 -122.380024515102 (37.7313920698281, -122.380024515102) 10 3 8 58 1
44764 255383 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 10 Niagara Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   11/10/2018 05:26:00 AM 3 3x3   6000028 2088914 37.7157612418296 -122.44183326031 (37.7157612418296, -122.44183326031) 9 7 6 28861 25
123010 255382 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 10 Niagara Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/10/2018 05:26:00 AM 3 3x3   6000028 2088914 37.7157612418296 -122.44183326031 (37.7157612418296, -122.44183326031) 9 7 6 28861 25
127914 255380 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 10 Niagara Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/10/2018 05:26:00 AM 3 3x3   6000028 2088914 37.7157612418296 -122.44183326031 (37.7157612418296, -122.44183326031) 9 7 6 28861 25
183367 255381 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 10 Niagara Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/10/2018 05:26:00 AM 3 3x3   6000028 2088914 37.7157612418296 -122.44183326031 (37.7157612418296, -122.44183326031) 9 7 6 28861 25
34680 4896 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 10 Rosie Lee Ln 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/11/1999 12:00:00 AM 6 3X4   6018106.77773 2094390.54536 37.7318123626362 -122.379724285267 (37.7318123626362, -122.379724285267) 10 3 8 58 1
37266 4898 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 10 Rosie Lee Ln 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X4   6017985.0017 2094485.55993 37.7320665362465 -122.380151894906 (37.7320665362465, -122.380151894906) 10 3 8 58 1
71509 4895 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 10 Rosie Lee Ln 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/19/1993 12:00:00 AM 12 3X4   6018140.88218 2094365.07214 37.7317442992597 -122.379604608867 (37.7317442992597, -122.379604608867) 10 3 8 58 1
180093 4897 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 10 Rosie Lee Ln 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X4   6018099.28954 2094405.02636 37.731851711586 -122.37975117949 (37.731851711586, -122.37975117949) 10 3 8 58 1
8417 259628 DPW Maintained 1 :: 45 100 Britton St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3     6008465.19154 2087632.83273 37.7127205750598 -122.412579828323 (37.7127205750598, -122.412579828323) 9 7 8 309 39
150275 28300 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100 Broad St 2 Sidewalk: Curb side : Cutout Tree DPW 1     13 3X3   5995887 2088090 37.713261901345 -122.456086835381 (37.713261901345, -122.456086835381) 9 8 6 28861 24
49778 3797 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 Cashmere St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6016837.41936 2095915.09048 37.7359283617946 -122.384218895383 (37.7359283617946, -122.384218895383) 10 3 8 58 1
117699 3796 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 Cashmere St 1 Sidewalk: Curb side : Cutout Tree DPW 1     1 3X3   6016917.42909 2095896.09045 37.7358806149833 -122.383940944619 (37.7358806149833, -122.383940944619) 10 3 8 58 1
39460 187613 DPW Maintained 1 Podocarpus macrophyllus :: Yew Pine 137 100 Castro St 10 Sidewalk: Property side : Cutout Tree DPW 1       3x3   6002192 2107639 37.767298794762 -122.435692380838 (37.767298794762, -122.435692380838) 15 5 5 28862 3
130728 187615 DPW Maintained 1 Podocarpus macrophyllus :: Yew Pine 137 100 Castro St 12 Sidewalk: Property side : Cutout Tree DPW 1       3x3   6002192 2107639 37.767298794762 -122.435692380838 (37.767298794762, -122.435692380838) 15 5 5 28862 3
164933 187614 DPW Maintained 1 Podocarpus macrophyllus :: Yew Pine 137 100 Castro St 11 Sidewalk: Property side : Cutout Tree DPW 1       3x3   6002192 2107639 37.767298794762 -122.435692380838 (37.767298794762, -122.435692380838) 15 5 5 28862 3
167452 187612 DPW Maintained 1 Podocarpus macrophyllus :: Yew Pine 137 100 Castro St 1 Sidewalk: Property side : Cutout Tree DPW 1       3x3   6002192 2107639 37.767298794762 -122.435692380838 (37.767298794762, -122.435692380838) 15 5 5 28862 3
14287 4591 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     2 3x2   6011425.16703 2118064.77563 37.796445660597 -122.404489964152 (37.796445660597, -122.404489964152) 3 1 10 308 4
117005 4592 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 100 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2016 01:42:00 PM 3 3x3   6011401.07939 2118088.92644 37.7965106267297 -122.404575013953 (37.7965106267297, -122.404575013953) 3 1 10 308 4
10670 258171 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 100 Dartmouth St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     6008455.21796 2093605.41918 37.7291194808141 -122.413036341511 (37.7291194808141, -122.413036341511) 9 3 7 309 28
14858 171814 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 100 Dartmouth St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6008473.26376 2093533.30473 37.7289224829841 -122.412968858728 (37.7289224829841, -122.412968858728) 9 3 7 309 28
18349 171813 DPW Maintained 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 100 Dartmouth St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 Width 3ft   6008462.06709 2093570.22923 37.7290232412306 -122.413010176287 (37.7290232412306, -122.413010176287) 9 3 7 309 28
33986 24963 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 Dolores St 4 Median : Cutout Tree DPW 1     90 20   6004800.73696 2107633.50365 37.7674315357679 -122.42666873509 (37.7674315357679, -122.42666873509) 8 4 5 28862 3
83756 24968 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 Dolores St 9 Median : Cutout Tree DPW 1     90 20   6004810.58196 2107534.13104 37.7671592390347 -122.426627605497 (37.7671592390347, -122.426627605497) 8 4 5 28862 3
90075 24962 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 Dolores St 3 Median : Cutout Tree DPW 1   04/21/2005 12:00:00 AM 30 20   6004805.8872 2107667.07109 37.7675239950663 -122.42665331172 (37.7675239950663, -122.42665331172) 8 4 5 28862 3
107384 24965 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 Dolores St 6 Median : Cutout Tree DPW 1     90 20   6004804.04595 2107595.6918 37.767327900586 -122.426654596838 (37.767327900586, -122.426654596838) 8 4 5 28862 3
116655 24966 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 100 Dolores St 7 Median : Cutout Tree DPW 1     90 20   6004812.73188 2107584.41194 37.7672974198587 -122.426623750096 (37.7672974198587, -122.426623750096) 8 4 5 28862 3

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