Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67642 | 67642 | 118478 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5981024.51617 | 2111800.84509 | 37.7775009394111 | -122.509215478972 | (37.7775009394111, -122.509215478972) | |||
| 183324 | 183324 | 68544 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 571 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32430 | 5982530.7498 | 2111896.5441900003 | 37.777852390021 | -122.504012093664 | (37.777852390021, -122.504012093664) | |
| 172451 | 172451 | 250881 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 154 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986823.250630001 | 2114733.9114599996 | 37.78589447530229 | -122.489371714655 | (37.7858944753023, -122.489371714655) | |||
| 182902 | 182902 | 40949 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 543 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45163 | 5989370.51415 | 2111642.49878 | 37.7775546903632 | -122.480332633054 | (37.7775546903632, -122.480332633054) | |
| 126862 | 126862 | 12763 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1806 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5989830.303719999 | 2114748.7330400003 | 37.786110250168704 | -122.478969342589 | (37.7861102501687, -122.478969342589) | |||
| 129901 | 129901 | 214660 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1215 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990499.972680001 | 2103786.33445 | 37.7560493544197 | -122.475851631658 | (37.7560493544197, -122.475851631658) | |||
| 162216 | 162216 | 121930 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 372 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5990921.90113 | 2112919.08197 | 37.781149865360206 | -122.47505913337099 | (37.7811498653602, -122.475059133371) | |||
| 134423 | 134423 | 214583 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990787.79928 | 2105160.7264400003 | 37.759839754027 | -122.474956561593 | (37.759839754027, -122.474956561593) | |||
| 62284 | 62284 | 214584 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990807.494390001 | 2105161.15088 | 37.759842060791996 | -122.47488847753 | (37.759842060792, -122.47488847753) | |||
| 63726 | 63726 | 213421 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2311 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991446.19939 | 2099675.30585 | 37.744816355291796 | -122.472279627908 | (37.7448163552918, -122.472279627908) | |||
| 62132 | 62132 | 213404 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2299 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991462.361409999 | 2099805.0928599997 | 37.7451736523548 | -122.472233202213 | (37.7451736523548, -122.472233202213) | |||
| 46495 | 46495 | 213405 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2291 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991470.93113 | 2099841.87305 | 37.7452751372339 | -122.47220625042802 | (37.7452751372339, -122.472206250428) | |||
| 69144 | 69144 | 213433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2326 Cecilia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991473.33081 | 2099563.7503299997 | 37.74451162271421 | -122.47217768345699 | (37.7445116227142, -122.472177683457) | |||
| 57314 | 57314 | 214586 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991797.242819999 | 2105160.13834 | 37.759896587568896 | -122.471465380821 | (37.7598965875689, -122.471465380821) | |||
| 135989 | 135989 | 214499 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1314 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992102.94479 | 2106463.61182 | 37.7634932615306 | -122.470503050471 | (37.7634932615306, -122.470503050471) | |||
| 29095 | 29095 | 218241 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Wawona St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 5992046.53731 | 2097216.7007400002 | 37.7381003774208 | -122.470024807225 | (37.7381003774208, -122.470024807225) | |||
| 135117 | 135117 | 213323 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 395 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991938.55148 | 2091189.98285 | 37.7215462696313 | -122.469959478668 | (37.7215462696313, -122.469959478668) | |||
| 68665 | 68665 | 213332 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 151 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991918.25557 | 2089546.87165 | 37.717033514761 | -122.46991006271999 | (37.717033514761, -122.46991006272) | |||
| 24980 | 24980 | 213333 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991918.76578 | 2089524.2789200002 | 37.7169715101175 | -122.469906655166 | (37.7169715101175, -122.469906655166) | |||
| 175499 | 175499 | 214688 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2624 14th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992099.807580001 | 2097491.63696 | 37.7388583620299 | -122.46986063866899 | (37.7388583620299, -122.469860638669) | |||
| 37234 | 37234 | 214686 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2624 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992129.357580001 | 2097425.2712 | 37.738677846497396 | -122.469753639146 | (37.7386778464974, -122.469753639146) | |||
| 29081 | 29081 | 213477 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 240 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992115.588269999 | 2095197.1132200002 | 37.7325590895214 | -122.46963908349899 | (37.7325590895214, -122.469639083499) | |||
| 185894 | 185894 | 213368 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1590 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992480.65426 | 2104648.2196 | 37.7585305048007 | -122.469064557877 | (37.7585305048007, -122.469064557877) | |||
| 134795 | 134795 | 213445 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2343 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992609.1265199995 | 2099494.08516 | 37.7443860045008 | -122.468245299792 | (37.7443860045008, -122.468245299792) | |||
| 63673 | 63673 | 213341 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 455 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5992454.16583 | 2090885.02641 | 37.7207387260928 | -122.468154982671 | (37.7207387260928, -122.468154982671) | |||
| 41345 | 41345 | 213459 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992964.35444 | 2099654.10226 | 37.7448458809298 | -122.467028637559 | (37.7448458809298, -122.467028637559) | |||
| 27459 | 27459 | 213462 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 314 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993067.05595 | 2099698.4128799997 | 37.7449734740606 | -122.46667673826201 | (37.7449734740606, -122.466676738262) | |||
| 35919 | 35919 | 213457 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993075.78823 | 2099665.10758 | 37.7448825301024 | -122.466644123432 | (37.7448825301024, -122.466644123432) | |||
| 133937 | 133937 | 214721 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Upland Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993008.28484 | 2094364.45541 | 37.7303243722575 | -122.466492343942 | (37.7303243722575, -122.466492343942) | |||
| 56005 | 56005 | 213450 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993181.54452 | 2099646.75602 | 37.744838243897206 | -122.46627710741801 | (37.7448382438972, -122.466277107418) | |||
| 42067 | 42067 | 213594 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2086 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993216.27549 | 2101282.1093200003 | 37.749330511306205 | -122.466275841157 | (37.7493305113062, -122.466275841157) | |||
| 52784 | 52784 | 214595 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1392 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993365.23899 | 2106030.71085 | 37.76237753652379 | -122.466105754188 | (37.7623775365238, -122.466105754188) | |||
| 124035 | 124035 | 102758 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1392 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5993422.3 | 2106025.2 | 37.7623656970292 | -122.465908002531 | (37.7623656970292, -122.465908002531) | |||
| 32614 | 32614 | 213347 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 529 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5993232.83209 | 2090695.6130099997 | 37.7202635827786 | -122.465449643 | (37.7202635827786, -122.465449643) | |||
| 47808 | 47808 | 214592 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1355 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993614.672730001 | 2106263.3144900003 | 37.7630305927228 | -122.465259958904 | (37.7630305927228, -122.465259958904) | |||
| 137946 | 137946 | 214774 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5993702.75991 | 2101413.55838 | 37.7497194941621 | -122.464603124653 | (37.7497194941621, -122.464603124653) | |||
| 47141 | 47141 | 213471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 390 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993863.77689 | 2099599.9221099997 | 37.744748989783 | -122.463914695418 | (37.744748989783, -122.463914695418) | |||
| 104436 | 104436 | 214692 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 369 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994032.06216 | 2099686.13289 | 37.744995399524605 | -122.463339056472 | (37.7449953995246, -122.463339056472) | |||
| 50853 | 50853 | 38717 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 458 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40620 | 5994382.59481 | 2112404.76272 | 37.779937641475705 | -122.463049617411 | (37.7799376414757, -122.463049617411) | ||
| 176517 | 176517 | 214814 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 349 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5994180.976419999 | 2099052.1679700003 | 37.7432632692845 | -122.462778159201 | (37.7432632692845, -122.462778159201) | |||
| 148541 | 148541 | 213283 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 321 Ashton Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994158.95263 | 2092018.0634599999 | 37.7239480827215 | -122.46234424081499 | (37.7239480827215, -122.462344240815) | |||
| 137181 | 137181 | 213366 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1339 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994540.087040001 | 2106406.8839 | 37.76347812055079 | -122.46206970207899 | (37.7634781205508, -122.462069702079) | |||
| 166035 | 166035 | 214700 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200x Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5994642.56982 | 2099211.09063 | 37.7437262061113 | -122.461193618499 | (37.7437262061113, -122.461193618499) | |||
| 168629 | 168629 | 213567 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994708.827190001 | 2099817.87371 | 37.745396093361705 | -122.46100848854799 | (37.7453960933617, -122.461008488548) | |||
| 25464 | 25464 | 213655 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Edgehill Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994743.32278 | 2099041.60515 | 37.7432666390437 | -122.460832960696 | (37.7432666390437, -122.460832960696) | |||
| 40170 | 40170 | 213651 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Edgehill Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994859.86261 | 2099088.6488 | 37.743402514010704 | -122.460433407183 | (37.7434025140107, -122.460433407183) | |||
| 59897 | 59897 | 214788 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994837.35309 | 2097388.84477 | 37.7387339794919 | -122.460388102034 | (37.7387339794919, -122.460388102034) | |||
| 151307 | 151307 | 213301 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 727 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994761.86207 | 2089904.6583900002 | 37.7181798769775 | -122.46010705669599 | (37.7181798769775, -122.460107056696) | |||
| 148010 | 148010 | 213498 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 202 Elmwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994844.316980001 | 2092680.71168 | 37.725806996680795 | -122.460023043831 | (37.7258069966808, -122.460023043831) | |||
| 23387 | 23387 | 213501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 787 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994873.7468 | 2093233.8423799998 | 37.7273274525845 | -122.459961359351 | (37.7273274525845, -122.459961359351) | |||
| 186142 | 186142 | 213502 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 799 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994882.72041 | 2093271.2307900002 | 37.727430628209795 | -122.459933045084 | (37.7274306282098, -122.459933045084) | |||
| 4533 | 4533 | 214732 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994886.41967 | 2092806.74885 | 37.7261554857857 | -122.459886624766 | (37.7261554857857, -122.459886624766) | |
| 4542 | 4542 | 214731 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994889.57203 | 2092796.33348 | 37.7261270689877 | -122.459874973176 | (37.7261270689877, -122.459874973176) | |
| 4537 | 4537 | 214730 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994894.76005 | 2092775.8058599997 | 37.7260710034609 | -122.459855552309 | (37.7260710034609, -122.459855552309) | |
| 180565 | 180565 | 214799 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995018.72239 | 2097530.56608 | 37.7391335428916 | -122.459771279518 | (37.7391335428916, -122.459771279518) | |||
| 56536 | 56536 | 68520 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 643 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32400 | 5995312.0360199995 | 2111170.0323400004 | 37.77660089482001 | -122.45974482687402 | (37.77660089482, -122.459744826874) | |
| 42381 | 42381 | 214725 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995169.64109 | 2092461.80365 | 37.7252246334854 | -122.458882587469 | (37.7252246334854, -122.458882587469) | |||
| 32586 | 32586 | 214733 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995184.64943 | 2092735.3524200001 | 37.7259765953253 | -122.45885050145701 | (37.7259765953253, -122.458850501457) | |||
| 170823 | 170823 | 214722 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995335.81879 | 2093369.06722 | 37.7277253117639 | -122.458373771745 | (37.7277253117639, -122.458373771745) | |||
| 134778 | 134778 | 214749 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995624.960659999 | 2093556.42251 | 37.7282563560431 | -122.45738775865699 | (37.7282563560431, -122.457387758657) | |||
| 182145 | 182145 | 214743 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995640.47159 | 2093655.78153 | 37.7285300628876 | -122.457341322169 | (37.7285300628876, -122.457341322169) | |||
| 183442 | 183442 | 213520 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 112 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995641.95505 | 2093454.2437599998 | 37.7279767738852 | -122.4573216198 | (37.7279767738852, -122.4573216198) | |||
| 137936 | 137936 | 213519 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995650.751180001 | 2093537.43777 | 37.7282057098272 | -122.457297227496 | (37.7282057098272, -122.457297227496) | |||
| 137972 | 137972 | 213512 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 150 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995679.11332 | 2093690.24968 | 37.7286269234873 | -122.45721022886299 | (37.7286269234873, -122.457210228863) | |||
| 134135 | 134135 | 213527 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Southwood Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5995752.91853 | 2092600.8246099998 | 37.7256398621782 | -122.456876318691 | (37.7256398621782, -122.456876318691) | |||
| 188912 | 188912 | 213530 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995845.09161 | 2092749.1474400002 | 37.7260524135838 | -122.456568407028 | (37.7260524135838, -122.456568407028) | |||
| 175956 | 175956 | 213531 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995850.23147 | 2092765.29861 | 37.726097055928705 | -122.456551806415 | (37.7260970559287, -122.456551806415) | |||
| 42262 | 42262 | 214783 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 984 Portola Dr | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5996077.08302 | 2098544.42751 | 37.7419781641671 | -122.456185254462 | (37.7419781641671, -122.456185254462) | |||
| 149463 | 149463 | 213540 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 185 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996102.56759 | 2094123.9077299999 | 37.7298419552203 | -122.455777666417 | (37.7298419552203, -122.455777666417) | |||
| 164881 | 164881 | 213542 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 175 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996107.46568 | 2094090.3506599998 | 37.729750096675794 | -122.455758308509 | (37.7297500966758, -122.455758308509) | |||
| 30317 | 30317 | 213584 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Montecito Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996668.25598 | 2094583.6155700001 | 37.7311366516249 | -122.45385521265301 | (37.7311366516249, -122.453855212653) | |||
| 184445 | 184445 | 214809 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 593 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5996723.66912 | 2094093.91182 | 37.729795219275 | -122.45362829392799 | (37.729795219275, -122.453628293928) | |||
| 54921 | 54921 | 213635 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 583 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996825.88745 | 2094091.1401400003 | 37.729793468270394 | -122.453274715555 | (37.7297934682704, -122.453274715555) | |||
| 177527 | 177527 | 213633 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996856.78477 | 2093858.89472 | 37.7291575486716 | -122.453151141523 | (37.7291575486716, -122.453151141523) | |||
| 36502 | 36502 | 214815 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 655 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5997076.755580001 | 2094378.60032 | 37.73059714113489 | -122.452428176541 | (37.7305971411349, -122.452428176541) | |||
| 146405 | 146405 | 239481 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Shrader St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997782.47434 | 2105960.8807900003 | 37.76243965450129 | -122.450823216731 | (37.7624396545013, -122.450823216731) | |||
| 28053 | 28053 | 237240 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997785.09075 | 2104911.6741400003 | 37.759558947007605 | -122.45073851589198 | (37.7595589470076, -122.450738515892) | |||
| 44808 | 44808 | 213630 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Reposa Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997903.821330001 | 2097994.0573400003 | 37.740571670359294 | -122.449829354368 | (37.7405716703593, -122.449829354368) | |||
| 125122 | 125122 | 96225 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 173 Marview Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2011 12:00:00 AM | 8 | 3x3 | Permit Number 767719 | 5998131.6 | 2103359.5 | 37.755316892676 | -122.449428282005 | (37.755316892676, -122.449428282005) | |
| 185307 | 185307 | 213627 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Sequoia Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998237.04023 | 2097606.63387 | 37.7395269584975 | -122.44864932061 | (37.7395269584975, -122.44864932061) | |||
| 149691 | 149691 | 213626 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Sequoia Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998241.71999 | 2097608.8435400003 | 37.739533293312604 | -122.44863329921002 | (37.7395332933126, -122.44863329921) | |||
| 54133 | 54133 | 213695 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 231 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998737.63514 | 2093659.6015599999 | 37.728717954649504 | -122.446634578437 | (37.7287179546495, -122.446634578437) | |||
| 148223 | 148223 | 178974 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5998851.51754 | 2088138.5359099999 | 37.7135648862728 | -122.445843970916 | (37.7135648862728, -122.445843970916) | |||
| 25256 | 25256 | 238433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Corbett Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 5999629.6727599995 | 2105348.1757099996 | 37.7608628875441 | -122.444390425487 | (37.7608628875441, -122.444390425487) | |||
| 45961 | 45961 | 213699 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 62 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999655.47058 | 2093801.73285 | 37.7291606000606 | -122.44347177969802 | (37.7291606000606, -122.443471779698) | |||
| 59454 | 59454 | 238315 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4769 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999968.346480001 | 2104607.37563 | 37.758848150752 | -122.44316590047899 | (37.758848150752, -122.443165900479) | |||
| 12648 | 12648 | 1088 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2222 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 8 | 3X3 | 5999676.1210900005 | 2089518.7544200001 | 37.717401703502205 | -122.443092918703 | (37.7174017035022, -122.443092918703) | ||
| 50539 | 50539 | 238409 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 209 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000055.039469999 | 2105629.0572200003 | 37.761658379262705 | -122.442939445802 | (37.7616583792627, -122.442939445802) | |||
| 53714 | 53714 | 238314 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 45 Eagle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000118.88808 | 2104341.86796 | 37.7581277146448 | -122.44262619575001 | (37.7581277146448, -122.44262619575) | |||
| 12882 | 12882 | 62704 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 251 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1986 12:00:00 AM | 8 | 3x3 | Permit Number 23044 | 5999960.32769 | 2091545.33962 | 37.7229824455563 | -122.442255952067 | (37.7229824455563, -122.442255952067) | |
| 131832 | 131832 | 135926 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2575 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000595.0032 | 2118891.4120400003 | 37.7981041894114 | -122.44202391886299 | (37.7981041894114, -122.442023918863) | |||
| 157095 | 157095 | 237449 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 42 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6000330.97205 | 2101418.03285 | 37.75011166152311 | -122.441682891454 | (37.7501116615231, -122.441682891454) | |||
| 132498 | 132498 | 238417 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 154 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000421.144859999 | 2105640.77335 | 37.7617114149583 | -122.441674079916 | (37.7617114149583, -122.441674079916) | |||
| 63298 | 63298 | 238411 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 135 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000536.85005 | 2105585.68651 | 37.7615667518287 | -122.441269950672 | (37.7615667518287, -122.441269950672) | |||
| 159954 | 159954 | 62779 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 8 | Permit Number 23134 | 6000268.11132 | 2091745.7518099998 | 37.7235502685229 | -122.441206382083 | (37.7235502685229, -122.441206382083) | |
| 165651 | 165651 | 239424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 7 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000599.70336 | 2102797.60435 | 37.7539149394492 | -122.44085255730499 | (37.7539149394492, -122.440852557305) | |||
| 150319 | 150319 | 78354 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1125 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 8 | 6000366.91048 | 2090562.1790900002 | 37.7203060748337 | -122.44077999190701 | (37.7203060748337, -122.440779991907) | ||
| 69441 | 69441 | 238308 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 84 Seward St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000740.70306 | 2104526.54658 | 37.7586702234594 | -122.440488942504 | (37.7586702234594, -122.440488942504) | |||
| 38676 | 38676 | 179059 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Santa Rosa Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000540.14475 | 2093725.6550599998 | 37.729002120636295 | -122.440407941486 | (37.7290021206363, -122.440407941486) | |||
| 176589 | 176589 | 237443 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 692 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000740.185880001 | 2100908.5426 | 37.748736030656204 | -122.440231277748 | (37.7487360306562, -122.440231277748) |
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");