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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2141 | 2141 | 18982 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2920 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000616.67404 | 2115546.70514 | 37.7889217363036 | -122.44170876675699 | (37.7889217363036, -122.441708766757) | |||
| 8535 | 8535 | 94877 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3043 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2010 12:00:00 AM | 12 | 3x3 | 6000192.74031 | 2115767.95632 | 37.7895050707416 | -122.443191412453 | (37.7895050707416, -122.443191412453) | ||
| 11150 | 11150 | 28262 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3624 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2003 12:00:00 AM | 12 | 3x3 | 6012194.4874599995 | 2088681.14992 | 37.715807638979705 | -122.399763675165 | (37.7158076389797, -122.399763675165) | ||
| 11602 | 11602 | 27093 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 711 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6006091.0826900005 | 2093593.66537 | 37.7289542101608 | -122.421208528251 | (37.7289542101608, -122.421208528251) | |||
| 11924 | 11924 | 27095 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 711 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6006067.91108 | 2093593.9714799998 | 37.7289537443201 | -122.421288656069 | (37.7289537443201, -122.421288656069) | |||
| 12282 | 12282 | 17504 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002139.261969999 | 2091310.46109 | 37.7224614665061 | -122.43470704369 | (37.7224614665061, -122.43470704369) | |||
| 12555 | 12555 | 27112 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004609.34849 | 2093526.9165 | 37.728687286881204 | -122.426326244487 | (37.7286872868812, -122.426326244487) | |||
| 12568 | 12568 | 28244 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3260 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2003 12:00:00 AM | 12 | 2X3 | 6011894.92216 | 2090508.59301 | 37.7208087239121 | -122.40092743836 | (37.7208087239121, -122.40092743836) | ||
| 13866 | 13866 | 10995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016004.21156 | 2097242.6965900003 | 37.7395275952262 | -122.387192226744 | (37.7395275952262, -122.387192226744) | |||
| 17088 | 17088 | 4158 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3739-3737 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/1989 12:00:00 AM | 12 | 3X3 | 6005577.7811900005 | 2100485.8259400004 | 37.74784958418571 | -122.423472835916 | (37.7478495841857, -122.423472835916) | ||
| 17098 | 17098 | 4184 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3835 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 12 | 3X3 | 6004944.66483 | 2100451.1135299997 | 37.7477185170056 | -122.425659653475 | (37.7477185170056, -122.425659653475) | ||
| 17165 | 17165 | 23041 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 987 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1994 12:00:00 AM | 12 | 3X3 | 6006352.9755 | 2103862.85209 | 37.7571658456457 | -122.421031987753 | (37.7571658456457, -122.421031987753) | ||
| 17183 | 17183 | 10191 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1163 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/1991 12:00:00 AM | 12 | 2X3 | 6005802.7182 | 2102181.70358 | 37.7525187680511 | -122.422815518735 | (37.7525187680511, -122.422815518735) | ||
| 17251 | 17251 | 4061 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3045 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 12 | 3x3 | 6009371.8230099995 | 2100537.10689 | 37.7482038046704 | -122.41035678685499 | (37.7482038046704, -122.410356786855) | ||
| 17635 | 17635 | 4185 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3836 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004920.4543 | 2100493.66271 | 37.747833979169705 | -122.42574640029899 | (37.7478339791697, -122.425746400299) | |||
| 18004 | 18004 | 5790 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 573 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002988.46433 | 2108287.7672099997 | 37.769125358463995 | -122.43298388241301 | (37.769125358464, -122.432983882413) | |||
| 18418 | 18418 | 27508 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1325 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/24/2000 12:00:00 AM | 12 | 3X3 | 6005854.22427 | 2101278.43596 | 37.750041509014004 | -122.42257322160299 | (37.750041509014, -122.422573221603) | ||
| 19466 | 19466 | 12753 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1730 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2000 12:00:00 AM | 12 | 3X3 | 5990048.7235199995 | 2114754.53717 | 37.786138867937495 | -122.478214101082 | (37.7861388679375, -122.478214101082) | ||
| 20923 | 20923 | 1370 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5999037.99816 | 2100015.3023099997 | 37.7461863501203 | -122.446053170314 | (37.7461863501203, -122.446053170314) | |||
| 21681 | 21681 | 4232 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3997 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1995 12:00:00 AM | 12 | 3x3 | 6003965.74465 | 2100395.01673 | 37.7475091242643 | -122.429040707768 | (37.7475091242643, -122.429040707768) | ||
| 22128 | 22128 | 4249 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4043 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1995 12:00:00 AM | 12 | 3X3 | 6003613.964 | 2100376.48243 | 37.7474383143284 | -122.43025582047599 | (37.7474383143284, -122.430255820476) | ||
| 24441 | 24441 | 213456 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993116.56669 | 2099668.45247 | 37.7448940675206 | -122.46650336333799 | (37.7448940675206, -122.466503363338) | |||
| 24459 | 24459 | 239377 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 439 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6000680.1305599995 | 2101434.3966200002 | 37.7501764801778 | -122.44047665777 | (37.7501764801778, -122.44047665777) | |||
| 24539 | 24539 | 238429 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 56 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999556.96177 | 2105441.5581799997 | 37.7611151437823 | -122.444648611854 | (37.7611151437823, -122.444648611854) | |||
| 24573 | 24573 | 238500 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 541 30th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6003116.9804 | 2098309.75539 | 37.741735400282 | -122.431826811079 | (37.741735400282, -122.431826811079) | |||
| 24678 | 24678 | 21658 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1745 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004251.7833336 | 2114607.9002324 | 37.7865504610901 | -122.42906481766 | (37.7865504610901, -122.42906481766) | |||
| 24726 | 24726 | 72266 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 359 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 12 | 6002393.10905 | 2091502.19798 | 37.7230023412585 | -122.43384325116999 | (37.7230023412585, -122.43384325117) | ||
| 25218 | 25218 | 238350 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 369 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003912.3019199995 | 2103897.26854 | 37.7571224605398 | -122.429475232291 | (37.7571224605398, -122.429475232291) | |||
| 27300 | 27300 | 213638 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996760.40263 | 2094089.73367 | 37.7297858528368 | -122.453501001192 | (37.7297858528368, -122.453501001192) | |||
| 28930 | 28930 | 238219 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3917 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004421.857419999 | 2101298.96602 | 37.750016967417295 | -122.42752788802099 | (37.7500169674173, -122.427527888021) | |||
| 29583 | 29583 | 238243 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 185 Hancock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003100.47561 | 2105030.65008 | 37.760188457161796 | -122.43236378278999 | (37.7601884571618, -122.43236378279) | |||
| 29621 | 29621 | 66088 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2229 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 12 | Permit Number 29132 | 6007569.63634 | 2120087.67012 | 37.8017838015514 | -122.41797443666401 | (37.8017838015514, -122.417974436664) | |
| 30704 | 30704 | 43671 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 128 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 12 | Permit Number 43314 | 5995229.94076 | 2114692.20799 | 37.786267125837796 | -122.460284069366 | (37.7862671258378, -122.460284069366) | |
| 32922 | 32922 | 124504 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2753 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5996397.54593 | 2111238.05856 | 37.776850040769894 | -122.45599467407 | (37.7768500407699, -122.45599467407) | |||
| 34743 | 34743 | 239442 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 515 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003339.39661 | 2096201.0987200001 | 37.7359581185722 | -122.430907315439 | (37.7359581185722, -122.430907315439) | |||
| 35688 | 35688 | 214746 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5995633.22563 | 2093615.1679099998 | 37.728418131484496 | -122.45736343468701 | (37.7284181314845, -122.457363434687) | |||
| 36067 | 36067 | 179157 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1219 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001634.55542 | 2087559.6833400002 | 37.7121340010651 | -122.436183413036 | (37.7121340010651, -122.436183413036) | |||
| 36181 | 36181 | 238117 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3017 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009237.773630001 | 2104492.70808 | 37.7590574832375 | -122.411099692516 | (37.7590574832375, -122.411099692516) | |||
| 37185 | 37185 | 238189 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4043 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003563.02667 | 2101251.3566 | 37.749837629113294 | -122.430494372819 | (37.7498376291133, -122.430494372819) | |||
| 39029 | 39029 | 238415 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 33 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001057.77596 | 2106119.8706900002 | 37.7630631508618 | -122.43950657978998 | (37.7630631508618, -122.43950657979) | |||
| 39257 | 39257 | 238369 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 588 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002538.45248 | 2103872.03964 | 37.756975307182 | -122.434224721993 | (37.756975307182, -122.434224721993) | |||
| 40725 | 40725 | 238141 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006237.39498 | 2099106.47904 | 37.7440994184675 | -122.421093993304 | (37.7440994184675, -122.421093993304) | |||
| 42225 | 42225 | 237100 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Dearborn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005826.477630001 | 2105998.8251400003 | 37.7630010337862 | -122.42300463446101 | (37.7630010337862, -122.423004634461) | |||
| 46499 | 46499 | 237407 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 134 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6003754.57585 | 2095019.16171 | 37.732736302740896 | -122.429387615873 | (37.7327363027409, -122.429387615873) | |||
| 46645 | 46645 | 239554 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006386.35805 | 2098191.38212 | 37.7415951644956 | -122.42051396747101 | (37.7415951644956, -122.420513967471) | |||
| 47628 | 47628 | 238150 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4206 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001758.25339 | 2101786.09007 | 37.7512034771813 | -122.436773622822 | (37.7512034771813, -122.436773622822) | |||
| 47849 | 47849 | 238220 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 408 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6004143.86901 | 2101473.06412 | 37.7504792729009 | -122.42850159479799 | (37.7504792729009, -122.428501594798) | |||
| 49843 | 49843 | 239376 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 475 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000689.17836 | 2101277.96611 | 37.749747474776 | -122.440434152212 | (37.749747474776, -122.440434152212) | |||
| 50638 | 50638 | 214662 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 817 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5992338.41631 | 2105212.76737 | 37.7600723852386 | -122.469597573482 | (37.7600723852386, -122.469597573482) | |||
| 50826 | 50826 | 237335 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 209 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007119.4283 | 2096907.6823900002 | 37.738111695391204 | -122.417888277143 | (37.7381116953912, -122.417888277143) | |||
| 51333 | 51333 | 213541 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 185 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996106.5404199995 | 2094099.6630400002 | 37.729775613132 | -122.45576218010599 | (37.729775613132, -122.455762180106) | |||
| 56382 | 56382 | 239518 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 518 Nevada St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008859.919290001 | 2095921.12965 | 37.7355006343334 | -122.411800816557 | (37.7355006343334, -122.411800816557) | |||
| 57941 | 57941 | 239492 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 525 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007715.81485 | 2096893.5376900001 | 37.738106402899795 | -122.41582526383101 | (37.7381064028998, -122.415825263831) | |||
| 59415 | 59415 | 213371 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1695 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992456.73021 | 2103998.57674 | 37.756745373020294 | -122.46910001725 | (37.7567453730203, -122.46910001725) | |||
| 60174 | 60174 | 40696 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 308 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 12 | Permit Number 41676 | 6005349.23912 | 2094062.7546400002 | 37.7302003755475 | -122.423806479907 | (37.7302003755475, -122.423806479907) | |
| 61262 | 61262 | 237173 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1536 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008723.78366 | 2099800.15633 | 37.7461439533815 | -122.41254560811701 | (37.7461439533815, -122.412545608117) | |||
| 61956 | 61956 | 72143 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1985 12:00:00 AM | 12 | 6000249.61025 | 2091756.3807599999 | 37.723578399296606 | -122.44127109908301 | (37.7235783992966, -122.441271099083) | ||
| 62141 | 62141 | 238079 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008738.1032 | 2096906.59496 | 37.738199673362395 | -122.41229161256099 | (37.7381996733624, -122.412291612561) | |||
| 63063 | 63063 | 239511 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 368 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008784.34963 | 2097059.5549 | 37.7386222630119 | -122.41214252205499 | (37.7386222630119, -122.412142522055) | |||
| 64721 | 64721 | 179055 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Santa Ysabel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000916.39944 | 2093093.66767 | 37.7272882448407 | -122.439061927974 | (37.7272882448407, -122.439061927974) | |||
| 65115 | 65115 | 237072 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3399 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007248.37653 | 2100524.5773400003 | 37.7480501375056 | -122.417698728809 | (37.7480501375056, -122.417698728809) | |||
| 65630 | 65630 | 238337 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4184 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002537.26418 | 2104163.92201 | 37.7577766786695 | -122.43424969797701 | (37.7577766786695, -122.434249697977) | |||
| 66609 | 66609 | 238111 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006130.75158 | 2102097.2822 | 37.7523054695348 | -122.421675126227 | (37.7523054695348, -122.421675126227) | |||
| 66957 | 66957 | 213435 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2320 Cecilia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5991477.88555 | 2099610.75787 | 37.744640956913706 | -122.47216536005699 | (37.7446409569137, -122.472165360057) | |||
| 69102 | 69102 | 238288 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001740.25021 | 2105130.8583 | 37.7603863817444 | -122.43707532468201 | (37.7603863817444, -122.437075324682) | |||
| 69528 | 69528 | 238402 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003869.86313 | 2107043.38322 | 37.7657585359576 | -122.42984640320499 | (37.7657585359576, -122.429846403205) | |||
| 69827 | 69827 | 31988 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 137 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 12 | Permit Number 35388 | 5994566.451859999 | 2114623.28431 | 37.786039692573205 | -122.46257455055901 | (37.7860396925732, -122.462574550559) | |
| 72867 | 72867 | 213672 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 233 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5994584.30105 | 2098807.88448 | 37.742615749323 | -122.46136587284201 | (37.742615749323, -122.461365872842) | |||
| 73178 | 73178 | 239482 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 266 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997756.5692 | 2105932.2708 | 37.76235961572971 | -122.45091074955799 | (37.7623596157297, -122.450910749558) | |||
| 74304 | 74304 | 196486 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Jack London Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6014249.44841 | 2112687.4163599997 | 37.7818381074737 | -122.394340577066 | (37.7818381074737, -122.394340577066) | |||
| 76478 | 76478 | 238181 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1307 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002572.01453 | 2101708.7288599997 | 37.7510372761464 | -122.433954022462 | (37.7510372761464, -122.433954022462) | |||
| 76868 | 76868 | 196441 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 768 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6012093.04476 | 2104807.3138 | 37.7600810286241 | -122.401246859559 | (37.7600810286241, -122.401246859559) | ||||
| 78561 | 78561 | 14625 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 15 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 12 | 3X4 | 6017974.7726653 | 2094204.2737729999 | 37.7312936151853 | -122.380167719121 | (37.7312936151853, -122.380167719121) | ||
| 84684 | 84684 | 21663 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1751 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004224.469596201 | 2114604.1030069 | 37.786538488702504 | -122.42915904562 | (37.7865384887025, -122.42915904562) | |||
| 85212 | 85212 | 12835 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2240 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2005 12:00:00 AM | 12 | 5 | 5988460.73959 | 2114698.1479700003 | 37.7858917318965 | -122.48370390161001 | (37.7858917318965, -122.48370390161) | ||
| 85352 | 85352 | 24468 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3832 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1995 12:00:00 AM | 12 | 3X3 | 6004979.4036442 | 2100499.5239535 | 37.7478534037891 | -122.42554297324301 | (37.7478534037891, -122.425542973243) | ||
| 89197 | 89197 | 78358 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3021-3023 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2000 12:00:00 AM | 12 | 3x3 | 6009285.65580835 | 2104489.61631361 | 37.759051679025895 | -122.41093387422501 | (37.7590516790259, -122.410933874225) | ||
| 94442 | 94442 | 95276 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 728 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x5 | Created tree record for 2 trees on 2/2/2011. Trees planted years ago but no permit record for planting. | 6009044.4 | 2104856.4 | 37.760045252375605 | -122.411794171614 | (37.7600452523756, -122.411794171614) | ||
| 95112 | 95112 | 28260 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3562 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2003 12:00:00 AM | 12 | 3x3 | 6012130.0554759 | 2089144.2345931 | 37.717075584405706 | -122.400018884967 | (37.7170755844057, -122.400018884967) | ||
| 97758 | 97758 | 21655 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1700 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004345.5648 | 2114673.53748 | 37.7867359926545 | -122.42874503768101 | (37.7867359926545, -122.428745037681) | |||
| 99921 | 99921 | 4057 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2997X CESAR CHAVEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 12 | 3x3 | 6009584.7 | 2100553.3 | 37.7482601984276 | -122.409621804497 | (37.7482601984276, -122.409621804497) | ||
| 102400 | 102400 | 6398 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4X Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/1998 12:00:00 AM | 12 | 3X3 | 6018041.9202743 | 2094226.9871977002 | 37.7313596862419 | -122.379937152762 | (37.7313596862419, -122.379937152762) | ||
| 106277 | 106277 | 116388 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 369 LIBERTY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003920.0 | 2103882.0 | 37.757080972596896 | -122.429447520552 | (37.7570809725969, -122.429447520552) | |||
| 109978 | 109978 | 4156 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3728 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1997 12:00:00 AM | 12 | 3X3 | 6005666.336308599 | 2100538.647271 | 37.747999617329796 | -122.423170370206 | (37.7479996173298, -122.423170370206) | ||
| 119697 | 119697 | 238336 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4166 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002612.8595 | 2104171.37607 | 37.7578014361103 | -122.433988791145 | (37.7578014361103, -122.433988791145) | |||
| 122784 | 122784 | 26727 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008944.94841 | 2120470.5671200003 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | |||
| 129900 | 129900 | 239444 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 112 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003418.50093 | 2096162.71698 | 37.7358572128391 | -122.430631082368 | (37.7358572128391, -122.430631082368) | |||
| 131060 | 131060 | 179043 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 185 Rousseau St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003587.09627 | 2094654.6620200002 | 37.731725985448 | -122.429940643172 | (37.731725985448, -122.429940643172) | |||
| 133585 | 133585 | 213649 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5999480.38992 | 2096117.32238 | 37.735508679678 | -122.44424337825001 | (37.735508679678, -122.44424337825) | |||
| 133843 | 133843 | 213648 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 33 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5999490.37481 | 2096123.0943099998 | 37.735525097687294 | -122.44420927146002 | (37.7355250976873, -122.44420927146) | |||
| 134206 | 134206 | 239465 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 112 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997095.6853 | 2105895.5893599996 | 37.762221041888104 | -122.45319384044 | (37.7622210418881, -122.45319384044) | |||
| 137703 | 137703 | 214801 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 335 Juanita Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5995052.86946 | 2097512.7865 | 37.739086688207294 | -122.459651927803 | (37.7390866882073, -122.459651927803) | |||
| 137812 | 137812 | 237438 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1249 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001996.991330001 | 2100364.87543 | 37.747314724106204 | -122.435846365126 | (37.7473147241062, -122.435846365126) | |||
| 139120 | 139120 | 4124 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3435 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 12 | 3X3 | 6006760.09222 | 2100373.98133 | 37.7476091457032 | -122.419376518884 | (37.7476091457032, -122.419376518884) | ||
| 142447 | 142447 | 26728 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6008944.94841 | 2120470.5671200003 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | |||
| 147448 | 147448 | 237221 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4042 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6003593.36551 | 2100421.02177 | 37.7475594422299 | -122.430330225874 | (37.7475594422299, -122.430330225874) | |||
| 147765 | 147765 | 238092 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1378 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009265.01952 | 2101130.38415 | 37.74982682464471 | -122.410768004543 | (37.7498268246447, -122.410768004543) | |||
| 147951 | 147951 | 179070 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Delano Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999898.613419999 | 2091994.1618700002 | 37.7242112909146 | -122.44250149305701 | (37.7242112909146, -122.442501493057) | |||
| 150490 | 150490 | 136010 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1761 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007314.88578 | 2118424.776 | 37.797203571436896 | -122.418737997073 | (37.7972035714369, -122.418737997073) | |||
| 150891 | 150891 | 238287 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001741.359069999 | 2105121.29108 | 37.760360175513505 | -122.437070804676 | (37.7603601755135, -122.437070804676) |
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");