Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 110438 | 110438 | 12424 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1701X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2015 12:00:00 AM | 2 | 4X4 | 6004421.35326 | 2114759.5543400003 | 37.7869764624576 | -122.428488960967 | (37.7869764624576, -122.428488960967) | ||
| 4845 | 4845 | 38140 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 2 | Permit Number 40297 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | |
| 154069 | 154069 | 43063 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 490 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51464 | 5985346.9900400005 | 2112594.40853 | 37.779933731493294 | -122.49432133158399 | (37.7799337314933, -122.494321331584) | |
| 68028 | 68028 | 45482 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3020 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 2 | Permit Number 44263 | 5990295.806419999 | 2095116.94306 | 37.7322336167725 | -122.475924589162 | (37.7322336167725, -122.475924589162) | |
| 132561 | 132561 | 45514 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 2 | Permit Number 44278 | 5988535.25971 | 2095760.7230900002 | 37.7338990344167 | -122.482058269478 | (37.7338990344167, -122.482058269478) | |
| 125280 | 125280 | 47314 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1420 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | 2 | Permit Number 45244 | 6010384.18455371 | 2100995.83638931 | 37.7495200736312 | -122.406888381765 | (37.7495200736312, -122.406888381765) | |
| 156931 | 156931 | 48689 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 455 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | 2 | Permit Number 45968 | 6008469.24313 | 2088342.73235 | 37.714670039767 | -122.412615977341 | (37.714670039767, -122.412615977341) | ||
| 176951 | 176951 | 48912 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1930 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2002 12:00:00 AM | 2 | 3x3 | Permit Number 46107 | 6004309.09705 | 2118070.5094 | 37.796061152762796 | -122.429113506091 | (37.7960611527628, -122.429113506091) |
| 43631 | 43631 | 50013 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 999 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 2 | Permit Number 52022 | 6012813.23846 | 2102916.22313 | 37.7549286606329 | -122.398623329429 | (37.7549286606329, -122.398623329429) | ||
| 172980 | 172980 | 50792 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2740 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47317 | 5999864.3976 | 2118141.20218 | 37.7960026509676 | -122.444498073449 | (37.7960026509676, -122.444498073449) | |||
| 150585 | 150585 | 56095 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 783 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52001 | 5981348.38409 | 2110404.98623 | 37.7736874110676 | -122.507991510924 | (37.7736874110676, -122.507991510924) | |
| 75708 | 75708 | 59120 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 540 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 2 | 3x3 | Permit Number 18424 | 5992853.52259 | 2111756.57585 | 37.7780696980739 | -122.468292145877 | (37.7780696980739, -122.468292145877) | |
| 166051 | 166051 | 64856 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Almaden Ct | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 2 | Permit Number 25872 | 5995898.09877 | 2112568.97781 | 37.7804757138181 | -122.45781873289499 | (37.7804757138181, -122.457818732895) | |
| 28805 | 28805 | 64858 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 2 | Permit Number 25874 | 5995885.498430001 | 2112555.8177099996 | 37.7804388557843 | -122.45786137054199 | (37.7804388557843, -122.457861370542) | |
| 166312 | 166312 | 68274 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 2 | Permit Number 32081 | 6008779.93848 | 2093554.1542200001 | 37.7289969414408 | -122.411910130973 | (37.7289969414408, -122.411910130973) | |
| 36774 | 36774 | 69416 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 148 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 2 | Permit Number 33521 | 6001460.481240001 | 2087339.3254900002 | 37.7115190554232 | -122.436769298869 | (37.7115190554232, -122.436769298869) | |
| 178641 | 178641 | 70480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 919 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767510 | 6005011.406280001 | 2092024.56337 | 37.724584874666206 | -122.42482946681001 | (37.7245848746662, -122.42482946681) |
| 41204 | 41204 | 78480 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 2 | 6001855.9620900005 | 2090141.3500299999 | 37.719235261989 | -122.43560274687799 | (37.719235261989, -122.435602746878) | ||
| 71854 | 71854 | 81961 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 485 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 2 | Permit Number 49960 | 5984369.11349 | 2112553.91349 | 37.779765269334504 | -122.49770119972901 | (37.7797652693345, -122.497701199729) | ||
| 153524 | 153524 | 84212 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 156 Tioga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50701 | 6010164.59248 | 2089152.68925 | 37.7169890199119 | -122.406813177404 | (37.7169890199119, -122.406813177404) | |
| 45985 | 45985 | 84283 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 156 Tioga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50701 | 6010175.00365 | 2089148.86152 | 37.7169790922895 | -122.40677692123501 | (37.7169790922895, -122.406776921235) | |
| 178173 | 178173 | 88272 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 518 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51258 | 6010632.7883 | 2105837.1165299998 | 37.7628270590352 | -122.40636977475599 | (37.7628270590352, -122.406369774756) | |
| 87590 | 87590 | 91928 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 2 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
| 98111 | 98111 | 91929 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 2 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
| 158895 | 158895 | 92228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 819 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52552 | 5984148.0757 | 2110235.49072 | 37.77338659024161 | -122.498294572929 | (37.7733865902416, -122.498294572929) | |
| 147200 | 147200 | 92229 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 831 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52669 | 5984149.10381 | 2110157.50395 | 37.7731725212481 | -122.498285255587 | (37.7731725212481, -122.498285255587) | |
| 37777 | 37777 | 92608 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2524 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52920 | 5990771.27794 | 2112015.60912 | 37.7786604478424 | -122.47551422168101 | (37.7786604478424, -122.475514221681) | |
| 130781 | 130781 | 92609 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2528 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52920 | 5990746.65563 | 2112013.99975 | 37.778654601597 | -122.475599281341 | (37.778654601597, -122.475599281341) | |
| 68233 | 68233 | 95715 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 922 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767470 | 6005041.96775 | 2091992.0995900002 | 37.7244974623786 | -122.42472151131099 | (37.7244974623786, -122.424721511311) |
| 13168 | 13168 | 95747 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 223 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767492 | 6002627.86341 | 2092385.97592 | 37.7254423161963 | -122.433094867748 | (37.7254423161963, -122.433094867748) |
| 28327 | 28327 | 95833 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767565 | 6010212.70231 | 2112022.42286 | 37.7797869733249 | -122.408258986859 | (37.7797869733249, -122.408258986859) |
| 25098 | 25098 | 95928 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 758 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767625 | 5987895.384330001 | 2110807.039 | 37.775174921567796 | -122.485374215588 | (37.7751749215678, -122.485374215588) |
| 156020 | 156020 | 95931 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 691 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767628 | 5987521.80961 | 2111256.95198 | 37.7763884852693 | -122.486699521672 | (37.7763884852693, -122.486699521672) |
| 173587 | 173587 | 95934 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 674 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767631 | 5987254.50705 | 2111348.9878700003 | 37.7766256032795 | -122.487630947058 | (37.7766256032795, -122.487630947058) |
| 129882 | 129882 | 95990 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 734 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767642 | 5986340.19492 | 2110900.5686 | 37.7753410020486 | -122.490760773635 | (37.7753410020486, -122.490760773635) |
| 165506 | 165506 | 95992 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 858 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767644 | 5986371.40114 | 2110056.12968 | 37.7730242344515 | -122.490590683906 | (37.7730242344515, -122.490590683906) |
| 157988 | 157988 | 96028 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 730 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767669 | 6007516.24853 | 2113853.8784 | 37.784664348435605 | -122.417717077682 | (37.7846643484356, -122.417717077682) |
| 25818 | 25818 | 96898 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 334 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | 2 | 4x4 | Permit Number 768036 | 5987169.6042 | 2113664.32132 | 37.7829778993822 | -122.48809482 | (37.7829778993822, -122.48809482) | |
| 157195 | 157195 | 96899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 334 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | 2 | 4x4 | Permit Number 768036 | 5987170.52326 | 2113675.9123 | 37.783009778520004 | -122.488092492463 | (37.78300977852, -122.488092492463) | |
| 147431 | 147431 | 96900 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 334 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | 2 | 4x4 | Permit Number 768036 | 5987168.76751 | 2113688.0402900004 | 37.7830429760908 | -122.488099458022 | (37.7830429760908, -122.488099458022) | |
| 182102 | 182102 | 103454 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5988396.696330001 | 2114118.88325 | 37.7842975073391 | -122.48388298077101 | (37.7842975073391, -122.483882980771) | |||
| 166746 | 166746 | 117912 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 889 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5983541.524809999 | 2109784.94999 | 37.772113950042794 | -122.50035936764999 | (37.7721139500428, -122.50035936765) | |||
| 168858 | 168858 | 117913 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 893 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983541.21756 | 2109770.57795 | 37.7720744705229 | -122.500359367665 | (37.7720744705229, -122.500359367665) | |||
| 175612 | 175612 | 118209 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 574 35th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5985058.9891 | 2111965.86595 | 37.7781910764099 | -122.495271274867 | (37.7781910764099, -122.495271274867) | |||
| 31693 | 31693 | 119100 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 855 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5981674.98764 | 2109913.6134599997 | 37.772357483762704 | -122.50682530453399 | (37.7723574837627, -122.506825304534) | |||
| 154082 | 154082 | 119956 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5987168.10276 | 2113699.1852599997 | 37.783073538215795 | -122.488102576965 | (37.7830735382158, -122.488102576965) | |||
| 38835 | 38835 | 119957 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 346 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5987171.5706 | 2113609.1286400002 | 37.7828264707534 | -122.48808396026399 | (37.7828264707534, -122.488083960264) | |||
| 64761 | 64761 | 120325 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 742 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5988848.2342 | 2110250.1988 | 37.77370145820289 | -122.482037331833 | (37.7737014582029, -122.482037331833) | |||
| 181843 | 181843 | 120426 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 667 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989088.891559999 | 2110781.28528 | 37.7751736683191 | -122.48124376819099 | (37.7751736683191, -122.481243768191) | |||
| 83146 | 83146 | 121562 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1046 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003754.0 | 2102204.0 | 37.7524641810183 | -122.42990192261499 | (37.7524641810183, -122.429901922615) | |||
| 140542 | 140542 | 121578 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 192X Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5999692.0 | 2106609.0 | 37.7643283535961 | -122.44426547040001 | (37.7643283535961, -122.4442654704) | |||
| 26879 | 26879 | 122163 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 557 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5991250.26553 | 2111589.08538 | 37.7775170853646 | -122.473826110289 | (37.7775170853646, -122.473826110289) | |||
| 156694 | 156694 | 123031 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 722 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991970.8857 | 2110474.96476 | 37.7744997243223 | -122.47125207498101 | (37.7744997243223, -122.471252074981) | |||
| 49316 | 49316 | 123273 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5993791.71774 | 2111566.05198 | 37.7776007134003 | -122.465032776868 | (37.7776007134003, -122.465032776868) | |||
| 179988 | 179988 | 123298 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 727 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994403.21402 | 2110559.5838200003 | 37.7748724608847 | -122.462844385609 | (37.7748724608847, -122.462844385609) | |||
| 149087 | 149087 | 123798 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1900 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992773.6819 | 2112088.5545 | 37.7789766097312 | -122.468592502086 | (37.7789766097312, -122.468592502086) | |||
| 161006 | 161006 | 123799 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1900 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992759.08391 | 2112088.12025 | 37.7789745741229 | -122.468642970342 | (37.7789745741229, -122.468642970342) | |||
| 28762 | 28762 | 123988 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993914.451719999 | 2115450.72048 | 37.7882740365456 | -122.464890390305 | (37.7882740365456, -122.464890390305) | |||
| 42821 | 42821 | 124018 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 222 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991848.751540001 | 2113924.91675 | 37.7839652833195 | -122.471926053095 | (37.7839652833195, -122.471926053095) | |||
| 147196 | 147196 | 124173 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 73 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5995877.88887 | 2112306.67242 | 37.7797543317579 | -122.45786966108601 | (37.7797543317579, -122.457869661086) | |||
| 137048 | 137048 | 124183 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Almaden Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995879.71577 | 2112592.37489 | 37.7805388998707 | -122.45788402155199 | (37.7805388998707, -122.457884021552) | |||
| 169219 | 169219 | 124346 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 804 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993044.54414 | 2111416.29684 | 37.777146414825204 | -122.467606586696 | (37.7771464148252, -122.467606586696) | |||
| 26900 | 26900 | 124493 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3148 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995905.24735 | 2111438.77615 | 37.7773728899422 | -122.45771219988 | (37.7773728899422, -122.45771219988) | |||
| 185153 | 185153 | 135917 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2350 Green St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6001679.33795 | 2118057.34258 | 37.7958757853901 | -122.438212029083 | (37.7958757853901, -122.438212029083) | |||
| 165767 | 165767 | 135928 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1960 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000881.44205 | 2120995.2314 | 37.8038970374844 | -122.44118378211901 | (37.8038970374844, -122.441183782119) | |||
| 172041 | 172041 | 135929 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1960 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000857.17484 | 2120992.84894 | 37.8038891135616 | -122.44126758904 | (37.8038891135616, -122.44126758904) | |||
| 154793 | 154793 | 135930 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1960 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000826.2402099995 | 2120988.3379599997 | 37.8038749654115 | -122.441374316075 | (37.8038749654115, -122.441374316075) | |||
| 130695 | 130695 | 135954 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2993 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6000463.47531 | 2115807.7741 | 37.789629833704 | -122.442257560964 | (37.789629833704, -122.442257560964) | |||
| 174646 | 174646 | 135972 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2304 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002483.01544 | 2117812.37138 | 37.795248833821894 | -122.43541362484301 | (37.7952488338219, -122.435413624843) | |||
| 76252 | 76252 | 136003 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009481.94772 | 2116801.23595 | 37.7928675009884 | -122.411124650506 | (37.7928675009884, -122.411124650506) | |||
| 71790 | 71790 | 178966 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 502 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010065.35663 | 2092212.96753 | 37.725386356787794 | -122.40737181018 | (37.7253863567878, -122.40737181018) | |||
| 157289 | 157289 | 178971 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 509 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010024.16897 | 2086365.7166900001 | 37.7093287026266 | -122.407102219496 | (37.7093287026266, -122.407102219496) | |||
| 165923 | 165923 | 178982 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Whipple Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998252.81183 | 2087192.10261 | 37.7109319923872 | -122.447845208002 | (37.7109319923872, -122.447845208002) | |||
| 165739 | 165739 | 178983 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Whipple Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998242.85384 | 2087202.59008 | 37.710960219414794 | -122.447880379569 | (37.7109602194148, -122.447880379569) | |||
| 136799 | 136799 | 178986 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 61 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6000882.20287 | 2091063.4197200001 | 37.721711700807205 | -122.439034703684 | (37.7217117008072, -122.439034703684) | |||
| 130391 | 130391 | 179007 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 363 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003730.47238 | 2089066.9527 | 37.716391493258 | -122.42904671254 | (37.716391493258, -122.42904671254) | |||
| 172211 | 172211 | 179008 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 600 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002499.6579 | 2090233.80705 | 37.7195256683641 | -122.433384339735 | (37.7195256683641, -122.433384339735) | |||
| 171494 | 171494 | 179009 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 600 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002484.54609 | 2090211.4480599998 | 37.71946341819061 | -122.433434978747 | (37.7194634181906, -122.433434978747) | |||
| 23638 | 23638 | 179012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6001860.73543 | 2090148.2767900003 | 37.719254552441704 | -122.435586742551 | (37.7192545524417, -122.435586742551) | |||
| 170124 | 170124 | 179016 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 70 Curtis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6000604.90599 | 2088146.70208 | 37.713687269620706 | -122.439784232863 | (37.7136872696207, -122.439784232863) | |||
| 62486 | 62486 | 179020 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5642 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5998346.4551 | 2087191.26802 | 37.7109350527871 | -122.44752149612101 | (37.7109350527871, -122.447521496121) | |||
| 161728 | 161728 | 179021 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5642 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5998317.810930001 | 2087173.37189 | 37.7108842770725 | -122.447619209286 | (37.7108842770725, -122.447619209286) | |||
| 166664 | 166664 | 179032 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 33 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010961.719880001 | 2088492.90138 | 37.7152219465056 | -122.40401147266199 | (37.7152219465056, -122.404011472662) | |||
| 75532 | 75532 | 179037 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5989055.57419 | 2095644.9365599998 | 37.733611362859605 | -122.480250933435 | (37.7336113628596, -122.480250933435) | |||
| 119487 | 119487 | 179038 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5989055.89984 | 2095635.51997 | 37.733585526248795 | -122.480249118607 | (37.7335855262488, -122.480249118607) | |||
| 155549 | 155549 | 179039 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5989055.72291 | 2095627.1595 | 37.7335625602678 | -122.48024911859699 | (37.7335625602678, -122.480249118597) | |||
| 41298 | 41298 | 179046 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 179 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001233.0942400005 | 2093248.7296099998 | 37.727732024306796 | -122.437978219718 | (37.7277320243068, -122.437978219718) | |||
| 178919 | 178919 | 179098 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004160.23558 | 2094047.68925 | 37.7300918156881 | -122.42791594906299 | (37.7300918156881, -122.427915949063) | |||
| 172393 | 172393 | 179099 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 135 Craut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004053.41682 | 2094064.32583 | 37.730131452391504 | -122.428286420292 | (37.7301314523915, -122.428286420292) | |||
| 32494 | 32494 | 179102 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 135 Craut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004051.16086 | 2094125.98713 | 37.730300632864896 | -122.428298612397 | (37.7303006328649, -122.428298612397) | |||
| 173780 | 173780 | 179103 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 135 Craut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004050.55138 | 2094143.07968 | 37.730347530692605 | -122.428301937189 | (37.7303475306926, -122.428301937189) | |||
| 154120 | 154120 | 179104 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 135 Craut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004049.57525 | 2094157.9447400002 | 37.730388291584504 | -122.42830637085 | (37.7303882915845, -122.42830637085) | |||
| 152222 | 152222 | 179105 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6004219.82639 | 2094286.1611799998 | 37.7307499773192 | -122.427726920565 | (37.7307499773192, -122.427726920565) | |||
| 169494 | 169494 | 179106 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 180 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004534.83526 | 2094298.9310700002 | 37.730802854758295 | -122.426638793939 | (37.7308028547583, -122.426638793939) | |||
| 44300 | 44300 | 179120 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 228 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009351.5528 | 2094781.0170099998 | 37.7323976980807 | -122.41002058520701 | (37.7323976980807, -122.410020585207) | |||
| 185071 | 185071 | 179122 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 62 Girard Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010416.60856 | 2094359.22813 | 37.731299191484105 | -122.406308712574 | (37.7312991914841, -122.406308712574) | |||
| 46047 | 46047 | 179127 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009957.2988599995 | 2092936.1916 | 37.727366129731294 | -122.407796331556 | (37.7273661297313, -122.407796331556) | |||
| 52150 | 52150 | 179154 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 374 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001871.82658 | 2087846.75593 | 37.712935716983 | -122.435383858181 | (37.712935716983, -122.435383858181) | |||
| 35376 | 35376 | 179161 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 233 Naylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002647.79999 | 2086739.6543400001 | 37.7099398962889 | -122.432622809119 | (37.7099398962889, -122.432622809119) | |||
| 299 | 299 | 196427 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 McLea Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010117.0 | 2109248.0 | 37.772163696411795 | -122.408394314545 | (37.7721636964118, -122.408394314545) |
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");