Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3800 | 3800 | 213446 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993033.55222 | 2099443.36305 | 37.744271238444206 | -122.46677405027799 | (37.7442712384442, -122.466774050278) | |||
24761 | 24761 | 239379 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001966.9971 | 2100951.6663900004 | 37.7489242092946 | -122.43599206429899 | (37.7489242092946, -122.435992064299) | |||
26309 | 26309 | 214582 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990775.418980001 | 2105160.42766 | 37.7598382161767 | -122.47499935674 | (37.7598382161767, -122.47499935674) | |||
28192 | 28192 | 213505 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 435 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995673.53388 | 2093929.48913 | 37.7292834969286 | -122.457246816911 | (37.7292834969286, -122.457246816911) | |||
31805 | 31805 | 196440 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1400 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014910.39402 | 2101173.59345 | 37.7502603851252 | -122.391248908417 | (37.7502603851252, -122.391248908417) | |||
33345 | 33345 | 238295 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4331 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001522.95996 | 2105232.46628 | 37.76065301904121 | -122.437834106978 | (37.7606530190412, -122.437834106978) | |||
33752 | 33752 | 214776 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 36 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993929.139169999 | 2101136.44437 | 37.7489716575191 | -122.463800191051 | (37.7489716575191, -122.463800191051) | |||
35218 | 35218 | 179144 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 27 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011384.73394 | 2092575.3064700002 | 37.7264550220761 | -122.402836290783 | (37.7264550220761, -122.402836290783) | |||
38826 | 38826 | 237101 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Dearborn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005826.7194 | 2106021.63498 | 37.7630636778686 | -122.423005419568 | (37.7630636778686, -122.423005419568) | |||
40048 | 40048 | 214790 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 385 Valdez Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5995727.44967 | 2095481.9792400002 | 37.7335493555041 | -122.45717268576401 | (37.7335493555041, -122.457172685764) | |||
41835 | 41835 | 36752 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2579 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 5 | Permit Number 41197 | 6002410.05116 | 2116400.74901 | 37.7913687394284 | -122.435565056287 | (37.7913687394284, -122.435565056287) | |
44234 | 44234 | 40656 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Congdon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 5 | Permit Number 47919 | 6004682.83135 | 2093737.6135099998 | 37.729269967531295 | -122.42608720287501 | (37.7292699675313, -122.426087202875) | |
49020 | 49020 | 213515 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 136 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995664.797590001 | 2093624.26858 | 37.7284449330771 | -122.457254947662 | (37.7284449330771, -122.457254947662) | |||
51769 | 51769 | 178969 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1029 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008570.63643 | 2086915.27252 | 37.710756219889 | -122.412164693966 | (37.710756219889, -122.412164693966) | |||
52601 | 52601 | 218243 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Wawona St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5992077.34134 | 2097249.8857 | 37.7381932756065 | -122.46992071879299 | (37.7381932756065, -122.469920718793) | |||
53116 | 53116 | 196472 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012828.31305 | 2093641.68277 | 37.7294635726784 | -122.39792063783001 | (37.7294635726784, -122.39792063783) | |||
54683 | 54683 | 237231 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 156 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997890.32696 | 2105949.42746 | 37.762414379941 | -122.450449370342 | (37.762414379941, -122.450449370342) | |||
56506 | 56506 | 214706 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 365 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992562.58655 | 2094392.71432 | 37.7303762352585 | -122.468035225354 | (37.7303762352585, -122.468035225354) | |||
57767 | 57767 | 196435 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2400 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010616.04846 | 2105554.51436 | 37.7620501608016 | -122.40640775851101 | (37.7620501608016, -122.406407758511) | |||
58431 | 58431 | 238422 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 39 Ord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000862.680480001 | 2106132.31447 | 37.7630862130923 | -122.440182239531 | (37.7630862130923, -122.440182239531) | |||
58834 | 58834 | 246596 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Waller St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6005499.23386 | 2109278.3771900004 | 37.771987429293794 | -122.424369733388 | (37.7719874292938, -122.424369733388) | |||
61199 | 61199 | 238059 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 235 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007196.64814 | 2098835.72523 | 37.7434100179704 | -122.41775791321301 | (37.7434100179704, -122.417757913213) | |||
63695 | 63695 | 214742 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995645.35981 | 2093675.42483 | 37.7285842794183 | -122.457325843925 | (37.7285842794183, -122.457325843925) | |||
64175 | 64175 | 213537 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 350 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995960.276190001 | 2094132.2579700002 | 37.7298567157933 | -122.456270184638 | (37.7298567157933, -122.456270184638) | |||
65904 | 65904 | 213549 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 167 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996164.200680001 | 2094572.3950200002 | 37.7310769303549 | -122.455596998927 | (37.7310769303549, -122.455596998927) | |||
71320 | 71320 | 119536 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 871 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5986636.85825 | 2109986.6532900003 | 37.772848973963 | -122.489667337074 | (37.772848973963, -122.489667337074) | |||
71827 | 71827 | 196444 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200x Kansas St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 6011674.76736 | 2102721.10758 | 37.7543294225845 | -122.402546786399 | (37.7543294225845, -122.402546786399) | |||
72612 | 72612 | 238205 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3753 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003372.86711 | 2103580.20335 | 37.756221318288105 | -122.43131817159401 | (37.7562213182881, -122.431318171594) | |||
73371 | 73371 | 238198 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3980 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003319.92767 | 2101870.58274 | 37.7515241043535 | -122.431379217587 | (37.7515241043535, -122.431379217587) | |||
73503 | 73503 | 37967 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 456 Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40197 | 6013486.4792599995 | 2104950.0016 | 37.76055045945989 | -122.396437603638 | (37.7605504594599, -122.396437603638) | |
112881 | 112881 | 96952 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 32951 | 5988431.28084 | 2110571.1656 | 37.7745584847462 | -122.483503155986 | (37.7745584847462, -122.483503155986) | ||
129573 | 129573 | 214713 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 104 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993041.99484 | 2094312.53309 | 37.730183751567004 | -122.466372032662 | (37.730183751567, -122.466372032662) | |||
130629 | 130629 | 237273 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 538 Moultrie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007678.69569 | 2096826.35906 | 37.7379198583235 | -122.415948847759 | (37.7379198583235, -122.415948847759) | |||
131282 | 131282 | 213492 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 598 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995442.0885 | 2093284.14 | 37.7274982284469 | -122.45800025452101 | (37.7274982284469, -122.458000254521) | |||
131344 | 131344 | 50296 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3052 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 5 | Permit Number 47008 | 5990299.81493 | 2094981.9607400002 | 37.7318632220065 | -122.47590087674101 | (37.7318632220065, -122.475900876741) | |
131800 | 131800 | 213513 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995671.87942 | 2093659.25145 | 37.7285413943492 | -122.457232995212 | (37.7285413943492, -122.457232995212) | |||
134466 | 134466 | 179119 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 621 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008944.10696 | 2093176.6835 | 37.7279696962286 | -122.411315930896 | (37.7279696962286, -122.411315930896) | |||
135038 | 135038 | 214836 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 551 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5994751.08968 | 2092221.3600299999 | 37.724540365428 | -122.460312054477 | (37.724540365428, -122.460312054477) | |||
135619 | 135619 | 214734 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995175.571830001 | 2092744.7785099999 | 37.7260019553109 | -122.45888256407801 | (37.7260019553109, -122.458882564078) | |||
135668 | 135668 | 238147 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 802 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001871.92033 | 2101706.7023 | 37.7509919566136 | -122.43637486971201 | (37.7509919566136, -122.436374869712) | |||
146079 | 146079 | 102036 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
147151 | 147151 | 213352 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 752 Head St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993533.94375 | 2090828.7779700002 | 37.7206465833581 | -122.464418471345 | (37.7206465833581, -122.464418471345) | |||
147211 | 147211 | 237282 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 536 Ellsworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007992.832359999 | 2096323.6955799998 | 37.7365573107595 | -122.41482715485 | (37.7365573107595, -122.41482715485) | |||
150914 | 150914 | 213545 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996122.94435 | 2093991.52147 | 37.72947962377471 | -122.45569765643499 | (37.7294796237747, -122.455697656435) | |||
151392 | 151392 | 213466 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992628.19492 | 2098122.8504 | 37.7406220431851 | -122.46807964016199 | (37.7406220431851, -122.468079640162) | |||
151554 | 151554 | 213415 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2493 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991371.6003 | 2098454.8903099997 | 37.7414610899681 | -122.472448620415 | (37.7414610899681, -122.472448620415) | |||
152848 | 152848 | 238241 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 198 Hancock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003080.16415 | 2105070.64153 | 37.7602971123315 | -122.43243688685699 | (37.7602971123315, -122.432436886857) | |||
153219 | 153219 | 179023 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 947 Olmstead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008910.54006 | 2090367.6054099998 | 37.7202546776964 | -122.411233621349 | (37.7202546776964, -122.411233621349) | |||
155902 | 155902 | 123062 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 472 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5991906.84489 | 2112217.36307 | 37.7792801711752 | -122.471600599763 | (37.7792801711752, -122.471600599763) | |||
157718 | 157718 | 238227 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 62 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6004074.9323 | 2102707.3864599997 | 37.753864531534 | -122.428827968657 | (37.753864531534, -122.428827968657) | |||
159746 | 159746 | 214711 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993359.6935 | 2094710.89058 | 37.7312958694138 | -122.46530264071998 | (37.7312958694138, -122.46530264072) | |||
163704 | 163704 | 214753 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995611.1547 | 2093431.54917 | 37.7279126909161 | -122.457426455583 | (37.7279126909161, -122.457426455583) | |||
166433 | 166433 | 250875 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986467.14332 | 2114671.0752 | 37.7857011507179 | -122.490599105783 | (37.7857011507179, -122.490599105783) | |||
167032 | 167032 | 179163 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 171 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002120.7512 | 2086617.7341900002 | 37.7095752265844 | -122.43443567596 | (37.7095752265844, -122.43443567596) | |||
167531 | 167531 | 238451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 66 Carmelita St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002635.187000001 | 2108649.70915 | 37.770099117414 | -122.434231725909 | (37.770099117414, -122.434231725909) | |||
169557 | 169557 | 179140 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011506.1503099995 | 2092130.7968400002 | 37.725241269158104 | -122.402385315842 | (37.7252412691581, -122.402385315842) | |||
174660 | 174660 | 178999 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002140.71576 | 2089748.47374 | 37.7181726806159 | -122.434590385445 | (37.7181726806159, -122.434590385445) | |||
175566 | 175566 | 214587 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991795.61852 | 2105144.1496 | 37.7598525927434 | -122.47146983337299 | (37.7598525927434, -122.471469833373) | |||
182553 | 182553 | 88408 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769129 | 6009412.43491 | 2117319.72378 | 37.794287243625604 | -122.411401815264 | (37.7942872436256, -122.411401815264) | |
182777 | 182777 | 49699 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 87@ TUCKER Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50825 | 6011128.67682 | 2088300.86402 | 37.7147039774881 | -122.403420891467 | (37.7147039774881, -122.403420891467) | |
185776 | 185776 | 50300 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 5 | Permit Number 47010 | 5989048.80024 | 2095796.1569299998 | 37.7340261814504 | -122.480285417057 | (37.7340261814504, -122.480285417057) | |
187534 | 187534 | 213472 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 390 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993869.43858 | 2099604.78571 | 37.744762670277204 | -122.463895471497 | (37.7447626702772, -122.463895471497) |
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");