Street_Tree_List

Data source: data.sfgov.org

233 rows where qLegalStatus = 3 and qSpecies = 39 sorted by qCaretaker

View and edit SQL

Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes

qLegalStatus

  • DPW Maintained · 233
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker ▼ qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
104 251210 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1170 Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1992 12:00:00 AM                
340 191854 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 573 10th St 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     24 Width 6ft tree is in ROW therefore DPW maintained 6009977.72395 2108375.30106 37.7697596664942 -122.408814503513 (37.7697596664942, -122.408814503513)
389 191855 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 573 10th St 2 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     49 Width 6ft Cal Trans adjacent; 10 ft ROW 6009921.77605 2108434.69103 37.7699196037317 -122.409012217656 (37.7699196037317, -122.409012217656)
4668 253644 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200x La Salle Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 11/05/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4669 253646 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200x La Salle Ave 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 11/09/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4684 253645 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200x La Salle Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 03/11/2006 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
5380 23543 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2800X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2     35 9   6005659.04127 2120027.6333 37.8015112413055 -122.424581715282 (37.8015112413055, -122.424581715282)
6534 23551 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2900X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2     30     6005612.78895 2120375.11437 37.802462723129395 -122.424766503478 (37.8024627231294, -122.424766503478)
7152 29781 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2000X Van Ness Ave 3 Median : Cutout 11 Tree 1 DPW 2   03/12/2006 12:00:00 AM 3     6006021.95745 2117391.75426 37.7942942736085 -122.42313839334601 (37.7942942736085, -122.423138393346)
8259 23442 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2100X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2     24 9   6005990.50725 2117651.28863 37.795005114851 -122.42326567258301 (37.795005114851, -122.423265672583)
10299 1295 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4000X Alemany Blvd 3 Median : Cutout 11 Tree 1 DPW 2     25 10   5991914.74417 2087134.82891 37.710410426081 -122.46974669545901 (37.710410426081, -122.469746695459)
10727 1298 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4000X Alemany Blvd 6 Median : Cutout 11 Tree 1 DPW 2     25 10   5991889.9079 2087118.85792 37.7103651380077 -122.46983137204599 (37.7103651380077, -122.469831372046)
10785 1296 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4000X Alemany Blvd 4 Median : Cutout 11 Tree 1 DPW 2     35 10   5991907.39965 2087130.17274 37.710397216839496 -122.46977174067499 (37.7103972168395, -122.469771740675)
10821 1299 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4000X Alemany Blvd 7 Median : Cutout 11 Tree 1 DPW 2     40 10   5991881.88808 2087114.90346 37.7103538164401 -122.46985880224301 (37.7103538164401, -122.469858802243)
11437 1297 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4000X Alemany Blvd 5 Median : Cutout 11 Tree 1 DPW 2     25 10   5991899.37983 2087126.21827 37.7103858952584 -122.46979917089199 (37.7103858952584, -122.469799170892)
13889 11219 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1050X Ingalls St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/28/1992 12:00:00 AM 30 3X4   6018141.66576 2094727.81231 37.7327403559813 -122.379627091035 (37.7327403559813, -122.379627091035)
14018 99640 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1000X Gilman Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3x3 City Owned Lot 6015553.4063 2089548.4030000002 37.7183756251523 -122.38821408703001 (37.7183756251523, -122.38821408703)
14069 11218 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1050X Ingalls St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     70 3X4   6018145.287959999 2094715.08165 37.73270559986911 -122.379613683941 (37.7327055998691, -122.379613683941)
14285 11226 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1050X Ingalls St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/29/1992 12:00:00 AM 35 3X4   6018091.97554 2094860.3210200001 37.7331014580651 -122.379808087687 (37.7331014580651, -122.379808087687)
14426 4895 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 Rosie Lee Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/19/1993 12:00:00 AM 12 3X4   6018140.882180001 2094365.07214 37.7317442992597 -122.379604608867 (37.7317442992597, -122.379604608867)
14846 11225 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1050X Ingalls St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/29/1992 12:00:00 AM 35 3X4   6018100.6161400005 2094835.81488 37.733034645636394 -122.37977651247101 (37.7330346456364, -122.379776512471)
15149 22069 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2955 03rd St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/18/2000 12:00:00 AM 3 3X3   6015996.14125 2101854.73781 37.7521908608401 -122.387541804919 (37.7521908608401, -122.387541804919)
16239 22065 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2955 03rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/01/2000 12:00:00 AM 3 3X3   6016001.4583 2101755.32387 37.7519181854896 -122.387516482698 (37.7519181854896, -122.387516482698)
16356 11215 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1050X Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X4   6018142.31163 2094695.6186 37.732651993985705 -122.37962262229799 (37.7326519939857, -122.379622622298)
16446 22064 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2955 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/01/2000 12:00:00 AM 3 3X3   6016002.11901 2101736.21307 37.751865747830294 -122.38751286473301 (37.7518657478303, -122.387512864733)
16458 11221 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1050X Ingalls St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X4   6018130.45859 2094749.06198 37.7327980852604 -122.379667313208 (37.7327980852604, -122.379667313208)
16971 4468 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1497 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004583.98516 2100211.8834700002 37.7470412591526 -122.426889829809 (37.7470412591526, -122.426889829809)
17146 2013 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 500X Bosworth St 6 Median : Cutout 11 Tree 1 DPW 2     12 10   6002577.1884699995 2095292.92439 37.7334212632741 -122.433477690263 (37.7334212632741, -122.433477690263)
17205 26909 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 Caine Ave 5 Median : Cutout 11 Tree 1 DPW 2     18 10   5997629.54091 2089680.9775599998 37.71773022584279 -122.45017865014299 (37.7177302258428, -122.450178650143)
17236 19195 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 150 Sanchez St 2 Median : Cutout 11 Tree 1 DPW 2     24 3X3   6003512.4095 2107418.3103 37.76676774608121 -122.431109521045 (37.7667677460812, -122.431109521045)
17237 26912 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 Caine Ave 8 Median : Cutout 11 Tree 1 DPW 2     50 10   5997598.31865 2089637.50605 37.7176090763688 -122.450283439137 (37.7176090763688, -122.450283439137)
17421 4245 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4038 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003639.78589 2100421.5344700003 37.7475634792894 -122.430169743652 (37.7475634792894, -122.430169743652)
18452 10752 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1120X Hudson Ave 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
18851 22861 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 151 Turquoise Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X2   5999939.19286 2099172.51002 37.7439236657612 -122.44287645099199 (37.7439236657612, -122.442876450992)
19083 26913 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 Caine Ave 9 Median : Cutout 11 Tree 1 DPW 2     24 10   5997584.35365 2089616.43233 37.717550413599795 -122.45033019131 (37.7175504135998, -122.45033019131)
19195 26910 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 Caine Ave 6 Median : Cutout 11 Tree 1 DPW 2     12 10   5997620.43146 2089669.0920400003 37.7176970696553 -122.45020928103399 (37.7176970696553, -122.450209281034)
19231 2011 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 500X Bosworth St 4 Median : Cutout 11 Tree 1 DPW 2     12 10   6002543.1242 2095301.43659 37.7334427031002 -122.433596068029 (37.7334427031002, -122.433596068029)
19342 26905 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 Caine Ave 1 Median : Cutout 11 Tree 1 DPW 2     12 10   5997683.40035 2089758.8108400002 37.7179470200262 -122.449998089654 (37.7179470200262, -122.449998089654)
19416 2014 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 500X Bosworth St 7 Median : Cutout 11 Tree 1 DPW 2     18 10   6002609.44021 2095285.23051 37.733401967419205 -122.43336563743799 (37.7334019674192, -122.433365637438)
19420 12067 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1225X La Salle Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6017323.1868972 2094393.2571117 37.7317765554235 -122.38243353641701 (37.7317765554235, -122.382433536417)
19538 16588 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 88X Noe St 2 Median : Cutout 11 Tree 1 DPW 2     6 3X3   6002852.6033 2107735.26664 37.7676006199961 -122.43341433031401 (37.7676006199961, -122.433414330314)
19568 26708 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 88X Noe St 1 Median : Cutout 11 Tree 1 DPW 2     12 3   6002857.07874 2107723.1475299997 37.767567597789295 -122.43339798423 (37.7675675977893, -122.43339798423)
19977 29369 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 500X Bosworth St 9 Median : Cutout 11 Tree 1 DPW 2   07/06/2005 12:00:00 AM 3 3X3   6002638.340030001 2095276.9082799999 37.733380755998894 -122.43326512830099 (37.7333807559989, -122.433265128301)
20093 2015 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 500X Bosworth St 8 Median : Cutout 11 Tree 1 DPW 2     12 10   6002627.0989 2095279.66022 37.733387674484604 -122.433304188563 (37.7333876744846, -122.433304188563)
20209 4252 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 4072 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003430.396430001 2100411.11399 37.747523005287206 -122.430893055767 (37.7475230052872, -122.430893055767)
20603 26906 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 Caine Ave 2 Median : Cutout 11 Tree 1 DPW 2     24 10   5997668.873459999 2089736.17467 37.717884035095295 -122.450046671911 (37.7178840350953, -122.450046671911)
20904 12016 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1230X La Salle Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/09/1992 12:00:00 AM 6 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438)
21291 2046 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 701X Bosworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6001912.87216 2095420.3332200001 37.733733385587 -122.43578352768299 (37.733733385587, -122.435783527683)
21305 26908 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 Caine Ave 4 Median : Cutout 11 Tree 1 DPW 2     18 10   5997639.65043 2089696.09364 37.7177723096208 -122.45014479517 (37.7177723096208, -122.45014479517)
21568 2012 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 500X Bosworth St 5 Median : Cutout 11 Tree 1 DPW 2     18 10   6002566.51434 2095294.967 37.7334262662011 -122.43351473961599 (37.7334262662011, -122.433514739616)
21645 26907 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 10 Caine Ave 3 Median : Cutout 11 Tree 1 DPW 2     18 10   5997653.71656 2089718.57825 37.717834852078205 -122.45009779478701 (37.7178348520782, -122.450097794787)
21793 29370 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 500X Bosworth St 10 Median : Cutout 11 Tree 1 DPW 2   07/06/2005 12:00:00 AM 3 3X3   6002650.152480001 2095274.05972 37.733373604614 -122.433224085933 (37.733373604614, -122.433224085933)
22187 4461 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1451 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6004572.77209 2100404.42204 37.74756929159079 -122.42694231424299 (37.7475692915908, -122.426942314243)
22854 176359 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 350x Winding Way 8 Median : Cutout 11 Tree 1 DPW 2     19 Width 0ft   6001093.21408 2086592.19305 37.7094467152559 -122.437985185864 (37.7094467152559, -122.437985185864)
23224 4372 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1007 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 3X3   6000961.422590001 2096155.46194 37.7356977864326 -122.439125632357 (37.7356977864326, -122.439125632357)
32359 191816 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1300x De Haro St 2 Median : Yard 3 Tree 1 DPW 2     18     6012277.20441 2102232.55885 37.7530215888816 -122.40042907904899 (37.7530215888816, -122.400429079049)
33183 209132 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Bosworth St 18 Median : Yard 3 Tree 1 DPW 2     22 Width 10ft   6001073.50305 2095703.1639599998 37.7344622582302 -122.438705728106 (37.7344622582302, -122.438705728106)
35512 249464 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Van Ness Ave 2 Median : Yard 3 Tree 1 DPW 2     24     6006534.583819999 2113721.77463 37.7842463336479 -122.421103932595 (37.7842463336479, -122.421103932595)
37159 249463 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Van Ness Ave 1 Median : Yard 3 Tree 1 DPW 2     27     6006539.42856 2113694.50869 37.7841717411666 -122.421085234814 (37.7841717411666, -122.421085234814)
38339 8592 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2355X Geary Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6000490.27762 2113338.60243 37.7828516547291 -122.44198752522699 (37.7828516547291, -122.441987525227)
41196 209133 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Bosworth St 19 Median : Yard 3 Tree 1 DPW 2     25     6001054.84945 2095714.1457200001 37.734491350384005 -122.43877100628 (37.734491350384, -122.43877100628)
44401 126600 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1820x Van Ness Ave 6 Median : Yard 3 Tree 1 DPW 2     19     6006102.71241 2116870.57968 37.7928678157445 -122.42282191472201 (37.7928678157445, -122.422821914722)
47273 10756 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1120X Hudson Ave 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
49627 4480 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1544 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004537.43405 2099923.54921 37.7462469275435 -122.427030266568 (37.7462469275435, -122.427030266568)
50215 209138 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Bosworth St 24 Median : Yard 3 Tree 1 DPW 2     24     6000918.34106 2095790.55513 37.7346933857729 -122.439248434772 (37.7346933857729, -122.439248434772)
50311 209137 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Bosworth St 23 Median : Yard 3 Tree 1 DPW 2     24     6000977.0463 2095762.1119400002 37.734618627848796 -122.43904343343 (37.7346186278488, -122.43904343343)
58168 209136 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Bosworth St 22 Median : Yard 3 Tree 1 DPW 2     27     6000997.1554 2095746.93377 37.7345780962937 -122.438972822257 (37.7345780962937, -122.438972822257)
59293 209131 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Bosworth St 17 Median : Yard 3 Tree 1 DPW 2     28 Width 10ft   6001087.056530001 2095697.8346 37.734448396084396 -122.43865848761699 (37.7344483960844, -122.438658487617)
67936 209179 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 255x San Marcos Ave 6 Median : Cutout 11 Tree 1 DPW 2     14 Width 5ft   5993078.87861 2100249.74193 37.7464879656554 -122.46667592616998 (37.7464879656554, -122.46667592617)
72160 10810 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1139X Hudson Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x4   6017615.78501 2094776.3050099998 37.7328444878546 -122.38144858171499 (37.7328444878546, -122.381448581715)
72215 11275 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1176X Ingalls St 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
73439 249465 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 900x Van Ness Ave 3 Median : Yard 3 Tree 1 DPW 2     26     6006528.896380001 2113762.4002 37.78435756088879 -122.421126494805 (37.7843575608888, -122.421126494805)
76168 2148 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1100X Bosworth St 9 Median : Cutout 11 Tree 1 DPW 2     12 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
77361 17319 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 98X Otis St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6006649.48331 2109199.16396 37.7718348142851 -122.42038530226101 (37.7718348142851, -122.420385302261)
77440 23201 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 538X Van Ness Ave 3 Median : Cutout 11 Tree 1 DPW 2     30 9   6006777.891315901 2112378.9819314997 37.7805730648795 -122.420166841786 (37.7805730648795, -122.420166841786)
77827 11247 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1145X Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/09/2003 12:00:00 AM 8 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
77931 10799 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1139X Hudson Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 3x4   6017498.59701 2094875.2630099999 37.733109736403705 -122.381860615174 (37.7331097364037, -122.381860615174)
78253 12004 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1230X La Salle Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438)
78294 24522 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1120X Hudson Ave 45 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     18 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
78989 11248 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1145X Ingalls St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
79089 11278 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1176X Ingalls St 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
79233 10737 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1120X Hudson Ave 34 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
79391 12006 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1230X La Salle Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438)
79498 12022 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1250X La Salle Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6017218.4556902 2094518.6413490002 37.7321150500381 -122.38280433953301 (37.7321150500381, -122.382804339533)
79673 12115 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1295X La Salle Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6016958.2682626 2094597.9426773998 37.7323184171755 -122.383709392876 (37.7323184171755, -122.383709392876)
81021 17318 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 98X Otis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6006649.48331 2109199.16396 37.7718348142851 -122.42038530226101 (37.7718348142851, -122.420385302261)
81116 11239 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1100X Ingalls St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
81260 10730 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1100 Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
81312 11243 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1100X Ingalls St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
82031 23557 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2900X Van Ness Ave 8 Median : Cutout 11 Tree 1 DPW 2     28 9x200   6005648.5023441 2120304.1415398 37.8022698669467 -122.42463786565399 (37.8022698669467, -122.424637865654)
82251 12036 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1250X La Salle Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6017218.4556902 2094518.6413490002 37.7321150500381 -122.38280433953301 (37.7321150500381, -122.382804339533)
82684 11268 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1176X Ingalls St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
82997 10741 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1120X Hudson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
84760 10732 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1100 Hudson Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
85139 6395 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 5X Rosie Lee Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/19/1993 12:00:00 AM 3 3X4   6018168.8629005 2094369.8502073998 37.7317589621466 -122.379508204595 (37.7317589621466, -122.379508204595)
85254 6176 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1075 Ellis St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6005893.15301 2113273.27935 37.782978696051 -122.423291166859 (37.782978696051, -122.423291166859)
86062 10809 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1139X Hudson Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X4   6017607.97201 2094759.3780099999 37.7327975782942 -122.381474416821 (37.7327975782942, -122.381474416821)
86336 8593 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2355X Geary Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000490.27762 2113338.60243 37.7828516547291 -122.44198752522699 (37.7828516547291, -122.441987525227)
86825 11235 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1100X Ingalls St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/06/2016 12:00:00 AM 18 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
86885 11999 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200X La Salle Ave 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/09/1992 12:00:00 AM 12 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)

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 1895.145ms · Data source: data.sfgov.org