Street_Tree_List

Data source: data.sfgov.org

821 rows where search matches "cherry" and qSiteInfo = 2 sorted by DBH

✎ 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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
35756 35756 218355 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 365 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5993521.424240001 2100014.7209799998 37.7458681870785 -122.465128597612 (37.7458681870785, -122.465128597612)
38741 38741 212480 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1930 09th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5993487.89331 2102336.85264 37.752242234595705 -122.46541319797501 (37.7522422345957, -122.465413197975)
39671 39671 218133 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 50 Lopez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5994001.76195 2100682.29452 37.747728861899205 -122.46351610870501 (37.7477288618992, -122.463516108705)
39971 39971 218354 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 365 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5993503.7358800005 2100017.05504 37.745873575808794 -122.46518993049801 (37.7458735758088, -122.465189930498)
42773 42773 237209 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 483 Valley St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6002775.7731 2099167.46556 37.744071124872896 -122.43306785839899 (37.7440711248729, -122.433067858399)
43286 43286 212542 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 155 Terrace Walk 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5993830.43125 2096581.14739 37.736458268419206 -122.46381092625799 (37.7364582684192, -122.463810926258)
45248 45248 184305 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1562 38th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5984382.3056 2104532.0637 37.757740324240295 -122.497063286444 (37.7577403242403, -122.497063286444)
46931 46931 183520 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2563 27th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5987980.9372 2097853.3266 37.739612521668896 -122.484128114644 (37.7396125216689, -122.484128114644)
47170 47170 218362 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 319 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5993715.662880001 2100098.54629 37.746109548922206 -122.464463038136 (37.7461095489222, -122.464463038136)
48579 48579 178918 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 263 Flournoy St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5993792.015380001 2086765.64003 37.709505048900496 -122.46323172778 (37.7095050489005, -122.46323172778)
50209 50209 182801 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1771 33rd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5985937.2360000005 2103186.122 37.7541357363912 -122.49158669787799 (37.7541357363912, -122.491586697878)
51415 51415 182275 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 3150 Kirkham St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5985063.5912 2105018.8618 37.7591168373077 -122.49474304376001 (37.7591168373077, -122.49474304376)
52388 52388 178914 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 263 Flournoy St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5993788.47929 2086756.5816799998 37.7094799730978 -122.463243292153 (37.7094799730978, -122.463243292153)
53737 53737 218431 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 71 Lopez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5993979.4713 2100498.80546 37.747223763070295 -122.46357987330799 (37.7472237630703, -122.463579873308)
59593 59593 237207 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 483 Valley St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6002742.12056 2099166.74161 37.7440672281147 -122.433184169536 (37.7440672281147, -122.433184169536)
60297 60297 182224 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1599 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5985275.2811 2104383.8376 37.7573856255252 -122.493964129886 (37.7573856255252, -122.493964129886)
61059 61059 182221 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2830 Lawton St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5985427.0921 2104352.0968 37.7573073554199 -122.493436776332 (37.7573073554199, -122.493436776332)
62219 62219 213573 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 401 Dewey Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5995208.70184 2100413.07322 37.7470591142869 -122.459323109585 (37.7470591142869, -122.459323109585)
65590 65590 178916 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 263 Flournoy St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5993790.44094 2086761.47706 37.7094935276652 -122.46323686739599 (37.7094935276652, -122.463236867396)
66527 66527 178915 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 263 Flournoy St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5993789.8911 2086758.89685 37.70948641134179 -122.46323858062 (37.7094864113418, -122.46323858062)
67795 67795 178907 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 263 Flournoy St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5993774.9758 2086763.55645 37.7094983462303 -122.46329046790501 (37.7094983462303, -122.463290467905)
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)
68684 68684 218324 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 430 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5993138.3267 2099955.06168 37.7456822792311 -122.466448948955 (37.7456822792311, -122.466448948955)
69187 69187 212543 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 155 Terrace Walk 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5993816.76239 2096598.14857 37.7365041617454 -122.463859418574 (37.7365041617454, -122.463859418574)
72984 72984 218363 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 319 Castenada Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5993721.44123 2100107.37219 37.7461341157 -122.464443698212 (37.7461341157, -122.464443698212)
74381 74381 212577 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 495 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5995077.72925 2098209.43297 37.74100093654771 -122.459616418059 (37.7410009365477, -122.459616418059)
75705 75705 250820 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 60 Sea View Ter 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5986182.97775 2114165.47247 37.7842963089586 -122.49154499381599 (37.7842963089586, -122.491544993816)
76456 76456 178908 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 263 Flournoy St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5993776.62184 2086766.22044 37.7095057557476 -122.463284972138 (37.7095057557476, -122.463284972138)
133532 133532 212487 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 26 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5994233.60487 2100043.6839 37.7459887537819 -122.462668095672 (37.7459887537819, -122.462668095672)
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)
137051 137051 178842 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 856 Prague St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6002039.2106099995 2086908.72872 37.7103696049432 -122.434738288839 (37.7103696049432, -122.434738288839)
137816 137816 212901 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1942 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5991289.25239 2102186.06751 37.7517011709901 -122.473005373606 (37.7517011709901, -122.473005373606)
151905 151905 213022 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 20 Belmont Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5996746.54746 2106178.70773 37.7629783960584 -122.454421821532 (37.7629783960584, -122.454421821532)
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)
152743 152743 182409 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1521 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5985259.3217 2104833.2809 37.7586187384667 -122.494052446724 (37.7586187384667, -122.494052446724)
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)
154672 154672 182570 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2202 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5989157.6649 2098357.6812 37.7410657893771 -122.480096445466 (37.7410657893771, -122.480096445466)
155329 155329 239003 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2392 Bryant St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   6009661.58461 2103420.7224 37.7561378099155 -122.409558287803 (37.7561378099155, -122.409558287803)
158576 158576 181897 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2346 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5987356.2384 2099265.0635 37.7434523865632 -122.48639164593399 (37.7434523865632, -122.486391645934)
159311 159311 183377 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2651 22nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5989551.7412 2097288.806 37.738153824368204 -122.478655737727 (37.7381538243682, -122.478655737727)
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)
161769 161769 235993 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 459 Valley St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6002953.9006 2099181.33863 37.7441193195685 -122.432452924464 (37.7441193195685, -122.432452924464)
162281 162281 212578 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 495 Ulloa St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5995091.0187099995 2098208.3748 37.7409987952479 -122.45957039166599 (37.7409987952479, -122.459570391666)
167153 167153 212488 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 26 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5994199.72121 2100051.66062 37.74600870434679 -122.46278583851401 (37.7460087043468, -122.462785838514)
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)
171200 171200 123333 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 737 04th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5994714.05712 2110527.69086 37.7748027900674 -122.46176680881099 (37.7748027900674, -122.461766808811)
174227 174227 181930 Undocumented 2 Prunus spp :: Cherry 84 2431 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5986090.3717 2098682.4704 37.741778875367295 -122.49072577603 (37.7417788753673, -122.49072577603)
174540 174540 184306 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1562 38th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5984381.1972 2104548.1361 37.757784389614 -122.497068306014 (37.757784389614, -122.497068306014)
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)
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)
182335 182335 178911 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 263 Flournoy St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5993783.22919 2086769.82188 37.709516025103895 -122.46326239735201 (37.7095160251039, -122.463262397352)
183798 183798 212504 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 65 Sotelo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5993846.98511 2101368.61986 37.749604417822205 -122.464101130262 (37.7496044178222, -122.464101130262)
183985 183985 178917 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 263 Flournoy St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5993792.21408 2086763.29106 37.7094986106303 -122.463230870712 (37.7094986106303, -122.463230870712)
184051 184051 178910 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 263 Flournoy St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5993781.83724 2086767.02745 37.7095082720684 -122.463267005492 (37.7095082720684, -122.463267005492)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
39106 39106 182579 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2458 23rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5989241.8181 2098602.0912 37.741741764812396 -122.479823358011 (37.7417417648124, -122.479823358011)
39432 39432 237070 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3390 Cesar Chavez St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6007214.5669 2100609.67167 37.7482818846986 -122.41782167243 (37.7482818846986, -122.41782167243)
39866 39866 182572 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 2212 Ulloa St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5989118.5154 2098355.8518 37.7410584915124 -122.48023167480301 (37.7410584915124, -122.480231674803)
40213 40213 213483 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 200 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994968.55628 2100619.47305 37.74761202648929 -122.460168457927 (37.7476120264893, -122.460168457927)
40670 40670 213401 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Quintara St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991567.73676 2101101.51332 37.7487393860095 -122.47196330756 (37.7487393860095, -122.47196330756)
42387 42387 218392 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 279 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5993972.22975 2100279.2566400003 37.7466205203156 -122.463588982552 (37.7466205203156, -122.463588982552)
42855 42855 213400 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Quintara St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991548.4151099995 2101099.1787400004 37.7487318577911 -122.472029950926 (37.7487318577911, -122.472029950926)
44976 44976 140824 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 98 JORDAN AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5996239.98 2113878.2862 37.784090361774794 -122.456730730831 (37.7840903617748, -122.456730730831)
45242 45242 213576 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994554.1980800005 2099981.39248 37.7458361756945 -122.46155502007299 (37.7458361756945, -122.461555020073)
47186 47186 200490 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1088 Jamestown Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   6013545.6611 2089994.9439 37.7194902878281 -122.39518533478001 (37.7194902878281, -122.39518533478)
48434 48434 182802 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1771 33rd Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5985936.734 2103180.0986 37.7541191684466 -122.491587990539 (37.7541191684466, -122.491587990539)
49260 49260 213458 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 331 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5992978.54855 2099656.27544 37.7448526672074 -122.46697971536301 (37.7448526672074, -122.466979715363)
49337 49337 213548 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 140 Colon Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5996162.65905 2093980.6549 37.729452065849294 -122.455559574538 (37.7294520658493, -122.455559574538)
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)
49850 49850 213071 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 418 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993974.73035 2101663.4594900003 37.7504213340809 -122.463680782643 (37.7504213340809, -122.463680782643)
50305 50305 213569 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Merced Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5995296.87532 2100197.80172 37.7464731016692 -122.459002630776 (37.7464731016692, -122.459002630776)
51380 51380 213399 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Quintara St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991532.61986 2101100.8826900003 37.74873562236029 -122.472084694454 (37.7487356223603, -122.472084694454)
52275 52275 212499 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 65 Sotelo Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993890.56554 2101313.40966 37.7494553362962 -122.46394642170799 (37.7494553362962, -122.463946421708)
52543 52543 212493 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 340 Pacheco St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994235.042830001 2101061.62573 37.7487838476045 -122.46273695584499 (37.7487838476045, -122.462736955845)
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)
53908 53908 214215 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 8 Edgehill Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994873.30356 2099101.4838900003 37.7434385291714 -122.46038786192 (37.7434385291714, -122.46038786192)
54244 54244 196406 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1021 Minnesota St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6015301.01099 2103753.62638 37.7573662793475 -122.390078334671 (37.7573662793475, -122.390078334671)
54329 54329 213663 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Edgehill Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994711.26401 2098940.32402 37.7429867016817 -122.460936471749 (37.7429867016817, -122.460936471749)
54993 54993 213486 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 266 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994659.1262300005 2100320.90612 37.74677443390021 -122.461216802127 (37.7467744339002, -122.461216802127)

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