Street_Tree_List

Data source: data.sfgov.org

217 rows where qSiteInfo = 2 and qSpecies = 18 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 217 ✖
Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188145 188145 213572 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6 Merced Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995340.05175 2100264.05702 37.7466575040536 -122.45885812859801 (37.7466575040536, -122.458858128598)
187732 187732 214729 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 620 Faxon Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994877.75254 2092392.95175 37.725018800251796 -122.459886624766 (37.7250188002518, -122.459886624766)
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)
187309 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)
186638 186638 238427 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 46 Mars St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5999551.73328 2105494.96582 37.761261489550705 -122.444670533732 (37.7612614895507, -122.444670533732)
186426 186426 214765 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993613.7342 2101408.96874 37.7497017595309 -122.464910643325 (37.7497017595309, -122.464910643325)
186096 186096 246690 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 51 Stoneman St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6008005.33416 2099391.14992 37.7449805661161 -122.41500097851002 (37.7449805661161, -122.41500097851)
185931 185931 118627 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 494 46th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5981628.0956 2112437.91019 37.7792856992778 -122.50717480668301 (37.7792856992778, -122.507174806683)
185845 185845 238428 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 48 Mars St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5999550.38613 2105480.9679099997 37.76122297789 -122.444674186789 (37.76122297789, -122.444674186789)
184698 184698 213460 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 360 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5992857.49918 2099683.78553 37.7449212153419 -122.46740027790199 (37.7449212153419, -122.467400277902)
183294 183294 237062 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 189 Tiffany Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   6006064.26727 2099183.21264 37.7443003503954 -122.421698080498 (37.7443003503954, -122.421698080498)
182372 182372 213673 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 233 Kensington Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5994572.28535 2098818.2381 37.742643486217105 -122.461408169751 (37.7426434862171, -122.461408169751)
181338 181338 213606 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 153 Vasquez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994943.30534 2099473.46779 37.7444639307591 -122.460172759368 (37.7444639307591, -122.460172759368)
180995 180995 250869 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986468.30668 2114640.25117 37.785616584774104 -122.490592812307 (37.7856165847741, -122.490592812307)
180675 180675 213449 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Cortes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5993183.71921 2099631.03001 37.7447951897395 -122.466268445152 (37.7447951897395, -122.466268445152)
179631 179631 213662 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Edgehill Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994703.12273 2098951.8229900002 37.7430178065176 -122.46096545511101 (37.7430178065176, -122.460965455111)
179415 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)
179381 179381 213434 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2326 Cecilia Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991474.66936 2099581.1439400003 37.7445594585564 -122.47217432268499 (37.7445594585564, -122.472174322685)
178872 178872 213578 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 468 Dewey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994798.52341 2100109.7667799997 37.7462027195744 -122.46071948511101 (37.7462027195744, -122.460719485111)
178867 178867 250677 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 735 El Camino Del Mar 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5986302.66224 2114812.53014 37.78607993617911 -122.49117856955 (37.7860799361791, -122.49117856955)
177855 177855 213439 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2306 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5991480.5494800005 2099691.03581 37.7448615336422 -122.47216199929501 (37.7448615336422, -122.472161999295)
177005 177005 214490 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2083 16th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991275.47389 2101260.33758 37.7491585600375 -122.47298552109 (37.7491585600375, -122.47298552109)
176624 176624 213429 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2344 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991482.19388 2099461.6129099997 37.7442316925378 -122.472139593583 (37.7442316925378, -122.472139593583)
176517 176517 214814 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 349 Kensington Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5994180.976419999 2099052.1679700003 37.7432632692845 -122.462778159201 (37.7432632692845, -122.462778159201)
176349 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)
175798 175798 123040 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 586 Funston Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5991933.82363 2111460.09457 37.7772024792906 -122.47145207590499 (37.7772024792906, -122.471452075905)
175714 175714 238464 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 595 Waller St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6002882.5169400005 2108867.91188 37.7707122832869 -122.433391810394 (37.7707122832869, -122.433391810394)
175268 175268 213644 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 28 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5999501.838169999 2096096.8027 37.7354535611166 -122.44416774976001 (37.7354535611166, -122.44416774976)
174331 174331 238437 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 404 Loma Vista Ter 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5999965.68289 2106731.28661 37.7646797326031 -122.443327665152 (37.7646797326031, -122.443327665152)
173955 173955 179013 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 575 Lisbon St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6001863.70015 2090153.04553 37.719267814726 -122.435576835623 (37.719267814726, -122.435576835623)
172451 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)
171902 171902 213658 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Edgehill Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994707.10173 2098998.8404 37.7431471335475 -122.460955103903 (37.7431471335475, -122.460955103903)
170124 170124 179016 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 70 Curtis St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6000604.90599 2088146.70208 37.713687269620706 -122.439784232863 (37.7136872696207, -122.439784232863)
170080 170080 237063 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 132 27th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 8ft   6005626.63256 2100241.78482 37.7471822602654 -122.423286564723 (37.7471822602654, -122.423286564723)
169697 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)
169418 169418 237059 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 199 Tiffany Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6006039.83494 2099139.1612299997 37.7441780174179 -122.42177943406901 (37.7441780174179, -122.421779434069)
169376 169376 213558 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Valdez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5996393.4117 2094019.32459 37.72957148234121 -122.45476463767599 (37.7295714823412, -122.454764637676)
169127 169127 213485 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 266 Magellan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994672.963719999 2100339.90318 37.74682739138329 -122.46117033057301 (37.7468273913833, -122.461170330573)
168464 168464 213487 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 270 Magellan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5994647.931480001 2100314.84296 37.746757141726704 -122.461255072761 (37.7467571417267, -122.461255072761)
168358 168358 237206 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 483 Valley St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6002728.73401 2099167.30182 37.7440680069289 -122.43323049721 (37.7440680069289, -122.43323049721)
168210 168210 218135 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 0 Noriega St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5992409.03176 2103467.31015 37.7552838973381 -122.469226308173 (37.7552838973381, -122.469226308173)
168168 168168 213448 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Cortes Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993184.39566 2099612.1282900004 37.7447433294416 -122.46626473273199 (37.7447433294416, -122.466264732732)
167375 167375 213574 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 401 Dewey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5995184.75747 2100395.85805 37.747010469052206 -122.45940466010201 (37.7470104690522, -122.459404660102)
167213 167213 213484 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 200 Magellan Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994952.79314 2100602.87802 37.7475655540149 -122.460221763422 (37.7475655540149, -122.460221763422)
166651 166651 250870 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986470.3680300005 2114630.24299 37.7855892256034 -122.490584944137 (37.7855892256034, -122.490584944137)
166643 166643 213570 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Merced Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5995304.50078 2100206.2944900002 37.7464968590373 -122.458976877776 (37.7464968590373, -122.458976877776)
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)
166260 166260 213436 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2320 Cecilia Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5991479.35771 2099619.1153 37.7446639894614 -122.47216087873899 (37.7446639894614, -122.472160878739)
165881 165881 213595 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 444 08th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5993843.0022599995 2101824.40238 37.7508556508809 -122.46414798674999 (37.7508556508809, -122.46414798675)
164635 164635 214779 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5992800.25839 2095349.1682799999 37.7330161429665 -122.467283086348 (37.7330161429665, -122.467283086348)
163946 163946 218240 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 329 Wawona St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 2ft   5992041.06009 2097211.89095 37.7380868543242 -122.470043394412 (37.7380868543242, -122.470043394412)
163386 163386 214771 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 330 Forest Hill Path 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994272.06767 2100993.3623099998 37.748598545893394 -122.46260397398999 (37.7485985458934, -122.46260397399)
160563 160563 213398 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Quintara St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991517.42633 2101098.4611299997 37.7487280941444 -122.472137056592 (37.7487280941444, -122.472137056592)
160348 160348 218239 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 333 Wawona St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 2ft   5992027.82558 2097196.10935 37.738042756963296 -122.47008800346599 (37.7380427569633, -122.470088003466)
159600 159600 213583 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Garcia Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994657.50527 2099501.27559 37.744523840899205 -122.46116300556801 (37.7445238408992, -122.461163005568)
158346 158346 213661 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Edgehill Way 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994700.406169999 2098993.61475 37.7431323999386 -122.460977876533 (37.7431323999386, -122.460977876533)
157642 157642 237127 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 501 York St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6009827.96491 2105859.23915 37.7628427477209 -122.409154949944 (37.7628427477209, -122.409154949944)
157025 157025 239438 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 221 Mateo St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6003961.12868 2096293.81528 37.7362479053017 -122.428764347015 (37.7362479053017, -122.428764347015)
156323 156323 213482 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Sola Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994974.838219999 2100674.05314 37.7477622510295 -122.460150689121 (37.7477622510295, -122.460150689121)
154989 154989 136018 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 11 Greenwich St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6012250.392990001 2120519.5939 37.8032320823636 -122.401807129095 (37.8032320823636, -122.401807129095)
154266 154266 213293 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 930 Capitol Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995051.99009 2090130.06095 37.7188154620373 -122.45912052741001 (37.7188154620373, -122.45912052741)
154192 154192 214784 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 222 Fowler Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     50 Width 8ft   5997118.36808 2099147.53648 37.7436938709906 -122.45262836023399 (37.7436938709906, -122.452628360234)
153946 153946 250819 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Sea View Ter 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5986191.04243 2114164.9353 37.7842953053345 -122.49151705368999 (37.7842953053345, -122.49151705369)
153720 153720 214811 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 111 Edgehill Way 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994726.40905 2098964.7055200003 37.7430545186528 -122.46088587139799 (37.7430545186528, -122.460885871398)
153167 153167 214491 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1908 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991283.85529 2102380.71309 37.752235304435395 -122.473038230333 (37.7522353044354, -122.473038230333)
152578 152578 213473 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 45 Dorantes Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994145.2265 2100030.80799 37.7459483094686 -122.462972759886 (37.7459483094686, -122.462972759886)
152202 152202 214767 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 333 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5994252.85515 2100808.3467 37.7480894333884 -122.462656990837 (37.7480894333884, -122.462656990837)
149697 149697 238353 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 737 Sanchez St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6003694.73227 2104140.3391 37.757777553703 -122.43024501240299 (37.757777553703, -122.430245012403)
149609 149609 213602 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 47 Santa Rita Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993779.00092 2100704.49945 37.7477769936179 -122.46428801028799 (37.7477769936179, -122.464288010288)
149108 149108 213571 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Merced Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995317.16684 2100218.39007 37.746530798564 -122.458933955845 (37.746530798564, -122.458933955845)
147549 147549 239437 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Natick St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6003054.423690001 2095570.6971900002 37.7342110290136 -122.43184758179399 (37.7342110290136, -122.431847581794)
147395 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)
146881 146881 213437 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2316 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5991477.149780001 2099652.715 37.7447561178165 -122.47217096194599 (37.7447561178165, -122.472170961946)
146653 146653 237020 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 85 Webster St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6004265.72291 2108964.3991799997 37.7710555904751 -122.428614156631 (37.7710555904751, -122.428614156631)
141430 141430 117091 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2X 09TH AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
137946 137946 214774 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 88 Sotelo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5993702.75991 2101413.55838 37.7497194941621 -122.464603124653 (37.7497194941621, -122.464603124653)
136766 136766 213470 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 396 Magellan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993853.55379 2099589.61797 37.7447201080625 -122.463949296841 (37.7447201080625, -122.463949296841)
136090 136090 213575 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 475 Dewey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994817.52034 2100048.80174 37.746036417842205 -122.46064937938 (37.7460364178422, -122.46064937938)
135808 135808 213461 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 314 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993060.97049 2099698.9583900003 37.744974620699 -122.466697820147 (37.744974620699, -122.466697820147)
135745 135745 214813 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 349 Kensington Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5994166.60375 2099059.892 37.7432836497201 -122.46282841600599 (37.7432836497201, -122.462828416006)
135228 135228 237060 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 199 Tiffany Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6006047.428119999 2099152.06421 37.7442138742778 -122.421754094776 (37.7442138742778, -122.421754094776)
134984 134984 179034 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 88 Alpha St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 5ft   6011090.19294 2088313.2717799998 37.7147358971229 -122.403554780747 (37.7147358971229, -122.403554780747)
134608 134608 213647 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 31 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5999489.23346 2096109.45083 37.7354875707953 -122.444212237426 (37.7354875707953, -122.444212237426)
134135 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)
133843 133843 213648 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 33 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5999490.37481 2096123.0943099998 37.735525097687294 -122.44420927146002 (37.7355250976873, -122.44420927146)
133729 133729 239375 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4407 24th St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   6000535.569069999 2101672.81424 37.750822884967704 -122.440993660945 (37.7508228849677, -122.440993660945)
133585 133585 213649 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 34 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5999480.38992 2096117.32238 37.735508679678 -122.44424337825001 (37.735508679678, -122.44424337825)
132655 132655 250524 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 95 26th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   5987685.45058 2115374.99193 37.7877049922276 -122.486435864334 (37.7877049922276, -122.486435864334)
132130 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)
132126 132126 213640 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5999549.40588 2096053.5305299999 37.735337459545605 -122.444000182688 (37.7353374595456, -122.444000182688)
131462 131462 179011 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 579 Lisbon St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   6001850.91399 2090131.7943 37.71920873736379 -122.435619512955 (37.7192087373638, -122.435619512955)
131339 131339 213554 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 55 Valdez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996349.28998 2094015.7857 37.729559234450896 -122.454916914484 (37.7295592344509, -122.454916914484)
129524 129524 120701 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 70 22nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 5ft   5988982.8407 2114887.49266 37.7864419959893 -122.48191147245501 (37.7864419959893, -122.481911472455)
126747 126747 250902 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 266 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5986843.33005 2114156.49339 37.7843102232907 -122.489259776936 (37.7843102232907, -122.489259776936)
124363 124363 214772 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 96 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993626.401000001 2101411.46451 37.7497093426138 -122.46486702261801 (37.7497093426138, -122.464867022618)
100884 100884 214775 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 36 Sotelo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993929.10229 2101145.39334 37.7489962269912 -122.463800968038 (37.7489962269912, -122.463800968038)
77124 77124 123052 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 544 Funston Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5991924.81576 2111692.51922 37.7778401329349 -122.471500177083 (37.7778401329349, -122.471500177083)
76930 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)
76291 76291 213654 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Edgehill Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5994824.078840001 2099066.74247 37.7433403061049 -122.460555550413 (37.7433403061049, -122.460555550413)
76027 76027 213474 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993866.67958 2099897.14622 37.7455652594364 -122.463926229234 (37.7455652594364, -122.463926229234)

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