Street_Tree_List

Data source: data.sfgov.org

217 rows where qSiteInfo = 2 and qSpecies = 18 sorted by SiteOrder

✎ 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
4797 4797 214559 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1342 Irving St 1 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 Width 3ft   5991532.56497 2106606.32246 37.7638521099028 -122.472486197695 (37.7638521099028, -122.472486197695)
4821 4821 214558 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1340 Irving St 1 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2   02/18/2009 12:00:00 AM 4 Width 3ft   5991564.93185 2106609.34919 37.7638622938456 -122.472374472204 (37.7638622938456, -122.472374472204)
23387 23387 213501 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 787 Faxon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994873.7468 2093233.8423799998 37.7273274525845 -122.459961359351 (37.7273274525845, -122.459961359351)
23557 23557 213451 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Cortes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5993177.52134 2099659.6696900004 37.7448734694269 -122.466291957027 (37.7448734694269, -122.466291957027)
24441 24441 213456 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 305 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5993116.56669 2099668.45247 37.7448940675206 -122.46650336333799 (37.7448940675206, -122.466503363338)
25262 25262 237451 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4407 24th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6000528.815780001 2101672.95433 37.7508228849759 -122.441017024421 (37.7508228849759, -122.441017024421)
25464 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)
29824 29824 214773 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 92 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993651.47421 2101409.8267 37.74970629121471 -122.464780200252 (37.7497062912147, -122.464780200252)
30750 30750 213598 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 128 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994427.44461 2101171.23368 37.749095882669295 -122.462079583807 (37.7490958826693, -122.462079583807)
32602 32602 213579 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 464 Dewey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994822.2189 2100134.8158400003 37.7462728613029 -122.460639364526 (37.7462728613029, -122.460639364526)
34050 34050 214489 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2083 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991276.32219 2101284.43599 37.7492247771203 -122.47298434476801 (37.7492247771203, -122.472984344768)
34110 34110 213580 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 45 Merced Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5995131.70851 2099996.48556 37.74591084191 -122.459559177141 (37.74591084191, -122.459559177141)
34374 34374 213557 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Valdez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5996396.856430001 2093987.6566700002 37.7294847274146 -122.454750441903 (37.7294847274146, -122.454750441903)
34790 34790 237110 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 380 Lexington St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 1ft   6006531.04727 2103908.9188900003 37.7573023708184 -122.420419415431 (37.7573023708184, -122.420419415431)
34957 34957 214766 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993866.28574 2101627.27037 37.7503157185921 -122.464053162237 (37.7503157185921, -122.464053162237)
35376 35376 179161 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 233 Naylor St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6002647.79999 2086739.6543400001 37.7099398962889 -122.432622809119 (37.7099398962889, -122.432622809119)
36134 36134 213597 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 444 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5993860.18599 2101791.35553 37.750765903044794 -122.46408616556299 (37.7507659030448, -122.464086165563)
37368 37368 213397 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2011 15th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991583.99315 2101696.28864 37.7503734254013 -122.47195043737301 (37.7503734254013, -122.471950437373)
37916 37916 124377 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 43 Jordan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5996171.6686 2114245.1499900003 37.7850937492478 -122.45699360696501 (37.7850937492478, -122.456993606965)
38356 38356 213463 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 314 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993094.88579 2099699.80528 37.7449789032567 -122.46658060972 (37.7449789032567, -122.46658060972)
38427 38427 213600 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994324.50306 2101547.6622200003 37.7501235325769 -122.46246285419501 (37.7501235325769, -122.462462854195)
39369 39369 250521 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 95 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   5987685.5238 2115445.0256 37.787897288863796 -122.48644075485201 (37.7878972888638, -122.486440754852)
40170 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)
40381 40381 250676 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 735 El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986293.297259999 2114811.88275 37.786077611448 -122.49121092176 (37.786077611448, -122.49121092176)
41345 41345 213459 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 331 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5992964.35444 2099654.10226 37.7448458809298 -122.467028637559 (37.7448458809298, -122.467028637559)
45175 45175 213430 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2340 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5991476.167830001 2099498.51961 37.7443326801156 -122.47216311983401 (37.7443326801156, -122.472163119834)
47216 47216 214727 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 620 Faxon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994875.65194 2092373.1358900003 37.7249642698646 -122.45989245148199 (37.7249642698646, -122.459892451482)
47537 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)
49667 49667 214777 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 36 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993930.07421 2101127.47655 37.7489470880465 -122.46379630688101 (37.7489470880465, -122.463796306881)
51607 51607 214770 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 328 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5994294.76269 2100935.2317 37.748440240943204 -122.462521279527 (37.7484402409432, -122.462521279527)
52702 52702 213581 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Garcia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994661.106000001 2099475.65423 37.7444536982758 -122.461148698258 (37.7444536982758, -122.461148698258)
52836 52836 213657 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Edgehill Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994715.35615 2099021.32381 37.7432093423507 -122.46092819170099 (37.7432093423507, -122.460928191701)
53702 53702 218238 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 333 Wawona St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 2ft   5992020.14039 2097188.56235 37.738021590525996 -122.47011402534599 (37.738021590526, -122.470114025346)
57812 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)
61123 61123 213601 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 35 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5994302.03638 2101543.53453 37.7501109051904 -122.462540245329 (37.7501109051904, -122.462540245329)
62002 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)
66724 66724 213447 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 526 Magellan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993054.572480001 2099444.94374 37.744276791733704 -122.46670148220899 (37.7442767917337, -122.466701482209)
66957 66957 213435 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2320 Cecilia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991477.88555 2099610.75787 37.744640956913706 -122.47216536005699 (37.7446409569137, -122.472165360057)
67642 67642 118478 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 578 48th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5981024.51617 2111800.84509 37.7775009394111 -122.509215478972 (37.7775009394111, -122.509215478972)
68476 68476 179033 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 88 Alpha St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 5ft   6011104.28456 2088327.78048 37.7147765222032 -122.40350709418001 (37.7147765222032, -122.40350709418)
69144 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)
71386 71386 213674 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5995877.17583 2098581.55424 37.7420686278778 -122.456879149764 (37.7420686278778, -122.456879149764)
71505 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)
71611 71611 213499 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 737 Faxon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5994838.82218 2092907.1624099999 37.726428459682296 -122.460058436671 (37.7264284596823, -122.460058436671)
71891 71891 250874 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5986467.3841 2114682.3933599996 37.7857322411853 -122.490599105779 (37.7857322411853, -122.490599105779)
72276 72276 218242 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 325 Wawona St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 2ft   5992065.00246 2097235.79822 37.738153881691 -122.46996235468599 (37.738153881691, -122.469962354686)
74663 74663 238436 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 404 Loma Vista Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5999965.40666 2106753.04147 37.7647394502792 -122.44333018325199 (37.7647394502792, -122.443330183252)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
3800 3800 213446 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 530 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993033.55222 2099443.36305 37.744271238444206 -122.46677405027799 (37.7442712384442, -122.466774050278)
27459 27459 213462 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 314 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993067.05595 2099698.4128799997 37.7449734740606 -122.46667673826201 (37.7449734740606, -122.466676738262)
29095 29095 218241 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 329 Wawona St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 2ft   5992046.53731 2097216.7007400002 37.7381003774208 -122.470024807225 (37.7381003774208, -122.470024807225)
32529 32529 120326 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 738 23rd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 2ft   5988846.16685 2110288.25768 37.773805837099 -122.48204727167901 (37.773805837099, -122.482047271679)

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