Street_Tree_List

Data source: data.sfgov.org

258 rows where DBH = 8 and qSpecies = 18 sorted by qAddress

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize

DBH

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
151398 237057 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Albion St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6005792.84324 2107206.9501900002 37.766316361124204 -122.423206846131 (37.7663163611242, -122.423206846131)
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)
65737 237406 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Rousseau St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6003490.74781 2095180.0910599998 37.733163237889705 -122.43031121240801 (37.7331632378897, -122.430311212408)
155046 237178 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 102 Peralta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010211.56612 2100240.61937 37.747436753123395 -122.407432068339 (37.7474367531234, -122.407432068339)
162028 237362 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1024 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6008600.1572 2102553.65045 37.753697493244296 -122.41316776537901 (37.7536974932443, -122.413167765379)
181028 237124 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1025 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 6ft   6008637.74753 2102555.44614 37.7537045340508 -122.413037896084 (37.7537045340508, -122.413037896084)
63078 179090 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 105 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6004283.33861 2092987.6886900002 37.727188253710295 -122.427414882796 (37.7271882537103, -122.427414882796)
70697 179091 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 105 Edinburgh St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6004289.65055 2092997.26304 37.72721489973979 -122.42739374423 (37.7272148997398, -122.42739374423)
33130 237129 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1050 York St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009970.37435 2102983.71181 37.7549551744519 -122.408459559056 (37.7549551744519, -122.408459559056)
183886 238104 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1070 Capp St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007407.26502 2101103.9240599996 37.7496498326723 -122.417190343875 (37.7496498326723, -122.417190343875)
134002 237375 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1071 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009203.81222 2102937.13478 37.7547843257492 -122.41110726841299 (37.7547843257492, -122.411107268413)
64071 238105 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1086 Capp St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007413.8685800005 2101032.90286 37.7494551960109 -122.41716247657 (37.7494551960109, -122.41716247657)
36765 179054 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 11 Santa Ysabel Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6000895.42593 2093107.17468 37.7273241385819 -122.439135400803 (37.7273241385819, -122.439135400803)
151967 196468 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1101 Cesar Chavez St 12 : 4 Tree 1 Private 1     8 Width 3ft   6015629.24905 2101065.86664 37.7500044578413 -122.38875552004801 (37.7500044578413, -122.388755520048)
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)
21630 26477 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 112 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/23/2001 12:00:00 AM 8 3x3   6001287.0278199995 2098748.5722 37.742836382684295 -122.438185594392 (37.7428363826843, -122.438185594392)
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)
24585 49743 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 114 Arleta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM 8   Permit Number 46542 6010621.23603 2087831.01483 37.7133855110935 -122.405141759495 (37.7133855110935, -122.405141759495)
68807 237368 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1142 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007610.26122 2103005.0736599998 37.754881376099895 -122.41662303354299 (37.7548813760999, -122.416623033543)
68144 72942 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 115 Gladstone Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1999 12:00:00 AM 8     6006185.1456 2093706.6722400002 37.729269804734294 -122.420891365245 (37.7292698047343, -122.420891365245)
187910 237431 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1204 Diamond St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8     6001926.93451 2100562.26984 37.747852742609204 -122.43610273936899 (37.7478527426092, -122.436102739369)
16945 27513 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1212 Guerrero St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/10/2001 12:00:00 AM 8 3X3   6005754.33518 2101803.9188099997 37.751478728181795 -122.422955987444 (37.7514787281818, -122.422955987444)
17483 27512 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1212 Guerrero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/2000 12:00:00 AM 8 3X3   6005753.54797 2101830.48031 37.75155161552 -122.422960597352 (37.75155161552, -122.422960597352)
17628 27516 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1212 Guerrero St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/2000 12:00:00 AM 8 3X3   6005758.28533 2101749.6847900003 37.75133003695179 -122.422938473144 (37.7513300369518, -122.422938473144)
18229 27514 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1212 Guerrero St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/2000 12:00:00 AM 8 3X3   6005755.80226 2101784.51034 37.7514255197779 -122.422949534811 (37.7514255197779, -122.422949534811)
20572 27519 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1212 Guerrero St 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/08/2000 12:00:00 AM 8 3X3   6005760.41969 2101697.87743 37.751187906306896 -122.42292741057 (37.7511879063069, -122.42292741057)
21098 10199 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1212 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 2X2   6005752.31611 2101874.30524 37.7516718791661 -122.42296797178801 (37.7516718791661, -122.422967971788)
21994 27517 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1212 Guerrero St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/2000 12:00:00 AM 8 3X3   6005756.59865 2101732.46517 37.7512826606677 -122.422943082157 (37.7512826606677, -122.422943082157)
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)
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)
29866 238523 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 124 Moffitt St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6002701.22767 2096788.6026400002 37.7375350896745 -122.43315568259199 (37.7375350896745, -122.433155682592)
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)
119842 238399 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 127 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6002891.0834 2107543.95425 37.76707750593479 -122.433267560956 (37.7670775059348, -122.433267560956)
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)
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)
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)
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)
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)
32123 238182 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1305 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6002572.19519 2101717.4702 37.7510612880479 -122.43395402248699 (37.7510612880479, -122.433954022487)
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)
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)
649 96374 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1315 Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/2011 12:00:00 AM 8 3x3 Permit Number 768288 6008916.2106800005 2117429.1962900003 37.7945599836999 -122.41312655846599 (37.7945599836999, -122.413126558466)
6734 96373 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1315 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/17/2011 12:00:00 AM 8 3x3 Permit Number 768288 6008912.46348 2117456.9297 37.7946359224745 -122.41314148629499 (37.7946359224745, -122.413141486295)
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)
84414 26169 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1320 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/2004 12:00:00 AM 8 3X3   6005780.5723577 2101269.3137616003 37.750012306137 -122.422827266036 (37.750012306137, -122.422827266036)
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)
59928 32098 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 134 Hartford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 8   Permit Number 35471 6002656.28427 2105089.46023 37.7603247386273 -122.433904232401 (37.7603247386273, -122.433904232401)
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)
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)
168007 237332 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 136 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6005681.71691 2096637.35347 37.737288415535396 -122.422839963208 (37.7372884155354, -122.422839963208)
112791 23845 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1360 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/17/2001 12:00:00 AM 8 3X3   6003737.7759918 2113383.7091882997 37.7831600307032 -122.43075576300899 (37.7831600307032, -122.430755763009)
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)
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)
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)
59440 196504 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 142 Russ St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6010369.66301 2111467.46147 37.778271967325004 -122.40767684761002 (37.778271967325, -122.40767684761)
129561 237370 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1429 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6009322.8071800005 2100850.0167799997 37.749060238052294 -122.410548375712 (37.7490602380523, -122.410548375712)
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)
133876 237357 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1448 Treat Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008697.70775 2100711.62827 37.7486451892219 -122.412700200662 (37.7486451892219, -122.412700200662)
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)
61545 237400 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 149 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006179.98115 2102125.53046 37.7523858086711 -122.421506888246 (37.7523858086711, -122.421506888246)
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)
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)
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)
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)
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)
185143 237171 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1591 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008782.19605 2099461.78779 37.7452181462955 -122.412319712805 (37.7452181462955, -122.412319712805)
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)
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)
110571 51834 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 168 29th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/13/2005 12:00:00 AM 8 3x3 Permit Number 48063 6005440.48678199 2099065.68713562 37.7439424571986 -122.42384662792699 (37.7439424571986, -122.423846627927)
159836 238128 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 168 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6005448.09835 2099061.1826400002 37.743930518573606 -122.42381998861201 (37.7439305185736, -122.423819988612)
150786 239550 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 173 Bonview St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007148.228630001 2098090.56095 37.7413612382336 -122.417872525497 (37.7413612382336, -122.417872525497)
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)
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)
51040 80385 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1754 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2002 12:00:00 AM 8     6011729.10125 2092748.5600299998 37.7269499630479 -122.40165799273599 (37.7269499630479, -122.401657992736)
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)
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)
76049 237403 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 190 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006132.14055 2102096.37065 37.752303044951404 -122.421670258201 (37.7523030449514, -122.421670258201)
59450 196470 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1950 Newcomb Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 9ft   6013295.589480001 2097174.20298 37.7391891560441 -122.39655273032899 (37.7391891560441, -122.396552730329)
160988 202147 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1979 Armstrong Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 7ft   6012955.252309999 2093506.82348 37.72910034549879 -122.397472339298 (37.7291003454988, -122.397472339298)
39923 238083 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 199 Powhattan Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008630.1472 2098081.04423 37.7414183955492 -122.412747878228 (37.7414183955492, -122.412747878228)
151932 55259 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2 Britton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/1972 12:00:00 AM 8   Permit Number 11181 6008604.18987 2088002.78931 37.7137441994136 -122.41212553387501 (37.7137441994136, -122.412125533875)
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)
59315 237279 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 200 Ellsworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008083.61272 2097672.38407 37.7402656139611 -122.41460869875601 (37.7402656139611, -122.414608698756)
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)
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)
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)
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)
147858 238222 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 209 Vicksburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6004148.77666 2102090.97951 37.7521762018776 -122.428528663484 (37.7521762018776, -122.428528663484)
88494 113152 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 21 BRONTE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6009396.0 2097313.0 37.7393524690061 -122.410045605495 (37.7393524690061, -122.410045605495)
65644 237320 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 21 Bronte St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6009376.6168 2097305.0778799998 37.7393296301669 -122.410112065144 (37.7393296301669, -122.410112065144)
57461 238344 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 213 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6002080.48499 2104602.09911 37.7589538705354 -122.43586077857701 (37.7589538705354, -122.435860778577)
184342 237340 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 217 Holly Park Cir 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006872.11608 2096713.55038 37.7375647304254 -122.41872959740299 (37.7375647304254, -122.418729597403)
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)
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)
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)
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)
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)
75965 135975 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2325 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6003558.57482 2116562.95168 37.79187927196 -122.43160277647301 (37.79187927196, -122.431602776473)
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)
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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 831.99ms · Data source: data.sfgov.org