Street_Tree_List

Data source: data.sfgov.org

189,144 rows sorted by TreeID

View and edit SQL

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
111961 1 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 10 10th Ave 1 Median : Cutout 11 Tree 1 DPW 2     3 16   5992719.40718 2114869.71245 37.7866097734767 -122.46898271049601 (37.7866097734767, -122.468982710496)
93529 2 DPW Maintained 3 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 850X Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/25/2009 12:00:00 AM 3 3X3   5992872.52482 2114854.21479 37.78657606668221 -122.468451837381 (37.7865760666822, -122.468451837381)
124086 3 DPW Maintained 3 Podocarpus macrophyllus :: Yew Pine 168 2X 12th Ave 2 Median : Cutout 11 Tree 1 DPW 2     3 16   5992095.57585 2114853.19204 37.7865283500331 -122.471139790973 (37.7865283500331, -122.471139790973)
144529 4 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1101X Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     9 3X3   5992046.40751 2114771.53879 37.7863013087655 -122.471303948198 (37.7863013087655, -122.471303948198)
97457 6 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 4949X California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   5992285.036119999 2114103.37756 37.784480522922394 -122.470429683488 (37.7844805229224, -122.470429683488)
76128 10 DPW Maintained 3 Palm (unknown Genus) :: Palm Spp 161 97 12th St 4 Median : Cutout 11 Tree 1 DPW 2     20 3X3   6007166.5822125 2109668.7679164 37.7731533608049 -122.418629924651 (37.7731533608049, -122.418629924651)
118070 11 DPW Maintained 3 Palm (unknown Genus) :: Palm Spp 161 97 12th St 5 Median : Cutout 11 Tree 1 DPW 2     20 3X3   6007166.5822125 2109668.7679164 37.7731533608049 -122.418629924651 (37.7731533608049, -122.418629924651)
107073 12 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 97 12th St 6 Median : Cutout 11 Tree 1 DPW 2     3 3X3   6007166.5822125 2109668.7679164 37.7731533608049 -122.418629924651 (37.7731533608049, -122.418629924651)
110072 18 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2801X 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   5992314.354430901 2097139.1969018 37.737903049839396 -122.469093199098 (37.7379030498394, -122.469093199098)
114915 19 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2801X 14th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3X3   5992314.354430901 2097139.1969018 37.737903049839396 -122.469093199098 (37.7379030498394, -122.469093199098)
128627 20 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2810X 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 3X3   5992369.501524299 2097155.3271501 37.7379505257286 -122.468903703785 (37.7379505257286, -122.468903703785)
83534 21 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2810X 14th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 3X3   5992369.501524299 2097155.3271501 37.7379505257286 -122.468903703785 (37.7379505257286, -122.468903703785)
21370 22 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 725 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/18/2017 08:22:00 AM 3 3X3   6003898.66598 2107719.95316 37.7676178644975 -122.429795042015 (37.7676178644975, -122.429795042015)
20605 23 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 729 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/30/2011 12:00:00 AM 3 4x4   6003875.846919999 2107718.3128400003 37.7676120683604 -122.429873853201 (37.7676120683604, -122.429873853201)
19020 25 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 736 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/17/1995 12:00:00 AM 0     6003903.525084401 2107767.6234363 37.7677490306877 -122.429781635515 (37.7677490306877, -122.429781635515)
21692 26 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 736 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/12/1992 12:00:00 AM 12 3X3   6003885.725319999 2107769.72577 37.7677537952191 -122.4298433527 (37.7677537952191, -122.4298433527)
82272 27 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 740 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/2008 12:00:00 AM 3 3X3   6003877.1873918 2107766.1695161 37.767743547109106 -122.429872630659 (37.7677435471091, -122.429872630659)
126224 28 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 742 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/15/2011 12:00:00 AM 3 3x3   6003863.8671794 2107765.4342001 37.76774077377821 -122.42991865118601 (37.7677407737782, -122.429918651186)
23088 29 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 742 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3X3   6003854.77769 2107764.13441 37.7677366901162 -122.42994999788799 (37.7677366901162, -122.429949997888)
17231 30 Permitted Site 1 Lagerstroemia indica :: Crape Myrtle 199 750 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 1X1   6003777.42436 2107761.72523 37.7677256941011 -122.430217381651 (37.7677256941011, -122.430217381651)
19634 31 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 753 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/08/2016 06:04:00 AM 3 3X3   6003785.60824 2107710.67637 37.7675859898405 -122.430185432325 (37.7675859898405, -122.430185432325)
97182 32 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 753 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/08/2016 06:10:00 AM 3 3X3   6003820.6216400005 2107707.01694 37.7675779249973 -122.43006406443999 (37.7675779249973, -122.43006406444)
20666 33 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 755 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/17/1998 12:00:00 AM 3 3X3   6003762.7674 2107707.98129 37.7675772960935 -122.43026424352199 (37.7675772960935, -122.430264243522)
18331 34 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 759 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6003742.09963 2107707.8799900003 37.767575847275204 -122.430335723414 (37.7675758472752, -122.430335723414)
17593 35 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 765 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6003712.362269999 2107704.7999 37.767565705622296 -122.430438361268 (37.7675657056223, -122.430438361268)
20763 36 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 773 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6003693.31613 2107706.2481400003 37.7675686032223 -122.430504342717 (37.7675686032223, -122.430504342717)
21403 38 DPW Maintained 3 Maytenus boaria :: Mayten 22 775 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6003673.2104 2107707.71827 37.767571500863795 -122.430573990716 (37.7675715008638, -122.430573990716)
106390 39 Permitted Site 1 Maytenus boaria :: Mayten 22 783 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   6003606.5955195995 2107701.1557949 37.7675497079099 -122.430803934479 (37.7675497079099, -122.430803934479)
23112 40 Permitted Site 1 Maytenus boaria :: Mayten 22 784 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/1995 12:00:00 AM 14 2x3   6003610.50181 2107749.59526 37.7676829322386 -122.430793880335 (37.7676829322386, -122.430793880335)
21243 41 Permitted Site 1 Maytenus boaria :: Mayten 22 795 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   6003608.499480001 2107706.26027 37.767563831432206 -122.43079771324601 (37.7675638314322, -122.430797713246)
96931 42 Permitted Site 1 Maytenus boaria :: Mayten 22 795 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   6003531.1175202 2107696.9891434 37.7675339906335 -122.431064705472 (37.7675339906335, -122.431064705472)
21346 43 Permitted Site 1 Maytenus boaria :: Mayten 22 797 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   6003580.94003 2107704.3456099997 37.7675570127652 -122.43089290110001 (37.7675570127652, -122.4308929011)
82457 44 Permitted Site 1 Maytenus boaria :: Mayten 22 795 14th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   6003531.1175202 2107696.9891434 37.7675339906335 -122.431064705472 (37.7675339906335, -122.431064705472)
18465 45 DPW Maintained 3 Maytenus boaria :: Mayten 22 810 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/05/1990 12:00:00 AM 12 3X3   6003436.52432 2107742.06145 37.7676523876611 -122.431395108624 (37.7676523876611, -122.431395108624)
3771 47 DPW Maintained 3 Maytenus boaria :: Mayten 22 810 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/03/1998 12:00:00 AM 6 3X3   6003389.5525400005 2107739.47109 37.7676426129451 -122.431557393053 (37.7676426129451, -122.431557393053)
753 48 DPW Maintained 3 Maytenus boaria :: Mayten 22 810 14th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 3X3   6003376.13457 2107738.85817 37.767640169485105 -122.43160376032499 (37.7676401694851, -122.431603760325)
19936 50 DPW Maintained 3 Maytenus boaria :: Mayten 22 811 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X3   6003361.68382 2107697.25864 37.767525128208 -122.431650773269 (37.767525128208, -122.431650773269)
17746 51 Permitted Site 1 Maytenus boaria :: Mayten 22 811 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/1990 12:00:00 AM 18 3X3   6003382.24776 2107695.57838 37.767521680208205 -122.431579525381 (37.7675216802082, -122.431579525381)
17351 52 DPW Maintained 3 Maytenus boaria :: Mayten 22 814 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3X3   6003333.6015 2107734.84158 37.767626730010704 -122.43175058993201 (37.7676267300107, -122.431750589932)
18204 53 DPW Maintained 3 Maytenus boaria :: Mayten 22 819 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6003339.25774 2107690.1864099996 37.7675044384029 -122.431727837076 (37.7675044384029, -122.431727837076)
20057 54 DPW Maintained 3 Maytenus boaria :: Mayten 22 820 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6003308.16067 2107736.25671 37.7676291734667 -122.431838687528 (37.7676291734667, -122.431838687528)
97615 55 DPW Maintained 3 Maytenus boaria :: Mayten 22 825 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4X4   6003336.0552036 2107686.2210378996 37.7674933689218 -122.431738631065 (37.7674933689218, -122.431738631065)
110229 56 DPW Maintained 3 Maytenus boaria :: Mayten 22 828 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003308.2753875 2107734.7636253997 37.7676250803229 -122.431838184113 (37.7676250803229, -122.431838184113)
21020 57 DPW Maintained 3 Maytenus boaria :: Mayten 22 829 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   6003284.96574 2107687.1211099997 37.7674929441796 -122.43191540687 (37.7674929441796, -122.43191540687)
19565 58 DPW Maintained 3 Maytenus boaria :: Mayten 22 831 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6003255.09688 2107686.06346 37.767488346823896 -122.432018643671 (37.7674883468239, -122.432018643671)
20961 59 DPW Maintained 3 Maytenus boaria :: Mayten 22 839 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6003236.18776 2107686.4539 37.7674883468466 -122.432084075632 (37.7674883468466, -122.432084075632)
21094 60 Permitted Site 1 Maytenus boaria :: Mayten 22 842 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/1990 12:00:00 AM 12 3X3   6003241.42575 2107728.73521 37.7676047379919 -122.432068977808 (37.7676047379919, -122.432068977808)
81661 61 DPW Maintained 3 Maytenus boaria :: Mayten 22 843 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 4x4   6003222.9956732 2107679.9797688 37.7674698225277 -122.43212924287901 (37.7674698225277, -122.432129242879)
20459 62 DPW Maintained 3 Maytenus boaria :: Mayten 22 848 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003213.61389 2107723.52495 37.7675888550728 -122.43216480327101 (37.7675888550728, -122.432164803271)
116627 63 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 847 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/2015 12:00:00 AM 3 3X3   6003197.9718305 2107678.5983679 37.7674646107508 -122.43221569826001 (37.7674646107508, -122.43221569826)
19937 65 Permitted Site 1 Maytenus boaria :: Mayten 22 854 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/1990 12:00:00 AM 12 6x3.5   6003105.8355 2107716.44027 37.7675632909511 -122.432537088438 (37.7675632909511, -122.432537088438)
9061 66 Permitted Site 1 Maytenus boaria :: Mayten 22 854 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 5.5x3.5   6003138.2570065 2107725.378034 37.767589670380296 -122.432425585191 (37.7675896703803, -122.432425585191)
81768 69 DPW Maintained 3 Maytenus boaria :: Mayten 22 865 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3X3   6003077.949911701 2107671.9727494 37.7674396126058 -122.43263036424999 (37.7674396126058, -122.43263036425)
17374 70 DPW Maintained 3 Maytenus boaria :: Mayten 22 877 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6003041.605930001 2107668.70427 37.7674285769945 -122.432755839529 (37.7674285769945, -122.432755839529)
17083 71 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 878 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/02/2015 07:54:00 AM 3 3X3   6003035.3624 2107711.09825 37.767544626421106 -122.43278046386001 (37.7675446264211, -122.43278046386)
17177 72 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 878 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/03/2016 12:34:00 PM 3 3X3   6003020.08721 2107708.79941 37.7675374480197 -122.432833134452 (37.7675374480197, -122.432833134452)
17699 73 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 880 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 3X3   6002985.89482 2107705.84522 37.767527397193795 -122.432951190257 (37.7675273971938, -122.432951190257)
16954 74 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 888 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x3   6002936.546 2107706.34195 37.767525961893 -122.433121916663 (37.767525961893, -122.433121916663)
125538 75 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 888 14TH ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/1995 12:00:00 AM 40     6002921.0 2107736.0 37.7676065137922 -122.433177807531 (37.7676065137922, -122.433177807531)
85245 77 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 97X Noe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6002876.5924018 2107716.5314312 37.7675505386543 -122.433330016252 (37.7675505386543, -122.433330016252)
143619 78 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 97X Noe St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6002876.5924018 2107716.5314312 37.7675505386543 -122.433330016252 (37.7675505386543, -122.433330016252)
9078 79 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 899 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 3X3   6002864.319993401 2107660.1796498 37.767395114191295 -122.433368437593 (37.7673951141913, -122.433368437593)
9288 80 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 899 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6002864.319993401 2107660.1796498 37.767395114191295 -122.433368437593 (37.7673951141913, -122.433368437593)
128193 81 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 899 14th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/29/2001 12:00:00 AM 8 3X3   6002864.319993401 2107660.1796498 37.767395114191295 -122.433368437593 (37.7673951141913, -122.433368437593)
19455 82 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6002798.55883 2107703.57748 37.7675105430125 -122.43359899801901 (37.7675105430125, -122.433598998019)
17266 83 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/03/1997 12:00:00 AM 12 3X3   6002779.45804 2107702.26706 37.7675058611368 -122.433664971386 (37.7675058611368, -122.433664971386)
17770 84 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6002751.01782 2107698.1488200002 37.767492939684296 -122.43376304785102 (37.7674929396843, -122.433763047851)
20925 85 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6002730.58019 2107700.13974 37.7674972465285 -122.433833881131 (37.7674972465285, -122.433833881131)
19702 86 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 900X 14th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002711.6629800005 2107699.4849 37.7674943750014 -122.433899266359 (37.7674943750014, -122.433899266359)
21984 87 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 900X 14th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6002676.805380001 2107689.7475799997 37.767465660541 -122.43401913788999 (37.767465660541, -122.43401913789)
20448 88 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 900X 14th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002652.7260300005 2107693.38271 37.767474275148004 -122.434102684915 (37.767474275148, -122.434102684915)
18670 89 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3X3   6002626.96421 2107691.82359 37.7674685320657 -122.434191680018 (37.7674685320657, -122.434191680018)
19187 90 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3X3   6002594.42208 2107692.49628 37.7674685320724 -122.434304286835 (37.7674685320724, -122.434304286835)
18320 91 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3X3   6002566.003169999 2107689.4236 37.767458482149294 -122.43440236419399 (37.7674584821493, -122.434402364194)
18693 92 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3X3   6002538.15272 2107688.43049 37.7674541744033 -122.434498624009 (37.7674541744033, -122.434498624009)
18863 93 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   6002517.65025 2107687.28581 37.767449867535504 -122.43456945733699 (37.7674498675355, -122.434569457337)
21910 94 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 900X 14th St 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X3   6002488.782240001 2107687.88267 37.7674498675536 -122.434669350436 (37.7674498675536, -122.434669350436)
17531 95 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   6002436.73331 2107684.77563 37.7674383813948 -122.434849158187 (37.7674383813948, -122.434849158187)
17703 96 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3X3   6002409.38596 2107682.72677 37.7674312030188 -122.434943602286 (37.7674312030188, -122.434943602286)
20760 97 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 900X 14th St 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/03/1997 12:00:00 AM 12 3X3   6002378.86758 2107679.69737 37.767421152188604 -122.435048944375 (37.7674211521886, -122.435048944375)
17717 98 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6002352.6347900005 2107680.7629400003 37.7674225884029 -122.435139756108 (37.7674225884029, -122.435139756108)
20835 99 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 900X 14th St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3X3   6002314.25424 2107678.41928 37.767413973794795 -122.43527234134501 (37.7674139737948, -122.435272341345)
102626 102 DPW Maintained 3 Maytenus boaria :: Mayten 22 923 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6002700.4016261 2107651.1308054 37.767360967419705 -122.43393476112301 (37.7673609674197, -122.433934761123)
125395 103 DPW Maintained 3 Maytenus boaria :: Mayten 22 905 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002810.7304432 2107657.2213263 37.76738395094429 -122.433553584829 (37.7673839509443, -122.433553584829)
19112 104 DPW Maintained 3 Maytenus boaria :: Mayten 22 903 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6002728.05745 2107652.23665 37.7673655732026 -122.433839182638 (37.7673655732026, -122.433839182638)
140598 105 Permitted Site 1 Maytenus boaria :: Mayten 22 923 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/1996 12:00:00 AM 12 3X3   6002700.4016261 2107651.1308054 37.767360967419705 -122.43393476112301 (37.7673609674197, -122.433934761123)
19313 106 DPW Maintained 3 Maytenus boaria :: Mayten 22 927 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6002652.29309 2107649.54302 37.7673538775163 -122.434101048134 (37.7673538775163, -122.434101048134)
22155 107 DPW Maintained 3 Maytenus boaria :: Mayten 22 935 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6002622.320669999 2107648.0329400003 37.767348030106795 -122.434204610458 (37.7673480301068, -122.434204610458)
19208 108 DPW Maintained 3 Maytenus boaria :: Mayten 22 939 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6002600.95184 2107648.90078 37.7673492001289 -122.434278584211 (37.7673492001289, -122.434278584211)
3462 109 Permitted Site 1 Maytenus boaria :: Mayten 22 941 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3X3   6002569.29571 2107648.70327 37.767346860988 -122.434388064079 (37.767346860988, -122.434388064079)
17007 110 DPW Maintained 3 Maytenus boaria :: Mayten 22 945 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002532.89226 2107646.47434 37.767338674478104 -122.43451381896799 (37.7673386744781, -122.434513818968)
1581 111 DPW Maintained 3 Maytenus boaria :: Mayten 22 955 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6002518.0 2107623.0 37.767273374303706 -122.43456365047399 (37.7672733743037, -122.434563650474)
20713 112 DPW Maintained 3 Maytenus boaria :: Mayten 22 955 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6002510.55394 2107641.82471 37.7673246396489 -122.43459075148 (37.7673246396489, -122.43459075148)
20178 113 DPW Maintained 3 Maytenus boaria :: Mayten 22 959 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 3X3   6002493.042169999 2107643.0386799998 37.767326978783395 -122.43465140896002 (37.7673269787834, -122.43465140896)
20050 114 DPW Maintained 3 Maytenus boaria :: Mayten 22 963 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X3   6002475.041 2107641.28126 37.76732113139371 -122.434713546705 (37.7673211313937, -122.434713546705)
17754 115 DPW Maintained 3 Maytenus boaria :: Mayten 22 967 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X3   6002439.93798 2107639.87747 37.7673152840014 -122.434834862532 (37.7673152840014, -122.434834862532)
17850 116 Permitted Site 1 Maytenus boaria :: Mayten 22 973 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3X3   6002428.768680001 2107637.5526900003 37.7673082665764 -122.434873329236 (37.7673082665764, -122.434873329236)
18942 117 DPW Maintained 3 Maytenus boaria :: Mayten 22 975 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3X3   6002386.388619999 2107635.87333 37.767301249177606 -122.435019795532 (37.7673012491776, -122.435019795532)
95758 118 Permitted Site 1 Maytenus boaria :: Mayten 22 983 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/07/1997 12:00:00 AM 8 3X3   6002330.8302335 2107630.7292246004 37.767283969912796 -122.43521159584101 (37.7672839699128, -122.435211595841)
17513 119 DPW Maintained 3 Maytenus boaria :: Mayten 22 983 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 3X3   6002320.92055 2107634.67153 37.7672942317745 -122.43524615398701 (37.7672942317745, -122.435246153987)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 3185.739ms · Data source: data.sfgov.org