Street_Tree_List

Data source: data.sfgov.org

201 rows where DBH = 7 and qSpecies = 18 sorted by qAddress

View and edit SQL

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

DBH

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
177339 237055 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Albion St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6005794.81287 2107159.8300900003 37.7661870916781 -122.42319668379601 (37.7661870916781, -122.423196683796)
188326 237054 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Albion St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6005797.6398599995 2107141.4188 37.766136698186706 -122.423185596933 (37.7661366981867, -122.423185596933)
177590 179114 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Yale St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006904.09352 2093533.23761 37.7288340895016 -122.418393600792 (37.7288340895016, -122.418393600792)
183083 237039 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Octavia St 2 : 4 Tree 1 Private 1     7 Width 4ft   6005609.24206 2109730.37641 37.7732347215415 -122.424021354908 (37.7732347215415, -122.424021354908)
2962 238484 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 103 Germania St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/1996 12:00:00 AM 7 Width 3ft Permit Number 37768 6003723.3725 2108822.3529 37.7706348579377 -122.430480026835 (37.7706348579377, -122.430480026835)
156212 213288 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1039 Plymouth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995905.05181 2090820.4262299999 37.720760046333496 -122.456221739052 (37.7207600463335, -122.456221739052)
129792 239380 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1045 Diamond St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001965.88505 2100966.71291 37.748965460295295 -122.435996986282 (37.7489654602953, -122.435996986282)
165754 239381 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1045 Diamond St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001965.34817 2100982.03085 37.749007489225896 -122.43599993875 (37.7490074892259, -122.43599993875)
162531 238498 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 105 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003477.3432599995 2097803.5179 37.7403658101453 -122.43054468270901 (37.7403658101453, -122.430544682709)
32182 238284 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 107 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002049.03443 2105187.74161 37.7605601163763 -122.43601145548 (37.7605601163763, -122.43601145548)
59126 238103 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1070 Capp St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007408.1692 2101126.1965400004 37.7497110387337 -122.41718879522101 (37.7497110387337, -122.417188795221)
133870 237233 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 110 Carmel St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   5998197.90052 2105385.6119999997 37.760883883112506 -122.449344967798 (37.7608838831125, -122.449344967798)
76058 214695 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 111 Pacheco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5994531.06764 2099914.59728 37.7456514414536 -122.46163015929899 (37.7456514414536, -122.461630159299)
136377 33273 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1121 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/13/1996 12:00:00 AM 7   Permit Number 37442 6009382.25638 2117052.9627099996 37.7935530901583 -122.41148738125901 (37.7935530901583, -122.411487381259)
71708 66515 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1173 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/20/1991 12:00:00 AM 7   Permit Number 29681 6007962.75323 2118537.74133 37.7975502016423 -122.41650421331 (37.7975502016423, -122.41650421331)
138154 213546 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 120 Colon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996160.95111 2093881.0696900003 37.729178530763704 -122.45555828401001 (37.7291785307637, -122.45555828401)
156414 213668 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 120 Edgehill Way 4 Front Yard : Yard 7 Tree 1 Private 1     7 Width 3ft   5994864.53372 2098940.09364 37.742994887300895 -122.460406494088 (37.7429948873009, -122.460406494088)
29134 213564 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 120 Hazelwood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996496.71182 2094497.05235 37.730889133023894 -122.454442016707 (37.7308891330239, -122.454442016707)
68712 214661 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1207 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5990516.2149 2103788.47288 37.756056167676796 -122.47579561737899 (37.7560561676768, -122.475795617379)
122146 237078 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1213 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6011151.97874 2102591.50578 37.7539443643514 -122.404345610361 (37.7539443643514, -122.404345610361)
172050 179155 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1219 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001609.50582 2087555.82392 37.7121219807101 -122.436269715579 (37.7121219807101, -122.436269715579)
60874 214690 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Forest Side Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992455.885480001 2098286.40938 37.7410611821255 -122.468687312988 (37.7410611821255, -122.468687312988)
66278 214511 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1256 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991129.134930001 2106870.28966 37.7645535343379 -122.47390078539301 (37.7645535343379, -122.473900785393)
53005 237369 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1270 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007652.02884 2102269.91751 37.7528651536288 -122.416426519083 (37.7528651536288, -122.416426519083)
164627 213356 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 128 Shields St 1 : 4 Tree 1 Private 1     7 Width 3ft   5993609.42924 2089850.5677200002 37.717965004654495 -122.464086568463 (37.7179650046545, -122.464086568463)
66136 237131 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1298 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010040.24724 2101736.3478099997 37.751534103039106 -122.408129951231 (37.7515341030391, -122.408129951231)
163514 237319 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 13 Bronte St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6009381.9747 2097364.8525 37.7394940586067 -122.41009775870899 (37.7394940586067, -122.410097758709)
149473 213517 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Eastwood Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995657.9114 2093576.16628 37.728312460239 -122.45727527503 (37.728312460239, -122.45727527503)
157637 213481 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5995034.05151 2100934.56273 37.7484809505562 -122.45996480284201 (37.7484809505562, -122.459964802842)
130098 213561 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Montecito Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996368.30466 2094246.96905 37.7301950992263 -122.45486787625099 (37.7301950992263, -122.454867876251)
137695 214748 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 131 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5995627.33147 2093578.0296099999 37.728315820111206 -122.457381125259 (37.7283158201112, -122.457381125259)
69686 214618 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1318 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5992726.7392 2106452.86445 37.7634998014025 -122.46834478191299 (37.7634998014025, -122.468344781913)
48145 213532 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1321 Plymouth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995868.11744 2092855.1447 37.726344778666004 -122.456496470238 (37.726344778666, -122.456496470238)
48553 237350 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1327 Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6008148.7592400005 2097711.6028400003 37.740376959939496 -122.41438622176399 (37.7403769599395, -122.414386221764)
68955 67626 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1334 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/11/1993 12:00:00 AM 7   Permit Number 31212 6007155.75192 2118470.9352 37.7973213520513 -122.41929191739901 (37.7973213520513, -122.419291917399)
163139 213469 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 134 Forest Side Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992386.6287 2098205.19502 37.740834186951396 -122.468920866899 (37.7408341869514, -122.468920866899)
69928 179111 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1362 Wayland St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6007634.67362 2091466.7715 37.723201116628395 -122.415721669126 (37.7232011166284, -122.415721669126)
135510 214623 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1405 11th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992699.2887699995 2105840.21181 37.7618160331047 -122.46839514841801 (37.7618160331047, -122.468395148418)
46671 214787 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 142 Robinhood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5996140.97875 2096605.13185 37.7366570006238 -122.455824168555 (37.7366570006238, -122.455824168555)
38699 52528 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 142 San Juan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2005 12:00:00 AM 7   Permit Number 48628 6001332.37944 2092272.13723 37.725056169781205 -122.437565081984 (37.7250561697812, -122.437565081984)
39192 237047 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1420 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010376.92538 2101024.95602 37.7495996235389 -122.406915536442 (37.7495996235389, -122.406915536442)
37813 238091 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 143 Precita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007328.83633 2100176.58773 37.7470991638041 -122.417395843442 (37.7470991638041, -122.417395843442)
37085 43877 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 144 Paris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/01/2000 12:00:00 AM 7   Permit Number 43492 6003098.49585 2092711.51751 37.726362865838 -122.431491164302 (37.726362865838, -122.431491164302)
25588 213562 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 145 Hazelwood Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5996449.59751 2094511.04667 37.7309248558938 -122.454605908258 (37.7309248558938, -122.454605908258)
160632 239489 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 149 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007596.83968 2097934.55267 37.7409581108362 -122.41631033385 (37.7409581108362, -122.41631033385)
174447 214741 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 149 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5995646.65866 2093691.6399400001 37.7286288768052 -122.457322526337 (37.7286288768052, -122.457322526337)
147925 69417 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 149 Seville St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/1994 12:00:00 AM 7   Permit Number 33522 6001453.459840001 2087297.44526 37.7114036625088 -122.436790570551 (37.7114036625088, -122.436790570551)
50591 214626 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1490 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5992765.05186 2105331.6268700003 37.7604233906498 -122.468130704575 (37.7604233906498, -122.468130704575)
50711 213511 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 150 Eastwood Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995678.2658 2093705.9591 37.728670009096604 -122.457214294721 (37.7286700090966, -122.457214294721)
160968 213417 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1500 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991348.87476 2098431.44962 37.7413954124699 -122.47252548818001 (37.7413954124699, -122.47252548818)
2028 137540 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1510 Steiner St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6002670.5536 2113409.7602 37.7831710382055 -122.434449780345 (37.7831710382055, -122.434449780345)
37021 52927 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 155 Delano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/2006 12:00:00 AM 7   Permit Number 48911 6000347.40158 2092558.92243 37.7257875650324 -122.44099059964199 (37.7257875650324, -122.440990599642)
34283 71395 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1553 Kirkwood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/1988 12:00:00 AM 7     6015450.35777 2096531.9462 37.7375453329415 -122.389057616714 (37.7375453329415, -122.389057616714)
76147 213552 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 159 Valdez Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5996195.23273 2094521.1933400002 37.7309381235969 -122.45548601716999 (37.7309381235969, -122.45548601717)
170585 237238 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 160 Belgrave Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5997759.67882 2104910.90723 37.7595553865982 -122.45082634726002 (37.7595553865982, -122.45082634726)
156124 213373 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1623 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5992438.33257 2104386.8742299997 37.757810473397605 -122.46919190279101 (37.7578104733976, -122.469191902791)
70879 214481 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1623 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5990862.01954 2104342.15602 37.7575964779098 -122.474640129733 (37.7575964779098, -122.474640129733)
62002 214782 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1627 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5992928.85631 2095341.1686900002 37.733001600925 -122.466837912033 (37.733001600925, -122.466837912033)
186400 214739 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 163 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5995642.708819999 2093778.0293599998 37.7288658544767 -122.457342428316 (37.7288658544767, -122.457342428316)
41242 213372 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1695 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992451.123869999 2104023.5243900004 37.756813548812794 -122.46912122148198 (37.7568135488128, -122.469121221482)
160656 237144 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 170 Linda St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6005849.94213 2104551.74877 37.7590290259771 -122.422820631377 (37.7590290259771, -122.422820631377)
27902 237161 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1704 Alabama St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009291.76832 2099412.6751099997 37.745111875222605 -122.41055422399799 (37.7451118752226, -122.410554223998)
46698 214631 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1776 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5992834.36322 2103387.96848 37.7550906141526 -122.467749627638 (37.7550906141526, -122.467749627638)
78887 47481 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1809 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 7   Permit Number 45377 5999494.3233199995 2115164.49026 37.7878082622913 -122.445564438253 (37.7878082622913, -122.445564438253)
56247 239495 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 183 Ellsworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6008119.0668 2097783.93358 37.7405738961806 -122.414494003717 (37.7405738961806, -122.414494003717)
150482 237061 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 189 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006054.68331 2099167.27831 37.744256057884705 -122.42173008828001 (37.7442560578847, -122.42173008828)
133475 178977 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 190 Rae Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 1ft   5997636.8287 2087155.6990200002 37.71079680899621 -122.449971558745 (37.7107968089962, -122.449971558745)
181618 239476 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 192 Upper Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5999659.94513 2106593.00366 37.7642826027833 -122.444375189158 (37.7642826027833, -122.444375189158)
188990 237330 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 Montezuma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007590.604590001 2099741.7313 37.745919870209605 -122.416459870422 (37.7459198702096, -122.416459870422)
69506 51979 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 201 Otsego Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2015 12:00:00 AM 7 3x3 Permit Number 775837 6000531.055869999 2092082.3650200001 37.7244895060779 -122.440321560704 (37.7244895060779, -122.440321560704)
34760 213591 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2038 10th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5993200.871040001 2101602.44663 37.75020918670911 -122.466352387876 (37.7502091867091, -122.466352387876)
70635 213403 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2115 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5990666.17605 2100976.9204599997 37.7483450764622 -122.475071772846 (37.7483450764622, -122.475071772846)
131249 237120 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2132 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009548.42279 2104767.49302 37.759829396529 -122.410044714901 (37.759829396529, -122.410044714901)
67348 50606 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 219 03rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/02/2003 12:00:00 AM 7   Permit Number 47205 5994896.0666 2113978.5362299997 37.784288365194996 -122.461387423321 (37.784288365195, -122.461387423321)
180015 238342 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 219 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002084.58101 2104567.6189900003 37.7588594291365 -122.43584414559099 (37.7588594291365, -122.435844145591)
187756 238343 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 219 Collingwood St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002082.73822 2104584.2017099997 37.7589048565973 -122.43585170530001 (37.7589048565973, -122.4358517053)
172812 196484 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 22 South Park 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6014481.0981 2112803.55306 37.7821698664821 -122.393547301273 (37.7821698664821, -122.393547301273)
24367 238301 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 222 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001725.065719999 2104535.0570799997 37.7587495931307 -122.43708518302799 (37.7587495931307, -122.437085183028)
64826 239556 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 222 Winfield St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006749.08669 2098198.6867400003 37.741635656457 -122.419260290053 (37.741635656457, -122.419260290053)
147639 213305 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 223 Capitol Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995012.40881 2087891.7837 37.712667406052496 -122.45909535897499 (37.7126674060525, -122.459095358975)
163881 237201 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 225 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6004272.781830001 2099243.3149599996 37.744364192347795 -122.427896939189 (37.7443641923478, -122.427896939189)
136441 238408 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 227 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5999936.15736 2105561.41019 37.7614658586796 -122.44334575050199 (37.7614658586796, -122.443345750502)
155818 213407 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2281 Cecilia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991478.9532699995 2099887.90451 37.7454019920197 -122.47218186622 (37.7454019920197, -122.47218186622)
71505 213438 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2310 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991478.325209999 2099662.36916 37.7447826936787 -122.472167601152 (37.7447826936787, -122.472167601152)
35149 135976 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2319 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6003577.71337 2116564.31874 37.7918841103205 -122.43153665472 (37.7918841103205, -122.43153665472)
47537 213432 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2330 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991474.23883 2099545.3415099997 37.744461129378 -122.472173202136 (37.744461129378, -122.472173202136)
133107 213425 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2333 Cecilia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991441.219819999 2099500.5467 37.744336223447704 -122.472284109241 (37.7443362234477, -122.472284109241)
179415 213431 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2336 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991475.01091 2099520.48282 37.74439291849001 -122.472168720814 (37.74439291849, -122.472168720814)
50996 213444 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2351 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992608.79172 2099462.0696400004 37.7442980787015 -122.468244128866 (37.7442980787015, -122.468244128866)
147395 213428 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2356 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991465.99867 2099400.33215 37.744062494091 -122.472191126522 (37.744062494091, -122.472191126522)
160670 213443 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2379 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5992616.385419999 2099292.02218 37.743831610246 -122.468205503896 (37.743831610246, -122.468205503896)
19771 31446 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 239 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/1995 12:00:00 AM 7   Permit Number 35021 6002088.5838 2104465.22029 37.758578494425294 -122.435822975577 (37.7585784944253, -122.435822975577)
177043 196434 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2400 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010626.05667 2105554.79226 37.7620514837216 -122.406373163394 (37.7620514837216, -122.406373163394)
163171 32104 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 242 Hartford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 7   Permit Number 35476 6002688.38371 2104495.7919400004 37.7586964899576 -122.433750783787 (37.7586964899576, -122.433750783787)
167046 239490 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 249 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007775.8469 2097942.50211 37.7409900025935 -122.415691953736 (37.7409900025935, -122.415691953736)
45022 237364 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2498 Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6008191.48556 2103992.92844 37.757626472091 -122.414682895521 (37.757626472091, -122.414682895521)
67810 213625 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 Sequoia Way 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5998243.47992 2097619.18832 37.73956179822439 -122.448627959023 (37.7395617982244, -122.448627959023)
157439 30897 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 252 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/09/1995 12:00:00 AM 7   Permit Number 34724 6007528.97575 2097493.2020099997 37.739742443263296 -122.416513727228 (37.7397424432633, -122.416513727228)
57812 250934 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 259 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5987104.958930001 2114216.89652 37.7844913413477 -122.48835908522699 (37.7844913413477, -122.488359085227)
30982 179077 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 26 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6004472.54344 2093374.1401799999 37.7282600630306 -122.426788312529 (37.7282600630306, -122.426788312529)

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