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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 72974 | 72974 | 213652 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Edgehill Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994842.29481 | 2099078.88139 | 37.743374684505206 | -122.46049344413099 | (37.7433746845052, -122.460493444131) | |||
| 149108 | 149108 | 213571 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995317.16684 | 2100218.39007 | 37.746530798564 | -122.458933955845 | (37.746530798564, -122.458933955845) | |||
| 10801 | 10801 | 83237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769756 | 6004043.10746 | 2093201.4009 | 37.727761469894794 | -122.42826058457099 | (37.7277614698948, -122.428260584571) |
| 182840 | 182840 | 179092 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Naples St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004478.253830001 | 2092876.7352900002 | 37.7268946223776 | -122.42673316430201 | (37.7268946223776, -122.426733164302) | |||
| 165776 | 165776 | 179116 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Yale St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006991.89793 | 2093240.59071 | 37.7280354870245 | -122.418069316059 | (37.7280354870245, -122.418069316059) | |||
| 50139 | 50139 | 136013 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006984.715969999 | 2120484.67695 | 37.8028409447119 | -122.420026726469 | (37.8028409447119, -122.420026726469) | |||
| 158154 | 158154 | 79061 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1006 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 4 | 6012156.574130001 | 2103666.55961 | 37.756952313327396 | -122.40094698961599 | (37.7569523133274, -122.400946989616) | ||
| 106963 | 106963 | 27248 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100X CORTLAND AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2000 12:00:00 AM | 4 | 3X3 | 6006272.0 | 2097672.0 | 37.7401626122958 | -122.420872513823 | (37.7401626122958, -122.420872513823) | ||
| 72144 | 72144 | 87155 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50137 | 5992081.9043 | 2114697.2023099996 | 37.7860992546106 | -122.471175721775 | (37.7860992546106, -122.471175721775) | |
| 62835 | 62835 | 179146 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 102 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011358.3265 | 2092604.64263 | 37.726534098550204 | -122.40292964310301 | (37.7265340985502, -122.402929643103) | |||
| 52218 | 52218 | 136001 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009476.76834 | 2116835.36375 | 37.792960917161395 | -122.41114498327299 | (37.7929609171614, -122.411144983273) | |||
| 56430 | 56430 | 135998 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009470.07385 | 2116888.9827900003 | 37.7931077665596 | -122.411171935935 | (37.7931077665596, -122.411171935935) | |||
| 130216 | 130216 | 135999 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009475.36486 | 2116853.62807 | 37.79301098783029 | -122.411151130141 | (37.7930109878303, -122.411151130141) | |||
| 169477 | 169477 | 136000 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009476.57256 | 2116845.84647 | 37.792989689179294 | -122.411146401493 | (37.7929896891793, -122.411146401493) | |||
| 180962 | 180962 | 214752 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995609.0834800005 | 2093408.98072 | 37.727850604413796 | -122.457431983704 | (37.7278506044138, -122.457431983704) | |||
| 72980 | 72980 | 69395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1075 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33499 | 6002066.46838 | 2087158.9447 | 37.711058190666705 | -122.43466196070801 | (37.7110581906667, -122.434661960708) | |
| 65343 | 65343 | 237117 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1086 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005704.9636699995 | 2102692.93709 | 37.7539169809013 | -122.423189907394 | (37.7539169809013, -122.423189907394) | |||
| 61341 | 61341 | 237229 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998076.1875599995 | 2106198.82247 | 37.7631097915092 | -122.449824524095 | (37.7631097915092, -122.449824524095) | |||
| 66393 | 66393 | 213312 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Caine Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997293.25449 | 2089167.74263 | 37.716301751698204 | -122.451304041065 | (37.7163017516982, -122.451304041065) | |||
| 147069 | 147069 | 213311 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997282.73831 | 2089151.44786 | 37.716256407882106 | -122.451339215357 | (37.7162564078821, -122.451339215357) | |||
| 54370 | 54370 | 238412 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000623.254480001 | 2105558.02265 | 37.761495715270904 | -122.44096912924499 | (37.7614957152709, -122.440969129245) | |||
| 176728 | 176728 | 238413 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000620.6168 | 2105576.07492 | 37.761545132131296 | -122.440979546976 | (37.7615451321313, -122.440979546976) | |||
| 29713 | 29713 | 88413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51386 | 6009439.10659 | 2116768.27237 | 37.792774588415796 | -122.411270553799 | (37.7927745884158, -122.411270553799) | |
| 51355 | 51355 | 196467 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6015482.81101 | 2101057.8670900003 | 37.7499743755266 | -122.389261356351 | (37.7499743755266, -122.389261356351) | |||
| 60536 | 60536 | 214519 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992317.04824 | 2106570.7861599997 | 37.763799911465 | -122.46977034493901 | (37.763799911465, -122.469770344939) | |||
| 160997 | 160997 | 214553 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1104 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992323.456069999 | 2106634.49291 | 37.7639752037022 | -122.46975282075701 | (37.7639752037022, -122.469752820757) | |||
| 149456 | 149456 | 213310 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997269.145819999 | 2089132.21478 | 37.716202819983 | -122.451384810958 | (37.716202819983, -122.451384810958) | |||
| 166833 | 166833 | 238516 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001807.33737 | 2096679.7017700002 | 37.7371853253266 | -122.43623848751999 | (37.7371853253266, -122.43623848752) | |||
| 27798 | 27798 | 238400 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002888.32666 | 2107612.09162 | 37.7672644381318 | -122.433281965392 | (37.7672644381318, -122.433281965392) | |||
| 93408 | 93408 | 213521 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 112 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995640.44181 | 2093438.11503 | 37.7279324013586 | -122.45732568475401 | (37.7279324013586, -122.457325684754) | |||
| 165990 | 165990 | 238260 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Hartford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002684.23387 | 2105269.06904 | 37.7608194871373 | -122.433820405688 | (37.7608194871373, -122.433820405688) | |||
| 38128 | 38128 | 88409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | |
| 44141 | 44141 | 88407 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | |
| 66520 | 66520 | 100031 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | |
| 27655 | 27655 | 135992 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009196.7187 | 2117357.70571 | 37.7943794313202 | -122.41215090645201 | (37.7943794313202, -122.412150906452) | |||
| 28028 | 28028 | 135997 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009336.40364 | 2117377.1493 | 37.794440655352794 | -122.411668952587 | (37.7944406553528, -122.411668952587) | |||
| 74178 | 74178 | 135994 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009269.53041 | 2117367.6946099997 | 37.794410943569495 | -122.411899674537 | (37.7944109435695, -122.411899674537) | |||
| 164530 | 164530 | 135993 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009221.31733 | 2117360.97425 | 37.794389786122 | -122.412066023053 | (37.794389786122, -122.412066023053) | |||
| 164977 | 164977 | 135995 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009287.1824 | 2117369.66466 | 37.7944173431466 | -122.41183873557199 | (37.7944173431466, -122.411838735572) | |||
| 185356 | 185356 | 135996 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009314.46183 | 2117374.97438 | 37.794433452692104 | -122.41174472045601 | (37.7944334526921, -122.411744720456) | |||
| 37522 | 37522 | 213670 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 3ft | 5994884.54629 | 2098945.43271 | 37.74301069827921 | -122.460337683337 | (37.7430106982792, -122.460337683337) | |||
| 147471 | 147471 | 213666 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 3ft | 5994837.41528 | 2098931.7185400003 | 37.742970331311795 | -122.460499654841 | (37.7429703313118, -122.460499654841) | |||
| 70386 | 70386 | 237336 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007250.44992 | 2096983.00447 | 37.7383258860178 | -122.417440605404 | (37.7383258860178, -122.417440605404) | |||
| 181691 | 181691 | 213563 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996504.15927 | 2094478.31136 | 37.7308381018815 | -122.454414916535 | (37.7308381018815, -122.454414916535) | |||
| 55416 | 55416 | 237434 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1206 Diamond St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6001928.49113 | 2100507.97364 | 37.7477037465288 | -122.436093471852 | (37.7477037465288, -122.436093471852) | |||
| 176153 | 176153 | 237433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1206 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6001927.83941 | 2100530.44886 | 37.747765421138794 | -122.43609733352699 | (37.7477654211388, -122.436097333527) | |||
| 170449 | 170449 | 179031 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Tucker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010327.66378 | 2088774.95095 | 37.7159609509146 | -122.406222917279 | (37.7159609509146, -122.406222917279) | |||
| 152346 | 152346 | 213377 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1210 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993321.34014 | 2107196.20465 | 37.765575143506105 | -122.46634229118901 | (37.7655751435061, -122.466342291189) | |||
| 20141 | 20141 | 27518 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 4 | 3x3 | 6005759.73558 | 2101716.47325 | 37.751238927544605 | -122.422931097816 | (37.7512389275446, -122.422931097816) | ||
| 53666 | 53666 | 237053 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 123 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005912.27788 | 2106519.83607 | 37.76443644800921 | -122.42274490845301 | (37.7644364480092, -122.422744908453) | |||
| 154108 | 154108 | 70417 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 4 | 6007053.10759 | 2093048.1738200001 | 37.7275105968359 | -122.417844078137 | (37.7275105968359, -122.417844078137) | ||
| 57270 | 57270 | 213376 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1243 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993278.150880001 | 2107040.93522 | 37.7651463224575 | -122.46648038567 | (37.7651463224575, -122.46648038567) | |||
| 153620 | 153620 | 214510 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1246 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990818.1577 | 2106901.7104599997 | 37.7646217901831 | -122.47497865434799 | (37.7646217901831, -122.474978654348) | |||
| 188393 | 188393 | 238414 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000656.2221099995 | 2105622.5799 | 37.761674851230296 | -122.44085973930099 | (37.7616748512303, -122.440859739301) | |||
| 178321 | 178321 | 213623 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995805.80133 | 2096226.42669 | 37.7355979265959 | -122.456955630803 | (37.7355979265959, -122.456955630803) | |||
| 62188 | 62188 | 213582 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Garcia Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994660.96861 | 2099488.84226 | 37.7444899013971 | -122.461150129069 | (37.7444899013971, -122.461150129069) | |||
| 159600 | 159600 | 213583 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Garcia Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994657.50527 | 2099501.27559 | 37.744523840899205 | -122.46116300556801 | (37.7445238408992, -122.461163005568) | |||
| 129977 | 129977 | 237182 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009861.192009999 | 2099851.79535 | 37.746349510516204 | -122.40861621916099 | (37.7463495105162, -122.408616219161) | |||
| 44379 | 44379 | 214636 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1254 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992710.27647 | 2106925.6088900003 | 37.7647968818831 | -122.46843611705299 | (37.7647968818831, -122.468436117053) | |||
| 135490 | 135490 | 214590 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1272 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5994263.614440001 | 2106823.5038099997 | 37.764606128503 | -122.463056154933 | (37.764606128503, -122.463056154933) | |||
| 153724 | 153724 | 214635 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1276 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5992405.22777 | 2106756.96673 | 37.764316210447504 | -122.469478915116 | (37.7643162104475, -122.469478915116) | |||
| 73158 | 73158 | 213599 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 128 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994429.75237 | 2101162.69532 | 37.7490725713631 | -122.46207098449601 | (37.7490725713631, -122.462070984496) | |||
| 30897 | 30897 | 214641 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1281 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993288.48621 | 2106790.9815599998 | 37.7644606118874 | -122.46642647040501 | (37.7644606118874, -122.466426470405) | |||
| 130339 | 130339 | 92531 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1298X Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6011695.143180001 | 2102366.06354 | 37.75335568701529 | -122.40245135756201 | (37.7533556870153, -122.402451357562) | ||||
| 61846 | 61846 | 214827 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Marston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5998577.38588 | 2093218.92266 | 37.7274987986193 | -122.447156866022 | (37.7274987986193, -122.447156866022) | |||
| 45874 | 45874 | 213559 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Montecito Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996394.710419999 | 2094260.17076 | 37.7302328626481 | -122.45477754205099 | (37.7302328626481, -122.454777542051) | |||
| 28434 | 28434 | 196463 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014925.6309 | 2101062.89752 | 37.7499572830217 | -122.39118848116999 | (37.7499572830217, -122.39118848117) | |||
| 173218 | 173218 | 237348 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1305 Eugenia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008557.2056599995 | 2097676.42362 | 37.740303301858 | -122.412971483856 | (37.740303301858, -122.412971483856) | |||
| 132738 | 132738 | 213367 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1307 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994533.24595 | 2106589.65287 | 37.76397956273821 | -122.462106618336 | (37.7639795627382, -122.462106618336) | |||
| 50228 | 50228 | 238074 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007150.37364 | 2097131.4565700002 | 37.7387278712849 | -122.41779714071801 | (37.7387278712849, -122.417797140718) | |||
| 30298 | 30298 | 214610 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1317 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993294.793 | 2106507.24559 | 37.7636819114108 | -122.466384034097 | (37.7636819114108, -122.466384034097) | |||
| 161023 | 161023 | 214591 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1333 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993612.54689 | 2106403.41455 | 37.7634151482214 | -122.46527748849199 | (37.7634151482214, -122.465277488492) | |||
| 133457 | 133457 | 238178 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1333 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002577.4131 | 2101632.9259 | 37.7508294455348 | -122.43392993593001 | (37.7508294455348, -122.43392993593) | |||
| 150154 | 150154 | 214604 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1340 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993354.43773 | 2106360.8901400003 | 37.7632834991452 | -122.466167106819 | (37.7632834991452, -122.466167106819) | |||
| 4821 | 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) | ||
| 73855 | 73855 | 214603 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1342 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993355.88687 | 2106339.40983 | 37.7632246034565 | -122.46616053369301 | (37.7632246034565, -122.466160533693) | |||
| 69039 | 69039 | 214487 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1351 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991108.21615 | 2106198.3695400003 | 37.7627074096277 | -122.47392411200701 | (37.7627074096277, -122.473924112007) | |||
| 170090 | 170090 | 214602 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1352 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993354.826830001 | 2106288.96143 | 37.7630860242229 | -122.46616053368 | (37.7630860242229, -122.46616053368) | |||
| 45036 | 45036 | 214593 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1359 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993615.46246 | 2106240.58605 | 37.7629682319156 | -122.46525557650801 | (37.7629682319156, -122.465255576508) | |||
| 25834 | 25834 | 214493 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1359 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991433.81997 | 2106159.32578 | 37.762619060232296 | -122.47279512831001 | (37.7626190602323, -122.47279512831) | |||
| 136542 | 136542 | 213516 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 136 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995661.5652 | 2093604.66303 | 37.728390915308 | -122.457264704412 | (37.728390915308, -122.457264704412) | |||
| 133380 | 133380 | 214601 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1360 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993356.82436 | 2106203.11935 | 37.7628504396238 | -122.46614738648701 | (37.7628504396238, -122.466147386487) | |||
| 149637 | 149637 | 135931 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1361 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004797.09073 | 2120517.98623 | 37.8028089081649 | -122.42759940931002 | (37.8028089081649, -122.42759940931) | |||
| 130416 | 130416 | 214600 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1368 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993361.42673 | 2106180.94195 | 37.7627898118252 | -122.46612985693301 | (37.7627898118252, -122.466129856933) | |||
| 62059 | 62059 | 179134 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010795.656719999 | 2093351.7204900002 | 37.7285539830718 | -122.404927357511 | (37.7285539830718, -122.404927357511) | |||
| 166435 | 166435 | 179135 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010828.32671 | 2093363.20014 | 37.7285873299367 | -122.404815222846 | (37.7285873299367, -122.404815222846) | |||
| 180872 | 180872 | 179136 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Burrows St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010838.78874 | 2093367.25092 | 37.7285990373024 | -122.404779339894 | (37.7285990373024, -122.404779339894) | |||
| 49643 | 49643 | 214599 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1372 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993361.64911 | 2106161.3799 | 37.7627361123925 | -122.466127666177 | (37.7627361123925, -122.466127666177) | |||
| 67343 | 67343 | 214598 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1376 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993363.63892 | 2106135.47177 | 37.762665090255496 | -122.466118901381 | (37.7626650902555, -122.466118901381) | |||
| 182153 | 182153 | 214597 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1380 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993363.01616 | 2106105.83321 | 37.7625836746058 | -122.46611890136299 | (37.7625836746058, -122.466118901363) | |||
| 56771 | 56771 | 238468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 139 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002785.88822 | 2109064.42785 | 37.7712463852336 | -122.433740098024 | (37.7712463852336, -122.433740098024) | |||
| 151561 | 151561 | 136015 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Havens St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6007560.5835 | 2119380.86157 | 37.7998425735334 | -122.417955630044 | (37.7998425735334, -122.417955630044) | |||
| 69423 | 69423 | 57395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1415 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1994 12:00:00 AM | 4 | Permit Number 33423 | 6007958.46126 | 2117300.9237 | 37.7941539658926 | -122.41643141230499 | (37.7941539658926, -122.416431412305) | ||
| 136184 | 136184 | 114855 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1416x Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006703.84741 | 2115349.3843 | 37.7887248899861 | -122.42063391904499 | (37.7887248899861, -122.420633919045) | |||
| 61714 | 61714 | 214578 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1419 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991327.39991 | 2106536.51596 | 37.7636485627529 | -122.473190703187 | (37.7636485627529, -122.473190703187) | |||
| 53632 | 53632 | 237049 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1420 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010399.818580001 | 2100970.62017 | 37.7494517102366 | -122.40683254161199 | (37.7494517102366, -122.406832541612) | |||
| 137361 | 137361 | 214562 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1426 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991293.47534 | 2106598.40333 | 37.763816524628204 | -122.473312550532 | (37.7638165246282, -122.473312550532) | |||
| 150684 | 150684 | 214577 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1427 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991285.40608 | 2106533.11575 | 37.76363679511471 | -122.47333569728201 | (37.7636367951147, -122.473335697282) | |||
| 154160 | 154160 | 214575 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1437 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991239.6267099995 | 2106533.99936 | 37.7636365703049 | -122.47349409668502 | (37.7636365703049, -122.473494096685) | |||
| 182464 | 182464 | 214574 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1441 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991211.29509 | 2106533.5678 | 37.7636337446377 | -122.473592054438 | (37.7636337446377, -122.473592054438) |
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");