Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34490 | 34490 | 68541 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 6 | Permit Number 32425 | 5982517.9924800005 | 2112299.68917 | 37.778958557712606 | -122.504086094205 | (37.7789585577126, -122.504086094205) | |
| 112200 | 112200 | 115223 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 741 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5985056.66405 | 2110813.18731 | 37.7750260153576 | -122.49519429373699 | (37.7750260153576, -122.495194293737) | |||
| 170118 | 170118 | 250758 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 214 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985901.94322 | 2114466.62788 | 37.785106767213705 | -122.49253944703699 | (37.7851067672137, -122.492539447037) | |||
| 147077 | 147077 | 250761 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 228 32nd Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985903.37202 | 2114379.41265 | 37.7848673829594 | -122.49252807871001 | (37.7848673829594, -122.49252807871) | |||
| 40381 | 40381 | 250676 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 735 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986293.297259999 | 2114811.88275 | 37.786077611448 | -122.49121092176 | (37.786077611448, -122.49121092176) | |||
| 180995 | 180995 | 250869 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 133 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986468.30668 | 2114640.25117 | 37.785616584774104 | -122.490592812307 | (37.7856165847741, -122.490592812307) | |||
| 166651 | 166651 | 250870 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 133 30th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986470.3680300005 | 2114630.24299 | 37.7855892256034 | -122.490584944137 | (37.7855892256034, -122.490584944137) | |||
| 172196 | 172196 | 35478 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 524 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1998 12:00:00 AM | 6 | Permit Number 38890 | 5986598.81458 | 2112347.1481 | 37.779328002919705 | -122.489972580124 | (37.7793280029197, -122.489972580124) | ||
| 80359 | 80359 | 99851 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 191 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988632.0 | 2114084.0 | 37.784215423052295 | -122.483066364805 | (37.7842154230523, -122.483066364805) | |||
| 161168 | 161168 | 68950 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 734 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32939 | 5988846.075 | 2110312.98983 | 37.7738737393837 | -122.482049401575 | (37.7738737393837, -122.482049401575) | |
| 63928 | 63928 | 120706 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5989297.54688 | 2115010.0433400003 | 37.786796782687205 | -122.480831656181 | (37.7867967826872, -122.480831656181) | |||
| 164404 | 164404 | 40950 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 543 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 6 | Permit Number 42451 | 5989371.25434 | 2111628.81002 | 37.777517147846204 | -122.480329070335 | (37.7775171478462, -122.480329070335) | |
| 146555 | 146555 | 50298 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2909 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 6 | Permit Number 47009 | 5989047.4642199995 | 2095832.2551400003 | 37.734125220204604 | -122.48029267726999 | (37.7341252202046, -122.48029267727) | |
| 40751 | 40751 | 68941 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 730 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32928 | 5989462.36102 | 2110347.5276900004 | 37.774004395159295 | -122.479920119491 | (37.7740043951593, -122.479920119491) | |
| 79299 | 79299 | 12771 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1831 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1992 12:00:00 AM | 6 | 3X3 | 5989737.94266 | 2114686.68849 | 37.785934529444 | -122.479284343127 | (37.785934529444, -122.479284343127) | ||
| 77101 | 77101 | 70171 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 775 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 6 | 5990355.07569 | 2110118.2458599997 | 37.7734266747554 | -122.476815345127 | (37.7734266747554, -122.476815345127) | ||
| 158190 | 158190 | 214659 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1843 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990602.16808 | 2102840.10921 | 37.7534571944178 | -122.475429125678 | (37.7534571944178, -122.475429125678) | |||
| 71219 | 71219 | 214483 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1868 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5990967.174319999 | 2102702.6319999998 | 37.7531008695265 | -122.47415683856899 | (37.7531008695265, -122.474156838569) | |||
| 61128 | 61128 | 214484 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1868 17th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5990968.36883 | 2102715.12154 | 37.753135231722396 | -122.47415361899598 | (37.7531352317224, -122.474153618996) | |||
| 40172 | 40172 | 213418 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1500 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991335.33208 | 2098431.48094 | 37.741394714585496 | -122.47257231588301 | (37.7413947145855, -122.472572315883) | |||
| 182960 | 182960 | 213422 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2317 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991444.6705 | 2099648.88289 | 37.7447437161621 | -122.47228298869499 | (37.7447437161621, -122.472282988695) | |||
| 161020 | 161020 | 213320 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 238 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991458.7746 | 2090762.7040099998 | 37.720345321258705 | -122.47158680100901 | (37.7203453212587, -122.471586801009) | |||
| 42915 | 42915 | 214589 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991796.94128 | 2105115.28006 | 37.7597734011291 | -122.47146315499701 | (37.7597734011291, -122.471463154997) | |||
| 177523 | 177523 | 214588 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991798.55182 | 2105130.62844 | 37.7598156368994 | -122.47145870337299 | (37.7598156368994, -122.471458703373) | |||
| 37063 | 37063 | 213321 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5991673.594880001 | 2090710.5616 | 37.7202145769251 | -122.470840448236 | (37.7202145769251, -122.470840448236) | |||
| 160107 | 160107 | 214516 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1203 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992147.44859 | 2106565.08379 | 37.76377444986029 | -122.470356517645 | (37.7637744498603, -122.470356517645) | |||
| 186438 | 186438 | 213370 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1567 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992114.844269999 | 2104775.13643 | 37.758857841827606 | -122.47033892420001 | (37.7588578418276, -122.4703389242) | |||
| 1495 | 1495 | 213442 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2455 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2002 12:00:00 AM | 6 | Width 3ft | Permit Number 45711 | 5992014.67382 | 2098752.22599 | 37.742314697659204 | -122.470246761681 | (37.7423146976592, -122.470246761681) | |
| 72276 | 72276 | 218242 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Wawona St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 5992065.00246 | 2097235.79822 | 37.738153881691 | -122.46996235468599 | (37.738153881691, -122.469962354686) | |||
| 74785 | 74785 | 213334 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5991917.942369999 | 2089508.58685 | 37.716928375916 | -122.469908359396 | (37.716928375916, -122.469908359396) | |||
| 149708 | 149708 | 213331 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 151 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5991924.78555 | 2089552.6251599998 | 37.7170496899626 | -122.469887910591 | (37.7170496899626, -122.469887910591) | |||
| 53955 | 53955 | 213335 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 53 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5991917.8551 | 2088918.99095 | 37.715309483835 | -122.469865758501 | (37.715309483835, -122.469865758501) | |||
| 125065 | 125065 | 124047 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 693 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5992526.1539900005 | 2110751.1645299997 | 37.775290197576105 | -122.469351420391 | (37.7752901975761, -122.469351420391) | ||||
| 75018 | 75018 | 124048 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 693 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5992526.55561 | 2110733.67497 | 37.775242199176795 | -122.469348757796 | (37.7752421991768, -122.469348757796) | ||||
| 39076 | 39076 | 123168 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 598 10th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5992809.72377 | 2111438.2053099996 | 37.7771930089585 | -122.468420491782 | (37.7771930089585, -122.468420491782) | ||||
| 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) | |||
| 186222 | 186222 | 56305 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1973 12:00:00 AM | 6 | Permit Number 12437 | 5993019.12779 | 2114510.13973 | 37.785639797963704 | -122.467919595671 | (37.7856397979637, -122.467919595671) | ||
| 68680 | 68680 | 214503 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1961 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5992841.14878 | 2102244.10103 | 37.751950241809205 | -122.467642977944 | (37.7519502418092, -122.467642977944) | |||
| 164635 | 164635 | 214779 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1723 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5992800.25839 | 2095349.1682799999 | 37.7330161429665 | -122.467283086348 | (37.7330161429665, -122.467283086348) | |||
| 135756 | 135756 | 214652 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 306 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993036.75439 | 2103256.19316 | 37.7547404775 | -122.467040126413 | (37.7547404775, -122.467040126413) | |||
| 148057 | 148057 | 214529 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 831 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993147.15611 | 2106598.8236599998 | 37.7639248407744 | -122.466901317842 | (37.7639248407744, -122.466901317842) | |||
| 38356 | 38356 | 213463 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 314 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993094.88579 | 2099699.80528 | 37.7449789032567 | -122.46658060972 | (37.7449789032567, -122.46658060972) | |||
| 57602 | 57602 | 213592 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2038 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993203.16917 | 2101587.87617 | 37.750169312562704 | -122.466343382053 | (37.7501693125627, -122.466343382053) | |||
| 65192 | 65192 | 214685 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 63 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993146.31618 | 2098681.89926 | 37.7421869588497 | -122.46632881033399 | (37.7421869588497, -122.466328810334) | |||
| 77028 | 77028 | 214596 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1392 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5993363.63081 | 2106044.62421 | 37.7624156461858 | -122.466112327348 | (37.7624156461858, -122.466112327348) | |||
| 18995 | 18995 | 19331 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2000 12:00:00 AM | 6 | 3x3 | 5993203.76699 | 2089824.45321 | 37.7178699121392 | -122.465486857851 | (37.7178699121392, -122.465486857851) | ||
| 147327 | 147327 | 214536 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 647 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993699.4039199995 | 2106621.4524 | 37.7640188316212 | -122.464992916908 | (37.7640188316212, -122.464992916908) | |||
| 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) | |
| 136766 | 136766 | 213470 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 396 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993853.55379 | 2099589.61797 | 37.7447201080625 | -122.463949296841 | (37.7447201080625, -122.463949296841) | |||
| 97015 | 97015 | 10703 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130X Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5993684.4832438 | 2089860.5757616002 | 37.717996809726 | -122.46382786766 | (37.717996809726, -122.46382786766) | |||
| 56945 | 56945 | 84414 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51575 | 5994138.61763 | 2110515.8988900003 | 37.7747372701378 | -122.46375650168999 | (37.7747372701378, -122.46375650169) | |
| 185145 | 185145 | 214786 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 34 Fairfield Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5993908.89145 | 2093024.3192599998 | 37.7266966141529 | -122.463281639244 | (37.7266966141529, -122.463281639244) | |||
| 135745 | 135745 | 214813 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 349 Kensington Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5994166.60375 | 2099059.892 | 37.7432836497201 | -122.46282841600599 | (37.7432836497201, -122.462828416006) | |||
| 32843 | 32843 | 31989 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 6 | Permit Number 35389 | 5994568.75053 | 2114560.8648099997 | 37.78586843793 | -122.462562068449 | (37.78586843793, -122.462562068449) | |
| 110120 | 110120 | 101655 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200X Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994672.4771300005 | 2099264.801 | 37.7438754024487 | -122.461094099214 | (37.7438754024487, -122.461094099214) | |||
| 86950 | 86950 | 94707 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Edgehill Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/29/2010 12:00:00 AM | 6 | Permit Number 53868 | 5994701.2 | 2098925.3 | 37.7429448703691 | -122.460970181408 | (37.7429448703691, -122.460970181408) | ||
| 140594 | 140594 | 94706 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/29/2010 12:00:00 AM | 6 | Permit Number 53868 | 5994701.2 | 2098925.3 | 37.7429448703691 | -122.460970181408 | (37.7429448703691, -122.460970181408) | ||
| 159871 | 159871 | 84412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 569-571 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51568 | 5994982.60822 | 2111689.36495 | 37.7780078944262 | -122.460922053766 | (37.7780078944262, -122.460922053766) | |
| 133177 | 133177 | 82162 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 569-571 03rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51568 | 5994982.94214 | 2111676.20425 | 37.7779717778616 | -122.460919944539 | (37.7779717778616, -122.460919944539) | |
| 32602 | 32602 | 213579 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 464 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994822.2189 | 2100134.8158400003 | 37.7462728613029 | -122.460639364526 | (37.7462728613029, -122.460639364526) | |||
| 24891 | 24891 | 213671 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 5994885.5088599995 | 2098943.91671 | 37.7430065910919 | -122.460334245238 | (37.7430065910919, -122.460334245238) | |||
| 77144 | 77144 | 213292 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 221 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994712.31061 | 2090077.6554299998 | 37.7186520354525 | -122.46029086104299 | (37.7186520354525, -122.460290861043) | |||
| 34110 | 34110 | 213580 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 45 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995131.70851 | 2099996.48556 | 37.74591084191 | -122.459559177141 | (37.74591084191, -122.459559177141) | |||
| 35079 | 35079 | 213616 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995109.982340001 | 2095633.16995 | 37.733929007011206 | -122.459318378264 | (37.7339290070112, -122.459318378264) | |||
| 59095 | 59095 | 214834 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1223 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995042.942000001 | 2092029.67306 | 37.7240308230599 | -122.459289291479 | (37.7240308230599, -122.459289291479) | |||
| 163597 | 163597 | 213615 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995123.16436 | 2095604.38426 | 37.733850726423 | -122.459270720479 | (37.733850726423, -122.459270720479) | |||
| 168043 | 168043 | 214737 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995133.12046 | 2093665.44373 | 37.7285274395723 | -122.459095949818 | (37.7285274395723, -122.459095949818) | |||
| 141655 | 141655 | 1576 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 605 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1999 12:00:00 AM | 6 | 3x3 | 5995596.544419999 | 2112077.2508400003 | 37.779108233448 | -122.45882633362 | (37.779108233448, -122.45882633362) | ||
| 42511 | 42511 | 214723 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995322.28894 | 2093286.2773099998 | 37.7274972131074 | -122.45841455420299 | (37.7274972131074, -122.458414554203) | |||
| 75303 | 75303 | 213294 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 23 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995303.99589 | 2090064.66919 | 37.71865039597979 | -122.458244719016 | (37.7186503959798, -122.458244719016) | |||
| 171241 | 171241 | 213493 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 598 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995429.76267 | 2093267.5886900001 | 37.7274520743399 | -122.45804166739401 | (37.7274520743399, -122.458041667394) | |||
| 188032 | 188032 | 72515 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 44 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1996 12:00:00 AM | 6 | 5995895.10246 | 2112445.80394 | 37.7801373389306 | -122.457820182784 | (37.7801373389306, -122.457820182784) | ||
| 68081 | 68081 | 64861 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 6 | Permit Number 25877 | 5995901.579469999 | 2112392.78617 | 37.779992138301296 | -122.457793938484 | (37.7799921383013, -122.457793938484) | |
| 183309 | 183309 | 213302 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 663 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995432.632669999 | 2089892.10127 | 37.7181839562956 | -122.457787596334 | (37.7181839562956, -122.457787596334) | |||
| 178580 | 178580 | 213303 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 655 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995455.6031599995 | 2089891.9177400002 | 37.7181847719797 | -122.457708184405 | (37.7181847719797, -122.457708184405) | |||
| 65575 | 65575 | 214738 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 169 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995625.765869999 | 2093824.2443799998 | 37.7289917766278 | -122.457404343046 | (37.7289917766278, -122.457404343046) | |||
| 180844 | 180844 | 214747 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995630.96112 | 2093598.65464 | 37.72837265995471 | -122.45737006898999 | (37.7283726599547, -122.45737006899) | |||
| 35668 | 35668 | 213507 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 170 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995650.65208 | 2093847.52813 | 37.729057137577 | -122.457319993841 | (37.729057137577, -122.457319993841) | |||
| 169146 | 169146 | 214757 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995633.92023 | 2092945.0693400002 | 37.7265782417753 | -122.45731257623301 | (37.7265782417753, -122.457312576233) | |||
| 74115 | 74115 | 213518 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995655.95253 | 2093561.2181099998 | 37.7282713036556 | -122.45728096594999 | (37.7282713036556, -122.45728096595) | |||
| 150500 | 150500 | 214833 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 229 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995622.68342 | 2091459.3417599997 | 37.7224981435639 | -122.45724398941601 | (37.7224981435639, -122.457243989416) | |||
| 75094 | 75094 | 213514 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995669.27876 | 2093647.3614400001 | 37.7285085978803 | -122.45724112599899 | (37.7285085978803, -122.457241125999) | |||
| 185440 | 185440 | 213504 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 435 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995680.74302 | 2093936.8329099999 | 37.7293040752209 | -122.457222425468 | (37.7293040752209, -122.457222425468) | |||
| 58550 | 58550 | 214789 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 385 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5995719.97757 | 2095492.23955 | 37.7335770986874 | -122.45719926076401 | (37.7335770986874, -122.457199260764) | |||
| 63757 | 63757 | 124620 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700 Euclid Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996122.36346 | 2113846.2215299997 | 37.7839955667695 | -122.457135318887 | (37.7839955667695, -122.457135318887) | |||
| 31003 | 31003 | 124618 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996155.438130001 | 2113845.79893 | 37.78399630583271 | -122.45702086273 | (37.7839963058327, -122.45702086273) | |||
| 56405 | 56405 | 213539 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1560 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995783.29259 | 2094350.88739 | 37.7304468581388 | -122.45689784037701 | (37.7304468581388, -122.456897840377) | |||
| 53858 | 53858 | 214650 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 28 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5996115.71323 | 2106752.8498400003 | 37.7645186442469 | -122.45664517043899 | (37.7645186442469, -122.456645170439) | |||
| 158488 | 158488 | 213529 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5995838.74514 | 2092736.52805 | 37.7260173993826 | -122.45658943406201 | (37.7260173993826, -122.456589434062) | |||
| 39066 | 39066 | 124480 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 276 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5996245.79674 | 2110923.35846 | 37.7759772459796 | -122.456496854767 | (37.7759772459796, -122.456496854767) | |||
| 160674 | 160674 | 213538 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 350 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995937.4596 | 2094121.86195 | 37.729826861018296 | -122.456348312323 | (37.7298268610183, -122.456348312323) | |||
| 131980 | 131980 | 213544 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996121.67701 | 2094002.3279900001 | 37.72950922315211 | -122.455702818554 | (37.7295092231521, -122.455702818554) | |||
| 164460 | 164460 | 213550 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 167 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996175.013809999 | 2094553.95501 | 37.731026919034704 | -122.455558283981 | (37.7310269190347, -122.455558283981) | |||
| 34178 | 34178 | 213551 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 159 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996188.75737 | 2094532.8518700001 | 37.73096976354329 | -122.455509245751 | (37.7309697635433, -122.455509245751) | |||
| 34374 | 34374 | 213557 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Valdez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996396.856430001 | 2093987.6566700002 | 37.7294847274146 | -122.454750441903 | (37.7294847274146, -122.454750441903) | |||
| 63980 | 63980 | 135933 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997039.44005 | 2116145.17864 | 37.790360514882394 | -122.45412868571002 | (37.7903605148824, -122.45412868571) | |||
| 49995 | 49995 | 135934 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997041.86737 | 2116129.80097 | 37.790318431109704 | -122.454119176269 | (37.7903184311097, -122.454119176269) | |||
| 153330 | 153330 | 214830 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996526.30071 | 2090008.918 | 37.718567477585204 | -122.454015706561 | (37.7185674775852, -122.454015706561) | |||
| 61183 | 61183 | 213585 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996654.35387 | 2094558.3489299999 | 37.731066478420296 | -122.453901450408 | (37.7310664784203, -122.453901450408) |
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");