Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 178112 | 178112 | 178839 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 921 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6001840.757 | 2086804.7866200001 | 37.7100729338953 | -122.435416754499 | (37.7100729338953, -122.435416754499) | |||
| 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) |
| 182397 | 182397 | 78518 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Laura St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5997355.58596 | 2086978.87375 | 37.7102951905332 | -122.450930851174 | (37.7102951905332, -122.450930851174) | ||
| 39626 | 39626 | 78781 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Laura St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5997342.70536 | 2086993.5441299998 | 37.7103347346378 | -122.450976426135 | (37.7103347346378, -122.450976426135) | ||
| 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) | |||
| 57287 | 57287 | 178739 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 416 Peninsula Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012199.66481 | 2086699.2931099997 | 37.7103661434655 | -122.39960671288999 | (37.7103661434655, -122.39960671289) | |||
| 137051 | 137051 | 178842 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 856 Prague St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6002039.2106099995 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | |||
| 59060 | 59060 | 178841 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 856 Prague St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002067.276880001 | 2086921.00065 | 37.710404894347704 | -122.434642162998 | (37.7104048943477, -122.434642162998) | |||
| 45234 | 45234 | 178756 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 47 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008299.13366 | 2086795.4391400001 | 37.710411944121596 | -122.413094604643 | (37.7104119441216, -122.413094604643) | |||
| 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) | |||
| 155848 | 155848 | 178895 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 240 Concord St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999918.78145 | 2087003.9139 | 37.7105103506437 | -122.44207374220801 | (37.7105103506437, -122.442073742208) | |||
| 31556 | 31556 | 178755 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008316.596469999 | 2086843.3583099998 | 37.710544500606396 | -122.413037635286 | (37.7105445006064, -122.413037635286) | |||
| 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) | |
| 185410 | 185410 | 178754 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 27 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008327.5198 | 2086871.77855 | 37.7106231499219 | -122.41300188991801 | (37.7106231499219, -122.413001889918) | |||
| 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) | ||
| 57825 | 57825 | 78914 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 219 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 3 | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | ||
| 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) | |||
| 164778 | 164778 | 178845 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 543 Sawyer St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007634.8415 | 2086934.3968099998 | 37.7107561785306 | -122.415400376427 | (37.7107561785306, -122.415400376427) | |||
| 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) | |||
| 71089 | 71089 | 84187 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 543 Sawyer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50696 | 6007633.86618 | 2086936.80805 | 37.7107627444765 | -122.41540391795601 | (37.7107627444765, -122.415403917956) | |
| 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) | |||
| 130109 | 130109 | 78715 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 190 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | 5 | 6008812.7369 | 2086938.0409099997 | 37.710832318719504 | -122.411329543927 | (37.7108323187195, -122.411329543927) | ||
| 76801 | 76801 | 178696 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1121 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008480.0549800005 | 2086950.0388900002 | 37.7108465981642 | -122.41248022108101 | (37.7108465981642, -122.412480221081) | |||
| 187979 | 187979 | 179663 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 333 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012567.3674099995 | 2086868.9308 | 37.7108524248833 | -122.398347742071 | (37.7108524248833, -122.398347742071) | |||
| 175027 | 175027 | 51531 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 175 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 1 | Permit Number 47833 | 5997697.55511 | 2087175.4993200002 | 37.7108546506849 | -122.449763101302 | (37.7108546506849, -122.449763101302) | ||
| 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) | |||
| 85059 | 85059 | 51530 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 169 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | Permit Number 47832 | 5997730.87276608 | 2087189.13752554 | 37.710894004264205 | -122.449648930425 | (37.7108940042642, -122.449648930425) | |||
| 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) | |||
| 88240 | 88240 | 65746 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 252 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | Permit Number 28705 | 6000865.93587078 | 2087131.69490372 | 37.7109151403091 | -122.438809330108 | (37.7109151403091, -122.438809330108) | ||
| 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) | |||
| 66305 | 66305 | 54661 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 2 | Permit Number 10485 | 6012308.35839 | 2086909.49761 | 37.71094938168571 | -122.399245788885 | (37.7109493816857, -122.399245788885) | ||
| 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) | |||
| 161744 | 161744 | 105552 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 329 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6012582.61187 | 2086912.65676 | 37.7109733369276 | -122.398298119266 | (37.7109733369276, -122.398298119266) | ||||
| 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) | |
| 10668 | 10668 | 108896 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 312 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772786 | 6000205.0169 | 2087170.16849 | 37.7109831566161 | -122.441096373403 | (37.7109831566161, -122.441096373403) |
| 32097 | 32097 | 179664 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 325 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 6012585.69681 | 2086923.17392 | 37.711002386816 | -122.398288194338 | (37.711002386816, -122.398288194338) | |||
| 183711 | 183711 | 178832 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 26 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6002753.4939 | 2087126.6504400002 | 37.711008496830004 | -122.43228513165 | (37.71100849683, -122.43228513165) | |||
| 68434 | 68434 | 178697 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 170 Lawrence Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5996822.297619999 | 2087264.10807 | 37.7110478340594 | -122.452794569318 | (37.7110478340594, -122.452794569318) | |||
| 42877 | 42877 | 179665 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 325 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 6012591.22281 | 2086940.79015 | 37.7110510653234 | -122.398270330217 | (37.7110510653234, -122.398270330217) | |||
| 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) | |
| 10613 | 10613 | 16409 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1186X Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | TR | 6001094.970430001 | 2087182.82135 | 37.7110685499383 | -122.43802139438401 | (37.7110685499383, -122.438021394384) | |||
| 162407 | 162407 | 65315 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 543 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1989 12:00:00 AM | 18 | Permit Number 28137 | 6013067.51643 | 2086945.4340000001 | 37.711090336012504 | -122.39662445846001 | (37.7110903360125, -122.39662445846) | ||
| 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) |
| 40726 | 40726 | 178738 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 88 Gillette Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6013102.20794 | 2086955.43637 | 37.7111197312489 | -122.39650525601002 | (37.7111197312489, -122.39650525601) | |||
| 72038 | 72038 | 178737 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Gillette Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013141.93389 | 2086956.08513 | 37.7111237233427 | -122.39636799789801 | (37.7111237233427, -122.396367997898) | |||
| 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) | |
| 133075 | 133075 | 178840 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1065 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002119.38667 | 2087187.3937099997 | 37.711139309492395 | -122.434481095339 | (37.7111393094924, -122.434481095339) | |||
| 153282 | 153282 | 179666 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 309 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012604.11309 | 2086981.7039299998 | 37.7111641245081 | -122.39822864665899 | (37.7111641245081, -122.398228646659) | |||
| 155089 | 155089 | 179667 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 309 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012610.18411 | 2086997.87945 | 37.711208877458404 | -122.398208797709 | (37.7112088774584, -122.398208797709) | |||
| 170429 | 170429 | 178896 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 424 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6012763.5947 | 2086999.9849599998 | 37.711223202768295 | -122.397678716599 | (37.7112232027683, -122.397678716599) | |||
| 89222 | 89222 | 89359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 308 Tocoloma Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.39839375585301 | (37.7112369933076, -122.398393755853) | ||
| 173907 | 173907 | 179668 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 301 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012612.993480001 | 2087008.97407 | 37.7112394975798 | -122.398199865648 | (37.7112394975798, -122.398199865648) | |||
| 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) | |
| 182222 | 182222 | 178965 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 748 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002497.1974599995 | 2087222.1001 | 37.7112560450962 | -122.433177768149 | (37.7112560450962, -122.433177768149) | |||
| 45466 | 45466 | 179637 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 120 Farragut Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997385.090419999 | 2087337.68892 | 37.7112821038472 | -122.45085473348301 | (37.7112821038472, -122.450854733483) | |||
| 165663 | 165663 | 179669 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 301 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012620.012630001 | 2087029.4196400002 | 37.71129602805021 | -122.39817703904801 | (37.7112960280502, -122.398177039048) | |||
| 11772 | 11772 | 95029 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 13 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010870.6461 | 2087075.073 | 37.71132378726 | -122.40422653482 | (37.71132378726, -122.40422653482) | |||
| 10780 | 10780 | 26783 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010951.9721 | 2087077.0783 | 37.711333837408205 | -122.40394559103301 | (37.7113338374082, -122.403945591033) | |||
| 12055 | 12055 | 95028 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 21 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010854.6037 | 2087083.0942 | 37.711344915432 | -122.404282545919 | (37.711344915432, -122.404282545919) | |||
| 11844 | 11844 | 95027 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 29 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010839.0069 | 2087091.1154 | 37.711366068478 | -122.404337016935 | (37.711366068478, -122.404337016935) | |||
| 13116 | 13116 | 26784 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010928.7998 | 2087090.8926 | 37.7113704740421 | -122.40402665236999 | (37.7113704740421, -122.40402665237) | |||
| 149646 | 149646 | 179794 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 640 Rolph St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6002828.72839 | 2087264.3912099998 | 37.711390968591296 | -122.432034933064 | (37.7113909685913, -122.432034933064) | |||
| 10565 | 10565 | 94985 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010907.8555 | 2087101.5876 | 37.7113986701374 | -122.40409979381799 | (37.7113986701374, -122.404099793818) | |||
| 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) | |
| 11754 | 11754 | 95026 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 33 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010809.5958 | 2087105.821 | 37.7114048035242 | -122.404439704211 | (37.7114048035242, -122.404439704211) | |||
| 12814 | 12814 | 95025 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 37 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010791.7709 | 2087116.9615 | 37.7114343969477 | -122.40450209567699 | (37.7114343969477, -122.404502095677) | |||
| 11522 | 11522 | 94986 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010873.097 | 2087120.3037 | 37.711448118617 | -122.404221245197 | (37.711448118617, -122.404221245197) | |||
| 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) | |||
| 12283 | 12283 | 95024 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010769.0442 | 2087127.6565 | 37.7114624931322 | -122.404581397838 | (37.7114624931322, -122.404581397838) | |||
| 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) | |||
| 10438 | 10438 | 95023 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 45 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010750.3281 | 2087136.1233 | 37.711484695229295 | -122.404646681546 | (37.7114846952293, -122.404646681546) | |||
| 11422 | 11422 | 26785 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 28 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1999 12:00:00 AM | 3 | 3X3 | 6010847.2509 | 2087135.4549 | 37.7114882765061 | -122.40431164223101 | (37.7114882765061, -122.404311642231) | ||
| 144970 | 144970 | 179173 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 136 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6001549.186980001 | 2087334.6879 | 37.7115113626193 | -122.43646237733299 | (37.7115113626193, -122.436462377333) | |||
| 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) | |
| 11927 | 11927 | 52333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2005 12:00:00 AM | 3 | Permit Number 48484 | 6010821.8504 | 2087147.4867 | 37.7115198939825 | -122.40440027981701 | (37.7115198939825, -122.404400279817) | ||
| 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) | |||
| 55272 | 55272 | 179170 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 179 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001259.83204 | 2087347.3317200001 | 37.7115296332658 | -122.437463366848 | (37.7115296332658, -122.437463366848) | |||
| 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) | |
| 12802 | 12802 | 26786 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 34 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6010794.6675 | 2087161.3009 | 37.7115563058928 | -122.404495203342 | (37.7115563058928, -122.404495203342) | |||
| 11853 | 11853 | 94988 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 38 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010771.4951 | 2087173.3327 | 37.711588047755605 | -122.40457614013901 | (37.7115880477556, -122.404576140139) |
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");