Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 156176 | 156176 | 44741 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 271 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 3 | Permit Number 43859 | 5992054.55445 | 2086618.7004799999 | 37.7090013413078 | -122.46922594483601 | (37.7090013413078, -122.469225944836) | |
| 140557 | 140557 | 109055 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 320 Hanover St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772693 | 5999569.6 | 2086544.4 | 37.70922872292179 | -122.443247602414 | (37.7092287229218, -122.443247602414) | |
| 68733 | 68733 | 31023 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34788 | 6002794.80361 | 2086503.3822400002 | 37.7092994800486 | -122.43209787574 | (37.7092994800486, -122.43209787574) | |
| 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) | |||
| 178402 | 178402 | 31022 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34788 | 6002783.56511 | 2086520.12567 | 37.7093448166924 | -122.43213791266001 | (37.7093448166924, -122.43213791266) | |
| 28678 | 28678 | 179035 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 178 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010379.06325 | 2086412.1514400002 | 37.709476057444796 | -122.40587891040899 | (37.7094760574448, -122.405878910409) | |||
| 73045 | 73045 | 31021 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 317 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34787 | 6002776.11429 | 2086581.1916200002 | 37.7095120680942 | -122.432168021935 | (37.7095120680942, -122.432168021935) | |
| 28128 | 28128 | 179162 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 171 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002093.74544 | 2086607.8879 | 37.7095466578231 | -122.434528308849 | (37.7095466578231, -122.434528308849) | |||
| 167032 | 167032 | 179163 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 171 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002120.7512 | 2086617.7341900002 | 37.7095752265844 | -122.43443567596 | (37.7095752265844, -122.43443567596) | |||
| 10329 | 10329 | 109051 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772570 | 5995048.30925 | 2086814.9244099997 | 37.7097126663738 | -122.45889335865 | (37.7097126663738, -122.45889335865) |
| 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) | |||
| 176683 | 176683 | 179153 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 412 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 8ft | 6001969.08964 | 2086773.8202799999 | 37.7099951946836 | -122.434970999229 | (37.7099951946836, -122.434970999229) | |||
| 157300 | 157300 | 57927 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 559 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 3 | Permit Number 16885 | 5999203.256130001 | 2086855.58023 | 37.7100622571339 | -122.444536089569 | (37.7100622571339, -122.444536089569) | ||
| 97508 | 97508 | 108899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772775 | 6000547.04329 | 2086890.00633 | 37.710233369404605 | -122.43989417722 | (37.7102333694046, -122.43989417722) |
| 136130 | 136130 | 178972 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 856 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009124.92679 | 2086754.6391599998 | 37.7103462396574 | -122.410237598787 | (37.7103462396574, -122.410237598787) | |||
| 105452 | 105452 | 37342 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 507 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 15 | Permit Number 39850 | 5999504.92576 | 2086983.7691900001 | 37.71043144412221 | -122.44350266602801 | (37.7104314441222, -122.443502666028) | |
| 53799 | 53799 | 178967 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 505 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5999517.95201 | 2086983.4986400001 | 37.7104314441356 | -122.44345762526899 | (37.7104314441356, -122.443457625269) | |||
| 28887 | 28887 | 84197 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 551 Sawyer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50697 | 6007614.52495 | 2086883.3270299998 | 37.7106148095844 | -122.41546698201 | (37.7106148095844, -122.41546698201) | |
| 146266 | 146266 | 109076 | Property Tree 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 772744 | 6001554.7 | 2087011.6 | 37.7106245477128 | -122.43642021389401 | (37.7106245477128, -122.436420213894) | ||
| 161431 | 161431 | 179036 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 551 Sawyer St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007618.72078 | 2086894.99872 | 37.7106470934606 | -122.415453306029 | (37.7106470934606, -122.415453306029) | |||
| 82049 | 82049 | 69397 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | Permit Number 772744 | 6001523.93675849 | 2087030.79827901 | 37.7106755138649 | -122.436527911504 | (37.7106755138649, -122.436527911504) | |
| 12718 | 12718 | 109057 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 825 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772770 | 5997289.5352300005 | 2087142.99435 | 37.7107420465867 | -122.45117096298401 | (37.7107420465867, -122.451170962984) |
| 51659 | 51659 | 178979 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 Rae Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997616.63139 | 2087136.8467599999 | 37.7107438892848 | -122.450040007061 | (37.7107438892848, -122.450040007061) | |||
| 42755 | 42755 | 178970 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1029 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008583.66239 | 2086910.8267599999 | 37.7107447436356 | -122.412119359132 | (37.7107447436356, -122.412119359132) | |||
| 51769 | 51769 | 178969 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1029 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008570.63643 | 2086915.27252 | 37.710756219889 | -122.412164693966 | (37.710756219889, -122.412164693966) | |||
| 168670 | 168670 | 178978 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 Rae Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997625.81626 | 2087145.6195099999 | 37.7107685028255 | -122.450008894089 | (37.7107685028255, -122.450008894089) | |||
| 155352 | 155352 | 178968 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1029 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008554.00356 | 2086922.9270900001 | 37.710776304465 | -122.412222721805 | (37.710776304465, -122.412222721805) | |||
| 80030 | 80030 | 84222 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
| 93504 | 93504 | 84211 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
| 141941 | 141941 | 84223 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
| 133475 | 133475 | 178977 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5997636.8287 | 2087155.6990200002 | 37.71079680899621 | -122.449971558745 | (37.7107968089962, -122.449971558745) | |||
| 156949 | 156949 | 178980 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998273.4288099995 | 2087174.03892 | 37.7108835719974 | -122.44777265158702 | (37.7108835719974, -122.447772651587) | |||
| 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) | |||
| 92213 | 92213 | 99888 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
| 102810 | 102810 | 99892 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646@ Whipple Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
| 103926 | 103926 | 99890 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646@ Whipple Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
| 111780 | 111780 | 99887 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
| 139392 | 139392 | 99891 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646@ Whipple Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
| 146325 | 146325 | 99889 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646@ Whipple Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
| 181085 | 181085 | 178981 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998261.9451 | 2087183.3832900003 | 37.7109085731488 | -122.447813014086 | (37.7109085731488, -122.447813014086) | |||
| 135851 | 135851 | 31058 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 6 | Permit Number 34809 | 6002732.75221 | 2087097.44922 | 37.71092714054029 | -122.432354735598 | (37.7109271405403, -122.432354735598) | |
| 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) | |||
| 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) | |||
| 139522 | 139522 | 51976 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 163 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2005 12:00:00 AM | Permit Number 48195 | 5997753.64161846 | 2087210.79293758 | 37.710954767676704 | -122.449571795733 | (37.7109547676767, -122.449571795733) | |||
| 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) | |||
| 163282 | 163282 | 31057 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 5 | Permit Number 34809 | 6002747.277969999 | 2087115.5773200002 | 37.7109777400017 | -122.43230582505 | (37.7109777400017, -122.43230582505) | |
| 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) | |
| 13060 | 13060 | 109069 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1065 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772763 | 6002105.570119999 | 2087176.80573 | 37.7111094529054 | -122.434528092094 | (37.7111094529054, -122.434528092094) |
| 52624 | 52624 | 86960 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 208 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49928 | 5993493.7535 | 2087361.9529 | 37.71112519553311 | -122.464305827668 | (37.7111251955331, -122.464305827668) | |
| 12196 | 12196 | 86961 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 212 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49929 | 5993495.99209 | 2087406.2303400002 | 37.7112468999028 | -122.464301303157 | (37.7112468999028, -122.464301303157) | |
| 147925 | 147925 | 69417 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 7 | Permit Number 33522 | 6001453.459840001 | 2087297.44526 | 37.7114036625088 | -122.436790570551 | (37.7114036625088, -122.436790570551) | |
| 34465 | 34465 | 179159 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001727.04807 | 2087313.1468599997 | 37.711462320802205 | -122.435846103423 | (37.7114623208022, -122.435846103423) | |||
| 151564 | 151564 | 179160 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Seville St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001754.98626 | 2087320.62379 | 37.711484437814896 | -122.43575007652599 | (37.7114844378149, -122.435750076526) | |||
| 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) | |
| 36399 | 36399 | 179158 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 148 Seville St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6001439.08808 | 2087342.2198599998 | 37.7115257868681 | -122.436843446185 | (37.7115257868681, -122.436843446185) | |||
| 173547 | 173547 | 37340 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 10 | Permit Number 39848 | 6000626.60293 | 2087367.0099799999 | 37.7115476439893 | -122.43965337791799 | (37.7115476439893, -122.439653377918) | |
| 171041 | 171041 | 65739 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 12 | Permit Number 28675 | 5999799.15568 | 2087425.51821 | 37.7116611636025 | -122.442517443427 | (37.7116611636025, -122.442517443427) | |
| 60368 | 60368 | 69413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 73 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33518 | 6001961.1999 | 2087395.4649599998 | 37.711701646594 | -122.43504269857 | (37.711701646594, -122.43504269857) | |
| 106738 | 106738 | 95016 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010516.6 | 2087234.5 | 37.7117417518759 | -122.405461434977 | (37.7117417518759, -122.405461434977) | |||
| 172050 | 172050 | 179155 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1219 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001609.50582 | 2087555.82392 | 37.7121219807101 | -122.436269715579 | (37.7121219807101, -122.436269715579) | |||
| 162550 | 162550 | 179156 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1219 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001622.38743 | 2087558.0089200002 | 37.712128712138295 | -122.436225349332 | (37.7121287121383, -122.436225349332) | |||
| 36067 | 36067 | 179157 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1219 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001634.55542 | 2087559.6833400002 | 37.7121340010651 | -122.436183413036 | (37.7121340010651, -122.436183413036) | |||
| 81667 | 81667 | 44392 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X ATHENS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492.0 | 2087581.0 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | |||
| 102329 | 102329 | 44394 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X ATHENS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492.0 | 2087581.0 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | |||
| 121911 | 121911 | 44393 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X ATHENS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492.0 | 2087581.0 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | |||
| 87906 | 87906 | 95006 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 195 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2013 12:00:00 AM | 3 | 3x3 | 6009968.4 | 2087457.4 | 37.7123231225616 | -122.407371876718 | (37.7123231225616, -122.407371876718) | ||
| 185251 | 185251 | 213304 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994495.39623 | 2087783.3442799998 | 37.71233992151021 | -122.460874450904 | (37.7123399215102, -122.460874450904) | |||
| 26523 | 26523 | 88167 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 189 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 51184 | 6010014.6058 | 2087504.2072 | 37.7124542316575 | -122.40721547231199 | (37.7124542316575, -122.407215472312) | |
| 129707 | 129707 | 48506 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 45 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 5 | Permit Number 45843 | 6001715.61599 | 2087735.00145 | 37.71261999108761 | -122.43591578108999 | (37.7126199910876, -122.43591578109) | ||
| 147639 | 147639 | 213305 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 223 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995012.40881 | 2087891.7837 | 37.712667406052496 | -122.45909535897499 | (37.7126674060525, -122.459095358975) | |||
| 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) | |||
| 150046 | 150046 | 178975 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 60 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5998617.79966 | 2087941.66603 | 37.713010978548496 | -122.44663762444999 | (37.7130109785485, -122.44663762445) | |||
| 32294 | 32294 | 213357 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992244.95419 | 2088111.9424400001 | 37.7131124256698 | -122.468676481533 | (37.7131124256698, -122.468676481533) | |||
| 55797 | 55797 | 178976 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 221 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5998101.98654 | 2088087.6608 | 37.7133823688881 | -122.448430945451 | (37.7133823688881, -122.448430945451) | |||
| 24585 | 24585 | 49743 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 114 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 8 | Permit Number 46542 | 6010621.23603 | 2087831.01483 | 37.7133855110935 | -122.405141759495 | (37.7133855110935, -122.405141759495) | |
| 174698 | 174698 | 49745 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 34@ LELAND Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46544 | 6008556.3350599995 | 2087877.23988 | 37.7133967814171 | -122.41228206988899 | (37.7133967814171, -122.412282069889) | |
| 184405 | 184405 | 179029 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 226 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009880.60922 | 2087872.96636 | 37.7134592690157 | -122.407704592601 | (37.7134592690157, -122.407704592601) | |||
| 54523 | 54523 | 31006 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34780 | 6000669.33593 | 2088075.8661099998 | 37.713496437089894 | -122.43955646516599 | (37.7134964370899, -122.439556465166) | |
| 148223 | 148223 | 178974 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5998851.51754 | 2088138.5359099999 | 37.7135648862728 | -122.445843970916 | (37.7135648862728, -122.445843970916) | |||
| 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) | |||
| 151932 | 151932 | 55259 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1972 12:00:00 AM | 8 | Permit Number 11181 | 6008604.18987 | 2088002.78931 | 37.7137441994136 | -122.41212553387501 | (37.7137441994136, -122.412125533875) | ||
| 107563 | 107563 | 86870 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 602 Randolph St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443.0 | 2088555.0 | 37.7143403939216 | -122.46802418223301 | (37.7143403939216, -122.468024182233) | ||
| 115044 | 115044 | 86869 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 602 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443.0 | 2088555.0 | 37.7143403939216 | -122.46802418223301 | (37.7143403939216, -122.468024182233) | ||
| 141542 | 141542 | 86868 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 602 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49803 | 5992443.0 | 2088555.0 | 37.7143403939216 | -122.46802418223301 | (37.7143403939216, -122.468024182233) | ||
| 70594 | 70594 | 41410 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 531 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 5 | Permit Number 42023 | 6007957.48629 | 2088255.0601400002 | 37.714400574992204 | -122.414378624292 | (37.7144005749922, -122.414378624292) | ||
| 122960 | 122960 | 179028 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 535 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007927.50802 | 2088265.2218900002 | 37.7144267929389 | -122.41448296003 | (37.7144267929389, -122.41448296003) | |||
| 69640 | 69640 | 213344 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 117 Vernon St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992432.58541 | 2088617.0275700002 | 37.7145101052228 | -122.468064688059 | (37.7145101052228, -122.468064688059) | |||
| 31639 | 31639 | 213343 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 117 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992434.92339 | 2088648.0359 | 37.7145953816368 | -122.468058861341 | (37.7145953816368, -122.468058861341) | |||
| 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) | ||
| 56762 | 56762 | 49698 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 87@ TUCKER Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50825 | 6011117.29096 | 2088288.9421 | 37.7146706063491 | -122.403459407649 | (37.7146706063491, -122.403459407649) | |
| 182777 | 182777 | 49699 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 87@ TUCKER Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50825 | 6011128.67682 | 2088300.86402 | 37.7147039774881 | -122.403420891467 | (37.7147039774881, -122.403420891467) | |
| 134984 | 134984 | 179034 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Alpha St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6011090.19294 | 2088313.2717799998 | 37.7147358971229 | -122.403554780747 | (37.7147358971229, -122.403554780747) | |||
| 173982 | 173982 | 213346 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 223 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992956.82489 | 2088699.8094099998 | 37.7147676656708 | -122.466258733373 | (37.7147676656708, -122.466258733373) | |||
| 68476 | 68476 | 179033 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Alpha St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6011104.28456 | 2088327.78048 | 37.7147765222032 | -122.40350709418001 | (37.7147765222032, -122.40350709418) | |||
| 172419 | 172419 | 179017 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 27 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000125.72789 | 2088561.8694099998 | 37.714799938735 | -122.441470215282 | (37.714799938735, -122.441470215282) | |||
| 47314 | 47314 | 179018 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 27 Pope St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000118.2745199995 | 2088586.12335 | 37.7148661099687 | -122.441497716551 | (37.7148661099687, -122.441497716551) | |||
| 51420 | 51420 | 179019 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 27 Pope St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000109.84085 | 2088611.05825 | 37.714934095108106 | -122.44152865502701 | (37.7149340951081, -122.441528655027) | |||
| 53260 | 53260 | 178985 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 276 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5998310.44307 | 2088707.23579 | 37.7150954964391 | -122.447755025789 | (37.7150954964391, -122.447755025789) | |||
| 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) | |||
| 84033 | 84033 | 48563 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 53 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45982 | 5991907.82184104 | 2088893.56567496 | 37.715239092234704 | -122.469898587444 | (37.7152390922347, -122.469898587444) |
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");