Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 136860 | 136860 | 107594 | Permitted Site 1 | Prunus campanulata :: Taiwan Flowering Cherry 537 | 1801X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x6 | 5993052.66806 | 2112040.96292 | 37.778862048054 | -122.467623923273 | (37.778862048054, -122.467623923273) | |||
| 109005 | 109005 | 99791 | Undocumented 2 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 520 | 4120-4124 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x4 | 6002399.0 | 2101817.0 | 37.7513247429435 | -122.43456006421499 | (37.7513247429435, -122.434560064215) | ||||
| 122132 | 122132 | 99793 | Undocumented 2 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 520 | 4120-4124 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002399.0 | 2101817.0 | 37.7513247429435 | -122.43456006421499 | (37.7513247429435, -122.434560064215) | ||||
| 107483 | 107483 | 51021 | Permitted Site 1 | Prunus sargentii :: Sargent Cherry 517 | 4275 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50421 | 6001430.71351981 | 2101713.7407115 | 37.750986202789 | -122.43790110742201 | (37.750986202789, -122.437901107422) | ||
| 87008 | 87008 | 108240 | Undocumented 2 | Prunus serrula :: Birchbark Cherry 495 | 163 DELMAR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5999383.5 | 2107248.1 | 37.766065556669396 | -122.445378437485 | (37.7660655566694, -122.445378437485) | |||
| 91238 | 91238 | 107719 | Permitted Site 1 | Prunus serrula :: Birchbark Cherry 495 | 3301x 18TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774073 | 6007483.0 | 2105569.0 | 37.761914169510604 | -122.417244815958 | (37.7619141695106, -122.417244815958) | |
| 98556 | 98556 | 97557 | Permitted Site 1 | Prunus serrula :: Birchbark Cherry 495 | 1316 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2011 12:00:00 AM | Permit Number 768295 | 5993059.9 | 2106465.7 | 37.7635542817507 | -122.467193428173 | (37.7635542817507, -122.467193428173) | |||
| 86750 | 86750 | 106343 | Permitted Site 1 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497 VALLEY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779.0 | 2099138.0 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | ||
| 97261 | 97261 | 106340 | Permitted Site 1 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497 VALLEY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 770848 | 6002779.0 | 2099138.0 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | |||
| 101029 | 101029 | 122389 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 166 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991334.0 | 2104180.0 | 37.7571785771329 | -122.47299602104601 | (37.7571785771329, -122.472996021046) | ||||
| 101496 | 101496 | 117093 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 2X 09TH AVE | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | |||
| 102296 | 102296 | 117095 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 2X 09TH AVE | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | |||
| 103462 | 103462 | 106338 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497 VALLEY ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779.0 | 2099138.0 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | ||
| 143282 | 143282 | 106339 | Permitted Site 1 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497X Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779.6 | 2099138.4 | 37.7439915346951 | -122.433052549622 | (37.7439915346951, -122.433052549622) | ||
| 145290 | 145290 | 106337 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497 VALLEY ST | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779.0 | 2099138.0 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | ||
| 82574 | 82574 | 107467 | Permitted Site 1 | Prunus sargentii 'Columnaris' :: Sargent Cherry Tree 'Columnaris' 473 | 1643 35th Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/11/2014 12:00:00 AM | 3 | Permit Number 773410 | 5985268.14341 | 2104019.02784 | 37.7563835411873 | -122.493961929435 | (37.7563835411873, -122.493961929435) | |||
| 80729 | 80729 | 97127 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2690 Broadway | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 84471 | 84471 | 97946 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2 Mendosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 3x3 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | ||
| 87567 | 87567 | 100981 | DPW Maintained 3 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 05/03/2013 12:00:00 AM | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||
| 89035 | 89035 | 100982 | DPW Maintained 3 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 05/03/2013 12:00:00 AM | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||
| 108722 | 108722 | 97947 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 3x3 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | ||
| 112108 | 112108 | 97134 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2690 Broadway | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 120643 | 120643 | 97948 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2 Mendosa Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 3x3 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | ||
| 140818 | 140818 | 100980 | DPW Maintained 3 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 05/03/2013 12:00:00 AM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |
| 146003 | 146003 | 97126 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2690 Broadway | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 80682 | 80682 | 41831 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 1359 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42217 | 5991431.78738883 | 2106173.10651318 | 37.76265678079321 | -122.47280316308901 | (37.7626567807932, -122.472803163089) |
| 90098 | 90098 | 41832 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 1359 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 42217 | 5991431.78738883 | 2106173.10651318 | 37.76265678079321 | -122.47280316308901 | (37.7626567807932, -122.472803163089) |
| 104923 | 104923 | 39977 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 2535 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 41236 | 5990760.76494865 | 2098142.10858699 | 37.7405668981047 | -122.474537835541 | (37.7405668981047, -122.474537835541) | ||
| 111796 | 111796 | 24818 | DPW Maintained 3 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 400X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/2015 12:00:00 AM | 3 | 3x3 | 6007983.04766 | 2094988.0680200001 | 37.73288941859111 | -122.41476648967699 | (37.7328894185911, -122.414766489677) | ||
| 112340 | 112340 | 39604 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 3628 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1989 12:00:00 AM | 5 | 3x3 | Permit Number 41007 | 6005441.47926786 | 2104914.36675045 | 37.7600016345446 | -122.424259080531 | (37.7600016345446, -122.424259080531) |
| 114847 | 114847 | 108140 | Undocumented 2 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 3390x 18TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006957.7 | 2105612.4 | 37.7620037686995 | -122.41906470461399 | (37.7620037686995, -122.419064704614) | ||||
| 139070 | 139070 | 46183 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 60 Stonecrest Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 44510 | 5991036.80877736 | 2093807.38449355 | 37.7286808348731 | -122.473267326425 | (37.7286808348731, -122.473267326425) | ||
| 142228 | 142228 | 38658 | Permitted Site 1 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40580 | 5997471.03104632 | 2107818.12364092 | 37.7675213374579 | -122.452034381815 | (37.7675213374579, -122.452034381815) | |
| 78714 | 78714 | 96271 | Permitted Site 1 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 55 Trumbull St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | ||||
| 81522 | 81522 | 95577 | Permitted Site 1 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 4275 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767366 | 6001424.0 | 2101719.0 | 37.75100026176621 | -122.437924700053 | (37.7510002617662, -122.437924700053) | |
| 88233 | 88233 | 47175 | Permitted Site 1 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 75 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767457 | 5993197.64059075 | 2093576.49859777 | 37.7281717618687 | -122.465780492629 | (37.7281717618687, -122.465780492629) | |
| 99450 | 99450 | 96062 | Permitted Site 1 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 417 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767688 | 6009194.6 | 2100253.2 | 37.747414322961504 | -122.410949571503 | (37.7474143229615, -122.410949571503) | |
| 104194 | 104194 | 93171 | Permitted Site 1 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 2920 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/2010 12:00:00 AM | Permit Number 53190 | 6000826.0 | 2115571.0 | 37.7890003682186 | -122.44098627280701 | (37.7890003682186, -122.440986272807) | |||
| 105137 | 105137 | 101918 | DPW Maintained 3 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 114 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3x3 | 6001282.9 | 2098757.3 | 37.742860112399796 | -122.438200492302 | (37.7428601123998, -122.438200492302) | |||
| 109789 | 109789 | 96268 | Permitted Site 1 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 55 Trumbull St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 767873 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | |||
| 123591 | 123591 | 96270 | Permitted Site 1 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 55 Trumbull St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | ||||
| 124627 | 124627 | 96272 | Permitted Site 1 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 55 Trumbull St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 767873 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | |||
| 125778 | 125778 | 92544 | Permitted Site 1 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 137 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2009 12:00:00 AM | 3x3 | Permit Number 52887 | 6010547.0 | 2094083.0 | 37.7305480203361 | -122.405838472752 | (37.7305480203361, -122.405838472752) | ||
| 142152 | 142152 | 96269 | Permitted Site 1 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 55 Trumbull St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | ||||
| 55581 | 55581 | 249708 | Undocumented 2 | Prunus lusitanica :: Portugese Cherry Laurel 430 | 2400 Baker St | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5999695.18411 | 2117183.83938 | 37.7933643296589 | -122.44501472497 | (37.7933643296589, -122.44501472497) | ||||
| 113820 | 113820 | 28265 | DPW Maintained 3 | Prunus lusitanica :: Portugese Cherry Laurel 430 | 2X 12th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992095.82399 | 2114846.95109 | 37.7865112284639 | -122.47113847763 | (37.7865112284639, -122.47113847763) | |||
| 157374 | 157374 | 122908 | DPW Maintained 3 | Prunus lusitanica :: Portugese Cherry Laurel 430 | 2x 12th Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5992093.66064 | 2114888.38015 | 37.7866248560676 | -122.471148981632 | (37.7866248560676, -122.471148981632) | ||||
| 186388 | 186388 | 196346 | Undocumented 2 | Prunus lusitanica :: Portugese Cherry Laurel 430 | 680 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6012073.439230001 | 2105277.1493599997 | 37.761369999043396 | -122.401347684342 | (37.7613699990434, -122.401347684342) | ||||
| 29577 | 29577 | 213706 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 1444 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5990875.43177 | 2105581.50007 | 37.7610001645442 | -122.474684197434 | (37.7610001645442, -122.474684197434) | |||
| 31907 | 31907 | 246740 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 132 Ripley St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 8ft | 6008857.53269 | 2099073.06292 | 37.7441550208325 | -122.41203174448201 | (37.7441550208325, -122.412031744482) | |||
| 40302 | 40302 | 238539 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 4079 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003407.21225 | 2100365.41325 | 37.7473962080773 | -122.430969964019 | (37.7473962080773, -122.430969964019) | |||
| 41059 | 41059 | 196515 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 2075 Palou Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6012358.51021 | 2097085.95445 | 37.7388946487629 | -122.399786553923 | (37.7388946487629, -122.399786553923) | |||
| 41681 | 41681 | 43655 | Permitted Site 1 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 152 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 2 | Permit Number 43299 | 5992759.135869999 | 2114454.8579 | 37.785472992325396 | -122.468815060585 | (37.7854729923254, -122.468815060585) | |
| 46132 | 46132 | 238538 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 2766 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009533.48603 | 2103380.6247400003 | 37.7560205320462 | -122.409998467263 | (37.7560205320462, -122.409998467263) | |||
| 62751 | 62751 | 136028 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 701 Buchanan St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 6ft | 6004477.21749 | 2110912.17552 | 37.7764156757853 | -122.428021412563 | (37.7764156757853, -122.428021412563) | |||
| 85147 | 85147 | 48680 | Permitted Site 1 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 23 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2014 12:00:00 AM | 3x3 | Permit Number 773002 | 6012118.7327785995 | 2095652.09441988 | 37.734944200728606 | -122.40051490481399 | (37.7349442007286, -122.400514904814) | ||
| 88578 | 88578 | 99514 | Permitted Site 1 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 154 Miraloma Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2012 12:00:00 AM | Permit Number 768163 | 5994585.5 | 2096588.5 | 37.73652193950829 | -122.461200886189 | (37.7365219395083, -122.461200886189) | |||
| 114831 | 114831 | 102471 | Permitted Site 1 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 66 Sotelo Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2013 12:00:00 AM | 6/15 | Permit Number 769896 | 5993897.9 | 2101386.8 | 37.7496572701738 | -122.46392638569701 | (37.7496572701738, -122.463926385697) | ||
| 137653 | 137653 | 213707 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 1907 16th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5991230.22664 | 2102378.81623 | 37.752226991095704 | -122.473223546438 | (37.7522269910957, -122.473223546438) | |||
| 146532 | 146532 | 196514 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 2200 Alameda St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6010334.79158 | 2107884.9177 | 37.7684331799705 | -122.40754483165199 | (37.7684331799705, -122.407544831652) | |||
| 148814 | 148814 | 123973 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 67 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993617.7484800005 | 2115063.03526 | 37.7871924476765 | -122.46588874556801 | (37.7871924476765, -122.465888745568) | |||
| 165110 | 165110 | 238540 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 217 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6009894.85304 | 2099616.29886 | 37.7457047739516 | -122.40848321393699 | (37.7457047739516, -122.408483213937) | |||
| 170495 | 170495 | 117867 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 842 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983574.3920599995 | 2110074.48435 | 37.7729108571993 | -122.500267088216 | (37.7729108571993, -122.500267088216) | |||
| 173199 | 173199 | 136030 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 475 Marina Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6000838.224669999 | 2121681.08222 | 37.805777738417795 | -122.441382580867 | (37.8057777384178, -122.441382580867) | |||
| 177121 | 177121 | 117868 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 842 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5983575.47317 | 2110057.58486 | 37.7728645195254 | -122.500262098966 | (37.7728645195254, -122.500262098966) | |||
| 186749 | 186749 | 136029 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 3743 Scott St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000599.31455 | 2121234.7075799997 | 37.804538500507995 | -122.44217730004101 | (37.804538500508, -122.442177300041) | |||
| 186901 | 186901 | 238537 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 2766 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009544.770219999 | 2103381.35603 | 37.7560231724418 | -122.40995949424 | (37.7560231724418, -122.40995949424) | |||
| 27051 | 27051 | 196337 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015979.32592 | 2099953.2392599997 | 37.7469688106565 | -122.38746731498199 | (37.7469688106565, -122.387467314982) | ||||
| 30197 | 30197 | 196336 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 1750 22nd St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6012821.16046 | 2103795.98592 | 37.757344738798 | -122.398657667323 | (37.757344738798, -122.398657667323) | ||||
| 36595 | 36595 | 196340 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 8ft | 6015958.58897 | 2099937.15281 | 37.7469234920398 | -122.387537900079 | (37.7469234920398, -122.387537900079) | |||
| 47420 | 47420 | 237953 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 5569 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6001685.30274 | 2097174.90356 | 37.7385380999471 | -122.436695853025 | (37.7385380999471, -122.436695853025) | |||
| 48787 | 48787 | 237954 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 5569 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6001676.453319999 | 2097164.39417 | 37.7385087406884 | -122.43672569793002 | (37.7385087406884, -122.43672569793) | |||
| 51189 | 51189 | 196345 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015663.1317300005 | 2099868.27306 | 37.7467179933348 | -122.388554766215 | (37.7467179933348, -122.388554766215) | ||||
| 58494 | 58494 | 214359 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 618 Detroit St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5999464.23273 | 2095044.92453 | 37.732563205716204 | -122.444222201904 | (37.7325632057162, -122.444222201904) | |||
| 68337 | 68337 | 196343 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6015689.423719999 | 2099879.91957 | 37.7467514292439 | -122.388464663129 | (37.7467514292439, -122.388464663129) | ||||
| 70989 | 70989 | 196341 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015838.55119 | 2099899.27486 | 37.7468128376585 | -122.387950340845 | (37.7468128376585, -122.387950340845) | ||||
| 81165 | 81165 | 97014 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 85013 | 85013 | 97015 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 94845 | 94845 | 97016 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 112315 | 112315 | 114756 | Permitted Site 1 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 301X Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | Permit Number 777132 | 6010782.8898599995 | 2090965.6524200002 | 37.722001621884 | -122.40480357636001 | (37.722001621884, -122.40480357636) | |||
| 114328 | 114328 | 121377 | Significant Tree 6 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 2701 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001200.0 | 2116539.0 | 37.79167953949779 | -122.439761713662 | (37.7916795394978, -122.439761713662) | ||||
| 131586 | 131586 | 196344 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015666.28786 | 2099877.42762 | 37.7467433047611 | -122.38854449143801 | (37.7467433047611, -122.388544491438) | ||||
| 158271 | 158271 | 237955 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 43 Harry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6003146.635009999 | 2097611.34949 | 37.739819419837396 | -122.431674423652 | (37.7398194198374, -122.431674423652) | |||
| 161815 | 161815 | 196342 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015828.19689 | 2099862.61894 | 37.7467116144672 | -122.38798358786501 | (37.7467116144672, -122.387983587865) | ||||
| 164450 | 164450 | 178858 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 321 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010771.67715 | 2090938.6411099997 | 37.7219268276555 | -122.40484043533701 | (37.7219268276555, -122.404840435337) | |||
| 164689 | 164689 | 237952 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 1243 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5997445.05985 | 2105447.6147 | 37.761011034661706 | -122.45195317171301 | (37.7610110346617, -122.451953171713) | |||
| 170630 | 170630 | 83694 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 2455 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 5987336.2715 | 2098572.6525 | 37.7415500456995 | -122.486409860339 | (37.7415500456995, -122.486409860339) | |||
| 179258 | 179258 | 196339 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 8ft | 6015967.11689 | 2099936.1121799997 | 37.7469211070262 | -122.387508338452 | (37.7469211070262, -122.387508338452) | |||
| 186723 | 186723 | 196338 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6015971.97004 | 2099951.82403 | 37.7469645173129 | -122.387492652478 | (37.7469645173129, -122.387492652478) | ||||
| 187204 | 187204 | 237951 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 200 Eugenia Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6006574.718780001 | 2098103.54318 | 37.7413645918137 | -122.419856447043 | (37.7413645918137, -122.419856447043) | ||||
| 17474 | 17474 | 5669 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 1411 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005264.89314 | 2100092.7159 | 37.746752529107596 | -122.42452683054701 | (37.7467525291076, -122.424526830547) | |||
| 25786 | 25786 | 196352 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011956.0756 | 2105144.27438 | 37.76099860510921 | -122.401744258403 | (37.7609986051092, -122.401744258403) | ||||
| 27717 | 27717 | 196349 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6011979.46515 | 2105146.30626 | 37.761005489419205 | -122.40166350647499 | (37.7610054894192, -122.401663506475) | ||||
| 30690 | 30690 | 135882 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 2431 Jones St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6007964.86831 | 2120685.23293 | 37.803446794585795 | -122.41664910307199 | (37.8034467945858, -122.416649103072) | |||
| 36140 | 36140 | 135880 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 3573 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997686.8627 | 2115746.51973 | 37.789303006579104 | -122.45185988682199 | (37.7893030065791, -122.451859886822) | |||
| 40421 | 40421 | 196353 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6011962.814119999 | 2105133.05123 | 37.7609681648715 | -122.40172016377599 | (37.7609681648715, -122.401720163776) | ||||
| 42652 | 42652 | 196357 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6011913.72494 | 2105132.82627 | 37.7609648076872 | -122.40188992698401 | (37.7609648076872, -122.401889926984) | ||||
| 43191 | 43191 | 196350 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6011973.312390001 | 2105136.40204 | 37.7609779512911 | -122.401684090158 | (37.7609779512911, -122.401684090158) | ||||
| 45232 | 45232 | 214374 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1670 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5993737.50266 | 2104155.61578 | 37.757250482639606 | -122.46468207522601 | (37.7572504826396, -122.464682075226) | |||
| 46029 | 46029 | 214375 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 40 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001152.10793 | 2095216.80224 | 37.7331312930803 | -122.43839913213199 | (37.7331312930803, -122.438399132132) |
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");