Street_Tree_List

Data source: data.sfgov.org

306 rows where qSpecies = 193

View and edit SQL

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2834 18980 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2918 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6000663.1774699995 2115553.99763 37.788944409101 -122.441548395156 (37.788944409101, -122.441548395156)
3645 237733 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 4084 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001754.97283 2105879.14802 37.7624418398492 -122.437077981268 (37.7624418398492, -122.437077981268)
5475 107944 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 44x MacOndray Ln 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   6008447.49259 2119151.63001 37.7992630360091 -122.414870351108 (37.7992630360091, -122.414870351108)
6542 19818 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 100 STAIRWAY25 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 100ST            
6594 29762 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 530 Francisco St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6008749.3255 2121116.482 37.8046749842608 -122.413964972943 (37.8046749842608, -122.413964972943)
10535 114182 Permitted Site 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 126 Chester Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x6 Permit Number 776810 5991719.57231 2088350.33 37.713736615419606 -122.470509712677 (37.7137366154196, -122.470509712677)
11243 19800 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 100 STAIRWAY21 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 40ST            
12103 20322 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 101X Sunset Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
12291 97765 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 400X Amazon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6001461.36757 2088928.6001 37.7158829014541 -122.436879936162 (37.7158829014541, -122.436879936162)
17482 29621 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 900X Junipero Serra Blvd 30 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 3X3   5991159.4977400005 2090848.6205 37.7205639077711 -122.47262755402299 (37.7205639077711, -122.472627554023)
19823 28241 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 3849 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X6   6004869.33528 2100447.6674099998 37.74770479785771 -122.42591989391501 (37.7477047978577, -122.425919893915)
21562 29959 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 300x Junipero Serra Blvd 6 Median : Cutout 11 Tree 1 DPW 2   04/01/2007 12:00:00 AM 3 3x3   5991398.70735 2094566.15878 37.730785187583606 -122.472071516681 (37.7307851875836, -122.472071516681)
21874 29958 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 300X Junipero Serra Blvd 4 Median : Cutout 11 Tree 1 DPW 2   04/01/2007 12:00:00 AM 3 3x3   5991400.2554 2094584.59866 37.7308359084501 -122.47206750842501 (37.7308359084501, -122.472067508425)
22878 211497 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 500 Junipero Serra Blvd 69 : 4 Tree 1 Private 1     4 Width 0ft   5991316.04145 2093239.9376700001 37.7271389322076 -122.472260663898 (37.7271389322076, -122.472260663898)
23455 194596 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 800 Wisconsin St 7 : 4 Tree 1 Private 1     12 Width 3ft   6012720.64304 2103613.2936299997 37.7568375049672 -122.398992475934 (37.7568375049672, -122.398992475934)
23733 142705 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 550 FRANCISCO ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6008670.6587 2121106.7911 37.804643957021604 -122.41423652198 (37.8046439570216, -122.41423652198)
23997 211515 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 42 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 2ft   6001141.02777 2095226.0889599998 37.7331561620146 -122.43843810425301 (37.7331561620146, -122.438438104253)
24142 234004 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1300 Noe St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6003211.15019 2100572.61203 37.7479540161859 -122.431662723473 (37.7479540161859, -122.431662723473)
24930 233980 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1609 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 Width 3ft   6005332.72592 2098929.24645 37.7435617380791 -122.424209538959 (37.7435617380791, -122.424209538959)
26232 211495 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 500 Junipero Serra Blvd 65 : 4 Tree 1 Private 1     3 Width 0ft   5991310.32822 2093255.28671 37.72718074619429 -122.472281532691 (37.7271807461943, -122.472281532691)
27022 211487 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 300 Junipero Serra Blvd 26 : 4 Tree 1 Private 1     7 Width 0ft   5991384.264769999 2094458.5137 37.730488785420704 -122.47211360318701 (37.7304887854207, -122.472113603187)
27472 186312 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1800 Sunset Blvd 50 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984965.9651 2102794.0558 37.753002421044 -122.494916634558 (37.753002421044, -122.494916634558)
28295 178408 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1601 San Jose Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6001651.1985599995 2094173.31719 37.7302944985896 -122.43659898077699 (37.7302944985896, -122.436598980777)
29212 67866 Permitted Site 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 525 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/07/2008 12:00:00 AM 10 3x3 Permit Number 51918 6011810.47286 2105913.7518 37.763103292118004 -122.402301941482 (37.763103292118, -122.402301941482)
29373 185326 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2601 Sunset Blvd 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 0ft   5985005.7858 2097131.3413 37.737456475448205 -122.494361550047 (37.7374564754482, -122.494361550047)
29518 233985 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 524 Belvedere St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 2ft   5998610.0170599995 2106121.66353 37.762928461205505 -122.447972640126 (37.7629284612055, -122.447972640126)
30244 194592 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1098 19th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6014470.31991 2105301.99437 37.761571655840896 -122.393059550356 (37.7615716558409, -122.393059550356)
30293 186656 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1401 Sunset Blvd 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984694.4647 2105572.7074 37.7606159295654 -122.496060500131 (37.7606159295654, -122.496060500131)
30308 234002 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 4472 24th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 3ft   6000158.92491 2101697.14224 37.750868224295395 -122.442297873053 (37.7508682242954, -122.442297873053)
30339 211462 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 20 Santa Rita Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5993868.16001 2100935.65838 37.7484168360728 -122.463996482471 (37.7484168360728, -122.463996482471)
30763 186646 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1401 Sunset Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984695.8255 2105597.2027 37.7606832665135 -122.496057600995 (37.7606832665135, -122.496057600995)
31160 132445 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 44 MacOndray Ln 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6008457.55549 2119152.19379 37.7992651494321 -122.414835569802 (37.7992651494321, -122.414835569802)
31389 211482 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 458 Orizaba Ave 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 1ft   5994045.41043 2089492.79513 37.7170077644759 -122.46255364615699 (37.7170077644759, -122.462553646157)
31532 186290 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1800 Sunset Blvd 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984992.545 2102621.6891 37.752530705423496 -122.49481201009701 (37.7525307054235, -122.494812010097)
31988 194601 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 560 Missouri St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     22 Width 2ft   6013524.119940001 2104470.94675 37.7592371740688 -122.396273844275 (37.7592371740688, -122.396273844275)
31991 186899 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2700 Sunset Blvd 48 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985185.1341 2096610.575 37.7360370845142 -122.493703104722 (37.7360370845142, -122.493703104722)
32663 211491 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 500 Junipero Serra Blvd 20 : 4 Tree 1 Private 1     15 Width 0ft   5991339.7288 2093695.49673 37.7283911545133 -122.472211971033 (37.7283911545133, -122.472211971033)
32731 132443 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 45 MacOndray Ln 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6008455.947000001 2119141.60156 37.7992359754255 -122.414840385693 (37.7992359754255, -122.414840385693)
34211 211475 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 370 Teresita Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5997994.43141 2098177.8593599997 37.7410815301989 -122.449529301835 (37.7410815301989, -122.449529301835)
34233 249674 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2400 Baker St 6 Front Yard : Yard 7 Tree 1 Private 1     6     5999745.99135 2117154.55448 37.7932868206909 -122.444836822859 (37.7932868206909, -122.444836822859)
35004 234011 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 671 Church St 40 Front Yard : Yard 7 Tree 1 Private 1     12 Width 3ft   6004316.16134 2105104.7560099997 37.7604607925581 -122.42816458192499 (37.7604607925581, -122.428164581925)
35812 211504 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 700 Junipero Serra Blvd 140 : 4 Tree 1 Private 1     19 Width 0ft   5991207.795390001 2091589.11785 37.7225999261211 -122.472514564093 (37.7225999261211, -122.472514564093)
36241 211508 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 900 Junipero Serra Blvd 91 : 4 Tree 1 Private 1     8 Width 0ft   5991145.77584 2090549.03297 37.719740519976895 -122.47265315412201 (37.7197405199769, -122.472653154122)
37102 178409 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 747 Olmstead St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 4ft   6009504.75205 2090542.56388 37.720768384826705 -122.409191957952 (37.7207683848267, -122.409191957952)
37467 186905 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2700 Sunset Blvd 54 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985182.3835 2096680.7134 37.7362295049295 -122.49371778132401 (37.7362295049295, -122.493717781324)
38943 211496 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 500 Junipero Serra Blvd 66 : 4 Tree 1 Private 1     3 Width 0ft   5991314.70255 2093252.7900900003 37.7271741442599 -122.47226622890301 (37.7271741442599, -122.472266228903)
39614 137943 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1934 BUCHANAN ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6003936.5354 2115120.5913 37.787940331576294 -122.430192087218 (37.7879403315763, -122.430192087218)
39714 233979 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 984 Valencia St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6006291.32527 2103870.13031 37.7571823544938 -122.421245715219 (37.7571823544938, -122.421245715219)
39743 248507 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 130 Frederick St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5999267.956 2107716.9114 37.7673461983853 -122.445811798931 (37.7673461983853, -122.445811798931)
39820 233996 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1145 Douglass St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 4ft   6001366.11278 2100375.0445 37.7473067884747 -122.438028621322 (37.7473067884747, -122.438028621322)
40990 234003 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 500x 27th St 17 Median : Cutout 11 Tree 1 DPW 2     9 Width 4ft   6002888.7683 2100065.98913 37.7465446697175 -122.432741319957 (37.7465446697175, -122.432741319957)
41205 234007 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 3978 22nd St 1 : 4 Tree 1 Private 1     12     6001985.80169 2102958.64311 37.7544359571599 -122.43607063447399 (37.7544359571599, -122.436070634474)
41576 178403 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1601 San Jose Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6001622.1469 2094146.16948 37.7302183062155 -122.436697473612 (37.7302183062155, -122.436697473612)
41833 211469 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 100 Terrace Dr 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21     5993761.6919599995 2096603.4346099999 37.7365155021795 -122.46405020255199 (37.7365155021795, -122.464050202552)
41846 184992 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2701 Sunset Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5985034.7824 2096572.4498 37.7359236057275 -122.49422011427001 (37.7359236057275, -122.49422011427)
42283 187223 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2401 Sunset Blvd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984959.6865 2098764.6952 37.7419385280067 -122.4946413151 (37.7419385280067, -122.4946413151)
42414 178412 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1703 San Jose Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     6001615.63687 2094138.09403 37.7301957629086 -122.43671940177201 (37.7301957629086, -122.436719401772)
42518 186648 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1401 Sunset Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984709.2247 2105592.1781 37.760670255173295 -122.49601088920299 (37.7606702551733, -122.496010889203)
42960 132421 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 93 MacOndray Ln 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6008147.86247 2119098.46526 37.7991002182645 -122.41590341131099 (37.7991002182645, -122.415903411311)
43436 132413 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 8 Codman Pl 6 Back Yard : Yard 13 Tree 1 Private 1     11 Width 10ft   6009827.38182 2117300.98565 37.7942590579634 -122.409964721995 (37.7942590579634, -122.409964721995)
43616 187255 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2401 Sunset Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984931.0927 2098441.9934 37.741050802303796 -122.494716395865 (37.7410508023038, -122.494716395865)
44063 211456 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1380 12th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5992429.060880001 2106083.47981 37.7624683707489 -122.46934745851699 (37.7624683707489, -122.469347458517)
44639 217797 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 21 Sloat Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 5ft   5991294.478019999 2095928.89148 37.7345208760209 -122.47253116378201 (37.7345208760209, -122.472531163782)
44694 132423 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 943 Vallejo St 3 Side Yard : Yard 17 Tree 1 Private 1     6     6008817.55248 2118666.35728 37.7979513838133 -122.41355547121401 (37.7979513838133, -122.413555471214)
44921 233986 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 524 Belvedere St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 2ft   5998609.24404 2106138.43946 37.7629744795115 -122.44797652162599 (37.7629744795115, -122.447976521626)
45229 249704 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2400 Baker St 36 Front Yard : Yard 7 Tree 1 Private 1     5     5999690.977469999 2117209.86424 37.793435546960104 -122.445031151972 (37.7934355469601, -122.445031151972)
45350 186663 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1401 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984720.949 2105554.1789 37.7605666066845 -122.49596753741301 (37.7605666066845, -122.495967537413)
45715 234010 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 10 Museum Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 2ft   6000617.506990001 2106869.9600299997 37.765097643976205 -122.44108313359301 (37.7650976439762, -122.441083133593)
46821 186045 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1900 Sunset Blvd 40 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984977.5299 2102204.8272 37.7513852382741 -122.494833201598 (37.7513852382741, -122.494833201598)
46830 187238 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2401 Sunset Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984929.8672 2098580.4692 37.7414309477639 -122.494730839951 (37.7414309477639, -122.494730839951)
47165 233997 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1027 Douglass St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6001336.17311 2100800.0445 37.748472034653204 -122.438162590655 (37.7484720346532, -122.438162590655)
47448 211458 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 627 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5992320.27215 2103852.77916 37.7563371653349 -122.46956132179501 (37.7563371653349, -122.469561321795)
47612 132430 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 945 Green St 7 Front Yard : Yard 7 Tree 1 Private 1     3     6008611.92512 2118990.4909900003 37.79882982628239 -122.414289948436 (37.7988298262824, -122.414289948436)
47931 185333 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2601 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984974.4862 2097035.977 37.737192798845705 -122.49446273799299 (37.7371927988457, -122.494462737993)
49409 211489 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 300 Junipero Serra Blvd 42 : 4 Tree 1 Private 1     11 Width 0ft   5991385.31343 2094370.74598 37.730247857955 -122.472103582925 (37.730247857955, -122.472103582925)
49671 132429 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 945 Green St 6 Front Yard : Yard 7 Tree 1 Private 1     3     6008611.378880001 2118984.10383 37.79881225804311 -122.414291386455 (37.7988122580431, -122.414291386455)
50010 187381 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2200 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985077.6613 2100066.7313 37.745520471183795 -122.49432935498001 (37.7455204711838, -122.49432935498)
51529 132427 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 945 Green St 4 Front Yard : Yard 7 Tree 1 Private 1     3     6008608.8618 2118977.06556 37.798792791310206 -122.414299598148 (37.7987927913102, -122.414299598148)
51628 211457 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1612 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   5993723.499 2104492.49464 37.758174657459996 -122.464754967966 (37.75817465746, -122.464754967966)
51693 185327 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2601 Sunset Blvd 52 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5985009.972999999 2097123.3855 37.7374348759954 -122.494346486878 (37.7374348759954, -122.494346486878)
51885 178405 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1601 San Jose Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10     6001634.24365 2094157.9299599999 37.7302512852578 -122.436656495109 (37.7302512852578, -122.436656495109)
52805 178420 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 164 Otsego Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6000582.8572 2092343.3357400002 37.7252090212659 -122.440161196294 (37.7252090212659, -122.440161196294)
53395 234013 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 671 Church St 45 Front Yard : Yard 7 Tree 1 Private 1     9 Width 3ft   6004317.78072 2105162.3703799997 37.760619079539794 -122.42816308726499 (37.7606190795398, -122.428163087265)
53864 88779 Permitted Site 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 52 MacOndray Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 3x3 Permit Number 51696 6008424.66952 2119147.16935 37.7992495057053 -122.414949011194 (37.7992495057053, -122.414949011194)
54393 211454 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1478 14th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 5ft   5991840.401000001 2105371.22942 37.7604786845549 -122.471331499675 (37.7604786845549, -122.471331499675)
54641 178419 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 164 Otsego Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6000583.99969 2092347.99835 37.7252218887704 -122.44015758103201 (37.7252218887704, -122.440157581032)
55110 132432 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 943 Green St 2 Side Yard : Yard 17 Tree 1 Private 1     2     6008616.66785 2118981.63248 37.7988057694225 -122.41427290988999 (37.7988057694225, -122.41427290989)
55137 211463 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 28 Sotelo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5993946.4146 2101049.73072 37.748734559355604 -122.463734160116 (37.7487345593556, -122.463734160116)
55324 211461 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 268 Pacheco St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     46 Width 6ft   5994405.70319 2100667.69172 37.74771203198029 -122.462118252857 (37.7477120319803, -122.462118252857)
55591 120237 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 374 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5988416.64547 2113494.9813 37.782585610484 -122.483768203906 (37.782585610484, -122.483768203906)
55617 233991 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 252 Downey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   5999009.85314 2106698.21052 37.764534361698 -122.44663123474 (37.764534361698, -122.44663123474)
55865 211453 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1419 16th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5991125.878830001 2105721.1672 37.761398162224296 -122.473828208309 (37.7613981622243, -122.473828208309)
56453 233981 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 3846 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6004869.8512 2100493.03902 37.7478294069984 -122.425921339098 (37.7478294069984, -122.425921339098)
57447 123386 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 721 03rd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5995023.17687 2110618.9944 37.7750712752433 -122.460704125187 (37.7750712752433, -122.460704125187)
58074 211472 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 200x Terrace Dr 22 Median : Yard 3 Tree 1 DPW 2     7     5993829.814069999 2096532.0459099999 37.7363234123842 -122.463809497222 (37.7363234123842, -122.463809497222)
58076 247523 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1101 Waller St 4 Side Yard : Yard 17 Tree 1 Private 1     10     6000011.18383 2108488.88375 37.769508249328 -122.44329653959801 (37.769508249328, -122.443296539598)
59662 194599 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 560 Missouri St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     17 Width 2ft   6013504.76514 2104470.26142 37.7592342153007 -122.396340734951 (37.7592342153007, -122.396340734951)
59976 132441 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 81 MacOndray Ln 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   6008314.4941300005 2119120.93621 37.7991712844751 -122.41532839918999 (37.7991712844751, -122.41532839919)
60412 211501 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 500 Junipero Serra Blvd 76 : 4 Tree 1 Private 1     6 Width 0ft   5991307.02805 2093213.27688 37.727065206682404 -122.47228988016701 (37.7270652066824, -122.472289880167)
60422 187252 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 2401 Sunset Blvd 35 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984966.6307 2098466.0939 37.741119055848706 -122.49459529648998 (37.7411190558487, -122.49459529649)

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