Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3188 | 3188 | 213685 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 428 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/2002 12:00:00 AM | 9 | Width 2ft | Permit Number 45997 | 6000116.1968 | 2095121.7561599999 | 37.7328113412593 | -122.44197372410801 | (37.7328113412593, -122.441973724108) | |
| 3874 | 3874 | 239439 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x9 | 6004683.2193 | 2097236.31541 | 37.7388766398495 | -122.426334864463 | (37.7388766398495, -122.426334864463) | |||
| 4918 | 4918 | 43245 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 150 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 9 | Permit Number 43034 | 6010460.0 | 2093774.0 | 37.729694705520004 | -122.40611748494 | (37.72969470552, -122.40611748494) | |
| 6793 | 6793 | 106875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 9 | 3x3 | Permit Number 772880 | 5999376.012619999 | 2115702.7008599997 | 37.7892792923525 | -122.446012495778 | (37.7892792923525, -122.446012495778) | |
| 23561 | 23561 | 238503 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 68 Wilder St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002672.92744 | 2095557.23 | 37.7341524174814 | -122.433165572429 | (37.7341524174814, -122.433165572429) | |||
| 25642 | 25642 | 43023 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 519 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42885 | 6004020.081809999 | 2110698.29349 | 37.7758025350991 | -122.429587516272 | (37.7758025350991, -122.429587516272) | |
| 29303 | 29303 | 239530 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007356.16273 | 2097559.43734 | 37.7399145905948 | -122.417115934858 | (37.7399145905948, -122.417115934858) | |||
| 29975 | 29975 | 238524 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 140 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002633.141890001 | 2096863.59749 | 37.7377371457538 | -122.433396444615 | (37.7377371457538, -122.433396444615) | |||
| 30292 | 30292 | 238053 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 426 Lily St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004459.53739 | 2109991.5945200003 | 37.773886985434295 | -122.428016956418 | (37.7738869854343, -122.428016956418) | |||
| 31213 | 31213 | 237327 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 63 Winfield St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 6007296.44329 | 2099127.4866 | 37.7442167449119 | -122.417433518746 | (37.7442167449119, -122.417433518746) | |||
| 31951 | 31951 | 246463 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Duncan St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005105.34641 | 2099923.38039 | 37.746278561223605 | -122.42506648135 | (37.7462785612236, -122.42506648135) | |||
| 34215 | 34215 | 179115 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Yale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6006932.90152 | 2093437.9228299998 | 37.7285739974769 | -122.41828725417 | (37.7285739974769, -122.41828725417) | |||
| 34912 | 34912 | 41947 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 690 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 9 | Permit Number 42304 | 5993509.40357 | 2110837.2069 | 37.7755832179423 | -122.46595641563499 | (37.7755832179423, -122.465956415635) | |
| 35424 | 35424 | 237214 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 237 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004332.80938 | 2099540.3876900002 | 37.74518328139371 | -122.427710538533 | (37.7451832813937, -122.427710538533) | |||
| 35428 | 35428 | 48426 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3130 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 9 | Permit Number 45804 | 6001942.5823800005 | 2118964.92546 | 37.798382739120704 | -122.437366176208 | (37.7983827391207, -122.437366176208) | |
| 36044 | 36044 | 238139 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006189.42808 | 2099103.97241 | 37.7440898316937 | -122.42125967450701 | (37.7440898316937, -122.421259674507) | |||
| 37385 | 37385 | 213282 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 321 Ashton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5994159.10031 | 2092040.3515 | 37.724009288792296 | -122.46234534608601 | (37.7240092887923, -122.462345346086) | |||
| 37907 | 37907 | 196433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 592 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010645.13552 | 2105583.09907 | 37.7621302751024 | -122.40630917123801 | (37.7621302751024, -122.406309171238) | |||
| 38498 | 38498 | 213528 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1266 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995863.01289 | 2092507.47107 | 37.7253898569542 | -122.45648898608 | (37.7253898569542, -122.45648898608) | |||
| 38819 | 38819 | 239540 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007190.57712 | 2097427.3810900003 | 37.7395426768657 | -122.417679104726 | (37.7395426768657, -122.417679104726) | |||
| 39164 | 39164 | 238056 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 439 Lily St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6004411.75821 | 2109960.94242 | 37.773800119011895 | -122.428180047573 | (37.7738001190119, -122.428180047573) | |||
| 39433 | 39433 | 213503 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 799 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994884.402319999 | 2093295.6638 | 37.7274978120743 | -122.459928999933 | (37.7274978120743, -122.459928999933) | |||
| 39457 | 39457 | 237156 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 874 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010167.022919999 | 2104149.38568 | 37.7581668648249 | -122.40786168349399 | (37.7581668648249, -122.407861683494) | |||
| 39904 | 39904 | 238093 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1128 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009186.03745 | 2102591.03497 | 37.7538330166071 | -122.411144292581 | (37.7538330166071, -122.411144292581) | |||
| 39930 | 39930 | 237223 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 478 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003374.63036 | 2100117.4180099997 | 37.7467134247776 | -122.431064932422 | (37.7467134247776, -122.431064932422) | |||
| 40366 | 40366 | 237376 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1065 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009202.551580001 | 2102951.7552400003 | 37.7548243995487 | -122.41111266074199 | (37.7548243995487, -122.411112660742) | |||
| 42081 | 42081 | 214792 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 285 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995449.681340001 | 2097473.05136 | 37.7390003955387 | -122.45827706673 | (37.7390003955387, -122.45827706673) | |||
| 43020 | 43020 | 238528 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 28 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6003301.9628099995 | 2097731.40275 | 37.740157861699295 | -122.431145932563 | (37.7401578616993, -122.431145932563) | |||
| 43648 | 43648 | 239467 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1285 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 5997501.9107 | 2105032.0283 | 37.7598731953164 | -122.451726570432 | (37.7598731953164, -122.451726570432) | |||
| 43698 | 43698 | 214744 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995639.7235199995 | 2093649.0582299998 | 37.7285115593587 | -122.457343422077 | (37.7285115593587, -122.457343422077) | |||
| 44692 | 44692 | 135950 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3012 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004722.9901 | 2119938.49945 | 37.80121359538229 | -122.427814520823 | (37.8012135953823, -122.427814520823) | |||
| 45333 | 45333 | 237311 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 273 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008997.34657 | 2097088.95234 | 37.7387149309411 | -122.411408153666 | (37.7387149309411, -122.411408153666) | |||
| 45412 | 45412 | 239546 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 234 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007043.97235 | 2097599.78307 | 37.7400078035106 | -122.418198221295 | (37.7400078035106, -122.418198221295) | |||
| 45488 | 45488 | 238055 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 438 Lily St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6004413.04242 | 2109984.42979 | 37.7738646822544 | -122.428177279482 | (37.7738646822544, -122.428177279482) | |||
| 46283 | 46283 | 31905 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2259 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35330 | 5991969.67434 | 2100068.6545599997 | 37.7459266717829 | -122.47049820945 | (37.7459266717829, -122.47049820945) | |
| 49985 | 49985 | 31912 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2256 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 9 | Permit Number 35336 | 5991754.81336 | 2100091.67364 | 37.745977450207 | -122.47124283909099 | (37.745977450207, -122.471242839091) | |
| 50146 | 50146 | 214726 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Southwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995147.95146 | 2092472.32767 | 37.7252522831394 | -122.458958327485 | (37.7252522831394, -122.458958327485) | |||
| 52472 | 52472 | 213543 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 175 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5996110.621719999 | 2094080.6199 | 37.7297235594719 | -122.45574669468 | (37.7297235594719, -122.45574669468) | |||
| 52973 | 52973 | 238319 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000024.20764 | 2104904.5196 | 37.7596672199772 | -122.442994046358 | (37.7596672199772, -122.442994046358) | |||
| 55558 | 55558 | 239549 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 511 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006925.075680001 | 2097949.2793900003 | 37.740960749435295 | -122.41863409569099 | (37.7409607494353, -122.418634095691) | |||
| 56167 | 56167 | 214822 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 481 Flood Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997551.672230001 | 2094088.1550099999 | 37.729826844818504 | -122.450765393012 | (37.7298268448185, -122.450765393012) | |||
| 57336 | 57336 | 214818 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000452.08249 | 2094337.12961 | 37.7306760737326 | -122.44075622284201 | (37.7306760737326, -122.440756222842) | |||
| 58434 | 58434 | 135942 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 420 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998162.588409999 | 2115059.8609 | 37.7874448588433 | -122.450164425556 | (37.7874448588433, -122.450164425556) | |||
| 58971 | 58971 | 213698 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 54 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999705.61228 | 2093800.4183 | 37.7291598500291 | -122.443298341854 | (37.7291598500291, -122.443298341854) | |||
| 59162 | 59162 | 67443 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 161 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1992 12:00:00 AM | 9 | Permit Number 30946 | 5994572.42148 | 2114474.4165 | 37.785631285707105 | -122.46254309514099 | (37.7856312857071, -122.462543095141) | ||
| 59592 | 59592 | 68878 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 535 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 9 | Permit Number 32849 | 5994664.33554 | 2111876.7239 | 37.778504013274 | -122.462036654628 | (37.778504013274, -122.462036654628) | |
| 60065 | 60065 | 65973 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2245 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1990 12:00:00 AM | 9 | Permit Number 28997 | 5988612.04832 | 2110519.74016 | 37.7744278044001 | -122.48287408378 | (37.7744278044001, -122.48287408378) | ||
| 60122 | 60122 | 213603 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994000.56505 | 2100962.8135 | 37.74849902692429 | -122.46354060263701 | (37.7484990269243, -122.463540602637) | |||
| 60431 | 60431 | 238505 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002715.93525 | 2095546.35382 | 37.7341249935801 | -122.43301610421801 | (37.7341249935801, -122.433016104218) | |||
| 60872 | 60872 | 213416 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2493 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991370.65568 | 2098470.68683 | 37.7415044084939 | -122.472453037893 | (37.7415044084939, -122.472453037893) | |||
| 61082 | 61082 | 237312 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 275 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008994.00868 | 2097057.18443 | 37.73862751595421 | -122.411417450854 | (37.7386275159542, -122.411417450854) | |||
| 61123 | 61123 | 213601 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994302.03638 | 2101543.53453 | 37.7501109051904 | -122.462540245329 | (37.7501109051904, -122.462540245329) | |||
| 61622 | 61622 | 179071 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Delano Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999909.366830001 | 2092009.96893 | 37.724255306416296 | -122.44246545454399 | (37.7242553064163, -122.442465454544) | |||
| 61681 | 61681 | 239417 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1386 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6003241.87066 | 2100172.27936 | 37.746856537504705 | -122.43152791778799 | (37.7468565375047, -122.431527917788) | |||
| 62091 | 62091 | 214816 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 655 Hearst Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5997091.21284 | 2094378.0504 | 37.7305964594612 | -122.452378156221 | (37.7305964594612, -122.452378156221) | |||
| 62829 | 62829 | 237383 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 827 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007380.0217699995 | 2102480.66392 | 37.75342851503579 | -122.417382106324 | (37.7534285150358, -122.417382106324) | |||
| 62895 | 62895 | 40654 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Congdon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 9 | Permit Number 47919 | 6004685.50571 | 2093693.1599299998 | 37.7291480590261 | -122.426074794035 | (37.7291480590261, -122.426074794035) | |
| 64645 | 64645 | 213553 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 119 Valdez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5996273.88735 | 2094337.4099 | 37.730438011494996 | -122.455200820562 | (37.730438011495, -122.455200820562) | |||
| 66508 | 66508 | 246474 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 312 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004388.68199 | 2099882.3051 | 37.746125268169706 | -122.42754169531601 | (37.7461252681697, -122.427541695316) | |||
| 67636 | 67636 | 237305 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 185 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008838.31822 | 2097699.45702 | 37.7403823225842 | -122.412001132442 | (37.7403823225842, -122.412001132442) | |||
| 67770 | 67770 | 213506 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 170 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995645.91598 | 2093857.2294299998 | 37.7290835029864 | -122.457337068356 | (37.7290835029864, -122.457337068356) | |||
| 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) | |
| 68841 | 68841 | 196464 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Cesar Chavez St | 6 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6015016.3527 | 2101061.7401099997 | 37.7499591392145 | -122.390874677125 | (37.7499591392145, -122.390874677125) | |||
| 70102 | 70102 | 44491 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 55 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 9 | Permit Number 45395 | 6005461.21441 | 2093276.5457799998 | 37.728047939957 | -122.42336349723499 | (37.728047939957, -122.423363497235) | |
| 71686 | 71686 | 237107 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | 9 | Width 4ft | Permit Number 39047 | 6006621.1232900005 | 2105778.70866 | 37.7624414540443 | -122.42024059875 | (37.7624414540443, -122.42024059875) | |
| 72023 | 72023 | 40646 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 108 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | Permit Number 41644 | 6004664.1042599995 | 2094195.33475 | 37.7305257097718 | -122.426184517611 | (37.7305257097718, -122.426184517611) | |
| 72377 | 72377 | 238330 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 246 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002691.78046 | 2104466.49417 | 37.7586162380656 | -122.43373694232099 | (37.7586162380656, -122.433736942321) | |||
| 74662 | 74662 | 179015 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 570 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003097.37584 | 2090169.87122 | 37.7193840071539 | -122.431313686676 | (37.7193840071539, -122.431313686676) | |||
| 76097 | 76097 | 214678 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2682 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991462.8798400005 | 2097179.7313200003 | 37.7379651112972 | -122.47204008897499 | (37.7379651112972, -122.472040088975) | |||
| 76291 | 76291 | 213654 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Edgehill Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994824.078840001 | 2099066.74247 | 37.7433403061049 | -122.460555550413 | (37.7433403061049, -122.460555550413) | |||
| 76359 | 76359 | 80388 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1746 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 9 | 6011768.66094 | 2092717.74347 | 37.7268675545821 | -122.401519069956 | (37.7268675545821, -122.401519069956) | ||
| 76634 | 76634 | 237056 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Albion St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6005793.31637 | 2107190.9812 | 37.7662725407724 | -122.423204074428 | (37.7662725407724, -122.423204074428) | |||
| 82005 | 82005 | 52014 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301X 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48233 | 6004302.0 | 2098976.0 | 37.7436318598049 | -122.427776865938 | (37.7436318598049, -122.427776865938) | |
| 117358 | 117358 | 51015 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48063 | 6005440.48678199 | 2099065.68713562 | 37.7439424571986 | -122.42384662792699 | (37.7439424571986, -122.423846627927) | |
| 122954 | 122954 | 214793 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 283 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995486.378930001 | 2097483.8393599996 | 37.739032125438 | -122.45815096470801 | (37.739032125438, -122.458150964708) | |||
| 129624 | 129624 | 179067 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Meda Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000191.90379 | 2091755.2266900002 | 37.723571943081204 | -122.441470496792 | (37.7235719430812, -122.441470496792) | |||
| 130692 | 130692 | 178998 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 800 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001820.55644 | 2089152.21762 | 37.7165173138053 | -122.435654403046 | (37.7165173138053, -122.435654403046) | |||
| 131819 | 131819 | 38505 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1123 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1998 12:00:00 AM | 9 | Permit Number 40496 | 6008719.38643 | 2117949.78915 | 37.795978352179205 | -122.41384444046699 | (37.7959783521792, -122.413844440467) | ||
| 132153 | 132153 | 238242 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 185 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003074.67279 | 2105029.92031 | 37.760184990255794 | -122.432452970336 | (37.7601849902558, -122.432452970336) | |||
| 132632 | 132632 | 66574 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 275 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 9 | Permit Number 29764 | 6005180.346969999 | 2093822.91903 | 37.729532304260104 | -122.42437331088199 | (37.7295323042601, -122.424373310882) | |
| 133729 | 133729 | 239375 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4407 24th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6000535.569069999 | 2101672.81424 | 37.750822884967704 | -122.440993660945 | (37.7508228849677, -122.440993660945) | |||
| 133940 | 133940 | 32103 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 237 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 9 | Permit Number 35475 | 6002723.82147 | 2104526.537 | 37.7587829193134 | -122.43363042122101 | (37.7587829193134, -122.433630421221) | |
| 134623 | 134623 | 237323 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 85 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009349.15826 | 2096986.9873 | 37.7384546833378 | -122.410184553188 | (37.7384546833378, -122.410184553188) | |||
| 135228 | 135228 | 237060 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 199 Tiffany Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6006047.428119999 | 2099152.06421 | 37.7442138742778 | -122.421754094776 | (37.7442138742778, -122.421754094776) | |||
| 135345 | 135345 | 238107 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6006184.05234 | 2102126.82183 | 37.752389584027796 | -122.42149290108601 | (37.7523895840278, -122.421492901086) | |||
| 135376 | 135376 | 237347 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 207 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008785.61167 | 2097659.00145 | 37.7402682831545 | -122.412180513039 | (37.7402682831545, -122.412180513039) | |||
| 135742 | 135742 | 239398 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 204 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000596.07239 | 2102206.68161 | 37.752292201824396 | -122.440822727712 | (37.7522922018244, -122.440822727712) | |||
| 148552 | 148552 | 237066 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3425 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006736.51306 | 2100522.37025 | 37.7480152599946 | -122.41946858020701 | (37.7480152599946, -122.419468580207) | |||
| 148683 | 148683 | 46833 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 471 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | 9 | Permit Number 44906 | 6002821.93172 | 2091174.08119 | 37.7221257307043 | -122.4323374767 | (37.7221257307043, -122.4323374767) | |
| 148749 | 148749 | 237175 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1526 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009304.4397599995 | 2100402.9931 | 37.7478317803246 | -122.410580327728 | (37.7478317803246, -122.410580327728) | |||
| 149523 | 149523 | 179051 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000564.26285 | 2092887.9227099998 | 37.7267032736144 | -122.440264511299 | (37.7267032736144, -122.440264511299) | |||
| 151404 | 151404 | 34481 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 839 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2001 12:00:00 AM | 9 | Permit Number 38208 | 6008950.87239 | 2119364.8911900003 | 37.7998768700862 | -122.41314356464198 | (37.7998768700862, -122.413143564642) | |
| 153192 | 153192 | 238481 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 140 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003606.4439900005 | 2108831.51888 | 37.7706534010546 | -122.43088513814199 | (37.7706534010546, -122.430885138142) | |||
| 153510 | 153510 | 179083 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 31 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004487.94293 | 2093313.4408200001 | 37.7280942667373 | -122.426730755029 | (37.7280942667373, -122.426730755029) | |||
| 154441 | 154441 | 237326 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 63 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 6007291.38561 | 2099119.3862900003 | 37.744194218700294 | -122.417450433195 | (37.7441942187003, -122.417450433195) | |||
| 154946 | 154946 | 239468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 163 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5997553.16556 | 2107080.05988 | 37.7654995069206 | -122.451697043888 | (37.7654995069206, -122.451697043888) | |||
| 156239 | 156239 | 213510 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 154 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995679.789 | 2093745.03939 | 37.728777401642 | -122.457211854858 | (37.728777401642, -122.457211854858) | |||
| 158667 | 158667 | 38480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2515 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1998 12:00:00 AM | 9 | Permit Number 40479 | 5999797.205130001 | 2119471.52027 | 37.799651516149396 | -122.44482624505899 | (37.7996515161494, -122.444826245059) | ||
| 158713 | 158713 | 237322 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 33 Bronte St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6009369.40904 | 2097222.26631 | 37.7391018435688 | -122.410131141556 | (37.7391018435688, -122.410131141556) | |||
| 160555 | 160555 | 237373 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009218.81749 | 2102679.40367 | 37.7540774954946 | -122.41103717251998 | (37.7540774954946, -122.41103717252) |
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");