Street_Tree_List

Data source: data.sfgov.org

821 rows where search matches "cherry" and qSiteInfo = 2

✎ View and edit SQL

This data as json, CSV (advanced)

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

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 821 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1001 1001 238568 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1300 Noe St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   04/27/2017 12:00:00 AM 3 Width 5ft Permit Number 779731 6003218.5106 2100626.90187 37.7481035005842 -122.431641146931 (37.7481035005842, -122.431641146931)
2102 2102 196505 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3536 Jennings St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6013064.418880001 2089502.0027700001 37.7181099951501 -122.39681428375299 (37.7181099951501, -122.396814283753)
3683 3683 213464 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/24/2005 12:00:00 AM 2 Width 3ft Permit Number 48287 5993110.29995 2099700.9644 37.7449829754007 -122.46652739502701 (37.7449829754007, -122.466527395027)
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)
3822 3822 253559 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Cortes Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       Width 3ft   5993184.39566 2099612.1282900004 37.7447433294416 -122.46626473273199 (37.7447433294416, -122.466264732732)
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)
23375 23375 218050 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 72 San Rafael Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991878.2117099995 2095609.0189900002 37.7336763568794 -122.470489732417 (37.7336763568794, -122.470489732417)
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)
23401 23401 202171 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 20 Kalmanovitz St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 2ft   6013157.586080001 2093193.49557 37.7282512748665 -122.39675089323799 (37.7282512748665, -122.396750893238)
23409 23409 218091 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 62 Eastwood Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995658.864080001 2092992.02847 37.726708612908 -122.45722974236601 (37.726708612908, -122.457229742366)
23431 23431 213073 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 50 Castenada Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5994467.524230001 2101712.07423 37.7505832012692 -122.46198020334299 (37.7505832012692, -122.461980203343)
23481 23481 218410 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 205 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5994280.90702 2100599.38004 37.7475172792951 -122.462544833698 (37.7475172792951, -122.462544833698)
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)
23638 23638 179012 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 575 Lisbon St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6001860.73543 2090148.2767900003 37.719254552441704 -122.435586742551 (37.7192545524417, -122.435586742551)
23696 23696 212999 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1639 08th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5993681.9391 2104325.0016900003 37.7577123690443 -122.46488653520201 (37.7577123690443, -122.464886535202)
23912 23912 118028 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 51 Shore View Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5984316.15967 2112798.24876 37.780433038793 -122.49790243493 (37.780433038793, -122.49790243493)
24085 24085 212387 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 95 San Rafael Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5991919.26492 2095494.2164099999 37.7333635115101 -122.47033944313499 (37.7333635115101, -122.470339443135)
24251 24251 201271 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 200 Kalmanovitz St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 2ft   6013058.71274 2092794.8909900002 37.7271512843849 -122.39706476744301 (37.7271512843849, -122.397064767443)
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)
24504 24504 241043 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 300 Virginia Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6006909.48713 2098350.81017 37.742062385665605 -122.418716463718 (37.7420623856656, -122.418716463718)
24610 24610 183977 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1693 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5985918.7806 2103713.7918 37.7555834944248 -122.49168936146002 (37.7555834944248, -122.49168936146)
24630 24630 184291 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1543 41st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5983404.3155 2104639.3384 37.7579775103532 -122.50045345703501 (37.7579775103532, -122.500453457035)
24861 24861 182367 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1511 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5986186.5787 2104935.6262 37.758953963431 -122.49085314669901 (37.758953963431, -122.490853146699)
25078 25078 238351 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 737 Sanchez St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6003693.255030001 2104105.37257 37.7576814602529 -122.43024762673001 (37.7576814602529, -122.43024762673)
25162 25162 120283 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 139 24th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5988317.15466 2115062.63745 37.786884157218 -122.484227400222 (37.786884157218, -122.484227400222)
25231 25231 140921 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 150 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5996579.2478 2113360.6701 37.7826885995813 -122.455519569028 (37.7826885995813, -122.455519569028)
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)
25266 25266 215207 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 160 San Buenaventura Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 8ft   5993414.72395 2095618.6966 37.7337916535606 -122.465178304956 (37.7337916535606, -122.465178304956)
25275 25275 212516 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1845 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5992439.35548 2095372.08993 37.7330582393366 -122.468532478509 (37.7330582393366, -122.468532478509)
25325 25325 213664 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Edgehill Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994722.94591 2098926.36641 37.7429490497558 -122.460895067856 (37.7429490497558, -122.460895067856)
25451 25451 218361 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 319 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5993708.26635 2100090.28038 37.746086426450894 -122.46448801411199 (37.7460864264509, -122.464488014112)
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)
25478 25478 213643 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 27 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5999510.3328 2096092.78198 37.73544300577971 -122.44413809190901 (37.7354430057797, -122.444138091909)
25588 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)
25600 25600 218110 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 70 Lopez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5993948.55319 2100516.17746 37.7472696806615 -122.463688045574 (37.7472696806615, -122.463688045574)
25681 25681 196512 Undocumented 2 Prunus spp :: Cherry 84 625 King St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   6011914.18479 2108425.06588 37.770004584260704 -122.402119799109 (37.7700045842607, -122.402119799109)
25716 25716 135893 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 323 Marina Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6001843.597519999 2121830.48703 37.806245186226505 -122.437914052191 (37.8062451862265, -122.437914052191)
26158 26158 218116 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 55 Lopez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5994001.31011 2100596.31322 37.7474927529972 -122.46351143220899 (37.7474927529972, -122.463511432209)
26326 26326 213639 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5999561.36601 2096051.1462299998 37.7353315950748 -122.44395866097099 (37.7353315950748, -122.443958660971)
26387 26387 212392 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 65 San Rafael Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5991914.22227 2095632.90127 37.733744013755796 -122.470366973162 (37.7337440137558, -122.470366973162)
26591 26591 237795 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 408 Loma Vista Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5999966.83736 2106716.7634400004 37.7646399214278 -122.44332262893299 (37.7646399214278, -122.443322628933)
26752 26752 250523 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 95 26th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   5987685.92853 2115397.50584 37.78776683682629 -122.48643586433998 (37.7877668368263, -122.48643586434)
26793 26793 212579 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 495 Ulloa St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5995106.36295 2098205.71424 37.7409923723142 -122.459517144622 (37.7409923723142, -122.459517144622)
26986 26986 201270 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 200 Kalmanovitz St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 2ft   6013065.62044 2092803.8132900002 37.7271761677359 -122.39704151275801 (37.7271761677359, -122.397041512758)
27002 27002 181705 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1206 22nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5989261.3602 2107107.536 37.7650965865931 -122.48037820612 (37.7650965865931, -122.48037820612)
27014 27014 218047 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 78 San Rafael Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5991880.93343 2095530.55726 37.7334610780522 -122.47047461032301 (37.7334610780522, -122.470474610323)
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)
27493 27493 136046 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 20 Cherry St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     5996087.67176 2116001.0032200003 37.789910026470004 -122.45741128312001 (37.78991002647, -122.45741128312)
27606 27606 201518 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 501 Griffith St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6019207.673780001 2094338.78719 37.7317309074526 -122.37591462936199 (37.7317309074526, -122.375914629362)
27638 27638 218117 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 51 Lopez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5994004.41088 2100604.52458 37.7475154779688 -122.463501305851 (37.7475154779688, -122.463501305851)
27665 27665 215220 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 2020 09th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 6ft   5993507.89159 2101745.37647 37.7506193459188 -122.465301081296 (37.7506193459188, -122.465301081296)
28047 28047 212491 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 340 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994243.89249 2101041.77176 37.748729843319296 -122.462704913927 (37.7487298433193, -122.462704913927)
28066 28066 212497 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 65 Sotelo Ave 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993896.2239 2101284.60131 37.7493765619851 -122.463924764236 (37.7493765619851, -122.463924764236)
28134 28134 218416 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 206 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5994263.50524 2100633.1916900002 37.747609115379 -122.46260745978901 (37.747609115379, -122.462607459789)
28337 28337 212898 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1982 16th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5991298.21151 2101944.03657 37.7510371358669 -122.472956744582 (37.7510371358669, -122.472956744582)
28489 28489 237793 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 20 Loma Vista Ter 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5999972.7031 2106823.93628 37.7649345258447 -122.443310039328 (37.7649345258447, -122.443310039328)
28498 28498 218176 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1450 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   5992814.7731 2097288.8664 37.7383429066102 -122.467373901707 (37.7383429066102, -122.467373901707)
28635 28635 213024 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 20 Belmont Ave 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     5996733.15757 2106189.67252 37.7630077346534 -122.454468924419 (37.7630077346534, -122.454468924419)
28683 28683 212896 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2075 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991276.17965 2101331.74892 37.7493546778745 -122.472988287398 (37.7493546778745, -122.472988287398)
28944 28944 218040 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 25 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994170.67201 2100024.7382400003 37.745933109126504 -122.46288433316099 (37.7459331091265, -122.462884333161)
28949 28949 238015 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 77 Ashbury Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5999599.38464 2106733.87641 37.76466594869029 -122.44459477575501 (37.7646659486903, -122.444594775755)
29000 29000 237789 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 10 Loma Vista Ter 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5999974.87074 2106875.7261900003 37.7650768516417 -122.443306262176 (37.7650768516417, -122.443306262176)
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)
29110 29110 140804 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 90 COMMONWEALTH AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5996555.8967 2113971.183 37.784363565831704 -122.45564449638 (37.7843635658317, -122.45564449638)
29205 29205 212505 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 65 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993824.366 2101378.77522 37.7496309981911 -122.46418008445801 (37.7496309981911, -122.464180084458)
29289 29289 202261 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 8 Orsi Cir 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 2ft   6013121.62646 2093143.4791299999 37.728111938408496 -122.396871702789 (37.7281119384085, -122.396871702789)
29767 29767 140858 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 101 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5996504.4566 2113783.0205 37.7838439696062 -122.455808853694 (37.7838439696062, -122.455808853694)
29821 29821 212509 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 84 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5993741.80869 2101415.98276 37.7497284019398 -122.46446826950701 (37.7497284019398, -122.464468269507)
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)
30287 30287 214298 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 268 Pacheco St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5994394.90516 2100680.9533 37.7477478232146 -122.4621565532 (37.7477478232146, -122.4621565532)
30488 30488 218030 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 351 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5992903.727109999 2099651.1745700003 37.744834342625104 -122.467238060886 (37.7448343426251, -122.467238060886)
30557 30557 215212 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 165 San Buenaventura Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 8ft   5993408.7609 2095708.9649099999 37.7340391640776 -122.465205475246 (37.7340391640776, -122.465205475246)
30654 30654 237210 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 483 Valley St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6002788.0313800005 2099167.4963 37.744071904607395 -122.43302547424 (37.7440719046074, -122.43302547424)
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)
31329 31329 212511 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 44 Sotelo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5993924.86488 2101232.50449 37.7492351678801 -122.463821942925 (37.7492351678801, -122.463821942925)
31470 31470 236880 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 30 Ashbury Ter 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5999599.46075 2106928.4775400003 37.7652002791041 -122.44460850030701 (37.7652002791041, -122.444608500307)
31633 31633 140803 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 90 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5996555.8967 2113946.8166 37.7842966621812 -122.455642734536 (37.7842966621812, -122.455642734536)
31790 31790 215217 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 133 San Buenaventura Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   5993392.21356 2095932.78503 37.7346527642991 -122.465278936386 (37.7346527642991, -122.465278936386)
32181 32181 214447 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 265 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993364.21414 2099688.46118 37.7449632937192 -122.465648504685 (37.7449632937192, -122.465648504685)
32435 32435 218025 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2329 Funston Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5992295.63825 2099570.87702 37.744578744525 -122.469334855422 (37.744578744525, -122.469334855422)
32490 32490 212580 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 495 Ulloa St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5995135.00729 2098202.51543 37.74098523618029 -122.459417872064 (37.7409852361803, -122.459417872064)
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)
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)
32935 32935 196267 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1121 Jamestown Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6013259.78096 2090144.7382099999 37.719885690359604 -122.396184017281 (37.7198856903596, -122.396184017281)
32991 32991 237208 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 483 Valley St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6002753.541619999 2099167.64088 37.74407034517979 -122.433144742342 (37.7440703451798, -122.433144742342)
33378 33378 236765 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 221 Mateo St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6003987.70839 2096259.9534 37.736156432574504 -122.428670036887 (37.7361564325745, -122.428670036887)
33752 33752 214776 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 36 Sotelo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993929.139169999 2101136.44437 37.7489716575191 -122.463800191051 (37.7489716575191, -122.463800191051)
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)
34179 34179 197887 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 1493 Kansas St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 6ft   6011776.638040001 2101418.39447 37.7507581436897 -122.40210291074699 (37.7507581436897, -122.402102910747)
34202 34202 246791 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 175 Brewster St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6010143.06435 2098755.47908 37.743355047810205 -122.40756425069901 (37.7433550478102, -122.407564250699)
34329 34329 218041 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 45 Dorantes Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994128.104730001 2100036.1496099997 37.7459619899591 -122.463032351679 (37.7459619899591, -122.463032351679)
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)
34605 34605 212336 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 129 Kirkham St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 2ft   5994383.10995 2105287.3927 37.7603952490607 -122.462531423009 (37.7603952490607, -122.462531423009)
34655 34655 212490 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 40 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994121.05183 2100069.6594 37.746053593117 -122.463059170366 (37.746053593117, -122.463059170366)
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)
34928 34928 178912 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 263 Flournoy St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     5993780.74611 2086770.03775 37.709516474781104 -122.463270994886 (37.7095164747811, -122.463270994886)
34956 34956 212607 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 11 Miramar Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5995300.7051800005 2090004.7098400001 37.7184855727191 -122.458251756207 (37.7184855727191, -122.458251756207)
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)

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