Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3100 | 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) | |
| 10315 | 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) |
| 23166 | 23166 | 26519 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2851 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | 1X1 | Permit Number 777140 | 6009004.2746 | 2101873.01384 | 37.751851296609296 | -122.411722142074 | (37.7518512966093, -122.411722142074) | |
| 26523 | 26523 | 88167 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 189 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 51184 | 6010014.6058 | 2087504.2072 | 37.7124542316575 | -122.40721547231199 | (37.7124542316575, -122.407215472312) | |
| 44697 | 44697 | 103496 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989840.04595 | 2110621.50302 | 37.7747785915425 | -122.478633697845 | (37.7747785915425, -122.478633697845) | |
| 46285 | 46285 | 65280 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 435 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 1 | Permit Number 28085 | 6011091.92612 | 2112217.73363 | 37.7803724445696 | -122.405231107147 | (37.7803724445696, -122.405231107147) | |
| 48514 | 48514 | 50297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2909 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 1 | Permit Number 47009 | 5989047.82914 | 2095849.4982599998 | 37.7341725865769 | -122.48029267728701 | (37.7341725865769, -122.480292677287) | |
| 50531 | 50531 | 96079 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 664 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767703 | 5983226.11153 | 2111277.81973 | 37.7761944189321 | -122.501560849986 | (37.7761944189321, -122.501560849986) |
| 53314 | 53314 | 95695 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 523 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767449 | 5992184.07474 | 2111863.6623299997 | 37.7783250403386 | -122.47061578659999 | (37.7783250403386, -122.4706157866) |
| 54653 | 54653 | 51291 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2020 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | 1 | Permit Number 47663 | 5989189.38676 | 2113364.18569 | 37.7822714342333 | -122.481085302679 | (37.7822714342333, -122.481085302679) | ||
| 56087 | 56087 | 58297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1978 12:00:00 AM | 1 | Permit Number 17314 | 5995266.20192 | 2113689.20735 | 37.783515241763894 | -122.46008592615101 | (37.7835152417639, -122.460085926151) | ||
| 57170 | 57170 | 114542 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2035 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011944.84803 | 2103714.6650900003 | 37.757072587740296 | -122.401682603564 | (37.7570725877403, -122.401682603564) | ||
| 63276 | 63276 | 59606 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1077 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 1 | 3x3 | Permit Number 19007 | 6015566.4484 | 2104073.9972599996 | 37.7582606677124 | -122.38918270881099 | (37.7582606677124, -122.389182708811) | |
| 64127 | 64127 | 105980 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 750 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2014 12:00:00 AM | 1 | 3x4 | Permit Number 772437 | 5989466.7948900005 | 2110227.47578 | 37.7736750233383 | -122.479895995237 | (37.7736750233383, -122.479895995237) | |
| 68025 | 68025 | 95831 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767565 | 6010225.581130001 | 2112036.57812 | 37.7798265614898 | -122.408215431797 | (37.7798265614898, -122.408215431797) |
| 73545 | 73545 | 30881 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 59 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | 1 | Permit Number 34714 | 6004013.78951 | 2108865.19521 | 37.7707689396642 | -122.42947852651301 | (37.7707689396642, -122.429478526513) | ||
| 125064 | 125064 | 32691 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 480 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 1 | Permit Number 37101 | 6010795.05101 | 2111971.34075 | 37.7796793055824 | -122.406240776896 | (37.7796793055824, -122.406240776896) | |
| 126323 | 126323 | 103499 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989789.80565 | 2110619.51755 | 37.774770222886204 | -122.478807342211 | (37.7747702228862, -122.478807342211) | |
| 132392 | 132392 | 41910 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 595 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2000 12:00:00 AM | 1 | Permit Number 42273 | 5992200.00918 | 2111450.35788 | 37.7771911401531 | -122.470530554439 | (37.7771911401531, -122.470530554439) | ||
| 135433 | 135433 | 96081 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767704 | 5983251.84023 | 2110453.37841 | 37.773932253218 | -122.501410848383 | (37.773932253218, -122.501410848383) |
| 135464 | 135464 | 88201 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 436 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51208 | 6011209.66735 | 2112097.91592 | 37.780050034925104 | -122.404815345178 | (37.7800500349251, -122.404815345178) | |
| 136410 | 136410 | 82431 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 650 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52680 | 5982600.56645 | 2111346.95635 | 37.7763474878375 | -122.503729865488 | (37.7763474878375, -122.503729865488) | |
| 138481 | 138481 | 106920 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6006764.0 | 2107336.0 | 37.76672546023 | -122.419856949025 | (37.76672546023, -122.419856949025) | ||||
| 146930 | 146930 | 103497 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989824.39083 | 2110619.3957 | 37.7747718964667 | -122.47868769738001 | (37.7747718964667, -122.47868769738) | |
| 147133 | 147133 | 68292 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 1 | Permit Number 32101 | 5991174.54811 | 2115022.5246200003 | 37.7869399743547 | -122.47433864858101 | (37.7869399743547, -122.474338648581) | |
| 148645 | 148645 | 34700 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 546 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52703 | 5981644.97521 | 2112008.50675 | 37.7781076783894 | -122.507084551143 | (37.7781076783894, -122.507084551143) | |
| 155442 | 155442 | 88202 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 436 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51208 | 6011181.036719999 | 2112067.6395 | 37.779965302598704 | -122.404912259701 | (37.7799653025987, -122.404912259701) | |
| 158832 | 158832 | 114543 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2035 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011964.29912 | 2103715.1701700003 | 37.7570750599871 | -122.401615369369 | (37.7570750599871, -122.401615369369) | ||
| 160586 | 160586 | 95194 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 517 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767108 | 5985627.976369999 | 2112321.20657 | 37.7792000368481 | -122.49332915492701 | (37.7792000368481, -122.493329154927) | |
| 163678 | 163678 | 81982 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 563 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49998 | 5982533.65676 | 2111927.12728 | 37.7779365331701 | -122.504004303472 | (37.7779365331701, -122.504004303472) | |
| 170172 | 170172 | 59138 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 531 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 1 | Permit Number 18444 | 5992185.73773 | 2111803.62567 | 37.7781602921817 | -122.47060565987302 | (37.7781602921817, -122.470605659873) | ||
| 170297 | 170297 | 65278 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 415 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 1 | Permit Number 28081 | 6011215.3927 | 2112332.46737 | 37.7806943784819 | -122.40481205633999 | (37.7806943784819, -122.40481205634) | |
| 171618 | 171618 | 68224 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1500 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2012 12:00:00 AM | 1 | Permit Number 769229 | 5990833.387490001 | 2113424.07906 | 37.782531317215295 | -122.47540222511999 | (37.7825313172153, -122.47540222512) | |
| 177092 | 177092 | 94734 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53865 | 5992586.2471199995 | 2110603.0007 | 37.7748868521692 | -122.46913276056002 | (37.7748868521692, -122.46913276056) |
| 180014 | 180014 | 100870 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 23 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769325 | 5995481.9791 | 2111446.40578 | 37.7773695144675 | -122.45917696584299 | (37.7773695144675, -122.459176965843) | |
| 180438 | 180438 | 103498 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989807.55073 | 2110619.1422900003 | 37.774770222887604 | -122.478745931564 | (37.7747702228876, -122.478745931564) | |
| 184129 | 184129 | 32690 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 480 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 1 | Permit Number 37101 | 6010817.622359999 | 2111993.44255 | 37.7797412544913 | -122.406164249981 | (37.7797412544913, -122.406164249981) | |
| 185481 | 185481 | 51890 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 475 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | 1 | Permit Number 48103 | 6010867.53759 | 2112000.42013 | 37.779763205136206 | -122.40599206220301 | (37.7797632051362, -122.405992062203) | ||
| 186347 | 186347 | 47388 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 476Howard Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | 1 | Permit Number 45304 | 6010838.51311 | 2112011.8477 | 37.7797929592141 | -122.406093276399 | (37.7797929592141, -122.406093276399) | ||
| 23887 | 23887 | 83255 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5983253.61867 | 2110435.38712 | 37.773882958787205 | -122.501403365431 | (37.7738829587872, -122.501403365431) | |||
| 24549 | 24549 | 239423 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000623.604780001 | 2102403.64868 | 37.7528345937605 | -122.44074164393 | (37.7528345937605, -122.44074164393) | |||
| 24786 | 24786 | 123887 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 235 12th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992115.40766 | 2113777.13838 | 37.783574950661794 | -122.47099276010701 | (37.7835749506618, -122.470992760107) | |||
| 24941 | 24941 | 214585 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1275 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991735.0327699995 | 2106752.18709 | 37.7642643321484 | -122.471796560669 | (37.7642643321484, -122.471796560669) | |||
| 25494 | 25494 | 237385 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008720.74445 | 2101541.69648 | 37.750925664000704 | -122.412679212271 | (37.7509256640007, -122.412679212271) | |||
| 26420 | 26420 | 237140 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1285 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010074.8833099995 | 2101754.71583 | 37.7515864768406 | -122.40801147007099 | (37.7515864768406, -122.408011470071) | |||
| 26868 | 26868 | 135947 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 31 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001885.41156 | 2120707.63326 | 37.803164505492504 | -122.43768887996201 | (37.8031645054925, -122.437688879962) | |||
| 27296 | 27296 | 213681 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6000730.35653 | 2095033.04499 | 37.7326027399078 | -122.439844065674 | (37.7326027399078, -122.439844065674) | |||
| 28064 | 28064 | 237394 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2849 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009003.01461 | 2101888.403 | 37.751893481115395 | -122.41172758658399 | (37.7518934811154, -122.411727586584) | |||
| 28184 | 28184 | 214762 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Northwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5995454.99385 | 2094213.2008599997 | 37.730049946826796 | -122.45802284817199 | (37.7300499468268, -122.458022848172) | |||
| 28369 | 28369 | 237264 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 780 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007326.8188 | 2095184.16778 | 37.7333909723093 | -122.417049136835 | (37.7333909723093, -122.417049136835) | |||
| 28640 | 28640 | 124153 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 950 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996057.73725 | 2112257.8824 | 37.7796306981474 | -122.45724396024201 | (37.7796306981474, -122.457243960242) | |||
| 28695 | 28695 | 214477 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1587 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990545.71643 | 2104592.61626 | 37.758265842404 | -122.47575231233601 | (37.758265842404, -122.475752312336) | |||
| 29523 | 29523 | 237237 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 643 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998666.13007 | 2105451.86711 | 37.7610925752937 | -122.44773034478001 | (37.7610925752937, -122.44773034478) | |||
| 29741 | 29741 | 196461 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 615 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014144.28645 | 2104277.08263 | 37.7587393543665 | -122.39411542098999 | (37.7587393543665, -122.39411542099) | |||
| 29788 | 29788 | 214638 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1239 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993279.003830001 | 2107062.36881 | 37.7652052226678 | -122.466478993514 | (37.7652052226678, -122.466478993514) | |||
| 29862 | 29862 | 237360 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1328 Treat Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008685.53865 | 2100922.75177 | 37.749224204239 | -122.412757205096 | (37.749224204239, -122.412757205096) | |||
| 29919 | 29919 | 237125 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 900 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008561.37097 | 2103253.06793 | 37.7556157579627 | -122.413351355702 | (37.7556157579627, -122.413351355702) | |||
| 30296 | 30296 | 202045 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Exeter St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012584.35783 | 2091031.2434099999 | 37.7222822496095 | -122.39858091108201 | (37.7222822496095, -122.398580911082) | |||
| 30654 | 30654 | 237210 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002788.0313800005 | 2099167.4963 | 37.744071904607395 | -122.43302547424 | (37.7440719046074, -122.43302547424) | ||||
| 30946 | 30946 | 214679 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2662 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991458.95209 | 2097290.33549 | 37.7382685749396 | -122.472061728486 | (37.7382685749396, -122.472061728486) | |||
| 31049 | 31049 | 237165 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1801 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009370.48822 | 2099100.96041 | 37.7442603881066 | -122.41026001891001 | (37.7442603881066, -122.41026001891) | |||
| 31418 | 31418 | 238116 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3011 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009261.554769999 | 2104491.09339 | 37.7590543832636 | -122.41101733168999 | (37.7590543832636, -122.41101733169) | |||
| 31810 | 31810 | 214634 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1258 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992402.51004 | 2106874.95458 | 37.764640016757795 | -122.469496904268 | (37.7646400167578, -122.469496904268) | |||
| 32898 | 32898 | 237151 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Hampshire St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010131.8746 | 2105435.17727 | 37.761695390857795 | -122.40807391988001 | (37.7616953908578, -122.40807391988) | |||
| 32991 | 32991 | 237208 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002753.541619999 | 2099167.64088 | 37.74407034517979 | -122.433144742342 | (37.7440703451798, -122.433144742342) | ||||
| 33402 | 33402 | 237389 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008835.28321 | 2101547.20536 | 37.750947218045795 | -122.412283514173 | (37.7509472180458, -122.412283514173) | |||
| 33416 | 33416 | 196500 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 468 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010880.72676 | 2112052.38014 | 37.7799066128255 | -122.405950096213 | (37.7799066128255, -122.405950096213) | |||
| 33473 | 33473 | 214546 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 714 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993519.43334 | 2106675.98145 | 37.7641581752734 | -122.465619338785 | (37.7641581752734, -122.465619338785) | |||
| 33846 | 33846 | 123222 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5993211.31332 | 2110438.04706 | 37.7744700313031 | -122.466958548333 | (37.7744700313031, -122.466958548333) | |||
| 34005 | 34005 | 196506 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016688.4000699995 | 2094936.9316 | 37.7332342924349 | -122.384666003252 | (37.7332342924349, -122.384666003252) | |||
| 34050 | 34050 | 214489 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2083 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991276.32219 | 2101284.43599 | 37.7492247771203 | -122.47298434476801 | (37.7492247771203, -122.472984344768) | |||
| 34465 | 34465 | 179159 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001727.04807 | 2087313.1468599997 | 37.711462320802205 | -122.435846103423 | (37.7114623208022, -122.435846103423) | |||
| 34716 | 34716 | 237236 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 641 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998663.85715 | 2105470.4547200003 | 37.761143482317294 | -122.447739543949 | (37.7611434823173, -122.447739543949) | |||
| 34728 | 34728 | 123892 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 285 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992432.92995 | 2113586.68874 | 37.7830703873676 | -122.469880394252 | (37.7830703873676, -122.469880394252) | |||
| 35914 | 35914 | 196425 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6011155.7597199995 | 2111427.64984 | 37.778206627062296 | -122.404954631245 | (37.7782066270623, -122.404954631245) | |||
| 36046 | 36046 | 237218 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1534 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003930.350380001 | 2099302.4493400003 | 37.744507183667295 | -122.42908521071699 | (37.7445071836673, -122.429085210717) | |||
| 36262 | 36262 | 238321 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 129 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999968.6486599995 | 2105032.89953 | 37.760016551754 | -122.443195417152 | (37.760016551754, -122.443195417152) | |||
| 36963 | 36963 | 179014 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 174 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004359.78757 | 2090147.3010099998 | 37.7193934976835 | -122.426948390073 | (37.7193934976835, -122.426948390073) | |||
| 37932 | 37932 | 120691 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 346 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5989055.073580001 | 2112994.27839 | 37.7812479638107 | -122.481522861281 | (37.7812479638107, -122.481522861281) | |||
| 37977 | 37977 | 72335 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 775 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 1 | 5988805.09626 | 2110041.06897 | 37.773124736634294 | -122.482171226619 | (37.7731247366343, -122.482171226619) | ||
| 38688 | 38688 | 237334 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 379 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007338.79094 | 2096540.2275099999 | 37.737115088292 | -122.417103799428 | (37.737115088292, -122.417103799428) | |||
| 40351 | 40351 | 237387 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008814.668380001 | 2101545.8698 | 37.7509423940946 | -122.412354708115 | (37.7509423940946, -122.412354708115) | |||
| 40632 | 40632 | 120241 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 288 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5988396.42783 | 2114046.0373400003 | 37.784097477489794 | -122.483878566425 | (37.7840974774898, -122.483878566425) | |||
| 41091 | 41091 | 214637 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1231 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993277.56181 | 2107122.2146799997 | 37.765369460447296 | -122.466488331178 | (37.7653694604473, -122.466488331178) | |||
| 42773 | 42773 | 237209 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002775.7731 | 2099167.46556 | 37.744071124872896 | -122.43306785839899 | (37.7440711248729, -122.433067858399) | ||||
| 43645 | 43645 | 213424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2329 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991443.60729 | 2099536.95345 | 37.7444363251911 | -122.47227850735001 | (37.7444363251911, -122.47227850735) | |||
| 43899 | 43899 | 214548 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 800 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 4ft | 5993241.508719999 | 2106665.1801299998 | 37.7641124834295 | -122.46657980664 | (37.7641124834295, -122.46657980664) | |||
| 45768 | 45768 | 109206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2322 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 774968 | 5991447.56759 | 2112037.47435 | 37.77875966432521 | -122.47317629235901 | (37.7787596643252, -122.473176292359) | ||
| 47200 | 47200 | 214819 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001004.15668 | 2094363.7751900002 | 37.730780661291206 | -122.438849530576 | (37.7307806612912, -122.438849530576) | |||
| 48537 | 48537 | 116894 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6001897.52549 | 2120678.68583 | 37.8030857122852 | -122.43764488509899 | (37.8030857122852, -122.437644885099) | |||
| 48960 | 48960 | 214716 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 163 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993482.35353 | 2094088.81019 | 37.729594862901 | -122.46483342661502 | (37.729594862901, -122.464833426615) | |||
| 49034 | 49034 | 214547 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 754 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993387.3182 | 2106668.96839 | 37.764131298133 | -122.46607577350099 | (37.764131298133, -122.466075773501) | |||
| 49492 | 49492 | 135940 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 310 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5997632.68283 | 2115371.58358 | 37.7882704283935 | -122.452020280013 | (37.7882704283935, -122.452020280013) | |||
| 50315 | 50315 | 237149 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010132.87275 | 2105399.32846 | 37.7615970140239 | -122.408067939392 | (37.7615970140239, -122.408067939392) | |||
| 50428 | 50428 | 237250 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999614.9988400005 | 2106452.87899 | 37.763895290861605 | -122.444520573572 | (37.7638952908616, -122.444520573572) | |||
| 50840 | 50840 | 237249 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999617.47988 | 2106464.70048 | 37.7639278912924 | -122.444512842101 | (37.7639278912924, -122.444512842101) | |||
| 51276 | 51276 | 214657 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2033 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990646.87273 | 2101531.01352 | 37.7498653525019 | -122.475178967532 | (37.7498653525019, -122.475178967532) | |||
| 53260 | 53260 | 178985 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 276 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5998310.44307 | 2088707.23579 | 37.7150954964391 | -122.447755025789 | (37.7150954964391, -122.447755025789) | |||
| 53356 | 53356 | 238510 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004605.35635 | 2096606.41263 | 37.737142667797706 | -122.42655923724399 | (37.7371426677977, -122.426559237244) | |||
| 54381 | 54381 | 123144 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 572 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5992865.77571 | 2111587.1444200003 | 37.7776051929209 | -122.46823742950501 | (37.7776051929209, -122.468237429505) |
JSON shape: default, array, newline-delimited
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");