Street_Tree_List

Data source: data.sfgov.org

340 rows where DBH = 5 and qSpecies = 18 sorted by qAddress

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlotSize

DBH

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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)
76930 213653 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Edgehill Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994833.218169999 2099074.30171 37.7433615876766 -122.46052449682699 (37.7433615876766, -122.460524496827)
76069 237116 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Hwy 101 Southbound 4 Back Yard : Yard 13 Tree 1 Private 1     5     6005840.35144 2109000.46624 37.7712436090254 -122.423170022474 (37.7712436090254, -122.423170022474)
135 237030 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 4 : 4 Tree 1 DPW 2     5 Width 4ft   6005725.94025 2109733.85532 37.773250861665204 -122.423617927146 (37.7732508616652, -122.423617927146)
168224 237032 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 6 : 4 Tree 1 Private 1     5 Width 4ft   6005721.49565 2109758.3052 37.7733177442556 -122.423635040324 (37.7733177442556, -122.423635040324)
171710 237031 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Octavia St 5 : 4 Tree 1 Private 1     5 Width 4ft   6005723.44032 2109745.94906 37.773283927046 -122.423627434762 (37.773283927046, -122.423627434762)
169697 213577 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994569.9735900005 2099964.1686400003 37.745789791378 -122.46149922251001 (37.745789791378, -122.46149922251)
133460 196469 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1001 Cesar Chavez St 1 : 4 Tree 1 Private 1     5 Width 3ft   6015764.4296 2101073.59632 37.750033173207 -122.388288593857 (37.750033173207, -122.388288593857)
38174 214754 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5995607.36531 2093372.70982 37.7277509145579 -122.457435300396 (37.7277509145579, -122.457435300396)
49374 237038 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Octavia St 1 : 4 Tree 1 Private 1     5 Width 4ft   6005608.429830001 2109742.33589 37.773267513529 -122.424025015163 (37.773267513529, -122.424025015163)
147759 237040 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Octavia St 3 : 4 Tree 1 Private 1     5 Width 4ft   6005610.09761 2109720.52403 37.7732077175873 -122.42401769467699 (37.7732077175873, -122.424017694677)
151819 179142 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Woolsey St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6011536.91523 2092140.59723 37.7252698963774 -122.402279652698 (37.7252698963774, -122.402279652698)
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)
134618 237248 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1018 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998867.298909999 2106367.84933 37.7636191288389 -122.447100512681 (37.7636191288389, -122.447100512681)
42755 178970 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1029 Sunnydale Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6008583.66239 2086910.8267599999 37.7107447436356 -122.412119359132 (37.7107447436356, -122.412119359132)
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)
155352 178968 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1029 Sunnydale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6008554.00356 2086922.9270900001 37.710776304465 -122.412222721805 (37.710776304465, -122.412222721805)
76200 214712 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 104 Aptos Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5993048.1007199995 2094327.00059 37.730223828061206 -122.46635197506599 (37.7302238280612, -122.466351975066)
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)
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)
68872 239378 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1045 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001967.26718 2100937.20425 37.7488845150303 -122.435990095661 (37.7488845150303, -122.435990095661)
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)
72170 213468 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 108 Madrone Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992714.16407 2098359.03254 37.7412755040554 -122.467799567899 (37.7412755040554, -122.467799567899)
56131 49551 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1084REVISED Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/07/2003 12:00:00 AM 5   Permit Number 46441 6009968.28689 2111507.46699 37.7783593364429 -122.40906818514601 (37.7783593364429, -122.409068185146)
62370 213314 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 109 Caine Ave 4 : 4 Tree 1 Private 1     5 Width 3ft   5997314.23204 2089197.70588 37.716385224975795 -122.45123369250601 (37.7163852249758, -122.451233692506)
180916 213313 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 109 Caine Ave 3 : 4 Tree 1 Private 1     5 Width 3ft   5997305.300980001 2089185.13122 37.7163501865023 -122.45126365610099 (37.7163501865023, -122.451263656101)
49382 214518 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1115 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992295.0711900005 2106570.75423 37.7637985534841 -122.469846353829 (37.7637985534841, -122.469846353829)
40352 214556 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1134 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992207.40042 2106631.63575 37.763960649997 -122.47015401102199 (37.763960649997, -122.470154011022)
41563 214831 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 114 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5996535.21399 2090645.46472 37.7203157965229 -122.45403084486999 (37.7203157965229, -122.45403084487)
24527 214750 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 115 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5995612.00037 2093456.6914400002 37.7279817741139 -122.457425350319 (37.7279817741139, -122.457425350319)
65515 103235 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 116 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/03/2013 12:00:00 AM 5   Permit Number 770114 5998278.0 2110273.0 37.7743079905046 -122.44942009353998 (37.7743079905046, -122.44942009354)
179283 238324 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 118 Danvers St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5999937.73353 2105034.20415 37.7600183710625 -122.44330243107201 (37.7600183710625, -122.443302431072)
156227 52875 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 118@ BEACH Cervantes Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2006 12:00:00 AM 5 3x3 Permit Number 48887 6001367.786590001 2121129.52184 37.8042934541427 -122.439510392889 (37.8042934541427, -122.439510392889)
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)
151473 78234 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1200 Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2000 12:00:00 AM 5     5999806.62934 2090324.19629 37.7196207041996 -122.44269961461 (37.7196207041996, -122.44269961461)
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)
37641 214515 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1203 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992128.70606 2106565.35498 37.7637741108079 -122.47042136146601 (37.7637741108079, -122.470421361466)
51106 179030 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 121 Tucker Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6010311.02154 2088780.05452 37.715974033352 -122.406280800329 (37.715974033352, -122.406280800329)
168285 237337 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 124 Ellert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6007298.22515 2096977.17548 37.7383125688774 -122.417275008733 (37.7383125688774, -122.417275008733)
56077 250876 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986468.29527 2114661.08637 37.7856737915584 -122.490594385245 (37.7856737915584, -122.490594385245)
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)
45195 179089 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6004232.136580001 2092904.6382099998 37.7269573195072 -122.427585973436 (37.7269573195072, -122.427585973436)
24140 213364 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1256 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995501.45899 2106973.1472099996 37.765088237057206 -122.45878564505101 (37.7650882370572, -122.458785645051)
179414 237134 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1298 York St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6010042.928119999 2101694.54007 37.7514194583536 -122.408117732167 (37.7514194583536, -122.408117732167)
182241 237133 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1298 York St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6010041.99943 2101706.7565099997 37.751452949993 -122.40812180518299 (37.751452949993, -122.408121805183)
186491 237290 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Gates St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008290.53524 2097979.90466 37.7411216210694 -122.41391498957898 (37.7411216210694, -122.413914989579)
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)
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)
12764 83412 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 131 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/01/2009 12:00:00 AM 5 3x3 Permit Number 52320 6003991.38049 2093029.1643599998 37.727285619722295 -122.428427134505 (37.7272856197223, -122.428427134505)
150010 57783 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 132 Langton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/08/1977 12:00:00 AM 5   Permit Number 16708 6010300.606980001 2110589.59695 37.7758576905205 -122.407853819819 (37.7758576905205, -122.407853819819)
116490 237349 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1327 Eugenia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6008183.5398699995 2097707.7987599997 37.7403684685413 -122.414265694627 (37.7403684685413, -122.414265694627)
132130 250868 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986468.4993 2114649.30576 37.7856414573183 -122.490592812321 (37.7856414573183, -122.490592812321)
53778 239415 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1331 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6003277.56126 2100489.89633 37.7477306623461 -122.43142717303499 (37.7477306623461, -122.431427173035)
63931 237138 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1333 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6010092.41473 2101418.1954099997 37.7506634477621 -122.40792711546301 (37.7506634477621, -122.407927115463)
179560 237397 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1349 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6005861.9823900005 2101116.6759099998 37.74959779070179 -122.42253490058901 (37.7495977907018, -122.422534900589)
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)
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)
59195 237324 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 141 Bronte St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6009324.726 2096749.59433 37.7378014841462 -122.41025227214199 (37.7378014841462, -122.410252272142)
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)
131581 214736 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 142 Westwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5995136.59009 2093647.8547099999 37.728479343838394 -122.459082682125 (37.7284793438384, -122.459082682125)
147124 214745 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 143 Eastwood Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5995638.20043 2093638.9497200001 37.728483716343796 -122.45734795645001 (37.7284837163438, -122.45734795645)
171156 214576 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1433 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5991271.06324 2106533.25971 37.7636363598559 -122.473385314688 (37.7636363598559, -122.473385314688)
180157 214624 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1437 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992704.14512 2105656.98806 37.7613132293559 -122.468365022027 (37.7613132293559, -122.468365022027)
169330 237384 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 145 Bartlett St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006711.76494 2102924.2782900003 37.7546089570481 -122.419724558745 (37.7546089570481, -122.419724558745)
183451 179086 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 146 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003896.054690001 2092965.8387900002 37.7271063470709 -122.42875216298201 (37.7271063470709, -122.428752162982)
173230 237356 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1460 Treat Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008696.4782300005 2100696.55595 37.74860373498271 -122.41270338695801 (37.7486037349827, -122.412703386958)
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)
51459 237355 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1490 Treat Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008699.155040001 2100670.9782 37.748533654421394 -122.41269232260001 (37.7485336544214, -122.4126923226)
26412 237354 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1498 Treat Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008702.0539 2100646.6699900003 37.7484670721949 -122.412680580152 (37.7484670721949, -122.412680580152)
166970 214482 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1501 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5990834.97468 2105131.29032 37.7597616641021 -122.47479125810499 (37.7597616641021, -122.474791258105)
176349 213605 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 153 Vasquez Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994959.23188 2099490.14718 37.7445106442654 -122.460118897178 (37.7445106442654, -122.460118897178)
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)
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)
181265 214649 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 16 Hillway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5996114.56342 2106803.43322 37.7646574671859 -122.45665280570299 (37.7646574671859, -122.456652805703)
165023 213509 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 160 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995676.0127 2093766.8995400001 37.7288372074655 -122.45722649041402 (37.7288372074655, -122.457226490414)
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)
163181 213465 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 160 Madrone Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992622.33383 2098106.49157 37.7405767874889 -122.468098715706 (37.7405767874889, -122.468098715706)
72095 237172 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1600 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008747.760009999 2099354.11029 37.7449205552465 -122.412431177465 (37.7449205552465, -122.412431177465)
162338 237318 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 161 Bradford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6009544.13683 2097633.21679 37.7402400165656 -122.409556006214 (37.7402400165656, -122.409556006214)
31890 237043 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1650 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009416.7221099995 2107184.85565 37.7664595394906 -122.410670920049 (37.7664595394906, -122.410670920049)
61437 237044 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1650 Bryant St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009421.66766 2107070.91245 37.766146954953896 -122.410645766889 (37.7661469549539, -122.410645766889)
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)
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)
167730 238496 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1716 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003948.65821 2098247.39872 37.7416112938229 -122.428946700751 (37.7416112938229, -122.428946700751)
187309 214781 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 Monterey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5992834.3473 2095346.2214400002 37.733010019498 -122.467165018866 (37.733010019498, -122.467165018866)
179271 238279 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 173 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002064.94714 2104866.1537900004 37.7596780181477 -122.435933409625 (37.7596780181477, -122.435933409625)
13234 82735 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 174 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2012 12:00:00 AM 5 4x4 Permit Number 769757 6003803.82611 2092820.0296 37.726700767200896 -122.429060604385 (37.7267007672009, -122.429060604385)
68445 196459 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1760 Cesar Chavez St 5 : 4 Tree 1 Private 1     5 Width 2ft   6013796.36432 2101069.01684 37.7499113519264 -122.395093999398 (37.7499113519264, -122.395093999398)
136726 32208 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1779 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/22/1995 12:00:00 AM 5   Permit Number 35530 6009365.92876 2099185.56999 37.744492451861205 -122.41028175730601 (37.7444924518612, -122.410281757306)
65680 238239 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 178 Hancock St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003114.8756099995 2105072.8715 37.760305203553 -122.432316995528 (37.760305203553, -122.432316995528)
71278 179062 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Colonial Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6000439.3413 2093583.9176599998 37.7286072022493 -122.44074626284201 (37.7286072022493, -122.440746262842)
154585 179063 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Colonial Way 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6000420.96554 2093594.54688 37.7286353411305 -122.440810550888 (37.7286353411305, -122.440810550888)
45094 213387 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1818 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5993154.76021 2103068.62065 37.7542322625174 -122.466618400145 (37.7542322625174, -122.466618400145)
123729 42840 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1828 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/03/2000 12:00:00 AM 5   Permit Number 42772 6008289.65137 2118753.27916 37.7981603934451 -122.415388321908 (37.7981603934451, -122.415388321908)
56137 239512 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 184 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008807.60125 2097692.07072 37.7403603179715 -122.41210681810101 (37.7403603179715, -122.412106818101)
72032 239474 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 192 Upper Ter 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5999649.68958 2106560.94763 37.7641939997813 -122.444408356168 (37.7641939997813, -122.444408356168)
131251 239473 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 192 Upper Ter 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5999645.38119 2106544.57309 37.7641487935566 -122.44442208073099 (37.7641487935566, -122.444422080731)
73254 196456 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1950 Cesar Chavez St 12 : 4 Tree 1 Private 1     5 Width 3ft   6012848.61003 2101014.24206 37.7497082022719 -122.39836755861201 (37.7497082022719, -122.398367558612)
38958 238240 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 198 Hancock St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003097.13649 2105073.6590299997 37.760306360067 -122.432378403045 (37.760306360067, -122.432378403045)
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)

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 1886.166ms · Data source: data.sfgov.org