Street_Tree_List

Data source: data.sfgov.org

4,048 rows where qSpecies = 18 sorted by PermitNotes

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes ▼ XCoord YCoord Latitude Longitude Location
34 240126 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 Lily St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6006399.28254 2110261.0751 37.7747364652596 -122.42132618837299 (37.7747364652596, -122.421326188373)
71 251206 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 270 Trumbull St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005145.0 2094297.0 37.7308320294825 -122.424529217878 (37.7308320294825, -122.424529217878)
131 237033 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 7 : 4 Tree 1 DPW 2     6 Width 4ft   6005718.98472 2109769.85153 37.7733493059578 -122.423644547079 (37.7733493059578, -122.423644547079)
135 237030 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 4 : 4 Tree 1 DPW 2     5 Width 4ft   6005725.94025 2109733.85532 37.773250861665204 -122.423617927146 (37.7732508616652, -122.423617927146)
299 196427 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 McLea Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010117.0 2109248.0 37.772163696411795 -122.408394314545 (37.7721636964118, -122.408394314545)
383 181340 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1360 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   5988678.0351 2106085.8063 37.7622572799997 -122.48232089502501 (37.7622572799997, -122.482320895025)
1237 103805 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98X Hemlock St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006953.73656 2114843.50125 37.7873499398897 -122.41973342786999 (37.7873499398897, -122.41973342787)
1311 237352 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3186 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 4x4   6008549.69387 2100618.49329 37.7483811527756 -122.413205447889 (37.7483811527756, -122.413205447889)
1749 251678 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1841 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989656.0 2102823.0 37.7533553254519 -122.478699889248 (37.7533553254519, -122.478699889248)
2028 137540 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1510 Steiner St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6002670.5536 2113409.7602 37.7831710382055 -122.434449780345 (37.7831710382055, -122.434449780345)
2102 196505 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3536 Jennings St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6013064.418880001 2089502.0027700001 37.7181099951501 -122.39681428375299 (37.7181099951501, -122.396814283753)
2141 18982 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2920 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000616.67404 2115546.70514 37.7889217363036 -122.44170876675699 (37.7889217363036, -122.441708766757)
3251 214594 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 352 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/24/2017 12:00:00 AM 3 Width 2ft   5993402.37378 2105988.92272 37.7622649396058 -122.465974283195 (37.7622649396058, -122.465974283195)
3396 253424 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
3629 103766 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101X Austin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006706.11036 2115484.69473 37.7890965465282 -122.420635698799 (37.7890965465282, -122.420635698799)
3800 213446 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 530 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993033.55222 2099443.36305 37.744271238444206 -122.46677405027799 (37.7442712384442, -122.466774050278)
3822 253559 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Cortes Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   5993184.39566 2099612.1282900004 37.7447433294416 -122.46626473273199 (37.7447433294416, -122.466264732732)
3874 239439 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 131 Fairmount St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 4x9   6004683.2193 2097236.31541 37.7388766398495 -122.426334864463 (37.7388766398495, -122.426334864463)
4125 135979 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99 Fern St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 4 Width 4ft   6006900.63841 2115164.21663 37.788227554109504 -122.419939904112 (37.7882275541095, -122.419939904112)
4128 135978 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99 Fern St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 4 Width 4ft   6006877.42 2115159.3392 37.788212853775896 -122.420019889812 (37.7882128537759, -122.420019889812)
4141 135981 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98 Fern St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 Width 4ft   6006885.98637 2115183.79121 37.7882804756017 -122.419991987453 (37.7882804756017, -122.419991987453)
4143 135982 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98 Fern St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 Width 4ft   6006867.714380001 2115184.1661400003 37.788280475609795 -122.420055232261 (37.7882804756098, -122.420055232261)
4162 135980 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98 Fern St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 4 Width 4ft   6006900.58425 2115187.77482 37.7882922360442 -122.419941763898 (37.7882922360442, -122.419941763898)
4328 28085 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2255 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6002770.4091 2114749.1272 37.786854268374796 -122.43420010239201 (37.7868542683748, -122.434200102392)
4456 103803 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98X Hemlock St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6007001.17193 2114849.4881599997 37.7873690504995 -122.419569735969 (37.7873690504995, -122.419569735969)
4600 103784 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 103X Fern St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006741.56415 2115141.24736 37.788155522905505 -122.420488644345 (37.7881555229055, -122.420488644345)
4704 253666 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 578 07th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 4ft   5993791.71774 2111566.05198 37.7776007134003 -122.465032776868 (37.7776007134003, -122.465032776868)
4797 214559 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1342 Irving St 1 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 Width 3ft   5991532.56497 2106606.32246 37.7638521099028 -122.472486197695 (37.7638521099028, -122.472486197695)
4821 214558 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1340 Irving St 1 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2   02/18/2009 12:00:00 AM 4 Width 3ft   5991564.93185 2106609.34919 37.7638622938456 -122.472374472204 (37.7638622938456, -122.472374472204)
4846 76677 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 423 Burrows St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/30/1994 12:00:00 AM 3     6010109.0 2093148.0 37.7279562025478 -122.407286823302 (37.7279562025478, -122.407286823302)
5481 103804 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98X Hemlock St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006974.73956 2114845.21209 37.7873558205593 -122.419660883156 (37.7873558205593, -122.419660883156)
5494 87738 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 10 Median : Cutout 11 Tree 1 DPW 2   05/10/2008 12:00:00 AM 3 4x4   6005444.64461 2121623.98788 37.8058823097966 -122.425437295217 (37.8058823097966, -122.425437295217)
5641 7950 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1735 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/28/2008 12:00:00 AM 3 3X3   6005696.54994 2116082.67925 37.7906815134801 -122.424171198144 (37.7906815134801, -122.424171198144)
6267 17356 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2200 Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6005536.16539 2117610.65272 37.794867887291396 -122.424834871756 (37.7948678872914, -122.424834871756)
6501 103875 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 106X Austin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006702.4202 2115509.69435 37.7891649813311 -122.42065024171002 (37.7891649813311, -122.42065024171)
6617 103761 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 106X Austin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6006685.575019999 2115508.13748 37.7891597571573 -122.42070841348101 (37.7891597571573, -122.420708413481)
6991 103876 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 106X Austin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006716.01893 2115511.31786 37.7891702054911 -122.420603306998 (37.7891702054911, -122.420603306998)
7138 29119 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 509 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/19/2005 12:00:00 AM 3 3x3   6008381.9659 2113792.89597 37.7845455839642 -122.414717657915 (37.7845455839642, -122.414717657915)
7256 71253 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1436 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/19/1995 12:00:00 AM 10 3x3   6007270.15279 2117448.61656 37.7945207624857 -122.418823519012 (37.7945207624857, -122.418823519012)
7324 114856 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1416x Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2016 12:00:00 AM 3 3x3   6006677.767419999 2115342.38606 37.7887042046809 -122.42072365519199 (37.7887042046809, -122.420723655192)
7662 88451 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2   06/07/2008 12:00:00 AM 3 5x12   6005480.84439 2121378.35155 37.805209901088396 -122.425294529632 (37.8052099010884, -122.425294529632)
7952 17354 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2200 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6005542.87933 2117567.08542 37.7947486417029 -122.424808539584 (37.7947486417029, -122.424808539584)
8130 18953 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2857 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/2000 12:00:00 AM 3 3X3   6001142.520269999 2115568.9795 37.789012843016295 -122.439891012071 (37.7890128430163, -122.439891012071)
8222 103806 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98X Hemlock St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006930.58351 2114841.83487 37.787344060129705 -122.419813414468 (37.7873440601297, -122.419813414468)
8535 94877 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3043 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/12/2010 12:00:00 AM 12 3x3   6000192.74031 2115767.95632 37.7895050707416 -122.443191412453 (37.7895050707416, -122.443191412453)
8626 87739 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 11 Median : Cutout 11 Tree 1 DPW 2   05/10/2008 12:00:00 AM 3 4x4   6005433.618530001 2121623.41722 37.8058801199389 -122.42547541206699 (37.8058801199389, -122.425475412067)
8751 17355 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2200 Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6005540.30706 2117584.3351 37.7947958596827 -122.424818667772 (37.7947958596827, -122.424818667772)
8858 21651 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1689 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/31/2013 12:00:00 AM 3 4X4   6004532.1578 2114645.7829 37.7866703442988 -122.428097491401 (37.7866703442988, -122.428097491401)
8875 2624 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1822 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6004615.6699 2115060.0567 37.7878125608959 -122.427838089219 (37.7878125608959, -122.427838089219)
8877 103815 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99X Hemlock St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006959.84507 2114826.77891 37.7873043685578 -122.419711106691 (37.7873043685578, -122.419711106691)
8999 103785 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 103X Fern St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006767.43674 2115144.46398 37.7881658129506 -122.420399357843 (37.7881658129506, -122.420399357843)
9028 103814 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99X Hemlock St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2009 12:00:00 AM 3 3x3   6006931.25215 2114822.01169 37.787289668217795 -122.41980969397 (37.7872896682178, -122.41980969397)
9219 4233 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4000X Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/1995 12:00:00 AM 3 3x3   6003879.3665122 2100440.460437 37.7476290122472 -122.429342637933 (37.7476290122472, -122.429342637933)
9424 16412 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1200X Newcomb Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2008 12:00:00 AM 3 3x3   6016451.798598001 2094870.8752060002 37.7330398269448 -122.38547940494499 (37.7330398269448, -122.385479404945)
9468 16413 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1200X Newcomb Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2008 12:00:00 AM 3 3x3   6016451.798598001 2094870.8752060002 37.7330398269448 -122.38547940494499 (37.7330398269448, -122.385479404945)
9712 121497 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 468 Valley St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/20/2016 12:00:00 AM 3 3x3   6002891.0 2099226.0 37.744238382256704 -122.432673610292 (37.7442383822567, -122.432673610292)
9713 121496 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 468 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/20/2016 12:00:00 AM 3 3x3   6002891.0 2099226.0 37.744238382256704 -122.432673610292 (37.7442383822567, -122.432673610292)
10340 28256 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3476 San Bruno Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/19/2003 12:00:00 AM 6 3x3   6012060.981000001 2089540.1901200002 37.7181589470551 -122.400285438425 (37.7181589470551, -122.400285438425)
10377 28246 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3326 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2002 12:00:00 AM 3 2X3   6011947.80562 2090200.17318 37.7199648154144 -122.400722979282 (37.7199648154144, -122.400722979282)
10513 117008 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1315 Silliman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/2016 12:00:00 AM 3 3x3   6006952.61647 2093135.11232 37.7277436552341 -122.418197638517 (37.7277436552341, -122.418197638517)
10582 69800 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 367 Delano Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2000 12:00:00 AM 3 3x3   5999779.7835 2091764.7216900003 37.7235745268131 -122.442895800812 (37.7235745268131, -122.442895800812)
11150 28262 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3624 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/20/2003 12:00:00 AM 12 3x3   6012194.4874599995 2088681.14992 37.715807638979705 -122.399763675165 (37.7158076389797, -122.399763675165)
11292 86217 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2621 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/11/2013 12:00:00 AM 3 3x3   5988925.7787 2097455.0086 37.7385738093546 -122.48083214346799 (37.7385738093546, -122.480832143468)
11313 26979 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 538 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6004789.78173 2093487.7597 37.728589968546 -122.42569968949199 (37.728589968546, -122.425699689492)
11353 28245 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3312 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/23/2002 12:00:00 AM 8 2X3   6011933.46331 2090279.87862 37.7201828704297 -122.40077815269899 (37.7201828704297, -122.400778152699)
11481 28255 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3476 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/25/2003 12:00:00 AM 6 3x3   6012058.005419999 2089554.66958 37.7181985388057 -122.400296740219 (37.7181985388057, -122.400296740219)
11489 918 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1246 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/14/2000 12:00:00 AM 3 3x6   6002972.02958 2094203.5052200002 37.730452359288996 -122.43203484674801 (37.730452359289, -122.432034846748)
11602 27093 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 711 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X3   6006091.0826900005 2093593.66537 37.7289542101608 -122.421208528251 (37.7289542101608, -122.421208528251)
11634 101011 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 83 Santa Ynez Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     10 6x10   6000610.71791 2092062.1351 37.724438494726 -122.44004473049101 (37.724438494726, -122.440044730491)
11924 27095 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 711 Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X3   6006067.91108 2093593.9714799998 37.7289537443201 -122.421288656069 (37.7289537443201, -122.421288656069)
12009 28254 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3410 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2002 12:00:00 AM 8 3X3   6012011.64722 2089824.91922 37.7189380045612 -122.400475954423 (37.7189380045612, -122.400475954423)
12039 28243 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3230 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/21/2004 12:00:00 AM 8 2X3   6011870.75873 2090643.72462 37.7211784199346 -122.401020454343 (37.7211784199346, -122.401020454343)
12282 17504 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 132 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002139.261969999 2091310.46109 37.7224614665061 -122.43470704369 (37.7224614665061, -122.43470704369)
12555 27112 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 483 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004609.34849 2093526.9165 37.728687286881204 -122.426326244487 (37.7286872868812, -122.426326244487)
12568 28244 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3260 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/20/2003 12:00:00 AM 12 2X3   6011894.92216 2090508.59301 37.7208087239121 -122.40092743836 (37.7208087239121, -122.40092743836)
12648 1088 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2222 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/06/2006 12:00:00 AM 8 3X3   5999676.1210900005 2089518.7544200001 37.717401703502205 -122.443092918703 (37.7174017035022, -122.443092918703)
12793 13368 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 900 Mansell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X50   6009218.46856 2090025.7710400003 37.719333336630896 -122.410145089137 (37.7193333366309, -122.410145089137)
12903 28302 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3410 San Bruno Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 3X3   6012014.9954 2089805.7813099998 37.7188856424495 -122.40046303743799 (37.7188856424495, -122.400463037438)
13073 28301 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3336 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/20/2003 12:00:00 AM 8 3X3   6011974.103080001 2090046.14983 37.719543365213 -122.400621263274 (37.719543365213, -122.400621263274)
13686 27731 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1100 Cesar Chavez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2006 12:00:00 AM 3 3X3   6015524.1696 2101161.19501 37.7502603851148 -122.38912554882 (37.7502603851148, -122.38912554882)
13745 4018 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1760 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/1995 12:00:00 AM 3 2X3   6013908.29896 2101074.88916 37.7499337000814 -122.394707332299 (37.7499337000814, -122.394707332299)
13759 109718 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 91x Jennings Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6013027.725819999 2089252.6527099998 37.7174232872231 -122.396923644015 (37.7174232872231, -122.396923644015)
13815 27724 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1200 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2006 12:00:00 AM 3 3X3   6015353.113480001 2101161.82636 37.750252634763996 -122.389717121075 (37.750252634764, -122.389717121075)
13821 105161 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1600X Oakdale Ave 2 Front Yard : Cutout 8 Tree 1 Arts Commission 19     13 3x3   6014869.34112 2095641.8363700002 37.735069048787 -122.39100428831499 (37.735069048787, -122.391004288315)
13866 10995 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1544 Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6016004.21156 2097242.6965900003 37.7395275952262 -122.387192226744 (37.7395275952262, -122.387192226744)
14286 27729 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1100 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2006 12:00:00 AM 3 3X3   6015622.7491 2101166.85438 37.75028138877779 -122.38878504659999 (37.7502813887778, -122.3887850466)
15485 111661 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1398x Kansas St 1 Median : Cutout 11 Tree 1 DPW 2   06/25/2015 01:32:00 PM 3 3x3   6011721.86925 2101900.7924099998 37.7520796461774 -122.402326221379 (37.7520796461774, -122.402326221379)
15791 27728 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1200 Cesar Chavez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2006 12:00:00 AM 3 3X3   6015202.17288 2101166.08495 37.750255956855 -122.390239385253 (37.750255956855, -122.390239385253)
16042 4051 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2550 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2006 12:00:00 AM 3 3X3   6011835.74556 2100958.0718 37.749497496525 -122.401866156092 (37.749497496525, -122.401866156092)
16131 4050 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2550 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6011878.426080001 2100960.1838700003 37.7495056776496 -122.40171871317101 (37.7495056776496, -122.401718713171)
16684 121586 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 855 Carolina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   6012479.74347 2103984.1173799997 37.7578422788274 -122.399851639655 (37.7578422788274, -122.399851639655)
16945 27513 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1212 Guerrero St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/10/2001 12:00:00 AM 8 3X3   6005754.33518 2101803.9188099997 37.751478728181795 -122.422955987444 (37.7514787281818, -122.422955987444)
16975 4208 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3928 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/1995 12:00:00 AM 3 3X3   6004332.42415 2100461.61534 37.747712737955105 -122.427777497548 (37.7477127379551, -122.427777497548)
17088 4158 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3739-3737 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/31/1989 12:00:00 AM 12 3X3   6005577.7811900005 2100485.8259400004 37.74784958418571 -122.423472835916 (37.7478495841857, -122.423472835916)
17098 4184 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3835 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 12 3X3   6004944.66483 2100451.1135299997 37.7477185170056 -122.425659653475 (37.7477185170056, -122.425659653475)
17135 4290 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4319 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/1995 12:00:00 AM 3 3X3   6001811.82225 2100290.20269 37.7470991700926 -122.43648132156099 (37.7470991700926, -122.436481321561)
17165 23041 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 987 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/1994 12:00:00 AM 12 3X3   6006352.9755 2103862.85209 37.7571658456457 -122.421031987753 (37.7571658456457, -122.421031987753)
17183 10191 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1163 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/28/1991 12:00:00 AM 12 2X3   6005802.7182 2102181.70358 37.7525187680511 -122.422815518735 (37.7525187680511, -122.422815518735)
17251 4061 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3045 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/1995 12:00:00 AM 12 3x3   6009371.8230099995 2100537.10689 37.7482038046704 -122.41035678685499 (37.7482038046704, -122.410356786855)
17328 1375 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 57 Amethyst Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/24/1999 12:00:00 AM 3 1X1   5998969.3690599995 2100010.78272 37.7461700211271 -122.446290155185 (37.7461700211271, -122.446290155185)

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