Street_Tree_List

Data source: data.sfgov.org

4,048 rows where qSpecies = 18

View and edit SQL

Suggested facets: qLegalStatus, 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)
73 65479 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1051 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/01/1997 12:00:00 AM 10 3x3 Permit Number 28361 6008468.497880001 2115537.43749 37.789340533487795 -122.41454177659901 (37.7893405334878, -122.414541776599)
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)
649 96374 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1315 Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/2011 12:00:00 AM 8 3x3 Permit Number 768288 6008916.2106800005 2117429.1962900003 37.7945599836999 -122.41312655846599 (37.7945599836999, -122.413126558466)
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)
1252 61532 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 347 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2017 12:00:00 AM 3   Permit Number 772896 5991195.07104 2113068.5037599998 37.781575964268896 -122.474125016615 (37.7815759642689, -122.474125016615)
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)
1495 213442 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2455 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2002 12:00:00 AM 6 Width 3ft Permit Number 45711 5992014.67382 2098752.22599 37.742314697659204 -122.470246761681 (37.7423146976592, -122.470246761681)
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)
2424 239429 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 565 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2008 12:00:00 AM 5 Width 2ft Permit Number 51470 6001213.70363 2103034.08129 37.7545991976029 -122.438746149019 (37.7545991976029, -122.438746149019)
2617 59596 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1401 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/21/2014 12:00:00 AM 0   Permit Number 770950 6000181.59670606 2113731.76941076 37.7839135947641 -122.443083674123 (37.7839135947641, -122.443083674123)
2636 239448 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 224 Miguel St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/15/1997 12:00:00 AM 11 Width 4ft Permit Number 38139 6004193.01737 2096717.47365 37.7374242967807 -122.427992792539 (37.7374242967807, -122.427992792539)
2957 238483 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 103 Germania St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/1996 12:00:00 AM 13 Width 3ft Permit Number 37768 6003709.010969999 2108821.61027 37.7706320052989 -122.430529650538 (37.7706320052989, -122.430529650538)
2962 238484 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 103 Germania St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/1996 12:00:00 AM 7 Width 3ft Permit Number 37768 6003723.3725 2108822.3529 37.7706348579377 -122.430480026835 (37.7706348579377, -122.430480026835)
2996 178926 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 406 Capistrano Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3 Permit Number 780238 6000939.854169999 2092384.3608900001 37.7253419851205 -122.43893003518801 (37.7253419851205, -122.438930035188)
3084 238169 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1018 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/1989 12:00:00 AM 2 Width 4ft Permit Number 27197 6003120.08624 2102266.16095 37.7525989407879 -122.432098539422 (37.7525989407879, -122.432098539422)
3100 124475 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 336 Willard St North 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2008 12:00:00 AM 1 Width 3ft Permit Number 51142 5996295.75285 2110564.44719 37.7749946376288 -122.456298087251 (37.7749946376288, -122.456298087251)
3103 238168 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1010 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/1989 12:00:00 AM 14 Width 4ft Permit Number 27196 6003119.41534 2102323.30502 37.7527558068522 -122.432104939916 (37.7527558068522, -122.432104939916)
3188 213685 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 428 Congo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/23/2002 12:00:00 AM 9 Width 2ft Permit Number 45997 6000116.1968 2095121.7561599999 37.7328113412593 -122.44197372410801 (37.7328113412593, -122.441973724108)
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)
3412 117560 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2304 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/30/2016 12:00:00 AM 3 4x4 Permit Number 778613 6002499.39832 2117814.1104 37.7952545391263 -122.435357062003 (37.7952545391263, -122.435357062003)
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)
3683 213464 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/24/2005 12:00:00 AM 2 Width 3ft Permit Number 48287 5993110.29995 2099700.9644 37.7449829754007 -122.46652739502701 (37.7449829754007, -122.466527395027)
3739 237154 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 861 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/27/1992 12:00:00 AM 5 Width 6ft Permit Number 30833 6010197.69553 2104230.40256 37.7583910361238 -122.407761316458 (37.7583910361238, -122.407761316458)
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)
3846 239484 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 725 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/12/2017 12:00:00 AM 8 Width 3ft Permit Number 779370 6007401.15098 2095467.39415 37.7341728312175 -122.416812207728 (37.7341728312175, -122.416812207728)
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)
4329 239457 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 165 Sussex St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001959.66963 2096487.1672 37.7366653238346 -122.435698035437 (37.7366653238346, -122.435698035437)
4404 239458 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 165 Sussex St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001977.4736 2096494.97635 37.7366877772239 -122.435637038029 (37.7366877772239, -122.435637038029)
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)
4533 214732 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 706 Faxon Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/03/1999 12:00:00 AM 8 Width 2ft Permit Number 41499 5994886.41967 2092806.74885 37.7261554857857 -122.459886624766 (37.7261554857857, -122.459886624766)
4537 214730 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 706 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/03/1999 12:00:00 AM 8 Width 2ft Permit Number 41499 5994894.76005 2092775.8058599997 37.7260710034609 -122.459855552309 (37.7260710034609, -122.459855552309)
4542 214731 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 706 Faxon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/03/1999 12:00:00 AM 8 Width 2ft Permit Number 41499 5994889.57203 2092796.33348 37.7261270689877 -122.459874973176 (37.7261270689877, -122.459874973176)
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)
4841 88280 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3261 Clay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/26/2017 12:00:00 AM 3 3x3 Permit Number 778851 5999200.48769 2115630.5359099996 37.789071121774796 -122.446614594592 (37.7890711217748, -122.446614594592)
4845 38140 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 423 Burrows St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/15/1998 12:00:00 AM 2   Permit Number 40297 6010109.0 2093148.0 37.7279562025478 -122.407286823302 (37.7279562025478, -122.407286823302)
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)
4918 43245 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 150 Felton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 9   Permit Number 43034 6010460.0 2093774.0 37.729694705520004 -122.40611748494 (37.72969470552, -122.40611748494)
5453 21659 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1750 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/2015 12:00:00 AM 3 4X4 Permit Number 774105 6004291.1629 2114663.74 37.786706012119296 -122.428932556586 (37.7867060121193, -122.428932556586)
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)
5495 21662 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1750 Sutter St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/2015 12:00:00 AM 3 4X4 Permit Number 774105 6004219.9241 2114651.242 37.7866676632245 -122.42917813434201 (37.7866676632245, -122.429178134342)
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)
6091 34255 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2280 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/23/2016 12:00:00 AM 3 6x4 Permit Number 779106 6002701.36974 2117843.10011 37.7953456053627 -122.43466028347099 (37.7953456053627, -122.434660283471)
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)
6734 96373 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1315 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/2011 12:00:00 AM 8 3x3 Permit Number 768288 6008912.46348 2117456.9297 37.7946359224745 -122.41314148629499 (37.7946359224745, -122.413141486295)
6793 106875 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2014 12:00:00 AM 9 3x3 Permit Number 772880 5999376.012619999 2115702.7008599997 37.7892792923525 -122.446012495778 (37.7892792923525, -122.446012495778)
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)
7213 105719 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2317 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/2015 12:00:00 AM 3 3x3 Permit Number 775548 6003614.61217 2116568.84347 37.791898625373705 -122.43140930798799 (37.7918986253737, -122.431409307988)
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)
7289 111196 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2317 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/2015 12:00:00 AM 3   Permit Number 775548 6003599.3502400005 2116566.69152 37.7918918516902 -122.43146196059601 (37.7918918516902, -122.431461960596)
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)
7328 18943 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2799X Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2013 12:00:00 AM 3 3x3 Permit Number 769995 6001475.92192 2115618.2324 37.7891670515542 -122.438741019305 (37.7891670515542, -122.438741019305)
7650 88367 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2014 12:00:00 AM 3 3x3 Permit Number 772880 5999340.32482 2115698.11509 37.7892646630799 -122.44613564087099 (37.7892646630799, -122.446135640871)
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)
8180 21666 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1765 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2014 12:00:00 AM 3 4X4 Permit Number 774582 6004178.5577 2114595.027 37.7865109691436 -122.42931724201799 (37.7865109691436, -122.429317242018)
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)
8301 21660 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1750 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/2015 12:00:00 AM 3 4x4 Permit Number 774105 6004267.4166 2114661.2404 37.7866978047254 -122.429014534836 (37.7866978047254, -122.429014534836)
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)
8629 98380 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2610 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/08/2015 12:00:00 AM 3 3x3 Permit Number 775239 6001192.51464 2117382.3552900003 37.7939947472129 -122.439848106311 (37.7939947472129, -122.439848106311)
8744 21661 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1750 Sutter St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/2015 12:00:00 AM 3 4X4 Permit Number 774105 6004243.6704 2114654.9914 37.7866793023692 -122.429096245288 (37.7866793023692, -122.429096245288)
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)
8777 98381 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2610 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/08/2015 12:00:00 AM 3 3x3 Permit Number 775239 6001191.27881 2117387.7488599997 37.7940094862005 -122.43985276928801 (37.7940094862005, -122.439852769288)
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)
9780 65693 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3779 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2016 12:00:00 AM 3 4x4 Permit Number 779357 6005288.42845233 2101344.00549356 37.7501896116955 -122.424534439725 (37.7501896116955, -122.424534439725)
10315 47259 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1487 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/11/2014 12:00:00 AM 1 3x3 Permit Number 770986 5989591.7291 2105266.36 37.7600604072843 -122.479100863475 (37.7600604072843, -122.479100863475)
10329 109051 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 De Long St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772570 5995048.30925 2086814.9244099997 37.7097126663738 -122.45889335865 (37.7097126663738, -122.45889335865)

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